Subversion Repositories SmartDukaan

import java.io.ByteArrayInputStream;

import java.io.ByteArrayOutputStream;

import java.io.InputStream;

import java.time.LocalDate;

import java.time.LocalDateTime;

import java.time.format.DateTimeFormatter;

import java.time.temporal.ChronoUnit;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.HashMap;

import java.util.HashSet;

import java.util.List;

import java.util.Map;

import java.util.Set;

import java.util.stream.Collectors;

import javax.servlet.http.HttpServletRequest;

import javax.servlet.http.HttpServletResponse;

import org.apache.logging.log4j.LogManager;

import org.apache.logging.log4j.Logger;

import org.json.JSONObject;

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

	@Autowired

	private OrderRepository orderRepository;

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

	public String getFranchiseeSalesReport(HttpServletRequest request,

			Model model) throws ProfitMandiBusinessException {

		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

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

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

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

	    List<FocoSaleReportModel> focoSaleReportList =fofoOrderRepository.selectFocoSaleReport(fofoDetails.getFofoId(),fs.getCode(),currentStartMonth, currentDate);

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

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

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

		model.addAttribute("focoSaleReportList", focoSaleReportList);

		return "foco-sale-report";

	}

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

	public ResponseEntity<?> getdownloadFranchiseeSales(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);

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

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

		List<FocoSaleReportModel> focoSaleReportList = fofoOrderRepository.selectFocoSaleReport(fofoDetails.getFofoId(),

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

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

		for (FocoSaleReportModel fsr : focoSaleReportList) {

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

					fsr.getCreateDate(), fsr.getCustomerName(), fsr.getCustomerPhone(), fsr.getCustomerCity(),

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

					fsr.getCustomerGstNumber(), fsr.getCancelledTimestamp(), fsr.getGrnCompleteDate(),

					fsr.getHygieneRating(), fsr.getRating(), fsr.getStatus(), fsr.getRemark(),

					fsr.getCreatedTimestamp(), fsr.getDisposedTimestamp(), fsr.getNextTimestamp(),

					fsr.getActivationTimestamp(), 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, "Franchisee Sales Report");

		return responseEntity;

	}

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

	public ResponseEntity<?> getDownloadWalletSummaryReport(HttpServletRequest request,

			@RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,

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

			throws Exception {

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

		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

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

		for (WalletSummaryReportModel walletSummart : walletSummartList) {

			rows.add(Arrays.asList(walletSummart.getId(), walletSummart.getCode(), walletSummart.getName(),

					walletSummart.getEmail(), walletSummart.getPhone(), walletSummart.getAmount(),

					walletSummart.getRefundableAmount(), walletSummart.getReference(), walletSummart.getReferenceType(),

					walletSummart.getBusinessTimestamp(), walletSummart.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, "Wallet Statement Report");

		return responseEntity;

	}

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

	public String getWalletSummaryReport(HttpServletRequest request,

			Model model) throws Exception {

		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

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

		return "wallet-summary-report";

	}

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

	public String getPendingIndentReport(HttpServletRequest request,

			Model model) throws Exception {

		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

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

		return "pending-indent-report";

	}

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

	public ResponseEntity<?> getPendingIndentReportDownload(HttpServletRequest request,

			Model model) throws Exception {

		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

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

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

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

		List<PendingIndentReportModel> pendingIndentReports =fofoOrderRepository.selectPendingIndentReport(fofoDetails.getFofoId(),currentStartMonth, currentDate);

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

      for( PendingIndentReportModel pir : pendingIndentReports) {

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

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

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

					pir.getBillingTimestamp()));

		}

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

		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

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

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

		List<SchemePayoutReportModel> schemePayoutReports =fofoOrderRepository.selectSchemePayoutReport(fofoDetails.getFofoId(),currentStartMonth, currentDate);

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

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

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

		model.addAttribute("schemePayoutReports", schemePayoutReports);

		return "scheme-payout-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,

			Model model) throws Exception {

		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

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

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

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

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

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

		model.addAttribute("priceDropReports", priceDropReports);

		return "price-drop-report";

	}

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

	public  ResponseEntity<?> getSelectDownloadPriceDropReport(HttpServletRequest request,

			Model model) throws Exception {

		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);

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

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

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

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

     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", required = true, defaultValue = "") LocalDate startDate,

			@RequestParam(name = "endDate", required = true, defaultValue = "") 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(), currentStartMonth, currentDate);

		for (PartnerBillingSummaryModel pbsr : partnerBillingSummaryReports) {

			rows.add(Arrays.asList(pbsr.getId(), pbsr.getCreateTimestamp(), pbsr.getBillingTimestamp(),pbsr.getDeliveryTimestamp(),

					pbsr.getDeliveryTimestamp(), 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.getIgstRate(),pbsr.getCgstRate(),pbsr.getSgstRate()));

		}

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

				.getCSVByteStream(Arrays.asList("OrderId","CREATION_DATE","BILLING_DATE","DELIVERED_ON","SCANNED_IN_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","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,

			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<SchemePayoutReportModel> schemePayoutReports =fofoOrderRepository.selectSchemePayoutReport(fofoDetails.getFofoId(),currentStartMonth, currentDate);

		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;

	}