Subversion Repositories SmartDukaan

Rev

Rev 4361 | Rev 4746 | Go to most recent revision | Blame | Compare with Previous | Last modification | View Log | RSS feed

package in.shop2020.hotspot.dashbaord.server;

import in.shop2020.config.ConfigException;
import in.shop2020.logistics.DeliveryType;
import in.shop2020.logistics.LogisticsServiceException;
import in.shop2020.logistics.Provider;
import in.shop2020.model.v1.catalog.InventoryServiceException;
import in.shop2020.model.v1.catalog.Warehouse;
import in.shop2020.model.v1.catalog.InventoryService.Client;
import in.shop2020.model.v1.order.LineItem;
import in.shop2020.model.v1.order.Order;
import in.shop2020.model.v1.order.OrderStatus;
import in.shop2020.thrift.clients.CatalogClient;
import in.shop2020.thrift.clients.LogisticsClient;
import in.shop2020.thrift.clients.TransactionClient;
import in.shop2020.thrift.clients.config.ConfigClient;

import java.io.ByteArrayOutputStream;
import java.io.File;
import java.io.FileOutputStream;
import java.io.IOException;
import java.text.DateFormat;
import java.text.DecimalFormat;
import java.util.ArrayList;
import java.util.Date;
import java.util.Enumeration;
import java.util.List;
import java.util.Locale;
import java.util.Properties;
import java.util.ResourceBundle;

import javax.servlet.ServletException;
import javax.servlet.ServletOutputStream;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import org.apache.commons.lang.WordUtils;
import org.apache.thrift.TException;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;

import com.ibm.icu.text.RuleBasedNumberFormat;

import com.itextpdf.text.Document;
import com.itextpdf.text.Element;
import com.itextpdf.text.Font;
import com.itextpdf.text.FontFactory;
import com.itextpdf.text.FontFactoryImp;
import com.itextpdf.text.Image;
import com.itextpdf.text.Paragraph;
import com.itextpdf.text.Phrase;
import com.itextpdf.text.Rectangle;
import com.itextpdf.text.Font.FontFamily;
import com.itextpdf.text.pdf.BaseFont;
import com.itextpdf.text.pdf.PdfPCell;
import com.itextpdf.text.pdf.PdfPTable;
import com.itextpdf.text.pdf.PdfWriter;
import com.itextpdf.text.pdf.draw.DottedLineSeparator;

@SuppressWarnings("serial")
public class InvoiceServlet extends HttpServlet {
    
    private static Logger logger = LoggerFactory.getLogger(InvoiceServlet.class);
    
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        long orderId = Long.parseLong(request.getParameter("id"));
        long warehouseId = Long.parseLong(request.getParameter("warehouse"));
        boolean withBill = false;
        boolean printAll = false;
        try {
            withBill = Boolean.parseBoolean(request.getParameter("withBill"));
        } catch(Exception e){
            logger.warn("Couldn't infer whether bill should be printed. Not printing the bill.", e);
        }
        try {
                printAll = Boolean.parseBoolean(request.getParameter("printAll"));
        } catch(Exception e){
            logger.warn("Couldn't infer whether bill should be printed. Not printing the bill.", e);
        }
        
        logger.info("Printing invoice for order id: " + orderId);
        
        InvoiceGenerationService invoiceGenerationService = new InvoiceGenerationService();
        ByteArrayOutputStream baos = invoiceGenerationService.generateInvoice(orderId, withBill, printAll, warehouseId);
        response.setContentType("application/pdf");
        response.setHeader("Content-disposition", "inline; filename=invoice-"+orderId+".pdf" );
        
        ServletOutputStream sos;
        try {
            sos = response.getOutputStream();
            baos.writeTo(sos);
            sos.flush();
        } catch (IOException e) {
            logger.error("Encountered error while sending invoice response: ", e);
        }
    }
}

class InvoiceGenerationService {
    
    private static Logger logger = LoggerFactory.getLogger(InvoiceGenerationService.class);
    
    private TransactionClient tsc = null;
    private CatalogClient csc = null;
    private LogisticsClient lsc = null;
    
    private static Locale indianLocale = new Locale("en", "IN");
    private DecimalFormat amountFormat = new DecimalFormat("#,##0.00");

