Subversion Repositories SmartDukaan

Rev

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

Rev 27548 Rev 27549
Line 72... Line 72...
72
		Map<Integer, Double> lmtdSale = fofoOrderItemRepository.selectSumMopGroupByRetailer(
72
		Map<Integer, Double> lmtdSale = fofoOrderItemRepository.selectSumMopGroupByRetailer(
73
				curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1), 0, false);
73
				curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1), 0, false);
74
		Map<Integer, Double> mtdSale = fofoOrderItemRepository.selectSumMopGroupByRetailer(curDate.withDayOfMonth(1),
74
		Map<Integer, Double> mtdSale = fofoOrderItemRepository.selectSumMopGroupByRetailer(curDate.withDayOfMonth(1),
75
				curDate.with(LocalTime.MAX), 0, false);
75
				curDate.with(LocalTime.MAX), 0, false);
76
 
76
 
77
		Map<Integer, Long> last1daystertiary = fofoOrderItemRepository.selectQtyGroupByRetailer(curDate,
77
		Map<Integer, Double> todaytertiary = fofoOrderItemRepository.selectSumMopGroupByRetailer(curDate,
78
				curDate.with(LocalTime.MAX), 0, false);
78
				curDate.with(LocalTime.MAX), 0, false);
79
 
79
 
80
		Map<Integer, Long> last3daystertiary = fofoOrderItemRepository.selectQtyGroupByRetailer(curDate.minusDays(4),
80
		Map<Integer, Long> last3daystertiary = fofoOrderItemRepository.selectQtyGroupByRetailer(curDate.minusDays(4),
81
				curDate.minusDays(1).with(LocalTime.MAX), 0, false);
81
				curDate.minusDays(1).with(LocalTime.MAX), 0, false);
82
 
82
 
Line 110... Line 110...
110
			Map<EscalationType, AuthUser> authuserEsclationTypeMap = csService
110
			Map<EscalationType, AuthUser> authuserEsclationTypeMap = csService
111
					.getAuthUserAndEsclationByPartnerId(fofoId);
111
					.getAuthUserAndEsclationByPartnerId(fofoId);
112
			PartnerDetailModel pm = new PartnerDetailModel();
112
			PartnerDetailModel pm = new PartnerDetailModel();
113
			pm.setLmtd(lmtdSale.get(fofoId) == null ? 0 : lmtdSale.get(fofoId));
113
			pm.setLmtd(lmtdSale.get(fofoId) == null ? 0 : lmtdSale.get(fofoId));
114
			pm.setMtd(mtdSale.get(fofoId) == null ? 0 : mtdSale.get(fofoId));
114
			pm.setMtd(mtdSale.get(fofoId) == null ? 0 : mtdSale.get(fofoId));
115
			pm.setLastOneDayTertiary(last1daystertiary.get(fofoId) == null ? 0 : last1daystertiary.get(fofoId));
115
			pm.setTodayTertiary(todaytertiary.get(fofoId) == null ? 0 : todaytertiary.get(fofoId));
116
			pm.setLastThreeDaytertiary(last3daystertiary.get(fofoId) == null ? 0 : last3daystertiary.get(fofoId));
116
			pm.setLastThreeDaytertiary(last3daystertiary.get(fofoId) == null ? 0 : last3daystertiary.get(fofoId));
117
			pm.setWalletAmount(userWallet.get(fofoId).getAmount() == 0 ? 0 : userWallet.get(fofoId).getAmount());
117
			pm.setWalletAmount(userWallet.get(fofoId).getAmount() == 0 ? 0 : userWallet.get(fofoId).getAmount());
118
			pm.setInvestment(investmentMap.get(fofoId));
118
			pm.setInvestment(investmentMap.get(fofoId));
119
			pm.setTicket(ticketMap.get(fofoId) == null ? 0 : ticketMap.get(fofoId).intValue());
119
			pm.setTicket(ticketMap.get(fofoId) == null ? 0 : ticketMap.get(fofoId).intValue());
120
			pm.setHygiene(hygieneCount);
