Subversion Repositories SmartDukaan

import com.spice.profitmandi.dao.model.SecondaryOrderBilledLmsModel;

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

	public String getMonthlyPurchaseLineChart(HttpServletRequest request, Model model) throws Exception {

		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

		int fofoId = loginDetails.getFofoId();

		ChartModel cm = this.getPurchaseOrderChart(fofoId);

		LOGGER.info("chartMap" + gson.toJson(cm));

		model.addAttribute("chartMap", gson.toJson(cm));

		return "purchase_chart";

	}

	private ChartModel getPurchaseOrderChart(int fofoId) throws ProfitMandiBusinessException {

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

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

		List<SecondaryOrderBilledLmsModel> soblms = orderRepository.selectAllBilledOrderGroupByBrandFofoId(fofoId,

				curDate.withDayOfMonth(1).minusMonths(6));

		LOGGER.info("soblms" + soblms);

		Map<String, Map<YearMonth, Double>> brandMonthValueMap = new HashMap<>();

		for (SecondaryOrderBilledLmsModel orderBilledLmsMode : soblms) {

			Map<YearMonth, Double> yearMonthMap = new HashMap<>();

			yearMonthMap.put(YearMonth.from(startOfMonth), (double) orderBilledLmsMode.getFirstMonthValue());

			yearMonthMap.put(YearMonth.from(startOfMonth.minusNanos(1)),

					(double) orderBilledLmsMode.getSecondMonthValue());

			yearMonthMap.put(YearMonth.from(startOfMonth.minusMonths(2)),

					(double) orderBilledLmsMode.getThirdMonthValue());

			yearMonthMap.put(YearMonth.from(startOfMonth.minusMonths(3)),

					(double) orderBilledLmsMode.getFourthMonthValue());

			yearMonthMap.put(YearMonth.from(startOfMonth.minusMonths(4)),

					(double) orderBilledLmsMode.getFifthMonthValue());

			yearMonthMap.put(YearMonth.from(startOfMonth.minusMonths(5)),

					(double) orderBilledLmsMode.getSixthMonthValue());

			Map<YearMonth, Double> sortedYearMonthMap = new TreeMap<YearMonth, Double>(yearMonthMap);

			brandMonthValueMap.put(orderBilledLmsMode.getBrand(), sortedYearMonthMap);

		}

		LOGGER.info("brandMonthValueMap" + brandMonthValueMap);

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

		brands.add("Nokia");

		Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();

		for (String brand : brands) {

			Map<YearMonth, Double> coll = brandMonthValueMap.get(brand);

			LOGGER.info("coll" + coll);

			List<Double> valueList = new ArrayList<>();

			if (coll != null) {

				valueList.addAll(coll.values());

			}

			sortedBrandValue.put(brand, valueList);

		}

		LinkedHashSet<String> labels = new LinkedHashSet<String>();

		for (int i = 6; i >= 1; i--) {

			LocalDateTime startMonth = curDate.withDayOfMonth(1).minusMonths(i);

			labels.add(startMonth.format(DateTimeFormatter.ofPattern("MMM''uu")).toString());

			LOGGER.info("labels" + labels);

		}

		LOGGER.info("labels" + labels);

		LOGGER.info("sortedBrandValue" + sortedBrandValue);

		List<DatasetModel> datasets = new ArrayList<>();

		List<String> colorList = new ArrayList<>();

		colorList.add("slateblue");

		colorList.add("darkgreen");

		colorList.add("darkorange");

		colorList.add("#654321");

		colorList.add("deeppink");

		colorList.add("darkred");

		colorList.add("burlywood");

		colorList.add("goldenrod");

		colorList.add("slategray");

		colorList.add("darkviolet");

		colorList.add("cornsilk");

		List<String> borderList = new ArrayList<>();

		borderList.add("lightskyblue");

		borderList.add("green");

		borderList.add("orange");

		borderList.add("#DB8C44");

		borderList.add("pink");

		borderList.add("red");

		borderList.add("slategray");

		borderList.add("burlywood");

		borderList.add("goldenrod");

		borderList.add("darkviolet");

		borderList.add("cornsilk");

		int i = 0;

		for (Entry<String, List<Double>> brandValue : sortedBrandValue.entrySet()) {

			DatasetModel purchaseModel = new DatasetModel();

			purchaseModel.setLabel(brandValue.getKey());

			purchaseModel.setBackgroundColor(borderList.get(i));

			if (brandValue.getValue().isEmpty()) {

				purchaseModel.setData(Arrays.asList(0.0, 0.0, 0.0, 0.0, 0.0, 0.0));

			} else {

				purchaseModel.setData(brandValue.getValue());

			}

			purchaseModel.setType("line");

			purchaseModel.setOrder(1);

			purchaseModel.setFill("false");

			purchaseModel.setBorderColor(colorList.get(i));

			datasets.add(purchaseModel);

			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);

		HoverModel hover = new HoverModel();

		hover.setIntersect(false);

		hover.setMode("index");

		TitleModel tm = new TitleModel();

		tm.setText("Brand Wise Monthly Purchase");

		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;

	}