    private static final Font helvetica8 = FontFactory.getFont(FontFactory.HELVETICA, 8);
    private static final Font helvetica10 = FontFactory.getFont(FontFactory.HELVETICA, 10);
    private static final Font helvetica12 = FontFactory.getFont(FontFactory.HELVETICA, 12);
    private static final Font helvetica16 = FontFactory.getFont(FontFactory.HELVETICA, 16);
    private static final Font helvetica28 = FontFactory.getFont(FontFactory.HELVETICA, 28);
    
    private static final Font helveticaBold8 = FontFactory.getFont(FontFactory.HELVETICA_BOLD, 8);
    private static final Font helveticaBold12 = FontFactory.getFont(FontFactory.HELVETICA_BOLD, 12);

    private static final Properties properties = readProperties();
    private static final String ourAddress = properties.getProperty("sales_tax_address",
                    "Spice Online Retail Pvt. Ltd.\nKhasra No. 819, Block-K\nMahipalpur, New Delhi-110037\n");
    private static final String tinNo = properties.getProperty("sales_tax_tin", "07250399732");
    
    private static final String delhiPincodePrefix = "11";
    
    private static final double salesTaxLowRate = Double.parseDouble(properties.getProperty("sales_tax_low_rate", "5.0"));
    private static final double salesTaxHighRate = Double.parseDouble(properties.getProperty("sales_tax_high_rate", "12.5"));
    private static final double salesTaxCutOff = (Double.parseDouble(properties.getProperty("sales_tax_cutoff", "10000")) * (100 + salesTaxLowRate))/100;
    
    private static Properties readProperties(){
        ResourceBundle resource = ResourceBundle.getBundle(InvoiceGenerationService.class.getName());
        Properties props = new Properties();
        
        Enumeration<String> keys = resource.getKeys();
        while (keys.hasMoreElements()) {
            String key = keys.nextElement();
            props.put(key, resource.getString(key));
        }
        return props;
    }
    
    public InvoiceGenerationService() {
        try {
            tsc = new TransactionClient();
            csc = new CatalogClient();
            lsc = new LogisticsClient();
        } catch (Exception e) {
            logger.error("Error while instantiating thrift clients.", e);
        }
    }

    public ByteArrayOutputStream generateInvoice(long orderId, boolean withBill, boolean printAll, long warehouseId) {
        ByteArrayOutputStream baosPDF = null;
        in.shop2020.model.v1.order.TransactionService.Client tclient = tsc.getClient();
        Client iclient = csc.getClient();
        in.shop2020.logistics.LogisticsService.Client logisticsClient = lsc.getClient();

        
        try {
            baosPDF = new ByteArrayOutputStream();

            Document document = new Document();
            PdfWriter.getInstance(document, baosPDF);
            document.addAuthor("shop2020");
            //document.addTitle("Invoice No: " + order.getInvoice_number());
            document.open();
        
            List<Order> orders = new ArrayList<Order>();
            if(printAll){
                    try {
                        orders = tclient.getAllOrders(OrderStatus.ACCEPTED, 0, 0, warehouseId);
                    } catch (Exception e) {
                        logger.error("Error while getting order information", e);
                        return baosPDF; 
                                }
            }else{
                orders.add(tclient.getOrder(orderId));  
            }
            
            for(Order order: orders){
                Warehouse warehouse = null;
                Provider provider = null;
                String destCode = null;
                int barcodeFontSize = 0;
                try {
                        warehouse = iclient.getWarehouse(order.getWarehouse_id());
                        long providerId = order.getLogistics_provider_id();
                        provider = logisticsClient.getProvider(providerId);
                        destCode = logisticsClient.getDestinationCode(providerId, order.getCustomer_pincode());
                        barcodeFontSize = Integer.parseInt(ConfigClient.getClient().get(provider.getName().toLowerCase() + "_barcode_fontsize"));
                } catch (InventoryServiceException ise) {
                        logger.error("Error while getting the warehouse information.", ise);
                        return baosPDF;
                } catch (LogisticsServiceException lse) {
                        logger.error("Error while getting the provider information.", lse);
                        return baosPDF;
                } catch (ConfigException ce) {
                        logger.error("Error while getting the fontsize for the given provider", ce);
                        return baosPDF;
                } catch (TException te) {
                        logger.error("Error while getting some essential information from the services", te);
                        return baosPDF;
                }

                    PdfPTable dispatchAdviceTable = getDispatchAdviceTable(order, warehouse, provider, barcodeFontSize, destCode, withBill);
                    dispatchAdviceTable.setSpacingAfter(10.0f);
                    dispatchAdviceTable.setWidthPercentage(90.0f);

                    document.add(dispatchAdviceTable);
                    if(withBill){
                        PdfPTable taxTable = getTaxCumRetailInvoiceTable(order, provider);
                        taxTable.setSpacingBefore(5.0f);
                        taxTable.setWidthPercentage(90.0f);
                        document.add(new DottedLineSeparator());
                        document.add(taxTable);
                    }else{
                        PdfPTable extraInfoTable = getExtraInfoTable(order, provider, 16);
                        extraInfoTable.setSpacingBefore(5.0f);
                        extraInfoTable.setWidthPercentage(90.0f);
                        document.add(new DottedLineSeparator());
                        document.add(extraInfoTable);
                    }
                    document.newPage();
            }
            document.close();
            baosPDF.close();
        } catch (Exception e) {
            logger.error("Error while generating Invoice: ", e);
        }
        return baosPDF;
    }
    
