Subversion Repositories SmartDukaan

Rev

Rev 24012 | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 24012 Rev 24095
Line 30... Line 30...
30 
		}
 30 
		}
31 
	}
 31 
	}
32 
    public static File generateExcelSheet(PurchaseOrder purchaseOrder) {
 32 
    public static File generateExcelSheet(PurchaseOrder purchaseOrder) {
33 
        try {
 33 
        try {
34 
        	String tmpDir = System.getProperty("java.io.tmpdir");
 34 
        	String tmpDir = System.getProperty("java.io.tmpdir");
35 
            File file = new File(tmpDir + "/SORL-" + purchaseOrder.getId() + ".xls");
 35 
            File file = new File(tmpDir + "/NSSPL-" + purchaseOrder.getId() + ".xls");
36 
            BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(file));
 36 
            BufferedWriter bufferedWriter = new BufferedWriter(new FileWriter(file));
37 
            bufferedWriter.write(StringUtils.join(new String[]{"Brand", "Model Name", "Model Number", "Color", "Vendor Key", "Quantity Required", "Actual Quantity Fulfilled", "Other colors available"}, '\t'));
 37 
            bufferedWriter.write(StringUtils.join(new String[]{"Brand", "Model Name", "Model Number", "Color", "Vendor Key", "Quantity Required", "Actual Quantity Fulfilled", "Other colors available"}, '\t'));
38
38
39 
            for (LineItem lineitem : purchaseOrder.getLineitems()) {
 39 
            for (LineItem lineitem : purchaseOrder.getLineitems()) {
40 
            	String vendorKey = "";
 40 
            	String vendorKey = "";