GeMIS_WEB/GUI/g-skontorechnen.w

&ANALYZE-SUSPEND _VERSION-NUMBER AB_v9r12 GUI ADM2
&ANALYZE-RESUME
&Scoped-define WINDOW-NAME CURRENT-WINDOW
&Scoped-define FRAME-NAME gSkontoRechnen
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gSkontoRechnen 
/*------------------------------------------------------------------------

  File: 

  Description: from cntnrdlg.w - ADM2 SmartDialog Template

  Input Parameters:
      <none>

  Output Parameters:
      <none>

  Author: 

  Created: 
------------------------------------------------------------------------*/
/*          This .W file was created with the Progress AppBuilder.      */
/*----------------------------------------------------------------------*/

/* Create an unnamed pool to store all the widgets created 
     by this procedure. This is a good default which assures
     that this procedure's triggers and internal procedures 
     will execute in this procedure's storage, and that proper
     cleanup will occur on deletion of the procedure. */

CREATE WIDGET-POOL.

/* ***************************  Definitions  ************************** */

/* Parameters Definitions ---                                           */

/* Local Variable Definitions ---                                       */

DEF VAR MaxPage         AS INT                      NO-UNDO.
DEF VAR AktSeite        AS INT                      NO-UNDO.
DEF VAR FMutFlag        AS LOG                      NO-UNDO.
DEF VAR Firma           AS CHAR                     NO-UNDO.
DEF VAR AdFirma         AS CHAR                     NO-UNDO.

DEF TEMP-TABLE  TSko        LIKE SkontoAb
                            USE-INDEX SkontoAb-k1 AS PRIMARY.

DEF BUFFER      BSko        FOR TSko.

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


&ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK 

/* ********************  Preprocessor Definitions  ******************** */

&Scoped-define PROCEDURE-TYPE SmartDialog
&Scoped-define DB-AWARE no

&Scoped-define ADM-CONTAINER DIALOG-BOX

&Scoped-define ADM-SUPPORTED-LINKS Data-Target,Data-Source,Page-Target,Update-Source,Update-Target

/* Name of first Frame and/or Browse and/or first Query                 */
&Scoped-define FRAME-NAME gSkontoRechnen

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS F_VonKnr F_BisKnr F_VonDatum F_BisDatum ~
Btn_Rechnen F_Kunde RECT-21 
&Scoped-Define DISPLAYED-OBJECTS F_VonKnr F_BisKnr F_VonDatum F_BisDatum ~
F_Kunde 

/* Custom List Definitions                                              */
/* List-1,List-2,List-3,List-4,List-5,List-6                            */
&Scoped-define List-6 F_VonKnr F_BisKnr F_VonDatum F_BisDatum 

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



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

/* Define a dialog box                                                  */

/* Definitions of the field level widgets                               */
DEFINE BUTTON Btn_Rechnen 
     LABEL "Rechnen" 
     SIZE 12 BY 1.

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

DEFINE VARIABLE F_BisKnr AS INTEGER FORMAT "999999":U INITIAL 0 
     LABEL "--" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 11 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_Kunde AS CHARACTER FORMAT "X(256)":U 
     VIEW-AS FILL-IN NATIVE 
     SIZE 85 BY 1
     BGCOLOR 15  NO-UNDO.

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

DEFINE VARIABLE F_VonKnr AS INTEGER FORMAT "999999":U INITIAL 0 
     LABEL "von - bis Kundennummer" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 11 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE RECTANGLE RECT-21
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL 
     SIZE 89 BY 6.19.


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

DEFINE FRAME gSkontoRechnen
     F_VonKnr AT ROW 2 COL 28 COLON-ALIGNED
     F_BisKnr AT ROW 2 COL 48 COLON-ALIGNED
     F_VonDatum AT ROW 3 COL 28 COLON-ALIGNED
     F_BisDatum AT ROW 3 COL 48 COLON-ALIGNED
     Btn_Rechnen AT ROW 2 COL 77
     F_Kunde AT ROW 5 COL 2 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     RECT-21 AT ROW 1.24 COL 2
     SPACE(1.59) SKIP(0.32)
    WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER 
         SIDE-LABELS NO-UNDERLINE THREE-D  SCROLLABLE 
         TITLE "Skontoabrechnung rechnen".


/* *********************** Procedure Settings ************************ */

&ANALYZE-SUSPEND _PROCEDURE-SETTINGS
/* Settings for THIS-PROCEDURE
   Type: SmartDialog
   Allow: Basic,Browse,DB-Fields,Query,Smart
   Container Links: Data-Target,Data-Source,Page-Target,Update-Source,Update-Target
   Design Page: 1
   Other Settings: COMPILE
 */
&ANALYZE-RESUME _END-PROCEDURE-SETTINGS

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB gSkontoRechnen 
/* ************************* Included-Libraries *********************** */

{src/adm2/containr.i}

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




/* ***********  Runtime Attributes and AppBuilder Settings  *********** */

&ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
/* SETTINGS FOR DIALOG-BOX gSkontoRechnen
   Custom                                                               */
ASSIGN 
       FRAME gSkontoRechnen:SCROLLABLE       = FALSE
       FRAME gSkontoRechnen:HIDDEN           = TRUE.

/* SETTINGS FOR FILL-IN F_BisDatum IN FRAME gSkontoRechnen
   6                                                                    */
/* SETTINGS FOR FILL-IN F_BisKnr IN FRAME gSkontoRechnen
   6                                                                    */
ASSIGN 
       F_Kunde:READ-ONLY IN FRAME gSkontoRechnen        = TRUE.

/* SETTINGS FOR FILL-IN F_VonDatum IN FRAME gSkontoRechnen
   6                                                                    */
/* SETTINGS FOR FILL-IN F_VonKnr IN FRAME gSkontoRechnen
   6                                                                    */
/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


/* Setting information for Queries and Browse Widgets fields            */

&ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gSkontoRechnen
/* Query rebuild information for DIALOG-BOX gSkontoRechnen
     _Options          = "SHARE-LOCK"
     _Query            is NOT OPENED
*/  /* DIALOG-BOX gSkontoRechnen */
&ANALYZE-RESUME

 



/* ************************  Control Triggers  ************************ */

&Scoped-define SELF-NAME gSkontoRechnen
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSkontoRechnen gSkontoRechnen
ON END-ERROR OF FRAME gSkontoRechnen /* Skontoabrechnung rechnen */
DO:
    RUN ENDE.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSkontoRechnen gSkontoRechnen
ON GO OF FRAME gSkontoRechnen /* Skontoabrechnung rechnen */
DO:
    /*
    RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ) NO-ERROR.
    */
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSkontoRechnen gSkontoRechnen
ON WINDOW-CLOSE OF FRAME gSkontoRechnen /* Skontoabrechnung rechnen */
DO:  
    RUN ENDE.
    RETURN NO-APPLY.
END.

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


&Scoped-define SELF-NAME Btn_Rechnen
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Rechnen gSkontoRechnen
ON CHOOSE OF Btn_Rechnen IN FRAME gSkontoRechnen /* Rechnen */
DO:
    RUN RECHNEN.
END.

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


&UNDEFINE SELF-NAME

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


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

    MaxPage  = 1.
    AktSeite = 1.

    SESSION:DATA-ENTRY-RETURN = TRUE.

    SUBSCRIBE TO 'TOOLBAR' ANYWHERE.

/*  TRIGGERS    ------------------------------------------------------  */

    ON 'ALT-CURSOR-RIGHT':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN NEXTPAGE.
    END.
    ON 'ALT-CURSOR-LEFT':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN PREVPAGE.
    END.
    ON 'U1':U OF {&WINDOW-NAME} ANYWHERE
    DO:
        RUN ENTRY_CURSOR.
    END.
/*
    ON 'PAGE-DOWN':U OF {&WINDOW-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'Next':U ).
    END.
    ON 'PAGE-UP':U OF {&WINDOW-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'Prev':U ).
    END.
    
    ON 'ALT-RETURN':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'UPDATE':U ).
    END.
    ON 'ALT-INS':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'ADD':U    ).
    END.
    ON 'ALT-DEL':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'DELETE':U ).
    END.
    ON 'ALT-R':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'RESET':U  ).
    END.
    ON 'F9':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'SAVE':U   ).
    END.
    ON 'ALT-S':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'SAVE':U   ).
    END.
    ON 'ALT-K':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'COPY':U   ).
    END.

    ON 'END-ERROR':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        FMutFlag = DYNAMIC-FUNCTION('getMutflagAlt':U) NO-ERROR.
        IF FMutFlag = FALSE THEN DO:
            RUN ENDE.
            RETURN NO-APPLY.
        END.
        RUN TOOLBAR IN h_dyntoolbar ( INPUT 'CANCEL':U ).
        RETURN NO-APPLY.
    END.
*/    
/*  ------------------------------------------------------------------  */

    {src/adm2/dialogmn.i}

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


/* **********************  Internal Procedures  *********************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects gSkontoRechnen  _ADM-CREATE-OBJECTS
PROCEDURE adm-create-objects :
/*------------------------------------------------------------------------------
  Purpose:     Create handles for all SmartObjects used in this procedure.
               After SmartObjects are initialized, then SmartLinks are added.
  Parameters:  <none>
------------------------------------------------------------------------------*/

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE changePage gSkontoRechnen 
PROCEDURE changePage :
/*------------------------------------------------------------------------------
  Purpose:     Super Override
  Parameters:  
  Notes:       
------------------------------------------------------------------------------*/

  /* Code placed here will execute PRIOR to standard behavior. */

    RUN SUPER.

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).

    CASE AktSeite:

        WHEN 1 THEN DO:
/*           RUN addLink ( h_dyntoolbar , 'TableIO':U    , h_v-auftr        ). */
/*           RUN addLink ( h_dyntoolbar , 'Navigation':U , h_d-auftr        ). */
/*           RUN ToolbarInit ( INPUT h_d-auftr ).                              */
            RUN ENTRY_CURSOR.
        END.
        WHEN 2 THEN DO:
            RUN ENTRY_CURSOR.
        END.

    END CASE.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gSkontoRechnen  _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 gSkontoRechnen.
END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gSkontoRechnen 
PROCEDURE enableObject :
/*------------------------------------------------------------------------------
  Purpose:     Super Override
  Parameters:  
  Notes:       
------------------------------------------------------------------------------*/

    /* Code placed here will execute PRIOR to standard behavior. */

    RUN SUPER.

    RUN FENSTER_TITEL ( INPUT FRAME {&FRAME-NAME}:HANDLE ) NO-ERROR.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gSkontoRechnen  _DEFAULT-ENABLE
PROCEDURE enable_UI :
/*------------------------------------------------------------------------------
  Purpose:     ENABLE the User Interface
  Parameters:  <none>
  Notes:       Here we display/view/enable the widgets in the
               user-interface.  In addition, OPEN all queries
               associated with each FRAME and BROWSE.
               These statements here are based on the "Other 
               Settings" section of the widget Property Sheets.
------------------------------------------------------------------------------*/
  DISPLAY F_VonKnr F_BisKnr F_VonDatum F_BisDatum F_Kunde 
      WITH FRAME gSkontoRechnen.
  ENABLE F_VonKnr F_BisKnr F_VonDatum F_BisDatum Btn_Rechnen F_Kunde RECT-21 
      WITH FRAME gSkontoRechnen.
  VIEW FRAME gSkontoRechnen.
  {&OPEN-BROWSERS-IN-QUERY-gSkontoRechnen}