    private PdfPTable getDispatchAdviceTable(Order order, Warehouse warehouse, Provider provider, float barcodeFontSize, String destCode, boolean withBill){
        Font barCodeFont = getBarCodeFont(provider, barcodeFontSize);
        
        PdfPTable table = new PdfPTable(1);
        table.getDefaultCell().setBorder(Rectangle.NO_BORDER);

        PdfPTable logoTable = new PdfPTable(2);
        logoTable.getDefaultCell().setBorder(Rectangle.NO_BORDER);
        logoTable.getDefaultCell().setHorizontalAlignment(Element.ALIGN_RIGHT);
        logoTable.getDefaultCell().setVerticalAlignment(Element.ALIGN_BOTTOM);
        logoTable.addCell(getLogoCell());
        if(order.isCod())
            logoTable.addCell(new Phrase("COD   ", helvetica28));
        else
                logoTable.addCell(new Phrase("   ", helvetica28));
        PdfPCell titleCell = getTitleCell();
        PdfPTable customerTable = getCustomerAddressTable(order, destCode, false, helvetica12);
        PdfPTable providerInfoTable = getProviderTable(order, provider, barCodeFont);
        
        PdfPTable dispatchTable = new PdfPTable(new float[]{0.5f, 0.1f, 0.4f});
        dispatchTable.getDefaultCell().setBorder(Rectangle.NO_BORDER);
        dispatchTable.addCell(customerTable);
        dispatchTable.addCell(new Phrase(" "));
        dispatchTable.addCell(providerInfoTable);
        
        
        PdfPTable invoiceTable = null;
        if(withBill)
            invoiceTable = getTopInvoiceTable(order, tinNo);
        else
            invoiceTable = getTopInvoiceTable(order, warehouse.getTinNumber());
        
        PdfPCell addressCell = null;
        if(withBill)
            addressCell = getAddressCell(ourAddress);
        else
            addressCell = getAddressCell(warehouse.getLocation() + "\nPIN " + warehouse.getPincode() + "\n\n");
        
        PdfPTable chargesTable = new PdfPTable(1);
        chargesTable.getDefaultCell().setBorder(Rectangle.NO_BORDER);
        chargesTable.getDefaultCell().setHorizontalAlignment(Element.ALIGN_CENTER);
        if(order.isCod()){
            chargesTable.addCell(new Phrase("AMOUNT TO BE COLLECTED : Rs " + order.getTotal_amount(), helveticaBold12));
            chargesTable.addCell(new Phrase("RTO ADDRESS:DEL/ITG-111117"));
        } else {
            chargesTable.addCell(new Phrase("Do not pay any extra charges to the Courier."));  
        }

        PdfPTable addressAndNoteTable = new PdfPTable(new float[]{0.3f, 0.7f});
        addressAndNoteTable.getDefaultCell().setBorder(Rectangle.NO_BORDER);
        addressAndNoteTable.addCell(addressCell);
        addressAndNoteTable.addCell(chargesTable);
        
        table.addCell(logoTable);
        table.addCell(titleCell);
        table.addCell(dispatchTable);
        table.addCell(invoiceTable);
        table.addCell(new Phrase("If undelivered, return to:", helvetica10));
        table.addCell(addressAndNoteTable);
        return table;
    }

    private Font getBarCodeFont(Provider provider, float barcodeFontSize) {
        String fontPath = InvoiceGenerationService.class.getResource("/" + provider.getName().toLowerCase() + "/barcode.TTF").getPath();
        FontFactoryImp ttfFontFactory = new FontFactoryImp();
        ttfFontFactory.register(fontPath, "barcode");
        Font barCodeFont = ttfFontFactory.getFont("barcode", BaseFont.CP1252, true, barcodeFontSize);
        return barCodeFont;
    }

    private PdfPCell getLogoCell() {
        String logoPath = InvoiceGenerationService.class.getResource("/logo.jpg").getPath();
        PdfPCell logoCell;
        try {
            logoCell = new PdfPCell(Image.getInstance(logoPath), false);
        } catch (Exception e) {
            //Too Many exceptions to catch here: BadElementException, MalformedURLException and IOException
            logger.warn("Couldn't load the Saholic logo: ", e);
            logoCell = new PdfPCell(new Phrase("Saholic Logo"));
        }
        logoCell.setBorder(Rectangle.NO_BORDER);
        return logoCell;
    }

    private PdfPCell getTitleCell() {
        PdfPCell titleCell = new PdfPCell(new Phrase("Dispatch Advice", helveticaBold12));
        titleCell.setHorizontalAlignment(Element.ALIGN_CENTER);
        titleCell.setBorder(Rectangle.NO_BORDER);
        return titleCell;
    }

    private PdfPTable getProviderTable(Order order, Provider provider, Font barCodeFont) {
        PdfPTable providerInfoTable = new PdfPTable(1);
        providerInfoTable.getDefaultCell().setBorder(Rectangle.NO_BORDER);
        PdfPCell providerNameCell = new PdfPCell(new Phrase(provider.getName(), helveticaBold12));
        providerNameCell.setHorizontalAlignment(Element.ALIGN_LEFT);
        providerNameCell.setBorder(Rectangle.NO_BORDER);

        PdfPCell awbNumberCell = new PdfPCell(new Paragraph("*" + order.getAirwaybill_no() + "*", barCodeFont));
        awbNumberCell.setPaddingTop(20.0f);
        awbNumberCell.setVerticalAlignment(Element.ALIGN_MIDDLE);
        awbNumberCell.setBorder(Rectangle.NO_BORDER);

        providerInfoTable.addCell(providerNameCell);
        providerInfoTable.addCell(awbNumberCell);
        if(order.isCod())
            providerInfoTable.addCell(new Phrase("Account No : " + provider.getDetails().get(DeliveryType.COD).getAccountNo(), helvetica8));
        else
            providerInfoTable.addCell(new Phrase("Account No : " + provider.getDetails().get(DeliveryType.PREPAID).getAccountNo(), helvetica8));
        providerInfoTable.addCell(new Phrase("AWB Date   : " + DateFormat.getDateInstance(DateFormat.MEDIUM).format(new Date()), helvetica8));
        providerInfoTable.addCell(new Phrase("Weight         : " + order.getTotal_weight() + " Kg", helvetica8));
        return providerInfoTable;
    }

    private PdfPTable getTopInvoiceTable(Order order, String tinNo){
        PdfPTable invoiceTable = new PdfPTable(new float[]{0.2f, 0.2f, 0.3f, 0.1f, 0.1f, 0.1f});
        invoiceTable.getDefaultCell().setHorizontalAlignment(Element.ALIGN_CENTER);

        invoiceTable.addCell(getInvoiceTableHeader(6));

        invoiceTable.addCell(new Phrase("Order No", helvetica8));
        invoiceTable.addCell(new Phrase("Paymode", helvetica8));
        invoiceTable.addCell(new Phrase("Product Name", helvetica8));
        invoiceTable.addCell(new Phrase("Quantity", helvetica8));
        invoiceTable.addCell(new Phrase("Rate", helvetica8));
        invoiceTable.addCell(new Phrase("Amount", helvetica8));
        populateTopInvoiceTable(order, invoiceTable);

        invoiceTable.addCell(getTotalCell(4));      
        invoiceTable.addCell(getRupeesCell());
        invoiceTable.addCell(getTotalAmountCell(order.getTotal_amount()));

        PdfPCell tinCell = new PdfPCell(new Phrase("TIN NO. " + tinNo, helvetica8));
        tinCell.setColspan(6);
        tinCell.setPadding(2);
        invoiceTable.addCell(tinCell);
        
        return invoiceTable;
    }

