WebSVN – SmartDukaan – Diff – /trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/AdminUser.java

 package com.spice.profitmandi.service;
+import java.io.FileInputStream;
+import java.io.ObjectInputStream;
+import java.time.LocalDate;
+import java.time.LocalDateTime;
+import java.time.Period;
+import java.time.YearMonth;
+import java.time.format.DateTimeFormatter;
+import java.time.temporal.ChronoUnit;
+import java.util.ArrayList;
+import java.util.Arrays;
+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 java.util.stream.LongStream;
+import org.apache.logging.log4j.LogManager;
+import org.apache.logging.log4j.Logger;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.stereotype.Component;
+import org.springframework.ui.Model;
 import com.google.gson.Gson;
 import com.spice.profitmandi.common.enumuration.ReporticoProject;
 import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
+import com.spice.profitmandi.common.model.ChartInvestmentModel;
+import com.spice.profitmandi.common.model.ChartModel;
+import com.spice.profitmandi.common.model.CustomRetailer;
-import com.spice.profitmandi.common.model.*;
+import com.spice.profitmandi.common.model.Data;
+import com.spice.profitmandi.common.model.DataInvestmentModel;
+import com.spice.profitmandi.common.model.Legend;
+import com.spice.profitmandi.common.model.OptionModel;
+import com.spice.profitmandi.common.model.PieLables;
+import com.spice.profitmandi.common.model.ProfitMandiConstants;
 import com.spice.profitmandi.dao.entity.auth.AuthUser;
 import com.spice.profitmandi.dao.entity.auth.Menu;
 import com.spice.profitmandi.dao.entity.cs.Position;
 import com.spice.profitmandi.dao.entity.fofo.FofoStore;
 import com.spice.profitmandi.dao.entity.fofo.PartnerType;
 import com.spice.profitmandi.dao.repository.fofo.ActivatedImeiRepository;
 import com.spice.profitmandi.dao.repository.inventory.ReporticoCacheTableRepository;
 import com.spice.profitmandi.dao.repository.inventory.SaholicInventoryCISRepository;
 import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
 import com.spice.profitmandi.service.user.RetailerService;
