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

 import java.io.FileInputStream;
 import java.io.FileNotFoundException;
 import java.io.FileOutputStream;
 import java.io.ObjectInputStream;
 import java.io.ObjectOutputStream;
+import java.text.DateFormat;
+import java.text.SimpleDateFormat;
 import java.time.LocalDate;
 import java.time.LocalDateTime;
 import java.time.LocalTime;
 import java.time.Month;
 import java.time.Period;
 import java.time.ZoneOffset;
 import java.time.format.DateTimeFormatter;
 import java.util.ArrayList;
 import java.util.Arrays;
 import java.util.Collection;
+import java.util.Collections;
 import java.util.Comparator;
+import java.util.Date;
 import java.util.HashMap;
 import java.util.HashSet;
 import java.util.LinkedHashMap;
 import java.util.LinkedHashSet;
 import java.util.List;
+import java.util.Locale;
 import java.util.Map;
 import java.util.Map.Entry;
 import java.util.Optional;
 import java.util.Set;
 import java.util.TreeMap;
 import com.spice.profitmandi.dao.model.InStockBrandModel;
 import com.spice.profitmandi.dao.model.ItemWiseTertiaryModel;
 import com.spice.profitmandi.dao.model.MonthSaleModel;
 import com.spice.profitmandi.dao.model.PartnerDetailModel;
 import com.spice.profitmandi.dao.model.PartnerPendingIndentItemModel;
+import com.spice.profitmandi.dao.model.PriceDropWithDetailsByYearMonthModel;
 import com.spice.profitmandi.dao.model.PriceDropYearMonthModel;
 import com.spice.profitmandi.dao.model.SecondaryOrderBilledLmsModel;
 import com.spice.profitmandi.dao.model.SimpleCampaign;
 import com.spice.profitmandi.dao.model.SimpleCampaignParams;
 import com.spice.profitmandi.dao.model.WarehouseBrandItemUnbilledActivatedModel;
 		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 = "/getMonthlyPurchaseLineChart", method = RequestMethod.GET)
 	public String getMonthlyPurchaseLineChart(HttpServletRequest request, Model model) throws Exception {
 		model.addAttribute("chartMap", gson.toJson(cm));
 		return "bar_chart";
+	}
-	@RequestMapping(value = "/getMonthlyPriceDrop", method = RequestMethod.GET)
+	@RequestMapping(value = "/getMonthlyPriceDropTab", method = RequestMethod.GET)
 	public String getMonthlyPriceDrop(HttpServletRequest request, Model model) throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		int fofoId = loginDetails.getFofoId();
 		ChartModel cm = this.getMonthlyPriceDrop(fofoId);
 		model.addAttribute("chartMap", gson.toJson(cm));
 		return "price_drop_chart";
+	}
+	@RequestMapping(value = "/getPriceDropDetails", method = RequestMethod.GET)
+	public String getPriceDropDetails(HttpServletRequest request,
+			@RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId,
+			@RequestParam(name = "brand", required = true, defaultValue = "0") String brand,
+			@RequestParam(name = "yearMonth", required = true, defaultValue = "0") String yearMonth, Model model)
+			throws Exception {
+		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
+		LOGGER.info("params" + fofoId + brand + yearMonth);
+		List<PriceDropWithDetailsByYearMonthModel> priceDropdetailsList = priceDropRepository
+				.selectBrandPendingPriceDropWithDetailsByYearMonth(fofoId, brand, yearMonth);
+		LOGGER.info("priceDropdetailsList" + priceDropdetailsList);
+		model.addAttribute("priceDropdetailsList", priceDropdetailsList);
+		return "price-drop-details";
+	}
+	@RequestMapping(value = "/getMonthlyPriceDrop", method = RequestMethod.GET)
+	public String getMonthlyPriceDropTabular(HttpServletRequest request, Model model) throws Exception {
+		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
+		int fofoId = loginDetails.getFofoId();
+		LocalDateTime curDate = LocalDate.now().atStartOfDay();
+		LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(6);
+		List<YearMonth> ym = new ArrayList<YearMonth>();
+		for (int i = 1; i <= 6; i++) {
+			ym.add(YearMonth.from(curDate.withDayOfMonth(1).minusMonths(i)));
+		}
+		Collections.reverse(ym);
+		model.addAttribute("ym", ym);
+		LOGGER.info("ym" + ym);
+		List<PriceDropYearMonthModel> priceDropYearMonthModels = priceDropRepository
+				.selectBrandPendingPriceDropByYearMonth(fofoId, startOfMonth);
+		DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-yyyy");
+		Map<String, Map<YearMonth, Double>> brandMonthValue = new HashMap<>();
+		LOGGER.info("priceDropYearMonthModels" + priceDropYearMonthModels);
+		for (PriceDropYearMonthModel pdm : priceDropYearMonthModels) {
+			Map<YearMonth, Double> brandValue = new HashMap<>();
+			if (brandMonthValue.containsKey(pdm.getBrand())) {
+				brandValue = brandMonthValue.get(pdm.getBrand());
+				brandValue.put(YearMonth.parse(pdm.getYearMonth(), dateTimeFormatter), (double) pdm.getAmount());
+			} else {
+				brandValue.put(YearMonth.parse(pdm.getYearMonth(), dateTimeFormatter), (double) pdm.getAmount());
+			}
+			brandMonthValue.put(pdm.getBrand(), brandValue);
+		}
+		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");
+		Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
+		for (String brand : brands) {
+			Map<YearMonth, Double> yearMonthValue = brandMonthValue.get(brand);
+			for (int i = 6; 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()));
+		}
+		Map<String, List<Double>> brandValues = new LinkedHashMap<>();
+		for (Entry<String, List<Double>> vv : sortedBrandValue.entrySet()) {
+			Double total = vv.getValue().stream().mapToDouble(x -> x.doubleValue()).sum();
+			if (total != 0.0) {
+				brandValues.put(vv.getKey(), vv.getValue());
+			}
+			LOGGER.info("total" + total);
+		}
+		LOGGER.info("sortedBrandValue" + brandValues);
+		model.addAttribute("fofoId", fofoId);
+		model.addAttribute("sortedBrandValue", brandValues);
+		return "price-drop-tabular";
+	}
 	private ChartModel getMonthlyPriceDrop(int fofoId) throws ProfitMandiBusinessException {
 		LocalDateTime curDate = LocalDate.now().atStartOfDay();
 		LocalDateTime startOfMonth = curDate.withDayOfMonth(1).minusMonths(6);
 		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)));
 			Map<String, Double> valbrand = sortedMonthBrandValue.get(YearMonth.from(startMonth));
 			for (String brand : brands) {
 				if (valbrand != null) {
 					if (!valbrand.containsKey(brand)) {
 		borderList.add("#ff8c69");
 		borderList.add("#0000cd");
 		borderList.add("lightsalmon");
 		borderList.add("#0000cd");
 		borderList.add("cornsilk");
 		int i = 0;

Subversion Repositories SmartDukaan

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