GeMIS_WEB/GUI/g-gratislieferung.w

&ANALYZE-SUSPEND _VERSION-NUMBER AB_v9r12 GUI ADM2
&ANALYZE-RESUME
&Scoped-define WINDOW-NAME CURRENT-WINDOW
&Scoped-define FRAME-NAME gGratis
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gGratis 
/*------------------------------------------------------------------------

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

/* Local Variable Definitions ---                                       */

DEF VAR MaxPage         AS INT                      NO-UNDO.
DEF VAR AktSeite        AS INT                      NO-UNDO.
DEF VAR FMutFlag        AS LOG                      NO-UNDO.

DEF TEMP-TABLE TArtbw   LIKE Artbw.

/* _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 first Frame and/or Browse and/or first Query                 */
&Scoped-define FRAME-NAME gGratis

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS F_VonDatum F_BisDatum CB_Hersteller Btn_OK ~
Btn_Cancel RECT-38 
&Scoped-Define DISPLAYED-OBJECTS F_VonDatum F_BisDatum CB_Hersteller 

/* Custom List Definitions                                              */
/* List-1,List-2,List-3,List-4,List-5,List-6                            */
&Scoped-define List-1 F_VonDatum F_BisDatum CB_Hersteller 

/* _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 14 BY 1.

DEFINE BUTTON Btn_OK 
     LABEL "&Start" 
     SIZE 14 BY 1.

DEFINE VARIABLE CB_Hersteller AS CHARACTER FORMAT "X(256)":U 
     LABEL "Hersteller" 
     VIEW-AS COMBO-BOX SORT INNER-LINES 5
     DROP-DOWN-LIST
     SIZE 36 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_BisDatum AS DATE FORMAT "99.99.9999":U 
     LABEL "-" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 16 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_VonDatum AS DATE FORMAT "99.99.9999":U 
     LABEL "von - bis Lieferdatum" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 16 BY 1 TOOLTIP "Beginn der Lieferungen"
     BGCOLOR 15  NO-UNDO.

DEFINE RECTANGLE RECT-38
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL 
     SIZE 64 BY 6.67.


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

DEFINE FRAME gGratis
     F_VonDatum AT ROW 2 COL 23 COLON-ALIGNED
     F_BisDatum AT ROW 2 COL 42 COLON-ALIGNED
     CB_Hersteller AT ROW 4 COL 23 COLON-ALIGNED
     Btn_OK AT ROW 6 COL 7.4
     Btn_Cancel AT ROW 6 COL 47
     RECT-38 AT ROW 1.48 COL 3
     SPACE(1.99) SKIP(0.46)
    WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER 
         SIDE-LABELS NO-UNDERLINE THREE-D  SCROLLABLE 
         TITLE "Gratislieferungen"
         CANCEL-BUTTON Btn_Cancel.


/* *********************** 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 gGratis 
/* ************************* 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 gGratis
                                                                        */
ASSIGN 
       FRAME gGratis:SCROLLABLE       = FALSE
       FRAME gGratis:HIDDEN           = TRUE.

/* SETTINGS FOR COMBO-BOX CB_Hersteller IN FRAME gGratis
   1                                                                    */
/* SETTINGS FOR FILL-IN F_BisDatum IN FRAME gGratis
   1                                                                    */
/* SETTINGS FOR FILL-IN F_VonDatum IN FRAME gGratis
   1                                                                    */
/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


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

&ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gGratis
/* Query rebuild information for DIALOG-BOX gGratis
     _Options          = "SHARE-LOCK"
     _Query            is NOT OPENED
*/  /* DIALOG-BOX gGratis */
&ANALYZE-RESUME

 



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

&Scoped-define SELF-NAME gGratis
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gGratis gGratis
ON END-ERROR OF FRAME gGratis /* Gratislieferungen */
DO:
    RUN ENDE.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gGratis gGratis
ON GO OF FRAME gGratis /* Gratislieferungen */
DO:
    /*
    RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ) NO-ERROR.
    */
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gGratis gGratis
ON WINDOW-CLOSE OF FRAME gGratis /* Gratislieferungen */
DO:  
    RUN ENDE.
    RETURN NO-APPLY.
