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

         FofoStore fs = fofoStoreRepository.selectByRetailerId(fofoDetails.getFofoId());
         List<FocoSaleReportModel> focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoDetails.getFofoId(),
                 fs.getCode(), startDate.atStartOfDay(), endDate.atStartOfDay());
         LOGGER.info("focoSaleReportList {}", focoSaleReportList);
-        model.addAttribute("startDate", currentDate.minusDays(30).toLocalDate());
+        model.addAttribute("startDate",startDate);
         model.addAttribute("endDate", LocalDate.now());
         model.addAttribute("focoSaleReportList", focoSaleReportList);
         return "foco-sale-report";
+    }
         ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Wallet Statement Report");
         return responseEntity;
+    }
+    @RequestMapping(value = "/walletSummaryFetchReportByDate", method = RequestMethod.GET)
+    public String getwalletSummaryFetchReport(HttpServletRequest request,
+                                             @RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,
+                                             @RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate, Model model)
+            throws Exception {
+        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
+        List<List<?>> rows = new ArrayList<>();
+        LocalDateTime currentDate = LocalDate.now().atStartOfDay();
+        List<WalletSummaryReportModel> walletSummaryReports = fofoOrderRepository
+                .selectWalletSummaryReport(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
+        LOGGER.info("walletSummaryReports {}", walletSummaryReports);
+        model.addAttribute("startDate",startDate);
+        model.addAttribute("endDate", LocalDate.now());
+        model.addAttribute("walletSummaryReports", walletSummaryReports);
+        return "wallet-summary-report";
+    }
     @RequestMapping(value = "/walletSummaryReport", method = RequestMethod.GET)
     public String getWalletSummaryReport(HttpServletRequest request, Model model) throws Exception {
         LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
         model.addAttribute("endDate", LocalDate.now());
         model.addAttribute("pendingIndentReports", pendingIndentReports);
         return "pending-indent-report";
+    }
+    @RequestMapping(value = "/pendingIndentFetchReportByDate", method = RequestMethod.GET)
+    public String getpendingIndentFetchReport(HttpServletRequest request,
+                                             @RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,
+                                             @RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate, Model model)
+            throws Exception {
+        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
+        List<List<?>> rows = new ArrayList<>();
+        LocalDateTime currentDate = LocalDate.now().atStartOfDay();
+        List<PendingIndentReportModel> pendingIndentReports = fofoOrderRepository
+                .selectPendingIndentReport(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
+        LOGGER.info("pendingIndentReports {}", pendingIndentReports);
+        model.addAttribute("startDate",startDate);
+        model.addAttribute("endDate", LocalDate.now());
+        model.addAttribute("pendingIndentReports", pendingIndentReports);
+        return "pending-indent-report";
+    }
     @RequestMapping(value = "/pendingIndentReportDownload", method = RequestMethod.GET)
-    public ResponseEntity<?> getPendingIndentReportDownload(HttpServletRequest request, Model model) throws Exception {
+    public ResponseEntity<?> getPendingIndentReportDownload(HttpServletRequest request,
+                                                            @RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,
+                                                            @RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate, Model model)
+            throws Exception{
         LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
-        LocalDateTime currentDate = LocalDate.now().atStartOfDay();
+        /*LocalDateTime currentDate = LocalDate.now().atStartOfDay();
-        LocalDateTime currentStartMonth = currentDate.minusMonths(2).toLocalDate().atStartOfDay();
+        LocalDateTime currentStartMonth = currentDate.minusMonths(2).toLocalDate().atStartOfDay();*/
         List<List<?>> rows = new ArrayList<>();
         List<PendingIndentReportModel> pendingIndentReports = fofoOrderRepository
-                .selectPendingIndentReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);
+                .selectPendingIndentReport(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
         LOGGER.info("pendingIndentReports {}", pendingIndentReports);
         DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy HH:mm");
         for (PendingIndentReportModel pir : pendingIndentReports) {
         LocalDateTime currentDate = LocalDate.now().atStartOfDay();
         List<SchemePayoutReportModel> schemePayoutReports = fofoOrderRepository
                 .selectSchemePayoutReport(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
         LOGGER.info("schemePayoutReports {}", schemePayoutReports);
-        model.addAttribute("startDate", currentDate.minusMonths(3).toLocalDate());
+        model.addAttribute("startDate",startDate);
         model.addAttribute("endDate", LocalDate.now());
         model.addAttribute("schemePayoutReports", schemePayoutReports);
         return "scheme-payout-report";
+    }
         LocalDateTime currentDate = LocalDate.now().atStartOfDay();
         List<OfferPayoutDumpReportModel> offerPayoutDumpReports = fofoOrderRepository
                 .selectOfferPayoutDumpReport(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
         LOGGER.info("offerPayoutDumpReports {}", offerPayoutDumpReports);
-        model.addAttribute("startDate", currentDate.minusMonths(3).toLocalDate());
+        model.addAttribute("startDate",startDate);
         model.addAttribute("endDate", LocalDate.now());
         model.addAttribute("offerPayoutDumpReports", offerPayoutDumpReports);
         return "offer-payout-dump-report";
         model.addAttribute("endDate", LocalDate.now());
         model.addAttribute("priceDropReports", priceDropReports);
         return "price-drop-report";
+    }
+    @RequestMapping(value = "/priceDropFetchReportByDate", method = RequestMethod.GET)
+    public String getpriceDropFetchReportByDate(HttpServletRequest request,
+                                                @RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,
+                                                @RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate, Model model)
+            throws Exception {
+            LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
+            List<List<?>> rows = new ArrayList<>();
+            LocalDateTime currentDate = LocalDate.now().atStartOfDay();
+            List<PriceDropReportModel> priceDropReports = orderRepository.selectPriceDropReport(fofoDetails.getFofoId(),
+                    startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
+                 model.addAttribute("startDate",startDate);
+                model.addAttribute("endDate", LocalDate.now());
+                model.addAttribute("priceDropReports", priceDropReports);
+        return "price-drop-report";
+    }
     @RequestMapping(value = "/downloadPriceDropReport", method = RequestMethod.GET)
     public ResponseEntity<?> getSelectDownloadPriceDropReport(HttpServletRequest request,
                                                               @RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,
                                                               @RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate, Model model)

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/OrderController.java – Rev 33010 → 33067