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

 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.*;
-import com.spice.profitmandi.dao.entity.inventory.ReporticoCacheTable;
 import com.spice.profitmandi.dao.entity.transaction.LineItem;
 import com.spice.profitmandi.dao.entity.transaction.Order;
 import com.spice.profitmandi.dao.enumuration.catalog.UpgradeOfferStatus;
 import com.spice.profitmandi.dao.enumuration.transaction.OrderStatus;
 import com.spice.profitmandi.dao.model.SamsungUpgradeOfferModel;
 import org.springframework.web.bind.annotation.RequestMethod;
 import org.springframework.web.bind.annotation.RequestParam;
 import javax.servlet.http.HttpServletRequest;
 import javax.transaction.Transactional;
-import java.io.*;
+import java.io.File;
+import java.io.FileInputStream;
+import java.io.FileNotFoundException;
 import java.time.LocalDate;
 import java.time.LocalDateTime;
 import java.time.LocalTime;
 import java.time.YearMonth;
 import java.time.format.DateTimeFormatter;
 import java.util.*;
 import java.util.stream.Collectors;
+import static in.shop2020.model.v1.order.OrderStatus.*;
 @Controller
 @Transactional(rollbackOn = Throwable.class)
 public class DashboardController {
 	List<String> emails = Arrays.asList("kamini.sharma@smartdukaan.com", "neeraj.gupta@smartdukaan.com",
 	@RequestMapping(value = "/dashboard", method = RequestMethod.GET)
 	public String dashboard(HttpServletRequest request, Model model) throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		String email = loginDetails.getEmailId();
 		int fofoId = loginDetails.getFofoId();
-		LocalDateTime startDate = LocalDate.now().withDayOfYear(1).atStartOfDay();
-		LocalDateTime endtDate = LocalDateTime.now();
-		OnlineDeliveredOrderSum onlineDeliveredOrderSum = pendingOrderItemRepository
-				.selectSumSellingPriceOnlineOrder(fofoId, startDate, endtDate);
-		LOGGER.info("onlineDeliveredOrderSum" + onlineDeliveredOrderSum.getSellingPrice());
-		long countOrder = pendingOrderRepository.pendingOrderCount(fofoId, OrderStatus.PROCESSING);
-		LOGGER.info("countOrder" + countOrder);
-		ArrayList<in.shop2020.model.v1.order.OrderStatus> orderStatus = new ArrayList<>();
-		orderStatus.add(in.shop2020.model.v1.order.OrderStatus.SUBMITTED_FOR_PROCESSING);
-		orderStatus.add(in.shop2020.model.v1.order.OrderStatus.BILLED);
-		orderStatus.add(in.shop2020.model.v1.order.OrderStatus.SHIPPED_FROM_WH);
-		orderStatus.add(in.shop2020.model.v1.order.OrderStatus.DELIVERY_SUCCESS);
-		List<Order> order = orderRepository.selectGrnTimestampNull(fofoId, orderStatus);
-		List<LineItem> submittedLineItemIds = order.stream()
-				.filter(x -> x.getStatus().equals(in.shop2020.model.v1.order.OrderStatus.SUBMITTED_FOR_PROCESSING))
-				.map(x -> x.getLineItem()).collect(Collectors.toList());
-		List<LineItem> billedOrderIds = order.stream()
-				.filter(x -> x.getStatus().equals(in.shop2020.model.v1.order.OrderStatus.BILLED))
-				.map(x -> x.getLineItem()).collect(Collectors.toList());
-		List<LineItem> shippedOrderIds = order.stream()
-				.filter(x -> x.getStatus().equals(in.shop2020.model.v1.order.OrderStatus.SHIPPED_FROM_WH))
-				.map(x -> x.getLineItem()).collect(Collectors.toList());
-		List<LineItem> grnPendingLineItemIds = order.stream()
-				.filter(x -> x.getStatus().equals(in.shop2020.model.v1.order.OrderStatus.DELIVERY_SUCCESS))
-				.map(x -> x.getLineItem()).collect(Collectors.toList());
-		LOGGER.info("billedOrderIds {}", billedOrderIds);
-		LOGGER.info("shippedOrderIds {}", shippedOrderIds);
-		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("shippedCount", shippedCount);
-		LOGGER.info("shippedCount {}", shippedCount);
-		long shippedValue = shippedOrderIds.stream()
-				.collect(Collectors.summingLong(x -> x.getTotalPrice().longValue()));
-		model.addAttribute("shippedValue", shippedValue);
-		LocalDateTime curDate = LocalDate.now().atStartOfDay();
-		LocalDateTime currentMonthStart = curDate.withDayOfMonth(1);
-		LocalDateTime lastMonthStart = currentMonthStart.minusMonths(1);
-		LocalDateTime currentMonthEnd = currentMonthStart.withDayOfMonth(1);
-		LOGGER.info("lastMonthStart" + lastMonthStart);
-		LOGGER.info("currentMonthEnd" + currentMonthEnd);
-		model.addAttribute("countOrder", countOrder);
-		model.addAttribute("onlineDeliveredOrderSum", onlineDeliveredOrderSum.getSellingPrice());
 		boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());
 		model.addAttribute("isAdmin", isAdmin);
 		model.addAttribute("webApiHost", webApiHost);
 		model.addAttribute("webApiPort", webApiPort);
 				fofoStore = fofoStoreRepository.selectByRetailerId(loginDetails.getFofoId());
 				if (!fofoStore.isActive()) {
 					return "redirect:/login";
+				}
+				LocalDateTime startDate = LocalDate.now().withDayOfYear(1).atStartOfDay();
+				LocalDateTime endtDate = LocalDateTime.now();
+				OnlineDeliveredOrderSum onlineDeliveredOrderSum = pendingOrderItemRepository
+						.selectSumSellingPriceOnlineOrder(fofoId, startDate, endtDate);
+				LOGGER.info("onlineDeliveredOrderSum" + onlineDeliveredOrderSum.getSellingPrice());
+				long countOrder = pendingOrderRepository.pendingOrderCount(fofoId, OrderStatus.PROCESSING);
+				LOGGER.info("countOrder" + countOrder);
+				ArrayList<in.shop2020.model.v1.order.OrderStatus> orderStatus = new ArrayList<>();
+				orderStatus.add(SUBMITTED_FOR_PROCESSING);
+				orderStatus.add(BILLED);
+				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("shippedCount", shippedCount);
+				LOGGER.info("shippedCount {}", shippedCount);
+				long shippedValue = shippedOrderIds.stream()
+						.collect(Collectors.summingLong(x -> x.getTotalPrice().longValue()));
+				model.addAttribute("shippedValue", shippedValue);
+				LocalDateTime curDate = LocalDate.now().atStartOfDay();
+				LocalDateTime currentMonthStart = curDate.withDayOfMonth(1);
+				LocalDateTime lastMonthStart = currentMonthStart.minusMonths(1);
+				LocalDateTime currentMonthEnd = currentMonthStart.withDayOfMonth(1);
+				LOGGER.info("lastMonthStart" + lastMonthStart);
+				LOGGER.info("currentMonthEnd" + currentMonthEnd);
+				model.addAttribute("countOrder", countOrder);
+				model.addAttribute("onlineDeliveredOrderSum", onlineDeliveredOrderSum.getSellingPrice());
 				PartnerType partnerType = partnerTypeChangeService.getTypeOnDate(fofoStore.getId(), LocalDate.now());
 				model.addAttribute("partnerType", partnerType);
 				model.addAttribute("partnerTypeImage", PartnerType.imageMap.get(partnerType));
 				model.addAttribute("fofoStore", fofoStore);
 				model.addAttribute("partnerType", partnerType);
-				model.addAttribute("maa", loginDetails.getFofoId() == 175138885);
 				model.addAttribute("hasGift", fofoUser.hasGift(loginDetails.getFofoId()));
 				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(),
 , 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;
+				}
+				Map<Integer, String> monthValueMap = new HashMap<>();
+				for (int i = 0; i <= 5; i++) {
+					LocalDateTime startOfMonth = LocalDateTime.now().withDayOfMonth(1).minusMonths(i);
+					monthValueMap.put(i, startOfMonth.format(DateTimeFormatter.ofPattern("MMM''uu")));
+				}
+				model.addAttribute("monthValueMap", monthValueMap);
+				model.addAttribute("month", 0);
+				model.addAttribute("hygienePercentage", (hygieneCount * 100) / (invalidHygieneCount + hygieneCount));
+				model.addAttribute("monthDays", LocalDate.now().minusDays(1).lengthOfMonth());
+				model.addAttribute("dayOfMonth", LocalDate.now().minusDays(1).getDayOfMonth());
 			} catch (ProfitMandiBusinessException e) {
 				LOGGER.error("FofoStore Code not found of fofoId {}", loginDetails.getFofoId());
+			}
+			return "dashboard1";
+		}
-		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;
-		}
-		Map<Integer, String> monthValueMap = new HashMap<>();
-		for (int i = 0; i <= 5; i++) {
-			LocalDateTime startOfMonth = LocalDateTime.now().withDayOfMonth(1).minusMonths(i);
-			monthValueMap.put(i, startOfMonth.format(DateTimeFormatter.ofPattern("MMM''uu")));
-		}
-		model.addAttribute("monthValueMap", monthValueMap);
-		model.addAttribute("month", 0);
-		model.addAttribute("hygienePercentage", (hygieneCount * 100) / (invalidHygieneCount + hygieneCount));
-		model.addAttribute("monthDays", LocalDate.now().minusDays(1).lengthOfMonth());
-		model.addAttribute("dayOfMonth", LocalDate.now().minusDays(1).getDayOfMonth());
-		/*
-		 * if (loginDetails.isReadOnly()) { return "dashboard-readonly"; } else { }
-		 */
-		return "dashboard1";
+	}
 	@RequestMapping(value = "/getGrnPendingOrderStatus", method = RequestMethod.GET)
 	public String getGrnPendingOrderStatus(HttpServletRequest request, Model model) throws Exception {
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		int fofoId = loginDetails.getFofoId();
 		ArrayList<in.shop2020.model.v1.order.OrderStatus> orderStatus = new ArrayList<>();
-		orderStatus.add(in.shop2020.model.v1.order.OrderStatus.SHIPPED_FROM_WH);
+		orderStatus.add(SHIPPED_FROM_WH);
 		List<Order> order = orderRepository.selectOrders(fofoId, orderStatus);
 		List<Integer> shippedOrderIds = order.stream().filter(x -> x.getPartnerGrnTimestamp() == null)
 				.map(x -> x.getId()).collect(Collectors.toList());
 		model.addAttribute("shippedOrderIds", shippedOrderIds);
 		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)
