GeMIS_WEB/GUI/g-preisliste-total.w

&ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
&ANALYZE-RESUME
/* Connected Databases 
          anadat           PROGRESS
*/
&Scoped-define WINDOW-NAME CURRENT-WINDOW
&Scoped-define FRAME-NAME gPreisLief
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gPreisLief 
/*------------------------------------------------------------------------

  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 VAR Firma           AS CHAR INIT '1000'         NO-UNDO.
DEF VAR AdFirma         AS CHAR INIT '1000'         NO-UNDO.
DEF VAR SAktiv          AS LOG                      NO-UNDO.
DEF VAR Suchbe          AS CHAR                     NO-UNDO.

DEF TEMP-TABLE TPreisGrp    FIELD   Preis_Grp       AS INT
                            FIELD   Bez             AS CHAR
                            FIELD   Bru_Net         AS INT
                            FIELD   Preis           AS DEC

                            INDEX TPreisGrp-k1 IS PRIMARY
                                  Preis_Grp.


DEF TEMP-TABLE TArtst   LIKE Artst
    FIELD sWgr      AS CHAR
    FIELD sPgr      AS CHAR
    FIELD sAgr      AS CHAR
    FIELD cSort     AS CHAR
    INDEX tArtst-k1 IS PRIMARY
        sWgr
        sPgr
        sAgr
        cSort
    INDEX tArtst-k2
        Wg_Grp
        Prod_Grp
        Art_Grp
        .

/* _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 designated FRAME-NAME and/or first browse and/or first query */
&Scoped-define FRAME-NAME gPreisLief
&Scoped-define BROWSE-NAME Br_Lieferanten

/* Internal Tables (found by Frame, Query & Browse Queries)             */
&Scoped-define INTERNAL-TABLES Liefst Adresse

/* Definitions for BROWSE Br_Lieferanten                                */
&Scoped-define FIELDS-IN-QUERY-Br_Lieferanten Liefst.Knr Adresse.Anzeig_br 
&Scoped-define ENABLED-FIELDS-IN-QUERY-Br_Lieferanten 
&Scoped-define QUERY-STRING-Br_Lieferanten FOR EACH Liefst NO-LOCK, ~
      EACH Adresse OF Liefst NO-LOCK INDEXED-REPOSITION
&Scoped-define OPEN-QUERY-Br_Lieferanten OPEN QUERY Br_Lieferanten FOR EACH Liefst NO-LOCK, ~
      EACH Adresse OF Liefst NO-LOCK INDEXED-REPOSITION.
&Scoped-define TABLES-IN-QUERY-Br_Lieferanten Liefst Adresse
&Scoped-define FIRST-TABLE-IN-QUERY-Br_Lieferanten Liefst
&Scoped-define SECOND-TABLE-IN-QUERY-Br_Lieferanten Adresse


/* Definitions for DIALOG-BOX gPreisLief                                */

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS RECT-1 T_Alle F_Suchbe Br_Lieferanten ~
T_Zweite T_Artnr R_Sort F_AbDatum Btn_Excel Btn_Cancel 
&Scoped-Define DISPLAYED-OBJECTS T_Alle F_Suchbe T_Zweite T_Artnr R_Sort ~
F_AbDatum 

/* Custom List Definitions                                              */
/* List-1,List-2,List-3,List-4,List-5,List-6                            */
&Scoped-define List-6 T_Alle T_Zweite T_Artnr R_Sort F_AbDatum 

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



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

/* Define a dialog box                                                  */

/* Definitions of the field level widgets                               */
DEFINE BUTTON Btn_Cancel 
     LABEL "&Abbrechen" 
     SIZE 12 BY 1.

DEFINE BUTTON Btn_Excel 
     IMAGE-UP FILE "grafik/results%.ico":U
     LABEL "Excel" 
     SIZE 7 BY 1.81.

DEFINE VARIABLE F_AbDatum AS DATE FORMAT "99.99.9999":U 
     LABEL "Nur Artikel mit Preis ab :" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 16 BY 1 TOOLTIP "wenn keine Eingabe, dann der aktuell gültige Preis"
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_Suchbe AS CHARACTER FORMAT "X(256)":U 
     LABEL "Suchenbegriff" 
     VIEW-AS FILL-IN 
     SIZE 30 BY 1 NO-UNDO.

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