END.

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


&Scoped-define SELF-NAME Btn_Cancel
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Cancel gGratis
ON CHOOSE OF Btn_Cancel IN FRAME gGratis /* Abbrechen */
DO:
    RUN ENDE.
    RETURN NO-APPLY.
END.

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


&Scoped-define SELF-NAME Btn_OK
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_OK gGratis
ON CHOOSE OF Btn_OK IN FRAME gGratis /* Start */
DO:
DO WITH FRAME {&FRAME-NAME}:
    Btn_OK    :SENSITIVE = FALSE.
    Btn_Cancel:SENSITIVE = FALSE.
END.
    SESSION:SET-WAIT-STATE('Normal').
    RUN REPORT.
    SESSION:SET-WAIT-STATE('').
    RUN ENDE.
DO WITH FRAME {&FRAME-NAME}:
    Btn_OK    :SENSITIVE = FALSE.
    Btn_Cancel:SENSITIVE = FALSE.
END.
    RETURN NO-APPLY.
END.

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


&Scoped-define SELF-NAME CB_Hersteller
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Hersteller gGratis
ON RETURN OF CB_Hersteller IN FRAME gGratis /* Hersteller */
DO:
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

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


&Scoped-define SELF-NAME F_BisDatum
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_BisDatum gGratis
ON LEAVE OF F_BisDatum IN FRAME gGratis /* - */
DO:
    F_BisDatum = DATE(SELF:SCREEN-VALUE).
    IF F_BisDatum = ? THEN DO:
        SELF:SCREEN-VALUE = STRING(DATE(12,31,YEAR(TODAY))).
    END.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_BisDatum gGratis
ON RETURN OF F_BisDatum IN FRAME gGratis /* - */
DO:
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

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


&Scoped-define SELF-NAME F_VonDatum
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_VonDatum gGratis
ON LEAVE OF F_VonDatum IN FRAME gGratis /* von - bis Lieferdatum */
DO:
    F_VonDatum = DATE(SELF:SCREEN-VALUE).
    IF F_VonDatum = ? THEN DO:
        SELF:SCREEN-VALUE = STRING(DATE(01,01,YEAR(TODAY))).
    END.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_VonDatum gGratis
ON RETURN OF F_VonDatum IN FRAME gGratis /* von - bis Lieferdatum */
DO:
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

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


&UNDEFINE SELF-NAME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gGratis 


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

    MaxPage  = 1.
    AktSeite = 1.

    SESSION:DATA-ENTRY-RETURN = TRUE.

    SUBSCRIBE TO 'TOOLBAR' ANYWHERE.

/*  TRIGGERS    ------------------------------------------------------  */

    ON 'ALT-CURSOR-RIGHT':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN NEXTPAGE.
    END.
    ON 'ALT-CURSOR-LEFT':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN PREVPAGE.
    END.
    ON 'U1':U OF {&WINDOW-NAME} ANYWHERE
    DO:
        RUN ENTRY_CURSOR.
    END.
/*
    ON 'PAGE-DOWN':U OF {&WINDOW-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'Next':U ).
    END.
    ON 'PAGE-UP':U OF {&WINDOW-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'Prev':U ).
    END.
    
    ON 'ALT-RETURN':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'UPDATE':U ).
    END.
    ON 'ALT-INS':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'ADD':U    ).
    END.
    ON 'ALT-DEL':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'DELETE':U ).
    END.
    ON 'ALT-R':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'RESET':U  ).
    END.
    ON 'F9':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'SAVE':U   ).
    END.
    ON 'ALT-S':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'SAVE':U   ).
    END.
    ON 'ALT-K':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'COPY':U   ).
    END.

    ON 'END-ERROR':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        FMutFlag = DYNAMIC-FUNCTION('getMutflagAlt':U) NO-ERROR.
        IF FMutFlag = FALSE THEN DO:
            RUN ENDE.
            RETURN NO-APPLY.
        END.
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'CANCEL':U ).
        RETURN NO-APPLY.
    END.
*/    
/*  ------------------------------------------------------------------  */

    {src/adm2/dialogmn.i}

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


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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects gGratis  _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 changePage gGratis 
PROCEDURE changePage :
/*------------------------------------------------------------------------------
  Purpose:     Super Override
  Parameters:  
  Notes:       
------------------------------------------------------------------------------*/

  /* Code placed here will execute PRIOR to standard behavior. */

    RUN SUPER.

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).

    CASE AktSeite:

        WHEN 1 THEN DO:
/*           RUN addLink ( h_dyntoolbar , 'TableIO':U    , h_v-auftr        ). */
/*           RUN addLink ( h_dyntoolbar , 'Navigation':U , h_d-auftr        ). */
/*           RUN ToolbarInit ( INPUT h_d-auftr ).                              */
            RUN ENTRY_CURSOR.
        END.
        WHEN 2 THEN DO:
            RUN ENTRY_CURSOR.
        END.

    END CASE.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gGratis  _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 gGratis.
END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gGratis 
PROCEDURE enableObject :
/*------------------------------------------------------------------------------
  Purpose:     Super Override
  Parameters:  
  Notes:       
------------------------------------------------------------------------------*/

    F_VonDatum = DATE(01,01,YEAR(TODAY)).
    F_BisDatum = DATE(12,31,YEAR(TODAY)).

    RUN SUPER.

    DO WITH FRAME {&FRAME-NAME}:
        RUN FENSTER_TITEL ( INPUT FRAME {&FRAME-NAME}:HANDLE ) NO-ERROR.

        RUN COMBO_HERSTELLER ( CB_Hersteller:HANDLE ).

        DEF VAR cString     AS CHAR                     NO-UNDO.

        cString = CB_Hersteller:LIST-ITEM-PAIRS.
        cString = cString + ';Alle Hersteller;999999'.
        CB_Hersteller:LIST-ITEM-PAIRS = cString.
        CB_Hersteller:SCREEN-VALUE    = '999999'.
    END.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gGratis  _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 F_VonDatum F_BisDatum CB_Hersteller 
      WITH FRAME gGratis.
  ENABLE F_VonDatum F_BisDatum CB_Hersteller Btn_OK Btn_Cancel RECT-38 
      WITH FRAME gGratis.
  VIEW FRAME gGratis.
  {&OPEN-BROWSERS-IN-QUERY-gGratis}
END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gGratis 
PROCEDURE ENDE :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U) NO-ERROR.

    IF AktSeite > 1 THEN DO:
        RUN selectPage ( INPUT 1 ).
        RETURN NO-APPLY.
    END.

    RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ).
    APPLY 'GO' TO FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_CURSOR gGratis 
PROCEDURE ENTRY_CURSOR :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).

    CASE AktSeite:
