Subversion Repositories SmartDukaan

package com.spice.profitmandi.web.controller;

import java.io.IOException;

import java.time.LocalDate;

import java.time.LocalDateTime;

import java.time.LocalTime;

import java.time.format.DateTimeFormatter;

import java.util.ArrayList;

import java.util.Arrays;

import java.util.HashMap;

import java.util.List;

import java.util.Map;

import javax.servlet.http.HttpServletRequest;

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

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

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.enumuration.ReporticoProject;

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

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.dao.entity.auth.AuthUser;

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

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.transaction.OrderRepository;

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

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

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

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

@Controller

@Transactional(rollbackFor = Throwable.class)

public class ReportsController {

	@Autowired

	private RoleRepository roleRepository;

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

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

		return "partner-collection-summary";

	}

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

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

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

		List<CollectionSummary> collectionSummaryList =orderRepository

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

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

		model.addAttribute("startDate",startDate);

		model.addAttribute("endDate", endDate);

		model.addAttribute("collectionSummaryList", collectionSummaryList);

		return "partner-collection-summary";

	}

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

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

		List<CollectionSummary> 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 = "/reports", method = RequestMethod.GET)

	public String reports(HttpServletRequest httpServletRequest, Model model) throws ProfitMandiBusinessException, UnsupportedOperationException, IOException {

		//LoginDetails loginDetails = cookiesProcessor.getCookiesObject(httpServletRequest);

		Map<ReporticoProject, List<ReporticoUrlInfo>> returnMap = ReporticoProject.reporticoProjectMap;

		/*if(fofoStoreRepository.getWarehousePartnerMap().get(7720).stream().filter(x->x.getId()==loginDetails.getFofoId()).count() > 0) {

			Map<ReporticoProject, List<ReporticoUrlInfo>> returnMap1 = new HashMap<ReporticoProject, List<ReporticoUrlInfo>>();

			returnMap1.put(ReporticoProject.FOCO, returnMap.get(ReporticoProject.FOCO));

			returnMap1.put(ReporticoProject.FOCOR, returnMap.get(ReporticoProject.FOCOR).stream().skip(1).collect(Collectors.toList()));

			returnMap = returnMap1;

		}*/

		model.addAttribute("reporticoProjectMap", returnMap);

		return "reports";

	}

}