&ANALYZE-SUSPEND _VERSION-NUMBER UIB_v8r12 GUI ADM1 &ANALYZE-RESUME /* Connected Databases anadat PROGRESS */ &Scoped-define WINDOW-NAME CURRENT-WINDOW &Scoped-define FRAME-NAME D-Dialog &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS D-Dialog /*------------------------------------------------------------------------ File: Description: from cntnrdlg.w - ADM SmartDialog Template Input Parameters: Output Parameters: Author: Created: ------------------------------------------------------------------------*/ /* This .W file was created with the Progress UIB. */ /*----------------------------------------------------------------------*/ /* 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 --- */ /* Local Variable Definitions --- */ DEF VAR AufRecid AS RECID NO-UNDO. DEF VAR ok AS LOG NO-UNDO. /* ---------- Globale Variablen ---------------------------------- */ { v8/globvar.i" " " " "SHARED" } { v8/debivar.i " " " " "SHARED" } { v8/artivar.i " " " " "SHARED" } { v8/contvar.i " " " " "SHARED" } /* _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 /* Name of designated FRAME-NAME and/or first browse and/or first query */ &Scoped-define FRAME-NAME D-Dialog /* Internal Tables (found by Frame, Query & Browse Queries) */ &Scoped-define INTERNAL-TABLES Aufko /* Definitions for DIALOG-BOX D-Dialog */ &Scoped-define FIELDS-IN-QUERY-D-Dialog Aufko.Knr Aufko.Fak_Knr Aufko.Faknr ~ Aufko.Samm_Nr Aufko.Passant Aufko.Gedruckt Aufko.Verbucht &Scoped-define ENABLED-FIELDS-IN-QUERY-D-Dialog Aufko.Knr Aufko.Fak_Knr ~ Aufko.Faknr Aufko.Samm_Nr Aufko.Passant Aufko.Gedruckt Aufko.Verbucht &Scoped-define ENABLED-TABLES-IN-QUERY-D-Dialog Aufko &Scoped-define FIRST-ENABLED-TABLE-IN-QUERY-D-Dialog Aufko &Scoped-define QUERY-STRING-D-Dialog FOR EACH Aufko SHARE-LOCK &Scoped-define OPEN-QUERY-D-Dialog OPEN QUERY D-Dialog FOR EACH Aufko SHARE-LOCK. &Scoped-define TABLES-IN-QUERY-D-Dialog Aufko &Scoped-define FIRST-TABLE-IN-QUERY-D-Dialog Aufko /* Standard List Definitions */ &Scoped-Define ENABLED-FIELDS Aufko.Knr Aufko.Fak_Knr Aufko.Faknr ~ Aufko.Samm_Nr Aufko.Passant Aufko.Gedruckt Aufko.Verbucht &Scoped-define ENABLED-TABLES Aufko &Scoped-define FIRST-ENABLED-TABLE Aufko &Scoped-Define ENABLED-OBJECTS CB_Fakart CB_Aufsta Btn_OK Btn_Cancel &Scoped-Define DISPLAYED-FIELDS Aufko.Knr Aufko.Fak_Knr Aufko.Faknr ~ Aufko.Samm_Nr Aufko.Passant Aufko.Gedruckt Aufko.Verbucht &Scoped-define DISPLAYED-TABLES Aufko &Scoped-define FIRST-DISPLAYED-TABLE Aufko &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-1 Aufko.Faknr Aufko.Samm_Nr Aufko.Passant ~ Aufko.Gedruckt Aufko.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 BGCOLOR 8 . DEFINE BUTTON Btn_OK AUTO-GO LABEL "&OK" SIZE 15 BY 1 BGCOLOR 8 . DEFINE VARIABLE CB_Aufsta AS CHARACTER FORMAT "X(256)":U VIEW-AS COMBO-BOX INNER-LINES 5 DROP-DOWN-LIST SIZE 50 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 50 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Fakturaadresse AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 50 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Lieferadresse AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 50 BY 1 BGCOLOR 15 NO-UNDO. /* Query definitions */ &ANALYZE-SUSPEND DEFINE QUERY D-Dialog FOR Aufko SCROLLING. &ANALYZE-RESUME /* ************************ Frame Definitions *********************** */ DEFINE FRAME D-Dialog Aufko.Knr AT ROW 2.52 COL 18 COLON-ALIGNED LABEL "Liefer-Knr" FORMAT "999999" VIEW-AS FILL-IN NATIVE SIZE 11 BY 1 BGCOLOR 15 NO-TAB-STOP F_Lieferadresse AT ROW 2.52 COL 31 COLON-ALIGNED NO-LABEL Aufko.Fak_Knr AT ROW 3.52 COL 18 COLON-ALIGNED LABEL "Faktura-Knr" FORMAT "999999" VIEW-AS FILL-IN NATIVE SIZE 11 BY 1 BGCOLOR 15 NO-TAB-STOP F_Fakturaadresse AT ROW 3.52 COL 31 COLON-ALIGNED NO-LABEL Aufko.Faknr AT ROW 4.52 COL 18 COLON-ALIGNED VIEW-AS FILL-IN NATIVE SIZE 11 BY 1 BGCOLOR 15 CB_Fakart AT ROW 4.52 COL 31 COLON-ALIGNED NO-LABEL Aufko.Samm_Nr AT ROW 5.52 COL 18 COLON-ALIGNED LABEL "Sammel-Nr" FORMAT "999999" VIEW-AS FILL-IN NATIVE SIZE 11 BY 1 BGCOLOR 15 CB_Aufsta AT ROW 5.52 COL 31 COLON-ALIGNED NO-LABEL Aufko.Passant AT ROW 6.52 COL 18 COLON-ALIGNED LABEL "Passant" FORMAT "J/N" VIEW-AS FILL-IN NATIVE SIZE 5 BY 1 BGCOLOR 15 Aufko.Gedruckt AT ROW 7.52 COL 18 COLON-ALIGNED LABEL "Gedruckt" FORMAT "J/N" VIEW-AS FILL-IN NATIVE SIZE 5 BY 1 BGCOLOR 15 Btn_OK AT ROW 7.52 COL 67.4 Aufko.Verbucht AT ROW 8.52 COL 18 COLON-ALIGNED LABEL "Verbucht" FORMAT "J/N" VIEW-AS FILL-IN NATIVE SIZE 5 BY 1 BGCOLOR 15 Btn_Cancel AT ROW 8.52 COL 67.4 SPACE(8.39) SKIP(1.57) WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE TITLE "Aenderungen durch den Administrator" DEFAULT-BUTTON Btn_OK CANCEL-BUTTON Btn_Cancel. /* *********************** Procedure Settings ************************ */ &ANALYZE-SUSPEND _PROCEDURE-SETTINGS /* Settings for THIS-PROCEDURE Type: SmartDialog Allow: Basic,Browse,DB-Fields,Query,Smart Design Page: 1 Other Settings: COMPILE */ &ANALYZE-RESUME _END-PROCEDURE-SETTINGS &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB D-Dialog /* ************************* Included-Libraries *********************** */ {src/adm/method/containr.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* *********** Runtime Attributes and AppBuilder Settings *********** */ &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES /* SETTINGS FOR DIALOG-BOX D-Dialog FRAME-NAME */ ASSIGN FRAME D-Dialog:SCROLLABLE = FALSE FRAME D-Dialog:HIDDEN = TRUE. /* SETTINGS FOR FILL-IN Aufko.Faknr IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN Aufko.Fak_Knr IN FRAME D-Dialog EXP-LABEL EXP-FORMAT */ ASSIGN Aufko.Fak_Knr:READ-ONLY IN FRAME D-Dialog = TRUE. /* SETTINGS FOR FILL-IN F_Fakturaadresse IN FRAME D-Dialog NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Lieferadresse IN FRAME D-Dialog NO-ENABLE */ /* SETTINGS FOR FILL-IN Aufko.Gedruckt IN FRAME D-Dialog 1 EXP-LABEL EXP-FORMAT */ /* SETTINGS FOR FILL-IN Aufko.Knr IN FRAME D-Dialog EXP-LABEL EXP-FORMAT */ ASSIGN Aufko.Knr:READ-ONLY IN FRAME D-Dialog = TRUE. /* SETTINGS FOR FILL-IN Aufko.Passant IN FRAME D-Dialog 1 EXP-LABEL EXP-FORMAT */ /* SETTINGS FOR FILL-IN Aufko.Samm_Nr IN FRAME D-Dialog 1 EXP-LABEL EXP-FORMAT */ /* SETTINGS FOR FILL-IN Aufko.Verbucht IN FRAME D-Dialog 1 EXP-LABEL EXP-FORMAT */ /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX D-Dialog /* Query rebuild information for DIALOG-BOX D-Dialog _TblList = "AnaDat.Aufko" _Options = "SHARE-LOCK" _Query is NOT OPENED */ /* DIALOG-BOX D-Dialog */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME D-Dialog &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL D-Dialog D-Dialog ON WINDOW-CLOSE OF FRAME D-Dialog /* Aenderungen durch den Administrator */ DO: /* Add Trigger to equate WINDOW-CLOSE to END-ERROR. */ APPLY "END-ERROR":U TO SELF. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME Btn_OK &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_OK D-Dialog ON CHOOSE OF Btn_OK IN FRAME D-Dialog /* OK */ DO: DEF VAR iFaknr AS INT NO-UNDO. DEF BUFFER BAufko FOR Aufko. DO TRANSACTION WITH FRAME {&FRAME-NAME} WHILE TRUE: FIND Aufko WHERE RECID(Aufko) = AufRecid. iFaknr = INTEGER(Aufko.Faknr:SCREEN-VALUE) NO-ERROR. IF iFaknr > 0 THEN DO: FIND FIRST Debop NO-LOCK WHERE Debop.Firma = GVFirma AND Debop.Faknr = iFaknr NO-ERROR. IF AVAILABLE Debop THEN DO: MESSAGE 'Diese Rechnugesnummer ist ungültig (bereits vorhanden)' VIEW-AS ALERT-BOX ERROR. APPLY 'ENTRY' TO Aufko.Faknr. RETURN NO-APPLY. END. FIND FIRST BAufko NO-LOCK WHERE BAufko.Firma = Aufko.Firma AND BAufko.Faknr = iFaknr AND BAufko.Knr <> Aufko.Knr NO-ERROR. IF AVAILABLE BAufko THEN DO: MESSAGE 'Diese Rechnugesnummer ist bereits bei Kunde ' BAufko.Knr ' vergeben!' VIEW-AS ALERT-BOX ERROR. APPLY 'ENTRY' TO Aufko.Faknr. RELEASE BAufko. RETURN NO-APPLY. END. FIND FIRST BAufko NO-LOCK WHERE BAufko.Firma = Aufko.Firma AND BAufko.Faknr = iFaknr AND BAufko.Knr = Aufko.Knr AND BAufko.Aufnr <> Aufko.Aufnr AND BAufko.Samm_Nr <> Aufko.Samm_Nr NO-ERROR. IF AVAILABLE BAufko THEN DO: MESSAGE 'Diese Rechnugesnummer ist bereits bei einer anderen Sammelrechung ' BAufko.Aufnr ' vergeben!' VIEW-AS ALERT-BOX ERROR. APPLY 'ENTRY' TO Aufko.Faknr. RELEASE BAufko. RETURN NO-APPLY. END. END. ASSIGN {&List-1}. ASSIGN Aufko.Fak_Art = INTEGER(SUBSTRING(CB_Fakart:SCREEN-VALUE,01,03)) Aufko.Auf_Sta = INTEGER(SUBSTRING(CB_Aufsta:SCREEN-VALUE,01,03)). RELEASE Aufko. LEAVE. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK D-Dialog /* *************************** Main Block *************************** */ FIND Aufko USE-INDEX Aufko-k1 WHERE Aufko.Firma = GVFirma AND Aufko.Aufnr = XVAufnr NO-LOCK NO-ERROR. IF NOT AVAILABLE Aufko THEN DO: APPLY 'WINDOW-CLOSE' TO FRAME {&FRAME-NAME}. RETURN NO-APPLY. END. AufRecid = RECID(Aufko). F_Lieferadresse = ''. F_Fakturaadresse = ''. FIND Adresse USE-INDEX Adresse-k1 WHERE Adresse.Firma = GVFirma AND Adresse.Knr = Aufko.Knr NO-LOCK NO-ERROR. IF AVAILABLE Adresse THEN F_Lieferadresse = Adresse.Anzeig_Br. FIND Adresse USE-INDEX Adresse-k1 WHERE Adresse.Firma = GVFirma AND Adresse.Knr = Aufko.Fak_Knr NO-LOCK NO-ERROR. IF AVAILABLE Adresse THEN F_Fakturaadresse = Adresse.Anzeig_Br. DO WITH FRAME {&FRAME-NAME}: /* Fakturaarten */ ok = TRUE. ix = 0. i1 = 1. DO WHILE ok: ok = CB_Fakart:DELETE(1). END. FOR EACH Tabel USE-INDEX Tabel-k2 WHERE Tabel.Firma = GVFirma AND Tabel.RecArt = 'FAKART' NO-LOCK: ok = CB_Fakart:ADD-LAST(STRING(Tabel.CodeI,"zz9 ") + Tabel.Bez1). ix = ix + 1. IF Tabel.CodeI = Aufko.Fak_Art THEN i1 = ix. END. CB_Fakart:SCREEN-VALUE = CB_Fakart:ENTRY(i1). /* Auftragstatus */ ok = TRUE. ix = 0. i1 = 1. DO WHILE ok: ok = CB_Aufsta:DELETE(1). END. FOR EACH Tabel USE-INDEX Tabel-k2 WHERE Tabel.Firma = GVFirma AND Tabel.RecArt = 'AUFSTATUS' NO-LOCK: ok = CB_Aufsta:ADD-LAST(STRING(Tabel.CodeI,"zz9 ") + Tabel.Bez1). ix = ix + 1. IF Tabel.CodeI = Aufko.Auf_Sta THEN i1 = ix. END. CB_Aufsta:SCREEN-VALUE = CB_Aufsta:ENTRY(i1). END. {src/adm/template/dialogmn.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* ********************** Internal Procedures *********************** */ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects D-Dialog _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 adm-row-available D-Dialog _ADM-ROW-AVAILABLE PROCEDURE adm-row-available : /*------------------------------------------------------------------------------ Purpose: Dispatched to this procedure when the Record- Source has a new row available. This procedure tries to get the new row (or foriegn keys) from the Record-Source and process it. Parameters: ------------------------------------------------------------------------------*/ /* Define variables needed by this internal procedure. */ {src/adm/template/row-head.i} /* Process the newly available records (i.e. display fields, open queries, and/or pass records on to any RECORD-TARGETS). */ {src/adm/template/row-end.i} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI D-Dialog _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 D-Dialog. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI D-Dialog _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 D-Dialog. IF AVAILABLE Aufko THEN DISPLAY Aufko.Knr Aufko.Fak_Knr Aufko.Faknr Aufko.Samm_Nr Aufko.Passant Aufko.Gedruckt Aufko.Verbucht WITH FRAME D-Dialog. ENABLE Aufko.Knr Aufko.Fak_Knr Aufko.Faknr CB_Fakart Aufko.Samm_Nr CB_Aufsta Aufko.Passant Aufko.Gedruckt Btn_OK Aufko.Verbucht Btn_Cancel WITH FRAME D-Dialog. VIEW FRAME D-Dialog. {&OPEN-BROWSERS-IN-QUERY-D-Dialog} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE send-records D-Dialog _ADM-SEND-RECORDS PROCEDURE send-records : /*------------------------------------------------------------------------------ Purpose: Send record ROWID's for all tables used by this file. Parameters: see template/snd-head.i ------------------------------------------------------------------------------*/ /* Define variables needed by this internal procedure. */ {src/adm/template/snd-head.i} /* For each requested table, put it's ROWID in the output list. */ {src/adm/template/snd-list.i "Aufko"} /* Deal with any unexpected table requests before closing. */ {src/adm/template/snd-end.i} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE state-changed D-Dialog PROCEDURE state-changed : /* ----------------------------------------------------------- Purpose: Parameters: Notes: -------------------------------------------------------------*/ DEFINE INPUT PARAMETER p-issuer-hdl AS HANDLE NO-UNDO. DEFINE INPUT PARAMETER p-state AS CHARACTER NO-UNDO. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME