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

+		}
+	}
 	@RequestMapping(value = "/downloadCollectionSummary", method = RequestMethod.GET)
 	public ResponseEntity<?> getDownloadCollectionSummary(HttpServletRequest request,
-														  @RequestParam int fofoId,
+														  @RequestParam(defaultValue = "0") int fofoId,
 														  @RequestParam(name = "startDate") LocalDate startDate,
 														  @RequestParam(name = "endDate") LocalDate endDate, Model model) throws Exception {
 		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
 		List<List<?>> rows = new ArrayList<>();
 		boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
 		List<CollectionSummary> collectionSummaryList = null;
 		if (isAdmin) {
+			if (fofoId == 0) {
+				collectionSummaryList = new ArrayList<>();
+			} else {
-			collectionSummaryList = orderRepository.selectCollectionSummary(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
+				collectionSummaryList = orderRepository.selectCollectionSummary(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
+			}
 		} else {
-			fofoId = fofoDetails.getFofoId();
-			collectionSummaryList = orderRepository.selectCollectionSummary(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
+			collectionSummaryList = orderRepository.selectCollectionSummary(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
+		}
 		Logger.info("CollectionSummaryList {}", collectionSummaryList);
 		DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy HH:mm");
 		for (CollectionSummary cs : collectionSummaryList) {
 			rows.add(Arrays.asList(cs.getDate().format(
+	}
 	@RequestMapping(value = "/downloadFranchiseeSales", method = RequestMethod.GET)
 	public ResponseEntity<?> getdownloadFranchiseeSales(HttpServletRequest request,
-														@RequestParam int fofoId,
+														@RequestParam(defaultValue = "0") int fofoId,
 														@RequestParam(name = "startDate") LocalDate startDate,
 														@RequestParam(name = "endDate") LocalDate endDate,
 														Model model)
 			throws Exception {
 		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
 		boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
 		List<FocoSaleReportModel> focoSaleReportList = null;
 		FofoStore fs = null;
 		if (isAdmin) {
 			fs = fofoStoreRepository.selectByRetailerId(fofoId);
+			if (fofoId == 0) {
+				focoSaleReportList = new ArrayList<>();
+			} else {
-			focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoId,
+				focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoId,
-					fs.getCode(), startDate.atStartOfDay(), endDate.atStartOfDay());
+						fs.getCode(), startDate.atStartOfDay(), endDate.atStartOfDay());
+			}
 		} else {
-			fofoId = fofoDetails.getFofoId();
-			fs = fofoStoreRepository.selectByRetailerId(fofoId);
+			fs = fofoStoreRepository.selectByRetailerId(fofoDetails.getFofoId());
 			focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoDetails.getFofoId(),
 					fs.getCode(), startDate.atStartOfDay(), endDate.atStartOfDay());
+		}
 		LOGGER.info("FocoSaleReportList {}", focoSaleReportList);
 		List<List<?>> rows = new ArrayList<>();
 		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
 		boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
 		List<WalletSummaryReportModel> walletSummartList = null;
 		if (isAdmin) {
+			if (fofoId == 0)
+				walletSummartList = new ArrayList<>();
+			else
-			walletSummartList = fofoOrderRepository.selectWalletSummaryReport(
+				walletSummartList = fofoOrderRepository.selectWalletSummaryReport(
 					fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
 		} else {
 			walletSummartList = fofoOrderRepository.selectWalletSummaryReport(
 					fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
+	}
 	@RequestMapping(value = "/pendingIndentReportDownload", method = RequestMethod.GET)
 	public ResponseEntity<?> getPendingIndentReportDownload(HttpServletRequest request,
-															@RequestParam int fofoId,
+															@RequestParam(defaultValue = "0") int fofoId,
 															@RequestParam(name = "startDate") LocalDate startDate,
 															@RequestParam(name = "endDate") LocalDate endDate, Model model)
 			throws Exception {
 		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
 		boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
         /*LocalDateTime currentDate = LocalDate.now().atStartOfDay();
         LocalDateTime currentStartMonth = currentDate.minusMonths(2).toLocalDate().atStartOfDay();*/
 		List<PendingIndentReportModel> pendingIndentReports = null;
 		List<List<?>> rows = new ArrayList<>();
 		if (isAdmin) {
+			if (fofoId == 0)
+				pendingIndentReports = new ArrayList<>();
+			else
-			pendingIndentReports = fofoOrderRepository
+				pendingIndentReports = fofoOrderRepository
 					.selectPendingIndentReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
 		} else {
 			pendingIndentReports = fofoOrderRepository
 					.selectPendingIndentReport(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
+	}
 	@RequestMapping(value = "/downloadPriceDropReport", method = RequestMethod.GET)
 	public ResponseEntity<?> getSelectDownloadPriceDropReport(HttpServletRequest request,
-															  @RequestParam() int fofoId,
+															  @RequestParam(defaultValue = "0") int fofoId,
 															  @RequestParam(name = "startDate") LocalDate startDate,
 															  @RequestParam(name = "endDate") LocalDate endDate, Model model)
 			throws Exception {
 		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
 		boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
 		List<List<?>> rows = new ArrayList<>();
 		List<PriceDropReportModel> priceDropReports = null;
 		if (isAdmin) {
+			if (fofoId == 0)
+				priceDropReports = new ArrayList<>();
+			else
-			priceDropReports = orderRepository.selectPriceDropReport(fofoId,
+				priceDropReports = orderRepository.selectPriceDropReport(fofoId,
 					startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
 		} else {
 			fofoId = fofoDetails.getFofoId();
 			priceDropReports = orderRepository.selectPriceDropReport(fofoId,
 					startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
 		return responseEntity;
+	}
 	@RequestMapping(value = "/schemePayoutReportDownload", method = RequestMethod.GET)
 	public ResponseEntity<?> getSchemePayoutReportDownload(HttpServletRequest request,
-														   @RequestParam int fofoId,
+														   @RequestParam(defaultValue = "0") int fofoId,
 														   @RequestParam(name = "startDate") LocalDate startDate,
 														   @RequestParam(name = "endDate") LocalDate endDate, Model model)
 			throws Exception {
 		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
 		boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
 		List<SchemePayoutReportModel> schemePayoutReports = null;
 		if (isAdmin) {
+			if (fofoId == 0)
+				schemePayoutReports = new ArrayList<>();
+			else
-			schemePayoutReports = fofoOrderRepository
+				schemePayoutReports = fofoOrderRepository
 					.selectSchemePayoutReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
 		} else {
 			fofoId = fofoDetails.getFofoId();
 			schemePayoutReports = fofoOrderRepository
 					.selectSchemePayoutReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
+	}
 	@RequestMapping(value = "/offerPayoutDumpReportDownload", method = RequestMethod.GET)
 	public ResponseEntity<?> getOfferPayoutDumpReportDownload(HttpServletRequest request,
-															  @RequestParam int fofoId,
+															  @RequestParam(defaultValue = "0") int fofoId,
 															  @RequestParam(name = "startDate") LocalDate startDate,
 															  @RequestParam(name = "endDate") LocalDate endDate, Model model)
 			throws Exception {
 		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
 		List<List<?>> rows = new ArrayList<>();
 		boolean isAdmin = roleManager.isAdmin(fofoDetails.getRoleIds());
 		List<OfferPayoutDumpReportModel> offerPayoutReports = null;
 		if (isAdmin) {
+			if (fofoId == 0)
+				offerPayoutReports = new ArrayList<>();
+			else
-			offerPayoutReports = fofoOrderRepository
+				offerPayoutReports = fofoOrderRepository
 					.selectOfferPayoutDumpReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
 		} else {
 			fofoId = fofoDetails.getFofoId();
 			offerPayoutReports = fofoOrderRepository
 					.selectOfferPayoutDumpReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/ReportsController.java – Rev 33102 → 33108