Package sk.iway.iwcm.dmail

Class EmailDB

java.lang.Object
sk.iway.iwcm.dmail.EmailDB
public class EmailDB extends Object
EmailDB.java

  • Constructor Details

    • EmailDB

      protected EmailDB()

  • Method Details

    • getStaus

      public static String getStaus(int campaignId)
      Ziska stav kampane, vrati hodnoty: - unknown (neznama kampan) - disabled (kampan je zastavena) - enabled (kampan je spustena) - all_sent (vsetky emaily odoslane)
      Parameters:
      campaignId -
      Returns:

    • resendEmail

      public static void resendEmail(int campaignId)
      Znova odosle emaily kampane (moze sa zmenit obsah stranky a znova odoslat)
      Parameters:
      campaignId -

    • activateDisableEmails

      public static void activateDisableEmails(boolean disabled, int campainId)
      Aktivovanie / deaktivovanie kampane
      Parameters:
      disabled -
      campainId -

    • fillUnsubscribedEmailBean

      public static void fillUnsubscribedEmailBean(EmailUnsubscribedBean e, ResultSet rs) throws SQLException
      Throws:
      SQLException

    • getUnsubscribedEmail

      public static List<EmailUnsubscribedBean> getUnsubscribedEmail(String searchString)

    • deleteUnsubscribedEmail

      public static boolean deleteUnsubscribedEmail(int id)

    • deleteUnsubscribedEmail

      public static boolean deleteUnsubscribedEmail(String email)

    • addUnsubscribedEmail

      public static boolean addUnsubscribedEmail(String email)

    • getHashtableFromUnsubscribedEmails

      public static Map<String,Integer> getHashtableFromUnsubscribedEmails()

    • getEmail

      public static String getEmail(int emailId)
      Vrati email pre zadane email_id z tabulky emails, pouziva sa na kontrolu emailu pre odhlasenie
      Parameters:
      emailId -
      Returns:

    • deleteUnsubscribedEmailsFromCampaign

      public static int deleteUnsubscribedEmailsFromCampaign(int campaignId)
      Vymaze odhlasene emaily z danej kampane, je potrebne vykonat pred znovaspustenim kampane
      Parameters:
      campaignId -
      Returns:
      pocet zmazanych emailov

    • saveEmails

      public static boolean saveEmails(int userGroupId, String url, String senderName, String senderEmail, String subject, String attachments, int userId, Timestamp createDate, Prop prop, PrintWriter out)
      Naplnenie tabulky emailov
      Parameters:
      userGroupId - - id skupiny pousivatelov, ktorym sa mail posiela
      url - - URL adresa webu (http://www.interway.sk/showdoc.do?docid=10) - aby zbehol loopback connect
      senderName - - meno odosielatela
      senderEmail - - email odosielatela
      subject - - predmet
      attachments - - zoznam priloh oddelenych ; (linka na subor na disku)
      userId - - id pouzivatela, ktory kampan vytvara
      createDate - - datum vytvorenia (podla toho je potom potrebne zavolat runEmails)
      prop - - I18N prop (alebo null ak sa nic nevypisuje)
      Returns:

    • saveEmails

      public static boolean saveEmails(List<UserDetails> users, String url, String senderName, String senderEmail, String replyTo, String ccEmail, String bccEmail, String subject, String attachments, int userId, Timestamp createDate, String userGroupsString)

    • activateEmails

      public static void activateEmails(long date)
      Aktivovanie odosielania emailov so zadanym datumom
      Parameters:
      date -

    • main

      public static void main(String[] args)
      You can use this main method in cron to periodically send emails. It expect one argument in pageParams format. Params are: - groupId - userGroupId - url - url to be sent in email - senderName - name of sender - senderEmail - email of sender - subject - subject of email - instanceId - unique ID of instance to verify last sending, it's verified against Audit DMAIL_AUTOSENDER
      Parameters:
      args -