GeMIS_WEB/GUI/v8/d-fakartwechsel.w

&ANALYZE-SUSPEND _VERSION-NUMBER UIB_v8r12 GUI ADM1
&ANALYZE-RESUME
&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 XFak_Art    AS CHAR                             NO-UNDO.
DEF VAR VFak_Art    AS INT                              NO-UNDO.
DEF VAR ok          AS LOG                              NO-UNDO.
DEF VAR xx          AS INT                              NO-UNDO.
DEF VAR ARecid      AS RECID                            NO-UNDO.
DEF VAR AltCode     AS INT                              NO-UNDO.

DEF BUFFER XAufko   FOR Aufko.

/*  ----------  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 first Frame and/or Browse and/or first Query                 */
&Scoped-define FRAME-NAME D-Dialog

/* Standard List Definitions                                            */
&Scoped-Define ENABLED-OBJECTS Btn_OK F_Knr E_Adresse F_Aufnr F_Faknr ~
CB-Fak_Art RECT-32 
&Scoped-Define DISPLAYED-OBJECTS F_Knr E_Adresse F_Aufnr F_Faknr CB-Fak_Art 

/* Custom List Definitions                                              */
/* List-1,List-2,List-3,List-4,List-5,List-6                            */
&Scoped-define List-1 F_Knr E_Adresse F_Aufnr F_Faknr 

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



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

/* Define a dialog box                                                  */

/* Definitions of the field level widgets                               */
DEFINE BUTTON Btn_OK AUTO-GO DEFAULT 
     LABEL "OK" 
     SIZE 14 BY 1.24
     BGCOLOR 8 .

DEFINE VARIABLE CB-Fak_Art AS CHARACTER FORMAT "X(256)":U 
     LABEL "Faktura-Art" 
     VIEW-AS COMBO-BOX INNER-LINES 5
     DROP-DOWN-LIST
     SIZE 47.4 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE E_Adresse AS CHARACTER 
     VIEW-AS EDITOR NO-WORD-WRAP MAX-CHARS 500
     SIZE 47.8 BY 4.95
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_Aufnr AS INTEGER FORMAT "9999999":U INITIAL 0 
     LABEL "Aufnr" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 11 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_Faknr AS INTEGER FORMAT "9999999":U INITIAL 0 
     LABEL "Fakturanummer" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 11 BY 1
     BGCOLOR 15  NO-UNDO.

DEFINE VARIABLE F_Knr AS INTEGER FORMAT "999999":U INITIAL 0 
     LABEL "Kunde" 
     VIEW-AS FILL-IN NATIVE 
     SIZE 11 BY 1
     BGCOLOR 15 .

DEFINE RECTANGLE RECT-32
     EDGE-PIXELS 2 GRAPHIC-EDGE  NO-FILL 
     SIZE 75.4 BY 13.


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

DEFINE FRAME D-Dialog
     Btn_OK AT ROW 12 COL 26.2
     F_Knr AT ROW 1.71 COL 24.2 COLON-ALIGNED NO-TAB-STOP 
     E_Adresse AT ROW 2.95 COL 26.2 NO-LABEL NO-TAB-STOP 
     F_Aufnr AT ROW 8.52 COL 24.2 COLON-ALIGNED NO-TAB-STOP 
     F_Faknr AT ROW 9.52 COL 24.2 COLON-ALIGNED NO-TAB-STOP 
     CB-Fak_Art AT ROW 10.52 COL 24.2 COLON-ALIGNED
     RECT-32 AT ROW 1.29 COL 3
     SPACE(1.98) SKIP(0.50)
    WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER 
         SIDE-LABELS NO-UNDERLINE THREE-D  SCROLLABLE 
         TITLE "Aendern der Fakturaart"
         DEFAULT-BUTTON Btn_OK.


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