-import org.apache.logging.log4j.LogManager;
-import org.apache.logging.log4j.Logger;
-import org.springframework.beans.factory.annotation.Autowired;
-import org.springframework.stereotype.Component;
-import org.springframework.ui.Model;
-import java.io.FileInputStream;
-import java.io.ObjectInputStream;
-import java.time.LocalDate;
-import java.time.LocalDateTime;
-import java.time.Period;
-import java.time.YearMonth;
-import java.time.format.DateTimeFormatter;
-import java.time.temporal.ChronoUnit;
-import java.util.*;
-import java.util.Map.Entry;
-import java.util.stream.Collectors;
-import java.util.stream.LongStream;
 @Component
 public class AdminUser {
 	@Autowired
 	private Gson gson;
 	List<String> brands = Arrays.asList("Oppo", "Vivo", "Samsung", "Realme", "Xiaomi", "Tecno", "Itel", "Lava",
 			"Nokia");
 	private static final Logger LOGGER = LogManager.getLogger(AdminUser.class);
-	public ChartModel getBrandWiseLmp(List<Integer> warehouseIds, List<Integer> fofoIds, LocalDate startDateTime) {
+	public ChartModel getBrandWiseLmp(List<Integer> warehouseIds, List<Integer> fofoIds, LocalDate startDate,
+			LocalDate endDate, String filterType) {
-		LOGGER.info("params" + warehouseIds + fofoIds + startDateTime);
+		LOGGER.info("params" + warehouseIds + fofoIds + startDate);
-		List<BrandWiseModel> brandWiseLms = orderRepository.selectGroupByBrandLmp(fofoIds, warehouseIds, startDateTime);
+		List<BrandWiseModel> brandWiseLms = orderRepository.selectGroupByBrandLmp(fofoIds, warehouseIds, startDate,
+				endDate, filterType);
 		LOGGER.info("brandWiseLms" + brandWiseLms);
+		ChartModel cm = null;
+		if (filterType.equals("dateWise")) {
-		DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-dd-yyyy");
+			DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-dd-yyyy");
-		Map<String, Map<LocalDate, Double>> brandDateValue = new HashMap<>();
+			Map<String, Map<LocalDate, Double>> brandDateValue = new HashMap<>();
-		for (BrandWiseModel bwl : brandWiseLms) {
+			for (BrandWiseModel bwl : brandWiseLms) {
-			if (!brandDateValue.containsKey(bwl.getBrand())) {
+				if (!brandDateValue.containsKey(bwl.getBrand())) {
-				brandDateValue.put(bwl.getBrand(), new HashMap<>());
+					brandDateValue.put(bwl.getBrand(), new HashMap<>());
+				}
+				Map<LocalDate, Double> dateWiseSalesMap = brandDateValue.get(bwl.getBrand());
+				dateWiseSalesMap.put(LocalDate.parse(bwl.getYearMonth(), dateTimeFormatter), (double) bwl.getAmount());
+			}
-			Map<LocalDate, Double> dateWiseSalesMap = brandDateValue.get(bwl.getBrand());
-			dateWiseSalesMap.put(LocalDate.parse(bwl.getYearMonth(), dateTimeFormatter), (double) bwl.getAmount());
-		}
-		long days = startDateTime.until(LocalDate.now(), ChronoUnit.DAYS);
+			long days = startDate.until(endDate, ChronoUnit.DAYS);
-		List<LocalDate> allDatesBetween = LongStream.range(0, days).mapToObj(x -> startDateTime.plusDays(x)).collect(Collectors.toList());
+			List<LocalDate> allDatesBetween = LongStream.range(0, days).mapToObj(x -> startDate.plusDays(x))
+					.collect(Collectors.toList());
-		LOGGER.info("All dates between {}", allDatesBetween);
+			LOGGER.info("All dates between {}", allDatesBetween);
-		Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
+			Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
-		for (String brand : brands) {
+			for (String brand : brands) {
-			if (!brandDateValue.containsKey(brand)) {
+				if (!brandDateValue.containsKey(brand)) {
-				brandDateValue.put(brand, new HashMap<>());
+					brandDateValue.put(brand, new HashMap<>());
-			}
+				}
-			Map<LocalDate, Double> dateWiseBrand = brandDateValue.get(brand);
+				Map<LocalDate, Double> dateWiseBrand = brandDateValue.get(brand);
-			for (LocalDate date : allDatesBetween) {
+				for (LocalDate date : allDatesBetween) {
-				if (dateWiseBrand.get(date) == null) {
+					if (dateWiseBrand.get(date) == null) {
-					dateWiseBrand.put(date, 0.0);
+						dateWiseBrand.put(date, 0.0);
+					}
+				}
+				Map<LocalDate, Double> sortedMonthBrandValue = new TreeMap<>(dateWiseBrand);
+				sortedBrandValue.put(brand, new ArrayList<>(sortedMonthBrandValue.values()));
+				LOGGER.info("Sorted Brandwise values count {}", sortedMonthBrandValue.size());
+			}
+			LOGGER.info("brandMonthValueCount {}", brandDateValue.size());
+			LOGGER.info("sortedBrandValueCount {}", sortedBrandValue.size());
+			cm = chartService.createChartWithLabels(
+					allDatesBetween.stream().map(x -> x.format((DateTimeFormatter.ofPattern("dd MMM''uu"))))
+							.collect(Collectors.toCollection(LinkedHashSet::new)),
+					sortedBrandValue, colorList, borderList, "Brand Wise Date Wise Purchase");
+		} else {
+			DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-yyyy");
+			Map<String, Map<YearMonth, Double>> brandMonthValue = new HashMap<>();
+			for (BrandWiseModel bwl : brandWiseLms) {
+				Map<YearMonth, Double> yearMonthValue = new HashMap<>();
+				if (brandMonthValue.containsKey(bwl.getBrand())) {
+					yearMonthValue = brandMonthValue.get(bwl.getBrand());
+					yearMonthValue.put(YearMonth.parse(bwl.getYearMonth(), dateTimeFormatter),
+							(double) bwl.getAmount());
+				} else {
+					yearMonthValue.put(YearMonth.parse(bwl.getYearMonth(), dateTimeFormatter),
+							(double) bwl.getAmount());
+				}
+				brandMonthValue.put(bwl.getBrand(), yearMonthValue);
+			}
+			LocalDateTime curDate = LocalDate.now().atStartOfDay();
+			Period age = Period.between(startDate, endDate);
+			int months = age.getMonths();
+			LOGGER.info("months" + months);
+			LOGGER.info("brandWiseLms" + brandWiseLms);
+			LOGGER.info("brandMonthValue" + brandMonthValue);
-			Map<LocalDate, Double> sortedMonthBrandValue = new TreeMap<>(dateWiseBrand);
+			Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
+			for (String brand : brands) {
-			sortedBrandValue.put(brand, new ArrayList<>(sortedMonthBrandValue.values()));
+				Map<YearMonth, Double> yearMonthValue = brandMonthValue.get(brand);
+				for (int i = months; i >= 0; i--) {
+					LocalDateTime startMonth = curDate.withDayOfMonth(1).minusMonths(i);
+					if (yearMonthValue != null) {
-			LOGGER.info("Sorted Brandwise values count {}", sortedMonthBrandValue.size());
+						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("brandMonthValueCount {}", brandDateValue.size());
+			}
-		LOGGER.info("sortedBrandValueCount {}", sortedBrandValue.size());
+			cm = chartService.createChart(months, sortedBrandValue, colorList, borderList,
+					"Brand Wise Monthly Purchase");
-		ChartModel cm = chartService.createChartWithLabels(
-				allDatesBetween.stream().map(x -> x.format((DateTimeFormatter.ofPattern("dd MMM''uu")))).collect(Collectors.toCollection(LinkedHashSet::new))
-				, sortedBrandValue, colorList, borderList,
-				"Brand Wise Monthly Purchase");
+		}
 		return cm;
+	}
 	public ChartInvestmentModel getAllStatePartnerType(Map<Integer, PartnerDetailModel> fofoIdAndallValues)
 		cm.setOptions(om);
 		return cm;
+	}
-	public Map<String, Object> getFilter(int warehouseId, String email, LocalDate date)
+	public Map<String, Object> getFilter(int warehouseId, String email, LocalDateTime date, LocalDateTime endDate)
 			throws ProfitMandiBusinessException {
 		Map<String, Object> map = new HashMap<>();
 		Map<Integer, CustomRetailer> customRetailersMap = null;
 		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
 			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("endDate", endDate);
 		map.put("customRetailersMap", customRetailersMap);
 		map.put("fofoIds", fofoIds);
 		map.put("warehouseMap", warehouseMap);
 		return map;
+	}
-	public ChartModel getBrandWiseLms(List<Integer> warehouseIds, List<Integer> fofoIds, LocalDate startDateTime) {
+	public ChartModel getBrandWiseLms(List<Integer> warehouseIds, List<Integer> fofoIds, LocalDate startDate,
+			LocalDate endDate, String filterType) {
-		LOGGER.info("params" + warehouseIds + fofoIds + startDateTime);
+		LOGGER.info("params" + warehouseIds + fofoIds + startDate);
-		List<BrandWiseModel> brandWiseLms = fofoStoreRepository.selectGroupByBrandLms(fofoIds, warehouseIds,
+		List<BrandWiseModel> brandWiseLms = fofoStoreRepository.selectGroupByBrandLms(fofoIds, warehouseIds, startDate,
-				startDateTime);
+				endDate, filterType);
 		LOGGER.info("brandWiseLms" + brandWiseLms);
-		DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-yyyy");
+		ChartModel cm = null;
-		Map<String, Map<YearMonth, Double>> brandMonthValue = new HashMap<>();
-		for (BrandWiseModel bwl : brandWiseLms) {
+		if (filterType.equals("dateWise")) {
-			Map<YearMonth, Double> yearMonthValue = new HashMap<>();
-			if (brandMonthValue.containsKey(bwl.getBrand())) {
-				yearMonthValue = brandMonthValue.get(bwl.getBrand());
-				yearMonthValue.put(YearMonth.parse(bwl.getYearMonth(), dateTimeFormatter), (double) bwl.getAmount());
-			} else {
-				yearMonthValue.put(YearMonth.parse(bwl.getYearMonth(), dateTimeFormatter), (double) bwl.getAmount());
+			DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-dd-yyyy");
+			Map<String, Map<LocalDate, Double>> brandDateValue = new HashMap<>();
+			for (BrandWiseModel bwl : brandWiseLms) {
+				if (!brandDateValue.containsKey(bwl.getBrand())) {
+					brandDateValue.put(bwl.getBrand(), new HashMap<>());
+				}
+				Map<LocalDate, Double> dateWiseSalesMap = brandDateValue.get(bwl.getBrand());
+				dateWiseSalesMap.put(LocalDate.parse(bwl.getYearMonth(), dateTimeFormatter), (double) bwl.getAmount());
+			}
-			brandMonthValue.put(bwl.getBrand(), yearMonthValue);
-		}
-		LocalDateTime curDate = LocalDate.now().atStartOfDay();
+			long days = startDate.until(endDate, ChronoUnit.DAYS);
+			List<LocalDate> allDatesBetween = LongStream.range(0, days).mapToObj(x -> startDate.plusDays(x))
+					.collect(Collectors.toList());
+			LOGGER.info("All dates between {}", allDatesBetween);
+			Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
+			for (String brand : brands) {
+				if (!brandDateValue.containsKey(brand)) {
-		Period age = Period.between(startDateTime, LocalDate.now());
+					brandDateValue.put(brand, new HashMap<>());
+				}
+				Map<LocalDate, Double> dateWiseBrand = brandDateValue.get(brand);
+				for (LocalDate date : allDatesBetween) {
+					if (dateWiseBrand.get(date) == null) {
-		int months = age.getMonths();
+						dateWiseBrand.put(date, 0.0);
+					}
+				}
+				Map<LocalDate, Double> sortedMonthBrandValue = new TreeMap<>(dateWiseBrand);
+				sortedBrandValue.put(brand, new ArrayList<>(sortedMonthBrandValue.values()));
+				LOGGER.info("Sorted Brandwise values count {}", sortedMonthBrandValue.size());
+			}
-		LOGGER.info("months" + months);
+			LOGGER.info("brandMonthValueCount {}", brandDateValue.size());
+			LOGGER.info("sortedBrandValueCount {}", sortedBrandValue.size());
+			cm = chartService.createChartWithLabels(
+					allDatesBetween.stream().map(x -> x.format((DateTimeFormatter.ofPattern("dd MMM''uu"))))
+							.collect(Collectors.toCollection(LinkedHashSet::new)),
+					sortedBrandValue, colorList, borderList, "Brand Wise Date Wise Sale");
+		} else {
+			DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-yyyy");
+			Map<String, Map<YearMonth, Double>> brandMonthValue = new HashMap<>();
-		LOGGER.info("brandWiseLms" + brandWiseLms);
+			for (BrandWiseModel bwl : brandWiseLms) {
+				Map<YearMonth, Double> yearMonthValue = new HashMap<>();
+				if (brandMonthValue.containsKey(bwl.getBrand())) {
-		LOGGER.info("brandMonthValue" + brandMonthValue);
+					yearMonthValue = brandMonthValue.get(bwl.getBrand());
+					yearMonthValue.put(YearMonth.parse(bwl.getYearMonth(), dateTimeFormatter),
+							(double) bwl.getAmount());
+				} else {
-		Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
+					yearMonthValue.put(YearMonth.parse(bwl.getYearMonth(), dateTimeFormatter),
+							(double) bwl.getAmount());
-		for (String brand : brands) {
+				}
-			Map<YearMonth, Double> yearMonthValue = brandMonthValue.get(brand);
+				brandMonthValue.put(bwl.getBrand(), yearMonthValue);
-			for (int i = months; i >= 0; i--) {
+			}
-				LocalDateTime startMonth = curDate.withDayOfMonth(1).minusMonths(i);
+			LocalDateTime curDate = LocalDate.now().atStartOfDay();
+			Period age = Period.between(startDate, endDate);
+			int months = age.getMonths();
+			LOGGER.info("months" + months);
+			LOGGER.info("brandWiseLms" + brandWiseLms);
+			LOGGER.info("brandMonthValue" + brandMonthValue);
+			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 != null) {
-					if (yearMonthValue.get(YearMonth.from(startMonth)) == 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);
+					}
-				} else {
-					yearMonthValue = new HashMap<>();
-					yearMonthValue.put(YearMonth.from(startMonth), 0.0);
+				}
-			}
-			Map<YearMonth, Double> sortedMonthBrandValue = new TreeMap<>(yearMonthValue);
+				Map<YearMonth, Double> sortedMonthBrandValue = new TreeMap<>(yearMonthValue);
-			brandMonthValue.put(brand, sortedMonthBrandValue);
+				brandMonthValue.put(brand, sortedMonthBrandValue);
-			sortedBrandValue.put(brand, sortedMonthBrandValue.values().stream().collect(Collectors.toList()));
+				sortedBrandValue.put(brand, sortedMonthBrandValue.values().stream().collect(Collectors.toList()));
-		}
+			}
-		ChartModel cm = chartService.createChart(months, sortedBrandValue, colorList, borderList,
+			cm = chartService.createChart(months, sortedBrandValue, colorList, borderList, "Brand Wise Monthly Sale");
-				"Brand Wise Monthly Sale");
+		}
 		return cm;
+	}
 	public String adminPanel(int fofoId, String email, Model model) throws Exception {

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-dao/src/main/java/com/spice/profitmandi/service/AdminUser.java – Rev 30268 → 30279