END PROCEDURE.

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

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

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U) NO-ERROR.

    IF AktSeite > 1 THEN DO:
        RUN selectPage ( INPUT 1 ).
        RETURN NO-APPLY.
    END.

    RUN ENDE_PROGRAMM ( INPUT THIS-PROCEDURE:FILE-NAME ).
    APPLY 'GO' TO FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.

END PROCEDURE.

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

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

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).

    CASE AktSeite:
/*         WHEN 1 THEN RUN applyEntry IN h_v-adresse  ( INPUT ? ). */
/*         WHEN 2 THEN RUN applyEntry IN h_f-adrkomm  ( INPUT ? ). */
/*         WHEN 3 THEN RUN applyEntry IN h_b-auftbb   ( INPUT ? ). */
/*         WHEN 4 THEN RUN applyEntry IN h_b-aufdet   ( INPUT ? ). */
/*         WHEN 5 THEN RUN applyEntry IN h_b-aufstreu ( INPUT ? ). */
/*         WHEN 6 THEN RUN applyEntry IN h_b-auffak   ( INPUT ? ). */
/*         WHEN 7 THEN RUN applyEntry IN h_b-position ( INPUT ? ). */
    END CASE.

    RETURN NO-APPLY.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE exitObject gSkontoRechnen 
PROCEDURE exitObject :
/*------------------------------------------------------------------------------
  Purpose:     Super Override
  Parameters:  
  Notes:       
------------------------------------------------------------------------------*/

    RUN ENDE.
    RETURN NO-APPLY.

END PROCEDURE.

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

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

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
    IF AktSeite = MaxPage THEN AktSeite = 1.
    ELSE                       AktSeite = AktSeite + 1.

    RUN selectPage ( INPUT AktSeite ).

END PROCEDURE.

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

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

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).
    IF AktSeite = 1 THEN AktSeite = MaxPage.
    ELSE                 AktSeite = AktSeite - 1.

    RUN selectPage ( INPUT AktSeite ).

END PROCEDURE.

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

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

    DEF VAR FwSprcd     AS INT                          NO-UNDO.
    DEF VAR Rundbetr    AS DEC  DECIMALS 4              NO-UNDO.
    DEF VAR VBrutto     AS DEC  DECIMALS 4              NO-UNDO.
    DEF VAR VNetto      AS DEC  DECIMALS 4              NO-UNDO.
    DEF VAR VMwst       AS DEC  DECIMALS 4              NO-UNDO.
    DEF VAR VProz       AS DEC  DECIMALS 4              NO-UNDO.
    DEF VAR VSkonto     AS DEC  DECIMALS 4              NO-UNDO.
    DEF VAR TSkonto     AS DEC  DECIMALS 4  EXTENT 10   NO-UNDO.
    DEF VAR PSkonto     AS DEC  DECIMALS 4  EXTENT 10   NO-UNDO.
    DEF VAR MaxMWST     AS INT                          NO-UNDO.
    DEF VAR VTage       AS INT                          NO-UNDO.
    DEF VAR Berechtigt  AS LOG                          NO-UNDO.
    DEF VAR Inklusive   AS LOG                          NO-UNDO.
    DEF VAR VWuCd       AS INT                          NO-UNDO.
    DEF VAR VArt        AS INT                          NO-UNDO.
    DEF VAR VWert       AS DEC  DECIMALS 4              NO-UNDO.
    DEF VAR VDatum      AS DATE FORMAT "99.99.9999"     NO-UNDO.
    DEF VAR i1          AS INT                          NO-UNDO.

