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

 import org.springframework.web.bind.annotation.RequestMapping;
 import org.springframework.web.bind.annotation.RequestMethod;
 import org.springframework.web.bind.annotation.RequestParam;
 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.exception.ProfitMandiBusinessException;
 import com.spice.profitmandi.common.model.ActivateItemModel;
 import com.spice.profitmandi.common.model.ChartInvestmentModel;
 import com.spice.profitmandi.dao.entity.fofo.InventoryItem;
 import com.spice.profitmandi.dao.entity.fofo.PartnerType;
 import com.spice.profitmandi.dao.entity.inventory.ReporticoCacheTable;
 import com.spice.profitmandi.dao.entity.transaction.Order;
 import com.spice.profitmandi.dao.enumuration.transaction.OrderStatus;
+import com.spice.profitmandi.dao.model.ActivationImeiUpdationModel;
+import com.spice.profitmandi.dao.model.BrandWiseActivatedModel;
 import com.spice.profitmandi.dao.model.BrandWisePartnerSaleModel;
 import com.spice.profitmandi.dao.model.BrandWiseUnbilledActivateStockModel;
 import com.spice.profitmandi.dao.model.CreateOfferRequest;
 import com.spice.profitmandi.dao.model.InStockBrandItemModel;
 import com.spice.profitmandi.dao.model.InStockBrandModel;
 import com.spice.profitmandi.dao.model.PartnerPendingIndentItemModel;
 import com.spice.profitmandi.dao.model.PriceDropBrandModel;
 import com.spice.profitmandi.dao.model.PriceDropWithDetailsByYearMonthModel;
 import com.spice.profitmandi.dao.model.PriceDropYearMonthModel;
 import com.spice.profitmandi.dao.model.WarehouseBrandItemUnbilledActivatedModel;
+import com.spice.profitmandi.dao.model.WarehouseBrandWiseItemActivatedModel;
 import com.spice.profitmandi.dao.model.WarehouseBrandWiseItemSaleModel;
+import com.spice.profitmandi.dao.model.WarehouseWiseActivatedModel;
 import com.spice.profitmandi.dao.model.WarehouseWiseBrandSaleModel;
 import com.spice.profitmandi.dao.model.WarehouseWiseBrandStockModel;
 import com.spice.profitmandi.dao.model.WarehouseWiseBrandUnbilledActivatedModel;
 import com.spice.profitmandi.dao.model.WarehouseWiseitemStockModel;
 import com.spice.profitmandi.dao.repository.auth.AuthRepository;
 import com.spice.profitmandi.dao.repository.cs.PositionRepository;
 import com.spice.profitmandi.dao.repository.cs.TicketAssignedRepository;
 import com.spice.profitmandi.dao.repository.cs.TicketRepository;
 import com.spice.profitmandi.dao.repository.dtr.DocumentRepository;
 import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
+import com.spice.profitmandi.dao.repository.dtr.Mongo;
 import com.spice.profitmandi.dao.repository.dtr.NotificationCampaignRepository;
 import com.spice.profitmandi.dao.repository.dtr.UserAccountRepository;
+import com.spice.profitmandi.dao.repository.fofo.ActivatedImeiRepository;
 import com.spice.profitmandi.dao.repository.fofo.CurrentInventorySnapshotRepository;
 import com.spice.profitmandi.dao.repository.fofo.FofoOrderItemRepository;
 import com.spice.profitmandi.dao.repository.fofo.FofoOrderRepository;
 import com.spice.profitmandi.dao.repository.fofo.HygieneDataRepository;
 import com.spice.profitmandi.dao.repository.fofo.InventoryItemRepository;
 	@Autowired
 	private FofoUser fofoUser;
 	@Autowired
