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;

    @RequestMapping(value = "/reports/{projectName}/{fileName}")
    public ResponseEntity<?> fetchReport(HttpServletRequest request, @PathVariable String fileName,
                                         @PathVariable ReporticoProject projectName, @RequestBody(required = false) 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.getAmountType(), spr.getPurchaseReference(),
                    spr.getInvoiceNumber(), spr.getSioAmount(), spr.getStatus(), spr.getStatusDescription(),
                    spr.getCreateTimestamp(), spr.getRolledBackTimestamp()));

        }
        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(Arrays.asList("Item_Id",
                "serial_number", "Brand", "Model Name", "Model Number", "Color", "Scheme_IN_DP", "Scheme_out_dp",
                "Scheme_Id", "Name", "Type", "amount", "Purchase_Invoice", "SALE_INOVOICE", "Amount", "status",
                "description", "create_timestamp", "rolled_back_timestamp"), 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
                offerPayoutReports = fofoOrderRepository
                        .selectOfferPayoutDumpReport(fofoId, startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
        } else {
            fofoId = fofoDetails.getFofoId();
            offerPayoutReports = fofoOrderRepository
                    .selectOfferPayoutDumpReport(fofoId, 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());
        if (date == null) {
            date = LocalDate.now().minusDays(3);
        }

        LOGGER.info("date" + date);
        List<Integer> fofoIds = fofoStoreRepository.selectActiveStores().stream().map(x -> x.getId())
                .collect(Collectors.toList());

        Map<Integer, CustomRetailer> customRetailerMap = retailerService.getAllFofoRetailers();

        Map<Integer, CustomRetailer> customRetailersMap = fofoIds.stream().map(x -> customRetailerMap.get(x))
                .filter(x -> x != null).collect(Collectors.toList()).stream()
                .collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));

        model.addAttribute("customRetailersMap", customRetailersMap);

        List<PendingOrderItem> pendingOrderItem = null;

        pendingOrderItem = pendingOrderItemRepository.selectAll(date.atStartOfDay(), LocalDateTime.now());

        Map<String, Object> map = pendingOrderService.getItemOrders(pendingOrderItem, 0);

        model.addAttribute("pendingOrderItem", map.get("pendingOrderItem"));
        model.addAttribute("partnerInventoryMap", map.get("partnerInventoryMap"));
        model.addAttribute("date", date);
        model.addAttribute("isAdmin", isAdmin);
        return "online-all-order-item";
    }


    @RequestMapping(value = "/reports", method = RequestMethod.GET)
    public String reports(HttpServletRequest httpServletRequest, Model model) throws ProfitMandiBusinessException, UnsupportedOperationException, IOException {
        //LoginDetails loginDetails = cookiesProcessor.getCookiesObject(httpServletRequest);
        Map<ReporticoProject, List<ReporticoUrlInfo>> returnMap = ReporticoProject.reporticoProjectMap;
                /*if(fofoStoreRepository.getWarehousePartnerMap().get(7720).stream().filter(x->x.getId()==loginDetails.getFofoId()).count() > 0) {
                        Map<ReporticoProject, List<ReporticoUrlInfo>> returnMap1 = new HashMap<ReporticoProject, List<ReporticoUrlInfo>>();
                        returnMap1.put(ReporticoProject.FOCO, returnMap.get(ReporticoProject.FOCO));
                        returnMap1.put(ReporticoProject.FOCOR, returnMap.get(ReporticoProject.FOCOR).stream().skip(1).collect(Collectors.toList()));
                        returnMap = returnMap1;
                }*/
        model.addAttribute("reporticoProjectMap", returnMap);
        return "reports";
    }
}