public String generatePieChart(
String hitOrdNum, HttpSession session, PrintWriter pw, String courseId, int studentId) {
/* int groupId=0;
if (groupName.equals("All")){
groupId=0;
}else{
groupId = studStatisticBean.getGroupIdByName(groupName);
}*/
String filename = null;
try {
// Retrieve list of WebHits
StudentsConceptChartDataSet whDataSet =
new StudentsConceptChartDataSet(studStatisticBean, courseId, studentId);
ArrayList list = whDataSet.getDataBySection(hitOrdNum);
// Throw a custom NoDataException if there is no data
if (list.size() == 0) {
System.out.println("No data has been found");
throw new NoDataException();
}
// Create and populate a PieDataSet
DefaultPieDataset data = new DefaultPieDataset();
Iterator iter = list.listIterator();
while (iter.hasNext()) {
StudentsConceptHit wh = (StudentsConceptHit) iter.next();
data.setValue(wh.getSection(), wh.getHitDegree());
}
// Create the chart object
PiePlot plot = new PiePlot(data);
plot.setInsets(new Insets(0, 5, 5, 5));
plot.setURLGenerator(new StandardPieURLGenerator("xy_chart.jsp", "section"));
plot.setToolTipGenerator(new StandardPieItemLabelGenerator());
JFreeChart chart = new JFreeChart("", JFreeChart.DEFAULT_TITLE_FONT, plot, true);
chart.setBackgroundPaint(java.awt.Color.white);
// Write the chart image to the temporary directory
ChartRenderingInfo info = new ChartRenderingInfo(new StandardEntityCollection());
filename = ServletUtilities.saveChartAsPNG(chart, 600, 400, info, session);
// Write the image map to the PrintWriter
ChartUtilities.writeImageMap(pw, filename, info);
pw.flush();
} catch (NoDataException e) {
System.out.println(e.toString());
filename = "public_nodata_500x300.png";
} catch (Exception e) {
System.out.println("Exception - " + e.toString());
e.printStackTrace(System.out);
filename = "public_error_500x300.png";
}
return filename;
}
public String generateBarChart(
String hitSection, HttpSession session, PrintWriter pw, String courseId, int studentId) {
/* int groupId=0;
if (groupName.equals("All")){
groupId=0;
}else{
groupId = studStatisticBean.getGroupIdByName(groupName);
}*/
String filename = null;
try {
// Retrieve list of WebHits
StudentsConceptChartDataSet cDataSet =
new StudentsConceptChartDataSet(studStatisticBean, courseId, studentId);
ArrayList list = cDataSet.getDataBySection(hitSection);
// Throw a custom NoDataException if there is no data
if (list.size() == 0) {
System.out.println("No data has been found");
throw new NoDataException();
}
// Create and populate a CategoryDataset
Iterator iter = list.listIterator();
DefaultCategoryDataset dataSet = new DefaultCategoryDataset();
while (iter.hasNext()) {
StudentsConceptHit wh = (StudentsConceptHit) iter.next();
// Comparable c1= Double.parseDouble(wh.getHitDegree());
dataSet.addValue(
wh.getHitDegree(),
"degree of mastery for concept ",
String.valueOf(wh.getHitConcept()));
}
// Create the chart object
CategoryAxis categoryAxis = new CategoryAxis("Concepts");
ValueAxis valueAxis = new NumberAxis("Degree of Mastery");
valueAxis.setRange(0.0, 6.0);
categoryAxis.setCategoryLabelPositions(
new CategoryLabelPositions().createUpRotationLabelPositions(45));
BarRenderer renderer = new BarRenderer();
renderer.setDrawBarOutline(true);
renderer.setItemURLGenerator(
new StandardCategoryURLGenerator("xy_chart.jsp", "series", "section"));
StandardCategoryToolTipGenerator scttg = new StandardCategoryToolTipGenerator();
renderer.setToolTipGenerator(scttg);
Plot plot = new CategoryPlot(dataSet, categoryAxis, valueAxis, renderer);
JFreeChart chart = new JFreeChart("", JFreeChart.DEFAULT_TITLE_FONT, plot, true);
chart.setBackgroundPaint(java.awt.Color.white);
// Write the chart image to the temporary directory
ChartRenderingInfo info = new ChartRenderingInfo(new StandardEntityCollection());
filename = ServletUtilities.saveChartAsPNG(chart, 600, 400, info, session);
// Write the image map to the PrintWriter
ChartUtilities.writeImageMap(pw, filename, info);
pw.flush();
} catch (NoDataException e) {
System.out.println(e.toString());
filename = "public_nodata_500x300.png";
} catch (Exception e) {
System.out.println("Exception - " + e.toString());
e.printStackTrace(System.out);
filename = "public_error_500x300.png";
}
return filename;
}
public String generateXYAreaChart(
HttpSession session, PrintWriter pw, String courseId, int studentId) {
String filename = null;
/* int groupId=0;
if (groupName.equals("All")){
groupId=0;
}else{
groupId = studStatisticBean.getGroupIdByName(groupName);
}*/
try {
// Retrieve list of WebHits for each section and populate a TableXYDataset
StudentsConceptChartDataSet cDataSet =
new StudentsConceptChartDataSet(studStatisticBean, courseId, studentId);
// cDataSet.setStudentStatisticBeanIdRef(studStatisticBean);
ArrayList sections = cDataSet.getSections();
Iterator sectionIter = sections.iterator();
DefaultTableXYDataset dataset = new DefaultTableXYDataset();
while (sectionIter.hasNext()) {
String section = (String) sectionIter.next();
ArrayList list = cDataSet.getDataByHitConcept(section);
XYSeries dataSeries = new XYSeries(section, true, false);
Iterator webHitIter = list.iterator();
while (webHitIter.hasNext()) {
StudentsConceptHit cHit = (StudentsConceptHit) webHitIter.next();
dataSeries.add(cHit.getOrdNumb(), cHit.getHitDegree());
}
dataset.addSeries(dataSeries);
}
// Throw a custom NoDataException if there is no data
if (dataset.getItemCount() == 0) {
System.out.println("No data has been found");
throw new NoDataException();
}
// Create tooltip and URL generators
SimpleDateFormat sdf = new SimpleDateFormat("dd-MMM-yyyy", Locale.UK);
StandardXYToolTipGenerator ttg =
new StandardXYToolTipGenerator(
StandardXYToolTipGenerator.DEFAULT_TOOL_TIP_FORMAT, sdf, NumberFormat.getInstance());
TimeSeriesURLGenerator urlg =
new TimeSeriesURLGenerator(sdf, "bar_chart.jsp", "series", "hitDate");
// Create the X-Axis
DateAxis xAxis = new DateAxis(null);
xAxis.setLowerMargin(0.0);
xAxis.setUpperMargin(0.0);
// Create the X-Axis
NumberAxis yAxis = new NumberAxis(null);
yAxis.setAutoRangeIncludesZero(true);
// Create the renderer
StackedXYAreaRenderer renderer =
new StackedXYAreaRenderer(XYAreaRenderer.AREA_AND_SHAPES, ttg, urlg);
renderer.setSeriesPaint(0, new Color(255, 255, 180));
renderer.setSeriesPaint(1, new Color(206, 230, 255));
renderer.setSeriesPaint(2, new Color(255, 230, 230));
renderer.setSeriesPaint(3, new Color(206, 255, 206));
renderer.setShapePaint(Color.gray);
renderer.setShapeStroke(new BasicStroke(0.5f));
renderer.setShape(new Ellipse2D.Double(-3, -3, 6, 6));
renderer.setOutline(true);
// Create the plot
XYPlot plot = new XYPlot(dataset, xAxis, yAxis, renderer);
plot.setForegroundAlpha(0.65f);
// Reconfigure Y-Axis so the auto-range knows that the data is stacked
yAxis.configure();
// Create the chart
JFreeChart chart = new JFreeChart(null, JFreeChart.DEFAULT_TITLE_FONT, plot, true);
chart.setBackgroundPaint(java.awt.Color.white);
// Write the chart image to the temporary directory
ChartRenderingInfo info = new ChartRenderingInfo(new StandardEntityCollection());
filename = ServletUtilities.saveChartAsPNG(chart, 600, 400, info, session);
// Write the image map to the PrintWriter
ChartUtilities.writeImageMap(pw, filename, info);
pw.flush();
} catch (NoDataException e) {
System.out.println(e.toString());
filename = "public_nodata_500x300.png";
} catch (Exception e) {
System.out.println("Exception - " + e.toString());
e.printStackTrace(System.out);
filename = "public_error_500x300.png";
}
return filename;
}
public String generateXYChart(
String section, HttpSession session, PrintWriter pw, String courseId, int studentId) {
/*int groupId=0;
if (groupName.equals("All")){
groupId=0;
}else{
groupId = studStatisticBean.getGroupIdByName(groupName);
}*/
String filename = null;
try {
// Retrieve list of WebHits
StudentsConceptChartDataSet cDataSet =
new StudentsConceptChartDataSet(studStatisticBean, courseId, studentId);
ArrayList list = cDataSet.getDataByHitConcept(section);
// Throw a custom NoDataException if there is no data
if (list.size() == 0) {
System.out.println("No data has been found");
throw new NoDataException();
}
// Create and populate an XYSeries Collection
XYSeries dataSeries = new XYSeries("Students progress line");
Iterator iter = list.listIterator();
while (iter.hasNext()) {
StudentsConceptHit ch = (StudentsConceptHit) iter.next();
dataSeries.add(ch.getOrdNumb(), ch.getHitDegree());
}
XYSeriesCollection xyDataset = new XYSeriesCollection(dataSeries);
NumberFormat nf = NumberFormat.getIntegerInstance();
NumberFormat nf2 = NumberFormat.getInstance();
String cTitle = null;
// StandardXYToolTipGenerator ttg = new
// StandardXYToolTipGenerator(StandardXYToolTipGenerator.DEFAULT_TOOL_TIP_FORMAT,nf,nf2);
CustomXYToolTipGenerator ttg = new CustomXYToolTipGenerator();
ttg.addToolTipSeries(cDataSet.getConceptNames());
StandardXYURLGenerator sxyUrlGen =
new StandardXYURLGenerator("#", xyDataset.getSeriesName(0), "PassedConceptOrdNum");
ValueAxis ordNumAxis = new NumberAxis("Concept ordinal number");
NumberAxis valueAxis = new NumberAxis("Current knowledge");
// valueAxis.setAutoRangeIncludesZero(true);
valueAxis.setRange(0.0, 6.0); // override default
ordNumAxis.setAutoRange(true);
ordNumAxis.setLowerMargin(0.0);
StandardXYItemRenderer renderer =
new StandardXYItemRenderer(
StandardXYItemRenderer.LINES + StandardXYItemRenderer.SHAPES, ttg, sxyUrlGen);
Marker marker = new ValueMarker(1.50); // /
Marker marker2 = new ValueMarker(2.50);
Marker marker3 = new ValueMarker(3.50);
Marker marker4 = new ValueMarker(4.50);
Marker marker5 = new ValueMarker(5.00);
renderer.setShapesFilled(true);
XYPlot plot = new XYPlot(xyDataset, ordNumAxis, valueAxis, renderer);
plot.addRangeMarker(marker);
plot.addRangeMarker(marker2);
plot.addRangeMarker(marker3);
plot.addRangeMarker(marker4);
plot.addRangeMarker(marker5);
XYTextAnnotation xyBad = new XYTextAnnotation("Bad", 1, 1);
xyBad.setX(0.2);
xyBad.setY(0.75);
XYTextAnnotation xyNotBad = new XYTextAnnotation("Not Bad", 1, 1);
xyNotBad.setX(0.2);
xyNotBad.setY(2);
XYTextAnnotation xyGood = new XYTextAnnotation("Good", 1, 1);
xyGood.setX(0.2);
xyGood.setY(3);
XYTextAnnotation xyVeryGood = new XYTextAnnotation("Very Good", 1, 1);
xyVeryGood.setX(0.2);
xyVeryGood.setY(4);
XYTextAnnotation xyExcellent = new XYTextAnnotation("Excellent", 1, 1);
xyExcellent.setX(0.2);
xyExcellent.setY(4.75);
XYTextAnnotation xyExpert = new XYTextAnnotation("Expert", 1, 1);
xyExpert.setX(0.2);
xyExpert.setY(5.25);
plot.addAnnotation(xyBad);
plot.addAnnotation(xyNotBad);
plot.addAnnotation(xyGood);
plot.addAnnotation(xyVeryGood);
plot.addAnnotation(xyExcellent);
plot.addAnnotation(xyExpert);
JFreeChart chart = new JFreeChart("", JFreeChart.DEFAULT_TITLE_FONT, plot, true);
chart.setBackgroundPaint(java.awt.Color.white);
// Write the chart image to the temporary directory
ChartRenderingInfo info = new ChartRenderingInfo(new StandardEntityCollection());
filename = ServletUtilities.saveChartAsPNG(chart, 600, 400, info, session);
// Write the image map to the PrintWriter
ChartUtilities.writeImageMap(pw, filename, info);
pw.flush();
} catch (NoDataException e) {
System.out.println(e.toString());
filename = "public_nodata_500x300.png";
} catch (Exception e) {
System.out.println("Exception - " + e.toString());
e.printStackTrace(System.out);
filename = "public_error_500x300.png";
}
return filename;
}
public static String getSimplePieChart(Map dataSource, String objectName, HttpSession session)
throws Throwable {
DefaultPieDataset dataset = new DefaultPieDataset();
Element chartObject =
XMLHandler.getElementByAttribute(getChartObjectList(), "name", objectName);
String title = chartObject.getAttributeValue("title");
int width = Integer.parseInt(chartObject.getAttributeValue("width"));
int height = Integer.parseInt(chartObject.getAttributeValue("height"));
Element LabelKeys = chartObject.getChild("Labels");
Element ValueKeys = chartObject.getChild("Values");
String valueKey = ValueKeys.getText();
String valueType = ValueKeys.getAttributeValue("type");
List labelKeys = LabelKeys.getChildren("Label");
String labelKey = LabelKeys.getText();
if (valueType.equalsIgnoreCase("number")) {
for (int i = 0; i < dataSource.size(); i++) {
Map rec = (Map) dataSource.get("ROW" + i);
Number value = (Number) rec.get(valueKey);
String label;
if (labelKeys.isEmpty()) {
label = DataFilter.show(rec, labelKey);
} else {
label = ((Element) labelKeys.get(i)).getText();
}
dataset.setValue(label, value);
}
} else {
for (int i = 0; i < dataSource.size(); i++) {
Map rec = (Map) dataSource.get("ROW" + i);
double value = (Double) rec.get(valueKey);
String label;
if (labelKeys.isEmpty()) {
label = DataFilter.show(rec, labelKey);
} else {
label = ((Element) labelKeys.get(i)).getText();
}
dataset.setValue(label, value);
}
}
JFreeChart chart =
ChartFactory.createPieChart3D(
title,
dataset,
chartObject.getAttribute("showLegend").getBooleanValue(),
chartObject.getAttribute("showToolTips").getBooleanValue(),
chartObject.getAttribute("urls").getBooleanValue());
PiePlot3D pie3dplot = (PiePlot3D) chart.getPlot();
float alpha = 0.7F;
if (chartObject.getAttribute("alpha") != null) {
alpha = chartObject.getAttribute("alpha").getFloatValue();
}
pie3dplot.setForegroundAlpha(alpha);
return ServletUtilities.saveChartAsPNG(chart, width, height, null, session);
}
public static String getBarSeries(Map dataSource, String objectName, HttpSession session)
throws Exception {
DefaultKeyedValues barValues = new DefaultKeyedValues();
DefaultKeyedValues seriesValues = new DefaultKeyedValues();
Element chartObject =
XMLHandler.getElementByAttribute(getChartObjectList(), "name", objectName);
Element barField = chartObject.getChild("BarFields").getChild("Field");
Element seriesField = chartObject.getChild("SeriesFields").getChild("Field");
for (int i = 0; i < dataSource.size(); i++) {
Map rec = (Map) dataSource.get("ROW" + i);
barValues.addValue(
DataFilter.show(rec, chartObject.getChildText("ColumnLabel")),
Double.parseDouble(rec.get(barField.getAttributeValue("name")).toString()));
seriesValues.addValue(
DataFilter.show(rec, chartObject.getChildText("ColumnLabel")),
Double.parseDouble(rec.get(seriesField.getAttributeValue("name")).toString()));
}
CategoryDataset dataset =
DatasetUtilities.createCategoryDataset(barField.getAttributeValue("label"), barValues);
PlotOrientation plotOrientation =
chartObject.getAttributeValue("plotOrientation").equalsIgnoreCase("VERTICAL")
? PlotOrientation.VERTICAL
: PlotOrientation.HORIZONTAL;
JFreeChart chart =
ChartFactory.createBarChart3D(
chartObject.getAttributeValue("title"),
chartObject.getAttributeValue("categoryAxisLabel"),
chartObject.getAttributeValue("valueAxisLabel"),
dataset,
plotOrientation,
chartObject.getAttribute("showLegend").getBooleanValue(),
chartObject.getAttribute("showToolTips").getBooleanValue(),
chartObject.getAttribute("urls").getBooleanValue());
CategoryPlot categoryplot = chart.getCategoryPlot();
LineRenderer3D lineRenderer = new LineRenderer3D();
CategoryDataset datasetSeries =
DatasetUtilities.createCategoryDataset(
seriesField.getAttributeValue("label"), seriesValues);
categoryplot.setDataset(1, datasetSeries);
categoryplot.setRangeAxis(1, new NumberAxis3D(seriesField.getAttributeValue("label")));
categoryplot.setRenderer(1, lineRenderer);
categoryplot.mapDatasetToRangeAxis(1, 1);
BarRenderer3D barrenderer = (BarRenderer3D) categoryplot.getRenderer();
barrenderer.setLabelGenerator(new StandardCategoryLabelGenerator());
barrenderer.setItemLabelsVisible(true);
barrenderer.setPositiveItemLabelPosition(
new ItemLabelPosition(ItemLabelAnchor.OUTSIDE1, TextAnchor.BASELINE_CENTER));
// lineRenderer.setLabelGenerator(new StandardCategoryLabelGenerator());
// lineRenderer.setItemLabelsVisible(true);
// lineRenderer.setPositiveItemLabelPosition(
// new ItemLabelPosition(ItemLabelAnchor.OUTSIDE10, TextAnchor.CENTER));
float alpha = 0.7F;
if (chartObject.getAttribute("alpha") != null) {
alpha = chartObject.getAttribute("alpha").getFloatValue();
}
categoryplot.setForegroundAlpha(alpha);
int width, height;
if (chartObject.getAttributeValue("width").equalsIgnoreCase("auto")) {
width = (50 * dataSource.size()) + 100;
} else {
width = Integer.parseInt(chartObject.getAttributeValue("width"));
}
if (chartObject.getAttributeValue("height").equalsIgnoreCase("auto")) {
height = (50 * dataSource.size()) + 100;
} else {
height = Integer.parseInt(chartObject.getAttributeValue("height"));
}
return ServletUtilities.saveChartAsPNG(chart, width, height, session);
}
public static String getSimpleBarChart(Map dataSource, String objectName, HttpSession session)
throws Throwable {
Element chartObject =
XMLHandler.getElementByAttribute(getChartObjectList(), "name", objectName);
List invokeFields = chartObject.getChild("InvokeFields").getChildren("Field");
double[][] data = new double[invokeFields.size()][dataSource.size()];
String[] rowKeys = new String[invokeFields.size()];
String[] columnKeys = new String[dataSource.size()];
String columnLabel = chartObject.getChildText("ColumnLabel");
for (int i = 0; i < dataSource.size(); i++) {
Map rec = (Map) dataSource.get("ROW" + i);
columnKeys[i] = DataFilter.show(rec, columnLabel);
for (int j = 0; j < invokeFields.size(); j++) {
data[j][i] =
Double.parseDouble(
rec.get(((Element) invokeFields.get(j)).getAttributeValue("name")).toString());
}
}
for (int i = 0; i < invokeFields.size(); i++) {
rowKeys[i] = ((Element) invokeFields.get(i)).getAttributeValue("label");
}
CategoryDataset dataset = DatasetUtilities.createCategoryDataset(rowKeys, columnKeys, data);
PlotOrientation plotOrientation =
chartObject.getAttributeValue("plotOrientation").equalsIgnoreCase("VERTICAL")
? PlotOrientation.VERTICAL
: PlotOrientation.HORIZONTAL;
JFreeChart chart =
ChartFactory.createBarChart3D(
chartObject.getAttributeValue("title"),
chartObject.getAttributeValue("categoryAxisLabel"),
chartObject.getAttributeValue("valueAxisLabel"),
dataset,
plotOrientation,
chartObject.getAttribute("showLegend").getBooleanValue(),
chartObject.getAttribute("showToolTips").getBooleanValue(),
chartObject.getAttribute("urls").getBooleanValue());
CategoryPlot C3dplot = (CategoryPlot) chart.getPlot();
if (chartObject.getAttribute("alpha") != null) {
C3dplot.setForegroundAlpha(chartObject.getAttribute("alpha").getFloatValue());
}
BarRenderer3D barrenderer = (BarRenderer3D) C3dplot.getRenderer();
barrenderer.setLabelGenerator(new StandardCategoryLabelGenerator());
barrenderer.setItemLabelsVisible(true);
barrenderer.setPositiveItemLabelPosition(
new ItemLabelPosition(ItemLabelAnchor.OUTSIDE1, TextAnchor.BASELINE_CENTER));
int width, height;
if (chartObject.getAttributeValue("width").equalsIgnoreCase("auto")) {
width = (50 * dataSource.size()) * invokeFields.size() + 100;
} else {
width = Integer.parseInt(chartObject.getAttributeValue("width"));
}
if (chartObject.getAttributeValue("height").equalsIgnoreCase("auto")) {
height = (50 * dataSource.size()) * invokeFields.size() + 100;
} else {
height = Integer.parseInt(chartObject.getAttributeValue("height"));
}
return ServletUtilities.saveChartAsPNG(chart, width, height, session);
}