&ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2 &ANALYZE-RESUME /* Connected Databases anadat PROGRESS */ &Scoped-define WINDOW-NAME CURRENT-WINDOW &Scoped-define FRAME-NAME gAufkoAdmin {adecomm/appserv.i} /* Temp-Table and Buffer definitions */ DEFINE TEMP-TABLE tAufko NO-UNDO LIKE Aufko. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gAufkoAdmin /*------------------------------------------------------------------------ File: Description: from cntnrdlg.w - ADM2 SmartDialog Template Input Parameters: Output Parameters: Author: Created: ------------------------------------------------------------------------*/ /* This .W file was created with the Progress AppBuilder. */ /*----------------------------------------------------------------------*/ /* Create an unnamed pool to store all the widgets created by this procedure. This is a good default which assures that this procedure's triggers and internal procedures will execute in this procedure's storage, and that proper cleanup will occur on deletion of the procedure. */ CREATE WIDGET-POOL. /* *************************** Definitions ************************** */ /* Parameters Definitions --- */ DEF INPUT PARAMETER iphAufko AS HANDLE NO-UNDO. DEF OUTPUT PARAMETER oplRetVal AS LOG NO-UNDO. /* Local Variable Definitions --- */ DEF VAR hAufko AS HANDLE NO-UNDO. DEF VAR iRecid AS RECID NO-UNDO. DEF BUFFER bAdresse FOR Adresse. DEF BUFFER bAufko FOR Aufko . { incl/dlgdefinition.i } { src/adm2/widgetprto.i } /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK /* ******************** Preprocessor Definitions ******************** */ &Scoped-define PROCEDURE-TYPE SmartDialog &Scoped-define DB-AWARE no &Scoped-define ADM-CONTAINER DIALOG-BOX &Scoped-define ADM-SUPPORTED-LINKS Data-Target,Data-Source,Page-Target,Update-Source,Update-Target /* Name of designated FRAME-NAME and/or first browse and/or first query */ &Scoped-define FRAME-NAME gAufkoAdmin /* Internal Tables (found by Frame, Query & Browse Queries) */ &Scoped-define INTERNAL-TABLES tAufko /* Definitions for DIALOG-BOX gAufkoAdmin */ &Scoped-define FIELDS-IN-QUERY-gAufkoAdmin tAufko.Knr tAufko.Fak_Knr ~ tAufko.Faknr tAufko.Samm_Nr tAufko.Passant tAufko.Gedruckt tAufko.Verbucht &Scoped-define ENABLED-FIELDS-IN-QUERY-gAufkoAdmin tAufko.Knr ~ tAufko.Fak_Knr tAufko.Faknr tAufko.Samm_Nr tAufko.Passant tAufko.Gedruckt ~ tAufko.Verbucht &Scoped-define ENABLED-TABLES-IN-QUERY-gAufkoAdmin tAufko &Scoped-define FIRST-ENABLED-TABLE-IN-QUERY-gAufkoAdmin tAufko &Scoped-define QUERY-STRING-gAufkoAdmin FOR EACH tAufko SHARE-LOCK &Scoped-define OPEN-QUERY-gAufkoAdmin OPEN QUERY gAufkoAdmin FOR EACH tAufko SHARE-LOCK. &Scoped-define TABLES-IN-QUERY-gAufkoAdmin tAufko &Scoped-define FIRST-TABLE-IN-QUERY-gAufkoAdmin tAufko /* Standard List Definitions */ &Scoped-Define ENABLED-FIELDS tAufko.Knr tAufko.Fak_Knr tAufko.Faknr ~ tAufko.Samm_Nr tAufko.Passant tAufko.Gedruckt tAufko.Verbucht &Scoped-define ENABLED-TABLES tAufko &Scoped-define FIRST-ENABLED-TABLE tAufko &Scoped-Define ENABLED-OBJECTS RECT-2 F_Lieferadresse F_Fakturaadresse ~ CB_Fakart CB_Aufsta Btn_OK Btn_Cancel &Scoped-Define DISPLAYED-FIELDS tAufko.Knr tAufko.Fak_Knr tAufko.Faknr ~ tAufko.Samm_Nr tAufko.Passant tAufko.Gedruckt tAufko.Verbucht &Scoped-define DISPLAYED-TABLES tAufko &Scoped-define FIRST-DISPLAYED-TABLE tAufko &Scoped-Define DISPLAYED-OBJECTS F_Lieferadresse F_Fakturaadresse CB_Fakart ~ CB_Aufsta /* Custom List Definitions */ /* List-1,List-2,List-3,List-4,List-5,List-6 */ &Scoped-define List-6 tAufko.Knr tAufko.Fak_Knr tAufko.Faknr tAufko.Samm_Nr ~ tAufko.Passant tAufko.Gedruckt tAufko.Verbucht /* _UIB-PREPROCESSOR-BLOCK-END */ &ANALYZE-RESUME /* *********************** Control Definitions ********************** */ /* Define a dialog box */ /* Definitions of the field level widgets */ DEFINE BUTTON Btn_Cancel AUTO-END-KEY LABEL "abbrechen" SIZE 15 BY 1. DEFINE BUTTON Btn_OK AUTO-GO LABEL "OK" SIZE 15 BY 1. DEFINE VARIABLE CB_Aufsta AS CHARACTER FORMAT "X(256)":U VIEW-AS COMBO-BOX INNER-LINES 5 DROP-DOWN-LIST SIZE 60 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE CB_Fakart AS CHARACTER FORMAT "X(256)":U VIEW-AS COMBO-BOX INNER-LINES 5 DROP-DOWN-LIST SIZE 60 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fakturaadresse AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 60 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Lieferadresse AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 60 BY 1 BGCOLOR 15 NO-UNDO. DEFINE RECTANGLE RECT-2 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 90 BY 7.62. /* Query definitions */ &ANALYZE-SUSPEND DEFINE QUERY gAufkoAdmin FOR tAufko SCROLLING. &ANALYZE-RESUME /* ************************ Frame Definitions *********************** */ DEFINE FRAME gAufkoAdmin tAufko.Knr AT ROW 2 COL 15.2 COLON-ALIGNED WIDGET-ID 36 LABEL "Liefer-Knr" FORMAT "z999999" VIEW-AS FILL-IN NATIVE SIZE 12 BY 1 BGCOLOR 15 NO-TAB-STOP F_Lieferadresse AT ROW 2 COL 28 COLON-ALIGNED NO-LABEL WIDGET-ID 14 NO-TAB-STOP tAufko.Fak_Knr AT ROW 3 COL 15.2 COLON-ALIGNED WIDGET-ID 32 LABEL "Faktura-Knr" FORMAT "z999999" VIEW-AS FILL-IN NATIVE SIZE 12 BY 1 BGCOLOR 15 NO-TAB-STOP F_Fakturaadresse AT ROW 3 COL 28 COLON-ALIGNED NO-LABEL WIDGET-ID 12 NO-TAB-STOP tAufko.Fak_Art AT ROW 3 COL 68 COLON-ALIGNED WIDGET-ID 30 FORMAT "999999" VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP tAufko.Auf_Sta AT ROW 3 COL 68 COLON-ALIGNED WIDGET-ID 26 FORMAT "999999" VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP tAufko.Faknr AT ROW 4 COL 15.2 COLON-ALIGNED WIDGET-ID 28 VIEW-AS FILL-IN NATIVE SIZE 12 BY 1 BGCOLOR 15 CB_Fakart AT ROW 4 COL 28 COLON-ALIGNED NO-LABEL WIDGET-ID 6 tAufko.Samm_Nr AT ROW 5 COL 15.2 COLON-ALIGNED WIDGET-ID 40 LABEL "Sammel-Nr" FORMAT "z999999" VIEW-AS FILL-IN NATIVE SIZE 12 BY 1 BGCOLOR 15 CB_Aufsta AT ROW 5 COL 28 COLON-ALIGNED NO-LABEL WIDGET-ID 4 tAufko.Passant AT ROW 6 COL 17.2 WIDGET-ID 38 VIEW-AS TOGGLE-BOX SIZE 14 BY 1 tAufko.Gedruckt AT ROW 7 COL 17.2 WIDGET-ID 34 VIEW-AS TOGGLE-BOX SIZE 14 BY 1 tAufko.Verbucht AT ROW 8 COL 17.2 WIDGET-ID 42 VIEW-AS TOGGLE-BOX SIZE 14 BY 1 Btn_OK AT ROW 9.52 COL 31 Btn_Cancel AT ROW 9.52 COL 52.2 RECT-2 AT ROW 1.48 COL 3 WIDGET-ID 2 SPACE(1.79) SKIP(2.37) WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE TITLE "Änderungen durch den Administrator" CANCEL-BUTTON Btn_Cancel WIDGET-ID 100. /* *********************** Procedure Settings ************************ */ &ANALYZE-SUSPEND _PROCEDURE-SETTINGS /* Settings for THIS-PROCEDURE Type: SmartDialog Allow: Basic,Browse,DB-Fields,Query,Smart Container Links: Data-Target,Data-Source,Page-Target,Update-Source,Update-Target Design Page: 1 Other Settings: COMPILE APPSERVER Temp-Tables and Buffers: TABLE: tAufko T "?" NO-UNDO AnaDat Aufko END-TABLES. */ &ANALYZE-RESUME _END-PROCEDURE-SETTINGS &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB gAufkoAdmin /* ************************* Included-Libraries *********************** */ {src/adm2/containr.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* *********** Runtime Attributes and AppBuilder Settings *********** */ &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES /* SETTINGS FOR DIALOG-BOX gAufkoAdmin FRAME-NAME */ ASSIGN FRAME gAufkoAdmin:SCROLLABLE = FALSE FRAME gAufkoAdmin:HIDDEN = TRUE. /* SETTINGS FOR FILL-IN tAufko.Auf_Sta IN FRAME gAufkoAdmin NO-DISPLAY NO-ENABLE EXP-FORMAT */ ASSIGN tAufko.Auf_Sta:HIDDEN IN FRAME gAufkoAdmin = TRUE tAufko.Auf_Sta:READ-ONLY IN FRAME gAufkoAdmin = TRUE. /* SETTINGS FOR FILL-IN tAufko.Faknr IN FRAME gAufkoAdmin 6 */ /* SETTINGS FOR FILL-IN tAufko.Fak_Art IN FRAME gAufkoAdmin NO-DISPLAY NO-ENABLE EXP-FORMAT */ ASSIGN tAufko.Fak_Art:HIDDEN IN FRAME gAufkoAdmin = TRUE tAufko.Fak_Art:READ-ONLY IN FRAME gAufkoAdmin = TRUE. /* SETTINGS FOR FILL-IN tAufko.Fak_Knr IN FRAME gAufkoAdmin 6 EXP-LABEL EXP-FORMAT */ ASSIGN tAufko.Fak_Knr:READ-ONLY IN FRAME gAufkoAdmin = TRUE. ASSIGN F_Fakturaadresse:READ-ONLY IN FRAME gAufkoAdmin = TRUE. ASSIGN F_Lieferadresse:READ-ONLY IN FRAME gAufkoAdmin = TRUE. /* SETTINGS FOR TOGGLE-BOX tAufko.Gedruckt IN FRAME gAufkoAdmin 6 */ /* SETTINGS FOR FILL-IN tAufko.Knr IN FRAME gAufkoAdmin 6 EXP-LABEL EXP-FORMAT */ ASSIGN tAufko.Knr:READ-ONLY IN FRAME gAufkoAdmin = TRUE. /* SETTINGS FOR TOGGLE-BOX tAufko.Passant IN FRAME gAufkoAdmin 6 */ /* SETTINGS FOR FILL-IN tAufko.Samm_Nr IN FRAME gAufkoAdmin 6 EXP-LABEL EXP-FORMAT */ /* SETTINGS FOR TOGGLE-BOX tAufko.Verbucht IN FRAME gAufkoAdmin 6 */ /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gAufkoAdmin /* Query rebuild information for DIALOG-BOX gAufkoAdmin _TblList = "Temp-Tables.tAufko" _Options = "SHARE-LOCK" _Query is NOT OPENED */ /* DIALOG-BOX gAufkoAdmin */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME gAufkoAdmin &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gAufkoAdmin gAufkoAdmin ON END-ERROR OF FRAME gAufkoAdmin /* Änderungen durch den Administrator */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gAufkoAdmin gAufkoAdmin ON WINDOW-CLOSE OF FRAME gAufkoAdmin /* Änderungen durch den Administrator */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME Btn_Cancel &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Cancel gAufkoAdmin ON CHOOSE OF Btn_Cancel IN FRAME gAufkoAdmin /* abbrechen */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME Btn_OK &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_OK gAufkoAdmin ON CHOOSE OF Btn_OK IN FRAME gAufkoAdmin /* OK */ DO: btnOK = TRUE. RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME CB_Aufsta &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Aufsta gAufkoAdmin ON VALUE-CHANGED OF CB_Aufsta IN FRAME gAufkoAdmin DO: tAufko.Fak_Art:SCREEN-VALUE = SELF:SCREEN-VALUE. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME CB_Fakart &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Fakart gAufkoAdmin ON VALUE-CHANGED OF CB_Fakart IN FRAME gAufkoAdmin DO: tAufko.Fak_Art:SCREEN-VALUE = SELF:SCREEN-VALUE. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME tAufko.Gedruckt &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL tAufko.Gedruckt gAufkoAdmin ON RETURN OF tAufko.Gedruckt IN FRAME gAufkoAdmin /* Gedruckt */ DO: APPLY 'TAB' TO SELF. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME tAufko.Passant &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL tAufko.Passant gAufkoAdmin ON RETURN OF tAufko.Passant IN FRAME gAufkoAdmin /* Passant */ DO: APPLY 'TAB' TO SELF. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME tAufko.Verbucht &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL tAufko.Verbucht gAufkoAdmin ON RETURN OF tAufko.Verbucht IN FRAME gAufkoAdmin /* Verbucht */ DO: APPLY 'TAB' TO SELF. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gAufkoAdmin /* *************************** Main Block *************************** */ { incl/dlgmainblock.i } oplRetVal = FALSE. EMPTY TEMP-TABLE tAufko. CREATE tAufko. hAufko = TEMP-TABLE tAufko:DEFAULT-BUFFER-HANDLE. hAufko:BUFFER-COPY(iphAufko). FIND bAufko NO-LOCK WHERE bAufko.Firma = tAufko.Firma AND bAufko.Aufnr = tAufko.Aufnr. iRecid = RECID(bAufko). RELEASE bAufko. {src/adm2/dialogmn.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* ********************** Internal Procedures *********************** */ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects gAufkoAdmin _ADM-CREATE-OBJECTS PROCEDURE adm-create-objects : /*------------------------------------------------------------------------------ Purpose: Create handles for all SmartObjects used in this procedure. After SmartObjects are initialized, then SmartLinks are added. Parameters: ------------------------------------------------------------------------------*/ END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gAufkoAdmin _DEFAULT-DISABLE PROCEDURE disable_UI : /*------------------------------------------------------------------------------ Purpose: DISABLE the User Interface Parameters: Notes: Here we clean-up the user-interface by deleting dynamic widgets we have created and/or hide frames. This procedure is usually called when we are ready to "clean-up" after running. ------------------------------------------------------------------------------*/ /* Hide all frames. */ HIDE FRAME gAufkoAdmin. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gAufkoAdmin PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ FIND FIRST tAufko. F_Lieferadresse = DYNAMIC-FUNCTION('getAdressAnzeige':U, tAufko.Knr ) NO-ERROR. F_Fakturaadresse = DYNAMIC-FUNCTION('getAdressAnzeige':U, tAufko.Fak_Knr) NO-ERROR. DO WITH FRAME {&FRAME-NAME}: RUN COMBO_FAKART ( CB_Fakart:HANDLE ). RUN COMBO_AUFSTATUS ( CB_Aufsta:HANDLE ). END. { incl/dlgenableobject.i } DO WITH FRAME {&FRAME-NAME}: tAufko.Fak_Art:SCREEN-VALUE = STRING(tAufko.Fak_Art). tAufko.Auf_Sta:SCREEN-VALUE = STRING(tAufko.Auf_Sta). CB_Fakart:SCREEN-VALUE = tAufko.Fak_Art:SCREEN-VALUE. CB_Aufsta:SCREEN-VALUE = tAufko.Auf_Sta:SCREEN-VALUE. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gAufkoAdmin _DEFAULT-ENABLE PROCEDURE enable_UI : /*------------------------------------------------------------------------------ Purpose: ENABLE the User Interface Parameters: Notes: Here we display/view/enable the widgets in the user-interface. In addition, OPEN all queries associated with each FRAME and BROWSE. These statements here are based on the "Other Settings" section of the widget Property Sheets. ------------------------------------------------------------------------------*/ DISPLAY F_Lieferadresse F_Fakturaadresse CB_Fakart CB_Aufsta WITH FRAME gAufkoAdmin. IF AVAILABLE tAufko THEN DISPLAY tAufko.Knr tAufko.Fak_Knr tAufko.Faknr tAufko.Samm_Nr tAufko.Passant tAufko.Gedruckt tAufko.Verbucht WITH FRAME gAufkoAdmin. ENABLE RECT-2 tAufko.Knr F_Lieferadresse tAufko.Fak_Knr F_Fakturaadresse tAufko.Faknr CB_Fakart tAufko.Samm_Nr CB_Aufsta tAufko.Passant tAufko.Gedruckt tAufko.Verbucht Btn_OK Btn_Cancel WITH FRAME gAufkoAdmin. VIEW FRAME gAufkoAdmin. {&OPEN-BROWSERS-IN-QUERY-gAufkoAdmin} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gAufkoAdmin PROCEDURE ENDE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ IF btnOK THEN DO WITH FRAME {&FRAME-NAME}: FIND FIRST tAufko. tAufko.Fak_Art:SCREEN-VALUE = CB_Fakart:SCREEN-VALUE. tAufko.Auf_Sta:SCREEN-VALUE = CB_Aufsta:SCREEN-VALUE. tAufko.Fak_Art = INTEGER(CB_Fakart:SCREEN-VALUE). tAufko.Auf_Sta = INTEGER(CB_Aufsta:SCREEN-VALUE). ASSIGN {&List-6}. REPEAT TRANSACTION: FIND bAufko WHERE RECID(bAufko) = iRecid. BUFFER-COPY tAufko USING Fak_Art Auf_Sta Faknr Samm_Nr Passant Gedruckt Verbucht TO bAufko. RELEASE bAufko. LEAVE. END. oplRetVal = TRUE. END. { incl/dlgende.i } END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME