/** * @author Dennis W. Gichangi * @version 2011.0329 * @since 1.6 * website www.openbaraza.org * The contents of this file are subject to the GNU Lesser General Public License * Version 3.0 ; you may use this file in compliance with the License. */ package org.baraza.reports; import org.baraza.xml.BElement; import org.baraza.DB.BQuery; public class BReportMaker { public String makeReport(String reportname, String mysql, BQuery query) { String myReport = "\n"; myReport += "\n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; for(int i = 0; i < query.getColumnCount(); i++) { myReport += " \n"; } myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " <band height=\"71\" splitType=\"Stretch\">\n"; myReport += " <staticText>\n"; myReport += " <reportElement style=\"Title\" x=\"66\" y=\"0\" width=\"446\" height=\"62\"/>\n"; myReport += " <textElement verticalAlignment=\"Middle\">\n"; myReport += " <font fontName=\"Times New Roman\" size=\"24\" pdfFontName=\"Times-Roman\"/>\n"; myReport += " </textElement>\n"; myReport += " <text><![CDATA[" + query.initCap(reportname.replace("vw_", "")) + " Report]]></text>\n"; myReport += " </staticText>\n"; myReport += " </band>\n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; int w = 525 / query.getColumnCount(); int x = 0; for(int i = 0; i < query.getColumnCount(); i++) { x = 1 + (i * w); myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; } myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; for(int i = 0; i < query.getColumnCount(); i++) { x = 1 + (i * w); myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " "; myReport += "\n"; myReport += " \n"; } myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += "\n"; return myReport; } public String makeLandscapeReport(String reportname, String mysql, BQuery query) { String myReport = "\n"; myReport += "\n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; for(int i = 0; i < query.getColumnCount(); i++) { myReport += " \n"; } myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " <band height=\"71\" splitType=\"Stretch\">\n"; myReport += " <staticText>\n"; myReport += " <reportElement style=\"Title\" x=\"66\" y=\"0\" width=\"446\" height=\"62\"/>\n"; myReport += " <textElement verticalAlignment=\"Middle\">\n"; myReport += " <font fontName=\"Times New Roman\" size=\"24\" pdfFontName=\"Times-Roman\"/>\n"; myReport += " </textElement>\n"; myReport += " <text><![CDATA[" + query.initCap(reportname.replace("vw_", "")) + " Report]]></text>\n"; myReport += " </staticText>\n"; myReport += " </band>\n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; int w = 770 / query.getColumnCount(); int x = 0; for(int i = 0; i < query.getColumnCount(); i++) { x = 1 + (i * w); myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; } myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; for(int i = 0; i < query.getColumnCount(); i++) { x = 1 + (i * w); myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " "; myReport += "\n"; myReport += " \n"; } myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += "\n"; return myReport; } public String makeSubReport(String reportname, String mysql, BQuery query) { String myReport = "\n"; myReport += "\n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; for(int i = 0; i < query.getColumnCount(); i++) { myReport += " \n"; } myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " <band height=\"21\" splitType=\"Stretch\">\n"; myReport += " <staticText>\n"; myReport += " <reportElement style=\"Title\" x=\"1\" y=\"0\" width=\"446\" height=\"20\"/>\n"; myReport += " <textElement verticalAlignment=\"Middle\">\n"; myReport += " <font fontName=\"Times New Roman\" size=\"12\" pdfFontName=\"Times-Roman\"/>\n"; myReport += " </textElement>\n"; myReport += " <text><![CDATA[" + query.initCap(reportname.replace("vw_", "")) + "]]></text>\n"; myReport += " </staticText>\n"; myReport += " </band>\n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; int w = 525 / query.getColumnCount(); int x = 0; for(int i = 0; i < query.getColumnCount(); i++) { x = 1 + (i * w); myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; } myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; for(int i = 0; i < query.getColumnCount(); i++) { x = 1 + (i * w); myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " \n"; myReport += " "; myReport += "\n"; myReport += " \n"; } myReport += " \n"; myReport += " \n"; myReport += "\n"; return myReport; } }