Subversion Repositories SmartDukaan

Rev

Rev 27509 | Rev 27538 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 27509 Rev 27529
Line 51... Line 51...
51 
import com.spice.profitmandi.common.model.DatasetModel;
 51 
import com.spice.profitmandi.common.model.DatasetModel;
52 
import com.spice.profitmandi.common.model.LegendModel;
 52 
import com.spice.profitmandi.common.model.LegendModel;
53 
import com.spice.profitmandi.common.model.Notification;
 53 
import com.spice.profitmandi.common.model.Notification;
54 
import com.spice.profitmandi.common.model.OptionsModel;
 54 
import com.spice.profitmandi.common.model.OptionsModel;
55 
import com.spice.profitmandi.common.model.ProfitMandiConstants;
 55 
import com.spice.profitmandi.common.model.ProfitMandiConstants;
- 
 
 56 
import com.spice.profitmandi.common.model.SaholicInventoryCIsModel;
56 
import com.spice.profitmandi.common.model.TitleModel;
 57 
import com.spice.profitmandi.common.model.TitleModel;
57 
import com.spice.profitmandi.common.web.util.ResponseSender;
 58 
import com.spice.profitmandi.common.web.util.ResponseSender;
58 
import com.spice.profitmandi.dao.Interface.Campaign;
 59 
import com.spice.profitmandi.dao.Interface.Campaign;
59 
import com.spice.profitmandi.dao.entity.auth.AuthUser;
 60 
import com.spice.profitmandi.dao.entity.auth.AuthUser;
60 
import com.spice.profitmandi.dao.entity.auth.Menu;
 61 
import com.spice.profitmandi.dao.entity.auth.Menu;
Line 68... Line 69...
68 
import com.spice.profitmandi.dao.entity.fofo.FofoStore;
 69 
import com.spice.profitmandi.dao.entity.fofo.FofoStore;
69 
import com.spice.profitmandi.dao.entity.fofo.PartnerDailyInvestment;
 70 
import com.spice.profitmandi.dao.entity.fofo.PartnerDailyInvestment;
70 
import com.spice.profitmandi.dao.entity.fofo.PartnerTargetDetails;
 71 
import com.spice.profitmandi.dao.entity.fofo.PartnerTargetDetails;
71 
import com.spice.profitmandi.dao.entity.fofo.PartnerType;
 72 
import com.spice.profitmandi.dao.entity.fofo.PartnerType;
72 
import com.spice.profitmandi.dao.entity.fofo.PartnerTypeChange;
 73 
import com.spice.profitmandi.dao.entity.fofo.PartnerTypeChange;
- 
 
 74 
import com.spice.profitmandi.dao.entity.inventory.ReporticoCacheTable;
- 
 
 75 
import com.spice.profitmandi.dao.entity.inventory.SaholicInventoryCIS;
73 
import com.spice.profitmandi.dao.entity.user.Lead;
 76 
import com.spice.profitmandi.dao.entity.user.Lead;
74 
import com.spice.profitmandi.dao.enumuration.catalog.ItemCriteriaType;
 77 
import com.spice.profitmandi.dao.enumuration.catalog.ItemCriteriaType;
75 
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
 78 
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
76 
import com.spice.profitmandi.dao.enumuration.dtr.LeadStatus;
 79 
import com.spice.profitmandi.dao.enumuration.dtr.LeadStatus;
77 
import com.spice.profitmandi.dao.model.CreateOfferRequest;
 80 
import com.spice.profitmandi.dao.model.CreateOfferRequest;
Line 109... Line 112...
109 
import com.spice.profitmandi.dao.repository.fofo.InventoryItemRepository;
 112 
import com.spice.profitmandi.dao.repository.fofo.InventoryItemRepository;
110 
import com.spice.profitmandi.dao.repository.fofo.PartnerDailyInvestmentRepository;
 113 
import com.spice.profitmandi.dao.repository.fofo.PartnerDailyInvestmentRepository;
111 
import com.spice.profitmandi.dao.repository.fofo.PartnerTargetRepository;
 114 
import com.spice.profitmandi.dao.repository.fofo.PartnerTargetRepository;
112 
import com.spice.profitmandi.dao.repository.fofo.PartnerTypeChangeRepository;
 115 
import com.spice.profitmandi.dao.repository.fofo.PartnerTypeChangeRepository;
113 
import com.spice.profitmandi.dao.repository.fofo.PartnerTypeChangeService;
 116 
