GeMIS_WEB/GUI/v8/d-aufko-admin.w

&ANALYZE-SUSPEND _VERSION-NUMBER UIB_v8r12 GUI ADM1
&ANALYZE-RESUME
/* Connected Databases 
          anadat           PROGRESS
*/
&Scoped-define WINDOW-NAME CURRENT-WINDOW
&Scoped-define FRAME-NAME D-Dialog
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS D-Dialog 
/*------------------------------------------------------------------------

  File: 

  Description: from cntnrdlg.w - ADM SmartDialog Template

  Input Parameters:
      <none>

  Output Parameters:
      <none>

  Author: 

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

/* 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 AufRecid            AS RECID                    NO-UNDO.
DEF VAR ok                  AS LOG                      NO-UNDO.

/*  ----------  Globale Variablen   ---------------------------------- */

{ v8/globvar.i" " " " "SHARED" }
{ v8/debivar.i " " " " "SHARED" }
{ v8/artivar.i " " " " "SHARED" }
{ v8/contvar.i " " " " "SHARED" }

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

/* Name of designated FRAME-NAME and/or first browse and/or first query */
&Scoped-define FRAME-NAME D-Dialog

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

/* Definitions for DIALOG-BOX D-Dialog                                  */
&Scoped-define FIELDS-IN-QUERY-D-Dialog Aufko.Knr Aufko.Fak_Knr Aufko.Faknr ~
Aufko.Samm_Nr Aufko.Passant Aufko.Gedruckt Aufko.Verbucht 
&Scoped-define ENABLED-FIELDS-IN-QUERY-D-Dialog Aufko.Knr Aufko.Fak_Knr ~
Aufko.Faknr Aufko.Samm_Nr Aufko.Passant Aufko.Gedruckt Aufko.Verbucht 
&Scoped-define ENABLED-TABLES-IN-QUERY-D-Dialog Aufko
&Scoped-define FIRST-ENABLED-TABLE-IN-QUERY-D-Dialog Aufko
&Scoped-define QUERY-STRING-D-Dialog FOR EACH Aufko SHARE-LOCK
&Scoped-define OPEN-QUERY-D-Dialog OPEN QUERY D-Dialog FOR EACH Aufko SHARE-LOCK.
&Scoped-define TABLES-IN-QUERY-D-Dialog Aufko
&Scoped-define FIRST-TABLE-IN-QUERY-D-Dialog Aufko


/* Standard List Definitions                                            */
&Scoped-Define ENABLED-FIELDS Aufko.Knr Aufko.Fak_Knr Aufko.Faknr ~
Aufko.Samm_Nr Aufko.Passant Aufko.Gedruckt Aufko.Verbucht 
&Scoped-define ENABLED-TABLES Aufko
&Scoped-define FIRST-ENABLED-TABLE Aufko
&Scoped-Define ENABLED-OBJECTS CB_Fakart CB_Aufsta Btn_OK Btn_Cancel 
&Scoped-Define DISPLAYED-FIELDS Aufko.Knr Aufko.Fak_Knr Aufko.Faknr ~
Aufko.Samm_Nr Aufko.Passant Aufko.Gedruckt Aufko.Verbucht 
&Scoped-define DISPLAYED-TABLES Aufko
&Scoped-define FIRST-DISPLAYED-TABLE Aufko
&Scoped-Define DISPLAYED-OBJECTS F_Lieferadresse F_Fakturaadresse CB_Fakart ~
CB_Aufsta 

/* Custom List Definitions                                              */
/* List-1,List-2,List-3,List-4,List-5,List-6                            */
&Scoped-define List-1 Aufko.Faknr Aufko.Samm_Nr Aufko.Passant ~
Aufko.Gedruckt Aufko.Verbucht 

/* _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 15 BY 1
     BGCOLOR 8 .

DEFINE BUTTON Btn_OK AUTO-GO 
     LABEL "&OK" 
     SIZE 15 BY 1
     BGCOLOR 8 .

DEFINE VARIABLE CB_Aufsta AS CHARACTER FORMAT "X(256)":U 
     VIEW-AS COMBO-BOX INNER-LINES 5
     DROP-DOWN-LIST
     SIZE 50 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE CB_Fakart AS CHARACTER FORMAT "X(256)":U 
     VIEW-AS COMBO-BOX INNER-LINES 5
     DROP-DOWN-LIST
     SIZE 50 BY 1
     BGCOLOR 15  NO-UNDO.

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

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

/* Query definitions                                                    */
&ANALYZE-SUSPEND
DEFINE QUERY D-Dialog FOR 
      Aufko SCROLLING.
&ANALYZE-RESUME

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

DEFINE FRAME D-Dialog
     Aufko.Knr AT ROW 2.52 COL 18 COLON-ALIGNED
          LABEL "Liefer-Knr" FORMAT "999999"
          VIEW-AS FILL-IN NATIVE 
          SIZE 11 BY 1
          BGCOLOR 15  NO-TAB-STOP 
     F_Lieferadresse AT ROW 2.52 COL 31 COLON-ALIGNED NO-LABEL
     Aufko.Fak_Knr AT ROW 3.52 COL 18 COLON-ALIGNED
          LABEL "Faktura-Knr" FORMAT "999999"
          VIEW-AS FILL-IN NATIVE 
          SIZE 11 BY 1
          BGCOLOR 15  NO-TAB-STOP 
     F_Fakturaadresse AT ROW 3.52 COL 31 COLON-ALIGNED NO-LABEL
     Aufko.Faknr AT ROW 4.52 COL 18 COLON-ALIGNED
          VIEW-AS FILL-IN NATIVE 
          SIZE 11 BY 1
          BGCOLOR 15 
     CB_Fakart AT ROW 4.52 COL 31 COLON-ALIGNED NO-LABEL
     Aufko.Samm_Nr AT ROW 5.52 COL 18 COLON-ALIGNED
          LABEL "Sammel-Nr" FORMAT "999999"
          VIEW-AS FILL-IN NATIVE 
          SIZE 11 BY 1
          BGCOLOR 15 
     CB_Aufsta AT ROW 5.52 COL 31 COLON-ALIGNED NO-LABEL
     Aufko.Passant AT ROW 6.52 COL 18 COLON-ALIGNED
          LABEL "Passant" FORMAT "J/N"
          VIEW-AS FILL-IN NATIVE 
          SIZE 5 BY 1
          BGCOLOR 15 
     Aufko.Gedruckt AT ROW 7.52 COL 18 COLON-ALIGNED
          LABEL "Gedruckt" FORMAT "J/N"
          VIEW-AS FILL-IN NATIVE 
          SIZE 5 BY 1
          BGCOLOR 15 
     Btn_OK AT ROW 7.52 COL 67.4
     Aufko.Verbucht AT ROW 8.52 COL 18 COLON-ALIGNED
          LABEL "Verbucht" FORMAT "J/N"
          VIEW-AS FILL-IN NATIVE 
          SIZE 5 BY 1
          BGCOLOR 15 
     Btn_Cancel AT ROW 8.52 COL 67.4
     SPACE(8.39) SKIP(1.57)
    WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER 
         SIDE-LABELS NO-UNDERLINE THREE-D  SCROLLABLE 
         TITLE "Aenderungen durch den Administrator"
         DEFAULT-BUTTON Btn_OK CANCEL-BUTTON Btn_Cancel.


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

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

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

{src/adm/method/containr.i}

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




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

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

/* SETTINGS FOR FILL-IN Aufko.Faknr IN FRAME D-Dialog
   1                                                                    */
/* SETTINGS FOR FILL-IN Aufko.Fak_Knr IN FRAME D-Dialog
   EXP-LABEL EXP-FORMAT                                                 */
ASSIGN 
       Aufko.Fak_Knr:READ-ONLY IN FRAME D-Dialog        = TRUE.

/* SETTINGS FOR FILL-IN F_Fakturaadresse IN FRAME D-Dialog
   NO-ENABLE                                                            */
/* SETTINGS FOR FILL-IN F_Lieferadresse IN FRAME D-Dialog
   NO-ENABLE                                                            */
/* SETTINGS FOR FILL-IN Aufko.Gedruckt IN FRAME D-Dialog
   1 EXP-LABEL EXP-FORMAT                                               */
/* SETTINGS FOR FILL-IN Aufko.Knr IN FRAME D-Dialog
   EXP-LABEL EXP-FORMAT                                                 */
ASSIGN 
       Aufko.Knr:READ-ONLY IN FRAME D-Dialog        = TRUE.

/* SETTINGS FOR FILL-IN Aufko.Passant IN FRAME D-Dialog
   1 EXP-LABEL EXP-FORMAT                                               */
/* SETTINGS FOR FILL-IN Aufko.Samm_Nr IN FRAME D-Dialog
   1 EXP-LABEL EXP-FORMAT                                               */
/* SETTINGS FOR FILL-IN Aufko.Verbucht IN FRAME D-Dialog
   1 EXP-LABEL EXP-FORMAT                                               */
/* _RUN-TIME-ATTRIBUTES-END */
&ANALYZE-RESUME


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

&ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX D-Dialog
/* Query rebuild information for DIALOG-BOX D-Dialog
     _TblList          = "AnaDat.Aufko"
     _Options          = "SHARE-LOCK"
     _Query            is NOT OPENED
*/  /* DIALOG-BOX D-Dialog */
&ANALYZE-RESUME

 



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

&Scoped-define SELF-NAME D-Dialog
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL D-Dialog D-Dialog
ON WINDOW-CLOSE OF FRAME D-Dialog /* Aenderungen durch den Administrator */
DO:  
  /* Add Trigger to equate WINDOW-CLOSE to END-ERROR. */
  APPLY "END-ERROR":U TO SELF.
END.

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


&Scoped-define SELF-NAME Btn_OK
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_OK D-Dialog
ON CHOOSE OF Btn_OK IN FRAME D-Dialog /* OK */
DO:

    DEF VAR iFaknr      AS INT                      NO-UNDO.
    DEF BUFFER BAufko   FOR Aufko.

DO TRANSACTION WITH FRAME {&FRAME-NAME} WHILE TRUE:
    
    FIND Aufko WHERE RECID(Aufko) = AufRecid.
    iFaknr = INTEGER(Aufko.Faknr:SCREEN-VALUE) NO-ERROR.
    IF iFaknr > 0 THEN DO:
        FIND FIRST Debop NO-LOCK
            WHERE Debop.Firma = GVFirma
            AND   Debop.Faknr = iFaknr NO-ERROR.
        IF AVAILABLE Debop THEN DO:
            MESSAGE 'Diese Rechnugesnummer ist ungültig (bereits vorhanden)'
                    VIEW-AS ALERT-BOX ERROR.
            APPLY 'ENTRY' TO Aufko.Faknr.
            RETURN NO-APPLY.
        END.
        FIND FIRST BAufko NO-LOCK
            WHERE BAufko.Firma = Aufko.Firma
            AND   BAufko.Faknr = iFaknr
            AND   BAufko.Knr  <> Aufko.Knr NO-ERROR.
        IF AVAILABLE BAufko THEN DO:
            MESSAGE 'Diese Rechnugesnummer ist bereits bei Kunde ' BAufko.Knr ' vergeben!'
                    VIEW-AS ALERT-BOX ERROR.
            APPLY 'ENTRY' TO Aufko.Faknr.
            RELEASE BAufko.
            RETURN NO-APPLY.
        END.
        FIND FIRST BAufko NO-LOCK
            WHERE BAufko.Firma    = Aufko.Firma
            AND   BAufko.Faknr    = iFaknr
            AND   BAufko.Knr      = Aufko.Knr
            AND   BAufko.Aufnr   <> Aufko.Aufnr
            AND   BAufko.Samm_Nr <> Aufko.Samm_Nr NO-ERROR.
        IF AVAILABLE BAufko THEN DO:
            MESSAGE 'Diese Rechnugesnummer ist bereits bei einer anderen Sammelrechung ' BAufko.Aufnr ' vergeben!'
                    VIEW-AS ALERT-BOX ERROR.
            APPLY 'ENTRY' TO Aufko.Faknr.
            RELEASE BAufko.
            RETURN NO-APPLY.
        END.
    END.
    ASSIGN  {&List-1}.
    ASSIGN  Aufko.Fak_Art = INTEGER(SUBSTRING(CB_Fakart:SCREEN-VALUE,01,03))
            Aufko.Auf_Sta = INTEGER(SUBSTRING(CB_Aufsta:SCREEN-VALUE,01,03)).
    RELEASE Aufko.
    LEAVE.
END.
END.

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


&UNDEFINE SELF-NAME

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK D-Dialog 


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

FIND Aufko USE-INDEX Aufko-k1
           WHERE Aufko.Firma = GVFirma
           AND   Aufko.Aufnr = XVAufnr NO-LOCK NO-ERROR.
IF NOT AVAILABLE Aufko THEN DO:
    APPLY 'WINDOW-CLOSE' TO FRAME {&FRAME-NAME}.
    RETURN NO-APPLY.
END.
AufRecid = RECID(Aufko).

F_Lieferadresse  = ''.
F_Fakturaadresse = ''.
FIND Adresse USE-INDEX Adresse-k1
             WHERE Adresse.Firma = GVFirma
             AND   Adresse.Knr   = Aufko.Knr NO-LOCK NO-ERROR.
IF AVAILABLE Adresse THEN F_Lieferadresse = Adresse.Anzeig_Br.

