Subversion Repositories SmartDukaan

Rev

Rev 31377 | Rev 33092 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 31377 Rev 33067
Line 1... Line 1...
1 
package com.spice.profitmandi.web.controller;
 1 
package com.spice.profitmandi.web.controller;
2 
 
 2 
 
3 
import java.io.IOException;
 3 
import java.io.IOException;
4 
import java.time.LocalDate;
 4 
import java.time.LocalDate;
5 
import java.time.LocalDateTime;
 5 
import java.time.LocalDateTime;
- 
 
 6 
import java.time.LocalTime;
6 
import java.time.format.DateTimeFormatter;
 7 
import java.time.format.DateTimeFormatter;
7 
import java.util.ArrayList;
 8 
import java.util.ArrayList;
8 
import java.util.Arrays;
 9 
import java.util.Arrays;
9 
import java.util.HashMap;
 10 
import java.util.HashMap;
10 
import java.util.List;
 11 
import java.util.List;
11 
import java.util.Map;
 12 
import java.util.Map;
12 
 
 13 
 
13 
import javax.servlet.http.HttpServletRequest;
 14 
import javax.servlet.http.HttpServletRequest;
14 
 
 15 
 
- 
 
 16 
import com.spice.profitmandi.dao.model.SchemePayoutReportModel;
15 
import org.apache.http.HttpResponse;
 17 
import org.apache.http.HttpResponse;
16 
import org.apache.logging.log4j.LogManager;
 18 
import org.apache.logging.log4j.LogManager;
17 
import org.apache.logging.log4j.Logger;
 19 
import org.apache.logging.log4j.Logger;
18 
import org.springframework.beans.factory.annotation.Autowired;
 20 
import org.springframework.beans.factory.annotation.Autowired;
19 
import org.springframework.core.io.InputStreamResource;
 21 
import org.springframework.core.io.InputStreamResource;
Line 139... Line 141...
139 
		model.addAttribute("startDate",currentDate.minusDays(30).toLocalDate());
 141 
		model.addAttribute("startDate",currentDate.minusDays(30).toLocalDate());
140 
		model.addAttribute("endDate", LocalDate.now());
 142 
		model.addAttribute("endDate", LocalDate.now());
141 
		model.addAttribute("collectionSummaryList", collectionSummaryList);
 143 
		model.addAttribute("collectionSummaryList", collectionSummaryList);
142 
		return "partner-collection-summary";
 144 
		return "partner-collection-summary";
143 
	}
 145 
	}
- 
 
 146 
	@RequestMapping(value = "/collectionSummaryFetchReportByDate", method = RequestMethod.GET)
- 
 
 147 
	public String getcollectionSummaryFetchReport(HttpServletRequest request,
- 
 
 148 
											 @RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,
- 
 
 149 
											 @RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate, Model model)
- 
 
 150 
			throws Exception {
- 
 
 151 
		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
- 
 
 152 
 
- 
 
 153 
		List<List<?>> rows = new ArrayList<>();
- 
 
 154 
 
- 
 
 155 
		LocalDateTime currentDate = LocalDate.now().atStartOfDay();
- 
 
 156 
 
- 
 
 157 
		List<CollectionSummary> collectionSummaryList =orderRepository
- 
 
 158 
		.selectCollectionSummary(fofoDetails.getFofoId(), startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
- 
 
 159 
		Logger.info("CollectionSummaryList {}", collectionSummaryList);
- 
 
 160 
 
- 
 
 161 
		model.addAttribute("startDate",startDate);
- 
 
 162 
		model.addAttribute("endDate", endDate);
- 
 
 163 
		model.addAttribute("collectionSummaryList", collectionSummaryList);
- 
 
 164 
		return "partner-collection-summary";
- 
 
 165 
	}
144
166
145 
	@RequestMapping(value = "/downloadCollectionSummary", method = RequestMethod.GET)
 167 
	@RequestMapping(value = "/downloadCollectionSummary", method = RequestMethod.GET)
146 
	public ResponseEntity<?>  getDownloadCollectionSummary(HttpServletRequest request,
 168 
	public ResponseEntity<?>  getDownloadCollectionSummary(HttpServletRequest request,
147 
			@RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,
 169 
			@RequestParam(name = "startDate", required = true, defaultValue = "") LocalDate startDate,
148 
			@RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate,Model model) throws Exception {
 170 
			@RequestParam(name = "endDate", required = true, defaultValue = "") LocalDate endDate,Model model) throws Exception {
149 
		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
 171 
		LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
150 
		List<List<?>> rows = new ArrayList<>();
 172 
		List<List<?>> rows = new ArrayList<>();
151 
 
 173 
 
152
174
153 
		List<CollectionSummary> collectionSummaryList =orderRepository.selectCollectionSummary(fofoDetails.getFofoId(),startDate.atStartOfDay(), endDate.atStartOfDay());
 175 
		List<CollectionSummary> collectionSummaryList =orderRepository.selectCollectionSummary(fofoDetails.getFofoId(),startDate.atStartOfDay(), endDate.atTime(LocalTime.MAX));
154
176
155 
		Logger.info("CollectionSummaryList {}", collectionSummaryList);
 177 
		Logger.info("CollectionSummaryList {}", collectionSummaryList);
156 
		DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy HH:mm");
 178 
		DateTimeFormatter dateTimeFormatter = DateTimeFormatter.ofPattern("dd/MM/yyyy HH:mm");
157
179
158 
		for( CollectionSummary cs : collectionSummaryList) {
 180 
		for( CollectionSummary cs : collectionSummaryList) {