package dataQualityWebSite; import java.text.DateFormat; import java.text.DecimalFormat; import java.text.SimpleDateFormat; import java.util.Calendar; import java.util.ListIterator; public class SVGChart { // This needs refactoring: // - remove references to Tier 1 and Tier 2 (these go back to T-Mobile days) // - remove lower amber and red sections // - the odd tweaks here and there can't really be necessary // - try to remove confusion - it can't be that hard. private DashboardFile svgChartFile; private Calendar today; private DateFormat dateFormat; private DateFormat longDateFormat; private double daysBetween (Calendar c1, Calendar c2) { long milliSec; milliSec = c2.getTimeInMillis() - c1.getTimeInMillis(); return (double)milliSec / (1000 * 60 * 60 * 24); } private Calendar firstOfMonth(Calendar cIn) { Calendar cOut; cOut = cIn; cOut.set(Calendar.DATE, 1); return cOut; } private int[] calculateRectangle ( long top, long bottom, double minY, double maxY, double yScale, boolean wholeChartZero ) { long height; int intHeight; int intTop; int[] coordinates = {100,0,580,0}; // x, y, width, height if (top > maxY) top = Math.round(maxY); if (top < minY) top = Math.round(minY); if (bottom > maxY) bottom = Math.round(maxY); if (bottom < minY) bottom = Math.round(minY); height = top - bottom; top -= minY; // Allow for minY not being zero intTop = (int) Math.round(top * yScale); intHeight = (int) Math.round(height * yScale); if(wholeChartZero) intHeight -= 5; coordinates[1] = 350 - intTop; coordinates[3] = intHeight; return coordinates; } private String colouredRectangleSvg ( int x, int y, int width, int height, String colour ) { String rgbString; String rgbRed = "rgb(255,0,0);opacity:0.2"; String rgbAmber = "rgb(255,200,0);opacity:0.2"; String rgbGreen = "rgb(0,255,0);opacity:0.2"; if (height <= 0) return ""; else { if (colour.equals("red")) rgbString = new String(rgbRed); else if (colour.equals("amber")) rgbString = new String(rgbAmber); else rgbString = new String(rgbGreen); return ( " " ); } } public SVGChart(SeriesList seriesList, FactorElement factorElement, Configuration configuration) { int monthsOnGraph; int i; Calendar nMonthsBefore; double maxChange; double minChange; double maxValue; double minValue; double mean; double standardDeviation; double maxY; double minY; int orderOfMagnitude; // the highest power of 10 which is less than maxChange double yScale; double xScale; long top; long bottom; double tickIncrement; double tickY; ListIterator iterator; SeriesElement seriesElement; double change; double value; Calendar auditDate; long x; long y; boolean firstPoint; int monthIncrement; Calendar xOriginDate; String factorType; String chartTitle; boolean wholeChartZero; String svgChartFileName; int[] rectangleCoordinates; // x, y, width, height int bottomOfRed; int bottomOfAmber; DecimalFormat integerFormat; integerFormat = new DecimalFormat("###,###,###,###,###"); monthsOnGraph = factorElement.getMonthsOnGraph(); factorType = new String(factorElement.getFactorType()); svgChartFileName = new String ( configuration.getHtmlFileLocation() + configuration.getChartPrefix() + factorElement.getFactorId() + ".htm" ); svgChartFile = new DashboardFile(svgChartFileName); today = Calendar.getInstance(); dateFormat = new SimpleDateFormat("dd MMM yyyy"); dateFormat.format(today.getTime()); svgChartFile.PutLine(""); svgChartFile.PutLine(""); svgChartFile.PutLine(""); svgChartFile.PutLine(" " + factorElement.getFactorTitle() + ""); svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); svgChartFile.PutLine(""); svgChartFile.PutLine(""); svgChartFile.PutLine(""); svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); if (factorType.equals("Trend")) { svgChartFile.PutLine(" "); chartTitle = new String("CHANGES for "); svgChartFile.PutLine ( " " + chartTitle + factorElement.getFactorTitle() + "" ); } else { svgChartFile.PutLine(" "); chartTitle = new String("VALUES for "); svgChartFile.PutLine ( " " + chartTitle + factorElement.getFactorTitle() + "" ); } maxChange = seriesList.getMaxChange(); minChange = seriesList.getMinChange(); maxValue = seriesList.getMaxValue(); minValue = seriesList.getMinValue(); if (factorType.equals("Trend")) { if ((minChange == 0) && (maxChange == 0)) wholeChartZero = true; else wholeChartZero = false; } else { if ((minValue == 0) && (maxValue == 0)) wholeChartZero = true; else wholeChartZero = false; } mean = seriesList.getMean(); standardDeviation = seriesList.getStandardDeviation(); // // Tweaking Y axis // if (!factorType.equals("Trend")) // { // if (factorElement.getAmberLimit() > maxValue) // { // maxValue = factorElement.getAmberLimit(); // } // } // double d; if (factorType.equals("Trend")) d = maxChange; else d = maxValue; for (orderOfMagnitude = 0; d > 1; orderOfMagnitude++) d /= 10; if (orderOfMagnitude > 0) orderOfMagnitude--; if (factorType.equals("Trend")) { minY = (Math.floor(minChange / Math.pow(10, orderOfMagnitude)) * Math.pow(10, orderOfMagnitude)); maxY = (Math.ceil(maxChange / Math.pow(10, orderOfMagnitude)) * Math.pow(10, orderOfMagnitude)); } else { minY = (Math.floor(minValue / Math.pow(10, orderOfMagnitude)) * Math.pow(10, orderOfMagnitude)); maxY = (Math.ceil(maxValue / Math.pow(10, orderOfMagnitude)) * Math.pow(10, orderOfMagnitude)); } if (maxY < 1) maxY = 1; if (minY == maxY) minY = 0; if (maxY < 10) { maxY = 10; } yScale = 300 / (maxY - minY); // // Chart objects are measured from the top of the chart, in the opposite direction to the Y-axis. // Plot area starts from 50 (50 units down from the top of the graph) and is 300 units high. // Rectangles (such as the red, amber and green shading) are specified by their top position and their height // All of this can be confusing! // // // Upper Red // // top is top of chart, always 50 // For Trends: bottom is (mean + (3 * SD)) or top of graph; // For Tier 1 and Tier 2 bottom is amber limit or top of graph; // if the bottom of the upper red area is above the top // of the graph it is not shown at all. // top = Math.round(maxY); if (factorType.equals("Trend")) bottom = Math.round(mean + (3 * standardDeviation)); else bottom = Math.round(factorElement.getAmberLimit()); rectangleCoordinates = calculateRectangle(top, bottom, minY, maxY, yScale, wholeChartZero); bottomOfRed = rectangleCoordinates[1] + rectangleCoordinates[3]; svgChartFile.PutLine(colouredRectangleSvg(rectangleCoordinates[0], rectangleCoordinates[1], rectangleCoordinates[2], rectangleCoordinates[3], "red")); // svgChartFile.PutLine(colouredRectangle(top, bottom, minY, maxY, yScale, "red", wholeChartZero)); // // Upper Amber // if (factorType.equals("Trend")) { top = Math.round(mean + (3 * standardDeviation)); bottom = Math.round(mean + (2 * standardDeviation)); } else { top = Math.round(factorElement.getAmberLimit()); bottom = Math.round(factorElement.getGreenLimit()); } rectangleCoordinates = calculateRectangle(top, bottom, minY, maxY, yScale, wholeChartZero); if (rectangleCoordinates[1] != bottomOfRed) rectangleCoordinates[1] = bottomOfRed; bottomOfAmber = rectangleCoordinates[1] + rectangleCoordinates[3]; svgChartFile.PutLine(colouredRectangleSvg(rectangleCoordinates[0], rectangleCoordinates[1], rectangleCoordinates[2], rectangleCoordinates[3], "amber")); // svgChartFile.PutLine(colouredRectangle(top, bottom, minY, maxY, yScale, "amber", wholeChartZero)); // // Green // if (factorType.equals("Trend")) { top = Math.round(mean + (2 * standardDeviation)); bottom = Math.round(mean - (2 * standardDeviation)); } else { top = Math.round(factorElement.getGreenLimit()); bottom = 0; } rectangleCoordinates = calculateRectangle(top, bottom, minY, maxY, yScale, wholeChartZero); if (rectangleCoordinates[1] != bottomOfAmber) rectangleCoordinates[1] = bottomOfAmber; svgChartFile.PutLine(colouredRectangleSvg(rectangleCoordinates[0], rectangleCoordinates[1], rectangleCoordinates[2], rectangleCoordinates[3], "green")); // svgChartFile.PutLine(colouredRectangle(top, bottom, minY, maxY, yScale, "green", wholeChartZero)); // // Lower Amber // // if (factorType.equals("Trend")) // { // top = Math.round(mean - (2 * standardDeviation)); // bottom = Math.round(mean - (3 * standardDeviation)); // svgChartFile.PutLine(colouredRectangle(top, bottom, minY, maxY, yScale, "amber", wholeChartZero)); // } // // Lower Red // // if (factorType.equals("Trend")) // { // top = Math.round(mean - (3 * standardDeviation)); // bottom = Math.round(minY); // svgChartFile.PutLine(colouredRectangle(top, bottom, minY, maxY, yScale, "red", wholeChartZero)); // } // // Special Case: If the plot is zero all the way along, then it looks silly because the whole chart is red. // In this case only, put a thin green rectangle just above the line. // if (factorType.equals("Trend")) { if ((minChange == 0) && (maxChange == 0)) { svgChartFile.PutLine ( " " ); } } else { if ((minValue == 0) && (maxValue == 0)) { svgChartFile.PutLine ( " " ); } } // // End of special case // // // Build X-axis // svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); xScale = (double)(580 * 12) / (double)(365 * monthsOnGraph); monthIncrement = (int) Math.ceil(monthsOnGraph / 6); xOriginDate = Calendar.getInstance(); xOriginDate.add(Calendar.MONTH, ( 1 - monthsOnGraph)); xOriginDate.set(Calendar.DATE, 1); nMonthsBefore = Calendar.getInstance(); nMonthsBefore.add(Calendar.MONTH, ( 1 - monthsOnGraph)); svgChartFile.PutLine ( " " + dateFormat.format(firstOfMonth(nMonthsBefore).getTime()) + "" ); for (i = 0; i < monthsOnGraph; i += monthIncrement) { nMonthsBefore.add(Calendar.MONTH, monthIncrement); svgChartFile.PutLine ( " " ); svgChartFile.PutLine ( " " + dateFormat.format(firstOfMonth(nMonthsBefore).getTime()) + "" ); } svgChartFile.PutLine(" "); // // Build Y-axis // svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); tickIncrement = Math.pow(10, orderOfMagnitude); for (tickY = minY; tickY <= maxY; tickY += tickIncrement) { svgChartFile.PutLine ( " " ); svgChartFile.PutLine ( " " + integerFormat.format(Math.round(tickY)) + "" ); } svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); // // Plot the values // firstPoint = true; for (iterator = seriesList.listIterator(); iterator.hasNext(); ) { seriesElement = (SeriesElement) iterator.next(); change = seriesElement.getChange(); value = seriesElement.getValue(); // Hack to stop negative values breaking the graph // if (value < 0) // value = 0; // End of this part of the hack auditDate = seriesElement.getAuditDate(); x = Math.round(daysBetween(xOriginDate, auditDate) * xScale); double rawY; if (factorType.equals("Trend")) rawY = change; else rawY = value; y = Math.round(300.0 - ((rawY - minY) * yScale)); if ((x > -2) && (x < 582)) { if (firstPoint) { firstPoint = false; svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); longDateFormat = new SimpleDateFormat("EEE, dd MMM yyyy HH:mm:ss"); svgChartFile.PutLine ( " Chart published: " + longDateFormat.format(today.getTime()) + "" ); svgChartFile.PutLine(" "); svgChartFile.PutLine("
"); svgChartFile.PutLine("
"); svgChartFile.PutLine("
"); svgChartFile.PutLine(" "); svgChartFile.PutLine("
"); svgChartFile.PutLine("
"); svgChartFile.PutLine("
"); svgChartFile.PutLine("
"); svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); svgChartFile.PutLine(" "); svgChartFile.PutLine("
"); svgChartFile.PutLine("
"); svgChartFile.PutLine("
"); svgChartFile.PutLine(" "); svgChartFile.PutLine("
"); svgChartFile.PutLine("
"); svgChartFile.PutLine("
"); svgChartFile.PutLine(" "); svgChartFile.PutLine("
"); svgChartFile.PutLine("
"); svgChartFile.PutLine("
"); svgChartFile.PutLine(""); svgChartFile.Close(); } }