Subversion Repositories SmartDukaan

package com.spice.profitmandi.web.controller;

import com.spice.profitmandi.common.enumuration.ReporticoProject;

import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;

import com.spice.profitmandi.common.model.CustomRetailer;

import com.spice.profitmandi.common.model.ReporticoUrlInfo;

import com.spice.profitmandi.common.services.ReporticoService;

import com.spice.profitmandi.common.util.FileUtil;

import com.spice.profitmandi.common.util.FormattingUtils;

import com.spice.profitmandi.dao.entity.auth.AuthUser;

import com.spice.profitmandi.dao.entity.fofo.FofoStore;

import com.spice.profitmandi.dao.entity.fofo.PendingOrderItem;

import com.spice.profitmandi.dao.model.*;

import com.spice.profitmandi.dao.repository.auth.AuthRepository;

import com.spice.profitmandi.dao.repository.cs.CsService;

import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;

import com.spice.profitmandi.dao.repository.dtr.RoleRepository;

import com.spice.profitmandi.dao.repository.fofo.FofoOrderRepository;

import com.spice.profitmandi.dao.repository.fofo.PendingOrderItemRepository;

import com.spice.profitmandi.dao.repository.fofo.PendingOrderService;

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

import com.spice.profitmandi.service.authentication.RoleManager;

import com.spice.profitmandi.service.order.OrderService;

import com.spice.profitmandi.service.user.RetailerService;

import com.spice.profitmandi.web.model.LoginDetails;

import com.spice.profitmandi.web.util.CookiesProcessor;

import org.apache.http.HttpResponse;

import org.apache.logging.log4j.LogManager;

import org.apache.logging.log4j.Logger;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.core.io.InputStreamResource;

import org.springframework.http.HttpHeaders;

import org.springframework.http.HttpStatus;

import org.springframework.http.ResponseEntity;

import org.springframework.stereotype.Controller;

import org.springframework.transaction.annotation.Transactional;

import org.springframework.ui.Model;

import org.springframework.web.bind.annotation.*;

import javax.servlet.http.HttpServletRequest;

import java.io.IOException;

import java.time.LocalDate;

import java.time.LocalDateTime;

import java.time.LocalTime;

import java.time.format.DateTimeFormatter;

import java.util.*;

import java.util.stream.Collectors;

@Controller

@Transactional(rollbackFor = Throwable.class)

public class ReportsController {

    private static final Logger LOGGER = LogManager.getLogger(OrderController.class);

    private static final Logger Logger = LogManager.getLogger(OrderController.class);

    @Autowired

    private RoleRepository roleRepository;

    @Autowired

    private FofoOrderRepository fofoOrderRepository;

    @Autowired

    private RetailerService retailerService;

    @Autowired

    private PendingOrderItemRepository pendingOrderItemRepository;

    @Autowired

    private PendingOrderService pendingOrderService;

    @Autowired

    private CookiesProcessor cookiesProcessor;

    @Autowired

    private FofoStoreRepository fofoStoreRepository;

    @Autowired

    private ReporticoService reporticoService;

    @Autowired

    private OrderRepository orderRepository;

    @Autowired

    private RoleManager roleManager;

    @Autowired

    private OrderService orderService;

    @Autowired

    private CsService csService;

    @Autowired

    private AuthRepository authRepository;

    @PostMapping(value = "/reports/{projectName}/{fileName}")

    public ResponseEntity<?> fetchReport(HttpServletRequest request, @PathVariable String fileName,

                                         @PathVariable ReporticoProject projectName, @RequestBody Map<String, String> paramsMap)

            throws ProfitMandiBusinessException, UnsupportedOperationException, IOException {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

        HttpResponse response;

        if (roleManager.isAdmin(loginDetails.getRoleIds())) {

            if (fileName.equalsIgnoreCase("LeadsReport")) {

                if (paramsMap == null) {

                    paramsMap = new HashMap<String, String>();

                }

                Map<Integer, List<Integer>> mapping = csService.getL2L1Mapping();

                AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());

                List<Integer> authIds = mapping.get(authUser.getId());

                if (authIds == null) {

                    authIds = new ArrayList<>();

                }

                authIds.add(authUser.getId());

                paramsMap.put("authId", authIds + "");

            }

        } else {

            if (paramsMap == null) {

                paramsMap = new HashMap<String, String>();

            }

            paramsMap.put("MANUAL_fofoId", loginDetails.getFofoId() + "");

        }

        response = getAdminReportFile(loginDetails.getEmailId(), projectName, fileName + ".xml", paramsMap);

        HttpHeaders headers = new HttpHeaders();

        InputStreamResource is = new InputStreamResource(response.getEntity().getContent());

        headers.set("Content-Type", "application/vnd.ms-excel");

        headers.set("Content-disposition", "inline; filename=report-" + fileName + ".csv");

        headers.setContentLength(response.getEntity().getContentLength());

        return new ResponseEntity<InputStreamResource>(is, headers, HttpStatus.OK);

    }

    private HttpResponse getAdminReportFile(String email, ReporticoProject projectName, String fileName,

                                            Map<String, String> reportParams) throws ProfitMandiBusinessException, IOException {

        return reporticoService.getReportFile(projectName, fileName, reportParams);

    }

    @RequestMapping(value = "/collectionSummary", method = RequestMethod.GET)

    public String getCollectionSummary(HttpServletRequest request,

                                       Model model) throws ProfitMandiBusinessException {

        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

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

        LocalDateTime currentDate = LocalDate.now().atStartOfDay();

        LocalDateTime currentStartMonth = currentDate.minusDays(30).toLocalDate().atStartOfDay();

        List<CollectionSummary> collectionSummaryList = orderRepository.selectCollectionSummary(fofoDetails.getFofoId(), currentStartMonth, currentDate);

        Logger.info("CollectionSummaryList {}", collectionSummaryList);

        model.addAttribute("startDate", currentDate.minusDays(30).toLocalDate());

        model.addAttribute("endDate", LocalDate.now());

        model.addAttribute("collectionSummaryList", collectionSummaryList);

        model.addAttribute("isAdmin", isAdmin);

        return "partner-collection-summary";

    }

    @RequestMapping(value = "/collectionSummaryFetchReportByDate", method = RequestMethod.GET)

    public String getcollectionSummaryFetchReport(HttpServletRequest request,

                                                  @RequestParam(defaultValue = "0") int fofoId,

                                                  @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);

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

        if (isAdmin) {

            startDate = LocalDate.now().minusDays(30);

            endDate = LocalDate.now();

        }

        model.addAttribute("startDate", startDate);

        model.addAttribute("endDate", endDate);

        model.addAttribute("isAdmin", isAdmin);

        if (isAdmin) {

            if (fofoId == 0) {

                //No need to send any data

                model.addAttribute("collectionSummaryList", new ArrayList<>());

                return "partner-collection-summary";

            } else {

                List<CollectionSummary> collectionSummaryList = orderRepository

                        .selectCollectionSummary(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

                model.addAttribute("collectionSummaryList", collectionSummaryList);

                return "partner-collection-summary";

            }

        } else {

            fofoId = fofoDetails.getFofoId();

            List<CollectionSummary> collectionSummaryList = orderRepository

                    .selectCollectionSummary(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

            model.addAttribute("collectionSummaryList", collectionSummaryList);

            return "partner-collection-summary";

        }

    }

    @RequestMapping(value = "/downloadCollectionSummary", method = RequestMethod.GET)

    public ResponseEntity<?> getDownloadCollectionSummary(HttpServletRequest request,

                                                          @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));

            }

        } else {

            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(

                            dateTimeFormatter), cs.getReferenceType(), cs.getCash(), cs.getPinelabs(), cs.getBajajFinserv(), cs.getHomeCredit(), cs.getPaytm(),

                    cs.getCapitalFirst(), cs.getZestMoney(), cs.getSamsungSure(), cs.getTotalAmount()));

        }

        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil

                .getCSVByteStream(Arrays.asList("Date", "Reference Type", "Cash", "Pinelabs", "Bajaj Finservice", "Home Credit", "Paymt",

                        "Capital First", "Zest Money", "Samsung Sure", "Total Amount"), rows);

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

        return responseEntity;

    }

    @RequestMapping(value = "/franchiseeSalesReport", method = RequestMethod.GET)

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

                                           @RequestParam(required = false) LocalDate startDate, @RequestParam(required = false) LocalDate endDate)

            throws ProfitMandiBusinessException {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

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

        if (startDate == null) {

            startDate = LocalDate.now().minusDays(30);

        }

        endDate = LocalDate.now();

        model.addAttribute("startDate", startDate);

        model.addAttribute("endDate", endDate);

        model.addAttribute("isAdmin", isAdmin);

        LOGGER.info("q {}, starDate - {}, endDate - {}", fofoId, startDate, endDate);

        if (isAdmin) {

            if (fofoId == 0) {

                //No need to pull any data

                model.addAttribute("focoSaleReportList", new ArrayList<>());

                return "foco-sale-report";

            }

        } else {

            fofoId = loginDetails.getFofoId();

        }

        FofoStore fs = fofoStoreRepository.selectByRetailerId(fofoId);

        List<FocoSaleReportModel> focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoId, fs.getCode(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

        model.addAttribute("focoSaleReportList", focoSaleReportList);

        return "foco-sale-report";

    }

    @RequestMapping(value = "/franchiseeSalesFetchReportByDate", method = RequestMethod.GET)

    public String getfranchiseeSalesFetchReport(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());

        if (startDate == null) {

            startDate = LocalDate.now().minusDays(30);

            endDate = LocalDate.now();

        }

        model.addAttribute("startDate", startDate);

        model.addAttribute("endDate", endDate);

        model.addAttribute("isAdmin", isAdmin);

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

        LOGGER.info("q {}, starDate - {}, endDate - {}", fofoId, startDate, endDate);

        if (isAdmin) {

            if (fofoId == 0) {

                //no need any data

                model.addAttribute("focoSaleReportList", new ArrayList<>());

                return "foco-sale-report";

            }

        } else {

            fofoId = loginDetails.getFofoId();

        }

        FofoStore fs = fofoStoreRepository.selectByRetailerId(fofoId);

        List<FocoSaleReportModel> focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoId, fs.getCode(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

        model.addAttribute("focoSaleReportList", focoSaleReportList);

        return "foco-sale-report";

    }

    @RequestMapping(value = "/downloadFranchiseeSales", method = RequestMethod.GET)

    public ResponseEntity<?> getdownloadFranchiseeSales(HttpServletRequest request,

                                                        @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<FocoSaleReportModel> focoSaleReportList = null;

        FofoStore fs = null;

        if (isAdmin) {

            fs = fofoStoreRepository.selectByRetailerId(fofoId);

            if (fofoId == 0) {

                focoSaleReportList = new ArrayList<>();

            } else {

                focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoId,

                        fs.getCode(), startDate.atStartOfDay(), endDate.atStartOfDay());

            }

        } else {

            fs = fofoStoreRepository.selectByRetailerId(fofoDetails.getFofoId());

            focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoDetails.getFofoId(),

                    fs.getCode(), startDate.atStartOfDay(), endDate.atStartOfDay());

        }

        LOGGER.info("FocoSaleReportList {}", focoSaleReportList);

        String partnerName = null;

        for (FocoSaleReportModel fsr : focoSaleReportList) {

            partnerName = fsr.getName();

            rows.add(Arrays.asList(fsr.getCode(), fsr.getName(), fsr.getCity(), fsr.getState(), fsr.getRegion(),

                    fsr.getItemId(), fsr.getBrand(), fsr.getModelName(), fsr.getModelNumber(), fsr.getColor(),

                    fsr.getQuantity(), fsr.getDp(), fsr.getSellingPrice(), fsr.getMop(), fsr.getSerialNumber(),

                    FormattingUtils.format(fsr.getCreateDate()), fsr.getCustomerName(), fsr.getCustomerPhone(),

                    fsr.getCustomerCity(), fsr.getCustomerPincode(), fsr.getInvoiceNumber(), fsr.getPurchaseReference(),

                    fsr.getCustomerGstNumber(), FormattingUtils.format(fsr.getCancelledTimestamp()),

                    FormattingUtils.format(fsr.getGrnCompleteDate()), fsr.getHygieneRating(), fsr.getRating(),

                    fsr.getStatus(), fsr.getRemark(), FormattingUtils.format(fsr.getCreatedTimestamp()),

                    FormattingUtils.format(fsr.getDisposedTimestamp()),

                    FormattingUtils.format(fsr.getNextTimestamp()),

                    FormattingUtils.format(fsr.getActivationTimestamp()),

                    FormattingUtils.format(fsr.getActivationTimestamp()), fsr.getLabel()));

        }

        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(

                Arrays.asList("Code", "Name", "City", "State", "Region", "Item Id", "Brand", "Model Name",

                        "Model Number", "Color", "Quantity", "Dp", "Selling_Price", "mop", "Serial Number",

                        "Create Date", "Customer Name", "Customer Phone", "Customer City", " Customer Pincode",

                        "Invoice  Number", "Purchase Reference", "Customer Gst Number", " Cancelled Timestamp",

                        "GRN Complete Date", "Hygiene Rating", "Rating", "Status", "Remark", "Created Timestamp",

                        "Disposed Timestamp", " Next Timestamp", "Activation Timestamp", "Create Timestamp", "Label"),

                rows);

        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, partnerName + " Franchisee Sales Report");

        return responseEntity;

    }

    @RequestMapping(value = "/downloadWalletSummaryReport", method = RequestMethod.GET)

    public ResponseEntity<?> getDownloadWalletSummaryReport(HttpServletRequest request,

                                                            @RequestParam(defaultValue = "0", name = "fofoId") int fofoId,

                                                            @RequestParam(name = "startDate") LocalDate startDate,

                                                            @RequestParam(name = "endDate") LocalDate endDate, Model model)

            throws Exception {

        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(

                        fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

        } else {

            walletSummartList = fofoOrderRepository.selectWalletSummaryReport(

                    fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

        }

        LOGGER.info("walletSummartList {}", fofoId);

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

        String partnerDetail = null;

        for (WalletSummaryReportModel walletSummary : walletSummartList) {

            partnerDetail = walletSummary.getName() + "(" + walletSummary.getCode() + "-" + walletSummary.getPhone() + ")" + "-" + walletSummary.getEmail();

            rows.add(Arrays.asList(

                    walletSummary.getId(),

                    //walletSummary.getCode(),

                    //walletSummary.getName(),

                    //walletSummary.getEmail(),

                    //walletSummary.getPhone(),

                    walletSummary.getAmount(),

                    walletSummary.getRefundableAmount(),

                    walletSummary.getReference(),

                    walletSummary.getReferenceType(),

                    FormattingUtils.format(walletSummary.getBusinessTimestamp()),

                    walletSummary.getDescription()

            ));

        }

        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil

                .getCSVByteStream(Arrays.asList("Id",

//						"Code",

//						"Name",

//						"Email",

//						"Phone",

                        "Amount", "Refundable_amount",

                        "Reference", "Reference_type", "Business_timestamp", "Description"), rows);

        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, partnerDetail + " Wallet Statement Report");

        return responseEntity;

    }

    @RequestMapping(value = "/walletSummaryFetchReportByDate", method = RequestMethod.GET)

    public String getwalletSummaryFetchReport(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());

        if (startDate == null) {

            startDate = LocalDate.now().minusDays(30);

        }

        endDate = LocalDate.now();

        model.addAttribute("startDate", startDate);

        model.addAttribute("endDate", endDate);

        model.addAttribute("isAdmin", isAdmin);

        if (isAdmin) {

            if (fofoId == 0) {

                //No need to send any data

                model.addAttribute("walletSummartList", new ArrayList<>());

                return "wallet-summary-report";

            } else {

                List<WalletSummaryReportModel> walletSummartList = fofoOrderRepository

                        .selectWalletSummaryReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

                model.addAttribute("walletSummartList", walletSummartList);

                return "wallet-summary-report";

            }

        } else {

            FofoStore fs = fofoStoreRepository.selectByRetailerId(fofoId);

            List<WalletSummaryReportModel> walletSummartList = fofoOrderRepository

                    .selectWalletSummaryReport(loginDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

            //LOGGER.info("walletSummartList {}", walletSummartList);

            model.addAttribute("walletSummartList", walletSummartList);

            return "wallet-summary-report";

        }

    }

    @RequestMapping(value = "/walletSummaryReport", method = RequestMethod.GET)

    public String getWalletSummaryReport(HttpServletRequest request, Model model) throws Exception {

        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

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

        LocalDateTime currentDate = LocalDate.now().atStartOfDay();

        LocalDateTime currentStartMonth = currentDate.minusDays(30).toLocalDate().atStartOfDay();

        List<WalletSummaryReportModel> walletSummartList = fofoOrderRepository

                .selectWalletSummaryReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);

        LOGGER.info("walletSummartList {}", walletSummartList);

        model.addAttribute("startDate", currentDate.minusDays(30).toLocalDate());

        model.addAttribute("endDate", LocalDate.now());

        model.addAttribute("walletSummartList", walletSummartList);

        model.addAttribute("isAdmin", isAdmin);

        return "wallet-summary-report";

    }

    @RequestMapping(value = "/pendingIndentReport", method = RequestMethod.GET)

    public String getPendingIndentReport(HttpServletRequest request, 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 = fofoOrderRepository

                .selectPendingIndentReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);

        LOGGER.info("pendingIndentReports {}", pendingIndentReports);

        model.addAttribute("startDate", currentDate.minusMonths(2).toLocalDate());

        model.addAttribute("endDate", LocalDate.now());

        model.addAttribute("pendingIndentReports", pendingIndentReports);

        model.addAttribute("isAdmin", isAdmin);

        return "pending-indent-report";

    }

    @RequestMapping(value = "/pendingIndentFetchReportByDate", method = RequestMethod.GET)

    public String getpendingIndentFetchReport(

            HttpServletRequest request,

            @RequestParam(defaultValue = "0") int fofoId,

            @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);

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

        if (startDate == null) {

            startDate = LocalDate.now().minusDays(30);

            endDate = LocalDate.now();

        }

        model.addAttribute("startDate", startDate);

        model.addAttribute("endDate", endDate);

        model.addAttribute("isAdmin", isAdmin);

        if (isAdmin) {

            if (fofoId == 0) {

                model.addAttribute("pendingIndentReports", new ArrayList<>());

                return "pending-indent-report";

            } else {

                List<PendingIndentReportModel> pendingIndentReports = fofoOrderRepository

                        .selectPendingIndentReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

                model.addAttribute("pendingIndentReports", pendingIndentReports);

                return "pending-indent-report";

            }

        } else {

            LocalDateTime currentDate = LocalDate.now().atStartOfDay();

            List<PendingIndentReportModel> pendingIndentReports = fofoOrderRepository

                    .selectPendingIndentReport(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

            model.addAttribute("pendingIndentReports", pendingIndentReports);

            return "pending-indent-report";

        }

    }

    @RequestMapping(value = "/pendingIndentReportDownload", method = RequestMethod.GET)

    public ResponseEntity<?> getPendingIndentReportDownload(HttpServletRequest request,

                                                            @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

                        .selectPendingIndentReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

        } else {

            pendingIndentReports = fofoOrderRepository

                    .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) {

            rows.add(Arrays.asList(pir.getTransactionId(), pir.getOrderId(),

                    pir.getCreatTimestamp().format(dateTimeFormatter), pir.getItemId(), pir.getBrand(),

                    pir.getModelName(), pir.getModelNumber(), pir.getColor(), pir.getQuantity(), pir.getUnitPrice(),

                    pir.getWalletAmount(), pir.getStatus(), pir.getInvoiceNumber(),

                    pir.getBillingTimestamp() == null ? "" : pir.getBillingTimestamp().format(dateTimeFormatter)));

        }

        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(Arrays.asList(

                "Transaction Id", "Order Id", "Created_At", "Item_Id", "Brand", "Model Name", "Model Number", "Color",

                "Quantity", "Unit Price", "Wallet Deduction", "Status", "Invoice Number", "Billing Timestamp"), rows);

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

        return responseEntity;

    }

    @RequestMapping(value = "/schemePayoutReport", method = RequestMethod.GET)

    public String getschemePayoutReport(HttpServletRequest request, Model model,

                                        @RequestParam(required = false) LocalDate startDate, @RequestParam(required = false) LocalDate endDate)

            throws ProfitMandiBusinessException {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

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

        if (startDate == null) {

            startDate = LocalDate.now().minusDays(30);

            endDate = LocalDate.now();

        }

        model.addAttribute("startDate", startDate);

        model.addAttribute("endDate", endDate);

        model.addAttribute("isAdmin", isAdmin);

        //LOGGER.info("schemePayoutReports {}", schemePayoutReports);

        List<SchemePayoutReportModel> schemePayoutReports = fofoOrderRepository

                .selectSchemePayoutReport(loginDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

        model.addAttribute("schemePayoutReports", schemePayoutReports);

        return "scheme-payout-report";

    }

    @RequestMapping(value = "/schemePayoutFetchReportByDate", method = RequestMethod.GET)

    public String getschemePayoutFetchReportByDate(

            HttpServletRequest request,

            Model model,

            @RequestParam(defaultValue = "0") int fofoId,

            @RequestParam(required = false) LocalDate startDate,

            @RequestParam(required = false) LocalDate endDate)

            throws ProfitMandiBusinessException {

        //LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

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

        if (startDate == null) {

            startDate = LocalDate.now().minusDays(30);

            endDate = LocalDate.now();

        }

        model.addAttribute("startDate", startDate);

        model.addAttribute("endDate", endDate);

        model.addAttribute("isAdmin", isAdmin);

        LOGGER.info("q {}, starDate - {}, endDate - {}", fofoId, startDate, endDate);

        if (isAdmin) {

            if (fofoId == 0) {

                //No need to pull any data

                model.addAttribute("schemePayoutReports", new ArrayList<>());

                return "scheme-payout-report";

            } else {

                List<SchemePayoutReportModel> schemePayoutReports = fofoOrderRepository

                        .selectSchemePayoutReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

                model.addAttribute("schemePayoutReports", schemePayoutReports);

                return "scheme-payout-report";

            }

        } else {

            fofoId = loginDetails.getFofoId();

            List<SchemePayoutReportModel> schemePayoutReports = fofoOrderRepository

                    .selectSchemePayoutReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

            model.addAttribute("schemePayoutReports", schemePayoutReports);

            return "scheme-payout-report";

        }

    }

    @RequestMapping(value = "/offerPayoutReport", method = RequestMethod.GET)

    public String getOfferPayoutReport(HttpServletRequest request, Model model, @RequestParam(required = false) LocalDate startDate, @RequestParam(required = false) LocalDate endDate) throws Exception {

        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

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

        if (startDate == null) {

            startDate = LocalDate.now().minusDays(30);

            endDate = LocalDate.now();

        }

        model.addAttribute("startDate", startDate);

        model.addAttribute("endDate", endDate);

        List<OfferPayoutDumpReportModel> offerPayoutDumpReports = fofoOrderRepository

                .selectOfferPayoutDumpReport(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

        LOGGER.info("offerPayoutDumpReports {}", offerPayoutDumpReports);

        model.addAttribute("offerPayoutDumpReports", offerPayoutDumpReports);

        model.addAttribute("isAdmin", isAdmin);

        return "offer-payout-dump-report";

    }

    @RequestMapping(value = "/offerPayoutFetchReportByDate", method = RequestMethod.GET)

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

                                                  @RequestParam(required = false) LocalDate startDate, @RequestParam(required = false) LocalDate endDate)

            throws ProfitMandiBusinessException {

        LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);

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

        if (startDate == null) {

            startDate = LocalDate.now().minusDays(30);

            endDate = LocalDate.now();

        }

        model.addAttribute("startDate", startDate);

        model.addAttribute("endDate", endDate);

        model.addAttribute("isAdmin", isAdmin);

        LOGGER.info("q {}, starDate - {}, endDate - {}", fofoId, startDate, endDate);

        if (isAdmin) {

            if (fofoId == 0) {

                //No need to pull any data

                model.addAttribute("offerPayoutReports", new ArrayList<>());

                return "offer-payout-dump-report";

            } else {

                List<OfferPayoutDumpReportModel> offerPayoutDumpReports = fofoOrderRepository

                        .selectOfferPayoutDumpReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

                model.addAttribute("offerPayoutDumpReports", offerPayoutDumpReports);

                return "offer-payout-dump-report";

            }

        } else {

            fofoId = loginDetails.getFofoId();

            List<OfferPayoutDumpReportModel> offerPayoutDumpReports = fofoOrderRepository

                    .selectOfferPayoutDumpReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

            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();

        LocalDateTime currentStartMonth = currentDate.minusMonths(3).toLocalDate().atStartOfDay();

        List<PartnerBillingSummaryModel> partnerBillingSummaryReports = fofoOrderRepository

                .selectPartnerBillingSummaryReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);

        model.addAttribute("startDate", currentDate.minusMonths(3).toLocalDate());

        model.addAttribute("endDate", LocalDate.now());

        model.addAttribute("partnerBillingSummaryReports", partnerBillingSummaryReports);

        return "partner-billing-summary-report";

    }

    @RequestMapping(value = "/priceDropReport", method = RequestMethod.GET)

    public String getSelectPriceDropReport(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);

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

        if (startDate == null) {

            startDate = LocalDate.now().minusDays(30);

            endDate = LocalDate.now();

        }

        model.addAttribute("startDate", startDate);

        model.addAttribute("endDate", endDate);

        model.addAttribute("isAdmin", isAdmin);

        List<PriceDropReportModel> priceDropReports = orderRepository.selectPriceDropReport(fofoDetails.getFofoId(),

                startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

        model.addAttribute("priceDropReports", priceDropReports);

        return "price-drop-report";

    }

    @RequestMapping(value = "/priceDropFetchReportByDate", method = RequestMethod.GET)

    public String getpriceDropFetchReportByDate(HttpServletRequest request,

                                                @RequestParam(defaultValue = "0") int fofoId,

                                                @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);

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

        if (startDate == null) {

            startDate = LocalDate.now().minusDays(30);

            endDate = LocalDate.now();

        }

        model.addAttribute("startDate", startDate);

        model.addAttribute("endDate", endDate);

        model.addAttribute("isAdmin", isAdmin);

        if (isAdmin) {

            if (fofoId == 0) {

                model.addAttribute("priceDropReports", new ArrayList<>());

                return "price-drop-report";

            } else {

                List<PriceDropReportModel> priceDropReports = orderRepository.selectPriceDropReport(fofoId,

                        startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

                model.addAttribute("priceDropReports", priceDropReports);

                return "price-drop-report";

            }

        } else {

            List<PriceDropReportModel> priceDropReports = orderRepository.selectPriceDropReport(fofoDetails.getFofoId(),

                    startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

            model.addAttribute("priceDropReports", priceDropReports);

            return "price-drop-report";

        }

    }

    @RequestMapping(value = "/downloadPriceDropReport", method = RequestMethod.GET)

    public ResponseEntity<?> getSelectDownloadPriceDropReport(HttpServletRequest request,

                                                              @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,

                        startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

        } else {

            fofoId = fofoDetails.getFofoId();

            priceDropReports = orderRepository.selectPriceDropReport(fofoId,

                    startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

        }

        for (PriceDropReportModel pdr : priceDropReports) {

            rows.add(Arrays.asList(pdr.getCode(), pdr.getId(), pdr.getBrand(), pdr.getModelName(), pdr.getModelNumber(),

                    FormattingUtils.formatDate(pdr.getAffectedOn()), pdr.getAmount(), FormattingUtils.format(pdr.getCreditTimestamp()), pdr.getImei(), pdr.getStatus(),

                    FormattingUtils.format(pdr.getRejectedTimestamp()), pdr.getRejectionReason()));

        }

        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil

                .getCSVByteStream(Arrays.asList("code", "Price_Drop_Id", "brand", "model_name", "model_number",

                        "affected_on", "amount", "Credit Date", "Imei", "status", "Rejected Date", "Rejected Reason"), rows);

        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "price drop report");

        return responseEntity;

    }

    @RequestMapping(value = "/downloadPartnerBillingSummaryReport", method = RequestMethod.GET)

    public ResponseEntity<?> getdownloadPartnerBillingSummaryReport(HttpServletRequest request,

                                                                    @RequestParam(name = "startDate") LocalDate startDate,

                                                                    @RequestParam(name = "endDate") LocalDate endDate, Model model)

            throws Exception {

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

        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

        LocalDateTime currentDate = LocalDate.now().atStartOfDay();

        LocalDateTime currentStartMonth = currentDate.minusMonths(3).toLocalDate().atStartOfDay();

        List<PartnerBillingSummaryModel> partnerBillingSummaryReports = fofoOrderRepository

                .selectPartnerBillingSummaryReport(fofoDetails.getFofoId(), startDate.atStartOfDay(),

                        endDate.atTime(LocalTime.MAX));

        for (PartnerBillingSummaryModel pbsr : partnerBillingSummaryReports) {

            rows.add(Arrays.asList(pbsr.getId(),

                    FormattingUtils.format(pbsr.getCreateTimestamp()),

                    FormattingUtils.format(pbsr.getBillingTimestamp()),

                    FormattingUtils.format(pbsr.getDeliveryTimestamp()),

                    FormattingUtils.format(pbsr.getPartnerGrnTimestamp()),

                    pbsr.getTransactionId(),

                    pbsr.getLogisticsTransactionId(), pbsr.getAirwayBillNumber(), pbsr.getStatusSubGroup(),

                    pbsr.getStatusName(), pbsr.getRetailerId(), pbsr.getRetailerName(), pbsr.getItemId(),

                    pbsr.getBrand(), pbsr.getModelName(), pbsr.getModelNumber(), pbsr.getColor(), pbsr.getUnitPrice(),

                    pbsr.getQuantity(), pbsr.getTotalPrice(), pbsr.getInvoiceNumber(), pbsr.getSellerName(), pbsr.getGstNumber(), pbsr.getHsnCode(), pbsr.getIgstRate(),

                    pbsr.getCgstRate(), pbsr.getSgstRate()));

        }

        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(Arrays.asList("OrderId",

                "Created On", "Billed On", "Delivered On", "Grned On", "Transaction_id", "master_order_id",

                "airwaybill_no", "statusSubGroupp", "statusName", "customer_id", "customer_name", "Item_Id", "brand",

                "model_name", "model_number", "color", "selling_price", "Quantity", "total_price", "invoice_number",

                "seller_name", "gst_number", "hsn_code", "igstrate", "cgstrate", "sgstrate"), rows);

        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);

        LocalDateTime currentDate = LocalDate.now().atStartOfDay();

        LocalDateTime currentStartMonth = currentDate.minusMonths(3).toLocalDate().atStartOfDay();

        List<FocoSchemeOutReportModel> focoSchemeOutReports = fofoOrderRepository

                .selectInvoiceSchemeOutSummaryReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);

        LOGGER.info("focoSchemeOutReportModel {}", focoSchemeOutReports);

        model.addAttribute("startDate", currentDate.minusMonths(3).toLocalDate());

        model.addAttribute("endDate", LocalDate.now());

        model.addAttribute("focoSchemeOutReports", focoSchemeOutReports);

        return "invoicewise-scheme-out-report";

    }

    @RequestMapping(value = "/downloadInvoiceSchemeOutSummaryReport", method = RequestMethod.GET)

    public ResponseEntity<?> getDownloadInvoiceSchemeOutSummaryReport(HttpServletRequest request, 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<FocoSchemeOutReportModel> focoSchemeOutReports = fofoOrderRepository

                .selectInvoiceSchemeOutSummaryReport(fofoDetails.getFofoId(), currentStartMonth, currentDate);

        LOGGER.info("focoSchemeOutReportModel {}", focoSchemeOutReports);

        for (FocoSchemeOutReportModel fsor : focoSchemeOutReports) {

            rows.add(Arrays.asList(fsor.getInvoiceNumber(), fsor.getQuantity(), fsor.getBrand(), fsor.getModelName(),

                    fsor.getModelNumber(), fsor.getColor(), fsor.getAmount()));

        }

        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(

                Arrays.asList("InvoiceNumber", "Quantity", "Brand", "Model Name", "Model Number", "Color", "Amount"),

                rows);

        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows,

                "invoice wise scheme out Summary Report");

        return responseEntity;

    }

    @RequestMapping(value = "/schemePayoutReportDownload", method = RequestMethod.GET)

    public ResponseEntity<?> getSchemePayoutReportDownload(HttpServletRequest request,

                                                           @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<SchemePayoutReportModel> schemePayoutReports = null;

        if (isAdmin) {

            if (fofoId == 0)

                schemePayoutReports = new ArrayList<>();

            else

                schemePayoutReports = fofoOrderRepository

                        .selectSchemePayoutReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));

        } else {

            fofoId = fofoDetails.getFofoId();

            schemePayoutReports = fofoOrderRepository

                    .selectSchemePayoutReport(fofoId, 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(),

                    spr.getModelNumber(), spr.getColor(), spr.getSchemeInDp(), spr.getSchemeOutDp(), spr.getSchemeId(),

                    spr.getName(), spr.getType(), spr.getAmount(), spr.getAmountType(), spr.getSioAmount(), spr.getPurchaseReference(),

                    spr.getInvoiceNumber(), spr.getStatus(), spr.getStatusDescription(),

                    FormattingUtils.formatDateTime(spr.getCreateTimestamp()), FormattingUtils.formatDateTime(spr.getRolledBackTimestamp())));

        }

        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(Arrays.asList("Item Id",

                "Serial No", "Brand", "Model Name", "Model Number", "Color", "Scheme In Dp", "Scheme Out Dp",

                "Scheme Id", "Name", "Scheme Type", "Amount", "Amount Type", "Amount Paid", "Purchase Invoice", "Sale Invoice", "Status",

                "Description", "Created on", "Reversed On"), rows);

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

        return responseEntity;

    }

    @RequestMapping(value = "/offerPayoutDumpReportDownload", method = RequestMethod.GET)

    public ResponseEntity<?> getOfferPayoutDumpReportDownload(HttpServletRequest request,

                                                              @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