Subversion Repositories SmartDukaan

package in.shop2020.inventory.service;

import in.shop2020.purchase.PurchaseOrder;

import in.shop2020.purchase.Supplier;

import in.shop2020.purchase.TaxType;

import java.io.ByteArrayOutputStream;

import java.io.File;

import java.io.FileOutputStream;

import java.io.IOException;

import java.math.BigDecimal;

import java.text.DateFormat;

import java.util.Date;

import org.slf4j.Logger;

import org.slf4j.LoggerFactory;

import com.itextpdf.text.Document;

import com.itextpdf.text.Element;

import com.itextpdf.text.Font;

import com.itextpdf.text.Font.FontFamily;

import com.itextpdf.text.FontFactory;

import com.itextpdf.text.Paragraph;

import com.itextpdf.text.Phrase;

import com.itextpdf.text.Rectangle;

import com.itextpdf.text.pdf.PdfPCell;

import com.itextpdf.text.pdf.PdfPTable;

import com.itextpdf.text.pdf.PdfWriter;

public class PdfPoSheetGenerator {

    private static Logger logger = LoggerFactory

            .getLogger(PdfPoSheetGenerator.class);

    // private static final Properties properties = readProperties();

    private static final String ourAddressDelhi = "Spice Online Retail Pvt. Ltd.\nC/O,PIBCO LIMITED, Basement,Punjsons\n2,Kalkaji Industrial Area, New Delhi-110019\n";

    private static final String ourAddressBhiwandi = "Spice Online Retail Pvt. Ltd.\nC/O. FedEx Express Transportation and Supply Chain Services (India) Private Limited.\nC/O NDR WAREHOUSING, SURVEY NO.95, MUMBAI - NASIK HIGHWAY, WADAPE VILLAGE\nBHIWANDI (NR. SAI DHABA), Thane,Maharashtra -421302\n";                   

    private static final String ourAddressGoregaon = "Spice Online Retail Pvt. Ltd.\n93/743, Motilal Nagar-1, Goregaon(WEST),\nMotilal Nagar, Mumbai, Maharashtra-400062\n";

    private static final String ourAddressBangalore = "Spice Online Retail Pvt. Ltd.\n C/O.Drive India Enterprise Solutions Limited)\n Survey No. 86, Korulur Village, Kasab Hobli\n Hoskote Taluka\n Bangalore – 560067, Karnataka\n";

    private static final String ourAddressBangaloreSR = "Spice Online Retail Pvt. Ltd.\n Shop No. 320, Municipal 59th Cross,\n Next to Rammandir Ground,\n 3rd Block, Rajaji Nagar,\nBangalore - 560010, Karnataka\n";

    private static final String ourAddressGurgaon = "Spice Online Retail Private Limited,\n SHOP NO. 10 & 11,\n OLD DELHI ROAD,OPP SECTOR-14, GURGAON-122001 Haryana\n";

    private static final String ourAddressHyderabad = "Spice Online Retail Pvt. Ltd, Drive India Enterprise Solutions Limited, 16,17&18, Gundllapochampalli, Kompalli, Medchal Mandal, Secandrabad-500014, Dist- Hyderabad";

    private static final String ourAddressGurgaonS = "Spice Online Retail Pvt Ltd. \nC/O.Drive India Enterprise Solutions Ltd, \nKhasra No.2771,Main Sheetla Mata Mandir Road \nOpposite Sec-5,Petrol Pump(Bharat Petroliam) \nNear Anmol Vatika, Gurgaon- 122001";

    private static final String amazonAddress = "Spice Online Retail Pvt. Ltd. C/O Amazon Seller Services  Pvt. Ltd.,\nBuilding H Prathmesh Complex, Saravali Village,\nOpp Hotel Vatika Kalyan, Bhivandi Junction,\nBhiwandi, Maharashtra\n";

