GeMIS_WEB/GUI/g-liefart.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 gArtLie
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gArtLie 
/*------------------------------------------------------------------------

  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 iDaten      AS CHAR             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 geloeschte      AS LOG  INIT FALSE          NO-UNDO.

DEF VAR Knr             AS INT                      NO-UNDO.
DEF VAR Lieferant       AS CHAR                     NO-UNDO.

DEF VAR Ums_Vorj        AS INT  FORMAT "zzz,zzz,zz9-"   NO-UNDO.
DEF VAR Ums_Lauf        AS INT  FORMAT "zzz,zzz,zz9-"   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 designated FRAME-NAME and/or first browse and/or first query */
&Scoped-define FRAME-NAME gArtLie
&Scoped-define BROWSE-NAME Br_LiefArt

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

/* Definitions for BROWSE Br_LiefArt                                    */
&Scoped-define FIELDS-IN-QUERY-Br_LiefArt ArtLief.Artnr ArtLief.Inhalt ~
ArtLief.Jahr Artst.Bez Artst.Bestand Artst.Bestellt Artst.Mind_Bestand ~
ArtLief.S_Preis_FRW Artst.Listen_EP ~
DYNAMIC-FUNCTION('GETUMSATZ':U, YEAR(TODAY) - 1) @ Ums_Vorj ~
DYNAMIC-FUNCTION('GETUMSATZ':U, YEAR(TODAY) ) @ Ums_Lauf 
&Scoped-define ENABLED-FIELDS-IN-QUERY-Br_LiefArt 
&Scoped-define QUERY-STRING-Br_LiefArt FOR EACH ArtLief NO-LOCK, ~
      EACH Artst OF ArtLief NO-LOCK INDEXED-REPOSITION
&Scoped-define OPEN-QUERY-Br_LiefArt OPEN QUERY Br_LiefArt FOR EACH ArtLief NO-LOCK, ~
      EACH Artst OF ArtLief NO-LOCK INDEXED-REPOSITION.
&Scoped-define TABLES-IN-QUERY-Br_LiefArt ArtLief Artst
&Scoped-define FIRST-TABLE-IN-QUERY-Br_LiefArt ArtLief
&Scoped-define SECOND-TABLE-IN-QUERY-Br_LiefArt Artst


/* Definitions for DIALOG-BOX gArtLie                                   */

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS RECT-1 RECT-2 Br_LiefArt Btn_Excel 

/* Custom List Definitions                                              */
/* List-1,List-2,List-3,List-4,List-5,List-6                            */

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


/* ************************  Function Prototypes ********************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD GETUMSATZ gArtLie 
FUNCTION GETUMSATZ RETURNS DECIMAL
  ( Jahr AS INT )  FORWARD.

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


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

/* Define a dialog box                                                  */

/* Menu Definitions                                                     */
DEFINE MENU POPUP-MENU-Br_LiefArt 
       MENU-ITEM m_inaktive_einaus LABEL "inaktive ein/aus".


/* Definitions of the field level widgets                               */
DEFINE BUTTON Btn_Excel 
     IMAGE-UP FILE "grafik/results%.ico":U
     LABEL "Excel" 
     SIZE 7 BY 1.67.

DEFINE RECTANGLE RECT-1
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL   
     SIZE 152 BY 14.05.

DEFINE RECTANGLE RECT-2
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL   
     SIZE 131 BY 2.14.

/* Query definitions                                                    */
&ANALYZE-SUSPEND
DEFINE QUERY Br_LiefArt FOR 
      ArtLief, 
      Artst SCROLLING.
&ANALYZE-RESUME

/* Browse definitions                                                   */
DEFINE BROWSE Br_LiefArt
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_LiefArt gArtLie _STRUCTURED
  QUERY Br_LiefArt NO-LOCK DISPLAY
      ArtLief.Artnr FORMAT "999999":U
      ArtLief.Inhalt FORMAT "9999":U
      ArtLief.Jahr FORMAT "9999":U
      Artst.Bez COLUMN-LABEL "Artikel" FORMAT "x(32)":U
      Artst.Bestand FORMAT "zz,zzz,zz9-":U
      Artst.Bestellt FORMAT "zz,zzz,zz9-":U
      Artst.Mind_Bestand COLUMN-LABEL "Mind. Best" FORMAT "zz,zzz,zz9-":U
            WIDTH 11
      ArtLief.S_Preis_FRW COLUMN-LABEL "Sein Preis" FORMAT "zzz,zz9.9999":U
      Artst.Listen_EP COLUMN-LABEL "Listen EP" FORMAT "z,zz9.999":U
            WIDTH 11
      DYNAMIC-FUNCTION('GETUMSATZ':U, YEAR(TODAY) - 1) @ Ums_Vorj COLUMN-LABEL "Ums Vorjahr" FORMAT "zzz,zzz,zz9-":U
            WIDTH 13
      DYNAMIC-FUNCTION('GETUMSATZ':U, YEAR(TODAY) ) @ Ums_Lauf COLUMN-LABEL "Ums Laufend" FORMAT "zzz,zzz,zz9-":U
            WIDTH 16
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
    WITH NO-ROW-MARKERS SEPARATORS SIZE 150 BY 13.57
         BGCOLOR 15  TOOLTIP "rechte Maustaste gelöschte ein und ausschalten".


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

DEFINE FRAME gArtLie
     Br_LiefArt AT ROW 1.48 COL 3
     Btn_Excel AT ROW 15.76 COL 123
     RECT-1 AT ROW 1.24 COL 2
     RECT-2 AT ROW 15.52 COL 2
     SPACE(24.79) SKIP(0.66)
    WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER 
         SIDE-LABELS NO-UNDERLINE THREE-D  SCROLLABLE 
         TITLE "Artikel von ->".


/* *********************** 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 gArtLie 
/* ************************* 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 gArtLie
   FRAME-NAME                                                           */
/* BROWSE-TAB Br_LiefArt RECT-2 gArtLie */
ASSIGN 
       FRAME gArtLie:SCROLLABLE       = FALSE
       FRAME gArtLie:HIDDEN           = TRUE.

ASSIGN 
       Br_LiefArt:POPUP-MENU IN FRAME gArtLie             = MENU POPUP-MENU-Br_LiefArt:HANDLE.

/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


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

&ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_LiefArt
/* Query rebuild information for BROWSE Br_LiefArt
     _TblList          = "AnaDat.ArtLief,AnaDat.Artst OF AnaDat.ArtLief"
     _Options          = "NO-LOCK INDEXED-REPOSITION"
     _FldNameList[1]   = AnaDat.ArtLief.Artnr
     _FldNameList[2]   = AnaDat.ArtLief.Inhalt
     _FldNameList[3]   = AnaDat.ArtLief.Jahr
     _FldNameList[4]   > AnaDat.Artst.Bez
"Artst.Bez" "Artikel" "x(32)" "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[5]   > AnaDat.Artst.Bestand
"Artst.Bestand" ? "zz,zzz,zz9-" "integer" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[6]   > AnaDat.Artst.Bestellt
"Artst.Bestellt" ? "zz,zzz,zz9-" "integer" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[7]   > AnaDat.Artst.Mind_Bestand
"Artst.Mind_Bestand" "Mind. Best" "zz,zzz,zz9-" "integer" ? ? ? ? ? ? no ? no no "11" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[8]   > AnaDat.ArtLief.S_Preis_FRW
"ArtLief.S_Preis_FRW" "Sein Preis" "zzz,zz9.9999" "decimal" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[9]   > AnaDat.Artst.Listen_EP
"Artst.Listen_EP" "Listen EP" ? "decimal" ? ? ? ? ? ? no ? no no "11" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[10]   > "_<CALC>"
"DYNAMIC-FUNCTION('GETUMSATZ':U, YEAR(TODAY) - 1) @ Ums_Vorj" "Ums Vorjahr" "zzz,zzz,zz9-" ? ? ? ? ? ? ? no ? no no "13" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[11]   > "_<CALC>"
"DYNAMIC-FUNCTION('GETUMSATZ':U, YEAR(TODAY) ) @ Ums_Lauf" "Ums Laufend" "zzz,zzz,zz9-" ? ? ? ? ? ? ? no ? no no "16" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _Query            is NOT OPENED
*/  /* BROWSE Br_LiefArt */
&ANALYZE-RESUME

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

 



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

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

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


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

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


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

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


