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

 import java.io.ObjectOutputStream;
 import java.time.LocalDate;
 import java.time.LocalDateTime;
 import java.time.LocalTime;
 import java.time.Month;
+import java.time.Period;
 import java.time.YearMonth;
 import java.time.ZoneOffset;
 import java.time.format.DateTimeFormatter;
 import java.util.ArrayList;
 import java.util.Arrays;
 import javax.transaction.Transactional;
 import org.apache.commons.collections4.OrderedMap;
 import org.apache.logging.log4j.LogManager;
 import org.apache.logging.log4j.Logger;
-import org.bouncycastle.crypto.tls.HashAlgorithm;
 import org.json.JSONObject;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.core.io.InputStreamResource;
 import org.springframework.http.HttpHeaders;
 import com.spice.profitmandi.dao.entity.transaction.Order;
 import com.spice.profitmandi.dao.entity.user.Lead;
 import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
 import com.spice.profitmandi.dao.enumuration.dtr.LeadStatus;
 import com.spice.profitmandi.dao.enumuration.transaction.OrderStatus;
+import com.spice.profitmandi.dao.model.BrandWiseModel;
 import com.spice.profitmandi.dao.model.BrandWisePartnerSaleModel;
 import com.spice.profitmandi.dao.model.BrandWiseUnbilledActivateStockModel;
 import com.spice.profitmandi.dao.model.CreateOfferRequest;
 import com.spice.profitmandi.dao.model.InStockBrandItemModel;
 import com.spice.profitmandi.dao.model.InStockBrandModel;
 	private Map<String, Object> getSales(int fofoId) {
 		Map<String, Object> salesMap = new LinkedHashMap<>();
 		LocalDateTime now = LocalDateTime.now();
-		LocalDateTime startOfToday= LocalDate.now().atStartOfDay();
+		LocalDateTime startOfToday = LocalDate.now().atStartOfDay();
 		int monthLength = LocalDate.now().lengthOfMonth();
 		int daysGone = now.getDayOfMonth() - 1;
 		int daysRemaining = monthLength - daysGone;
-		Double todaySale = fofoOrderItemRepository
-				.selectSumMopGroupByRetailer(startOfToday, now, fofoId, false).get(fofoId);
+		Double todaySale = fofoOrderItemRepository.selectSumMopGroupByRetailer(startOfToday, now, fofoId, false)
-		Double mtdSaleTillYesterDay = fofoOrderItemRepository
-				.selectSumMopGroupByRetailer(startOfToday.withDayOfMonth(1), startOfToday, fofoId, false)
 				.get(fofoId);
+		Double mtdSaleTillYesterDay = fofoOrderItemRepository
+				.selectSumMopGroupByRetailer(startOfToday.withDayOfMonth(1), startOfToday, fofoId, false).get(fofoId);
 		Double mtdSale = mtdSaleTillYesterDay + todaySale;
-		Double lmtdSale = fofoOrderItemRepository.selectSumMopGroupByRetailer(startOfToday.withDayOfMonth(1).minusMonths(1),
+		Double lmtdSale = fofoOrderItemRepository.selectSumMopGroupByRetailer(
-				now.minusMonths(1), fofoId, false).get(fofoId);
+				startOfToday.withDayOfMonth(1).minusMonths(1), now.minusMonths(1), fofoId, false).get(fofoId);
 		List<PartnerTargetDetails> partnerTargetDetails = partnerTargetRepository
 				.selectAllGeEqAndLeEqStartDateAndEndDate(LocalDateTime.now());
 		if (partnerTargetDetails.isEmpty()) {
 			partnerTargetDetails = partnerTargetRepository
+		}
 		PartnerType partnerType = partnerTypeChangeService.getTypeOnDate(fofoId, LocalDate.now());
 		int currentRate = 0;
-		if(mtdSaleTillYesterDay> 0) {
+		if (mtdSaleTillYesterDay > 0) {
 			currentRate = (int) (mtdSaleTillYesterDay / daysGone);
+		}
 		salesMap.put("requiredType", partnerType.next());
 		float reqdAmount = partnerTypeChangeService.getMinimumAmount(partnerType.next());
 		LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(6);
 		List<PriceDropYearMonthModel> priceDropYearMonthModels = priceDropRepository
 				.selectBrandPendingPriceDropByYearMonth(fofoId, startOfMonth);
-			DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-yyyy");
+		DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-yyyy");
 		Map<YearMonth, Map<String, Double>> monthBrandValue = new HashMap<>();
-        LOGGER.info("priceDropYearMonthModels"+priceDropYearMonthModels);
+		LOGGER.info("priceDropYearMonthModels" + priceDropYearMonthModels);
 		for (PriceDropYearMonthModel priceDropYearMonthModel : priceDropYearMonthModels) {
 			Map<String, Double> brandValue = new HashMap<>();
 			brandValue.put(priceDropYearMonthModel.getBrand(), (double) priceDropYearMonthModel.getAmount());
 			monthBrandValue.put(YearMonth.parse(priceDropYearMonthModel.getYearMonth(), dateTimeFormatter), brandValue);
+		}
 		Map<YearMonth, Map<String, Double>> sortedMonthBrandValue = new TreeMap<>(monthBrandValue);
-		LOGGER.info("sortedMonthBrandValue"+sortedMonthBrandValue);
+		LOGGER.info("sortedMonthBrandValue" + sortedMonthBrandValue);
 		List<String> brands = new ArrayList<>();
 		brands.add("Accessories");
 		brands.add("Oppo");
 		brands.add("Vivo");
 		brands.add("Samsung");
 		brands.add("Realme");
 		brands.add("Mi");
 		brands.add("Tecno");
 		brands.add("Itel");
 		brands.add("Nokia");
 		for (int i = 6; i >= 1; i--) {
 			LocalDateTime startMonth = curDate.withDayOfMonth(1).minusMonths(i);
-			LOGGER.info("getStartMonth"+sortedMonthBrandValue.get(YearMonth.from(startMonth)));
+			LOGGER.info("getStartMonth" + sortedMonthBrandValue.get(YearMonth.from(startMonth)));
 			Map<String, Double> valbrand = sortedMonthBrandValue.get(YearMonth.from(startMonth));
 			for (String brand : brands) {
 				if (valbrand != null) {
 					if (!valbrand.containsKey(brand)) {
 						valbrand.put(brand, 0.0);
-					}
-					else {
+					} else {
 						valbrand.put(brand, valbrand.get(brand));
+					}
 				} else {
 					valbrand = new HashMap<String, Double>();
 		colorList.add("coral");
 		colorList.add("steelblue");
 		colorList.add("red");
 		colorList.add("midnightblue");
 		colorList.add("cornsilk");
 		List<String> borderList = new ArrayList<>();
 		borderList.add("pink");
 		borderList.add("#ff8c69");
 		borderList.add("#0000cd");
 		borderList.add("lightsalmon");
 		borderList.add("#0000cd");
 		borderList.add("cornsilk");
 		int i = 0;
 		for (Entry<String, List<Double>> brandValue : sortedBrandValue.entrySet()) {
 			DatasetModel purchaseModel = new DatasetModel();
 			purchaseModel.setLabel(brandValue.getKey());
 			purchaseModel.setBackgroundColor(colorList.get(i));
 			if (brandValue.getValue().isEmpty()) {
 		Tooltips tooltips = new Tooltips();
 		tooltips.setBodyFontSize(15);
 		tooltips.setTitleFontSize(15);
 		tooltips.setMode("index");
 		tooltips.setIntersect(false);
-        tooltips.setBackgroundColor("rgba(0, 0, 0, .5)");
+		tooltips.setBackgroundColor("rgba(0, 0, 0, .5)");
 		HoverModel hover = new HoverModel();
 		hover.setIntersect(false);
 		hover.setMode("index");
 		TitleModel tm = new TitleModel();
 		tooltips.setBodyFontSize(15);
 		tooltips.setTitleFontSize(15);
 		tooltips.setMode("index");
 		tooltips.setIntersect(false);
 		tooltips.setBackgroundColor("rgba(0, 0, 0, .5)");
 		HoverModel hover = new HoverModel();
 		hover.setIntersect(false);
 		hover.setMode("index");
 		TitleModel tm = new TitleModel();
 			LinkedHashMap<Integer, WarehouseWiseStockModel> warehouseStockSortedMap = new LinkedHashMap<>();
 			Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
 			LinkedHashMap<Integer, String> wm = new LinkedHashMap<Integer, String>();
-			Map<String, BrandWisePartnerSaleModel> partnersBrandSaleMap = null;
-			List<BrandWisePartnerSaleModel> accessoriesBrandSales = null;
 			Map<AuthUser, Long> authUserTicketCount = null;
 			for (Map.Entry<Integer, String> entry : warehouseMap.entrySet()) {
 				wm.put(entry.getKey(), entry.getValue());
+			}
 				// warehouseStock
 				warehousePartnerDetailMap = this.getWarehousePartnerDetail(warehouseIdFofoIdMap);
 				rctPartneStat = reporticoCacheTableRepository.selectByTableName("partnerStat");
-				partnersBrandSaleMap = fofoStoreRepository
-						.selectGroupByBrandWarehousePartnerSale(new ArrayList<>(fofoIds)).stream()
-						.collect(Collectors.toMap(x -> x.getBrand(), x -> x));
-				List<BrandWiseUnbilledActivateStockModel> unbilledActivatedStock = fofoStoreRepository
-						.selectUnbilledActivateStockGroupByBrand(new ArrayList<>(fofoIds));
-				for (BrandWiseUnbilledActivateStockModel un : unbilledActivatedStock) {
-					BrandWisePartnerSaleModel bpt = partnersBrandSaleMap.get(un.getBrand());
-					if (bpt != null) {
-						bpt.setAmtd(un.getUnbilledMtd());
-						bpt.setUamtdQty(un.getUnbilledMTDQty());
-					} else {
-						bpt = new BrandWisePartnerSaleModel();
-						bpt.setBrand(un.getBrand());
-						bpt.setAmtd(un.getUnbilledMtd());
-						bpt.setUamtdQty(un.getUnbilledMTDQty());
-						bpt.setLms(0);
-						bpt.setLmtd(0);
-						bpt.setMtd(0);
-						bpt.setMtdQty(0);
-						bpt.setLmtd(0);
-						bpt.setLmtdQty(0);
-						partnersBrandSaleMap.put(un.getBrand(), bpt);
-					}
-				}
-				accessoriesBrandSales = fofoStoreRepository
-						.selectGroupByBrandAccesoriesWarehousePartnerSale(new ArrayList<>(fofoIds));
 				Set<CustomRetailer> positionRetailers = fofoIds.stream()
 						.map(x -> retailerService.getAllFofoRetailers().get(x)).filter(x -> x != null)
 						.collect(Collectors.toSet());
 				model.addAttribute("retailers", gson.toJson(positionRetailers));
 				model.addAttribute("reporticoProjectMap", ReporticoProject.salesReporticoProjectMap);
 					if (menuIds.size() > 0) {
 						menus = menuRepository.selectAllByIds(menuIds);
+					}
+				}
+			}
+			Map<Integer, CustomRetailer> customRetailerMap = retailerService
+					.getFofoRetailers(fofoIds.stream().map(x -> x).collect(Collectors.toList()));
 			model.addAttribute("authId", authUser.getId());
 			model.addAttribute("rctPartneStat", rctPartneStat);
 			model.addAttribute("reporticoDate", rctSaholic);
 			model.addAttribute("warehousePartnerDetailMap", warehousePartnerDetailMap);
 			model.addAttribute("warehouseMap", wm);
+			model.addAttribute("customRetailersMap", customRetailerMap);
+			model.addAttribute("fofoIds", fofoIds);
 			model.addAttribute("authUserTicketCount", authUserTicketCount);
 			model.addAttribute("warehouseStockMap", warehouseStockSortedMap);
-			model.addAttribute("brandSalesMap", partnersBrandSaleMap);
+			LocalDateTime curDate = LocalDate.now().atStartOfDay();
-			model.addAttribute("accessoriesBrandSales", accessoriesBrandSales);
+			model.addAttribute("date", curDate.withDayOfMonth(1).minusMonths(6).toLocalDate());
 		} catch (ProfitMandiBusinessException e) {
+		}
 		List<Menu> menuList = (menus != null) ? this.prepareMenu(menus) : new ArrayList<>();
 		LOGGER.info("menu" + menuList);
 		model.addAttribute("customRetailer", customRetailer);
 		return "partner-secondary-order";
+	}
+	@RequestMapping(value = "/getMobileBrandWise", method = RequestMethod.GET)
+	public String getMobileBrandWise(HttpServletRequest request, Model model) throws Exception {
+		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
+		String email = loginDetails.getEmailId();
+		AuthUser authUser = authRepository.selectByEmailOrMobile(email);
+		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
+		Set<Integer> fofoIds = storeGuyMap.get(authUser.getEmailId());
+		if (emails.contains(authUser.getEmailId())) {
+			fofoIds = storeGuyMap.get("tarun.verma@smartdukaan.com");
+			LOGGER.info("fofoIds" + fofoIds);
+		}
+		Map<String, BrandWisePartnerSaleModel> partnersBrandSaleMap = null;
+		partnersBrandSaleMap = fofoStoreRepository.selectGroupByBrandWarehousePartnerSale(new ArrayList<>(fofoIds))
+				.stream().collect(Collectors.toMap(x -> x.getBrand(), x -> x));
+		List<BrandWiseUnbilledActivateStockModel> unbilledActivatedStock = fofoStoreRepository
+				.selectUnbilledActivateStockGroupByBrand(new ArrayList<>(fofoIds));
+		for (BrandWiseUnbilledActivateStockModel un : unbilledActivatedStock) {
+			BrandWisePartnerSaleModel bpt = partnersBrandSaleMap.get(un.getBrand());
+			if (bpt != null) {
+				bpt.setAmtd(un.getUnbilledMtd());
+				bpt.setUamtdQty(un.getUnbilledMTDQty());
+			} else {
+				bpt = new BrandWisePartnerSaleModel();
+				bpt.setBrand(un.getBrand());
+				bpt.setAmtd(un.getUnbilledMtd());
+				bpt.setUamtdQty(un.getUnbilledMTDQty());
+				bpt.setLms(0);
+				bpt.setLmtd(0);
+				bpt.setMtd(0);
+				bpt.setMtdQty(0);
+				bpt.setLmtd(0);
+				bpt.setLmtdQty(0);
+				partnersBrandSaleMap.put(un.getBrand(), bpt);
+			}
+		}
+		model.addAttribute("brandSalesMap", partnersBrandSaleMap);
+		return "mobile-brand-wise-report";
+	}
+	@RequestMapping(value = "/getAccessoriesBrandWise", method = RequestMethod.GET)
+	public String getAccessoriesBrandWise(HttpServletRequest request, Model model) throws Exception {
+		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
+		String email = loginDetails.getEmailId();
+		AuthUser authUser = authRepository.selectByEmailOrMobile(email);
+		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
+		Set<Integer> fofoIds = storeGuyMap.get(authUser.getEmailId());
+		if (emails.contains(authUser.getEmailId())) {
+			fofoIds = storeGuyMap.get("tarun.verma@smartdukaan.com");
+			LOGGER.info("fofoIds" + fofoIds);
+		}
+		List<BrandWisePartnerSaleModel> accessoriesBrandSales = null;
+		accessoriesBrandSales = fofoStoreRepository
+				.selectGroupByBrandAccesoriesWarehousePartnerSale(new ArrayList<>(fofoIds));
+		model.addAttribute("accessoriesBrandSales", accessoriesBrandSales);
+		return "accessories-brand-wise-report";
+	}
+	@RequestMapping(value = "/getMobileLMSGraph", method = RequestMethod.GET)
+	public String getMobileLMSGraph(HttpServletRequest request, @RequestParam int warehouseId,
+			@RequestParam(required = false) LocalDate date, @RequestParam List<Integer> fofoIds, Model model)
+			throws Exception {
+		if (date == null) {
+			LocalDateTime curDate = LocalDate.now().atStartOfDay();
+			LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(6);
+			date = startOfMonth.toLocalDate();
+		}
+		Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository
+				.selectActivePartnersByRetailerIds(new ArrayList<>(fofoIds)).stream().collect(Collectors.groupingBy(
+						FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));
+		ChartModel cm;
+		if (warehouseId != 0) {
+			cm = this.getBrandWiseLms(Arrays.asList(warehouseId),
+					fofoIds.stream().map(x -> x).collect(Collectors.toList()), date);
+		} else {
+			cm = this.getBrandWiseLms(new ArrayList<>(warehouseIdFofoIdMap.keySet()),
+					fofoIds.stream().map(x -> x).collect(Collectors.toList()), date);
+		}
+		LOGGER.info("chartMap" + gson.toJson(cm));
+		model.addAttribute("chartMap", gson.toJson(cm));
+		return "brand-wise-mobile-lms-chart";
+	}
+	private ChartModel getBrandWiseLms(List<Integer> warehouseIds, List<Integer> fofoIds, LocalDate startDateTime) {
+		LOGGER.info("params" + warehouseIds + fofoIds + startDateTime);
+		List<BrandWiseModel> brandWiseLms = fofoStoreRepository.selectGroupByBrandLms(fofoIds, warehouseIds,
+				startDateTime);
+		LOGGER.info("brandWiseLms" + brandWiseLms);
+		DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-yyyy");
+		Map<String, Map<YearMonth, Double>> brandMonthValue = new HashMap<>();
+		for (BrandWiseModel bwl : brandWiseLms) {
+			Map<YearMonth, Double> brandValue = new HashMap<>();
+			if (brandMonthValue.containsKey(bwl.getBrand())) {
+				brandValue = brandMonthValue.get(bwl.getBrand());
+				brandValue.put(YearMonth.parse(bwl.getYearMonth(), dateTimeFormatter), (double) bwl.getAmount());
+			} else {
+				brandValue.put(YearMonth.parse(bwl.getYearMonth(), dateTimeFormatter), (double) bwl.getAmount());
+			}
+			brandMonthValue.put(bwl.getBrand(), brandValue);
+		}
+		LocalDateTime curDate = LocalDate.now().atStartOfDay();
+		Period age = Period.between(startDateTime, LocalDate.now());
+		int months = age.getMonths();
+		LOGGER.info("months" + months);
+		LOGGER.info("brandWiseLms" + brandWiseLms);
+		LOGGER.info("brandMonthValue" + brandMonthValue);
+		List<String> brands = new ArrayList<>();
+		brands.add("Oppo");
+		brands.add("Vivo");
+		brands.add("Samsung");
+		brands.add("Realme");
+		brands.add("Mi");
+		brands.add("Tecno");
+		brands.add("Itel");
+		brands.add("Lava");
+		brands.add("Nokia");
+		Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
+		for (String brand : brands) {
+			Map<YearMonth, Double> yearMonthValue = brandMonthValue.get(brand);
+			for (int i = months; i >= 1; i--) {
+				LocalDateTime startMonth = curDate.withDayOfMonth(1).minusMonths(i);
+				if (yearMonthValue != null) {
+					if (yearMonthValue.get(YearMonth.from(startMonth)) == null) {
+						yearMonthValue.put(YearMonth.from(startMonth), 0.0);
+					}
+				} else {
+					yearMonthValue = new HashMap<>();
+					yearMonthValue.put(YearMonth.from(startMonth), 0.0);
+				}
+			}
+			Map<YearMonth, Double> sortedMonthBrandValue = new TreeMap<>(yearMonthValue);
+			brandMonthValue.put(brand, sortedMonthBrandValue);
+			sortedBrandValue.put(brand, sortedMonthBrandValue.values().stream().collect(Collectors.toList()));
+		}
+		LOGGER.info("brandMonthValue" + brandMonthValue);
+		LOGGER.info("sortedBrandValue" + sortedBrandValue);
+		LinkedHashSet<String> labels = new LinkedHashSet<String>();
+		for (int i = months; i >= 1; i--) {
+			LocalDateTime startMonth = curDate.withDayOfMonth(1).minusMonths(i);
+			labels.add(startMonth.format(DateTimeFormatter.ofPattern("MMM''uu")).toString());
+		}
+		List<DatasetModel> datasets = new ArrayList<>();
+		List<String> colorList = new ArrayList<>();
+		colorList.add("darkgreen");
+		colorList.add("dodgerblue");
+		colorList.add("darkblue");
+		colorList.add("gold");
+		colorList.add("coral");
+		colorList.add("steelblue");
+		colorList.add("red");
+		colorList.add("midnightblue");
+		colorList.add("cornsilk");
+		List<String> borderList = new ArrayList<>();
+		borderList.add("pink");
+		borderList.add("mediumseagreen");
+		borderList.add("lightblue");
+		borderList.add("#0000cd");
+		borderList.add("#f7e98e");
+		borderList.add("#ff8c69");
+		borderList.add("#0000cd");
+		borderList.add("lightsalmon");
+		borderList.add("#0000cd");
+		borderList.add("cornsilk");
+		int i = 0;
+		for (Entry<String, List<Double>> brandValue : sortedBrandValue.entrySet()) {
+			DatasetModel lmsModel = new DatasetModel();
+			lmsModel.setLabel(brandValue.getKey());
+			lmsModel.setBackgroundColor(colorList.get(i));
+			if (brandValue.getValue().isEmpty()) {
+				lmsModel.setData(Arrays.asList(0.0, 0.0, 0.0, 0.0, 0.0, 0.0));
+			} else {
+				lmsModel.setData(brandValue.getValue());
+			}
+			lmsModel.setType("line");
+			lmsModel.setOrder(1);
+			lmsModel.setFill("false");
+			lmsModel.setBorderColor(borderList.get(i));
+			datasets.add(lmsModel);
+			i++;
+		}
+		DataModel dm = new DataModel();
+		dm.setDatasets(datasets);
+		dm.setLabels(labels);
+		LegendModel lm = new LegendModel();
+		lm.setPosition("top");
+		Tooltips tooltips = new Tooltips();
+		tooltips.setBodyFontSize(15);
+		tooltips.setTitleFontSize(15);
+		tooltips.setMode("index");
+		tooltips.setIntersect(false);
+		tooltips.setBackgroundColor("rgba(0, 0, 0, .5)");
+		HoverModel hover = new HoverModel();
+		hover.setIntersect(false);
+		hover.setMode("index");
+		TitleModel tm = new TitleModel();
+		tm.setText("Brand Wise Monthly Sale");
+		tm.setDisplay(true);
+		tm.setFontSize(20);
+		tm.setFontColor("#111");
+		OptionsModel om = new OptionsModel();
+		om.setResponsive(true);
+		om.setLegend(lm);
+		om.setTitle(tm);
+		om.setTooltips(tooltips);
+		om.setHover(hover);
+		ChartModel cm = new ChartModel();
+		cm.setType("line");
+		cm.setData(dm);
+		cm.setOptions(om);
+		LOGGER.info("cm" + cm);
+		return cm;
+	}
+}

Subversion Repositories SmartDukaan

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