    private void populateTopInvoiceTable(Order order, PdfPTable invoiceTable) {
        List<LineItem> lineitems = order.getLineitems();
        for (LineItem lineitem : lineitems) {
            invoiceTable.addCell(new Phrase(order.getId() + "", helvetica8));
            if(order.isCod())
                invoiceTable.addCell(new Phrase("COD", helvetica8));
            else
                invoiceTable.addCell(new Phrase("Prepaid", helvetica8));
            
            invoiceTable.addCell(getProductNameCell(lineitem, false));
            
            invoiceTable.addCell(new Phrase(lineitem.getQuantity() + "", helvetica8));
            
            invoiceTable.addCell(getPriceCell(lineitem.getUnit_price()));

            invoiceTable.addCell(getPriceCell(lineitem.getTotal_price()));
        }
    }
    
    private PdfPCell getAddressCell(String address) {
        Paragraph addressParagraph = new Paragraph(address, new Font(FontFamily.TIMES_ROMAN, 8f));
        PdfPCell addressCell = new PdfPCell();
        addressCell.addElement(addressParagraph);
        addressCell.setHorizontalAlignment(Element.ALIGN_LEFT);
        addressCell.setBorder(Rectangle.NO_BORDER);
        return addressCell;
    }
    
    private PdfPTable getTaxCumRetailInvoiceTable(Order order, Provider provider){
        PdfPTable taxTable = new PdfPTable(1);
        taxTable.getDefaultCell().setBorder(Rectangle.NO_BORDER);
        taxTable.getDefaultCell().setHorizontalAlignment(Element.ALIGN_CENTER);
        
        PdfPCell retailInvoiceTitleCell = new PdfPCell(new Phrase("TAX CUM RETAIL INVOICE", helveticaBold12));
        retailInvoiceTitleCell.setHorizontalAlignment(Element.ALIGN_CENTER);
        retailInvoiceTitleCell.setBorder(Rectangle.NO_BORDER);
        
        Paragraph sorlAddress = new Paragraph(ourAddress + "TIN NO. " + tinNo, new Font(FontFamily.TIMES_ROMAN, 8f, Element.ALIGN_CENTER));
        PdfPCell sorlAddressCell = new PdfPCell(sorlAddress);
        sorlAddressCell.addElement(sorlAddress);
        sorlAddressCell.setHorizontalAlignment(Element.ALIGN_CENTER);

        PdfPTable customerAddress = getCustomerAddressTable(order, null, true, helvetica8);
        PdfPTable orderDetails = getOrderDetails(order, provider);
        
        PdfPTable addrAndOrderDetailsTable = new PdfPTable(new float[]{0.5f, 0.1f, 0.4f});
        addrAndOrderDetailsTable.getDefaultCell().setBorder(Rectangle.NO_BORDER);
        addrAndOrderDetailsTable.addCell(customerAddress);
        addrAndOrderDetailsTable.addCell(new Phrase(" "));
        addrAndOrderDetailsTable.addCell(orderDetails);
        
        boolean isVAT = order.getCustomer_pincode().startsWith(delhiPincodePrefix);
        PdfPTable invoiceTable = getBottomInvoiceTable(order, isVAT);
        
        PdfPCell disclaimerCell = new PdfPCell(new Phrase("Goods once sold will not be taken back.\nAll disputes subject to Delhi Jurisdiction.", helvetica8));
        disclaimerCell.setHorizontalAlignment(Element.ALIGN_LEFT);
        disclaimerCell.setBorder(Rectangle.NO_BORDER);
                
        taxTable.addCell(retailInvoiceTitleCell);
        taxTable.addCell(sorlAddress);
        taxTable.addCell(addrAndOrderDetailsTable);
        taxTable.addCell(invoiceTable);
        taxTable.addCell(disclaimerCell);
        
        return taxTable;
    }
    
    private PdfPTable getCustomerAddressTable(Order order, String destCode, boolean showPaymentMode, Font font){
        PdfPTable customerTable = new PdfPTable(1);
        customerTable.getDefaultCell().setBorder(Rectangle.NO_BORDER);
        customerTable.addCell(new Phrase(order.getCustomer_name(), font));
        customerTable.addCell(new Phrase(order.getCustomer_address1(), font));
        customerTable.addCell(new Phrase(order.getCustomer_address2(), font));
        customerTable.addCell(new Phrase(order.getCustomer_city() + "," + order.getCustomer_state(), font));
        if(destCode != null)
            customerTable.addCell(new Phrase(order.getCustomer_pincode() + " - " + destCode, helvetica16));
        else
            customerTable.addCell(new Phrase(order.getCustomer_pincode(), font));
        customerTable.addCell(new Phrase("Phone :" + order.getCustomer_mobilenumber(), font));
        if(showPaymentMode){
            customerTable.addCell(new Phrase(" ", font));
            customerTable.addCell(new Phrase("Payment Mode: Prepaid", font));
        }
        return customerTable;
    }
    
    private PdfPTable getOrderDetails(Order order, Provider provider){
        PdfPTable orderTable = new PdfPTable(new float[]{0.4f, 0.6f});
        orderTable.getDefaultCell().setBorder(Rectangle.NO_BORDER);
        
        orderTable.addCell(new Phrase("Invoice No:", helvetica8));
        orderTable.addCell(new Phrase(order.getInvoice_number(), helvetica8));
        
        orderTable.addCell(new Phrase("Date:", helvetica8));
        orderTable.addCell(new Phrase(DateFormat.getDateInstance(DateFormat.MEDIUM).format(new Date(order.getBilling_timestamp())), helvetica8));
        
        orderTable.addCell(new Phrase(" "));
        orderTable.addCell(new Phrase(" "));
        
        orderTable.addCell(new Phrase("Order ID:", helvetica8));
        orderTable.addCell(new Phrase("" + order.getId(), helvetica8));
        
        orderTable.addCell(new Phrase("Order Date:", helvetica8));
        orderTable.addCell(new Phrase(DateFormat.getDateInstance(DateFormat.MEDIUM).format(new Date(order.getCreated_timestamp())), helvetica8));
        
        orderTable.addCell(new Phrase("Courier:", helvetica8));
        orderTable.addCell(new Phrase(provider.getName(), helvetica8));
        
        orderTable.addCell(new Phrase("AWB No:", helvetica8));
        orderTable.addCell(new Phrase(order.getAirwaybill_no(), helvetica8));
        
        orderTable.addCell(new Phrase("AWB Date:", helvetica8));
        orderTable.addCell(new Phrase(DateFormat.getDateInstance(DateFormat.MEDIUM).format(new Date()), helvetica8));
        
        return orderTable;
    }
    
    private PdfPTable getBottomInvoiceTable(Order order, boolean isVAT){
        PdfPTable invoiceTable = new PdfPTable(new float[]{0.2f, 0.5f, 0.1f, 0.1f, 0.1f});
        invoiceTable.getDefaultCell().setHorizontalAlignment(Element.ALIGN_CENTER);

        invoiceTable.addCell(getInvoiceTableHeader(5));

        invoiceTable.addCell(new Phrase("Sl. No.", helveticaBold8));
        invoiceTable.addCell(new Phrase("Description", helveticaBold8));
        invoiceTable.addCell(new Phrase("Quantity", helveticaBold8));
        invoiceTable.addCell(new Phrase("Rate (Rs)", helveticaBold8));
        invoiceTable.addCell(new Phrase("Amount (Rs)", helveticaBold8));
        
        double orderAmount = order.getTotal_amount();
        double rate = getTaxRate(orderAmount);
        double salesTax = (rate * orderAmount)/(100 + rate);
        
        populateBottomInvoiceTable(order, invoiceTable, rate);
        
        PdfPCell salesTaxCell = getPriceCell(salesTax);
        
        invoiceTable.addCell(getVATLabelCell(isVAT));
        invoiceTable.addCell(new Phrase(rate + "%", helvetica8));
        invoiceTable.addCell(salesTaxCell);
        
        invoiceTable.addCell(getEmptyCell(5));
        
        invoiceTable.addCell(getTotalCell(3));
        invoiceTable.addCell(getRupeesCell());
        invoiceTable.addCell(getTotalAmountCell(orderAmount));
        
        invoiceTable.addCell(new Phrase("Amount in Words:", helvetica8));
        invoiceTable.addCell(getAmountInWordsCell(orderAmount));
        
        invoiceTable.addCell(getEOECell(5));
        
        return invoiceTable;
    }

