&ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2 &ANALYZE-RESUME /* Connected Databases */ &Scoped-define WINDOW-NAME wINhaltsstoffe {adecomm/appserv.i} &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS wINhaltsstoffe /*------------------------------------------------------------------------ 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 --- */ DEFINE VARIABLE hQuery AS HANDLE NO-UNDO. { properties.i } { ttinhaltsstoffe.i } { incl/windefinition.i } {src/adm2/widgetprto.i} /* _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 designated FRAME-NAME and/or first browse and/or first query */ &Scoped-define FRAME-NAME fMain &Scoped-define BROWSE-NAME Br_Inhalt /* Internal Tables (found by Frame, Query & Browse Queries) */ &Scoped-define INTERNAL-TABLES tInhalt /* Definitions for BROWSE Br_Inhalt */ &Scoped-define FIELDS-IN-QUERY-Br_Inhalt tInhalt.cType tInhalt.cStoff tInhalt.nWert &Scoped-define ENABLED-FIELDS-IN-QUERY-Br_Inhalt &Scoped-define SELF-NAME Br_Inhalt &Scoped-define QUERY-STRING-Br_Inhalt FOR EACH tInhalt &Scoped-define OPEN-QUERY-Br_Inhalt OPEN QUERY {&SELF-NAME} FOR EACH tInhalt. &Scoped-define TABLES-IN-QUERY-Br_Inhalt tInhalt &Scoped-define FIRST-TABLE-IN-QUERY-Br_Inhalt tInhalt /* Definitions for FRAME fMain */ &Scoped-define OPEN-BROWSERS-IN-QUERY-fMain ~ ~{&OPEN-QUERY-Br_Inhalt} /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS RECT-2 Br_Inhalt /* 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 getProgname wINhaltsstoffe FUNCTION getProgname RETURNS CHARACTER ( /* parameter-definitions */ ) FORWARD. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* *********************** Control Definitions ********************** */ /* Define the widget handle for the window */ DEFINE VAR wINhaltsstoffe AS WIDGET-HANDLE NO-UNDO. /* Definitions of the field level widgets */ DEFINE RECTANGLE RECT-2 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 88 BY 12.86. /* Query definitions */ &ANALYZE-SUSPEND DEFINE QUERY Br_Inhalt FOR tInhalt SCROLLING. &ANALYZE-RESUME /* Browse definitions */ DEFINE BROWSE Br_Inhalt &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_Inhalt wINhaltsstoffe _FREEFORM QUERY Br_Inhalt DISPLAY tInhalt.cType LABEL 'Art' tInhalt.cStoff LABEL 'Bezeichnung' tInhalt.nWert LABEL 'Wert' /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME WITH NO-ROW-MARKERS SEPARATORS SIZE 86 BY 12.38. /* ************************ Frame Definitions *********************** */ DEFINE FRAME fMain Br_Inhalt AT ROW 1.48 COL 3 WIDGET-ID 200 RECT-2 AT ROW 1.24 COL 2 WIDGET-ID 2 WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY SIDE-LABELS NO-UNDERLINE THREE-D AT COL 1 ROW 1 SIZE 90 BY 13.33 WIDGET-ID 100. /* *********************** 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 Other Settings: COMPILE APPSERVER */ &ANALYZE-RESUME _END-PROCEDURE-SETTINGS /* ************************* Create Window ************************** */ &ANALYZE-SUSPEND _CREATE-WINDOW IF SESSION:DISPLAY-TYPE = "GUI":U THEN CREATE WINDOW wINhaltsstoffe ASSIGN HIDDEN = YES TITLE = "Inhaltsstoffe" HEIGHT = 13.33 WIDTH = 90 MAX-HEIGHT = 30.48 MAX-WIDTH = 160 VIRTUAL-HEIGHT = 30.48 VIRTUAL-WIDTH = 160 RESIZE = NO SCROLL-BARS = NO STATUS-AREA = NO BGCOLOR = ? FGCOLOR = ? THREE-D = YES MESSAGE-AREA = NO SENSITIVE = YES. ELSE {&WINDOW-NAME} = CURRENT-WINDOW. &IF '{&WINDOW-SYSTEM}' NE 'TTY' &THEN IF NOT wINhaltsstoffe:LOAD-ICON("grafik/appl.ico":U) THEN MESSAGE "Unable to load icon: grafik/appl.ico" VIEW-AS ALERT-BOX WARNING BUTTONS OK. &ENDIF /* END WINDOW DEFINITION */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB wINhaltsstoffe /* ************************* 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 wINhaltsstoffe VISIBLE,,RUN-PERSISTENT */ /* SETTINGS FOR FRAME fMain FRAME-NAME */ /* BROWSE-TAB Br_Inhalt RECT-2 fMain */ IF SESSION:DISPLAY-TYPE = "GUI":U AND VALID-HANDLE(wINhaltsstoffe) THEN wINhaltsstoffe:HIDDEN = YES. /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_Inhalt /* Query rebuild information for BROWSE Br_Inhalt _START_FREEFORM OPEN QUERY {&SELF-NAME} FOR EACH tInhalt. _END_FREEFORM _Query is OPENED */ /* BROWSE Br_Inhalt */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME wINhaltsstoffe &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL wINhaltsstoffe wINhaltsstoffe ON END-ERROR OF wINhaltsstoffe /* Inhaltsstoffe */ OR ENDKEY OF {&WINDOW-NAME} ANYWHERE DO: /* This case occurs when the user presses the "Esc" key. In a persistently run window, just ignore this. If we did not, the application would exit. */ 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 wINhaltsstoffe wINhaltsstoffe ON WINDOW-CLOSE OF wINhaltsstoffe /* Inhaltsstoffe */ DO: /* This ADM code must be left here in order for the SmartWindow and its descendents to terminate properly on exit. */ RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define BROWSE-NAME Br_Inhalt &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK wINhaltsstoffe /* *************************** Main Block *************************** */ { incl/winmainblock.i } {src/adm2/windowmn.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* ********************** Internal Procedures *********************** */ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects wINhaltsstoffe _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 wINhaltsstoffe PROCEDURE changePage : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ RUN SUPER. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U) NO-ERROR. CASE AktSeite: WHEN 1 THEN DO: /* RUN addLink ( hAktionen , 'TableIO':U , h_v-auftr ). */ /* RUN addLink ( hAktionen , 'Navigation':U , h_d-auftr ). */ /* RUN setButtons IN hAktionen ( 'initial-TableIo' ) NO-ERROR. */ END. WHEN 2 THEN DO: END. END CASE. RUN ENTRY_CURSOR. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI wINhaltsstoffe _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(wINhaltsstoffe) THEN DELETE WIDGET wINhaltsstoffe. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject wINhaltsstoffe PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ CREATE QUERY hQuery. hQuery:SET-BUFFERS ( htInhalt ). hQuery:QUERY-PREPARE('FOR EACH tInhalt NO-LOCK BY tInhalt.cType '). BROWSE Br_Inhalt:QUERY = hQuery. { incl/winenableobject.i } RUN SUPER. hQuery:QUERY-OPEN(). END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI wINhaltsstoffe _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-2 Br_Inhalt WITH FRAME fMain IN WINDOW wINhaltsstoffe. {&OPEN-BROWSERS-IN-QUERY-fMain} VIEW wINhaltsstoffe. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE wINhaltsstoffe PROCEDURE ENDE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ { incl/winende.i } END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_CURSOR wINhaltsstoffe PROCEDURE ENTRY_CURSOR : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U) NO-ERROR. FMutFlag = DYNAMIC-FUNCTION('getMutflag':U, INPUT Progname) NO-ERROR. CASE AktSeite: /* WHEN 1 THEN DO: */ /* IF FMutFlag THEN RUN applyEntry IN h_v- ( INPUT ? ). */ /* ELSE RUN applyEntry IN h_b- ( INPUT ? ). */ /* END. */ /* 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 wINhaltsstoffe 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 &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject wINhaltsstoffe PROCEDURE initializeObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ /* Code placed here will execute PRIOR to standard behavior. */ RUN SUPER. { incl/wininitializeobject.i } END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE OPENQUERY wINhaltsstoffe PROCEDURE OPENQUERY : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEFINE VARIABLE cString AS CHARACTER NO-UNDO. DEFINE VARIABLE rArtst AS RECID NO-UNDO. DEFINE VARIABLE cGlnNr AS CHARACTER NO-UNDO. DEFINE VARIABLE cConString AS CHARACTER NO-UNDO. DEFINE VARIABLE hServer AS HANDLE NO-UNDO. DEFINE VARIABLE cStrichcode AS CHARACTER NO-UNDO EXTENT 5. DEFINE VARIABLE i1 AS INTEGER NO-UNDO. DEFINE VARIABLE i2 AS INTEGER NO-UNDO. DEFINE VARIABLE i3 AS INTEGER NO-UNDO. DEFINE BUFFER bArtst FOR Artst. EMPTY TEMP-TABLE tInhalt. hQuery:QUERY-OPEN (). cString = DYNAMIC-FUNCTION('getArtikel':U) NO-ERROR. rArtst = ?. cStrichcode = ''. i1 = 0. IF cString = '' THEN RETURN. rArtst = INTEGER(ENTRY(1, cString, CHR(01) )). FIND bArtst NO-LOCK WHERE RECID(bArtst) = rArtst. IF bArtst.Strichcode <> '' THEN DO: i1 = i1 + 1. cStrichcode[i1] = bArtst.Strichcode. END. FIND FIRST ArtLief NO-LOCK WHERE ArtLief.FIrma = Firma AND ArtLief.Artnr = bArtst.Artnr AND ArtLief.Inhalt = bArtst.Inhalt AND ArtLief.Jahr = bArtst.Jahr AND ArtLief.Haupt = TRUE NO-ERROR. IF NOT AVAILABLE ArtLief THEN DO: FIND FIRST ArtLief NO-LOCK WHERE ArtLief.FIrma = Firma AND ArtLief.Artnr = bArtst.Artnr AND ArtLief.Inhalt = bArtst.Inhalt AND ArtLief.Jahr = bArtst.Jahr NO-ERROR. END. IF AVAILABLE ArtLief THEN DO: IF ArtLief.Strichcode_KGeb <> '' THEN DO: i1 = i1 + 1. cStrichcode[i1] = ArtLief.Strichcode_KGeb. END. IF ArtLief.Strichcode_VGeb <> '' THEN DO: i1 = i1 + 1. cStrichcode[i1] = ArtLief.Strichcode_VGeb. END. IF ArtLief.Strichcode_GGeb <> '' THEN DO: i1 = i1 + 1. cStrichcode[i1] = ArtLief.Strichcode_GGeb. END. FIND Liefst NO-LOCK WHERE Liefst.Firma = ArtLief.Firma AND Liefst.Knr = ArtLief.Knr NO-ERROR. cGlnNr = (IF AVAILABLE Liefst THEN Liefst.GLN_Nr1 ELSE ''). END. IF i1 = 0 THEN RETURN. cConString = SUBSTITUTE('-AppService &1 -H &2 -S &3 -sessionModel session-free', cERPAppServer, cERPServer, cNSPort). CREATE SERVER hServer. hServer:CONNECT(cConString) NO-ERROR. IF NOT hServer:CONNECTED() THEN DO: MESSAGE 'Kein AppServer für asERP' SKIP 'Connect-String -> ' cConString VIEW-AS ALERT-BOX. RETURN. END. A000: DO i3 = 1 TO 2: IF i3 = 2 THEN DO: IF cGlnNr = '' THEN LEAVE A000. cGlnNr = ''. END. DO i2 = 1 TO i1: RUN 'ddinhaltsstoffe.p' ON hServer ( cGlnNr, cStrichcode[i2], OUTPUT TABLE tInhalt ). FIND FIRST tInhalt NO-LOCK NO-ERROR. IF AVAILABLE tInhalt THEN LEAVE A000. END. END. hServer:DISCONNECT(). DELETE OBJECT hServer NO-ERROR. hQuery:QUERY-OPEN(). END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE SEITENWECHSEL wINhaltsstoffe PROCEDURE SEITENWECHSEL : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ { incl/winseitenwechsel.i } END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE selectPage wINhaltsstoffe PROCEDURE selectPage : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEFINE INPUT PARAMETER piPageNum AS INTEGER NO-UNDO. DEFINE VARIABLE FMutFlag AS LOG NO-UNDO. DEFINE VARIABLE MutProg AS CHARACTER NO-UNDO. FMutFlag = DYNAMIC-FUNCTION ('getMutflag':U, INPUT Progname) NO-ERROR. IF FMutFlag THEN RETURN NO-APPLY. CASE piPageNum: END CASE. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U) NO-ERROR. CASE AktSeite: WHEN 1 THEN DO: /* RUN removeLink ( hAktionen , 'TableIO':U , h_v-auftr ). */ /* RUN removeLink ( hAktionen , '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 wINhaltsstoffe PROCEDURE TOOLBAR : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ { incl/wintoolbar.i } END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE viewObject wINhaltsstoffe PROCEDURE viewObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ RUN SUPER. RUN ENTRY_CURSOR. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* ************************ Function Implementations ***************** */ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION getProgname wINhaltsstoffe FUNCTION getProgname RETURNS CHARACTER ( /* parameter-definitions */ ) : /*------------------------------------------------------------------------------ Purpose: Notes: ------------------------------------------------------------------------------*/ RETURN Progname. END FUNCTION. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME