GeMIS_WEB/GUI/v-spezprei-art.w

&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-spezprei.i"}.



&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS vTableWin 
/*------------------------------------------------------------------------

  File:

  Description: from viewer.w - Template for SmartDataViewer objects

  Input Parameters:
      <none>

  Output Parameters:
      <none>

------------------------------------------------------------------------*/
/*          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  F_Knr
&Scoped-define LETZTES_FELD F_Wert
&Scoped-define KEY_FELDER   F_Knr,Menge
&Scoped-define NUR_LESEN    Kunde
&Scoped-define Eingabe      F_Knr,F_Wert

{ incl/viwdefinition.i }

DEF VAR lLeave          AS LOG  INIT TRUE           NO-UNDO.
DEF VAR cArtikel        AS CHAR                     NO-UNDO.
DEF VAR nKnr            AS INT                      NO-UNDO.
DEF VAR nArtnr          AS INT                      NO-UNDO.
DEF VAR nInhalt         AS INT                      NO-UNDO.
DEF VAR nJahr           AS INT                      NO-UNDO.
DEF VAR iKnr            AS INT                      NO-UNDO.

DEF TEMP-TABLE TSpezPrei    LIKE Spezprei.

{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-spezprei.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.Menge RowObject.Ab_Datum ~
RowObject.Bis_Datum RowObject.Kunde RowObject.Wert RowObject.VP_Normal ~
RowObject.Marge RowObject.AltPreis 
&Scoped-define ENABLED-TABLES RowObject
&Scoped-define FIRST-ENABLED-TABLE RowObject
&Scoped-Define ENABLED-OBJECTS F_Knr CB_Art F_Wert Btn_Kopieren ~
Btn_Loeschen Btn_Excel RECT-1 RECT-2 
&Scoped-Define DISPLAYED-FIELDS RowObject.Menge RowObject.Ab_Datum ~
RowObject.Bis_Datum RowObject.Kunde RowObject.Wert RowObject.VP_Normal ~
RowObject.Proz_Betr RowObject.Inhalt RowObject.Artnr RowObject.Firma ~
RowObject.PreisMut RowObject.Jahr RowObject.Knr RowObject.Marge ~
RowObject.AltPreis 
&Scoped-define DISPLAYED-TABLES RowObject
&Scoped-define FIRST-DISPLAYED-TABLE RowObject
&Scoped-Define DISPLAYED-OBJECTS F_Knr CB_Art F_Artnr F_Inhalt F_Jahr ~
F_Datum 

/* Custom List Definitions                                              */
/* ADM-ASSIGN-FIELDS,List-2,List-3,List-4,List-5,List-6                 */
&Scoped-define List-5 Btn_Kopieren Btn_Loeschen Btn_Excel 
&Scoped-define List-6 F_Artnr F_Inhalt F_Jahr F_Datum 

/* _UIB-PREPROCESSOR-BLOCK-END */
&ANALYZE-RESUME



/* ***********************  Control Definitions  ********************** */


/* Menu Definitions                                                     */
DEFINE MENU POPUP-MENU-F-Main 
       MENU-ITEM m_lschen_Spezialpreise_von_in LABEL "löschen Spezialpreise von inaktiven Artikeln".


/* Definitions of the field level widgets                               */
DEFINE BUTTON Btn_Excel 
     IMAGE-UP FILE "grafik/results%.ico":U
     IMAGE-INSENSITIVE FILE "grafik/results%.ico":U
     LABEL "Excel" 
     SIZE 7 BY 1.81.

DEFINE BUTTON Btn_Kopieren 
     LABEL "Ko&pieren" 
     SIZE 12 BY 1.

DEFINE BUTTON Btn_Loeschen 
     LABEL "&Löschen" 
     SIZE 12 BY 1.

DEFINE VARIABLE CB_Art AS CHARACTER FORMAT "X(256)":U 
     LABEL "Preisart" 
     VIEW-AS COMBO-BOX INNER-LINES 5
     LIST-ITEM-PAIRS "Prozent","P",
                     "Betrag","B"
     DROP-DOWN-LIST
     SIZE 16 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_Artnr AS INTEGER FORMAT "999999":U INITIAL 0 
     LABEL "zu Artikel" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 11 BY 1 TOOLTIP "Kopieren mit <RETURN>-Taste"
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_Datum AS DATE FORMAT "99.99.9999":U 
     LABEL "bis Datum" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 15 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_Inhalt AS INTEGER FORMAT "9999":U INITIAL 0 
     LABEL "/" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 8 BY 1 TOOLTIP "Kopieren mit <RETURN>-Taste"
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_Jahr AS INTEGER FORMAT "9999":U INITIAL 0 
     LABEL "/" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 8 BY 1 TOOLTIP "Kopieren mit <RETURN>-Taste"
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_Knr AS CHARACTER FORMAT "x(20)":U 
     LABEL "Kunde" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 15 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_Wert AS DECIMAL FORMAT "zzzz9.9999-":U INITIAL 0 
     LABEL "Wert" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 17 BY 1
     BGCOLOR 11  NO-UNDO.

DEFINE RECTANGLE RECT-1
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL   
     SIZE 150 BY 4.81.

DEFINE RECTANGLE RECT-2
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL   
     SIZE 150 BY 2.48.


/* ************************  Frame Definitions  *********************** */