import com.spice.profitmandi.dao.repository.fofo.PartnerTypeChangeService;
- 
 
 117 
import com.spice.profitmandi.dao.repository.inventory.ReporticoCacheTableRepository;
- 
 
 118 
import com.spice.profitmandi.dao.repository.inventory.SaholicInventoryCISRepository;
114 
import com.spice.profitmandi.dao.repository.inventory.SaholicInventorySnapshotRepository;
 119 
import com.spice.profitmandi.dao.repository.inventory.SaholicInventorySnapshotRepository;
115 
import com.spice.profitmandi.service.PartnerInvestmentService;
 120 
import com.spice.profitmandi.service.PartnerInvestmentService;
116 
import com.spice.profitmandi.service.PartnerStatsService;
 121 
import com.spice.profitmandi.service.PartnerStatsService;
117 
import com.spice.profitmandi.service.authentication.RoleManager;
 122 
import com.spice.profitmandi.service.authentication.RoleManager;
118 
import com.spice.profitmandi.service.inventory.InventoryService;
 123 
import com.spice.profitmandi.service.inventory.InventoryService;
119 
import com.spice.profitmandi.service.user.RetailerService;
 124 
import com.spice.profitmandi.service.user.RetailerService;
120 
import com.spice.profitmandi.web.model.LoginDetails;
 125 
import com.spice.profitmandi.web.model.LoginDetails;
121 
import com.spice.profitmandi.web.util.CookiesProcessor;
 126 
import com.spice.profitmandi.web.util.CookiesProcessor;
- 
 
 127 
import com.spice.profitmandi.web.util.MVCResponseSender;
122 
 
 128 
 
123 
@Controller
 129 
@Controller
124 
@Transactional(rollbackOn = Throwable.class)
 130 
@Transactional(rollbackOn = Throwable.class)
125 
public class DashboardController {
 131 
public class DashboardController {
126 
 
 132 
 
Line 241... Line 247...
241 
	@Autowired
 247 
	@Autowired
242 
	private OfferPartnerRepository offerPartnerRepository;
 248 
	private OfferPartnerRepository offerPartnerRepository;
243 
 
 249 
 
244 
	@Autowired
 250 
	@Autowired
245 
	private OfferMarginRepository offerMarginRepository;
 251 
	private OfferMarginRepository offerMarginRepository;
- 
 
 252 
 
246 
	@Autowired
 253 
	@Autowired
247 
	private ItemRepository itemRepository;
 254 
	private ItemRepository itemRepository;
248 
 
 255 
 
249 
	@Autowired
 256 
	@Autowired
250 
	private SaholicInventorySnapshotRepository saholicInventorySnapshotRepository;
 257 
	private SaholicInventorySnapshotRepository saholicInventorySnapshotRepository;
- 
 
 258 
 
- 
 
 259 
	@Autowired
- 
 
 260 
	private SaholicInventoryCISRepository saholicInventoryCISRepository;
- 
 
 261 
 
- 
 
 262 
	@Autowired
- 
 
 263 
	private MVCResponseSender mvcResponseSender;
- 
 
 264 
 
- 
 
 265 
	@Autowired
- 
 
 266 
	private ReporticoCacheTableRepository reporticoCacheTableRepository;
- 
 
 267 
 
251 
	private static final Logger LOGGER = LogManager.getLogger(DashboardController.class);
 268 
	private static final Logger LOGGER = LogManager.getLogger(DashboardController.class);
252 
 
