&ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2 &ANALYZE-RESUME &Scoped-define WINDOW-NAME CURRENT-WINDOW &Scoped-define FRAME-NAME gInventUeb &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gInventUeb /*------------------------------------------------------------------------ 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 --- */ /* 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 FwSprcd AS INT NO-UNDO. DEF VAR Firma AS CHAR NO-UNDO. DEF VAR VNeg AS INT NO-UNDO. DEF VAR VPos AS INT NO-UNDO. DEF VAR VNegFak AS INT NO-UNDO. DEF VAR VPosFak AS INT NO-UNDO. DEF VAR VDiff AS DEC DECIMALS 4 NO-UNDO. DEF VAR ARecid AS RECID NO-UNDO. DEF VAR LRecid AS RECID NO-UNDO. DEF VAR VDatum AS DATE NO-UNDO. DEF VAR FwFRW AS CHAR NO-UNDO. DEF VAR iLager AS INT NO-UNDO. DEF BUFFER BArtst FOR Artst. DEF BUFFER BArtLager FOR ArtLager. DEF TEMP-TABLE tDatum NO-UNDO FIELD Datum AS DATE INDEX tDatum-k1 IS PRIMARY Datum DESCENDING. /* _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 gInventUeb /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS F_Datum F_Artnr_V F_Artnr_B F_Inhalt_V ~ F_Inhalt_B F_Jahr_V F_Jahr_B F_Wgr_V F_Wgr_B Btn_Start Btn_Cancel ~ CB_Negativ CB_Positiv T_Negativ T_Positiv CB_Lager RECT-36 &Scoped-Define DISPLAYED-OBJECTS F_Datum F_Artnr_V F_Artnr_B F_Inhalt_V ~ F_Inhalt_B F_Jahr_V F_Jahr_B F_Wgr_V F_Wgr_B F_Fortschritt CB_Negativ ~ CB_Positiv T_Negativ T_Positiv CB_Lager /* Custom List Definitions */ /* List-1,List-2,List-3,List-4,List-5,List-6 */ &Scoped-define List-1 F_Datum F_Artnr_V F_Artnr_B F_Inhalt_V F_Inhalt_B ~ F_Jahr_V F_Jahr_B F_Wgr_V F_Wgr_B &Scoped-define List-6 F_Datum F_Artnr_V F_Artnr_B F_Inhalt_V F_Inhalt_B ~ F_Jahr_V F_Jahr_B F_Wgr_V F_Wgr_B CB_Negativ CB_Positiv T_Negativ T_Positiv /* _UIB-PREPROCESSOR-BLOCK-END */ &ANALYZE-RESUME /* *********************** Control Definitions ********************** */ /* Define a dialog box */ /* Definitions of the field level widgets */ DEFINE BUTTON Btn_Cancel AUTO-END-KEY LABEL "&Abbrechen" SIZE 15 BY 1. DEFINE BUTTON Btn_Start LABEL "&Start" SIZE 15 BY 1. DEFINE VARIABLE CB_Lager AS CHARACTER FORMAT "X(256)":U LABEL "Lager" VIEW-AS COMBO-BOX INNER-LINES 5 LIST-ITEM-PAIRS "Item 1","Item 1" DROP-DOWN-LIST SIZE 30 BY 1 NO-UNDO. DEFINE VARIABLE CB_Negativ AS CHARACTER FORMAT "X(256)":U LABEL "Minus Korrekturen" VIEW-AS COMBO-BOX INNER-LINES 5 DROP-DOWN-LIST SIZE 25.8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE CB_Positiv AS CHARACTER FORMAT "X(256)":U LABEL "Positiv Korrekturen" VIEW-AS COMBO-BOX INNER-LINES 5 DROP-DOWN-LIST SIZE 25.8 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Artnr_B AS INTEGER FORMAT "999999" INITIAL 0 LABEL "--" VIEW-AS FILL-IN NATIVE SIZE 11 BY 1 BGCOLOR 15 . DEFINE VARIABLE F_Artnr_V AS INTEGER FORMAT "999999" INITIAL 0 LABEL "Artikelnummer" VIEW-AS FILL-IN NATIVE SIZE 11 BY 1 BGCOLOR 15 . DEFINE VARIABLE F_Datum AS DATE FORMAT "99.99.9999" LABEL "Inventardatum" VIEW-AS FILL-IN NATIVE SIZE 16 BY 1 BGCOLOR 15 . DEFINE VARIABLE F_Fortschritt AS CHARACTER FORMAT "X(256)":U VIEW-AS FILL-IN NATIVE SIZE 60 BY 1 BGCOLOR 8 NO-UNDO. DEFINE VARIABLE F_Inhalt_B AS INTEGER FORMAT "9999" INITIAL 0 LABEL "--" VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 . DEFINE VARIABLE F_Inhalt_V AS INTEGER FORMAT "9999" INITIAL 0 LABEL "Inhalt" VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 . DEFINE VARIABLE F_Jahr_B AS INTEGER FORMAT "9999" INITIAL 0 LABEL "--" VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 . DEFINE VARIABLE F_Jahr_V AS INTEGER FORMAT "9999" INITIAL 0 LABEL "Jahr" VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 . DEFINE VARIABLE F_Wgr_B AS INTEGER FORMAT "9999" INITIAL 0 LABEL "--" VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 . DEFINE VARIABLE F_Wgr_V AS INTEGER FORMAT "9999" INITIAL 0 LABEL "Warengruppe" VIEW-AS FILL-IN NATIVE SIZE 8 BY 1 BGCOLOR 15 . DEFINE RECTANGLE RECT-36 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 70 BY 13.33. DEFINE VARIABLE T_Negativ AS LOGICAL INITIAL no LABEL "automatisch" VIEW-AS TOGGLE-BOX SIZE 17 BY 1 NO-UNDO. DEFINE VARIABLE T_Positiv AS LOGICAL INITIAL no LABEL "automatisch" VIEW-AS TOGGLE-BOX SIZE 17 BY 1 NO-UNDO. /* ************************ Frame Definitions *********************** */ DEFINE FRAME gInventUeb F_Datum AT ROW 3 COL 21 COLON-ALIGNED F_Artnr_V AT ROW 4 COL 21 COLON-ALIGNED F_Artnr_B AT ROW 4 COL 36 COLON-ALIGNED F_Inhalt_V AT ROW 5 COL 21 COLON-ALIGNED F_Inhalt_B AT ROW 5 COL 36 COLON-ALIGNED F_Jahr_V AT ROW 6 COL 21 COLON-ALIGNED F_Jahr_B AT ROW 6 COL 36 COLON-ALIGNED F_Wgr_V AT ROW 7 COL 21 COLON-ALIGNED F_Wgr_B AT ROW 7 COL 36 COLON-ALIGNED Btn_Start AT ROW 13 COL 7 Btn_Cancel AT ROW 13 COL 52 F_Fortschritt AT ROW 11.52 COL 7 NO-LABEL CB_Negativ AT ROW 8.52 COL 21 COLON-ALIGNED CB_Positiv AT ROW 9.52 COL 21 COLON-ALIGNED T_Negativ AT ROW 8.52 COL 52 T_Positiv AT ROW 9.52 COL 52 CB_Lager AT ROW 2 COL 21 COLON-ALIGNED WIDGET-ID 2 RECT-36 AT ROW 1.24 COL 2 SPACE(0.79) SKIP(0.22) WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE TITLE "Inventarübernahme" 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 gInventUeb /* ************************* 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 gInventUeb FRAME-NAME Custom */ ASSIGN FRAME gInventUeb:SCROLLABLE = FALSE FRAME gInventUeb:HIDDEN = TRUE. /* SETTINGS FOR COMBO-BOX CB_Negativ IN FRAME gInventUeb 6 */ /* SETTINGS FOR COMBO-BOX CB_Positiv IN FRAME gInventUeb 6 */ /* SETTINGS FOR FILL-IN F_Artnr_B IN FRAME gInventUeb 1 6 */ /* SETTINGS FOR FILL-IN F_Artnr_V IN FRAME gInventUeb 1 6 */ /* SETTINGS FOR FILL-IN F_Datum IN FRAME gInventUeb 1 6 */ /* SETTINGS FOR FILL-IN F_Fortschritt IN FRAME gInventUeb NO-ENABLE ALIGN-L */ /* SETTINGS FOR FILL-IN F_Inhalt_B IN FRAME gInventUeb 1 6 */ /* SETTINGS FOR FILL-IN F_Inhalt_V IN FRAME gInventUeb 1 6 */ /* SETTINGS FOR FILL-IN F_Jahr_B IN FRAME gInventUeb 1 6 */ /* SETTINGS FOR FILL-IN F_Jahr_V IN FRAME gInventUeb 1 6 */ /* SETTINGS FOR FILL-IN F_Wgr_B IN FRAME gInventUeb 1 6 */ /* SETTINGS FOR FILL-IN F_Wgr_V IN FRAME gInventUeb 1 6 */ /* SETTINGS FOR TOGGLE-BOX T_Negativ IN FRAME gInventUeb 6 */ /* SETTINGS FOR TOGGLE-BOX T_Positiv IN FRAME gInventUeb 6 */ /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gInventUeb /* Query rebuild information for DIALOG-BOX gInventUeb _Options = "SHARE-LOCK" _Query is NOT OPENED */ /* DIALOG-BOX gInventUeb */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME gInventUeb &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gInventUeb gInventUeb ON END-ERROR OF FRAME gInventUeb /* Inventarübernahme */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gInventUeb gInventUeb ON GO OF FRAME gInventUeb /* Inventarübernahme */ DO: /* RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ) NO-ERROR. */ END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gInventUeb gInventUeb ON WINDOW-CLOSE OF FRAME gInventUeb /* Inventarübernahme */ 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 gInventUeb ON CHOOSE OF Btn_Cancel IN FRAME gInventUeb /* Abbrechen */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME Btn_Start &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Start gInventUeb ON CHOOSE OF Btn_Start IN FRAME gInventUeb /* Start */ DO: DEF VAR cDaten AS CHAR NO-UNDO. DEF VAR Eingang AS DEC DECIMALS 3 NO-UNDO. DEF VAR Ausgang AS DEC DECIMALS 3 NO-UNDO. DEF VAR Inventar AS DEC DECIMALS 3 NO-UNDO. DEF VAR nBestand AS DEC DECIMALS 3 NO-UNDO. DEF VAR iTrnr AS INT NO-UNDO. DO WITH FRAME {&FRAME-NAME}: ASSIGN {&List-6}. iLager = INTEGER(CB_Lager:SCREEN-VALUE). VNeg = INTEGER(CB_Negativ:SCREEN-VALUE). VPos = INTEGER(CB_Positiv:SCREEN-VALUE). RUN FIND_LAGTRANSART ( INPUT VNeg, OUTPUT cDaten ). IF cDaten <> '' AND cDaten <> ? THEN VNegFak = INTEGER(ENTRY(3, cDaten, CHR(01) )). ELSE VNegFak = 1. RUN FIND_LAGTRANSART ( INPUT VPos, OUTPUT cDaten ). IF cDaten <> '' AND cDaten <> ? THEN VPosFak = INTEGER(ENTRY(3, cDaten, CHR(01) )). ELSE VPosFak = 1. RUN DATUMTEST. IF RETURN-VALUE = 'NO-APPLY' THEN RETURN NO-APPLY. VDatum = F_Datum - 1. DISABLE Btn_Start Btn_Cancel. SESSION:SET-WAIT-STATE('GENRAL'). DISABLE TRIGGERS FOR LOAD OF ArtLager. FOR EACH Artst USE-INDEX Artst-k1 WHERE Artst.Firma = Firma AND Artst.Artnr >= F_Artnr_V AND Artst.Artnr <= F_Artnr_B AND Artst.Inhalt >= F_Inhalt_V AND Artst.Inhalt <= F_Inhalt_B AND Artst.Jahr >= F_Jahr_V AND Artst.Jahr <= F_Jahr_B AND Artst.Wg_Grp >= F_Wgr_V AND Artst.Wg_Grp <= F_Wgr_B AND Artst.Lager = TRUE TRANSACTION: FIND ArtLager USE-INDEX ArtLager-k1 WHERE ArtLager.Firma = Artst.Firma AND ArtLager.Artnr = Artst.Artnr AND ArtLager.Inhalt = Artst.Inhalt AND ArtLager.Jahr = Artst.Jahr AND ArtLager.Lager = iLager NO-ERROR. IF NOT AVAILABLE ArtLager THEN DO: CREATE ArtLager. ASSIGN ArtLager.Firma = Artst.Firma ArtLager.Artnr = Artst.Artnr ArtLager.Inhalt = Artst.Inhalt ArtLager.Jahr = Artst.Jahr ArtLager.Lager = iLager ArtLager.Datum_Inv = F_Datum. END. IF ArtLager.Datum_Inv <> F_Datum THEN NEXT. F_Fortschritt = STRING(Artst.Artnr,"999999") + " " + Artst.Bez. F_Fortschritt:SCREEN-VALUE = STRING(Artst.Artnr,"999999") + " " + Artst.Bez. ARecid = RECID(Artst). LRecid = RECID(ArtLager). RUN INVENTARBUCHUNG ( OUTPUT ArtLager.Inv_Best, OUTPUT iTrnr ). ASSIGN Eingang = 0 Ausgang = 0. FOR EACH Artbw USE-INDEX Artbw-k2 WHERE Artbw.Firma = Artst.Firma AND Artbw.Artnr = Artst.Artnr AND Artbw.Inhalt = Artst.Inhalt AND Artbw.Jahr = Artst.Jahr AND Artbw.Lager = iLager AND Artbw.Datum >= F_Datum NO-LOCK: IF Artbw.Datum = F_Datum AND Artbw.Trnr > iTrnr THEN NEXT. IF Artbw.Tr_Art > 20 THEN NEXT. IF NOT Artbw.Lag_Buch THEN NEXT. IF Artbw.Tr_Art < 11 THEN Ausgang = Ausgang + Artbw.Menge. ELSE Eingang = Eingang + Artbw.Menge. END. ASSIGN ArtLager.Eingang = Eingang ArtLager.Ausgang = Ausgang ArtLager.Bestand = ArtLager.Inv_Best + ArtLager.Eingang - ArtLager.Ausgang. VDiff = ArtLager.Bestand - ArtLager.Bestand_Alt + ArtLager.Ausgang - ArtLager.Eingang. IF VDiff <> 0 THEN RUN KORREKTUR. nBestand = 0. FOR EACH ArtLager USE-INDEX ArtLager-k1 WHERE ArtLager.Firma = Artst.Firma AND ArtLager.Artnr = Artst.Artnr AND ArtLager.Inhalt = Artst.Inhalt AND ArtLager.Jahr = Artst.Jahr: nBestand = nBestand + ArtLager.Bestand. END. Artst.Bestand = nBestand. END. ENABLE Btn_Start Btn_Cancel. SESSION:SET-WAIT-STATE(''). F_Fortschritt:SCREEN-VALUE = ''. APPLY 'ENTRY' TO CB_Lager. END. RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME CB_Lager &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Lager gInventUeb ON VALUE-CHANGED OF CB_Lager IN FRAME gInventUeb /* Lager */ DO: iLager = INTEGER(CB_Lager:SCREEN-VALUE). END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME F_Datum &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Datum gInventUeb ON LEAVE OF F_Datum IN FRAME gInventUeb /* Inventardatum */ DO: ASSIGN {&List-6}. RUN DATUMTEST. IF RETURN-VALUE = 'NO-APPLY' THEN RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME T_Negativ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL T_Negativ gInventUeb ON VALUE-CHANGED OF T_Negativ IN FRAME gInventUeb /* automatisch */ DO: DO WITH FRAME {&FRAME-NAME}: ASSIGN T_Negativ. IF T_Negativ THEN CB_Negativ:SENSITIVE = TRUE. ELSE CB_Negativ:SENSITIVE = FALSE. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME T_Positiv &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL T_Positiv gInventUeb ON VALUE-CHANGED OF T_Positiv IN FRAME gInventUeb /* automatisch */ DO: DO WITH FRAME {&FRAME-NAME}: ASSIGN T_Positiv. IF T_Positiv THEN CB_Positiv:SENSITIVE = TRUE. ELSE CB_Positiv:SENSITIVE = FALSE. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gInventUeb /* *************************** Main Block *************************** */ MaxPage = 1. AktSeite = 1. FwSprcd = DYNAMIC-FUNCTION('GETFWSPRCD':U) NO-ERROR. Firma = DYNAMIC-FUNCTION('GETMANDANT':U) NO-ERROR. 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 gInventUeb _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 gInventUeb 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 DATUMTEST gInventUeb PROCEDURE DATUMTEST : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DO WITH FRAME {&FRAME-NAME}: IF F_Datum = ? THEN DO: RUN FEHLER ( INPUT 0096 ). APPLY 'ENTRY' TO F_Datum. RETURN 'NO-APPLY'. END. RETURN. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gInventUeb _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 gInventUeb. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gInventUeb PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR ix AS INT NO-UNDO. /* Code placed here will execute PRIOR to standard behavior. */ RUN SUPER. RUN FENSTER_TITEL ( INPUT FRAME {&FRAME-NAME}:HANDLE ) NO-ERROR. DO WITH FRAME {&FRAME-NAME}: iLager = DYNAMIC-FUNCTION('getBenLager':U). RUN COMBO_LAGER ( CB_Lager:HANDLE ). CB_Lager:SCREEN-VALUE = STRING(iLager,'999999'). F_Datum = ?. F_Artnr_V = 0. F_Artnr_B = 0. F_Inhalt_V = 0. F_Inhalt_B = 9999. F_Jahr_V = 0. F_Jahr_B = 9999. F_Wgr_V = 0. F_Wgr_B = 9999. RUN COMBO_LAGERTRANS ( INPUT CB_Negativ:HANDLE ). RUN COMBO_LAGERTRANS ( INPUT CB_Positiv:HANDLE ). T_Negativ = FALSE. T_Positiv = FALSE. CB_Negativ:SENSITIVE = FALSE. CB_Positiv:SENSITIVE = FALSE. EMPTY TEMP-TABLE tDatum. FOR EACH ArtLager NO-LOCK WHERE ArtLager.Firma = Firma AND ArtLager.Lager = iLager AND ArtLager.Datum_Inv <> ?: F_Datum = ArtLager.Datum_Inv. FIND FIRST tDatum WHERE tDatum.Datum = F_Datum NO-ERROR. IF NOT AVAILABLE tDatum THEN DO: CREATE tDatum. ASSIGN tDatum.Datum = F_Datum. END. END. FIND FIRST tDatum NO-ERROR. IF NOT AVAILABLE tDatum THEN F_Datum = TODAY. ELSE F_Datum = tDatum.Datum. DISPLAY {&List-6}. END. GET-KEY-VALUE SECTION 'FwSteuer' KEY 'FwFRW' VALUE FwFRW. IF FwFRW = ? THEN FwFRW = 'CHF'. APPLY 'ENTRY' TO F_Datum IN FRAME {&FRAME-NAME}. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gInventUeb _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 F_Datum F_Artnr_V F_Artnr_B F_Inhalt_V F_Inhalt_B F_Jahr_V F_Jahr_B F_Wgr_V F_Wgr_B F_Fortschritt CB_Negativ CB_Positiv T_Negativ T_Positiv CB_Lager WITH FRAME gInventUeb. ENABLE F_Datum F_Artnr_V F_Artnr_B F_Inhalt_V F_Inhalt_B F_Jahr_V F_Jahr_B F_Wgr_V F_Wgr_B Btn_Start Btn_Cancel CB_Negativ CB_Positiv T_Negativ T_Positiv CB_Lager RECT-36 WITH FRAME gInventUeb. VIEW FRAME gInventUeb. {&OPEN-BROWSERS-IN-QUERY-gInventUeb} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gInventUeb 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 gInventUeb PROCEDURE ENTRY_CURSOR : /*------------------------------------------------------------------------------ Purpose: Parameters: 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 gInventUeb 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 INVENTARBUCHUNG gInventUeb PROCEDURE INVENTARBUCHUNG : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF OUTPUT PARAMETER opInvBest AS DEC NO-UNDO. DEF OUTPUT PARAMETER opTrnr AS INT NO-UNDO. DEF VAR VArt AS INT NO-UNDO. DEF VAR i1 AS INT NO-UNDO. DEF VAR KGeb_Me AS DEC DECIMALS 3 NO-UNDO. DEF VAR VGeb_Me AS DEC DECIMALS 3 NO-UNDO. DEF VAR GGeb_Me AS DEC DECIMALS 3 NO-UNDO. FIND Steuer WHERE Steuer.Firma = Firma NO-LOCK. FIND BArtst WHERE RECID(BArtst) = ARecid NO-LOCK. FIND BArtLager WHERE RECID(BArtLager) = LRecid. FIND KGebinde USE-INDEX KGebinde-k1 WHERE KGebinde.Firma = Firma AND KGebinde.Geb_Cd = BArtst.KGeb_Cd NO-LOCK NO-ERROR. KGeb_Me = 0. VGeb_Me = 0. GGeb_Me = 0. i1 = 99999999. FOR EACH Artbw USE-INDEX Artbw-k7 WHERE Artbw.Firma = BArtLager.Firma AND Artbw.Artnr = BArtLager.Artnr AND Artbw.Inhalt = BArtLager.Inhalt AND Artbw.Jahr = BArtLager.Jahr AND Artbw.Tr_Art = 21 AND Artbw.Datum = BArtLager.Datum_Inv AND Artbw.Lager = BArtLager.Lager. KGeb_Me = KGeb_Me + Artbw.KGeb_Me. VGeb_Me = VGeb_Me + Artbw.VGeb_Me. GGeb_Me = GGeb_Me + Artbw.GGeb_Me. IF Artbw.Trnr < i1 THEN i1 = Artbw.Trnr. DELETE Artbw. END. IF i1 = 99999999 THEN DO: FIND LAST Artbw USE-INDEX Artbw-k1 WHERE Artbw.Firma = Firma NO-LOCK NO-ERROR. IF AVAILABLE Artbw THEN i1 = Artbw.Trnr + 1. ELSE i1 = 1. END. opTrnr = i1. FIND Wust USE-INDEX Wust-k1 WHERE Wust.CodeK = Steuer.MWST-Exkl AND Wust.CodeA = BArtst.MWSt NO-LOCK NO-ERROR. CREATE Artbw. ASSIGN Artbw.Firma = Firma Artbw.Trnr = i1 Artbw.Tr_Art = 21 Artbw.Artnr = BArtst.Artnr Artbw.Inhalt = BArtst.Inhalt Artbw.Jahr = BArtst.Jahr Artbw.Bez1 = BArtst.Bez Artbw.Knr = 0 Artbw.Menge = KGeb_Me Artbw.Alk_Gehalt = BArtst.Alk_Gehalt Artbw.Aktion = FALSE Artbw.Sk_Ber = FALSE Artbw.Netto = FALSE Artbw.Lager = BArtLager.Lager Artbw.KGeb_Cd = BArtst.KGeb_Cd Artbw.VGeb_Cd = BArtst.VGeb_Cd Artbw.GGeb_Cd = BArtst.GGeb_Cd Artbw.KGeb_Me = KGeb_Me Artbw.VGeb_Me = VGeb_Me Artbw.GGeb_Me = GGeb_Me Artbw.EP = BArtst.DEP Artbw.Preis = BArtst.DEP Artbw.Bru_Betr = BArtst.DEP * KGeb_Me Artbw.Net_Betr = BArtst.DEP * KGeb_Me Artbw.Datum = BArtLager.Datum_Inv Artbw.Abhol = FALSE Artbw.FRW = FwFRW Artbw.Faktor = 1 Artbw.Kurs = 1.0 Artbw.WC = BArtst.MWST Artbw.WuCd = Wust.WuCd Artbw.Aufnr = 0. IF AVAILABLE KGebinde THEN DO: ASSIGN Artbw.Liter = KGeb_Me * KGebinde.Inhalt / 100 Artbw.Gewicht = (KGeb_Me * BArtst.Gewicht) + (KGeb_Me * KGebinde.Gewicht). END. opInvBest = Artbw.Menge. RELEASE BArtst. RELEASE BArtLager. RELEASE Steuer. RELEASE KGebinde. RELEASE Wust. RELEASE Artbw. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE KORREKTUR gInventUeb PROCEDURE KORREKTUR : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR VArt AS INT NO-UNDO. DEF VAR i1 AS INT NO-UNDO. DO WITH FRAME {&FRAME-NAME}: IF T_Negativ = FALSE AND T_Positiv = FALSE THEN RETURN. IF VDiff < 0 AND T_Negativ = FALSE THEN RETURN. IF VDiff > 0 AND T_Positiv = FALSE THEN RETURN. IF VDiff < 0 THEN VArt = VNeg. ELSE VArt = VPos. REPEAT TRANSACTION WITH FRAME {&FRAME-NAME}: FIND Steuer WHERE Steuer.Firma = Firma NO-LOCK. FIND BArtst WHERE RECID(BArtst) = ARecid NO-LOCK. FIND BArtLager WHERE RECID(BArtLager) = LRecid. FIND KGebinde USE-INDEX KGebinde-k1 WHERE KGebinde.Firma = Firma AND KGebinde.Geb_Cd = BArtst.KGeb_Cd NO-LOCK NO-ERROR. FIND LAST Artbw USE-INDEX Artbw-k1 WHERE Artbw.Firma = Firma NO-LOCK NO-ERROR. IF AVAILABLE Artbw THEN i1 = Artbw.Trnr + 1. ELSE i1 = 1. FIND Wust USE-INDEX Wust-k1 WHERE Wust.CodeK = Steuer.MWST-Exkl AND Wust.CodeA = BArtst.MWSt NO-LOCK NO-ERROR. CREATE Artbw. ASSIGN Artbw.Firma = Firma Artbw.Trnr = i1 Artbw.Tr_Art = VArt Artbw.Artnr = BArtst.Artnr Artbw.Inhalt = BArtst.Inhalt Artbw.Jahr = BArtst.Jahr Artbw.Bez1 = BArtst.Bez Artbw.Knr = 0 Artbw.Menge = VDiff Artbw.Alk_Gehalt = BArtst.Alk_Gehalt Artbw.Aktion = FALSE Artbw.Sk_Ber = FALSE Artbw.Netto = FALSE Artbw.Lager = BArtLager.Lager Artbw.KGeb_Cd = BArtst.KGeb_Cd Artbw.VGeb_Cd = BArtst.VGeb_Cd Artbw.GGeb_Cd = BArtst.GGeb_Cd Artbw.KGeb_Me = VDiff Artbw.VGeb_Me = 0 Artbw.GGeb_Me = 0 Artbw.EP = BArtst.DEP Artbw.Preis = BArtst.DEP Artbw.Bru_Betr = BArtst.DEP * VDiff Artbw.Net_Betr = BArtst.DEP * VDiff Artbw.Liter = VDiff * KGebinde.Inhalt / 100 Artbw.Gewicht = (VDiff * BArtst.Gewicht) + KGebinde.Gewicht Artbw.Datum = VDatum Artbw.Abhol = FALSE Artbw.FRW = FwFRW Artbw.Faktor = 1 Artbw.Kurs = 1.0 Artbw.WC = BArtst.MWST Artbw.WuCd = Wust.WuCd Artbw.Aufnr = 0. BArtLager.Bestand_Alt = BArtLager.Bestand_Alt + VDiff. RELEASE BArtst. RELEASE BArtLager. RELEASE Steuer. RELEASE KGebinde. RELEASE Wust. RELEASE Artbw. LEAVE. END. END. /* FRAME */ RETURN. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE NEXTPAGE gInventUeb 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 PREVPAGE gInventUeb 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 selectPage gInventUeb 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 gInventUeb 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