Subversion Repositories SmartDukaan

	@RequestMapping(value = "/getMobileLMSFilter", method = RequestMethod.GET)

	public String getMobileLMSFilter(HttpServletRequest request,

			@RequestParam(required = false, defaultValue = "0") int warehouseId,

			@RequestParam(required = false) LocalDate date, Model model) throws Exception {

		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

		String email = loginDetails.getEmailId();

		Map<String, Object> map = this.getFilter(warehouseId, email, date);

		model.addAttribute("warehouseId", warehouseId);

		model.addAllAttributes(map);

		return "chart-filter-lms";

	}

	@RequestMapping(value = "/getMobileLMPFilter", method = RequestMethod.GET)

	public String getMobileLMPFilter(HttpServletRequest request,

			@RequestParam(required = false, defaultValue = "0") int warehouseId,

			@RequestParam(required = false) LocalDate date, Model model) throws Exception {

		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

		String email = loginDetails.getEmailId();

		Map<String, Object> map = this.getFilter(warehouseId, email, date);

		model.addAttribute("warehouseId", warehouseId);

		model.addAllAttributes(map);

		return "chart-filter-lmp";

	}

	@RequestMapping(value = "/getMobileLMPGraph", method = RequestMethod.GET)

	public String getMobileLMPGraph(HttpServletRequest request, @RequestParam(required = false) int warehouseId,

			@RequestParam(required = false) LocalDate date, @RequestParam List<Integer> fofoIds, Model model)

			throws Exception {

		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.getBrandWiseLmp(Arrays.asList(warehouseId),

					fofoIds.stream().map(x -> x).collect(Collectors.toList()), date);

		} else {

			cm = this.getBrandWiseLmp(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-lmp-chart";

	}

	public Map<String, Object> getFilter(int warehouseId, String email, LocalDate date)

			throws ProfitMandiBusinessException {

		Map<String, Object> map = new HashMap<>();

		Map<Integer, CustomRetailer> customRetailersMap = null;

		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();

		AuthUser authUser = authRepository.selectByEmailOrMobile(email);

		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;

		Set<Integer> fofoIds = null;

		fofoIds = storeGuyMap.get(authUser.getEmailId());

		if (emails.contains(authUser.getEmailId())) {

			fofoIds = storeGuyMap.get("tarun.verma@smartdukaan.com");

		}

		if (warehouseId != 0) {

			fofoIds = fofoStoreRepository.selectPartnerByfofoIdAndWarehouse(new ArrayList<>(fofoIds), warehouseId)

					.stream().map(x -> x).collect(Collectors.toSet());

		}

		if (date == null) {

			LocalDateTime curDate = LocalDate.now().atStartOfDay();

			LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(6);

			date = startOfMonth.toLocalDate();

		}

		if (fofoIds != null) {

			customRetailersMap = retailerService

					.getFofoRetailers(fofoIds.stream().map(x -> x).collect(Collectors.toList()));

		}

		map.put("date", date);

		map.put("customRetailersMap", customRetailersMap);

		map.put("fofoIds", fofoIds);

		map.put("warehouseMap", warehouseMap);

		return map;

	}

			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;

	}

	private ChartModel getBrandWiseLmp(List<Integer> warehouseIds, List<Integer> fofoIds, LocalDate startDateTime) {

		LOGGER.info("params" + warehouseIds + fofoIds + startDateTime);

		List<BrandWiseModel> brandWiseLms = orderRepository.selectGroupByBrandLmp(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());

			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 >= 0; 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 >= 0; 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("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));

			lmsModel.setData(brandValue.getValue());