| Line 748... |
Line 748... |
| 748 |
|
748 |
|
| 749 |
public static void writeDailySaleReportVsTarget(Map<Integer, Float> targetValues, Map<Integer, Double> saleValues,
|
749 |
public static void writeDailySaleReportVsTarget(Map<Integer, Float> targetValues, Map<Integer, Double> saleValues,
|
| 750 |
Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer, Map<Integer, String> fofoIdsAndSlabNames,
|
750 |
Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer, Map<Integer, String> fofoIdsAndSlabNames,
|
| 751 |
Map<Integer, Double> monthlyTargetAchievementPercentage, Map<Integer, Float> dailyAverageSale,
|
751 |
Map<Integer, Double> monthlyTargetAchievementPercentage, Map<Integer, Float> dailyAverageSale,
|
| 752 |
Map<Integer, Double> remainingMonthlyTargets, Map<Integer, Double> todayAchievements,
|
752 |
Map<Integer, Double> remainingMonthlyTargets, Map<Integer, Double> todayAchievements,
|
| 753 |
Map<Integer, Float> todayAchievementsPercentage, List<Integer> fofoIds,
|
753 |
List<Integer> fofoIds,
|
| 754 |
Map<Integer, String> salesHeadNameAndFofoIdMap, OutputStream outputStream) {
|
754 |
Map<Integer, String> salesHeadNameAndFofoIdMap, OutputStream outputStream) {
|
| 755 |
SXSSFWorkbook workbook = new SXSSFWorkbook();
|
755 |
SXSSFWorkbook workbook = new SXSSFWorkbook();
|
| 756 |
|
756 |
|
| 757 |
// CreationHelper createHelper = workbook.getCreationHelper();
|
757 |
// CreationHelper createHelper = workbook.getCreationHelper();
|
| 758 |
|
758 |
|
| Line 771... |
Line 771... |
| 771 |
Cell cellTargetValue = rowHeader.createCell(4);
|
771 |
Cell cellTargetValue = rowHeader.createCell(4);
|
| 772 |
cellTargetValue.setCellValue("Target Value");
|
772 |
cellTargetValue.setCellValue("Target Value");
|
| 773 |
Cell cellDailyTarget = rowHeader.createCell(5);
|
773 |
Cell cellDailyTarget = rowHeader.createCell(5);
|
| 774 |
cellDailyTarget.setCellValue("Daily Target");
|
774 |
cellDailyTarget.setCellValue("Daily Target");
|
| 775 |
Cell cellTodayAchievement = rowHeader.createCell(6);
|
775 |
Cell cellTodayAchievement = rowHeader.createCell(6);
|
| 776 |
cellTodayAchievement.setCellValue("Today's Achievement");
|
776 |
cellTodayAchievement.setCellValue("Today's Sale");
|
| 777 |
Cell cellTodayAchievementPercentage = rowHeader.createCell(7);
|
- |
|
| 778 |
cellTodayAchievementPercentage.setCellValue("Today's Achievement %");
|
- |
|
| 779 |
Cell cellMonthlySaleValue = rowHeader.createCell(8);
|
777 |
Cell cellMonthlySaleValue = rowHeader.createCell(7);
|
| 780 |
cellMonthlySaleValue.setCellValue("MTD Achievement");
|
778 |
cellMonthlySaleValue.setCellValue("Total Sale");
|
| 781 |
Cell cellMonthlySaleValuePercentage = rowHeader.createCell(9);
|
779 |
Cell cellMonthlySaleValuePercentage = rowHeader.createCell(8);
|
| 782 |
cellMonthlySaleValuePercentage.setCellValue("Achievement%");
|
780 |
cellMonthlySaleValuePercentage.setCellValue("Total Sale%");
|
| 783 |
Cell cellRemainingTarget = rowHeader.createCell(10);
|
781 |
Cell cellRemainingTarget = rowHeader.createCell(9);
|
| 784 |
cellRemainingTarget.setCellValue("Remaining");
|
782 |
cellRemainingTarget.setCellValue("Remaining");
|
| 785 |
Cell cellEligibility = rowHeader.createCell(11);
|
783 |
Cell cellEligibility = rowHeader.createCell(10);
|
| 786 |
cellEligibility.setCellValue("Eligibility");
|
784 |
cellEligibility.setCellValue("Eligibility");
|
| 787 |
Font font = workbook.createFont();
|
785 |
Font font = workbook.createFont();
|
| 788 |
CellStyle cellStyle = workbook.createCellStyle();
|
786 |
CellStyle cellStyle = workbook.createCellStyle();
|
| 789 |
font.setBold(true);
|
787 |
font.setBold(true);
|
| 790 |
cellStyle.setAlignment(HorizontalAlignment.CENTER);
|
788 |
cellStyle.setAlignment(HorizontalAlignment.CENTER);
|
| Line 846... |
Line 844... |
| 846 |
if (todayAchievements.get(fofoId) != null) {
|
844 |
if (todayAchievements.get(fofoId) != null) {
|
| 847 |
cellTodayAchieveMentSaleValue.setCellValue(todayAchievements.get(fofoId));
|
845 |
cellTodayAchieveMentSaleValue.setCellValue(todayAchievements.get(fofoId));
|
| 848 |
} else {
|
846 |
} else {
|
| 849 |
cellTodayAchieveMentSaleValue.setCellValue(0);
|
847 |
cellTodayAchieveMentSaleValue.setCellValue(0);
|
| 850 |
}
|
848 |
}
|
| 851 |
Cell cellTodayAchieveMentSaleValuePercentage = row.createCell(cellnum++);
|
- |
|
| 852 |
if (todayAchievementsPercentage.get(fofoId) != null) {
|
- |
|
| 853 |
cellTodayAchieveMentSaleValuePercentage.setCellValue(todayAchievementsPercentage.get(fofoId) + "%");
|
- |
|
| 854 |
} else {
|
- |
|
| 855 |
cellTodayAchieveMentSaleValuePercentage.setCellValue(0 + "%");
|
- |
|
| 856 |
|
- |
|
| 857 |
}
|
- |
|
| 858 |
Cell cellMTDAchievement = row.createCell(cellnum++);
|
849 |
Cell cellMTDAchievement = row.createCell(cellnum++);
|
| 859 |
if (saleValues.get(fofoId) != null) {
|
850 |
if (saleValues.get(fofoId) != null) {
|
| 860 |
cellMTDAchievement.setCellValue(saleValues.get(fofoId));
|
851 |
cellMTDAchievement.setCellValue(saleValues.get(fofoId));
|
| 861 |
} else {
|
852 |
} else {
|
| 862 |
cellMTDAchievement.setCellValue(0);
|
853 |
cellMTDAchievement.setCellValue(0);
|