Subversion Repositories SmartDukaan

/**

 * 

 */

package in.shop2020.inventory.service;

import in.shop2020.purchase.LineItem;

import in.shop2020.purchase.PurchaseOrder;

import java.io.BufferedWriter;

import java.io.File;

import java.io.FileWriter;

import org.apache.commons.lang.StringUtils;

/**

 * @author mandeep

 *

 */

public class POExcelGenerator {

    public static File generateExcelSheet(PurchaseOrder purchaseOrder) {

        try {

            File file = new File("SORL-" + purchaseOrder.getId() + ".xls");

            BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(file));

            bufferedWriter.write(StringUtils.join(new String[]{"Brand", "Model Name", "Model Number", "Color", "Quantity Required", "Actual Quantity Fulfilled", "Other colors available"}, '\t'));

            for (LineItem lineitem : purchaseOrder.getLineitems()) {

                bufferedWriter.newLine();

                bufferedWriter.write(StringUtils.join(new String[]{lineitem.getBrand(), lineitem.getModelName(), lineitem.getModelNumber(), lineitem.getColor(), String.valueOf(lineitem.getQuantity()), "0", ""}, '\t'));

            }

            bufferedWriter.close();

            return file;

        } catch (Exception e) {

            return null;

        }

    }

}