    private PdfPCell getInvoiceTableHeader(int colspan) {
        PdfPCell invoiceTableHeader = new PdfPCell(new Phrase("Order Details:", helveticaBold12));
        invoiceTableHeader.setBorder(Rectangle.NO_BORDER);
        invoiceTableHeader.setColspan(colspan);
        invoiceTableHeader.setPaddingTop(10);
        return invoiceTableHeader;
    }

    private double getTaxRate(double orderAmount) {
        double rate;
        if(orderAmount <= salesTaxCutOff){
            rate = salesTaxLowRate;
        } else {
            rate = salesTaxHighRate;
        }
        return rate;
    }

    private void populateBottomInvoiceTable(Order order, PdfPTable invoiceTable, double rate) {
        for (LineItem lineitem : order.getLineitems()) {
            invoiceTable.addCell(new Phrase("" + order.getId() , helvetica8));
            
            invoiceTable.addCell(getProductNameCell(lineitem, true));
            
            invoiceTable.addCell(new Phrase("" + lineitem.getQuantity(), helvetica8));
            
            double itemPrice = lineitem.getUnit_price();
            double showPrice = (100 * itemPrice)/(100 + rate);
            invoiceTable.addCell(getPriceCell(showPrice)); //Unit Price Cell
            
            double totalPrice = lineitem.getTotal_price();
            showPrice = (100 * totalPrice)/(100 + rate);
            invoiceTable.addCell(getPriceCell(showPrice));  //Total Price Cell
        }
    }

    private PdfPCell getProductNameCell(LineItem lineitem, boolean appendIMEI) {
        String itemName = getItemDisplayName(lineitem, appendIMEI);
        PdfPCell productNameCell = new PdfPCell(new Phrase(itemName, helvetica8));
        productNameCell.setHorizontalAlignment(Element.ALIGN_LEFT);
        return productNameCell;
    }

    private PdfPCell getPriceCell(double price) {
        PdfPCell totalPriceCell = new PdfPCell(new Phrase(amountFormat.format(price), helvetica8));
        totalPriceCell.setHorizontalAlignment(Element.ALIGN_RIGHT);
        return totalPriceCell;
    }

    private PdfPCell getVATLabelCell(boolean isVAT) {
        PdfPCell vatCell = null;
        if(isVAT){
            vatCell = new PdfPCell(new Phrase("VAT", helveticaBold8));
        } else {
            vatCell = new PdfPCell(new Phrase("CST", helveticaBold8));
        }
        vatCell.setColspan(3);
        vatCell.setHorizontalAlignment(Element.ALIGN_RIGHT);
        return vatCell;
    }
    
    private PdfPCell getEmptyCell(int colspan) {
        PdfPCell emptyCell = new PdfPCell(new Phrase(" ", helvetica8));
        emptyCell.setColspan(colspan);
        return emptyCell;
    }

    private PdfPCell getTotalCell(int colspan) {
        PdfPCell totalCell = new PdfPCell(new Phrase("Total", helveticaBold8));
        totalCell.setColspan(colspan);
        totalCell.setHorizontalAlignment(Element.ALIGN_RIGHT);
        return totalCell;
    }
    
    private PdfPCell getRupeesCell() {
        PdfPCell rupeesCell = new PdfPCell(new Phrase("Rs.", helveticaBold8));
        rupeesCell.setHorizontalAlignment(Element.ALIGN_RIGHT);
        return rupeesCell;
    }

    private PdfPCell getTotalAmountCell(double orderAmount) {
        PdfPCell totalAmountCell = new PdfPCell(new Phrase(amountFormat.format(orderAmount), helveticaBold8));
        totalAmountCell.setHorizontalAlignment(Element.ALIGN_RIGHT);
        return totalAmountCell;
    }

