GeMIS_WEB/GUI/g-kundenbewegungen.w

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

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

DEF INPUT PARAMETER ipKnr   AS INT                  NO-UNDO.

/* 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 VAR Firma           AS CHAR                     NO-UNDO.
DEF VAR AdFirma         AS CHAR                     NO-UNDO.

DEF STREAM Out_Stream.
DEF STREAM Inp_Stream.

DEF TEMP-TABLE TExcel   FIELD Zeile     AS INT
                        FIELD KeyWort   AS CHAR
                        FIELD Feld      AS CHAR EXTENT 15.

DEF TEMP-TABLE TArtbw   LIKE Artbw
                        FIELD cSort AS CHAR
                        INDEX TArtbw-k1 IS PRIMARY
                              cSort.

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

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

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

/* _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 AUTO-GO 
     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_Kunde AS CHARACTER FORMAT "X(256)":U 
     LABEL "Kunde/Lieferant" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 48 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_Aktionen AS INTEGER 
     VIEW-AS RADIO-SET VERTICAL
     RADIO-BUTTONS 
          "alle Bewegungen", 1,
"keine Aktionen", 2,
"nur Aktionen", 3
     SIZE 35 BY 2 NO-UNDO.

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

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


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

DEFINE FRAME gKundenbeweg
     F_Kunde AT ROW 2 COL 18 COLON-ALIGNED NO-TAB-STOP 
     F_VonDatum AT ROW 3 COL 18 COLON-ALIGNED
     F_BisDatum AT ROW 3 COL 37 COLON-ALIGNED
     R_Aktionen AT ROW 4.33 COL 20 NO-LABEL
     R_Sort AT ROW 6.71 COL 20 NO-LABEL
     Btn_OK AT ROW 9.1 COL 21
     Btn_Cancel AT ROW 9.1 COL 39.8
     RECT-3 AT ROW 1.24 COL 2
     SPACE(0.99) SKIP(0.22)
    WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER 
         SIDE-LABELS NO-UNDERLINE THREE-D  SCROLLABLE 
         TITLE "Kde.-/Lieferanten-Bewegungen"
         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 gKundenbeweg 
/* ************************* 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 gKundenbeweg
   Custom                                                               */
ASSIGN 
       FRAME gKundenbeweg:SCROLLABLE       = FALSE
       FRAME gKundenbeweg:HIDDEN           = TRUE.

/* SETTINGS FOR FILL-IN F_BisDatum IN FRAME gKundenbeweg
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Kunde IN FRAME gKundenbeweg
   6                                                                    */
ASSIGN 
       F_Kunde:READ-ONLY IN FRAME gKundenbeweg        = TRUE.

/* SETTINGS FOR FILL-IN F_VonDatum IN FRAME gKundenbeweg
   6                                                                    */
/* SETTINGS FOR RADIO-SET R_Aktionen IN FRAME gKundenbeweg
   6                                                                    */
/* SETTINGS FOR RADIO-SET R_Sort IN FRAME gKundenbeweg
   6                                                                    */
/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


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

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

 



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

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

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


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

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gKundenbeweg gKundenbeweg
ON WINDOW-CLOSE OF FRAME gKundenbeweg /* Kde.-/Lieferanten-Bewegungen */
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 gKundenbeweg
ON CHOOSE OF Btn_Cancel IN FRAME gKundenbeweg /* 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 gKundenbeweg
ON CHOOSE OF Btn_OK IN FRAME gKundenbeweg /* Start */
DO:
    DISABLE Btn_OK
            Btn_Cancel WITH FRAME {&FRAME-NAME}.
    SESSION:SET-WAIT-STATE('GENERAL').
    RUN REPORT.
    SESSION:SET-WAIT-STATE('').
    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_Aktionen
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL R_Aktionen gKundenbeweg
ON RETURN OF R_Aktionen IN FRAME gKundenbeweg
DO:
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

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


&Scoped-define SELF-NAME R_Sort
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL R_Sort gKundenbeweg
ON RETURN OF R_Sort IN FRAME gKundenbeweg
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 gKundenbeweg 


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

    MaxPage  = 1.
    AktSeite = 1.

    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 gKundenbeweg  _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 gKundenbeweg 
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 gKundenbeweg  _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 gKundenbeweg.
END PROCEDURE.

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

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

    Firma     = DYNAMIC-FUNCTION('GETMANDANT':U)   NO-ERROR.
    AdFirma   = DYNAMIC-FUNCTION('GETADMANDANT':U) NO-ERROR.

    FIND Adresse USE-INDEX Adresse-k1
                 WHERE Adresse.Firma = AdFirma
                 AND   Adresse.Knr   = ipKnr NO-LOCK NO-ERROR.
    IF NOT AVAILABLE Adresse THEN F_Kunde = '??????????'.
    ELSE                          F_Kunde = Adresse.Anzeig_Br.

    FIND FIRST Artbw USE-INDEX Artbw-k3
                     WHERE Artbw.Firma = Firma
                     AND   Artbw.Knr   = ipKnr NO-LOCK NO-ERROR.
    IF AVAILABLE Artbw THEN F_VonDatum = Artbw.Datum.
    FIND LAST  Artbw USE-INDEX Artbw-k3
                     WHERE Artbw.Firma = Firma
                     AND   Artbw.Knr   = ipKnr NO-LOCK NO-ERROR.
    IF AVAILABLE Artbw THEN F_BisDatum = Artbw.Datum.

    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 gKundenbeweg  _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_Kunde F_VonDatum F_BisDatum R_Aktionen R_Sort 
      WITH FRAME gKundenbeweg.
  ENABLE F_Kunde F_VonDatum F_BisDatum R_Aktionen R_Sort Btn_OK Btn_Cancel 
         RECT-3 
      WITH FRAME gKundenbeweg.
  VIEW FRAME gKundenbeweg.
  {&OPEN-BROWSERS-IN-QUERY-gKundenbeweg}
END PROCEDURE.

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

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

    DEF INPUT PARAMETER eh  AS COM-HANDLE       NO-UNDO.

    DEF VAR Zelle   AS CHAR                     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 = 'F1'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = 'Kde.-/Lieferanten-Bewegungen'.
    Zelle = 'K1'.
    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 = 'F2'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = STRING(F_VonDatum,'99.99.9999')
                       + ' - '
                       + STRING(F_BisDatum,'99.99.9999').
    Zelle = 'K2'.
    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 REPORT gKundenbeweg 
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 xText       AS CHAR                     NO-UNDO.
    DEF VAR Ja          AS LOG                      NO-UNDO.
    DEF VAR KGeb        AS CHAR                     NO-UNDO.
    DEF VAR VGeb        AS CHAR                     NO-UNDO.
    DEF VAR GGeb        AS CHAR                     NO-UNDO.
    DEF VAR Netto       AS DEC  DECIMALS 4          NO-UNDO.
    DEF VAR Rabatt      AS DEC  DECIMALS 4          NO-UNDO.
    DEF VAR i           AS INT                      NO-UNDO.

    DatenName = 'KdeBewegungen.txt'.
    DateiName = 'KdeBewegungen.xls' + CHR(01) + 'KdeBewegungen.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.

    EMPTY TEMP-TABLE TArtbw.
    FOR EACH Artbw USE-INDEX Artbw-k3
                   WHERE Artbw.Firma  = Firma
                   AND   Artbw.Knr    = ipKnr
                   AND   Artbw.Datum >= F_VonDatum
                   AND   Artbw.Datum <= F_BisDatum NO-LOCK:
        IF R_Aktionen = 2       AND
           Artbw.Aktion = TRUE  THEN NEXT.
        IF R_Aktionen = 3       AND
           Artbw.Aktion = FALSE THEN NEXT.
        CREATE  TArtbw.
        BUFFER-COPY Artbw TO TArtbw.
        CASE R_Sort:
            WHEN 1 THEN DO:
                cSort = STRING(Artbw.Artnr       ,'999999')
                      + STRING(Artbw.Inhalt      ,'9999')
                      + STRING(Artbw.Jahr        ,'9999')
                      + STRING(YEAR (Artbw.Datum),'9999')
                      + STRING(MONTH(Artbw.Datum),'99')
                      + STRING(DAY  (Artbw.Datum),'99').
            END.
            WHEN 2 THEN DO:
                cSort = STRING(YEAR (Artbw.Datum),'9999')
                      + STRING(MONTH(Artbw.Datum),'99')
                      + STRING(DAY  (Artbw.Datum),'99')
                      + STRING(Artbw.Artnr       ,'999999')
                      + STRING(Artbw.Inhalt      ,'9999')
                      + STRING(Artbw.Jahr        ,'9999').
            END.
            WHEN 3 THEN DO:
                cSort = STRING(Artbw.Bez1        ,'x(20)')
                      + STRING(YEAR (Artbw.Datum),'9999')
                      + STRING(MONTH(Artbw.Datum),'99')
                      + STRING(DAY  (Artbw.Datum),'99').
            END.
        END CASE.
    END.

    FIND FIRST TArtbw NO-LOCK NO-ERROR.
    IF NOT AVAILABLE TArtbw THEN DO:
        DYNAMIC-FUNCTION('RELEASEEXCEL':U, INPUT excelAppl ) NO-ERROR.
        RETURN.
    END.

    OUTPUT TO VALUE(DatenName) APPEND.

    PUT CONTROL '£Artnr£Bezeichnung£Jahr£KGebinde£'
                'Datum£Menge£Preis£Netto£Rabatt£Akt'            CHR(10)
                                                                CHR(10)
                STRING(ipKnr,'999999  ')
                F_Kunde                                         CHR(10)
                '£'                                             CHR(10).

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

        Netto  = TArtbw.Net_Betr - TArtbw.Auf_Rab
                                 - TArtbw.Abh_Rab
                                 - TArtbw.Auf_Sp_Rab.
        Rabatt = (TArtbw.Menge * TArtbw.Preis) - Netto.

        IF TArtbw.Aktion    AND
           R_Aktionen = 1   THEN PUT CONTROL 'Aktion'.
        PUT CONTROL '£'.
        PUT CONTROL STRING(TArtbw.Artnr     ,'999999')          '£'
                           TArtbw.Bez1                          '£'
                    TRIM(STRING(TArtbw.Jahr ,'zzzz'))           '£'
                           KGeb                                 '£'
                    STRING(TArtbw.Datum,'99.99.9999')           '£'
                    TRIM(STRING(TArtbw.Menge,'->>>,>>>,>>9'))   '£'
                    TRIM(STRING(TArtbw.Preis,'->>>,>>9.999'))   '£'
                    TRIM(STRING(Netto       ,'->,>>>,>>9.999')) '£'
                    TRIM(STRING(Rabatt      ,'->,>>>,>>9.999')) '£'
                    STRING(TArtbw.Aktion,'J/N')                 CHR(10).
    END.
    OUTPUT CLOSE.

    EMPTY TEMP-TABLE TExcel.
    i = 2.
    INPUT  STREAM INP_Stream  FROM Value(DatenName) NO-ECHO NO-MAP.
    REPEAT TRANSACTION ON STOP UNDO, LEAVE WITH FRAME f_Print:
        i = i + 1.
        CREATE TExcel.
        IMPORT STREAM INP_Stream DELIMITER '£' TExcel.KeyWort
                                               TExcel.Feld .
        TExcel.Zeile = i.
    END.
    INPUT  STREAM INP_Stream CLOSE.

    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.

    FOR EACH TExcel WHERE TExcel.KeyWort <> '' BY TExcel.Zeile:
        CASE TExcel.KeyWort:
            WHEN 'Aktion' THEN DO:
                Zelle = 'A'  + STRING(TExcel.Zeile).
                excelAppl:Range(Zelle):SELECT.
                excelAppl:Selection:VALUE = ''.
                Zelle = 'B'  + STRING(TExcel.Zeile)
                      + ':K' + STRING(TExcel.Zeile).
                excelAppl:Range(Zelle):SELECT.
                excelAppl:Application:RUN ( TExcel.KeyWort ).
            END.
        END CASE.
    END.
    
    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 gKundenbeweg 
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