/* CRMS, customer relationship management system    Copyright (C) 2003  Service To Youth Council    This program is free software; you can redistribute it and/or modify    it under the terms of the GNU General Public License as published by    the Free Software Foundation; either version 2 of the License, or    (at your option) any later version.    This program is distributed in the hope that it will be useful,    but WITHOUT ANY WARRANTY; without even the implied warranty of    MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the    GNU General Public License for more details.    You should have received a copy of the GNU General Public License    along with this program; if not, write to the Free Software    Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA    For further information contact the SYC ICT department on GPL@syc.net.au    98 Kermode Street    North Adelaide    South Australia    SA 5006     +61 (0)8 8367 0755    *//* * CallReport.java * * Created on 12 June 2003, 10:00 */package crms.report;import java.util.*;import java.sql.*;import java.text.*;import crms.dao.*;import crms.util.*;import org.apache.log4j.Logger;/** * * @author  Administrator */public class CallReport implements ReportProcessor {    public static Logger logger = Logger.getLogger(CallReport.class);        public static SimpleDateFormat df = new SimpleDateFormat("dd/MM/yyyy");        public static String PARAM_FROM = "from";    public static String PARAM_TO = "to";        CallDAO callDAO = DAOFactory.getInstance().getCallDAO();    LDAPDAO ldapDAO = LDAPDAOFactory.getInstance().getLDAPDAO();        /** Creates a new instance of CallReport */        public CallReport() {    }        public Report processReport(HashMap params) {        logger.debug("Processing CallReport...");        String fromStr = (String) params.get(PARAM_FROM);        long fromLong = Long.parseLong(fromStr);        java.util.Date fromDate = new java.util.Date(fromLong);        String toStr = (String) params.get(PARAM_TO);        long toLong = Long.parseLong(toStr);        java.util.Date toDate = new java.util.Date(toLong);                Report report = new Report();        report.setSubHeading("For period: " + df.format(fromDate) + " to " + df.format(toDate));                String sql = "select \"Date\", \"Owner\", \"Number\", \"OwnerHasRead\", \"Note\"\n";        sql += "from \"Call\"\n";        sql += "where \"Date\" > '" + df.format(fromDate) + "'\n";        sql += "  and \"Date\" <= '" + df.format(toDate) + "'\n";        sql += "Order By \"Call\".\"Owner\", \"Call\".\"Date\"";                logger.debug("Creating XML Resultset...");        StringBuffer buf = AbstractDAO.createXMLResultset(Report.TAG_ROOT, Report.TAG_ENTRY, sql);        logger.debug("Resultset created...");        logger.debug("Setting content on report object...");                report.setContent(buf);        logger.debug("Returning report");        return report;    }    }