ConfigGenTool

功能清單顯示/隱藏
原始資料
預覽
資料表
關聯性在定義部分未指定的關係時，未指定的表必須放在來源表
視圖
實作範例Cheatsheet

//////////////////// ManageComponent-HTML ////////////////////
<app-estate-main-view [dataSources]="mainViewDS"></app-estate-main-view>
<app-estate-editor [dataSources]="formDS"></app-estate-editor>

<app-systemSetting-selector [dataSources]="systemSettingSelectDS"></app-systemSetting-selector>
<app-user-selector [dataSources]="userSelectDS"></app-user-selector>

//////////////////// ManageComponent-TS ////////////////////
@Component({
    selector: 'app-potentialProject-manage',
    templateUrl: './manage.component.html',
    styleUrls: ['./manage.component.scss']
})
export class PotentialProjectManageComponent
{
    // Main View
    public mainViewDS: MainViewDataSources = new MainViewDataSources(
        this,
        this.potentialProjectService,
        this.datetimeService);
    public formDS: FormDataSource = new FormDataSource(
        this,
        this.potentialProjectService);

    public userSelectDS: UserSelectDataSource = new UserSelectDataSource(
        this,
        this.userService,
        this.datetimeService);

    public systemSettingSelectDS: SystemSettingSelectDataSource = new SystemSettingSelectDataSource(
        this,
        this.systemSettingService,
        this.datetimeService);

    // Dependancies
    constructor(
        private potentialProjectService: PotentialProjectService,
        private systemSettingService: SystemSettingService,
        private datetimeService: DatetimeService,
        private userService: AuthHTTPService) { }
}

//////////////////// JWTable ////////////////////
/// XXX = Uppercase-FullName(ex: PotentialProject)
/// XX = Uppercase-Synonym(ex: Project)
/// xxx = Lowercase-Synonym(ex: potentialProject)
/// xx = Lowercase-Synonym(ex: project)
export class MainViewDataSources implements
    IntegrateXXXMainView
{
    private expandedData: XXXViewModel | null;
    private updateTableCallbacks: Array<Function>;
    private expandSubrowCallbacks: Array<Function>;

    public constructor(
        private parentInstance: XXXManageComponent,
        public xxxService: XXXService,
        public datetimeService: DatetimeService)
    {
        this.expandedData = null;
        this.updateTableCallbacks = [];
        this.expandSubrowCallbacks = [];
    }
    public registerUpdateTableCallback(callback: Function): void
    {
        this.updateTableCallbacks.push(callback);
    }

    public setModifyingXXX(xx: XXXViewModel | null): void
    {
        this.parentInstance.formDS.setModifyingXX(xx);
    }
    public openXXXEditor(isCreate: boolean): void
    {
        this.parentInstance.formDS.openXXXEditor(isCreate);
    }
    public tableXXXUpdate(): void
    {
        this.updateTableCallbacks.forEach(callback => callback());
    }

    public getExtraFilters(): Array<ColumnQueryString>
    {
        return [];
    }
}



//////////////////// JWForm ////////////////////
/// XXX = Uppercase-FullName(ex: PotentialProject)
/// XX = Uppercase-Synonym(ex: Project)
/// xxx = Lowercase-FullName(ex: potentialProject)
/// xx = Lowercase-Synonym(ex: project)
/// OO1/OO2 = Uppercase-ForeignSynonym(ex: Status)
/// ooo1/ooo2 = Lowercase-ForeignFullName(ex: statusSSID)
/// OOOT1/OOOT2 = Uppercase-ForeignTypeFullName(ex: SystemSetting)
/// ooT1/ooT2 = Lowercase-ForeignTypeSynonym(ex: ssetting)
export class FormDataSource implements
    IntegrateXXXEditor
{
    private selectedOO1: TableJoinPreviewInfo;
    private selectedOO2: TableJoinPreviewInfo;
    private modifyingXX: XXXViewModel | null;

    private openEditorCallbacks: Array<Function>;
    private closeEditorCallbacks: Array<Function>;
    private updateEditorCallbacks: Array<Function>;

    constructor(
        private parentInstance: XXXManageComponent,
        public xxxService: XXXService)
    {
        this.setModifyingXX(null);
        this.setOO1Info(null);
        this.setOO2Info(null);

        this.openEditorCallbacks = [];
        this.closeEditorCallbacks = [];
        this.updateEditorCallbacks = [];
    }
    public registerOpenEditorCallback(callback: Function): void
    {
        this.openEditorCallbacks.push(callback);
    }
    public registerCloseEditorCallback(callback: Function): void
    {
        this.closeEditorCallbacks.push(callback);
    }
    public registerUpdateEditorCallback(callback: Function): void
    {
        this.updateEditorCallbacks.push(callback);
    }

    public openXXXEditor(isCreate: boolean): void
    {
        this.openEditorCallbacks.forEach(callback => callback(isCreate));
    }
    public closeXXXEditor(): void
    {
        this.closeEditorCallbacks.forEach(callback => callback());
    }
    public updateXXXEditor(columnName: string, value: any)
    {
        this.updateEditorCallbacks.forEach(callback => callback(columnName, value));
    }

    public getModifyingID(): number | null
    {
        return this.modifyingXX?.id ?? null;
    }
    public setModifyingXX(xx: XXXViewModel | null): void
    {
        this.modifyingXX = xx;
    }

    public tableXXXUpdate(): void
    {
        this.parentInstance.mainViewDS.tableXXXUpdate();
    }
    public openOO1Selector(): void
    {
        this.parentInstance.ooT1SelectDS.openOOOT1Selector("ooo1");
    }
    public openOO2Selector(): void
    {
        this.parentInstance.ooT1SelectDS.openOOOT1Selector("ooo2");
    }

    public getOO1Info(): TableJoinPreviewInfo
    {
        return this.selectedOO1;
    }
    public getOO2Info(): TableJoinPreviewInfo
    {
        return this.selectedOO2;
    }

    public setOO1Info(ooT1: OOOT1ViewModel | null): void
    {
        this.selectedOO1 = new TableJoinPreviewInfo(
            `${ooT1?.ID ?? 0}`,
            ooT1?.value ?? "(未選擇)",
            ooT1?.value2 ?? "");
    }
    public setOO2Info(ooT2: OOOT1ViewModel | null): void
    {
        this.selectedOO2 = new TableJoinPreviewInfo(
            `${ooT2?.ID ?? 0}`,
            ooT2?.value ?? "(未選擇)",
            ooT2?.value2 ?? "");
    }
}