 269 
 
253 
	@RequestMapping(value = "/12dashboard34", method = RequestMethod.GET)
 270 
	@RequestMapping(value = "/12dashboard34", method = RequestMethod.GET)
254 
	public String dashboard1(HttpServletRequest request, Model model, @RequestParam int fofoId) throws Exception {
 271 
	public String dashboard1(HttpServletRequest request, Model model, @RequestParam int fofoId) throws Exception {
255 
		boolean isAdmin = false;
 272 
		boolean isAdmin = false;
Line 757... Line 774...
757 
		List<Menu> menus = null;
 774 
		List<Menu> menus = null;
758 
		try {
 775 
		try {
759 
			AuthUser authUser = authRepository.selectByEmailOrMobile(email);
 776 
			AuthUser authUser = authRepository.selectByEmailOrMobile(email);
760 
			List<Position> positions = positionRepository.selectAll(authUser.getId());
 777 
			List<Position> positions = positionRepository.selectAll(authUser.getId());
761 
			Map<Integer, AuthUser> authIdAndAuthUserMap = null;
 778 
			Map<Integer, AuthUser> authIdAndAuthUserMap = null;
762 
 
 - 
 
- 
 
 779 
			ReporticoCacheTable rct = null;
763 
			Map<Integer, WarehouseWiseStockModel> warehouseStockMap = new HashMap<>();
 780 
			Map<Integer, WarehouseWiseStockModel> warehouseStockMap = new HashMap<>();
764 
			Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
 781 
			Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
765 
			Map<Integer, PartnerDetailModel> authIdAndallValues = null;
 782 
			Map<Integer, PartnerDetailModel> authIdAndallValues = null;
766 
			if (positions.size() > 0) {
 783 
			if (positions.size() > 0) {
767 
				if (positions.stream()
 784 
				if (positions.stream()
Line 780... Line 797...
780 
 
 797 
 
781 
					AuthUser dummyAuthUser = new AuthUser();
 798 
					AuthUser dummyAuthUser = new AuthUser();
782 
					dummyAuthUser.setFirstName("Total");
 799 
					dummyAuthUser.setFirstName("Total");
783 
					dummyAuthUser.setLastName("Values");
 800 
					dummyAuthUser.setLastName("Values");
784 
					authIdAndAuthUserMap.put(0, dummyAuthUser);
 801 
					authIdAndAuthUserMap.put(0, dummyAuthUser);
- 
 
 802 
 
785 
					warehouseStockMap = saholicInventorySnapshotRepository.selectGroupByWarehouse().stream()
 803 
					warehouseStockMap = saholicInventoryCISRepository.selectGroupByWarehouse().stream()
786 
							.collect(Collectors.toMap(x -> x.getWarehouseId(), x -> x));
 804 
							.collect(Collectors.toMap(x -> x.getWarehouseId(), x -> x));
787 
 
 805 
 
- 
 
 806 
					rct = reporticoCacheTableRepository.selectByTableName("SaholicInventoryCIS");
788 
					LOGGER.info("warehouseStockMap" + warehouseStockMap);
 807 
					LOGGER.info("warehouseStockMap" + warehouseStockMap);
- 
 
 808 
 
789 
					authIdAndallValues = this.getL2AuthUserPartnerDetail();
 809 
					authIdAndallValues = this.getL2AuthUserPartnerDetail();
790 
				}
 810 
				}
791 
			}
 811 
			}
792 
 
 812 
 
793 
			if (Arrays.asList("amit.gupta@shop2020.in", "tejbeer.kaur@shop2020.in", "manish.tiwari@smartdukaan.com")
 813 
			if (Arrays.asList("amit.gupta@shop2020.in", "tejbeer.kaur@shop2020.in", "manish.tiwari@smartdukaan.com")
Line 829... Line 849...
829 
					model.addAttribute("warehouses", getWarehouses(positionRetailers));
 849 
					model.addAttribute("warehouses", getWarehouses(positionRetailers));
830 
				}
 850 
				}
831 
				model.addAttribute("authId", authUser.getId());
 851 
				model.addAttribute("authId", authUser.getId());
832 
 
 852 
 
833 
			}
 853 
			}
834 
 
 - 
 
- 
 
 854 
			model.addAttribute("reporticoDate", rct);
835 
			model.addAttribute("authIdAndallValues", authIdAndallValues);
 855 
			model.addAttribute("authIdAndallValues", authIdAndallValues);
836 
			model.addAttribute("authIdAndAuthUserMap", authIdAndAuthUserMap);
 856 
			model.addAttribute("authIdAndAuthUserMap", authIdAndAuthUserMap);
837 
			model.addAttribute("warehouseMap", warehouseMap);
 857 
			model.addAttribute("warehouseMap", warehouseMap);
838 
			model.addAttribute("warehouseStockMap", warehouseStockMap);
 858 
			model.addAttribute("warehouseStockMap", warehouseStockMap);
839 
		} catch (ProfitMandiBusinessException e) {
 859 
		} catch (ProfitMandiBusinessException e) {
Line 954... Line 974...
954 
 
 974 
 
955 
	@RequestMapping(value = "/getWarehouseWiseBrandStock", method = RequestMethod.GET)
 975 
	@RequestMapping(value = "/getWarehouseWiseBrandStock", method = RequestMethod.GET)
956 
	public String getWarehouseWiseBrandStock(HttpServletRequest request, Model model, @RequestParam int warehouseId)
 976 
	public String getWarehouseWiseBrandStock(HttpServletRequest request, Model model, @RequestParam int warehouseId)
957 
			throws Exception {
 977 
			throws Exception {
958 
 
 978 
 
959 
		List<WarehouseWiseBrandStockModel> warehouseWiseBrandStock = saholicInventorySnapshotRepository
 979 
		List<WarehouseWiseBrandStockModel> warehouseWiseBrandStock = saholicInventoryCISRepository
960 
				.selectGroupByWarehouseAndBrand(warehouseId);
 980 
				.selectGroupByWarehouseAndBrand(warehouseId);
961 
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
 981 
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
962 
		model.addAttribute("warehouseWiseBrandStock", warehouseWiseBrandStock);
 982 
		model.addAttribute("warehouseWiseBrandStock", warehouseWiseBrandStock);
963 
		model.addAttribute("warehouseMap", warehouseMap);
 983 
		model.addAttribute("warehouseMap", warehouseMap);
964 
		LOGGER.info("warehouseWiseBrandStock" + warehouseWiseBrandStock);
 984 
		LOGGER.info("warehouseWiseBrandStock" + warehouseWiseBrandStock);
965 
		return "warehouse_brand_stock";
 985 
		return "warehouse_brand_stock";
966 
	}
 986 
	}
967 
 
 987 
 
- 
 
 988 
	@RequestMapping(value = "/getWarehouseWiseData", method = RequestMethod.GET)
- 
 
 989 
	public String getWarehouseWiseData(HttpServletRequest request, Model model) throws Exception {
- 
 
 990 
		inventoryService.getItemAvailabilityAndIndent();
- 
 
 991 
		model.addAttribute("response", mvcResponseSender.createResponseString(true));
- 
 
 992 
		return "response";
- 
 
 993 
	}
- 
 
 994 
 
968 
	@RequestMapping(value = "/getWarehouseWiseBrandItemStock", method = RequestMethod.GET)
 995 
	@RequestMapping(value = "/getWarehouseWiseBrandItemStock", method = RequestMethod.GET)
969 
	public String getWarehouseWiseBrandItemStock(HttpServletRequest request, Model model, @RequestParam int warehouseId,
 996 
	public String getWarehouseWiseBrandItemStock(HttpServletRequest request, Model model, @RequestParam int warehouseId,
970 
			@RequestParam String brand) throws Exception {
 997 
			@RequestParam List<String> brands) throws Exception {
971 
 
 998 
 
972 
		List<WarehouseWiseitemStockModel> warehouseWiseItemStock = saholicInventorySnapshotRepository
 999 
		List<WarehouseWiseitemStockModel> warehouseWiseItemStock = saholicInventoryCISRepository
973 
				.selectWarehouseItemStock(warehouseId, brand);
 1000 
				.selectWarehouseItemStock(warehouseId, brands);
974 
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
 1001 
		Map<Integer, String> warehouseMap = ProfitMandiConstants.WAREHOUSE_MAP;
975 
		List<String> brands = mongoClient.getAllBrandsToDisplay(0).stream().map(x -> (String) x.get("name"))
 1002 
		List<String> listbrands = saholicInventoryCISRepository.selectAllBrand();
976 
				.collect(Collectors.toList());
 - 
 
977 
 
 - 
 
978 
		model.addAttribute("warehouseWiseItemStock", warehouseWiseItemStock);
 1003 
		model.addAttribute("warehouseWiseItemStock", warehouseWiseItemStock);
979 
		model.addAttribute("warehouseMap", warehouseMap);
 1004 
		model.addAttribute("warehouseMap", warehouseMap);
- 
 
 1005 
		model.addAttribute("warehouseId", warehouseId);
980 
		model.addAttribute("brands", brands);
 1006 
		model.addAttribute("brands", listbrands);
- 
 
 1007 
		model.addAttribute("selectedBrand", brands);
981 
		LOGGER.info("warehouseWiseItemStock" + warehouseWiseItemStock);
 1008 
		LOGGER.info("warehouseWiseItemStock" + warehouseWiseItemStock);
982 
		return "warehouse_brand_item_stock";
 1009 
		return "warehouse_brand_item_stock";
983 
	}
 1010 
	}
984 
 
 1011 
 
985 
	private String getWarehouses(Set<CustomRetailer> positionRetailers) {
 1012 
	private String getWarehouses(Set<CustomRetailer> positionRetailers) {