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(
new Rectangle(
java.lang.Float.parseFloat(System.getProperty("papersize_width")),
java.lang.Float.parseFloat(System.getProperty("papersize_legnth"))),
java.lang.Float.parseFloat(System.getProperty("receiptPageMargin")),
java.lang.Float.parseFloat(System.getProperty("receiptPageMargin")),
java.lang.Float.parseFloat(System.getProperty("receiptPageMargin")),
java.lang.Float.parseFloat(System.getProperty("receiptPageMargin")));
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+" 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("Member Statements - 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);
// com.lowagie.text.rtf.RtfTable table = new com.lowagie.text.rtf.RtfTable();
// Table table = new Table(6);
int headerwidths[] = {15, 20, 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().setBorderColor(java.awt.Color.WHITE);
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 st5 = connectDB.createStatement();
java.sql.Statement st6 = connectDB.createStatement();
java.sql.Statement st3 = 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 rset1 = st1.executeQuery("select
// cb.dealer,cb.receipt_no,CURRENT_TIMESTAMP(0),cb.patient_no from ac_cash_collection
// cb, hp_patient_card pc where cb.patient_no = '"+MNo+"' AND cb.date::date =
// current_date AND cb.transaction_type = 'Receipts' AND pc.paid = false");
java.sql.ResultSet rset1 = st1.executeQuery("select CURRENT_TIMESTAMP(0)");
// java.sql.ResultSet rsetTotals = st2.executeQuery("select sum(pc.credit) as
// debit from hp_patient_card pc where pc.patient_no = '"+MNo+"' AND
// pc.transaction_type = 'Receipts' AND pc.paid = false AND pc.date::date =
// current_date");
// java.sql.ResultSet rs = st.executeQuery("select cb.receipt_no from
// ac_cash_collection cb, hp_patient_card pc where cb.patient_no = '"+MNo+"' AND
// pc.paid = false AND pc.date::date = current_date");
java.sql.ResultSet rset5 =
st5.executeQuery(
"select description,sum(quantity),sum(debit) from ac_cash_collection where patient_no = '"
+ MNo
+ "' AND date::date = current_date and receipt_no = '"
+ Receipt
+ "' group by description");
java.sql.ResultSet rset6 =
st6.executeQuery(
"select distinct user_name,cash_point from ac_cash_collection where patient_no = '"
+ MNo
+ "' AND date = current_date");
System.out.println(MNo);
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: " + rset3.getObject(3).toString(), pFontHeader);
table.addCell(phrase);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
phrase = new Phrase("Fax: " + 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: " + rset3.getObject(6).toString(), pFontHeader);
table.addCell(phrase);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
phrase = new Phrase("Website: " + rset3.getObject(7).toString(), pFontHeader);
table.addCell(phrase);
/// table.addCell(" ");
}
// table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
// table.getDefaultCell().setBorderWidth(Rectangle.TOP);
while (rset1.next()) table.getDefaultCell().setColspan(2);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
// phrase = new Phrase("Receipt No. "+ rset1.getString(2), pFontHeader);
phrase = new Phrase("Receipt No. " + Receipt, pFontHeader);
table.addCell(phrase);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
table.getDefaultCell().setColspan(4);
phrase = new Phrase("RECEIPT ", pFontHeader1);
table.addCell(phrase);
table.getDefaultCell().setColspan(2);
table.getDefaultCell().setBorderColor(java.awt.Color.WHITE);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
// phrase = new Phrase("Patient No. "+ rset1.getObject(4).toString(), pFontHeader);
phrase = new Phrase("Patient No. " + MNo, pFontHeader);
table.addCell(phrase);
// phrase = new Phrase("Name "+ rset1.getObject(1).toString(), pFontHeader);
phrase = new Phrase("Name " + Name, pFontHeader);
table.addCell(phrase);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
phrase = new Phrase("Date " + rset1.getObject(1).toString(), pFontHeader);
table.addCell(phrase);
table.getDefaultCell().setColspan(3);
phrase = new Phrase("Description", pFontHeader);
table.addCell(phrase);
table.getDefaultCell().setColspan(1);
phrase = new Phrase("Qty", pFontHeader);
table.addCell(phrase);
// table.addCell("Description");
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
table.getDefaultCell().setColspan(2);
phrase = new Phrase("Amount KShs.", pFontHeader);
table.addCell(phrase);
while (rset5.next()) {
table.getDefaultCell().setColspan(3);
table.getDefaultCell().setBorderColor(java.awt.Color.WHITE);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
phrase = new Phrase(rset5.getObject(1).toString(), pFontHeader);
table.addCell(phrase);
table.getDefaultCell().setColspan(1);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
phrase = new Phrase(rset5.getObject(2).toString(), pFontHeader);
table.addCell(phrase);
table.getDefaultCell().setColspan(2);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
phrase =
new Phrase(
new com.afrisoftech.sys.Format2Currency()
.Format2Currency(rset5.getString(3)),
pFontHeader);
table.addCell(phrase);
}
/* table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT);
phrase = new Phrase(new com.afrisoftech.sys.Format2Currency().Format2Currency(rset1.getString(5)),pFontHeader);
table.addCell(phrase);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT);
phrase = new Phrase(new com.afrisoftech.sys.Format2Currency().Format2Currency(rset1.getString(6)),pFontHeader);
table.addCell(phrase);
}
*/
// table.getDefaultCell().setBorderColor(java.awt.Color.BLACK);
// table.getDefaultCell().setBorder(Rectangle.BOTTOM | Rectangle.TOP);
// while (rsetTotals.next()) {
table.getDefaultCell().setColspan(4);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
phrase = new Phrase("Total", pFontHeader);
table.addCell(phrase);
table.getDefaultCell().setColspan(2);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_CENTER);
// phrase = new Phrase(new
// com.afrisoftech.sys.Format2Currency().Format2Currency(rsetTotals.getString(1)),pFontHeader);
phrase =
new Phrase(
new com.afrisoftech.sys.Format2Currency().Format2Currency(Amount),
pFontHeader);
table.addCell(phrase);
/* table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT);
phrase = new Phrase(new com.afrisoftech.sys.Format2Currency().Format2Currency(rsetTotals.getString(2)),pFontHeader);
//phrase = new Phrase(" ");
table.addCell(phrase);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_RIGHT);
phrase = new Phrase(new com.afrisoftech.sys.Format2Currency().Format2Currency(rsetTotals.getString(3)),pFontHeader);
table.addCell(phrase);
*/
// }
while (rset6.next()) table.getDefaultCell().setColspan(3);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
phrase = new Phrase("Payment Mode : " + Paymode, pFontHeader);
table.addCell(phrase);
table.getDefaultCell().setColspan(3);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
phrase = new Phrase("Served By : " + rset6.getString(1), pFontHeader);
table.addCell(phrase);
table.getDefaultCell().setColspan(3);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
phrase = new Phrase("Cash Point : " + rset6.getString(2).toString(), pFontHeader);
table.addCell(phrase);
table.getDefaultCell().setHorizontalAlignment(PdfCell.ALIGN_LEFT);
table.getDefaultCell().setColspan(3);
phrase = new Phrase("Thank You. We wish You quick recovery", pFontHeader);
table.addCell(phrase);
docPdf.add(table);
// java.sql.PreparedStatement pstmt4 = connectDB.prepareStatement("UPDATE
// hp_patient_card SET paid ='true' WHERE patient_no = '"+MNo+"' AND date::date =
// current_date");
// pstmt4.executeUpdate();
} 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 = rt.exec("kword " + tempFile + "");
// wait_for_Pdf2Show = rt.exec("cat kghostview "+tempFile+"");
wait_for_Pdf2Show.waitFor();
} else if (System.getProperty("os.name").equalsIgnoreCase("Windows 98")) {
wait_for_Pdf2Show = rt.exec("command.exe /C AcroRd32 /p /h " + tempFile);
wait_for_Pdf2Show.waitFor();
// wait_for_Pdf2Show = rt.exec("c:/Program Files/Adobe/Acrobat 5.0/Reader/AcroRd32.exe
// "+tempFile);
// wait_for_Pdf2Show.waitFor();
} else {
wait_for_Pdf2Show = rt.exec("cmd.exe /C AcroRd32 /p /h " + tempFile);
wait_for_Pdf2Show.waitFor();
// 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.String getDateLable() {
java.lang.String date_label = null;
java.lang.String month_now_strs = null;
java.lang.String date_now_strs = null;
java.lang.String year_now_strs = null;
java.lang.String minute_now_strs = null;
java.lang.String hour_now_strs = null;
java.lang.Runtime rt = java.lang.Runtime.getRuntime();
java.util.Calendar calinst = java.util.Calendar.getInstance();
java.util.Date date_now = calinst.getTime();
int date_now_str = date_now.getDate();
int month_now_str = date_now.getMonth();
int year_now_str = date_now.getYear();
int hour_now_str = date_now.getHours();
int minute_now_str = date_now.getMinutes();
int year_now_abs = year_now_str - 100;
if (year_now_abs < 10) {
year_now_strs = "200" + year_now_abs;
} else {
year_now_strs = "20" + year_now_abs;
}
switch (month_now_str) {
case 0:
month_now_strs = "JAN";
break;
case 1:
month_now_strs = "FEB";
break;
case 2:
month_now_strs = "MAR";
break;
case 3:
month_now_strs = "APR";
break;
case 4:
month_now_strs = "MAY";
break;
case 5:
month_now_strs = "JUN";
break;
case 6:
month_now_strs = "JUL";
break;
case 7:
month_now_strs = "AUG";
break;
case 8:
month_now_strs = "SEP";
break;
case 9:
month_now_strs = "OCT";
break;
case 10:
month_now_strs = "NOV";
break;
case 11:
month_now_strs = "DEC";
break;
default:
if (month_now_str < 10) {
month_now_strs = "0" + month_now_str;
} else {
month_now_strs = "" + month_now_str;
}
}
if (date_now_str < 10) {
date_now_strs = "0" + date_now_str;
} else {
date_now_strs = "" + date_now_str;
}
if (minute_now_str < 10) {
minute_now_strs = "0" + minute_now_str;
} else {
minute_now_strs = "" + minute_now_str;
}
if (hour_now_str < 10) {
hour_now_strs = "0" + hour_now_str;
} else {
hour_now_strs = "" + hour_now_str;
}
date_label =
date_now_strs + month_now_strs + year_now_strs + "@" + hour_now_strs + minute_now_strs;
return date_label;
}