Subversion Repositories SmartDukaan

Rev

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

Rev 1389 Rev 3107
Line 21... Line 21...
21 
import org.apache.poi.ss.usermodel.CreationHelper;
 21 
import org.apache.poi.ss.usermodel.CreationHelper;
22 
import org.apache.poi.ss.usermodel.Row;
 22 
import org.apache.poi.ss.usermodel.Row;
23 
import org.apache.poi.ss.usermodel.Sheet;
 23 
import org.apache.poi.ss.usermodel.Sheet;
24 
import org.apache.poi.ss.usermodel.Workbook;
 24 
import org.apache.poi.ss.usermodel.Workbook;
25 
import org.apache.thrift.TException;
 25 
import org.apache.thrift.TException;
- 
 
 26 
import org.slf4j.Logger;
- 
 
 27 
import org.slf4j.LoggerFactory;
26 
 
 28 
 
27 
public class PendingOrdersGenerator {
 29 
public class PendingOrdersGenerator {
- 
 
 30
- 
 
 31 
    private static Logger logger = LoggerFactory.getLogger(PendingOrdersGenerator.class);
- 
 
 32
28 
	private TransactionServiceClient tsc = null;
 33 
	private TransactionServiceClient tsc = null;
29
34
30 
	public PendingOrdersGenerator(){
 35 
	public PendingOrdersGenerator(){
31 
		try {
 36 
		try {
32 
			tsc = new TransactionServiceClient();
 37 
			tsc = new TransactionServiceClient();
33 
		} catch (Exception e) {
 38 
		} catch (Exception e) {
34 
			e.printStackTrace();
 39 
			logger.error("Error establishing connection to transaction service", e);
35 
		}
 40 
		}
36 
	}
 41 
	}
37 
 
 42 
 
38 
	public ByteArrayOutputStream generatePendingOrdersDetails(long warehouseId){
 43 
	public ByteArrayOutputStream generatePendingOrdersDetails(long warehouseId){
39 
		final int COL_SNO = 0,
 44 
		final int COL_SNO = 0,
Line 54... Line 59...
54
59
55 
		try {
 60 
		try {
56 
			orders = txnClient.batchOrders(warehouseId);
 61 
			orders = txnClient.batchOrders(warehouseId);
57 
			//getAllOrders(OrderStatus.SUBMITTED_FOR_PROCESSING, 0L, new Date().getTime(), warehouseId);
 62 
			//getAllOrders(OrderStatus.SUBMITTED_FOR_PROCESSING, 0L, new Date().getTime(), warehouseId);
58 
		} catch (TransactionServiceException e) {
 63 
		} catch (TransactionServiceException e) {
59 
			e.printStackTrace();
 64 
			logger.error("Error in transaction service while batching orders", e);
60 
			return baosXLS;
 65 
			return baosXLS;
61 
		} catch (TException e) {
 66 
		} catch (TException e) {
62 
			e.printStackTrace();
 67 
			logger.error("Error getting info from transaction service", e);
63 
			return baosXLS;
 68 
			return baosXLS;
64 
		}
 69 
		}
65
70
66 
		Workbook wb = new HSSFWorkbook();
 71 
		Workbook wb = new HSSFWorkbook();
67 
		CreationHelper createHelper = wb.getCreationHelper();
 72 
		CreationHelper createHelper = wb.getCreationHelper();
Line 205... Line 210...
205 
	    // Write the workbook to the output stream
 210 
	    // Write the workbook to the output stream
206 
		try {
 211 
		try {
207 
			wb.write(baosXLS);
 212 
			wb.write(baosXLS);
208 
			baosXLS.close();
 213 
			baosXLS.close();
209 
		} catch (IOException e) {
 214 
		} catch (IOException e) {
210 
			e.printStackTrace();
 215 
			logger.error("Error streaming pending orders report", e);
211 
		}
 216 
		}
212 
		return baosXLS;
 217 
		return baosXLS;
213 
	}
 218 
	}
214
219
215 
	private String getValueForEmptyString(String s){
 220 
	private String getValueForEmptyString(String s){
Line 226... Line 231...
226 
			FileOutputStream f = new FileOutputStream(userHome + "/pending-orders.xls");
 231 
			FileOutputStream f = new FileOutputStream(userHome + "/pending-orders.xls");
227 
			ByteArrayOutputStream baosXLS = pendingOrdersGenerator.generatePendingOrdersDetails(1);
 232 
			ByteArrayOutputStream baosXLS = pendingOrdersGenerator.generatePendingOrdersDetails(1);
228 
			baosXLS.writeTo(f);
 233 
			baosXLS.writeTo(f);
229 
			f.close();
 234 
			f.close();
230 
		} catch (FileNotFoundException e) {
 235 
		} catch (FileNotFoundException e) {
231 
			e.printStackTrace();
 236 
			logger.error("Error while creating the pending orders report", e);
232 
		} catch (IOException e) {
 237 
		} catch (IOException e) {
233 
			e.printStackTrace();
 238 
			logger.error("IO error while writing the pending orders report", e);
234 
		}
 239 
		}
235 
		System.out.println("Successfully generated the pending orders report");
 240 
		System.out.println("Successfully generated the pending orders report");
236 
	}
 241 
	}
237 
}
 242 
}