DEFINE FRAME F-Main
     F_Knr AT ROW 1.52 COL 9 COLON-ALIGNED WIDGET-ID 22
     RowObject.Menge AT ROW 2.52 COL 24 COLON-ALIGNED WIDGET-ID 30
          LABEL "ab Menge" FORMAT "zzz,zz9"
          VIEW-AS FILL-IN NATIVE 
          SIZE 12 BY 1
          BGCOLOR 15 
     RowObject.Ab_Datum AT ROW 3.52 COL 24 COLON-ALIGNED WIDGET-ID 16
          LABEL "gültig ab/bis" FORMAT "99.99.9999"
          VIEW-AS FILL-IN NATIVE 
          SIZE 16 BY 1
          BGCOLOR 15 
     RowObject.Bis_Datum AT ROW 3.52 COL 48 COLON-ALIGNED WIDGET-ID 18
          LABEL "/" FORMAT "99.99.9999"
          VIEW-AS FILL-IN NATIVE 
          SIZE 16 BY 1
          BGCOLOR 15 
     RowObject.Kunde AT ROW 1.52 COL 24 COLON-ALIGNED NO-LABEL WIDGET-ID 26 FORMAT "x(60)"
          VIEW-AS FILL-IN NATIVE 
          SIZE 80 BY 1
          BGCOLOR 15  NO-TAB-STOP 
     CB_Art AT ROW 4.52 COL 24 COLON-ALIGNED WIDGET-ID 20
     RowObject.Wert AT ROW 4.52 COL 48 COLON-ALIGNED WIDGET-ID 34
          LABEL "Wert" FORMAT "zzz9.9999-"
          VIEW-AS FILL-IN NATIVE 
          SIZE 16 BY 1
          BGCOLOR 15 
     RowObject.VP_Normal AT ROW 1.52 COL 123 COLON-ALIGNED WIDGET-ID 32
          LABEL "aktueller VP"
          VIEW-AS FILL-IN NATIVE 
          SIZE 18 BY 1
          BGCOLOR 14  NO-TAB-STOP 
     F_Wert AT ROW 4.52 COL 83.4 COLON-ALIGNED WIDGET-ID 24
     Btn_Kopieren AT ROW 7.14 COL 4.6 WIDGET-ID 42
     F_Artnr AT ROW 7.14 COL 26 COLON-ALIGNED WIDGET-ID 46
     RowObject.Proz_Betr AT ROW 4 COL 100 WIDGET-ID 12
          LABEL "Proz_Betr"
          VIEW-AS TOGGLE-BOX
          SIZE 4 BY 1 NO-TAB-STOP 
     F_Inhalt AT ROW 7.14 COL 40 COLON-ALIGNED WIDGET-ID 50
     F_Jahr AT ROW 7.14 COL 51 COLON-ALIGNED WIDGET-ID 52
     RowObject.Inhalt AT ROW 4 COL 98 COLON-ALIGNED WIDGET-ID 6
          VIEW-AS FILL-IN NATIVE 
          SIZE 4 BY 1
          BGCOLOR 15  NO-TAB-STOP 
     Btn_Loeschen AT ROW 7.14 COL 65.4 WIDGET-ID 44
     F_Datum AT ROW 7.14 COL 88 COLON-ALIGNED WIDGET-ID 48
     RowObject.Artnr AT ROW 4 COL 98 COLON-ALIGNED WIDGET-ID 2
          VIEW-AS FILL-IN NATIVE 
          SIZE 4 BY 1
          BGCOLOR 15  NO-TAB-STOP 
     Btn_Excel AT ROW 6.76 COL 115.6 WIDGET-ID 40
     RowObject.Firma AT ROW 4 COL 98 COLON-ALIGNED WIDGET-ID 4
          VIEW-AS FILL-IN NATIVE 
          SIZE 4 BY 1
          BGCOLOR 15  NO-TAB-STOP 
     RowObject.PreisMut AT ROW 4 COL 98 COLON-ALIGNED WIDGET-ID 10
          VIEW-AS FILL-IN NATIVE 
          SIZE 4 BY 1
          BGCOLOR 15  NO-TAB-STOP 
     RowObject.Jahr AT ROW 4 COL 98 COLON-ALIGNED WIDGET-ID 8
          VIEW-AS FILL-IN NATIVE 
          SIZE 4 BY 1
          BGCOLOR 15  NO-TAB-STOP 
     RowObject.Knr AT ROW 4 COL 100 COLON-ALIGNED WIDGET-ID 14
          VIEW-AS FILL-IN NATIVE 
          SIZE 4 BY 1
          BGCOLOR 15  NO-TAB-STOP 
     RowObject.Marge AT ROW 4.52 COL 123 COLON-ALIGNED WIDGET-ID 28
          LABEL "Marge" FORMAT "zzzz9.9999-"
          VIEW-AS FILL-IN NATIVE 
          SIZE 18 BY 1
          BGCOLOR 14  NO-TAB-STOP 
     RowObject.AltPreis AT ROW 2.52 COL 123 COLON-ALIGNED WIDGET-ID 54
          LABEL "alter VP"
          VIEW-AS FILL-IN NATIVE 
          SIZE 18 BY 1
          BGCOLOR 14  NO-TAB-STOP 
     RECT-1 AT ROW 1.24 COL 2 WIDGET-ID 36
    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.

/* DEFINE FRAME statement is approaching 4K Bytes.  Breaking it up   */
DEFINE FRAME F-Main
     RECT-2 AT ROW 6.43 COL 2 WIDGET-ID 38
    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-spezprei.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-spezprei.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             = 8.67
         WIDTH              = 152.
/* 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 Custom                            */
ASSIGN 
       FRAME F-Main:SCROLLABLE       = FALSE
       FRAME F-Main:HIDDEN           = TRUE
       FRAME F-Main:POPUP-MENU       = MENU POPUP-MENU-F-Main:HANDLE.

/* SETTINGS FOR FILL-IN RowObject.Ab_Datum IN FRAME F-Main
   EXP-LABEL EXP-FORMAT                                                 */
/* SETTINGS FOR FILL-IN RowObject.AltPreis IN FRAME F-Main
   EXP-LABEL                                                            */
ASSIGN 
       RowObject.AltPreis: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 EXP-FORMAT                                                 */
/* SETTINGS FOR BUTTON Btn_Excel IN FRAME F-Main
   5                                                                    */
/* SETTINGS FOR BUTTON Btn_Kopieren IN FRAME F-Main
   5                                                                    */
/* SETTINGS FOR BUTTON Btn_Loeschen IN FRAME F-Main
   5                                                                    */
/* 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 F_Artnr IN FRAME F-Main
   NO-ENABLE 6                                                          */
ASSIGN 
       F_Artnr:READ-ONLY IN FRAME F-Main        = TRUE.

/* SETTINGS FOR FILL-IN F_Datum IN FRAME F-Main
   NO-ENABLE 6                                                          */
ASSIGN 
       F_Datum:READ-ONLY IN FRAME F-Main        = TRUE.

/* SETTINGS FOR FILL-IN F_Inhalt IN FRAME F-Main
   NO-ENABLE 6                                                          */
ASSIGN 
       F_Inhalt:READ-ONLY IN FRAME F-Main        = TRUE.

/* SETTINGS FOR FILL-IN F_Jahr IN FRAME F-Main
   NO-ENABLE 6                                                          */
ASSIGN 
       F_Jahr:READ-ONLY IN FRAME F-Main        = TRUE.

/* SETTINGS FOR FILL-IN F_Wert IN FRAME F-Main
   NO-DISPLAY                                                           */
/* 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.Knr IN FRAME F-Main
   NO-ENABLE                                                            */
ASSIGN 
       RowObject.Knr:HIDDEN IN FRAME F-Main           = TRUE
       RowObject.Knr:READ-ONLY IN FRAME F-Main        = TRUE.

/* SETTINGS FOR FILL-IN RowObject.Kunde IN FRAME F-Main
   EXP-LABEL EXP-FORMAT                                                 */
ASSIGN 
       RowObject.Kunde:READ-ONLY IN FRAME F-Main        = TRUE.

/* SETTINGS FOR FILL-IN RowObject.Marge IN FRAME F-Main
   EXP-LABEL EXP-FORMAT                                                 */
ASSIGN 
       RowObject.Marge:READ-ONLY IN FRAME F-Main        = TRUE.

/* SETTINGS FOR FILL-IN RowObject.Menge IN FRAME F-Main
   EXP-LABEL EXP-FORMAT                                                 */
/* SETTINGS FOR FILL-IN RowObject.PreisMut IN FRAME F-Main
   NO-ENABLE                                                            */
ASSIGN 
       RowObject.PreisMut:HIDDEN IN FRAME F-Main           = TRUE
       RowObject.PreisMut:READ-ONLY IN FRAME F-Main        = TRUE.

/* SETTINGS FOR TOGGLE-BOX RowObject.Proz_Betr IN FRAME F-Main
   NO-ENABLE EXP-LABEL                                                  */
ASSIGN 
       RowObject.Proz_Betr:HIDDEN IN FRAME F-Main           = TRUE.

/* SETTINGS FOR FILL-IN RowObject.VP_Normal IN FRAME F-Main
   EXP-LABEL                                                            */
ASSIGN 
       RowObject.VP_Normal:READ-ONLY IN FRAME F-Main        = TRUE.

/* SETTINGS FOR FILL-IN RowObject.Wert IN FRAME F-Main
   EXP-LABEL EXP-FORMAT                                                 */
/* _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 Btn_Excel
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Excel vTableWin
ON CHOOSE OF Btn_Excel IN FRAME F-Main /* Excel */
DO:
    DISABLE Btn_Excel WITH FRAME {&FRAME-NAME}.
    RUN REPORT.
    ENABLE  Btn_Excel WITH FRAME {&FRAME-NAME}.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&Scoped-define SELF-NAME Btn_Kopieren
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Kopieren vTableWin
ON CHOOSE OF Btn_Kopieren IN FRAME F-Main /* Kopieren */
DO:
    IF FMut THEN RETURN NO-APPLY.