+									  @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 = "fofoId", required = true, defaultValue = "0") int fofoId,
-			@RequestParam(name = "brand", required = true, defaultValue = "0") String brand,
+									  @RequestParam(name = "brand", required = true, defaultValue = "0") String brand,
-			@RequestParam(name = "yearMonth", required = false, defaultValue = "0") String yearMonth, Model model)
+									  @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 = "fofoId", required = true, defaultValue = "0") int fofoId,
-			@RequestParam(name = "brand", required = true, defaultValue = "0") String brand, Model model)
+											  @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 = "fofoId", required = true, defaultValue = "0") int fofoId,
-			@RequestParam(name = "brand", required = true, defaultValue = "0") String brand,
+												 @RequestParam(name = "brand", required = true, defaultValue = "0") String brand,
-			@RequestParam(name = "yearMonth", required = false, defaultValue = "0") String yearMonth, Model model)
+												 @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 = "fofoId", required = true, defaultValue = "0") int fofoId,
-			@RequestParam(name = "brand", required = true, defaultValue = "0") String brand, Model model)
+												 @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 = "fofoId", required = true, defaultValue = "0") int fofoId,
-			@RequestParam(name = "brand", required = true, defaultValue = "0") String brand,
+												   @RequestParam(name = "brand", required = true, defaultValue = "0") String brand,
-			@RequestParam(name = "yearMonth", required = false, defaultValue = "0") String yearMonth, Model model)
+												   @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 = "fofoId", required = true, defaultValue = "0") int fofoId,
-			@RequestParam(name = "brand", required = true, defaultValue = "0") String brand, Model model)
+														  @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 {
+											 @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);
 		inventoryService.getItemAvailabilityAndIndent();
 		model.addAttribute("response", mvcResponseSender.createResponseString(true));
 		return "response";