    /**
     * This method uses ICU4J libraries to convert the given amount into words
     * of Indian locale.
     * 
     * @param orderAmount
     *            The amount to convert.
     * @return the string representation of the given amount.
     */
    private PdfPCell getAmountInWordsCell(double orderAmount) {
        RuleBasedNumberFormat amountInWordsFormat = new RuleBasedNumberFormat(indianLocale, RuleBasedNumberFormat.SPELLOUT);
        StringBuilder amountInWords = new StringBuilder("Rs. ");
        amountInWords.append(WordUtils.capitalize(amountInWordsFormat.format((int)orderAmount)));
        amountInWords.append(" and ");
        amountInWords.append(WordUtils.capitalize(amountInWordsFormat.format((int)(orderAmount*100)%100)));
        amountInWords.append(" paise");
                
        PdfPCell amountInWordsCell= new PdfPCell(new Phrase(amountInWords.toString(), helveticaBold8));
        amountInWordsCell.setColspan(4);
        return amountInWordsCell;
    }

    /**
     * Returns the item name to be displayed in the invoice table.
     * 
     * @param lineitem
     *            The line item whose name has to be displayed
     * @param appendIMEI
     *            Whether to attach the IMEI No. to the item name
     * @return The name to be displayed for the given line item.
     */
    private String getItemDisplayName(LineItem lineitem, boolean appendIMEI){
        StringBuffer itemName = new StringBuffer();
        if(lineitem.getBrand()!= null)
            itemName.append(lineitem.getBrand() + " ");
        if(lineitem.getModel_name() != null)
            itemName.append(lineitem.getModel_name() + " ");
        if(lineitem.getModel_number() != null )
            itemName.append(lineitem.getModel_number() + " ");
        if(lineitem.getColor() != null && !lineitem.getColor().trim().equals("NA"))
            itemName.append("("+lineitem.getColor()+")");
        if(appendIMEI && lineitem.isSetImei_number()){
            itemName.append("\nIMEI No. " + lineitem.getImei_number());
        }
            
        return itemName.toString();
    }

    /**
     * 
     * @param colspan
     * @return a PdfPCell containing the E&amp;OE text and spanning the given
     *         no. of columns
     */
    private PdfPCell getEOECell(int colspan) {
        PdfPCell eoeCell = new PdfPCell(new Phrase("E & O.E", helvetica8));
        eoeCell.setColspan(colspan);
        eoeCell.setHorizontalAlignment(Element.ALIGN_RIGHT);
        return eoeCell;
    }
    
    private PdfPTable getExtraInfoTable(Order order, Provider provider, float barcodeFontSize){
        PdfPTable extraInfoTable = new PdfPTable(1);
        extraInfoTable.getDefaultCell().setBorder(Rectangle.NO_BORDER);
        extraInfoTable.getDefaultCell().setHorizontalAlignment(Element.ALIGN_CENTER);

        String fontPath = InvoiceGenerationService.class.getResource("/saholic.TTF").getPath();
        FontFactoryImp ttfFontFactory = new FontFactoryImp();
        ttfFontFactory.register(fontPath, "barcode");
        Font barCodeFont = ttfFontFactory.getFont("barcode", BaseFont.CP1252, true, barcodeFontSize);
        
        PdfPCell extraInfoCell = new PdfPCell(new Paragraph( "*" + order.getId() + "*        *" + order.getCustomer_name() + "*        *"  + order.getTotal_amount() + "*", barCodeFont));
        extraInfoCell.setPaddingTop(20.0f);
        extraInfoCell.setVerticalAlignment(Element.ALIGN_MIDDLE);
        extraInfoCell.setBorder(Rectangle.NO_BORDER);
        
        extraInfoTable.addCell(extraInfoCell);
        
        
        return extraInfoTable;
    }
    public static void main(String[] args) throws IOException {
        InvoiceGenerationService invoiceGenerationService = new InvoiceGenerationService();
        long orderId = 542;
        ByteArrayOutputStream baos = invoiceGenerationService.generateInvoice(orderId, false, false, 1);
        String userHome = System.getProperty("user.home");
        File f = new File(userHome + "/invoice-" + orderId + ".pdf");
        FileOutputStream fos = new FileOutputStream(f);
        baos.writeTo(fos);
        System.out.println("Invoice generated.");
    }
}