DEFINE RECTANGLE RECT-1
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL   
     SIZE 72 BY 11.67.

DEFINE VARIABLE T_Alle AS LOGICAL INITIAL no 
     LABEL "alle Lieferanten" 
     VIEW-AS TOGGLE-BOX
     SIZE 22 BY 1 NO-UNDO.

DEFINE VARIABLE T_Artnr AS LOGICAL INITIAL no 
     LABEL "Ganze Artikelnummer" 
     VIEW-AS TOGGLE-BOX
     SIZE 67.6 BY 1 NO-UNDO.

DEFINE VARIABLE T_Zweite AS LOGICAL INITIAL no 
     LABEL "Zweite Artikelbezeichnung drucken ?" 
     VIEW-AS TOGGLE-BOX
     SIZE 67.6 BY 1 NO-UNDO.

/* Query definitions                                                    */
&ANALYZE-SUSPEND
DEFINE QUERY Br_Lieferanten FOR 
      Liefst, 
      Adresse SCROLLING.
&ANALYZE-RESUME

/* Browse definitions                                                   */
DEFINE BROWSE Br_Lieferanten
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_Lieferanten gPreisLief _STRUCTURED
  QUERY Br_Lieferanten NO-LOCK DISPLAY
      Liefst.Knr FORMAT "999999":U WIDTH .2
      Adresse.Anzeig_br COLUMN-LABEL "Lieferant" FORMAT "x(75)":U
            WIDTH 63
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
    WITH NO-ROW-MARKERS SEPARATORS SIZE 70 BY 5.24
         BGCOLOR 15 .


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

DEFINE FRAME gPreisLief
     T_Alle AT ROW 1.62 COL 3.8
     F_Suchbe AT ROW 1.62 COL 40.4 COLON-ALIGNED
     Br_Lieferanten AT ROW 3 COL 3
     T_Zweite AT ROW 8.52 COL 5
     T_Artnr AT ROW 9.52 COL 5 WIDGET-ID 2
     R_Sort AT ROW 10.81 COL 5 NO-LABEL
     F_AbDatum AT ROW 12.52 COL 26.4 COLON-ALIGNED
     Btn_Excel AT ROW 14.1 COL 4.2
     Btn_Cancel AT ROW 14.48 COL 58.6
     RECT-1 AT ROW 1.24 COL 2
     SPACE(2.79) SKIP(3.60)
    WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER 
         SIDE-LABELS NO-UNDERLINE THREE-D  SCROLLABLE 
         TITLE "Alle Preise / Lieferant"
         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 gPreisLief 
/* ************************* 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 gPreisLief
   FRAME-NAME                                                           */
/* BROWSE-TAB Br_Lieferanten F_Suchbe gPreisLief */
ASSIGN 
       FRAME gPreisLief:SCROLLABLE       = FALSE
       FRAME gPreisLief:HIDDEN           = TRUE.

ASSIGN 
       Liefst.Knr:VISIBLE IN BROWSE Br_Lieferanten = FALSE.

/* SETTINGS FOR FILL-IN F_AbDatum IN FRAME gPreisLief
   6                                                                    */
/* SETTINGS FOR RADIO-SET R_Sort IN FRAME gPreisLief
   6                                                                    */
/* SETTINGS FOR TOGGLE-BOX T_Alle IN FRAME gPreisLief
   6                                                                    */
/* SETTINGS FOR TOGGLE-BOX T_Artnr IN FRAME gPreisLief
   6                                                                    */
/* SETTINGS FOR TOGGLE-BOX T_Zweite IN FRAME gPreisLief
   6                                                                    */
/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


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

&ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_Lieferanten
/* Query rebuild information for BROWSE Br_Lieferanten
     _TblList          = "AnaDat.Liefst,AnaDat.Adresse OF AnaDat.Liefst"
     _Options          = "NO-LOCK INDEXED-REPOSITION"
     _FldNameList[1]   > AnaDat.Liefst.Knr
"Liefst.Knr" ? ? "integer" ? ? ? ? ? ? no ? no no ".2" no no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[2]   > AnaDat.Adresse.Anzeig_br
"Adresse.Anzeig_br" "Lieferant" ? "character" ? ? ? ? ? ? no ? no no "63" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _Query            is NOT OPENED
*/  /* BROWSE Br_Lieferanten */
&ANALYZE-RESUME

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

 



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

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

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gPreisLief gPreisLief
ON GO OF FRAME gPreisLief /* Alle Preise / Lieferant */
DO:
    IF SAktiv THEN RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ) NO-ERROR.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gPreisLief gPreisLief
