Subversion Repositories SmartDukaan

    @Autowired

    private LoanStatementRepository loanStatementRepository;

    @RequestMapping(value = "/loan/loan-statement", method = RequestMethod.GET)

    public String loanStatement(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,

                                @RequestParam(required = false) LocalDate startDate,

                                @RequestParam(required = false) LocalDate endDate)

            throws Exception {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());

        model.addAttribute("isAdmin", isAdmin);

        return "partner-loan-statement";

    }

    @RequestMapping(value = "/loan/partner-loan-statement-report", method = RequestMethod.GET)

    public String partnerLoanStatement(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,

                                       @RequestParam(required = false) LocalDateTime startDate,

                                       @RequestParam(required = false) LocalDateTime endDate)

            throws Exception {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());

        int partnerId = 0;

        if (fofoId > 0) {

            partnerId = fofoId;

        } else {

            partnerId = loginDetails.getFofoId();

        }

        FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(partnerId);

        List<LoanStatementReportModel> loanStatementReportModels = loanStatementRepository.selectByDatesAndStoreCode(startDate, endDate, fofoStore.getCode());

        model.addAttribute("isAdmin", isAdmin);

        model.addAttribute("loanStatementReportModels", loanStatementReportModels);

        return "partner-loan-statement-summary";

    }

    @RequestMapping(value = "/loan/download-partner-loan-statement-report", method = RequestMethod.GET)

    public ResponseEntity<?> downloadPartnerLoanStatement(HttpServletRequest request, Model model, @RequestParam(defaultValue = "0") int fofoId,

                                                          @RequestParam(required = false) LocalDateTime startDate,

                                                          @RequestParam(required = false) LocalDateTime endDate)

            throws Exception {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        boolean isAdmin = roleManager.isAdmin(loginDetails.getRoleIds());

        int partnerId = 0;

        if (fofoId > 0) {

            partnerId = fofoId;

        } else {

            partnerId = loginDetails.getFofoId();

        }

        FofoStore fofoStore = fofoStoreRepository.selectByRetailerId(partnerId);

        List<List<?>> rows = new ArrayList<>();

        List<LoanStatementReportModel> loanStatementReportModels = loanStatementRepository.selectByDatesAndStoreCode(startDate, endDate, fofoStore.getCode());// Extract the store name from the first loan statement

        String storeName = loanStatementReportModels.get(0).getStoreName();

        DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy HH:mm");

        for (LoanStatementReportModel loanStatement : loanStatementReportModels) {

            rows.add(Arrays.asList(

                    loanStatement.getCode(),  // Code

                    String.valueOf(loanStatement.getId()),  // ID (convert int to string)

                    loanStatement.getStoreName(),  // Store Name

                    loanStatement.getState(),  // State

                    loanStatement.getZone(),  // Zone

                    loanStatement.getArea(),  // Area

                    loanStatement.getTerritory(),  // Territory

                    String.valueOf(loanStatement.getLoanId()),  // Loan ID

                    loanStatement.getInterestRate().toString(),  // Interest Rate (BigDecimal to String)

                    loanStatement.getIntialAmount().toString(),  // Initial Amount (BigDecimal to String)

                    loanStatement.getPendingAmount().toString(),  // Pending Amount (BigDecimal to String)

                    loanStatement.getCreatedOn().format(dateTimeFormatter),  // Created On (format LocalDateTime)

                    loanStatement.getDueDate().format(dateTimeFormatter),  // Due Date (format LocalDateTime)

                    loanStatement.getInterestAccrued().toString(),  // Interest Accrued (BigDecimal to String)

                    loanStatement.getInterestPaid().toString(),  // Interest Paid (BigDecimal to String)

                    String.valueOf(loanStatement.getFreeDays()),  // Free Days (convert int to string)

                    loanStatement.getLoanReferenceType().toString(),  // Loan Reference Type (enum or string)

                    loanStatement.getAmount().toString(),  // Amount (BigDecimal to String)

                    loanStatement.getBusinessDate().format(dateTimeFormatter),  // Business Date (format LocalDateTime)

                    loanStatement.getCreatedAt().format(dateTimeFormatter),  // Created At (format LocalDateTime)

                    loanStatement.getDescription(),  // Description

                    loanStatement.getStatus()  // Status (calculated value)

            ));

        }

        // Set up the headers and create the CSV

        List<String> headers = Arrays.asList("Code", "ID", "Store Name", "State", "Zone", "Area", "Territory", "Loan ID",

                "Interest Rate", "Initial Amount", "Pending Amount", "Created On", "Due Date",

                "Interest Accrued", "Interest Paid", "Free Days", "Loan Reference Type",

                "Amount", "Business Date", "Created At", "Description", "Status");

        // Create the CSV byte stream

        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(headers, rows);

        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Partner Loan Summary Report");

        return responseEntity;

    }