WebSVN – SmartDukaan – Diff – /trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/util/ExcelUtils.java

 			workbook.close();
 		} catch (IOException ioException) {
 			LOGGER.error("Unable to generate excel file", ioException);
+		}
+	}
-	public static void writeItemCompleteLedgerModels(Map<String,List<ItemCompleteLedgerModel>> itemCompleteLedgerModelsMap,
+	public static void writeItemCompleteLedgerModels(
-			OutputStream outputStream) {
+			Map<String, List<ItemCompleteLedgerModel>> itemCompleteLedgerModelsMap, OutputStream outputStream) {
 		SXSSFWorkbook workbook = new SXSSFWorkbook();
 		// CreationHelper createHelper = workbook.getCreationHelper();
-		for(Map.Entry<String, List<ItemCompleteLedgerModel>> itemCompleteLedgerModelsEntry : itemCompleteLedgerModelsMap.entrySet()) {
+		for (Map.Entry<String, List<ItemCompleteLedgerModel>> itemCompleteLedgerModelsEntry : itemCompleteLedgerModelsMap
+				.entrySet()) {
 			SXSSFSheet sheet = workbook.createSheet(itemCompleteLedgerModelsEntry.getKey());
 			List<ItemCompleteLedgerModel> itemCompleteLedgerModels = itemCompleteLedgerModelsEntry.getValue();
 			sheet.addMergedRegion(new CellRangeAddress(0, 1, 0, 0));
 			sheet.addMergedRegion(new CellRangeAddress(0, 1, 1, 1));
 			sheet.addMergedRegion(new CellRangeAddress(0, 1, 2, 2));
 			sheet.addMergedRegion(new CellRangeAddress(0, 1, 3, 3));
 			sheet.addMergedRegion(new CellRangeAddress(0, 1, 4, 4));
 			sheet.addMergedRegion(new CellRangeAddress(0, 1, 5, 5));
 			sheet.trackAllColumnsForAutoSizing();
 			Row rowHeader = sheet.createRow(0);
 			Cell cellItemIdHeader = rowHeader.createCell(0);
 			cellItemIdHeader.setCellValue("Item Id");
 			Cell cellBrandHeader = rowHeader.createCell(1);
 			cellBrandHeader.setCellValue("Brand");
 			Cell cellOutwardsHeader = rowHeader.createCell(12);
 			cellOutwardsHeader.setCellValue("Outwards");
 			Cell cellClosingBalanceHeader = rowHeader.createCell(15);
 			cellClosingBalanceHeader.setCellValue("Closing Balance");
 			Row rowQuantityRateValue = sheet.createRow(1);
 			for (int index = 6; index < 18; index = index + 3) {
 				Cell cellQuantityHeader = rowQuantityRateValue.createCell(index);
 				cellQuantityHeader.setCellValue("Quantity");
 				Cell cellRateHeader = rowQuantityRateValue.createCell(index + 1);
 				cellRateHeader.setCellValue("Rate");
 					cellOpeningValue.setCellValue("-");
 				} else {
 					cellOpeningQuantity.setCellValue(itemCompleteLedgerModel.getOpeningLedger().getQuantity());
 					cellOpeningRate.setCellValue(itemCompleteLedgerModel.getOpeningLedger().getRate());
 					cellOpeningValue.setCellValue(itemCompleteLedgerModel.getOpeningLedger().getValue());
+					openingQuantityTotal = openingQuantityTotal
-					openingQuantityTotal = openingQuantityTotal + itemCompleteLedgerModel.getOpeningLedger().getQuantity();
+							+ itemCompleteLedgerModel.getOpeningLedger().getQuantity();
 					openingValueTotal = openingValueTotal + itemCompleteLedgerModel.getOpeningLedger().getValue();
+				}
 				Cell cellInwardsQuantity = rowValues.createCell(9);
 				Cell cellInwardsRate = rowValues.createCell(10);
 				Cell cellInwardsValue = rowValues.createCell(11);
 					cellInwardsValue.setCellValue("-");
 				} else {
 					cellInwardsQuantity.setCellValue(itemCompleteLedgerModel.getInwardsLedger().getQuantity());
 					cellInwardsRate.setCellValue(itemCompleteLedgerModel.getInwardsLedger().getRate());
 					cellInwardsValue.setCellValue(itemCompleteLedgerModel.getInwardsLedger().getValue());
+					inwardsQuantityTotal = inwardsQuantityTotal
-					inwardsQuantityTotal = inwardsQuantityTotal + itemCompleteLedgerModel.getInwardsLedger().getQuantity();
+							+ itemCompleteLedgerModel.getInwardsLedger().getQuantity();
 					inwardsValueTotal = inwardsValueTotal + itemCompleteLedgerModel.getInwardsLedger().getValue();
+				}
 				Cell cellOutwardsQuantity = rowValues.createCell(12);
 				Cell cellOutwardsRate = rowValues.createCell(13);
 				Cell cellOutwardsValue = rowValues.createCell(14);
 					cellClosingValue.setCellValue("-");
 				} else {
 					cellClosingQuantity.setCellValue(itemCompleteLedgerModel.getClosingLedger().getQuantity());
 					cellClosingRate.setCellValue(itemCompleteLedgerModel.getClosingLedger().getRate());
 					cellClosingValue.setCellValue(itemCompleteLedgerModel.getClosingLedger().getValue());
+					closingQuantityTotal = closingQuantityTotal
-					closingQuantityTotal = closingQuantityTotal + itemCompleteLedgerModel.getClosingLedger().getQuantity();
+							+ itemCompleteLedgerModel.getClosingLedger().getQuantity();
 					closingValueTotal = closingValueTotal + itemCompleteLedgerModel.getClosingLedger().getValue();
+				}
+			}
 			Row rowTotal = sheet.createRow(itemCompleteLedgerModels.size() + 2);
 			if (openingQuantityTotal > 0) {
 				Cell cellOpeningQuantityTotal = rowTotal.createCell(6);
 				cellOpeningQuantityTotal.setCellValue(openingQuantityTotal);
 				Cell cellOpeningValueTotal = rowTotal.createCell(8);
 				cellOpeningValueTotal.setCellValue(openingValueTotal);
+			}
 			if (inwardsQuantityTotal > 0) {
 				Cell cellInwardsQuantityTotal = rowTotal.createCell(9);
 				cellInwardsQuantityTotal.setCellValue(inwardsQuantityTotal);
 				Cell cellInwardsValueTotal = rowTotal.createCell(11);
 				cellInwardsValueTotal.setCellValue(inwardsValueTotal);
+			}
 			if (outwardsQuantityTotal > 0) {
 				Cell cellOutwardsQuantityTotal = rowTotal.createCell(12);
 				cellOutwardsQuantityTotal.setCellValue(outwardsQuantityTotal);
 				Cell cellOutwardsValueTotal = rowTotal.createCell(14);
 				cellOutwardsValueTotal.setCellValue(outwardsValueTotal);
+			}
 			if (closingQuantityTotal > 0) {
 				Cell cellClosingQuantityTotal = rowTotal.createCell(15);
 				cellClosingQuantityTotal.setCellValue(closingQuantityTotal);
 				Cell cellClosingValueTotal = rowTotal.createCell(17);
 				cellClosingValueTotal.setCellValue(closingValueTotal);
+			}
 			for (int index = 0; index < 18; index++) {
 				sheet.autoSizeColumn(index);
+			}
+		}
 		try {
+			}
+		}
 		return partnerTargetModels;
