GeMIS_WEB/GUI/v8/v-reorgdebjou.w

&ANALYZE-SUSPEND _VERSION-NUMBER UIB_v8r12 GUI ADM1
&ANALYZE-RESUME
&Scoped-define WINDOW-NAME CURRENT-WINDOW
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS V-table-Win 
/*------------------------------------------------------------------------

  File:

  Description: from VIEWER.W - Template for SmartViewer Objects

  Input Parameters:
      <none>

  Output Parameters:
      <none>

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


/*  ----------  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 SmartViewer
&Scoped-define DB-AWARE no

&Scoped-define ADM-SUPPORTED-LINKS Record-Source,Record-Target,TableIO-Target

/* Name of first Frame and/or Browse and/or first Query                 */
&Scoped-define FRAME-NAME F-Main

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS F_VKnr F_BKnr F_VFaknr F_BFaknr F_VDatum ~
F_BDatum T_DEBFA T_DEBZA T_DEBWU T_DEBOP T_DEBHI Btn_Start RECT-23 RECT-24 ~
RECT-25 
&Scoped-Define DISPLAYED-OBJECTS F_VKnr F_BKnr F_VFaknr F_BFaknr F_VDatum ~
F_BDatum T_DEBFA T_DEBZA T_DEBWU T_DEBOP T_DEBHI 

/* Custom List Definitions                                              */
/* ADM-CREATE-FIELDS,ADM-ASSIGN-FIELDS,List-3,List-4,List-5,List-6      */
&Scoped-define List-6 F_VKnr F_BKnr F_VFaknr F_BFaknr F_VDatum F_BDatum ~
T_DEBFA T_DEBZA T_DEBWU T_DEBOP T_DEBHI 

/* _UIB-PREPROCESSOR-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _XFTR "Foreign Keys" V-table-Win _INLINE
/* Actions: ? adm/support/keyedit.w ? ? ? */
/* STRUCTURED-DATA
<KEY-OBJECT>
THIS-PROCEDURE
</KEY-OBJECT>
<FOREIGN-KEYS>
</FOREIGN-KEYS> 
<EXECUTING-CODE>
**************************
* Set attributes related to FOREIGN KEYS
*/
RUN set-attribute-list (
    'Keys-Accepted = "",
     Keys-Supplied = ""':U).
/**************************
</EXECUTING-CODE> */   

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


/* ***********************  Control Definitions  ********************** */


/* Definitions of the field level widgets                               */
DEFINE BUTTON Btn_Start 
     LABEL "&Start" 
     SIZE 15.6 BY 1.

DEFINE VARIABLE F_BDatum AS DATE FORMAT "99.99.9999":U INITIAL 12/31/9999 
     VIEW-AS FILL-IN NATIVE 
     SIZE 16 BY 1.05
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_BFaknr AS INTEGER FORMAT "9999999":U INITIAL 0 
     VIEW-AS FILL-IN NATIVE 
     SIZE 11 BY 1.05
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_BKnr AS INTEGER FORMAT "999999":U INITIAL 0 
     VIEW-AS FILL-IN NATIVE 
     SIZE 11 BY 1.05
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_VDatum AS DATE FORMAT "99.99.9999":U INITIAL 01/01/1901 
     LABEL "Datum" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 16 BY 1.05
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_VFaknr AS INTEGER FORMAT "9999999":U INITIAL 0 
     LABEL "Fakturanummer" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 11 BY 1.05
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_VKnr AS INTEGER FORMAT "999999":U INITIAL 0 
     LABEL "Kundennummer" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 11 BY 1.05
     BGCOLOR 15  NO-UNDO.

DEFINE RECTANGLE RECT-23
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL 
     SIZE 64.4 BY 4.33.

DEFINE RECTANGLE RECT-24
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL 
     SIZE 87.6 BY 1.81.

DEFINE RECTANGLE RECT-25
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL 
     SIZE 89.6 BY 7.71.

DEFINE VARIABLE T_DEBFA AS LOGICAL INITIAL no 
     LABEL "Faktura" 
     VIEW-AS TOGGLE-BOX
     SIZE 14.2 BY .95 TOOLTIP "Reorg des Fakturajournals" NO-UNDO.

DEFINE VARIABLE T_DEBHI AS LOGICAL INITIAL no 
     LABEL "Kontoblatt" 
     VIEW-AS TOGGLE-BOX
     SIZE 16.8 BY .95 TOOLTIP "Reorg des Fakturajournals" NO-UNDO.

DEFINE VARIABLE T_DEBOP AS LOGICAL INITIAL no 
     LABEL "Off. Posten" 
     VIEW-AS TOGGLE-BOX
     SIZE 18 BY .95 TOOLTIP "Reorg der offenen Posten" NO-UNDO.

DEFINE VARIABLE T_DEBWU AS LOGICAL INITIAL no 
     LABEL "Mehrwertst." 
     VIEW-AS TOGGLE-BOX
     SIZE 17 BY .95 TOOLTIP "Reorg des Mehrwertsteuerjournals" NO-UNDO.

DEFINE VARIABLE T_DEBZA AS LOGICAL INITIAL no 
     LABEL "Zahlung" 
     VIEW-AS TOGGLE-BOX
     SIZE 14.2 BY .95 TOOLTIP "Reorg des Zahlungjournals" NO-UNDO.


/* ************************  Frame Definitions  *********************** */

DEFINE FRAME F-Main
     F_VKnr AT ROW 1.95 COL 22.8 COLON-ALIGNED
     F_BKnr AT ROW 1.95 COL 46 COLON-ALIGNED NO-LABEL
     F_VFaknr AT ROW 3.14 COL 22.8 COLON-ALIGNED
     F_BFaknr AT ROW 3.14 COL 46 COLON-ALIGNED NO-LABEL
     F_VDatum AT ROW 4.33 COL 22.8 COLON-ALIGNED
     F_BDatum AT ROW 4.33 COL 46 COLON-ALIGNED NO-LABEL
     T_DEBFA AT ROW 7.38 COL 5
     T_DEBZA AT ROW 7.38 COL 20.6
     T_DEBWU AT ROW 7.38 COL 35.8
     T_DEBOP AT ROW 7.38 COL 54
     T_DEBHI AT ROW 7.38 COL 73
     Btn_Start AT ROW 4.33 COL 72.6
     RECT-23 AT ROW 1.57 COL 3.6
     RECT-24 AT ROW 6.91 COL 3.6
     RECT-25 AT ROW 1.29 COL 2.6
     "--" VIEW-AS TEXT
          SIZE 2 BY 1.05 AT ROW 1.95 COL 44.4
     "--" VIEW-AS TEXT
          SIZE 2 BY 1.05 AT ROW 3.14 COL 44.4
     "--" VIEW-AS TEXT
          SIZE 2 BY 1.05 AT ROW 4.33 COL 44.4
    WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY 
         SIDE-LABELS NO-UNDERLINE THREE-D 
         AT COL 1 ROW 1 SCROLLABLE .


/* *********************** Procedure Settings ************************ */

&ANALYZE-SUSPEND _PROCEDURE-SETTINGS
/* Settings for THIS-PROCEDURE
   Type: SmartViewer
   Allow: Basic,DB-Fields
   Frames: 1
   Add Fields to: EXTERNAL-TABLES
   Other Settings: PERSISTENT-ONLY COMPILE
 */

/* This procedure should always be RUN PERSISTENT.  Report the error,  */
/* then cleanup and return.                                            */
IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
          VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  RETURN.
END.

&ANALYZE-RESUME _END-PROCEDURE-SETTINGS

/* *************************  Create Window  ************************** */

&ANALYZE-SUSPEND _CREATE-WINDOW
/* DESIGN Window definition (used by the UIB) 
  CREATE WINDOW V-table-Win ASSIGN
         HEIGHT             = 8.48
         WIDTH              = 92.2.
/* END WINDOW DEFINITION */
                                                                        */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB V-table-Win 
/* ************************* Included-Libraries *********************** */

{src/adm/method/viewer.i}

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME




/* ***********  Runtime Attributes and AppBuilder Settings  *********** */

&ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
/* SETTINGS FOR WINDOW V-table-Win
  VISIBLE,,RUN-PERSISTENT                                               */
/* SETTINGS FOR FRAME F-Main
   NOT-VISIBLE Size-to-Fit Custom                                       */
ASSIGN 
       FRAME F-Main:SCROLLABLE       = FALSE
       FRAME F-Main:HIDDEN           = TRUE.

/* SETTINGS FOR FILL-IN F_BDatum IN FRAME F-Main
   6                                                                    */
/* SETTINGS FOR FILL-IN F_BFaknr IN FRAME F-Main
   6                                                                    */
/* SETTINGS FOR FILL-IN F_BKnr IN FRAME F-Main
   6                                                                    */
/* SETTINGS FOR FILL-IN F_VDatum IN FRAME F-Main
   6                                                                    */
/* SETTINGS FOR FILL-IN F_VFaknr IN FRAME F-Main
   6                                                                    */
/* SETTINGS FOR FILL-IN F_VKnr IN FRAME F-Main
   6                                                                    */
/* SETTINGS FOR TOGGLE-BOX T_DEBFA IN FRAME F-Main
   6                                                                    */
/* SETTINGS FOR TOGGLE-BOX T_DEBHI IN FRAME F-Main
   6                                                                    */
/* SETTINGS FOR TOGGLE-BOX T_DEBOP IN FRAME F-Main
   6                                                                    */
/* SETTINGS FOR TOGGLE-BOX T_DEBWU IN FRAME F-Main
   6                                                                    */
/* SETTINGS FOR TOGGLE-BOX T_DEBZA IN FRAME F-Main
   6                                                                    */
/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


/* Setting information for Queries and Browse Widgets fields            */

&ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
/* Query rebuild information for FRAME F-Main
     _Options          = "NO-LOCK"
     _Query            is NOT OPENED
*/  /* FRAME F-Main */
&ANALYZE-RESUME

 



/* ************************  Control Triggers  ************************ */

&Scoped-define SELF-NAME F-Main
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F-Main V-table-Win
ON END-ERROR OF FRAME F-Main
DO:
    RUN new-state ( INPUT 'ENDE, MAIN':U ).
    RETURN NO-APPLY.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&Scoped-define SELF-NAME Btn_Start
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Start V-table-Win
ON CHOOSE OF Btn_Start IN FRAME F-Main /* Start */
DO:
    DISABLE Btn_Start WITH FRAME {&FRAME-NAME}.
    RUN REORG.
    ENABLE  Btn_Start WITH FRAME {&FRAME-NAME}.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&UNDEFINE SELF-NAME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK V-table-Win 


/* ***************************  Main Block  *************************** */

  &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN          
    RUN dispatch IN THIS-PROCEDURE ('initialize':U).        
  &ENDIF         
  
  /************************ INTERNAL PROCEDURES ********************/

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


/* **********************  Internal Procedures  *********************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-row-available V-table-Win  _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:  <none>
------------------------------------------------------------------------------*/

  /* 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 V-table-Win  _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 F-Main.
  IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE.
END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REORG V-table-Win 
PROCEDURE REORG :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DO WITH FRAME {&FRAME-NAME}:
        ASSIGN  {&List-6}.
        
        IF F_VKnr = 0           AND
           F_BKnr = 0           THEN F_BKnr = 9999999.
        IF F_BKnr < F_VKnr      THEN F_BKnr = F_VKnr.
        
        IF F_VFaknr = 0         AND
           F_BFaknr = 0         THEN F_BFaknr = 999999.
        IF F_BFaknr < F_VFaknr  THEN F_BFaknr = F_VFaknr.

        IF F_VDatum = ?         THEN F_VDatum = 01/01/0001.
        IF F_BDatum = ?         THEN F_BDatum = TODAY - 1.
        IF F_BDatum < F_VDatum  THEN F_BDatum = F_VDatum.
        
        DISPLAY {&List-6}.
                
        DO WHILE T_DEBFA:
            DISABLE T_DEBFA.
            FOR EACH Debfa USE-INDEX Debfa-k3
                           WHERE Debfa.Firma   = GVFirma
                           AND   Debfa.FakDat >= F_VDatum
                           AND   Debfa.FakDat <= F_BDatum
                           AND   Debfa.Faknr  >= F_VFaknr
                           AND   Debfa.Faknr  <= F_BFaknr
                           AND   Debfa.Knr    >= F_VKnr  
                           AND   Debfa.Knr    <= F_BKnr  :
                DELETE  Debfa.
            END.
            ENABLE  T_DEBFA.
            LEAVE.
        END.
            
        DO WHILE T_DEBZA:
            DISABLE T_DEBZA.
            FOR EACH Debza USE-INDEX Debza-k3
                           WHERE Debza.Firma   = GVFirma
                           AND   Debza.ZahDat >= F_VDatum
                           AND   Debza.ZahDat <= F_BDatum
                           AND   Debza.Faknr  >= F_VFaknr
                           AND   Debza.Faknr  <= F_BFaknr
                           AND   Debza.Knr    >= F_VKnr  
                           AND   Debza.Knr    <= F_BKnr  :
                DELETE  Debza.
            END.
            ENABLE  T_DEBZA.
            LEAVE.
        END.
            
        DO WHILE T_DEBWU:
            DISABLE T_DEBWU.
            FOR EACH Debwu USE-INDEX Debwu-k3
                           WHERE Debwu.Firma   = GVFirma
                           AND   Debwu.Datum  >= F_VDatum
                           AND   Debwu.Datum  <= F_BDatum
                           AND   Debwu.Faknr  >= F_VFaknr
                           AND   Debwu.Faknr  <= F_BFaknr
                           AND   Debwu.Knr    >= F_VKnr  
                           AND   Debwu.Knr    <= F_BKnr  :
                DELETE  Debwu.
            END.
            ENABLE  T_DEBWU.
            LEAVE.
        END.
            
        DO WHILE T_DEBOP:
            DISABLE T_DEBOP.
            FOR EACH Debop USE-INDEX Debop-k1
                           WHERE Debop.Firma   = GVFirma
                           AND   Debop.Knr    >= F_VKnr  
                           AND   Debop.Knr    <= F_BKnr
                           AND   Debop.Faknr  >= F_VFaknr
                           AND   Debop.Faknr  <= F_BFaknr
                           AND   Debop.FakDat >= F_VDatum
                           AND   Debop.FakDat <= F_BDatum
                           AND   Debop.Saldo   = 0  :
                IF Debop.Faknr = 999999 THEN NEXT.
                DELETE  Debop.
            END.
            ENABLE  T_DEBOP.
            LEAVE.
        END.
            
        DO WHILE T_DEBHI:
            DISABLE T_DEBHI.
            FOR EACH Debhi USE-INDEX Debhi-k2
                           WHERE Debhi.Firma   = GVFirma
                           AND   Debhi.Knr    >= F_VKnr  
                           AND   Debhi.Knr    <= F_BKnr
                           AND   Debhi.Datum  >= F_VDatum
                           AND   Debhi.Datum  <= F_BDatum
                           AND   Debhi.Faknr  >= F_VFaknr
                           AND   Debhi.Faknr  <= F_BFaknr :
                DELETE  Debhi.
            END.
            ENABLE  T_DEBHI.
            LEAVE.
        END.
        
    END.
            
END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE send-records V-table-Win  _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 SmartViewer, 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 V-table-Win 
PROCEDURE state-changed :
/* -----------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
-------------------------------------------------------------*/
  DEFINE INPUT PARAMETER p-issuer-hdl AS HANDLE    NO-UNDO.
  DEFINE INPUT PARAMETER p-state      AS CHARACTER NO-UNDO.

  CASE p-state:
      /* Object instance CASEs can go here to replace standard behavior
         or add new cases. */
      {src/adm/template/vstates.i}
  END CASE.
END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME