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