&ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2 &ANALYZE-RESUME /* Connected Databases adprime PROGRESS */ &Scoped-define WINDOW-NAME CURRENT-WINDOW &Scoped-define FRAME-NAME gOffenPosten &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gOffenPosten /*------------------------------------------------------------------------ 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 --- */ DEFINE INPUT PARAMETER ipArt AS INTEGER NO-UNDO. DEFINE INPUT PARAMETER ipStart AS DECIMAL NO-UNDO. DEFINE OUTPUT PARAMETER opRecid AS RECID NO-UNDO. /* Local Variable Definitions --- */ DEFINE VARIABLE MaxPage AS INTEGER NO-UNDO. DEFINE VARIABLE AktSeite AS INTEGER NO-UNDO. DEFINE VARIABLE FMutFlag AS LOG NO-UNDO. DEFINE VARIABLE ProgName AS CHARACTER NO-UNDO. DEFINE VARIABLE SAktiv AS LOG NO-UNDO. DEFINE VARIABLE Firma AS CHARACTER NO-UNDO. DEFINE VARIABLE AdFirma AS CHARACTER NO-UNDO. DEFINE VARIABLE iArt AS INTEGER NO-UNDO. /* _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 gOffenPosten &Scoped-define BROWSE-NAME Br_Debop /* Internal Tables (found by Frame, Query & Browse Queries) */ &Scoped-define INTERNAL-TABLES Debop /* Definitions for BROWSE Br_Debop */ &Scoped-define FIELDS-IN-QUERY-Br_Debop Debop.Knr Debop.Faknr Debop.Fakdat ~ Debop.Fakbetr Debop.Fakbetr_FRW Debop.Saldo Debop.Saldo_FRW &Scoped-define ENABLED-FIELDS-IN-QUERY-Br_Debop &Scoped-define QUERY-STRING-Br_Debop FOR EACH Debop NO-LOCK INDEXED-REPOSITION &Scoped-define OPEN-QUERY-Br_Debop OPEN QUERY Br_Debop FOR EACH Debop NO-LOCK INDEXED-REPOSITION. &Scoped-define TABLES-IN-QUERY-Br_Debop Debop &Scoped-define FIRST-TABLE-IN-QUERY-Br_Debop Debop /* Definitions for DIALOG-BOX gOffenPosten */ /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS RECT-3 Br_Debop T_Null &Scoped-Define DISPLAYED-OBJECTS T_Null /* Custom List Definitions */ /* List-1,List-2,List-3,List-4,List-5,List-6 */ /* _UIB-PREPROCESSOR-BLOCK-END */ &ANALYZE-RESUME /* *********************** Control Definitions ********************** */ /* Define a dialog box */ /* Definitions of the field level widgets */ DEFINE RECTANGLE RECT-3 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 118 BY 9.05. DEFINE VARIABLE T_Null AS LOGICAL INITIAL NO LABEL "Saldo = 0" VIEW-AS TOGGLE-BOX SIZE 15 BY .81 NO-UNDO. /* Query definitions */ &ANALYZE-SUSPEND DEFINE QUERY Br_Debop FOR Debop SCROLLING. &ANALYZE-RESUME /* Browse definitions */ DEFINE BROWSE Br_Debop &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_Debop gOffenPosten _STRUCTURED QUERY Br_Debop NO-LOCK DISPLAY Debop.Knr FORMAT "999999":U Debop.Faknr FORMAT "9999999":U Debop.Fakdat COLUMN-LABEL "Datum" FORMAT "99.99.9999":U Debop.Fakbetr COLUMN-LABEL "Betrag" FORMAT "zzz,zzz,zz9.99-":U Debop.Fakbetr_FRW COLUMN-LABEL "Betrag/Frw" FORMAT "zzz,zzz,zz9.99-":U Debop.Saldo FORMAT "zzz,zzz,zz9.99-":U Debop.Saldo_FRW COLUMN-LABEL "Saldo/Frw" FORMAT "zzz,zzz,zz9.99-":U /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME WITH NO-ROW-MARKERS SEPARATORS SIZE 98 BY 8.57. /* ************************ Frame Definitions *********************** */ DEFINE FRAME gOffenPosten Br_Debop AT ROW 1.48 COL 3 T_Null AT ROW 1.48 COL 103 RECT-3 AT ROW 1.24 COL 2 SPACE(0.79) SKIP(0.18) WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE TITLE "anzeigen offene Posten". /* *********************** 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 */ &ANALYZE-RESUME _END-PROCEDURE-SETTINGS &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB gOffenPosten /* ************************* 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 gOffenPosten FRAME-NAME */ /* BROWSE-TAB Br_Debop RECT-3 gOffenPosten */ ASSIGN FRAME gOffenPosten:SCROLLABLE = FALSE FRAME gOffenPosten:HIDDEN = TRUE. /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_Debop /* Query rebuild information for BROWSE Br_Debop _TblList = "ADPRIME.Debop" _Options = "NO-LOCK INDEXED-REPOSITION" _FldNameList[1] = ADPRIME.Debop.Knr _FldNameList[2] = ADPRIME.Debop.Faknr _FldNameList[3] > ADPRIME.Debop.Fakdat "Debop.Fakdat" "Datum" ? "date" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no _FldNameList[4] > ADPRIME.Debop.Fakbetr "Debop.Fakbetr" "Betrag" ? "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no _FldNameList[5] > ADPRIME.Debop.Fakbetr_FRW "Debop.Fakbetr_FRW" "Betrag/Frw" ? "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no _FldNameList[6] = ADPRIME.Debop.Saldo _FldNameList[7] > ADPRIME.Debop.Saldo_FRW "Debop.Saldo_FRW" "Saldo/Frw" ? "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no _Query is NOT OPENED */ /* BROWSE Br_Debop */ &ANALYZE-RESUME &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gOffenPosten /* Query rebuild information for DIALOG-BOX gOffenPosten _Options = "SHARE-LOCK" _Query is NOT OPENED */ /* DIALOG-BOX gOffenPosten */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME gOffenPosten &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gOffenPosten gOffenPosten ON END-ERROR OF FRAME gOffenPosten /* anzeigen offene Posten */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gOffenPosten gOffenPosten ON GO OF FRAME gOffenPosten /* anzeigen offene Posten */ DO: /* RUN ENDE_PROGRAMM ( INPUT Progname ) NO-ERROR. */ END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gOffenPosten gOffenPosten ON WINDOW-CLOSE OF FRAME gOffenPosten /* anzeigen offene Posten */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define BROWSE-NAME Br_Debop &Scoped-define SELF-NAME Br_Debop &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Debop gOffenPosten ON LEFT-MOUSE-DBLCLICK OF Br_Debop IN FRAME gOffenPosten DO: RUN SELEKTION. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Debop gOffenPosten ON RETURN OF Br_Debop IN FRAME gOffenPosten DO: RUN SELEKTION. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Debop gOffenPosten ON ROW-DISPLAY OF Br_Debop IN FRAME gOffenPosten DO: CASE iArt: WHEN 1 THEN Debop.Faknr :BGCOLOR IN BROWSE {&BROWSE-NAME} = 14. WHEN 2 THEN Debop.Knr :BGCOLOR IN BROWSE {&BROWSE-NAME} = 14. WHEN 3 THEN Debop.Fakbetr_Frw:BGCOLOR IN BROWSE {&BROWSE-NAME} = 14. END CASE. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME T_Null &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL T_Null gOffenPosten ON VALUE-CHANGED OF T_Null IN FRAME gOffenPosten /* Saldo = 0 */ DO: RUN OPENQUERYDEBOP. APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gOffenPosten /* *************************** Main Block *************************** */ opRecid = ?. MaxPage = 1. AktSeite = 1. sAktiv = DYNAMIC-FUNCTION('getSuperaktiv':U) NO-ERROR. IF sAktiv THEN DO: Firma = DYNAMIC-FUNCTION('getMandant':U ) NO-ERROR. AdFirma = DYNAMIC-FUNCTION('getAdMandat':U ) NO-ERROR. Progname = DYNAMIC-FUNCTION('MAKEPROGNAME':U, INPUT THIS-PROCEDURE ) NO-ERROR. END. SESSION:DATA-ENTRY-RETURN = TRUE. {src/adm2/dialogmn.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* ********************** Internal Procedures *********************** */ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects gOffenPosten _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 gOffenPosten _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 gOffenPosten. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gOffenPosten PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEFINE VARIABLE wx AS INTEGER NO-UNDO. DEFINE VARIABLE wy AS INTEGER NO-UNDO. DEFINE VARIABLE MaxX AS INTEGER NO-UNDO. DEFINE VARIABLE MaxY AS INTEGER NO-UNDO. DEFINE VARIABLE xString AS CHARACTER NO-UNDO. MaxX = SESSION:WIDTH-PIXELS. MaxY = SESSION:HEIGHT-PIXELS. GET-KEY-VALUE SECTION 'FensterPositionen' KEY ProgName VALUE xString. IF xString = ? THEN xString = '30;30'. IF xString = '' THEN xString = '30;30'. wx = INTEGER(ENTRY(1, xString, ';')). wy = INTEGER(ENTRY(2, xString, ';')). IF wx < 0 THEN wx = 30. IF wy < 0 THEN wy = 30. IF wx > (MaxX - 20) THEN wx = 30. IF wy > (MaxY - 20) THEN wy = 30. FRAME {&FRAME-NAME}:X = wx. FRAME {&FRAME-NAME}:Y = wy. RUN SUPER. IF sAktiv THEN RUN FENSTER_TITEL ( INPUT FRAME {&FRAME-NAME}:HANDLE ) NO-ERROR. RUN OPENQUERYDEBOP. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gOffenPosten _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 T_Null WITH FRAME gOffenPosten. ENABLE RECT-3 Br_Debop T_Null WITH FRAME gOffenPosten. VIEW FRAME gOffenPosten. {&OPEN-BROWSERS-IN-QUERY-gOffenPosten} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gOffenPosten PROCEDURE ENDE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEFINE VARIABLE wx AS INTEGER NO-UNDO. DEFINE VARIABLE wy AS INTEGER NO-UNDO. DEFINE VARIABLE xString AS CHARACTER NO-UNDO. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U) NO-ERROR. IF AktSeite > 1 THEN DO: RUN selectPage ( INPUT 1 ). RETURN NO-APPLY. END. IF sAktiv THEN RUN ENDE_PROGRAMM ( INPUT Progname ). wx = FRAME {&FRAME-NAME}:X NO-ERROR. wy = FRAME {&FRAME-NAME}:Y NO-ERROR. xString = STRING(wx) + ';' + STRING(wy). PUT-KEY-VALUE SECTION 'FensterPositionen' KEY ProgName VALUE xString. APPLY "CLOSE":U TO THIS-PROCEDURE. APPLY 'GO' TO FRAME {&FRAME-NAME}. RETURN NO-APPLY. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE exitObject gOffenPosten PROCEDURE exitObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ RUN ENDE. RETURN NO-APPLY. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE OPENQUERYDEBOP gOffenPosten PROCEDURE OPENQUERYDEBOP : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEFINE VARIABLE Knr AS INTEGER NO-UNDO. DEFINE VARIABLE Faknr AS INTEGER NO-UNDO. DEFINE VARIABLE Betrag AS DECIMAL NO-UNDO. DO WITH FRAME {&FRAME-NAME}: ASSIGN T_Null. END. iArt = ipArt. DO WHILE NOT T_Null: CASE iArt: WHEN 1 THEN DO: Faknr = ipStart. OPEN QUERY {&BROWSE-NAME} FOR EACH Debop USE-INDEX Debop-k2 WHERE Debop.Firma = Firma AND Debop.Faknr >= Faknr AND Debop.Saldo_Frw <> 0 NO-LOCK. END. WHEN 2 THEN DO: Knr = ipStart. OPEN QUERY {&BROWSE-NAME} FOR EACH Debop USE-INDEX Debop-k1 WHERE Debop.Firma = Firma AND Debop.Knr = Knr AND Debop.Saldo_Frw <> 0 NO-LOCK. END. WHEN 3 THEN DO: Betrag = ipStart. OPEN QUERY {&BROWSE-NAME} FOR EACH Debop USE-INDEX Debop-k3 WHERE Debop.Firma = Firma AND Debop.Fakbetr_Frw >= Betrag AND Debop.Saldo_Frw <> 0 NO-LOCK. END. END CASE. LEAVE. END. DO WHILE T_Null: CASE iArt: WHEN 1 THEN DO: Faknr = ipStart. OPEN QUERY {&BROWSE-NAME} FOR EACH Debop USE-INDEX Debop-k2 WHERE Debop.Firma = Firma AND Debop.Faknr >= Faknr NO-LOCK. END. WHEN 2 THEN DO: Knr = ipStart. OPEN QUERY {&BROWSE-NAME} FOR EACH Debop USE-INDEX Debop-k1 WHERE Debop.Firma = Firma AND Debop.Knr >= Knr NO-LOCK. END. WHEN 3 THEN DO: Betrag = ipStart. OPEN QUERY {&BROWSE-NAME} FOR EACH Debop USE-INDEX Debop-k3 WHERE Debop.Firma = Firma AND Debop.Fakbetr_Frw >= Betrag NO-LOCK. END. END CASE. LEAVE. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SELEKTION gOffenPosten PROCEDURE SELEKTION : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DO WHILE TRUE WITH FRAME {&FRAME-NAME}: IF NUM-RESULTS('{&BROWSE-NAME}') = ? THEN LEAVE. IF NUM-RESULTS('{&BROWSE-NAME}') = 0 THEN LEAVE. IF {&BROWSE-NAME}:NUM-SELECTED-ROWS = 0 THEN LEAVE. {&BROWSE-NAME}:FETCH-SELECTED-ROW(1). opRecid = RECID(Debop). LEAVE. END. APPLY 'GO' TO FRAME {&FRAME-NAME}. RETURN NO-APPLY. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME