GeMIS_WEB/GUI/b-aufze.w

&ANALYZE-SUSPEND _VERSION-NUMBER AB_v10r12 GUI ADM2
&ANALYZE-RESUME
/* Connected Databases 
          anadat           PROGRESS
*/
&Scoped-define WINDOW-NAME CURRENT-WINDOW
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS bTableWin 
/*------------------------------------------------------------------------

  File: adm2\src\browser.w

  Description: SmartDataBrowser Object

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

/* Parameters Definitions ---                                           */

/* Local Variable Definitions ---                                       */

{ incl/tmpbrowser.i }

{src/adm2/widgetprto.i}

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


&ANALYZE-SUSPEND _UIB-PREPROCESSOR-BLOCK 

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

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

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

/* Include file with RowObject temp-table definition */
&Scoped-define DATA-FIELD-DEFS "d-aufze.i"

/* Name of designated FRAME-NAME and/or first browse and/or first query */
&Scoped-define FRAME-NAME F-Main
&Scoped-define BROWSE-NAME br_aufze

/* Internal Tables (found by Frame, Query & Browse Queries)             */
&Scoped-define INTERNAL-TABLES rowObject

/* Definitions for BROWSE br_aufze                                      */
&Scoped-define FIELDS-IN-QUERY-br_aufze rowObject.VGebinde ~
rowObject.KGebinde rowObject.MBest rowObject.Artnr rowObject.Bezeichnung ~
rowObject.Jahr rowObject.GGeb_Me rowObject.VGeb_Me rowObject.MGeli ~
rowObject.Preis rowObject.MRuek rowObject.Rab_Wert rowObject.Rab_Su_Grp ~
rowObject.WuCd rowObject.Inhalt rowObject.Net_Betr rowObject.Pos ~
rowObject.Aktion 
&Scoped-define ENABLED-FIELDS-IN-QUERY-br_aufze 
&Scoped-define QUERY-STRING-br_aufze FOR EACH rowObject NO-LOCK INDEXED-REPOSITION
&Scoped-define OPEN-QUERY-br_aufze OPEN QUERY br_aufze FOR EACH rowObject NO-LOCK INDEXED-REPOSITION.
&Scoped-define TABLES-IN-QUERY-br_aufze rowObject
&Scoped-define FIRST-TABLE-IN-QUERY-br_aufze rowObject


/* Definitions for FRAME F-Main                                         */

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS RECT-1 RECT-16 RECT-17 RECT-18 RECT-19 ~
RECT-20 RECT-21 RECT-22 br_aufze 

/* Custom List Definitions                                              */
/* List-1,List-2,List-3,List-4,List-5,List-6                            */

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


/* ************************  Function Prototypes ********************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION-FORWARD setZeilenfarbe bTableWin 
FUNCTION setZeilenfarbe RETURNS LOGICAL
    ( ipFarbe AS INT  )  FORWARD.

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


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


/* Menu Definitions                                                     */
DEFINE MENU POPUP-MENU-br_aufze 
       MENU-ITEM X_BESCHAFFUNGSAUFTRAG LABEL "Neuer Auftrag für Beschaffungsartikel".


/* Definitions of the field level widgets                               */
DEFINE RECTANGLE RECT-1
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL   
     SIZE 182 BY 13.1.

DEFINE RECTANGLE RECT-16
     EDGE-PIXELS 2 GRAPHIC-EDGE    
     SIZE 3 BY .71
     BGCOLOR 14 .

DEFINE RECTANGLE RECT-17
     EDGE-PIXELS 2 GRAPHIC-EDGE    
     SIZE 3 BY .71
     BGCOLOR 10 .

DEFINE RECTANGLE RECT-18
     EDGE-PIXELS 2 GRAPHIC-EDGE    
     SIZE 3 BY .71
     BGCOLOR 11 .

DEFINE RECTANGLE RECT-19
     EDGE-PIXELS 2 GRAPHIC-EDGE    
     SIZE 3 BY .71
     BGCOLOR 8 .