DO WITH FRAME {&FRAME-NAME}:
    ASSIGN  {&List-6}.
    IF F_VonKnr = 0         AND
       F_BisKnr = 0         THEN F_BisKnr = 999999.
    IF F_VonKnr > F_BisKnr  THEN F_BisKnr = F_VonKnr.
    
    IF F_VonDatum = ?       THEN F_VonDatum = 01/01/0001.
    IF F_BisDatum = ? THEN DO:
       F_BisDatum = TODAY.
        DO WHILE TRUE.
            IF MONTH(F_BisDatum + 1) <> MONTH(F_BisDatum) THEN LEAVE.
            F_BisDatum = F_BisDatum - 1.
        END.
    END.
    DISPLAY {&List-6}.
    
    DISABLE Btn_Rechnen.

    Firma   = DYNAMIC-FUNCTION('GETMANDANT':U)      NO-ERROR.
    AdFirma = DYNAMIC-FUNCTION('GETADMANDANT':U)    NO-ERROR.
    FwSprcd = DYNAMIC-FUNCTION('GETFWSPRCD':U)      NO-ERROR.
    F_Kunde = 'Löschen der nicht verbuchten Skonti'.
    DISPLAY F_Kunde.
    
    FOR EACH SkontoAb USE-INDEX SkontoAb-k1
                      WHERE SkontoAb.Firma    = Firma
                      AND   SkontoAb.Sko_Sta  = 0
                      AND   SkontoAb.Knr     >= F_VonKnr
                      AND   SkontoAb.Knr     <= F_BisKnr :
        DELETE  SkontoAb.
    END.
    
    F_Kunde = 'Aufbereiten der Rechnungen'.
    DISPLAY F_Kunde.
    
    VWucd = -1.
    FOR EACH TSko:
        DELETE  TSko.
    END.

    FOR EACH Savko USE-INDEX Savko-k6
                   WHERE Savko.Firma      = Firma
                   AND   Savko.Knr       >= F_VonKnr
                   AND   Savko.Knr       <= F_BisKnr
                   AND   Savko.Fak_Datum >= F_VonDatum
                   AND   Savko.Fak_Datum <= F_BisDatum  NO-LOCK,
        EACH Savze USE-INDEX Savze-k1
                   WHERE Savze.Firma      = Savko.Firma
                   AND   Savze.Aufnr      = Savko.Aufnr
                   AND   Savze.Artnr     <> 0
                   AND   Savze.Trnr      <> 0
                   AND   Savze.MWST%      = 0 :
        FIND LAST MWSTAns USE-INDEX MWSTAns-k1
                          WHERE MWSTAns.MWST_Cd = Savze.WuCd
                          AND   MWSTAns.Datum  <= Savko.Fak_Datum NO-LOCK.
        Savze.MWST% = MWSTAns.Ansatz.
    END.

    FOR EACH Savko USE-INDEX Savko-k6
                   WHERE Savko.Firma      = Firma
                   AND   Savko.Knr       >= F_VonKnr
                   AND   Savko.Knr       <= F_BisKnr
                   AND   Savko.Fak_Datum >= F_VonDatum
                   AND   Savko.Fak_Datum <= F_BisDatum  NO-LOCK,
        EACH Savze USE-INDEX Savze-k1
                   WHERE Savze.Firma      = Savko.Firma
                   AND   Savze.Aufnr      = Savko.Aufnr
                   AND   Savze.Artnr     <> 0
                   AND   Savze.Trnr      <> 0           NO-LOCK
                   
                   BREAK BY Savko.Firma
                         BY Savko.Fak_Knr
                         BY Savko.Faknr
                         BY Savze.MWST%
                         BY Savze.MWST_Inkl :

        IF FIRST-OF ( Savko.Fak_Knr ) THEN DO:
            FIND Adresse USE-INDEX Adresse-k1
                         WHERE Adresse.Firma = AdFirma
                         AND   Adresse.Knr   = Savko.Fak_Knr NO-LOCK NO-ERROR.
            F_Kunde = STRING(Savko.Fak_Knr,"999999 / ") + Adresse.Anzeig_Br.
            DISPLAY F_Kunde WITH FRAME {&FRAME-NAME}.
        END.

        IF FIRST-OF ( Savko.Faknr ) THEN DO:
            FIND Kondi USE-INDEX Kondi-k1
                       WHERE Kondi.Sprcd = FwSprcd
                       AND   Kondi.Kond  = Savko.Kond NO-LOCK NO-ERROR.
            IF Kondi.Skonto[01] = 0 THEN Berechtigt = FALSE.
            ELSE                         Berechtigt = TRUE.
            VTage = Kondi.Tage[01].
            VProz = Kondi.Skonto[01].
        END.
        DO WHILE FIRST-OF ( Savze.MWST_Inkl ):
            VBrutto    = 0.
            VNetto     = 0.
            LEAVE.
        END.

        DO WHILE Berechtigt:
            IF Savze.Sk_Ber THEN DO:
                VBrutto = VBrutto + Savze.Net_Betr
                                  - Savze.Auf_Rab
                                  - Savze.Abh_Rab
                                  - Savze.Auf_Sp_Rab.
            END.
            IF NOT LAST-OF ( Savze.MWST_Inkl ) THEN LEAVE.
            
            IF VBrutto = 0 THEN LEAVE.

            IF Savze.MWST_Inkl THEN VNetto = VBrutto * 100 / (100 + Savze.MWST%).
            ELSE                    VNetto = VBrutto.

            FIND TSko USE-INDEX SkontoAb-k1
                      WHERE TSko.Firma    = Savko.Firma
                      AND   TSko.Sko_Sta  = 0
                      AND   TSko.Knr      = Savko.Fak_Knr
                      AND   TSko.VonDatum = F_VonDatum
                      AND   TSko.Faknr    = Savko.Faknr
                      AND   TSko.MWST-%   = Savze.MWST% NO-ERROR.
            IF NOT AVAILABLE TSko THEN DO:
                CREATE  TSko.
                ASSIGN  TSko.Firma      = Savko.Firma
                        TSko.Sko_Sta    = 0
                        TSko.Knr        = Savko.Fak_Knr
                        TSko.VonDatum   = F_VonDatum
                        TSko.Faknr      = Savko.Faknr
                        TSko.Fak_Datum  = Savko.Fak_Datum
                        TSko.MWST-%     = Savze.MWST%
                        TSko.Netto      = VNetto
                        TSko.BisDatum   = F_BisDatum
                        TSko.Sko_Datum  = TSko.Fak_Datum + VTage
                        TSko.Sko_Proz   = VProz.
            END.
            ELSE DO:
                ASSIGN  TSko.Netto      = TSko.Netto  + VNetto.
            END.
            TSko.MWST_Betrag = TSko.Netto  * Savze.MWST% / 100.
            TSko.Brutto      = TSko.Netto  + TSko.MWST_Betrag.
            TSko.Sko_Betr    = TSko.Brutto * VProz       / 100.
            
            LEAVE.
        END.
                
        IF NOT LAST-OF ( Savko.Fak_Knr ) THEN NEXT.
        
        FOR EACH TSko USE-INDEX SkontoAb-k1

                      BREAK BY TSko.Firma
                            BY TSko.Sko_Sta
                            BY TSko.Knr
                            BY TSko.Faknr
                            BY TSko.MWST-%  :

            IF FIRST-OF ( TSko.Faknr ) THEN DO:
                VDatum  = ?.
                VSkonto = 0.
                TSkonto = 0.
                PSkonto = 0.
                MaxMWST = 0.
                VBrutto = 0.
                FOR EACH Debhi USE-INDEX Debhi-k3
                               WHERE Debhi.Firma = TSko.Firma
                               AND   Debhi.Knr   = TSko.Knr
                               AND   Debhi.Faknr = TSko.Faknr
                               AND   Debhi.Soll  = 0    NO-LOCK:
                    IF VDatum = ?            THEN VDatum = Debhi.Datum.
                    IF Debhi.Datum > VDatum  THEN VDatum = Debhi.Datum.
                    VSkonto  = VSkonto + Debhi.Skonto.
                END.
            END.
                
            MaxMWST          = MaxMWST + 1.
            PSkonto[MaxMWST] = TSko.MWST-%.
            TSkonto[MaxMWST] = TSko.Netto + TSko.MWST_Betrag.
            VBrutto          = VBrutto    + TSko.Brutto.
            
            TSko.Zah_Datum = VDatum.
            IF VDatum = ? THEN DO:
                TSko.Anz_Tage  = TODAY - TSko.Sko_Datum.
            END.
            ELSE DO:
                TSko.Anz_Tage  = TSko.Zah_Datum - TSko.Sko_Datum.
            END.
            IF TSko.Anz_Tage <= 0 THEN TSko.Berechtigt = TRUE.
            ELSE                       TSko.Berechtigt = FALSE. 
            
            IF NOT LAST-OF ( TSko.Faknr ) THEN NEXT.
            
            VNetto = VSkonto.
            i1     = 0.
            FOR EACH BSko USE-INDEX SkontoAb-k1
                          WHERE BSko.Firma   = TSko.Firma
                          AND   BSko.Sko_Sta = TSko.Sko_Sta
                          AND   BSko.Knr     = TSko.Knr
                          AND   BSko.Faknr   = TSko.Faknr :
                i1 = i1 + 1.
                IF i1 = MaxMWST THEN BSko.Sko_Abzug = VNetto.
                ELSE DO:
                    Rundbetr       = TSkonto[i1] * 100 / VBrutto.
                    Rundbetr       = VSkonto * Rundbetr / 100.
                    VNetto         = VNetto - Rundbetr.
                    BSko.Sko_Abzug = Rundbetr.
                END.
            END.
            
            IF NOT LAST-OF ( TSko.Knr ) THEN NEXT.
            
            FOR EACH BSko USE-INDEX SkontoAb-k1
                          WHERE BSko.Firma   = TSko.Firma
                          AND   BSko.Sko_Sta = TSko.Sko_Sta
                          AND   BSko.Knr     = TSko.Knr :
                CREATE  SkontoAb.
                BUFFER-COPY BSko TO SkontoAb.
                DELETE  BSko.
            END.
        END.
    END.
