Discussion: Using Itext to create a report

ATUAHENE OPPONG JONES

Member

ATUAHENE OPPONG JONES:1/4/2017 5:43

please am using Itext to create report but everything goes to the App Data in the drive C:
please can you give me an alternative so that after installing the user can direct where he chooses to save the reports after generating. thanks.

String ch = inv.getText();
String dataFolder = System.getenv("APPDATA") + "/Stock reports/" + ch + ".pdf";

try {
Document my_pdf_report = new Document(new Rectangle(981.1f, 696.85f)) {
};

PdfWriter writer = PdfWriter.getInstance(my_pdf_report, new FileOutputStream(dataFolder));
my_pdf_report.open();
// // add image
// Image image=Image.getInstance(dataFolder+"ksoftlogo.jpg");
// my_pdf_report.add(new Paragraph("Ksoft",FontFactory.getFont(FontFactory.TIMES_BOLDITALIC,18,Font.BOLD,BaseColor.GREEN)));
// my_pdf_report.add(image);
PdfContentByte cb = writer.getDirectContent();
BarcodeEAN code = new BarcodeEAN();
//code.setCode("1234567891011");
Paragraph para = new Paragraph();

my_pdf_report.add(new Paragraph("Barcode UPC-A"));
code.setCodeType(Barcode.UPCA);
code.setCode("1098765432112");
my_pdf_report.add(code.createImageWithBarcode(cb, BaseColor.BLACK, BaseColor.BLACK));

my_pdf_report.add(para);

my_pdf_report.add(new Paragraph(" ***JUST LOVE ENTERPRISE ® ***\n 0241918131/0241224726 \n"
+ ""
+ " KUMASI", FontFactory.getFont(FontFactory.HELVETICA_BOLD, 24, Font.BOLD, BaseColor.BLUE)));
my_pdf_report.add(new Paragraph(" " + new Date().toGMTString()));
my_pdf_report.add(new Paragraph("========================================================================================================"));

// //creating title for my table

PdfPTable header = new PdfPTable(12);

header.addCell("INVOICE");
header.addCell("PRODUCT ID");
header.addCell("PRODUCT NAME");
header.addCell("QTY");
header.addCell("UNIT COST");
header.addCell("TOTAL QTY");
header.addCell("GRD TOTAL");
header.addCell("AMT PAID");
header.addCell("BAL");
header.addCell("Pay MODE");
header.addCell("STATUS");
header.addCell("BILL DATE");

my_pdf_report.add(header);

String url = "jdbc:mysql://localhost:3306/";
String dbName = "inventory";
String driver = "com.mysql.jdbc.Driver";
String userName = "root";
String password = "";
try{

Class.forName(driver).newInstance();
con = DriverManager.getConnection(url + dbName, userName, password);
// String sql = "select * from log";
// pst = con.prepareStatement(sql);
//
// rs = pst.executeQuery();
rs = stmt.executeQuery("SELECT p.Invoice, p.TotalQty, p.SubTotal, p.Amtpay, p.Bal, p.Paymode, p.Cstatus, p.BillDate, s.PID, s.Pname, s.Qtypurchased, s.Unitcost, s.TCost FROM productsales AS p Natural join sales AS s where Invoice like '%"+ch+"'");
/* Step-2: Initialize PDF my_pdf_reports - logical objects */

// PdfWriter.getInstance(my_pdf_report, new FileOutputStream("Report1.pdf"));
// my_pdf_report.open();

//we have four columns in our table

PdfPTable my_report_table = new PdfPTable(12);
//create a cell object
PdfPCell table_cell;
System.out.println("check 2");
while (rs.next()) {

String dept_id = rs.getString("Invoice");
table_cell=new PdfPCell(new Phrase(dept_id));
my_report_table.addCell(table_cell);
String pi=rs.getString("PID");
table_cell=new PdfPCell(new Phrase(pi));
my_report_table.addCell(table_cell);
String pn=rs.getString("Pname");
table_cell=new PdfPCell(new Phrase(pn));
my_report_table.addCell(table_cell);
String qt=rs.getString("Qtypurchased");
table_cell=new PdfPCell(new Phrase(qt));
my_report_table.addCell(table_cell);

String uc=rs.getString("Unitcost");
table_cell=new PdfPCell(new Phrase(uc));
my_report_table.addCell(table_cell);
String tc=rs.getString("TotalQty");
table_cell=new PdfPCell(new Phrase(tc));
my_report_table.addCell(table_cell);

String surname=rs.getString("SubTotal");
table_cell=new PdfPCell(new Phrase(surname));
my_report_table.addCell(table_cell);
String manager_id=rs.getString("Amtpay");
table_cell=new PdfPCell(new Phrase(manager_id));
my_report_table.addCell(table_cell);

String bal=rs.getString("Bal");
table_cell=new PdfPCell(new Phrase(bal));
my_report_table.addCell(table_cell);
String pmod=rs.getString("Paymode");
table_cell=new PdfPCell(new Phrase(pmod));
my_report_table.addCell(table_cell);
String cs=rs.getString("Cstatus");
table_cell=new PdfPCell(new Phrase(cs));
my_report_table.addCell(table_cell);
String bill=rs.getString("BillDate");
table_cell=new PdfPCell(new Phrase(bill));
my_report_table.addCell(table_cell);

}
/* Attach report table to PDF */
my_pdf_report.add(my_report_table);

/* Close all DB related objects */
//adding List Items
com.itextpdf.text.List list = new com.itextpdf.text.List(true, 20);
list.add("General Comment :................................................\t \n................................................................................\n................................................................................\n");
list.add("Admin's Remarks :........................................................\t \n................................................................................\n................................................................................\n");

my_pdf_report.add(list);

//
my_pdf_report.topMargin();
my_pdf_report.add(new Paragraph(" \n "
+ ""
+ ""
+ ""
+ ""
+ ""
+ ""
+ ""
+ ""
+ ""
+ ""
+ ""
+ ""
+ ""
+ ""
+ " "
+ ""
+ ""
+ ""
+ ""
+ ""
+ ""
+ ""
+ ""
+ ""
+ " Powered by T.K ©2016"));

// my_pdf_report.close();
JOptionPane.showMessageDialog(null, "Report Saved\n"
+ "Please Check Report Folder"
);
my_pdf_report.close();

try {
File myFile = new File(dataFolder);
Desktop.getDesktop().open(myFile);
} catch (IOException ex) {
// no application registered for PDFs
JOptionPane.showMessageDialog(null, ex.getMessage());
}
} catch (Exception e) {
JOptionPane.showMessageDialog(null, e.getMessage());
}

}
catch(Exception e){

}

1/4/2017 5:43

Technology For Life

David Capka

ICT.social team

Replies to ATUAHENE OPPONG JONES
David Capka:1/4/2017 9:43

Please, use the </> button to insert source codes to the forum. The AppData folder is specified at the start of your code:

String dataFolder = System.getenv("APPDATA") + "/Stock reports/" + ch + ".pdf";

To make the user select a path in Java Swing, use JFileChooser instead:

JFileChooser chooser = new JFileChooser();
chooser.setCurrentDirectory(new java.io.File("."));
chooser.setDialogTitle("Choose the destination path");
chooser.setFileSelectionMode(JFileChooser.DIRECTORIES_ONLY); // Only folders
chooser.setAcceptAllFileFilterUsed(false);

if (chooser.showOpenDialog(null) == JFileChooser.APPROVE_OPTION) {
      String dataFolder = chooser.getCurrentDirectory() + ch + ".pdf";;
} else {
      // Show error message here or perform any failure action you want to
}

Also consider switching to JavaFX.

Edited 1/4/2017 9:43

Up Reply

1/4/2017 9:43

You can walk through a storm and feel the wind but you know you are not the wind.

ATUAHENE OPPONG JONES

Member

ATUAHENE OPPONG JONES:1/4/2017 11:07

am highly grateful it worked as i wanted. PERFECT.
Please Mr. David with respect to the JavaFX i have no idea but if you can give me tutorial notes .pdf on it i will do perfectly well.
hope to get that help from you because I Love working with java than any other platform.
thanks very much.
from Jones.

Up Reply

1/4/2017 11:07

Technology For Life

ATUAHENE OPPONG JONES

Member

ATUAHENE OPPONG JONES:1/4/2017 12:19

please the directory is ook but the pdf becomes empty without leaving the file (pdf) in it.
what should i do.

Up Reply

1/4/2017 12:19

Technology For Life

David Capka

ICT.social team

Replies to ATUAHENE OPPONG JONES
David Capka:1/4/2017 16:30

And are you sure that the code generating the PDF file works? If so, try to print what is in the dataFolder variable at the end:

System.out.println(dataFolder);

What does it print? Maybe I forgot to add a slash:

chooser.getCurrentDirectory() + "/" + ch + ".pdf";

Up Reply

1/4/2017 16:30

You can walk through a storm and feel the wind but you know you are not the wind.

ATUAHENE OPPONG JONES

Member

ATUAHENE OPPONG JONES:1/4/2017 16:54

the pdf file comes alright but cant save to the folder like my first code.
so please help me Boss

Up Reply

1/4/2017 16:54

Technology For Life

David Capka

ICT.social team

Replies to ATUAHENE OPPONG JONES
David Capka:1/5/2017 2:22

Try to print the path as I wrote in the last message and to add the extra slash.

Up Reply

1/5/2017 2:22

You can walk through a storm and feel the wind but you know you are not the wind.

PHP professional, $7000 a month. Like the sound of that? We'll get you there for $120.

Discover more...

PHP professional, $7000 a month. Like the sound of that? We'll get you there for $120.

PHP e-shop course

To maintain the quality of discussion, we only allow registered members to comment. Sign in. If you're new, Sign up, it's free.

7 messages from 7 displayed.