1 22 23 package org.cofax.module; 24 25 import org.cofax.*; 26 import org.cofax.cms.*; 27 import javax.servlet.http.*; 28 import java.util.*; 29 30 36 37 public class CofaxToolsExtNewsletter extends CofaxToolsExtModule { 38 39 43 public String navigate(DataStore db, CofaxPage page, HttpServletRequest req, HttpServletResponse res, HttpSession session) { 44 String mode = (String ) req.getParameter("mode"); 45 HashMap ht = new HashMap(); 46 CofaxToolsUser user = (CofaxToolsUser) (session.getAttribute("user")); 47 String workingPubName = (String ) user.workingPubName; 48 page.putGlossaryValue("system:message", getI18NMessage("message_welcome")); 49 50 if (mode.equals("newsletter_set_newsletter")) { 52 String newsletterID = (String ) req.getParameter("NEWSLETTERID"); 53 String newsletterName = (String ) req.getParameter("NEWSLETTERNAME"); 54 if ((newsletterID != null) && !(newsletterID.equals(""))) { 55 String tag = "update tblNewsletters set newsletterName='" + formatString(newsletterName) + "' where newsletterID=" + newsletterID; 56 List list = CofaxToolsDbUtils.getPackageData(db, ht, tag); 57 page.putGlossaryValue("system:message", getI18NMessage("message_newslettermodified")); 58 page.putGlossaryValue("request:newsletterID", newsletterID); 59 } else { 60 String tag = "insert into tblNewsletters(newsletterName, pubName) values('" + formatString(newsletterName) + "','" + workingPubName + "')"; 62 List list = CofaxToolsDbUtils.getPackageData(db, ht, tag); 63 page.putGlossaryValue("system:message", getI18NMessage("message_newsletteradded")); 64 } 65 } 66 67 if (mode.equals("newsletter_delete_suscriber")) { 69 String suscriberID = (String ) req.getParameter("SUSCRIBERID"); 70 String newsletterID = (String ) req.getParameter("NEWSLETTERID"); 71 if ((suscriberID != null) && !(suscriberID.equals(""))) { 72 String tag = "delete from tblNewsletterSuscribers where suscriberID=" + suscriberID; 73 List list = CofaxToolsDbUtils.getPackageData(db, ht, tag); 74 page.putGlossaryValue("system:message", getI18NMessage("message_suscriberdeleted")); 75 page.putGlossaryValue("request:newsletterID", newsletterID); 76 } else { 77 page.putGlossaryValue("system:message", getI18NMessage("message_errorSuscriberID")); 78 } 79 } 80 81 if (mode.equals("newsletter_set_suscriber")) { 83 String suscriberID = (String ) req.getParameter("SUSCRIBERID"); 84 String newsletterID = (String ) req.getParameter("NEWSLETTERID"); 85 String mail = (String ) req.getParameter("mail"); 86 String name = (String ) req.getParameter("name"); 87 if ((suscriberID != null) && !(suscriberID.equals(""))) { 88 String tag = "update tblNewsletterSuscribers set mail='" + formatString(mail) + "', name='" + formatString(name) + "' where suscriberID=" 89 + suscriberID; 90 List list = CofaxToolsDbUtils.getPackageData(db, ht, tag); 91 page.putGlossaryValue("system:message", getI18NMessage("message_suscribermodified")); 92 page.putGlossaryValue("request:newsletterID", newsletterID); 93 } else { 94 page.putGlossaryValue("system:message", getI18NMessage("message_errorSuscriberID")); 95 } 96 } 97 98 page.putGlossaryValue("system:highLightTab", "admin"); 99 page.putGlossaryValue("request:pubName", workingPubName); 100 CofaxToolsNavigation.includeResource(page, "" + CofaxToolsServlet.templatePath + "module/editNewsletter.jsp", req, res, session); 104 return ""; 105 } 106 107 public String formatString(String input) { 108 String retVal = CofaxToolsUtil.replace(input, "'", "''"); 109 retVal = CofaxToolsUtil.replace(retVal, "\\", "\\\\"); 110 return retVal; 111 } 112 113 public String getI18NMessage(String message) { 114 ResourceBundle messages; 115 String returnMessage = ""; 116 Locale lcl = CofaxToolsServlet.lcl; 117 try { 118 messages = ResourceBundle.getBundle("org.cofax.module.newsletter", lcl); 119 returnMessage = messages.getString(message); 120 } catch (Exception e) { 121 CofaxToolsUtil.log("CofaxToolsExtNewsletter : getI18NMessage : error while reading " + message); 122 } 123 return (returnMessage); 124 } 125 126 } 127 | Popular Tags |