callreport.java

CRMS客户关系管理系统(JAVA版）,这是一个客户关系管理系统。

    /* 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 [e-mail]
    98 Kermode Street
    North Adelaide
    South Australia
    SA 5006 
    [phone]
    */
/*
 * 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;
    }
    
}