DEFINE RECTANGLE RECT-20
     EDGE-PIXELS 2 GRAPHIC-EDGE    
     SIZE 3 BY .71
     BGCOLOR 11 .

DEFINE RECTANGLE RECT-21
     EDGE-PIXELS 2 GRAPHIC-EDGE    
     SIZE 3 BY .71
     BGCOLOR 13 .

DEFINE RECTANGLE RECT-22
     EDGE-PIXELS 2 GRAPHIC-EDGE    
     SIZE 3 BY .71
     BGCOLOR 12 .

/* Query definitions                                                    */
&ANALYZE-SUSPEND
DEFINE TEMP-TABLE RowObject NO-UNDO
    {{&DATA-FIELD-DEFS}}
    {src/adm2/robjflds.i}.

DEFINE QUERY br_aufze FOR 
      rowObject SCROLLING.
&ANALYZE-RESUME

/* Browse definitions                                                   */
DEFINE BROWSE br_aufze
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS br_aufze bTableWin _STRUCTURED
  QUERY br_aufze NO-LOCK DISPLAY
      rowObject.VGebinde FORMAT "x(12)":U WIDTH 10
      rowObject.KGebinde FORMAT "x(12)":U WIDTH 10
      rowObject.MBest COLUMN-LABEL "Bestellt" FORMAT "zzzz9.99-":U
      rowObject.Artnr FORMAT "999999":U
      rowObject.Bezeichnung FORMAT "x(40)":U WIDTH 35
      rowObject.Jahr FORMAT "9999":U
      rowObject.GGeb_Me COLUMN-LABEL "GGeb" FORMAT "zzz,zz9.99-":U
            WIDTH 10
      rowObject.VGeb_Me COLUMN-LABEL "VGeb" FORMAT "zzz,zz9.99-":U
            WIDTH 10
      rowObject.MGeli COLUMN-LABEL "Geliefert" FORMAT "zzzz9.99-":U
      rowObject.Preis FORMAT "zzz,zz9.999":U
      rowObject.MRuek COLUMN-LABEL "Rückstand" FORMAT "zzzz9.99-":U
      rowObject.Rab_Wert COLUMN-LABEL "Rabatt" FORMAT "zz9.9999-":U
      rowObject.Rab_Su_Grp COLUMN-LABEL "RSG" FORMAT "999":U
      rowObject.WuCd COLUMN-LABEL "MW" FORMAT "99":U
      rowObject.Inhalt FORMAT "9999":U
      rowObject.Net_Betr COLUMN-LABEL "Betrag" FORMAT "zzz,zzz,zz9.999-":U
            WIDTH 10
      rowObject.Pos FORMAT "99999":U
      rowObject.Aktion COLUMN-LABEL "AK" FORMAT "1/0":U
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
    WITH NO-ASSIGN NO-AUTO-VALIDATE NO-ROW-MARKERS SEPARATORS SIZE 180 BY 12.62.


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