ON WINDOW-CLOSE OF FRAME gPreisLief /* Alle Preise / Lieferant */
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 gPreisLief
ON CHOOSE OF Btn_Cancel IN FRAME gPreisLief /* Abbrechen */
DO:
    RUN ENDE.
    RETURN NO-APPLY.
END.

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


&Scoped-define SELF-NAME Btn_Excel
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Excel gPreisLief
ON CHOOSE OF Btn_Excel IN FRAME gPreisLief /* Excel */
DO:
    DO WITH FRAME {&FRAME-NAME}:
        ASSIGN  {&list-6}.
        Btn_Excel:SENSITIVE = FALSE.
        SESSION:SET-WAIT-STATE('GENERAL').
        RUN REPORT.
        SESSION:SET-WAIT-STATE('').
        Btn_Excel:SENSITIVE = TRUE.
    END.
END.

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


&Scoped-define SELF-NAME F_Suchbe
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gPreisLief
ON VALUE-CHANGED OF F_Suchbe IN FRAME gPreisLief /* Suchenbegriff */
DO:
    Suchbe = SELF:SCREEN-VALUE.
    RUN OPENQUERY.
END.

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


&Scoped-define BROWSE-NAME Br_Lieferanten
&UNDEFINE SELF-NAME

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


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

    MaxPage  = 1.
    AktSeite = 1.
    SAktiv   = FALSE.

    SAktiv   = DYNAMIC-FUNCTION('getSuperAktiv':U) NO-ERROR.
    IF SAktiv THEN DO:
        Firma    = DYNAMIC-FUNCTION('GETMANDANT':U)     NO-ERROR.
        AdFirma  = DYNAMIC-FUNCTION('GETADMANDANT':U)   NO-ERROR.
    END.

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

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

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

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

    RUN SUPER.

    IF SAktiv THEN 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 gPreisLief  _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 T_Alle F_Suchbe T_Zweite T_Artnr R_Sort F_AbDatum 
      WITH FRAME gPreisLief.
  ENABLE RECT-1 T_Alle F_Suchbe Br_Lieferanten T_Zweite T_Artnr R_Sort 
         F_AbDatum Btn_Excel Btn_Cancel 
      WITH FRAME gPreisLief.
  VIEW FRAME gPreisLief.
  {&OPEN-BROWSERS-IN-QUERY-gPreisLief}
END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gPreisLief 
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.

    IF SAktiv THEN 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 gPreisLief 
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 gPreisLief 
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 gPreisLief 
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 OPENQUERY gPreisLief 
PROCEDURE OPENQUERY :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    OPEN QUERY {&BROWSE-NAME}
        FOR EACH Liefst USE-INDEX Liefst-k1
                        WHERE Liefst.Firma = Firma
                        AND   Liefst.Aktiv = TRUE       NO-LOCK,
            FIRST Adresse USE-INDEX Adresse-k1
                          WHERE Adresse.Firma = AdFirma
                          AND   Adresse.Knr   = Liefst.Knr
                          AND   Adresse.Aktiv = TRUE
                          AND   Adresse.Suchbe BEGINS Suchbe NO-LOCK

                          BY Adresse.Anzeig_br.

END PROCEDURE.

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

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

    DEF VAR excelAppl   AS COM-HANDLE               NO-UNDO.
    DEF VAR DateiName   AS CHAR                     NO-UNDO.
    DEF VAR DatenName   AS CHAR                     NO-UNDO.
    DEF VAR Ja          AS LOG                      NO-UNDO.
    DEF VAR KGeb        AS CHAR                     NO-UNDO.
    DEF VAR Zelle       AS CHAR                     NO-UNDO.
    DEF VAR ii          AS INT                      NO-UNDO.
    DEF VAR xText       AS CHAR                     NO-UNDO.
    DEF VAR AbDatum     AS DATE                     NO-UNDO.
    DEF VAR cWgr        AS CHAR                     NO-UNDO.
    DEF VAR cPgr        AS CHAR                     NO-UNDO.
    DEF VAR cAgr        AS CHAR                     NO-UNDO.

    IF F_AbDatum <> ? THEN AbDatum = F_AbDatum.
    ELSE                   AbDatum = TODAY.

    IF NOT AVAILABLE Liefst     THEN RETURN.
    IF NOT AVAILABLE Adresse    THEN RETURN.