DO WITH FRAME {&FRAME-NAME}:
    IF INDEX(SELF:LABEL, 'eich') > 0 THEN RUN KOPIEREN.
    ELSE DO:
        RUN ENABLE_DISABLE ( INPUT TRUE ).
        Btn_Kopieren:LABEL     = '&Speichern'.
        Btn_Loeschen:SENSITIVE = FALSE.
        Btn_Excel   :SENSITIVE = FALSE.
        F_Datum     :SENSITIVE = FALSE.
        F_Datum     :TAB-STOP  = FALSE.
        APPLY   'ENTRY' TO F_Artnr.
        RETURN NO-APPLY.
    END.
END.

END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Kopieren vTableWin
ON END-ERROR OF Btn_Kopieren IN FRAME F-Main /* Kopieren */
DO:
    IF INDEX(SELF:LABEL, 'eic') > 0 THEN DO:
        SELF:LABEL = 'Ko&pieren'.
        RUN ENABLE_DISABLE ( TRUE ).
        APPLY 'U1'.
        RETURN NO-APPLY.
    END.
    ELSE DO:
        APPLY 'U1'.
        RETURN NO-APPLY.
    END.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Kopieren vTableWin
ON ENDKEY OF Btn_Kopieren IN FRAME F-Main /* Kopieren */
DO:
    IF INDEX(SELF:LABEL, 'eic') > 0 THEN DO:
        SELF:LABEL = 'Ko&pieren'.
        RUN ENABLE_DISABLE ( TRUE ).
        APPLY 'U1'.
        RETURN NO-APPLY.
    END.
    ELSE DO:
        APPLY 'U1'.
        RETURN NO-APPLY.
    END.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Kopieren vTableWin
ON RETURN OF Btn_Kopieren IN FRAME F-Main /* Kopieren */
DO:
    IF FMut THEN RETURN NO-APPLY.

DO WITH FRAME {&FRAME-NAME}:
    IF INDEX(SELF:LABEL, 'eich') > 0 THEN RUN KOPIEREN.
    ELSE DO:
        RUN ENABLE_DISABLE ( INPUT TRUE ).
        Btn_Kopieren:LABEL     = '&Speichern'.
        Btn_Loeschen:SENSITIVE = FALSE.
        Btn_Excel   :SENSITIVE = FALSE.
        F_Datum     :SENSITIVE = FALSE.
        F_Datum     :TAB-STOP  = FALSE.
        APPLY   'ENTRY' TO F_Artnr.
        RETURN NO-APPLY.
    END.
END.

END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&Scoped-define SELF-NAME Btn_Loeschen
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Loeschen vTableWin
ON CHOOSE OF Btn_Loeschen IN FRAME F-Main /* Löschen */
DO:
    IF FMut THEN RETURN NO-APPLY.

    DO WITH FRAME {&FRAME-NAME}:
        SELF:SENSITIVE = FALSE.
        F_Datum:SENSITIVE = TRUE.
        F_Datum:TAB-STOP  = TRUE.
        APPLY 'ENTRY' TO F_Datum.
        RETURN NO-APPLY.
    END.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&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 /* Preisart */
DO:
DO WITH FRAME {&FRAME-NAME}:
    IF NOT FMut THEN SELF:SCREEN-VALUE = rowObject.Proz_Betr:SCREEN-VALUE.
    rowObject.Proz_Betr:SCREEN-VALUE = SELF:SCREEN-VALUE.
    rowObject.Proz_Betr:MODIFIED = TRUE.
    IF CB_Art:SCREEN-VALUE = 'P' THEN F_Wert:LABEL = 'Preis'.
    ELSE                              F_Wert:LABEL = 'Prozent'.
END.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&Scoped-define SELF-NAME F_Artnr
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Artnr vTableWin
ON END-ERROR OF F_Artnr IN FRAME F-Main /* zu Artikel */
DO:

DO WITH FRAME {&FRAME-NAME}:
    SELF:SCREEN-VALUE = '0'.
    RUN ENABLE_DISABLE ( INPUT FALSE ).
    APPLY 'U1'.
    RETURN NO-APPLY.
END.

END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Artnr vTableWin
ON LEAVE OF F_Artnr IN FRAME F-Main /* zu Artikel */
DO:
    IF INTEGER(SELF:SCREEN-VALUE) = 0 THEN RETURN.
    FIND FIRST Artst USE-INDEX Artst-k1
                     WHERE Artst.Firma = Firma
                     AND   Artst.Artnr = INTEGER(SELF:SCREEN-VALUE)
                           NO-LOCK NO-ERROR.
    IF NOT AVAILABLE Artst THEN DO:
        RUN FEHLER ( INPUT 1042 ) NO-ERROR.
        APPLY 'ENTRY' TO SELF.
        RETURN NO-APPLY.
    END.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Artnr vTableWin
ON RETURN OF F_Artnr IN FRAME F-Main /* zu Artikel */
DO:
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&Scoped-define SELF-NAME F_Datum
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Datum vTableWin
ON END-ERROR OF F_Datum IN FRAME F-Main /* bis Datum */
DO:
DO WITH FRAME {&FRAME-NAME}:
    SELF:SCREEN-VALUE      = ''.
    SELF:SENSITIVE         = FALSE.
    SELF:TAB-STOP          = FALSE.
    ENABLE  {&list-5}.
    APPLY 'U1'.
    RETURN NO-APPLY.
END.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Datum vTableWin
ON LEAVE OF F_Datum IN FRAME F-Main /* bis Datum */
DO:
    RUN LOESCHEN.
    RETURN NO-APPLY.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Datum vTableWin
ON RETURN OF F_Datum IN FRAME F-Main /* bis Datum */
DO:
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&Scoped-define SELF-NAME F_Inhalt
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Inhalt vTableWin
ON END-ERROR OF F_Inhalt IN FRAME F-Main /* / */
DO:

DO WITH FRAME {&FRAME-NAME}:
    SELF:SCREEN-VALUE = '0'.
    RUN ENABLE_DISABLE ( INPUT FALSE ).
    APPLY 'U1'.
    RETURN NO-APPLY.
END.

END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Inhalt vTableWin
ON LEAVE OF F_Inhalt IN FRAME F-Main /* / */
DO:
    DEF VAR iArtnr      AS INT                      NO-UNDO.
    DEF VAR iInhalt     AS INT                      NO-UNDO.

    iArtnr  = INTEGER(F_Artnr :SCREEN-VALUE).
    iInhalt = INTEGER(F_Inhalt:SCREEN-VALUE).
    IF iArtnr = 0 THEN RETURN.
    FIND FIRST Artst USE-INDEX Artst-k1
                     WHERE Artst.Firma  = Firma
                     AND   Artst.Artnr  = iArtnr
                     AND   Artst.Inhalt = iInhalt NO-LOCK NO-ERROR.
    IF NOT AVAILABLE Artst THEN DO:
        RUN FEHLER ( INPUT 1042 ) NO-ERROR.
        APPLY 'ENTRY' TO SELF.
        RETURN NO-APPLY.
    END.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Inhalt vTableWin
ON RETURN OF F_Inhalt IN FRAME F-Main /* / */
DO:
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&Scoped-define SELF-NAME F_Jahr
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Jahr vTableWin
ON END-ERROR OF F_Jahr IN FRAME F-Main /* / */
DO:

DO WITH FRAME {&FRAME-NAME}:
    SELF:SCREEN-VALUE = '0'.
    RUN ENABLE_DISABLE ( INPUT FALSE ).
    APPLY 'U1'.
    RETURN NO-APPLY.
END.

