Subversion Repositories SmartDukaan

import java.time.LocalTime;

			model.addAttribute("planningMonth", currentMonthDate.getMonth());

			model.addAttribute("freezed", true);

		model.addAttribute("previousPlanningMonth", LocalDate.now().minusMonths(1).getMonth());

		model.addAttribute("currentPlanningMonth", LocalDate.now().getMonth());

		model.addAttribute("customRetailers", customRetailers);

		model.addAttribute("totalAmount", totalAmount);

		model.addAttribute("monthlyPlanned", monthlyPlanned);

		model.addAttribute("totalPcs", totalPcs);

		return "open-indent";

	}

	@RequestMapping(value = "/indent/loadIndentPreviousMonth")

	public String previousMonthLoadOpenIndent(HttpServletRequest request, Model model,

			@RequestParam(required = false, defaultValue = "0") int fofoId,

			@RequestParam(defaultValue = "TEN_LAC") CounterSize counterSize) throws Exception {

		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

		Set<Integer> roleIds = loginDetails.getRoleIds();

		LOGGER.info("Counter size is {}", counterSize);

		LOGGER.info("Fofo Id is {}", fofoId);

		boolean isAdmin = roleManager.isAdmin(roleIds);

		List<String> brands = mongoClient.getMongoBrands(fofoId, null, 3).stream().map(x -> (String) x.get("name"))

				.collect(Collectors.toList());

		Map<String, Object> equalsMap = new HashMap<>();

		equalsMap.put("categoryId", 10006);

		equalsMap.put("brand", brands);

		Map<String, List<?>> notEqualsMap = new HashMap<>();

		Map<String, List<?>> notEqualsJoinMap = new HashMap<>();

		Map<Integer, Integer> currentStockMap;

		if (!isAdmin && fofoId == 0) {

			fofoId = cookiesProcessor.getCookiesObject(request).getFofoId();

			Map<String, Object> equalsStockJoinMap = new HashMap<>();

			equalsStockJoinMap.put("fofoId", fofoId);

			currentStockMap = itemRepository

					.selectItems(CurrentInventorySnapshot.class, "id", "itemId", equalsMap, notEqualsMap,

							equalsStockJoinMap, notEqualsJoinMap, "availability")

					.stream().collect(Collectors.toMap(x -> x.getCatalogId(), x -> (int) x.getAggregateValue()));

			LOGGER.info("currentStock");

		} else {

			if (fofoId == 0) {

				Map<String, Object> equalsStockJoinMap = new HashMap<>();

				equalsStockJoinMap.put("fofoId", fofoId);

				currentStockMap = itemRepository

						.selectItems(CurrentInventorySnapshot.class, "id", "itemId", equalsMap, notEqualsMap,

								equalsStockJoinMap, notEqualsJoinMap, "availability")

						.stream().collect(Collectors.toMap(x -> x.getCatalogId(), x -> (int) x.getAggregateValue()));

			} else {

				Map<String, Object> equalsStockJoinMap = new HashMap<>();

				equalsStockJoinMap.put("fofoId", fofoId);

				currentStockMap = itemRepository

						.selectItems(CurrentInventorySnapshot.class, "id", "itemId", equalsMap, notEqualsMap,

								equalsStockJoinMap, notEqualsJoinMap, "availability")

						.stream().collect(Collectors.toMap(x -> x.getCatalogId(), x -> (int) x.getAggregateValue()));

			}

		}

		LOGGER.info("currentStock" + currentStockMap);

		Map<Integer, Integer> itemsInTransit = null;

		List<TagListing> tagListings = tagListingRepository.selectAll(true);

		if (!isAdmin) {

			tagListings = new ArrayList<>(tagListings);

			List<Order> inTransitOrders = orderRepository.selectPendingGrnOrder(fofoId, validOrderStatusList);

			inTransitOrders = this.filterValidOrders(inTransitOrders);

			itemsInTransit = inTransitOrders.stream().collect(Collectors.groupingBy(x -> x.getLineItem().getItemId(),

					Collectors.summingInt(x -> x.getLineItem().getQuantity())));

		} else {

			itemsInTransit = new HashMap<>();

		}

		int totalPcs = 0;

		float totalAmount = 0;

		Map<Integer, CatalogListingModel> catalogListingMap = new HashMap<>();

		Map<Integer, FocusedModel> focusedModelMap = focusedModelRepository.selectAll().stream()

				.collect(Collectors.toMap(FocusedModel::getCatalogId, Function.identity()));

		LocalDate currentMonthDate = LocalDate.now().minusMonths(1).withDayOfMonth(1);

		MonthlyPlanned monthlyPlanned = null;

		monthlyPlanned = monthlyPlannedRepository.selectByFofoIdYearMonth(fofoId, currentMonthDate);

		LOGGER.info("monthlyPlanned2" + monthlyPlanned);

		model.addAttribute("planningMonth", LocalDate.now().minusMonths(1).getMonth());

		model.addAttribute("previousPlanningMonth", LocalDate.now().minusMonths(1).getMonth());

		model.addAttribute("currentPlanningMonth", LocalDate.now().getMonth());

		Map<Integer, Integer> plannedDetailMap = null;

		if (monthlyPlanned != null) {

			plannedDetailMap = plannedDetailRepository.selectByPlannedId(monthlyPlanned.getId()).stream()

					.collect(Collectors.toMap(x -> x.getCatalogId(), x -> x.getQuantity()));

		}

		LOGGER.info("plannedDetailMap" + plannedDetailMap);

		LocalDateTime curDate = LocalDate.now().atStartOfDay();

		List<Integer> fofoOrderIds = fofoOrderRepository

				.selectByFofoIdBetweenCreatedTimeStamp(loginDetails.getFofoId(),

						curDate.withDayOfMonth(1).minusMonths(1), curDate.with(LocalTime.MAX).minusMonths(1))

				.stream().map(x -> x.getId()).collect(Collectors.toList());

		LOGGER.info("fofoOrderIds" + fofoOrderIds);

		Map<String, Object> equalsJoinMap = new HashMap<>();

		equalsJoinMap.put("orderId", fofoOrderIds);

		Map<Integer, Integer> lastMonthSaleMap = itemRepository

				.selectItems(FofoOrderItem.class, "id", "itemId", equalsMap, notEqualsMap, equalsJoinMap,

						notEqualsJoinMap, "quantity")

				.stream().collect(Collectors.toMap(x -> x.getCatalogId(), x -> (int) x.getAggregateValue()));

		LOGGER.info("lastMonthSaleMap" + lastMonthSaleMap);

		Map<Integer, TagListing> taglistingMap = tagListings.stream()

				.collect(Collectors.toMap(x -> x.getItemId(), x -> x));

		List<Item> items = itemRepository.selectByIds(taglistingMap.keySet());

		Map<Integer, List<Item>> catalogIdItemMap = items.stream().collect(

				Collectors.groupingBy(x -> x.getCatalogItemId(), Collectors.mapping(y -> y, Collectors.toList())));

		LOGGER.info("catalogIdItemMap");

		Map<String, Object> equalsItemJoinMap = new HashMap<>();

		equalsItemJoinMap.put("active", 1);

		List<CatalogIdAggregateValue> tagListingCatalogIds = itemRepository.selectItems(TagListing.class, "id",

				"itemId", equalsMap, notEqualsMap, equalsItemJoinMap, notEqualsJoinMap, "tagId");

		LOGGER.info("tagListingCatalogIds");

		for (CatalogIdAggregateValue catalogIdAggregateValue : tagListingCatalogIds) {

			int catalogId = catalogIdAggregateValue.getCatalogId();

			Item item = catalogIdItemMap.get(catalogId).get(0);

			TagListing tagListing = taglistingMap.get(item.getId());

			CatalogListingModel catalogListingModel = catalogListingMap.get(catalogId);

			if (!catalogListingMap.containsKey(catalogId)) {

				catalogListingModel = new CatalogListingModel();

				catalogListingModel.setCatalogId(catalogId);

				catalogListingModel.setDp(tagListing.getSellingPrice());

				catalogListingModel.setMop(tagListing.getMop());

				catalogListingModel.setItemDescription(item.getItemDescriptionNoColor());

				if (plannedDetailMap != null) {

					Integer quantity = plannedDetailMap.get(catalogId);

					if (quantity != null) {

						catalogListingModel.setAllocatedQuantity(quantity);

					}

				}

				if (lastMonthSaleMap != null) {

					Integer lastMonthSale = lastMonthSaleMap.get(catalogId);

					if (lastMonthSale != null) {

						catalogListingModel.setLastMonthSaleMap(lastMonthSale);

					} else {

						catalogListingModel.setLastMonthSaleMap(0);

					}

				} else {

					catalogListingModel.setLast15DaysSale(0);

				}

				catalogListingModel.setBrand(item.getBrand());

				if (item.getCategoryId() == 10006) {

					catalogListingModel.setCategoryId(item.getCategoryId());

				}

				FocusedModel fm = focusedModelMap.get(catalogId);

				if (fm != null) {

					catalogListingModel.setRecommendedQty(fm.getRecommendedQty());

					catalogListingModel.setMinimumQty(fm.getMinimumQty());

				} else {

					catalogListingModel.setRecommendedQty(0);

					catalogListingModel.setMinimumQty(0);

				}

				catalogListingMap.put(catalogId, catalogListingModel);

			}

			int itemAvailability = 0;

			if (currentStockMap != null) {

				Integer qty = currentStockMap.get(catalogId);

				itemAvailability = qty == null ? 0 : qty;

				catalogListingModel.setStockInHand(itemAvailability);

			} else {

				catalogListingModel.setStockInHand(0);

			}

			Integer inTransitQuantity = itemsInTransit.get(item.getId());

			int inTransitQty = (inTransitQuantity == null ? 0 : inTransitQuantity);

			catalogListingModel.setInTransitQuantity(catalogListingModel.getInTransitQuantity() + inTransitQty);

		}

		Map<Integer, CustomRetailer> customRetailersMap = retailerService.getFofoRetailers();

		if (fofoId > 0) {

			CustomRetailer customRetailer = customRetailersMap.get(fofoId);

			model.addAttribute("retailerName",

					customRetailer.getBusinessName() + "-" + customRetailer.getAddress().getCity());

			FofoStore fs = fofoStoreRepository.selectByRetailerId(fofoId);

			model.addAttribute("retailerId", customRetailer.getPartnerId());

			model.addAttribute("counterSize", fs.getCounterSize().toString());

		} else {

			model.addAttribute("counterSize", counterSize.toString());

		}

		String customRetailers = JSONObject.valueToString(customRetailersMap.values());

		List<CatalogListingModel> catalogModelList = new ArrayList<>(catalogListingMap.values());

		Comparator<CatalogListingModel> firstCmp = Comparator.comparing(CatalogListingModel::getMinimumQty,

				Comparator.reverseOrder());

		LOGGER.info("monthlyPlanned" + monthlyPlanned);

		model.addAttribute("catalogTagListings",

				catalogModelList.stream().sorted(firstCmp).collect(Collectors.toList()));

		model.addAttribute("isAdmin", roleManager.isAdmin(roleIds));

		model.addAttribute("previousMonth", true);

		model.addAttribute("freezed", true);

		model.addAttribute("brandStockPrices",this.getBrandStockPrices(loginDetails.getFofoId()));