Subversion Repositories SmartDukaan

package com.spice.profitmandi.common.util;

import java.io.OutputStream;

import java.time.LocalDateTime;

import java.util.Locale;

import java.util.Set;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import org.springframework.util.StringUtils;

import com.ibm.icu.text.RuleBasedNumberFormat;

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.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.spice.profitmandi.common.model.CustomCustomer;

import com.spice.profitmandi.common.model.CustomFofoOrderItem;

import com.spice.profitmandi.common.model.CustomInsurancePolicy;

import com.spice.profitmandi.common.model.CustomRetailer;

import com.spice.profitmandi.common.model.PdfModel;

public class PdfUtils {

	private static final Font FONT_TITLE = new Font(Font.FontFamily.HELVETICA  , 18, Font.BOLD);

	private static Font FONT_NORMAL = new Font(Font.FontFamily.TIMES_ROMAN, 10, Font.NORMAL);

	private static Font FONT_BOLD = new Font(Font.FontFamily.TIMES_ROMAN, 10, Font.BOLD);

	//private static Font fontTableHeader = new Font(Font.FontFamily.TIMES_ROMAN, 14, Font.BOLD);

	private static final String INVOICE_TITLE = "INVOICE";

	private static final Locale indianLocale = Locale.getDefault();

	private static final Logger LOGGER = LoggerFactory.getLogger(PdfUtils.class);