+	}
-	public static void writeDailySaleReportVsTarget(String targetName,Map<Integer, Float> targetValues, Map<Integer, Double> saleValues,
+	public static void writeDailySaleReportVsTargetForPartner(Map<Integer, String> targetIdAndTargetNameMap,
-			Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer, Map<Integer, String> fofoIdsAndSlabNames,
-			Map<Integer, Double> monthlyTargetAchievementPercentage, Map<Integer, Float> dailyAverageSale,
-			Map<Integer, Double> remainingMonthlyTargets, Map<Integer, Double> todayAchievements,
+			Map<Integer, Float> targetIdAndtargetValuesMap, Map<Integer, Double> targetIdAndsaleValuesMap,
-			 List<Integer> fofoIds,
-			Map<Integer, String> salesHeadNameAndFofoIdMap, OutputStream outputStream) {
-		SXSSFWorkbook workbook = new SXSSFWorkbook();
-		// CreationHelper createHelper = workbook.getCreationHelper();
-		SXSSFSheet sheet = workbook.createSheet("DailySaleReports");
-		sheet.trackAllColumnsForAutoSizing();
-		Row rowHeader = sheet.createRow(0);
-		Cell cellStoreName = rowHeader.createCell(0);
-		cellStoreName.setCellValue("Store Name");
-		Cell cellBusiness = rowHeader.createCell(1);
-		cellBusiness.setCellValue("Business Manager");
-		Cell cellAssistant = rowHeader.createCell(2);
-		cellAssistant.setCellValue("Assistant Manager");
-		Cell cellSchemeName = rowHeader.createCell(3);
-		cellSchemeName.setCellValue("Scheme Name");
-		Cell cellTargetValue = rowHeader.createCell(4);
-		cellTargetValue.setCellValue("Scheme Target");
-		Cell cellTotalAchievement = rowHeader.createCell(5);
-		cellTotalAchievement.setCellValue("Total Achievement");
-		Cell cellTotalAchievementPercentage = rowHeader.createCell(6);
-		cellTotalAchievementPercentage.setCellValue("Total Achievement Percentage");
-		Cell cellDailyTarget = rowHeader.createCell(7);
-		cellDailyTarget.setCellValue("Daily Target");
-		Cell cellTodayAchievement = rowHeader.createCell(8);
-		cellTodayAchievement.setCellValue("Today Achievement");
-		Cell cellRemainingTarget = rowHeader.createCell(9);
-		cellRemainingTarget.setCellValue("Remaining Target");
-		Cell cellEligibility = rowHeader.createCell(10);
-		cellEligibility.setCellValue("Eligibility");
-		Font font = workbook.createFont();
-		CellStyle cellStyle = workbook.createCellStyle();
-		font.setBold(true);
-		cellStyle.setAlignment(HorizontalAlignment.CENTER);
-		// font.setFontHeight((short)16);
-		cellStyle.setFont(font);
-		for (int i = 0; i < 14; i++) {
-			if (rowHeader.getCell(i) != null) {
-				rowHeader.getCell(i).setCellStyle(cellStyle);
-			}
-		}
-		int rownum = 1;
-		for (Integer fofoId : fofoIds) {
-			Row row = sheet.createRow(rownum++);
-			int cellnum = 0;
-			Cell cellPartner = row.createCell(cellnum++);
-			if (fofoIdsAndCustomRetailer.get(fofoId) != null) {
-				cellPartner.setCellValue(fofoIdsAndCustomRetailer.get(fofoId).getBusinessName());
-			} else {
-				cellPartner.setCellValue("-");
-			}
-			Cell cellBusinessManager = row.createCell(cellnum++);
-			if (salesHeadNameAndFofoIdMap.get(fofoId) != null) {
-				if (salesHeadNameAndFofoIdMap.get(fofoId).equals("Kamal")) {
-					cellBusinessManager.setCellValue("Mohinder");
-				} else {
-					cellBusinessManager.setCellValue(salesHeadNameAndFofoIdMap.get(fofoId));
-				}
-			} else {
-				cellBusinessManager.setCellValue("-");
-			}
-			Cell cellAssistantManager = row.createCell(cellnum++);
-			if (salesHeadNameAndFofoIdMap.get(fofoId) != null) {
-				if (salesHeadNameAndFofoIdMap.get(fofoId).equals("Kamal")) {
-					cellAssistantManager.setCellValue(salesHeadNameAndFofoIdMap.get(fofoId));
-				} else {
-					cellAssistantManager.setCellValue("");
-				}
-			} else {
-				cellAssistantManager.setCellValue("");
-			}
-			Cell cellTargetName = row.createCell(cellnum++);
-			if (targetName==null||targetName=="") {
-				cellTargetName.setCellValue("");
-			} else {
-				cellTargetName.setCellValue(targetName);
-			}
-			Cell cellMTDTargetValue = row.createCell(cellnum++);
-			if (targetValues.get(fofoId) != null) {
-				cellMTDTargetValue.setCellValue(targetValues.get(fofoId));
-			} else {
-				cellMTDTargetValue.setCellValue("-");
-			}
-			Cell cellMTDAchievement = row.createCell(cellnum++);
-			if (saleValues.get(fofoId) != null) {
-				cellMTDAchievement.setCellValue(saleValues.get(fofoId));
-			} else {
-				cellMTDAchievement.setCellValue(0);
-			}
-			Cell cellMTDAchievementPercentage = row.createCell(cellnum++);
-			if (monthlyTargetAchievementPercentage.get(fofoId) != null) {
-				cellMTDAchievementPercentage.setCellValue(monthlyTargetAchievementPercentage.get(fofoId) + "%");
-			} else {
-				cellMTDAchievementPercentage.setCellValue(0 + "%");
-			}
-			Cell cellDailyTargetValue = row.createCell(cellnum++);
-			if (dailyAverageSale.get(fofoId) != null) {
-				String formatting = FormattingUtils.formatDecimalTwoDigits(dailyAverageSale.get(fofoId));
-				cellDailyTargetValue.setCellValue(formatting);
-			} else {
-				cellDailyTargetValue.setCellValue(0);
-			}
-			Cell cellTodayAchieveMentSaleValue = row.createCell(cellnum++);
-			if (todayAchievements.get(fofoId) != null) {
-				cellTodayAchieveMentSaleValue.setCellValue(todayAchievements.get(fofoId));
-			} else {
-				cellTodayAchieveMentSaleValue.setCellValue(0);
-			}
-			Cell cellRemaining = row.createCell(cellnum++);
-			if (remainingMonthlyTargets.get(fofoId) != null) {
-				cellRemaining.setCellValue(remainingMonthlyTargets.get(fofoId));
-			} else {
-				cellRemaining.setCellValue(0);
-			}
-			Cell cellEligible = row.createCell(cellnum++);
-			if (fofoIdsAndSlabNames.get(fofoId) != null) {
-				cellEligible.setCellValue(fofoIdsAndSlabNames.get(fofoId));
-			} else {
-				cellEligible.setCellValue("-");
-			}
-		}
-		for (int index = 0; index < saleValues.size(); index++) {
-			sheet.autoSizeColumn(index);
-		}
-		try {
-			workbook.write(outputStream);
-			workbook.close();
-		} catch (IOException ioException) {
-			LOGGER.error("Unable to generate excel file", ioException);
-		}
-	}
-	public static void writeDailySaleReportVsTargetForPartner(Map<Integer,String> targetIdAndTargetNameMap,Map<Integer, Float> targetIdAndtargetValuesMap, Map<Integer, Double> targetIdAndsaleValuesMap,
 			Map<Integer, CustomRetailer> targetIdAndCustomRetailerMap, Map<Integer, String> targetIdAndSlabNamesMap,
+			Map<Integer, Double> targetIdAndsaleValuesPercentageMap,
-			Map<Integer, Double> targetIdAndsaleValuesPercentageMap, Map<Integer, Float> targetIdAndtargetdailyAverageSaleMap,
+			Map<Integer, Float> targetIdAndtargetdailyAverageSaleMap,
 			Map<Integer, Double> targetIdAndRemainingTargetMap, Map<Integer, Double> targetIdAndtodayAchievementsMap,
-			 Map<Integer, String> targetIdAndSalesHeadMap , OutputStream outputStream) {
+			Map<Integer, String> targetIdAndSalesHeadMap, OutputStream outputStream) {
 		SXSSFWorkbook workbook = new SXSSFWorkbook();
 		// CreationHelper createHelper = workbook.getCreationHelper();
 		SXSSFSheet sheet = workbook.createSheet("DailySaleReports");
 			if (targetIdAndCustomRetailerMap.get(targetId) != null) {
 				cellPartner.setCellValue(targetIdAndCustomRetailerMap.get(targetId).getBusinessName());
 			} else {
 				cellPartner.setCellValue("-");
+			}
 			Cell cellBusinessManager = row.createCell(cellnum++);
 			if (targetIdAndSalesHeadMap.get(targetId) != null) {
 				if (targetIdAndSalesHeadMap.get(targetId).equals("Kamal")) {
 					cellBusinessManager.setCellValue("Mohinder");
 				} else {
+				}
 			} else {
 				cellAssistantManager.setCellValue("");
+			}
 			Cell cellTargetName = row.createCell(cellnum++);
-			if (targetIdAndTargetNameMap.get(targetId)==null||targetIdAndTargetNameMap.get(targetId)=="") {
+			if (targetIdAndTargetNameMap.get(targetId) == null || targetIdAndTargetNameMap.get(targetId) == "") {
 				cellTargetName.setCellValue("");
 			} else {
 				cellTargetName.setCellValue(targetIdAndTargetNameMap.get(targetId));
+			}
 			Cell cellMTDTargetValue = row.createCell(cellnum++);
 			if (targetIdAndtargetValuesMap.get(targetId) != null) {
 				cellMTDAchievementPercentage.setCellValue(0 + "%");
+			}
 			Cell cellDailyTargetValue1 = row.createCell(cellnum++);
 			if (targetIdAndtargetdailyAverageSaleMap.get(targetId) != null) {
+				String formatting = FormattingUtils
-				String formatting = FormattingUtils.formatDecimalTwoDigits(targetIdAndtargetdailyAverageSaleMap.get(targetId));
+						.formatDecimalTwoDigits(targetIdAndtargetdailyAverageSaleMap.get(targetId));
 				cellDailyTargetValue1.setCellValue(formatting);
 			} else {
 				cellDailyTargetValue1.setCellValue(0);
+			}
 			Cell cellTodayAchieveMentSaleValue = row.createCell(cellnum++);
 			if (targetIdAndtodayAchievementsMap.get(targetId) != null) {
 				cellTodayAchieveMentSaleValue.setCellValue(targetIdAndtodayAchievementsMap.get(targetId));
 			} else {
 				cellTodayAchieveMentSaleValue.setCellValue(0);
+			}
 			Cell cellRemaining = row.createCell(cellnum++);
 			if (targetIdAndRemainingTargetMap.get(targetId) != null) {
 				cellRemaining.setCellValue(targetIdAndRemainingTargetMap.get(targetId));
 			} else {
 				cellRemaining.setCellValue(0);

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-common/src/main/java/com/spice/profitmandi/common/util/ExcelUtils.java – Rev 24222 → 25380