GeMIS_WEB/GUI/g-such-artikkarte.w

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

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

DEF OUTPUT PARAMETER opArtikel      AS CHAR                     NO-UNDO.

/* 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 INIT ''.
DEF VAR VSort           AS INT                      NO-UNDO INIT 1.
DEF VAR VSuch1          AS CHAR                     NO-UNDO INIT ''.
DEF VAR VSuch2          AS CHAR                     NO-UNDO INIT ''.
DEF VAR VSuch3          AS CHAR                     NO-UNDO INIT ''.
DEF VAR VSuch4          AS CHAR                     NO-UNDO INIT ''.
DEF VAR VSuch5          AS CHAR                     NO-UNDO INIT ''.
DEF VAR Inhalt          AS CHAR                     NO-UNDO INIT ''.
DEF VAR MinNr           AS INT                      NO-UNDO.

DEF VAR AnzVorhanden    AS INT                      NO-UNDO.

/* _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 gsuchartikel
&Scoped-define BROWSE-NAME Br_artikel

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

/* Definitions for BROWSE Br_artikel                                    */
&Scoped-define FIELDS-IN-QUERY-Br_artikel Artst.Artnr Artst.Inhalt ~
Artst.Jahr Artst.Suchbe Artst.Bez Artst.Bestand Artst.Listen_EP ~
Artst.Alk_Gehalt 
&Scoped-define ENABLED-FIELDS-IN-QUERY-Br_artikel 
&Scoped-define OPEN-QUERY-Br_artikel OPEN QUERY Br_artikel FOR EACH Artst NO-LOCK, ~
      EACH Artbez OF Artst NO-LOCK INDEXED-REPOSITION.
&Scoped-define TABLES-IN-QUERY-Br_artikel Artst Artbez
&Scoped-define FIRST-TABLE-IN-QUERY-Br_artikel Artst
&Scoped-define SECOND-TABLE-IN-QUERY-Br_artikel Artbez


/* Definitions for DIALOG-BOX gsuchartikel                              */

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS F_Artnr F_Inhalt F_Jahr F_Suchbe F_Bez ~
Br_artikel T_Geloescht RECT-38 
&Scoped-Define DISPLAYED-OBJECTS F_Artnr F_Inhalt F_Jahr F_Suchbe F_Bez ~
T_Geloescht 

/* Custom List Definitions                                              */
/* List-1,List-2,List-3,List-4,List-5,List-6                            */
&Scoped-define List-6 F_Artnr F_Inhalt F_Jahr F_Suchbe F_Bez T_Geloescht 

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



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

/* Define a dialog box                                                  */

/* Definitions of the field level widgets                               */
DEFINE VARIABLE F_Artnr AS INTEGER FORMAT "999999":U INITIAL 0 
     LABEL "Artnr" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 11 BY 1
     BGCOLOR 15  NO-UNDO.

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

DEFINE VARIABLE F_Inhalt AS INTEGER FORMAT "9999":U INITIAL 0 
     LABEL "Inhalt" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 8 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_Jahr AS INTEGER FORMAT "9999":U INITIAL 0 
     LABEL "Jahrgang" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 8 BY 1
     BGCOLOR 15  NO-UNDO.

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

DEFINE RECTANGLE RECT-38
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL 
     SIZE 105 BY 19.29.

DEFINE VARIABLE T_Geloescht AS LOGICAL INITIAL no 
     LABEL "&inaktive ?" 
     VIEW-AS TOGGLE-BOX
     SIZE 15.2 BY 1 NO-UNDO.

/* Query definitions                                                    */
&ANALYZE-SUSPEND
DEFINE QUERY Br_artikel FOR 
      Artst, 
      Artbez SCROLLING.
&ANALYZE-RESUME

/* Browse definitions                                                   */
DEFINE BROWSE Br_artikel
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_artikel gsuchartikel _STRUCTURED
  QUERY Br_artikel NO-LOCK DISPLAY
      Artst.Artnr FORMAT "999999":U WIDTH 7
      Artst.Inhalt FORMAT "9999":U WIDTH 6
      Artst.Jahr FORMAT "9999":U WIDTH 5
      Artst.Suchbe FORMAT "x(15)":U
      Artst.Bez COLUMN-LABEL "Bezeichnung" FORMAT "x(30)":U
      Artst.Bestand FORMAT "zzzzz,zz9-":U WIDTH 11
      Artst.Listen_EP COLUMN-LABEL "Listen EP" FORMAT "z,zz9.999":U
            WIDTH 10
      Artst.Alk_Gehalt COLUMN-LABEL "Alk%" FORMAT "zz9.9":U WIDTH 5
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
    WITH NO-ROW-MARKERS SEPARATORS SIZE 100 BY 14.76
         BGCOLOR 15 .


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

DEFINE FRAME gsuchartikel
     F_Artnr AT ROW 1.52 COL 18 COLON-ALIGNED
     F_Inhalt AT ROW 1.52 COL 40 COLON-ALIGNED
     F_Jahr AT ROW 1.52 COL 62 COLON-ALIGNED
     F_Suchbe AT ROW 2.52 COL 18 COLON-ALIGNED
     F_Bez AT ROW 3.52 COL 18 COLON-ALIGNED
     Br_artikel AT ROW 5.19 COL 4
     T_Geloescht AT ROW 3.52 COL 64.2 NO-TAB-STOP 
     RECT-38 AT ROW 1.24 COL 2
     SPACE(0.99) SKIP(0.22)
    WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER 
         SIDE-LABELS NO-UNDERLINE THREE-D  SCROLLABLE 
         TITLE "Suche nach Artikeln".


/* *********************** 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 gsuchartikel 
/* ************************* 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 gsuchartikel
   Custom                                                               */
/* BROWSE-TAB Br_artikel F_Bez gsuchartikel */
ASSIGN 
       FRAME gsuchartikel:SCROLLABLE       = FALSE
       FRAME gsuchartikel:HIDDEN           = TRUE.

ASSIGN 
       Br_artikel:COLUMN-RESIZABLE IN FRAME gsuchartikel       = TRUE.

/* SETTINGS FOR FILL-IN F_Artnr IN FRAME gsuchartikel
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Bez IN FRAME gsuchartikel
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Inhalt IN FRAME gsuchartikel
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Jahr IN FRAME gsuchartikel
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Suchbe IN FRAME gsuchartikel
   6                                                                    */
/* SETTINGS FOR TOGGLE-BOX T_Geloescht IN FRAME gsuchartikel
   6                                                                    */
/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


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

&ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_artikel
/* Query rebuild information for BROWSE Br_artikel
     _TblList          = "AnaDat.Artst,AnaDat.Artbez OF AnaDat.Artst"
     _Options          = "NO-LOCK INDEXED-REPOSITION"
     _FldNameList[1]   > AnaDat.Artst.Artnr
"Artst.Artnr" ? ? "integer" ? ? ? ? ? ? no ? no no "7" yes no no "U" "" ""
     _FldNameList[2]   > AnaDat.Artst.Inhalt
"Artst.Inhalt" ? ? "integer" ? ? ? ? ? ? no ? no no "6" yes no no "U" "" ""
     _FldNameList[3]   > AnaDat.Artst.Jahr
"Artst.Jahr" ? ? "integer" ? ? ? ? ? ? no ? no no "5" yes no no "U" "" ""
     _FldNameList[4]   = AnaDat.Artst.Suchbe
     _FldNameList[5]   > AnaDat.Artst.Bez
"Artst.Bez" "Bezeichnung" ? "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" ""
     _FldNameList[6]   > AnaDat.Artst.Bestand
"Artst.Bestand" ? ? "integer" ? ? ? ? ? ? no ? no no "11" yes no no "U" "" ""
     _FldNameList[7]   > AnaDat.Artst.Listen_EP
"Artst.Listen_EP" "Listen EP" ? "decimal" ? ? ? ? ? ? no ? no no "10" yes no no "U" "" ""
     _FldNameList[8]   > AnaDat.Artst.Alk_Gehalt
"Artst.Alk_Gehalt" "Alk%" "zz9.9" "decimal" ? ? ? ? ? ? no ? no no "5" yes no no "U" "" ""
     _Query            is NOT OPENED
*/  /* BROWSE Br_artikel */
&ANALYZE-RESUME

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

 



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

&Scoped-define SELF-NAME gsuchartikel
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gsuchartikel gsuchartikel
ON END-ERROR OF FRAME gsuchartikel /* Suche nach Artikeln */
DO:
    RUN ENDE.
    RETURN NO-APPLY.
END.

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


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

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gsuchartikel gsuchartikel
ON WINDOW-CLOSE OF FRAME gsuchartikel /* Suche nach Artikeln */
DO:  
    RUN ENDE.
    RETURN NO-APPLY.
END.

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


&Scoped-define BROWSE-NAME Br_artikel
&Scoped-define SELF-NAME Br_artikel
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_artikel gsuchartikel
ON END-ERROR OF Br_artikel IN FRAME gsuchartikel
DO:
    APPLY 'ENTRY' TO F_Artnr IN FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_artikel gsuchartikel
ON RETURN OF Br_artikel IN FRAME gsuchartikel
DO:
DO WITH FRAME {&FRAME-NAME}:
    IF NUM-RESULTS('{&BROWSE-NAME}') = ?    THEN RETURN NO-APPLY.
    IF NUM-RESULTS('{&BROWSE-NAME}') = 0    THEN RETURN NO-APPLY.
    IF {&BROWSE-NAME}:NUM-SELECTED-ROWS = 0 THEN RETURN NO-APPLY.

    {&BROWSE-NAME}:FETCH-SELECTED-ROW(1).

    ASSIGN  {&List-6}.
    F_Artnr  = Artst.Artnr.
    VSuch1   = TRIM(STRING(F_Artnr ,'zzzzzzzz')).
    F_Inhalt = Artst.Inhalt.
    VSuch2   = TRIM(STRING(F_Inhalt,'zzzzzzzz')).
    F_Jahr   = Artst.Jahr  .
    VSuch3   = TRIM(STRING(F_Jahr  ,'zzzzzzzz')).
    VSuch4   = F_Suchbe.
    VSuch5   = F_Bez   .

    {&BROWSE-NAME}:FETCH-SELECTED-ROW(1).

    opArtikel = STRING(RECID(Artst))    + CHR(01)
              + Artst.Firma             + CHR(01)
              + STRING(Artst.Artnr)     + CHR(01)
              + STRING(Artst.Inhalt)    + CHR(01)
              + STRING(Artst.Jahr)      + CHR(01)
              + STRING(VSort)           + CHR(01).
    IF VSort <> 1 THEN VSuch1 = ''.
    IF VSort <> 2 THEN VSuch2 = ''.
    IF VSort <> 3 THEN VSuch3 = ''.
    IF VSort <> 4 THEN VSuch4 = ''.
    IF VSort <> 5 THEN VSuch5 = ''.

    opArtikel = opArtikel + VSuch1  + CHR(01)
                          + VSuch2  + CHR(01)
                          + VSuch3  + CHR(01)
                          + VSuch4  + CHR(01)
                          + VSuch5  + CHR(01).
END.

    RUN ENDE.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_artikel gsuchartikel
ON ROW-DISPLAY OF Br_artikel IN FRAME gsuchartikel
DO:
    DEF VAR Farbe   AS INT                      NO-UNDO.

    IF NOT AVAILABLE Artst THEN RETURN.

    DO WITH FRAME {&FRAME-NAME}:
        Farbe = 15.
        IF Artst.Ausverk > 1        THEN Farbe = 14.
        IF Artst.Aktiv   = FALSE    THEN Farbe = 12.

        Artst.Artnr  :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
        Artst.Inhalt :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
        Artst.Jahr   :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
        Artst.Suchbe :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
        Artst.Bez    :BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
        Artst.Bestand:BGCOLOR IN BROWSE {&BROWSE-NAME} = Farbe.
    END.
END.

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


&Scoped-define SELF-NAME F_Artnr
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Artnr gsuchartikel
ON ENTRY OF F_Artnr IN FRAME gsuchartikel /* Artnr */
DO:
    VSuch1 = ''.
    vSuch2 = ''.
    VSuch3 = ''.
    VSuch4 = ''.
    VSuch5 = ''.
    DO WITH FRAME {&FRAME-NAME}:
        F_Inhalt:SCREEN-VALUE = ''.
        F_Jahr  :SCREEN-VALUE = ''.
        F_Suchbe:SCREEN-VALUE = ''.
        F_Bez   :SCREEN-VALUE = ''.
        F_Artnr :SCREEN-VALUE = ''.

        F_Artnr :SET-SELECTION(1, 7).
    END.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Artnr gsuchartikel
ON LEAVE OF F_Artnr IN FRAME gsuchartikel /* Artnr */
DO:
    DEF VAR iArtnr  AS INT                      NO-UNDO.

    VSuch1 = SELF:SCREEN-VALUE.
    VSuch1 = TRIM(STRING(INTEGER(VSuch1),'zzzzzz')).
    IF VSuch1 <> '' THEN DO:
        iArtnr = INTEGER(VSuch1).
        DO WHILE iArtnr LT MinNr:
            iArtnr = iArtnr * 10.
        END.
        VSuch1 = STRING(iArtnr).
        SELF:SCREEN-VALUE = VSuch1.
        RUN OPENQUERY.
        IF NOT LASTKEY = KEYCODE('RETURN') THEN RETURN.
        IF AnzVorhanden = 0 THEN RETURN.
        IF AnzVorhanden > 1 THEN DO:
            APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
            RETURN NO-APPLY.
        END.
        APPLY 'RETURN' TO BROWSE {&BROWSE-NAME}.
        RETURN NO-APPLY.
    END.
END.

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


&Scoped-define SELF-NAME F_Bez
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Bez gsuchartikel
ON END-ERROR OF F_Bez IN FRAME gsuchartikel /* Bezeichnung */
DO:
    APPLY 'ENTRY' TO F_Artnr IN FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Bez gsuchartikel
ON LEAVE OF F_Bez IN FRAME gsuchartikel /* Bezeichnung */
DO:
    VSuch5 = SELF:SCREEN-VALUE.
    IF VSuch5 <> '' THEN DO WITH FRAME {&FRAME-NAME}:
        RUN OPENQUERY.
        IF NOT LASTKEY = KEYCODE('RETURN') THEN RETURN.
        IF AnzVorhanden = 0 THEN RETURN.
        IF AnzVorhanden > 1 THEN DO:
            APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
            RETURN NO-APPLY.
        END.
        APPLY 'RETURN' TO BROWSE {&BROWSE-NAME}.
        RETURN NO-APPLY.
    END.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Bez gsuchartikel
ON VALUE-CHANGED OF F_Bez IN FRAME gsuchartikel /* Bezeichnung */
DO:
    VSuch5 = SELF:SCREEN-VALUE.
    IF VSuch5 <> '' THEN RUN OPENQUERY.
END.

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


&Scoped-define SELF-NAME F_Inhalt
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Inhalt gsuchartikel
ON END-ERROR OF F_Inhalt IN FRAME gsuchartikel /* Inhalt */
DO:
    APPLY 'ENTRY' TO F_Artnr IN FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Inhalt gsuchartikel
ON LEAVE OF F_Inhalt IN FRAME gsuchartikel /* Inhalt */
DO:
    VSuch2 = SELF:SCREEN-VALUE.
    VSuch2 = TRIM(STRING(INTEGER(Vsuch2),'zzzzzz')).
    IF VSuch2 <> '' THEN DO WITH FRAME {&FRAME-NAME}:
        RUN OPENQUERY.
        IF NOT LASTKEY = KEYCODE('RETURN') THEN RETURN.
        IF AnzVorhanden = 0 THEN RETURN.
        IF AnzVorhanden > 1 THEN DO:
            APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
            RETURN NO-APPLY.
        END.
        APPLY 'RETURN' TO BROWSE {&BROWSE-NAME}.
        RETURN NO-APPLY.
    END.
END.

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


&Scoped-define SELF-NAME F_Jahr
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Jahr gsuchartikel
ON END-ERROR OF F_Jahr IN FRAME gsuchartikel /* Jahrgang */
DO:
    APPLY 'ENTRY' TO F_Artnr IN FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Jahr gsuchartikel
ON LEAVE OF F_Jahr IN FRAME gsuchartikel /* Jahrgang */
DO:
    VSuch3 = SELF:SCREEN-VALUE.
    VSuch3 = TRIM(STRING(INTEGER(VSuch3),'zzzzzz')).
    IF VSuch3 <> '' THEN DO WITH FRAME {&FRAME-NAME}:
        RUN OPENQUERY.
        IF NOT LASTKEY = KEYCODE('RETURN') THEN RETURN.
        IF AnzVorhanden = 0 THEN RETURN.
        IF AnzVorhanden > 1 THEN DO:
            APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
            RETURN NO-APPLY.
        END.
        APPLY 'RETURN' TO BROWSE {&BROWSE-NAME}.
        RETURN NO-APPLY.
    END.
