GeMIS_WEB/GUI/g-such-bank.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 gSuchenBank
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gSuchenBank 
/*------------------------------------------------------------------------

  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 INPUT-OUTPUT PARAMETER ipBeginn     AS CHAR                 NO-UNDO.

/* Local Variable Definitions ---                                       */

DEF VAR VSuchbe     AS CHAR                     NO-UNDO.
DEF VAR VName       AS CHAR                     NO-UNDO.
DEF VAR VSort       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 gSuchenBank
&Scoped-define BROWSE-NAME Br_Bankst

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

/* Definitions for BROWSE Br_Bankst                                     */
&Scoped-define FIELDS-IN-QUERY-Br_Bankst Bankst.Bank Bankst.Clearing ~
Bankst.Adr[1] Bankst.Adr[4] 
&Scoped-define ENABLED-FIELDS-IN-QUERY-Br_Bankst Bankst.Clearing 
&Scoped-define ENABLED-TABLES-IN-QUERY-Br_Bankst Bankst
&Scoped-define FIRST-ENABLED-TABLE-IN-QUERY-Br_Bankst Bankst
&Scoped-define OPEN-QUERY-Br_Bankst OPEN QUERY Br_Bankst FOR EACH Bankst NO-LOCK INDEXED-REPOSITION.
&Scoped-define TABLES-IN-QUERY-Br_Bankst Bankst
&Scoped-define FIRST-TABLE-IN-QUERY-Br_Bankst Bankst


/* Definitions for DIALOG-BOX gSuchenBank                               */

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS F_Such_1 F_Such_2 F_Name Br_Bankst RECT-1 
&Scoped-Define DISPLAYED-OBJECTS F_Such_1 F_Such_2 F_Name 

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

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



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

/* Define a dialog box                                                  */

/* Definitions of the field level widgets                               */
DEFINE VARIABLE F_Name AS CHARACTER FORMAT "x(30)":U 
     LABEL "Bank" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 45 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_Such_1 AS CHARACTER FORMAT "x(10)":U 
     LABEL "Bank / Ort" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 15 BY 1
     BGCOLOR 15  NO-UNDO.

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

DEFINE RECTANGLE RECT-1
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL 
     SIZE 91 BY 13.48.

/* Query definitions                                                    */
&ANALYZE-SUSPEND
DEFINE QUERY Br_Bankst FOR 
      Bankst SCROLLING.
&ANALYZE-RESUME

/* Browse definitions                                                   */
DEFINE BROWSE Br_Bankst
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _DISPLAY-FIELDS Br_Bankst gSuchenBank _STRUCTURED
  QUERY Br_Bankst NO-LOCK DISPLAY
      Bankst.Bank FORMAT "zzz9":U
      Bankst.Clearing FORMAT "x(15)":U
      Bankst.Adr[1] COLUMN-LABEL "Bank" FORMAT "x(30)":U
      Bankst.Adr[4] COLUMN-LABEL "Ort" FORMAT "x(30)":U
  ENABLE
      Bankst.Clearing
/* _UIB-CODE-BLOCK-END */
&ANALYZE-RESUME
    WITH NO-ROW-MARKERS SEPARATORS SIZE 86 BY 9.43
         BGCOLOR 15  EXPANDABLE.


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

DEFINE FRAME gSuchenBank
     F_Such_1 AT ROW 1.52 COL 20 COLON-ALIGNED
     F_Such_2 AT ROW 1.52 COL 38 COLON-ALIGNED
     F_Name AT ROW 3 COL 20 COLON-ALIGNED
     Br_Bankst AT ROW 4.71 COL 4.2
     RECT-1 AT ROW 1.24 COL 2
     SPACE(1.99) SKIP(0.13)
    WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER 
         SIDE-LABELS NO-UNDERLINE THREE-D  SCROLLABLE 
         TITLE "Suchen einer Bank".


/* *********************** 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
   Other Settings: COMPILE
 */
&ANALYZE-RESUME _END-PROCEDURE-SETTINGS

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _INCLUDED-LIB gSuchenBank 
/* ************************* 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 gSuchenBank
   Custom                                                               */
/* BROWSE-TAB Br_Bankst F_Name gSuchenBank */
ASSIGN 
       FRAME gSuchenBank:SCROLLABLE       = FALSE
       FRAME gSuchenBank:HIDDEN           = TRUE.

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


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

&ANALYZE-SUSPEND _QUERY-BLOCK BROWSE Br_Bankst
/* Query rebuild information for BROWSE Br_Bankst
     _TblList          = "AnaDat.Bankst"
     _Options          = "NO-LOCK INDEXED-REPOSITION"
     _FldNameList[1]   = AnaDat.Bankst.Bank
     _FldNameList[2]   > AnaDat.Bankst.Clearing
"Bankst.Clearing" ? ? "character" ? ? ? ? ? ? yes ? no no ? yes no no "U" "" ""
     _FldNameList[3]   > AnaDat.Bankst.Adr[1]
"Bankst.Adr[1]" "Bank" ? "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" ""
     _FldNameList[4]   > AnaDat.Bankst.Adr[4]
"Bankst.Adr[4]" "Ort" ? "character" ? ? ? ? ? ? no ? no no ? yes no no "U" "" ""
     _Query            is NOT OPENED
*/  /* BROWSE Br_Bankst */
&ANALYZE-RESUME

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

 



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

&Scoped-define SELF-NAME gSuchenBank
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSuchenBank gSuchenBank
ON END-ERROR OF FRAME gSuchenBank /* Suchen einer Bank */
DO:
    ipBeginn = ''.
    RUN ENDE.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSuchenBank gSuchenBank
ON WINDOW-CLOSE OF FRAME gSuchenBank /* Suchen einer Bank */
DO:  
    ipBeginn = ''.
    RUN ENDE.
    RETURN NO-APPLY.
END.

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


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

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Bankst gSuchenBank
ON RETURN OF Br_Bankst IN FRAME gSuchenBank
DO:
    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).
    ipBeginn = STRING(Bankst.Bank)      + CHR(01)
             + Bankst.Clearing          + CHR(01)
             + Bankst.Adr[01]           + CHR(01)
             + Bankst.Adr[04].
    RUN ENDE.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Br_Bankst gSuchenBank
ON START-SEARCH OF Br_Bankst IN FRAME gSuchenBank
DO:
    DEF VAR xx AS HANDLE.
    xx = {&BROWSE-NAME}:CURRENT-COLUMN.
    /*
    IF xx:NAME = 'Plz' THEN ipSort = 1.
    ELSE                    ipSort = 2.
    IF ipSort = 1 THEN F_Eingabe:LABEL = 'Plz'.
    IF ipSort = 2 THEN F_Eingabe:LABEL = 'Ort'.
    ipBeginn  = ''.
    F_Eingabe = ''.
    */
    APPLY 'END-SEARCH'          TO BROWSE {&BROWSE-NAME}.
    RUN OPENQUERY.
    APPLY 'ENTRY'               TO F_Such_1.
    RETURN NO-APPLY.
END.

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


&Scoped-define SELF-NAME F_Name
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Name gSuchenBank
ON CURSOR-DOWN OF F_Name IN FRAME gSuchenBank /* Bank */
DO:
    F_Name:SCREEN-VALUE = ''.
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Name gSuchenBank
ON RETURN OF F_Name IN FRAME gSuchenBank /* Bank */
DO:
    F_Name:SCREEN-VALUE = ''.
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Name gSuchenBank
ON VALUE-CHANGED OF F_Name IN FRAME gSuchenBank /* Bank */
DO:
    DO WITH FRAME {&FRAME-NAME}:
        VSort   = 2.
        VSuchbe = SELF:SCREEN-VALUE.
        RUN OPENQUERY.
        APPLY 'END'   TO F_Name.
    END.
    RETURN NO-APPLY.
END.

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


&Scoped-define SELF-NAME F_Such_1
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Such_1 gSuchenBank
ON CURSOR-DOWN OF F_Such_1 IN FRAME gSuchenBank /* Bank / Ort */
DO:
    F_Such_1:SCREEN-VALUE = ''.
    APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Such_1 gSuchenBank
ON RETURN OF F_Such_1 IN FRAME gSuchenBank /* Bank / Ort */
DO:
    F_Such_1:SCREEN-VALUE = ''.
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Such_1 gSuchenBank
ON VALUE-CHANGED OF F_Such_1 IN FRAME gSuchenBank /* Bank / Ort */
DO:
    DO WITH FRAME {&FRAME-NAME}:
        VSort   = 1.
        VSuchbe = SELF:SCREEN-VALUE.
        RUN OPENQUERY.
        APPLY 'END'   TO F_Such_1.
    END.
    RETURN NO-APPLY.
END.

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



&Scoped-define SELF-NAME F_Such_2
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Such_2 gSuchenBank
ON CURSOR-DOWN OF F_Such_2 IN FRAME gSuchenBank /* / */
DO:
    F_Such_2:SCREEN-VALUE = ''.
    APPLY 'ENTRY' TO {&BROWSE-NAME} IN FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Such_2 gSuchenBank
ON RETURN OF F_Such_2 IN FRAME gSuchenBank /* / */
DO:
    F_Such_2:SCREEN-VALUE = ''.
    APPLY 'TAB' TO SELF.
    RETURN NO-APPLY.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL F_Such_2 gSuchenBank
ON VALUE-CHANGED OF F_Such_2 IN FRAME gSuchenBank /* / */
DO:
    DO WITH FRAME {&FRAME-NAME}:
        VSort   = 1.
        VSuchbe = ''.
        SUBSTRING(VSuchbe,01) = F_Such_1:SCREEN-VALUE.
        SUBSTRING(VSuchbe,11) = F_Such_2:SCREEN-VALUE.
        RUN OPENQUERY.
        APPLY 'END'   TO F_Such_2.
    END.
    RETURN NO-APPLY.
END.

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



&UNDEFINE SELF-NAME

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


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

SESSION:DATA-ENTRY-RETURN = TRUE.

VSort     = 1.
ipBeginn  = ''.
VSuchbe   = ''.

{src/adm2/dialogmn.i}

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


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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects gSuchenBank  _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 createObjects gSuchenBank 
PROCEDURE createObjects :
/*------------------------------------------------------------------------------
  Purpose:     Super Override
  Parameters:  
  Notes:       
------------------------------------------------------------------------------*/

    RUN SUPER.

END PROCEDURE.

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

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

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

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

    RUN SUPER.

    {&BROWSE-NAME}:READ-ONLY IN FRAME {&FRAME-NAME} = TRUE.
    RUN OPENQUERY.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gSuchenBank  _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_Such_1 F_Such_2 F_Name 
      WITH FRAME gSuchenBank.
  ENABLE F_Such_1 F_Such_2 F_Name Br_Bankst RECT-1 
      WITH FRAME gSuchenBank.
  VIEW FRAME gSuchenBank.
  {&OPEN-BROWSERS-IN-QUERY-gSuchenBank}
END PROCEDURE.

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

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

    APPLY 'GO' TO FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.

END PROCEDURE.

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

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

    IF NUM-RESULTS("{&BROWSE-NAME}") <> ? THEN CLOSE QUERY {&BROWSE-NAME}.

    DEF VAR aSuch       AS CHAR                     NO-UNDO.
    DEF VAR bSuch       AS CHAR                     NO-UNDO.

    CASE VSort:
        WHEN 1 THEN DO:
            aSuch = TRIM(SUBSTRING(VSuchbe,01,10)).
            bSuch = TRIM(SUBSTRING(VSuchbe,11,10)).
            OPEN QUERY {&BROWSE-NAME}
                FOR EACH Bankst USE-INDEX Bankst-k1
                                WHERE Bankst.Suchbe               BEGINS aSuch
                                AND   SUBSTRING(Bankst.Suchbe,11) BEGINS bSuch
                                      NO-LOCK.
        END.
        WHEN 2 THEN DO:
            OPEN QUERY {&BROWSE-NAME}
                FOR EACH Bankst USE-INDEX Bankst-k1
                                WHERE Bankst.Adr[01] BEGINS VSuchbe NO-LOCK.
        END.
    END CASE.

END PROCEDURE.

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