package com.ronald.gantengtimesheet.report;
import java.io.File;
import java.io.FileOutputStream;
import java.text.DateFormat;
import java.util.ArrayList;
import java.util.Calendar;
import java.util.Date;
import java.util.List;
import java.util.Map;
import java.util.TreeMap;
import javax.swing.JProgressBar;
import org.jdesktop.swingx.JXLabel;
import com.itextpdf.text.BaseColor;
import com.itextpdf.text.Chunk;
import com.itextpdf.text.Document;
import com.itextpdf.text.DocumentException;
import com.itextpdf.text.Element;
import com.itextpdf.text.Font;
import com.itextpdf.text.FontFactory;
import com.itextpdf.text.PageSize;
import com.itextpdf.text.Paragraph;
import com.itextpdf.text.Rectangle;
import com.itextpdf.text.pdf.PdfPCell;
import com.itextpdf.text.pdf.PdfPTable;
import com.itextpdf.text.pdf.PdfWriter;
import com.itextpdf.text.pdf.draw.LineSeparator;
import com.ronald.gantengtimesheet.config.Config;
import com.ronald.gantengtimesheet.db.RecordEntity;
import com.ronald.gantengtimesheet.ui.util.Util;
public class Report {
private static Report instance;
public static synchronized Report getInstance() {
if (instance == null) {
instance = new Report();
}
return instance;
}
private Report() {}
private Date start;
private Date end;
private JProgressBar progress;
private JXLabel progressLabel;
private String invoiceNumber;
private final Map<Date, List<RecordEntity>> map = new TreeMap<Date, List<RecordEntity>>();
public File exportToPDF(final File output, final String invoiceNumber, final Date start, final Date end,
final List<RecordEntity> recordEntities, final Boolean skipEmptyRecords,
final JProgressBar progress, final JXLabel progressLabel) {
try {
this.start = start;
this.end = end;
this.progress = progress;
this.progressLabel = progressLabel;
this.invoiceNumber = invoiceNumber;
processMap(recordEntities);
final Document document = new Document(PageSize.A4, 20, 20, 10, 10);
PdfWriter.getInstance(document, new FileOutputStream(output));
document.open();
addMetaData(document);
addTitle(document);
addTable(document, skipEmptyRecords);
addNotes(document);
document.close();
} catch (final Exception e) {
e.printStackTrace();
return null;
}
return output;
}
private void processMap(final List<RecordEntity> recordEntities) {
map.clear();
final Calendar cal = Calendar.getInstance();
cal.setTime(start);
while (cal.getTime().before(end) || cal.getTime().equals(end)) {
map.put(cal.getTime(), new ArrayList<RecordEntity>());
cal.add(Calendar.DAY_OF_YEAR, 1);
}
for (final RecordEntity r : recordEntities) {
map.get(r.getDate()).add(r);
}
}
private void addTable(final Document document, final Boolean skipEmptyRecords) throws DocumentException {
double progressValue = 20;
progress.setValue((int)progressValue);
// columns are: date, duration, rate, total, description
final PdfPTable table = new PdfPTable(5);
table.setWidthPercentage(100);
table.setWidths(new int[] {30, 30, 30, 40, 150});
table.addCell(new Paragraph("Date", getDefaultBoldFont()));
table.addCell(new Paragraph("Duration (hr)", getDefaultBoldFont()));
table.addCell(new Paragraph("Rate per Hour", getDefaultBoldFont()));
table.addCell(new Paragraph("Total", getDefaultBoldFont()));
table.addCell(new Paragraph("Description", getDefaultBoldFont()));
final double increment = map.size() / 80d;
double sumDuration=0;
double sumTotal=0;
for (final Date d : map.keySet()) {
progressValue+=increment;
progress.setValue((int)progressValue);
if (skipEmptyRecords && map.get(d).isEmpty()) {
continue;
}
final PdfPCell dateCell = new PdfPCell(new Paragraph(Util.ReportDateFormat.format(d), getDefaultFont()));
dateCell.setHorizontalAlignment(Element.ALIGN_CENTER);
if (!map.get(d).isEmpty()) {
dateCell.setRowspan(map.get(d).size());
}
table.addCell(dateCell);
double tempSumDuration=0;
double tempSumTotal=0;
for (final RecordEntity r : map.get(d)) {
PdfPCell duration = new PdfPCell(new Paragraph(Util.DecimalFormat.format(r.getDuration()),getDefaultFont()));
duration.setHorizontalAlignment(Element.ALIGN_RIGHT);
PdfPCell rate = new PdfPCell(new Paragraph(Util.CurrencyFormat.format(r.getRate()),getDefaultFont()));
rate.setHorizontalAlignment(Element.ALIGN_RIGHT);
PdfPCell total = new PdfPCell(new Paragraph(Util.CurrencyFormat.format(r.getDuration()*r.getRate()),getDefaultFont()));
total.setHorizontalAlignment(Element.ALIGN_RIGHT);
PdfPCell desc = new PdfPCell(new Paragraph(r.getDescription(),getDefaultFont()));
desc.setHorizontalAlignment(Element.ALIGN_LEFT);
tempSumDuration+=r.getDuration();
tempSumTotal+=(r.getDuration()*r.getRate());
table.addCell(duration);
table.addCell(rate);
table.addCell(total);
table.addCell(desc);
}
if (map.get(d).isEmpty()) {
table.addCell(new Paragraph(""));
table.addCell(new Paragraph(""));
table.addCell(new Paragraph(""));
table.addCell(new Paragraph(""));
} else {
PdfPCell totalText = new PdfPCell(new Paragraph("Sum",getDefaultBoldFont()));
totalText.setHorizontalAlignment(Element.ALIGN_LEFT);
PdfPCell duration = new PdfPCell(new Paragraph(Util.DecimalFormat.format(tempSumDuration),getDefaultBoldFont()));
duration.setHorizontalAlignment(Element.ALIGN_RIGHT);
PdfPCell rate = new PdfPCell(new Paragraph("",getDefaultBoldFont()));
rate.setHorizontalAlignment(Element.ALIGN_RIGHT);
PdfPCell total = new PdfPCell(new Paragraph(Util.CurrencyFormat.format(tempSumTotal),getDefaultBoldFont()));
total.setHorizontalAlignment(Element.ALIGN_RIGHT);
PdfPCell desc = new PdfPCell(new Paragraph("",getDefaultBoldFont()));
desc.setHorizontalAlignment(Element.ALIGN_LEFT);
table.addCell(totalText);
table.addCell(duration);
table.addCell(rate);
table.addCell(total);
table.addCell(desc);
if (!d.equals(end)) {
PdfPCell separator = new PdfPCell(new Paragraph("\n\n", getDefaultFont()));
separator.setColspan(5);
table.addCell(separator);
}
}
sumDuration+=tempSumDuration;
sumTotal+=tempSumTotal;
}
// adds total
PdfPCell totalText = new PdfPCell(new Paragraph("Total",getDefaultBoldFont()));
totalText.setHorizontalAlignment(Element.ALIGN_LEFT);
PdfPCell duration = new PdfPCell(new Paragraph(Util.DecimalFormat.format(sumDuration),getDefaultBoldFont()));
duration.setHorizontalAlignment(Element.ALIGN_RIGHT);
PdfPCell rate = new PdfPCell(new Paragraph("",getDefaultBoldFont()));
rate.setHorizontalAlignment(Element.ALIGN_RIGHT);
PdfPCell total = new PdfPCell(new Paragraph(Util.CurrencyFormat.format(sumTotal),getDefaultBoldFont()));
total.setHorizontalAlignment(Element.ALIGN_RIGHT);
PdfPCell desc = new PdfPCell(new Paragraph("",getDefaultBoldFont()));
desc.setHorizontalAlignment(Element.ALIGN_LEFT);
totalText.setBorder(Rectangle.NO_BORDER);
duration.setBorder(Rectangle.NO_BORDER);
rate.setBorder(Rectangle.NO_BORDER);
total.setBorder(Rectangle.NO_BORDER);
desc.setBorder(Rectangle.NO_BORDER);
table.addCell(totalText);
table.addCell(duration);
table.addCell(rate);
table.addCell(total);
table.addCell(desc);
document.add(table);
}
private void addMetaData(final Document document) {
progress.setValue(5);
document.addTitle("Invoice ("+Util.ReportDateFormat.format(start)+" - "+DateFormat.getDateInstance().format(end)+")");
document.addKeywords("Invoice");
document.addAuthor(Config.getFrom());
document.addCreator(Config.getFrom());
}
private void addTitle(final Document document) throws DocumentException {
progress.setValue(10);
final Paragraph from = new Paragraph(Config.getFrom(),getDefaultFont());
from.setAlignment(Paragraph.ALIGN_CENTER);
from.add(new Chunk("\n"));
from.add(new Chunk(new LineSeparator(1f, 100f, BaseColor.BLACK, Element.ALIGN_CENTER, 0)));
from.add(new Chunk("\n\n"));
document.add(from);
final PdfPTable table = new PdfPTable(2);
final Paragraph invoice = new Paragraph("Invoice No", getDefaultBoldFont());
final Paragraph invoiceValue = new Paragraph(this.invoiceNumber, getDefaultFont());
final Paragraph date = new Paragraph("Date", getDefaultBoldFont());
final Paragraph dateValue = new Paragraph(Util.ReportDateFormat.format(new Date()), getDefaultFont());
final Paragraph to = new Paragraph("To", getDefaultBoldFont());
final Paragraph toValue = new Paragraph(Config.getTo(), getDefaultFont());
// no border
table.getDefaultCell().setBorder(Rectangle.NO_BORDER);
table.setWidths(new int[] {15, 100});
table.addCell(invoice);
table.addCell(invoiceValue);
table.addCell(date);
table.addCell(dateValue);
table.addCell(to);
table.addCell(toValue);
table.setHorizontalAlignment(Element.ALIGN_LEFT);
document.add(table);
document.add(new Paragraph("\n", getDefaultFont()));
final String titleStr = "Invoice ("+Util.ReportDateFormat.format(start)+" - "+Util.ReportDateFormat.format(end)+")";
final Font f = getDefaultBoldFont();
f.setSize(14);
final Paragraph title = new Paragraph(titleStr, f);
title.setAlignment(Element.ALIGN_CENTER);
document.add(title);
document.add(new Paragraph("\n", getDefaultFont()));
}
private Font getDefaultFont() {
return FontFactory.getFont(FontFactory.HELVETICA,10);
}
private Font getDefaultBoldFont() {
return FontFactory.getFont(FontFactory.HELVETICA_BOLD,10);
}
private void addNotes(final Document document) throws DocumentException {
progress.setValue(80);
if (Config.getNotes().isEmpty()) return;
final PdfPTable table = new PdfPTable(2);
final Paragraph note = new Paragraph("Notes", getDefaultBoldFont());
final Paragraph noteValue = new Paragraph(Config.getNotes(), getDefaultFont());
// no border
table.getDefaultCell().setBorder(Rectangle.NO_BORDER);
table.setWidths(new int[] {15, 100});
table.addCell(note);
table.addCell(noteValue);
table.setHorizontalAlignment(Element.ALIGN_LEFT);
document.add(new Paragraph("\n"));
document.add(new LineSeparator(1f, 100f, BaseColor.BLACK, Element.ALIGN_CENTER, 0));
document.add(table);
document.add(new Paragraph("\n", getDefaultFont()));
}
}