&ANALYZE-SUSPEND _VERSION-NUMBER UIB_v8r12 GUI ADM1 &ANALYZE-RESUME /* Connected Databases anadat PROGRESS */ &Scoped-define WINDOW-NAME CURRENT-WINDOW &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS B-table-Win /*------------------------------------------------------------------------ File: Description: from BROWSER.W - Basic SmartBrowser Object Template Input Parameters: Output Parameters: ------------------------------------------------------------------------*/ /* This .W file was created with the Progress UIB. */ /*----------------------------------------------------------------------*/ /* 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 ************************** */ &Scoped-define ERSTES-FELD Menge &Scoped-define ZWEITES-FELD Menge &Scoped-define LETZTES-FELD Menge &Scoped-define INPUT-FELDER SavGebKo.Menge &Scoped-define DATEI-NAME SavGebKo &Scoped-define Zahl_Felder F_ZahBetr,F_ZahSko,CB-ZahARt,Btn_Bezahlt /* *************************** Definitions ************************** */ /* Parameters Definitions --- */ /* Local Variable Definitions --- */ /* --------------------------------------------------------------------------- */ DEF VAR VUpdate AS LOG INIT FALSE NO-UNDO. DEF VAR VSpeichern AS LOG INIT FALSE NO-UNDO. DEF VAR VNeu AS LOG INIT FALSE NO-UNDO. DEF VAR FErfassen AS LOG INIT FALSE NO-UNDO. DEF VAR PHandle AS HANDLE NO-UNDO. DEF VAR XHandle AS HANDLE NO-UNDO. DEF VAR LHandle AS HANDLE NO-UNDO. DEF VAR ch AS CHAR NO-UNDO. DEF VAR VText AS CHAR FORMAT "x(30)" NO-UNDO. DEF VAR QOpen AS LOG INIT FALSE NO-UNDO. DEF VAR FQOpen AS LOG INIT FALSE NO-UNDO. DEF VAR Vorhanden AS LOG NO-UNDO. DEF VAR VROWID AS ROWID NO-UNDO. DEF VAR Feldname AS CHAR NO-UNDO. DEF VAR FeldInhalt AS CHAR NO-UNDO. DEF VAR BStatus AS INT INIT 0 NO-UNDO. DEF BUFFER B{&DATEI-NAME} FOR {&DATEI-NAME}. /* --------------------------------------------------------------------------- */ /* Parameters Definitions --- */ /* Local Variable Definitions --- */ DEF VAR XZahart AS CHAR NO-UNDO. DEF VAR VZahArt AS INT NO-UNDO. DEF VAR VKonto AS CHAR NO-UNDO. DEF VAR xx AS INT NO-UNDO. DEF VAR VBetrag AS DEC NO-UNDO. DEF VAR ok AS LOG NO-UNDO. DEF VAR ARecid AS RECID NO-UNDO. DEF VAR FCuDw AS LOG NO-UNDO. DEF BUFFER BSavko FOR Savko. /* ---------- Globale Variablen ---------------------------------- */ { v8/globvar.i" " " " "SHARED" } { v8/debivar.i " " " " "SHARED" } { v8/artivar.i " " " " "SHARED" } { v8/contvar.i " " " " "SHARED" } { v8/aufkototv.i "NEW" "SHARED" } /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK /* ******************** Preprocessor Definitions ******************** */ &Scoped-define PROCEDURE-TYPE SmartBrowser &Scoped-define DB-AWARE no &Scoped-define ADM-SUPPORTED-LINKS Record-Source,Record-Target,TableIO-Target /* Name of first Frame and/or Browse and/or first Query */ &Scoped-define FRAME-NAME F-Main &Scoped-define BROWSE-NAME br_table /* Internal Tables (found by Frame, Query & Browse Queries) */ &Scoped-define INTERNAL-TABLES SavGebKo /* Define KEY-PHRASE in case it is used by any query. */ &Scoped-define KEY-PHRASE TRUE /* Definitions for BROWSE br_table */ &Scoped-define FIELDS-IN-QUERY-br_table SavGebKo.Menge VText @ VText ~ VBetrag @ VBetrag &Scoped-define ENABLED-FIELDS-IN-QUERY-br_table SavGebKo.Menge &Scoped-define ENABLED-TABLES-IN-QUERY-br_table SavGebKo &Scoped-define FIRST-ENABLED-TABLE-IN-QUERY-br_table SavGebKo &Scoped-define QUERY-STRING-br_table FOR EACH SavGebKo WHERE ~{&KEY-PHRASE} ~ AND SavGebKo.Firma = GVFirma ~ AND SavGebKo.Aufnr = XVAufnr NO-LOCK ~ ~{&SORTBY-PHRASE} &Scoped-define OPEN-QUERY-br_table OPEN QUERY br_table FOR EACH SavGebKo WHERE ~{&KEY-PHRASE} ~ AND SavGebKo.Firma = GVFirma ~ AND SavGebKo.Aufnr = XVAufnr NO-LOCK ~ ~{&SORTBY-PHRASE}. &Scoped-define TABLES-IN-QUERY-br_table SavGebKo &Scoped-define FIRST-TABLE-IN-QUERY-br_table SavGebKo /* Definitions for FRAME F-Main */ /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS RECT-38 RECT-9 br_table E_Adresse F_WW ~ F_Gebinde F_Recycling F_MWST F_Total CB-Zahart F_Skonto F_Netto F_Saldo ~ F_Bezahlt F_Skonto_Bez &Scoped-Define DISPLAYED-OBJECTS F_Aufnr E_Adresse F_WW F_Gebinde ~ F_Recycling F_MWST F_Total CB-Zahart F_Skonto F_Netto F_Saldo F_Zahbetr ~ F_ZahSko F_Bezahlt F_Skonto_Bez /* Custom List Definitions */ /* List-1,List-2,List-3,List-4,List-5,List-6 */ &Scoped-define List-1 F_WW F_Gebinde F_Recycling F_MWST F_Total F_Skonto ~ F_Netto F_Saldo F_Zahbetr F_ZahSko F_Bezahlt F_Skonto_Bez &Scoped-define List-5 SavKo.Fahrer SavKo.BeiFahrer SavKo.LKW &Scoped-define List-6 F_WW F_Gebinde F_Recycling F_MWST F_Total F_Skonto ~ F_Netto F_Saldo F_Zahbetr F_ZahSko F_Bezahlt F_Skonto_Bez /* _UIB-PREPROCESSOR-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _XFTR "Foreign Keys" B-table-Win _INLINE /* Actions: ? adm/support/keyedit.w ? ? ? */ /* STRUCTURED-DATA &BROWSE-NAME ************************** * Set attributes related to FOREIGN KEYS */ RUN set-attribute-list ( 'Keys-Accepted = "", Keys-Supplied = ""':U). /************************** */ /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _XFTR "Advanced Query Options" B-table-Win _INLINE /* Actions: ? adm/support/advqedit.w ? ? ? */ /* STRUCTURED-DATA &BROWSE-NAME ************************ * Set attributes related to SORTBY-OPTIONS */ RUN set-attribute-list ( 'SortBy-Options = ""':U). /************************ */ /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* *********************** Control Definitions ********************** */ /* Definitions of the field level widgets */ DEFINE VARIABLE CB-Zahart AS CHARACTER FORMAT "X(256)":U LABEL "Zahlungsart" VIEW-AS COMBO-BOX INNER-LINES 5 DROP-DOWN-LIST SIZE 32 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE E_Adresse AS CHARACTER VIEW-AS EDITOR NO-WORD-WRAP MAX-CHARS 500 SIZE 83.8 BY 6.57 BGCOLOR 15 FONT 6 NO-UNDO. DEFINE VARIABLE F_Aufnr AS INTEGER FORMAT "9999999":U INITIAL 0 LABEL "Auftragsnummer" VIEW-AS FILL-IN NATIVE SIZE 10 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Bezahlt AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0 LABEL "Bezahlt" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 14 NO-UNDO. DEFINE VARIABLE F_Gebinde AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0 LABEL "Gebinde" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_MWST AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0 LABEL "Mehrwertst." VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Netto AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0 LABEL "Nettobetrag" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Recycling AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0 LABEL "Gebühren" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Saldo AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0 LABEL "Saldo" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 14 NO-UNDO. DEFINE VARIABLE F_Skonto AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0 LABEL "Skonto" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Skonto_Bez AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0 LABEL "Skontoabzug" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 14 NO-UNDO. DEFINE VARIABLE F_Total AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0 LABEL "Totalbetrag" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 8 NO-UNDO. DEFINE VARIABLE F_WW AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0 LABEL "Warenwert" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Zahbetr AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0 LABEL "Zahlbetrag" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_ZahSko AS DECIMAL FORMAT "zzz,zz9.99-":U INITIAL 0 LABEL "Skonto" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 15 NO-UNDO. DEFINE RECTANGLE RECT-38 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 49.6 BY 2.67. DEFINE RECTANGLE RECT-9 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 148 BY 21.43. /* Query definitions */ &ANALYZE-SUSPEND DEFINE QUERY br_table FOR SavGebKo SCROLLING. &ANALYZE-RESUME /* Browse definitions */ DEFINE BROWSE br_table &ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_table B-table-Win _STRUCTURED QUERY br_table NO-LOCK DISPLAY SavGebKo.Menge FORMAT "zz,zz9-":U VText @ VText COLUMN-LABEL "Bezeichnung" FORMAT "x(30)":U VBetrag @ VBetrag COLUMN-LABEL "Betrag" FORMAT "zzz,zz9.99-":U ENABLE SavGebKo.Menge /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME WITH NO-ASSIGN NO-ROW-MARKERS SEPARATORS SIZE 58 BY 20.95 BGCOLOR 15 . /* ************************ Frame Definitions *********************** */ DEFINE FRAME F-Main br_table AT ROW 1.48 COL 3 F_Aufnr AT ROW 1.76 COL 130.6 COLON-ALIGNED E_Adresse AT ROW 3.29 COL 62.6 NO-LABEL F_WW AT ROW 11 COL 73 COLON-ALIGNED F_Gebinde AT ROW 12 COL 73 COLON-ALIGNED SavKo.Fahrer AT ROW 12.67 COL 98 COLON-ALIGNED NO-LABEL FORMAT "99" VIEW-AS FILL-IN NATIVE SIZE 5 BY 1 BGCOLOR 15 SavKo.BeiFahrer AT ROW 12.67 COL 106 COLON-ALIGNED NO-LABEL FORMAT "99" VIEW-AS FILL-IN NATIVE SIZE 5 BY 1 BGCOLOR 15 SavKo.LKW AT ROW 12.67 COL 114 COLON-ALIGNED NO-LABEL FORMAT "99" VIEW-AS FILL-IN NATIVE SIZE 5 BY 1 BGCOLOR 15 F_Recycling AT ROW 13 COL 73 COLON-ALIGNED F_MWST AT ROW 14 COL 73 COLON-ALIGNED F_Total AT ROW 15 COL 73 COLON-ALIGNED CB-Zahart AT ROW 15.86 COL 112 COLON-ALIGNED F_Skonto AT ROW 16 COL 73 COLON-ALIGNED F_Netto AT ROW 17 COL 73 COLON-ALIGNED F_Saldo AT ROW 18 COL 73 COLON-ALIGNED F_Zahbetr AT ROW 19 COL 73 COLON-ALIGNED F_ZahSko AT ROW 19 COL 112 COLON-ALIGNED F_Bezahlt AT ROW 20 COL 73 COLON-ALIGNED F_Skonto_Bez AT ROW 20 COL 112 COLON-ALIGNED "Fahrer BeiFa LKW" VIEW-AS TEXT SIZE 25.4 BY .81 AT ROW 11.67 COL 100 RECT-38 AT ROW 11.38 COL 97.8 RECT-9 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 SCROLLABLE . /* *********************** Procedure Settings ************************ */ &ANALYZE-SUSPEND _PROCEDURE-SETTINGS /* Settings for THIS-PROCEDURE Type: SmartBrowser Allow: Basic,Browse Frames: 1 Add Fields to: EXTERNAL-TABLES Other Settings: PERSISTENT-ONLY COMPILE */ /* This procedure should always be RUN PERSISTENT. Report the error, */ /* then cleanup and return. */ IF NOT THIS-PROCEDURE:PERSISTENT THEN DO: MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U VIEW-AS ALERT-BOX ERROR BUTTONS OK. RETURN. END. &ANALYZE-RESUME _END-PROCEDURE-SETTINGS /* ************************* Create Window ************************** */ &ANALYZE-SUSPEND _CREATE-WINDOW /* DESIGN Window definition (used by the UIB) CREATE WINDOW B-table-Win ASSIGN HEIGHT = 21.91 WIDTH = 150. /* END WINDOW DEFINITION */ */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB B-table-Win /* ************************* Included-Libraries *********************** */ {src/adm/method/browser.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* *********** Runtime Attributes and AppBuilder Settings *********** */ &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES /* SETTINGS FOR WINDOW B-table-Win NOT-VISIBLE,,RUN-PERSISTENT */ /* SETTINGS FOR FRAME F-Main NOT-VISIBLE Size-to-Fit */ /* BROWSE-TAB br_table RECT-9 F-Main */ ASSIGN FRAME F-Main:SCROLLABLE = FALSE FRAME F-Main:HIDDEN = TRUE FRAME F-Main:RESIZABLE = TRUE. /* SETTINGS FOR FILL-IN SavKo.BeiFahrer IN FRAME F-Main NO-DISPLAY NO-ENABLE 5 EXP-LABEL EXP-FORMAT */ ASSIGN E_Adresse:RETURN-INSERTED IN FRAME F-Main = TRUE E_Adresse:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN SavKo.Fahrer IN FRAME F-Main NO-DISPLAY NO-ENABLE 5 EXP-LABEL EXP-FORMAT */ /* SETTINGS FOR FILL-IN F_Aufnr IN FRAME F-Main NO-ENABLE */ /* SETTINGS FOR FILL-IN F_Bezahlt IN FRAME F-Main 1 6 */ /* SETTINGS FOR FILL-IN F_Gebinde IN FRAME F-Main 1 6 */ /* SETTINGS FOR FILL-IN F_MWST IN FRAME F-Main 1 6 */ /* SETTINGS FOR FILL-IN F_Netto IN FRAME F-Main 1 6 */ /* SETTINGS FOR FILL-IN F_Recycling IN FRAME F-Main 1 6 */ /* SETTINGS FOR FILL-IN F_Saldo IN FRAME F-Main 1 6 */ /* SETTINGS FOR FILL-IN F_Skonto IN FRAME F-Main 1 6 */ /* SETTINGS FOR FILL-IN F_Skonto_Bez IN FRAME F-Main 1 6 */ /* SETTINGS FOR FILL-IN F_Total IN FRAME F-Main 1 6 */ /* SETTINGS FOR FILL-IN F_WW IN FRAME F-Main 1 6 */ /* SETTINGS FOR FILL-IN F_Zahbetr IN FRAME F-Main NO-ENABLE 1 6 */ /* SETTINGS FOR FILL-IN F_ZahSko IN FRAME F-Main NO-ENABLE 1 6 */ /* SETTINGS FOR FILL-IN SavKo.LKW IN FRAME F-Main NO-DISPLAY NO-ENABLE 5 EXP-LABEL EXP-FORMAT */ /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_table /* Query rebuild information for BROWSE br_table _TblList = "AnaDat.SavGebKo" _Options = "NO-LOCK KEY-PHRASE SORTBY-PHRASE" _Where[1] = "SavGebKo.Firma = GVFirma AND SavGebKo.Aufnr = XVAufnr" _FldNameList[1] > AnaDat.SavGebKo.Menge "SavGebKo.Menge" ? ? "decimal" ? ? ? ? ? ? yes ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no _FldNameList[2] > "_" "VText @ VText" "Bezeichnung" "x(30)" ? ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no _FldNameList[3] > "_" "VBetrag @ VBetrag" "Betrag" "zzz,zz9.99-" ? ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no _Query is NOT OPENED */ /* BROWSE br_table */ &ANALYZE-RESUME &ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main /* Query rebuild information for FRAME F-Main _Options = "NO-LOCK" _Query is NOT OPENED */ /* FRAME F-Main */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define BROWSE-NAME br_table &Scoped-define SELF-NAME br_table &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table B-table-Win ON ROW-DISPLAY OF br_table IN FRAME F-Main DO: IF NOT AVAILABLE SavGebKo THEN RETURN. RUN ANZEIGE. IF SavGebKo.Menge <> 0 THEN DO: SavGebKo.Menge:BGCOLOR IN BROWSE {&BROWSE-NAME} = 8. VText:BGCOLOR IN BROWSE {&BROWSE-NAME} = 8. VBetrag:BGCOLOR IN BROWSE {&BROWSE-NAME} = 8. END. ELSE DO: SavGebKo.Menge:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15. VText:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15. VBetrag:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table B-table-Win ON ROW-ENTRY OF br_table IN FRAME F-Main DO: {src/adm/template/brsentry.i} END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_table B-table-Win ON VALUE-CHANGED OF br_table IN FRAME F-Main DO: RUN ANZEIGE. {src/adm/template/brschnge.i} END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME CB-Zahart &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB-Zahart B-table-Win ON VALUE-CHANGED OF CB-Zahart IN FRAME F-Main /* Zahlungsart */ DO: DO WITH FRAME {&FRAME-NAME}: ix = LOOKUP(SELF:SCREEN-VALUE, SELF:LIST-ITEMS, '|'). VZahart = INTEGER(ENTRY(ix, XZahart, "|")). FIND Tabel USE-INDEX Tabel-k1 WHERE Tabel.Firma = GVFirma AND Tabel.RecArt = 'ZAHART' AND Tabel.CodeC = '' AND Tabel.CodeI = VZahart AND Tabel.Sprcd = 1 NO-LOCK. VKonto = Tabel.Bez2. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK B-table-Win /* *************************** Main Block *************************** */ &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN RUN dispatch IN THIS-PROCEDURE ('initialize':U). &ENDIF FCuDw = FALSE. /* ------ Triggers ---------------------------------------------------- */ ON END-ERROR OF {&INPUT-FELDER} IN BROWSE {&BROWSE-NAME} OR END-ERROR OF BROWSE {&BROWSE-NAME} DO: VSpeichern = FALSE. IF NOT VUpdate THEN DO: RUN new-state ( INPUT 'ENDE, MAIN':U ). RETURN NO-APPLY. END. END. ON LEFT-MOUSE-DOWN, RIGHT-MOUSE-DOWN, MIDDLE-MOUSE-DOWN OF BROWSE {&BROWSE-NAME} DO: DO WHILE TRUE: IF NOT VUpdate THEN LEAVE. XHandle = {&BROWSE-NAME}:CURRENT-COLUMN IN FRAME {&FRAME-NAME}. IF NOT VALID-HANDLE(XHandle) THEN XHandle = LAST-EVENT:WIDGET-LEAVE. IF VALID-HANDLE(XHandle) THEN DO: APPLY 'LEAVE' TO XHandle. RETURN. END. LEAVE. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* ********************** Internal Procedures *********************** */ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-row-available B-table-Win _ADM-ROW-AVAILABLE PROCEDURE adm-row-available : /*------------------------------------------------------------------------------ Purpose: Dispatched to this procedure when the Record- Source has a new row available. This procedure tries to get the new row (or foriegn keys) from the Record-Source and process it. Parameters: ------------------------------------------------------------------------------*/ /* Define variables needed by this internal procedure. */ {src/adm/template/row-head.i} /* Process the newly available records (i.e. display fields, open queries, and/or pass records on to any RECORD-TARGETS). */ {src/adm/template/row-end.i} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ANZEIGE B-table-Win PROCEDURE ANZEIGE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ VText = ''. IF AVAILABLE {&DATEI-NAME} THEN DO: VRecid = RECID({&DATEI-NAME}). VROWID = ROWID({&DATEI-NAME}). FIND GebRueck USE-INDEX GebRueck-k1 WHERE GebRueck.Firma = GVFirma AND GebRueck.Geb_Cd = SavGebKo.Geb_Cd NO-LOCK NO-ERROR. IF AVAILABLE GebRueck THEN VText = GebRueck.Bez. ELSE VText = FILL('?', 20). VBetrag = SavGebKo.Betrag_1 + SavGebKo.Betrag_2 + SavGebKo.Betrag_3. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ANZEIGE_DETAIL B-table-Win PROCEDURE ANZEIGE_DETAIL : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DO WITH FRAME {&FRAME-NAME}: F_Aufnr = XVAufnr. E_Adresse = ''. FIND Adresse USE-INDEX Adresse-k1 WHERE Adresse.Firma = AdFirma AND Adresse.Knr = Savko.Knr NO-LOCK NO-ERROR. E_Adresse = Adresse.Anschrift[05] + CHR(10) + Adresse.Anschrift[06] + CHR(10) + Adresse.Anschrift[07] + CHR(10) + Adresse.Anschrift[08] + CHR(10) + Adresse.Anschrift[09] + CHR(10) + Adresse.Anschrift[10] + CHR(10) + Adresse.Anschrift[11] + CHR(10) + Adresse.Anschrift[12]. DISPLAY F_Aufnr E_Adresse {&List-5}. F_WW = VTotal[01]. F_Gebinde = VTotal[11]. F_Recycling = VTotal[12]. F_MWST = VTotal[09]. F_Total = VTotal[10]. F_Skonto = 0. F_ZahBetr = 0. F_ZahSko = 0. F_Bezahlt = Savko.Bar_Betr. F_Skonto_Bez = Savko.Bar_Skonto. F_Saldo = F_Total - F_Bezahlt - F_Skonto. ARecid = RECID(Savko). FIND Kondi USE-INDEX Kondi-k1 WHERE Kondi.Kond = Savko.Kond AND Kondi.Sprcd = Adresse.Sprcd NO-LOCK NO-ERROR. IF AVAILABLE Kondi THEN DO: IF Kondi.Skonto[01] <> 0 THEN DO: Rundbetr = VTotal[02] * Kondi.Skonto[01] / 100. Rundcode = 1. RUN "v8/runden.p". F_Skonto = Rundbetr. END. END. Rundbetr = F_Total - F_Skonto. Rundcode = 1. RUN "v8/runden.p". F_Netto = Rundbetr. DISPLAY {&List-1}. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI B-table-Win _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 F-Main. IF THIS-PROCEDURE:PERSISTENT THEN DELETE PROCEDURE THIS-PROCEDURE. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE GEBINDE_KONTO B-table-Win PROCEDURE GEBINDE_KONTO : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR MW AS INT. DEF INPUT PARAMETER Art AS INT. DO WHILE SavGebKo.Kto_Cd1 <> '': IF SavGebKo.Anz_1 = 0 THEN LEAVE. FIND GebKonto USE-INDEX GebKonto-k1 WHERE GebKonto.Firma = GVFirma AND GebKonto.Geb_Cd = SavGebKo.Kto_Cd1 NO-LOCK. IF GebKonto.MWST_Art = 0 THEN MW = 11. IF GebKonto.MWST_Art = 2 THEN MW = GebKonto.MWST_Cd. IF GebKonto.MWST_Art = 1 THEN DO: FIND FIRST AufGKon USE-INDEX AufGKon-k1 WHERE AufGKon.Firma = GVFirma AND AufGKon.Aufnr = SavGebKo.Aufnr AND AufGKon.Geb_Cd = GebKonto.Geb_Cd NO-LOCK NO-ERROR. IF AVAILABLE AufGKon THEN MW = AufGKon.MWSt_Cd. ELSE MW = 11. END. FIND AufGKon USE-INDEX AufGKon-k1 WHERE AufGKon.Firma = GVFirma AND AufGKon.Aufnr = SavGebKo.Aufnr AND AufGKon.Geb_Cd = GebKonto.Geb_Cd AND AufGKon.MWSt_Cd = MW NO-ERROR. IF NOT AVAILABLE AufGKon THEN DO: CREATE AufGKon. ASSIGN AufGKon.Firma = SavGebKo.Firma AufGKon.Aufnr = SavGebKo.Aufnr AufGKon.Geb_Cd = GebKonto.Geb_Cd AufGKon.MWSt_Cd = MW AufGKon.Gebuehr = GebKonto.Gebuehr AufGKon.Depot = GebKonto.Depot AufGKon.Sort_Cd = GebKonto.Sort_Cd. END. IF Art = 1 THEN AufGKon.Eingang = AufGKon.Eingang + (SavGebKo.Anz_1 * SavGebKo.Menge). IF Art = 2 THEN AufGKon.Eingang = AufGKon.Eingang - (SavGebKo.Anz_1 * SavGebKo.Menge). AufGKon.Betrag = (AufGKon.Ausgang - AufGKon.Eingang) * (AufGKon.Depot + AufGKon.Gebuehr). LEAVE. END. DO WHILE SavGebKo.Kto_Cd2 <> '': IF SavGebKo.Anz_2 = 0 THEN LEAVE. FIND GebKonto USE-INDEX GebKonto-k1 WHERE GebKonto.Firma = GVFirma AND GebKonto.Geb_Cd = SavGebKo.Kto_Cd2 NO-LOCK. IF GebKonto.MWST_Art = 0 THEN MW = 11. IF GebKonto.MWST_Art = 2 THEN MW = GebKonto.MWST_Cd. IF GebKonto.MWST_Art = 1 THEN DO: FIND FIRST AufGKon USE-INDEX AufGKon-k1 WHERE AufGKon.Firma = GVFirma AND AufGKon.Aufnr = SavGebKo.Aufnr AND AufGKon.Geb_Cd = GebKonto.Geb_Cd NO-LOCK NO-ERROR. IF AVAILABLE AufGKon THEN MW = AufGKon.MWSt_Cd. ELSE MW = 11. END. FIND AufGKon USE-INDEX AufGKon-k1 WHERE AufGKon.Firma = GVFirma AND AufGKon.Aufnr = SavGebKo.Aufnr AND AufGKon.Geb_Cd = GebKonto.Geb_Cd AND AufGKon.MWSt_Cd = MW NO-ERROR. IF NOT AVAILABLE AufGKon THEN DO: CREATE AufGKon. ASSIGN AufGKon.Firma = SavGebKo.Firma AufGKon.Aufnr = SavGebKo.Aufnr AufGKon.Geb_Cd = GebKonto.Geb_Cd AufGKon.MWSt_Cd = MW AufGKon.Gebuehr = GebKonto.Gebuehr AufGKon.Depot = GebKonto.Depot AufGKon.Sort_Cd = GebKonto.Sort_Cd. END. IF Art = 1 THEN AufGKon.Eingang = AufGKon.Eingang + (SavGebKo.Anz_2 * SavGebKo.Menge). IF Art = 2 THEN AufGKon.Eingang = AufGKon.Eingang - (SavGebKo.Anz_2 * SavGebKo.Menge). AufGKon.Betrag = (AufGKon.Ausgang - AufGKon.Eingang) * (AufGKon.Depot + AufGKon.Gebuehr). LEAVE. END. DO WHILE SavGebKo.Kto_Cd3 <> '': IF SavGebKo.Anz_3 = 0 THEN LEAVE. FIND GebKonto USE-INDEX GebKonto-k1 WHERE GebKonto.Firma = GVFirma AND GebKonto.Geb_Cd = SavGebKo.Kto_Cd3 NO-LOCK. IF GebKonto.MWST_Art = 0 THEN MW = 11. IF GebKonto.MWST_Art = 2 THEN MW = GebKonto.MWST_Cd. IF GebKonto.MWST_Art = 1 THEN DO: FIND FIRST AufGKon USE-INDEX AufGKon-k1 WHERE AufGKon.Firma = GVFirma AND AufGKon.Aufnr = SavGebKo.Aufnr AND AufGKon.Geb_Cd = GebKonto.Geb_Cd NO-LOCK NO-ERROR. IF AVAILABLE AufGKon THEN MW = AufGKon.MWSt_Cd. ELSE MW = 11. END. FIND AufGKon USE-INDEX AufGKon-k1 WHERE AufGKon.Firma = GVFirma AND AufGKon.Aufnr = SavGebKo.Aufnr AND AufGKon.Geb_Cd = GebKonto.Geb_Cd AND AufGKon.MWSt_Cd = MW NO-ERROR. IF NOT AVAILABLE AufGKon THEN DO: CREATE AufGKon. ASSIGN AufGKon.Firma = SavGebKo.Firma AufGKon.Aufnr = SavGebKo.Aufnr AufGKon.Geb_Cd = GebKonto.Geb_Cd AufGKon.MWSt_Cd = MW AufGKon.Gebuehr = GebKonto.Gebuehr AufGKon.Depot = GebKonto.Depot AufGKon.Sort_Cd = GebKonto.Sort_Cd. END. IF Art = 1 THEN AufGKon.Eingang = AufGKon.Eingang + (SavGebKo.Anz_3 * SavGebKo.Menge). IF Art = 2 THEN AufGKon.Eingang = AufGKon.Eingang - (SavGebKo.Anz_3 * SavGebKo.Menge). AufGKon.Betrag = (AufGKon.Ausgang - AufGKon.Eingang) * (AufGKon.Depot + AufGKon.Gebuehr). LEAVE. END. RETURN. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-assign-record B-table-Win PROCEDURE local-assign-record : /*------------------------------------------------------------------------------ Purpose: Override standard ADM method Notes: ------------------------------------------------------------------------------*/ RUN GEBINDE_KONTO ( INPUT 2 ). RUN dispatch IN THIS-PROCEDURE ( INPUT 'assign-record':U ) . RUN GEBINDE_KONTO ( INPUT 1 ). XVAufnr = SavGebKo.Aufnr. RUN "v8/savkotot.p". IF VNeu THEN DO: END. ELSE DO: END. ASSIGN SavGebKo.Betrag_1 = SavGebKo.Anz_1 * SavGebKo.Wert_1 * SavGebKo.Menge SavGebKo.Betrag_2 = SavGebKo.Anz_2 * SavGebKo.Wert_2 * SavGebKo.Menge SavGebKo.Betrag_3 = SavGebKo.Anz_3 * SavGebKo.Wert_3 * SavGebKo.Menge. VBetrag = SavGebKo.Betrag_1 + SavGebKo.Betrag_2 + SavGebKo.Betrag_3. RUN dispatch IN THIS-PROCEDURE ('display-fields':U). RUN ANZEIGE_DETAIL. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-display-fields B-table-Win PROCEDURE local-display-fields : /*------------------------------------------------------------------------------ Purpose: Override standard ADM method Notes: ------------------------------------------------------------------------------*/ RUN dispatch IN THIS-PROCEDURE ( INPUT 'display-fields':U ) . IF SavGebKo.Menge <> 0 THEN DO: SavGebKo.Menge:BGCOLOR IN BROWSE {&BROWSE-NAME} = 8. VText:BGCOLOR IN BROWSE {&BROWSE-NAME} = 8. VBetrag:BGCOLOR IN BROWSE {&BROWSE-NAME} = 8. END. ELSE DO: SavGebKo.Menge:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15. VText:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15. VBetrag:BGCOLOR IN BROWSE {&BROWSE-NAME} = 15. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-hide B-table-Win PROCEDURE local-hide : /*------------------------------------------------------------------------------ Purpose: Override standard ADM method Notes: ------------------------------------------------------------------------------*/ RUN dispatch IN THIS-PROCEDURE ( INPUT 'hide':U ) . FQOpen = FALSE. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-initialize B-table-Win PROCEDURE local-initialize : /*------------------------------------------------------------------------------ Purpose: Override standard ADM method Notes: ------------------------------------------------------------------------------*/ RUN dispatch IN THIS-PROCEDURE ( INPUT 'initialize':U ) . DO WITH FRAME {&FRAME-NAME}: CB-Zahart:DELIMITER = "|". XZahart = ''. ok = TRUE. xx = 0. DO WHILE ok: ok = CB-Zahart:DELETE(1). END. FOR EACH Tabel USE-INDEX Tabel-k1 WHERE Tabel.Firma = GVFirma AND Tabel.RecArt = 'ZAHART' AND Tabel.CodeC = '' AND Tabel.Sprcd = 1 NO-LOCK: ok = CB-Zahart:ADD-LAST(Tabel.Bez1). XZahart = XZahart + STRING(Tabel.CodeI,"999|"). END. ix = 1. CB-Zahart:SCREEN-VALUE = CB-Zahart:ENTRY(ix). VZahart = INTEGER(ENTRY(ix, XZahart, "|")). FIND Tabel USE-INDEX Tabel-k1 WHERE Tabel.Firma = GVFirma AND Tabel.RecArt = 'ZAHART' AND Tabel.CodeC = '' AND Tabel.CodeI = VZahart AND Tabel.Sprcd = 1 NO-LOCK. VKonto = Tabel.Bez2. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-open-query B-table-Win PROCEDURE local-open-query : /*------------------------------------------------------------------------------ Purpose: Override standard ADM method Notes: ------------------------------------------------------------------------------*/ QOpen = FALSE. Vorhanden = FALSE. RUN dispatch IN THIS-PROCEDURE ( INPUT 'open-query':U ). QOpen = TRUE. DO WHILE TRUE WITH FRAME {&FRAME-NAME}: IF NUM-RESULTS("{&BROWSE-NAME}":U) = ? THEN LEAVE. IF NUM-RESULTS("{&BROWSE-NAME}":U) = 0 THEN LEAVE. Vorhanden = TRUE. LEAVE. END. DO WITH FRAME {&FRAME-NAME}: IF Vorhanden THEN DO: APPLY 'VALUE-CHANGED' TO BROWSE {&BROWSE-NAME}. END. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE local-view B-table-Win PROCEDURE local-view : /*------------------------------------------------------------------------------ Purpose: Override standard ADM method Notes: ------------------------------------------------------------------------------*/ IF XVAufnr = 0 THEN DO: RUN new-state ( INPUT 'seite_1, MAIN':U ). RETURN NO-APPLY. END. FIND Savko USE-INDEX Savko-k1 WHERE Savko.Firma = GVFirma AND Savko.Aufnr = XVAufnr NO-LOCK NO-ERROR. IF NOT AVAILABLE Savko THEN DO: RUN new-state ( INPUT 'seite_1, MAIN':U ). RETURN NO-APPLY. END. RUN "v8/savkotot.p". RUN dispatch IN THIS-PROCEDURE ( INPUT 'view':U ) . FQOpen = TRUE. DO WITH FRAME {&FRAME-NAME}: RUN dispatch IN THIS-PROCEDURE ('open-query':U). RUN dispatch IN THIS-PROCEDURE ('disable-fields':U). RUN ANZEIGE_DETAIL. IF NUM-RESULTS("{&BROWSE-NAME}":U) = ? THEN LEAVE. IF NUM-RESULTS("{&BROWSE-NAME}":U) = 0 THEN LEAVE. {&BROWSE-NAME}:SELECT-FOCUSED-ROW(). APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}. RETURN NO-APPLY. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE send-records B-table-Win _ADM-SEND-RECORDS PROCEDURE send-records : /*------------------------------------------------------------------------------ Purpose: Send record ROWID's for all tables used by this file. Parameters: see template/snd-head.i ------------------------------------------------------------------------------*/ /* Define variables needed by this internal procedure. */ {src/adm/template/snd-head.i} /* For each requested table, put it's ROWID in the output list. */ {src/adm/template/snd-list.i "SavGebKo"} /* Deal with any unexpected table requests before closing. */ {src/adm/template/snd-end.i} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE state-changed B-table-Win PROCEDURE state-changed : /* ----------------------------------------------------------- Purpose: Parameters: Notes: -------------------------------------------------------------*/ DEFINE INPUT PARAMETER p-issuer-hdl AS HANDLE NO-UNDO. DEFINE INPUT PARAMETER p-state AS CHARACTER NO-UNDO. CASE p-state: WHEN 'first-record' THEN DO: RUN ANZEIGE. RUN set-attribute-list('Query-Position=':U + p-state). RETURN NO-APPLY. END. WHEN 'browser_entry' THEN DO: APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}. RETURN NO-APPLY. END. {src/adm/template/bstates.i} END CASE. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME