GeMIS_WEB/GUI/g-anzeig-debop.w

&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:
      <none>

  Output Parameters:
      <none>

  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:  <none>
------------------------------------------------------------------------------*/

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:  <none>
      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:  <none>
      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:  <none>
      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:  <none>
      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:  <none>
      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