    private static final String amazonAddreseBangalore = "Spice Online Retail Pvt. Ltd.\n C/O Amazon Seller Services Pvt. Ltd.\n 38 & 39, Soukya Road,\n kacherakanahalli,\n Hoskote Taluka,\n Bangalore  -560067, Karnataka\n";

    private static final String amazonAddressMewat = "Spice Online Retail Pvt. Ltd.\n C/O AMAZON Seller Services Pvt. Limited,\n  Gokaldas Warehousing Corporation,  Unit No 1,\n Village Taoru,  Tehsil Taoru, Distt Mewat - 122105";

    private static final String flipkartAddressGgn = "Spice Online Retail Pvt. Ltd.\n C/O. Flipkart Internet Pvt. Ltd, \n KILLA NO.219/15-16 25/1 220/11 12/1 12/2 13/1/113/1/2 20 21/1 21/2/1 22/1 23/1/1,\n Bohra Kalan, PATAUDI, GURGAON - 122001, Haryana\n";

    private static final String flipkartAddressDelhi = "Spice Online Retail Pvt. Ltd.\n C/O Flipkart Internet Pvt. Ltd.\n Khasra No. 435,Road No.# 04 ,Lal Dora Extension,\nMahipalpur, New Delhi- 110037\n";

    private static final String tinNoDelhi = "07250399732";

    private static final String tinNoMum = "27450984008";

    private static final String tinNoBan = "29171183852";

    private static final String tinNoFkGgn = "06681944625";

    private static final String tinNoOurGgn = "06681944625";

    private static final String tinNoOurHyd = "36601220768";

    private static final String tinNoFkDelhi = "07720408834";

    private static final Font helvetica8 = FontFactory.getFont(

            FontFactory.HELVETICA, 8);

    private static final Font helveticaBold8 = FontFactory.getFont(

            FontFactory.HELVETICA_BOLD, 8);

    private static final Font helveticaBold12 = FontFactory.getFont(

            FontFactory.HELVETICA_BOLD, 12);

    public static String generatePdfSheet(PurchaseOrder purchaseOrder,

            Supplier supplier) throws IOException {

        ByteArrayOutputStream baosPDF = null;

        try {

            baosPDF = new ByteArrayOutputStream();

            Document document = new Document();

            PdfWriter.getInstance(document, baosPDF);

            document.addAuthor("shop2020");

            document.addTitle("Purchase Order No: "

                    + purchaseOrder.getPoNumber());

            document.open();

            PdfPTable poTable = getPoTable(purchaseOrder, supplier);

            poTable.setSpacingAfter(10.0f);

            poTable.setWidthPercentage(90.0f);

            document.add(poTable);

            document.close();

            baosPDF.close();

        } catch (Exception e) {

            logger.error("Error while generating Invoice: ", e);

        }

        String tmpDir = System.getProperty("java.io.tmpdir");

        String filename = tmpDir + "/po-" + purchaseOrder.getId() + ".pdf";

        File f = new File(filename);

        FileOutputStream fos = new FileOutputStream(f);

        baosPDF.writeTo(fos);

        return filename;

    }

    private static PdfPTable getPoTable(PurchaseOrder purchaseOrder,

            Supplier supplier) throws Exception {

        PdfPTable poTable = new PdfPTable(1);

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

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

        PdfPCell poTitleCell = new PdfPCell(new Phrase("Purchase Order",

                helveticaBold12));

        poTitleCell.setHorizontalAlignment(Element.ALIGN_CENTER);

        poTitleCell.setBorder(Rectangle.NO_BORDER);

        Date poDate = new Date(purchaseOrder.getCreatedAt());

        PdfPTable poSummaryTable = new PdfPTable(new float[] { 0.5f, 0.5f });

        poSummaryTable.addCell(new PdfPCell(new Phrase("PO No: "

                + purchaseOrder.getPoNumber())));

        poSummaryTable.addCell(new PdfPCell(new Phrase("Date: "

        		+ DateFormat.getDateInstance(DateFormat.MEDIUM).format(

        				poDate))));

        poSummaryTable.setSpacingBefore(10.0f);

        poTable.addCell(poTitleCell);

        poTable.addCell(getAddressCell(purchaseOrder.getWarehouseId(), purchaseOrder.getShippingWarehouseId()));

        poTable.addCell(poSummaryTable);

        poTable.addCell(getSalutationTable(supplier));

        poTable.addCell(getPoDetailsTable(purchaseOrder));

        poTable.addCell(getBillToTable(purchaseOrder.getWarehouseId(), purchaseOrder.getTaxType()));

        //poTable.addCell(getCFormCell(purchaseOrder.getTaxType()));

        return poTable;

    }

    private static PdfPCell getCFormCell(TaxType taxType) {

    	PdfPCell cFormCell = null;

		if(taxType == TaxType.CFORM) {

			cFormCell = new PdfPCell(new Paragraph("*To be billed on CST Against C-Form ", new Font(FontFamily.TIMES_ROMAN, 8f)));

		} else {

			cFormCell = new PdfPCell();

		}

		cFormCell.setBorder(Rectangle.NO_BORDER);

		cFormCell.setHorizontalAlignment(Element.ALIGN_LEFT);

		return cFormCell;

	}

	private static PdfPTable getAddressCell(long warehouseId, long shippingWarehouseId) {

    	//TODO Write this code in a proper configurable way

    	String address = "";

    	String tinNo = "";

    	String shippingAddress = "";

    	String shippingTinNo = "";

    	if(warehouseId ==7) {

    		address = ourAddressDelhi;

    		tinNo = tinNoDelhi;

    	} else if(warehouseId == 12) {

    		address = ourAddressGoregaon;

    		tinNo = tinNoMum;

    	} else if(warehouseId == 13) {

    		address = ourAddressBhiwandi;

    		tinNo = tinNoMum;

    	} else if(warehouseId ==16) {

    		address = amazonAddress;

    		tinNo = tinNoMum;

    	} else if(warehouseId ==1765){

    		address = ourAddressBangalore;

    		tinNo = tinNoBan;

    	} else if(warehouseId ==1768){

    		address = ourAddressBangaloreSR;

    		tinNo = tinNoBan;

    	} else if(warehouseId ==1771){

    		address = amazonAddreseBangalore;

    		tinNo = tinNoBan;

    	} else if(warehouseId == 2854){

    		address = flipkartAddressGgn;

    		tinNo = tinNoFkGgn;

    	} else if(warehouseId == 2857){

    		address = ourAddressGurgaon;

    		tinNo = tinNoOurGgn;

    	} else if(warehouseId == 3295){

    		address = amazonAddressMewat;

    		tinNo = tinNoOurGgn;

    	} else if(warehouseId == 3298){

    		address = ourAddressHyderabad;

    		tinNo = tinNoOurHyd;

    	} else if(warehouseId == 3931){

    		address = ourAddressGurgaonS;

    		tinNo = tinNoOurGgn;

    	} else if(warehouseId == 4699){

    		address = flipkartAddressDelhi;

    		tinNo = tinNoFkDelhi;

    	}

    	PdfPTable billToShipToTable  = new PdfPTable(2);

        Paragraph addressParagraph = new Paragraph(address + "\nTIN NO. "

                + tinNo, new Font(FontFamily.TIMES_ROMAN, 8f));

        PdfPCell addressCell = new PdfPCell();

        if(warehouseId != shippingWarehouseId) {

           	addressParagraph = new Paragraph("Bill To :\n" + address + "\n\nTIN NO. "

                    + tinNo, new Font(FontFamily.TIMES_ROMAN, 8f));

        }

        addressCell.addElement(addressParagraph);

        //addressCell.setHorizontalAlignment(Element.ALIGN_CENTER);

        addressCell.setBorder(Rectangle.NO_BORDER);

        if(warehouseId != shippingWarehouseId) {

			if(shippingWarehouseId ==7) {

				shippingAddress = ourAddressDelhi;

				shippingTinNo = tinNoDelhi;

	    	} else if(shippingWarehouseId == 12) {

	    		shippingAddress = ourAddressGoregaon;

	    		shippingTinNo = tinNoMum;

	    	} else if(shippingWarehouseId == 13) {

	    		shippingAddress = ourAddressBhiwandi;

	    		shippingTinNo = tinNoMum;

	    	} else if(shippingWarehouseId ==16) {

	    		shippingAddress = amazonAddress;

	    		shippingTinNo = tinNoMum;

	    	} else if(shippingWarehouseId ==1765){

	    		shippingAddress = ourAddressBangalore;

	    		shippingTinNo = tinNoBan;

	    	} else if(shippingWarehouseId ==1768){

	    		shippingAddress = ourAddressBangaloreSR;

	    		shippingTinNo = tinNoBan;

	    	} else if(shippingWarehouseId ==1771){

	    		shippingAddress = amazonAddreseBangalore;

	    		shippingTinNo = tinNoBan;

	    	} else if(shippingWarehouseId == 2854){

	    		shippingAddress = flipkartAddressGgn;

	    		shippingTinNo = tinNoFkGgn;

	    	} else if(shippingWarehouseId == 2857){

	    		shippingAddress = ourAddressGurgaon;

	    		shippingTinNo = tinNoOurGgn;

	    	} else if(shippingWarehouseId == 3295){

	    		shippingAddress = amazonAddressMewat;

	    		shippingTinNo = tinNoOurGgn;

	    	} else if(shippingWarehouseId == 3298){

	    		shippingAddress = ourAddressHyderabad;

	    		shippingTinNo = tinNoOurHyd;

	    	} else if(shippingWarehouseId == 3931){

	    		shippingAddress = ourAddressGurgaonS;

	    		shippingTinNo = tinNoOurGgn;

	    	} else if(shippingWarehouseId == 4699){

	    		shippingAddress = flipkartAddressDelhi;

	    		shippingTinNo = tinNoFkDelhi;

	    	}

			PdfPCell billToShipToCell = new PdfPCell();

			billToShipToCell.setHorizontalAlignment(Element.ALIGN_LEFT);

			billToShipToCell.setBorder(Rectangle.NO_BORDER);

			PdfPCell shippingAddressCell = new PdfPCell();

			shippingAddressCell.addElement(new Paragraph("Ship To :\n" +shippingAddress + "\nTIN NO. "

	                + shippingTinNo, new Font(FontFamily.TIMES_ROMAN, 8f)));

			shippingAddressCell.setHorizontalAlignment(Element.ALIGN_LEFT);

	        shippingAddressCell.setBorder(Rectangle.LEFT);

	        billToShipToTable.addCell(addressCell);

	        billToShipToTable.addCell(shippingAddressCell);

	        billToShipToCell.addElement(billToShipToTable);

	        return billToShipToTable;

    	}

        billToShipToTable.addCell(addressCell);

        PdfPCell placeHolderCell = new PdfPCell();

        placeHolderCell.setBorder(Rectangle.NO_BORDER);

        billToShipToTable.addCell(placeHolderCell);

        return billToShipToTable;

    }