&ANALYZE-SUSPEND _PROCEDURE-SETTINGS
/* Settings for THIS-PROCEDURE
   Type: SmartDialog
   Allow: Basic,Browse,DB-Fields,Query,Smart
   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
   Custom                                                               */
ASSIGN 
       FRAME D-Dialog:SCROLLABLE       = FALSE
       FRAME D-Dialog:HIDDEN           = TRUE.

/* SETTINGS FOR EDITOR E_Adresse IN FRAME D-Dialog
   1                                                                    */
ASSIGN 
       E_Adresse:RETURN-INSERTED IN FRAME D-Dialog  = TRUE
       E_Adresse:READ-ONLY IN FRAME D-Dialog        = TRUE.

/* SETTINGS FOR FILL-IN F_Aufnr IN FRAME D-Dialog
   1                                                                    */
ASSIGN 
       F_Aufnr:READ-ONLY IN FRAME D-Dialog        = TRUE.

/* SETTINGS FOR FILL-IN F_Faknr IN FRAME D-Dialog
   1                                                                    */
ASSIGN 
       F_Faknr:READ-ONLY IN FRAME D-Dialog        = TRUE.

/* SETTINGS FOR FILL-IN F_Knr IN FRAME D-Dialog
   1                                                                    */
ASSIGN 
       F_Knr:READ-ONLY IN FRAME D-Dialog        = TRUE.

/* _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
     _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 GO OF FRAME D-Dialog /* Aendern der Fakturaart */
DO:
    REPEAT TRANSACTION:
        FIND Aufko WHERE RECID(Aufko) = ARecid.
        FIND Tabel USE-INDEX Tabel-k1
                   WHERE Tabel.Firma  = GVFirma
                   AND   Tabel.RecArt = "FAKART"
                   AND   Tabel.CodeC  = ""
                   AND   Tabel.CodeI  = Aufko.Fak_Art
                   AND   Tabel.Sprcd  = 1   NO-LOCK NO-ERROR.
        AltCode = Tabel.Int_3.

        IF Aufko.Fak_Art  = 99  AND
           VFak_Art      <> 99  THEN Aufko.Faknr = 0.
        IF Aufko.Fak_Art <> 99  AND
           VFak_Art       = 99  THEN Aufko.Faknr = Aufko.Aufnr.
           
        Aufko.Fak_Art = VFak_Art.
        
        FIND Tabel USE-INDEX Tabel-k1
                   WHERE Tabel.Firma  = GVFirma
                   AND   Tabel.RecArt = "FAKART"
                   AND   Tabel.CodeC  = ""
                   AND   Tabel.CodeI  = Aufko.Fak_Art
                   AND   Tabel.Sprcd  = 1   NO-LOCK NO-ERROR.
                   
        IF Tabel.Int_3 = 4 THEN DO:
            FIND FIRST XAufko USE-INDEX Aufko-k4
                              WHERE XAufko.Firma    = Aufko.Firma
                              AND   XAufko.Knr      = Aufko.Knr
                              AND   XAufko.Fak_Art  = Aufko.Fak_Art
                              AND   XAufko.Faknr    = 0
                              AND   XAufko.Samm_Nr <> 0 NO-LOCK NO-ERROR.
            IF AVAILABLE XAufko THEN DO:
                Aufko.Samm_Nr = XAufko.Samm_Nr.
                Aufko.Faknr   = XAufko.Faknr.
            END.
            ELSE DO:
                FIND LAST XAufko USE-INDEX Aufko-k5
                                 WHERE XAufko.Firma    = Aufko.Firma
                                 AND   XAufko.Fak_Art  = Aufko.Fak_Art
                                       NO-LOCK NO-ERROR.
                IF AVAILABLE XAufko THEN Aufko.Samm_Nr = XAufko.Samm_Nr + 1.
                ELSE                     Aufko.Samm_Nr = 1.
                Aufko.Faknr   = 0.
            END.
        END.
        ELSE DO:
            Aufko.Samm_Nr = 0.
            IF AltCode = 4 THEN DO:
                Aufko.Faknr   = 0.
                Aufko.Fak_Dat = ?.
            END.
        END.
        LEAVE.
    END.
    RELEASE Aufko.