END.

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


&Scoped-define SELF-NAME F_Suchbe
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gsuchartikel
ON END-ERROR OF F_Suchbe IN FRAME gsuchartikel /* Suchbegriff */
DO:
    APPLY 'ENTRY' TO F_Artnr IN FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gsuchartikel
ON LEAVE OF F_Suchbe IN FRAME gsuchartikel /* Suchbegriff */
DO:
    VSuch4 = SELF:SCREEN-VALUE.
    IF VSuch4 <> '' THEN DO WITH FRAME {&FRAME-NAME}:
        RUN OPENQUERY.
        IF NOT LASTKEY = KEYCODE('RETURN') THEN RETURN.
        IF AnzVorhanden = 0 THEN RETURN.
        IF AnzVorhanden > 1 THEN DO:
            APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
            RETURN NO-APPLY.
        END.
        APPLY 'RETURN' TO BROWSE {&BROWSE-NAME}.
        RETURN NO-APPLY.
    END.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Suchbe gsuchartikel
ON VALUE-CHANGED OF F_Suchbe IN FRAME gsuchartikel /* Suchbegriff */
DO:
    VSuch4 = SELF:SCREEN-VALUE.
    IF VSuch4 <> '' THEN RUN OPENQUERY.
END.

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


&Scoped-define SELF-NAME T_Geloescht
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL T_Geloescht gsuchartikel
ON VALUE-CHANGED OF T_Geloescht IN FRAME gsuchartikel /* inaktive ? */
DO:
    DEF VAR xHandle     AS HANDLE                   NO-UNDO.

    xHandle = ?.
    DO WITH FRAME {&FRAME-NAME}:
        IF F_Bez   :SCREEN-VALUE <> ''      THEN xHandle = F_Bez   :HANDLE.
        IF F_Suchbe:SCREEN-VALUE <> ''      THEN xHandle = F_Suchbe:HANDLE.
        IF F_Jahr  :SCREEN-VALUE <> '0000'  THEN xHandle = F_Jahr  :HANDLE.
        IF F_Inhalt:SCREEN-VALUE <> '0000'  THEN xHandle = F_Inhalt:HANDLE.

        IF NOT VALID-HANDLE(xHandle) THEN xHandle = F_Artnr:HANDLE.
        APPLY 'ENTRY' TO xHandle.

        CASE xHandle:NAME:
            WHEN 'F_Artnr'  THEN RETURN NO-APPLY.
            WHEN 'F_Inhalt' THEN RETURN NO-APPLY.
            WHEN 'F_Jahr'   THEN RETURN NO-APPLY.
        END CASE.
        IF xHandle:SCREEN-VALUE = '' THEN RETURN NO-APPLY.
        APPLY 'VALUE-CHANGED' TO xHandle.
        RETURN NO-APPLY.
    END.
END.

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


&UNDEFINE SELF-NAME

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


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

    opArtikel = ''.
    MaxPage   = 1.
    AktSeite  = 1.
    Firma     = DYNAMIC-FUNCTION('GETMANDANT':U).

    DEF VAR ix      AS INT                      NO-UNDO.

    FIND Steuer USE-INDEX Steuer-k1
                WHERE Steuer.Firma = Firma NO-LOCK NO-ERROR.
    MinNr     = 1.
    IF AVAILABLE Steuer THEN DO:
        DO ix = 2 TO DYNAMIC-FUNCTION('GETMINARTNR':U) :
            MinNr = MinNr * 10.
        END.
    END.

    SESSION:DATA-ENTRY-RETURN = TRUE.

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

    ON 'CURSOR-DOWN':U OF F_Artnr  , F_Inhalt, F_Jahr ,
                          F_Suchbe , F_Bez
                       IN FRAME {&FRAME-NAME}
    DO:
        APPLY 'ENTRY' TO BROWSE {&BROWSE-NAME}.
        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 gsuchartikel  _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 gsuchartikel 
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 gsuchartikel  _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 gsuchartikel.
END PROCEDURE.

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

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

    DEF VAR hColumn         AS HANDLE               NO-UNDO.
    DEF VAR cBreite         AS CHAR                 NO-UNDO.
    DEF VAR cString         AS CHAR                 NO-UNDO.

    GET-KEY-VALUE SECTION 'GrundEinstellungen'
                  KEY     'EpAufArtikelSuchen'
                  VALUE   cString.
    IF cString = ? THEN cString = 'nein'.

    DO WITH FRAME {&FRAME-NAME}:
        IF cString BEGINS 'n' THEN Artst.Listen_EP:VISIBLE IN BROWSE {&BROWSE-NAME} = FALSE.
        ELSE                       Artst.Listen_EP:VISIBLE IN BROWSE {&BROWSE-NAME} = TRUE .
        hColumn = {&BROWSE-NAME}:FIRST-COLUMN IN FRAME {&FRAME-NAME}.

        DO WHILE VALID-HANDLE(hColumn):
            IF hColumn:VISIBLE = TRUE THEN DO:
                GET-KEY-VALUE SECTION 'ArtikelSuchBrowser'
                              KEY     hColumn:NAME
                              VALUE   cBreite.
                DO WHILE TRUE WITH FRAME {&FRAME-NAME}:
                    IF cBreite = ?  THEN LEAVE.
                    IF cBreite = '' THEN LEAVE.
                    IF DECIMAL(cBreite) < 2 THEN cBreite = '2'.
                    hColumn:WIDTH = DECIMAL(cBreite).
                    LEAVE.
                END.
            END.
            hColumn = hColumn:NEXT-COLUMN.
        END.
    END.

    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 gsuchartikel  _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_Artnr F_Inhalt F_Jahr F_Suchbe F_Bez T_Geloescht 
      WITH FRAME gsuchartikel.
  ENABLE F_Artnr F_Inhalt F_Jahr F_Suchbe F_Bez Br_artikel T_Geloescht RECT-38 
      WITH FRAME gsuchartikel.
  VIEW FRAME gsuchartikel.
  {&OPEN-BROWSERS-IN-QUERY-gsuchartikel}
END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gsuchartikel 
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.

    DEF VAR hColumn     AS HANDLE                   NO-UNDO.

    DO WITH FRAME {&FRAME-NAME}:
        hColumn = {&BROWSE-NAME}:FIRST-COLUMN.
        DO WHILE VALID-HANDLE(hColumn):
            PUT-KEY-VALUE SECTION 'ArtikelSuchBrowser'
                          KEY     hColumn:NAME
                          VALUE   STRING(hColumn:WIDTH).
            hColumn = hColumn:NEXT-COLUMN.
        END.
    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 gsuchartikel 
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 gsuchartikel 
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 gsuchartikel 
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 OPENQUERY gsuchartikel 
PROCEDURE OPENQUERY :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF VAR FAktiv  AS LOG                      NO-UNDO.

    DO WITH FRAME {&FRAME-NAME}:
        ASSIGN  {&list-6}.

        IF T_Geloescht = TRUE THEN FAktiv = FALSE.
        ELSE                       FAktiv = TRUE.
    END.

    VSort = 1.
    IF VSuch5 <> '' AND INDEX(VSuch5, '*') = 0 THEN VSort = 5.
    IF VSuch4 <> '' AND INDEX(VSuch4, '*') = 0 THEN VSort = 4.
    IF VSuch3 <> '' AND INDEX(VSuch3, '*') = 0 THEN VSort = 3.
    IF VSuch2 <> '' AND INDEX(VSuch2, '*') = 0 THEN VSort = 2.
    IF VSuch1 <> '' AND INDEX(VSuch1, '*') = 0 THEN VSort = 1.

    SESSION:SET-WAIT-STATE('GENERAL').
    
    CASE VSort:
        WHEN 1 THEN DO:
            OPEN QUERY {&BROWSE-NAME}
            FOR EACH Artst USE-INDEX Artst-k1
                           WHERE Artst.Firma   = Firma
                           AND   Artst.Aktiv   = FAktiv
                           AND   Artst.Artnr  >= INTEGER(VSuch1)
                AND (IF VSuch2 <> '' THEN Artst.Inhalt  = INTEGER(VSuch2)
                     ELSE                 Artst.Inhalt >= 0             )
                AND (IF VSuch3 <> '' THEN Artst.Jahr    = INTEGER(VSuch3)
                     ELSE                 Artst.Jahr   >= 0             )
                AND (IF INDEX(VSuch4, '*') = 0 THEN Artst.Suchbe BEGINS  VSuch4
                     ELSE                           Artst.Suchbe MATCHES VSuch4)
                AND (IF INDEX(VSuch5, '*') = 0 THEN Artst.Bez    BEGINS  VSuch5
                     ELSE                           Artst.Bez    MATCHES VSuch5)
                           NO-LOCK,
                FIRST Artbez OF Artst WHERE Artbez.Zustext[01] <> ''
                                      OR    Artbez.Zustext[02] <> '' NO-LOCK.
        END.

        WHEN 2 THEN DO:
            OPEN QUERY {&BROWSE-NAME}
            FOR EACH Artst USE-INDEX Artst-k1
                           WHERE Artst.Firma   = Firma
                           AND   Artst.Aktiv   = FAktiv
                           AND   Artst.Inhalt  = INTEGER(VSuch2)
                AND (IF VSuch3 <> '' THEN Artst.Jahr    = INTEGER(VSuch3)
                     ELSE                 Artst.Jahr   >= 0             )
                AND (IF INDEX(VSuch4, '*') = 0 THEN Artst.Suchbe BEGINS  VSuch4
                     ELSE                           Artst.Suchbe MATCHES VSuch4)
                AND (IF INDEX(VSuch5, '*') = 0 THEN Artst.Bez    BEGINS  VSuch5
                     ELSE                           Artst.Bez    MATCHES VSuch5)
                           NO-LOCK,
                FIRST Artbez OF Artst WHERE Artbez.Zustext[01] <> ''
                                      OR    Artbez.Zustext[02] <> '' NO-LOCK.
        END.

        WHEN 3 THEN DO:
            OPEN QUERY {&BROWSE-NAME}
            FOR EACH Artst USE-INDEX Artst-k1
                           WHERE Artst.Firma   = Firma
                           AND   Artst.Aktiv   = FAktiv
                           AND   Artst.Jahr    = INTEGER(VSuch3)
                AND (IF INDEX(VSuch4, '*') = 0 THEN Artst.Suchbe BEGINS  VSuch4
                     ELSE                           Artst.Suchbe MATCHES VSuch4)
                AND (IF INDEX(VSuch5, '*') = 0 THEN Artst.Bez    BEGINS  VSuch5
                     ELSE                           Artst.Bez    MATCHES VSuch5)
                           NO-LOCK,
                FIRST Artbez OF Artst WHERE Artbez.Zustext[01] <> ''
                                      OR    Artbez.Zustext[02] <> '' NO-LOCK.
        END.

        WHEN 4 THEN DO:
            OPEN QUERY {&BROWSE-NAME}
            FOR EACH Artst USE-INDEX Artst-k2
                             WHERE Artst.Firma   = Firma
                             AND   Artst.Aktiv   = FAktiv
                             AND   Artst.Suchbe  BEGINS VSuch4
                AND (IF INDEX(VSuch5, '*') = 0 THEN Artst.Bez    BEGINS  VSuch5
                     ELSE                           Artst.Bez    MATCHES VSuch5)
                           NO-LOCK,
                FIRST Artbez OF Artst WHERE Artbez.Zustext[01] <> ''
                                      OR    Artbez.Zustext[02] <> '' NO-LOCK.
        END.

        WHEN 5 THEN DO:
            OPEN QUERY {&BROWSE-NAME}
            FOR EACH Artst USE-INDEX Artst-k3
                             WHERE Artst.Firma   = Firma
                             AND   Artst.Aktiv   = FAktiv
                             AND   Artst.Bez     BEGINS VSuch5
                AND (IF INDEX(VSuch4, '*') = 0 THEN Artst.Suchbe BEGINS  VSuch4
                     ELSE                           Artst.Suchbe MATCHES VSuch4)
                           NO-LOCK,
                FIRST Artbez OF Artst WHERE Artbez.Zustext[01] <> ''
                                      OR    Artbez.Zustext[02] <> '' NO-LOCK.
        END.

    END CASE.

    SESSION:SET-WAIT-STATE('').
    
    AnzVorhanden = NUM-RESULTS('{&BROWSE-NAME}') NO-ERROR.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE PREVPAGE gsuchartikel 
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 selectPage gsuchartikel 
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 gsuchartikel 
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