+	private ActivatedImeiRepository activatedImeiRepository;
+	@Autowired
+	private Mongo mongoClient;
+	@Autowired
 	private PositionRepository positionRepository;
 	private static final Logger LOGGER = LogManager.getLogger(DashboardController.class);
 	@RequestMapping(value = "/12dashboard34", method = RequestMethod.GET)
 	public String dashboard1(HttpServletRequest request, Model model, @RequestParam int fofoId) throws Exception {
 		model.addAttribute("priceDropdetailsList", priceDropdetailsList);
 		return "price-drop-details";
+	}
 	@RequestMapping(value = "/getPriceDropDetailSixMonths", method = RequestMethod.GET)
 	public String getPriceDropDetailSixMonths(HttpServletRequest request,
 			@RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId,
 			@RequestParam(name = "brand", required = true, defaultValue = "0") String brand, Model model)
 			throws Exception {
 		LocalDateTime curDate = LocalDate.now().atStartOfDay();
 		LocalDateTime startfMonthSixMonth = curDate.withDayOfMonth(1).minusMonths(12);
 		LocalDateTime endMonthTotal = curDate.withDayOfMonth(1).minusMonths(6);
 		List<PriceDropWithDetailsByYearMonthModel> priceDropdetailsList = priceDropRepository
-				.selectBrandPendingPriceDropWithDetailsAndSixMonth(fofoId, brand, startfMonthSixMonth,endMonthTotal);
+				.selectBrandPendingPriceDropWithDetailsAndSixMonth(fofoId, brand, startfMonthSixMonth, endMonthTotal);
 		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();
 		DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("MM-yyyy");
 		Map<String, Map<YearMonth, Double>> brandMonthValue = new HashMap<>();
 		LOGGER.info("priceDropBrandSixMonthTotals" + priceDropBrandSixMonthTotals);
-		Map<String, Double> priceDropBrandSixMonthMap=priceDropBrandSixMonthTotals.stream().collect(Collectors.toMap(x->x.getBrand(), x->(double)x.getAmount()));
+		Map<String, Double> priceDropBrandSixMonthMap = priceDropBrandSixMonthTotals.stream()
+				.collect(Collectors.toMap(x -> x.getBrand(), x -> (double) x.getAmount()));
 		model.addAttribute("priceDropBrandSixMonthMap", priceDropBrandSixMonthMap);
 		LOGGER.info("priceDropYearMonthModels" + priceDropYearMonthModels);
 		for (PriceDropYearMonthModel pdm : priceDropYearMonthModels) {
 			Map<YearMonth, Double> brandValue = new HashMap<>();
 		brands.add("Tecno");
 		brands.add("Itel");
 		brands.add("Nokia");
 		Map<String, List<Double>> sortedBrandValue = new LinkedHashMap<>();
-       model.addAttribute("brands", brands);
+		model.addAttribute("brands", brands);
 		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);
 		LOGGER.info("chartMap" + gson.toJson(cm));
 		model.addAttribute("chartMap", gson.toJson(cm));
 		return "brand-wise-mobile-lmp-chart";
+	}
+	@RequestMapping(value = "/getActivatedModelWarehouseWise", method = RequestMethod.GET)
+	public String getActivatedModelWarehouseWise(HttpServletRequest request, Model model, @RequestParam String brand)
+			throws Exception {
+		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
+		List<Integer> fofoIds = getFofoIds(loginDetails);
+		List<WarehouseWiseActivatedModel> warehouseWiseActivatedModels = activatedImeiRepository
+				.selectActivatedModelGroupByWarehouse(brand, fofoIds);
+		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
+		List<DBObject> mobileBrands = mongoClient.getAllBrandsToDisplay(3);
+		List<String> brands = mobileBrands.stream().map(x -> (String) x.get("name")).collect(Collectors.toList());
+		LOGGER.info("brands" + brands.add("Redmi"));
+		model.addAttribute("warehouseWiseActivatedModels", warehouseWiseActivatedModels);
+		model.addAttribute("warehouseMap", warehouseMap);
+		model.addAttribute("brands", brands);
+		model.addAttribute("selectedbrand", brand);
+		return "warehousewise_activated_model";
+	}
+	@RequestMapping(value = "/getActivatedModelByBrand", method = RequestMethod.GET)
+	public String getActivatedModelByBrand(HttpServletRequest request, Model model) throws Exception {
+		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
+		List<Integer> fofoIds = getFofoIds(loginDetails);
+		List<BrandWiseActivatedModel> activatedModels = activatedImeiRepository
+				.selectActivatedModelGroupByBrand(new ArrayList<>(fofoIds));
+		model.addAttribute("activatedModels", activatedModels);
+		return "activation-brandwise-report";
+	}
+	@RequestMapping(value = "/getWarehouseBrandWiseItemActivatedModel", method = RequestMethod.GET)
+	public String getWarehouseBrandWiseItemActivatedModel(HttpServletRequest request, Model model,
+			@RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {
+		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
+		List<Integer> fofoIds = getFofoIds(loginDetails);
+		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
+		List<WarehouseBrandWiseItemActivatedModel> activatedItems = activatedImeiRepository
+				.selectWarehouseBrandActivatedItem(warehouseId, brand, fofoIds);
+		model.addAttribute("warehouseMap", warehouseMap);
+		model.addAttribute("activatedItems", activatedItems);
+		return "warehouse-activated-itemwise-model";
+	}
+	@RequestMapping(value = "/getActivatedImeiUpdationDate", method = RequestMethod.GET)
+	public String getActivatedImeiUpdationDate(HttpServletRequest request, Model model) throws Exception {
+		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
+		List<ActivationImeiUpdationModel> activationImeiUpdations = activatedImeiRepository
+				.selectActivatedUpdationDate();
+		model.addAttribute("warehouseMap", warehouseMap);
+		model.addAttribute("activationImeiUpdations", activationImeiUpdations);
+		return "activation-updation-timestamp";
+	}
+	private List<Integer> getFofoIds(LoginDetails loginDetails) throws ProfitMandiBusinessException {
+		String email = loginDetails.getEmailId();
+		AuthUser authUser = authRepository.selectByEmailOrMobile(email);
+		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
+		Set<Integer> fofoIds = storeGuyMap.get(authUser.getEmailId());
+		if (emails.contains(authUser.getEmailId())) {
+			fofoIds = storeGuyMap.get("tarun.verma@smartdukaan.com");
+			LOGGER.info("fofoIds" + fofoIds);
+		}
+		if (fofoIds == null) {
+			List<Position> positions1 = positionRepository.selectAll(authUser.getId());
+			if (positions1.stream().filter(x -> x.getCategoryId() == ProfitMandiConstants.TICKET_CATEGORY_MASTER)
+					.count() > 0) {
+				fofoIds = csService.getPositionCustomRetailerMap(positions1).values().stream().flatMap(x -> x.stream())
+						.map(x -> x.getPartnerId()).collect(Collectors.toSet());
+			}
+		}
+		return new ArrayList<>(fofoIds);
+	}
+}

Subversion Repositories SmartDukaan

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