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

         model.addAttribute("startDate", currentDate.minusDays(30).toLocalDate());
         model.addAttribute("endDate", LocalDate.now());
         model.addAttribute("focoSaleReportList", focoSaleReportList);
         return "foco-sale-report";
+    }
+    @RequestMapping(value = "/franchiseeSalesFetchReportByDate", method = RequestMethod.GET)
+    public String getfranchiseeSalesFetchReport(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();
+        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("endDate", LocalDate.now());
+        model.addAttribute("focoSaleReportList", focoSaleReportList);
+        return "foco-sale-report";
+    }
     @RequestMapping(value = "/downloadFranchiseeSales", method = RequestMethod.GET)
     public ResponseEntity<?> getdownloadFranchiseeSales(HttpServletRequest request,
                                                         @RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,
                                                         @RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate, Model model)
         List<SchemePayoutReportModel> schemePayoutReports = fofoOrderRepository
                 .selectSchemePayoutReport(fofoDetails.getFofoId(), startDate, currentDate);
         LOGGER.info("schemePayoutReports {}", schemePayoutReports);
+       model.addAttribute("startDate", currentDate.minusMonths(3).toLocalDate());
+        model.addAttribute("endDate", LocalDate.now());
+        model.addAttribute("schemePayoutReports", schemePayoutReports);
+        return "scheme-payout-report";
+    }
+    @RequestMapping(value = "/schemePayoutFetchReportByDate", method = RequestMethod.GET)
+    public String getschemePayoutFetchReport(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<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("endDate", LocalDate.now());
         model.addAttribute("schemePayoutReports", schemePayoutReports);
         return "scheme-payout-report";
+    }
+    @RequestMapping(value = "/offerPayoutReport", method = RequestMethod.GET)
+    public String getOfferPayoutReport(HttpServletRequest request, Model model) throws Exception {
+        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
+        LocalDateTime currentDate = LocalDate.now().atStartOfDay();
+        LocalDateTime startDate = currentDate.minusMonths(3).toLocalDate().atStartOfDay();
+        List<OfferPayoutDumpReportModel> offerPayoutDumpReports = fofoOrderRepository
+                .selectOfferPayoutDumpReport(fofoDetails.getFofoId(), startDate, currentDate);
+        LOGGER.info("offerPayoutDumpReports {}", offerPayoutDumpReports);
+        model.addAttribute("startDate", currentDate.minusMonths(3).toLocalDate());
+        model.addAttribute("endDate", LocalDate.now());
+        model.addAttribute("offerPayoutDumpReports", offerPayoutDumpReports);
+        return "offer-payout-dump-report";
+    }
+    @RequestMapping(value = "/offerPayoutFetchReportByDate", method = RequestMethod.GET)
+    public String getOfferPayoutFetchReport(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<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("endDate", LocalDate.now());
+        model.addAttribute("offerPayoutDumpReports", offerPayoutDumpReports);
+        return "offer-payout-dump-report";
+    }
     @RequestMapping(value = "/selectPartnerBillingSummaryReport", method = RequestMethod.GET)
     public String getselectPartnerBillingSummaryReport(HttpServletRequest request, Model model) throws Exception {
         LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
         LocalDateTime currentDate = LocalDate.now().atStartOfDay();
         ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Billing Statement Report");
         return responseEntity;
+    }
     @RequestMapping(value = "/invoiceSchemeOutSummaryReport", method = RequestMethod.GET)
     public String getInvoiceSchemeOutSummaryReport(HttpServletRequest request, Model model) throws Exception {
         LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
                 "invoice wise scheme out Summary Report");
         return responseEntity;
+    }
-    @RequestMapping(value = "/schemePayoutReportDownload", method = RequestMethod.GET)
+   @RequestMapping(value = "/schemePayoutReportDownload", method = RequestMethod.GET)
     public ResponseEntity<?> getSchemePayoutReportDownload(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();
-        LocalDateTime currentStartMonth = currentDate.minusMonths(3).toLocalDate().atStartOfDay();
         List<SchemePayoutReportModel> schemePayoutReports = fofoOrderRepository
-                .selectSchemePayoutReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);
+                .selectSchemePayoutReport(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
         LOGGER.info("schemePayoutReports {}", schemePayoutReports);
         for (SchemePayoutReportModel spr : schemePayoutReports) {
             rows.add(Arrays.asList(spr.getId(), spr.getSerialNumber(), spr.getBrand(), spr.getModelName(),
         ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Scheme Payout Summary Report");
         return responseEntity;
+    }
+    @RequestMapping(value = "/offerPayoutDumpReportDownload", method = RequestMethod.GET)
+    public ResponseEntity<?> getOfferPayoutDumpReportDownload(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<>();
+        List<OfferPayoutDumpReportModel> offerPayoutReports = fofoOrderRepository
+                .selectOfferPayoutDumpReport(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
+        for (OfferPayoutDumpReportModel opdr : offerPayoutReports) {
+            rows.add(Arrays.asList(opdr.getId(),  opdr.getBrand(), opdr.getModelName(),
+                    opdr.getModelNumber(), opdr.getColor(), opdr.getSerialNumber(), opdr.getOfferId(),
+                    opdr.getName(), opdr.getType(),
+                    opdr.getSlabAmount(), opdr.getAmount(),opdr.getDescription(),
+                    opdr.getCreateTimestamp(), opdr.getRejectTimestamp()));
+        }
+        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(Arrays.asList("Id",
+                "Brand", "Model Name", "Model Number", "Color","Serial number",
+                "Offer Id", "Name", "Type", "Slab Amount","Amount",
+                "Description", "Credited On", "Rejected On"), rows);
+        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Offer Payout Summary Report");
+        return responseEntity;
+    }
     @GetMapping("/getAllOnlineOrder")
     public String getAllOrders(HttpServletRequest request, @RequestParam(required = false) LocalDate date, Model model)
             throws ProfitMandiBusinessException {
         LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
         boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());

Subversion Repositories SmartDukaan

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