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

 import java.util.stream.Collectors;
 import javax.servlet.http.HttpServletRequest;
 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;
+			}
+		}
 		LOGGER.info("map" + brandMonthValueMap);
-		Map<String, List<Double>> brandlistValue = new HashMap<>();
-		List<String> brands = new ArrayList<>();
-		for (String bwr : brandMonthValueMap.keys()) {
-			if (!brands.contains(bwr)) {
-				brands.add(bwr);
+		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");
-		LOGGER.info("brands" + brands);
+		brands.add("Lava");
+		brands.add("Nokia");
+		Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
 		for (String brand : brands) {
 			Collection<Map<YearMonth, Double>> coll = brandMonthValueMap.get(brand);
 			LOGGER.info("coll" + coll);
 			for (Map<YearMonth, Double> col : coll) {
 				valueList.addAll(col.values());
+			}
-			brandlistValue.put(brand, valueList);
+			sortedBrandValue.put(brand, valueList);
+		}
-		LOGGER.info("brandlistValue" + brandlistValue);
+		LOGGER.info("sortedBrandValue" + sortedBrandValue);
 		LinkedHashSet<String> labels = new LinkedHashSet<String>();
 		for (Entry<YearMonth, Map<String, Double>> val : sortedMonthValueMap.entrySet()) {
 			labels.add(val.getKey().format(DateTimeFormatter.ofPattern("MMM''uu")).toString());
+		}
 		List<String> labelList = new ArrayList<>(labels);
 		List<Double> lmsValues = new ArrayList<>();
 		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("darkgreen");
 		colorList.add("darkred");
-		colorList.add("slateblue");
 		colorList.add("burlywood");
 		colorList.add("goldenrod");
 		colorList.add("slategray");
 		colorList.add("darkviolet");
 		colorList.add("cornsilk");
-		List<String> borderList = new ArrayList<>();
+		List<String> borderList = new ArrayList<>();
+		borderList.add("lightskyblue");
+		borderList.add("green");
 		borderList.add("orange");
 		borderList.add("#DB8C44");
 		borderList.add("pink");
-		borderList.add("green");
 		borderList.add("red");
-		borderList.add("lightskyblue");
 		borderList.add("slategray");
 		borderList.add("burlywood");
 		borderList.add("goldenrod");
 		borderList.add("darkviolet");
 		borderList.add("cornsilk");
-		int i= 0;
+		int i = 0;
-		for (Entry<String, List<Double>> brandValue : brandlistValue.entrySet()) {
+		for (Entry<String, List<Double>> brandValue : sortedBrandValue.entrySet()) {
 			DatasetModel lineLmsChart = new DatasetModel();
 			lineLmsChart.setLabel(brandValue.getKey());
 			lineLmsChart.setBackgroundColor(borderList.get(i));
+			if (brandValue.getValue().isEmpty()) {
+                  lineLmsChart.setData(Arrays.asList(0.0,0.0,0.0,0.0,0.0,0.0));
+			} else {
-			lineLmsChart.setData(brandValue.getValue());
+				lineLmsChart.setData(brandValue.getValue());
+			}
 			lineLmsChart.setType("line");
 			lineLmsChart.setOrder(1);
 			lineLmsChart.setFill("false");
 			lineLmsChart.setBorderColor(colorList.get(i));
 			datasets.add(lineLmsChart);
 			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 LMS");
 		tm.setDisplay(true);
 		tm.setFontSize(20);
-        tm.setFontColor("#111");
+		tm.setFontColor("#111");
-        OptionsModel om = new OptionsModel();
+		OptionsModel om = new OptionsModel();
 		om.setResponsive(true);
 		om.setLegend(lm);
 		om.setTitle(tm);
 		om.setTooltips(tooltips);
 		om.setHover(hover);
 		LOGGER.info("cur Date" + curDate.withDayOfMonth(1));
 		LOGGER.info("curDateYear" + curDate.with(LocalTime.MAX));
 		Map<String, Double> brandwisesale = fofoOrderItemRepository
-		.selectSumAmountGroupByBrand(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId);
+				.selectSumAmountGroupByBrand(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId);
 		LOGGER.info("brandwisesale" + brandwisesale);
 		Map<Integer, Double> accesoriesmtdsale = fofoOrderRepository.selectSumSaleGroupByFofoIdsForMobileOrAccessories(
-		fofoId, curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), Optional.of(false));
+				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()
+				.selectValueOfActivatedImeis(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId).stream()
-		.collect(Collectors.toMap(x -> x.getBrand(), x -> (double) x.getSellingPrice()));
+				.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),
+				.selectValueOfActivatedImeis(curDate.withDayOfMonth(1).minusMonths(1),
-		curDate.with(LocalTime.MAX).minusMonths(1), fofoId)
+						curDate.with(LocalTime.MAX).minusMonths(1), fofoId)
-		.stream().collect(Collectors.toMap(x -> x.getBrand(), x -> (double) x.getSellingPrice()));
+				.stream().collect(Collectors.toMap(x -> x.getBrand(), x -> (double) x.getSellingPrice()));
 		Map<String, Double> lmtdBrandWiseSale = fofoOrderItemRepository.selectSumAmountGroupByBrand(
-		curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1), fofoId);
+				curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1), fofoId);
 		activatedImeisWithSellingPriceLMTD.put("Lava", lmtdBrandWiseSale.get("Lava"));
 		Map<Integer, Double> accesorieslmtdsale = fofoOrderRepository.selectSumSaleGroupByFofoIdsForMobileOrAccessories(
-		fofoId, curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1),
+				fofoId, curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1),
-		Optional.of(false));
+				Optional.of(false));
 		lmtdBrandWiseSale.put("Accessories", accesorieslmtdsale.get(fofoId));
 		ChartModel cm = new ChartModel();
