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

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

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

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

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

		} else {

			fofoId = fofoDetails.getFofoId();

			collectionSummaryList = orderRepository.selectCollectionSummary(fofoId, 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 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);

			focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoId,

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

		} else {

			fofoId = fofoDetails.getFofoId();

			fs = fofoStoreRepository.selectByRetailerId(fofoId);

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

			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 partnerName = null;

		for (WalletSummaryReportModel walletSummary : walletSummartList) {

			partnerName = walletSummary.getName();

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

		}

		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, partnerName + " 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 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) {

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

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

					pdr.getAffectedOn(), pdr.getAmount(), pdr.getPartnerPayout(), pdr.getImei(), pdr.getStatus(),

					pdr.getUpdateTimestamp(), 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", "partner_payout", "Imei", "status", "processed_on", "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 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) {

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

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