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

 import java.io.ObjectInputStream;
 import java.io.ObjectOutputStream;
 import java.time.LocalDate;
 import java.time.LocalDateTime;
 import java.time.LocalTime;
+import java.time.Month;
 import java.time.YearMonth;
 import java.time.ZoneOffset;
 import java.time.format.DateTimeFormatter;
 import java.util.ArrayList;
 import java.util.Arrays;
 			model.addAttribute("brandStockPrices", this.getBrandStockPrices(fofoId));
 			model.addAttribute("salesMap", this.getSales(fofoId));
 			model.addAttribute("activatedImeis", inventoryItemRepository.selectCountByActivatedNotSold(fofoId));
 			// this.setInvestments
 			//
+			Map<Integer, String> monthValueMap = new HashMap<>();
+			for (int i = 0; i <= 5; i++) {
+				LocalDateTime startOfMonth = LocalDateTime.now().withDayOfMonth(1).minusMonths(i);
+				monthValueMap.put(i, startOfMonth.format(DateTimeFormatter.ofPattern("MMM''uu")));
+			}
+			LOGGER.info("monthValueMap" + monthValueMap);
+			model.addAttribute("monthValueMap", monthValueMap);
 			model.addAttribute("investments", this.getInvestments(fofoId));
 			model.addAttribute("isInvestmentOk",
 					partnerInvestmentService.isInvestmentOk(fofoId, 10, ProfitMandiConstants.CUTOFF_INVESTMENT));
 		} catch (ProfitMandiBusinessException e) {
 			LOGGER.error("FofoStore Code not found of fofoId {}", fofoId);
+		}
-		LocalDateTime currentMonthStart = LocalDateTime.now().withDayOfMonth(1);
-		LocalDateTime currentMonthEnd = currentMonthStart.plusMonths(1).withDayOfMonth(1);
-		double currentMonthRating = hygieneDataRepository.selectRatingAvg(fofoId, currentMonthStart, currentMonthEnd)
-				/ 2;
+			return "12dashboard34";
-		double lastMonthRating = hygieneDataRepository.selectRatingAvg(fofoId, currentMonthStart, currentMonthEnd) / 2;
-		double ratingTillDate = hygieneDataRepository.selectRatingAvg(fofoId, currentMonthStart, currentMonthEnd) / 2;
-		model.addAttribute("currentMonthRating", (float) Math.round(currentMonthRating * 10) / 10);
-		model.addAttribute("lastMonthRating", (float) Math.round(lastMonthRating * 10) / 10);
-		model.addAttribute("ratingTillDate", (float) Math.round(ratingTillDate * 10) / 10);
+	}
-		long hygieneCount = hygieneDataRepository.selectHygieneCount(fofoId, true, currentMonthStart, currentMonthEnd);
-		long invalidHygieneCount = hygieneDataRepository.selectHygieneCount(fofoId, false, currentMonthStart,
+	private Map<String, Object> getInvestments(int fofoId) throws Exception {
+		Map<String, Object> investments = new LinkedHashMap<>();
+		PartnerDailyInvestment investment = partnerInvestmentService.getInvestment(fofoId, 0);
-				currentMonthEnd);
+		LocalDate currentMonthStart = LocalDate.now().withDayOfMonth(1);
-		if (hygieneCount == 0 && invalidHygieneCount == 0) {
+		LocalDate yesterDate = LocalDate.now().minusDays(1);
+		PartnerDailyInvestment yesterdayInvestment = partnerDailyInvestmentRepository.select(fofoId, yesterDate);
-			invalidHygieneCount = 1;
+		if (yesterdayInvestment == null) {
+			yesterdayInvestment = new PartnerDailyInvestment();
+		}
-		model.addAttribute("hygienePercentage", (hygieneCount * 100) / (invalidHygieneCount + hygieneCount));
+		List<PartnerDailyInvestment> currentMonthInvestments = partnerDailyInvestmentRepository.selectAll(fofoId,
-		model.addAttribute("monthDays", LocalDate.now().minusDays(1).lengthOfMonth());
+				currentMonthStart, currentMonthStart.withDayOfMonth(currentMonthStart.lengthOfMonth()));
+		long okInvestmentDays = currentMonthInvestments.stream().filter(x -> x.getShortPercentage() <= 10)
+				.collect(Collectors.counting());
+		investments.put("today", investment.getTotalInvestment());
+		investments.put("investment", investment);
+		investments.put("inStock", investment.getInStockAmount());
+		investments.put("minimum", investment.getMinInvestmentString());
+		investments.put("short", investment.getShortPercentage());
-		model.addAttribute("dayOfMonth", LocalDate.now().minusDays(1).getDayOfMonth());
+		investments.put("activated_stock", investment.getActivatedStockAmount());
+		investments.put("okDays", okInvestmentDays);
-		return "12dashboard34";
+		return investments;
+	}
-	private Map<String, Object> getInvestments(int fofoId) throws Exception {
+	private Map<String, Object> getInvestmentsMonths(int fofoId, int month) throws Exception {
 		Map<String, Object> investments = new LinkedHashMap<>();
 		PartnerDailyInvestment investment = partnerInvestmentService.getInvestment(fofoId, 0);
-		LocalDate currentMonthStart = LocalDate.now().withDayOfMonth(1);
+		LocalDate currentMonthStart = LocalDate.now().withDayOfMonth(1).minusMonths(month);
 		LocalDate yesterDate = LocalDate.now().minusDays(1);
 		PartnerDailyInvestment yesterdayInvestment = partnerDailyInvestmentRepository.select(fofoId, yesterDate);
 		if (yesterdayInvestment == null) {
 			yesterdayInvestment = new PartnerDailyInvestment();
+		}
 		long invalidHygieneCount = hygieneDataRepository.selectHygieneCount(loginDetails.getFofoId(), false,
 				currentMonthStart, currentMonthEnd);
 		if (hygieneCount == 0 && invalidHygieneCount == 0) {
 			invalidHygieneCount = 1;
+		}
+		Map<Integer, String> monthValueMap = new HashMap<>();
+		for (int i = 0; i <= 5; i++) {
+			LocalDateTime startOfMonth = LocalDateTime.now().withDayOfMonth(1).minusMonths(i);
+			monthValueMap.put(i, startOfMonth.format(DateTimeFormatter.ofPattern("MMM''uu")));
+		}
+		model.addAttribute("monthValueMap", monthValueMap);
+		model.addAttribute("month", 0);
 		model.addAttribute("hygienePercentage", (hygieneCount * 100) / (invalidHygieneCount + hygieneCount));
 		model.addAttribute("monthDays", LocalDate.now().minusDays(1).lengthOfMonth());
 		model.addAttribute("dayOfMonth", LocalDate.now().minusDays(1).getDayOfMonth());
 		/*
 		 * if (loginDetails.isReadOnly()) { return "dashboard-readonly"; } else { }
 		 */
 		return "dashboard1";
+	}
+	@RequestMapping(value = "/getMonthsInvestment", method = RequestMethod.GET)
+	public String getMonthsInvestment(HttpServletRequest request,
+			@RequestParam(name = "month", required = true, defaultValue = "0") int month, Model model)
+			throws Exception {
+		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
+		int fofoId = loginDetails.getFofoId();
+		Map<String, Object> investment = getInvestmentsMonths(fofoId, month);
+		LocalDateTime currentMonthStart = LocalDateTime.now().withDayOfMonth(1);
+		LocalDateTime lastMonthStart = currentMonthStart.minusMonths(1);
+		LocalDateTime currentMonthEnd = currentMonthStart.plusMonths(1).withDayOfMonth(1);
+		double currentMonthRating = hygieneDataRepository.selectRatingAvg(loginDetails.getFofoId(), currentMonthStart,
+				currentMonthEnd) / 2;
+		double lastMonthRating = hygieneDataRepository.selectRatingAvg(loginDetails.getFofoId(), lastMonthStart,
+				currentMonthStart) / 2;
+		double ratingTillDate = hygieneDataRepository.selectRatingAvg(loginDetails.getFofoId(), LocalDateTime.MIN,
+				currentMonthEnd) / 2;
+		model.addAttribute("currentMonthRating", (float) Math.round(currentMonthRating * 10) / 10);
+		model.addAttribute("lastMonthRating", (float) Math.round(lastMonthRating * 10) / 10);
+		model.addAttribute("ratingTillDate", (float) Math.round(ratingTillDate * 10) / 10);
+		long hygieneCount = hygieneDataRepository.selectHygieneCount(loginDetails.getFofoId(), true, currentMonthStart.minusMonths(month),
+				currentMonthEnd.minusMonths(month));
+		long invalidHygieneCount = hygieneDataRepository.selectHygieneCount(loginDetails.getFofoId(), false,
+				currentMonthStart.minusMonths(month),
+				currentMonthEnd.minusMonths(month));
+		if (hygieneCount == 0 && invalidHygieneCount == 0) {
+			invalidHygieneCount = 1;
+		}
+		Map<Integer, String> monthValueMap = new HashMap<>();
+		for (int i = 0; i <= 5; i++) {
+			LocalDateTime startOfMonth = LocalDateTime.now().withDayOfMonth(1).minusMonths(i);
+			monthValueMap.put(i, startOfMonth.format(DateTimeFormatter.ofPattern("MMM''uu")));
+		}
+		model.addAttribute("hygienePercentage", (hygieneCount * 100) / (invalidHygieneCount + hygieneCount));
+		model.addAttribute("monthValueMap" ,monthValueMap);
+		model.addAttribute("investments", investment);
+		model.addAttribute("monthDays", LocalDate.now().minusMonths(month).lengthOfMonth());
+		model.addAttribute("dayOfMonth", LocalDate.now().minusMonths(month).lengthOfMonth());
+		model.addAttribute("month",month);
+		return "performance";
+	}
 	@RequestMapping(value = "/investmentDetails", method = RequestMethod.GET)
 	public String getInvestmentDetails(HttpServletRequest request, Model model) throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 	private ChartInvestmentModel getInvestmentChart(int fofoId) throws ProfitMandiBusinessException {
 		PartnerDailyInvestment investment = partnerInvestmentService.getInvestment(fofoId, 0);
 		Map<String, Float> investmentWalletAmount = new HashMap<>();
 		investmentWalletAmount.put("Wallet", investment.getWalletAmount());
-		investmentWalletAmount.put("InStocks", investment.getInStockAmount()-investment.getActivatedStockAmount());
+		investmentWalletAmount.put("InStocks", investment.getInStockAmount() - investment.getActivatedStockAmount());
 		investmentWalletAmount.put("Unbilled Order", investment.getUnbilledAmount());
 		investmentWalletAmount.put("GrnPending", investment.getGrnPendingAmount());
 		investmentWalletAmount.put("ReturnInTransit", investment.getReturnInTransitAmount());
 		if (investment.getShortInvestment() > 0) {
 		LOGGER.info("brandwisesale" + brandwisesale);
 		Map<Integer, Double> accesoriesmtdsale = fofoOrderRepository.selectSumSaleGroupByFofoIdsForMobileOrAccessories(
 				fofoId, curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), Optional.of(false));
 		brandwisesale.put("Accessories", accesoriesmtdsale.get(fofoId));
 		Map<String, Double> activatedImeisWithSellingPriceMTD = fofoOrderRepository
 				.selectValueOfActivatedImeis(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId).stream()
 				.collect(Collectors.toMap(x -> x.getBrand(), x -> (double) x.getSellingPrice()));
 		activatedImeisWithSellingPriceMTD.put("Lava", brandwisesale.get("Lava"));
 		Map<String, Double> activatedImeisWithSellingPriceLMTD = fofoOrderRepository
 				.selectValueOfActivatedImeis(curDate.withDayOfMonth(1).minusMonths(1),
 						curDate.with(LocalTime.MAX).minusMonths(1), fofoId)
 				.stream().collect(Collectors.toMap(x -> x.getBrand(), x -> (double) x.getSellingPrice()));
 			if (emails.contains(authUser.getEmailId())) {
 				fofoIds = storeGuyMap.get("tarun.verma@smartdukaan.com");
 				LOGGER.info("fofoIds" + fofoIds);
+			}
 			if (fofoIds != null) {
 				Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository
 						.selectActivePartnersByRetailerIds(new ArrayList<>(fofoIds)).stream()
 						.collect(Collectors.groupingBy(FofoStore::getWarehouseId,
 						partnersBrandSaleMap.put(un.getBrand(), bpt);
+					}
+				}
 				accessoriesBrandSales = fofoStoreRepository
 						.selectGroupByBrandAccesoriesWarehousePartnerSale(new ArrayList<>(fofoIds));
+				Set<CustomRetailer> positionRetailers = fofoIds.stream()
-				Set<CustomRetailer> positionRetailers = fofoIds.stream().map(x->retailerService.getAllFofoRetailers().get(x)).filter(x->x!=null).collect(Collectors.toSet());
+						.map(x -> retailerService.getAllFofoRetailers().get(x)).filter(x -> x != null)
+						.collect(Collectors.toSet());
 				model.addAttribute("retailers", gson.toJson(positionRetailers));
 				model.addAttribute("reporticoProjectMap", ReporticoProject.salesReporticoProjectMap);
 				model.addAttribute("warehouses", getWarehouses(positionRetailers));
+			}
 					if (menuIds.size() > 0) {
 						menus = menuRepository.selectAllByIds(menuIds);
+					}
+				}
+			}
+			/*
+			 * List<Position> salesPositions = positions.stream() .filter(x ->
+			 * x.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_SALES)
+			 * .collect(Collectors.toList()); if (salesPositions.size() > 0) {
+			 * Set<CustomRetailer> positionRetailers = new HashSet<>();
+			 * csService.getPositionCustomRetailerMap(salesPositions).values().forEach(
+			 * customRetailers -> { positionRetailers.addAll(customRetailers); }); }
+			 */
+			if (fofoIds == null) {
-				/*List<Position> salesPositions = positions.stream()
+				List<Position> warehousePositions = positions.stream()
-						.filter(x -> x.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_SALES)
+						.filter(x -> x.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_WAREHOUSE)
 						.collect(Collectors.toList());
-				if (salesPositions.size() > 0) {
+				if (warehousePositions.size() > 0) {
 					Set<CustomRetailer> positionRetailers = new HashSet<>();
-					csService.getPositionCustomRetailerMap(salesPositions).values().forEach(customRetailers -> {
+					csService.getPositionCustomRetailerMap(warehousePositions).values().forEach(customRetailers -> {
 						positionRetailers.addAll(customRetailers);
 					});
-				}*/
-				if(fofoIds == null) {
-					List<Position> warehousePositions = positions.stream()
-							.filter(x -> x.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_WAREHOUSE)
-							.collect(Collectors.toList());
-					if (warehousePositions.size() > 0) {
-						Set<CustomRetailer> positionRetailers = new HashSet<>();
-						csService.getPositionCustomRetailerMap(warehousePositions).values().forEach(customRetailers -> {
-							positionRetailers.addAll(customRetailers);
-						});
-						model.addAttribute("reporticoProjectMap", ReporticoProject.warehouseReporticoMap);
+					model.addAttribute("reporticoProjectMap", ReporticoProject.warehouseReporticoMap);
-						model.addAttribute("retailers", gson.toJson(positionRetailers));
+					model.addAttribute("retailers", gson.toJson(positionRetailers));
-						model.addAttribute("warehouses", getWarehouses(positionRetailers));
+					model.addAttribute("warehouses", getWarehouses(positionRetailers));
-					}
+				}
+			}
-				model.addAttribute("authId", authUser.getId());
+			model.addAttribute("authId", authUser.getId());
 			model.addAttribute("rctPartneStat", rctPartneStat);
 			model.addAttribute("reporticoDate", rctSaholic);
 			model.addAttribute("warehousePartnerDetailMap", warehousePartnerDetailMap);

Subversion Repositories SmartDukaan

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