GeMIS_WEB/GUI/g-kontakt.w

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

  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 SAktiv          AS LOG                      NO-UNDO INIT FALSE.
DEF VAR Firma           AS CHAR                     NO-UNDO.
DEF VAR AdFirma         AS CHAR                     NO-UNDO.
DEF VAR iLiArt          AS INT                      NO-UNDO.
DEF VAR iVon            AS INT                      NO-UNDO.
DEF VAR iBis            AS INT                      NO-UNDO.
DEF VAR cVon            AS CHAR                     NO-UNDO.
DEF VAR cBis            AS CHAR                     NO-UNDO.

DEF BUFFER     BAdresse FOR  Adresse.
DEF TEMP-TABLE TAdresse LIKE Adresse
                        FIELD xSort     AS CHAR
                        FIELD iInd      AS INT
                        INDEX TAdresse-k1
                        IS PRIMARY
                            XSort
                            Knr
                            iInd.

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

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS F_Fe01 F_Fe02 F_Fe03 F_Fe04 F_Fe05 F_Fe06 ~
F_Fe07 F_Fe08 F_Fe09 F_Fe10 F_Fe11 F_Fe12 F_Fe13 F_Fe14 F_Fe15 Btn_Excel ~
Btn_Cancel RECT-39 
&Scoped-Define DISPLAYED-OBJECTS F_Fe01 F_Fe02 F_Fe03 F_Fe04 F_Fe05 F_Fe06 ~
F_Fe07 F_Fe08 F_Fe09 F_Fe10 F_Fe11 F_Fe12 F_Fe13 F_Fe14 F_Fe15 

/* Custom List Definitions                                              */
/* List-1,List-2,List-3,List-4,List-5,List-6                            */
&Scoped-define List-5 Btn_Excel 
&Scoped-define List-6 F_Fe01 F_Fe02 F_Fe03 F_Fe04 F_Fe05 F_Fe06 F_Fe07 ~
F_Fe08 F_Fe09 F_Fe10 F_Fe11 F_Fe12 F_Fe13 F_Fe14 F_Fe15 

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



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

/* Define a dialog box                                                  */

/* Definitions of the field level widgets                               */
DEFINE BUTTON Btn_Cancel AUTO-END-KEY 
     LABEL "&Abbrechen" 
     SIZE 16 BY 1.

DEFINE BUTTON Btn_Excel 
     IMAGE-UP FILE "grafik/results%.ico":U
     IMAGE-INSENSITIVE FILE "grafik/results%.ico":U
     LABEL "Excel" 
     SIZE 7 BY 1.81.

DEFINE VARIABLE F_Cd01 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd02 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd03 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd04 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd05 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd06 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd07 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd08 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd09 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd10 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd11 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd12 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd13 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd14 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

DEFINE VARIABLE F_Cd15 AS CHARACTER FORMAT "x(05)":U 
     VIEW-AS FILL-IN 
     SIZE 8 BY 1 NO-UNDO.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

DEFINE RECTANGLE RECT-39
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL 
     SIZE 124 BY 3.


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

DEFINE FRAME gKkontaktliste
     F_Fe01 AT ROW 3 COL 3 COLON-ALIGNED NO-LABEL
     F_Fe02 AT ROW 3 COL 11 COLON-ALIGNED NO-LABEL
     F_Fe03 AT ROW 3 COL 19 COLON-ALIGNED NO-LABEL
     F_Fe04 AT ROW 3 COL 27 COLON-ALIGNED NO-LABEL
     F_Cd01 AT ROW 2 COL 3 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     F_Fe05 AT ROW 3 COL 35 COLON-ALIGNED NO-LABEL
     F_Fe06 AT ROW 3 COL 43 COLON-ALIGNED NO-LABEL
     F_Cd02 AT ROW 2 COL 11 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     F_Fe07 AT ROW 3 COL 51 COLON-ALIGNED NO-LABEL
     F_Cd03 AT ROW 2 COL 19 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     F_Fe08 AT ROW 3 COL 59 COLON-ALIGNED NO-LABEL
     F_Cd04 AT ROW 2 COL 27 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     F_Fe09 AT ROW 3 COL 67 COLON-ALIGNED NO-LABEL
     F_Cd05 AT ROW 2 COL 35 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     F_Fe10 AT ROW 3 COL 75 COLON-ALIGNED NO-LABEL
     F_Cd06 AT ROW 2 COL 43 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     F_Fe11 AT ROW 3 COL 83 COLON-ALIGNED NO-LABEL
     F_Cd07 AT ROW 2 COL 51 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     F_Fe12 AT ROW 3 COL 91 COLON-ALIGNED NO-LABEL
     F_Cd08 AT ROW 2 COL 59 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     F_Fe13 AT ROW 3 COL 99 COLON-ALIGNED NO-LABEL
     F_Cd09 AT ROW 2 COL 67 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     F_Fe14 AT ROW 3 COL 107 COLON-ALIGNED NO-LABEL
     F_Cd10 AT ROW 2 COL 75 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     F_Fe15 AT ROW 3 COL 115 COLON-ALIGNED NO-LABEL
     F_Cd11 AT ROW 2 COL 83 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     F_Cd12 AT ROW 2 COL 91 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     F_Cd13 AT ROW 2 COL 99 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     F_Cd14 AT ROW 2 COL 107 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     Btn_Excel AT ROW 5.1 COL 116.6
     F_Cd15 AT ROW 2 COL 115 COLON-ALIGNED NO-LABEL NO-TAB-STOP 
     Btn_Cancel AT ROW 5.67 COL 5.4
     RECT-39 AT ROW 1.52 COL 2
     SPACE(2.19) SKIP(3.42)
    WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER 
         SIDE-LABELS NO-UNDERLINE THREE-D  SCROLLABLE 
         TITLE "Kontaktliste"
         CANCEL-BUTTON Btn_Cancel.


/* *********************** 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 gKkontaktliste 
/* ************************* 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 gKkontaktliste
   Custom                                                               */
ASSIGN 
       FRAME gKkontaktliste:SCROLLABLE       = FALSE
       FRAME gKkontaktliste:HIDDEN           = TRUE.

/* SETTINGS FOR BUTTON Btn_Excel IN FRAME gKkontaktliste
   5                                                                    */
/* SETTINGS FOR FILL-IN F_Cd01 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd02 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd03 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd04 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd05 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd06 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd07 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd08 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd09 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd10 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd11 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd12 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd13 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd14 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Cd15 IN FRAME gKkontaktliste
   NO-DISPLAY NO-ENABLE                                                 */
/* SETTINGS FOR FILL-IN F_Fe01 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe02 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe03 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe04 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe05 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe06 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe07 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe08 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe09 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe10 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe11 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe12 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe13 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe14 IN FRAME gKkontaktliste
   6                                                                    */
/* SETTINGS FOR FILL-IN F_Fe15 IN FRAME gKkontaktliste
   6                                                                    */
/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


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

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

 



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

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

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


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

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


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

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


&Scoped-define SELF-NAME Btn_Cancel
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Cancel gKkontaktliste
ON CHOOSE OF Btn_Cancel IN FRAME gKkontaktliste /* Abbrechen */
DO:
    RUN ENDE.
    RETURN NO-APPLY.
END.

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


&Scoped-define SELF-NAME Btn_Excel
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_Excel gKkontaktliste
ON CHOOSE OF Btn_Excel IN FRAME gKkontaktliste /* Excel */
DO:
    DISABLE Btn_Excel WITH FRAME {&FRAME-NAME}.
    RUN REPORT.
    ENABLE  Btn_Excel WITH FRAME {&FRAME-NAME}.
END.

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


&UNDEFINE SELF-NAME

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


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

    MaxPage  = 1.
    AktSeite = 0.

    SESSION:DATA-ENTRY-RETURN = TRUE.

    SAktiv = DYNAMIC-FUNCTION('getSuperAktiv':U) NO-ERROR.
    IF SAktiv THEN DO:
        Firma   = DYNAMIC-FUNCTION('GETMANDANT':U  ) NO-ERROR.
        AdFirma = DYNAMIC-FUNCTION('GETADMANDANT':U) NO-ERROR.
    END.

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

    ON 'END-ERROR':U OF FRAME {&FRAME-NAME} ANYWHERE
    DO:
        RUN ENDE.
        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 gKkontaktliste  _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 AUSGABE gKkontaktliste 
PROCEDURE AUSGABE :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF VAR DateiName       AS CHAR                     NO-UNDO.
    DEF VAR DatenName       AS CHAR                     NO-UNDO.
    DEF VAR SteuerName      AS CHAR                     NO-UNDO.
    DEF VAR TempName        AS CHAR                     NO-UNDO.
    DEF VAR cParameter      AS CHAR                     NO-UNDO.
    DEF VAR Zelle           AS CHAR                     NO-UNDO.
    DEF VAR VZeile          AS CHAR                     NO-UNDO.
    DEF VAR comAppl         AS COM-HANDLE               NO-UNDO.
    DEF VAR io              AS LOG                      NO-UNDO.
    DEF VAR ix              AS INT                      NO-UNDO.

    DateiName = 'Kontakt.xls'.
    DatenName = SESSION:TEMP-DIR + 'Kontakt.txt'.
    cParameter = DateiName + CHR(01) + DateiName + CHR(01).
    RUN CREATEDATEI ( INPUT cParameter ).
    DateiName = RETURN-VALUE.

    OUTPUT TO VALUE(DatenName).

    FOR EACH TAdresse NO-LOCK 
                      BY TAdresse.Cd01
                      BY TAdresse.Cd02
                      BY TAdresse.Suchbe :
        VZeile = ''.
        VZeile = TAdresse.Cd01                                  + '£'
               + TAdresse.Cd02                                  + '£'
               + STRING(TAdresse.Knr,'999999')                  + '£'
               + TAdresse.Anzeig_Br                             + '£'.
        IF TAdresse.Firma1 <> '' THEN DO:
            IF TAdresse.Tel-1 <> ''
                THEN VZeile = VZeile + 'G: ' + TAdresse.Tel-1.
                ELSE VZeile = VZeile + 'P: ' + TAdresse.Tel-2.                   
        END.
        ELSE DO:
            IF TAdresse.Tel-2 <> ''
                THEN VZeile = VZeile + 'P: ' + TAdresse.Tel-2.
                ELSE VZeile = VZeile + 'G: ' + TAdresse.Tel-1.                   
        END.
        VZeile = VZeile                                         + '£'
               + TAdresse.Cd03                                  + '£'
               + TAdresse.Cd04                                  + '£'
               + TAdresse.Cd05                                  + '£'
               + TAdresse.Cd06.
        VZeile = VZeile + CHR(13).
        VZeile = REPLACE(VZeile, '"', ' ').
        VZeile = REPLACE(VZeile, "'", ' ').
        VZeile = REPLACE(VZeile, ';', ' ').
        PUT CONTROL VZeile.
    END.
    OUTPUT CLOSE.

    comAppl = DYNAMIC-FUNCTION('CREATEEXCEL':U) NO-ERROR.

    RUN OPENEXCEL ( INPUT comAppl,
                    INPUT DateiName,
                    INPUT '',
                    OUTPUT io ).
    IF NOT io THEN DO:
        RUN FEHLER ( INPUT 1040 ).
        RETURN NO-APPLY.
    END.

    Zelle = 'A2'.
    comAppl:Range(Zelle):SELECT.
    comAppl:Selection:FormulaR1C1 = 'TEXT;' + DatenName.
    comAppl:Application:RUN ( 'DateiEinfügen' ).

    DYNAMIC-FUNCTION('RELEASEEXCEL':U, INPUT comAppl ) NO-ERROR.

END PROCEDURE.

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

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

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

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

    DEF VAR Sprcd       AS INT                      NO-UNDO.
    DEF VAR ix          AS INT                      NO-UNDO.
    DEF VAR cFelder     AS CHAR                     NO-UNDO.

    RUN SUPER.

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

DO WITH FRAME {&FRAME-NAME}:
    Sprcd = DYNAMIC-FUNCTION('GETBENUTZERSPRCD':U) NO-ERROR.
    FIND Femeld WHERE Femeld.Sprcd = Sprcd
                AND   Femeld.Fenr  = 999 NO-LOCK NO-ERROR.
    IF AVAILABLE Femeld THEN cFelder = Femeld.Fetext.
    ELSE                     cFelder = ''.
    DO ix = 1 TO NUM-ENTRIES(Femeld.Fetext, ','):
        CASE ix:
            WHEN 01 THEN F_Cd01:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 02 THEN F_Cd02:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 03 THEN F_Cd03:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 04 THEN F_Cd04:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 05 THEN F_Cd05:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 06 THEN F_Cd06:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 07 THEN F_Cd07:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 08 THEN F_Cd08:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 09 THEN F_Cd09:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 10 THEN F_Cd10:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 11 THEN F_Cd11:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 12 THEN F_Cd12:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 13 THEN F_Cd13:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 14 THEN F_Cd14:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
            WHEN 15 THEN F_Cd15:SCREEN-VALUE = ENTRY(ix, cFelder, ',').
        END CASE.
    END.

    GET-KEY-VALUE SECTION 'Auswertungen'
                  KEY     'Kontaktliste'
                  VALUE   cFelder.
    IF cFelder = ? THEN cFelder = FILL('@', 15).

    DO ix = 1 TO NUM-ENTRIES(cFelder, '@').
        CASE ix:
            WHEN  1 THEN F_Fe01       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN  2 THEN F_Fe02       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN  3 THEN F_Fe03       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN  4 THEN F_Fe04       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN  5 THEN F_Fe05       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN  6 THEN F_Fe06       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN  7 THEN F_Fe07       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN  8 THEN F_Fe08       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN  9 THEN F_Fe09       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN 10 THEN F_Fe10       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN 11 THEN F_Fe11       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN 12 THEN F_Fe12       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN 13 THEN F_Fe13       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN 14 THEN F_Fe14       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
            WHEN 15 THEN F_Fe15       =         ENTRY(ix, cFelder, '@')      NO-ERROR.
        END CASE.
    END.

    DISPLAY {&List-6}.

END.

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI gKkontaktliste  _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_Fe01 F_Fe02 F_Fe03 F_Fe04 F_Fe05 F_Fe06 F_Fe07 F_Fe08 F_Fe09 F_Fe10 
          F_Fe11 F_Fe12 F_Fe13 F_Fe14 F_Fe15 
      WITH FRAME gKkontaktliste.
  ENABLE F_Fe01 F_Fe02 F_Fe03 F_Fe04 F_Fe05 F_Fe06 F_Fe07 F_Fe08 F_Fe09 F_Fe10 
         F_Fe11 F_Fe12 F_Fe13 F_Fe14 F_Fe15 Btn_Excel Btn_Cancel RECT-39 
      WITH FRAME gKkontaktliste.
  VIEW FRAME gKkontaktliste.
  {&OPEN-BROWSERS-IN-QUERY-gKkontaktliste}
END PROCEDURE.

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

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

    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 exitObject gKkontaktliste 
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 REPORT gKkontaktliste 
PROCEDURE REPORT :
/*------------------------------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
------------------------------------------------------------------------------*/

    DEF VAR cFelder     AS CHAR                     NO-UNDO.

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

    cFelder = F_Fe01                                + '@'
            + F_Fe02                                + '@'
            + F_Fe03                                + '@'
            + F_Fe04                                + '@'
            + F_Fe05                                + '@'
            + F_Fe06                                + '@'
            + F_Fe07                                + '@'
            + F_Fe08                                + '@'
            + F_Fe09                                + '@'
            + F_Fe10                                + '@'
            + F_Fe11                                + '@'
            + F_Fe12                                + '@'
            + F_Fe13                                + '@'
            + F_Fe14                                + '@'
            + F_Fe15.
    PUT-KEY-VALUE SECTION 'Auswertungen'
                  KEY     'Kontaktliste'
                  VALUE   cFelder.

    Btn_Excel:HIDDEN  = FALSE.
    Btn_Cancel:HIDDEN = FALSE.
            
    SESSION:SET-WAIT-STATE('GENERAL').
    
    RUN SELEKTION.
    RUN AUSGABE.

    SESSION:SET-WAIT-STATE('').
    
    Btn_Excel:HIDDEN  = TRUE.
    Btn_Cancel:HIDDEN = TRUE.
    RUN ENDE.
END.

END PROCEDURE.

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

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

    FOR EACH TAdresse:
        DELETE  TAdresse.
    END.

    FOR EACH BAdresse USE-INDEX Adresse-k1
                      WHERE BAdresse.Firma = AdFirma
                      AND   BAdresse.Aktiv = TRUE NO-LOCK:
        IF F_Fe01 <> ''                             AND
           LOOKUP(BAdresse.Cd01, F_Fe01, ',') = 0   THEN NEXT.
        IF F_Fe02 <> ''                             AND
           LOOKUP(BAdresse.Cd02, F_Fe02, ',') = 0   THEN NEXT.
        IF F_Fe03 <> ''                             AND
           LOOKUP(BAdresse.Cd03, F_Fe03, ',') = 0   THEN NEXT.
        IF F_Fe04 <> ''                             AND
           LOOKUP(BAdresse.Cd04, F_Fe04, ',') = 0   THEN NEXT.
        IF F_Fe05 <> ''                             AND
           LOOKUP(BAdresse.Cd05, F_Fe05, ',') = 0   THEN NEXT.
        IF F_Fe06 <> ''                             AND
           LOOKUP(BAdresse.Cd06, F_Fe06, ',') = 0   THEN NEXT.
        IF F_Fe07 <> ''                             AND
           LOOKUP(BAdresse.Cd07, F_Fe07, ',') = 0   THEN NEXT.
        IF F_Fe08 <> ''                             AND
           LOOKUP(BAdresse.Cd08, F_Fe08, ',') = 0   THEN NEXT.
        IF F_Fe09 <> ''                             AND
           LOOKUP(BAdresse.Cd09, F_Fe09, ',') = 0   THEN NEXT.
        IF F_Fe10 <> ''                             AND
           LOOKUP(BAdresse.Cd10, F_Fe10, ',') = 0   THEN NEXT.
        IF F_Fe11 <> ''                             AND
           LOOKUP(BAdresse.Cd11, F_Fe11, ',') = 0   THEN NEXT.
        IF F_Fe12 <> ''                             AND
           LOOKUP(BAdresse.Cd12, F_Fe12, ',') = 0   THEN NEXT.
        IF F_Fe13 <> ''                             AND
           LOOKUP(BAdresse.Cd13, F_Fe13, ',') = 0   THEN NEXT.
        IF F_Fe14 <> ''                             AND
           LOOKUP(BAdresse.Cd14, F_Fe14, ',') = 0   THEN NEXT.
        IF F_Fe15 <> ''                             AND
           LOOKUP(BAdresse.Cd15, F_Fe15, ',') = 0   THEN NEXT.

        CREATE  TAdresse.
        BUFFER-COPY BAdresse TO TAdresse.
    END.

END PROCEDURE.

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