/*         WHEN 1 THEN RUN applyEntry IN h_v-adresse  ( INPUT ? ). */
/*         WHEN 2 THEN RUN applyEntry IN h_f-adrkomm  ( INPUT ? ). */
/*         WHEN 3 THEN RUN applyEntry IN h_b-auftbb   ( INPUT ? ). */
/*         WHEN 4 THEN RUN applyEntry IN h_b-aufdet   ( INPUT ? ). */
/*         WHEN 5 THEN RUN applyEntry IN h_b-aufstreu ( INPUT ? ). */
/*         WHEN 6 THEN RUN applyEntry IN h_b-auffak   ( INPUT ? ). */
/*         WHEN 7 THEN RUN applyEntry IN h_b-position ( INPUT ? ). */
    END CASE.

    RETURN NO-APPLY.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE exitObject gGratis 
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 NEXTPAGE gGratis 
PROCEDURE NEXTPAGE :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
    IF AktSeite = MaxPage THEN AktSeite = 1.
    ELSE                       AktSeite = AktSeite + 1.

    RUN selectPage ( INPUT AktSeite ).

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE PREVPAGE gGratis 
PROCEDURE PREVPAGE :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
    IF AktSeite = 1 THEN AktSeite = MaxPage.
    ELSE                 AktSeite = AktSeite - 1.

    RUN selectPage ( INPUT AktSeite ).

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REPORT gGratis 
PROCEDURE REPORT :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF VAR excelAppl   AS COM-HANDLE               NO-UNDO.
    DEF VAR DatenName   AS CHAR                     NO-UNDO.
    DEF VAR DateiName   AS CHAR                     NO-UNDO.
    DEF VAR Zelle       AS CHAR                     NO-UNDO.
    DEF VAR VHerst      AS INT                      NO-UNDO.
    DEF VAR XArtikel    AS CHAR                     NO-UNDO.
    DEF VAR Firma       AS CHAR                     NO-UNDO.
    DEF VAR AdFirma     AS CHAR                     NO-UNDO.
    DEF VAR cDaten      AS CHAR                     NO-UNDO.
    DEF VAR FwSprcd     AS INT                      NO-UNDO.
    DEF VAR Ja          AS LOG                      NO-UNDO.
    DEF VAR VTotal      AS DEC  DECIMALS 4          NO-UNDO EXTENT 10.
    DEF VAR VBetrag     AS DEC  DECIMALS 4          NO-UNDO.

    Firma     = DYNAMIC-FUNCTION('GETMANDANT':U  )  NO-ERROR.
    AdFirma   = DYNAMIC-FUNCTION('GETADMANDANT':U)  NO-ERROR.
    FwSprcd   = DYNAMIC-FUNCTION('GETFWSPRCD':U  )  NO-ERROR.
    DatenName = 'Gratis.txt'.
    DateiName = 'Gratis.xls' + CHR(01) + 'Gratis.xls'.

DO WITH FRAME {&FRAME-NAME}:
    ASSIGN  {&List-1}.
    VHerst = INTEGER(CB_Hersteller:SCREEN-VALUE).

    DO WHILE TRUE:
        excelAppl = DYNAMIC-FUNCTION('CREATEEXCEL':U) NO-ERROR.
        IF NOT VALID-HANDLE(excelAppl) THEN DO:
            RUN FEHLER ( INPUT 1035 ).
            RETURN NO-APPLY.
        END.
        LEAVE.
    END.

    DO WHILE TRUE:
        RUN CREATEDATEI ( INPUT DateiName ).
        IF NOT RETURN-VALUE BEGINS 'ERROR-' THEN LEAVE.
        CASE RETURN-VALUE:
            WHEN 'ERROR-PARAMETER' THEN DO:
                RUN FEHLER ( INPUT 1036 ).
                RETURN NO-APPLY.
            END.
            WHEN 'ERROR-LOESCHEN' THEN DO:
                RUN FEHLER ( INPUT 1037 ).
                RETURN NO-APPLY.
            END.
            WHEN 'ERROR-VORLAGE' THEN DO:
                RUN FEHLER ( INPUT 1038 ).
                RETURN NO-APPLY.
            END.
            OTHERWISE DO:
                MESSAGE RETURN-VALUE VIEW-AS ALERT-BOX ERROR.
                RETURN NO-APPLY.
            END.
        END CASE.
        LEAVE.
    END.
    DateiName = RETURN-VALUE.

    DO WHILE TRUE:
        RUN CREATEDATEI ( INPUT DatenName ).
        IF NOT RETURN-VALUE BEGINS 'ERROR-' THEN LEAVE.
        CASE RETURN-VALUE:
            WHEN 'ERROR-PARAMETER' THEN DO:
                RUN FEHLER ( INPUT 1036 ).
                RETURN NO-APPLY.
            END.
            WHEN 'ERROR-LOESCHEN' THEN DO:
                RUN FEHLER ( INPUT 1037 ).
                RETURN NO-APPLY.
            END.
            WHEN 'ERROR-VORLAGE' THEN DO:
                RUN FEHLER ( INPUT 1038 ).
                RETURN NO-APPLY.
            END.
            OTHERWISE DO:
                MESSAGE RETURN-VALUE VIEW-AS ALERT-BOX ERROR.
                RETURN NO-APPLY.
            END.
        END CASE.
        LEAVE.
    END.
    DatenName = RETURN-VALUE.

    FOR EACH TArtbw:
        DELETE  TArtbw.
    END.
    FOR EACH Artst USE-INDEX Artst-k1
                   WHERE Artst.Firma = Firma
                   AND   Artst.Aktiv = TRUE NO-LOCK:
        IF VHerst <> 999999         AND
           Artst.Herst <> VHerst    THEN NEXT.
        FOR EACH Artbw USE-INDEX Artbw-k2
                          WHERE Artbw.Firma    = Artst.Firma
                          AND   Artbw.Artnr    = Artst.Artnr
                          AND   Artbw.Inhalt   = Artst.Inhalt
                          AND   Artbw.Jahr     = Artst.Jahr
                          AND   Artbw.Fak_Dat <> ?
                          AND   Artbw.Fak_Dat >= F_VonDatum
                          AND   Artbw.Fak_Dat <= F_BisDatum
                          AND   Artbw.Preis    = 0
                          AND   Artbw.Tr_Art   = 1      NO-LOCK:
            CREATE  TArtbw.
            BUFFER-COPY Artbw TO TArtbw.
        END.
    END.

    OUTPUT TO VALUE(DatenName) APPEND.

    IF VHerst = 999999 THEN DO:
        cDaten = ' (alle Hersteller) '.
    END.
    ELSE DO:
        RUN FIND_HERSTELLER ( INPUT VHerst, OUTPUT cDaten ).
        IF cDaten <> ?      AND
           cDaten <> ''     THEN cDaten = ENTRY(2, cDaten, CHR(01)).
        ELSE                     cDaten = '??????????'.
    END.

    cDaten = 'Gratislieferungen ' + cDaten
           + ' für die Zeit ' + STRING(F_VonDatum,'99.99.9999')
           + ' - '  + STRING(F_BisDatum,'99.99.9999').
    PUT CONTROL '£'     CHR(10)
                cDaten  CHR(10)
                '£'     CHR(10)
                '£Kunde£Fak.Datum£Menge£Listen EP£Betrag'   CHR(10)
                '£'     CHR(10).

    VTotal = 0.
    FOR EACH TArtbw
             BREAK BY TArtbw.Artnr
                   BY TArtbw.Inhalt
                   BY TArtbw.Jahr
                   BY TArtbw.Knr
                   BY TArtbw.Datum :
        
        IF FIRST-OF ( TArtbw.Jahr) THEN DO:
            FIND Artst OF TArtbw NO-LOCK.
            FIND Artbez USE-INDEX Artbez-k1
                        WHERE Artbez.Firma  = Artst.Firma
                        AND   Artbez.Artnr  = Artst.Artnr
                        AND   Artbez.Inhalt = Artst.Inhalt
                        AND   Artbez.Jahr   = Artst.Jahr
                        AND   Artbez.Sprcd  = FwSprcd NO-LOCK NO-ERROR.
            IF NOT AVAILABLE Artbez THEN DO:
                FIND FIRST Artbez OF Artst NO-LOCK NO-ERROR.
            END.
            FIND KGebinde USE-INDEX KGebinde-k1
                          WHERE KGebinde.Firma  = Firma
                          AND   KGebinde.Geb_Cd = Artst.KGeb_Cd NO-LOCK.

            XArtikel = Artbez.Bez1.
            IF Artbez.Bez2 <> ''
                THEN XArtikel = XArtikel + ", " + Artbez.Bez2.
            XArtikel = XArtikel + ", " + KGebinde.KBez.
            IF Artst.Jahr > 1000
                THEN XArtikel = XArtikel + ", " + STRING(Artst.Jahr,"9999").
            IF Artst.Alk_Gehalt <> 0
                THEN XArtikel = XArtikel + ", " + STRING(Artst.Alk_Gehalt,">>9.99%").
            PUT CONTROL XArtikel    CHR(10).
            VTotal[01] = 0.
            VTotal[03] = 0.
        END.
        
        FIND Adresse  USE-INDEX Adresse-k1
                      WHERE Adresse.Firma = AdFirma
                      AND   Adresse.Knr   = TArtbw.Knr NO-LOCK.

        VBetrag = Artst.Listen_EP * TArtbw.Menge.

        PUT CONTROL '£'
                    Adresse.Anzeig_Br                           '£'
                    STRING(TArtbw.Fak_Dat   ,'99.99.9999')      '£'
                    STRING(TArtbw.Menge     ,'->>>,>>9')        '£'
                    STRING(Artst.Listen     ,'->>>,>>9.99')     '£'
                    STRING(VBetrag          ,'->>>,>>>,>>9.99')  CHR(10).

        VTotal[01] = VTotal[01] + TArtbw.Menge.
        VTotal[02] = VTotal[02] + TArtbw.Menge.
        VTotal[03] = VTotal[03] + VBetrag.
        VTotal[04] = VTotal[04] + VBetrag.
        
        IF NOT LAST-OF( TArtbw.Jahr ) THEN NEXT.
        
        PUT CONTROL '£££'
                    STRING(VTotal[01]   ,'->>>,>>9')            '££'
                    STRING(VTotal[03]   ,'->>>,>>>,>>9.99')     CHR(10)
                    '£'                                         CHR(10).
    END.

    PUT CONTROL '£££££'
        STRING(VTotal[04]   ,'->>>,>>>,>>9.99')   CHR(10).

    OUTPUT CLOSE.

    RUN OPENEXCEL ( INPUT excelAppl,
                    INPUT DateiName,
                    INPUT '',
                    OUTPUT Ja ).
    IF NOT Ja THEN DO:
        RUN FEHLER ( INPUT 1040 ).
        RETURN NO-APPLY.
    END.

    Zelle = 'A1'.
    excelAppl:Range(Zelle):SELECT.
    excelAppl:Selection:FormulaR1C1 = 'TEXT;' + DatenName.
    excelAppl:Application:RUN ( 'DateiEinfügen' ).

    Zelle = 'A1'.
    excelAppl:Range(Zelle):SELECT.
    excelAppl:Selection:ColumnWidth = 0.3.
    
    DYNAMIC-FUNCTION('RELEASEEXCEL':U, INPUT excelAppl ) NO-ERROR.
                    