END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Jahr vTableWin
ON LEAVE OF F_Jahr IN FRAME F-Main /* / */
DO:
    DEF VAR iArtnr      AS INT                      NO-UNDO.
    DEF VAR iInhalt     AS INT                      NO-UNDO.
    DEF VAR iJahr       AS INT                      NO-UNDO.
    DEF VAR cString     AS CHAR                     NO-UNDO.

    iArtnr  = INTEGER(F_Artnr :SCREEN-VALUE).
    iInhalt = INTEGER(F_Inhalt:SCREEN-VALUE).
    iJahr   = INTEGER(F_Jahr  :SCREEN-VALUE).
    IF iArtnr = 0 THEN RETURN NO-APPLY.
    FIND FIRST Artst NO-LOCK USE-INDEX Artst-k1
            WHERE Artst.Firma  = Firma
            AND   Artst.Artnr  = iArtnr
            AND   Artst.Inhalt = iInhalt
            AND   Artst.Jahr   = iJahr NO-ERROR.
    IF NOT AVAILABLE Artst THEN DO:
        RUN FEHLER ( INPUT 1042 ) NO-ERROR.
        APPLY 'ENTRY' TO SELF.
        RETURN NO-APPLY.
    END.
    cString = SUBSTITUTE('kopieren zu Artikel &1.&2.&3 &4 &5 &6 mit Speichern bestätigen!',
              Artst.Artnr, Artst.Inhalt, Artst.Jahr, Artst.Bez, Artst.VGeb_Cd, Artst.KGeb_Cd).
    MESSAGE cString
            VIEW-AS ALERT-BOX INFORMATION.
    APPLY 'ENTRY' TO Btn_Kopieren.
    RETURN NO-APPLY.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Jahr vTableWin
ON RETURN OF F_Jahr IN FRAME F-Main /* / */
DO:
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&Scoped-define SELF-NAME m_lschen_Spezialpreise_von_in
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL m_lschen_Spezialpreise_von_in vTableWin
ON CHOOSE OF MENU-ITEM m_lschen_Spezialpreise_von_in /* löschen Spezialpreise von inaktiven Artikeln */
DO:
    IF FMut THEN RETURN NO-APPLY.
    RUN LOESCHEN_INAKT.
    APPLY 'U1'.
    RETURN NO-APPLY.
END.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME


&UNDEFINE SELF-NAME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK vTableWin 


/* ***************************  Main Block  *************************** */

    { incl/viwmainblock.i }

    &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:       
------------------------------------------------------------------------------*/

    DO WITH FRAME {&FRAME-NAME}:
        RUN ENABLE_DISABLE ( INPUT FALSE ).
    END.

    cArtikel = DYNAMIC-FUNCTION('getArtikel':U) NO-ERROR.
    IF cArtikel = '' OR 
       cArtikel = ?  THEN DO:
        DYNAMIC-FUNCTION('setFlagAbbruch':U, TRUE, ProgName) NO-ERROR.
        RETURN NO-APPLY.
    END.

    nArtnr  = INTEGER(ENTRY(2, cArtikel, CHR(01))).
    nInhalt = INTEGER(ENTRY(3, cArtikel, CHR(01))).
    nJahr   = INTEGER(ENTRY(4, cArtikel, CHR(01))).

    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 BERECHNEN vTableWin 
PROCEDURE BERECHNEN :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF VAR lInkl       AS LOG                      NO-UNDO.
    DEF VAR PreisGrp    AS INT                      NO-UNDO.
    DEF VAR FwPreisGrp  AS INT                      NO-UNDO.
    DEF VAR Marge       AS DEC  DECIMALS 4          NO-UNDO.
    DEF VAR VK_Netto    AS DEC  DECIMALS 4          NO-UNDO.
    DEF VAR VK_Spez     AS DEC  DECIMALS 4          NO-UNDO.
    DEF VAR Ansatz      AS DEC  DECIMALS 4          NO-UNDO.
    DEF VAR Wert        AS DEC  DECIMALS 4          NO-UNDO.

    FwPreisGrp = DYNAMIC-FUNCTION('GETFWPREISGRP':U) NO-ERROR.

    DO WITH FRAME {&FRAME-NAME}:
        nKnr    = INTEGER(F_Knr:SCREEN-VALUE           ).
        nArtnr  = INTEGER(rowObject.Artnr:SCREEN-VALUE ).
        nInhalt = INTEGER(rowObject.Inhalt:SCREEN-VALUE).
        nJahr   = INTEGER(rowObject.Jahr:SCREEN-VALUE  ).
        Wert    = DECIMAL(rowObject.Wert:SCREEN-VALUE  ).
    END.

    FIND Artst NO-LOCK USE-INDEX Artst-k1
            WHERE Artst.Firma  = Firma
            AND   Artst.Artnr  = nArtnr
            AND   Artst.Inhalt = nInhalt
            AND   Artst.Jahr   = nJahr NO-ERROR.
    FIND Debst NO-LOCK USE-INDEX Debst-k1
            WHERE Debst.Firma  = Firma
            AND   Debst.Knr    = nKnr  NO-ERROR.
    PreisGrp = Debst.Preis_Grp.
    FIND Wust NO-LOCK USE-INDEX Wust-k1
            WHERE Wust.CodeK = Debst.MWST
            AND   Wust.CodeA = 99 NO-ERROR.
    lInkl  = Wust.Incl.

    FIND AbwPrGrp NO-LOCK USE-INDEX AbwPrGrp-k1
            WHERE AbwPrGrp.Firma  = Firma
            AND   AbwPrGrp.Knr    = SpezPrei.Knr
            AND   AbwPrGrp.Wg_Grp = Artst.Wg_Grp NO-ERROR.
    IF AVAILABLE AbwPrGrp THEN PreisGrp = AbwPrGrp.Preis_Grp.

    FIND LAST ArtPreis NO-LOCK USE-INDEX ArtPreis-k1
            WHERE ArtPreis.Firma     = Firma
            AND   ArtPreis.Artnr     = nArtnr
            AND   ArtPreis.Inhalt    = nInhalt
            AND   ArtPreis.Jahr      = nJahr 
            AND   ArtPreis.Preis_Grp = PreisGrp
            AND   ArtPreis.Ab_Datum <= TODAY
            AND   ArtPreis.Aktion    = FALSE
            AND   ArtPreis.Aktiv     = TRUE NO-ERROR.
    IF NOT AVAILABLE ArtPreis THEN DO:
        FIND LAST ArtPreis NO-LOCK USE-INDEX ArtPreis-k1
                WHERE ArtPreis.Firma     = Firma
                AND   ArtPreis.Artnr     = nArtnr
                AND   ArtPreis.Inhalt    = nInhalt
                AND   ArtPreis.Jahr      = nJahr 
                AND   ArtPreis.Preis_Grp = Debst.Preis_Grp
                AND   ArtPreis.Ab_Datum <= TODAY
                AND   ArtPreis.Aktion    = FALSE
                AND   ArtPreis.Aktiv     = TRUE NO-ERROR.
    END.
    IF NOT AVAILABLE ArtPreis THEN DO:
        FIND LAST ArtPreis NO-LOCK USE-INDEX ArtPreis-k1
                WHERE ArtPreis.Firma     = Firma
                AND   ArtPreis.Artnr     = nArtnr
                AND   ArtPreis.Inhalt    = nInhalt
                AND   ArtPreis.Jahr      = nJahr 
                AND   ArtPreis.Preis_Grp = FwPreisGrp
                AND   ArtPreis.Ab_Datum <= TODAY
                AND   ArtPreis.Aktion    = FALSE
                AND   ArtPreis.Aktiv     = TRUE NO-ERROR.
    END.

    DO WITH FRAME {&FRAME-NAME}:
        Ansatz = ArtPreis.VK_Brutto * 100 / ArtPreis.VK_Netto.
        IF lInkl THEN rowObject.VP_Norm:SCREEN-VALUE = STRING(ArtPreis.VK_Brutto).
        ELSE          rowObject.VP_Norm:SCREEN-VALUE = STRING(ArtPreis.VK_Netto).
        VK_Netto = DECIMAL(rowObject.VP_Norm:SCREEN-VALUE).
        IF CB_Art:SCREEN-VALUE = 'P' THEN VK_Spez = VK_Netto * (100 - Wert) / 100.
        ELSE                              VK_Spez = Wert.
        IF lInkl THEN VK_Spez = VK_Spez / Ansatz * 100.
        
        IF Artst.Listen_EP = 0 THEN Marge = 0.
        ELSE                        Marge = 100 - (Artst.Listen_EP * 100 / VK_Spez).

        rowObject.Marge:SCREEN-VALUE = STRING(Marge).
    END.

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.
    
    DO WITH FRAME {&FRAME-NAME}:
        RUN ENABLE_DISABLE ( INPUT TRUE ).
    END.

    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:       
------------------------------------------------------------------------------*/

    DO WITH FRAME {&FRAME-NAME}:
        RUN ENABLE_DISABLE ( INPUT FALSE ).
    END.

    cArtikel = DYNAMIC-FUNCTION('getArtikel':U) NO-ERROR.
    IF cArtikel = '' OR
       cArtikel = ?  THEN DO:
        DYNAMIC-FUNCTION('setFlagAbbruch':U, INPUT TRUE, Progname) NO-ERROR.
        RETURN NO-APPLY.
    END.

    nArtnr  = INTEGER(ENTRY(2, cArtikel, CHR(01))).
    nInhalt = INTEGER(ENTRY(3, cArtikel, CHR(01))).
    nJahr   = INTEGER(ENTRY(4, cArtikel, CHR(01))).

    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.

    Ja = DYNAMIC-FUNCTION( 'ANTWORT_NEIN':U, INPUT 1000 ).
    IF NOT Ja THEN DO:
        RUN TOOLBAR IN hKontainer ( INPUT 'CANCEL':U ) NO-ERROR.
        RETURN NO-APPLY.
    END.

    RUN SUPER.

    /* Code placed here will execute AFTER standard behavior.    */

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  ).
    RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&Eingabe}'       , INPUT TRUE  ).
    RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&List-6}'        , INPUT FALSE ).

    IF NUM-ENTRIES('{&KEY_FELDER}', ',') > 0 THEN DO:
        RUN FARBE_FELDER ( INPUT Fenster, INPUT '{&KEY_FELDER}', INPUT 15 ).
    END.

    DO WITH FRAME {&FRAME-NAME}:
        ENABLE  {&List-5}.
    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:  <none>
  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.

    DEF VAR VP      AS DEC  DECIMALS 4              NO-UNDO.
    DEF VAR Wert    AS DEC  DECIMALS 4              NO-UNDO.
    DEF VAR Betrag  AS DEC  DECIMALS 4              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}:
        F_Knr:SCREEN-VALUE  = rowObject.Knr:SCREEN-VALUE.
        CB_Art:SCREEN-VALUE = rowObject.Proz_Betr:SCREEN-VALUE NO-ERROR.

        VP   = DECIMAL(rowObject.VP_Norm:SCREEN-VALUE).
        Wert = DECIMAL(rowObject.Wert:SCREEN-VALUE   ).
        IF CB_Art:SCREEN-VALUE = 'P' THEN DO:
            F_Wert:LABEL = 'Preis'.
            Betrag = VP * (100 - Wert) / 100.
            F_Wert:SCREEN-VALUE = STRING(Betrag).
        END.
        ELSE DO:
            F_Wert:LABEL = 'Prozent'.
            Betrag = (100 - (Wert * 100 / VP)).
            F_Wert:SCREEN-VALUE = STRING(Betrag).
        END.
    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 ).
    RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&Eingabe}'        , INPUT FALSE ).
    RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&List-6}'         , INPUT TRUE  ).

    IF NUM-ENTRIES('{&NUR_LESEN}', ',') > 0 THEN DO:
        RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&NUR_LESEN}', INPUT TRUE ).
    END.
    
    DO WITH FRAME {&FRAME-NAME}:
        IF CB_Art:SCREEN-VALUE = 'P' THEN F_Wert:LABEL = 'Preis'.
        ELSE                              F_Wert:LABEL = 'Prozent'.
        DISABLE {&List-5}.
    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 }
    
    IF SAktiv THEN DO WITH FRAME {&FRAME-NAME}:
        RUN READONLY_FELDER ( INPUT Fenster, INPUT '{&List-6}' , INPUT TRUE ).
    END.
    RUN ENABLE_DISABLE ( TRUE ).

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENABLE_DISABLE vTableWin 
PROCEDURE ENABLE_DISABLE :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF INPUT PARAMETER ipArt   AS LOG          NO-UNDO.

DO WITH FRAME {&FRAME-NAME}:
    CASE ipArt:
        WHEN FALSE THEN DO:
            Btn_Kopieren:SENSITIVE = TRUE.
            Btn_Loeschen:SENSITIVE = TRUE.
            Btn_Excel   :SENSITIVE = TRUE.
            Btn_Kopieren:LABEL     = 'Ko&pieren'.
        END.
        OTHERWISE DO:
            Btn_Kopieren:SENSITIVE = TRUE .
            Btn_Loeschen:SENSITIVE = FALSE.
            Btn_Excel   :SENSITIVE = FALSE.
            Btn_Kopieren:LABEL     = 'Ko&pieren'.
        END.
    END CASE.

    F_Artnr :SCREEN-VALUE   = ''.
    F_Inhalt:SCREEN-VALUE   = ''.
    F_Jahr  :SCREEN-VALUE   = ''.
    F_Datum :SCREEN-VALUE   = ''.
    F_Artnr :SENSITIVE      = ipArt.
    F_Artnr :READ-ONLY      = NOT ipArt.
    F_Artnr :TAB-STOP       = ipArt.
    F_Inhalt:SENSITIVE      = ipArt.
    F_Inhalt:READ-ONLY      = NOT ipArt.
    F_Inhalt:TAB-STOP       = ipArt.
    F_Jahr  :SENSITIVE      = ipArt.
    F_Jahr  :READ-ONLY      = NOT ipArt.
    F_Jahr  :TAB-STOP       = ipArt.
    F_Datum :SENSITIVE      = ipArt.
    F_Datum :READ-ONLY      = NOT ipArt.
    F_Datum :TAB-STOP       = ipArt.
END.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENTRY_FELD_TEST vTableWin 
PROCEDURE ENTRY_FELD_TEST :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF VAR nPreis          AS DEC  DECIMALS 4      NO-UNDO.
    DEF VAR nWert           AS DEC  DECIMALS 4      NO-UNDO.
    DEF VAR nBetrag         AS DEC  DECIMALS 4      NO-UNDO.

    { incl/viwentryfeldtest.i }

    DO WITH FRAME {&FRAME-NAME}:
        CASE FeldName:
            WHEN 'F_Wert' THEN DO:
                nWert = DECIMAL(rowObject.Wert:SCREEN-VALUE).
                IF nWert = 0 THEN RETURN ''.
    
                nPreis = DECIMAL(rowObject.VP_Norm:SCREEN-VALUE).
                IF CB_Art:SCREEN-VALUE = 'P' THEN DO:
                    nBetrag = nPreis * (100 - nWert) / 100.
                    ipHandle:SCREEN-VALUE = STRING(nBetrag).
                END.
                ELSE DO:
                    nBetrag = 100 - (nWert * 100 / nPreis).
                    ipHandle:SCREEN-VALUE = STRING(nBetrag).
                END.
                RUN BERECHNEN.
                ipHandle:MODIFIED = FALSE.
            END.
        END CASE.
    END.

    RETURN ''.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE FEHLWERTE vTableWin 
