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

 import com.spice.profitmandi.common.model.DatasetModel;
 import com.spice.profitmandi.common.model.LegendModel;
 import com.spice.profitmandi.common.model.Notification;
 import com.spice.profitmandi.common.model.OptionsModel;
 import com.spice.profitmandi.common.model.ProfitMandiConstants;
-import com.spice.profitmandi.common.model.SaholicInventoryCIsModel;
 import com.spice.profitmandi.common.model.TitleModel;
 import com.spice.profitmandi.common.web.util.ResponseSender;
 import com.spice.profitmandi.dao.Interface.Campaign;
 import com.spice.profitmandi.dao.entity.auth.AuthUser;
 import com.spice.profitmandi.dao.entity.auth.Menu;
 import com.spice.profitmandi.dao.entity.dtr.NotificationCampaign;
 import com.spice.profitmandi.dao.entity.fofo.FofoStore;
 import com.spice.profitmandi.dao.entity.fofo.PartnerDailyInvestment;
 import com.spice.profitmandi.dao.entity.fofo.PartnerTargetDetails;
 import com.spice.profitmandi.dao.entity.fofo.PartnerType;
-import com.spice.profitmandi.dao.entity.fofo.PartnerTypeChange;
 import com.spice.profitmandi.dao.entity.inventory.ReporticoCacheTable;
-import com.spice.profitmandi.dao.entity.inventory.SaholicInventoryCIS;
 import com.spice.profitmandi.dao.entity.user.Lead;
 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.CreateOfferRequest;
 			List<Position> positions = positionRepository.selectAll(authUser.getId());
 			Map<Integer, AuthUser> authIdAndAuthUserMap = null;
 			ReporticoCacheTable rct = null;
 			Map<Integer, WarehouseWiseStockModel> warehouseStockMap = new HashMap<>();
 			Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
+			LinkedHashMap<Integer, String> wm = new LinkedHashMap<Integer, String>();
+			LinkedHashMap<Integer, String> sortedwm = new LinkedHashMap<Integer, String>();
+			for (Map.Entry<Integer, String> entry : warehouseMap.entrySet()) {
+				wm.put(entry.getKey(), entry.getValue());
+			}
+			wm.put(0, "Total Values");
+			long stockValue = 0;
+			long stockQty = 0;
+			long pendingIndent = 0;
 			Map<Integer, PartnerDetailModel> authIdAndallValues = null;
 			if (positions.size() > 0) {
 				if (positions.stream()
 						.filter(x -> x.getEscalationType().equals(EscalationType.L3)
 								|| x.getEscalationType().equals(EscalationType.L4)
 					AuthUser dummyAuthUser = new AuthUser();
 					dummyAuthUser.setFirstName("Total");
 					dummyAuthUser.setLastName("Values");
 					authIdAndAuthUserMap.put(0, dummyAuthUser);
 					warehouseStockMap = saholicInventoryCISRepository.selectGroupByWarehouse().stream()
 							.collect(Collectors.toMap(x -> x.getWarehouseId(), x -> x));
+					List<WarehouseWiseStockModel> warehouseStocks = saholicInventoryCISRepository
+							.selectGroupByWarehouse();
+					if (!warehouseStocks.isEmpty()) {
+						for (WarehouseWiseStockModel warehouseStock : warehouseStocks) {
+							stockValue += warehouseStock.getStockValue();
+							stockQty += warehouseStock.getStockQty();
+							pendingIndent += warehouseStock.getPendingIndent();
+						}
+						WarehouseWiseStockModel ws = new WarehouseWiseStockModel();
+						ws.setStockQty(stockQty);
+						ws.setStockValue(stockValue);
+						ws.setPendingIndent(pendingIndent);
+						ws.setWarehouseId(0);
+						warehouseStockMap.put(0, ws);
+					}
 					rct = reporticoCacheTableRepository.selectByTableName("SaholicInventoryCIS");
 					LOGGER.info("warehouseStockMap" + warehouseStockMap);
 					authIdAndallValues = this.getL2AuthUserPartnerDetail();
+				}
 					model.addAttribute("warehouses", getWarehouses(positionRetailers));
+				}
 				model.addAttribute("authId", authUser.getId());
+			}
+			LOGGER.info("warehouseMap" + wm);
 			model.addAttribute("reporticoDate", rct);
 			model.addAttribute("authIdAndallValues", authIdAndallValues);
 			model.addAttribute("authIdAndAuthUserMap", authIdAndAuthUserMap);
-			model.addAttribute("warehouseMap", warehouseMap);
+			model.addAttribute("warehouseMap", wm);
 			model.addAttribute("warehouseStockMap", warehouseStockMap);
 		} catch (ProfitMandiBusinessException e) {
+		}
 		List<Menu> menuList = (menus != null) ? this.prepareMenu(menus) : new ArrayList<>();
 		LOGGER.info("menu" + menuList);
 		List<WarehouseWiseBrandStockModel> warehouseWiseBrandStock = saholicInventoryCISRepository
 				.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";
+	}
 		inventoryService.getItemAvailabilityAndIndent();
 		model.addAttribute("response", mvcResponseSender.createResponseString(true));
 		return "response";
+	}
-	@RequestMapping(value = "/getWarehouseWiseBrandItemStock", method = RequestMethod.GET)
+	@RequestMapping(value = "/getWarehouseWiseBrandAndCategory", method = RequestMethod.GET)
-	public String getWarehouseWiseBrandItemStock(HttpServletRequest request, Model model,
+	public String getWarehouseWiseBrandAndCategory(HttpServletRequest request, Model model,
 			@RequestParam List<Integer> warehouseId, @RequestParam List<String> brands, @RequestParam String category)
 			throws Exception {
-		List<WarehouseWiseitemStockModel> warehouseWiseItemStock = saholicInventoryCISRepository
-				.selectWarehouseItemStock(warehouseId, brands, category);
 		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
 		List<String> listbrands = saholicInventoryCISRepository.selectAllBrand();
 		List<String> listCategory = saholicInventoryCISRepository.selectAllSubCategory();
-		model.addAttribute("warehouseWiseItemStock", warehouseWiseItemStock);
 		model.addAttribute("warehouseMap", warehouseMap);
 		model.addAttribute("brands", listbrands);
 		model.addAttribute("listCategory", listCategory);
 		model.addAttribute("selectedBrand", brands);
 		model.addAttribute("selectedWarehouse", warehouseId);
-		LOGGER.info("warehouseWiseItemStock" + warehouseWiseItemStock);
+		model.addAttribute("selectedCategory", category);
 		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());
+		}
 		List<WarehouseWiseitemStockModel> warehouseWiseItemStock = saholicInventoryCISRepository
 				.selectWarehouseItemStock(warehouseId, brands, category);
-		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
 		model.addAttribute("warehouseWiseItemStock", warehouseWiseItemStock);
 		model.addAttribute("warehouseMap", warehouseMap);
 		LOGGER.info("warehouseWiseItemStock" + warehouseWiseItemStock);
 		return "warehouse_item_details";

Subversion Repositories SmartDukaan

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