120
			pm.setHygiene(hygieneCount);
121
			pm.setPartnerType(partnerType);
121
			pm.setPartnerType(partnerType);
-
 
122
			if (authuserEsclationTypeMap.get(EscalationType.L1) == null) {
122
 
123
 
-
 
124
				if (authuserEsclationTypeMap.get(EscalationType.L2) == null) {
-
 
125
					pm.setAuthUser(authuserEsclationTypeMap.get(EscalationType.L3).getName());
-
 
126
				} else {
123
			pm.setAuthUser(authuserEsclationTypeMap.get(EscalationType.L1) == null ? "Not Available"
127
					pm.setAuthUser(authuserEsclationTypeMap.get(EscalationType.L2).getName());
-
 
128
				}
-
 
129
 
-
 
130
			} else {
124
					: authuserEsclationTypeMap.get(EscalationType.L1).getName());
131
				pm.setAuthUser(authuserEsclationTypeMap.get(EscalationType.L1).getName());
-
 
132
			}
125
			pm.setTotalHygiene(totalHygieneCount);
133
			pm.setTotalHygiene(totalHygieneCount);
126
 
134
 
127
			pm.setTicket(ticketMap.get(fofoId) == null ? 0 : ticketMap.get(fofoId).intValue());
135
			pm.setTicket(ticketMap.get(fofoId) == null ? 0 : ticketMap.get(fofoId).intValue());
128
			allPartnerStats.put(fofoId, pm);
136
			allPartnerStats.put(fofoId, pm);
129
			LOGGER.info("pm {}", pm);
137
			LOGGER.info("pm {}", pm);
Line 140... Line 148...
140
		PartnerDetailModel pdm = new PartnerDetailModel();
148
		PartnerDetailModel pdm = new PartnerDetailModel();
141
		PartnerDailyInvestment aggregateInvestment = new PartnerDailyInvestment();
149
		PartnerDailyInvestment aggregateInvestment = new PartnerDailyInvestment();
142
		pdm.setInvestment(aggregateInvestment);
150
		pdm.setInvestment(aggregateInvestment);
143
		double totallmtdAmount = 0;
151
		double totallmtdAmount = 0;
144
		double totalmtdAmount = 0;
152
		double totalmtdAmount = 0;
-
 
153
		double todayTertiary = 0;
145
		int totalTicketCount = 0;
154
		int totalTicketCount = 0;
146
 
155
 
147
		int currentHygieneCount = 0;
156
		int currentHygieneCount = 0;
148
		int currentTotalHygieneCount = 0;
157
		int currentTotalHygieneCount = 0;
149
		for (PartnerDetailModel partnerDetailModel : partnerDetailModels) {
158
		for (PartnerDetailModel partnerDetailModel : partnerDetailModels) {
150
			PartnerDailyInvestment pdi = partnerDetailModel.getInvestment();
159
			PartnerDailyInvestment pdi = partnerDetailModel.getInvestment();
151
			totallmtdAmount += partnerDetailModel.getLmtd();
160
			totallmtdAmount += partnerDetailModel.getLmtd();
152
			totalmtdAmount += partnerDetailModel.getMtd();
161
			totalmtdAmount += partnerDetailModel.getMtd();
153
			totalTicketCount += partnerDetailModel.getTicket();
162
			totalTicketCount += partnerDetailModel.getTicket();
-
 
163
			todayTertiary += partnerDetailModel.getTodayTertiary();
154
			currentHygieneCount += partnerDetailModel.getHygiene();
164
			currentHygieneCount += partnerDetailModel.getHygiene();
155
			currentTotalHygieneCount += partnerDetailModel.getTotalHygiene();
165
			currentTotalHygieneCount += partnerDetailModel.getTotalHygiene();
156
			aggregateInvestment.setActivatedStockAmount(
166
			aggregateInvestment.setActivatedStockAmount(
157
					aggregateInvestment.getActivatedStockAmount() + pdi.getActivatedStockAmount());
167
					aggregateInvestment.getActivatedStockAmount() + pdi.getActivatedStockAmount());
158
			aggregateInvestment
168
			aggregateInvestment
Line 162... Line 172...
162
					aggregateInvestment.getReturnInTransitAmount() + pdi.getReturnInTransitAmount());
172
					aggregateInvestment.getReturnInTransitAmount() + pdi.getReturnInTransitAmount());