//////////////////// Selector ////////////////////
export class SystemSettingSelectDataSource implements
    IntegrateSystemSettingSelector
{
    private expandedData: EstateViewModel | null;
    private openSelectorCallbacks: Array<Function>;
    private closeSelectorCallbacks: Array<Function>;

    private returnTarget: string;

    constructor(
        private parentInstance: PotentialProjectManageComponent,
        public systemSettingService: SystemSettingService,
        public datetimeService: DatetimeService)
    {
        this.expandedData = null;
        this.openSelectorCallbacks = [];
        this.closeSelectorCallbacks = [];
    }

    public registerOpenSelectorCallback(callback: Function): void
    {
        this.openSelectorCallbacks.push(callback);
    }
    public registerCloseSelectorCallback(callback: Function): void
    {
        this.closeSelectorCallbacks.push(callback);
    }

    public openSystemSettingSelector(returnTarget: string): void
    {
        this.returnTarget = returnTarget;
        this.openSelectorCallbacks.forEach(callback => callback());
    }
    public closeSystemSettingSelector(): void
    {
        this.closeSelectorCallbacks.forEach(callback => callback());
    }

    public updateSystemSettingFormValue(columnName: string, value: any): void
    {
        this.parentInstance.formDS.updatePotentialProjectEditor(this.returnTarget, value);
    }

    public setSystemSettingInfo(systemSetting: SystemSettingViewModel | null): void
    {
        switch (this.returnTarget)
        {
            case "statusSSID":          this.parentInstance.formDS.setStatusInfo(systemSetting); break;
            case "gradeSSID":           this.parentInstance.formDS.setGradeInfo(systemSetting); break;
            case "potentialReasonSSID": this.parentInstance.formDS.setReasonInfo(systemSetting); break;
        }
    }

    public getExtraFilter(): Array<ColumnQueryString>
    {
        let ret: Array<ColumnQueryString> =
        [
            { ColumnName: "SettingType", QueryString: "UserParams", QueryOperator: "Equals" }
        ];
        switch (this.returnTarget)
        {
            case "statusSSID":
                ret.push({ ColumnName: "SettingCode", QueryString: "EstateLocation", QueryOperator: "Equals" });  
                ret.push({ ColumnName: "SettingName", QueryString: "County", QueryOperator: "Equals" }); break; 
            case "gradeSSID":
                ret.push({ ColumnName: "SettingCode", QueryString: "EstateLocation", QueryOperator: "Equals" });  
                ret.push({ ColumnName: "SettingName", QueryString: "District", QueryOperator: "Equals" }); break; 
            case "potentialReasonSSID":
                ret.push({ ColumnName: "SettingCode", QueryString: "EstateSpec", QueryOperator: "Equals" });  
                ret.push({ ColumnName: "SettingName", QueryString: "Purpose", QueryOperator: "Equals" }); break; 
        }
        return ret;
    }
}

export class UserSelectDataSource implements
    IntegrateUserSelector
{
    private openSelectorCallbacks: Array<Function>;
    private closeSelectorCallbacks: Array<Function>;

    constructor(
        private parentInstance: PotentialProjectManageComponent,
        public userService: AuthHTTPService,
        public datetimeService: DatetimeService)
    {
        this.openSelectorCallbacks = [];
        this.closeSelectorCallbacks = [];
    }

    public registerOpenSelectorCallback(callback: Function): void
    {
        this.openSelectorCallbacks.push(callback);
    }
    public registerCloseSelectorCallback(callback: Function): void
    {
        this.closeSelectorCallbacks.push(callback);
    }

    public openUserSelector(): void
    {
        this.openSelectorCallbacks.forEach(callback => callback());
    }
    public closeUserSelector(): void
    {
        this.closeSelectorCallbacks.forEach(callback => callback());
    }

    public updateUserFormValue(columnName: string, value: any): void
    {
        this.parentInstance.formDS.updatePotentialProjectEditor("salesPerson", value);
    }
    public setUserInfo(user: UserInfoViewModel | null): void
    {
        this.parentInstance.formDS.setUserInfo(user);
    }

}