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

 import com.spice.profitmandi.dao.entity.catalog.Offer;
 import com.spice.profitmandi.dao.entity.catalog.OfferPartner;
 import com.spice.profitmandi.dao.entity.catalog.Offermargin;
 import com.spice.profitmandi.dao.entity.catalog.TagListing;
 import com.spice.profitmandi.dao.entity.cs.Position;
+import com.spice.profitmandi.dao.entity.cs.TicketAssigned;
 import com.spice.profitmandi.dao.entity.dtr.Document;
 import com.spice.profitmandi.dao.entity.dtr.NotificationCampaign;
 import com.spice.profitmandi.dao.entity.fofo.FofoStore;
 import com.spice.profitmandi.dao.entity.fofo.InventoryItem;
 import com.spice.profitmandi.dao.entity.fofo.PartnerDailyInvestment;
 import com.spice.profitmandi.dao.enumuration.catalog.ItemCriteriaType;
 import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
 import com.spice.profitmandi.dao.enumuration.dtr.LeadStatus;
 import com.spice.profitmandi.dao.model.BrandWisePartnerSaleModel;
 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.ItemTypeParams;
 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.repository.catalog.OfferRepository;
 import com.spice.profitmandi.dao.repository.catalog.TagListingRepository;
 import com.spice.profitmandi.dao.repository.cs.CsService;
 import com.spice.profitmandi.dao.repository.cs.PartnersPositionRepository;
 import com.spice.profitmandi.dao.repository.cs.PositionRepository;
+import com.spice.profitmandi.dao.repository.cs.TicketAssignedRepository;
 import com.spice.profitmandi.dao.repository.cs.TicketCategoryRepository;
 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.LeadRepository;
 	private TransactionService transactionService;
 	@Autowired
 	private TagListingRepository tagListingRepository;
+	@Autowired
+	private TicketAssignedRepository ticketAssignedRepository;
 	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 {
 		boolean isAdmin = false;
 						warehouseStockMap.put(0, ws);
+					}
 					warehousePartnerDetailMap = this.getWarehousePartnerDetail();
-					LOGGER.info("warehousePartnerDetailMap" + warehousePartnerDetailMap);
 					rctSaholic = reporticoCacheTableRepository.selectByTableName("SaholicInventoryCIS");
 					rctPartneStat = reporticoCacheTableRepository.selectByTableName("partnerStat");
 					partnersBrandSale = fofoStoreRepository.selectGroupByBrandWarehousePartnerSale();
 					accessoriesBrandSales = fofoStoreRepository.selectGroupByBrandAccesoriesWarehousePartnerSale();
+				}
 				if (positions.stream().filter(x -> x.getEscalationType().equals(EscalationType.L5)).count() > 0) {
 					menus = menuRepository.selectAll();
 				} else {
 					List<Integer> menuIds = menuCategoryRepository.selectAllByPositions(positions).stream()
 							.map(x -> x.getMenuId()).collect(Collectors.toList());
-					LOGGER.info("Menu Ids are {}", menuIds);
 					if (menuIds.size() > 0) {
 						menus = menuRepository.selectAllByIds(menuIds);
+					}
+				}
 				List<Position> salesPositions = positions.stream()
 				.selectGroupByWarehouseAndBrand(warehouseId);
 		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
 		model.addAttribute("warehouseWiseBrandStock", warehouseWiseBrandStock);
 		model.addAttribute("warehouseId", warehouseId);
 		model.addAttribute("warehouseMap", warehouseMap);
-		LOGGER.info("warehouseWiseBrandStock" + warehouseWiseBrandStock);
 		return "warehouse_brand_stock";
