&ANALYZE-SUSPEND _VERSION-NUMBER AB_v9r12 GUI ADM2 &ANALYZE-RESUME &Scoped-define WINDOW-NAME CURRENT-WINDOW &Scoped-define FRAME-NAME gSerienMail &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _DEFINITIONS gSerienMail /*------------------------------------------------------------------------ File: Description: from cntnrdlg.w - ADM2 SmartDialog Template Input Parameters: Output Parameters: 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 PARAMETER ipBuffer AS HANDLE 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 ProgName AS CHAR NO-UNDO. DEF VAR SAktiv AS LOG NO-UNDO. DEF VAR Firma AS CHAR NO-UNDO. DEF VAR AdFirma AS CHAR NO-UNDO. DEF VAR hFeld AS HANDLE NO-UNDO. DEF VAR iKommArt AS INT NO-UNDO. DEF VAR MailKomm AS INT NO-UNDO. DEF VAR cValue AS CHAR NO-UNDO. DEF VAR cSendTo AS CHAR NO-UNDO. DEF VAR cCC AS CHAR NO-UNDO. DEF VAR cKopie AS CHAR 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 gSerienMail /* Standard List Definitions */ &Scoped-Define ENABLED-OBJECTS F_To F_BCC F_Attach Btn_SDatei F_Betreff ~ E_Mail T_Einzeln Btn_OK Btn_Cancel RECT-5 &Scoped-Define DISPLAYED-OBJECTS F_To F_BCC F_Attach F_Betreff E_Mail ~ T_Einzeln /* Custom List Definitions */ /* List-1,List-2,List-3,List-4,List-5,List-6 */ &Scoped-define List-6 F_To F_BCC F_Attach F_Betreff E_Mail T_Einzeln /* _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. DEFINE BUTTON Btn_OK AUTO-GO LABEL "&Start" SIZE 15 BY 1. DEFINE BUTTON Btn_SDatei IMAGE-UP FILE "grafik/select.bmp":U LABEL "DateiSuchen" SIZE 4.4 BY 1.05 TOOLTIP "Starten neue Selektion (ALT-S)". DEFINE VARIABLE E_Mail AS CHARACTER VIEW-AS EDITOR SCROLLBAR-VERTICAL SIZE 80 BY 4.91 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Attach AS CHARACTER FORMAT "X(256)":U LABEL "Anhangs-Dokument" VIEW-AS FILL-IN NATIVE SIZE 75.6 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_BCC AS CHARACTER FORMAT "x(5000)":U LABEL "Blindkopien" VIEW-AS FILL-IN NATIVE SIZE 80 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_Betreff AS CHARACTER FORMAT "X(256)":U LABEL "Betreff" VIEW-AS FILL-IN NATIVE SIZE 80 BY 1 BGCOLOR 15 NO-UNDO. DEFINE VARIABLE F_To AS CHARACTER FORMAT "x(5000)":U LABEL "Mail To" VIEW-AS FILL-IN NATIVE SIZE 80 BY 1 BGCOLOR 15 NO-UNDO. DEFINE RECTANGLE RECT-5 EDGE-PIXELS 2 GRAPHIC-EDGE NO-FILL SIZE 112 BY 13.33. DEFINE VARIABLE T_Einzeln AS LOGICAL INITIAL no LABEL "einzelne Mails" VIEW-AS TOGGLE-BOX SIZE 19 BY 1 NO-UNDO. /* ************************ Frame Definitions *********************** */ DEFINE FRAME gSerienMail F_To AT ROW 2 COL 28 COLON-ALIGNED NO-TAB-STOP F_BCC AT ROW 3 COL 28 COLON-ALIGNED NO-TAB-STOP F_Attach AT ROW 4 COL 28 COLON-ALIGNED Btn_SDatei AT ROW 4 COL 105.6 NO-TAB-STOP F_Betreff AT ROW 5 COL 28 COLON-ALIGNED E_Mail AT ROW 6.52 COL 30 NO-LABEL T_Einzeln AT ROW 11.62 COL 30 Btn_OK AT ROW 13 COL 44.6 Btn_Cancel AT ROW 13 COL 68.8 RECT-5 AT ROW 1.24 COL 2 SPACE(0.99) SKIP(0.23) WITH VIEW-AS DIALOG-BOX KEEP-TAB-ORDER SIDE-LABELS NO-UNDERLINE THREE-D SCROLLABLE TITLE "Serien-Mail" 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 gSerienMail /* ************************* 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 gSerienMail */ ASSIGN FRAME gSerienMail:SCROLLABLE = FALSE FRAME gSerienMail:HIDDEN = TRUE. /* SETTINGS FOR EDITOR E_Mail IN FRAME gSerienMail 6 */ ASSIGN E_Mail:RETURN-INSERTED IN FRAME gSerienMail = TRUE. /* SETTINGS FOR FILL-IN F_Attach IN FRAME gSerienMail 6 */ /* SETTINGS FOR FILL-IN F_BCC IN FRAME gSerienMail 6 */ ASSIGN F_BCC:READ-ONLY IN FRAME gSerienMail = TRUE. /* SETTINGS FOR FILL-IN F_Betreff IN FRAME gSerienMail 6 */ /* SETTINGS FOR FILL-IN F_To IN FRAME gSerienMail 6 */ ASSIGN F_To:READ-ONLY IN FRAME gSerienMail = TRUE. /* SETTINGS FOR TOGGLE-BOX T_Einzeln IN FRAME gSerienMail 6 */ /* _RUN-TIME-ATTRIBUTES-END */ &ANALYZE-RESUME /* Setting information for Queries and Browse Widgets fields */ &ANALYZE-SUSPEND _QUERY-BLOCK DIALOG-BOX gSerienMail /* Query rebuild information for DIALOG-BOX gSerienMail _Options = "SHARE-LOCK" _Query is NOT OPENED */ /* DIALOG-BOX gSerienMail */ &ANALYZE-RESUME /* ************************ Control Triggers ************************ */ &Scoped-define SELF-NAME gSerienMail &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSerienMail gSerienMail ON END-ERROR OF FRAME gSerienMail /* Serien-Mail */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSerienMail gSerienMail ON GO OF FRAME gSerienMail /* Serien-Mail */ DO: /* RUN ENDE_PROGRAMM ( INPUT Progname ) NO-ERROR. */ END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL gSerienMail gSerienMail ON WINDOW-CLOSE OF FRAME gSerienMail /* Serien-Mail */ 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 gSerienMail ON CHOOSE OF Btn_Cancel IN FRAME gSerienMail /* Abbrechen */ DO: RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME Btn_OK &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_OK gSerienMail ON CHOOSE OF Btn_OK IN FRAME gSerienMail /* Start */ DO: DEF VAR cKommun AS CHAR NO-UNDO. DEF VAR cDoku AS CHAR NO-UNDO. DEF VAR cBetreff AS CHAR NO-UNDO. DEF VAR cMail AS CHAR NO-UNDO. DO WITH FRAME {&FRAME-NAME}: ASSIGN {&List-6}. cDoku = F_Attach. cBetreff = F_Betreff. cMail = REPLACE(E_Mail, CHR(10), '£'). DO WHILE TRUE: IF cDoku = '' THEN LEAVE. FILE-INFO:FILE-NAME = cDoku NO-ERROR. IF FILE-INFO:FILE-TYPE BEGINS 'F' THEN LEAVE. MESSAGE 'Die Datei für den Anhang ist ungültig' VIEW-AS ALERT-BOX. RETURN NO-APPLY. END. PUT-KEY-VALUE SECTION 'MailSend' KEY 'Doku' VALUE cDoku . PUT-KEY-VALUE SECTION 'MailSend' KEY 'Betreff' VALUE cBetreff. PUT-KEY-VALUE SECTION 'MailSend' KEY 'Mail' VALUE cMail . PUT-KEY-VALUE SECTION 'MailSend' KEY 'Einzeln' VALUE STRING(T_Einzeln). END. RUN MAIL_VERSENDEN. RUN ENDE. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME Btn_SDatei &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL Btn_SDatei gSerienMail ON CHOOSE OF Btn_SDatei IN FRAME gSerienMail /* DateiSuchen */ DO: DEF VAR ja AS LOG NO-UNDO. SYSTEM-DIALOG GET-FILE F_Attach MUST-EXIST USE-FILENAME UPDATE ja. IF NOT ja THEN RETURN NO-APPLY. DO WITH FRAME {&FRAME-NAME}: DISPLAY F_Attach. END. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &Scoped-define SELF-NAME T_Einzeln &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CONTROL T_Einzeln gSerienMail ON RETURN OF T_Einzeln IN FRAME gSerienMail /* einzelne Mails */ DO: APPLY 'TAB' TO SELF. RETURN NO-APPLY. END. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &UNDEFINE SELF-NAME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _CUSTOM _MAIN-BLOCK gSerienMail /* *************************** Main Block *************************** */ MaxPage = 1. AktSeite = 1. 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. Progname = DYNAMIC-FUNCTION('MAKEPROGNAME':U, INPUT THIS-PROCEDURE ) NO-ERROR. END. SESSION:DATA-ENTRY-RETURN = TRUE. /* 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 gSerienMail _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: ------------------------------------------------------------------------------*/ END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE disable_UI gSerienMail _DEFAULT-DISABLE PROCEDURE disable_UI : /*------------------------------------------------------------------------------ Purpose: DISABLE the User Interface Parameters: 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 gSerienMail. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE enableObject gSerienMail PROCEDURE enableObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR wx AS INT NO-UNDO. DEF VAR wy AS INT NO-UNDO. DEF VAR MaxX AS INT NO-UNDO. DEF VAR MaxY AS INT NO-UNDO. DEF VAR xString AS CHAR NO-UNDO. MaxX = SESSION:WIDTH-PIXELS. MaxY = SESSION:HEIGHT-PIXELS. GET-KEY-VALUE SECTION 'FensterPositionen' KEY ProgName VALUE xString. IF xString = ? THEN xString = '30;30'. IF xString = '' THEN xString = '30;30'. wx = INTEGER(ENTRY(1, xString, ';')). wy = INTEGER(ENTRY(2, xString, ';')). IF wx < 0 THEN wx = 30. IF wy < 0 THEN wy = 30. IF wx > (MaxX - 20) THEN wx = 30. IF wy > (MaxY - 20) THEN wy = 30. FRAME {&FRAME-NAME}:X = wx. FRAME {&FRAME-NAME}:Y = wy. RUN SUPER. IF sAktiv THEN 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 gSerienMail _DEFAULT-ENABLE PROCEDURE enable_UI : /*------------------------------------------------------------------------------ Purpose: ENABLE the User Interface Parameters: 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_To F_BCC F_Attach F_Betreff E_Mail T_Einzeln WITH FRAME gSerienMail. ENABLE F_To F_BCC F_Attach Btn_SDatei F_Betreff E_Mail T_Einzeln Btn_OK Btn_Cancel RECT-5 WITH FRAME gSerienMail. VIEW FRAME gSerienMail. {&OPEN-BROWSERS-IN-QUERY-gSerienMail} END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE ENDE gSerienMail PROCEDURE ENDE : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR wx AS INT NO-UNDO. DEF VAR wy AS INT NO-UNDO. DEF VAR xString AS CHAR NO-UNDO. AktSeite = DYNAMIC-FUNCTION('getCurrentPage':U) NO-ERROR. IF AktSeite > 1 THEN DO: RUN selectPage ( INPUT 1 ). RETURN NO-APPLY. END. IF sAktiv THEN RUN ENDE_PROGRAMM ( INPUT Progname ). wx = FRAME {&FRAME-NAME}:X NO-ERROR. wy = FRAME {&FRAME-NAME}:Y NO-ERROR. xString = STRING(wx) + ';' + STRING(wy). PUT-KEY-VALUE SECTION 'FensterPositionen' KEY ProgName VALUE xString. APPLY "CLOSE":U TO THIS-PROCEDURE. APPLY 'GO' TO FRAME {&FRAME-NAME}. RETURN NO-APPLY. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE exitObject gSerienMail 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 FIND_MAIL_ADRESSEN gSerienMail PROCEDURE FIND_MAIL_ADRESSEN : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR hQuery AS WIDGET-HANDLE NO-UNDO. DEF VAR i1 AS INT NO-UNDO. DEF VAR cFirma AS CHAR NO-UNDO. DEF VAR iKnr AS INT NO-UNDO. DEF VAR fFound AS LOG NO-UNDO. DEF VAR hFeld AS HANDLE NO-UNDO. DEF VAR cMail AS CHAR NO-UNDO. cSendTo = ''. cCC = ''. CREATE QUERY hQuery. hQuery:SET-BUFFERS( ipBuffer ). hQuery:QUERY-PREPARE('FOR EACH TAdresse NO-LOCK'). hQuery:QUERY-OPEN(). hQuery:GET-FIRST(). REPEAT WITH FRAME {&FRAME-NAME}: IF hQuery:QUERY-OFF-END THEN LEAVE. hFeld = ipBuffer:BUFFER-FIELD('cMail'). cMail = hFeld:BUFFER-VALUE(0). DO WHILE cMail <> '': IF INDEX(cMail, '@') = 0 THEN LEAVE. IF cSendTo = '' THEN cSendTo = cMail. ELSE DO: IF cCC <> '' THEN cCC = cCC + '; '. cCC = cCC + cMail. END. LEAVE. END. hQuery:GET-NEXT(). END. DO WITH FRAME {&FRAME-NAME}: F_To = cSendTo. F_Bcc = cCC. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE initializeObject gSerienMail PROCEDURE initializeObject : /*------------------------------------------------------------------------------ Purpose: Super Override Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR cKommun AS CHAR NO-UNDO. DEF VAR cDoku AS CHAR NO-UNDO. DEF VAR cBetreff AS CHAR NO-UNDO. DEF VAR cMail AS CHAR NO-UNDO. DEF VAR cEinzeln AS CHAR NO-UNDO. DO WITH FRAME {&FRAME-NAME}: GET-KEY-VALUE SECTION 'MailSend' KEY 'Doku' VALUE cDoku . IF cDoku = ? THEN cDoku = ''. GET-KEY-VALUE SECTION 'MailSend' KEY 'Betreff' VALUE cBetreff. IF cBetreff = ? THEN cBetreff = ''. GET-KEY-VALUE SECTION 'MailSend' KEY 'Mail' VALUE cMail . IF cMail = ? THEN cMail = ''. cMail = REPLACE(cMail, '£', CHR(10)). GET-KEY-VALUE SECTION 'MailSend' KEY 'Einzeln' VALUE cEinzeln. IF cEinzeln = ? THEN cEinzeln = 'no'. F_Attach = cDoku . F_Betreff = cBetreff. E_Mail = cMail . T_Einzeln = (IF cEinzeln BEGINS 'n' THEN FALSE ELSE TRUE). END. RUN FIND_MAIL_ADRESSEN. RUN SUPER. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME &ANALYZE-SUSPEND _UIB-CODE-BLOCK _PROCEDURE MAIL_VERSENDEN gSerienMail PROCEDURE MAIL_VERSENDEN : /*------------------------------------------------------------------------------ Purpose: Parameters: Notes: ------------------------------------------------------------------------------*/ DEF VAR i1 AS INT NO-UNDO. DO WITH FRAME {&FRAME-NAME}: ASSIGN {&List-6}. IF T_Einzeln THEN DO: cKopie = cCC. cCC = ''. END. RUN SEND_MAIL_BY_MAILADRESSE ( INPUT cSendTo , INPUT cCC , INPUT F_Betreff, INPUT E_Mail , INPUT F_Attach ). DO i1 = 1 TO NUM-ENTRIES(cKopie, ';'): cSendTo = TRIM(ENTRY(i1, cKopie, ';')). RUN SEND_MAIL_BY_MAILADRESSE ( INPUT cSendTo , INPUT cCC , INPUT F_Betreff, INPUT E_Mail , INPUT F_Attach ). END. RETURN NO-APPLY. END. END PROCEDURE. /* _UIB-CODE-BLOCK-END */ &ANALYZE-RESUME