&Scoped-define BROWSE-NAME Br_LiefArt
&Scoped-define SELF-NAME Br_LiefArt
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_LiefArt gArtLie
ON ENTRY OF Br_LiefArt IN FRAME gArtLie
DO:
    APPLY 'VALUE-CHANGED' TO BROWSE {&BROWSE-NAME}.
    RETURN NO-APPLY.  
END.

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



&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_LiefArt gArtLie
ON ROW-DISPLAY OF Br_LiefArt IN FRAME gArtLie
DO:
    DEF VAR Farbe   AS INT                      NO-UNDO.

    IF Artst.Aktiv THEN Farbe = 15.
    ELSE                Farbe = 12.

    ArtLief.Artnr      :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
    ArtLief.Inhalt     :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
    ArtLief.Jahr       :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
    Artst.Bez          :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
    Artst.Bestand      :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
    Artst.Bestellt     :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
    Artst.Mind_Bestand   :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
    ArtLief.S_Preis_FRW:BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
    Artst.Listen_Ep    :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
    Ums_Vorj           :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
    Ums_Lauf           :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_LiefArt gArtLie
ON VALUE-CHANGED OF Br_LiefArt IN FRAME gArtLie
DO:
        PUBLISH 'BESTELLVORSCHLAG' ( Artst.Artnr, Artst.Inhalt, Artst.Jahr ).
        APPLY 'ENTRY' TO SELF.
        RETURN NO-APPLY.
END.

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


&Scoped-define SELF-NAME Btn_Excel
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Excel gArtLie
ON CHOOSE OF Btn_Excel IN FRAME gArtLie /* Excel */
DO:
    DISABLE Btn_Excel WITH FRAME {&FRAME-NAME}.
    RUN REPORT.
    ENABLE  Btn_Excel WITH FRAME {&FRAME-NAME}.
END.

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


&Scoped-define SELF-NAME m_inaktive_einaus
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL m_inaktive_einaus gArtLie
ON CHOOSE OF MENU-ITEM m_inaktive_einaus /* inaktive ein/aus */
DO:
    geloeschte = (IF geloeschte THEN FALSE ELSE TRUE).
    RUN OPENQUERY.
END.

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


&UNDEFINE SELF-NAME

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


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

    MaxPage  = 1.
    AktSeite = 1.

    Knr       = INTEGER(ENTRY(1, iDaten, CHR(01))).
    Lieferant =         ENTRY(2, iDaten, CHR(01)).

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

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

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

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

    RUN SUPER.

    FRAME {&FRAME-NAME}:TITLE = FRAME {&FRAME-NAME}:TITLE + ' ' + Lieferant.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gArtLie  _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.
------------------------------------------------------------------------------*/
  ENABLE RECT-1 RECT-2 Br_LiefArt Btn_Excel 
      WITH FRAME gArtLie.
  VIEW FRAME gArtLie.
  {&OPEN-BROWSERS-IN-QUERY-gArtLie}
END PROCEDURE.

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

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

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

    APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.

    RETURN NO-APPLY.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE exitObject gArtLie 
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 gArtLie 
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 = 'Links1'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = Steuer.Firma1.
    Zelle = 'Mitte1'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = 'Artikel des Lieferanten'.
    Zelle = 'Rechts1'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = 'Datum : ' + STRING(TODAY,'99.99.9999').

    Zelle = 'Links2'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = Steuer.Ort.
    Zelle = 'Mitte2'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = ''.
    Zelle = 'Rechts2'.
    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 gArtLie 
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 gArtLie 
PROCEDURE OPENQUERY :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

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

    CASE geloeschte:
        WHEN FALSE THEN DO:
            OPEN QUERY {&BROWSE-NAME}
                FOR EACH ArtLief USE-INDEX ArtLief-k2
                                 WHERE Artlief.Firma = Firma
                                 AND   ArtLief.Knr   = Knr  NO-LOCK,
                    FIRST Artst OF ArtLief NO-LOCK.
        END.
        OTHERWISE DO:
            OPEN QUERY {&BROWSE-NAME}
                FOR EACH ArtLief USE-INDEX ArtLief-k2
                                 WHERE Artlief.Firma = Firma
                                 AND   ArtLief.Knr   = Knr  NO-LOCK,
                    FIRST Artst OF ArtLief NO-LOCK
                        WHERE Artst.Aktiv = TRUE.
        END.
    END CASE.

END PROCEDURE.

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

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

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

DO WITH FRAME {&FRAME-NAME}:
    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 '£'
                Lieferant                                       CHR(10).
    PUT CONTROL '£Artnr£Bezeichnung£Gebinde£Jahr£Bestand£'
                'Bestellt£Mindest£Listen£Umsatz£Umsatz'         CHR(10).
    PUT CONTROL '£££££££Bestand£EP£Vorjahr£Laufend'             CHR(10)
                '£'                                             CHR(10).

    Ja = QUERY {&BROWSE-NAME}:GET-FIRST NO-ERROR.
    DO WHILE Ja:
        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).
        Ums_Vorj = DYNAMIC-FUNCTION('GETUMSATZ':U, YEAR(TODAY) - 1).
        Ums_Lauf = DYNAMIC-FUNCTION('GETUMSATZ':U, YEAR(TODAY)    ).

        PUT CONTROL '£'.
        PUT CONTROL STRING(Artst.Artnr      ,'999999')      '£'
                           Artst.Bez                        '£'
                           KGeb                             '£'
                    STRING(Artst.Jahr       ,'zzzz')        '£'
                    STRING(Artst.Bestand    ,'->>>>>>>>9')  '£'
                    STRING(Artst.Bestellt   ,'->>>>>>>>9')  '£'
                    STRING(Artst.Mind_Bestand ,'->>>>>>>>9')  '£'
                    STRING(Artst.Listen_EP  ,'>>>>9.999')   '£'
                    STRING(Ums_Vorj         ,'->>>>>>>>9')  '£'
                    STRING(Ums_Lauf         ,'->>>>>>>>9')  CHR(10).
        Ja = QUERY {&BROWSE-NAME}:GET-NEXT NO-ERROR.
    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 = 'A3'.
    excelAppl:Range(Zelle):SELECT.
    excelAppl:Selection:FormulaR1C1 = 'TEXT;' + DatenName.
    excelAppl:Application:RUN ( 'DateiEinfügen' ).

    RUN KOPF ( INPUT excelAppl ).

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

    RUN SUPER.

    RUN OPENQUERY.

END PROCEDURE.

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

/* ************************  Function Implementations ***************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION GETUMSATZ gArtLie 
FUNCTION GETUMSATZ RETURNS DECIMAL
  ( Jahr AS INT ) :
/*------------------------------------------------------------------------------
  Purpose:  
    Notes:  
------------------------------------------------------------------------------*/

    FIND ArtUms USE-INDEX ArtUms-k1
                WHERE ArtUms.Firma  = Artst.Firma
                AND   ArtUms.Artnr  = Artst.Artnr
                AND   ArtUms.Inhalt = Artst.Inhalt
                AND   ArtUms.Jahrg  = Artst.Jahr
                AND   ArtUms.Jahr   = Jahr NO-LOCK NO-ERROR.
    IF NOT AVAILABLE ArtUms THEN RETURN 0.00.
    ELSE                         RETURN ArtUms.Me_Kum.

END FUNCTION.

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