DO WITH FRAME {&FRAME-NAME}:
    DatenName = 'PreislisteTotal.txt'.
    DateiName = 'PreislisteTotal.xls' + CHR(01) + 'PreislisteTotal.xls'.
    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 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.

    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.

    FOR EACH TPreisGrp:
        DELETE  TPreisGrp.
    END.
    FOR EACH Tabel USE-INDEX Tabel-k1
                   WHERE Tabel.Firma  = Firma
                   AND   Tabel.RecArt = 'PREGRP' NO-LOCK:
        CREATE  TPreisGrp.
        ASSIGN  TPreisGrp.Preis_Grp = Tabel.CodeI
                TPreisGrp.Bez       = Tabel.Bez1
                TPreisGrp.Bru_Net   = Tabel.Int_1.
    END.

    OUTPUT TO VALUE(DatenName) APPEND.
    IF T_Alle THEN DO:
        PUT CONTROL '£Alle Lieferanten'
                    CHR(10).
    END.
    ELSE DO:
        PUT CONTROL '£'
                    STRING(Adresse.Knr,"999999  ")
                    Adresse.Anzeig_Br
                    CHR(10).
    END.
    PUT CONTROL '£Artnr£Bezeichnung£Gebinde£Jahr£Listen EP'.
    FOR EACH TPreisGrp NO-LOCK:
        PUT CONTROL '£' TPreisGrp.Bez.
    END.
    PUT CONTROL CHR(10)
                '£' CHR(10).

    EMPTY TEMP-TABLE tArtst.
    IF T_Alle THEN DO:
        FOR EACH Artst USE-INDEX Artst-k1
                       WHERE  Artst.Firma   = Firma
                       AND    Artst.Aktiv   = TRUE
                       AND    Artst.Ausverk < 9 NO-LOCK:
            CREATE  tArtst.
            BUFFER-COPY Artst TO tArtst.
            tArtst.cSort = (IF R_Sort = 1 THEN STRING(Artst.Artnr,'999999') ELSE Artst.Bez).
        END.
    END.
    ELSE DO:
        FOR EACH ArtLief USE-INDEX ArtLief-k2
                         WHERE ArtLief.Firma  = Liefst.Firma
                         AND   ArtLief.Knr    = Liefst.Knr   NO-LOCK,
            FIRST Artst  USE-INDEX Artst-k1
                         WHERE  Artst.Firma   = ArtLief.Firma
                         AND    Artst.Artnr   = ArtLief.Artnr
                         AND    Artst.Inhalt  = ArtLief.Inhalt
                         AND    Artst.Jahr    = ArtLief.Jahr
                         AND    Artst.Aktiv   = TRUE
                         AND    Artst.Ausverk < 9   NO-LOCK:
            CREATE  tArtst.
            BUFFER-COPY Artst TO tArtst.
            tArtst.cSort = (IF R_Sort = 1 THEN STRING(Artst.Artnr,'999999') ELSE Artst.Bez).
        END.
    END.
    
    FOR EACH tArtst USE-INDEX tArtst-k2
            BREAK BY tArtst.Wg_Grp
                  BY tArtst.Prod_Grp
                  BY tArtst.Art_Grp:
        IF FIRST-OF (tArtst.Art_Grp) THEN DO:
            FIND ArtikGrp NO-LOCK
                    WHERE ArtikGrp.Firma    = tArtst.Firma
                    AND   ArtikGrp.Wgr      = tArtst.Wg_Grp
                    AND   ArtikGrp.Prod_Grp = tArtst.Prod_Grp
                    AND   ArtikGrp.Art_Grp  = tArtst.Art_Grp NO-ERROR.
            IF NOT AVAILABLE ArtikGrp THEN cAgr = '000'.
            ELSE                           cAgr = (IF ArtikGrp.Sort_Preisliste = '' THEN STRING(ArtikGrp.Art_Grp,'999')
                                                                                    ELSE ArtikGrp.Sort_Preisliste).
        END.
        
        IF FIRST-OF (tArtst.Prod_Grp) THEN DO:
            FIND ProdGrp NO-LOCK
                    WHERE ProdGrp.Firma    = tArtst.Firma
                    AND   ProdGrp.Wgr      = tArtst.Wg_Grp
                    AND   ProdGrp.Prod_Grp = tArtst.Prod_Grp NO-ERROR.
            IF NOT AVAILABLE ProdGrp THEN cPgr = '000'.
            ELSE                          cPgr = (IF ProdGrp.Sort_Preisliste = '' THEN STRING(ProdGrp.Prod_Grp,'999')
                                                                                  ELSE ProdGrp.Sort_Preisliste).
        END.
        
        IF FIRST-OF (tArtst.Wg_Grp) THEN DO:
            FIND WarenGrp NO-LOCK
                    WHERE WarenGrp.Firma    = tArtst.Firma
                    AND   WarenGrp.Wgr      = tArtst.Wg_Grp NO-ERROR.
            IF NOT AVAILABLE WarenGrp THEN cWgr = '000'.
            ELSE                           cWgr = (IF WarenGrp.Sort_Preisliste = '' THEN STRING(WarenGrp.Wgr,'999')
                                                                                    ELSE WarenGrp.Sort_Preisliste).
        END.
        ASSIGN  tArtst.sWgr = cWgr
                tArtst.sPgr = cPgr
                tArtst.sAgr = cAgr.
    END.
    
    FOR EACH tArtst  USE-INDEX tArtst-k1 NO-LOCK,
        FIRST Artbez USE-INDEX Artbez-k1
                     WHERE  Artbez.Firma  = tArtst.Firma
                     AND    Artbez.Artnr  = tArtst.Artnr
                     AND    Artbez.Inhalt = tArtst.Inhalt
                     AND    Artbez.Jahr   = tArtst.Jahr NO-LOCK

                     BREAK BY tArtst.sWgr
                           BY tArtst.sPgr
                           BY tArtst.sAgr
                           BY tArtst.cSort :

        IF FIRST-OF (tArtst.sWgr) THEN DO:
            RUN FIND_WARENGRP ( INPUT tArtst.Wg_Grp, OUTPUT xText ).
            IF xText = '?'   THEN xText = 'unbekannt ... '.
            ELSE                  xText = ENTRY(2, xText, CHR(01)).
            IF xText = '-0-' THEN xText = ''.
            IF xText <> '' THEN PUT CONTROL ' ' xText  CHR(10).
        END.
        IF FIRST-OF (tArtst.sPgr) THEN DO:
            RUN FIND_PRODGRP  ( INPUT tArtst.Wg_Grp,
                                INPUT tArtst.Prod_Grp, OUTPUT xText ).
            IF xText = '?'   THEN xText = 'unbekannt ... '.
            ELSE                  xText = ENTRY(2, xText, CHR(01)).
            IF xText = '-0-' THEN xText = ''.
            IF xText <> '' THEN PUT CONTROL ' ' xText  CHR(10).
        END.
        IF FIRST-OF (tArtst.sAgr) THEN DO:
            RUN FIND_ARTIKGRP ( INPUT tArtst.Wg_Grp,
                                INPUT tArtst.Prod_Grp,
                                INPUT tArtst.Art_Grp, OUTPUT xText ).
            IF xText = '?'   THEN xText = 'unbekannt ... '.
            ELSE                  xText = ENTRY(2, xText, CHR(01)).
            IF xText = '-0-' THEN xText = ''.
            IF xText <> '' THEN PUT CONTROL ' ' xText  CHR(10).
        END.
    
        FIND KGebinde USE-INDEX KGebinde-k1
                      WHERE KGebinde.Firma  = Firma
                      AND   KGebinde.Geb_Cd = tArtst.KGeb_Cd NO-LOCK NO-ERROR.
        IF AVAILABLE KGebinde THEN KGeb = KGebinde.KBez.
        ELSE                       KGeb = FILL('?', 10).

        FOR EACH TPreisGrp:
            TPreisGrp.Preis = 0.
            IF F_AbDatum = ? THEN DO:
                FIND LAST ArtPreis USE-INDEX ArtPreis-k1
                                   WHERE Artpreis.Firma     = tArtst.Firma
                                   AND   ArtPreis.Artnr     = tArtst.Artnr
                                   AND   ArtPreis.Inhalt    = tArtst.Inhalt
                                   AND   ArtPreis.Jahr      = tArtst.Jahr
                                   AND   ArtPreis.Preis_Grp = TPreisGrp.Preis_Grp
                                   AND   ArtPreis.Aktion    = FALSE
                                   AND   ArtPreis.Ab_Datum <= AbDatum NO-LOCK NO-ERROR.
                IF NOT AVAILABLE ArtPreis THEN NEXT.
                IF TPreisGrp.Bru_Net = 0 THEN TPreisGrp.Preis = ArtPreis.VK_Netto.
                ELSE                          TPreisGrp.Preis = ArtPreis.VK_Brutto.
            END.
            ELSE DO:
                FIND FIRST ArtPreis USE-INDEX ArtPreis-k1
                                    WHERE Artpreis.Firma     = tArtst.Firma
                                    AND   ArtPreis.Artnr     = tArtst.Artnr
                                    AND   ArtPreis.Inhalt    = tArtst.Inhalt
                                    AND   ArtPreis.Jahr      = tArtst.Jahr
                                    AND   ArtPreis.Preis_Grp = TPreisGrp.Preis_Grp
                                    AND   ArtPreis.Aktion    = FALSE
                                    AND   ArtPreis.Ab_Datum >= AbDatum NO-LOCK NO-ERROR.
                IF NOT AVAILABLE ArtPreis THEN NEXT.
                IF TPreisGrp.Bru_Net = 0 THEN TPreisGrp.Preis = ArtPreis.VK_Netto.
                ELSE                          TPreisGrp.Preis = ArtPreis.VK_Brutto.
            END.
        END.

        PUT CONTROL '£'
                    STRING(tArtst.Artnr,"999999")           "£"
                    Artbez.Bez1                             "£"
                    KGeb                                    "£"
                    STRING(tArtst.Jahr ,"zzzz")             "£"
                    STRING(tArtst.Listen_EP,"zzzz9.999").
        FOR EACH TPreisGrp:
            PUT CONTROL '£'.
            IF TPreisGrp.Preis <> 0
            THEN PUT CONTROL STRING(TPreisGrp.Preis,"zzzz9.999").
        END.
        IF T_Artnr THEN DO:
            PUT CONTROL '£' STRING(tArtst.Inhalt,'9999')
                        '£' STRING(tArtst.Jahr  ,'9999').
        END.
        PUT CONTROL CHR(10).
        IF T_Zweite THEN DO:
            IF Artbez.Bez2 <> '' THEN DO:
                PUT CONTROL '£'
                            "£"
                            Artbez.Bez2                             "£"
                            CHR(10).
            END.
        END.
        IF LAST-OF ( tArtst.sAgr ) THEN PUT CONTROL '£' CHR(10).
    END.
    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' ).

    ii = 70.
    Zelle = CHR(ii) + ':' + CHR(ii).
    excelAppl:Range(Zelle):Select.
    excelAppl:Selection:ColumnWidth = 9.

    FOR EACH TPreisGrp:
        ii = ii + 1.
        Zelle = CHR(ii) + ':' + CHR(ii).
        excelAppl:Range(Zelle):Select.
        excelAppl:Selection:NumberFormat = "#,##0.000".
        excelAppl:Selection:Columns:AutoFit.
    END.
    Zelle = 'A1'.
    excelAppl:Range(Zelle):SELECT.
    excelAppl:Selection:ColumnWidth = 0.2.

    DYNAMIC-FUNCTION('RELEASEEXCEL':U, INPUT excelAppl ) NO-ERROR.

END.

    
END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE selectPage gPreisLief 
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 gPreisLief 
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

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

    RUN SUPER.

    RUN OPENQUERY.

END PROCEDURE.

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