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 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 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;
        }
        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;
                }
                        
                        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 ==16) {
                address = amazonAddress;
                tinNo = tinNoMum;
                contactPerson = "Mr. Sandeep Sachdeva, Contact No. +91 9716691287";
        } 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";
        }

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

}