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



@Controller
@Transactional(rollbackOn = Throwable.class)
public class DashboardController {
 
	List<String> emails = Arrays.asList("kamini.sharma@smartdukaan.com", "neeraj.gupta@smartdukaan.com",
			"niranjan.kala@smartdukaan.com", "hemant.kaura@smartdukaan.com", "amit.gupta@smartdukaan.com",
			"tejbeer.kaur@smartdukaan.com");
 
	@Value("${web.api.host}")
	private String webApiHost;
 
	@Value("${web.api.scheme}")

				orderStatus.add(SHIPPED_FROM_WH);
				orderStatus.add(DELIVERY_SUCCESS);
 
				List<Order> openOrders = orderRepository.selectGrnTimestampNull(fofoId, orderStatus);
				List<LineItem> submittedLineItemIds = openOrders.stream()
						.filter(x -> x.getStatus().equals(SUBMITTED_FOR_PROCESSING)).map(x -> x.getLineItem())
						.collect(Collectors.toList());
				List<LineItem> billedOrderIds = openOrders.stream().filter(x -> x.getStatus().equals(BILLED))
						.map(x -> x.getLineItem()).collect(Collectors.toList());
 
 
 
				List<LineItem> shippedOrderIds = openOrders.stream().filter(x -> x.getStatus().equals(SHIPPED_FROM_WH))
 
						.map(x -> x.getLineItem()).collect(Collectors.toList());
				List<LineItem> grnPendingLineItemIds = openOrders.stream()
						.filter(x -> x.getStatus().equals(DELIVERY_SUCCESS)).map(x -> x.getLineItem())
						.collect(Collectors.toList());
 
 
				long imeiActivationPendingCount = 0;
				long imeiActivationPendingValue = 0;
				List<Integer> grnPendingOrderIds = openOrders.stream()
						.filter(x -> x.getStatus().equals(SHIPPED_FROM_WH) || x.getStatus().equals(DELIVERY_SUCCESS))
						.map(x -> x.getId()).collect(Collectors.toList());
				if (grnPendingOrderIds.size() > 0) {
					List<ImeiActivationTimestampModel> imeiActivationTimestampModels = activatedImeiRepository
							.selectActivatedImeisByOrders(grnPendingOrderIds);
					imeiActivationPendingCount = imeiActivationTimestampModels.size();
					imeiActivationPendingValue = imeiActivationTimestampModels.stream()
							.collect(Collectors.summingDouble(x -> x.getSellingPrice())).longValue();
				}
 
 
				long grnPendingCount = grnPendingLineItemIds.stream()
						.collect(Collectors.summingLong(LineItem::getQuantity));
				long grnPendingValue = grnPendingLineItemIds.stream()
						.collect(Collectors.summingLong(x -> x.getTotalPrice().longValue()));
				model.addAttribute("grnPendingCount", grnPendingCount);
				model.addAttribute("grnPendingValue", grnPendingValue);
 
				long submittedCount = submittedLineItemIds.stream()
						.collect(Collectors.summingLong(LineItem::getQuantity));
				long submittedValue = submittedLineItemIds.stream()
						.collect(Collectors.summingLong(x -> x.getTotalPrice().longValue()));
				model.addAttribute("submittedCount", submittedCount);
				model.addAttribute("submittedValue", submittedValue);
 
				long billedCount = billedOrderIds.stream().collect(Collectors.summingLong(LineItem::getQuantity));
				long billedValue = billedOrderIds.stream()
						.collect(Collectors.summingLong(x -> x.getTotalPrice().longValue()));
				model.addAttribute("billedValue", billedValue);
				model.addAttribute("billedCount", billedCount);
				LOGGER.info("billedCount {}", billedCount);
 
				long shippedCount = shippedOrderIds.stream().collect(Collectors.summingLong(LineItem::getQuantity));

				model.addAttribute("giftItemId", ProfitMandiConstants.GIFT_ID);
				model.addAttribute("retailers", new JSONObject().append("code", fofoStore.getCode())
						.append("partnerId", fofoStore.getId()).toString());
				model.addAttribute("activatedImeis",
						inventoryItemRepository.selectCountByActivatedNotSold(loginDetails.getFofoId()));
				model.addAttribute("imeiActivationPendingCount", imeiActivationPendingCount);
 