	public static void generateAndWrite(PdfModel pdfModel, OutputStream outputStream){

		Document document = new Document();

		document.setMargins(0, 0, 25, 0);

        try {

        	CustomCustomer customer = pdfModel.getCustomer();

        	CustomRetailer retailer = pdfModel.getRetailer();

        	boolean gstWithInState = false;

        	String customerAddressStateCode = "", retailerAddressStateCode = "";

        	if(customer.getAddress().getState().equals(retailer.getAddress().getState())){

        		gstWithInState = true;

        		customerAddressStateCode = Utils.getStateCode(customer.getAddress().getState());

        	}else{

        		customerAddressStateCode = Utils.getStateCode(customer.getAddress().getState());

        		retailerAddressStateCode = Utils.getStateCode(retailer.getAddress().getState());

        	}

        	Set<CustomFofoOrderItem> orderItems = pdfModel.getOrderItems();

            PdfWriter.getInstance(document,outputStream);

            document.open();

            document.addTitle(pdfModel.getTitle());

            document.addAuthor(pdfModel.getAuther());

            Paragraph paragraphTitle = new Paragraph(INVOICE_TITLE, FONT_TITLE);

            paragraphTitle.setAlignment(Element.ALIGN_CENTER);

            PdfPCell blankCell = new PdfPCell();

            blankCell.setBorder(Rectangle.NO_BORDER);

            PdfPTable tableCustomerRetailer = new PdfPTable(3);

            tableCustomerRetailer.setWidthPercentage(90);

            tableCustomerRetailer.getDefaultCell().setBorder(Rectangle.NO_BORDER);

            PdfPCell columnCustomerInfo = new PdfPCell();

            columnCustomerInfo.addElement(new Paragraph(StringUtils.capitalize(customer.getFirstName() + " " + customer.getLastName()), FONT_NORMAL));

            columnCustomerInfo.addElement(new Paragraph(StringUtils.capitalize(customer.getAddress().getLine1()) + ", " + StringUtils.capitalize(customer.getAddress().getLine2()), FONT_NORMAL));

            columnCustomerInfo.addElement(new Paragraph(StringUtils.capitalize(customer.getAddress().getCity()) + ", " + StringUtils.capitalize(customer.getAddress().getState()) + "(" + customerAddressStateCode + ")" + "\n" + customer.getAddress().getPinCode(), FONT_NORMAL));

            columnCustomerInfo.addElement(new Paragraph(customer.getMobileNumber(), FONT_NORMAL));

            columnCustomerInfo.setBorder(Rectangle.NO_BORDER);

            PdfPCell columnRetailerInfo = new PdfPCell();

            //columnRetailerInfo.addElement(new Paragraph("Invoice No:"));

            columnRetailerInfo.addElement(new Paragraph(StringUtils.capitalize(retailer.getBusinessName()), FONT_BOLD));

           // columnRetailerInfo.addElement(new Paragraph("Plot No. 485, Udyog Vihar Phase V, Gurgoan-122016", FONT_BOLD));

            columnRetailerInfo.addElement(new Paragraph(StringUtils.capitalize(retailer.getAddress().getLine1()) + ", " + StringUtils.capitalize(retailer.getAddress().getLine2()) + ", " + StringUtils.capitalize(retailer.getAddress().getCity()) + "-" + retailer.getAddress().getPinCode() + ", " + retailer.getAddress().getState() + "(" + (gstWithInState? customerAddressStateCode : retailerAddressStateCode) + ")", FONT_BOLD));

            columnRetailerInfo.addElement(new Paragraph("Contact No.- "+retailer.getMobileNumber(), FONT_BOLD));

            columnRetailerInfo.addElement(new Paragraph("GST NO. " + retailer.getGstNumber(), FONT_BOLD));

            columnRetailerInfo.setBorder(Rectangle.NO_BORDER);

            PdfPTable tableInvoiceDateRetailer = new PdfPTable(1);

            tableInvoiceDateRetailer.getDefaultCell().setBorder(Rectangle.NO_BORDER);

            PdfPTable tableInvoiceDate = new PdfPTable(2);

            tableInvoiceDate.getDefaultCell().setBorder(Rectangle.NO_BORDER);

            PdfPCell invoiceNumberKey = new PdfPCell(new Paragraph("Invoice No:", FONT_NORMAL));

            invoiceNumberKey.setBorder(Rectangle.NO_BORDER);

            PdfPCell invoiceNumberValue = new PdfPCell(new Paragraph(pdfModel.getInvoiceNumber(), FONT_NORMAL));

            invoiceNumberValue.setBorder(Rectangle.NO_BORDER);

            PdfPCell dateKey = new PdfPCell(new Paragraph("Date:", FONT_NORMAL));

            dateKey.setBorder(Rectangle.NO_BORDER);

            LocalDateTime now = LocalDateTime.now();

            //PdfPCell dateValue = new PdfPCell(new Paragraph("May 22, 2017", FONT_NORMAL));

            PdfPCell dateValue = new PdfPCell(new Paragraph(now.getMonth().name() + now.getDayOfMonth() + ", " + now.getYear(), FONT_NORMAL));

            dateValue.setBorder(Rectangle.NO_BORDER);

            tableInvoiceDate.addCell(invoiceNumberKey);

            //tableInvoiceDate.addCell(blankCell);

            tableInvoiceDate.addCell(invoiceNumberValue);

            tableInvoiceDate.addCell(dateKey);

            //tableInvoiceDate.addCell(blankCell);

            tableInvoiceDate.addCell(dateValue);

            tableInvoiceDateRetailer.addCell(tableInvoiceDate);

            tableInvoiceDateRetailer.addCell(columnRetailerInfo);

            tableCustomerRetailer.addCell(columnCustomerInfo);

            tableCustomerRetailer.addCell(blankCell);

            tableCustomerRetailer.addCell(tableInvoiceDateRetailer);

            PdfPTable orders = null;

            if(!gstWithInState){

            	orders = new PdfPTable(8);

            }else{

            	orders = new PdfPTable(10);

            }

            orders.setWidthPercentage(90);

            //PdfPCell orderDetail = new PdfPCell(new Paragraph("Order Details:"));

            /*PdfPTable ordersTable = new PdfPTable(8);

            PdfPCell srNo = new PdfPCell(new Paragraph("Sr No"));

            PdfPCell description = new PdfPCell(new Paragraph("Description"));

            PdfPCell quantity = new PdfPCell(new Paragraph("Quantity"));

            PdfPCell rate = new PdfPCell(new Paragraph("Rate (Rs)"));

            PdfPCell amount = new PdfPCell(new Paragraph("Amount (Rs)"));

            PdfPCell taxRate = new PdfPCell(new Paragraph("Tax Rate%"));

            PdfPCell tax = new PdfPCell(new Paragraph("Tax (Rs)"));

            PdfPCell itemTotal = new PdfPCell(new Paragraph("Item Total (Rs)"));

            srNo.setBorder(Rectangle.NO_BORDER);

            description.setBorder(Rectangle.NO_BORDER);

            quantity.setBorder(Rectangle.NO_BORDER);

            rate.setBorder(Rectangle.NO_BORDER);

            amount.setBorder(Rectangle.NO_BORDER);

            taxRate.setBorder(Rectangle.NO_BORDER);

            tax.setBorder(Rectangle.NO_BORDER);

            itemTotal.setBorder(Rectangle.NO_BORDER);*/

            orders.addCell(new Paragraph("SrNo", FONT_BOLD));

            orders.addCell(new Paragraph("Description", FONT_BOLD));

            orders.addCell(new Paragraph("HSN", FONT_BOLD));

            orders.addCell(new Paragraph("Qty", FONT_BOLD));

            orders.addCell(new Paragraph("Rate(Rs)", FONT_BOLD));

            orders.addCell(new Paragraph("Discount(Rs)", FONT_BOLD));

            orders.addCell(new Paragraph("Amount(Rs)", FONT_BOLD));

            if(!gstWithInState){

            	orders.addCell(new Paragraph("IGST Rate%", FONT_BOLD));

                orders.addCell(new Paragraph("IGST Amount", FONT_BOLD));

                //orders.setWidths(new float[]{1, 3, 1, 1, 1, 1, 1, 1});

                orders.setWidths(new float[]{.6f, 2.3f, 1.2f, .7f, 1.1f, 1.1f, .9f, .9f});

            }else{

            	orders.addCell(new Paragraph("CGST Rate%", FONT_BOLD));

                orders.addCell(new Paragraph("CGST Amount", FONT_BOLD));

                orders.addCell(new Paragraph("SGST Rate%", FONT_BOLD));

                orders.addCell(new Paragraph("SGST Amount", FONT_BOLD));

                //orders.setWidths(new float[]{1, 3, 1, 1, 1, 1, 1, 1, 1, 1});

                orders.setWidths(new float[]{.6f, 2.3f, 1.2f, .7f, 1.1f, 1.1f, .9f, .9f, .9f, .9f});

            }

            //orders.addCell(new Paragraph("Item Total (Rs)", FONT_BOLD));

            orders.setHeaderRows(1);

            //orders.setSkipFirstHeader(true);

            float igstTotalAmount = 0, cgstTotalAmount = 0, sgstTotalAmount = 0;

            int index = 1;

        	for(CustomFofoOrderItem orderItem : orderItems){

            	orders.addCell(new Paragraph(String.valueOf(index++), FONT_NORMAL));

            	orders.addCell(new Paragraph(orderItem.getDescription(), FONT_NORMAL));

            	orders.addCell(new Paragraph(orderItem.getHsnCode(), FONT_NORMAL));

            	orders.addCell(new Paragraph(String.valueOf(orderItem.getQuantity()), FONT_NORMAL));

            	orders.addCell(new Paragraph(String.format("%.2f", orderItem.getRate()), FONT_NORMAL));

            	orders.addCell(new Paragraph(String.format("%.2f", orderItem.getDiscount()), FONT_NORMAL));

            	orders.addCell(new Paragraph(String.format("%.2f", orderItem.getAmount()), FONT_NORMAL));

            	if(!gstWithInState){

            		orders.addCell(new Paragraph(String.format("%.2f", orderItem.getIgstRate()), FONT_NORMAL));

            		orders.addCell(new Paragraph(String.format("%.2f", orderItem.getIgstAmount()), FONT_NORMAL));

            		igstTotalAmount = igstTotalAmount + orderItem.getIgstAmount();

            	}else{

            		orders.addCell(new Paragraph(String.format("%.2f", orderItem.getCgstRate()), FONT_NORMAL));

            		orders.addCell(new Paragraph(String.format("%.2f", orderItem.getCgstAmount()), FONT_NORMAL));

            		orders.addCell(new Paragraph(String.format("%.2f", orderItem.getSgstRate()), FONT_NORMAL));

            		orders.addCell(new Paragraph(String.format("%.2f", orderItem.getSgstAmount()), FONT_NORMAL));

            		cgstTotalAmount = cgstTotalAmount + orderItem.getCgstAmount();

            		sgstTotalAmount = sgstTotalAmount + orderItem.getSgstAmount();

            	}

            	//orders.addCell(new Paragraph(String.format("%.2f", orderItem.getItemTotal()), FONT_NORMAL));

            }

        	for(CustomInsurancePolicy insurancePolicy : pdfModel.getInsurancePolicies()){

        		orders.addCell(new Paragraph(String.valueOf(index++), FONT_NORMAL));

            	orders.addCell(new Paragraph(insurancePolicy.getDescription(), FONT_NORMAL));

            	orders.addCell(new Paragraph(insurancePolicy.getHsnCode(), FONT_NORMAL));

            	orders.addCell(new Paragraph("1", FONT_NORMAL));

            	orders.addCell(new Paragraph(String.format("%.2f", insurancePolicy.getRate()), FONT_NORMAL));

            	orders.addCell(new Paragraph(String.format("%.2f", insurancePolicy.getRate()), FONT_NORMAL));

            	if(!gstWithInState){

            		orders.addCell(new Paragraph(String.format("%.2f", insurancePolicy.getIgstRate()), FONT_NORMAL));

            		orders.addCell(new Paragraph(String.format("%.2f", insurancePolicy.getIgstAmount()), FONT_NORMAL));

            		igstTotalAmount = igstTotalAmount + insurancePolicy.getIgstAmount();

            	}else{

            		orders.addCell(new Paragraph(String.format("%.2f", insurancePolicy.getCgstRate()), FONT_NORMAL));

            		orders.addCell(new Paragraph(String.format("%.2f", insurancePolicy.getCgstAmount()), FONT_NORMAL));

            		orders.addCell(new Paragraph(String.format("%.2f", insurancePolicy.getSgstRate()), FONT_NORMAL));

            		orders.addCell(new Paragraph(String.format("%.2f", insurancePolicy.getSgstAmount()), FONT_NORMAL));

            		cgstTotalAmount = cgstTotalAmount + insurancePolicy.getCgstAmount();

            		sgstTotalAmount = sgstTotalAmount + insurancePolicy.getSgstAmount();

            	}

        	}

            //orders.addCell("1");

            //orders.addCell("Sansui X71Activ Ta2s");

            //orders.setHeaderRows(1);

            //orders.getDefaultCell().setBorder(Rectangle.NO_BORDER);

            //orders.addCell(orderDetail);

            //orders.addCell(ordersTable);

            document.add(paragraphTitle);

            document.add(Chunk.NEWLINE);

            document.add(Chunk.NEWLINE);

            //document.add(paragraphRetailerName);

            document.add(tableCustomerRetailer);

            //document.add(Chunk.NEWLINE);

            //document.add(Chunk.NEWLINE);

            document.add(Chunk.NEWLINE);

            document.add(orders);

            PdfPTable gstTotalTable = null;

            if(!gstWithInState){

            	gstTotalTable = new PdfPTable(3);

            	gstTotalTable.setWidths(new float[]{8, .9f, .9f});

            }else{

            	gstTotalTable = new PdfPTable(5);

            	gstTotalTable.setWidths(new float[]{8, .9f, .9f, .9f, .9f});

            }

            gstTotalTable.setWidthPercentage(90);

            /*for(int i = 0; i < 6; i++){

            	grandTotalTable.addCell(new Paragraph());

            }*/

            //PdfPCell grandTotalCell = new PdfPCell(new Paragraph("Grand total", fontBold));

            //grandTotalCell.setVerticalAlignment(Element.ALIGN_RIGHT);

            Paragraph gstTotalParagraph = new Paragraph("Gst Total", FONT_BOLD);

            gstTotalParagraph.setIndentationRight(20);

            gstTotalTable.addCell(gstTotalParagraph);

            if(!gstWithInState){

            	gstTotalTable.addCell(new Paragraph("IGST", FONT_BOLD));

            	gstTotalTable.addCell(new Paragraph(String.format("%.2f", igstTotalAmount), FONT_BOLD));

            }else{

            	gstTotalTable.addCell(new Paragraph("CGST", FONT_BOLD));

            	gstTotalTable.addCell(new Paragraph(String.format("%.2f", cgstTotalAmount), FONT_BOLD));

            	gstTotalTable.addCell(new Paragraph("SGST", FONT_BOLD));

            	gstTotalTable.addCell(new Paragraph(String.format("%.2f", sgstTotalAmount), FONT_BOLD));

            }

            //grandTotalCell.setColspan(6);

            document.add(gstTotalTable);

            PdfPTable grandTotalTable = new PdfPTable(3);

            if(!gstWithInState){

            	grandTotalTable.setWidths(new float[]{8, .9f, .9f});

            }else{

            	grandTotalTable.setWidths(new float[]{10, .9f, .9f});

            }

            grandTotalTable.setWidthPercentage(90);

            Paragraph grandTotalParagraph = new Paragraph("Grand total", FONT_BOLD);

            grandTotalParagraph.setIndentationRight(20);

            grandTotalTable.addCell(grandTotalParagraph);

            Paragraph rsParagraph = new Paragraph("Rs.", FONT_BOLD);

            grandTotalTable.addCell(rsParagraph);

            Paragraph amountParagraph = new Paragraph(String.format("%.2f", pdfModel.getTotalAmount()), FONT_BOLD);

            grandTotalTable.addCell(amountParagraph);

            document.add(grandTotalTable);

            PdfPTable amountInWordsTable = new PdfPTable(3);

            if(!gstWithInState){

            	amountInWordsTable.setWidths(new float[]{2, 5, 2.7f});

            }else{

            	amountInWordsTable.setWidths(new float[]{2, 7, 2.7f});

            }

            amountInWordsTable.setWidthPercentage(90);

            amountInWordsTable.addCell(new Paragraph("Amount in Words:", FONT_BOLD));

            String amountInWords = toAmountInWords(pdfModel.getTotalAmount());

           	amountInWordsTable.addCell(new Paragraph(amountInWords.toString(), FONT_BOLD));

            amountInWordsTable.addCell(new Paragraph("E & O.E", FONT_NORMAL));

            document.add(amountInWordsTable);            

            Paragraph warningParagraph = new Paragraph("Goods once sold will not be taken back.\nThis is a Computer Generated Invoice.", FONT_NORMAL);

            warningParagraph.setIndentationLeft(40);

            document.add(Chunk.NEWLINE);

            document.add(warningParagraph);

            document.close(); // no need to close PDFwriter?

        } catch (DocumentException e) {

            LOGGER.error("Unable to write data to pdf file : ", e);

        } catch (Exception e) {

			// TODO Auto-generated catch block

			e.printStackTrace();

		}

	}

	private static String toAmountInWords(float amount){

		RuleBasedNumberFormat amountInWordsFormat = new RuleBasedNumberFormat(indianLocale, RuleBasedNumberFormat.SPELLOUT);

       	StringBuilder amountInWords = new StringBuilder("Rs. ");

        amountInWords.append(StringUtils.capitalize(amountInWordsFormat.format((int)amount)));

       	amountInWords.append(" and ");

        amountInWords.append(StringUtils.capitalize(amountInWordsFormat.format((int)(amount*100)%100)));

       	amountInWords.append(" paise");

       	return amountInWords.toString();

	}

}