&ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2 &ANALYZE-RESUME /* Connected Databases anadat PROGRESS */ &Scoped-define WINDOW-NAME CURRENT-WINDOW {adecomm/appserv.i} /* Temp-Table and Buffer definitions */ DEFINE TEMP-TABLE RowObject NO-UNDO {"d-aktpreis.i"}. &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS vTableWin /*------------------------------------------------------------------------ File: Description: from viewer.w - Template for SmartDataViewer objects Input Parameters: Output Parameters: ------------------------------------------------------------------------*/ /* 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 ************************** */ /* Komma-Trennzeichen */ /* Keyfelder werden beim Mutieren nicht "Enabled" */ &Scoped-define ERSTES_FELD Ab_Datum &Scoped-define LETZTES_FELD Bemerkung &Scoped-define KEY_FELDER Gruppe &Scoped-define NUR_LESEN Aktion { incl/viwdefinition.i } DEF VAR lAktpreis AS LOG NO-UNDO. DEF VAR BegDat AS DATE NO-UNDO. {src/adm2/widgetprto.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK /* ******************** Preprocessor Definitions ******************** */ &Scoped-define PROCEDURE-TYPE SmartDataViewer &Scoped-define DB-AWARE no &Scoped-define ADM-CONTAINER FRAME &Scoped-define ADM-SUPPORTED-LINKS Data-Target,Update-Source,TableIO-Target,GroupAssign-Source,GroupAssign-Target /* Include file with RowObject temp-table definition */ &Scoped-define DATA-FIELD-DEFS "d-aktpreis.i" /* Name of designated FRAME-NAME and/or first browse and/or first query */ &Scoped-define FRAME-NAME F-Main /* Standard List Definitions */ &Scoped-Define ENABLED-FIELDS RowObject.Gruppe RowObject.Ab_Datum ~ RowObject.Bis_Datum RowObject.Wert RowObject.Bemerkung RowObject.Aktion &Scoped-define ENABLED-TABLES RowObject &Scoped-define FIRST-ENABLED-TABLE RowObject &Scoped-Define ENABLED-OBJECTS RECT-6 CB_Art &Scoped-Define DISPLAYED-FIELDS RowObject.Gruppe RowObject.Ab_Datum ~ RowObject.Bis_Datum RowObject.Jahr RowObject.Grp RowObject.Art ~ RowObject.VK_Netto RowObject.VK_Brutto RowObject.Marge RowObject.VK_Normal ~ RowObject.Artnr RowObject.Firma RowObject.Inhalt RowObject.Wert ~ RowObject.Bemerkung RowObject.Aktion &Scoped-define DISPLAYED-TABLES RowObject &Scoped-define FIRST-DISPLAYED-TABLE RowObject &Scoped-Define DISPLAYED-OBJECTS CB_Art /* Custom List Definitions */ /* ADM-ASSIGN-FIELDS,List-2,List-3,List-4,List-5,List-6 */ /* _UIB-PREPROCESSOR-BLOCK-END */ &ANALYZE-RESUME /* *********************** Control Definitions ********************** */ /* Definitions of the field level widgets */ DEFINE VARIABLE CB_Art AS CHARACTER FORMAT "X(256)":U LABEL "Abschlagsart" VIEW-AS COMBO-BOX INNER-LINES 5 LIST-ITEM-PAIRS "Betrag","0", "Prozent","1" DROP-DOWN-LIST SIZE 17 BY 1 BGCOLOR 15 NO-UNDO. DEFINE RECTANGLE RECT-6 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 70 BY 6.71. /* ************************ Frame Definitions *********************** */ DEFINE FRAME F-Main RowObject.Gruppe AT ROW 1.52 COL 23 COLON-ALIGNED WIDGET-ID 18 VIEW-AS FILL-IN NATIVE SIZE 35 BY 1 BGCOLOR 15 RowObject.Ab_Datum AT ROW 2.52 COL 23 COLON-ALIGNED WIDGET-ID 2 LABEL "gültig von/bis Datum" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 15 RowObject.Bis_Datum AT ROW 2.52 COL 42 COLON-ALIGNED WIDGET-ID 12 LABEL "/" VIEW-AS FILL-IN NATIVE SIZE 16 BY 1 BGCOLOR 15 CB_Art AT ROW 3.52 COL 23 COLON-ALIGNED WIDGET-ID 36 RowObject.Jahr AT ROW 4 COL 58 COLON-ALIGNED WIDGET-ID 22 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.Grp AT ROW 4 COL 58 COLON-ALIGNED WIDGET-ID 16 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.Art AT ROW 4 COL 58 COLON-ALIGNED WIDGET-ID 6 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.VK_Netto AT ROW 4 COL 58 COLON-ALIGNED WIDGET-ID 28 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.VK_Brutto AT ROW 4 COL 58 COLON-ALIGNED WIDGET-ID 26 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.Marge AT ROW 4 COL 58 COLON-ALIGNED WIDGET-ID 24 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.VK_Normal AT ROW 4 COL 58 COLON-ALIGNED WIDGET-ID 30 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.Artnr AT ROW 4 COL 58 COLON-ALIGNED WIDGET-ID 8 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.Firma AT ROW 4 COL 58 COLON-ALIGNED WIDGET-ID 14 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.Inhalt AT ROW 4 COL 58 COLON-ALIGNED WIDGET-ID 20 VIEW-AS FILL-IN NATIVE SIZE 4 BY 1 BGCOLOR 15 NO-TAB-STOP RowObject.Wert AT ROW 4.52 COL 23 COLON-ALIGNED WIDGET-ID 32 LABEL "Abschlag" VIEW-AS FILL-IN NATIVE SIZE 17 BY 1 BGCOLOR 15 RowObject.Bemerkung AT ROW 5.52 COL 23 COLON-ALIGNED WIDGET-ID 10 VIEW-AS FILL-IN NATIVE SIZE 35 BY 1 BGCOLOR 15 RowObject.Aktion AT ROW 6.52 COL 23 COLON-ALIGNED WIDGET-ID 4 VIEW-AS FILL-IN NATIVE SIZE 35 BY 1 BGCOLOR 15 RECT-6 AT ROW 1.24 COL 2 WIDGET-ID 34 WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY USE-DICT-EXPS SIDE-LABELS NO-UNDERLINE THREE-D NO-AUTO-VALIDATE AT COL 1 ROW 1 SCROLLABLE WIDGET-ID 100. /* *********************** Procedure Settings ************************ */ &ANALYZE-SUSPEND _PROCEDURE-SETTINGS /* Settings for THIS-PROCEDURE Type: SmartDataViewer Data Source: "d-aktpreis.w" Allow: Basic,DB-Fields,Smart Container Links: Data-Target,Update-Source,TableIO-Target,GroupAssign-Source,GroupAssign-Target Frames: 1 Add Fields to: Neither Other Settings: PERSISTENT-ONLY COMPILE APPSERVER Temp-Tables and Buffers: TABLE: RowObject D "?" NO-UNDO ADDITIONAL-FIELDS: {d-aktpreis.i} END-FIELDS. END-TABLES. */ /* 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 vTableWin ASSIGN HEIGHT = 7.33 WIDTH = 72.6. /* END WINDOW DEFINITION */ */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB vTableWin /* ************************* Included-Libraries *********************** */ {src/adm2/viewer.i} /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* *********** Runtime Attributes and AppBuilder Settings *********** */ &ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES /* SETTINGS FOR WINDOW vTableWin VISIBLE,,RUN-PERSISTENT */ /* SETTINGS FOR FRAME F-Main NOT-VISIBLE FRAME-NAME Size-to-Fit */ ASSIGN FRAME F-Main:SCROLLABLE = FALSE FRAME F-Main:HIDDEN = TRUE. /* SETTINGS FOR FILL-IN RowObject.Ab_Datum IN FRAME F-Main EXP-LABEL */ /* SETTINGS FOR FILL-IN RowObject.Art IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.Art:HIDDEN IN FRAME F-Main = TRUE RowObject.Art:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Artnr IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.Artnr:HIDDEN IN FRAME F-Main = TRUE RowObject.Artnr:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Bis_Datum IN FRAME F-Main EXP-LABEL */ /* SETTINGS FOR FILL-IN RowObject.Firma IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.Firma:HIDDEN IN FRAME F-Main = TRUE RowObject.Firma:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Grp IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.Grp:HIDDEN IN FRAME F-Main = TRUE RowObject.Grp:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Inhalt IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.Inhalt:HIDDEN IN FRAME F-Main = TRUE RowObject.Inhalt:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Jahr IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.Jahr:HIDDEN IN FRAME F-Main = TRUE RowObject.Jahr:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Marge IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.Marge:HIDDEN IN FRAME F-Main = TRUE RowObject.Marge:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.VK_Brutto IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.VK_Brutto:HIDDEN IN FRAME F-Main = TRUE RowObject.VK_Brutto:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.VK_Netto IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.VK_Netto:HIDDEN IN FRAME F-Main = TRUE RowObject.VK_Netto:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.VK_Normal IN FRAME F-Main NO-ENABLE */ ASSIGN RowObject.VK_Normal:HIDDEN IN FRAME F-Main = TRUE RowObject.VK_Normal:READ-ONLY IN FRAME F-Main = TRUE. /* SETTINGS FOR FILL-IN RowObject.Wert IN FRAME F-Main EXP-LABEL */ /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &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 SELF-NAME CB_Art &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB_Art vTableWin ON VALUE-CHANGED OF CB_Art IN FRAME F-Main /* Abschlagsart */ DO: IF NOT FMut THEN SELF:SCREEN-VALUE = rowObject.Art:SCREEN-VALUE NO-ERROR. rowObject.Art:SCREEN-VALUE = SELF:SCREEN-VALUE. IF Fmut THEN rowObject.Art:MODIFIED = TRUE. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK vTableWin /* *************************** Main Block *************************** */ { incl/viwmainblock.i } FIND Steuer NO-LOCK USE-INDEX Steuer-k1 WHERE Steuer.Firma = Firma NO-ERROR. IF AVAILABLE Steuer THEN DO: IF Steuer.Aktionspreis = 0 THEN lAktpreis = TRUE. /* Preisgruppen */ ELSE lAktpreis = FALSE. /* Kundengruppen */ END. &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN RUN initializeObject. &ENDIF /************************ INTERNAL PROCEDURES ********************/ /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME /* ********************** Internal Procedures *********************** */ &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE addRecord vTableWin PROCEDURE addRecord : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DYNAMIC-FUNCTION('setFlagAbbruch':U, TRUE, ProgName) NO-ERROR. RETURN NO-APPLY. /* FNeu = TRUE. FMut = TRUE. FDisp = TRUE. RUN SUPER. */ /* Code placed here will execute AFTER standard behavior. */ END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE cancelRecord vTableWin PROCEDURE cancelRecord : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ FCancel = TRUE. RUN SUPER. /* Code placed here will execute AFTER standard behavior. */ END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE copyRecord vTableWin PROCEDURE copyRecord : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DYNAMIC-FUNCTION('setFlagAbbruch':U, TRUE, ProgName) NO-ERROR. RETURN NO-APPLY. /* FNeu = TRUE. FMut = TRUE. FCopy = TRUE. FDisp = TRUE. RUN SUPER. */ END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE deleteRecord vTableWin PROCEDURE deleteRecord : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR Ja AS LOG NO-UNDO. DEF VAR cGruppen AS CHAR NO-UNDO. DEF VAR Artnr AS INT NO-UNDO. DEF VAR Inhalt AS INT NO-UNDO. DEF VAR Jahr AS INT NO-UNDO. DEF VAR Ab_Datum AS DATE NO-UNDO. DEF VAR Aktion AS CHAR NO-UNDO. DEF VAR i1 AS INT NO-UNDO. DEF VAR Grp AS INT NO-UNDO. DO WITH FRAME {&FRAME-NAME}: Ja = ?. MESSAGE 'Möchten Sie die ganze Aktion löschen (Ja)' SKIP 'Nur den markierten Satz (Nein)' SKIP 'gar nichts löschen (Abbrechen)' VIEW-AS ALERT-BOX QUESTION BUTTONS YES-NO-CANCEL UPDATE Ja. IF Ja = ? THEN DO: RUN 'TOOLBAR' IN hKontainer ( INPUT 'CANCEL':U ). RETURN NO-APPLY. END. Artnr = INTEGER(rowObject.Artnr :SCREEN-VALUE). Inhalt = INTEGER(rowObject.Inhalt :SCREEN-VALUE). Jahr = INTEGER(rowObject.Jahr :SCREEN-VALUE). Ab_Datum = DATE (rowObject.Ab_Datum:SCREEN-VALUE). Aktion = rowObject.Aktion :SCREEN-VALUE . cGruppen = ''. IF Ja = FALSE THEN DO: cGruppen = rowObject.Grp:SCREEN-VALUE. RUN SUPER. END. IF Ja = TRUE THEN DO: REPEAT TRANSACTION: FOR EACH AktPreis USE-INDEX AktPreis-k1 WHERE AktPreis.Firma = Firma AND AktPreis.Artnr = Artnr AND AktPreis.Inhalt = Inhalt AND AktPreis.Jahr = Jahr AND AktPreis.Ab_Datum = Ab_Datum: IF cGruppen <> '' THEN cGruppen = cGruppen + ';'. cGruppen = cGruppen + STRING(AktPreis.Grp,'999'). DELETE AktPreis. END. LEAVE. END. RUN SET_OPENFLAG IN hDaten ( TRUE ). END. IF lAktPreis THEN DO: /* Preisgruppen */ REPEAT TRANSACTION WITH FRAME {&FRAME-NAME}: DO i1 = 1 TO NUM-ENTRIES(cGruppen, ';'): Grp = INTEGER(ENTRY(i1, cGruppen, ';')). FOR EACH ArtPreis USE-INDEX ArtPreis-k1 WHERE ArtPreis.Firma = Firma AND ArtPreis.Artnr = Artnr AND ArtPreis.Inhalt = Inhalt AND ArtPreis.Jahr = Jahr AND ArtPreis.Preis_Grp = Grp AND ArtPreis.Ab_Datum = Ab_Datum AND ArtPreis.Aktion = TRUE : DELETE ArtPreis. END. END. LEAVE. END. RUN SET_OPENFLAG IN hDaten ( TRUE ). END. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disableFields vTableWin PROCEDURE disableFields : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEFINE INPUT PARAMETER pcFieldType AS CHARACTER NO-UNDO. DO WITH FRAME {&FRAME-NAME}: END. RUN SUPER( INPUT pcFieldType). IF NOT VALID-HANDLE(Fenster) THEN Fenster = FRAME {&FRAME-NAME}:CURRENT-ITERATION. RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&ENABLED-FIELDS}', INPUT TRUE ). IF NUM-ENTRIES('{&KEY_FELDER}', ',') > 0 THEN DO: RUN FARBE_FELDER ( INPUT Fenster, INPUT '{&KEY_FELDER}', INPUT 15 ). END. DO WITH FRAME {&FRAME-NAME}: END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI vTableWin _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 displayFields vTableWin PROCEDURE displayFields : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEFINE INPUT PARAMETER pcColValues AS CHARACTER NO-UNDO. IF NOT FDisp THEN DO: FDisp = TRUE. RETURN. END. IF FCancel THEN pcColValues = OldColValues. IF NOT FNeu THEN OldColValues = pcColValues. OldColList = DYNAMIC-FUNCTION('getDisplayedFields':U). IF FNeu THEN RUN FEHLWERTE ( INPUT-OUTPUT pcColValues ). DO WITH FRAME {&FRAME-NAME}: END. RUN SUPER( INPUT pcColValues). FCancel = FALSE. DO WITH FRAME {&FRAME-NAME}: CB_Art:SCREEN-VALUE = rowObject.Art:SCREEN-VALUE NO-ERROR. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableFields vTableWin PROCEDURE enableFields : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ /* Code placed here will execute PRIOR to standard behavior. */ /* RUN SUPER. */ IF NOT VALID-HANDLE(Fenster) THEN Fenster = FRAME {&FRAME-NAME}:CURRENT-ITERATION. RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&ENABLED-FIELDS}', INPUT FALSE ). IF NUM-ENTRIES('{&NUR_LESEN}', ',') > 0 THEN DO: RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&NUR_LESEN}', INPUT TRUE ). END. DO WITH FRAME {&FRAME-NAME}: END. IF FNeu THEN RETURN. IF NUM-ENTRIES('{&KEY_FELDER}', ',') > 0 THEN DO: RUN SCHUETZE_FELDER ( INPUT Fenster, INPUT '{&KEY_FELDER}', INPUT TRUE ). END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject vTableWin PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ /* Code placed here will execute PRIOR to standard behavior. */ RUN SUPER. { incl/viwenableobject.i } END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_FELD_TEST vTableWin PROCEDURE ENTRY_FELD_TEST : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ { incl/viwentryfeldtest.i } DO WITH FRAME {&FRAME-NAME}: CASE FeldName: END CASE. END. RETURN ''. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE FEHLWERTE vTableWin PROCEDURE FEHLWERTE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF INPUT-OUTPUT PARAMETER pcColValues AS CHAR NO-UNDO. DEF VAR i1 AS INT NO-UNDO. IF FCancel THEN RETURN. IF NOT FCopy THEN DO WITH FRAME {&FRAME-NAME}: /* i1 = LOOKUP('Feld', oldColList, ',') + 1. */ /* ENTRY(i1, pcColValues, CHR(1)) = 'Fehlwert' NO-ERROR. */ END. IF FCopy THEN DO: END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE LEAVE_FELD_TEST vTableWin PROCEDURE LEAVE_FELD_TEST : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ { incl/viwleavefeldtest.i } DO WHILE FNeu WITH FRAME {&FRAME-NAME}: CASE FeldName: END CASE. LEAVE. END. DO WHILE TRUE WITH FRAME {&FRAME-NAME}: CASE FeldName: END CASE. LEAVE. END. IF LOOKUP(FeldName, '{&LETZTES_FELD}', ',') > 0 THEN DO: DO WHILE TRUE: IF KEYFUNCTION(LKY) = 'TAB' THEN LEAVE. IF KEYFUNCTION(LKY) = 'RETURN' THEN LEAVE. IF KEYFUNCTION(LKY) = 'F9' THEN LEAVE. RETURN ''. END. APPLY 'ALT-S'. RETURN 'APPLY'. END. RETURN ''. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE RETURN_FELD vTableWin PROCEDURE RETURN_FELD : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ { incl/viwreturnfeld.i } END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE TEST_EINGABEN vTableWin PROCEDURE TEST_EINGABEN : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF OUTPUT PARAMETER opJa AS LOG NO-UNDO. DEF VAR eHandle AS HANDLE NO-UNDO. DEF VAR cString AS CHAR NO-UNDO. DEF VAR iNummer AS INT NO-UNDO. opJa = FALSE. eHandle = ?. IF NOT FMut THEN RETURN. AAA000: DO WHILE TRUE WITH FRAME {&FRAME-NAME}: LEAVE. END. IF VALID-HANDLE(eHandle) THEN DO: APPLY 'ENTRY' TO eHandle. RETURN NO-APPLY. END. opJa = TRUE. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE updateMode vTableWin PROCEDURE updateMode : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEFINE INPUT PARAMETER pcMode AS CHARACTER NO-UNDO. CASE pcMode: WHEN 'updateBegin' THEN DO: END. WHEN 'updateEnd' THEN DO: END. END. RUN SUPER( INPUT pcMode). CASE pcMode: WHEN 'updateBegin' THEN DO: FMut = TRUE. BegDat = DATE(rowObject.Ab_Datum:SCREEN-VALUE IN FRAME {&FRAME-NAME}) NO-ERROR. END. WHEN 'updateEnd' THEN DO: FNeu = FALSE. FMut = FALSE. FCopy = FALSE. END. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE updateRecord vTableWin PROCEDURE updateRecord : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR Artnr AS INT NO-UNDO. DEF VAR Inhalt AS INT NO-UNDO. DEF VAR Jahr AS INT NO-UNDO. DEF VAR Grp AS INT NO-UNDO. DEF VAR Aktion AS CHAR NO-UNDO. DEF VAR AbDatum AS DATE NO-UNDO. DEF VAR cArtikel AS CHAR NO-UNDO. DEF VAR cPreisGrp AS CHAR NO-UNDO. DEF VAR Art AS INT NO-UNDO. DEF VAR EP AS DEC DECIMALS 4 NO-UNDO. DEF VAR Wert AS DEC DECIMALS 4 NO-UNDO. DEF VAR VK_Normal AS DEC DECIMALS 4 NO-UNDO. DEF VAR Bru_Netto AS LOG NO-UNDO. DEF VAR hArtPreis AS HANDLE NO-UNDO. DEF VAR hNetto AS HANDLE NO-UNDO. DEF VAR hBrutto AS HANDLE NO-UNDO. DEF VAR hMarge AS HANDLE NO-UNDO. DEF VAR hDatum AS HANDLE NO-UNDO. DO WITH FRAME {&FRAME-NAME}: Artnr = INTEGER(rowObject.Artnr:SCREEN-VALUE ). Inhalt = INTEGER(rowObject.Inhalt:SCREEN-VALUE ). Jahr = INTEGER(rowObject.Jahr:SCREEN-VALUE ). Grp = INTEGER(rowObject.Grp:SCREEN-VALUE ). Art = INTEGER(rowObject.Art:SCREEN-VALUE ). Aktion = rowObject.Aktion:SCREEN-VALUE . AbDatum = DATE (rowObject.Ab_Datum:SCREEN-VALUE). Wert = DECIMAL(rowObject.Wert :SCREEN-VALUE). VK_Normal = DECIMAL(rowObject.VK_Normal:SCREEN-VALUE). END. FNeu = FALSE. FCopy = FALSE. RUN SUPER. IF NOT lAktPreis THEN RETURN. FIND Artst USE-INDEX Artst-k1 WHERE Artst.Firma = Firma AND Artst.Artnr = Artnr AND Artst.Inhalt = Inhalt AND Artst.Jahr = Jahr NO-LOCK NO-ERROR. EP = Artst.Listen_EP. IF EP = 0 THEN EP = Artst.LEP. hArtPreis = BUFFER ArtPreis:HANDLE. hNetto = hArtPreis:BUFFER-FIELD('VK_Netto') . hBrutto = hArtPreis:BUFFER-FIELD('VK_Brutto') . hMarge = hArtPreis:BUFFER-FIELD('Marge') . hDatum = hArtPreis:BUFFER-FIELD('Ab_Datum'). REPEAT TRANSACTION: RUN FIND_PREISGRUPPE ( INPUT Grp, OUTPUT cPreisGrp ) NO-ERROR. IF cPreisGrp = '' THEN LEAVE. IF INTEGER(ENTRY(3, cPreisGrp, CHR(01))) = 1 THEN Bru_Netto = TRUE. ELSE Bru_Netto = FALSE. FOR EACH ArtPreis USE-INDEX ArtPreis-k1 WHERE ArtPreis.Firma = Firma AND ArtPreis.Artnr = Artnr AND ArtPreis.Inhalt = Inhalt AND ArtPreis.Jahr = Jahr AND ArtPreis.Preis_Grp = Grp AND ArtPreis.Ab_Datum = BegDat AND ArtPreis.Aktion = TRUE : IF Bru_Netto THEN DO: IF Art = 0 THEN ArtPreis.VK_Brutto = VK_Normal - Wert. IF Art = 1 THEN ArtPreis.VK_Brutto = VK_Normal * (100 - Wert) / 100. RUN RUNDEN ( INPUT 1, INPUT-OUTPUT ArtPreis.VK_Brutto ). Art = 2. END. ELSE DO: IF Art = 0 THEN ArtPreis.VK_Netto = VK_Normal - Wert. IF Art = 1 THEN ArtPreis.VK_Netto = VK_Normal * (100 - Wert) / 100. /* RUN RUNDEN ( INPUT 1, INPUT-OUTPUT ArtPreis.VK_Netto ). */ Art = 1. END. RUN ARTPREISRECHNEN ( INPUT Art, INPUT hNetto , INPUT hBrutto, INPUT hMarge , INPUT hDatum , INPUT 'CHF' ). ArtPreis.Ab_Datum = DATE (rowObject.Ab_Datum:SCREEN-VALUE ). ArtPreis.AktName = rowObject.Aktion:SCREEN-VALUE . IF EP <> 0 THEN ArtPreis.Marge = 100 - (EP * 100 / ArtPreis.VK_Netto). ELSE ArtPreis.Marge = 0. END. RELEASE ArtPreis. LEAVE. END. RUN REPOS_TABELLE IN hDaten NO-ERROR. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME