SalesBalanceReportView.java

package com.floreantpos.ui.report;

import java.awt.BorderLayout;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.HashMap;

import javax.swing.JButton;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JSeparator;
import javax.swing.border.EmptyBorder;

import net.miginfocom.swing.MigLayout;
import net.sf.jasperreports.engine.JREmptyDataSource;
import net.sf.jasperreports.engine.JasperFillManager;
import net.sf.jasperreports.engine.JasperPrint;
import net.sf.jasperreports.engine.JasperReport;
import net.sf.jasperreports.engine.util.JRLoader;
import net.sf.jasperreports.view.JRViewer;

import org.jdesktop.swingx.JXDatePicker;

import com.floreantpos.main.Application;
import com.floreantpos.model.util.DateUtil;
import com.floreantpos.report.SalesBalanceReport;
import com.floreantpos.report.services.ReportService;
import com.floreantpos.ui.dialog.POSMessageDialog;

public class SalesBalanceReportView extends JPanel {
	private SimpleDateFormat fullDateFormatter = new SimpleDateFormat("yyyy MMM dd, hh:mm a");
	private SimpleDateFormat shortDateFormatter = new SimpleDateFormat("yyyy MMM dd");
	
	private JXDatePicker fromDatePicker = new JXDatePicker();
	private JXDatePicker toDatePicker = new JXDatePicker();
	private JButton btnGo = new JButton("GO");
	private JPanel reportContainer;
	
	public SalesBalanceReportView() {
		super(new BorderLayout());
		
		JPanel topPanel = new JPanel(new MigLayout());
		
		topPanel.add(new JLabel("From:"), "grow");
		topPanel.add(fromDatePicker,"wrap");
		topPanel.add(new JLabel("To:"), "grow");
		topPanel.add(toDatePicker,"wrap");
		topPanel.add(btnGo, "skip 1, al right");
		add(topPanel, BorderLayout.NORTH);
		
		JPanel centerPanel = new JPanel(new BorderLayout());
		centerPanel.setBorder(new EmptyBorder(0, 10,10,10));
		centerPanel.add(new JSeparator(), BorderLayout.NORTH);
		
		reportContainer = new JPanel(new BorderLayout());
		centerPanel.add(reportContainer);
		
		add(centerPanel);
		
		btnGo.addActionListener(new ActionListener() {

			public void actionPerformed(ActionEvent e) {
				try {
					viewReport();
				} catch (Exception e1) {
					POSMessageDialog.showError(SalesBalanceReportView.this, POSMessageDialog.ERROR_MESSAGE, e1);
				}
			}
			
		});
	}
	
	private void viewReport() throws Exception {
		Date fromDate = fromDatePicker.getDate();
		Date toDate = toDatePicker.getDate();
		
		if(fromDate.after(toDate)) {
			POSMessageDialog.showError(Application.getInstance().getBackOfficeWindow(), "From date cannot be greater than to date.");
			return;
		}
		
		fromDate = DateUtil.startOfDay(fromDate);
		toDate = DateUtil.endOfDay(toDate);
		
		ReportService reportService = new ReportService();
		SalesBalanceReport report = reportService.getSalesBalanceReport(fromDate, toDate);
		
		HashMap<String, String> map = new HashMap<String, String>();
		ReportUtil.populateRestaurantProperties(map);
		map.put("fromDate", shortDateFormatter.format(fromDate));
		map.put("toDate", shortDateFormatter.format(toDate));
		map.put("reportTime", fullDateFormatter.format(new Date()));
		
		map.put("grossTaxableSales", Application.formatNumber(report.getGrossTaxableSalesAmount()));
		map.put("grossNonTaxableSales", Application.formatNumber(report.getGrossNonTaxableSalesAmount()));
		map.put("discounts", Application.formatNumber(report.getDiscountAmount()));
		map.put("netSales", Application.formatNumber(report.getNetSalesAmount()));
		map.put("salesTaxes", Application.formatNumber(report.getSalesTaxAmount()));
		map.put("totalRevenues", Application.formatNumber(report.getTotalRevenueAmount()));
		map.put("giftCertSold", Application.formatNumber(report.getGiftCertSalesAmount()));
		map.put("payIns", Application.formatNumber(report.getPayInsAmount()));
		map.put("chargedTips", Application.formatNumber(report.getChargedTipsAmount()));
		map.put("grossReceipts", Application.formatNumber(report.getGrossReceiptsAmount()));
		map.put("cashReceipts", Application.formatNumber(report.getCashReceiptsAmount()));
		map.put("creditCardReceipts", Application.formatNumber(report.getCreditCardReceiptsAmount()));
		map.put("grossTipsPaid", Application.formatNumber(report.getGrossTipsPaidAmount()));
		map.put("arReceipts", Application.formatNumber(report.getArReceiptsAmount()));
		map.put("giftCertReturns", Application.formatNumber(report.getGiftCertReturnAmount()));
		map.put("giftCertChange", Application.formatNumber(report.getGiftCertChangeAmount()));
		map.put("cashBack", Application.formatNumber(report.getCashBackAmount()));
		map.put("receiptDiff", Application.formatNumber(report.getReceiptDiffAmount()));
		map.put("tipsDiscount", Application.formatNumber(report.getTipsDiscountAmount()));
		map.put("cashPayout", Application.formatNumber(report.getCashPayoutAmount()));
		map.put("cashAccountable", Application.formatNumber(report.getCashAccountableAmount()));
		map.put("drawerPulls", Application.formatNumber(report.getDrawerPullsAmount()));
		map.put("coCurrent", Application.formatNumber(report.getCoCurrentAmount()));
		map.put("coPrevious", Application.formatNumber(report.getCoPreviousAmount()));
		map.put("coOverShort", Application.formatNumber(report.getOverShortAmount()));
		map.put("days", String.valueOf((int) ((toDate.getTime() - fromDate.getTime()) * (1.15740741 * Math.pow(10, -8))) + 1));
		
		JasperReport jasperReport = (JasperReport) JRLoader.loadObject(getClass().getResource("/com/floreantpos/ui/report/sales_summary_balance_report.jasper"));
		JasperPrint jasperPrint = JasperFillManager.fillReport(jasperReport, map, new JREmptyDataSource());
		JRViewer viewer = new JRViewer(jasperPrint);
		reportContainer.removeAll();
		reportContainer.add(viewer);
		reportContainer.revalidate();
		
	}
}