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

 import java.time.YearMonth;
 import java.time.ZoneOffset;
 import java.time.format.DateTimeFormatter;
 import java.util.ArrayList;
 import java.util.Arrays;
+import java.util.Collection;
 import java.util.Comparator;
 import java.util.HashMap;
 import java.util.HashSet;
 import java.util.LinkedHashMap;
+import java.util.LinkedHashSet;
 import java.util.List;
 import java.util.Map;
 import java.util.Map.Entry;
 import java.util.Optional;
 import java.util.Set;
+import java.util.TreeMap;
 import java.util.stream.Collectors;
 import javax.servlet.http.HttpServletRequest;
 import javax.transaction.Transactional;
 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 org.springframework.ui.Model;
 import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.bind.annotation.RequestMethod;
 import org.springframework.web.bind.annotation.RequestParam;
+import com.google.common.collect.ArrayListMultimap;
+import com.google.common.collect.Multimap;
 import com.google.gson.Gson;
 import com.mongodb.DBObject;
 import com.spice.profitmandi.common.enumuration.ContentType;
 import com.spice.profitmandi.common.enumuration.MessageType;
 import com.spice.profitmandi.common.enumuration.ReporticoProject;
 import com.spice.profitmandi.common.model.ChartModel;
 import com.spice.profitmandi.common.model.CustomRetailer;
 import com.spice.profitmandi.common.model.Data;
 import com.spice.profitmandi.common.model.DataInvestmentModel;
 import com.spice.profitmandi.common.model.DataModel;
 import com.spice.profitmandi.common.model.DatasetModel;
 import com.spice.profitmandi.common.model.Legend;
 import com.spice.profitmandi.common.model.LegendModel;
 import com.spice.profitmandi.common.model.Notification;
 import com.spice.profitmandi.common.model.OnlineDeliveredOrderSum;
 import com.spice.profitmandi.common.model.OptionModel;
 import com.spice.profitmandi.common.model.OptionsModel;
 import com.spice.profitmandi.common.model.PieLables;
+import com.spice.profitmandi.common.model.PluginsModel;
 import com.spice.profitmandi.common.model.ProfitMandiConstants;
 import com.spice.profitmandi.common.model.ScalesModel;
 import com.spice.profitmandi.common.model.TitleModel;
 import com.spice.profitmandi.common.web.util.ResponseSender;
 import com.spice.profitmandi.dao.Interface.Campaign;
 	@Value("${web.api.root}")
 	private String webApiRoot;
 	@Value("${web.api.port}")
 	private int webApiPort;
 	@Autowired
 	private CookiesProcessor cookiesProcessor;
 	@Autowired
 	private PendingOrderRepository pendingOrderRepository;
 	InventoryService inventoryService;
 	@Autowired
 	private PendingOrderItemRepository pendingOrderItemRepository;
 	@Autowired
 	private CurrentInventorySnapshotRepository currentInventorySnapshotRepository;
 	@Autowired
 	private FofoOrderItemRepository fofoOrderItemRepository;
 		} catch (ProfitMandiBusinessException e) {
 			LOGGER.error("FofoStore Code not found of fofoId {}", fofoId);
+		}
-			return "12dashboard34";
+		return "12dashboard34";
+	}
 	private Map<String, Object> getInvestments(int fofoId) throws Exception {
 		Map<String, Object> investments = new LinkedHashMap<>();
 		PartnerDailyInvestment investment = partnerInvestmentService.getInvestment(fofoId, 0);
 	@RequestMapping(value = "/dashboard", method = RequestMethod.GET)
 	public String dashboard(HttpServletRequest request, Model model) throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		String email = loginDetails.getEmailId();
-		int fofoId =  loginDetails.getFofoId();
+		int fofoId = loginDetails.getFofoId();
-	LocalDateTime startDate =	LocalDate.now().withDayOfYear(1).atStartOfDay();
-	LocalDateTime endtDate  =   LocalDateTime.now();
-	LOGGER.info("startDate"+startDate);
-	LOGGER.info("endtDate"+endtDate);
-	OnlineDeliveredOrderSum onlineDeliveredOrderSum= 	pendingOrderItemRepository.selectSumSellingPriceOnlineOrder(fofoId, startDate, endtDate);
-	LOGGER.info("onlineDeliveredOrderSum"+onlineDeliveredOrderSum.getSellingPrice());
+		LocalDateTime startDate = LocalDate.now().withDayOfYear(1).atStartOfDay();
+		LocalDateTime endtDate = LocalDateTime.now();
+		OnlineDeliveredOrderSum onlineDeliveredOrderSum = pendingOrderItemRepository
+				.selectSumSellingPriceOnlineOrder(fofoId, startDate, endtDate);
+		LOGGER.info("onlineDeliveredOrderSum" + onlineDeliveredOrderSum.getSellingPrice());
-	long countOrder =	pendingOrderRepository.pendingOrderCount(fofoId, OrderStatus.PROCESSING);
+		long countOrder = pendingOrderRepository.pendingOrderCount(fofoId, OrderStatus.PROCESSING);
-		LOGGER.info("countOrder"+countOrder);
+		LOGGER.info("countOrder" + countOrder);
 		model.addAttribute("countOrder", countOrder);
 		model.addAttribute("onlineDeliveredOrderSum", onlineDeliveredOrderSum.getSellingPrice());
 		boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
 		model.addAttribute("isAdmin", isAdmin);
 		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)
 			@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;
 				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),
+		long hygieneCount = hygieneDataRepository.selectHygieneCount(loginDetails.getFofoId(), true,
-				currentMonthEnd.minusMonths(month));
+				currentMonthStart.minusMonths(month), currentMonthEnd.minusMonths(month));
 		long invalidHygieneCount = hygieneDataRepository.selectHygieneCount(loginDetails.getFofoId(), false,
-				currentMonthStart.minusMonths(month),
+				currentMonthStart.minusMonths(month), currentMonthEnd.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("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);
+		model.addAttribute("month", month);
 		return "performance";
+	}
 	@RequestMapping(value = "/investmentDetails", method = RequestMethod.GET)
 	public String getInvestmentDetails(HttpServletRequest request, Model model) throws Exception {
 		LOGGER.info("InvestmentChart" + gson.toJson(cm));
 		LOGGER.info("InvestmentChart" + cm);
 		return "investmentdetails";
+	}
+	@RequestMapping(value = "/getlmsLineChart", method = RequestMethod.GET)
+	public String getlmsLineChart(HttpServletRequest request, Model model) throws Exception {
+		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
+		int fofoId = loginDetails.getFofoId();
+		ChartModel cm = this.getLmsLineChart(loginDetails.getFofoId());
+		LOGGER.info("linechartMap" + gson.toJson(cm));
+		model.addAttribute("linechartMap", gson.toJson(cm));
+		return "lmsLineChart";
+	}
+	@RequestMapping(value = "/getBarChart", method = RequestMethod.GET)
+	public String getBarChart(HttpServletRequest request, Model model) throws Exception {
+		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
+		int fofoId = loginDetails.getFofoId();
+		ChartModel cm = this.getBrandChart(fofoId);
+		LOGGER.info("chartMap" + gson.toJson(cm));
+		model.addAttribute("chartMap", gson.toJson(cm));
+		return "bar_chart";
+	}
 	private ChartInvestmentModel getInvestmentChart(int fofoId) throws ProfitMandiBusinessException {
 		PartnerDailyInvestment investment = partnerInvestmentService.getInvestment(fofoId, 0);
 		Map<String, Float> investmentWalletAmount = new HashMap<>();
 		cm.setOptions(om);
 		return cm;
+	}
-	private ChartModel getBrandChart(int fofoId) {
+	private ChartModel getLmsLineChart(int fofoId) throws ProfitMandiBusinessException {
 		LocalDateTime curDate = LocalDate.now().atStartOfDay();
-		LOGGER.info("cur Date" + curDate.withDayOfMonth(1));
+		Map<YearMonth, Map<String, Double>> monthValueMap = new HashMap<>();
-		LOGGER.info("curDateYear" + curDate.with(LocalTime.MAX));
+		for (int i = 1; i <= 6; i++) {
-		Map<String, Double> brandwisesale = fofoOrderItemRepository
-				.selectSumAmountGroupByBrand(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId);
+			LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(i);
-		LOGGER.info("brandwisesale" + brandwisesale);
+			Map<String, Double> lmsBrandWiseSale = fofoOrderItemRepository.selectSumAmountGroupByBrand(
+					curDate.withDayOfMonth(1).minusMonths(i), curDate.withDayOfMonth(1).minusMonths(i - 1), fofoId);
-		Map<Integer, Double> accesoriesmtdsale = fofoOrderRepository.selectSumSaleGroupByFofoIdsForMobileOrAccessories(
+			Map<Integer, Double> accesorieslmsSale = fofoOrderRepository
+					.selectSumSaleGroupByFofoIdsForMobileOrAccessories(fofoId, curDate.withDayOfMonth(1).minusMonths(i),
-				fofoId, curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), Optional.of(false));
+							curDate.withDayOfMonth(1).minusMonths(i - 1), Optional.of(false));
-		brandwisesale.put("Accessories", accesoriesmtdsale.get(fofoId));
+			LOGGER.info("lmsBrandWiseSale" + lmsBrandWiseSale);
-		Map<String, Double> activatedImeisWithSellingPriceMTD = fofoOrderRepository
+			lmsBrandWiseSale.put("Accessories", accesorieslmsSale.get(fofoId));
-				.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"));
+			monthValueMap.put(YearMonth.from(startOfMonth), lmsBrandWiseSale);
+		}
+		LOGGER.info("monthmap" + monthValueMap);
-		Map<String, Double> activatedImeisWithSellingPriceLMTD = fofoOrderRepository
+		Map<YearMonth, Map<String, Double>> sortedMonthValueMap = new TreeMap(monthValueMap);
-				.selectValueOfActivatedImeis(curDate.withDayOfMonth(1).minusMonths(1),
-						curDate.with(LocalTime.MAX).minusMonths(1), fofoId)
+		LOGGER.info("monthmap" + sortedMonthValueMap);
-				.stream().collect(Collectors.toMap(x -> x.getBrand(), x -> (double) x.getSellingPrice()));
-		Map<String, Double> lmtdBrandWiseSale = fofoOrderItemRepository.selectSumAmountGroupByBrand(
+		Multimap<String, Map<YearMonth, Double>> brandMonthValueMap = ArrayListMultimap.create();
-				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),
+		for (Entry<YearMonth, Map<String, Double>> month : sortedMonthValueMap.entrySet()) {
-				Optional.of(false));
-		lmtdBrandWiseSale.put("Accessories", accesorieslmtdsale.get(fofoId));
+			for (Entry<String, Double> val : month.getValue().entrySet()) {
+				Map<YearMonth, Double> yearValue = new HashMap<>();
+				yearValue.put(month.getKey(), val.getValue() == null ? 0 : val.getValue());
-		ChartModel cm = new ChartModel();
+				brandMonthValueMap.put(val.getKey(), yearValue);
-		HashSet<String> labels = new HashSet<String>();
-		labels.addAll(brandwisesale.keySet());
+			}
-		labels.addAll(lmtdBrandWiseSale.keySet());
+		}
+		LOGGER.info("map" + brandMonthValueMap);
+		Map<String, List<Double>> brandlistValue = new HashMap<>();
-		List<String> labelList = new ArrayList<>(labels);
+		List<String> brands = new ArrayList<>();
+		for (String bwr : brandMonthValueMap.keys()) {
+			if (!brands.contains(bwr)) {
+				brands.add(bwr);
+			}
+		}
-		List<Double> mtdActivatedImeisValues = new ArrayList<>();
+		LOGGER.info("brands" + brands);
-		List<Double> mtdValues = new ArrayList<>();
-		List<Double> lmtdUnActivatedImeisValues = new ArrayList<>();
-		List<Double> lmtdActivatedImeisValues = new ArrayList<>();
-		List<Double> mtdUnActivatedImeisValues = new ArrayList<>();
-		List<Double> lmtdValues = new ArrayList<>();
-		for (String label : labelList) {
+		for (String brand : brands) {
-			mtdActivatedImeisValues.add(activatedImeisWithSellingPriceMTD.get(label) == null ? 0
-					: activatedImeisWithSellingPriceMTD.get(label));
-			lmtdActivatedImeisValues.add(activatedImeisWithSellingPriceLMTD.get(label) == null ? 0
-					: activatedImeisWithSellingPriceLMTD.get(label));
-			mtdValues.add(brandwisesale.get(label) == null ? 0 : brandwisesale.get(label));
+			Collection<Map<YearMonth, Double>> coll = brandMonthValueMap.get(brand);
-			if (brandwisesale.get(label) != null) {
-				mtdUnActivatedImeisValues
-						.add(brandwisesale.get(label) - (activatedImeisWithSellingPriceMTD.get(label) == null ? 0
-								: activatedImeisWithSellingPriceMTD.get(label)));
-			} else {
-				mtdUnActivatedImeisValues.add(0.0);
-			}
-			if (lmtdBrandWiseSale.get(label) != null) {
-				lmtdUnActivatedImeisValues
-						.add(lmtdBrandWiseSale.get(label) - (activatedImeisWithSellingPriceLMTD.get(label) == null ? 0
-								: activatedImeisWithSellingPriceLMTD.get(label)));
-			} else {
-				lmtdUnActivatedImeisValues.add(0.0);
-			}
-			lmtdValues.add(lmtdBrandWiseSale.get(label) == null ? 0 : lmtdBrandWiseSale.get(label));
-		}
-		DatasetModel dsmtotal = new DatasetModel();
-		dsmtotal.setLabel("MTD");
-		dsmtotal.setBackgroundColor("blue");
-		dsmtotal.setData(mtdValues);
-		dsmtotal.setStack("stack0");
-		dsmtotal.setOrder(1);
-		DatasetModel dsmUnactivated = new DatasetModel();
-		dsmUnactivated.setLabel("MTD Unactivated");
-		dsmUnactivated.setBackgroundColor("red");
-		dsmUnactivated.setData(mtdUnActivatedImeisValues);
-		dsmUnactivated.setStack("stack0");
-		dsmUnactivated.setOrder(1);
-		LOGGER.info("mtdValuesMoney" + mtdValues);
+			LOGGER.info("coll" + coll);
-		DatasetModel mtdActivatedImeis = new DatasetModel();
-		mtdActivatedImeis.setLabel("MTD Activation");
-		mtdActivatedImeis.setData(mtdActivatedImeisValues);
-		mtdActivatedImeis.setBackgroundColor("#00008b");
-		mtdActivatedImeis.setStack("stack0");
-		mtdActivatedImeis.setOrder(1);
-		DatasetModel lmtddsmtotal = new DatasetModel();
-		lmtddsmtotal.setLabel("LMTD");
-		lmtddsmtotal.setBackgroundColor("blue");
-		lmtddsmtotal.setData(lmtdValues);
-		lmtddsmtotal.setStack("stack1");
-		lmtddsmtotal.setOrder(1);
-		DatasetModel lmtdUnActivated = new DatasetModel();
+			List<Double> valueList = new ArrayList<>();
-		lmtdUnActivated.setLabel("LMTD Unactivation");
-		lmtdUnActivated.setBackgroundColor("red");
-		lmtdUnActivated.setData(lmtdUnActivatedImeisValues);
-		lmtdUnActivated.setStack("stack1");
-		lmtdUnActivated.setOrder(1);
-		DatasetModel LmtdActivatedImeis = new DatasetModel();
-		LmtdActivatedImeis.setLabel("LMTD Activation");
-		LmtdActivatedImeis.setBackgroundColor("#87ceeb");
-		LmtdActivatedImeis.setData(lmtdActivatedImeisValues);
-		LmtdActivatedImeis.setStack("stack1");
-		LmtdActivatedImeis.setOrder(1);
-		DatasetModel linemtdChart = new DatasetModel();
+			for (Map<YearMonth, Double> col : coll) {
-		linemtdChart.setLabel("MTD");
-		linemtdChart.setBackgroundColor("#006400");
-		linemtdChart.setData(mtdValues);
+				valueList.addAll(col.values());
-		linemtdChart.setType("line");
-		linemtdChart.setOrder(2);
-		linemtdChart.setFill("false");
+			}
-		DatasetModel lineLmtdChart = new DatasetModel();
-		lineLmtdChart.setLabel("LMTD");
-		lineLmtdChart.setBackgroundColor("hotpink");
-		lineLmtdChart.setData(lmtdValues);
-		lineLmtdChart.setType("line");
-		lineLmtdChart.setOrder(3);
-		lineLmtdChart.setFill("false");
+			brandlistValue.put(brand, valueList);
+		}
+		LOGGER.info("brandlistValue" + brandlistValue);
+		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<>();
-		datasets.add(mtdActivatedImeis);
+		colorList.add("darkorange");
+		colorList.add("#654321");
-		datasets.add(dsmUnactivated);
+		colorList.add("deeppink");
-		datasets.add(LmtdActivatedImeis);
+		colorList.add("darkgreen");
-		datasets.add(lmtdUnActivated);
+		colorList.add("darkred");
-		datasets.add(linemtdChart);
+		colorList.add("slateblue");
+		List<String> borderList = new ArrayList<>();
+		borderList.add("orange");
+		borderList.add("#DB8C44");
+		borderList.add("pink");
+		borderList.add("green");
+		borderList.add("red");
+		borderList.add("lightskyblue");
+		int i= 0;
+		for (Entry<String, List<Double>> brandValue : brandlistValue.entrySet()) {
+			DatasetModel lineLmsChart = new DatasetModel();
+			lineLmsChart.setLabel(brandValue.getKey());
+			lineLmsChart.setBackgroundColor(borderList.get(i));
+			lineLmsChart.setData(brandValue.getValue());
+			lineLmsChart.setType("line");
+			lineLmsChart.setOrder(1);
+			lineLmsChart.setFill("false");
+			lineLmsChart.setBorderColor(colorList.get(i));
-		datasets.add(lineLmtdChart);
+			datasets.add(lineLmsChart);
+			i++;
+		}
 		DataModel dm = new DataModel();
 		dm.setDatasets(datasets);
 		dm.setLabels(labels);
 		LegendModel lm = new LegendModel();
 		lm.setPosition("top");
 		TitleModel tm = new TitleModel();
-		tm.setText("Brand Wise Sales");
+		tm.setText("Brand Wise LMS");
 		tm.setDisplay(true);
-		List<Axis> xAxes = new ArrayList<>();
-		Axis xAxis = new Axis();
-		xAxis.setStacked(true);
-		xAxes.add(xAxis);
-		List<Axis> yAxes = new ArrayList<>();
-		Axis yAxis = new Axis();
-		yAxis.setStacked(false);
-		yAxes.add(yAxis);
-		ScalesModel sm = new ScalesModel();
-		sm.setxAxes(xAxes);
 		OptionsModel om = new OptionsModel();
+		om.setResponsive(true);
 		om.setLegend(lm);
 		om.setTitle(tm);
-		om.setScales(sm);
+		ChartModel cm = new ChartModel();
-		cm.setType("bar");
+		cm.setType("line");
 		cm.setData(dm);
 		cm.setOptions(om);
 		LOGGER.info("cm" + cm);
 		return cm;
+	}
+	private ChartModel getBrandChart(int fofoId) {
+		LocalDateTime curDate = LocalDate.now().atStartOfDay();
+		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);
+		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()));
+		Map<String, Double> lmtdBrandWiseSale = fofoOrderItemRepository.selectSumAmountGroupByBrand(
+		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),
+		Optional.of(false));
+		lmtdBrandWiseSale.put("Accessories", accesorieslmtdsale.get(fofoId));
+		ChartModel cm = new ChartModel();
+		 HashSet<String> labels = new HashSet<String>();
+		 labels.addAll(brandwisesale.keySet());
+		 labels.addAll(lmtdBrandWiseSale.keySet());
+		 List<String> labelList = new ArrayList<>(labels);
+		 List<Double> mtdActivatedImeisValues = new ArrayList<>();
+		 List<Double> mtdValues = new ArrayList<>();
+		 List<Double> lmtdUnActivatedImeisValues = new ArrayList<>();
+		 List<Double> lmtdActivatedImeisValues = new ArrayList<>();
+		 List<Double> mtdUnActivatedImeisValues = new ArrayList<>();
+		 List<Double> lmtdValues = new ArrayList<>();
+		 for (String label : labelList) {
+		 mtdActivatedImeisValues.add(activatedImeisWithSellingPriceMTD.get(label) == null ? 0
+		 : activatedImeisWithSellingPriceMTD.get(label));
+		 lmtdActivatedImeisValues.add(activatedImeisWithSellingPriceLMTD.get(label) == null ? 0
+		 : activatedImeisWithSellingPriceLMTD.get(label));
+		 mtdValues.add(brandwisesale.get(label) == null ? 0 : brandwisesale.get(label));
+		 if (brandwisesale.get(label) != null) {
+		 mtdUnActivatedImeisValues
+		 .add(brandwisesale.get(label) - (activatedImeisWithSellingPriceMTD.get(label) == null ? 0
+		 : activatedImeisWithSellingPriceMTD.get(label)));
+		 } else {
+		 mtdUnActivatedImeisValues.add(0.0);
+		 }
+		 if (lmtdBrandWiseSale.get(label) != null) {
+		 lmtdUnActivatedImeisValues
+		 .add(lmtdBrandWiseSale.get(label) - (activatedImeisWithSellingPriceLMTD.get(label) == null ? 0
+		 : activatedImeisWithSellingPriceLMTD.get(label)));
+		 } else {
+		 lmtdUnActivatedImeisValues.add(0.0);
+		 }
+		 lmtdValues.add(lmtdBrandWiseSale.get(label) == null ? 0 : lmtdBrandWiseSale.get(label));
+		 }
+		 DatasetModel dsmtotal = new DatasetModel();
+		 dsmtotal.setLabel("MTD");
+		 dsmtotal.setBackgroundColor("blue");
+		 dsmtotal.setBorderColor("blue");
+		 dsmtotal.setData(mtdValues);
+		 dsmtotal.setStack("stack0");
+		 dsmtotal.setOrder(1);
+		 DatasetModel dsmUnactivated = new DatasetModel();
+		 dsmUnactivated.setLabel("MTD Unactivated");
+		 dsmUnactivated.setBackgroundColor("red");
+		 dsmUnactivated.setBorderColor("red");
+		 dsmUnactivated.setData(mtdUnActivatedImeisValues);
+		 dsmUnactivated.setStack("stack0");
+		 dsmUnactivated.setOrder(1);
+		 LOGGER.info("mtdValuesMoney" + mtdValues);
+		 DatasetModel mtdActivatedImeis = new DatasetModel();
+		 mtdActivatedImeis.setLabel("MTD Activation");
+		 mtdActivatedImeis.setBorderColor("#00008b");
+		 mtdActivatedImeis.setData(mtdActivatedImeisValues);
+		 mtdActivatedImeis.setBackgroundColor("#00008b");
+		 mtdActivatedImeis.setStack("stack0");
+		 mtdActivatedImeis.setOrder(1);
+		 DatasetModel lmtddsmtotal = new DatasetModel();
+		 lmtddsmtotal.setLabel("LMTD");
+		 lmtddsmtotal.setBackgroundColor("blue");
+		 lmtddsmtotal.setData(lmtdValues);
+		 lmtddsmtotal.setBorderColor("blue");
+		 lmtddsmtotal.setStack("stack1");
+		 lmtddsmtotal.setOrder(1);
+		 DatasetModel lmtdUnActivated = new DatasetModel();
+		 lmtdUnActivated.setLabel("LMTD Unactivation");
+		 lmtdUnActivated.setBackgroundColor("red");
+		 lmtdUnActivated.setBorderColor("red");
+		 lmtdUnActivated.setData(lmtdUnActivatedImeisValues);
+		 lmtdUnActivated.setStack("stack1");
+		 lmtdUnActivated.setOrder(1);
+		 DatasetModel LmtdActivatedImeis = new DatasetModel();
+		 LmtdActivatedImeis.setLabel("LMTD Activation");
+		 LmtdActivatedImeis.setBackgroundColor("#87ceeb");
+		 LmtdActivatedImeis.setBorderColor("#87ceeb");
+		 LmtdActivatedImeis.setData(lmtdActivatedImeisValues);
+		 LmtdActivatedImeis.setStack("stack1");
+		 LmtdActivatedImeis.setOrder(1);
+		 DatasetModel linemtdChart = new DatasetModel();
+		 linemtdChart.setLabel("MTD");
+		 linemtdChart.setBackgroundColor("#006400");
+		 linemtdChart.setBorderColor("#006400");
+		 linemtdChart.setData(mtdValues);
+		 linemtdChart.setType("line");
+		 linemtdChart.setOrder(2);
+		 linemtdChart.setFill("false");
+		 DatasetModel lineLmtdChart = new DatasetModel();
+		 lineLmtdChart.setLabel("LMTD");
+		 lineLmtdChart.setBackgroundColor("hotpink");
+		 lineLmtdChart.setBorderColor("hotpink");
+		 lineLmtdChart.setData(lmtdValues);
+		 lineLmtdChart.setType("line");
+		 lineLmtdChart.setOrder(3);
+		 lineLmtdChart.setFill("false");
+		 List<DatasetModel> datasets = new ArrayList<>();
+		 datasets.add(mtdActivatedImeis);
+		 datasets.add(dsmUnactivated);
+		 datasets.add(LmtdActivatedImeis);
+		 datasets.add(lmtdUnActivated);
+		 datasets.add(linemtdChart);
+		 datasets.add(lineLmtdChart);
+		 DataModel dm = new DataModel();
+		 dm.setDatasets(datasets);
+		 dm.setLabels(labels);
+		 LegendModel lm = new LegendModel();
+		 lm.setPosition("top");
+		 TitleModel tm = new TitleModel();
+		 tm.setText("Brand Wise Sales");
+		 tm.setDisplay(true);
+		 List<Axis> xAxes = new ArrayList<>();
+		 Axis xAxis = new Axis();
+		 xAxis.setStacked(true);
+		 xAxes.add(xAxis);
+		 List<Axis> yAxes = new ArrayList<>();
+		 Axis yAxis = new Axis();
+		 yAxis.setStacked(false);
+		 yAxes.add(yAxis);
+		 ScalesModel sm = new ScalesModel();
+		 sm.setxAxes(xAxes);
+		 OptionsModel om = new OptionsModel();
+		 om.setLegend(lm);
+		 om.setTitle(tm);
+		 om.setScales(sm);
+		 cm.setType("bar");
+		 cm.setData(dm);
+		 cm.setOptions(om);
+		 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);
 			List<Position> positions = positionRepository.selectAll(authUser.getId());

Subversion Repositories SmartDukaan

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