+	}
 	@RequestMapping(value = "/getWarehouseWiseData", method = RequestMethod.GET)
 	public String getWarehouseWiseData(HttpServletRequest request, Model model) throws Exception {
 		if (partnerStats != null) {
 			for (Entry<Integer, List<FofoStore>> warehouse : warehousePartnerMap.entrySet()) {
 				List<Integer> fofoIds = warehouse.getValue().stream().map(x -> x.getId()).collect(Collectors.toList());
 				List<PartnerDetailModel> partnerDetails = fofoIds.stream().map(x -> partnerStats.get(x))
 						.collect(Collectors.toList());
-				LOGGER.info("partnerDetails1" + partnerDetails);
 				if (partnerDetails != null && !partnerDetails.isEmpty()) {
 					PartnerDetailModel partnerDetailModel = partnerStatsService.getAggregateStats(partnerDetails);
 					warehouseIdAndallValues.put(warehouse.getKey(), partnerDetailModel);
+				}
+			}
-			LOGGER.info("warehouseIdAndallValues" + warehouseIdAndallValues);
 			PartnerDetailModel partnerDetailModel = partnerStatsService
 					.getAggregateStats(new ArrayList<>(partnerStats.values()));
 			warehouseIdAndallValues.put(0, partnerDetailModel);
+		}
 		return warehouseIdAndallValues;
 		List<WarehouseWiseitemStockModel> warehouseWiseItemStock = saholicInventoryCISRepository
 				.selectWarehouseItemStock(warehouseId, brands, category);
 		model.addAttribute("warehouseWiseItemStock", warehouseWiseItemStock);
 		model.addAttribute("warehouseMap", warehouseMap);
-		LOGGER.info("warehouseWiseItemStock" + warehouseWiseItemStock);
 		return "warehouse_item_details";
+	}
 	private String getWarehouses(Set<CustomRetailer> positionRetailers) {
 		Map<Integer, String> warehouses = new HashMap<>();
 		Set<String> brands = inventoryService.getAllTagListingBrands();
 		model.addAttribute("warehouseWiseBrandPartnerSales", warehouseWiseBrandPartnerSales);
 		model.addAttribute("warehouseMap", warehouseMap);
 		model.addAttribute("brands", brands);
 		model.addAttribute("selectedbrand", brand);
-		LOGGER.info("warehouseWiseBrandPartnerSales" + warehouseWiseBrandPartnerSales);
 		return "warehousewise_brand_partners_sale";
+	}
 	@RequestMapping(value = "/getWarehouseWiseAccesoriesBrandPartnerSale", method = RequestMethod.GET)
 	public String getWarehouseWiseAccesoriesBrandPartnerSale(HttpServletRequest request, Model model,
 		Set<String> brands = inventoryService.getAllTagListingBrands();
 		model.addAttribute("warehouseWiseBrandPartnerSales", warehouseWiseBrandPartnerSales);
 		model.addAttribute("warehouseMap", warehouseMap);
 		model.addAttribute("brands", brands);
 		model.addAttribute("selectedbrand", brand);
-		LOGGER.info("warehouseWiseBrandPartnerSales" + warehouseWiseBrandPartnerSales);
 		return "warehousewise_accessoriesbrand_sale";
+	}
 	@RequestMapping(value = "/getWarehouseBrandWiseItemSale", method = RequestMethod.GET)
 	public String getWarehouseBrandWiseItemSale(HttpServletRequest request, Model model,
 		model.addAttribute("accesorieslmtdsale", accesorieslmtdsale);
 		model.addAttribute("customRetailer", customRetailer);
 		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(
+				curDate.withDayOfMonth(1).minusMonths(1),
+				curDate.with(LocalTime.MAX).minusMonths(1).withDayOfMonth(lengthOfMonth), fofoId);
+		Map<String, Long> brandLmsQty = fofoOrderItemRepository.selectSumQuantityGroupByBrand(
+				curDate.withDayOfMonth(1).minusMonths(1),
+				curDate.with(LocalTime.MAX).minusMonths(1).withDayOfMonth(lengthOfMonth), fofoId);
+		Double accesorieslmssale = fofoOrderRepository
+				.selectSumSaleGroupByFofoIdsForMobileOrAccessories(fofoId, curDate.withDayOfMonth(1).minusMonths(1),
+						curDate.with(LocalTime.MAX).minusMonths(1).withDayOfMonth(lengthOfMonth), Optional.of(false))
+				.get(fofoId);
+		Long accesorieslmsqty = fofoOrderRepository
+				.selectSumSaleQuantityGroupByFofoIdsForMobileOrAccessories(fofoId,
+						curDate.withDayOfMonth(1).minusMonths(1),
+						curDate.with(LocalTime.MAX).minusMonths(1).withDayOfMonth(lengthOfMonth), Optional.of(false))
+				.get(fofoId);
+		model.addAttribute("brandLMSAmount", brandLMSAmount);
+		model.addAttribute("brandLmsQty", brandLmsQty);
+		model.addAttribute("accesorieslmssale", accesorieslmssale);
+		model.addAttribute("accesorieslmsqty", accesorieslmsqty);
+		model.addAttribute("customRetailer", customRetailer);
+		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> mobileStock = currentInventorySnapshotRepository
+		List<InStockBrandModel> mobileStocks = currentInventorySnapshotRepository
 				.selectSumInStockMobileGroupByBrand(fofoId);
-		List<InStockBrandModel> assStock = currentInventorySnapshotRepository
+		List<InStockBrandModel> accesStock = currentInventorySnapshotRepository
 				.selectSumInStockAccessoriesGroupByBrand(fofoId);
+		List<InStockBrandItemModel> stockItemlist = currentInventorySnapshotRepository
+				.selectInStockItemsByBrand(fofoId);
+		Map<String, List<InStockBrandItemModel>> stockItemMap = stockItemlist.stream()
+				.collect(Collectors.groupingBy(InStockBrandItemModel::getBrand));
+		model.addAttribute("stockItemMap", stockItemMap);
-		model.addAttribute("mobileStock", mobileStock);
+		model.addAttribute("mobileStock", mobileStocks);
-		model.addAttribute("assStock", assStock);
+		model.addAttribute("accesStock", accesStock);
 		model.addAttribute("customRetailer", customRetailer);
 		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);
+		for (TicketAssigned ticketAssign : ticketAssigns) {
+			AuthUser authUser = authRepository.selectById(ticketAssign.getAssineeId());
+			ticketIdAuthUser.put(ticketAssign.getTicketId(), authUser);
+		}
+		model.addAttribute("ticketIdAuthUser", ticketIdAuthUser);
+		model.addAttribute("ticketAssigns", ticketAssigns);
+		model.addAttribute("customRetailer", customRetailer);
+		return "open-ticket";
+	}
+}

Subversion Repositories SmartDukaan

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