    private static PdfPTable getSalutationTable(Supplier supplier)

            throws Exception {

        PdfPTable salutationTable = new PdfPTable(1);

        salutationTable.getDefaultCell().setHorizontalAlignment(

                Element.ALIGN_LEFT);

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

        salutationTable.addCell(new Phrase("To", helvetica8));

        if(supplier.getName().equals("Smobility Ltd.")) {

        	salutationTable.addCell(new Phrase("Spice Retail Ltd.", helvetica8));

        } else if(supplier.getName().equals("Smobility Ltd. - Mumbai")) {

        	salutationTable.addCell(new Phrase("Spice Retail Ltd. Mumbai", helvetica8));

        } else {

        	salutationTable.addCell(new Phrase(supplier

                    .getName(), helvetica8));

        }

        salutationTable.addCell(new Paragraph(supplier

                .getCommunicationAddress(), helvetica8));

        salutationTable.addCell(new Phrase("Dear Sir/Madam", helveticaBold8));

        salutationTable

                .addCell(new Phrase(

                        "Please supply the following stocks as per the details given below:",

                        helvetica8));

        salutationTable.addCell(new Phrase(" "));

        return salutationTable;

    }

    private static PdfPTable getPoDetailsTable(PurchaseOrder purchaseOrder) {

        PdfPTable detailsTable = new PdfPTable(new float[] { 0.1f, 0.5f, 0.1f,

                0.1f, 0.15f, 0.15f });

        detailsTable.addCell(new Phrase("Sl. No.", helveticaBold8));

        detailsTable.addCell(new Phrase("Description", helveticaBold8));

        detailsTable.addCell(new Phrase("Quantity", helveticaBold8));

        detailsTable.addCell(new Phrase("Mrp", helveticaBold8));

        detailsTable.addCell(new Phrase("Rate (Rs)", helveticaBold8));

        detailsTable.addCell(new Phrase("Amount (Rs)", helveticaBold8));

        int slNo = 0;

        double total = 0;

        for (in.shop2020.purchase.LineItem lineitem : purchaseOrder

                .getLineitems()) {

            slNo++;

            detailsTable.addCell(new Phrase(slNo + "", helvetica8));

            detailsTable.addCell(getProductNameCell(lineitem));

            detailsTable.addCell(new Phrase(lineitem.getQuantity() + "",

                    helvetica8));

            detailsTable.addCell(new Phrase(lineitem.getMrp() + "",

                    helvetica8));

            detailsTable.addCell(new Phrase(lineitem.getUnitPrice() + "",

                    helvetica8));

            double lineTotal = lineitem.getQuantity() * lineitem.getUnitPrice();

            total += lineTotal;

            detailsTable.addCell(new Phrase("" + lineTotal, helvetica8));

        }

        detailsTable.addCell(getTotalCell(5));

        detailsTable.addCell(new Phrase(BigDecimal.valueOf(total).toPlainString(), helvetica8));

        return detailsTable;

    }