DEFINE FRAME F-Main
     br_aufze AT ROW 1.48 COL 3 WIDGET-ID 200
     "Rückstand" VIEW-AS TEXT
          SIZE 14 BY .71 AT ROW 14.48 COL 7 WIDGET-ID 6
     "Aktion" VIEW-AS TEXT
          SIZE 14 BY .71 AT ROW 14.48 COL 27 WIDGET-ID 10
     "Spezialpreis" VIEW-AS TEXT
          SIZE 14 BY .71 AT ROW 14.48 COL 47 WIDGET-ID 14
     "Beschaffungsartikel" VIEW-AS TEXT
          SIZE 21.6 BY .71 AT ROW 14.48 COL 133.4 WIDGET-ID 26
     "/ ->ganze Zeile" VIEW-AS TEXT
          SIZE 18.6 BY .71 AT ROW 14.48 COL 81 WIDGET-ID 28
          FONT 6
     "Ausverkauft" VIEW-AS TEXT
          SIZE 21.6 BY .71 AT ROW 14.48 COL 160.2 WIDGET-ID 32
     "ohne Lagerführung" VIEW-AS TEXT
          SIZE 19.6 BY .71 AT ROW 14.48 COL 106.4 WIDGET-ID 22
     "Nettoartikel" VIEW-AS TEXT
          SIZE 14 BY .71 AT ROW 14.48 COL 67 WIDGET-ID 18
     RECT-1 AT ROW 1.24 COL 2 WIDGET-ID 2
     RECT-16 AT ROW 14.48 COL 3 WIDGET-ID 4
     RECT-17 AT ROW 14.48 COL 23 WIDGET-ID 8
     RECT-18 AT ROW 14.48 COL 43 WIDGET-ID 12
     RECT-19 AT ROW 14.48 COL 63 WIDGET-ID 16
     RECT-20 AT ROW 14.48 COL 102.4 WIDGET-ID 20
     RECT-21 AT ROW 14.48 COL 129 WIDGET-ID 24
     RECT-22 AT ROW 14.48 COL 155.8 WIDGET-ID 30
    WITH 1 DOWN NO-BOX KEEP-TAB-ORDER OVERLAY 
         SIDE-LABELS NO-UNDERLINE THREE-D 
         AT COL 1 ROW 1 SCROLLABLE  WIDGET-ID 100.


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

&ANALYZE-SUSPEND _PROCEDURE-SETTINGS
/* Settings for THIS-PROCEDURE
   Type: SmartDataBrowser
   Data Source: "d-aufze.w"
   Allow: Basic,Browse
   Frames: 1
   Add Fields to: Neither
   Other Settings: PERSISTENT-ONLY COMPILE
 */

/* This procedure should always be RUN PERSISTENT.  Report the error,  */
/* then cleanup and return.                                            */
IF NOT THIS-PROCEDURE:PERSISTENT THEN DO:
  MESSAGE "{&FILE-NAME} should only be RUN PERSISTENT.":U
          VIEW-AS ALERT-BOX ERROR BUTTONS OK.
  RETURN.
END.

&ANALYZE-RESUME _END-PROCEDURE-SETTINGS

/* *************************  Create Window  ************************** */

&ANALYZE-SUSPEND _CREATE-WINDOW
/* DESIGN Window definition (used by the UIB) 
  CREATE WINDOW bTableWin ASSIGN
         HEIGHT             = 14.57
         WIDTH              = 184.
/* END WINDOW DEFINITION */
                                                                        */
&ANALYZE-RESUME

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

{src/adm2/browser.i}

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




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

&ANALYZE-SUSPEND _RUN-TIME-ATTRIBUTES
/* SETTINGS FOR WINDOW bTableWin
  NOT-VISIBLE,,RUN-PERSISTENT                                           */
/* SETTINGS FOR FRAME F-Main
   NOT-VISIBLE FRAME-NAME Size-to-Fit                                   */
/* BROWSE-TAB br_aufze RECT-22 F-Main */
ASSIGN 
       FRAME F-Main:SCROLLABLE       = FALSE
       FRAME F-Main:HIDDEN           = TRUE.

ASSIGN 
       br_aufze:POPUP-MENU IN FRAME F-Main             = MENU POPUP-MENU-br_aufze:HANDLE.

ASSIGN 
       rowObject.Aktion:VISIBLE IN BROWSE br_aufze = FALSE.

/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


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