END.

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


&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL D-Dialog D-Dialog
ON WINDOW-CLOSE OF FRAME D-Dialog /* Aendern der Fakturaart */
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 CB-Fak_Art
&ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL CB-Fak_Art D-Dialog
ON VALUE-CHANGED OF CB-Fak_Art IN FRAME D-Dialog /* Faktura-Art */
DO:
    DO WITH FRAME {&FRAME-NAME}:
        ix       = LOOKUP(SELF:SCREEN-VALUE, SELF:LIST-ITEMS, '|').
        VFak_Art = INTEGER(ENTRY(ix, XFak_Art, "|")).
    END.
END.

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


&UNDEFINE SELF-NAME

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


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

{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_Knr E_Adresse F_Aufnr F_Faknr CB-Fak_Art 
      WITH FRAME D-Dialog.
  ENABLE Btn_OK F_Knr E_Adresse F_Aufnr F_Faknr CB-Fak_Art RECT-32 
      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 local-view D-Dialog 
PROCEDURE local-view :
/*------------------------------------------------------------------------------
  Purpose:     Override standard ADM method
  Notes:       
------------------------------------------------------------------------------*/

    RUN dispatch IN THIS-PROCEDURE ( INPUT 'view':U ) .
    
    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 'GO' TO FRAME {&FRAME-NAME}.
        RETURN NO-APPLY.
    END.
    ARecid = RECID(Aufko).

DO WITH FRAME {&FRAME-NAME}:

    CB-Fak_Art:DELIMITER = "|".
    XFak_Art  = ''.
    ok        = TRUE.
    xx        = 0.
    DO WHILE ok:
        ok = CB-Fak_Art:DELETE(1).
    END.
    FOR EACH Tabel USE-INDEX Tabel-k1
                   WHERE Tabel.Firma  = GVFirma
                   AND   Tabel.RecArt = 'FAKART'
                   AND   Tabel.CodeC  = ''
                   AND   Tabel.Sprcd  = 1   NO-LOCK:
        ok       = CB-Fak_Art:ADD-LAST(Tabel.Bez1).
        XFak_Art = XFak_Art + STRING(Tabel.CodeI,"999|").
    END.
    ix       = LOOKUP(STRING(Aufko.Fak_Art,"999"), XFak_Art, '|').
    VFak_Art = INTEGER(ENTRY(ix, XFak_Art, "|")).
    CB-Fak_Art:SCREEN-VALUE = CB-Fak_Art:ENTRY(ix).

    E_Adresse = ''.
    F_Knr     = Aufko.Knr.
    F_Aufnr   = AUfko.Aufnr.
    F_Faknr   = AUfko.Faknr.
    FIND Adresse USE-INDEX Adresse-k1
                 WHERE Adresse.Firma = AdFirma
                 AND   Adresse.Knr   = Aufko.Knr NO-LOCK NO-ERROR.
    IF AVAILABLE Adresse THEN DO:
        E_Adresse = Adresse.Anschrift[05] + CHR(10) +
                    Adresse.Anschrift[06] + CHR(10) +
                    Adresse.Anschrift[07] + CHR(10) +
                    Adresse.Anschrift[08] + CHR(10) +
                    Adresse.Anschrift[09] + CHR(10) +
                    Adresse.Anschrift[10] + CHR(10) +
                    Adresse.Anschrift[11] + CHR(10) +
                    Adresse.Anschrift[12].
    END.
    DISPLAY {&List-1}.
    APPLY 'ENTRY' TO CB-Fak_Art.
    
END.

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

  /* SEND-RECORDS does nothing because there are no External
     Tables specified for this SmartDialog, and there are no
     tables specified in any contained Browse, Query, or Frame. */

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