1 6 7 package com.quikj.application.communicator.applications.webtalk.controller; 8 9 import java.sql.*; 10 import java.io.*; 11 import java.util.*; 12 import javax.servlet.*; 13 import javax.servlet.http.*; 14 import org.apache.struts.action.*; 15 import com.quikj.server.framework.*; 16 import com.quikj.application.communicator.admin.controller.*; 17 import com.quikj.application.communicator.applications.webtalk.model.*; 18 22 public final class RegUserReportAction extends Action 23 { 24 25 26 public RegUserReportAction() 27 { 28 } 29 30 public ActionForward execute(ActionMapping mapping, 31 ActionForm form, HttpServletRequest request, 32 HttpServletResponse response) throws IOException, ServletException 33 { 34 Locale locale = getLocale(request); 35 ActionErrors errors = new ActionErrors(); 36 37 Connection c = (Connection)request.getSession().getAttribute("connection"); 39 if (c == null) 40 { 41 errors.add(ActionErrors.GLOBAL_ERROR, 42 new ActionError("error.not.logged.in")); 43 saveErrors(request, errors); 44 return mapping.findForward("logon"); 45 } 46 47 UserReportForm uform = (UserReportForm) form; 48 RegUserBean regUserBean = new RegUserBean(c); 49 regUserBean.setStartDate(TrafficDataBean.convertDate(uform.getStartDate())); 50 regUserBean.setEndDate(TrafficDataBean.convertDate(uform.getEndDate())); 51 regUserBean.setOrderBy(uform.getOrderBy()); 52 53 if (regUserBean.execute() == false) 54 { 55 AceLogger.Instance().log(AceLogger.ERROR, AceLogger.SYSTEM_LOG, 56 "RegUserReportAction.execute() : " + regUserBean.getErrorMessage()); 57 58 errors.add(ActionErrors.GLOBAL_ERROR, new ActionError("error.db.failure")); 59 saveErrors(request, errors); 60 61 return mapping.getInputForward(); 62 } 63 64 ArrayList results = regUserBean.getResults(); 65 if ((results != null) && (results.size() > 0)) 66 { 67 request.setAttribute("reg_user_list", results); 68 } 69 70 WebTalkRelatedTasks menu = new WebTalkRelatedTasks(); 71 menu.addLink(new LinkAttribute("Visitor Report", "visitor_report_input")); 72 menu.addLink(new LinkAttribute("Usage Report", "traffic_report_input")); 73 74 request.setAttribute("menu", menu); 75 request.setAttribute("reportDate", new java.util.Date ().toString()); 76 77 return (mapping.findForward("show_report")); 78 } 79 } 80 | Popular Tags |