&ANALYZE-SUSPEND _QUERY-BLOCK BROWSE br_aufze
/* Query rebuild information for BROWSE br_aufze
     _TblList          = "rowObject"
     _Options          = "NO-LOCK INDEXED-REPOSITION"
     _FldNameList[1]   > _<SDO>.rowObject.VGebinde
"rowObject.VGebinde" ? ? "character" ? ? ? ? ? ? no "?" no no "10" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[2]   > _<SDO>.rowObject.KGebinde
"rowObject.KGebinde" ? ? "character" ? ? ? ? ? ? no "?" no no "10" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[3]   > _<SDO>.rowObject.MBest
"rowObject.MBest" "Bestellt" ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[4]   = _<SDO>.rowObject.Artnr
     _FldNameList[5]   > _<SDO>.rowObject.Bezeichnung
"rowObject.Bezeichnung" ? ? "character" ? ? ? ? ? ? no ? no no "35" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[6]   = _<SDO>.rowObject.Jahr
     _FldNameList[7]   > _<SDO>.rowObject.GGeb_Me
"rowObject.GGeb_Me" "GGeb" ? "decimal" ? ? ? ? ? ? no "?" no no "10" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[8]   > _<SDO>.rowObject.VGeb_Me
"rowObject.VGeb_Me" "VGeb" ? "decimal" ? ? ? ? ? ? no "?" no no "10" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[9]   > _<SDO>.rowObject.MGeli
"rowObject.MGeli" "Geliefert" ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[10]   = _<SDO>.rowObject.Preis
     _FldNameList[11]   > _<SDO>.rowObject.MRuek
"rowObject.MRuek" "Rückstand" ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[12]   > _<SDO>.rowObject.Rab_Wert
"rowObject.Rab_Wert" "Rabatt" ? "decimal" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[13]   > _<SDO>.rowObject.Rab_Su_Grp
"rowObject.Rab_Su_Grp" "RSG" ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[14]   > _<SDO>.rowObject.WuCd
"rowObject.WuCd" "MW" ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[15]   > _<SDO>.rowObject.Inhalt
"rowObject.Inhalt" ? ? "integer" ? ? ? ? ? ? no "?" no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[16]   > _<SDO>.rowObject.Net_Betr
"rowObject.Net_Betr" "Betrag" ? "decimal" ? ? ? ? ? ? no ? no no "10" yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[17]   > _<SDO>.rowObject.Pos
"rowObject.Pos" ? "99999" "integer" ? ? ? ? ? ? no ? no no ? yes no no "U" "" "" "" "" "" "" 0 no 0 no no
     _FldNameList[18]   > _<SDO>.rowObject.Aktion
"rowObject.Aktion" "AK" ? "logical" ? ? ? ? ? ? no ? no no ? no no no "U" "" "" "" "" "" "" 0 no 0 no no
     _Query            is NOT OPENED
*/  /* BROWSE br_aufze */
&ANALYZE-RESUME

&ANALYZE-SUSPEND _QUERY-BLOCK FRAME F-Main
/* Query rebuild information for FRAME F-Main
     _Options          = "NO-LOCK"
     _Query            is NOT OPENED
*/  /* FRAME F-Main */
&ANALYZE-RESUME

 



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

