Subversion Repositories SmartDukaan

Rev

Rev 12174 | Rev 12177 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 12174 Rev 12176
Line 721... Line 721...
721 
			List<StockSaleDetail> slowMovingStockSaleList,
721 
			List<StockSaleDetail> slowMovingStockSaleList,
722 
			List<StockSaleDetail> nonMovingStockSaleList,
722 
			List<StockSaleDetail> nonMovingStockSaleList,
723 
			boolean mobTab) {
 723 
			boolean mobTab) {
724 
		String  fileName = "";
 724 
		String  fileName = "";
725 
		try{
 725 
		try{
726 
			HSSFWorkbook workbook = new HSSFWorkbook();
 726 
			HSSFWorkbook mtWorkbook = new HSSFWorkbook();
- 
 
 727 
			HSSFWorkbook emtWorkbook = new HSSFWorkbook();
- 
 
 728 
			HSSFSheet movingSheet;
- 
 
 729 
			HSSFSheet nonMovingSheet;
- 
 
 730 
			HSSFSheet slowMovingSheet;
- 
 
 731 
			if(mobTab){
727 
			HSSFSheet movingSheet = workbook.createSheet("Moving-Stock");
 732 
				movingSheet = mtWorkbook.createSheet("Moving-Stock");
728 
			HSSFSheet nonMovingSheet = workbook.createSheet("Non-Moving-Stock");
 733 
				nonMovingSheet = mtWorkbook.createSheet("Non-Moving-Stock");
729 
			HSSFSheet slowMovingSheet = workbook.createSheet("Non-Moving-Stock");
 734 
				slowMovingSheet = mtWorkbook.createSheet("Non-Moving-Stock");
- 
 
 735 
			} else {
- 
 
 736 
				movingSheet = emtWorkbook.createSheet("Moving-Stock");
- 
 
 737 
				nonMovingSheet = emtWorkbook.createSheet("Non-Moving-Stock");
- 
 
 738 
				slowMovingSheet = emtWorkbook.createSheet("Non-Moving-Stock");
- 
 
 739 
			}
- 
 
 740
730 
			Row row = movingSheet.createRow(0);
 741 
			Row row = movingSheet.createRow(0);
731 
 
 742 
 
732 
			row.createCell(0).setCellValue("ItemId");
 743 
			row.createCell(0).setCellValue("ItemId");
733 
			row.createCell(1).setCellValue("Category");
 744 
			row.createCell(1).setCellValue("Category");
734 
			row.createCell(2).setCellValue("ProductGroup");
 745 
			row.createCell(2).setCellValue("ProductGroup");
Line 895... Line 906...
895 
			FileOutputStream out;
 906 
			FileOutputStream out;
896 
			if(mobTab){
 907 
			if(mobTab){
897 
				File stockSalesReportMT = new File(tmpDir + "/StockSaleReport-MT" + (new Date()) + ".xls");
 908 
				File stockSalesReportMT = new File(tmpDir + "/StockSaleReport-MT" + (new Date()) + ".xls");
898 
				out = new FileOutputStream(stockSalesReportMT);
 909 
				out = new FileOutputStream(stockSalesReportMT);
899 
				fileName = stockSalesReportMT.getName();
 910 
				fileName = stockSalesReportMT.getName();
- 
 
 911 
				mtWorkbook.write(out);
900 
			} else {
 912 
			} else {
901 
				File stockSalesReportEMT = new File(tmpDir + "/StockSaleReport-EMT" + (new Date()) + ".xls");
 913 
				File stockSalesReportEMT = new File(tmpDir + "/StockSaleReport-EMT" + (new Date()) + ".xls");
902 
				out = new FileOutputStream(stockSalesReportEMT);
 914 
				out = new FileOutputStream(stockSalesReportEMT);
903 
				fileName = stockSalesReportEMT.getName();
 915 
				fileName = stockSalesReportEMT.getName();
- 
 
 916 
				emtWorkbook.write(out);
904 
			}
 917 
			}
905 
			workbook.write(out);
 918
906 
			out.close();
 919 
			out.close();
907 
			System.out.println("Excel written successfully..");
 920 
			System.out.println("Excel written successfully..");
908 
		}catch(Exception e){
 921 
		}catch(Exception e){
909 
			e.printStackTrace();
 922 
			e.printStackTrace();
910 
		}
 923 
		}