&ANALYZE-SUSPEND _VERSION-NUMBER AB_v9r12 GUI ADM2 &ANALYZE-RESUME &Scoped-define WINDOW-NAME wRestpostenliste &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS wRestpostenliste /*------------------------------------------------------------------------ File: Description: from cntnrwin.w - ADM SmartWindow Template Input Parameters: Output Parameters: History: New V9 Version - January 15, 1998 ------------------------------------------------------------------------*/ /* This .W file was created with the Progress AB. */ /*----------------------------------------------------------------------*/ /* 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 Fenster AS HANDLE NO-UNDO. DEF VAR hToolbar AS HANDLE NO-UNDO. DEF VAR FMutFlag AS LOG NO-UNDO INIT FALSE. DEF VAR SAktiv AS LOG NO-UNDO INIT FALSE. DEF VAR Firma AS CHAR NO-UNDO. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK /* ******************** Preprocessor Definitions ******************** */ &Scoped-define PROCEDURE-TYPE SmartWindow &Scoped-define DB-AWARE no &Scoped-define ADM-CONTAINER WINDOW &Scoped-define ADM-SUPPORTED-LINKS Data-Target,Data-Source,Page-Target,Update-Source,Update-Target,Filter-target,Filter-Source /* Name of first Frame and/or Browse and/or first Query */ &Scoped-define FRAME-NAME fMain /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS CB_Status Preisdatum VonArtnr BisArtnr ~ Btn_Excel VonInhalt BisInhalt T_Zweite RECT-37 &Scoped-Define DISPLAYED-OBJECTS CB_Status Preisdatum VonArtnr BisArtnr ~ VonInhalt BisInhalt T_Zweite /* Custom List Definitions */ /* List-1,List-2,List-3,List-4,List-5,List-6 */ &Scoped-define List-5 Btn_Excel &Scoped-define List-6 CB_Status Preisdatum VonArtnr BisArtnr VonInhalt ~ BisInhalt T_Zweite /* _UIB-PREPROCESSOR-BLOCK-END */ &ANALYZE-RESUME /* *********************** Control Definitions ********************** */ /* Define the widget handle for the window */ DEFINE VAR wRestpostenliste AS WIDGET-HANDLE NO-UNDO. /* Definitions of the field level widgets */ DEFINE BUTTON Btn_Excel IMAGE-UP FILE "grafik/results%.ico":U IMAGE-INSENSITIVE FILE "grafik/results%.ico":U LABEL "Excel" SIZE 7 BY 1.81. DEFINE VARIABLE CB_Status AS CHARACTER FORMAT "X(256)":U LABEL "Artikelstatus" VIEW-AS COMBO-BOX INNER-LINES 5 LIST-ITEM-PAIRS "Normaler Artikel (auf Vorrat)","000000", "Normaler Artikel","000001", "Restposten","000002", "Beschaffungsartikel","000008", "Ausverkauft","000009" DROP-DOWN-LIST SIZE 46 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE BisArtnr AS INTEGER FORMAT "999999":U INITIAL 999999 VIEW-AS FILL-IN SIZE 11 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE BisInhalt AS INTEGER FORMAT "9999":U INITIAL 9999 VIEW-AS FILL-IN SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE Preisdatum AS DATE FORMAT "99.99.9999":U LABEL "Preisdatum" VIEW-AS FILL-IN NATIVE SIZE 16 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE VonArtnr AS INTEGER FORMAT "999999":U INITIAL 0 LABEL "von - bis Artikelnummer" VIEW-AS FILL-IN SIZE 11 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE VonInhalt AS INTEGER FORMAT "9999":U INITIAL 0 LABEL "von - bis Inhalt" VIEW-AS FILL-IN SIZE 8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE RECTANGLE RECT-37 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 90 BY 7.38. DEFINE VARIABLE T_Zweite AS LOGICAL INITIAL no LABEL "Zweite Artikelbezeichnung drucken ?" VIEW-AS TOGGLE-BOX SIZE 45 BY 1 NO-UNDO. /* ************************ Frame Definitions *********************** */ DEFINE FRAME fMain CB_Status AT ROW 2 COL 28 COLON-ALIGNED Preisdatum AT ROW 3 COL 28 COLON-ALIGNED VonArtnr AT ROW 4 COL 28 COLON-ALIGNED BisArtnr AT ROW 4 COL 41 COLON-ALIGNED NO-LABEL Btn_Excel AT ROW 4 COL 82.2 VonInhalt AT ROW 5 COL 28 COLON-ALIGNED BisInhalt AT ROW 5 COL 41 COLON-ALIGNED NO-LABEL T_Zweite AT ROW 7 COL 30 RECT-37 AT ROW 1.24 COL 2 WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY SIDE-LABELS NO-UNDERLINE THREE-D AT COL 1 ROW 1 SIZE 92 BY 7.86. /* *********************** Procedure Settings ************************ */ &ANALYZE-SUSPEND _PROCEDURE-SETTINGS /* Settings for THIS-PROCEDURE Type: SmartWindow Allow: Basic,Browse,DB-Fields,Query,Smart,Window Container Links: Data-Target,Data-Source,Page-Target,Update-Source,Update-Target,Filter-target,Filter-Source Design Page: 1 */ &ANALYZE-RESUME _END-PROCEDURE-SETTINGS /* ************************* Create Window ************************** */ &ANALYZE-SUSPEND _CREATE-WINDOW IF SESSION:DISPLAY-TYPE = "GUI":U THEN CREATE WINDOW wRestpostenliste ASSIGN HIDDEN = YES TITLE = "Artikel-Status-Liste" HEIGHT = 7.86 WIDTH = 92 MAX-HEIGHT = 53.71 MAX-WIDTH = 320 VIRTUAL-HEIGHT = 53.71 VIRTUAL-WIDTH = 320 RESIZE = no SCROLL-BARS = no STATUS-AREA = no BGCOLOR = ? FGCOLOR = ? THREE-D = yes MESSAGE-AREA = no SENSITIVE = yes. ELSE {&WINDOW-NAME} = CURRENT-WINDOW. /* END WINDOW DEFINITION */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB wRestpostenliste /* ************************* Included-Libraries *********************** */ {src/adm2/containr.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* *********** Runtime Attributes and AppBuilder Settings *********** */ &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES /* SETTINGS FOR WINDOW wRestpostenliste VISIBLE,,RUN-PERSISTENT */ /* SETTINGS FOR FRAME fMain */ /* SETTINGS FOR FILL-IN BisArtnr IN FRAME fMain 6 */ /* SETTINGS FOR FILL-IN BisInhalt IN FRAME fMain 6 */ /* SETTINGS FOR BUTTON Btn_Excel IN FRAME fMain 5 */ /* SETTINGS FOR COMBO-BOX CB_Status IN FRAME fMain 6 */ /* SETTINGS FOR FILL-IN Preisdatum IN FRAME fMain 6 */ /* SETTINGS FOR TOGGLE-BOX T_Zweite IN FRAME fMain 6 */ /* SETTINGS FOR FILL-IN VonArtnr IN FRAME fMain 6 */ /* SETTINGS FOR FILL-IN VonInhalt IN FRAME fMain 6 */ IF SESSION:DISPLAY-TYPE = "GUI":U AND VALID-HANDLE(wRestpostenliste) THEN wRestpostenliste:HIDDEN = yes. /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME wRestpostenliste &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL wRestpostenliste wRestpostenliste ON END-ERROR OF wRestpostenliste /* Artikel-Status-Liste */ OR ENDKEY OF {&WINDOW-NAME} ANYWHERE DO: IF THIS-PROCEDURE:PERSISTENT THEN RETURN NO-APPLY. RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL wRestpostenliste wRestpostenliste ON WINDOW-CLOSE OF wRestpostenliste /* Artikel-Status-Liste */ 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 wRestpostenliste ON CHOOSE OF Btn_Excel IN FRAME fMain /* Excel */ DO: DO WITH FRAME {&FRAME-NAME}: Btn_Excel:VISIBLE = FALSE. RUN REPORT. Btn_Excel:VISIBLE = TRUE. RUN ENDE. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK wRestpostenliste /* *************************** Main Block *************************** */ MaxPage = 1. AktSeite = 1. SAktiv = DYNAMIC-FUNCTION('getSuperAktiv':U) NO-ERROR. IF SAktiv THEN DO: Firma = DYNAMIC-FUNCTION('GETMANDANT':U) NO-ERROR. END. SESSION:DATA-ENTRY-RETURN = TRUE. /* TRIGGERS ------------------------------------------------------ */ ON 'END-ERROR':U OF {&WINDOW-NAME} ANYWHERE DO: RUN ENDE. RETURN NO-APPLY. END. /* Include custom Main Block code for SmartWindows. */ {src/adm2/windowmn.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* ********************** Internal Procedures *********************** */ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects wRestpostenliste _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 disable_UI wRestpostenliste _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. ------------------------------------------------------------------------------*/ /* Delete the WINDOW we created */ IF SESSION:DISPLAY-TYPE = "GUI":U AND VALID-HANDLE(wRestpostenliste) THEN DELETE WIDGET wRestpostenliste. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject wRestpostenliste PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR wx AS INT NO-UNDO. DEF VAR wy AS INT NO-UNDO. DEF VAR xString AS CHAR NO-UNDO. GET-KEY-VALUE SECTION 'FensterPositionen' KEY 'Fenster' VALUE xString. IF xString = ? THEN xString = '30;30'. IF xString = '' THEN xString = '30;30'. wx = INTEGER(ENTRY(1, xString, ';')). wy = INTEGER(ENTRY(2, xString, ';')). IF wx < 0 THEN wx = 1. IF wy < 0 THEN wy = 1. {&WINDOW-NAME}:X = wx. {&WINDOW-NAME}:Y = wy. RUN SUPER. IF SAktiv THEN RUN FENSTER_TITEL ( INPUT {&WINDOW-NAME}:HANDLE ) NO-ERROR. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI wRestpostenliste _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. ------------------------------------------------------------------------------*/ DISPLAY CB_Status Preisdatum VonArtnr BisArtnr VonInhalt BisInhalt T_Zweite WITH FRAME fMain IN WINDOW wRestpostenliste. ENABLE CB_Status Preisdatum VonArtnr BisArtnr Btn_Excel VonInhalt BisInhalt T_Zweite RECT-37 WITH FRAME fMain IN WINDOW wRestpostenliste. {&OPEN-BROWSERS-IN-QUERY-fMain} VIEW wRestpostenliste. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE wRestpostenliste PROCEDURE ENDE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR wx AS INT NO-UNDO. DEF VAR wy AS INT NO-UNDO. DEF VAR xString AS CHAR NO-UNDO. 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 ). wx = {&WINDOW-NAME}:X NO-ERROR. wy = {&WINDOW-NAME}:Y NO-ERROR. xString = STRING(wx) + ';' + STRING(wy). PUT-KEY-VALUE SECTION 'FensterPositionen' KEY 'Fenster' VALUE xString. APPLY "CLOSE":U TO THIS-PROCEDURE. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE exitObject wRestpostenliste PROCEDURE exitObject : /*------------------------------------------------------------------------------ Purpose: Window-specific override of this procedure which destroys its contents and itself. Notes: ------------------------------------------------------------------------------*/ RUN ENDE. RETURN NO-APPLY. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME