Subversion Repositories SmartDukaan

import com.spice.profitmandi.dao.entity.transaction.UserWallet;

import com.spice.profitmandi.dao.entity.transaction.UserWalletHistory;

import com.spice.profitmandi.dao.repository.transaction.StatementDetailModel;

import com.spice.profitmandi.dao.repository.transaction.UserWalletHistoryRepository;

import com.spice.profitmandi.service.transaction.TransactionService;

import com.spice.profitmandi.service.wallet.WalletService;

import in.shop2020.model.v1.order.WalletReferenceType;

    @Autowired

    private WalletService walletService;

    @Autowired

    private UserWalletHistoryRepository userWalletHistoryRepository;

    @Autowired

    private TransactionService transactionService;

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

    public String accountStatement(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-account-statement";

    }

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

    public String getPartnerAccountStatement(HttpServletRequest request, @RequestParam LocalDateTime startDate, @RequestParam LocalDateTime endDate, Model model, @RequestParam(defaultValue = "0") int fofoId) throws Exception {

        boolean isAdmin = roleManager.isAdmin(cookiesProcessor.getCookiesObject(request).getRoleIds());

        if (fofoId > 0) {

            if (!isAdmin) {

                throw new ProfitMandiBusinessException("Unauthorised access", "PartnerId", "Permission Denied");

            }

        } else {

            fofoId = cookiesProcessor.getCookiesObject(request).getFofoId();

        }

        float openingBalance = walletService.getOpeningTill(fofoId, startDate);

        float closingBalance = walletService.getOpeningTill(fofoId, endDate);

        UserWallet uw = walletService.getUserWallet(fofoId);

        LOGGER.info("Start date - {}, end Date - {}", startDate, endDate);

        List<UserWalletHistory> history = userWalletHistoryRepository.selectPaginatedByWalletId(uw.getId(), startDate, endDate, 0, 0);

        history = history.stream().filter(x -> !x.getReferenceType().equals(WalletReferenceType.PURCHASE))

                .filter(x -> !WalletService.CN_WALLET_REFERENCES.contains(x.getReferenceType())).sorted(Comparator.comparing(UserWalletHistory::getId)).collect(Collectors.toList());

        Map<LocalDate, List<UserWalletHistory>> dateWalletMap = history.stream().collect(Collectors.groupingBy(x -> x.getTimestamp().toLocalDate()));

        CustomRetailer customRetailer = retailerService.getAllFofoRetailers().get(fofoId);

        List<StatementDetailModel> billedStatementDetails = orderRepository.selectDetailsBetween(fofoId, startDate, endDate);

        Map<Integer, Float> openingAmountMap = transactionService.getPendingIndentValueMap(startDate, Optional.of(fofoId));

        Map<Integer, Float> closingAmountMap = transactionService.getPendingIndentValueMap(endDate, Optional.of(fofoId));

        float openingPendingAmount = openingAmountMap.get(fofoId) == null ? 0 : openingAmountMap.get(fofoId);

        float closingPendingAmount = closingAmountMap.get(fofoId) == null ? 0 : closingAmountMap.get(fofoId);

        LOGGER.info("Opening - {}, Closing - {}", openingPendingAmount, closingPendingAmount);

        double grandTotalDebit = 0;

        double grandTotalCredit = 0;

        for (UserWalletHistory walletEntry : history) {

            if (walletEntry.getAmount() < 0) {

                grandTotalDebit += Math.abs(walletEntry.getAmount());

            } else {

                grandTotalCredit += walletEntry.getAmount();

            }

        }

        for (StatementDetailModel statement : billedStatementDetails) {

            if (statement.getAmount() < 0) {

                grandTotalCredit += Math.abs(statement.getAmount());

            } else {

                grandTotalDebit += statement.getAmount();

            }

        }

        model.addAttribute("billedStatementDetails", billedStatementDetails);

        model.addAttribute("customRetailer", customRetailer);

        model.addAttribute("wallethistory", history);

        model.addAttribute("startDate", startDate);

        model.addAttribute("endDate", endDate);

        model.addAttribute("dateWalletMap", dateWalletMap);

        model.addAttribute("openingBalance", (openingBalance + openingPendingAmount));

        model.addAttribute("closingBalance", (closingBalance + closingPendingAmount));

        model.addAttribute("grandTotalDebit", grandTotalDebit);

        model.addAttribute("grandTotalCredit", grandTotalCredit);

        return "account-statement-list";

    }