    private static PdfPTable getBillToTable(long warehouseId, TaxType taxType) {

    	//TODO Write this code in a proper configurable way

    	String address = "";

    	String tinNo = "";

    	String contactPerson = "";

    	if(warehouseId ==7) {

    		address = ourAddressDelhi;

    		tinNo = tinNoDelhi;

    		contactPerson = "Mr. Shiv Kumar, Contact No. +91 9953858076";

    	} else if(warehouseId == 12) {

    		address = ourAddressGoregaon;

    		tinNo = tinNoMum;

    		contactPerson = "Mr. Avinash Sambhaji Lavange, Contact No. +91 9004049589";

    	} else if(warehouseId == 13) {

    		address = ourAddressBhiwandi;

    		tinNo = tinNoMum;

    		contactPerson = "Mr. Vishal Tayade, Contact No. +91 9819231651";

    	} else if(warehouseId ==16) {

    		address = amazonAddress;

    		tinNo = tinNoMum;

    		contactPerson = "Mr. Sandeep Sachdeva, Contact No. +91 9716691287";

    	} else if(warehouseId ==1765) {

    		address = ourAddressBangalore;

    		tinNo = tinNoBan;

    		contactPerson = "Mr. Ravi Kumar, Contact No. +91 9686392567";

    	}

    	else if(warehouseId ==1768) {

    		address = ourAddressBangaloreSR;

    		tinNo = tinNoBan;

    		contactPerson = "Mr. Ravi Kumar, Contact No. +91 9686392567";

    	}

    	else if(warehouseId ==1771) {

    		address = amazonAddreseBangalore;

    		tinNo = tinNoBan;

    		contactPerson = "Mr. Ravi Kumar, Contact No. +91 9686392567";

    	}

    	else if(warehouseId ==2854) {

    		address = flipkartAddressGgn;

    		tinNo = tinNoFkGgn;

    		contactPerson = "Mr. Sandeep Sachdeva, Contact No. +91 9716691287";

    	} 

    	else if(warehouseId ==2857) {

    		address = ourAddressGurgaon;

    		tinNo = tinNoOurGgn;

    		contactPerson = "Mr. Sandeep Sachdeva, Contact No. +91 9716691287";

    	} 

    	else if(warehouseId == 3295) {

    		address = amazonAddressMewat;

    		tinNo = tinNoOurGgn;

    		contactPerson = "Mr. Sandeep Sachdeva, Contact No. +91 9716691287";

    	}

    	else if(warehouseId == 3298) {

    		address = ourAddressHyderabad;

    		tinNo = tinNoOurHyd;

    		contactPerson = "Mr. Achyuta Ramaiah A, Contact No. +91 9246581582";

    	}

    	else if(warehouseId == 3931) {

    		address = ourAddressGurgaonS;

    		tinNo = tinNoOurGgn;

    		contactPerson = "Mr. Sandeep Sachdeva, Contact No. +91 9716691287";

    	}

    	else if(warehouseId == 4699) {

    		address = flipkartAddressDelhi;

    		tinNo = tinNoFkDelhi;

    		contactPerson = "Mr. Sandeep Sachdeva, Contact No. +91 9716691287";

    	}

        PdfPTable billToTable = new PdfPTable(new float[] { 0.2f, 0.8f });

        billToTable.getDefaultCell().setHorizontalAlignment(Element.ALIGN_LEFT);

        billToTable.addCell(new Phrase("Bill To :", helvetica8));

        billToTable.addCell(new PdfPCell(new Paragraph(address

                + "\nTIN NO. " + tinNo, helvetica8)));

        billToTable.addCell(new Phrase("Contact Person:", helvetica8));

        billToTable.addCell(new Phrase(contactPerson, helvetica8));

        billToTable.addCell(new Phrase("Taxes:", helvetica8));

        if(taxType == TaxType.CFORM) {

        	billToTable.addCell(new Phrase("Prices inclusive of all taxes (To be billed on CST Against C-Form)",

        			helvetica8));

        } else {

        	billToTable.addCell(new Phrase("Prices inclusive of all taxes",

        			helvetica8));

        }

        return billToTable;

    }