PROCEDURE FEHLWERTE :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  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('Firma', oldColList, ',') + 1.
        ENTRY(i1, pcColValues, CHR(01)) = Firma NO-ERROR.
        i1 = LOOKUP('Proz_Betr', oldColList, ',') + 1.
        ENTRY(i1, pcColValues, CHR(01)) = STRING(FALSE,rowObject.Proz_Betr:FORMAT) NO-ERROR.
    END.

    IF FCopy THEN DO:
    END.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE FIND_DEBITOR vTableWin 
PROCEDURE FIND_DEBITOR :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF VAR iRecid      AS RECID                    NO-UNDO.
    DEF VAR cInput      AS CHAR                     NO-UNDO.

DO WITH FRAME {&FRAME-NAME}:
    cInput = 'DEB;' + TRIM(F_Knr:SCREEN-VALUE).
    RUN 'g-suchen-adresse.w':U ( cInput, OUTPUT iRecid ).
    IF iRecid = ? OR
       iRecid = 0 THEN RETURN 'ERROR'.
       
    FIND Adresse NO-LOCK WHERE RECID(Adresse) = iRecid NO-ERROR.
    lLeave = FALSE.
    iKnr   = Adresse.Knr.
    F_Knr:SCREEN-VALUE             = STRING(Adresse.Knr,'999999').
    rowObject.Knr:SCREEN-VALUE     = STRING(Adresse.Knr,'999999').
    rowObject.Kunde:SCREEN-VALUE   = Adresse.Anzeig_Br.

    RUN BERECHNEN.

    APPLY 'ENTRY' TO rowObject.Menge.
    lLeave = TRUE.
    RETURN NO-APPLY ''.
END.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE KOPF vTableWin 
PROCEDURE KOPF :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF INPUT PARAMETER eh  AS COM-HANDLE       NO-UNDO.

    DEF VAR Zelle   AS CHAR                     NO-UNDO.

    FIND Steuer USE-INDEX Steuer-k1
                WHERE Steuer.Firma = Firma NO-LOCK NO-ERROR.

    Zelle = 'Links1'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = Steuer.Firma1.
    Zelle = 'D1'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = 'Alle Kunden dieses Artikel mit Spezpreis'.
    Zelle = 'Rechts1'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = 'Datum : ' + STRING(TODAY,'99.99.9999').

    Zelle = 'Links2'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = Steuer.Ort.
    Zelle = 'D2'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = ''.
    Zelle = 'Rechts2'.
    eh:Range(Zelle):SELECT.
    eh:SELECTION:VALUE = 'Zeit  :     ' + STRING(TIME,'HH:MM:SS').

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE KOPIEREN vTableWin 
PROCEDURE KOPIEREN :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF VAR Artnr   AS INT                      NO-UNDO.
    DEF VAR Inhalt  AS INT                      NO-UNDO.
    DEF VAR Jahr    AS INT                      NO-UNDO.
    DEF VAR iArtnr  AS INT                      NO-UNDO.
    DEF VAR iInhalt AS INT                      NO-UNDO.
    DEF VAR iJahr   AS INT                      NO-UNDO.

    DO WITH FRAME {&FRAME-NAME}:
        ASSIGN  {&List-6}.
        Artnr  = INTEGER(rowObject.Artnr :SCREEN-VALUE).
        Inhalt = INTEGER(rowObject.Inhalt:SCREEN-VALUE).
        Jahr   = INTEGER(rowObject.Jahr  :SCREEN-VALUE).
        FIND Artst NO-LOCK USE-INDEX Artst-k1
                WHERE Artst.Firma  = Firma
                AND   Artst.Artnr  = F_Artnr
                AND   Artst.Inhalt = F_Inhalt
                AND   Artst.Jahr   = F_Jahr NO-ERROR.
        IF NOT AVAILABLE Artst THEN DO:
            RUN FEHLER ( INPUT 1042 ) NO-ERROR.
            APPLY 'ENTRY' TO F_Artnr.
            RETURN NO-APPLY.
        END.
        IF Artnr  = F_Artnr     AND
           Inhalt = F_Inhalt    AND
           Jahr   = F_Jahr      THEN DO:
            MESSAGE 'Kopieren in den selben/gleichen Artikel nicht möglich!'
                    VIEW-AS ALERT-BOX ERROR.
            APPLY 'ENTRY' TO F_Artnr.
            RETURN NO-APPLY.
        END.

        EMPTY TEMP-TABLE TSpezPrei.
        FOR EACH SpezPrei NO-LOCK USE-INDEX Spezprei-k2
                WHERE SpezPrei.Firma  = Firma
                AND   SpezPrei.Artnr  = Artnr
                AND   SpezPrei.Inhalt = Inhalt
                AND   SpezPrei.Jahr   = Jahr :
            CREATE  TSpezPrei.
            BUFFER-COPY SpezPrei
                EXCEPT  Artnr Inhalt Jahr
                TO TSpezPrei
                ASSIGN  TSpezPrei.Artnr  = F_Artnr
                        TSpezPrei.Inhalt = F_Inhalt
                        TSpezPrei.Jahr   = F_Jahr.
        END.

        REPEAT TRANSACTION:
            FOR EACH TSpezPrei.
                FIND SpezPrei OF TSpezPrei NO-ERROR.
                IF NOT AVAILABLE SpezPrei THEN CREATE SpezPrei.
                BUFFER-COPY TSpezPrei TO SpezPrei.
            END.
            RELEASE SpezPrei.
            LEAVE.
        END.
        RUN ENABLE_DISABLE ( INPUT FALSE ).
        APPLY 'U1'.
        RETURN NO-APPLY.
    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:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    { incl/viwleavefeldtest.i }

    DEF VAR nPreis          AS DEC  DECIMALS 4      NO-UNDO.
    DEF VAR nWert           AS DEC  DECIMALS 4      NO-UNDO.
    DEF VAR nBetrag         AS DEC  DECIMALS 4      NO-UNDO.

    DO WHILE FNeu WITH FRAME {&FRAME-NAME}:
        CASE FeldName:
            WHEN 'F_Knr' THEN DO WITH FRAME {&FRAME-NAME}:
                F_Knr = SELF:SCREEN-VALUE.
                iKnr  = INTEGER(F_Knr) NO-ERROR.
                IF ERROR-STATUS:ERROR THEN DO:
                    RUN FIND_DEBITOR.
                    IF RETURN-VALUE = 'ERROR' THEN DO:
                        APPLY 'ENTRY' TO F_Knr.
                        RETURN 'APPLY'.
                    END.
                END.
                FIND Adresse NO-LOCK USE-INDEX Adresse-k1
                        WHERE Adresse.Firma = AdFirma
                        AND   Adresse.Knr   = iKnr NO-ERROR.
                IF NOT AVAILABLE Adresse THEN DO:
                    RUN FIND_DEBITOR.
                    IF RETURN-VALUE = 'ERROR' THEN DO:
                        APPLY 'ENTRY' TO F_Knr.
                        RETURN 'APPLY'.
                    END.
                END.
                IF Adresse.Aktiv = FALSE THEN DO:
                    RUN FEHLER ( INPUT 1021 ).
                    RETURN 'ERROR'.
                END.
                iKnr = Adresse.Knr.
                FIND Debst NO-LOCK USE-INDEX Debst-k1
                        WHERE Debst.Firma  = Firma
                        AND   Debst.Knr    = iKnr NO-ERROR.
                IF NOT AVAILABLE Debst THEN DO:
                    RUN FEHLER ( INPUT 1016 ).
                    RETURN 'ERROR'.
                END.
                IF Debst.Aktiv = FALSE THEN DO:
                    RUN FEHLER ( INPUT 1019 ).
                    RETURN 'ERROR'.
                END.
                rowObject.Kunde:SCREEN-VALUE = Adresse.Anzeig_Br.
                rowObject.Knr  :SCREEN-VALUE = STRING(Adresse.Knr).
                F_Knr          :SCREEN-VALUE = STRING(Adresse.Knr).
                RUN BERECHNEN.
                RETURN ''.
            END.
            WHEN 'Menge' THEN DO:
                IF KEYFUNCTION(LASTKEY) = 'BACK-TAB' THEN RETURN.
                IF VALID-HANDLE(hENTER) THEN DO:
                    IF hENTER:NAME = 'F_Knr' THEN RETURN.
                END.
                nArtnr  = INTEGER(rowObject.Artnr:SCREEN-VALUE).
                nInhalt = INTEGER(rowObject.Inhalt:SCREEN-VALUE).
                nJahr   = INTEGER(rowObject.Jahr:SCREEN-VALUE).
                FIND SpezPrei NO-LOCK USE-INDEX SpezPrei-k1
                        WHERE SpezPrei.Firma  = Firma
                        AND   SpezPrei.Knr    = iKnr
                        AND   SpezPrei.Artnr  = nArtnr
                        AND   SpezPrei.Inhalt = nInhalt
                        AND   SpezPrei.Jahr   = nJahr
                        AND   SpezPrei.Menge  = DECIMAL(FeldInhalt) NO-ERROR.
                IF AVAILABLE SpezPrei THEN DO:
                    RUN FEHLER ( INPUT 1043 ).
                    RETURN 'ERROR'.
                END.
                RETURN ''.
            END.
        END CASE.
        LEAVE.
    END.

    DO WHILE TRUE WITH FRAME {&FRAME-NAME}:
        CASE FeldName:
            WHEN 'Ab_Datum' THEN DO:
                IF DATE(FeldInhalt) = ?
                    THEN ipHandle:SCREEN-VALUE = STRING(TODAY).
            END.
            WHEN 'Bis_Datum' THEN DO:
                IF DATE(FeldInhalt) = ?
                    THEN ipHandle:SCREEN-VALUE = STRING(DATE(12,31,2099)).
            END.
            WHEN 'F_Wert' THEN DO:
                IF ipHandle:MODIFIED = TRUE THEN DO:
                    nBetrag = DECIMAL(FeldInhalt). 
                    nPreis  = DECIMAL(rowObject.VP_Norm:SCREEN-VALUE).
                    nWert   = DECIMAL(rowObject.Wert:SCREEN-VALUE   ).
                    IF CB_Art:SCREEN-VALUE = 'P' THEN DO:
                        nWert = 100 - (nBetrag * 100 / nPreis).
                        rowObject.Wert:SCREEN-VALUE = STRING(nWert).
                    END.
                    ELSE DO:
                        nWert = nPreis * (100 - nBetrag) / 100.
                        rowObject.Wert:SCREEN-VALUE = STRING(nWert).
                    END.
                    RUN BERECHNEN.
                    RETURN 'ERROR'.
                END.
            END.
        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 LOESCHEN vTableWin 
