Subversion Repositories SmartDukaan

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.PickUpType;

import in.shop2020.logistics.PickupStore;

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.Attribute;

import in.shop2020.model.v1.order.LineItem;

import in.shop2020.model.v1.order.Order;

import in.shop2020.model.v1.order.OrderStatus;

import in.shop2020.model.v1.order.OrderType;

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.Calendar;

import java.util.Date;

import java.util.Enumeration;

import java.util.GregorianCalendar;

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"));

    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 {

	                List<OrderStatus> statuses = new ArrayList<OrderStatus>();

	                statuses.add(OrderStatus.ACCEPTED);

	                orders = tclient.getAllOrders(statuses, 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);

            		if(provider.getPickup().equals(PickUpType.SELF) || provider.getPickup().equals(PickUpType.RUNNER))

            			destCode = provider.getPickup().toString();

            		else

            			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();

         // Adding facility to store the bill on the local directory. This will happen for only for Mahipalpur warehouse.

            if(withBill && !printAll){

            	Calendar cal = new GregorianCalendar();

            	cal.setTimeInMillis(orders.get(0).getBilling_timestamp());

            	int year = cal.get(Calendar.YEAR);

      		  	int month = cal.get(Calendar.MONTH);

      		  	int day = cal.get(Calendar.DAY_OF_MONTH);

      		  	String dirPath = "/SaholicInvoices" + File.separator + year + File.separator  + month + File.separator + day;

      		  	File dirFile = new File(dirPath);

      		  	if(!dirFile.exists()){

      		  		dirFile.mkdirs();	

      		  	}

      		  	File f = new File( dirPath + File.separator + orderId + ".pdf");

                FileOutputStream fos = new FileOutputStream(f);

                baosPDF.writeTo(fos);

            }

        } 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.isLogisticsCod())

            logoTable.addCell(new Phrase("COD   ", helvetica28));

        else

        	logoTable.addCell(new Phrase("   ", helvetica28));

        PdfPCell titleCell = getTitleCell();

        PdfPTable customerTable = getCustomerAddressTable(order, destCode, false, helvetica12, false);

        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);

        Warehouse shippingLocation = CatalogUtils.getWarehouse(warehouse.getShippingWarehouseId());

        PdfPTable invoiceTable = getTopInvoiceTable(order, shippingLocation.getTinNumber());

        PdfPCell addressCell = getAddressCell(shippingLocation.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.isLogisticsCod()){

            chargesTable.addCell(new Phrase("AMOUNT TO BE COLLECTED : Rs " + order.getTotal_amount(), helveticaBold12));

            chargesTable.addCell(new Phrase("RTO ADDRESS:DEL/HPW/111116"));

        } 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.isLogisticsCod())

            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(order.getBilling_timestamp())), 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.getPickupStoreId() > 0 && order.isCod() == true)

                invoiceTable.addCell(new Phrase("In-Store", helvetica8));

            else if (order.isCod())

                invoiceTable.addCell(new Phrase("COD", helvetica8));

            else

                invoiceTable.addCell(new Phrase("Prepaid", helvetica8));

            /*

            if(order.isLogisticsCod())

                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);

        Phrase phrase = null;

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

        taxTable.getDefaultCell().setHorizontalAlignment(Element.ALIGN_CENTER);

        if (order.getOrderType().equals(OrderType.B2B)) {

            phrase = new Phrase("TAX INVOICE", helveticaBold12);

        } else {

            phrase = new Phrase("RETAIL INVOICE", helveticaBold12);

        }

        PdfPCell retailInvoiceTitleCell = new PdfPCell(phrase);

        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, true);

        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.\nThis is a Computer generated Invoice.", 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, boolean forInvoce){

        PdfPTable customerTable = new PdfPTable(1);

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

        if(forInvoce || order.getPickupStoreId() == 0){

	        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));

        }else{

        	try {

				in.shop2020.logistics.LogisticsService.Client lclient = (new LogisticsClient()).getClient();

	            PickupStore store = lclient.getPickupStore(order.getPickupStoreId());

			    customerTable.addCell(new Phrase(order.getCustomer_name() + " \nc/o " + store.getName(), font));

		        customerTable.addCell(new Phrase(store.getLine1(), font));

		        customerTable.addCell(new Phrase(store.getLine2(), font));

		        customerTable.addCell(new Phrase(store.getCity() + "," + store.getState(), font));

		        if(destCode != null)

		            customerTable.addCell(new Phrase(store.getPin() + " - " + destCode, helvetica16));

		        else

		            customerTable.addCell(new Phrase(store.getPin(), font));

		        customerTable.addCell(new Phrase("Phone :" + store.getPhone(), font));

			} catch (TException e) {

				// TODO Auto-generated catch block

				e.printStackTrace();

			}

        }

        if(order.getOrderType().equals(OrderType.B2B)) {

            String tin = null;

            in.shop2020.model.v1.order.TransactionService.Client tclient = tsc.getClient();

            List<Attribute> attributes;

            try {

                attributes = tclient.getAllAttributesForOrderId(order.getId());

                for(Attribute attribute : attributes) {

                    if(attribute.getName().equals("tinNumber")) {

                        tin = attribute.getValue();

                    }

                }

                if (tin != null) {

                    customerTable.addCell(new Phrase("TIN :" + tin, font));

                }

            } catch (Exception e) {

                logger.error("Error while getting order attributes", e);

            }

        }

        /*

        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(order.getBilling_timestamp())), 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(order.getLineitems().get(0).getUnit_price());

        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.isSetSerial_number()){

            itemName.append("\nIMEI No. " + lineitem.getSerial_number());

        }

        return itemName.toString();

    }

    /**

     * 

     * @param colspan

     * @return a PdfPCell containing the E&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 = 148574;

        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.");

    }

}