GeMIS_WEB/GUI/g-aktionen.w

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

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

DEFINE VARIABLE MaxPage  AS INTEGER   NO-UNDO.
DEFINE VARIABLE AktSeite AS INTEGER   NO-UNDO.
DEFINE VARIABLE FMutFlag AS LOG       NO-UNDO.
DEFINE VARIABLE Firma    AS CHARACTER 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 first Frame and/or Browse and/or first Query                 */
&Scoped-define FRAME-NAME gAAktionen

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS F_VonDatum F_BisDatum R_Sort T_Lieferanten ~
Btn_OK Btn_Cancel RECT-3 
&Scoped-Define DISPLAYED-OBJECTS F_VonDatum F_BisDatum R_Sort T_Lieferanten 

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

/* _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 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 Datum" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 16 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE R_Sort AS INTEGER 
     VIEW-AS RADIO-SET VERTICAL
     RADIO-BUTTONS 
          "Sortiert nach Bezeichnung", 1,
"Sortiert nach Artikelnummer", 2
     SIZE 35 BY 1.67 NO-UNDO.

DEFINE RECTANGLE RECT-3
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL   
     SIZE 68 BY 7.38.

DEFINE VARIABLE T_Lieferanten AS LOGICAL INITIAL NO 
     LABEL "Nur Hauptlieferant ?" 
     VIEW-AS TOGGLE-BOX
     SIZE 33 BY 1 NO-UNDO.


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

DEFINE FRAME gAAktionen
     F_VonDatum AT ROW 2.1 COL 18 COLON-ALIGNED
     F_BisDatum AT ROW 2.1 COL 37 COLON-ALIGNED
     R_Sort AT ROW 3.52 COL 20 NO-LABEL WIDGET-ID 4
     T_Lieferanten AT ROW 5.52 COL 20 WIDGET-ID 2
     Btn_OK AT ROW 7 COL 21
     Btn_Cancel AT ROW 7 COL 39.8
     RECT-3 AT ROW 1.24 COL 2
     SPACE(0.99) SKIP(0.32)
    WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER 
         SIDE-LABELS NO-UNDERLINE THREE-D  SCROLLABLE 
         TITLE "Aktionen"
         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 gAAktionen 
/* ************************* 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 gAAktionen
   Custom                                                               */
ASSIGN 
       FRAME gAAktionen:SCROLLABLE       = FALSE
       FRAME gAAktionen:HIDDEN           = TRUE.

/* SETTINGS FOR FILL-IN F_BisDatum IN FRAME gAAktionen
   6                                                                    */
/* SETTINGS FOR FILL-IN F_VonDatum IN FRAME gAAktionen
   6                                                                    */
/* SETTINGS FOR RADIO-SET R_Sort IN FRAME gAAktionen
   6                                                                    */
/* SETTINGS FOR TOGGLE-BOX T_Lieferanten IN FRAME gAAktionen
   6                                                                    */
/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


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

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

 



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

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

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


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

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gAAktionen gAAktionen
ON WINDOW-CLOSE OF FRAME gAAktionen /* Aktionen */
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 gAAktionen
ON CHOOSE OF Btn_Cancel IN FRAME gAAktionen /* 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 gAAktionen
ON CHOOSE OF Btn_OK IN FRAME gAAktionen /* Start */
DO:
        RUN REPORT.
        ENABLE  Btn_OK
            Btn_Cancel WITH FRAME {&FRAME-NAME}.
        RUN ENDE.
        RETURN NO-APPLY.
    END.

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


&Scoped-define SELF-NAME R_Sort
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL R_Sort gAAktionen
ON RETURN OF R_Sort IN FRAME gAAktionen
DO:
    APPLY 'TAB' TO SELF.
END.

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


&Scoped-define SELF-NAME T_Lieferanten
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL T_Lieferanten gAAktionen
ON RETURN OF T_Lieferanten IN FRAME gAAktionen /* Nur Hauptlieferant ? */
DO:
    APPLY 'TAB' TO SELF.  
END.

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



&UNDEFINE SELF-NAME

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


/* ***************************  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 gAAktionen  _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 gAAktionen 
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 gAAktionen  _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 gAAktionen.
END PROCEDURE.

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

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

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

    RUN SUPER.

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

END PROCEDURE.

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

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

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gAAktionen 
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 gAAktionen 
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 gAAktionen 
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 KOPF gAAktionen 
PROCEDURE KOPF :
/*------------------------------------------------------------------------------
          Purpose:     
          Parameters:  <none>
          Notes:       
        ------------------------------------------------------------------------------*/

    DEFINE INPUT PARAMETER eh  AS COMPONENT-HANDLE       NO-UNDO.

    DEFINE VARIABLE Zelle AS CHARACTER NO-UNDO.
    /*
        eh:APPLICATION:RUN('FormatKopf').
    */
    FIND Steuer USE-INDEX Steuer-k1
        WHERE Steuer.Firma = Firma NO-LOCK NO-ERROR.

    Zelle = 'A1'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = Steuer.Firma1.
    Zelle = 'D1'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = 'Aktionsliste'.
    Zelle = 'H1'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = 'Datum : ' + STRING(TODAY,'99.99.9999').

    Zelle = 'A2'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = Steuer.Ort.
    Zelle = 'D2'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = ''.
    Zelle = 'H2'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = 'Zeit  :     ' + STRING(TIME,'HH:MM:SS').

END PROCEDURE.

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

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

    DEFINE VARIABLE excelAppl AS COMPONENT-HANDLE NO-UNDO.
    DEFINE VARIABLE DatenName AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE DateiName AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE Zelle     AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE xText     AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE Ja        AS LOG              NO-UNDO.
    DEFINE VARIABLE KGeb      AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE VGeb      AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE GGeb      AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE sWgr      AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE sPgr      AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE sAgr      AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE sRgr      AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE sBgr      AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE sHerst    AS CHARACTER        NO-UNDO.
    DEFINE VARIABLE hQuery    AS HANDLE           NO-UNDO.
    DEFINE VARIABLE hBuffer   AS HANDLE           NO-UNDO.
    DEFINE VARIABLE cWhere    AS CHARACTER        NO-UNDO.

    Firma     = DYNAMIC-FUNCTION('GETMANDANT':U) NO-ERROR.
    DatenName = 'Aktionen.txt'.
    DateiName = 'Aktionen.xls' + CHR(01) + 'Aktionen.xls'.

    DO WITH FRAME {&FRAME-NAME}:
        ASSIGN  {&List-6}.
        IF F_VonDatum = ? THEN F_VonDatum = DATE(MONTH(TODAY),01,YEAR(TODAY)).
        IF F_BisDatum = ? THEN F_BisDatum = DATE(12,31,YEAR(TODAY)).
        DISPLAY {&List-6}.
        DISABLE Btn_OK
            Btn_Cancel.

        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.

        OUTPUT TO VALUE(DatenName) APPEND.

        PUT CONTROL '£Artnr£Bezeichnung£Jahr£KGebinde£'
            'Abschlag£von Datum£bis Datum'                  CHR(10)
            '£'                                             CHR(10).
            
        CREATE QUERY hQuery.
        
        hBuffer = BUFFER AktPreis:HANDLE.
        hQuery:SET-BUFFERS(hBuffer).
        
        hBuffer = BUFFER Artst:HANDLE.
        hQuery:ADD-BUFFER(hBuffer).
        
        hBuffer = BUFFER ArtLief:HANDLE.
        hQuery:ADD-BUFFER(hBuffer).
        
        cWhere = 'FOR EACH AktPreis NO-LOCK '
            + 'WHERE AktPreis.Firma      = &1  '
            + 'AND ((AktPreis.Ab_Datum  >= &2  '
            + 'AND   AktPreis.Ab_Datum  <= &3) '
            + ' OR  (AktPreis.Bis_Datum >= &2  '
            + 'AND   AktPreis.Bis_Datum <= &3)), '
               
            + 'EACH Artst NO-LOCK OF AktPreis, '
               
            + 'EACH ArtLief NO-LOCK '
            + 'WHERE ArtLief.Firma  = AktPreis.Firma  '
            + 'AND   Artlief.Artnr  = AktPreis.Artnr  '
            + 'AND   ArtLief.Inhalt = AktPreis.Inhalt '
            + 'AND   ArtLief.Jahr   = AktPreis.Jahr '.
        IF T_Lieferanten THEN cWhere = cWhere + 'AND ArtLief.Haupt = TRUE '.
        cWhere = cWhere + 'BREAK BY AktPreis.Grp '
            + 'BY ArtLief.Knr '.
        IF R_Sort = 1 THEN cWhere = cWhere + 'BY Artst.Bez '.
        cWhere = cWhere + 'BY AktPreis.Artnr '
            + 'BY AktPreis.Inhalt '
            + 'BY AktPreis.Jahr '.
        cWhere = SUBSTITUTE(cWhere, QUOTER(Firma), STRING(F_VonDatum), STRING(F_BisDatum)  ).

        hQuery:QUERY-PREPARE(cWhere).
        hQuery:QUERY-OPEN().
        
        DO WHILE hQuery:GET-NEXT():

            IF hQuery:FIRST-OF ( 1 ) THEN 
            DO:
                RUN FIND_KUNDENGRUPPE ( INPUT AktPreis.Grp, OUTPUT xText ).
                IF xText <> ''  AND
                    xText <> '?' THEN PUT CONTROL '£' CHR(10)
                        ENTRY(2, xText, CHR(01))
                        CHR(10).
            END.

            IF hQuery:FIRST-OF ( 2 ) THEN 
            DO:
                xText = DYNAMIC-FUNCTION('GETADRESSEANZEIGEBR':U, INPUT ArtLief.Knr,
                    INPUT 0 ) NO-ERROR.
                IF xText <> ''  AND
                    xText <> '?' THEN PUT CONTROL '£' CHR(10)
                        xText
                        CHR(10).
            END.

            FIND KGebinde USE-INDEX KGebinde-k1
                WHERE KGebinde.Firma  = Firma
                AND   KGebinde.Geb_Cd = Artst.KGeb_Cd NO-LOCK NO-ERROR.
            IF AVAILABLE KGebinde THEN KGeb = KGebinde.KBez.
            ELSE                       KGeb = FILL('?', 10).

            PUT CONTROL '£'.
            PUT CONTROL STRING(Artst.Artnr      ,'999999')      '£'
                               Artst.Bez                        '£'
                        STRING(Artst.Jahr       ,'zzzz')        '£'
                               KGeb                             '£'.
            IF AktPreis.Art = 0 THEN PUT CONTROL STRING(AktPreis.Wert,'9.99 Fr').
            IF AktPreis.Art = 1 THEN PUT CONTROL STRING(AktPreis.Wert,'z9.9 %').
            PUT CONTROL '£'
                STRING(AktPreis.Ab_Datum ,'99.99.9999') '£'
                STRING(AktPreis.Bis_Datum,'99.99.9999') .
            PUT CONTROL CHR(10).
        END.
        OUTPUT CLOSE.
        
        hQuery:QUERY-CLOSE().
        DELETE OBJECT hQuery.

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

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

        RUN KOPF ( INPUT excelAppl ) NO-ERROR.

        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 gAAktionen 
PROCEDURE selectPage :
/*------------------------------------------------------------------------------
          Purpose:     Super Override
          Parameters:  
          Notes:       
        ------------------------------------------------------------------------------*/

    DEFINE INPUT PARAMETER piPageNum   AS INTEGER                      NO-UNDO.

    DEFINE VARIABLE FMutFlag AS LOG       NO-UNDO.
    DEFINE VARIABLE MutProg  AS CHARACTER 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 gAAktionen 
PROCEDURE TOOLBAR :
/*------------------------------------------------------------------------------
          Purpose:     
          Parameters:  <none>
          Notes:       
        ------------------------------------------------------------------------------*/

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

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