END.
END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE selectPage gGratis 
PROCEDURE selectPage :
/*------------------------------------------------------------------------------
  Purpose:     Super Override
  Parameters:  
  Notes:       
------------------------------------------------------------------------------*/

    DEF INPUT PARAMETER piPageNum   AS INT                      NO-UNDO.

    DEF VAR FMutFlag        AS LOG                      NO-UNDO.
    DEF VAR MutProg         AS CHAR                     NO-UNDO.

    FMutFlag = DYNAMIC-FUNCTION('getMutflagAlt':U) NO-ERROR.
    DO WHILE TRUE:
        IF NOT FMutFlag THEN LEAVE.
        MutProg = DYNAMIC-FUNCTION('GETMUTPROG':U).
        IF MutProg <> THIS-PROCEDURE:FILE-NAME THEN LEAVE.
        RETURN NO-APPLY.
    END.

    CASE piPageNum:

    END CASE.

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).

    CASE AktSeite:

        WHEN 1 THEN DO:
/*             RUN removeLink ( h_dyntoolbar , 'TableIO':U    , h_v-auftr       ). */
/*             RUN removeLink ( h_dyntoolbar , 'Navigation':U , h_d-auftr       ). */
        END.

    END CASE.

    RUN SUPER( INPUT piPageNum).

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE TOOLBAR gGratis 
PROCEDURE TOOLBAR :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF INPUT PARAMETER pcAction    AS CHAR             NO-UNDO.
/*    
    RUN TOOLBAR IN h_dyntoolbar ( INPUT pcAction ).
*/
END PROCEDURE.

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