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