Subversion Repositories SmartDukaan

Rev

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

Rev 24186 Rev 24188
Line 759... Line 759...
759 
 
 759 
 
760 
		SXSSFSheet sheet = workbook.createSheet("DailySaleReports");
 760 
		SXSSFSheet sheet = workbook.createSheet("DailySaleReports");
761 
		sheet.trackAllColumnsForAutoSizing();
 761 
		sheet.trackAllColumnsForAutoSizing();
762 
 
 762 
 
763 
		Row rowHeader = sheet.createRow(0);
 763 
		Row rowHeader = sheet.createRow(0);
764 
		Cell cellTarget = rowHeader.createCell(0);
 764 
		Cell cellStoreName = rowHeader.createCell(0);
765 
		cellTarget.setCellValue("Target Name");
 765 
		cellStoreName.setCellValue("Store Name");
766 
		Cell cellBusiness = rowHeader.createCell(1);
 766 
		Cell cellBusiness = rowHeader.createCell(1);
767 
		cellBusiness.setCellValue("Business Manager");
 767 
		cellBusiness.setCellValue("Business Manager");
768 
		Cell cellAssistant = rowHeader.createCell(2);
 768 
		Cell cellAssistant = rowHeader.createCell(2);
769 
		cellAssistant.setCellValue("Assistant Manager");
 769 
		cellAssistant.setCellValue("Assistant Manager");
770 
		Cell cellFOfoId = rowHeader.createCell(3);
 770 
		Cell cellSchemeName = rowHeader.createCell(3);
771 
		cellFOfoId.setCellValue("FoFoId");
 771 
		cellSchemeName.setCellValue("Scheme Name");
772 
		Cell cellStoreName = rowHeader.createCell(4);
 772 
		Cell cellTargetValue = rowHeader.createCell(4);
773 
		cellStoreName.setCellValue("Store Name");
 773 
		cellTargetValue.setCellValue("Scheme Target");
774 
		Cell cellTargetValue = rowHeader.createCell(5);
 774 
		Cell cellTotalAchievement = rowHeader.createCell(5);
775 
		cellTargetValue.setCellValue("Target Value");
 775 
		cellTotalAchievement.setCellValue("Total Achievement");
- 
 
 776 
		Cell cellTotalAchievementPercentage = rowHeader.createCell(6);
- 
 
 777 
		cellTotalAchievementPercentage.setCellValue("Total Achievement Percentage");
776 
		Cell cellDailyTarget = rowHeader.createCell(6);
 778 
		Cell cellDailyTarget = rowHeader.createCell(7);
777 
		cellDailyTarget.setCellValue("Daily Target");
 779 
		cellDailyTarget.setCellValue("Daily Target");
778 
		Cell cellTodayAchievement = rowHeader.createCell(7);
 780 
		Cell cellTodayAchievement = rowHeader.createCell(8);
779 
		cellTodayAchievement.setCellValue("Today's Sale");
 781 
		cellTodayAchievement.setCellValue("Today Achievement");
780 
		Cell cellMonthlySaleValue = rowHeader.createCell(8);
 - 
 
781 
		cellMonthlySaleValue.setCellValue("Total Sale");
 - 
 
782 
		Cell cellMonthlySaleValuePercentage = rowHeader.createCell(9);
 - 
 
783 
		cellMonthlySaleValuePercentage.setCellValue("Total Sale%");
 - 
 
784 
		Cell cellRemainingTarget = rowHeader.createCell(10);
 782 
		Cell cellRemainingTarget = rowHeader.createCell(9);
785 
		cellRemainingTarget.setCellValue("Remaining");
 783 
		cellRemainingTarget.setCellValue("Remaining Target");
786 
		Cell cellEligibility = rowHeader.createCell(11);
 784 
		Cell cellEligibility = rowHeader.createCell(10);
787 
		cellEligibility.setCellValue("Eligibility");
 785 
		cellEligibility.setCellValue("Eligibility");
788 
		Font font = workbook.createFont();
 786 
		Font font = workbook.createFont();
789 
		CellStyle cellStyle = workbook.createCellStyle();
 787 
		CellStyle cellStyle = workbook.createCellStyle();
790 
		font.setBold(true);
 788 
		font.setBold(true);
791 
		cellStyle.setAlignment(HorizontalAlignment.CENTER);
 789 
		cellStyle.setAlignment(HorizontalAlignment.CENTER);
Line 798... Line 796...
798 
		}
 796 
		}
799 
		int rownum = 1;
 797 
		int rownum = 1;
800 
		for (Integer fofoId : fofoIds) {
 798 
		for (Integer fofoId : fofoIds) {
801 
			Row row = sheet.createRow(rownum++);
 799 
			Row row = sheet.createRow(rownum++);
802 
			int cellnum = 0;
 800 
			int cellnum = 0;
803 
			Cell cellTargetName = row.createCell(cellnum++);
 801 
			Cell cellPartner = row.createCell(cellnum++);
804 
			if (targetName==null||targetName=="") {
 802 
			if (fofoIdsAndCustomRetailer.get(fofoId) != null) {
805 
				cellTargetName.setCellValue("");
 803 
				cellPartner.setCellValue(fofoIdsAndCustomRetailer.get(fofoId).getBusinessName());
806
- 
 
807 
			} else {
 804 
			} else {
808 
				cellTargetName.setCellValue(targetName);
 805 
				cellPartner.setCellValue("-");
809 
			}
 806 
			}
810 
			Cell cellBusinessManager = row.createCell(cellnum++);
 807 
			Cell cellBusinessManager = row.createCell(cellnum++);
811 
			if (salesHeadNameAndFofoIdMap.get(fofoId) != null) {
 808 
			if (salesHeadNameAndFofoIdMap.get(fofoId) != null) {
812 
				if (salesHeadNameAndFofoIdMap.get(fofoId).equals("Kamal")) {
 809 
				if (salesHeadNameAndFofoIdMap.get(fofoId).equals("Kamal")) {
813 
					cellBusinessManager.setCellValue("Mohinder");
 810 
					cellBusinessManager.setCellValue("Mohinder");
Line 825... Line 822...
825 
					cellAssistantManager.setCellValue("");
 822 
					cellAssistantManager.setCellValue("");
826 
				}
 823 
				}
827 
			} else {
 824 
			} else {
828 
				cellAssistantManager.setCellValue("");
 825 
				cellAssistantManager.setCellValue("");
829 
			}
 826 
			}
830 
			Cell cellFofoId = row.createCell(cellnum++);
 827 
			Cell cellTargetName = row.createCell(cellnum++);
831 
			cellFofoId.setCellValue(fofoId);
 828 
			if (targetName==null||targetName=="") {
832 
			Cell cellPartner = row.createCell(cellnum++);
 829 
				cellTargetName.setCellValue("");
833 
			if (fofoIdsAndCustomRetailer.get(fofoId) != null) {
 - 
 
834 
				cellPartner.setCellValue(fofoIdsAndCustomRetailer.get(fofoId).getBusinessName());
 - 
 
- 
 
 830
835 
			} else {
 831 
			} else {
836 
				cellPartner.setCellValue("-");
 832 
				cellTargetName.setCellValue(targetName);
837 
			}
 833 
			}
838 
 
 834 
 
839 
			Cell cellMTDTargetValue = row.createCell(cellnum++);
 835 
			Cell cellMTDTargetValue = row.createCell(cellnum++);
840 
			if (targetValues.get(fofoId) != null) {
 836 
			if (targetValues.get(fofoId) != null) {
841 
				cellMTDTargetValue.setCellValue(targetValues.get(fofoId));
 837 
				cellMTDTargetValue.setCellValue(targetValues.get(fofoId));
842 
			} else {
 838 
			} else {
843 
				cellMTDTargetValue.setCellValue("-");
 839 
				cellMTDTargetValue.setCellValue("-");
844 
			}
 840 
			}
- 
 
 841 
			Cell cellMTDAchievement = row.createCell(cellnum++);
- 
 
 842 
			if (saleValues.get(fofoId) != null) {
- 
 
 843 
				cellMTDAchievement.setCellValue(saleValues.get(fofoId));
- 
 
 844 
			} else {
- 
 
 845 
				cellMTDAchievement.setCellValue(0);
- 
 
 846 
			}
- 
 
 847 
			Cell cellMTDAchievementPercentage = row.createCell(cellnum++);
- 
 
 848 
			if (monthlyTargetAchievementPercentage.get(fofoId) != null) {
- 
 
 849 
				cellMTDAchievementPercentage.setCellValue(monthlyTargetAchievementPercentage.get(fofoId) + "%");
- 
 
 850 
			} else {
- 
 
 851 
				cellMTDAchievementPercentage.setCellValue(0 + "%");
- 
 
 852 
			}
845 
 
 853 
 
846 
			Cell cellDailyTargetValue = row.createCell(cellnum++);
 854 
			Cell cellDailyTargetValue = row.createCell(cellnum++);
847 
			if (dailyAverageSale.get(fofoId) != null) {
 855 
			if (dailyAverageSale.get(fofoId) != null) {
848 
				String formatting = FormattingUtils.formatDecimalTwoDigits(dailyAverageSale.get(fofoId));
 856 
				String formatting = FormattingUtils.formatDecimalTwoDigits(dailyAverageSale.get(fofoId));
849 
				cellDailyTargetValue.setCellValue(formatting);
 857 
				cellDailyTargetValue.setCellValue(formatting);
Line 854... Line 862...
854 
			if (todayAchievements.get(fofoId) != null) {
 862 
			if (todayAchievements.get(fofoId) != null) {
855 
				cellTodayAchieveMentSaleValue.setCellValue(todayAchievements.get(fofoId));
 863 
				cellTodayAchieveMentSaleValue.setCellValue(todayAchievements.get(fofoId));
856 
			} else {
 864 
			} else {
857 
				cellTodayAchieveMentSaleValue.setCellValue(0);
 865 
				cellTodayAchieveMentSaleValue.setCellValue(0);
858 
			}
 866 
			}
859 
			Cell cellMTDAchievement = row.createCell(cellnum++);
 - 
 
860 
			if (saleValues.get(fofoId) != null) {
 - 
 
861 
				cellMTDAchievement.setCellValue(saleValues.get(fofoId));
 - 
 
862 
			} else {
 - 
 
863 
				cellMTDAchievement.setCellValue(0);
 - 
 
864 
			}
 867
865 
			Cell cellMTDAchievementPercentage = row.createCell(cellnum++);
 - 
 
866 
			if (monthlyTargetAchievementPercentage.get(fofoId) != null) {
 - 
 
867 
				cellMTDAchievementPercentage.setCellValue(monthlyTargetAchievementPercentage.get(fofoId) + "%");
 - 
 
868 
			} else {
 - 
 
869 
				cellMTDAchievementPercentage.setCellValue(0 + "%");
 - 
 
870 
			}
 - 
 
871 
 
 - 
 
872 
			Cell cellRemaining = row.createCell(cellnum++);
 868 
			Cell cellRemaining = row.createCell(cellnum++);
873 
			if (remainingMonthlyTargets.get(fofoId) != null) {
 869 
			if (remainingMonthlyTargets.get(fofoId) != null) {
874 
				cellRemaining.setCellValue(remainingMonthlyTargets.get(fofoId));
 870 
				cellRemaining.setCellValue(remainingMonthlyTargets.get(fofoId));
875 
			} else {
 871 
			} else {
876 
				cellRemaining.setCellValue(0);
 872 
				cellRemaining.setCellValue(0);
Line 906... Line 902...
906 
 
 902 
 
907 
		SXSSFSheet sheet = workbook.createSheet("DailySaleReports");
 903 
		SXSSFSheet sheet = workbook.createSheet("DailySaleReports");
908 
		sheet.trackAllColumnsForAutoSizing();
 904 
		sheet.trackAllColumnsForAutoSizing();
909 
 
 905 
 
910 
		Row rowHeader = sheet.createRow(0);
 906 
		Row rowHeader = sheet.createRow(0);
911 
		Cell cellTarget = rowHeader.createCell(0);
 907 
		Cell cellStoreName = rowHeader.createCell(0);
912 
		cellTarget.setCellValue("Target Name");
 908 
		cellStoreName.setCellValue("Store Name");
913 
		Cell cellBusiness = rowHeader.createCell(1);
 909 
		Cell cellBusiness = rowHeader.createCell(1);
914 
		cellBusiness.setCellValue("Business Manager");
 910 
		cellBusiness.setCellValue("Business Manager");
915 
		Cell cellAssistant = rowHeader.createCell(2);
 911 
		Cell cellAssistant = rowHeader.createCell(2);
916 
		cellAssistant.setCellValue("Assistant Manager");
 912 
		cellAssistant.setCellValue("Assistant Manager");
917 
		Cell cellStoreName = rowHeader.createCell(3);
 913 
		Cell cellSchemeName = rowHeader.createCell(3);
918 
		cellStoreName.setCellValue("Store Name");
 914 
		cellSchemeName.setCellValue("Scheme Name");
919 
		Cell cellTargetValue = rowHeader.createCell(4);
 915 
		Cell cellTargetValue = rowHeader.createCell(4);
920 
		cellTargetValue.setCellValue("Target Value");
 916 
		cellTargetValue.setCellValue("Scheme Target");
921 
		Cell cellDailyTarget = rowHeader.createCell(5);
 917 
		Cell cellMonthlySaleValue = rowHeader.createCell(5);
922 
		cellDailyTarget.setCellValue("Daily Target");
 918 
		cellMonthlySaleValue.setCellValue("Total Achievement");
923 
		Cell cellTodayAchievement = rowHeader.createCell(6);
 919 
		Cell cellMonthlySaleValuePercentage = rowHeader.createCell(6);
924 
		cellTodayAchievement.setCellValue("Today's Sale");
 920 
		cellMonthlySaleValuePercentage.setCellValue("Today Achievement Percentage");
925 
		Cell cellMonthlySaleValue = rowHeader.createCell(7);
 921 
		Cell cellDailyTargetValue = rowHeader.createCell(7);
926 
		cellMonthlySaleValue.setCellValue("Total Sale");
 922 
		cellDailyTargetValue.setCellValue("Daily Target");
927 
		Cell cellMonthlySaleValuePercentage = rowHeader.createCell(8);
 923 
		Cell cellTodayAchievement = rowHeader.createCell(8);
928 
		cellMonthlySaleValuePercentage.setCellValue("Total Sale%");
 924 
		cellTodayAchievement.setCellValue("Today Achievement");
929 
		Cell cellRemainingTarget = rowHeader.createCell(9);
 925 
		Cell cellRemainingTarget = rowHeader.createCell(9);
930 
		cellRemainingTarget.setCellValue("Remaining");
 926 
		cellRemainingTarget.setCellValue("Remaining Target");
931 
		Cell cellEligibility = rowHeader.createCell(10);
 927 
		Cell cellEligibility = rowHeader.createCell(10);
932 
		cellEligibility.setCellValue("Eligibility");
 928 
		cellEligibility.setCellValue("Eligibility");
933 
		Font font = workbook.createFont();
 929 
		Font font = workbook.createFont();
934 
		CellStyle cellStyle = workbook.createCellStyle();
 930 
		CellStyle cellStyle = workbook.createCellStyle();
935 
		font.setBold(true);
 931 
		font.setBold(true);
Line 943... Line 939...
943 
		}
 939 
		}
944 
		int rownum = 1;
 940 
		int rownum = 1;
945 
		for (Integer targetId : targetIdAndTargetNameMap.keySet()) {
 941 
		for (Integer targetId : targetIdAndTargetNameMap.keySet()) {
946 
			Row row = sheet.createRow(rownum++);
 942 
			Row row = sheet.createRow(rownum++);
947 
			int cellnum = 0;
 943 
			int cellnum = 0;
948 
			Cell cellTargetName = row.createCell(cellnum++);
 944 
			Cell cellPartner = row.createCell(cellnum++);
949 
			if (targetIdAndTargetNameMap.get(targetId)==null||targetIdAndTargetNameMap.get(targetId)=="") {
 945 
			if (targetIdAndCustomRetailerMap.get(targetId) != null) {
950 
				cellTargetName.setCellValue("");
 946 
				cellPartner.setCellValue(targetIdAndCustomRetailerMap.get(targetId).getBusinessName());
951
- 
 
952 
			} else {
 947 
			} else {
953 
				cellTargetName.setCellValue(targetIdAndTargetNameMap.get(targetId));
 948 
				cellPartner.setCellValue("-");
954 
			}
 949 
			}
- 
 
 950
955 
			Cell cellBusinessManager = row.createCell(cellnum++);
 951 
			Cell cellBusinessManager = row.createCell(cellnum++);
956 
			if (targetIdAndSalesHeadMap.get(targetId) != null) {
 952 
			if (targetIdAndSalesHeadMap.get(targetId) != null) {
957 
				if (targetIdAndSalesHeadMap.get(targetId).equals("Kamal")) {
 953 
				if (targetIdAndSalesHeadMap.get(targetId).equals("Kamal")) {
958 
					cellBusinessManager.setCellValue("Mohinder");
 954 
					cellBusinessManager.setCellValue("Mohinder");
959 
				} else {
 955 
				} else {
Line 970... Line 966...
970 
					cellAssistantManager.setCellValue("");
 966 
					cellAssistantManager.setCellValue("");
971 
				}
 967 
				}
972 
			} else {
 968 
			} else {
973 
				cellAssistantManager.setCellValue("");
 969 
				cellAssistantManager.setCellValue("");
974 
			}
 970 
			}
975 
			Cell cellPartner = row.createCell(cellnum++);
 971 
			Cell cellTargetName = row.createCell(cellnum++);
976 
			if (targetIdAndCustomRetailerMap.get(targetId) != null) {
 972 
			if (targetIdAndTargetNameMap.get(targetId)==null||targetIdAndTargetNameMap.get(targetId)=="") {
977 
				cellPartner.setCellValue(targetIdAndCustomRetailerMap.get(targetId).getBusinessName());
 973 
				cellTargetName.setCellValue("");
- 
 
 974
978 
			} else {
 975 
			} else {
979 
				cellPartner.setCellValue("-");
 976 
				cellTargetName.setCellValue(targetIdAndTargetNameMap.get(targetId));
980 
			}
 977 
			}
981 
			Cell cellMTDTargetValue = row.createCell(cellnum++);
 978 
			Cell cellMTDTargetValue = row.createCell(cellnum++);
982 
			if (targetIdAndtargetValuesMap.get(targetId) != null) {
 979 
			if (targetIdAndtargetValuesMap.get(targetId) != null) {
983 
				cellMTDTargetValue.setCellValue(targetIdAndtargetValuesMap.get(targetId));
 980 
				cellMTDTargetValue.setCellValue(targetIdAndtargetValuesMap.get(targetId));
984 
			} else {
 981 
			} else {
985 
				cellMTDTargetValue.setCellValue("-");
 982 
				cellMTDTargetValue.setCellValue("-");
986 
			}
 983 
			}
987 
 
 - 
 
988 
			Cell cellDailyTargetValue = row.createCell(cellnum++);
 - 
 
989 
			if (targetIdAndtargetdailyAverageSaleMap.get(targetId) != null) {
 - 
 
990 
				String formatting = FormattingUtils.formatDecimalTwoDigits(targetIdAndtargetdailyAverageSaleMap.get(targetId));
 - 
 
991 
				cellDailyTargetValue.setCellValue(formatting);
 - 
 
992 
			} else {
 - 
 
993 
				cellDailyTargetValue.setCellValue(0);
 - 
 
994 
			}
 - 
 
995 
			Cell cellTodayAchieveMentSaleValue = row.createCell(cellnum++);
 - 
 
996 
			if (targetIdAndtodayAchievementsMap.get(targetId) != null) {
 - 
 
997 
				cellTodayAchieveMentSaleValue.setCellValue(targetIdAndtodayAchievementsMap.get(targetId));
 - 
 
998 
			} else {
 - 
 
999 
				cellTodayAchieveMentSaleValue.setCellValue(0);
 - 
 
1000 
			}
 - 
 
1001 
			Cell cellMTDAchievement = row.createCell(cellnum++);
 984 
			Cell cellMTDAchievement = row.createCell(cellnum++);
1002 
			if (targetIdAndsaleValuesMap.get(targetId) != null) {
 985 
			if (targetIdAndsaleValuesMap.get(targetId) != null) {
1003 
				cellMTDAchievement.setCellValue(targetIdAndsaleValuesMap.get(targetId));
 986 
				cellMTDAchievement.setCellValue(targetIdAndsaleValuesMap.get(targetId));
1004 
			} else {
 987 
			} else {
1005 
				cellMTDAchievement.setCellValue(0);
 988 
				cellMTDAchievement.setCellValue(0);
Line 1009... Line 992...
1009 
				cellMTDAchievementPercentage.setCellValue(targetIdAndsaleValuesPercentageMap.get(targetId) + "%");
 992 
				cellMTDAchievementPercentage.setCellValue(targetIdAndsaleValuesPercentageMap.get(targetId) + "%");
1010 
			} else {
 993 
			} else {
1011 
				cellMTDAchievementPercentage.setCellValue(0 + "%");
 994 
				cellMTDAchievementPercentage.setCellValue(0 + "%");
1012 
			}
 995 
			}
1013 
 
 996 
 
- 
 
 997 
			Cell cellDailyTargetValue1 = row.createCell(cellnum++);
- 
 
 998 
			if (targetIdAndtargetdailyAverageSaleMap.get(targetId) != null) {
- 
 
 999 
				String formatting = FormattingUtils.formatDecimalTwoDigits(targetIdAndtargetdailyAverageSaleMap.get(targetId));
- 
 
 1000 
				cellDailyTargetValue1.setCellValue(formatting);
- 
 
 1001 
			} else {
- 
 
 1002 
				cellDailyTargetValue1.setCellValue(0);
- 
 
 1003 
			}
- 
 
 1004 
			Cell cellTodayAchieveMentSaleValue = row.createCell(cellnum++);
- 
 
 1005 
			if (targetIdAndtodayAchievementsMap.get(targetId) != null) {
- 
 
 1006 
				cellTodayAchieveMentSaleValue.setCellValue(targetIdAndtodayAchievementsMap.get(targetId));
- 
 
 1007 
			} else {
- 
 
 1008 
				cellTodayAchieveMentSaleValue.setCellValue(0);
- 
 
 1009 
			}
- 
 
 1010
1014 
			Cell cellRemaining = row.createCell(cellnum++);
 1011 
			Cell cellRemaining = row.createCell(cellnum++);
1015 
			if (targetIdAndRemainingTargetMap.get(targetId) != null) {
 1012 
			if (targetIdAndRemainingTargetMap.get(targetId) != null) {
1016 
				cellRemaining.setCellValue(targetIdAndRemainingTargetMap.get(targetId));
 1013 
				cellRemaining.setCellValue(targetIdAndRemainingTargetMap.get(targetId));
1017 
			} else {
 1014 
			} else {
1018 
				cellRemaining.setCellValue(0);
 1015 
				cellRemaining.setCellValue(0);