END.

    RUN ENDE.
    
END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE selectPage gSkontoRechnen 
PROCEDURE selectPage :
/*------------------------------------------------------------------------------
  Purpose:     Super Override
  Parameters:  
  Notes:       
------------------------------------------------------------------------------*/

    DEF INPUT PARAMETER piPageNum   AS INT                      NO-UNDO.

    DEF VAR FMutFlag        AS LOG                      NO-UNDO.
    DEF VAR MutProg         AS CHAR                     NO-UNDO.

    FMutFlag = DYNAMIC-FUNCTION('getMutflagAlt':U) NO-ERROR.
    DO WHILE TRUE:
        IF NOT FMutFlag THEN LEAVE.
        MutProg = DYNAMIC-FUNCTION('GETMUTPROG':U).
        IF MutProg <> THIS-PROCEDURE:FILE-NAME THEN LEAVE.
        RETURN NO-APPLY.
    END.

    CASE piPageNum:

    END CASE.

    AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U).

    CASE AktSeite:

        WHEN 1 THEN DO:
/*             RUN removeLink ( h_dyntoolbar , 'TableIO':U    , h_v-auftr       ). */
/*             RUN removeLink ( h_dyntoolbar , 'Navigation':U , h_d-auftr       ). */
        END.

    END CASE.

    RUN SUPER( INPUT piPageNum).

END PROCEDURE.

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

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

    DEF INPUT PARAMETER pcAction    AS CHAR             NO-UNDO.
/*    
    RUN TOOLBAR IN h_dyntoolbar ( INPUT pcAction ).
*/
END PROCEDURE.

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