				model.addAttribute("imeiActivationPendingValue", imeiActivationPendingValue);
 
 
				Map<Integer, Double> accesoriesmtdsale = fofoOrderRepository
						.selectSumSaleGroupByFofoIdsForMobileOrAccessories(loginDetails.getFofoId(),
								curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), Optional.of(false));
 

				model.addAttribute("publishedOffers", publishedOffers);
				model.addAttribute("investments", fofoUser.getInvestments(loginDetails.getFofoId()));
				model.addAttribute("isInvestmentOk", partnerInvestmentService.isInvestmentOk(loginDetails.getFofoId(),
						10, ProfitMandiConstants.CUTOFF_INVESTMENT));
 
				double currentMonthRating = hygieneDataRepository.selectRatingAvg(loginDetails.getFofoId(),
						currentMonthStart, currentMonthEnd) / 2;
				double lastMonthRating = hygieneDataRepository.selectRatingAvg(loginDetails.getFofoId(), lastMonthStart,
						currentMonthStart) / 2;
				double ratingTillDate = hygieneDataRepository.selectRatingAvg(loginDetails.getFofoId(),
						LocalDateTime.MIN, 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, currentMonthEnd);
 
				long invalidHygieneCount = hygieneDataRepository.selectHygieneCount(loginDetails.getFofoId(), false,
						currentMonthStart, currentMonthEnd);
				if (hygieneCount == 0 && invalidHygieneCount == 0) {
					invalidHygieneCount = 1;

		return "partner-total-income";
	}
 
	@RequestMapping(value = "/getMonthsInvestment", method = RequestMethod.GET)
	public String getMonthsInvestment(HttpServletRequest request,
			@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 = fofoUser.getInvestmentsMonths(fofoId, month);
 

		return "bar_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 = false, defaultValue = "0") String yearMonth, Model model)
			throws Exception {
 
		LOGGER.info("params" + fofoId + brand + yearMonth);
 
		List<PriceDropWithDetailsByYearMonthModel> priceDropdetailsList = priceDropRepository

		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 {
 
		LOGGER.info("params" + fofoId + brand);
		LocalDateTime curDate = LocalDate.now().atStartOfDay();
		LocalDateTime startfMonthSixMonth = curDate.withDayOfMonth(1).minusMonths(12);

		return "activation-tabular";
	}
 
	@RequestMapping(value = "/getMonthlyActivationItemDetail", method = RequestMethod.GET)
	public String getMonthlyActivationItemDetail(HttpServletRequest request,
			@RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId,
			@RequestParam(name = "brand", required = true, defaultValue = "0") String brand,
			@RequestParam(name = "yearMonth", required = false, defaultValue = "0") String yearMonth, Model model)
			throws Exception {
 
		LOGGER.info("params" + fofoId + brand + yearMonth);
 
		List<ActivationItemDetailModel> activationItemDetails = schemeInOutRepository

		return "activation-pending-item-details";
	}
 
	@RequestMapping(value = "/getMonthlyActivationBeforeSixMonthsItemDetail", method = RequestMethod.GET)
	public String getMonthlyActivationItemDetail(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 startOfMonth = curDate.withDayOfMonth(1).minusMonths(6);
 

 
	}
 
	@RequestMapping(value = "/getMonthlyUpgradeOfferItemDetail", method = RequestMethod.GET)
	public String getMonthlyUpgradeOfferItemDetail(HttpServletRequest request,
			@RequestParam(name = "fofoId", required = true, defaultValue = "0") int fofoId,
			@RequestParam(name = "brand", required = true, defaultValue = "0") String brand,
			@RequestParam(name = "yearMonth", required = false, defaultValue = "0") String yearMonth, Model model)
			throws Exception {
 
		LOGGER.info("params" + fofoId + brand + yearMonth);
		List<UpgradeOfferItemDetailModel> offerItems = samsungUpgradeOfferRepository
				.selectUpgradeOfferItemDetails(fofoId, UpgradeOfferStatus.approved, brand, yearMonth);

		return "upgrade-offer-item-detail";
	}
 
	@RequestMapping(value = "/getUpgradeOfferBeforeSixMonthItemDetail", method = RequestMethod.GET)
	public String getUpgradeOfferBeforeSixMonthItemDetail(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 startOfMonth = curDate.withDayOfMonth(1).minusMonths(6);
 

		return "auth_user_partner_detail";
	}
 
	@RequestMapping(value = "/getWarehouseWiseBrandStock", method = RequestMethod.GET)
	public String getWarehouseWiseBrandStock(HttpServletRequest request, Model model,
			@RequestParam List<Integer> warehouseId) throws Exception {
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		String email = loginDetails.getEmailId();
		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
		Set<Integer> authfofoIds = storeGuyMap.get(email);
		AuthUser authUser = authRepository.selectByEmailOrMobile(email);

		return "response";
	}
 
	@RequestMapping(value = "/getWarehouseWiseBrandAndCategory", method = RequestMethod.GET)
	public String getWarehouseWiseBrandAndCategory(HttpServletRequest request, Model model,
			@RequestParam List<Integer> warehouseId, @RequestParam List<String> brands, @RequestParam String category)
			throws Exception {
 
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
		List<String> listbrands = saholicInventoryCISRepository.selectAllBrand();
		List<String> listCategory = saholicInventoryCISRepository.selectAllSubCategory();

		return "warehouse_brand_item_stock";
	}
 
	@RequestMapping(value = "/getWarehouseWiseItemStock", method = RequestMethod.GET)
	public String getWarehouseWiseItemStock(HttpServletRequest request, Model model,
			@RequestParam List<Integer> warehouseId, @RequestParam List<String> brands, @RequestParam String category)
			throws Exception {
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
		if (warehouseId.contains(0)) {
			warehouseId.addAll(warehouseMap.keySet());
		}

		return "warehousewise_brand_partners_sale";
	}
 
	@RequestMapping(value = "/getWarehouseWiseAccesoriesBrandPartnerSale", method = RequestMethod.GET)
	public String getWarehouseWiseAccesoriesBrandPartnerSale(HttpServletRequest request, Model model,
			@RequestParam String brand) throws Exception {
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		String email = loginDetails.getEmailId();
		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
		Set<Integer> authfofoIds = storeGuyMap.get(email);
 

		return "warehousewise_accessoriesbrand_sale";
	}
 
	@RequestMapping(value = "/getWarehouseBrandWiseItemSale", method = RequestMethod.GET)
	public String getWarehouseBrandWiseItemSale(HttpServletRequest request, Model model,
			@RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		String email = loginDetails.getEmailId();
		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
		Set<Integer> authfofoIds = storeGuyMap.get(email);

		return "warehouse_partner_itemwise_sale";
	}
 
	@RequestMapping(value = "/getWarehouseAccesoriesBrandWiseItemSale", method = RequestMethod.GET)
	public String getWarehouseAccesoriesBrandWiseItemSale(HttpServletRequest request, Model model,
			@RequestParam List<Integer> warehouseId, @RequestParam String brand) throws Exception {
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		String email = loginDetails.getEmailId();
		Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
		Set<Integer> authfofoIds = storeGuyMap.get(email);

		return "contact-us";
	}
 
	@RequestMapping(value = "/notifications", method = RequestMethod.GET)
	public String getNotificationsWithType(HttpServletRequest request,
			@RequestParam(required = false) MessageType messageType,
			@RequestParam(name = "offset", defaultValue = "0") int offset,
			@RequestParam(name = "limit", defaultValue = "20") int limit, Model model) throws Exception {
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		int userId = 0;
		boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
		if (isAdmin) {
			userId = loginDetails.getFofoId();

		return "notification-template";
	}
 
	@RequestMapping(value = "/notifyDocument/documentId", method = RequestMethod.GET)
	public ResponseEntity<?> retailerDocumentById(HttpServletRequest request,
			@RequestParam(name = ProfitMandiConstants.DOCUMENT_ID) int documentId, @RequestParam int cid)
			throws ProfitMandiBusinessException {
		Document document = documentRepository.selectById(documentId);
		NotificationCampaign nc = notificationCampaignRepository.selectById(cid);
		if (nc.getDocumentId() == null) {
			throw new ProfitMandiBusinessException("cid", nc.getId(), "not available");

		return new ResponseEntity<InputStreamResource>(inputStreamResource, headers, HttpStatus.OK);
	}
 
	@RequestMapping(value = "/getItemWiseTertiary", method = RequestMethod.GET)
	public String getItemWiseTertiary(HttpServletRequest request,
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model)
			throws ProfitMandiBusinessException {
		List<ItemWiseTertiaryModel> itemWiseTertiary = fofoOrderRepository.SelectItemWiseTertiary(fofoId);
 
		LOGGER.info("itemWiseTertiary" + itemWiseTertiary);
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);

		return "item-wise-tertiary";
	}
 
	@RequestMapping(value = "/getItemWiseIndent", method = RequestMethod.GET)
	public String getItemWiseIndent(HttpServletRequest request,
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model)
			throws ProfitMandiBusinessException {
 
		List<Order> unbilledOrders = transactionService.getInTransitOrders(fofoId);
		model.addAttribute("unbilledOrders", unbilledOrders);
 
		return "item-wise-indent";
	}
 
	@RequestMapping(value = "/getPartnerInvestment", method = RequestMethod.GET)
	public String getPartnerInvestment(HttpServletRequest request,
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
		Map<Integer, PartnerDetailModel> partnerStats = adminUser.getPartnersStatDataFromFile();
		PartnerDetailModel partnerDetailModel = partnerStats.get(fofoId);
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
		model.addAttribute("partnerDetailModel", partnerDetailModel);
		model.addAttribute("customRetailer", customRetailer);
		return "partner-investment";
	}
 
	@RequestMapping(value = "/getPartnerPendingIndentItem", method = RequestMethod.GET)
	public String getPartnerPendingIndentItem(HttpServletRequest request, @RequestParam int warehouseId,
			@RequestParam int itemId, Model model) throws ProfitMandiBusinessException {
		List<PartnerPendingIndentItemModel> partnerPendingIndent = fofoStoreRepository
				.selectPartnerPendingIndentItem(itemId, warehouseId);
 
		model.addAttribute("partnerPendingIndent", partnerPendingIndent);
		return "partner-pending-indent-item";
	}
 
	@RequestMapping(value = "/getPatnerActivateStock", method = RequestMethod.GET)
	public String getPartnerActivateStockItem(HttpServletRequest request,
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
		List<ActivateItemModel> activateStocks = new ArrayList<>();
		List<InventoryItem> inventoryItems = inventoryItemRepository.selectByActivatedNotSold(fofoId);
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
 
		for (InventoryItem inventoryItem : inventoryItems) {

		return "partner-activate-stock";
	}
 
	@RequestMapping(value = "/getPatnerBrandWiseMTDSale", method = RequestMethod.GET)
	public String getPatnerBrandWiseMTDSale(HttpServletRequest request,
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
		LocalDateTime curDate = LocalDate.now().atStartOfDay();
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
		Map<String, Double> brandMtdAmount = fofoOrderItemRepository
				.selectSumAmountGroupByBrand(curDate.withDayOfMonth(1), curDate.with(LocalTime.MAX), fofoId);
		Map<String, Long> brandMtdQty = fofoOrderItemRepository.selectSumQuantityGroupByBrand(curDate.withDayOfMonth(1),

		return "partner-brand-mtd-sale";
	}
 
	@RequestMapping(value = "/getPatnerBrandWiseLMTDSale", method = RequestMethod.GET)
	public String getPatnerBrandWiseLMTDSale(HttpServletRequest request,
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
		LocalDateTime curDate = LocalDate.now().atStartOfDay();
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
		Map<String, Double> brandLMtdAmount = fofoOrderItemRepository.selectSumAmountGroupByBrand(
				curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1), fofoId);
		Map<String, Long> brandLmtdQty = fofoOrderItemRepository.selectSumQuantityGroupByBrand(

		return "partner-brand-lmtd-sale";
	}
 
	@RequestMapping(value = "/getPatnerBrandWiseLMSSale", method = RequestMethod.GET)
	public String getPatnerBrandWiseLMSSale(HttpServletRequest request,
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
		LocalDateTime curDate = LocalDate.now().atStartOfDay();
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
		int lengthOfMonth = YearMonth.from(curDate.minusMonths(1)).lengthOfMonth();
 
		Map<String, Double> brandLMSAmount = fofoOrderItemRepository.selectSumAmountGroupByBrand(

		return "partner-brand-lms-sale";
	}
 
	@RequestMapping(value = "/getPatnerInStock", method = RequestMethod.GET)
	public String getPatnerInStock(HttpServletRequest request,
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
 
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
 
		List<InStockBrandModel> mobileStocks = currentInventorySnapshotRepository
				.selectSumInStockMobileGroupByBrand(fofoId);

		return "partner-instock-item";
	}
 
	@RequestMapping(value = "/getOpenTicketByFofoId", method = RequestMethod.GET)
	public String getOpenTicketByFofoId(HttpServletRequest request,
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, Model model) throws Exception {
		Map<Integer, AuthUser> ticketIdAuthUser = new HashMap<>();
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
		List<Integer> ticketIds = ticketRepository.selectAllOpenTicketByRetailer(fofoId).stream().map(x -> x.getId())
				.collect(Collectors.toList());
		List<TicketAssigned> ticketAssigns = ticketAssignedRepository.selectByTicketIds(ticketIds);

		return "open-ticket";
	}
 
	@RequestMapping(value = "/getPartnerSecondarySale", method = RequestMethod.GET)
	public String getPartnerSecondarySale(HttpServletRequest request,
			@RequestParam(name = ProfitMandiConstants.FOFO_ID) int fofoId, @RequestParam String timeValue, Model model)
			throws Exception {
		LocalDateTime curDate = LocalDate.now().atStartOfDay();
		CustomRetailer customRetailer = retailerService.getFofoRetailer(fofoId);
		int lengthOfMonth = YearMonth.from(curDate.minusMonths(1)).lengthOfMonth();
		LocalDateTime startDate = null;

		return "accessories-brand-wise-report";
	}
 
	@RequestMapping(value = "/getMobileLMSGraph", method = RequestMethod.GET)
	public String getMobileLMSGraph(HttpServletRequest request, @RequestParam(required = false) int warehouseId,
			@RequestParam(required = false) LocalDateTime date, @RequestParam(required = false) LocalDateTime endDate,
			@RequestParam List<Integer> fofoIds, @RequestParam String filterType, Model model) throws Exception {
		Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository
				.selectActivePartnersByRetailerIds(new ArrayList<>(fofoIds)).stream().collect(Collectors.groupingBy(
						FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));
 
		ChartModel cm;

		return "brand-wise-mobile-lms-chart";
	}
 
	@RequestMapping(value = "/getMobileLMSFilter", method = RequestMethod.GET)
	public String getMobileLMSFilter(HttpServletRequest request,
			@RequestParam(required = false, defaultValue = "0") int warehouseId,
			@RequestParam(required = false) LocalDateTime date, @RequestParam(required = false) LocalDateTime endDate,
			Model model) throws Exception {
 
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
		String email = loginDetails.getEmailId();
 
		if (date == null) {

		return "chart-filter-lms";
	}
 
	@RequestMapping(value = "/getMobileLMPGraph", method = RequestMethod.GET)
	public String getMobileLMPGraph(HttpServletRequest request, @RequestParam(required = false) int warehouseId,
			@RequestParam(required = false) LocalDateTime date, @RequestParam(required = false) LocalDateTime endDate,
			@RequestParam List<Integer> fofoIds, @RequestParam String filterType, Model model) throws Exception {
		Map<Integer, List<Integer>> warehouseIdFofoIdMap = fofoStoreRepository
				.selectActivePartnersByRetailerIds(new ArrayList<>(fofoIds)).stream().collect(Collectors.groupingBy(
						FofoStore::getWarehouseId, Collectors.mapping(FofoStore::getId, Collectors.toList())));
 
		ChartModel cm;

		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

Subversion Repositories SmartDukaan

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

Rev 30455		Rev 30564
Line 82...		Line 82...
82	`@Controller`	82	`@Controller`
83	`@Transactional(rollbackOn = Throwable.class)`	83	`@Transactional(rollbackOn = Throwable.class)`
84	`public class DashboardController {`	84	`public class DashboardController {`
85		85
86	`List<String> emails = Arrays.asList("kamini.sharma@smartdukaan.com", "neeraj.gupta@smartdukaan.com",`	86	`List<String> emails = Arrays.asList("kamini.sharma@smartdukaan.com", "neeraj.gupta@smartdukaan.com",`
87	`"niranjan.kala@smartdukaan.com", "hemant.kaura@smartdukaan.com", "amit.gupta@shop2020.in",`	87	`"niranjan.kala@smartdukaan.com", "hemant.kaura@smartdukaan.com", "amit.gupta@smartdukaan.com",`
88	`"tejbeer.kaur@shop2020.in");`	88	`"tejbeer.kaur@smartdukaan.com");`
89		89
90	`@Value("${web.api.host}")`	90	`@Value("${web.api.host}")`
91	`private String webApiHost;`	91	`private String webApiHost;`
92		92
93	`@Value("${web.api.scheme}")`	93	`@Value("${web.api.scheme}")`
Line 350...		Line 350...
350	`orderStatus.add(SHIPPED_FROM_WH);`	350	`orderStatus.add(SHIPPED_FROM_WH);`
351	`orderStatus.add(DELIVERY_SUCCESS);`	351	`orderStatus.add(DELIVERY_SUCCESS);`
352		352
353	`List<Order> openOrders = orderRepository.selectGrnTimestampNull(fofoId, orderStatus);`	353	`List<Order> openOrders = orderRepository.selectGrnTimestampNull(fofoId, orderStatus);`
354	`List<LineItem> submittedLineItemIds = openOrders.stream()`	354	`List<LineItem> submittedLineItemIds = openOrders.stream()`
355	`.filter(x -> x.getStatus().equals(SUBMITTED_FOR_PROCESSING))`	355	`.filter(x -> x.getStatus().equals(SUBMITTED_FOR_PROCESSING)).map(x -> x.getLineItem())`
-		356	`.collect(Collectors.toList());`
-		357	`List<LineItem> billedOrderIds = openOrders.stream().filter(x -> x.getStatus().equals(BILLED))`
356	`.map(x -> x.getLineItem()).collect(Collectors.toList());`	358	`.map(x -> x.getLineItem()).collect(Collectors.toList());`
357	`List<LineItem> billedOrderIds = openOrders.stream()`	-
358	`.filter(x -> x.getStatus().equals(BILLED))`	-
359	`.map(x -> x.getLineItem()).collect(Collectors.toList());`	-
360	`List<LineItem> shippedOrderIds = openOrders.stream()`	359	`List<LineItem> shippedOrderIds = openOrders.stream().filter(x -> x.getStatus().equals(SHIPPED_FROM_WH))`
361	`.filter(x -> x.getStatus().equals(SHIPPED_FROM_WH))`	-
362	`.map(x -> x.getLineItem()).collect(Collectors.toList());`	360	`.map(x -> x.getLineItem()).collect(Collectors.toList());`
363	`List<LineItem> grnPendingLineItemIds = openOrders.stream()`	361	`List<LineItem> grnPendingLineItemIds = openOrders.stream()`
364	`.filter(x -> x.getStatus().equals(DELIVERY_SUCCESS))`	362	`.filter(x -> x.getStatus().equals(DELIVERY_SUCCESS)).map(x -> x.getLineItem())`
365	`.map(x -> x.getLineItem()).collect(Collectors.toList());`	363	`.collect(Collectors.toList());`
366		-
367		364
368	`long imeiActivationPendingCount = 0;`	365	`long imeiActivationPendingCount = 0;`
369	`long imeiActivationPendingValue = 0;`	366	`long imeiActivationPendingValue = 0;`
-		367	`List<Integer> grnPendingOrderIds = openOrders.stream()`
370	`List<Integer> grnPendingOrderIds = openOrders.stream().filter(x -> x.getStatus().equals(SHIPPED_FROM_WH) \|\| x.getStatus().equals(DELIVERY_SUCCESS)).map(x -> x.getId()).collect(Collectors.toList());`	368	`.filter(x -> x.getStatus().equals(SHIPPED_FROM_WH) \|\| x.getStatus().equals(DELIVERY_SUCCESS))`
-		369	`.map(x -> x.getId()).collect(Collectors.toList());`
371	`if (grnPendingOrderIds.size() > 0) {`	370	`if (grnPendingOrderIds.size() > 0) {`