GeMIS_WEB/GUI/v-aktpreis.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-aktpreis.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  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:  <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.

    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:  <none>
  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:  <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('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:  <none>
  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:  <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.
            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