FIND Adresse USE-INDEX Adresse-k1
             WHERE Adresse.Firma = GVFirma
             AND   Adresse.Knr   = Aufko.Fak_Knr NO-LOCK NO-ERROR.
IF AVAILABLE Adresse THEN F_Fakturaadresse = Adresse.Anzeig_Br.

DO WITH FRAME {&FRAME-NAME}:

    /*  Fakturaarten    */    
    
    ok = TRUE.
    ix = 0.
    i1 = 1.
    DO WHILE ok:
        ok = CB_Fakart:DELETE(1).
    END.
    FOR EACH Tabel USE-INDEX Tabel-k2
                   WHERE Tabel.Firma  = GVFirma
                   AND   Tabel.RecArt = 'FAKART' NO-LOCK:
        ok = CB_Fakart:ADD-LAST(STRING(Tabel.CodeI,"zz9  ") + Tabel.Bez1).
        ix = ix + 1.
        IF Tabel.CodeI = Aufko.Fak_Art THEN i1 = ix.
    END.
    CB_Fakart:SCREEN-VALUE = CB_Fakart:ENTRY(i1).

    /*  Auftragstatus   */    
    
    ok = TRUE.
    ix = 0.
    i1 = 1.
    DO WHILE ok:
        ok = CB_Aufsta:DELETE(1).
    END.
    FOR EACH Tabel USE-INDEX Tabel-k2
                   WHERE Tabel.Firma  = GVFirma
                   AND   Tabel.RecArt = 'AUFSTATUS' NO-LOCK:
        ok = CB_Aufsta:ADD-LAST(STRING(Tabel.CodeI,"zz9  ") + Tabel.Bez1).
        ix = ix + 1.
        IF Tabel.CodeI = Aufko.Auf_Sta THEN i1 = ix.
    END.
    CB_Aufsta:SCREEN-VALUE = CB_Aufsta:ENTRY(i1).

END.

{src/adm/template/dialogmn.i}

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


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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE adm-create-objects D-Dialog  _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 adm-row-available D-Dialog  _ADM-ROW-AVAILABLE
PROCEDURE adm-row-available :
/*------------------------------------------------------------------------------
  Purpose:     Dispatched to this procedure when the Record-
               Source has a new row available.  This procedure
               tries to get the new row (or foriegn keys) from
               the Record-Source and process it.
  Parameters:  <none>
------------------------------------------------------------------------------*/

  /* Define variables needed by this internal procedure.             */
  {src/adm/template/row-head.i}

  /* Process the newly available records (i.e. display fields,
     open queries, and/or pass records on to any RECORD-TARGETS).    */
  {src/adm/template/row-end.i}

END PROCEDURE.

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

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

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enable_UI D-Dialog  _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_Lieferadresse F_Fakturaadresse CB_Fakart CB_Aufsta 
      WITH FRAME D-Dialog.
  IF AVAILABLE Aufko THEN 
    DISPLAY Aufko.Knr Aufko.Fak_Knr Aufko.Faknr Aufko.Samm_Nr Aufko.Passant 
          Aufko.Gedruckt Aufko.Verbucht 
      WITH FRAME D-Dialog.
  ENABLE Aufko.Knr Aufko.Fak_Knr Aufko.Faknr CB_Fakart Aufko.Samm_Nr CB_Aufsta 
         Aufko.Passant Aufko.Gedruckt Btn_OK Aufko.Verbucht Btn_Cancel 
      WITH FRAME D-Dialog.
  VIEW FRAME D-Dialog.
  {&OPEN-BROWSERS-IN-QUERY-D-Dialog}
END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE send-records D-Dialog  _ADM-SEND-RECORDS
PROCEDURE send-records :
/*------------------------------------------------------------------------------
  Purpose:     Send record ROWID's for all tables used by
               this file.
  Parameters:  see template/snd-head.i
------------------------------------------------------------------------------*/

  /* Define variables needed by this internal procedure.               */
  {src/adm/template/snd-head.i}

  /* For each requested table, put it's ROWID in the output list.      */
  {src/adm/template/snd-list.i "Aufko"}

  /* Deal with any unexpected table requests before closing.           */
  {src/adm/template/snd-end.i}

END PROCEDURE.

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

&ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE state-changed D-Dialog 
PROCEDURE state-changed :
/* -----------------------------------------------------------
  Purpose:     
  Parameters:  <none>
  Notes:       
-------------------------------------------------------------*/
  DEFINE INPUT PARAMETER p-issuer-hdl AS HANDLE NO-UNDO.
  DEFINE INPUT PARAMETER p-state AS CHARACTER NO-UNDO.
END PROCEDURE.

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