&Scoped-define BROWSE-NAME br_aufze
&Scoped-define SELF-NAME br_aufze
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON CTRL-END OF br_aufze IN FRAME F-Main
DO:
        APPLY "END":U TO BROWSE {&BROWSE-NAME}.
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON CTRL-HOME OF br_aufze IN FRAME F-Main
DO:
        APPLY "HOME":U TO BROWSE {&BROWSE-NAME}.
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON CTRL-P OF br_aufze IN FRAME F-Main
DO:
        DEF VAR lMut AS LOG NO-UNDO.

        lMut = DYNAMIC-FUNCTION('getMutFlag':U, Progname ) NO-ERROR.
        IF lMut THEN 
        DO:
            APPLY 'U1'.
            RETURN NO-APPLY.
        END.
    
        RUN selectPage IN hFenster ( 1 ).
        PUBLISH 'CHOOSE-DRUCKEN' ( 'AUFZE' ).
        RETURN NO-APPLY.
    
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON CTRL-W OF br_aufze IN FRAME F-Main
DO:
        DEF VAR lMut AS LOG NO-UNDO.

        lMut = DYNAMIC-FUNCTION('getMutFlag':U, Progname ) NO-ERROR.
        IF lMut THEN 
        DO:
            APPLY 'U1'.
            RETURN NO-APPLY.
        END.
    
        RUN selectPage IN hFenster ( 1 ).
        PUBLISH 'CHOOSE-WEITER'.
        RETURN NO-APPLY.
    
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON CTRL-Z OF br_aufze IN FRAME F-Main
DO:
        DEF VAR lMut AS LOG NO-UNDO.

        lMut = DYNAMIC-FUNCTION('getMutFlag':U, Progname ) NO-ERROR.
        IF lMut THEN 
        DO:
            APPLY 'U1'.
            RETURN NO-APPLY.
        END.
    
        RUN selectPage IN hFenster ( 1 ).
        PUBLISH 'CHOOSE-ZURUECK'.
        RETURN NO-APPLY.
    
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON DEFAULT-ACTION OF br_aufze IN FRAME F-Main
DO:
    {src/adm2/brsdefault.i}
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON END OF br_aufze IN FRAME F-Main
DO:
    {src/adm2/brsend.i}
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON F5 OF br_aufze IN FRAME F-Main
DO:
        DEF VAR iRecid AS RECID NO-UNDO.
    
        DEF BUFFER bAufze FOR Aufze.

        iRecid = DYNAMIC-FUNCTION('getCurrentRecid':U IN hDaten ) NO-ERROR.
        IF iRecid = ? OR
            iRecid = 0 THEN RETURN NO-APPLY.
        DYNAMIC-FUNCTION('openQuery':U IN hDaten) NO-ERROR.
        FIND bAufze NO-LOCK WHERE RECID(bAufze) = iRecid NO-ERROR.
        DYNAMIC-FUNCTION('fetchRowIdent':U IN hDaten, STRING(ROWID(bAufze)), ? ) NO-ERROR.
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON HOME OF br_aufze IN FRAME F-Main
DO:
    {src/adm2/brshome.i}
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON LEFT-MOUSE-CLICK OF br_aufze IN FRAME F-Main
DO:
        APPLY 'ENTRY' TO {&BROWSE-NAME}.
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON LEFT-MOUSE-DBLCLICK OF br_aufze IN FRAME F-Main
DO:
        IF NOT VALID-HANDLE( hFenster ) THEN RETURN NO-APPLY.
        RUN TOOLBAR IN hFenster ( INPUT 'UPDATE' ).
        RETURN NO-APPLY.
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON OFF-END OF br_aufze IN FRAME F-Main
DO:
    {src/adm2/brsoffnd.i}
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON OFF-HOME OF br_aufze IN FRAME F-Main
DO:
    {src/adm2/brsoffhm.i}
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON RETURN OF br_aufze IN FRAME F-Main
DO:
        IF NOT VALID-HANDLE( hFenster ) THEN RETURN NO-APPLY.
        RUN TOOLBAR IN hFenster ( INPUT 'UPDATE' ).
        RETURN NO-APPLY.
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON ROW-DISPLAY OF br_aufze IN FRAME F-Main
DO:
        DEF VAR iFarbe AS INT NO-UNDO.
        DEFINE BUFFER bArtst FOR Artst.
    
        RELEASE bArtst.
        IF rowObject.Artnr > 0 THEN 
        DO:
            FIND bArtst NO-LOCK 
                WHERE bArtst.Firma  = rowObject.Firma
                AND   bArtst.Artnr  = rowObject.Artnr
                AND   bArtst.Inhalt = rowObject.Inhalt
                AND   bArtst.Jahr   = rowObject.Jahr .
        END.
    
        DO WITH FRAME {&FRAME-NAME}:
            iFarbe = 15.
            IF NOT rowObject.Lag_Buch AND cInstallation <> 'oswald' THEN iFarbe = 11.
            IF AVAILABLE bArtst THEN 
            DO:
                IF bArtst.Ausverk = 8     THEN iFarbe = 13.   /*  Beschaffungsartikel     */
                IF bArtst.Ausverk = 9     THEN iFarbe = 12.   /*  Ausverkauft             */
                IF bArtst.Aktiv = FALSE   THEN iFarbe = 12.   /*  gelöscht/inaktiv        */
            END.
            DYNAMIC-FUNCTION('setZeilenFarbe':U, iFarbe ) NO-ERROR.
            IF rowObject.MRuek <> 0   THEN rowObject.MRuek:BGCOLOR IN BROWSE {&BROWSE-NAME} = 14.
            IF rowObject.Netto        THEN rowObject.Preis:BGCOLOR IN BROWSE {&BROWSE-NAME} = 08.
            IF rowObject.PreisArt = 3 THEN rowObject.Preis:BGCOLOR IN BROWSE {&BROWSE-NAME} = 11.
            IF rowObject.PreisArt = 4    AND
                cInstallation <> 'oswald' THEN rowObject.Preis:BGCOLOR IN BROWSE {&BROWSE-NAME} = 11.
            IF rowObject.Aktion       THEN rowObject.Preis:BGCOLOR IN BROWSE {&BROWSE-NAME} = 10.
        
        /*        iFarbe = 0.                                                                 */
        /*        IF bArtst.Ausverk = 9     THEN iFarbe = 15.   /*  Ausverkauft             */*/
        /*        DYNAMIC-FUNCTION('setZeilenFarbe':U, iFarbe, 'F') NO-ERROR.                 */
        END.
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON ROW-ENTRY OF br_aufze IN FRAME F-Main
DO:
    {src/adm2/brsentry.i}
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON ROW-LEAVE OF br_aufze IN FRAME F-Main
DO:
    {src/adm2/brsleave.i}
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON SCROLL-NOTIFY OF br_aufze IN FRAME F-Main
DO:
        {src/adm2/brsscrol.i}
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON START-SEARCH OF br_aufze IN FRAME F-Main
DO:
        { incl/brwstartsearch.i }
    END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL br_aufze bTableWin
ON VALUE-CHANGED OF br_aufze IN FRAME F-Main
DO:
    {src/adm2/brschnge.i}
    END.

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


&UNDEFINE SELF-NAME

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


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

{ incl/brwmainblock.i }
{ incl/brwinternproc.i }

cInstallation = DYNAMIC-FUNCTION ('getInstallation':U) NO-ERROR.

SUBSCRIBE TO 'REFRESHAUFZE' ANYWHERE.

    &IF DEFINED(UIB_IS_RUNNING) <> 0 &THEN          
        RUN initializeObject.        
    &ENDIF

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


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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE BESCHAFFUNGSAUFTRAG bTableWin 
PROCEDURE BESCHAFFUNGSAUFTRAG :
/*------------------------------------------------------------------------------
     Purpose:
     Notes:
    ------------------------------------------------------------------------------*/

    DEFINE VARIABLE rAufze  AS RECID     NO-UNDO.
    DEFINE VARIABLE iPos    AS INTEGER   NO-UNDO.
    DEFINE VARIABLE iAufnr  AS INTEGER   NO-UNDO.
    DEFINE VARIABLE nTotal  AS DECIMAL   NO-UNDO DECIMALS 4 EXTENT 15.
    DEFINE VARIABLE cRetVal AS CHARACTER NO-UNDO.
    
    DEFINE BUFFER bAufze FOR Aufze.
    DEFINE BUFFER bAufko FOR Aufko.
    DEFINE BUFFER bDebst FOR Debst.
    
    rAufze = DYNAMIC-FUNCTION ('getCurrentRecid':U IN hDaten) NO-ERROR.
    IF  rAufze = ? OR 
        rAufze = 0 THEN RETURN NO-APPLY.
    FIND bAufze NO-LOCK WHERE RECID(bAufze) = rAufze.
    
    FIND bAufko NO-LOCK OF bAufze.
    FIND bDebst NO-LOCK
        WHERE bDebst.Firma = bAufko.Firma
        AND   bDebst.Knr   = bAufko.Knr.

    REPEAT TRANSACTION ON ERROR UNDO, LEAVE:    
        iAufnr = DYNAMIC-FUNCTION ('createAufnr':U, D1Firma) NO-ERROR.
        IF iAufnr = ? OR 
            iAufnr = 0 THEN LEAVE.
        CREATE  Aufko.
        BUFFER-COPY bAufko
            EXCEPT  Aufnr Fahrer LKW Tour_Nr1 Tour_Nr2 Faknr
            Fak_Datum Samm_Nr Fak_Art Auf_Sta Samm_Nr Gedruckt
            TO      Aufko
            ASSIGN  
            Aufko.Aufnr    = iAufnr
            Aufko.Tour_Nr1 = bDebst.Tour_Nr1
            Aufko.Tour_Nr2 = bDebst.Tour_Nr2
            Aufko.Fak_Art  = bDebst.Fak_Art
            Aufko.Auf_Sta  = 0
            Aufko.Gedruckt = FALSE.
        FOR EACH bAufze
            WHERE bAufze.Firma = D1Firma
            AND   bAufze.Aufnr = bAufko.Aufnr
            AND   bAufze.Artnr > 0,
        
            FIRST Artst NO-LOCK
            WHERE Artst.Firma  = bAufze.Firma
            AND   Artst.Artnr  = bAufze.Artnr
            AND   Artst.Inhalt = bAufze.Inhalt
            AND   Artst.Jahr   = bAufze.Jahr    :
            
            IF Artst.Ausverk <> 8 THEN NEXT.
        
            iPos = iPos + 5.
            CREATE  Aufze.
            BUFFER-COPY bAufze
                EXCEPT  Aufnr Pos
                TO      Aufze
                ASSIGN  
                Aufze.Aufnr = iAufnr
                Aufze.Pos   = iPos.
            DELETE bAufze.
        END.
        DYNAMIC-FUNCTION('createAufGebKo':U, iAufnr ) NO-ERROR.
        cRetVal = DYNAMIC-FUNCTION('calculateAuftragsTotal':U, D1Firma, iAufnr, OUTPUT nTotal ) NO-ERROR.
        RELEASE bAufko.
        RELEASE bAufze.
        RELEASE Aufko.
        RELEASE Aufze.
        RELEASE Artst.
        LEAVE.
    END.
    
    DYNAMIC-FUNCTION ('openQuery':U IN hDaten) NO-ERROR.
    APPLY 'U1'.
    RETURN NO-APPLY.                        

END PROCEDURE.

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

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

    DEF VAR hBrowser AS HANDLE NO-UNDO.

    hBrowser = {&BROWSE-NAME}:HANDLE IN FRAME {&FRAME-NAME}.
    DYNAMIC-FUNCTION('setBrowserDaten':U, INPUT hBrowser,
        INPUT Sektion ) NO-ERROR.

    RUN SUPER.

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

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI bTableWin  _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 ENTRY_BROWSE bTableWin 
PROCEDURE ENTRY_BROWSE :
/*------------------------------------------------------------------------------
          Purpose:     
          Parameters:  <none>
          Notes:       
        ------------------------------------------------------------------------------*/

    APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.

END PROCEDURE.

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

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

    { incl/brwinitialize.i }
    
END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE REFRESHAUFZE bTableWin 
PROCEDURE REFRESHAUFZE :
/*------------------------------------------------------------------------------
     Purpose:
     Notes:
    ------------------------------------------------------------------------------*/

    DO WITH FRAME {&FRAME-NAME}:
        APPLY 'F5' TO BROWSE {&BROWSE-NAME}.
        RETURN NO-APPLY.
    END.

END PROCEDURE.

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

/* ************************  Function Implementations ***************** */

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _FUNCTION setZeilenfarbe bTableWin 
FUNCTION setZeilenfarbe RETURNS LOGICAL
    ( ipFarbe AS INT  ) :
/*------------------------------------------------------------------------------
  Purpose:  
    Notes:  
------------------------------------------------------------------------------*/

    { incl/brwsetzeilenfarbe.i }

END FUNCTION.

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