GeMIS_WEB/GUI/v8/d-fakauswahl.w

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

  Output Parameters:
      <none>

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

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:  <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 D-Dialog  _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 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:  <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 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:  <none>
  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