163
			aggregateInvestment.setSalesAmount(aggregateInvestment.getSalesAmount() + pdi.getSalesAmount());
173
			aggregateInvestment.setSalesAmount(aggregateInvestment.getSalesAmount() + pdi.getSalesAmount());
164
			aggregateInvestment.setUnbilledAmount(aggregateInvestment.getUnbilledAmount() + pdi.getUnbilledAmount());
174
			aggregateInvestment.setUnbilledAmount(aggregateInvestment.getUnbilledAmount() + pdi.getUnbilledAmount());
165
			aggregateInvestment.setWalletAmount(aggregateInvestment.getWalletAmount() + pdi.getWalletAmount());
175
			aggregateInvestment.setWalletAmount(aggregateInvestment.getWalletAmount() + pdi.getWalletAmount());
166
		}
176
		}
-
 
177
 
-
 
178
		LOGGER.info("this.format((long) totallmtdAmount" + this.format((long) totallmtdAmount));
167
		pdm.setHygiene(currentHygieneCount);
179
		pdm.setHygiene(currentHygieneCount);
168
		pdm.setTotalHygiene(currentTotalHygieneCount);
180
		pdm.setTotalHygiene(currentTotalHygieneCount);
169
		pdm.setLmtd(totallmtdAmount);
181
		pdm.setLmtd(totallmtdAmount);
170
		pdm.setMtd(totalmtdAmount);
182
		pdm.setMtd(totalmtdAmount);
171
		pdm.setTicket(totalTicketCount);
183
		pdm.setTicket(totalTicketCount);
-
 
184
		pdm.setTodayTertiary(todayTertiary);
172
		pdm.setCount(partnerDetailModels.size());
185
		pdm.setCount(partnerDetailModels.size());
173
		return pdm;
186
		return pdm;
174
	}
187
	}
175
 
188
 
-
 
189
	private String format(long value) {
-
 
190
		String finalval = null;
-
 
191
 
-
 
192
		if (value >= 100000 && value < 10000000) {
-
 
193
			long reminder = value / 100000;
-
 
194
			long quitonent = value % 100000;
-
 
195
			finalval = reminder + "." + quitonent;
-
 
196
			String secondval = String.valueOf(quitonent);
-
 
197
			if (secondval.length() >= 2) {
-
 
198
				secondval = secondval.substring(0, 2);
-
 
199
				finalval = reminder + "." + secondval;
-
 
200
			}
-
 
201
			return String.valueOf(finalval) + " Lacs";
-
 
202
		} else if (value >= 1000 && value < 100000) {
-
 
203
			long reminder = value / 1000;
-
 
204
			long quitonent = value % 1000;
-
 
205
			finalval = reminder + "." + quitonent;
-
 
206
			String secondval = String.valueOf(quitonent);
-
 
207
			if (secondval.length() >= 2) {
-
 
208
				secondval = secondval.substring(0, 2);
-
 
209
				finalval = reminder + "." + secondval;
-
 
210
			}
-
 
211
			return String.valueOf(finalval) + " K";
-
 
212
		} else if (value >= 10000000 && value < 1000000000) {
-
 
213
			long reminder = value / 10000000;
-
 
214
			long quitonent = value % 10000000;
-
 
215
			finalval = reminder + "." + quitonent;
-
 
216
			String secondval = String.valueOf(quitonent);
-
 
217
			if (secondval.length() >= 2) {
-
 
218
				secondval = secondval.substring(0, 2);
-
 
219
				finalval = reminder + "." + secondval;
-
 
220
			}
-
 
221
			return String.valueOf(finalval) + " Cr";
-
 
222
		}
-
 
223
		return String.valueOf(finalval);
-
 
224
 
-
 
225
	}
-
 
226
 
176
}
227
}