    private static PdfPCell getProductNameCell(

            in.shop2020.purchase.LineItem lineitem) {

        String itemName = getItemDisplayName(lineitem);

        PdfPCell productNameCell = new PdfPCell(

                new Phrase(itemName, helvetica8));

        productNameCell.setHorizontalAlignment(Element.ALIGN_LEFT);

        return productNameCell;

    }

    private static String getItemDisplayName(

            in.shop2020.purchase.LineItem lineitem) {

        StringBuffer itemName = new StringBuffer();

        if (lineitem.getBrand() != null)

            itemName.append(lineitem.getBrand() + " ");

        if (lineitem.getModelName() != null)

            itemName.append(lineitem.getModelName() + " ");

        if (lineitem.getModelNumber() != null)

            itemName.append(lineitem.getModelNumber() + " ");

        if (lineitem.getColor() != null

                && !lineitem.getColor().trim().equals("NA"))

            itemName.append("(" + lineitem.getColor() + ")");

        return itemName.toString();

    }

    private static PdfPCell getTotalCell(int colspan) {

        PdfPCell totalCell = new PdfPCell(new Phrase("Total", helveticaBold8));

        totalCell.setColspan(colspan);

        totalCell.setHorizontalAlignment(Element.ALIGN_RIGHT);

        return totalCell;

    }

}