&ANALYZE-SUSPEND _VERSION-NUMBER UIB_v8r12 GUI ADM1 &ANALYZE-RESUME &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 --- */ DEF INPUT PARAMETER FVerbucht AS LOG. /* Local Variable Definitions --- */ 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 /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS CB_Fakart CB_Aufsta F_VKnr F_BKnr F_VDatum ~ F_BDatum F_FDatum Btn_OK Btn_Cancel &Scoped-Define DISPLAYED-OBJECTS CB_Fakart CB_Aufsta F_VKnr F_BKnr F_VDatum ~ F_BDatum F_FDatum /* Custom List Definitions */ /* List-1,List-2,List-3,List-4,List-5,List-6 */ &Scoped-define List-1 CB_Aufsta F_VKnr F_BKnr F_VDatum F_BDatum F_FDatum /* _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 12 BY 1 BGCOLOR 8 . DEFINE BUTTON Btn_OK AUTO-GO LABEL "&OK" SIZE 12 BY 1 BGCOLOR 8 . DEFINE VARIABLE CB_Aufsta AS CHARACTER FORMAT "X(256)":U LABEL "Auftragstatus" VIEW-AS COMBO-BOX INNER-LINES 5 DROP-DOWN-LIST SIZE 42 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE CB_Fakart AS CHARACTER FORMAT "X(256)":U LABEL "Fakturaart" VIEW-AS COMBO-BOX INNER-LINES 5 DROP-DOWN-LIST SIZE 42 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_BDatum AS DATE FORMAT "99.99.9999":U LABEL "-" VIEW-AS FILL-IN NATIVE SIZE 18.2 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_BKnr AS INTEGER FORMAT "999999":U INITIAL 0 LABEL "-" VIEW-AS FILL-IN NATIVE SIZE 12 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_FDatum AS DATE FORMAT "99.99.9999":U LABEL "Fakturadatum" VIEW-AS FILL-IN NATIVE SIZE 18.2 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_VDatum AS DATE FORMAT "99.99.9999":U LABEL "von - bis Lieferdatum" VIEW-AS FILL-IN NATIVE SIZE 18.2 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_VKnr AS INTEGER FORMAT "999999":U INITIAL 0 LABEL "von - bis Kundennummer" VIEW-AS FILL-IN NATIVE SIZE 12 BY 1 BGCOLOR 15 NO-UNDO. /* ************************ Frame Definitions *********************** */ DEFINE FRAME D-Dialog CB_Fakart AT ROW 2 COL 38 COLON-ALIGNED CB_Aufsta AT ROW 3 COL 38 COLON-ALIGNED F_VKnr AT ROW 4 COL 38 COLON-ALIGNED F_BKnr AT ROW 4 COL 62 COLON-ALIGNED F_VDatum AT ROW 5 COL 38 COLON-ALIGNED F_BDatum AT ROW 5 COL 62 COLON-ALIGNED F_FDatum AT ROW 6 COL 38 COLON-ALIGNED Btn_OK AT ROW 8 COL 16.6 Btn_Cancel AT ROW 8 COL 59 SPACE(21.39) SKIP(1.32) WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE TITLE "Auswahl Dokumente" 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 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 COMBO-BOX CB_Aufsta IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_BDatum IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_BKnr IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_FDatum IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_VDatum IN FRAME D-Dialog 1 */ /* SETTINGS FOR FILL-IN F_VKnr IN FRAME D-Dialog 1 */ /* _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 _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 /* Auswahl Dokumente */ 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: DO WITH FRAME {&FRAME-NAME}: ASSIGN {&List-1}. IF F_VDatum = ? THEN DO: { v8/fehler.i "0096" } APPLY 'ENTRY' TO F_VDatum. RETURN NO-APPLY. END. IF F_BDatum = ? THEN DO: { v8/fehler.i "0096" } APPLY 'ENTRY' TO F_BDatum. RETURN NO-APPLY. END. IF F_VDatum > F_BDatum THEN DO: { v8/fehler.i "0096" } APPLY 'ENTRY' TO F_VDatum. RETURN NO-APPLY. END. IF F_FDatum = ? THEN DO: { v8/fehler.i "0096" } APPLY 'ENTRY' TO F_FDatum. RETURN NO-APPLY. END. IF F_FDatum < F_VDatum THEN DO: { v8/fehler.i "0096" } APPLY 'ENTRY' TO F_FDatum. RETURN NO-APPLY. END. Linktext = TRIM(SUBSTRING(CB_Fakart:SCREEN-VALUE,01,03)) + ";" + TRIM(SUBSTRING(CB_Aufsta:SCREEN-VALUE,01,03)) + ";" + STRING(F_VKnr,"999999") + ";" + STRING(F_BKnr,"999999") + ";" + STRING(F_VDatum,"99.99.9999") + ";" + STRING(F_BDatum,"99.99.9999") + ";" + STRING(F_FDatum,"99.99.9999"). END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK D-Dialog /* *************************** Main Block *************************** */ DO WHILE FVerbucht: FIND Savko WHERE RECID(Savko) = INTEGER(Linktext) NO-LOCK NO-ERROR. Linktext = ''. F_VKnr = Savko.Fak_Knr. F_BKnr = Savko.Fak_Knr. F_VDatum = DATE(MONTH(Savko.Lief_Datum), 01, YEAR(Savko.Lief_Datum)). F_BDatum = F_VDatum + 27. DO ix = 1 TO 5: IF MONTH(F_BDatum + 1) <> MONTH(F_BDatum) THEN LEAVE. F_BDatum = F_BDatum + 1. END. IF Savko.Fak_Datum <> ? THEN F_FDatum = Savko.Fak_Datum. ELSE F_FDatum = F_BDatum. CB_Fakart:DELIMITER = ";". ok = TRUE. DO WHILE ok: ok = CB_Fakart:DELETE(1). END. ix = 0. i1 = 1. 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 = Savko.Fak_Art THEN i1 = ix. END. CB_Fakart:SCREEN-VALUE = CB_Fakart:ENTRY(i1). CB_Aufsta:DELIMITER = ";". ok = TRUE. DO WHILE ok: ok = CB_Aufsta:DELETE(1). END. ix = 0. i1 = 1. 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 = Savko.Auf_Sta THEN i1 = ix. END. CB_Aufsta:SCREEN-VALUE = CB_Aufsta:ENTRY(i1). LEAVE. END. DO WHILE NOT FVerbucht: FIND Aufko WHERE RECID(Aufko) = INTEGER(Linktext) NO-LOCK NO-ERROR. Linktext = ''. F_VKnr = Aufko.Fak_Knr. F_BKnr = Aufko.Fak_Knr. F_VDatum = DATE(MONTH(Aufko.Lief_Datum), 01, YEAR(Aufko.Lief_Datum)). F_BDatum = F_VDatum + 27. DO ix = 1 TO 5: IF MONTH(F_BDatum + 1) <> MONTH(F_BDatum) THEN LEAVE. F_BDatum = F_BDatum + 1. END. IF Aufko.Fak_Datum <> ? THEN F_FDatum = Aufko.Fak_Datum. ELSE F_FDatum = F_BDatum. CB_Fakart:DELIMITER = ";". ok = TRUE. DO WHILE ok: ok = CB_Fakart:DELETE(1). END. ix = 0. i1 = 1. 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). CB_Aufsta:DELIMITER = ";". ok = TRUE. DO WHILE ok: ok = CB_Aufsta:DELETE(1). END. ix = 0. i1 = 1. 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). LEAVE. 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 CB_Fakart CB_Aufsta F_VKnr F_BKnr F_VDatum F_BDatum F_FDatum WITH FRAME D-Dialog. ENABLE CB_Fakart CB_Aufsta F_VKnr F_BKnr F_VDatum F_BDatum F_FDatum Btn_OK 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 ------------------------------------------------------------------------------*/ /* SEND-RECORDS does nothing because there are no External Tables specified for this SmartDialog, and there are no tables specified in any contained Browse, Query, or Frame. */ 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