WebSVN – SmartDukaan – Diff – /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/DashboardController.java

 	@Value("${web.api.port}")
 	private int webApiPort;
 	@Autowired
 	private CookiesProcessor cookiesProcessor;
 	@Autowired
 	private PartnerStatsService partnerStatsService;
 	@Autowired
 	private MenuRepository menuRepository;
 			if (positions.size() > 0) {
 				if (positions.stream().filter(x -> x.getEscalationType().equals(EscalationType.L3)).count() > 0) {
 					authIdAndAuthUserMap = authRepository.selectAllActiveUser().stream()
 							.collect(Collectors.toMap(x -> x.getId(), x -> x));
+					AuthUser dummyAuthUser = new AuthUser();
+					dummyAuthUser.setFirstName("Total");
+					dummyAuthUser.setLastName("Values");
+					authIdAndAuthUserMap.put(0, dummyAuthUser);
 					authIdAndallValues = this.getL2AuthUserPartnerDetail();
+				}
+			}
 		LOGGER.info("menu" + menuList);
 		model.addAttribute("menu", menuList);
 		return "admin";
+	}
+	/*
-/*	@RequestMapping(value = "/getL1AuthUser", method = RequestMethod.GET)
+	 * @RequestMapping(value = "/getL1AuthUser", method = RequestMethod.GET) public
-	public String L1AuthUsersDetail(HttpServletRequest request, Model model, @RequestParam int authId)
+	 * String L1AuthUsersDetail(HttpServletRequest request, Model
-			throws Exception {
+	 * model, @RequestParam int authId) throws Exception {
+	 *
-		Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
+	 * Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
+	 *
-		LocalDateTime curDate = LocalDate.now().atStartOfDay();
+	 * LocalDateTime curDate = LocalDate.now().atStartOfDay(); Map<Integer, Double>
-		Map<Integer, Double> lmtdSale = fofoOrderItemRepository.selectSumAmountGroupByRetailer(
+	 * lmtdSale = fofoOrderItemRepository.selectSumAmountGroupByRetailer(
+	 * curDate.withDayOfMonth(1).minusMonths(1),
-				curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1), 0, false);
+	 * curDate.with(LocalTime.MAX).minusMonths(1), 0, false); Map<Integer, Double>
+	 * mtdSale =
-		Map<Integer, Double> mtdSale = fofoOrderItemRepository.selectSumAmountGroupByRetailer(curDate.withDayOfMonth(1),
+	 * fofoOrderItemRepository.selectSumAmountGroupByRetailer(curDate.withDayOfMonth
-				curDate.with(LocalTime.MAX), 0, false);
+	 * (1), curDate.with(LocalTime.MAX), 0, false); Map<Integer, List<Integer>>
-		Map<Integer, List<Integer>> L2L1Mapping = csService.getL1L2Mapping();
+	 * L2L1Mapping = csService.getL1L2Mapping();
+	 *
-		LOGGER.info("L2L1Mapping" + L2L1Mapping);
+	 * LOGGER.info("L2L1Mapping" + L2L1Mapping); List<Integer> l1authIds =
-		List<Integer> l1authIds = L2L1Mapping.get(authId);
+	 * L2L1Mapping.get(authId);
+	 *
-		Map<Integer, Object> authIdAndallValues = new LinkedHashMap<>();
+	 * Map<Integer, Object> authIdAndallValues = new LinkedHashMap<>(); Map<Integer,
-		Map<Integer, Object> authIdAndAuthUserMap = new LinkedHashMap<>();
+	 * Object> authIdAndAuthUserMap = new LinkedHashMap<>();
+	 *
+	 * Map<Integer, Long> ticketMap =
-		Map<Integer, Long> ticketMap = ticketRepository.selectAllNotClosedTicketsGroupByRetailer();
+	 * ticketRepository.selectAllNotClosedTicketsGroupByRetailer(); for (Integer
-		for (Integer l1AuthId : l1authIds) {
+	 * l1AuthId : l1authIds) {
+	 *
-			double totallmtdAmount = 0;
+	 * double totallmtdAmount = 0; double totalmtdAmount = 0; int totalTicketCount =
-			double totalmtdAmount = 0;
-			int totalTicketCount = 0;
-			float totalTodayInvestment = 0;
-			float totalStockInInvestment = 0;
+	 * 0; float totalTodayInvestment = 0; float totalStockInInvestment = 0; double
-			double currentMonthRatingAllPartners = 0;
+	 * currentMonthRatingAllPartners = 0; Map<Integer, Long> leadCount =
-			Map<Integer, Long> leadCount = leadRepository.selectByAssignAuthIdAndStatus(l1AuthId, LeadStatus.followUp)
+	 * leadRepository.selectByAssignAuthIdAndStatus(l1AuthId, LeadStatus.followUp)
-					.stream().collect(Collectors.groupingBy(Lead::getAssignTo, Collectors.counting()));
+	 * .stream().collect(Collectors.groupingBy(Lead::getAssignTo,
+	 * Collectors.counting()));
+	 *
-			AuthUser authUser = authRepository.selectById(l1AuthId);
+	 * AuthUser authUser = authRepository.selectById(l1AuthId);
+	 *
-			authIdAndAuthUserMap.put(l1AuthId, authUser);
+	 * authIdAndAuthUserMap.put(l1AuthId, authUser);
+	 *
-			List<Integer> fofoIds = pp.get(l1AuthId);
+	 * List<Integer> fofoIds = pp.get(l1AuthId);
+	 *
-			Map<Integer, PartnerDailyInvestment> partnerInvestentMap = partnerInvestmentService
+	 * Map<Integer, PartnerDailyInvestment> partnerInvestentMap =
+	 * partnerInvestmentService .getInvestment(fofoIds,
-					.getInvestment(fofoIds, 0).stream().collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
+	 * 0).stream().collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
-			for (Integer fId : fofoIds) {
-				try {
+	 *
-					PartnerDailyInvestment investment = partnerInvestentMap.get(fId);
+	 * for (Integer fId : fofoIds) { try { PartnerDailyInvestment investment =
-					totalTodayInvestment += investment.getTotalInvestment();
+	 * partnerInvestentMap.get(fId); totalTodayInvestment +=
-					totalStockInInvestment += investment.getInStockAmount();
+	 * investment.getTotalInvestment(); totalStockInInvestment +=
-				} catch (Exception e) {
+	 * investment.getInStockAmount(); } catch (Exception e) { }
-				}
+	 *
-				double currentMonthRating = hygieneDataRepository.selectRatingAvg(fId,
+	 * double currentMonthRating = hygieneDataRepository.selectRatingAvg(fId,
+	 * curDate.withDayOfMonth(1).minusMonths(1),
-						curDate.withDayOfMonth(1).minusMonths(1), curDate.plusMonths(1).withDayOfMonth(1));
+	 * curDate.plusMonths(1).withDayOfMonth(1));
+	 *
-				currentMonthRatingAllPartners += currentMonthRating;
+	 * currentMonthRatingAllPartners += currentMonthRating;
+	 *
-				fofoIds.size();
+	 * fofoIds.size();
+	 *
-				Double lmtdAmount = lmtdSale.get(fId);
+	 * Double lmtdAmount = lmtdSale.get(fId); Double mtdAmount = mtdSale.get(fId);
-				Double mtdAmount = mtdSale.get(fId);
-				Long ticketCount = ticketMap.get(fId);
+	 * Long ticketCount = ticketMap.get(fId); if (ticketCount != null) {
-				if (ticketCount != null) {
-					totalTicketCount += ticketCount;
+	 * totalTicketCount += ticketCount; }
-				}
+	 *
-				if (lmtdAmount != null) {
-					totallmtdAmount += lmtdAmount;
+	 * if (lmtdAmount != null) { totallmtdAmount += lmtdAmount; }
-				}
+	 *
-				if (mtdAmount != null) {
-					totalmtdAmount += mtdAmount;
+	 * if (mtdAmount != null) { totalmtdAmount += mtdAmount; }
-				}
-			}
+	 *
-			LOGGER.info("currentMonthRatingAllPartners" + currentMonthRatingAllPartners);
+	 * } LOGGER.info("currentMonthRatingAllPartners" +
-			LOGGER.info("size" + fofoIds.size());
+	 * currentMonthRatingAllPartners); LOGGER.info("size" + fofoIds.size()); double
-			double totalHygieneRating = currentMonthRatingAllPartners / fofoIds.size();
+	 * totalHygieneRating = currentMonthRatingAllPartners / fofoIds.size();
+	 *
-			LOGGER.info("totalHygieneRating" + totalHygieneRating);
+	 * LOGGER.info("totalHygieneRating" + totalHygieneRating);
+	 *
-			PartnerDetailModel pm = new PartnerDetailModel();
+	 * PartnerDetailModel pm = new PartnerDetailModel();
-			pm.setLmtd(totallmtdAmount);
+	 * pm.setLmtd(totallmtdAmount); pm.setMtd(totalmtdAmount); if
-			pm.setMtd(totalmtdAmount);
-			if (leadCount.get(l1AuthId) != null) {
+	 * (leadCount.get(l1AuthId) != null) {
-				pm.setLeads(leadCount.get(l1AuthId).intValue());
+	 * pm.setLeads(leadCount.get(l1AuthId).intValue()); } else { pm.setLeads(0); }
-			} else {
-				pm.setLeads(0);
-			}
+	 *
-			pm.setInvestment(totalTodayInvestment);
+	 * pm.setInvestment(totalTodayInvestment);
-			pm.setStockInInvestment(totalStockInInvestment);
+	 * pm.setStockInInvestment(totalStockInInvestment);
-			pm.setTicket(totalTicketCount);
+	 * pm.setTicket(totalTicketCount); pm.setHygiene((double)
-			pm.setHygiene((double) Math.round(totalHygieneRating));
-			authIdAndallValues.put(l1AuthId, pm);
+	 * Math.round(totalHygieneRating)); authIdAndallValues.put(l1AuthId, pm);
-		}
+	 *
-		model.addAttribute("authIdAndallValues", authIdAndallValues);
+	 * } model.addAttribute("authIdAndallValues", authIdAndallValues);
-		model.addAttribute("authIdAndAuthUserMap", authIdAndAuthUserMap);
+	 * model.addAttribute("authIdAndAuthUserMap", authIdAndAuthUserMap);
-		LOGGER.info("authIdAndallValues" + authIdAndallValues);
+	 * LOGGER.info("authIdAndallValues" + authIdAndallValues);
+	 *
-		return "auth_user_detail";
+	 * return "auth_user_detail"; }
-	}*/
+	 */
-/*	@RequestMapping(value = "/getAuthUserPartners", method = RequestMethod.GET)
+	@RequestMapping(value = "/getAuthUserPartners", method = RequestMethod.GET)
 	public String AuthUserPartnersDetail(HttpServletRequest request, Model model, @RequestParam int authId)
 			throws Exception {
 		Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
-		List<Integer> fofoIds = pp.get(authId);
-		Map<Integer, Long> ticketMap = ticketRepository.selectAllNotClosedTicketsGroupByRetailer();
-		Map<Integer, Object> fofoIdAndallValues = new LinkedHashMap<>();
-		Map<Integer, Object> fofoIdAndPartnerMap = new LinkedHashMap<>();
-		for (Integer fofoId : fofoIds) {
-			CustomRetailer cr = retailerService.getFofoRetailer(fofoId);
+		Map<Integer, PartnerDetailModel> fofoIdAndallValues = partnerStatsService.getAllPartnerStats();
-			fofoIdAndPartnerMap.put(fofoId, cr);
-			LocalDateTime curDate = LocalDate.now().atStartOfDay();
-			Double lmtdSale = fofoOrderItemRepository
-					.selectSumAmountGroupByRetailer(curDate.withDayOfMonth(1).minusMonths(1),
-							curDate.with(LocalTime.MAX).minusMonths(1), fofoId, false)
-					.get(fofoId);
+		if (authId != 0) {
-			Double mtdSale = fofoOrderItemRepository.selectSumAmountGroupByRetailer(curDate.withDayOfMonth(1),
-					curDate.with(LocalTime.MAX), fofoId, false).get(fofoId);
-			Map<String, Object> investmentMap = this.getInvestments(fofoId);
-			double currentMonthRating = hygieneDataRepository.selectRatingAvg(fofoId,
-					curDate.withDayOfMonth(1).minusMonths(1), curDate.plusMonths(1).withDayOfMonth(1));
-			Long ticketCount = ticketMap.get(fofoId);
+			List<Integer> fofoIds = pp.get(authId);
-			float totalTodayInvestment = (float) investmentMap.get("today");
-			float totalStockInInvestment = (float) investmentMap.get("inStock");
+			fofoIdAndallValues = fofoIdAndallValues.entrySet().stream().filter(x -> fofoIds.contains(x.getKey()))
-			PartnerDetailModel pm = new PartnerDetailModel();
-			pm.setLmtd(lmtdSale);
-			pm.setMtd(mtdSale);
-			pm.setInvestment(totalTodayInvestment);
-			pm.setStockInInvestment(totalStockInInvestment);
-			if (ticketCount != null) {
-				pm.setTicket(ticketCount.intValue());
+					.collect(Collectors.toMap(x -> x.getKey(), x -> x.getValue()));
-			} else {
-				pm.setTicket(0);
-			}
-			pm.setHygiene((double) Math.round(currentMonthRating));
-			fofoIdAndallValues.put(fofoId, pm);
+		}
+		Map<Integer, Object> fofoIdAndPartnerMap = new LinkedHashMap<>();
 		model.addAttribute("fofoIdAndallValues", fofoIdAndallValues);
 		model.addAttribute("fofoIdAndPartnerMap", fofoIdAndPartnerMap);
 		return "auth_user_partner_detail";
-	}*/
+	}
 	private String getWarehouses(Set<CustomRetailer> positionRetailers) {
 		Map<Integer, String> warehouses = new HashMap<>();
 		positionRetailers.stream().forEach(x -> {
 			if (x.getWarehouseId() != 0) {
 		final InputStreamResource inputStreamResource = new InputStreamResource(file);
 		return new ResponseEntity<InputStreamResource>(inputStreamResource, headers, HttpStatus.OK);
+	}
 	public Map<Integer, PartnerDetailModel> getL2AuthUserPartnerDetail() throws Exception {
-		List<Position> pos = positionRepository.selectPositionbyCategoryIdAndEscalationType(
-				ProfitMandiConstants.TICKET_CATEGORY_SALES, EscalationType.L2);
 		LOGGER.info("getL2AuthUserPartnerDetail Started");
 		Map<Integer, List<Integer>> L2L1Mapping = csService.getL2L1Mapping();
 		Map<Integer, Integer> authIdAndleadsCountMap = new HashMap<>();
 		for (Entry<Integer, List<Integer>> l2l1 : L2L1Mapping.entrySet()) {
 			List<Integer> authIds = l2l1.getValue();
 			authIds.add(l2l1.getKey());
 				authIdAndleadsCountMap.put(auth.getId(), leads.size());
 			} else {
 				authIdAndleadsCountMap.put(auth.getId(), 0);
+			}
+		}
 		Map<Integer, PartnerDetailModel> partnerStats = partnerStatsService.getAllPartnerStats();
 		LOGGER.info("authIdAndleadsCountMap" + authIdAndleadsCountMap);
 		Map<Integer, PartnerDetailModel> authIdAndallValues = new LinkedHashMap<>();
 		Map<Integer, List<Integer>> pp = csService.getAuthUserIdPartnerIdMapping();
 		for (int authUserId : pp.keySet()) {
 			if (L2L1Mapping.keySet().contains(authUserId)) {
 				List<Integer> fofoIds = pp.get(authUserId);
-				List<PartnerDetailModel> partnerDetails = fofoIds.stream().map(x->partnerStats.get(x)).collect(Collectors.toList());
+				List<PartnerDetailModel> partnerDetails = fofoIds.stream().map(x -> partnerStats.get(x))
+						.collect(Collectors.toList());
 				PartnerDetailModel partnerDetailModel = partnerStatsService.getAggregateStats(partnerDetails);
 				authIdAndallValues.put(authUserId, partnerDetailModel);
+			}
+		}
+		PartnerDetailModel partnerDetailModel = partnerStatsService
-		PartnerDetailModel partnerDetailModel = partnerStatsService.getAggregateStats(new ArrayList<>(partnerStats.values()));
+				.getAggregateStats(new ArrayList<>(partnerStats.values()));
 		authIdAndallValues.put(0, partnerDetailModel);
 		return authIdAndallValues;
+	}
+}

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/DashboardController.java – Rev 26460 → 26468