public void generatePdf() { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; // com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); com.lowagie.text.Document docPdf = new com.lowagie.text.Document(PageSize.A4.rotate()); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); try { java.lang.Class.forName("org.postgresql.Driver"); } catch (java.lang.ClassNotFoundException cnfExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), cnfExec.getMessage()); } String compName = null; String date = null; try { // java.sql.Connection conDb = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName, pFontHeader), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Orders - Page: ", pFontHeader), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(7); int headerwidths[] = {12, 10, 30, 30, 8, 8, 12}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(2); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(5); Phrase phrase = new Phrase("Orders list as at: " + endDate, pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setColspan(2); phrase = new Phrase("Printed on : " + date, pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); // table.getDefaultCell().setBackgroundColor(java.awt.Color.LIGHT_GRAY); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Order No", pFontHeader); table.addCell(phrase); phrase = new Phrase("Date Due", pFontHeader); table.addCell(phrase); phrase = new Phrase("Supplier", pFontHeader); table.addCell(phrase); phrase = new Phrase("Item", pFontHeader); table.addCell(phrase); phrase = new Phrase("Units", pFontHeader); table.addCell(phrase); phrase = new Phrase("Qty", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); phrase = new Phrase("Net Value", pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { java.lang.Object[] listofAct = this.getListofActivities(); java.sql.Statement st = connectDB.createStatement(); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); for (int i = 0; i < listofAct.length; i++) { int w = 0; java.sql.ResultSet rset3 = st3.executeQuery( "SELECT DISTINCT order_no,date_due AS date,supplier from st_orders WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "' AND order_no = '" + listofAct[i].toString() + "' ORDER BY date"); java.sql.ResultSet rset = st.executeQuery( "SELECT item,units,quantity,net_value from st_orders WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "' AND order_no = '" + listofAct[i].toString() + "' ORDER BY item"); java.sql.ResultSet rsetTotals = st2.executeQuery( "SELECT SUM(net_value) from st_orders WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "' AND order_no = '" + listofAct[i].toString() + "'"); while (rset3.next()) { while (rset.next()) { w = w + 1; if (w == 1) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset3.getObject(1).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset3.getObject(2).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset3.getObject(3).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(1).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(2).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(3)), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(4)), pFontHeader1); table.addCell(phrase); } else { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(1).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(2).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(3)), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(4)), pFontHeader1); table.addCell(phrase); } } } // table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); // table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); while (rsetTotals.next()) { table.getDefaultCell().setColspan(5); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase((""), pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rsetTotals.getString(1)), pFontHeader); table.addCell(phrase); } } docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; try { java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.Statement st2x = connectDB.createStatement(); java.sql.ResultSet rset2x = st2x.executeQuery("SELECT rep_currency from pb_hospitalprofile"); while (rset2x.next()) { ks = rset2x.getObject(1).toString(); } java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Price List - Page: "), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(5); int headerwidths[] = {20, 50, 30, 30, 30}; table.setWidths(headerwidths); table.setWidthPercentage((100)); // table.setHeaderRows(2); table .getDefaultCell() .setBorder(Rectangle.BOTTOM | Rectangle.TOP | Rectangle.LEFT | Rectangle.RIGHT); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); Phrase phrase = new Phrase(" "); // table.addCell(phrase); try { table.getDefaultCell().setColspan(5); phrase = new Phrase("Departmental Price List "); table.addCell(phrase); table.getDefaultCell().setColspan(4); java.sql.Statement st2 = connectDB.createStatement(); // java.sql.ResultSet rset = st.executeQuery("select code,upper(service_type) as // description,rate from pricelist WHERE main_service ilike '"+bank+"%' order by // service_type");// tn,debit_note db WHERE tn.policy_no != '' and tn.policy_no = // db.policy_no GROUP BY tn.policy_no,db.policy_class"); System.out.println("Printing Price List for GL/CODE : [" + bank + "]"); java.sql.ResultSet rset3 = st2.executeQuery( "SELECT DISTINCT activity FROM pb_activity WHERE code ILIKE '" + bank + "'"); while (rset3.next()) { table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase( rset3.getString(1).toUpperCase() + " - " + bank + " Price List as at : " + date, pFontHeader); table.addCell(phrase); } // Phrase phrase = new Phrase(bank +" Balance Report" +" as at : " +endDate, // pFontHeader); // table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Printed on : " + date, pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); // table.getDefaultCell().setBackgroundColor(java.awt.Color.LIGHT_GRAY); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("CODE", pFontHeader); table.addCell(phrase); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); phrase = new Phrase("DESCRIPTION", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase("",pFontHeader); // table.addCell(phrase); phrase = new Phrase("Norminal Rate (E.A) " + ks, pFontHeader); table.addCell(phrase); phrase = new Phrase("Special Rate (PRIVATE) " + ks, pFontHeader); table.addCell(phrase); phrase = new Phrase("NON E.A " + ks, pFontHeader); table.addCell(phrase); // phrase = new Phrase("Credit KShs.",pFontHeader); // table.addCell(phrase); // table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); // table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); double osBalance = 0.00; // java.sql.Connection conDb1 = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st = connectDB.createStatement(); // java.sql.Statement st2 = connectDB.createStatement(); // java.sql.ResultSet rset = st.executeQuery("select code,upper(service_type) as // description,rate from pricelist WHERE main_service ilike '"+bank+"%' order by // service_type");// tn,debit_note db WHERE tn.policy_no != '' and tn.policy_no = // db.policy_no GROUP BY tn.policy_no,db.policy_class"); System.out.println("Printing Price List for GL/CODE : [" + bank + "]"); java.sql.ResultSet rset = st.executeQuery( "SELECT code, upper(service_type), rate, anaesthetist_rate,other_prices FROM pb_operating_parameters WHERE gl_account ilike '" + bank + "' order by service_type"); while (rset.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(1), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(2), "-"), pFontHeader1); table.addCell(phrase); // table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(3)), pFontHeader); // osBalance = osBalance + rset1.getDouble(6); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(4)), pFontHeader); // osBalance = osBalance + rset1.getDouble(6); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(5)), pFontHeader); // osBalance = osBalance + rset1.getDouble(6); table.addCell(phrase); } docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(PageSize.A2.rotate()); try { try { Image img = Image.getInstance(com.afrisoftech.lib.CompanyLogo.getPath2Logo()); // Image imgWaterMark = Image.getInstance(System.getProperty("company.watermark")); com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String District = null; String Region = null; String date = null; try { java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name,district_branch from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); District = rset2.getObject(2).toString(); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("MINISTRY OF HEALTH : " + compName.toUpperCase()), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { SqlExec.printStackTrace(); javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("MOH - 204B : OP Over 5 Yrs Register : Page: "), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(21); int headerwidths[] = { 5, 10, 10, 10, 25, 10, 12, 20, 12, 12, 12, 12, 12, 12, 12, 25, 25, 12, 12, 12, 25 }; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(4); Phrase phrase = new Phrase("", pFontHeader); try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); java.util.Date endDate1 = dateFormat.parse(endDate.toLocaleString()); // dateInstance.toLocaleString()); java.util.Date endDate11 = dateFormat.parse(beginDate.toLocaleString()); // dateInstance.toLocaleString()); com.afrisoftech.lib.DateFormatter dateFormatter = new com.afrisoftech.lib.DateFormatter( dateFormat.parse(endDate.toLocaleString()), "MMMM"); java.lang.String monthString = dateFormatter.getDateString(); com.afrisoftech.lib.DateFormatter dateFormatters = new com.afrisoftech.lib.DateFormatter( dateFormat.parse(endDate.toLocaleString()), "yyyy"); java.lang.String yearString = dateFormatters.getDateString(); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(21); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); table.getDefaultCell().setFixedHeight(50); table.addCell(Image.getInstance(com.afrisoftech.lib.CompanyLogo.getPath2Logo())); table.getDefaultCell().setFixedHeight(-1); // table.getDefaultCell().setNoWrap(false); phrase = new Phrase("MOH 204B_Over 5 Yrs Register", pFontHeader2); table.addCell(phrase); table.getDefaultCell().setColspan(5); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("OP OVER 5 YEARS REGISTER", pFontHeader22); table.addCell(phrase); table.getDefaultCell().setColspan(10); phrase = new Phrase("HEALTH FACILITY : " + compName, pFontHeader22); table.addCell(phrase); table.getDefaultCell().setColspan(3); phrase = new Phrase("MONTH : " + monthString.toUpperCase(), pFontHeader22); table.addCell(phrase); table.getDefaultCell().setColspan(3); phrase = new Phrase("YEAR : " + yearString.toUpperCase(), pFontHeader22); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); table.getDefaultCell().setColspan(1); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(1); phrase = new Phrase("#", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Date", pFontHeader11); table.addCell(phrase); phrase = new Phrase("OPD No.", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Revisit", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Full Names", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Age YRS", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Sex", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Village", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Phone. No.", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Weight", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Height", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Visual Activity RE(Right Eye), LE(LEFT EYE)", pFontHeader11); table.addCell(phrase); phrase = new Phrase("HIV: 1=Cancelled, 2=Tested", pFontHeader11); table.addCell(phrase); phrase = new Phrase( "HIV Status: 1=Known Positive, 2=Positive this visit, 3=Negative, 4=Uknown", pFontHeader11); table.addCell(phrase); phrase = new Phrase( "Nutrition Status: 1=Nutrition Education, 2=Nutrition Suppliments", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Diagnosis/Classification", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Treatment/Prescription No.", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Amount Charged", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Receipt No.", pFontHeader11); table.addCell(phrase); phrase = new Phrase( "1 = From Other HF, 2 = To Other HF, 3 = From CU, 4 = To CU", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Remarks", pFontHeader11); table.addCell(phrase); // Second header row phrase = new Phrase("", pFontHeader11); table.addCell(phrase); phrase = new Phrase("A", pFontHeader11); table.addCell(phrase); phrase = new Phrase("B", pFontHeader11); table.addCell(phrase); phrase = new Phrase("C", pFontHeader11); table.addCell(phrase); phrase = new Phrase("D", pFontHeader11); table.addCell(phrase); phrase = new Phrase("E", pFontHeader11); table.addCell(phrase); phrase = new Phrase("F", pFontHeader11); table.addCell(phrase); phrase = new Phrase("G", pFontHeader11); table.addCell(phrase); phrase = new Phrase("H", pFontHeader11); table.addCell(phrase); phrase = new Phrase("I", pFontHeader11); table.addCell(phrase); phrase = new Phrase("J", pFontHeader11); table.addCell(phrase); phrase = new Phrase("K", pFontHeader11); table.addCell(phrase); phrase = new Phrase("L", pFontHeader11); table.addCell(phrase); phrase = new Phrase("M", pFontHeader11); table.addCell(phrase); phrase = new Phrase("N", pFontHeader11); table.addCell(phrase); phrase = new Phrase("O", pFontHeader11); table.addCell(phrase); phrase = new Phrase("P", pFontHeader11); table.addCell(phrase); phrase = new Phrase("Q", pFontHeader11); table.addCell(phrase); phrase = new Phrase("R", pFontHeader11); table.addCell(phrase); phrase = new Phrase("S", pFontHeader11); table.addCell(phrase); phrase = new Phrase("T", pFontHeader11); table.addCell(phrase); } catch (java.text.ParseException psExec) { psExec.printStackTrace(); javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); try { int noSeq = 0; java.lang.Object[] listofAct = this.getListofStaffNos(); System.out.println("The array has been called..."); for (int i = 0; i < listofAct.length; i++) { java.sql.PreparedStatement stw = connectDB.prepareStatement( "SELECT DISTINCT " + " date_part('day', date) ||'-'||date_part('month', date) ||'-'||date_part('year', date), patient_no," + " (CASE WHEN comments = 'Old' THEN 'YES' ELSE 'NO' END) as revisit, " + " initcap(name), age::int, (SELECT initcap(gender) FROM hp_patient_register WHERE hp_patient_register.patient_no = hp_patient_visit.patient_no ORDER BY 1 DESC LIMIT 1) as gender, " + " (SELECT initcap(residence) FROM hp_inpatient_register" + " WHERE hp_patient_visit.patient_no = hp_inpatient_register.patient_no" + " UNION SELECT initcap(residence) FROM hp_patient_register WHERE " + " hp_patient_visit.patient_no = hp_patient_register.patient_no ORDER BY 1 " + " DESC LIMIT 1) as village, (SELECT tel_no FROM hp_patient_register WHERE hp_patient_register.patient_no = hp_patient_visit.patient_no " + " ORDER BY 1 DESC LIMIT 1) as telephone, (SELECT weight::numeric(5,1) FROM hp_signs_record WHERE hp_signs_record.patient_no = hp_patient_visit.patient_no AND hp_signs_record.date = hp_patient_visit.date ORDER BY 1 DESC LIMIT 1) as weight," + " (SELECT height::numeric(5,1) FROM hp_signs_record WHERE hp_signs_record.patient_no = hp_patient_visit.patient_no AND hp_signs_record.date = hp_patient_visit.date ORDER BY 1 DESC LIMIT 1) as height, " + " ''," // to add eye conditions for over 5 years + " (SELECT (CASE WHEN hiv_counselled = true THEN '1' ELSE '' END) || ' '||" + "(CASE WHEN hiv_tested = true THEN '2' ELSE '' END) FROM key_health_indicators" + " WHERE key_health_indicators.patient_no = hp_patient_visit.patient_no) as hiv_tested," + " (SELECT (CASE WHEN hiv_status ilike '%positive%' THEN '1' ELSE '' END) || ' '||" + "(CASE WHEN hiv_status ilike '%visit' THEN '2' ELSE '' END)||' '||" + "(CASE WHEN hiv_status ilike 'negative' THEN '3' ELSE '' END)||' '||" + "(CASE WHEN hiv_status ilike 'unknown' THEN '4' ELSE '' END) FROM key_health_indicators" + " WHERE key_health_indicators.patient_no = hp_patient_visit.patient_no) as hiv_status," + " (SELECT (CASE WHEN nutrition_status ilike '%education%' THEN '1' ELSE '' END)||' '||" + "(CASE WHEN nutrition_status ILIKE '%suppliments%' THEN '2' ELSE '' END) " + "FROM key_health_indicators WHERE key_health_indicators.patient_no = hp_patient_visit.patient_no)" + " as nutrition_status, " + " (SELECT disease FROM hp_patient_diagnosis WHERE hp_patient_diagnosis.patient_no = hp_patient_visit.patient_no AND" + " hp_patient_diagnosis.date_recorded::date = hp_patient_visit.date::date AND disease is not null ORDER BY 1 DESC LIMIT 1) as diagnosis, " + " (SELECT replace(treatment, 'null', '') FROM hp_clinical_results WHERE hp_clinical_results.patient_no =" + " hp_patient_visit.patient_no AND hp_clinical_results.date = hp_patient_visit.date " + "ORDER BY 1 DESC LIMIT 1) as treatment, " + " (SELECT sum(credit-debit) FROM ac_ledger WHERE ac_ledger.patient_no = " + "hp_patient_visit.patient_no AND ac_ledger.date = hp_patient_visit.date) " + "as amount, '', " + " (SELECT refer_source FROM hp_patient_register WHERE hp_patient_register.patient_no" + " = hp_patient_visit.patient_no AND hp_patient_register.date = hp_patient_visit.date" + " ORDER BY 1 DESC LIMIT 1) as referral," + " (SELECT comments FROM hp_clinical_results WHERE hp_clinical_results.patient_no " + "= hp_patient_visit.patient_no AND hp_clinical_results.date = hp_patient_visit.date" + " ORDER BY 1 DESC LIMIT 1 )as comments FROM hp_patient_visit WHERE " + " date::date BETWEEN '" + beginDate + "' AND '" + endDate + "' " + " AND patient_no = ?"); stw.setObject(1, listofAct[i]); java.sql.ResultSet rsetw = stw.executeQuery(); while (rsetw.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(1); noSeq = noSeq + 1; // Index phrase = new Phrase(java.lang.String.valueOf(noSeq), pFontHeader1); table.addCell(phrase); // Lab procedure date phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(1), ""), pFontHeader1); table.addCell(phrase); // Patient Number phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(2), ""), pFontHeader1); table.addCell(phrase); // Lab Number phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(3), ""), pFontHeader1); table.addCell(phrase); // Revisit No phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(4), ""), pFontHeader1); table.addCell(phrase); // Patient names phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(5), ""), pFontHeader1); table.addCell(phrase); // Age phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(6), ""), pFontHeader1); table.addCell(phrase); // Gender phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(7), ""), pFontHeader1); table.addCell(phrase); // Village phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(8), ""), pFontHeader1); table.addCell(phrase); // Telephone number phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(9), ""), pFontHeader1); table.addCell(phrase); // Clinical diagnosis phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(10), ""), pFontHeader1); table.addCell(phrase); // Prior treatment phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(11), ""), pFontHeader1); table.addCell(phrase); // Type of specimen phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(12), ""), pFontHeader1); table.addCell(phrase); // Condition of specimen phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(13), ""), pFontHeader1); table.addCell(phrase); // Investigation required phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(14), ""), pFontHeader1); table.addCell(phrase); // Date sample taken phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(15), ""), pFontHeader1); table.addCell(phrase); // Date sample received phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(16), ""), pFontHeader1); table.addCell(phrase); // Amount Paid by client table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(17), ""), pFontHeader1); table.addCell(phrase); // Date sample analysed table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(18), ""), pFontHeader1); table.addCell(phrase); // Results phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(19), ""), pFontHeader1); table.addCell(phrase); // Date result dispatched phrase = new Phrase( new com.afrisoftech.lib.DBObject().getDBObject(rsetw.getString(20), ""), pFontHeader1); table.addCell(phrase); } } docPdf.add(table); } catch (java.sql.SQLException SqlExec) { SqlExec.printStackTrace(); javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { IOexec.printStackTrace(); javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
/** * Extended headers / footers example * * @param args Unused */ public static void main(String[] args) { System.out.println("Demonstrates use of the RtfHeaderFooter for extended headers and footers"); try { Document document = new Document(); RtfWriter2.getInstance(document, new FileOutputStream("ExtendedHeaderFooter.rtf")); // Create the Paragraphs that will be used in the header. Paragraph date = new Paragraph("01.01.2010"); date.setAlignment(Paragraph.ALIGN_RIGHT); Paragraph address = new Paragraph("TheFirm\nTheRoad 24, TheCity\n" + "+00 99 11 22 33 44"); // Create the RtfHeaderFooter with an array containing the Paragraphs to add RtfHeaderFooter header = new RtfHeaderFooter(new Element[] {date, address}); // Set the header document.setHeader(header); // Create the table that will be used as the footer Table footer = new Table(2); footer.setBorder(0); footer.getDefaultCell().setBorder(0); footer.setWidth(100); footer.addCell(new Cell("(c) Mark Hall")); Paragraph pageNumber = new Paragraph("Page "); // The RtfPageNumber is an RTF specific element that adds a page number field pageNumber.add(new RtfPageNumber()); pageNumber.setAlignment(Paragraph.ALIGN_RIGHT); footer.addCell(new Cell(pageNumber)); // Create the RtfHeaderFooter and set it as the footer to use document.setFooter(new RtfHeaderFooter(footer)); document.open(); document.add( new Paragraph( "This document has headers and footers created" + " using the RtfHeaderFooter class.")); document.close(); } catch (FileNotFoundException fnfe) { fnfe.printStackTrace(); } catch (DocumentException de) { de.printStackTrace(); } }
public void generatePdf() { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; try { // java.sql.Connection conDb = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name,rep_currency from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); ks = rset2.getString(2); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName + "", pFontHeader), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Petty Cash Payments - Page: ", pFontHeader), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { double amountTo = 0.00; String shiftDate = null; com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(8); int headerwidths[] = {12, 8, 20, 25, 15, 14, 13, 17}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(8); Phrase phrase = new Phrase("", pFontHeader); // try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); // java.util.Date endDate1 = // dateFormat.parse(endDate.toLocaleString());//dateInstance.toLocaleString()); // java.util.Date endDate11 = // dateFormat.parse(beginDate.toLocaleString());//dateInstance.toLocaleString()); // System.out.println(""+endDate1); // phrase = new Phrase(bank +" Report: " +dateFormat.format(formattedDate), // pFontHeader); // table.addCell(phrase); table.getDefaultCell().setColspan(5); phrase = new Phrase("Petty Cash Payments", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Printed On :" + date, pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(8); phrase = new Phrase("SHIFT No :- " + memNo, pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); // table.getDefaultCell().setBackgroundColor(java.awt.Color.LIGHT_GRAY); phrase = new Phrase("Date", pFontHeader); table.addCell(phrase); phrase = new Phrase("V/No.", pFontHeader); table.addCell(phrase); phrase = new Phrase("Dealer", pFontHeader); table.addCell(phrase); phrase = new Phrase("Details", pFontHeader); table.addCell(phrase); phrase = new Phrase("Gl A/C", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Deposits", pFontHeader); table.addCell(phrase); phrase = new Phrase("Withdrawals", pFontHeader); table.addCell(phrase); phrase = new Phrase("Balance " + ks, pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { java.sql.Statement st = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st3x = connectDB.createStatement(); java.sql.ResultSet rsetx = st3x.executeQuery( "SELECT start_date::date from ac_shifts WHERE shift_no = '" + memNo + "' AND cash_point = '" + CashPoint + "'"); while (rsetx.next()) { shiftDate = rsetx.getString(1); } java.sql.ResultSet rset = st.executeQuery( "SELECT date,voucher_no,initcap(payee),initcap(status),code,sum(debit-credit),transaction_no from ac_petty_cash WHERE shift_no = '" + memNo + "' AND cash_point = '" + CashPoint + "' AND paid = 'true' GROUP BY date,voucher_no,initcap(payee),initcap(status),code,transaction_no ORDER BY transaction_no"); java.sql.ResultSet rsetTotals = st2.executeQuery( "SELECT SUM(debit),SUM(credit) from ac_petty_cash WHERE shift_no = '" + memNo + "' AND cash_point = '" + CashPoint + "' AND paid = 'true'"); // java.sql.ResultSet rsetTotals1 = st3.executeQuery("SELECT SUM(debit - credit) from // ac_petty_cash WHERE shift_no != '"+memNo+"' AND shift_no < '"+memNo+"' AND date < // '"+shiftDate+"'"); java.sql.ResultSet rsetTotals1 = st3.executeQuery( "SELECT SUM(debit - credit) from ac_petty_cash WHERE shift_no::int < '" + memNo + "' AND shift_no != '" + memNo + "' AND date <= '" + shiftDate + "'"); while (rsetTotals1.next()) { table.getDefaultCell().setColspan(7); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("BFWD", pFontHeader); table.addCell(phrase); totals = rsetTotals1.getDouble(1); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(totals)), pFontHeader); table.addCell(phrase); } while (rset.next()) { amountTo = rset.getDouble(6); if (amountTo > 0) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getString(1), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getString(2), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getString(3), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getString(4), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getString(5), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(amountTo)), pFontHeader1); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(0.00)), pFontHeader1); table.addCell(phrase); totals = totals + rset.getDouble(6); TDebit = TDebit + (amountTo); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(totals)), pFontHeader); table.addCell(phrase); } else { if (amountTo < 0) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getString(1), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getString(2), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getString(3), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getString(4), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getString(5), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(0.00)), pFontHeader1); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(amountTo * -1)), pFontHeader1); table.addCell(phrase); TCredit = TCredit + (amountTo * -1); totals = totals + rset.getDouble(6); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(totals)), pFontHeader); table.addCell(phrase); } } } table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); while (rsetTotals.next()) { table.getDefaultCell().setColspan(5); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(TDebit)), pFontHeader); table.addCell(phrase); debit = rsetTotals.getDouble(1); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(TCredit)), pFontHeader); table.addCell(phrase); credit = rsetTotals.getDouble(2); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(totals)), pFontHeader); table.addCell(phrase); } table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); // table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); table.getDefaultCell().setColspan(8); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM); // while (rsetTotals1.next()) { table.getDefaultCell().setColspan(6); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Cash In Hand", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(totals)), pFontHeader); table.addCell(phrase); docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.sql.ResultSet rsetTotals1 = null; java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; try { java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.Statement st2x = connectDB.createStatement(); java.sql.ResultSet rset2x = st2x.executeQuery("SELECT rep_currency from pb_hospitalprofile"); while (rset2x.next()) { ks = rset2x.getObject(1).toString(); } java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName, pFontHeader), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Charge Sheet - Page: ", pFontHeader1), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(7); int headerwidths[] = {10, 15, 30, 10, 10, 10, 15}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(2); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(4); Phrase phrase = new Phrase( "Charges(Item/Service Rate) : ", com.lowagie.text.FontFactory.getFont(FontFactory.HELVETICA_BOLD, 8)); table.addCell(phrase); table.getDefaultCell().setColspan(3); phrase = new Phrase( "Printed On : " + date, com.lowagie.text.FontFactory.getFont(FontFactory.HELVETICA_BOLD, 8)); table.addCell(phrase); table.getDefaultCell().setColspan(1); phrase = new Phrase("Index", pFontHeader); table.addCell(phrase); phrase = new Phrase("Code", pFontHeader); table.addCell(phrase); phrase = new Phrase("Item/Service", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Normal Rate - E.A. (" + ks + ")", pFontHeader); table.addCell(phrase); phrase = new Phrase("Special Rate - PRIVATE (" + ks + ")", pFontHeader); table.addCell(phrase); phrase = new Phrase("NON E.A. (" + ks + ")", pFontHeader); table.addCell(phrase); phrase = new Phrase("Gl Account", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); // table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { table .getDefaultCell() .setBorder(Rectangle.BOTTOM | Rectangle.TOP | Rectangle.LEFT | Rectangle.RIGHT); // java.lang.Object[] listofAct = this.getListofActivities(); java.lang.Object[] listofAct1 = this.getListofActivities1(); // java.sql.Connection conDb1 = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); // System.out.println(listofAct.length); java.sql.Statement st2 = connectDB.createStatement(); for (int k = 0; k < listofAct1.length; k++) { java.sql.ResultSet rset1 = st2.executeQuery( "SELECT service_type,rate,gl_account,code,anaesthetist_rate,other_prices from pb_operating_parameters where main_service ilike '" + listofAct1[k].toString() + "' order by service_type"); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("", pFontHeader); // table.addCell(phrase); table.getDefaultCell().setColspan(7); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(listofAct1[k].toString(), pFontHeader); table.addCell(phrase); int index = 1; com.afrisoftech.lib.DBObject dbObject = new com.afrisoftech.lib.DBObject(); while (rset1.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(String.valueOf(index), pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset1.getObject(4), "-"), pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset1.getObject(1).toString(), pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency( java.lang.String.valueOf(rset1.getObject(2).toString())), pFontNum); // phrase = new Phrase(rset1.getObject(2).toString(),pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency( java.lang.String.valueOf(rset1.getObject(5).toString())), pFontNum); // phrase = new Phrase(rset1.getObject(2).toString(),pFontNum); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency( java.lang.String.valueOf(rset1.getObject(6).toString())), pFontNum); // phrase = new Phrase(rset1.getObject(2).toString(),pFontNum); table.addCell(phrase); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset1.getString(3), pFontNum); table.addCell(phrase); index++; } } docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.lang.Object[][] rangeDates = ageingSeries.getAgeingDateSeries(); // ageingDates = ageingSeries.getAgeingDateSeries(); double columnTotals[] = new double[rangeDates.length]; java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); int interval = 0; try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); java.util.Calendar calendar = java.util.Calendar.getInstance(); long dateNow = calendar.getTimeInMillis(); java.sql.Date datenowSql = new java.sql.Date(dateNow); System.out.println(datenowSql.toString()); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; try { // java.sql.Connection conDb = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) compName = rset2.getObject(1).toString(); while (rset4.next()) date = rset4.getObject(1).toString(); com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName, pFontHeader2), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Ageing Page: ", pFontHeader), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); double Totals = 0.00; double OS = 0.00; try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(rangeDates.length + 3); String headerWidths = null; java.util.Vector headerVector = new java.util.Vector(1, 1); int z = rangeDates.length; int headerwidths[] = {35, 15, 15, 10, 10}; table.setWidths(headerwidths); table.setWidthPercentage((107)); table.setHeaderRows(2); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(5); Phrase phrase = new Phrase(""); table.getDefaultCell().setColspan(3); try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); java.util.Date endDate2 = dateFormat.parse(endDate.toLocaleString()); phrase = new Phrase("Weekly Sales Comparison " + dateFormat.format(endDate2), pFontHeader); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setColspan(2); phrase = new Phrase("Printed on : " + date, pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("DESCRIPTION", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); for (int x = 0; x < rangeDates.length; x++) { int days = 1; try { // Date parser java.text.SimpleDateFormat dateFormat = new java.text.SimpleDateFormat("EEE MMM dd HH:mm:ss zzz yyyy"); com.afrisoftech.lib.DateFormatter dateFormatter = new com.afrisoftech.lib.DateFormatter( dateFormat.parse(rangeDates[x][0].toString().trim()), "w"); com.afrisoftech.lib.DateFormatter yearFormatterCurrent = new com.afrisoftech.lib.DateFormatter(endDate, "yy"); java.lang.String monthString = dateFormatter.getDateString(); java.lang.String yearStringCurrent = yearFormatterCurrent.getDateString(); // int days = 1; // if (x < 1) { com.afrisoftech.lib.DateFormatter dateFormatterCurrent = new com.afrisoftech.lib.DateFormatter(endDate, "w"); com.afrisoftech.lib.DateFormatter yearFormatterCurrent1 = new com.afrisoftech.lib.DateFormatter(endDate, "yy"); java.lang.String monthStringCurrent = dateFormatterCurrent.getDateString(); java.lang.String yearStringCurrent1 = yearFormatterCurrent1.getDateString(); // phrase = new Phrase("Week ["+monthStringCurrent+"/"+yearStringCurrent1+"]" // ,pFontHeader); // } else { // phrase = new Phrase("Week ["+monthString+"/"+yearStringCurrent+"]", // pFontHeader); // phrase = new Phrase("+ "+x*days +" // Month",pFontHeader); interval = x; // } table.addCell(phrase); // Catch java.text.parse exception. } catch (java.text.ParseException prs) { prs.printStackTrace(); } } // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Change % (+/-)", pFontHeader); table.addCell(phrase); phrase = new Phrase("Change In Reporting Rate", pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); // table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { double GrandTotal = 0.00; double Over120Total = 0.00; double TurnOver = 0.00; java.lang.Object[] listofAct = this.getListofActivities(); // java.sql.Connection conDb1 = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); System.out.println(listofAct.length); double Over120 = 0.00; for (int i = 0; i < listofAct.length; i++) { double TotalCount = 0.00; table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(1); java.sql.Statement stmta1 = connectDB.createStatement(); java.sql.PreparedStatement pSeta1 = connectDB.prepareStatement( "SELECT count(activity_code) FROM ac_ledger where activity_code = '" + listofAct[i] + "'"); java.sql.PreparedStatement pset22 = connectDB.prepareStatement( "select activity from pb_activity WHERE code = ?"); // < '"+endDate+"'::date // and date > // '"+endDate+"'::date - // 30 group by dealer"); // java.sql.PreparedStatement pset22 = connectDB.prepareStatement("select // description from ac_ledger WHERE activity_code = ?");//< '"+endDate+"'::date and // date > '"+endDate+"'::date - 30 group by dealer"); pset22.setString(1, listofAct[i].toString().toUpperCase()); java.sql.ResultSet rSeta1 = pSeta1.executeQuery(); while (rSeta1.next()) { name = rSeta1.getInt(1); } if (name > 0) { java.sql.ResultSet rset22 = pset22.executeQuery(); while (rset22.next()) { table.getDefaultCell().setColspan(1); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( dbObject.getDBObject(rset22.getObject(1).toString().toUpperCase(), "-"), pFontHeader1); table.addCell(phrase); } java.sql.Statement st2 = connectDB.createStatement(); java.sql.Statement st21 = connectDB.createStatement(); java.sql.Statement st22 = connectDB.createStatement(); java.sql.Statement st23 = connectDB.createStatement(); java.sql.Statement st211 = connectDB.createStatement(); java.sql.Statement st221 = connectDB.createStatement(); java.sql.Statement st231 = connectDB.createStatement(); java.sql.Statement st2A = connectDB.createStatement(); java.sql.Statement st2B = connectDB.createStatement(); java.sql.Statement st2C = connectDB.createStatement(); java.sql.Statement stc = connectDB.createStatement(); System.out.println("Dealer Is : [" + listofAct[i] + "]."); java.sql.PreparedStatement pset1 = connectDB.prepareStatement( "select sum(credit-debit) from ac_ledger WHERE activity_code = ? AND date = '" + rangeDates[rangeDates.length - 1][0] + "'"); // AND '"+rangeDates[rangeDates.length - 1][1]+"'");//< // '"+endDate+"'::date and date > '"+endDate+"'::date - 30 // group by dealer"); pset1.setString(1, listofAct[i].toString()); java.sql.ResultSet rset1 = pset1.executeQuery(); // java.sql.PreparedStatement pset111 = connectDB.prepareStatement("select // sum(credit-debit) from ac_ledger WHERE activity_code = ? AND date < // '"+endDate+"'");//< '"+endDate+"'::date and date > '"+endDate+"'::date - 30 // group by dealer"); // pset111.setString(1,listofAct[i].toString()); // java.sql.ResultSet rset111 = pset111.executeQuery(); // java.sql.Statement st02 = connectDB.createStatement(); // java.sql.PreparedStatement pset112 = connectDB.prepareStatement("select // sum(credit-debit) from ac_ledger WHERE activity_code = ? AND date < // '"+endDate+"'");//< '"+endDate+"'::date and date > '"+endDate+"'::date - 30 // group by dealer"); // pset112.setString(1,listofAct[i].toString()); // java.sql.ResultSet rset112 = pset112.executeQuery(); for (int t = 0; t < rangeDates.length; t++) { java.sql.Statement st01 = connectDB.createStatement(); java.sql.PreparedStatement pset = connectDB.prepareStatement( "select sum(credit-debit) from ac_ledger WHERE activity_code = ? AND date between '" + rangeDates[t][0] + "' AND '" + rangeDates[t][1] + "'"); // < '"+endDate+"'::date and date > '"+endDate+"'::date - 30 // group by dealer"); pset.setString(1, listofAct[i].toString().toUpperCase()); java.sql.ResultSet rset = pset.executeQuery(); while (rset.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(1)), pFontHeader1); table.addCell(phrase); columnTotals[t] = columnTotals[t] + rset.getDouble(1); TotalCount = TotalCount + rset.getDouble(1); TurnOver = rset.getDouble(1); } } // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(java.lang.String.valueOf(TotalCount)), pFontHeader); // table.addCell(phrase); while (rset1.next()) { Over120 = rset1.getDouble(1); if (Over120 > 0) { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency( java.lang.String.valueOf((Over120 / TurnOver) * 100)), pFontHeader); table.addCell(phrase); phrase = new Phrase("+", pFontHeader); table.addCell(phrase); } else { phrase = new Phrase(java.lang.String.valueOf(0.00), pFontHeader); table.addCell(phrase); phrase = new Phrase("", pFontHeader); table.addCell(phrase); } } /* }else{ if (TotalCount <= 0 && Over120 > 0){ phrase = new Phrase(java.lang.String.valueOf((Over120/TurnOver)*100), pFontHeader); table.addCell(phrase); phrase = new Phrase("+", pFontHeader); table.addCell(phrase); }else{ if (TotalCount > 0 && Over120 < 0){ phrase = new Phrase(java.lang.String.valueOf((Over120/TurnOver)*100), pFontHeader); table.addCell(phrase); phrase = new Phrase("-", pFontHeader); table.addCell(phrase); }else{ if (TotalCount > 0 && Over120 == 0){ phrase = new Phrase(java.lang.String.valueOf((Over120/TurnOver)*100), pFontHeader); table.addCell(phrase); phrase = new Phrase("-", pFontHeader); table.addCell(phrase); }else{ if (TotalCount < 0 && Over120 < 0){ phrase = new Phrase(java.lang.String.valueOf((Over120/TurnOver)*100), pFontHeader); table.addCell(phrase); phrase = new Phrase("-", pFontHeader); table.addCell(phrase); }else{ phrase = new Phrase(java.lang.String.valueOf(0.00), pFontHeader); table.addCell(phrase); phrase = new Phrase("", pFontHeader); table.addCell(phrase); } } } } }*/ // } } } table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); // while (rsetTotals.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rsetTotals.getString(1)), // pFontHeader); for (int x = 0; x < rangeDates.length; x++) { // phrase = new Phrase("Current"+2*x,pFontHeader); // table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(columnTotals[x])), pFontHeader); table.addCell(phrase); } phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(Over120Total)), pFontHeader); // table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(OS)), pFontHeader); // table.addCell(phrase); docPdf.add(table); } catch (java.sql.SQLException SqlExec) { SqlExec.printStackTrace(); javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { // Bad javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); try { if (System.getProperty("os.name").equalsIgnoreCase("Linux")) { System.out.println(tempFile); wait_for_Pdf2Show = rt.exec("kghostview " + tempFile + ""); wait_for_Pdf2Show.waitFor(); } else { wait_for_Pdf2Show = rt.exec("c:/Program Files/Adobe/Acrobat 5.0/Reader/AcroRd32.exe " + tempFile); wait_for_Pdf2Show.waitFor(); } } catch (java.lang.InterruptedException intrExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), intrExec.getMessage()); } } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException { WebApplicationContext ctx = WebApplicationContextUtils.getRequiredWebApplicationContext(this.getServletContext()); CourseManager manager = (CourseManager) ctx.getBean("courseManager"); HttpSession session = request.getSession(false); List selectFilterCouList = (List) session.getAttribute("selectFilterCouList"); Date date = new Date(); DateFormat dateFormat = new SimpleDateFormat("yyyy年 MM月 dd日 HH:mm"); String stuTmp[] = new String[selectFilterCouList.size()]; List students = new ArrayList(); for (int i = 0; i < selectFilterCouList.size(); i++) { stuTmp[i] = ((Map) selectFilterCouList.get(i)).get("dtimeOid").toString(); } students = manager.getSeldStuFilterBy(stuTmp, true); Document document = new Document(PageSize.A4, 72, 72, 35, 35); ByteArrayOutputStream ba = new ByteArrayOutputStream(); String year = manager.getNowBy("School_year"); String term = manager.getNowBy("School_term"); // 如果是下學期, 學年要+1 if (Integer.parseInt(term) == 2) { Integer tmpYear = (Integer.parseInt(year) + 1); year = tmpYear.toString(); term = "1"; } else { term = "2"; } try { PdfWriter writer = PdfWriter.getInstance(document, ba); // TODO 路徑 // Image // image=Image.getInstance("http://cap.chit.edu.tw/CIS/pages/images/2002chitWatermark.gif"); // Watermark wamark=new Watermark(image, ((PageSize.A4).width()-image.plainHeight())/2, // ((PageSize.A4).height()-image.plainHeight())/2); // document.add(wamark); Phrase now = doEncode("課程管理系統 " + dateFormat.format(date)); HeaderFooter header = new HeaderFooter(now, false); document.setHeader(header); document.setFooter(header); // Image logo=Image.getInstance("http://192.192.231.32:8080/CIS/pages/images/art.gif"); document.open(); for (int i = 0; i < students.size(); i++) { String buf[] = {((Map) students.get(i)).get("student_no").toString()}; List tmp = manager.getSeldStuFilterBy(buf, false); if (i % 2 != 0) { document.add(new Paragraph(doEncode("\n"))); document.add(new Paragraph(doEncode("\n"))); document.add(new Paragraph(doEncode("\n"))); } document.add(new Paragraph("")); Table table = new Table(6); table.setWidth(100); table.setBorderWidth(0); table.setPadding(5); // table.setSpacing(5); // table.setDefaultHorizontalAlignment(table.ALIGN_CENTER); // table.setDefaultHorizontalAlignment(table.ALIGN_MIDDLE); // table.setDefaultCellBorderColor(new Color(255, 255, 255)); Cell cell = new Cell(); cell.add(doEncode(year)); cell.add(doEncode("學年 第")); cell.add(doEncode(term)); cell.add(doEncode("學期 網路預選失敗通知單")); // cell.addElement(logo); cell.setColspan(6); cell.setHorizontalAlignment(cell.ALIGN_CENTER); cell.setBorderColor(new Color(255, 255, 255)); table.addCell(cell); // ((Map)students.get(i)).get("ClassName2"); cell = new Cell(); // cell.add(doEncode("學生班級: ")); cell.add(doEncode(((Map) students.get(i)).get("ClassName").toString())); cell.add(doEncode("\t學號: ")); cell.add(doEncode(((Map) students.get(i)).get("student_no").toString())); cell.add(doEncode("\t姓名: ")); cell.add(doEncode(((Map) students.get(i)).get("student_name").toString())); cell.setColspan(6); cell.setHorizontalAlignment(cell.ALIGN_LEFT); cell.setBorderColor(new Color(255, 255, 255)); table.addCell(cell); cell = new Cell(); cell.add(doEncode("您在第一階段網路選課所選的下列課程並未成功,請按照規定時間進行網路第二階段選課,以免影響您的權益。")); cell.setColspan(6); cell.setHorizontalAlignment(cell.ALIGN_LEFT); cell.setBorderColor(new Color(255, 255, 255)); table.addCell(cell); document.add(table); float[] widths = {0.2f, 0.3f, 0.1f, 0.1f, 0.1f, 0.2f}; PdfPTable tables = new PdfPTable(widths); tables.setWidthPercentage(100); PdfPCell cells = new PdfPCell(doEncode("開課班級")); tables.addCell(cells); cells = new PdfPCell(doEncode("科目名稱")); tables.addCell(cells); cells = new PdfPCell(doEncode("選別")); tables.addCell(cells); cells = new PdfPCell(doEncode("學分")); tables.addCell(cells); cells = new PdfPCell(doEncode("時數")); tables.addCell(cells); cells = new PdfPCell(doEncode("上課時間")); tables.addCell(cells); for (int j = 0; j < tmp.size(); j++) { cells = new PdfPCell(); cells = new PdfPCell(doEncode(((Map) tmp.get(j)).get("ClassName2").toString())); tables.addCell(cells); cells = new PdfPCell(doEncode(((Map) tmp.get(j)).get("chi_name").toString())); tables.addCell(cells); cells = new PdfPCell(doEncode(getOpt(((Map) tmp.get(j)).get("opt").toString()))); tables.addCell(cells); cells = new PdfPCell(doEncode(((Map) tmp.get(j)).get("credit").toString())); tables.addCell(cells); cells = new PdfPCell(doEncode(((Map) tmp.get(j)).get("thour").toString())); tables.addCell(cells); List dcTmp = manager.getDtimeClassListForOpenCourse(((Map) tmp.get(j)).get("dtimeOid").toString()); StringBuffer strBuf = new StringBuffer(); DtimeClass dtimeClass; for (int x = 0; x < dcTmp.size(); x++) { dtimeClass = (DtimeClass) dcTmp.get(x); strBuf.append("週" + dtimeClass.getWeek() + ":"); strBuf.append(dtimeClass.getBegin() + "~" + dtimeClass.getEnd() + " "); } cells = new PdfPCell(doEncode(strBuf.toString())); tables.addCell(cells); } for (int k = 13; k > tmp.size(); k--) { cells = new PdfPCell(doEncode("\t")); tables.addCell(cells); cells = new PdfPCell(doEncode("\t")); tables.addCell(cells); cells = new PdfPCell(doEncode("\t")); tables.addCell(cells); cells = new PdfPCell(doEncode("\t")); tables.addCell(cells); cells = new PdfPCell(doEncode("\t")); tables.addCell(cells); cells = new PdfPCell(doEncode("\t")); tables.addCell(cells); } document.add(tables); if (i % 2 == 1) { document.newPage(); } } } catch (DocumentException de) { de.printStackTrace(); System.err.println("A Document error:" + de.getMessage()); } document.close(); response.setContentType("application/pdf"); response.setContentLength(ba.size()); ServletOutputStream out = response.getOutputStream(); ba.writeTo(out); ba.close(); out.flush(); out.close(); }
public void generatePdf() { java.sql.ResultSet rsetTotals1 = null; java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; try { java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) compName = rset2.getObject(1).toString(); while (rset4.next()) date = rset4.getObject(1).toString(); com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName, pFontHeader), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Un Finalised Invoices List - Page: ", pFontHeader1), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); double balance = 0.00; try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(4); int headerwidths[] = {15, 30, 25, 15}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(2); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(2); Phrase phrase = new Phrase( "In Patient Unfinalised Inv : ", com.lowagie.text.FontFactory.getFont(FontFactory.HELVETICA_BOLD, 10)); table.addCell(phrase); table.getDefaultCell().setColspan(2); phrase = new Phrase( "Printed On : " + date, com.lowagie.text.FontFactory.getFont(FontFactory.HELVETICA_BOLD, 10)); table.addCell(phrase); table.getDefaultCell().setColspan(1); // phrase = new Phrase("Name", pFontHeader); // table.addCell(phrase); phrase = new Phrase("Date", pFontHeader); table.addCell(phrase); phrase = new Phrase("No.", pFontHeader); table.addCell(phrase); phrase = new Phrase("Name", pFontHeader); table.addCell(phrase); phrase = new Phrase("Amount", pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { // java.lang.Object[] listofAct = this.getListofActivities(); java.lang.Object[] listofAct1 = this.getListofActivities1(); java.sql.Statement st21 = connectDB.createStatement(); // java.sql.ResultSet rsetTotals = st21.executeQuery("SELECT sum(amount) from // op_unfinalised_inv where trans_date BETWEEN '"+beginDate+"' AND '"+endDate+"'"); // java.sql.Connection conDb1 = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); // System.out.println(listofAct.length); java.sql.Statement st2 = connectDB.createStatement(); java.sql.Statement st22 = connectDB.createStatement(); for (int k = 0; k < listofAct1.length; k++) { java.sql.ResultSet rset1 = st2.executeQuery( "SELECT patient_no,sum(debit-credit) from hp_patient_card WHERE patient_no ILIKE '" + listofAct1[k].toString() + "%' and invoice_no NOT iLike 'O%' OR invoice_no NOT iLike 'I%' AND date BETWEEN '" + beginDate + "' AND '" + endDate + "' group by patient_no"); java.sql.ResultSet rset2 = st22.executeQuery( "SELECT patient_name from hp_admission WHERE patient_no ILIKE '" + listofAct1[k].toString() + "%'"); /* table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(" ",pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // phrase = new Phrase(listofAct1[k].toString(),pFontHeader); // table.addCell(phrase); phrase = new Phrase("",pFontHeader); table.addCell(phrase); */ while (rset1.next()) { while (rset2.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(" ", pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset1.getObject(1).toString(), pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset2.getString(1), pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset1.getString(2)), pFontHeader1); table.addCell(phrase); balance = balance + rset1.getDouble(2); } } } // while (rsetTotals.next()) { table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rsetTotals.getString(1)), // pFontHeader); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(balance)), pFontHeader); table.addCell(phrase); // } // } docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); try { if (System.getProperty("os.name").equalsIgnoreCase("Linux")) { System.out.println(tempFile); wait_for_Pdf2Show = rt.exec("kghostview " + tempFile + ""); wait_for_Pdf2Show.waitFor(); } else { wait_for_Pdf2Show = rt.exec("c:/Program Files/Adobe/Acrobat 5.0/Reader/AcroRd32.exe " + tempFile); wait_for_Pdf2Show.waitFor(); } } catch (java.lang.InterruptedException intrExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), intrExec.getMessage()); } } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf(java.lang.String memNo) { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; /* try { java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while(rset2.next()) compName = rset2.getObject(1).toString(); while(rset4.next()) date = rset4.getObject(1).toString(); */ com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("FINAL VOUCHER"), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setRight(5); docPdf.setHeader(headerFoter); docPdf.open(); try { java.lang.Object listofStaffNos[] = this.getListofStaffNos(); for (int j = 0; j < listofStaffNos.length; j++) { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(6); int headerwidths[] = {25, 25, 20, 15, 15, 15}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(6); Phrase phrase = new Phrase(); // table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { java.sql.Statement st = connectDB.createStatement(); java.sql.Statement st1 = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.Statement st5 = connectDB.createStatement(); java.sql.ResultSet rset3 = st3.executeQuery( "select hospital_name,postal_code||' '||box_no||' '||town,main_telno||' '||other_telno,initcap(street),main_faxno,email,website,room_no from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("select dealer,description from ac.cash_book"); // java.sql.ResultSet rset = st.executeQuery("select DISTINCT member_code, // member_name,date from shares_transactions order by member_code"); java.sql.ResultSet rset = st.executeQuery( "select patient_no,initcap(first_name||' '||second_name||' '||last_name),address,residence,tel_no from hp_patient_register where patient_no = '" + listofStaffNos[j] + "'"); java.sql.ResultSet rset5 = st5.executeQuery( "select staff_no,staff_name from hp_schemestaff sh, hp_patient_card pc where pc.patient_no = '" + listofStaffNos[j] + "' AND pc.scheme_staff_no = sh.staff_no"); java.sql.ResultSet rset1 = st1.executeQuery( "select date::date,initcap(service) as service,dosage,reference,debit from hp_patient_card where patient_no = '" + listofStaffNos[j] + "' AND paid = true order by date"); java.sql.ResultSet rsetTotals = st2.executeQuery( "select sum(debit) from hp_patient_card where patient_no = '" + listofStaffNos[j] + "' AND paid = true"); while (rset3.next()) { table.getDefaultCell().setColspan(6); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); phrase = new Phrase(rset3.getObject(1).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(6); table.getDefaultCell().setBorderColor(java.awt.Color.white); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Address:" + "\t" + rset3.getObject(2).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Tel:" + "\t" + rset3.getObject(3).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Fax:" + "\t" + rset3.getObject(5).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setBorderColor(java.awt.Color.white); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Email:" + "\t" + rset3.getObject(6).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Website:" + "\t" + rset3.getObject(7).toString(), pFontHeader); table.addCell(phrase); /// table.addCell(" "); } table.getDefaultCell().setColspan(6); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); phrase = new Phrase("Voucher", pFontHeader1); table.addCell(phrase); while (rset4.next()) table.getDefaultCell().setColspan(6); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset4.getObject(1).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Address: " + rset4.getObject(2).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Tel: " + rset4.getObject(3).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Fax: " + rset4.getObject(4).toString(), pFontHeader); table.addCell(phrase); /* table.getDefaultCell().setBorderColor(java.awt.Color.white); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Email:"+"\t"+rset3.getObject(6).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Website:"+"\t" +rset3.getObject(7).toString(), pFontHeader); table.addCell(phrase); /// table.addCell(" "); */ while (rset5.next()) { table.getDefaultCell().setColspan(6); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Member No. " + rset5.getObject(1).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(6); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Member Name " + rset5.getObject(2).toString(), pFontHeader); table.addCell(phrase); } while (rset.next()) { table.getDefaultCell().setColspan(6); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Patient No. " + rset.getObject(1).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(6); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Patient Name " + rset.getObject(2).toString(), pFontHeader); table.addCell(phrase); /* table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Address "+rset.getObject(3).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Town "+rset.getObject(4).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("TEl No. "+rset.getObject(5).toString(), pFontHeader); table.addCell(phrase); */ } table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorderWidth(Rectangle.TOP); table.getDefaultCell().setColspan(1); phrase = new Phrase("Date", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(2); phrase = new Phrase("Description", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(1); phrase = new Phrase("Qty", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(1); phrase = new Phrase("Ref", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setColspan(1); phrase = new Phrase("Amount KShs", pFontHeader1); table.addCell(phrase); while (rset1.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset1.getObject(1).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset1.getObject(2).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset1.getObject(3).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset1.getObject(4).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset1.getString(5)), pFontHeader); table.addCell(phrase); } table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); while (rsetTotals.next()) { table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rsetTotals.getString(1)), pFontHeader); table.addCell(phrase); // phrase = new Phrase(" "); } docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } // } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); try { if (System.getProperty("os.name").equalsIgnoreCase("Linux")) { System.out.println(tempFile); wait_for_Pdf2Show = rt.exec("kghostview " + tempFile + ""); wait_for_Pdf2Show.waitFor(); } else { wait_for_Pdf2Show = rt.exec("c:/Program Files/Adobe/Acrobat 5.0/Reader/AcroRd32.exe " + tempFile); wait_for_Pdf2Show.waitFor(); } } catch (java.lang.InterruptedException intrExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), intrExec.getMessage()); } } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.util.Calendar calLast = java.util.Calendar.getInstance(); calLast.roll(java.util.Calendar.YEAR, -1); dateLastyear = calLast.getTime().toString(); System.out.println(this.dateLastyear); java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; try { // java.sql.Connection conDb = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName, pFontHeader), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("CORPORATION TAX - Page: ", pFontHeader), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(4); int headerwidths[] = {40, 40, 20, 20}; table.setWidths(headerwidths); table.setWidthPercentage((100)); Phrase phrase = new Phrase(""); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(2); try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); java.util.Date endDate1 = dateFormat.parse(endDate.toLocaleString()); // dateInstance.toLocaleString()); System.out.println("" + endDate1); // phrase = new Phrase(bank +" Report: " +dateFormat.format(formattedDate), // pFontHeader); // table.addCell(phrase); phrase = new Phrase( "Tax Computation : ".toUpperCase() + dateFormat.format(endDate1), pFontHeader); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Printed on : " + date, pFontHeader1); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { // java.lang.Object[] listofAct = this.getListofActivities(); java.lang.Object[] listofAct1 = this.getListofActivities1(); // java.sql.Connection conDb1 = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); // System.out.println(listofAct.length); java.sql.Statement st4 = connectDB.createStatement(); java.sql.PreparedStatement pstmt31w = connectDB.prepareStatement( "delete from ac_corporation_tax WHERE approved = false"); pstmt31w.executeUpdate(); java.sql.Statement st13 = connectDB.createStatement(); java.sql.ResultSet rset13 = st13.executeQuery(" select sum(amount) from pl_account_view"); // rsetTotals1 = st3.executeQuery("SELECT SUM(debit),SUM(credit) from"); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(4); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.addCell(" "); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // phrase = new Phrase(rset3.getObject(1).toString().toUpperCase(), pFontHeader); phrase = new Phrase("NET INCOME", pFontHeader1); table.addCell(phrase); // } while (rset13.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset13.getString(1)), pFontHeader1); table.addCell(phrase); pl = rset13.getDouble(1); java.sql.PreparedStatement pstmtC = connectDB.prepareStatement( "insert into ac_corporation_tax values(?, ?, ?, ?, ?,?)"); pstmtC.setObject(1, "" + endDate + ""); pstmtC.setObject(2, "NET INCOME"); pstmtC.setObject(3, "Income"); if (pl < 0) { pstmtC.setDouble(5, pl * -1); } else { pstmtC.setDouble(5, pl); } pstmtC.setDouble(4, 0.00); pstmtC.setDouble(6, 0.00); pstmtC.executeUpdate(); } table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(4); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.addCell(" "); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(4); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Add/Less: Disallowable Items ".toUpperCase(), pFontHeader1); table.addCell(phrase); // table.addCell("Add/Less: Disallowable Items ".toUpperCase(), pFontHeader1); for (int i = 0; i < listofAct1.length; i++) { java.sql.Statement st6 = connectDB.createStatement(); java.sql.Statement st7 = connectDB.createStatement(); // java.sql.Statement st8 = connectDB.createStatement(); java.sql.ResultSet rset7 = st7.executeQuery( "select description from ac_corporate_disallowables where gl_code = '" + listofAct1[i].toString() + "'"); java.sql.Statement st8 = connectDB.createStatement(); java.sql.ResultSet rset8 = st8.executeQuery( "select SUM(debit-credit) from ac_ledger where activity_code = '" + listofAct1[i].toString() + "' and date between '" + beginDate + "' AND '" + endDate + "'"); // java.sql.ResultSet rset8 = st8.executeQuery("select SUM(debit-credit) from // ac_ledger where activity_code = '"+listofAct1[i].toString()+"' and date between // '"+beginDate+"' AND '"+endDate+"'"); // rsetTotals1 = st3.executeQuery("SELECT SUM(debit),SUM(credit) from"); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.addCell(" "); while (rset7.next()) { while (rset8.next()) { table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset7.getObject(1).toString().toUpperCase(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset8.getString(1)), pFontHeader1); table.addCell(phrase); equity = equity + rset8.getDouble(1); java.sql.PreparedStatement pstmt111 = connectDB.prepareStatement( "insert into ac_corporation_tax values(?, ?, ?, ?, ?,?)"); pstmt111.setObject(1, "" + endDate + ""); pstmt111.setObject(2, rset7.getObject(1).toString()); pstmt111.setObject(3, "Disallowable"); pstmt111.setDouble(4, rset8.getDouble(1)); pstmt111.setDouble(5, 0.00); pstmt111.setDouble(6, 0.00); pstmt111.executeUpdate(); } } phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(equity)), pFontHeader); table.addCell(phrase); } table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(4); // table.addCell("Add/Less: Allowable Items "); phrase = new Phrase("Add/Less: Allowable Items ".toUpperCase(), pFontHeader1); table.addCell(phrase); // for (int i = 0; i < listofAct1.length; i++) { java.sql.Statement st6 = connectDB.createStatement(); java.sql.Statement st7 = connectDB.createStatement(); java.sql.Statement st83 = connectDB.createStatement(); java.sql.ResultSet rset83 = st83.executeQuery("select sum(investment_allow) from ac_asset_allocation"); // rsetTotals1 = st3.executeQuery("SELECT SUM(debit),SUM(credit) from"); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); // table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); while (rset83.next()) { table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(" ".toUpperCase(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Investment Allowance".toUpperCase(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset83.getString(1)), pFontHeader1); table.addCell(phrase); inv = inv + rset83.getDouble(1); phrase = new Phrase(" ".toUpperCase(), pFontHeader); table.addCell(phrase); java.sql.PreparedStatement pstmt1A = connectDB.prepareStatement( "insert into ac_corporation_tax values(?, ?, ?, ?, ?,?)"); pstmt1A.setObject(1, "" + endDate + ""); pstmt1A.setObject(2, "Investment Allowance"); pstmt1A.setObject(3, "Allowable"); pstmt1A.setDouble(5, inv); pstmt1A.setDouble(4, 0.00); pstmt1A.setDouble(6, 0.00); pstmt1A.executeUpdate(); } inv = inv; java.lang.Object[] listofAct2 = this.getListofActivities2(); for (int y = 0; y < listofAct2.length; y++) { java.sql.Statement st81 = connectDB.createStatement(); java.sql.ResultSet rset81 = st81.executeQuery( "select sum(wear_tear_allow*depreciation_rate/100) from ac_asset_allocation where gl_code = '" + listofAct2[y].toString() + "'"); while (rset81.next()) { table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setColspan(1); table.getDefaultCell().setColspan(1); wta = wta = +rset81.getDouble(1); // table.addCell(phrase); } Total = Total + wta; } table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(" ".toUpperCase(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Wear & Tear Allowance".toUpperCase(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(Total)), pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(inv + Total)), pFontHeader); table.addCell(phrase); java.sql.PreparedStatement pstmtB1 = connectDB.prepareStatement( "insert into ac_corporation_tax values(?, ?, ?, ?, ?,?)"); pstmtB1.setObject(1, "" + endDate + ""); pstmtB1.setObject(2, "Wear & Tear Allowance"); pstmtB1.setObject(3, "Allowable"); pstmtB1.setDouble(5, Total); pstmtB1.setDouble(4, 0.00); pstmtB1.setDouble(6, 0.00); pstmtB1.executeUpdate(); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("ADJUSTED TAXABLE INCOME".toUpperCase(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); if (pl < 0) { table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency( java.lang.String.valueOf((inv + Total + pl) - (-equity))), pFontHeader); table.addCell(phrase); taxableIncome = (inv + Total + pl) - (-equity); } else { table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf((inv + Total + pl) - equity)), pFontHeader); table.addCell(phrase); taxableIncome = (inv + Total + pl) - (equity); } java.sql.Statement st8111 = connectDB.createStatement(); java.sql.ResultSet rset8111 = st8111.executeQuery( "select count(debit) from ac_corporation_tax where category Ilike 'Tax Loss BFWD'"); while (rset8111.next()) { taxbf = rset8111.getInt(1); } if (taxbf > 0) { java.sql.Statement st811 = connectDB.createStatement(); java.sql.ResultSet rset811 = st811.executeQuery( "select sum(debit-tax_divided) as debit from ac_corporation_tax WHERE category Ilike 'Tax loss BFWD'"); while (rset811.next()) { table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("TAX LOSSES BFWD".toUpperCase(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setColspan(1); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset811.getString(1)), pFontHeader1); table.addCell(phrase); loss = rset811.getDouble(1); } } else { table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("TAX LOSSES BFWD".toUpperCase(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(0.00)), pFontHeader); table.addCell(phrase); loss = 0.00; } table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("TAXABLE INCOME".toUpperCase(), pFontHeader1); table.addCell(phrase); taxable = taxableIncome - loss; table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(taxable)), pFontHeader); table.addCell(phrase); java.sql.Statement st8112 = connectDB.createStatement(); java.sql.ResultSet rset8112 = st8112.executeQuery( " select ps.rate from pb_statutory ps, pb_activity pa where ps.gl_code = pa.code and pa.activity_category ilike 'CTX'"); while (rset8112.next()) { table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("TAX DUE".toUpperCase(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setColspan(1); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rset8112.getString(1)), // pFontHeader1); taxRate = rset8112.getDouble(1); } taxDue = taxable * taxRate / 100; if (taxDue > 0) { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(taxDue)), pFontHeader); table.addCell(phrase); } else { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(0.00)), pFontHeader); table.addCell(phrase); } java.sql.PreparedStatement pstmt1 = connectDB.prepareStatement( "insert into ac_corporation_tax values(?, ?, ?, ?, ?,?)"); pstmt1.setObject(1, "" + endDate + ""); if (taxDue < 0) { pstmt1.setObject(2, "Tax Loss BFWD"); pstmt1.setObject(3, "Tax Loss BFWD"); pstmt1.setDouble(4, taxable * -1); pstmt1.setDouble(6, 0.00); } else { pstmt1.setObject(2, "Tax For The Year"); pstmt1.setObject(3, "Tax Due"); pstmt1.setDouble(4, 0.00); pstmt1.setDouble(6, taxDue); } pstmt1.setDouble(5, 0.00); pstmt1.executeUpdate(); docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); try { java.lang.Class.forName("org.postgresql.Driver"); } catch (java.lang.ClassNotFoundException cnfExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), cnfExec.getMessage()); } double osBalancet = 0.00; String compName = null; String date = null; double osBalancebf = 0.00; double price = 0.00; double qty = 0.00; try { // java.sql.Connection conDb = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery( "SELECT TO_CHAR(current_timestamp(0),'FMDay FMDD/ MM/ YY HH12:MI')"); while (rset2.next()) { compName = rset2.getObject(1).toString(); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName + "", pFontHeader), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Stocks By Dep. Cost - Page: ", pFontHeader), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(5); int headerwidths[] = {25, 10, 10, 15, 10}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(2); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(5); Phrase phrase = new Phrase("", pFontHeader); try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); java.util.Date endDate1 = dateFormat.parse(endDate.toLocaleString()); // dateInstance.toLocaleString()); java.util.Date endDate11 = dateFormat.parse(beginDate.toLocaleString()); // dateInstance.toLocaleString()); System.out.println("" + endDate1); // phrase = new Phrase(bank +" Report: " +dateFormat.format(formattedDate), // pFontHeader); // table.addCell(phrase); table.getDefaultCell().setColspan(3); phrase = new Phrase( "Items cost Report " + StoreName + ": Period : From " + dateFormat.format(endDate11) + " To " + dateFormat.format(endDate1), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Printed On : " + date, pFontHeader); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } // Phrase phrase = new Phrase("Patients List As At:" +endDate, pFontHeader); // table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(1); // table.getDefaultCell().setBackgroundColor(java.awt.Color.LIGHT_GRAY); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); phrase = new Phrase("ITEM", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Units", pFontHeader); table.addCell(phrase); phrase = new Phrase("Bp", pFontHeader); table.addCell(phrase); phrase = new Phrase("qty", pFontHeader); table.addCell(phrase); phrase = new Phrase("Cost", pFontHeader); table.addCell(phrase); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase("AMOUNT",pFontHeader); // table.addCell(phrase); // phrase = new Phrase("TOTAL KShs",pFontHeader); // table.addCell(phrase); // phrase = new Phrase("PROFIT",pFontHeader); // table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { java.lang.Object[] listofAct = this.getListofActivities(); // java.sql.Connection conDb1 = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); System.out.println(listofAct.length); // java.sql.Statement pSet1 = connectDB.createStatement(); java.sql.Statement st = connectDB.createStatement(); // java.sql.ResultSet rsetTotals = st.executeQuery("select sum((ph.quantity * // st.transfer_price)::numeric(10,2)), sum(amount)::numeric(10,2),sum(amount - // ph.quantity * st.transfer_price)::numeric(10,2) from hp_pharmacy ph,st_stock_prices // st WHERE st.department = 'Pharmacy' AND ph.date_prescribed BETWEEN '"+beginDate+"' // AND '"+endDate+"' AND ph.description = st.product"); for (int i = 0; i < listofAct.length; i++) { System.out.println("item" + listofAct[i]); /* double opStock = 0.00; double supplies = 0.00; double sales = 0.00; double closing = 0.00; */ java.sql.Statement st1 = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st21 = connectDB.createStatement(); java.sql.Statement st31 = connectDB.createStatement(); java.sql.Statement st41 = connectDB.createStatement(); java.sql.Statement st32 = connectDB.createStatement(); java.sql.Statement st2e = connectDB.createStatement(); java.sql.ResultSet rset = st21.executeQuery( "select sp.product,sp.units,sp.transfer_price from st_stock_prices sp where sp.product ILIKE '" + listofAct[i] + "%' AND sp.department ILIKE '" + StoreName + "%'"); java.sql.ResultSet rset31 = st31.executeQuery( "select SUM(ph.quantity) from hp_pharmacy ph where ph.description ILIKE '" + listofAct[i] + "%' AND ph.main_service ILIKE '" + StoreName + "%' and ph.date_prescribed BETWEEN '" + beginDate + "' AND '" + endDate + "'"); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // phrase = new Phrase(dbObject.getDBObject(rset.getObject(1), "-"), pFontHeader1); table.getDefaultCell().setColspan(1); phrase = new Phrase(listofAct[i].toString().toUpperCase(), pFontHeader1); table.addCell(phrase); while (rset.next()) { table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(2), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(3)), pFontHeader1); price = rset.getDouble(3); table.addCell(phrase); } while (rset31.next()) { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset31.getString(1)), pFontHeader1); qty = rset31.getDouble(1); table.addCell(phrase); osBalancebf = qty * price; phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalancebf)), pFontHeader); osBalancet = osBalancebf + osBalancet; table.addCell(phrase); } } table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalancet)), pFontHeader); table.addCell(phrase); docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } try { if (System.getProperty("os.name").equalsIgnoreCase("Linux")) { System.out.println(tempFile); wait_for_Pdf2Show = rt.exec("kghostview " + tempFile + ""); wait_for_Pdf2Show.waitFor(); } else { wait_for_Pdf2Show = rt.exec("c:/Program Files/Adobe/Acrobat 5.0/Reader/AcroRd32.exe " + tempFile); wait_for_Pdf2Show.waitFor(); } } catch (java.lang.InterruptedException intrExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), intrExec.getMessage()); } } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.lang.Object[][] ageingDates = ageingSeries.getAgeingDateSeries(); ageingDates = ageingSeries.getAgeingDateSeries(); double columnTotals[] = new double[ageingDates.length]; java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; // com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); com.lowagie.text.Document docPdf = new com.lowagie.text.Document(PageSize.A4.rotate()); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; try { // java.sql.Connection conDb = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/medic","postgres","pilsiner"); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) compName = rset2.getObject(1).toString(); while (rset4.next()) date = rset4.getObject(1).toString(); com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName + ""), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Extendend Trial Balance - Page: ", pFontHeader), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(8); int headerwidths[] = {8, 20, 12, 12, 12, 12, 12, 12}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(3); table.getDefaultCell().setBorder(Rectangle.BOTTOM); Phrase phrase = new Phrase("", pFontHeader); try { double GrandTotal = 0.00; double Over120Total = 0.00; java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); java.util.Date endDate1 = dateFormat.parse(endDate.toLocaleString()); // dateInstance.toLocaleString()); java.util.Date endDate11 = dateFormat.parse(beginDate.toLocaleString()); // dateInstance.toLocaleString()); System.out.println("" + endDate1); // phrase = new Phrase(bank +" Report: " +dateFormat.format(formattedDate), // pFontHeader); // table.addCell(phrase); table.getDefaultCell().setColspan(5); phrase = new Phrase( "Extended Trial Balance : As at " + dateFormat.format(endDate1), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Printed On :" + date, pFontHeader); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } // Phrase phrase = new Phrase("Patients List As At:" +endDate, pFontHeader); // table.addCell(phrase); try { java.text.SimpleDateFormat dateFormat = new java.text.SimpleDateFormat("EEE MMM dd HH:mm:ss zzz yyyy"); com.afrisoftech.lib.DateFormatter dateFormatter = new com.afrisoftech.lib.DateFormatter( dateFormat.parse(endDate.toString().trim()), "MMMM yyyy"); java.lang.String monthString = dateFormatter.getDateString(); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table .getDefaultCell() .setBorder(Rectangle.BOTTOM | Rectangle.TOP | Rectangle.LEFT | Rectangle.RIGHT); table.getDefaultCell().setColspan(2); phrase = new Phrase(" ", pFontHeader); // table.addCell(phrase); phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); phrase = new Phrase("Prior Balances", pFontHeader); table.addCell(phrase); phrase = new Phrase(monthString + " Movement", pFontHeader); table.addCell(phrase); phrase = new Phrase("Ending Balance", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); phrase = new Phrase("GL. Code", pFontHeader); table.addCell(phrase); phrase = new Phrase("Description", pFontHeader); table.addCell(phrase); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Debit", pFontHeader); table.addCell(phrase); phrase = new Phrase("Credit", pFontHeader); table.addCell(phrase); phrase = new Phrase("Debit", pFontHeader); table.addCell(phrase); phrase = new Phrase("Credit", pFontHeader); table.addCell(phrase); phrase = new Phrase("Debit", pFontHeader); table.addCell(phrase); phrase = new Phrase("Credit", pFontHeader); table.addCell(phrase); } catch (java.text.ParseException prs) { prs.printStackTrace(); } table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); // table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); java.lang.Object[] listofAct = this.getListofActivities(); // for (int j = 0; j < listofStaffNos.length; j++) { try { int name = 0; double TurnOver = 0.00; double Over120 = 0.00; double TotalCount = 0.00; double current = 0.00; for (int i = 0; i < listofAct.length; i++) { java.sql.Statement stmta1 = connectDB.createStatement(); java.sql.PreparedStatement pSeta1 = connectDB.prepareStatement( "SELECT count(code) FROM ac_trial_balance where code = '" + listofAct[i] + "'"); java.sql.ResultSet rSeta1 = pSeta1.executeQuery(); while (rSeta1.next()) { name = rSeta1.getInt(1); } table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); if (name > 0) { java.sql.PreparedStatement pset22 = connectDB.prepareStatement( "select distinct code,initcap(activity) from pb_activity WHERE code = ? GROUP BY code,activity"); // < '"+endDate+"'::date and date > '"+endDate+"'::date - 30 group by dealer"); pset22.setString(1, listofAct[i].toString()); java.sql.ResultSet rset22 = pset22.executeQuery(); while (rset22.next()) { table.getDefaultCell().setColspan(1); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( dbObject.getDBObject(rset22.getObject(1).toString(), "-"), pFontHeader1); table.addCell(phrase); phrase = new Phrase( dbObject.getDBObject(rset22.getObject(2).toString(), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // for (int t = ageingDates.length - 1; t >= 0; t--) { double amount1 = 0.00; double amounta = 0.00; double amount1a = 0.00; for (int t = 0; t < ageingDates.length; t++) { double amount = 0.00; double amount1b = 0.00; System.out.println("Checking dates : " + ageingDates[t][1].toString()); java.sql.Statement st01 = connectDB.createStatement(); // java.sql.PreparedStatement pset = connectDB.prepareStatement("select // sum(mtd_debit-mtd_credit) from ac_trial_balance WHERE code = ? AND date // between '"+ageingDates[t][0]+"' AND '"+ageingDates[t][1]+"'"); java.sql.PreparedStatement pset = connectDB.prepareStatement( "select sum(mtd_debit-mtd_credit) from ac_trial_balance WHERE code = ? AND date <= '" + ageingDates[t][1] + "'"); pset.setString(1, listofAct[i].toString().toUpperCase()); java.sql.ResultSet rset = pset.executeQuery(); while (rset.next()) { amount = rset.getDouble(1); columnTotals[t] = columnTotals[t] + amount; } if (t == 0) { if (amount > 0) { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(amount)), pFontHeader1); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(0.00)), pFontHeader1); table.addCell(phrase); totalDebits = totalDebits + amount; amount1 = amount; } else { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(0.00)), pFontHeader1); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(amount * -1)), pFontHeader1); table.addCell(phrase); totalCredits = totalCredits + (amount * -1); amount1 = amount; } } else { java.sql.PreparedStatement pset1 = connectDB.prepareStatement( "select sum(mtd_debit),sum(mtd_credit) from ac_trial_balance WHERE code = ? AND date between '" + ageingDates[t][0] + "' AND '" + ageingDates[t][1] + "'"); pset1.setString(1, listofAct[i].toString().toUpperCase()); java.sql.ResultSet rset1 = pset1.executeQuery(); while (rset1.next()) { amount = rset1.getDouble(1); amount1b = rset1.getDouble(2); columnTotals[t] = columnTotals[t] + amount; } // if (amount > 0){ phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(amount)), pFontHeader1); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(amount1b)), pFontHeader1); table.addCell(phrase); totalDebits1 = totalDebits1 + amount; totalCredits1 = totalCredits1 + amount1b; amounta = amount - amount1b; /* }else{ phrase = new Phrase(new com.afrisoftech.sys.Format2Currency().Format2Currency(java.lang.String.valueOf(0.00)),pFontHeader1); table.addCell(phrase); phrase = new Phrase(new com.afrisoftech.sys.Format2Currency().Format2Currency(java.lang.String.valueOf(amount*-1)),pFontHeader1); table.addCell(phrase); totalCredits1 = totalCredits1 + (amount*-1); amounta = amount; }*/ } } balance = amounta + amount1; table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); if (balance > 0) { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(balance)), pFontHeader1); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(0.00)), pFontHeader1); table.addCell(phrase); totalDebits11 = totalDebits11 + balance; } else { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(0.00)), pFontHeader1); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(balance * -1)), pFontHeader1); table.addCell(phrase); totalCredits11 = totalCredits11 + balance; } } } } // table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); // table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); // while (rsetTotals.next()) { table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // for (int x = ageingDates.length - 1; x >= 0; x--) { for (int t = 0; t < ageingDates.length; t++) { if (t == 0) { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(totalDebits)), pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(totalCredits)), pFontHeader); table.addCell(phrase); } else { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(totalDebits1)), pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(totalCredits1)), pFontHeader); table.addCell(phrase); // totalDebits = columnTotals[x] + columnTotals1[x]; } } /* phrase = new Phrase(new com.afrisoftech.sys.Format2Currency().Format2Currency(java.lang.String.valueOf(totalDebits1+totalDebits-)), pFontHeader); table.addCell(phrase); phrase = new Phrase(new com.afrisoftech.sys.Format2Currency().Format2Currency(java.lang.String.valueOf(totalCredits1+totalCredits)), pFontHeader); table.addCell(phrase);*/ phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(totalDebits11)), pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(totalCredits11 * -1)), pFontHeader); table.addCell(phrase); docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); try { if (System.getProperty("os.name").equalsIgnoreCase("Linux")) { System.out.println(tempFile); wait_for_Pdf2Show = rt.exec("xpdf " + tempFile + ""); wait_for_Pdf2Show.waitFor(); } else { wait_for_Pdf2Show = rt.exec("c:/Program Files/Adobe/Acrobat 5.0/Reader/AcroRd32.exe " + tempFile); wait_for_Pdf2Show.waitFor(); } } catch (java.lang.InterruptedException intrExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), intrExec.getMessage()); } } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); /* try { java.lang.Class.forName("org.postgresql.Driver"); } catch(java.lang.ClassNotFoundException cnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), cnfExec.getMessage()); } */ String compName = null; String date = null; try { java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) compName = rset2.getObject(1).toString(); while (rset4.next()) date = rset4.getObject(1).toString(); com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase( "" + compName + " Printed On: " + date + ""), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Dept - Page: "), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(4); int headerwidths[] = { 20, 10, 40, 30, }; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(2); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(4); Phrase phrase; try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.LONG); // MEDIUM); java.util.Date formattedDate = dateFormat.parse(endDate); // dateInstance.toLocaleString()); java.util.Date formattedDate1 = dateFormat.parse(beginDate); phrase = new Phrase( bank + " Gross Pay " + dateFormat.format(formattedDate) + " --" + dateFormat.format(formattedDate), pFontHeader); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } table.getDefaultCell().setColspan(1); // table.getDefaultCell().setBackgroundColor(java.awt.Color.LIGHT_GRAY); phrase = new Phrase("No", pFontHeader); table.addCell(phrase); phrase = new Phrase("Staff No", pFontHeader); table.addCell(phrase); phrase = new Phrase("Staff Name", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Gross Pay", pFontHeader); table.addCell(phrase); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); // table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); double balance = 0.00; try { java.sql.Statement st = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); // java.sql.ResultSet rset11 = st22.executeQuery("SELECT sum(total_gross_pay) from // tax_card WHERE AND date BETWEEN '"+beginDate+"' AND '"+endDate+"'"); java.sql.ResultSet rset = st.executeQuery( "select tc.staff_no,upper(mf.first_name||' '||mf.middle_name),sum(tc.amount) from posting tc,master_file mf where tc.staff_no =mf.employee_no AND tc.date BETWEEN '" + beginDate + "' AND '" + endDate + "' AND mf.department ILIKE '" + bank + "%' and tc.allowance_deduction ilike 'Earn%' group by tc.staff_no,mf.first_name||' '||mf.middle_name,mf.department order by tc.staff_no"); // tn,debit_note db WHERE tn.policy_no != '' and tn.policy_no = db.policy_no GROUP BY tn.policy_no,db.policy_class"); // java.sql.ResultSet rset1 = st2.executeQuery("SELECT sum(tc.total_gross_pay) from // tax_card tc,master_file mf where tc.staff_no = mf.employee_no AND tc.date BETWEEN // '"+beginDate+"' AND '"+endDate+"' AND mf.department ILIKE '"+bank+"%'"); // java.sql.ResultSet rset3 = st3.executeQuery("select sum(amount) from posting WHERE // date BETWEEN '"+beginDate+"' AND '"+endDate+"' AND description = '"+bank+"'");// // tn,debit_note db WHERE tn.policy_no != '' and tn.policy_no = db.policy_no GROUP BY // tn.policy_no,db.policy_class"); while (rset.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); numberSeq = numberSeq + 1; phrase = new Phrase("" + numberSeq + " ", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(1).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(2).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(3)), pFontHeader1); balance = balance + rset.getDouble(3); table.addCell(phrase); } table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); // while (rset1.next()){ table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Totals", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(balance)), pFontHeader); table.addCell(phrase); docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); try { if (System.getProperty("os.name").equalsIgnoreCase("Linux")) { System.out.println(tempFile); wait_for_Pdf2Show = rt.exec("kghostview " + tempFile + ""); wait_for_Pdf2Show.waitFor(); } else { wait_for_Pdf2Show = rt.exec("c:/Program Files/Adobe/Acrobat 5.0/Reader/AcroRd32.exe " + tempFile); wait_for_Pdf2Show.waitFor(); } } catch (java.lang.InterruptedException intrExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), intrExec.getMessage()); } } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.sql.ResultSet rsetTotals1 = null; java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; try { java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name,rep_currency from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); ks = rset2.getString(2); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName, pFontHeader), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Credit Notes - Page: ", pFontHeader1), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); double osBalancebf = 0; try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(5); int headerwidths[] = {12, 10, 21, 25, 12}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(2); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(3); Phrase phrase = new Phrase( "Credit Notes : ", com.lowagie.text.FontFactory.getFont(FontFactory.HELVETICA_BOLD, 10)); table.addCell(phrase); table.getDefaultCell().setColspan(2); phrase = new Phrase( "Printed On : " + date, com.lowagie.text.FontFactory.getFont(FontFactory.HELVETICA_BOLD, 10)); table.addCell(phrase); table.getDefaultCell().setColspan(5); try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); java.util.Date endDate1 = dateFormat.parse(beginDate.toLocaleString()); // dateInstance.toLocaleString()); java.util.Date endDate2 = dateFormat.parse(endDate.toLocaleString()); phrase = new Phrase( "From :" + dateFormat.format(endDate1) + " To : " + dateFormat.format(endDate2), pFontHeader); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } table.getDefaultCell().setColspan(1); // phrase = new Phrase("Name", pFontHeader); // table.addCell(phrase); phrase = new Phrase("Date", pFontHeader); table.addCell(phrase); phrase = new Phrase("No.", pFontHeader); table.addCell(phrase); phrase = new Phrase("Name", pFontHeader); table.addCell(phrase); phrase = new Phrase("Description", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Amount " + ks, pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { // java.lang.Object[] listofAct = this.getListofActivities(); java.lang.Object[] listofAct1 = this.getListofActivities1(); java.sql.Statement st21 = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); java.sql.ResultSet rset1 = st2.executeQuery( "SELECT date,invoice_no,initcap(payee),initcap(journal_no||' '|| item),sum(credit) from ac_debtors where date BETWEEN '" + beginDate + "' AND '" + endDate + "' and transaction_type ILIKE 'credit not%' and credit > 0 GROUP BY date,invoice_no,payee,journal_no||' '|| item order by date,invoice_no"); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(" ", pFontHeader); // table.addCell(phrase); table.getDefaultCell().setColspan(4); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); while (rset1.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset1.getObject(1), "-"), pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset1.getObject(2), "-"), pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset1.getObject(3), "-"), pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // phrase = new Phrase(rset1.getString(4),pFontNum); phrase = new Phrase(dbObject.getDBObject(rset1.getObject(4), "-"), pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rset1.getString(5)),pFontHeader1); // table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset1.getString(5)), pFontHeader); osBalancebf = osBalancebf + rset1.getDouble(5); table.addCell(phrase); } // while (rsetTotals.next()) { table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalancebf)), pFontHeader); table.addCell(phrase); // } docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; String Activity = null; try { java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st5 = connectDB.createStatement(); java.sql.ResultSet rset5 = st5.executeQuery( "SELECT activity from pb_activity where code ilike '" + bank + "'"); java.sql.Statement st4 = connectDB.createStatement(); java.sql.Statement st2x = connectDB.createStatement(); java.sql.ResultSet rset2x = st2x.executeQuery("SELECT rep_currency from pb_hospitalprofile"); while (rset2x.next()) { ks = rset2x.getObject(1).toString(); } java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); } while (rset5.next()) { Activity = rset5.getObject(1).toString(); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName, pFontHeader), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Transaction By Account - Page: ", pFontHeader), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); double Debit = 0.00; double Credit = 0.00; double bal = 0.00; int nos = 0; double acBal = 0.00; try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(9); int headerwidths[] = {5, 12, 10, 20, 15, 10, 13, 13, 13}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(2); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(9); Phrase phrase = new Phrase("", pFontHeader); try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); java.util.Date endDate1 = dateFormat.parse(endDate.toLocaleString()); // dateInstance.toLocaleString()); java.util.Date endDate11 = dateFormat.parse(beginDate.toLocaleString()); // dateInstance.toLocaleString()); System.out.println("" + endDate1); // phrase = new Phrase(bank +" Report: " +dateFormat.format(formattedDate), // pFontHeader); // table.addCell(phrase); table.getDefaultCell().setColspan(7); phrase = new Phrase( bank + " " + Activity + " : Transactions Report [" + paType + "] Period : From " + dateFormat.format(endDate11) + " To " + dateFormat.format(endDate1), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Printed On :" + date, pFontHeader); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(1); phrase = new Phrase("No", pFontHeader); table.addCell(phrase); phrase = new Phrase("Date", pFontHeader); table.addCell(phrase); phrase = new Phrase("Trans No.", pFontHeader); table.addCell(phrase); phrase = new Phrase("Description", pFontHeader); table.addCell(phrase); phrase = new Phrase("Narration", pFontHeader); table.addCell(phrase); phrase = new Phrase("Doc. No", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Debit", pFontHeader); table.addCell(phrase); phrase = new Phrase("Credit " + ks, pFontHeader); table.addCell(phrase); phrase = new Phrase("Balance " + ks, pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { // java.sql.Connection conDb1 = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st = connectDB.createStatement(); java.sql.Statement stx = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); if (paType.equalsIgnoreCase("OP")) { java.sql.ResultSet rset = st.executeQuery( "select date,transaction_no,description,transaction_type,voucher_no,sum(debit),sum(credit) from ac_ledger WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "' AND activity_code = '" + bank + "' AND drawer = 'OP' GROUP BY date,description,transaction_no,transaction_type,voucher_no ORDER BY date,transaction_no ASC"); java.sql.ResultSet rset1 = stx.executeQuery( "select sum(debit-credit) from ac_ledger WHERE date < '" + beginDate + "' AND activity_code = '" + bank + "' AND drawer = 'OP'"); while (rset1.next()) { table.getDefaultCell().setColspan(7); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("BBF", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); bal = bal + rset1.getDouble(1); table.getDefaultCell().setColspan(2); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(bal)), pFontHeader); table.addCell(phrase); } while (rset.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); nos = nos + 1; table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(java.lang.String.valueOf(nos), pFontHeader1); table.addCell(phrase); phrase = new Phrase(dbObject.getDBObject(rset.getObject(1), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(2), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(3), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(4), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(5), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rsetTotals.getString(1)),pFontHeader); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(6)), pFontHeader); Debit = Debit + rset.getDouble(6); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(7)), pFontHeader); Credit = Credit + rset.getDouble(7); table.addCell(phrase); acBal = acBal + (bal + Debit - Credit); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(acBal)), pFontHeader); table.addCell(phrase); } } else { if (paType.equalsIgnoreCase("IP")) { java.sql.ResultSet rset = st.executeQuery( "select date,transaction_no,description,transaction_type,voucher_no,sum(debit),sum(credit) from ac_ledger WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "' AND activity_code = '" + bank + "' AND drawer = 'IP' GROUP BY date,description,transaction_no,transaction_type,voucher_no ORDER BY date ASC"); // tn,debit_note db WHERE tn.policy_no != '' and tn.policy_no = db.policy_no GROUP BY tn.policy_no,db.policy_class"); while (rset.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(1), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(2), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(3), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(4), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(5), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rsetTotals.getString(1)),pFontHeader); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(6)), pFontHeader); Debit = Debit + rset.getDouble(6); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(7)), pFontHeader); Credit = Credit + rset.getDouble(7); table.addCell(phrase); } } else { java.sql.ResultSet rset = st.executeQuery( "select date,transaction_no,description,transaction_type,invoice_no,sum(debit),sum(credit) from transaction_list_view WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "' AND activity_code = '" + bank + "' GROUP BY date,description,transaction_no,transaction_type,invoice_no ORDER BY date ASC"); // tn,debit_note db WHERE tn.policy_no != '' and tn.policy_no = db.policy_no GROUP BY tn.policy_no,db.policy_class"); while (rset.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(1), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(2), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(3), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(4), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(5), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rsetTotals.getString(1)),pFontHeader); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(6)), pFontHeader); Debit = Debit + rset.getDouble(6); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(7)), pFontHeader); Credit = Credit + rset.getDouble(7); table.addCell(phrase); } } } // java.sql.ResultSet rset = st.executeQuery("select // date,transaction_no,description,transaction_type,invoice_no,sum(debit),sum(credit) // from transaction_list_view WHERE date BETWEEN '"+beginDate+"' AND '"+endDate+"' AND // activity_code = '"+bank+"' GROUP BY // date,description,transaction_no,transaction_type,invoice_no ORDER BY date ASC");// // tn,debit_note db WHERE tn.policy_no != '' and tn.policy_no = db.policy_no GROUP BY // tn.policy_no,db.policy_class"); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); // while (rsetTotals.next()) { table.getDefaultCell().setColspan(6); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(Debit)), pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(Credit)), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(4); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Debit - Credit", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(Debit - Credit)), pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(acBal)), pFontHeader); table.addCell(phrase); // } docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.util.Calendar calLast = java.util.Calendar.getInstance(); calLast.roll(java.util.Calendar.YEAR, -1); dateLastyear = calLast.getTime().toString(); System.out.println(this.dateLastyear); java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); /* try { java.lang.Class.forName("org.postgresql.Driver"); } catch(java.lang.ClassNotFoundException cnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), cnfExec.getMessage()); } */ String compName = null; String date = null; try { // java.sql.Connection conDb = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT company_name from company_profile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) compName = rset2.getObject(1).toString(); while (rset4.next()) date = rset4.getObject(1).toString(); com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase( "" + compName + " Printed On: " + date + ""), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Balance Sheet - Page: "), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(3); int headerwidths[] = {30, 40, 30}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(3); Phrase phrase = new Phrase("Balance Sheet as at : " + beginDate, pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setBackgroundColor(java.awt.Color.LIGHT_GRAY); table.addCell(""); table.addCell(""); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.addCell("Amount KShs."); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { java.lang.Object[] listofAct = this.getListofActivities(); java.lang.Object[] listofAct1 = this.getListofActivities1(); java.lang.Object[] listofAct2 = this.getListofActivities2(); // java.sql.Connection conDb1 = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); System.out.println(listofAct.length); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset4 = st4.executeQuery( "SELECT SUM(amount) from assets_view WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "'"); for (int i = 0; i < listofAct.length; i++) { java.sql.Statement st = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); java.sql.Statement st3 = connectDB.createStatement(); java.sql.ResultSet rset3 = st3.executeQuery( "select DISTINCT at.description from accounts_setup at,balance_sheet_view bv,sub_activities sa,activity ac where at.main_code = '" + listofAct[i].toString() + "' and bv.gl_code = ac.code and ac.sub_code = sa.sub_code and sa.main_code = at.main_code and at.class = 'ba'"); java.sql.ResultSet rset = st.executeQuery( "select bv.gl_code,initcap(bv.description),sum(bv.amount) from balance_sheet_view bv,activity ac,accounts_setup at,sub_activities sa where at.main_code = '" + listofAct[i].toString() + "' and sa.main_code = '" + listofAct[i].toString() + "' and ac.sub_code = sa.sub_code and bv.gl_code = ac.code and at.class = 'ba' AND bv.date BETWEEN '" + beginDate + "' AND '" + endDate + "' group by bv.gl_code,bv.description order by bv.gl_code"); java.sql.ResultSet rsetTotals = st2.executeQuery( "SELECT SUM(amount) from balance_sheet_view bv,activity ac,sub_activities sa,accounts_setup at where sa.main_code = '" + listofAct[i].toString() + "' and sa.main_code = at.main_code and sa.sub_code = ac.sub_code and bv.gl_code = ac.code and at.class = 'ba' AND bv.date BETWEEN '" + beginDate + "' AND '" + endDate + "' group by sa.main_code"); // rsetTotals1 = st3.executeQuery("SELECT SUM(debit),SUM(credit) from"); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.addCell(" "); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); while (rset3.next()) { table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset3.getObject(1).toString(), pFontHeader1); table.addCell(phrase); } while (rset.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(1).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(2).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(3)), pFontHeader1); table.addCell(phrase); } while (rsetTotals.next()) { table.getDefaultCell().setColspan(2); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.TOP | Rectangle.BOTTOM); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Sub Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rsetTotals.getString(1)), pFontHeader); table.addCell(phrase); } } table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.addCell(" "); while (rset4.next()) { table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total Assets", pFontHeader); table.addCell(phrase); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset4.getString(1)), pFontHeader); table.addCell(phrase); } table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); java.sql.Statement st5 = connectDB.createStatement(); java.sql.ResultSet rset5 = st5.executeQuery( "SELECT SUM(amount) from liabilities_view WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "'"); for (int i = 0; i < listofAct1.length; i++) { java.sql.Statement st6 = connectDB.createStatement(); java.sql.Statement st7 = connectDB.createStatement(); java.sql.Statement st8 = connectDB.createStatement(); java.sql.ResultSet rset8 = st8.executeQuery( "select DISTINCT at.description from accounts_setup at,balance_sheet_view bv,sub_activities sa,activity ac where at.main_code = '" + listofAct1[i].toString() + "' and bv.gl_code = ac.code and ac.sub_code = sa.sub_code and sa.main_code = at.main_code and at.class = 'bl'"); java.sql.ResultSet rset6 = st6.executeQuery( "select bv.gl_code,bv.description,sum(bv.amount) from balance_sheet_view bv,activity ac,accounts_setup at,sub_activities sa where at.main_code = '" + listofAct1[i].toString() + "' and sa.main_code = '" + listofAct1[i].toString() + "' and ac.sub_code = sa.sub_code and bv.gl_code = ac.code and at.class = 'bl' AND bv.date BETWEEN '" + beginDate + "' AND '" + endDate + "' group by bv.gl_code,bv.description order by bv.gl_code"); java.sql.ResultSet rset7 = st7.executeQuery( "SELECT SUM(amount) from balance_sheet_view bv,activity ac,sub_activities sa,accounts_setup at where sa.main_code = '" + listofAct1[i].toString() + "' and sa.main_code = at.main_code and sa.sub_code = ac.sub_code and bv.gl_code = ac.code and at.class = 'bl' AND bv.date BETWEEN '" + beginDate + "' AND '" + endDate + "' group by sa.main_code"); // rsetTotals1 = st3.executeQuery("SELECT SUM(debit),SUM(credit) from"); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.addCell(" "); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); while (rset8.next()) { table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset8.getObject(1).toString(), pFontHeader1); table.addCell(phrase); } while (rset6.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset6.getObject(1).toString(), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset6.getObject(2).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset6.getString(3)), pFontHeader1); table.addCell(phrase); } while (rset7.next()) { table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setColspan(2); table.getDefaultCell().setBorder(Rectangle.TOP); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Sub Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset7.getString(1)), pFontHeader); table.addCell(phrase); } table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.addCell(" "); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); } while (rset5.next()) { table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total Liabilities", pFontHeader); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset5.getString(1)), pFontHeader); table.addCell(phrase); } float num_a = 0; float num_b = 0; float num_c = 0; float totals = 0; int j = 0; java.sql.Statement st13 = connectDB.createStatement(); java.sql.ResultSet rset13 = st13.executeQuery( " SELECT description,sub_code,(select sum(amount) from pl_account_view WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "') from sub_activities where identifier Like 'pl%'"); java.sql.Statement st9 = connectDB.createStatement(); java.sql.ResultSet rset9 = st9.executeQuery( "SELECT SUM(amount) from equity_view WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "'"); java.sql.Statement st14 = connectDB.createStatement(); java.sql.ResultSet rset14 = st14.executeQuery( "select(select sum(amount) from pl_account_view WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "') + (select sum(amount) from equity_view WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "')"); java.sql.Statement st16 = connectDB.createStatement(); java.sql.ResultSet rset16 = st16.executeQuery( "select(select sum(amount) from pl_account_view WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "') + (select sum(amount) from equity_view WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "') + (select sum(amount) from liabilities_view WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "')"); for (int i = 0; i < listofAct2.length; i++) { java.sql.Statement st10 = connectDB.createStatement(); java.sql.Statement st8 = connectDB.createStatement(); java.sql.Statement st11 = connectDB.createStatement(); // java.sql.ResultSet rset10 = st10.executeQuery("select * from equity_view"); java.sql.ResultSet rset11 = st11.executeQuery( "select DISTINCT at.description from accounts_setup at,balance_sheet_view bv,sub_activities sa,activity ac where at.main_code = '" + listofAct2[i].toString() + "' and bv.gl_code = ac.code and ac.sub_code = sa.sub_code and sa.main_code = at.main_code and at.class = 'bli'"); java.sql.Statement st15 = connectDB.createStatement(); java.sql.ResultSet rset15 = st15.executeQuery( "select bv.gl_code,bv.description,sum(bv.amount) from balance_sheet_view bv,activity ac,accounts_setup at,sub_activities sa where at.main_code = '" + listofAct2[i].toString() + "' and sa.main_code = '" + listofAct2[i].toString() + "' and ac.sub_code = sa.sub_code and bv.gl_code = ac.code and at.class = 'bli' AND bv.date BETWEEN '" + beginDate + "' AND '" + endDate + "' group by bv.gl_code,bv.description order by bv.gl_code"); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.addCell(" "); while (rset11.next()) { table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset11.getObject(1).toString(), pFontHeader1); System.out.println(rset11.getObject(1).toString()); table.addCell(phrase); } while (rset15.next()) { table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset15.getObject(1).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset15.getObject(2).toString(), pFontHeader1); System.out.println(rset15.getObject(2).toString()); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset15.getString(3)), pFontHeader1); table.addCell(phrase); } // } while (rset13.next()) // { // table.getDefaultCell().setColspan(2); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // table.getDefaultCell(). // phrase = new Phrase("Profit & Loss", pFontHeader); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset13.getObject(2).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset13.getObject(1).toString(), pFontHeader1); table.addCell(phrase); // table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset13.getString(3)), pFontHeader1); table.addCell(phrase); // } while (rset14.next()) { table.getDefaultCell().setColspan(2); table.getDefaultCell().setBorder(Rectangle.TOP); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // table.getDefaultCell(). phrase = new Phrase("Total Equity", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset14.getString(1)), pFontHeader1); table.addCell(phrase); } table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.addCell(" "); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); while (rset16.next()) { table.getDefaultCell().setColspan(2); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // table.getDefaultCell(). phrase = new Phrase("Total Liabilities + Equity", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); float totalLiabEq = rset16.getFloat(1); if (totalLiabEq != 0) { // phrase = new Phrase(totalLiabEq); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset16.getString(1)), pFontHeader1); table.addCell(phrase); } else { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset13.getString(3)), pFontHeader1); table.addCell(phrase); } } } docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); try { if (System.getProperty("os.name").equalsIgnoreCase("Linux")) { System.out.println(tempFile); wait_for_Pdf2Show = rt.exec("kghostview " + tempFile + ""); wait_for_Pdf2Show.waitFor(); } else { wait_for_Pdf2Show = rt.exec("c:/Program Files/Adobe/Acrobat 5.0/Reader/AcroRd32.exe " + tempFile); wait_for_Pdf2Show.waitFor(); } } catch (java.lang.InterruptedException intrExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), intrExec.getMessage()); } } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.sql.ResultSet rsetTotals1 = null; java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; try { java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.Statement st2x = connectDB.createStatement(); java.sql.ResultSet rset2x = st2x.executeQuery("SELECT rep_currency from pb_hospitalprofile"); while (rset2x.next()) { ks = rset2x.getObject(1).toString(); } java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName, pFontHeader), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase( "Out Patient Bills (Both Self & Scheme paying) - Page: ", pFontHeader11), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(7); int headerwidths[] = {7, 10, 12, 25, 16, 15, 15}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(2); Phrase phrase = new Phrase("", pFontHeader); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); java.util.Date endDate1 = null; java.util.Date endDate11 = null; java.text.DateFormat dateFormat = null; try { table.getDefaultCell().setColspan(4); dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); endDate11 = dateFormat.parse(endDate.toLocaleString()); endDate1 = dateFormat.parse(beginDate.toLocaleString()); phrase = new Phrase( "OUT-PATIENT BILLS RECONCILIATION : PERIOD " + dateFormat.format(endDate1) + " - " + dateFormat.format(endDate11), com.lowagie.text.FontFactory.getFont(FontFactory.HELVETICA_BOLD, 10)); table.addCell(phrase); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( "Printed On : " + date, com.lowagie.text.FontFactory.getFont(FontFactory.HELVETICA_BOLD, 10)); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(1); phrase = new Phrase("No", pFontHeader); table.addCell(phrase); phrase = new Phrase("Date", pFontHeader); table.addCell(phrase); phrase = new Phrase("Patient No.", pFontHeader); table.addCell(phrase); phrase = new Phrase("Name", pFontHeader); table.addCell(phrase); // phrase = new Phrase("Service", pFontHeader); // table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Debit ", pFontHeader); table.addCell(phrase); phrase = new Phrase("Credit ", pFontHeader); table.addCell(phrase); phrase = new Phrase("Balance", pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { // java.lang.Object[] listofAct = this.getListofActivities(); // java.lang.Object[] listofAct1 = this.getListofActivities1(); java.sql.Statement st21 = connectDB.createStatement(); java.sql.ResultSet rsetTotals = st21.executeQuery( "SELECT sum(debit-credit) from outpatient_bills where date BETWEEN '" + beginDate + "' AND '" + endDate + "' group by date"); java.sql.Statement st2 = connectDB.createStatement(); java.sql.Statement st23 = connectDB.createStatement(); java.sql.Statement st2v = connectDB.createStatement(); // for (int k = 0; k < listofAct1.length; k++) { /* java.sql.ResultSet rset13 = st23.executeQuery("SELECT sum(debit-credit) from outpatient_bills where trans_date BETWEEN '"+beginDate+"' AND '"+endDate+"' group by date"); while (rset13.next()) { balances = rset13.getDouble(3); } balances == 0.00; }else{*/ // balances = 0.00; // System.out.println(""+listofAct1[k].toString()); java.sql.ResultSet rset1 = st2.executeQuery( "SELECT date::date,patient_no,name,payment_mode,debit as debit,credit as credit, balance from outpatient_bills WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "' and balance <>0 group by patient_no,payment_mode,date,name,debit,credit,balance ORDER BY date"); // table.getDefaultCell().setColspan(1); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // phrase = new Phrase(" ",pFontHeader); // table.addCell(phrase); // table.getDefaultCell().setColspan(4); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // if(balances != 0.00){ // phrase = new Phrase(listofAct1[k].toString(),pFontHeader); // table.addCell(phrase); while (rset1.next()) { seqNo = seqNo + 1; table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("" + seqNo + ".", pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset1.getObject(1).toString(), pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset1.getObject(2).toString(), pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset1.getObject(3).toString(), pFontNum); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset1.getString(5)), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset1.getString(6)), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset1.getString(7)), pFontHeader1); table.addCell(phrase); debits = debits + rset1.getDouble(5); credits = credits + rset1.getDouble(6); totals = totals + rset1.getDouble(7); } // } // } // while (rsetTotals.next()) { table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); // totals = rsetTotals.getDouble(1); table.getDefaultCell().setColspan(4); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("TOTALS", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(debits)), pFontHeader1); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(credits)), pFontHeader1); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(totals)), pFontHeader1); table.addCell(phrase); // } // } docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf(java.lang.String memNo) { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; // com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); int titleFont = 0; int bodyFont = 0; float Widths = 0; float Heights = 0; float Margins = 0; try { connectDB.setAutoCommit(false); java.sql.Statement stm1 = connectDB.createStatement(); java.sql.ResultSet rse1 = stm1.executeQuery( "select header_font,body_font,width,height,margins from receipt_pref"); while (rse1.next()) { titleFont = rse1.getInt(1); bodyFont = rse1.getInt(2); Widths = rse1.getFloat(3); Heights = rse1.getFloat(4); Margins = rse1.getFloat(5); } } catch (java.sql.SQLException sq) { try { connectDB.rollback(); } catch (java.sql.SQLException sql) { // javax.swing.JOptionPane.showMessageDialog(this,sql.getMessage(),"Error // Message!",javax.swing.JOptionPane.ERROR_MESSAGE); } System.out.println(sq.getMessage()); // javax.swing.JOptionPane.showMessageDialog(this,sq.getMessage(), // "Error",javax.swing.JOptionPane.ERROR_MESSAGE); } // com.lowagie.text.Font pFontHeader = // FontFactory.getFont(System.getProperty("font_type_name"), // java.lang.Float.parseFloat(System.getProperty("receiptFontSize")), Font.NORMAL); // com.lowagie.text.Font pFontHeader1 = // FontFactory.getFont(System.getProperty("font_type_name"), // java.lang.Float.parseFloat(System.getProperty("receiptTitleFontSize")), Font.BOLD); com.lowagie.text.Font pFontHeader = FontFactory.getFont(FontFactory.HELVETICA, bodyFont, Font.NORMAL); com.lowagie.text.Font pFontHeader1 = FontFactory.getFont(FontFactory.HELVETICA, titleFont, Font.BOLD); com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); // com.lowagie.text.Document docPdf = new com.lowagie.text.Document(new Rectangle((Widths), // Heights),Margins,Margins,Margins,Margins); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String Address = null; String Tel = null; String compName = null; String Fax = null; String Email = null; String date = null; try { java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.Statement st2x = connectDB.createStatement(); java.sql.ResultSet rset2x = st2x.executeQuery("SELECT rep_currency from pb_hospitalprofile"); while (rset2x.next()) { ks = rset2x.getObject(1).toString(); } java.sql.ResultSet rset2 = st3.executeQuery( "select hospital_name,postal_code||' '||box_no||' '||town,main_telno||' '||other_telno,initcap(street),main_faxno,email||' '||website,room_no from pb_hospitalprofile"); // java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from // pb_hospitalprofile"); // java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); Address = rset2.getObject(2).toString(); Tel = rset2.getObject(3).toString(); Fax = rset2.getObject(5).toString(); Email = rset2.getObject(6).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase( "" + compName + "\n Address: " + Address + "\n Tel: " + Tel + " \n Fax: " + Fax + "\n Email: " + Email + ""), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } String Messg = null; try { java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("select name from pb_notice"); while (rset2.next()) { Messg = rset2.getObject(1).toString(); com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("" + Messg + ""), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); docPdf.setFooter(footer); } } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } docPdf.open(); try { java.lang.Object listofStaffNos[] = this.getListofStaffNos(); for (int j = 0; j < listofStaffNos.length; j++) { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(6); int headerwidths[] = {20, 35, 15, 15, 15, 15}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(6); Phrase phrase = new Phrase(); // table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); System.out.println(listofStaffNos[j]); try { // - for (int j = 0; j < listofStaffNos.length; j++) { java.sql.Statement st311 = connectDB.createStatement(); java.sql.Statement st12 = connectDB.createStatement(); java.sql.Statement st6 = connectDB.createStatement(); java.sql.Statement st61 = connectDB.createStatement(); java.sql.Statement st11 = connectDB.createStatement(); java.sql.Statement st = connectDB.createStatement(); java.sql.Statement st1 = connectDB.createStatement(); java.sql.Statement st1d = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); java.sql.Statement st31 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.Statement st5 = connectDB.createStatement(); java.sql.ResultSet rset311 = st311.executeQuery( "select ap.payer_id from ac_debtors ac,ac_scheme_providers ap where ac.dealer = ap.scheme_manager AND ac.invoice_no = '" + listofStaffNos[j] + "'"); java.sql.ResultSet rset31 = st31.executeQuery( "select pc.payee,sp.postal_code||' '||sp.address,sp.tel_main||' '||sp.other_tel,sp.main_fax from ac_schemes sp,ac_debtors pc where pc.payee = sp.scheme_name and pc.invoice_no = '" + listofStaffNos[j] + "'"); java.sql.ResultSet rset4 = st4.executeQuery( "select dealer from ac_debtors where invoice_no = '" + listofStaffNos[j] + "'"); java.sql.ResultSet rset5 = st5.executeQuery( "select pr.account_no,pr.member_name from hp_patient_register pr,ac_debtors db where db.invoice_no = '" + listofStaffNos[j] + "' and db.admission_no = pr.patient_no"); java.sql.ResultSet rset = st.executeQuery( "select admission_no,initcap(item) from ac_debtors where invoice_no = '" + listofStaffNos[j] + "'"); java.sql.ResultSet rsetTotals = st2.executeQuery( "select sum(credit) from hp_patient_card where invoice_no = '" + listofStaffNos[j] + "' AND paid = true"); java.sql.ResultSet rset12 = st12.executeQuery( "select date from ac_debtors where invoice_no = '" + listofStaffNos[j] + "'"); java.sql.ResultSet rset11 = st11.executeQuery( "select invoice_no from ac_debtors where invoice_no = '" + listofStaffNos[j] + "' and invoice_no IS NOT NULL"); java.sql.ResultSet rset1d = st1d.executeQuery( "select date::date,initcap(service) as service,dosage,reference,debit-credit from hp_patient_card where invoice_no = '" + listofStaffNos[j] + "' AND paid = true AND transaction_type not ilike 'Invoice' AND reference ILIKE 'C%'"); double osBalance = 0.00; double current = 0.00; System.out.println(listofStaffNos[j]); System.out.println("Step1 Complete"); while (rset4.next()) { table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase( "Payer Name: " + dbObject.getDBObject(rset4.getObject(1), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(3); // while (rset11.next()){ // table.getDefaultCell().setColspan(1); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(6); while (rset31.next()) { table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase( "Scheme Name: " + dbObject.getDBObject(rset31.getObject(1), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(3); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase( "Address.: " + dbObject.getDBObject(rset31.getObject(2), "-"), pFontHeader); table.addCell(phrase); while (rset12.next()) { table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase( "Invoice Date.: " + dbObject.getDBObject(rset12.getObject(1), "-"), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(6); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase( "Tel.: " + dbObject.getDBObject(rset31.getObject(3), "-"), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase( "Fax.: " + dbObject.getDBObject(rset31.getObject(4), "-"), pFontHeader); table.addCell(phrase); while (rset11.next()) { // table.getDefaultCell().setColspan(1); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase( "Invoice No.: " + dbObject.getDBObject(rset11.getObject(1), "-"), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(3); while (rset5.next()) { table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // phrase = new Phrase("Member No.", pFontHeader); phrase = new Phrase( "Member No.: " + dbObject.getDBObject(rset5.getObject(1), "-"), pFontHeader); table.addCell(phrase); System.out.println("Step4 Complete"); while (rset.next()) { table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase( "Patient Name.: " + dbObject.getDBObject(rset.getObject(2), "-"), pFontHeader); table.addCell(phrase); // while (rset5.next()){ table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase( "Member Name.: " + dbObject.getDBObject(rset5.getObject(2), "-"), pFontHeader); table.addCell(phrase); // while (rset.next()){ table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // phrase = new Phrase("Member Name "+rset5.getString(2), // pFontHeader); phrase = new Phrase( "Patient No.: " + dbObject.getDBObject(rset.getObject(1), "-"), pFontHeader); table.addCell(phrase); } } } } } } table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorderWidth(Rectangle.TOP); table.getDefaultCell().setColspan(1); phrase = new Phrase("Date", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(1); phrase = new Phrase("Description", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); phrase = new Phrase("Qty", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(1); phrase = new Phrase("Ref", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setColspan(1); phrase = new Phrase("Amount", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(1); phrase = new Phrase("Running " + ks, pFontHeader1); table.addCell(phrase); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); java.lang.Object listofStaffNos1[] = this.getListofStaffNos1(listofStaffNos[j]); for (int k = 0; k < listofStaffNos1.length; k++) { double osBalance1 = 0.00; java.sql.ResultSet rset1 = st1.executeQuery( "select date::date,initcap(service) as service,dosage::int,reference,debit-credit from hp_patient_card where invoice_no = '" + listofStaffNos[j] + "' AND paid = true and service not ilike 'Invoice' AND main_service ilike '" + listofStaffNos1[k] + "' AND reference NOT ILIKE 'C%'"); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(6); phrase = new Phrase(listofStaffNos1[k].toString(), pFontHeader1); table.addCell(phrase); while (rset1.next()) { table.getDefaultCell().setColspan(1); // table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset1.getObject(1), "-"), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset1.getObject(2), "-"), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); int dos = 0; dos = rset1.getInt(3); phrase = new Phrase(java.lang.String.valueOf(dos), pFontHeader); // phrase = new Phrase(dbObject.getDBObject(rset1.getObject(3), "-"), // pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset1.getObject(4), "-"), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset1.getString(5)), pFontHeader); // osBalance = osBalance + rset.getDouble(5); table.addCell(phrase); osBalance = osBalance + rset1.getDouble(5); osBalance1 = osBalance1 + rset1.getDouble(5); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance)), pFontHeader); // current = current + osBalance; table.addCell(phrase); } table.getDefaultCell().setColspan(3); phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(1); phrase = new Phrase("Gross ", pFontHeader11); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setColspan(1); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance1)), pFontHeader11); table.addCell(phrase); phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); } table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("", pFontHeader); table.addCell(phrase); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); while (rsetTotals.next()) { table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Invoice Total.", pFontHeader11); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setColspan(1); phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance)), pFontHeader11); table.addCell(phrase); } while (rset1d.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset1d.getObject(1), "-"), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset1d.getObject(2), "-"), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset1d.getObject(3), "-"), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset1d.getObject(4), "-"), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset1d.getString(5)), pFontHeader); table.addCell(phrase); osBalance = osBalance - rset1d.getDouble(5); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance)), pFontHeader); table.addCell(phrase); } table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("", pFontHeader); table.addCell(phrase); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance)), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(36); phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(6); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(" ", pFontHeader1); table.addCell(phrase); docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } boolean boolNewPage = docPdf.newPage(); } // } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf( UserShopForm sForm, List pItems, StoreData pStore, OutputStream pOut, String pImageName, boolean personal, boolean pCatalogOnly, String catalogLocaleCd) throws IOException { mSkuTag = ClwI18nUtil.getMessage(mRequest, "shop.og.text.ourSkuNum", null); try { catalogOnly = pCatalogOnly; initColumnsAdnWidths(sForm.getAppUser()); mSiteData = sForm.getAppUser().getSite(); AccountData mAccount = sForm.getAppUser().getUserAccount(); String ogInvDisplay = mAccount.getPropertyValue(RefCodeNames.PROPERTY_TYPE_CD.INVENTORY_OG_LIST_UI); boolean modernShoppingFl = mSiteData.hasModernInventoryShopping(); // loop through the items to check if the footer needs to have the pack // Disclaimer printed on each page. boolean printProblemPackDisclaimer = false, invItems = false, invAutoOrderItems = false, nonInvItems = false, addNewPage = false; for (int i = 0; i < pItems.size(); i++) { ShoppingCartItemData sci = (ShoppingCartItemData) pItems.get(i); if (sci.getProduct().isPackProblemSku()) { printProblemPackDisclaimer = true; } if (sci.getIsaInventoryItem()) { invItems = true; if (null != mSiteData && mSiteData.isAnInventoryAutoOrderItem(sci.getProduct().getProductId())) { invAutoOrderItems = true; } } else { nonInvItems = true; if (invItems) addNewPage = true; } } Phrase headPhrase = new Phrase(makeChunk("", heading, true)); if (catalogOnly) { String catalogStr = ClwI18nUtil.getMessage(mRequest, "shop.og.text.catalog", null); headPhrase.add(makeChunk(catalogStr, heading, true)); } else { if (sForm.getAppUser().getSite() != null && sForm.getAppUser().getSite().getBSC() != null && sForm.getAppUser().getSite().getBSC().getBusEntityData() != null && sForm.getAppUser().getSite().getBSC().getBusEntityData().getShortDesc() != null) { String subname = sForm.getAppUser().getSite().getBSC().getBusEntityData().getShortDesc() + " "; headPhrase.add(makeChunk(subname, heading, true)); headPhrase.add(makeChunk(" ", heading, true)); } String orderGuideStr = ClwI18nUtil.getMessage(mRequest, "shop.og.text.orderGuide", null); headPhrase.add(makeChunk(orderGuideStr, heading, true)); headPhrase.add(makeChunk(" ", heading, true)); headPhrase.add( makeChunk( sForm.getAppUser().getUserAccount().getBusEntity().getShortDesc(), heading, true)); } HeaderFooter header = new HeaderFooter(headPhrase, true); header.setAlignment(HeaderFooter.ALIGN_RIGHT); // setup the document // pageSize, marginLeft, marginRight, marginTop, marginBottom Document document = new Document(PageSize.A4, 10, 15, 30, 15); PdfWriter writer = PdfWriter.getInstance(document, pOut); String addr = pStore.getPrimaryAddress().getAddress1() + " " + pStore.getPrimaryAddress().getAddress2(); Chunk disclaimer = null; String fmsg = ""; if (invItems) { fmsg += ClwI18nUtil.getMessage(mRequest, "shop.og.text.i-inventoryItem", null) + " "; } if (invAutoOrderItems) { fmsg += ClwI18nUtil.getMessage(mRequest, "shop.og.text.a-autoOrderItem", null) + " "; } if (printProblemPackDisclaimer) { fmsg += ClwI18nUtil.getMessage(mRequest, "shop.og.text.*packAndOrUomMayDifferByRegion", null); } if (fmsg.length() > 0) { disclaimer = makeChunk(fmsg, smallItalic, true); } Phrase footPhrase = makeStoreFooter(pStore, disclaimer, null); HeaderFooter footer = new HeaderFooter(footPhrase, false); footer.setAlignment(HeaderFooter.ALIGN_CENTER); // setup the borders from the header header.setBorder(borderType); footer.setBorder(HeaderFooter.TOP); document.setHeader(header); document.setFooter(footer); document.open(); // voc message String vocMessage = ClwI18nUtil.getMessage(mRequest, "shop.message.vocNotIncluded", null); document.add(makePhrase(vocMessage, smallHeading, true)); document.add(makePhrase(null, smallHeading, true)); drawOGHeader(document, sForm, pImageName, personal); if (modernShoppingFl && !"SEPARATED LIST".equals(ogInvDisplay)) { drawHeader( document, pageNumber, pStore.getStoreBusinessName().getValue(), pImageName, true); String prevCat = null; for (int i = 0; i < pItems.size(); i++) { ShoppingCartItemData sci = (ShoppingCartItemData) pItems.get(i); Table itmTable = makeItemElement(sci); // if the item data will not fit onto the page, // make a new page, and redraw the header. if (writer.fitsPage(itmTable, document.bottomMargin() + 10)) { if (sForm.getOrderBy() == Constants.ORDER_BY_CATEGORY) { if (null == prevCat || !prevCat.equals(sci.getCategoryPath())) { document.add(makePhrase(sci.getCategoryPath(), smallHeading, true)); document.add(makePhrase(null, smallHeading, true)); } prevCat = sci.getCategoryPath(); } } if (!writer.fitsPage(itmTable, document.bottomMargin() + 10)) { document.newPage(); pageNumber = pageNumber + 1; drawHeader( document, pageNumber, pStore.getStoreBusinessName().getValue(), pImageName, true); if (sForm.getOrderBy() == Constants.ORDER_BY_CATEGORY) { document.add(makePhrase(sci.getCategoryPath(), smallHeading, true)); document.add(makePhrase(null, smallHeading, true)); prevCat = sci.getCategoryPath(); } } document.add(itmTable); } } else { if (invItems) { drawHeader( document, pageNumber, pStore.getStoreBusinessName().getValue(), pImageName, true); String prevCat = null; for (int i = 0; i < pItems.size(); i++) { ShoppingCartItemData sci = (ShoppingCartItemData) pItems.get(i); if (sci.getIsaInventoryItem() == false) { continue; } if (sci.getInventoryParValuesSum() <= 0) { // This is an inventory item that is not // allowed for this location. continue; } Table itmTable = makeItemElement(sci); // if the item data will not fit onto the page, // make a new page, and redraw the header. if (writer.fitsPage(itmTable, document.bottomMargin() + 10)) { if (sForm.getOrderBy() == Constants.ORDER_BY_CATEGORY) { if (null == prevCat || !prevCat.equals(sci.getCategoryPath())) { document.add(makePhrase(sci.getCategoryPath(), smallHeading, true)); document.add(makePhrase(null, smallHeading, true)); } prevCat = sci.getCategoryPath(); } } if (!writer.fitsPage(itmTable, document.bottomMargin() + 10)) { document.newPage(); pageNumber = pageNumber + 1; drawHeader( document, pageNumber, pStore.getStoreBusinessName().getValue(), pImageName, true); if (sForm.getOrderBy() == Constants.ORDER_BY_CATEGORY) { document.add(makePhrase(sci.getCategoryPath(), smallHeading, true)); document.add(makePhrase(null, smallHeading, true)); prevCat = sci.getCategoryPath(); } } document.add(itmTable); } } if (nonInvItems) { if (addNewPage) { document.newPage(); pageNumber = pageNumber + 1; } drawHeader( document, pageNumber, pStore.getStoreBusinessName().getValue(), pImageName, false); document.add(makeBlankLine()); String prevCat = null; for (int i = 0; i < pItems.size(); i++) { ShoppingCartItemData sci = (ShoppingCartItemData) pItems.get(i); if (sci.getIsaInventoryItem()) { continue; } Table itmTable = makeItemElement(sci); // Check to see if the category needs to be put out. if (writer.fitsPage(itmTable, document.bottomMargin() + 10)) { if (sForm.getOrderBy() == Constants.ORDER_BY_CATEGORY) { if (null == prevCat || !prevCat.equals(sci.getCategoryPath())) { document.add(makePhrase(sci.getCategoryPath(), smallHeading, true)); document.add(makePhrase(null, smallHeading, true)); } prevCat = sci.getCategoryPath(); } } // if the item data will not fit onto the page, // make a new page, and redraw the header. if (!writer.fitsPage(itmTable, document.bottomMargin() + 10)) { document.newPage(); pageNumber = pageNumber + 1; drawHeader( document, pageNumber, pStore.getStoreBusinessName().getValue(), pImageName, false); if (sForm.getOrderBy() == Constants.ORDER_BY_CATEGORY) { document.add(makePhrase(sci.getCategoryPath(), smallHeading, true)); document.add(makePhrase(null, smallHeading, true)); prevCat = sci.getCategoryPath(); } } document.add(itmTable); } } } // close out the document document.close(); } catch (DocumentException e) { e.printStackTrace(); throw new IOException(e.getMessage()); } }
public void generatePdf() { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); try { java.lang.Class.forName("org.postgresql.Driver"); } catch (java.lang.ClassNotFoundException cnfExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), cnfExec.getMessage()); } String compName = null; String date = null; try { // java.sql.Connection conDb = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.Statement st2x = connectDB.createStatement(); java.sql.ResultSet rset2x = st2x.executeQuery("SELECT rep_currency from pb_hospitalprofile"); while (rset2x.next()) { ks = rset2x.getObject(1).toString(); } java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName + "", pFontHeader), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Transaction List - Page: ", pFontHeader), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(9); int headerwidths[] = {5, 25, 10, 10, 14, 10, 14, 14, 8}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(2); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(9); Phrase phrase = new Phrase("", pFontHeader); try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); java.util.Date endDate1 = dateFormat.parse(endDate.toLocaleString()); // dateInstance.toLocaleString()); java.util.Date endDate11 = dateFormat.parse(beginDate.toLocaleString()); // dateInstance.toLocaleString()); System.out.println("" + endDate1); // phrase = new Phrase(bank +" Report: " +dateFormat.format(formattedDate), // pFontHeader); // table.addCell(phrase); table.getDefaultCell().setColspan(5); phrase = new Phrase( "Sales [" + CashPoint + "] Report : Period : From " + dateFormat.format(endDate11) + " To " + dateFormat.format(endDate1), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(4); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Printed On : " + date, pFontHeader); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } // Phrase phrase = new Phrase("Patients List As At:" +endDate, pFontHeader); // table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(1); // table.getDefaultCell().setBackgroundColor(java.awt.Color.LIGHT_GRAY); phrase = new Phrase("No", pFontHeader); table.addCell(phrase); phrase = new Phrase("ITEM", pFontHeader); table.addCell(phrase); phrase = new Phrase("UNIT", pFontHeader); // table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("COUNT", pFontHeader); table.addCell(phrase); phrase = new Phrase("UNIT COST", pFontHeader); table.addCell(phrase); phrase = new Phrase("TOTAL COST", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("SELLING PRICE", pFontHeader); table.addCell(phrase); phrase = new Phrase("TOTAL " + ks, pFontHeader); table.addCell(phrase); phrase = new Phrase("PROFIT " + ks, pFontHeader); table.addCell(phrase); phrase = new Phrase("MARKUP%", pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); double osBalance11 = 0.00; double osBalance31 = 0.00; double current = 0.00; double osBalance1 = 0.00; double osBalance3 = 0.00; try { java.lang.Object[] listofAct1 = this.getDates(); // for (int k = 0; k < listofAct1.length; k++) { double osBalance21 = 0.00; double osBalance22 = 0.00; double osBalance23 = 0.00; table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); table.getDefaultCell().setColspan(8); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // phrase = new Phrase(listofAct1[k].toString().toUpperCase(), pFontHeader); // table.addCell(phrase); java.lang.Object[] listofAct = this.getListofActivities(); // java.lang.Object[] listofAct = this.getListofActivities(); // java.sql.Connection conDb1 = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); System.out.println(listofAct.length); // java.sql.Statement pSet1 = connectDB.createStatement(); java.sql.Statement st = connectDB.createStatement(); for (int i = 0; i < listofAct.length; i++) { double qtys = 0.00; double osBalance2 = 0.00; // AND st.transfer_price > 0 System.out.println("item" + listofAct[i]); // java.sql.Statement stbx = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); // java.sql.PreparedStatement st1 = connectDB.prepareStatement("select // ph.description,sum(ph.quantity) as quantity,avg(st.transfer_price)::numeric(10,2) // as bprice,sum((ph.quantity * st.transfer_price)::numeric(10,2)) as cost, CASE // WHEN (sum(ph.quantity) > 0 ) THEN // (sum(ph.amount)/sum(ph.quantity))::numeric(10,2) ELSE 1.00 END AS // sprice,sum(amount)::numeric(10,2) as amt,sum(amount) - sum(ph.quantity * // st.transfer_price)::numeric(10,2),CASE WHEN (sum(transfer_price) = 0) THEN 0.00 // ELSE (avg(st.selling_price)/avg(st.transfer_price))::numeric(10,2) END AS markup // from hp_pharmacy ph,st_stock_prices st WHERE ph.main_service ilike // '"+CashPoint+"%' AND st.department ilike '"+CashPoint+"%' and ph.description = ? // AND ph.date_prescribed BETWEEN '"+beginDate+"' AND '"+endDate+"' AND // ph.description ilike st.product GROUP BY ph.description"); java.sql.PreparedStatement st1 = connectDB.prepareStatement( "select ph.description,sum(ph.quantity) as quantity,avg(st.transfer_price)::numeric(10,2) as bprice,sum((ph.quantity * st.transfer_price)::numeric(10,2)) as cost, CASE WHEN (sum(ph.quantity) > 0 ) THEN (sum(ph.amount)/sum(ph.quantity))::numeric(10,2) ELSE 1.00 END AS sprice,sum(amount)::numeric(10,2) as amt,sum(amount) - sum(ph.quantity * st.transfer_price)::numeric(10,2),CASE WHEN (sum(transfer_price) = 0) THEN 0.00 ELSE (avg(st.selling_price)/avg(st.transfer_price))::numeric(10,2) END AS markup from hp_pharmacy ph,st_stock_prices st WHERE ph.main_service ilike '" + CashPoint + "%' AND st.department ilike '" + CashPoint + "%' and ph.description = ? AND ph.date_prescribed BETWEEN '" + beginDate + "' AND '" + endDate + "' AND ph.description = st.product GROUP BY ph.description"); // java.sql.PreparedStatement stbx = connectDB.prepareStatement("select // sum(credit-debit) FROM ac_ledger WHERE activity_code ilike '"+gAccount+"%' and // service_type ilike ? AND date BETWEEN '"+beginDate+"' AND '"+endDate+"' AND // (transaction_type = 'Revenue' OR transaction_type = 'Refunds') GROUP BY // service_type"); java.sql.PreparedStatement stbx = connectDB.prepareStatement( "select sum(credit-debit) FROM ac_ledger WHERE activity_code = '" + gAccount + "' and service_type = ? AND date::date BETWEEN '" + beginDate + "' AND '" + endDate + "' GROUP BY service_type"); st1.setString(1, listofAct[i].toString()); java.sql.ResultSet rset = st1.executeQuery(); stbx.setString(1, listofAct[i].toString()); java.sql.ResultSet rsetbx = stbx.executeQuery(); while (rset.next()) { while (rsetbx.next()) { // table.getDefaultCell().setColspan(1); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); counter = counter + 1; phrase = new Phrase("" + counter, pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(1), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(2)), pFontHeader1); table.addCell(phrase); qtys = rset.getDouble(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(3)), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(4)), pFontHeader1); osBalance1 = rset.getDouble(4); osBalance21 = osBalance21 + rset.getDouble(4); osBalance11 = rset.getDouble(4); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); /* phrase = new Phrase(new com.afrisoftech.sys.Format2Currency().Format2Currency(rset.getString(6)),pFontHeader1); osBalance2 = osBalance2 + rset.getDouble(6); osBalance22 = osBalance22 + rset.getDouble(6); table.addCell(phrase); */ // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rsetbx.getString(1)),pFontHeader1); osBalance2 = rsetbx.getDouble(1); osBalance22 = osBalance22 + rsetbx.getDouble(1); if (qtys > 0) { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance2 / qtys)), pFontHeader1); table.addCell(phrase); } else { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance2 / 1)), pFontHeader1); table.addCell(phrase); } phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance2)), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rset.getString(7)),pFontHeader1); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance2 - osBalance1)), pFontHeader1); /* osBalance3 = osBalance3 + rset.getDouble(7); osBalance23 = osBalance23 + rset.getDouble(7); osBalance31 = rset.getDouble(7); */ table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); if (osBalance1 > 0) { // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rset.getString(8)),pFontHeader1); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency( java.lang.String.valueOf(osBalance2 / osBalance1)), pFontHeader1); table.addCell(phrase); } else { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance2 / 1)), pFontHeader1); table.addCell(phrase); } } } } table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); // while (rsetTotals.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("" + counter, pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance21)), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance22)), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance22 - osBalance21)), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase(" ", pFontHeader); if (osBalance21 > 0) { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance22 / osBalance21)), pFontHeader); table.addCell(phrase); } else { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(0.00)), pFontHeader); table.addCell(phrase); } // } /* table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); // while (rsetTotals.next()) { table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Sum Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase(new com.afrisoftech.sys.Format2Currency().Format2Currency(java.lang.String.valueOf(osBalance1)), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase(new com.afrisoftech.sys.Format2Currency().Format2Currency(java.lang.String.valueOf(osBalance2)), pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase(new com.afrisoftech.sys.Format2Currency().Format2Currency(java.lang.String.valueOf(osBalance3)), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(" ", pFontHeader); table.addCell(phrase); */ docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); try { java.lang.Class.forName("org.postgresql.Driver"); } catch (java.lang.ClassNotFoundException cnfExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), cnfExec.getMessage()); } String compName = null; String date = null; try { // java.sql.Connection conDb = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) compName = rset2.getObject(1).toString(); while (rset4.next()) date = rset4.getObject(1).toString(); com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName + "", pFontHeader), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Journal List - Page: ", pFontHeader), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(6); int headerwidths[] = {10, 10, 8, 25, 15, 15}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(2); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(6); Phrase phrase = new Phrase("", pFontHeader); double osBalance = 0; double osBalance1 = 0; // try { // java.text.DateFormat dateFormat = // java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM);//MEDIUM); // // java.util.Date endDate1 = // dateFormat.parse(endDate.toLocaleString());//dateInstance.toLocaleString()); // java.util.Date endDate11 = // dateFormat.parse(beginDate.toLocaleString());//dateInstance.toLocaleString()); // System.out.println(""+endDate1); // phrase = new Phrase(bank +" Report: " +dateFormat.format(formattedDate), // pFontHeader); // table.addCell(phrase); table.getDefaultCell().setColspan(4); phrase = new Phrase("Journal No : " + Jno, pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Printed On : " + date, pFontHeader); table.addCell(phrase); // } catch(java.text.ParseException psExec) { // javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), // psExec.getMessage()); // // } // Phrase phrase = new Phrase("Patients List As At:" +endDate, pFontHeader); // table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(1); // table.getDefaultCell().setBackgroundColor(java.awt.Color.LIGHT_GRAY); phrase = new Phrase("Date", pFontHeader); table.addCell(phrase); phrase = new Phrase("Activity Code", pFontHeader); table.addCell(phrase); phrase = new Phrase("journal No.", pFontHeader); table.addCell(phrase); phrase = new Phrase("Description", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Debit KShs", pFontHeader); table.addCell(phrase); phrase = new Phrase("Credit KShs", pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { java.sql.Statement st = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); java.sql.ResultSet rset = st.executeQuery( "select input_date,activity_code ,journal_no,description,debit,credit from ac_journal WHERE journal_no BETWEEN '" + Jno + "' AND '" + Jno1 + "' ORDER BY journal_no"); // tn,debit_note db WHERE tn.policy_no != '' // and tn.policy_no = db.policy_no GROUP BY // tn.policy_no,db.policy_class"); while (rset.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(1).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(2).toString(), pFontHeader1); table.addCell(phrase); phrase = new Phrase(rset.getObject(3).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getString(4).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(5)), pFontHeader1); osBalance = osBalance + rset.getDouble(5); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(6)), pFontHeader1); osBalance1 = osBalance1 + rset.getDouble(6); table.addCell(phrase); } table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); table.getDefaultCell().setColspan(4); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance)), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance1)), pFontHeader1); table.addCell(phrase); docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); try { if (System.getProperty("os.name").equalsIgnoreCase("Linux")) { System.out.println(tempFile); wait_for_Pdf2Show = rt.exec("kghostview " + tempFile + ""); wait_for_Pdf2Show.waitFor(); } else { wait_for_Pdf2Show = rt.exec("c:/Program Files/Adobe/Acrobat 5.0/Reader/AcroRd32.exe " + tempFile); wait_for_Pdf2Show.waitFor(); } } catch (java.lang.InterruptedException intrExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), intrExec.getMessage()); } } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); /* try { java.lang.Class.forName("org.postgresql.Driver"); } catch(java.lang.ClassNotFoundException cnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), cnfExec.getMessage()); } */ String compName = null; String date = null; try { java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName, pFontHeader), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("OP Rev BreakDown - Page: "), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(3); int headerwidths[] = { 50, 20, 30, }; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(2); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(3); Phrase phrase = new Phrase("", pFontHeader); try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); java.util.Date endDate1 = dateFormat.parse(endDate.toLocaleString()); // dateInstance.toLocaleString()); java.util.Date endDate11 = dateFormat.parse(beginDate.toLocaleString()); // dateInstance.toLocaleString()); System.out.println("" + endDate1); // phrase = new Phrase(bank +" Report: " +dateFormat.format(formattedDate), // pFontHeader); // table.addCell(phrase); table.getDefaultCell().setColspan(3); phrase = new Phrase(bank.toUpperCase() + " Revenue Break Down Report(OP)", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); phrase = new Phrase( "Period : From " + dateFormat.format(endDate11) + " To " + dateFormat.format(endDate1), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Printed On :" + date, pFontHeader); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } // Phrase phrase = new Phrase("Patients List As At:" +endDate, pFontHeader); // table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(2); // table.getDefaultCell().setBackgroundColor(java.awt.Color.LIGHT_GRAY); phrase = new Phrase("Description", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // table.addCell("Reference No."); table.getDefaultCell().setColspan(1); phrase = new Phrase("Amount KShs.", pFontHeader); table.addCell(phrase); // phrase = new Phrase("Credit KShs.",pFontHeader); // table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); // table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { // java.sql.Connection conDb1 = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); java.sql.ResultSet rset = st.executeQuery( "select UPPER(service),sum(amount) from ac_ledger WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "' AND activity_code ilike '" + bank + "' AND drawer = 'OP' group by service_type order by service_type "); while (rset.next()) { table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(1).toString(), pFontHeader1); table.addCell(phrase); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // phrase = new Phrase(rset.getObject(3).toString(), pFontHeader1); // table.addCell(phrase); // phrase = new Phrase(rset.getObject(4).toString(), pFontHeader1); // table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rsetTotals.getString(1)),pFontHeader); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(2)), pFontHeader1); table.addCell(phrase); balance = balance + rset.getDouble(2); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rset.getString(6)),pFontHeader1); // table.addCell(phrase); } table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); // while (rsetTotals.next()) { table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(balance)), pFontHeader); table.addCell(phrase); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rsetTotals.getString(2)),pFontHeader); // table.addCell(phrase); // } docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { // java.lang.Object[][] ageingDates = periodicDates.getMonthlyDates(); ageingDates = ageingSeries.getAgeingDateSeries(); double columnTotals[] = new double[ageingDates.length]; java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); int interval = 0; try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); java.util.Calendar calendar = java.util.Calendar.getInstance(); long dateNow = calendar.getTimeInMillis(); java.sql.Date datenowSql = new java.sql.Date(dateNow); System.out.println(datenowSql.toString()); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; try { // java.sql.Connection conDb = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) compName = rset2.getObject(1).toString(); while (rset4.next()) date = rset4.getObject(1).toString(); com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName, pFontHeader2), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase(Debtor + ": Ageing Page: ", pFontHeader), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); double Totals = 0.00; double OS = 0.00; try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(ageingDates.length + 4); String headerWidths = null; java.util.Vector headerVector = new java.util.Vector(1, 1); int z = ageingDates.length; int headerwidths[] = {22, 13, 13, 13, 13, 13, 13, 13}; // ,13,13}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(2); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(8); Phrase phrase = new Phrase(""); table.getDefaultCell().setColspan(5); try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); // java.util.Date endDate1 = // dateFormat.parse(beginDate.toLocaleString());//dateInstance.toLocaleString()); java.util.Date endDate2 = dateFormat.parse(endDate.toLocaleString()); // System.out.println(""+endDate1); // phrase = new Phrase(bank +" Report: " +dateFormat.format(formattedDate), // pFontHeader); // table.addCell(phrase); phrase = new Phrase( Debtor + ": Payer Ageing as at " + dateFormat.format(endDate2), pFontHeader); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setColspan(3); phrase = new Phrase("Printed on : " + date, pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); phrase = new Phrase("Name", pFontHeader); table.addCell(phrase); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase("O/S Balance",pFontHeader); // table.addCell(phrase); for (int x = 0; x < ageingDates.length; x++) { int days = 30; if (x < 1) { phrase = new Phrase("Current", pFontHeader); } else { phrase = new Phrase("Over " + x * days + " Days", pFontHeader); interval = x; } table.addCell(phrase); } // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Over " + ((interval + 1) * 30) + " Days", pFontHeader); table.addCell(phrase); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("UnAlloc.", pFontHeader); table.addCell(phrase); phrase = new Phrase("O/S", pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); // table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { double GrandTotal = 0.00; double Over120Total = 0.00; java.lang.Object[] listofAct = this.getListofActivities(); // java.sql.Connection conDb1 = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); System.out.println(listofAct.length); for (int i = 0; i < listofAct.length; i++) { double TurnOver = 0.00; double Over120 = 0.00; double TotalCount = 0.00; table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); java.sql.PreparedStatement pset10 = connectDB.prepareStatement( "select account_no||' '||scheme_name from ac_schemes WHERE account_no = ?"); // < '"+endDate+"'::date and date > '"+endDate+"'::date - 30 group by dealer"); // java.sql.PreparedStatement pset10 = connectDB.prepareStatement("select distinct // initcap(scheme_manager) as dealer from ac_scheme_providers WHERE scheme_manager = // ?");//< '"+endDate+"'::date and date > '"+endDate+"'::date - 30 group by // dealer"); pset10.setString(1, listofAct[i].toString()); java.sql.ResultSet rset10 = pset10.executeQuery(); while (rset10.next()) table.getDefaultCell().setColspan(1); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase(dbObject.getDBObject(rset10.getObject(1), "-"), pFontHeader1); table.addCell(phrase); // columnTotals[t] = columnTotals[t] + rset.getDouble(1); // table.addCell(phrase); java.sql.Statement st2 = connectDB.createStatement(); java.sql.Statement st21 = connectDB.createStatement(); java.sql.Statement st22 = connectDB.createStatement(); java.sql.Statement st23 = connectDB.createStatement(); java.sql.Statement st211 = connectDB.createStatement(); java.sql.Statement st221 = connectDB.createStatement(); java.sql.Statement st231 = connectDB.createStatement(); java.sql.Statement st2A = connectDB.createStatement(); java.sql.Statement st2B = connectDB.createStatement(); java.sql.Statement st2C = connectDB.createStatement(); java.sql.Statement stc = connectDB.createStatement(); System.out.println("Dealer Is : [" + listofAct[i] + "]."); java.sql.PreparedStatement pset1 = connectDB.prepareStatement( "select sum(balance) from ac_debtors WHERE account_no = ? and dealer = '" + Debtor + "' AND date < '" + ageingDates[0][0] + "'"); // < '"+endDate+"'::date and date > '"+endDate+"'::date - 30 // group by dealer"); // java.sql.PreparedStatement pset1 = connectDB.prepareStatement("select // sum(balance) from ac_debtors WHERE account_no = ? and dealer = '"+Debtor+"' AND // date < '"+ageingDates[ageingDates.length - 1][0]+"'");//< '"+endDate+"'::date and // date > '"+endDate+"'::date - 30 group by dealer"); pset1.setString(1, listofAct[i].toString()); java.sql.ResultSet rset1 = pset1.executeQuery(); java.sql.PreparedStatement pset111 = connectDB.prepareStatement( "select sum(balance-credit_bal) from ac_debtors WHERE account_no = ? and dealer = '" + Debtor + "' AND date < '" + endDate + "'"); // < '"+endDate+"'::date and date > '"+endDate+"'::date - 30 // group by dealer"); pset111.setString(1, listofAct[i].toString()); java.sql.ResultSet rset111 = pset111.executeQuery(); java.sql.Statement st02 = connectDB.createStatement(); java.sql.PreparedStatement pset112 = connectDB.prepareStatement( "select sum(credit_bal) from ac_debtors WHERE account_no = ? and dealer = '" + Debtor + "' AND date < '" + endDate + "'"); // < '"+endDate+"'::date and date > '"+endDate+"'::date - 30 // group by dealer"); pset112.setString(1, listofAct[i].toString()); java.sql.ResultSet rset112 = pset112.executeQuery(); for (int t = ageingDates.length - 1; t >= 0; t--) { // for (int t = 0; t < ageingDates.length; t++) { java.sql.Statement st01 = connectDB.createStatement(); java.sql.PreparedStatement pset = connectDB.prepareStatement( "select sum(balance) from ac_debtors WHERE account_no = ? and dealer = '" + Debtor + "' AND date between '" + ageingDates[t][0] + "' AND '" + ageingDates[t][1] + "'"); pset.setString(1, listofAct[i].toString().toUpperCase()); java.sql.ResultSet rset = pset.executeQuery(); while (rset.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(1)), pFontHeader1); table.addCell(phrase); columnTotals[t] = columnTotals[t] + rset.getDouble(1); } TotalCount = TotalCount + rset.getDouble(1); } while (rset1.next()) { System.out.println("This Result " + rset1.getString(1)); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset1.getString(1)), pFontHeader1); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency("0"),pFontHeader1); Over120 = rset1.getDouble(1); table.addCell(phrase); Over120Total = Over120Total + rset1.getDouble(1); TurnOver = TotalCount + Over120; } while (rset112.next()) { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset112.getString(1)), pFontHeader1); table.addCell(phrase); OS = OS + rset112.getDouble(1); } while (rset111.next()) { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset111.getString(1)), pFontHeader1); table.addCell(phrase); Totals = Totals + rset111.getDouble(1); } } table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); // while (rsetTotals.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rsetTotals.getString(1)), // pFontHeader); // for (int x = 0; x < ageingDates.length; x++) { for (int x = ageingDates.length - 1; x >= 0; x--) { // phrase = new Phrase("Current"+2*x,pFontHeader); // table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(columnTotals[x])), pFontHeader); table.addCell(phrase); } phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(Over120Total)), pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(OS)), pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(Totals)), pFontHeader); table.addCell(phrase); docPdf.add(table); } catch (java.sql.SQLException SqlExec) { SqlExec.printStackTrace(); javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { // Bad javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); try { if (System.getProperty("os.name").equalsIgnoreCase("Linux")) { System.out.println(tempFile); wait_for_Pdf2Show = rt.exec("kghostview " + tempFile + ""); wait_for_Pdf2Show.waitFor(); } else { wait_for_Pdf2Show = rt.exec("c:/Program Files/Adobe/Acrobat 5.0/Reader/AcroRd32.exe " + tempFile); wait_for_Pdf2Show.waitFor(); } } catch (java.lang.InterruptedException intrExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), intrExec.getMessage()); } } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; try { java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.Statement st2x = connectDB.createStatement(); java.sql.ResultSet rset2x = st2x.executeQuery("SELECT rep_currency from pb_hospitalprofile"); while (rset2x.next()) { ks = rset2x.getObject(1).toString(); } java.sql.ResultSet rset2 = st3.executeQuery("SELECT Hospital_name from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName, pFontHeader), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("UnBanked Items - Page: ", pFontHeader), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); double osBalance1 = 0.00; double osBalance = 0.00; double current = 0.00; double osBalancebf = 0.00; try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(5); int headerwidths[] = {11, 10, 20, 15, 15}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.setHeaderRows(4); Phrase phrase = new Phrase("UnBanked Items"); table.addCell(phrase); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(4); try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); java.util.Date endDate1 = dateFormat.parse(endDate.toLocaleString()); // dateInstance.toLocaleString()); java.util.Date beginDate1 = dateFormat.parse(beginDate.toLocaleString()); // dateInstance.toLocaleString()); System.out.println("" + endDate1); // phrase = new Phrase(bank +" Report: " +dateFormat.format(formattedDate), // pFontHeader); // table.addCell(phrase); phrase = new Phrase( "From: " + dateFormat.format(beginDate1) + " To: " + dateFormat.format(endDate1), pFontHeader); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Printed on : " + date, pFontHeader1); table.addCell(phrase); // table.getDefaultCell().setBackgroundColor(java.awt.Color.LIGHT_GRAY); // table.addCell(""); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(1); // table.getDefaultCell().setBackgroundColor(java.awt.Color.LIGHT_GRAY); phrase = new Phrase("Date", pFontHeader); table.addCell(phrase); phrase = new Phrase("ChqNo", pFontHeader); table.addCell(phrase); phrase = new Phrase("Description", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // table.addCell("Reference No."); phrase = new Phrase("Inwards " + ks, pFontHeader); table.addCell(phrase); phrase = new Phrase("Outwards " + ks, pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.WHITE); try { // java.sql.Connection conDb1 = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); java.sql.ResultSet rset = st.executeQuery( "select date,cheque_no,initcap(dealer),debit,credit from ac_cash_book WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "' and reconciled =false ORDER BY date"); // tn,debit_note db WHERE // tn.policy_no != '' and // tn.policy_no = db.policy_no // GROUP BY // tn.policy_no,db.policy_class"); java.sql.ResultSet rsetTotals = st2.executeQuery( "SELECT SUM(debit),SUM(credit) from ac_cash_book WHERE date BETWEEN '" + beginDate + "' AND '" + endDate + "' and reconciled = false"); while (rset.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(1).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); // table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(2).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset.getObject(3).toString(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rsetTotals.getString(1)),pFontHeader); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(4)), pFontHeader1); osBalance1 = osBalance1 + rset.getDouble(4); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(5)), pFontHeader1); osBalancebf = osBalancebf + rset.getDouble(5); // osBalancebf = osBalance1; table.addCell(phrase); } table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); // while (rsetTotals.next()) { table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance1)), pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalancebf)), pFontHeader); table.addCell(phrase); docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(PageSize.A4.rotate()); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase( "KENYA REVENUE AUTHORITY " + "\n INCOME TAX DEPARTMENT " + "\n INCOME TAX DEDUCTION CARD YEAR " + endDate, pFontHeader3), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); headerFoter.setBorderColor(java.awt.Color.WHITE); docPdf.setHeader(headerFoter); // com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter(new // Phrase("P9A \t\t\t\t\t (See back of this card for further information required by the // Department)."), true);// FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, // 12, Font.BOLDITALIC,java.awt.Color.blue)); // docPdf.setFooter(footer); docPdf.open(); try { // java.lang.Object listofStaffNos[] = this.getListofStaffNos(); // for (int j = 0; j < listofStaffNos.length; j++) { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(8); int headerwidths[] = {12, 25, 10, 10, 10, 12, 10, 12}; table.setWidths(headerwidths); table.setWidthPercentage((100)); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setColspan(8); Phrase phrase = new Phrase("", pFontHeader); // table.addCell(phrase); table .getDefaultCell() .setBorder(Rectangle.BOTTOM | Rectangle.LEFT | Rectangle.RIGHT | Rectangle.TOP); table.getDefaultCell().setColspan(1); try { // table.getDefaultCell().setBackgroundColor(java.awt.Color.LIGHT_GRAY); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); phrase = new Phrase("YEAR", pFontHeader); table.addCell(phrase); phrase = new Phrase("DESCRIPTION", pFontHeader); table.addCell(phrase); phrase = new Phrase("DEBIT", pFontHeader); table.addCell(phrase); phrase = new Phrase("CREDIT", pFontHeader); table.addCell(phrase); phrase = new Phrase("TAX/DIVINDED", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); phrase = new Phrase("DATE PAID", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); phrase = new Phrase("TAX REFUND", pFontHeader); table.addCell(phrase); phrase = new Phrase("DATE REFUNDED", pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); java.sql.Statement st = connectDB.createStatement(); java.sql.Statement st11b = connectDB.createStatement(); java.sql.ResultSet rset1 = st.executeQuery( "select tax_year,item_description,debit,credit,tax_divided,case when (date_paid is null) then 'now' else date_paid end as date_paid,tax_refunded,case when (date_refunded is null) then 'now' else date_refunded end as date_refunded from ac_corporation_tax where tax_year BETWEEN '" + beginDate + "' AND '" + endDate + "'"); while (rset1.next()) { table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(rset1.getObject(1).toString(), pFontHeader1); table.addCell(phrase); phrase = new Phrase(rset1.getObject(2).toString().toUpperCase(), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset1.getString(3)), pFontHeader1); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset1.getString(4)), pFontHeader1); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset1.getString(5)), pFontHeader1); table.addCell(phrase); // phrase = new Phrase(new // com.afrisoftech.sys.Format2Currency().Format2Currency(rset1.getString(6)), // pFontHeader1); // table.addCell(phrase); phrase = new Phrase(rset1.getObject(6).toString(), pFontHeader1); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset1.getString(7)), pFontHeader1); table.addCell(phrase); phrase = new Phrase(rset1.getObject(8).toString(), pFontHeader1); table.addCell(phrase); } docPdf.add(table); /* } catch(com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), BadElExec.getMessage()); }*/ System.out.println("Status of new page : " + docPdf.getPageNumber()); boolean boolNewPage = docPdf.newPage(); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } // } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } // } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); try { if (System.getProperty("os.name").equalsIgnoreCase("Linux")) { System.out.println(tempFile); // wait_for_Pdf2Show = rt.exec("kghostview "+tempFile+""); wait_for_Pdf2Show = rt.exec("xpdf " + tempFile + ""); wait_for_Pdf2Show.waitFor(); } else { wait_for_Pdf2Show = rt.exec("c:/Program Files/Adobe/Acrobat 5.0/Reader/AcroRd32.exe " + tempFile); wait_for_Pdf2Show.waitFor(); } } catch (java.lang.InterruptedException intrExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), intrExec.getMessage()); } } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } // } /* public java.lang.Object[] getListofStaffNos() { java.lang.Object[] listofStaffNos = null; java.util.Vector listStaffNoVector = new java.util.Vector(1,1); try { // java.sql.Connection connDB = java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement stmt1 = connectDB.createStatement(); java.sql.ResultSet rSet1 = stmt1.executeQuery("SELECT DISTINCT staff_no FROM tax_card where date BETWEEN '"+beginDate+"' AND '"+endDate+"' order by staff_no"); while (rSet1.next()) { listStaffNoVector.addElement(rSet1.getObject(1).toString()); } }catch (java.sql.SQLException sqlExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), sqlExec.getMessage()); } listofStaffNos = listStaffNoVector.toArray(); System.out.println("Done list of Staff Nos ..."); return listofStaffNos; } public java.lang.Object[] getListofStaffNos1() { java.lang.Object[] listofStaffNos1 = null; java.util.Vector listStaffNoVector1 = new java.util.Vector(1,1); try { // java.sql.Connection connDB = java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement stmt1 = connectDB.createStatement(); java.sql.ResultSet rSet1 = stmt1.executeQuery("SELECT DISTINCT month FROM tax_card where date BETWEEN '"+beginDate+"' AND '"+endDate+"' order by month"); while (rSet1.next()) { listStaffNoVector1.addElement(rSet1.getObject(1).toString()); } }catch (java.sql.SQLException sqlExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), sqlExec.getMessage()); } listofStaffNos1 = listStaffNoVector1.toArray(); System.out.println("Done list of Staff Nos ..."); return listofStaffNos1; }*/ }
public void generatePdf() { // java.lang.Object[][] ageingDates = periodicDates.getMonthlyDates(); ageingDates = ageingSeries.getAgeingDateSeries(); double columnTotals[] = new double[ageingDates.length]; double columnTotals2[] = new double[ageingDates.length]; java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); int interval = 0; try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); java.util.Calendar calendar = java.util.Calendar.getInstance(); long dateNow = calendar.getTimeInMillis(); java.sql.Date datenowSql = new java.sql.Date(dateNow); System.out.println(datenowSql.toString()); try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; try { // java.sql.Connection conDb = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name,rep_currency from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); ks = rset2.getString(2); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName, pFontHeader2), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Ageing Page: ", pFontHeader), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); double Totals = 0.00; double OS = 0.00; try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(ageingDates.length + 5); String headerWidths = null; java.util.Vector headerVector = new java.util.Vector(1, 1); int z = ageingDates.length; int headerwidths[] = {7, 35, 13, 13, 13, 13, 13, 13, 13}; // ,13,13}; table.setWidths(headerwidths); table.setWidthPercentage((107)); table.setHeaderRows(2); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(9); Phrase phrase = new Phrase(""); table.getDefaultCell().setColspan(6); try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); // java.util.Date endDate1 = // dateFormat.parse(beginDate.toLocaleString());//dateInstance.toLocaleString()); java.util.Date endDate2 = dateFormat.parse(endDate.toLocaleString()); phrase = new Phrase("Debtors Ageing as at " + dateFormat.format(endDate2), pFontHeader); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); table.getDefaultCell().setColspan(3); phrase = new Phrase("Printed on : " + date, pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER); phrase = new Phrase("No.", pFontHeader); table.addCell(phrase); phrase = new Phrase("Name", pFontHeader); table.addCell(phrase); for (int x = 0; x < ageingDates.length; x++) { // for (int x = ageingDates.length - 1; x >= 0; x--) { int days = 30; if (x < 1) { phrase = new Phrase("Current", pFontHeader); } else { phrase = new Phrase("+ " + x * days + " Days", pFontHeader); interval = x; } table.addCell(phrase); } phrase = new Phrase("+ " + ((interval + 1) * 30) + " Days", pFontHeader); table.addCell(phrase); phrase = new Phrase("UnAlloc.", pFontHeader); table.addCell(phrase); phrase = new Phrase("O/S " + ks, pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); try { double GrandTotal = 0.00; double Over120Total = 0.00; java.lang.Object[] listofAct = this.getListofActivities(); System.out.println(listofAct.length); for (int i = 0; i < listofAct.length; i++) { double TurnOver = 0.00; double Over120 = 0.00; double TotalCount = 0.00; double unalloc = 0.00; double Curr120 = 0.00; double bals = 0.00; // java.lang.Object[] listofActinv = this.getListofActivitiesinv(listofAct[i]); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(1); java.sql.Statement stmta1 = connectDB.createStatement(); java.sql.PreparedStatement pSeta1 = connectDB.prepareStatement( "SELECT count(account_no) FROM ac_debtors" + " where account_no = '" + listofAct[i] + "'"); java.sql.PreparedStatement pset22 = connectDB.prepareStatement( "select distinct account_no||' '||scheme_name from " + "ac_schemes WHERE account_no = ? order by 1 ASC"); // < // '"+endDate+"'::date and date > '"+endDate+"'::date - 30 group by dealer"); pset22.setString(1, listofAct[i].toString().toUpperCase()); java.sql.ResultSet rSeta1 = pSeta1.executeQuery(); while (rSeta1.next()) { name = rSeta1.getInt(1); } if (name > 0) { java.sql.ResultSet rset22 = pset22.executeQuery(); while (rset22.next()) { cnt = cnt + 1; phrase = new Phrase("" + cnt, pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(1); phrase = new Phrase(dbObject.getDBObject(rset22.getObject(1), "-"), pFontHeader1); table.addCell(phrase); java.sql.Statement st2 = connectDB.createStatement(); java.sql.Statement st21 = connectDB.createStatement(); java.sql.Statement st22 = connectDB.createStatement(); java.sql.Statement st23 = connectDB.createStatement(); java.sql.Statement st211 = connectDB.createStatement(); java.sql.Statement st221 = connectDB.createStatement(); java.sql.Statement st231 = connectDB.createStatement(); java.sql.Statement st2A = connectDB.createStatement(); java.sql.Statement st2B = connectDB.createStatement(); java.sql.Statement st2C = connectDB.createStatement(); java.sql.Statement stc = connectDB.createStatement(); System.out.println("Dealer Is : [" + listofAct[i] + "]."); java.sql.PreparedStatement pset111 = connectDB.prepareStatement( "select sum(debit-credit) from ac_debtors " + "WHERE account_no = ? AND date <= '" + endDate + "'"); // < '"+endDate+"'::date and date > '"+endDate+"'::date - 30 // group by dealer"); pset111.setString(1, listofAct[i].toString()); java.sql.ResultSet rset111 = pset111.executeQuery(); java.sql.Statement st02 = connectDB.createStatement(); java.sql.PreparedStatement pset112 = connectDB.prepareStatement( "select sum(credit) from ac_debtors" + " WHERE account_no = ? AND date <= '" + endDate + "'"); // < '"+endDate+"'::date and date > '"+endDate+"'::date - 30 // group by dealer"); pset112.setString(1, listofAct[i].toString()); java.sql.ResultSet rset112 = pset112.executeQuery(); // for (int k = 0; k < listofActinv.length; k++) { for (int t = ageingDates.length - 1; t >= 0; t--) { columnTotals[t] = 0.00; double credo = 0.00; double credo1 = 0.00; Over120 = 0.00; java.sql.Statement st01 = connectDB.createStatement(); java.sql.PreparedStatement pset = connectDB.prepareStatement( "select sum(debit),invoice_no from ac_debtors " + "WHERE account_no = ? AND date between '" + ageingDates[t][0] + "' AND '" + ageingDates[t][1] + "' " + " GROUP BY invoice_no order by 2 ASC"); pset.setString(1, listofAct[i].toString().toUpperCase()); java.sql.ResultSet rset = pset.executeQuery(); while (rset.next()) { String invoiceNo = rset.getString(2); java.sql.Statement st01x = connectDB.createStatement(); java.sql.PreparedStatement psetx = connectDB.prepareStatement( "select sum(credit),invoice_no from ac_debtors" + " WHERE account_no = ? AND date <= '" + endDate + "' AND invoice_no = '" + invoiceNo + "' GROUP BY invoice_no order by 2 ASC "); psetx.setString(1, listofAct[i].toString().toUpperCase()); java.sql.ResultSet rsetx = psetx.executeQuery(); while (rsetx.next()) { credo = rsetx.getDouble(1); } table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); columnTotals[t] = columnTotals[t] + (rset.getDouble(1) - credo); TotalCount = TotalCount + (rset.getDouble(1) - credo); columnTotals2[t] = columnTotals2[t] + (rset.getDouble(1) - credo); } } for (int t = ageingDates.length - 1; t >= 0; t--) { table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(columnTotals[t])), pFontHeader1); table.addCell(phrase); // } } table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); while (rset111.next()) { bals = rset111.getDouble(1); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(bals - TotalCount)), pFontHeader1); table.addCell(phrase); Over120Total = Over120Total + (bals - TotalCount); // Over120Total = Over120Total+ rset1.getDouble(1); TurnOver = TotalCount + Curr120; phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(bals - bals)), pFontHeader1); table.addCell(phrase); OS = OS + unalloc; phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset111.getString(1)), pFontHeader1); table.addCell(phrase); Totals = Totals + rset111.getDouble(1); } } } } table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); // while (rsetTotals.next()) { table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(1); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); for (int x = ageingDates.length - 1; x >= 0; x--) { phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(columnTotals2[x])), pFontHeader); table.addCell(phrase); grandTot = grandTot + columnTotals2[x]; } phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(Totals - grandTot)), pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(OS)), pFontHeader); table.addCell(phrase); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(Totals)), pFontHeader); table.addCell(phrase); docPdf.add(table); } catch (java.sql.SQLException SqlExec) { SqlExec.printStackTrace(); javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } /* } catch(java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), psExec.getMessage()); } */ } catch (com.lowagie.text.BadElementException BadElExec) { // Bad javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }
public void generatePdf() { java.lang.Process wait_for_Pdf2Show; java.util.Calendar cal = java.util.Calendar.getInstance(); java.util.Date dateStampPdf = cal.getTime(); java.lang.String pdfDateStamp = dateStampPdf.toString(); try { java.io.File tempFile = java.io.File.createTempFile("REP" + this.getDateLable() + "_", ".pdf"); tempFile.deleteOnExit(); java.lang.Runtime rt = java.lang.Runtime.getRuntime(); java.lang.String debitTotal = null; java.lang.String creditTotal = null; com.lowagie.text.Document docPdf = new com.lowagie.text.Document(); double osBalance = 0.00; double current = 0.00; try { try { com.lowagie.text.pdf.PdfWriter.getInstance( docPdf, new java.io.FileOutputStream(tempFile)); String compName = null; String date = null; try { // java.sql.Connection conDb = // java.sql.DriverManager.getConnection("jdbc:postgresql://localhost:5432/sako","postgres","pilsiner"); java.sql.Statement st3 = connectDB.createStatement(); java.sql.Statement st4 = connectDB.createStatement(); java.sql.ResultSet rset2 = st3.executeQuery("SELECT hospital_name,rep_currency from pb_hospitalprofile"); java.sql.ResultSet rset4 = st4.executeQuery("SELECT date('now') as Date"); while (rset2.next()) { compName = rset2.getObject(1).toString(); ks = rset2.getString(2); } while (rset4.next()) { date = rset4.getObject(1).toString(); } com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter( new Phrase("" + compName + ""), false); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setAlignment(com.lowagie.text.HeaderFooter.ALIGN_CENTER); // com.lowagie.text.HeaderFooter headerFoter = new com.lowagie.text.HeaderFooter(new // Phrase(""+compName+""),false);// // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 14, // Font.BOLDITALIC,java.awt.Color.blue))); headerFoter.setRight(5); docPdf.setHeader(headerFoter); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } com.lowagie.text.HeaderFooter footer = new com.lowagie.text.HeaderFooter( new Phrase("Expenses - Page: "), true); // FontFactory.getFont(com.lowagie.text.FontFactory.HELVETICA, 12, // Font.BOLDITALIC,java.awt.Color.blue)); docPdf.setFooter(footer); docPdf.open(); try { com.lowagie.text.pdf.PdfPTable table = new com.lowagie.text.pdf.PdfPTable(6); int headerwidths[] = {15, 15, 15, 25, 20, 10}; table.setWidths(headerwidths); table.setHeaderRows(2); table.setWidthPercentage((100)); table.getDefaultCell().setBorder(Rectangle.BOTTOM); table.getDefaultCell().setColspan(6); Phrase phrase = new Phrase("", pFontHeader); try { java.text.DateFormat dateFormat = java.text.DateFormat.getDateInstance(java.text.DateFormat.MEDIUM); // MEDIUM); java.util.Date endDate1 = dateFormat.parse(endDate.toLocaleString()); // dateInstance.toLocaleString()); java.util.Date endDate11 = dateFormat.parse(beginDate.toLocaleString()); // dateInstance.toLocaleString()); System.out.println("" + endDate1); // phrase = new Phrase(bank +" Report: " +dateFormat.format(formattedDate), // pFontHeader); // table.addCell(phrase); table.getDefaultCell().setColspan(4); phrase = new Phrase( "Expenses : Period : " + dateFormat.format(endDate11) + " ------ " + dateFormat.format(endDate1), pFontHeader); table.addCell(phrase); table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Printed On :" + date, pFontHeader); table.addCell(phrase); } catch (java.text.ParseException psExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), psExec.getMessage()); } // Phrase phrase = new Phrase("Patients List As At:" +endDate, pFontHeader); // table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); table.getDefaultCell().setColspan(2); // table.getDefaultCell().setBackgroundColor(java.awt.Color.LIGHT_GRAY); phrase = new Phrase("Gl Code", pFontHeader); table.addCell(phrase); phrase = new Phrase("Description ", pFontHeader); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase("Amount " + ks, pFontHeader); table.addCell(phrase); table.getDefaultCell().setBackgroundColor(java.awt.Color.WHITE); try { java.sql.Statement st = connectDB.createStatement(); java.sql.ResultSet rset = st.executeQuery( "select ac.gl_code,pb.activity,sum(ac.debit-ac.credit) from tb_itemized_summary ac,pb_activity pb where ac.date BETWEEN '" + beginDate + "' AND '" + endDate + "' and ac.gl_code = pb.code and pb.activity_category ilike 'E' group by ac.gl_code,pb.activity order by pb.activity"); java.sql.Statement st1 = connectDB.createStatement(); java.sql.Statement st2 = connectDB.createStatement(); while (rset.next()) { table.getDefaultCell().setColspan(2); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(1), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase(dbObject.getDBObject(rset.getObject(2), "-"), pFontHeader1); table.addCell(phrase); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(rset.getString(3)), pFontHeader); osBalance = osBalance + rset.getDouble(3); table.addCell(phrase); } table.getDefaultCell().setBorderColor(java.awt.Color.BLACK); table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT); phrase = new Phrase("Total", pFontHeader1); table.addCell(phrase); table.getDefaultCell().setColspan(3); table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT); phrase = new Phrase( new com.afrisoftech.sys.Format2Currency() .Format2Currency(java.lang.String.valueOf(osBalance)), pFontHeader); table.addCell(phrase); docPdf.add(table); } catch (java.sql.SQLException SqlExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), SqlExec.getMessage()); } // // } } catch (com.lowagie.text.BadElementException BadElExec) { javax.swing.JOptionPane.showMessageDialog( new javax.swing.JFrame(), BadElExec.getMessage()); } } catch (java.io.FileNotFoundException fnfExec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), fnfExec.getMessage()); } } catch (com.lowagie.text.DocumentException lwDocexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), lwDocexec.getMessage()); } docPdf.close(); com.afrisoftech.lib.PDFRenderer.renderPDF(tempFile); } catch (java.io.IOException IOexec) { javax.swing.JOptionPane.showMessageDialog(new javax.swing.JFrame(), IOexec.getMessage()); } }