&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: Output Parameters: 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] > "_" "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] > "_" "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: ------------------------------------------------------------------------------*/ 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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