/*
* $RCSfile: TicketBarChartHandler.java,v $ $Revision: 1.1.1.1 $ $Date: 2005/04/28 20:28:53 $ - $Author: mking_cv $
*
* The contents of this file are subject to the Open Software License
* Version 2.1 (the "License"); you may not use this file except in
* compliance with the License. You may obtain a copy of the License at
* http://www.centraview.com/opensource/license.html
*
* Software distributed under the License is distributed on an "AS IS"
* basis, WITHOUT WARRANTY OF ANY KIND, either express or implied. See the
* License for the specific language governing rights and limitations
* under the License.
*
* The Original Code is: CentraView Open Source.
*
* The developer of the Original Code is CentraView. Portions of the
* Original Code created by CentraView are Copyright (c) 2004 CentraView,
* LLC; All Rights Reserved. The terms "CentraView" and the CentraView
* logos are trademarks and service marks of CentraView, LLC.
*/
package com.centraview.support.ticket;
import java.io.IOException;
import java.io.OutputStream;
import java.util.Collection;
import java.util.HashMap;
import java.util.Iterator;
import javax.ejb.CreateException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
import org.apache.log4j.Logger;
import org.apache.struts.action.ActionForm;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import org.jfree.chart.ChartFactory;
import org.jfree.chart.ChartUtilities;
import org.jfree.chart.JFreeChart;
import org.jfree.chart.axis.CategoryAxis;
import org.jfree.chart.axis.CategoryLabelPositions;
import org.jfree.chart.axis.NumberAxis;
import org.jfree.chart.plot.CategoryPlot;
import org.jfree.chart.renderer.category.BarRenderer;
import org.jfree.data.category.DefaultCategoryDataset;
import com.centraview.chart.Chart;
import com.centraview.chart.ChartHome;
import com.centraview.common.CVUtility;
import com.centraview.common.UserObject;
import com.centraview.settings.Settings;
import com.centraview.valuelist.ValueListParameters;
/**
* Action/servlet for serving up the Tickets by Age
* chart image. Relies on a ValueListParameter being set
* on the session, which is used to help get the data from
* the ChartEJB.
*/
public class TicketBarChartHandler extends org.apache.struts.action.Action
{
private static Logger logger = Logger.getLogger(TicketBarChartHandler.class);
public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request, HttpServletResponse response) throws RuntimeException, Exception
{
final String dataSource = Settings.getInstance().getSiteInfo(CVUtility.getHostName(super.getServlet().getServletContext())).getDataSource();
HttpSession session = request.getSession();
UserObject userObject = (UserObject)session.getAttribute("userobject");
int individualId = userObject.getIndividualID(); // logged in user
// get the data from the session
ValueListParameters listParameters = (ValueListParameters)session.getAttribute("ticketBarChartParams");
// get the data from the EJB
ChartHome chartHome = (ChartHome)CVUtility.getHomeObject("com.centraview.chart.ChartHome", "Chart");
Chart chartRemote = null;
try
{
chartRemote = chartHome.create();
}catch(CreateException e){
logger.error("[execute] Exception thrown.", e);
throw new ServletException(e);
}
chartRemote.setDataSource(dataSource);
Collection chartRawData = (Collection)chartRemote.getTicketBarData(individualId, listParameters);
// Add the raw data to a JFree dataset
DefaultCategoryDataset chartData = new DefaultCategoryDataset();
Iterator iter = chartRawData.iterator();
while (iter.hasNext())
{
HashMap row = (HashMap)iter.next();
Number openTickets = (Number)row.get("count");
String userName = (String)row.get("name");
if(userName == null){
userName = "UnAssigned";
}
Number ageValue = (Number)row.get("age");
chartData.setValue(openTickets, userName, this.getAgeName(ageValue));
}
// create the chart
JFreeChart barChart = ChartFactory.createStackedBarChart("Open Tickets by Age", "Age", "# Open Tickets",
chartData, org.jfree.chart.plot.PlotOrientation.VERTICAL,
true, true, false);
// set the visual options
CategoryPlot plot = barChart.getCategoryPlot();
// set the X axis labels to be slanted
CategoryAxis domainAxis = plot.getDomainAxis();
domainAxis.setCategoryLabelPositions(CategoryLabelPositions.createUpRotationLabelPositions(Math.PI / 3.0));
// set the range axis to display integers only...
final NumberAxis rangeAxis = (NumberAxis)plot.getRangeAxis();
rangeAxis.setStandardTickUnits(NumberAxis.createIntegerTickUnits());
// set the max width of each bar
BarRenderer renderer = (BarRenderer) plot.getRenderer();
renderer.setMaxBarWidth(0.10);
// print the chart image directly the the HTTP stream
OutputStream out = response.getOutputStream();
response.setContentType("image/jpeg");
try
{
ChartUtilities.writeChartAsJPEG(out, 1.0f, barChart, 400, 300);
}catch(IOException e){
logger.error("[getOpportunityPieData] Exception thrown.", e);
throw new ServletException(e);
}finally{
out.close();
}
// return null (don't forward anywhere, we've done the output already)
return(null);
} // end execute() method
private String getAgeName(Number ageValue)
{
String ageName = "";
switch (ageValue.intValue())
{
case 0:
ageName = "- 1 Hour";
break;
case 1:
ageName = "- 2 Hours";
break;
case 2:
ageName = "- 4 Hours";
break;
case 3:
ageName = "- 8 Hours";
break;
case 4:
ageName = "- 1 Day";
break;
case 5:
ageName = "- 2 Days";
break;
case 6:
ageName = "- 3 Days";
break;
case 7:
ageName = "- 4 Days";
break;
case 8:
ageName = "- 5 Days";
break;
case 9:
ageName = "+ 5 Days";
break;
default:
ageName = "1 Hour";
}
return ageName;
}
} // end class definition