+	}
-	@RequestMapping(value = "/getPartnersStatData", method = RequestMethod.GET)
-	public String getPartnersStatData(HttpServletRequest request, Model model) throws Exception {
-		Map<Integer, PartnerDetailModel> partnerStats = partnerStatsService.getAllPartnerStats();
-		ObjectOutputStream oos = null;
-		FileOutputStream fout = null;
-		try {
-			fout = new FileOutputStream("/tmp/partnerStat.tmp", false);
-			oos = new ObjectOutputStream(fout);
-			oos.writeObject(partnerStats);
-		} catch (Exception ex) {
-			ex.printStackTrace();
-		} finally {
-			if (oos != null) {
-				oos.close();
-			}
-		}
-		ReporticoCacheTable rct = reporticoCacheTableRepository.selectByTableName("partnerStat");
-		if (rct == null) {
-			rct = new ReporticoCacheTable();
-			rct.setTableName("partnerStat");
-		}
-		rct.setLastCreatedTimestamp(LocalDateTime.now());
-		reporticoCacheTableRepository.persist(rct);
-		model.addAttribute("response", mvcResponseSender.createResponseString(true));
-		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)
+												   @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)
+											@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 {
+															 @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 {
+												@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 {
+														  @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(required = false) MessageType messageType,
-			@RequestParam(name = "offset", defaultValue = "0") int offset,
+										   @RequestParam(name = "offset", defaultValue = "0") int offset,
-			@RequestParam(name = "limit", defaultValue = "20") int limit, Model model) throws Exception {
+										   @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)
+												  @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)
+									  @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)
+									@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 {
+									   @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 {
+											  @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 {
+											  @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 {
+											@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 {
+											 @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 {
+											@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 {
+								   @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 {
+										@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)
+										  @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(required = false) LocalDateTime date, @RequestParam(required = false) LocalDateTime endDate,
-			@RequestParam List<Integer> fofoIds, @RequestParam String filterType, Model model) throws Exception {
+									@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, defaultValue = "0") int warehouseId,
-			@RequestParam(required = false) LocalDateTime date, @RequestParam(required = false) LocalDateTime endDate,
+									 @RequestParam(required = false) LocalDateTime date, @RequestParam(required = false) LocalDateTime endDate,
-			Model model) throws Exception {
+									 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(required = false) LocalDateTime date, @RequestParam(required = false) LocalDateTime endDate,
-			@RequestParam List<Integer> fofoIds, @RequestParam String filterType, Model model) throws Exception {
+									@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 {
+														  @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 30347 → 30455