-		 HashSet<String> labels = new HashSet<String>();
+		HashSet<String> labels = new HashSet<String>();
-		 labels.addAll(brandwisesale.keySet());
+		labels.addAll(brandwisesale.keySet());
-		 labels.addAll(lmtdBrandWiseSale.keySet());
+		labels.addAll(lmtdBrandWiseSale.keySet());
-		 List<String> labelList = new ArrayList<>(labels);
+		List<String> labelList = new ArrayList<>(labels);
-		 List<Double> mtdActivatedImeisValues = new ArrayList<>();
+		List<Double> mtdActivatedImeisValues = new ArrayList<>();
-		 List<Double> mtdValues = new ArrayList<>();
+		List<Double> mtdValues = new ArrayList<>();
-		 List<Double> lmtdUnActivatedImeisValues = new ArrayList<>();
+		List<Double> lmtdUnActivatedImeisValues = new ArrayList<>();
-		 List<Double> lmtdActivatedImeisValues = new ArrayList<>();
+		List<Double> lmtdActivatedImeisValues = new ArrayList<>();
-		 List<Double> mtdUnActivatedImeisValues = new ArrayList<>();
+		List<Double> mtdUnActivatedImeisValues = new ArrayList<>();
-		 List<Double> lmtdValues = new ArrayList<>();
+		List<Double> lmtdValues = new ArrayList<>();
-		 for (String label : labelList) {
+		for (String label : labelList) {
-		 mtdActivatedImeisValues.add(activatedImeisWithSellingPriceMTD.get(label) == null ? 0
+			mtdActivatedImeisValues.add(activatedImeisWithSellingPriceMTD.get(label) == null ? 0
-		 : activatedImeisWithSellingPriceMTD.get(label));
+					: activatedImeisWithSellingPriceMTD.get(label));
-		 lmtdActivatedImeisValues.add(activatedImeisWithSellingPriceLMTD.get(label) == null ? 0
+			lmtdActivatedImeisValues.add(activatedImeisWithSellingPriceLMTD.get(label) == null ? 0
-		 : activatedImeisWithSellingPriceLMTD.get(label));
+					: activatedImeisWithSellingPriceLMTD.get(label));
-		 mtdValues.add(brandwisesale.get(label) == null ? 0 : brandwisesale.get(label));
+			mtdValues.add(brandwisesale.get(label) == null ? 0 : brandwisesale.get(label));
-		 if (brandwisesale.get(label) != null) {
+			if (brandwisesale.get(label) != null) {
-		 mtdUnActivatedImeisValues
+				mtdUnActivatedImeisValues
-		 .add(brandwisesale.get(label) - (activatedImeisWithSellingPriceMTD.get(label) == null ? 0
+						.add(brandwisesale.get(label) - (activatedImeisWithSellingPriceMTD.get(label) == null ? 0
-		 : activatedImeisWithSellingPriceMTD.get(label)));
+								: activatedImeisWithSellingPriceMTD.get(label)));
-		 } else {
+			} else {
-		 mtdUnActivatedImeisValues.add(0.0);
+				mtdUnActivatedImeisValues.add(0.0);
-		 }
+			}
-		 if (lmtdBrandWiseSale.get(label) != null) {
+			if (lmtdBrandWiseSale.get(label) != null) {
-		 lmtdUnActivatedImeisValues
+				lmtdUnActivatedImeisValues
-		 .add(lmtdBrandWiseSale.get(label) - (activatedImeisWithSellingPriceLMTD.get(label) == null ? 0
+						.add(lmtdBrandWiseSale.get(label) - (activatedImeisWithSellingPriceLMTD.get(label) == null ? 0
-		 : activatedImeisWithSellingPriceLMTD.get(label)));
+								: activatedImeisWithSellingPriceLMTD.get(label)));
-		 } else {
+			} else {
-		 lmtdUnActivatedImeisValues.add(0.0);
+				lmtdUnActivatedImeisValues.add(0.0);
-		 }
+			}
-		 lmtdValues.add(lmtdBrandWiseSale.get(label) == null ? 0 : lmtdBrandWiseSale.get(label));
+			lmtdValues.add(lmtdBrandWiseSale.get(label) == null ? 0 : lmtdBrandWiseSale.get(label));
-		 }
+		}
-		 DatasetModel dsmtotal = new DatasetModel();
+		DatasetModel dsmtotal = new DatasetModel();
-		 dsmtotal.setLabel("MTD");
+		dsmtotal.setLabel("MTD");
-		 dsmtotal.setBackgroundColor("blue");
+		dsmtotal.setBackgroundColor("blue");
-		 dsmtotal.setBorderColor("blue");
+		dsmtotal.setBorderColor("blue");
-		 dsmtotal.setData(mtdValues);
+		dsmtotal.setData(mtdValues);
-		 dsmtotal.setStack("stack0");
+		dsmtotal.setStack("stack0");
-		 dsmtotal.setOrder(1);
+		dsmtotal.setOrder(1);
-		 DatasetModel dsmUnactivated = new DatasetModel();
+		DatasetModel dsmUnactivated = new DatasetModel();
-		 dsmUnactivated.setLabel("MTD Unactivated");
+		dsmUnactivated.setLabel("MTD Unactivated");
-		 dsmUnactivated.setBackgroundColor("red");
+		dsmUnactivated.setBackgroundColor("red");
-		 dsmUnactivated.setBorderColor("red");
+		dsmUnactivated.setBorderColor("red");
-		 dsmUnactivated.setData(mtdUnActivatedImeisValues);
+		dsmUnactivated.setData(mtdUnActivatedImeisValues);
-		 dsmUnactivated.setStack("stack0");
+		dsmUnactivated.setStack("stack0");
-		 dsmUnactivated.setOrder(1);
+		dsmUnactivated.setOrder(1);
-		 LOGGER.info("mtdValuesMoney" + mtdValues);
+		LOGGER.info("mtdValuesMoney" + mtdValues);
-		 DatasetModel mtdActivatedImeis = new DatasetModel();
+		DatasetModel mtdActivatedImeis = new DatasetModel();
-		 mtdActivatedImeis.setLabel("MTD Activation");
+		mtdActivatedImeis.setLabel("MTD Activation");
-		 mtdActivatedImeis.setBorderColor("#00008b");
+		mtdActivatedImeis.setBorderColor("#00008b");
-		 mtdActivatedImeis.setData(mtdActivatedImeisValues);
+		mtdActivatedImeis.setData(mtdActivatedImeisValues);
-		 mtdActivatedImeis.setBackgroundColor("#00008b");
+		mtdActivatedImeis.setBackgroundColor("#00008b");
-		 mtdActivatedImeis.setStack("stack0");
+		mtdActivatedImeis.setStack("stack0");
-		 mtdActivatedImeis.setOrder(1);
+		mtdActivatedImeis.setOrder(1);
-		 DatasetModel lmtddsmtotal = new DatasetModel();
+		DatasetModel lmtddsmtotal = new DatasetModel();
-		 lmtddsmtotal.setLabel("LMTD");
+		lmtddsmtotal.setLabel("LMTD");
-		 lmtddsmtotal.setBackgroundColor("blue");
+		lmtddsmtotal.setBackgroundColor("blue");
-		 lmtddsmtotal.setData(lmtdValues);
+		lmtddsmtotal.setData(lmtdValues);
-		 lmtddsmtotal.setBorderColor("blue");
+		lmtddsmtotal.setBorderColor("blue");
-		 lmtddsmtotal.setStack("stack1");
+		lmtddsmtotal.setStack("stack1");
-		 lmtddsmtotal.setOrder(1);
+		lmtddsmtotal.setOrder(1);
-		 DatasetModel lmtdUnActivated = new DatasetModel();
+		DatasetModel lmtdUnActivated = new DatasetModel();
-		 lmtdUnActivated.setLabel("LMTD Unactivation");
+		lmtdUnActivated.setLabel("LMTD Unactivation");
-		 lmtdUnActivated.setBackgroundColor("red");
+		lmtdUnActivated.setBackgroundColor("red");
-		 lmtdUnActivated.setBorderColor("red");
+		lmtdUnActivated.setBorderColor("red");
-		 lmtdUnActivated.setData(lmtdUnActivatedImeisValues);
+		lmtdUnActivated.setData(lmtdUnActivatedImeisValues);
-		 lmtdUnActivated.setStack("stack1");
+		lmtdUnActivated.setStack("stack1");
-		 lmtdUnActivated.setOrder(1);
+		lmtdUnActivated.setOrder(1);
-		 DatasetModel LmtdActivatedImeis = new DatasetModel();
+		DatasetModel LmtdActivatedImeis = new DatasetModel();
-		 LmtdActivatedImeis.setLabel("LMTD Activation");
+		LmtdActivatedImeis.setLabel("LMTD Activation");
-		 LmtdActivatedImeis.setBackgroundColor("#87ceeb");
+		LmtdActivatedImeis.setBackgroundColor("#87ceeb");
-		 LmtdActivatedImeis.setBorderColor("#87ceeb");
+		LmtdActivatedImeis.setBorderColor("#87ceeb");
-		 LmtdActivatedImeis.setData(lmtdActivatedImeisValues);
+		LmtdActivatedImeis.setData(lmtdActivatedImeisValues);
-		 LmtdActivatedImeis.setStack("stack1");
+		LmtdActivatedImeis.setStack("stack1");
-		 LmtdActivatedImeis.setOrder(1);
+		LmtdActivatedImeis.setOrder(1);
-		 DatasetModel linemtdChart = new DatasetModel();
+		DatasetModel linemtdChart = new DatasetModel();
-		 linemtdChart.setLabel("MTD");
+		linemtdChart.setLabel("MTD");
-		 linemtdChart.setBackgroundColor("#006400");
+		linemtdChart.setBackgroundColor("#006400");
-		 linemtdChart.setBorderColor("#006400");
+		linemtdChart.setBorderColor("#006400");
-		 linemtdChart.setData(mtdValues);
+		linemtdChart.setData(mtdValues);
-		 linemtdChart.setType("line");
+		linemtdChart.setType("line");
-		 linemtdChart.setOrder(2);
+		linemtdChart.setOrder(2);
-		 linemtdChart.setFill("false");
+		linemtdChart.setFill("false");
-		 DatasetModel lineLmtdChart = new DatasetModel();
+		DatasetModel lineLmtdChart = new DatasetModel();
-		 lineLmtdChart.setLabel("LMTD");
+		lineLmtdChart.setLabel("LMTD");
-		 lineLmtdChart.setBackgroundColor("hotpink");
+		lineLmtdChart.setBackgroundColor("hotpink");
-		 lineLmtdChart.setBorderColor("hotpink");
+		lineLmtdChart.setBorderColor("hotpink");
-		 lineLmtdChart.setData(lmtdValues);
+		lineLmtdChart.setData(lmtdValues);
-		 lineLmtdChart.setType("line");
+		lineLmtdChart.setType("line");
-		 lineLmtdChart.setOrder(3);
+		lineLmtdChart.setOrder(3);
-		 lineLmtdChart.setFill("false");
+		lineLmtdChart.setFill("false");
-		 List<DatasetModel> datasets = new ArrayList<>();
+		List<DatasetModel> datasets = new ArrayList<>();
-		 datasets.add(mtdActivatedImeis);
+		datasets.add(mtdActivatedImeis);
-		 datasets.add(dsmUnactivated);
+		datasets.add(dsmUnactivated);
-		 datasets.add(LmtdActivatedImeis);
+		datasets.add(LmtdActivatedImeis);
-		 datasets.add(lmtdUnActivated);
+		datasets.add(lmtdUnActivated);
-		 datasets.add(linemtdChart);
+		datasets.add(linemtdChart);
-		 datasets.add(lineLmtdChart);
+		datasets.add(lineLmtdChart);
-		 DataModel dm = new DataModel();
+		DataModel dm = new DataModel();
-		 dm.setDatasets(datasets);
+		dm.setDatasets(datasets);
-		 dm.setLabels(labels);
+		dm.setLabels(labels);
-		 Tooltips tooltips = new Tooltips();
+		Tooltips tooltips = new Tooltips();
-			tooltips.setBodyFontSize(10);
+		tooltips.setBodyFontSize(10);
-			tooltips.setTitleFontSize(10);
+		tooltips.setTitleFontSize(10);
-			tooltips.setMode("index");
+		tooltips.setMode("index");
-			tooltips.setIntersect(false);
+		tooltips.setIntersect(false);
-			HoverModel hover = new HoverModel();
+		HoverModel hover = new HoverModel();
-			hover.setIntersect(false);
+		hover.setIntersect(false);
-			hover.setMode("index");
+		hover.setMode("index");
-		 LegendModel lm = new LegendModel();
+		LegendModel lm = new LegendModel();
-		 lm.setPosition("top");
+		lm.setPosition("top");
-		 TitleModel tm = new TitleModel();
+		TitleModel tm = new TitleModel();
-		 tm.setText("Brand Wise Sales");
+		tm.setText("Brand Wise Sales");
-		 tm.setDisplay(true);
+		tm.setDisplay(true);
-		 tm.setFontSize(20);
+		tm.setFontSize(20);
-	        tm.setFontColor("#111");
+		tm.setFontColor("#111");
-		 List<Axis> xAxes = new ArrayList<>();
+		List<Axis> xAxes = new ArrayList<>();
-		 Axis xAxis = new Axis();
+		Axis xAxis = new Axis();
-		 xAxis.setStacked(true);
+		xAxis.setStacked(true);
-		 xAxes.add(xAxis);
+		xAxes.add(xAxis);
-		 List<Axis> yAxes = new ArrayList<>();
+		List<Axis> yAxes = new ArrayList<>();
-		 Axis yAxis = new Axis();
+		Axis yAxis = new Axis();
-		 yAxis.setStacked(false);
+		yAxis.setStacked(false);
-		 yAxes.add(yAxis);
+		yAxes.add(yAxis);
-		 ScalesModel sm = new ScalesModel();
+		ScalesModel sm = new ScalesModel();
-		 sm.setxAxes(xAxes);
+		sm.setxAxes(xAxes);
-		 OptionsModel om = new OptionsModel();
-		 om.setLegend(lm);
-		 om.setTitle(tm);
-		 om.setScales(sm);
-		 om.setHover(hover);
-		 om.setTooltips(tooltips);
-		 cm.setType("bar");
-		 cm.setData(dm);
-		 cm.setOptions(om);
+		OptionsModel om = new OptionsModel();
+		om.setLegend(lm);
+		om.setTitle(tm);
-		 LOGGER.info("cm" + cm);
+		om.setScales(sm);
+		om.setHover(hover);
+		om.setTooltips(tooltips);
+		cm.setType("bar");
+		cm.setData(dm);
+		cm.setOptions(om);
-		 return cm;
+		LOGGER.info("cm" + cm);
-		 }
+		return cm;
+	}
 	private String adminPanel(int fofoId, String email, Model model) throws Exception {
 		List<Menu> menus = null;
 		try {
 			AuthUser authUser = authRepository.selectByEmailOrMobile(email);

Subversion Repositories SmartDukaan

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