PROCEDURE LOESCHEN :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF VAR Ja          AS LOG                  NO-UNDO.
    DEF VAR dHandle     AS HANDLE               NO-UNDO.
    DEF VAR Artnr       AS INT                  NO-UNDO.
    DEF VAR Inhalt      AS INT                  NO-UNDO.
    DEF VAR Jahr        AS INT                  NO-UNDO.

DO WITH FRAME {&FRAME-NAME}:
    IF KEYFUNCTION(LASTKEY) <> 'RETURN' THEN DO:
        F_Datum:SCREEN-VALUE = ''.
        F_Datum:SENSITIVE    = FALSE.
        F_Datum:TAB-STOP     = FALSE.
        ENABLE  {&List-5}.
        APPLY 'U1'.
        RETURN NO-APPLY.
    END.
    IF DATE(F_Datum:SCREEN-VALUE) = ? THEN DO:
        F_Datum:SCREEN-VALUE = ''.
        F_Datum:SENSITIVE    = FALSE.
        F_Datum:TAB-STOP     = FALSE.
        ENABLE  {&List-5}.
        APPLY 'U1'.
        RETURN NO-APPLY.
    END.
    Artnr  = INTEGER(rowObject.Artnr :SCREEN-VALUE).
    Inhalt = INTEGER(rowObject.Inhalt:SCREEN-VALUE).
    Jahr   = INTEGER(rowObject.Jahr  :SCREEN-VALUE).
    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.
    IF NOT AVAILABLE Artst THEN DO:
        RUN FEHLER ( INPUT 1042 ).
        F_Datum:SCREEN-VALUE = ''.
        F_Datum:SENSITIVE    = FALSE.
        F_Datum:TAB-STOP     = FALSE.
        ENABLE  {&List-5}.
        APPLY 'U1'.
        RETURN NO-APPLY.
    END.

    Ja      = FALSE.
    F_Datum = DATE(F_Datum:SCREEN-VALUE).
    MESSAGE 'Wollen Sie alle Spezialpreise mit Gültigkeit ' SKIP
            'bis ' STRING(F_Datum,'99.99.9999') ' dieses Artikels löschen ? '
            VIEW-AS ALERT-BOX QUESTION BUTTONS YES-NO
            UPDATE  Ja.
    IF NOT Ja THEN DO:
        F_Datum:SCREEN-VALUE = ''.
        F_Datum:SENSITIVE    = FALSE.
        F_Datum:TAB-STOP     = FALSE.
        ENABLE  {&List-5}.
        APPLY 'U1'.
        RETURN NO-APPLY.
    END.

    FOR EACH SpezPrei USE-INDEX SpezPrei-k2
                      WHERE SpezPrei.Firma     = Firma
                      AND   SpezPrei.Artnr     = Artnr
                      AND   SpezPrei.Inhalt    = Inhalt
                      AND   SpezPrei.Jahr      = Jahr
                      AND   SpezPrei.Bis_Datum <= F_Datum TRANSACTION:
        DELETE SpezPrei.
    END.

    dHandle = DYNAMIC-FUNCTION('getDataSource':U) NO-ERROR.
    IF VALID-HANDLE(dHandle) THEN DYNAMIC-FUNCTION('openQuery':U IN dHandle ) NO-ERROR.

    F_Datum:SCREEN-VALUE = ''.
    F_Datum:SENSITIVE    = FALSE.
    F_Datum:TAB-STOP     = FALSE.
    ENABLE  {&List-5}.
    APPLY 'U1'.
    RETURN NO-APPLY.
END.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE LOESCHEN_INAKT vTableWin 
PROCEDURE LOESCHEN_INAKT :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    SESSION:SET-WAIT-STATE('GENERAL').

    FOR EACH Artst USE-INDEX Artst-k1
                   WHERE Artst.Firma = Firma
                   AND   Artst.Aktiv = FALSE NO-LOCK:
        FOR EACH SpezPrei USE-INDEX SpezPrei-k2
                          WHERE SpezPrei.Firma  = Artst.Firma
                          AND   SpezPrei.Artnr  = Artst.Artnr
                          AND   SpezPrei.Inhalt = Artst.Inhalt
                          AND   SpezPrei.Jahr   = Artst.Jahr:
            DELETE  SpezPrei.
        END.
        RELEASE SpezPrei.
        RELEASE Artst.
    END.

    SESSION:SET-WAIT-STATE('').

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REPORT vTableWin 
PROCEDURE REPORT :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF VAR excelAppl   AS COM-HANDLE               NO-UNDO.
    DEF VAR DatenName   AS CHAR                     NO-UNDO.
    DEF VAR DateiName   AS CHAR                     NO-UNDO.
    DEF VAR Zelle       AS CHAR                     NO-UNDO.
    DEF VAR xText       AS CHAR                     NO-UNDO.
    DEF VAR Ja          AS LOG                      NO-UNDO.
    DEF VAR KGeb        AS CHAR                     NO-UNDO.
    DEF VAR cArtikel    AS CHAR                     NO-UNDO.
    DEF VAR Artikel     AS CHAR                     NO-UNDO.
    DEF VAR Kunde       AS CHAR                     NO-UNDO.
    DEF VAR ARecid      AS RECID                    NO-UNDO.

    Firma    = DYNAMIC-FUNCTION('getMandant':U)            NO-ERROR.
    cArtikel = DYNAMIC-FUNCTION('getArtikel':U)            NO-ERROR.
    IF cArtikel = '' OR
       cArtikel = ?  THEN RETURN NO-APPLY.
    ARecid   = INTEGER(ENTRY(1, cArtikel, CHR(01))).
    FIND Artst WHERE RECID(Artst) = ARecid  NO-LOCK NO-ERROR.
    FIND FIRST ArtBez OF Artst              NO-LOCK NO-ERROR.
    FIND KGebinde USE-INDEX KGebinde-k1
                  WHERE KGebinde.Firma  = Firma
                  AND   KGebinde.Geb_Cd = Artst.KGeb_Cd NO-LOCK NO-ERROR.
    IF AVAILABLE KGebinde THEN KGeb = KGebinde.KBez.
    ELSE                       KGeb = FILL('?', 10).
    Artikel = STRING(Artst.Artnr,'999999  ')
            +        Artbez.Bez1.
    IF Artbez.Bez2     <> ''    THEN Artikel = Artikel      + ', '
                                             + Artbez.Bez2.
    Artikel = Artikel + ' / ' + KGeb.
    IF Artst.Jahr       > 1900  THEN Artikel = Artikel      + ' / '
                                             + STRING(Artst.Jahr,'9999').
    IF Artst.Alk_Gehalt > 0     THEN Artikel = Artikel      + ' / '
                                             + STRING(Artst.Alk_Gehalt,'zz9.99%').

    DatenName = 'ArtikelSpezialPreise.txt'.
    DateiName = 'ArtikelSpezialPreise.xls' + CHR(01) + 'ArtikelSpezialPreise.xls'.

DO WITH FRAME {&FRAME-NAME}:
    DO WHILE TRUE:
        excelAppl = DYNAMIC-FUNCTION('CREATEEXCEL':U) NO-ERROR.
        IF NOT VALID-HANDLE(excelAppl) THEN DO:
            RUN FEHLER ( INPUT 1035 ).
            RETURN NO-APPLY.
        END.
        LEAVE.
    END.

    DO WHILE TRUE:
        RUN CREATEDATEI ( INPUT DateiName ).
        IF NOT RETURN-VALUE BEGINS 'ERROR-' THEN LEAVE.
        CASE RETURN-VALUE:
            WHEN 'ERROR-PARAMETER' THEN DO:
                RUN FEHLER ( INPUT 1036 ).
                RETURN NO-APPLY.
            END.
            WHEN 'ERROR-LOESCHEN' THEN DO:
                RUN FEHLER ( INPUT 1037 ).
                RETURN NO-APPLY.
            END.
            WHEN 'ERROR-VORLAGE' THEN DO:
                RUN FEHLER ( INPUT 1038 ).
                RETURN NO-APPLY.
            END.
            OTHERWISE DO:
                MESSAGE RETURN-VALUE VIEW-AS ALERT-BOX ERROR.
                RETURN NO-APPLY.
            END.
        END CASE.
        LEAVE.
    END.
    DateiName = RETURN-VALUE.

    DO WHILE TRUE:
        RUN CREATEDATEI ( INPUT DatenName ).
        IF NOT RETURN-VALUE BEGINS 'ERROR-' THEN LEAVE.
        CASE RETURN-VALUE:
            WHEN 'ERROR-PARAMETER' THEN DO:
                RUN FEHLER ( INPUT 1036 ).
                RETURN NO-APPLY.
            END.
            WHEN 'ERROR-LOESCHEN' THEN DO:
                RUN FEHLER ( INPUT 1037 ).
                RETURN NO-APPLY.
            END.
            WHEN 'ERROR-VORLAGE' THEN DO:
                RUN FEHLER ( INPUT 1038 ).
                RETURN NO-APPLY.
            END.
            OTHERWISE DO:
                MESSAGE RETURN-VALUE VIEW-AS ALERT-BOX ERROR.
                RETURN NO-APPLY.
            END.
        END CASE.
        LEAVE.
    END.
    DatenName = RETURN-VALUE.

    OUTPUT TO VALUE(DatenName) APPEND.

    PUT CONTROL '£'
                Artikel                                         CHR(10).
    PUT CONTROL '£Knr£Kunde£Menge£ab£bis£P/B£Wert'              CHR(10)
                '£'                                             CHR(10).

    FOR EACH SpezPrei USE-INDEX SpezPrei-k2
                      WHERE SpezPrei.Firma  = Firma
                      AND   SpezPrei.Artnr  = Artst.Artnr
                      AND   SpezPrei.Inhalt = Artst.Inhalt
                      AND   SpezPrei.Jahr   = Artst.Jahr        NO-LOCK:
        Kunde = DYNAMIC-FUNCTION('GETADRESSEANZEIGEBR':U,
                                  INPUT SpezPrei.Knr, INPUT 0)  NO-ERROR.

        PUT CONTROL '£'.
        PUT CONTROL STRING(SpezPrei.Knr      ,'999999')      '£'
                           Kunde                            '£'
                    STRING(SpezPrei.Menge    ,'zzzzzz')     '£'
                    STRING(SpezPrei.Ab_Datum ,'99.99.9999') '£'
                    STRING(SpezPrei.Bis_Datum,'99.99.9999') '£'
                    STRING(SpezPrei.Proz_Betr,'%/Fr')       '£'
                    STRING(SpezPrei.Wert     ,'>>>>9.999')  CHR(10).
    END.
    OUTPUT CLOSE.

    RUN OPENEXCEL ( INPUT excelAppl,
                    INPUT DateiName,
                    INPUT '',
                    OUTPUT Ja ).
    IF NOT Ja THEN DO:
        RUN FEHLER ( INPUT 1040 ).
        RETURN NO-APPLY.
    END.

    Zelle = 'A3'.
    excelAppl:Range(Zelle):SELECT.
    excelAppl:Selection:FormulaR1C1 = 'TEXT;' + DatenName.
    excelAppl:Application:RUN ( 'DateiEinfügen' ).

    RUN KOPF ( INPUT excelAppl ).

    Zelle = 'A1'.
    excelAppl:Range(Zelle):SELECT.
    excelAppl:Selection:ColumnWidth = 0.3.
    
    DYNAMIC-FUNCTION('RELEASEEXCEL':U, INPUT excelAppl ) NO-ERROR.
END.

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE RETURN_FELD vTableWin 
PROCEDURE RETURN_FELD :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  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:  <none>
  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.
        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:       
------------------------------------------------------------------------------*/

    DO WITH FRAME {&FRAME-NAME}:
        rowObject.Knr:SCREEN-VALUE       = F_Knr:SCREEN-VALUE.
        rowObject.Proz_Betr:SCREEN-VALUE = CB_Art:SCREEN-VALUE.
        DYNAMIC-FUNCTION('SETMODIFIEDFLAG':U, INPUT Fenster, INPUT TRUE).

        rowObject.VP_Norm:MODIFIED  = FALSE.
        rowObject.Marge:MODIFIED    = FALSE.
        rowObject.AltPreis:MODIFIED = FALSE.
        F_Wert:MODIFIED             = FALSE.
    END.

    FNeu  = FALSE.
    FCopy = FALSE.
    RUN SUPER.

    /* Code placed here will execute AFTER standard behavior.    */

END PROCEDURE.

/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME