Subversion Repositories SmartDukaan

Rev

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

Rev 30274 Rev 30326
Line 1... Line 1...
1
package com.spice.profitmandi.web.controller;
1
package com.spice.profitmandi.web.controller;
2
 
2
 
3
import com.spice.profitmandi.common.enumuration.DateTimePattern;
-
 
4
import com.spice.profitmandi.common.enumuration.ReporticoProject;
3
import com.spice.profitmandi.common.enumuration.ReporticoProject;
5
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
4
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
6
import com.spice.profitmandi.common.model.CustomRetailer;
5
import com.spice.profitmandi.common.model.CustomRetailer;
7
import com.spice.profitmandi.common.model.ProfitMandiConstants;
6
import com.spice.profitmandi.common.model.ProfitMandiConstants;
8
import com.spice.profitmandi.common.model.SchemeItems;
7
import com.spice.profitmandi.common.model.SchemeItems;
9
import com.spice.profitmandi.common.model.SchemeModel;
8
import com.spice.profitmandi.common.model.SchemeModel;
10
import com.spice.profitmandi.common.services.ReporticoService;
9
import com.spice.profitmandi.common.services.ReporticoService;
-
 
10
import com.spice.profitmandi.common.util.ExcelUtils;
-
 
11
import com.spice.profitmandi.common.util.FileUtil;
-
 
12
import com.spice.profitmandi.common.util.FormattingUtils;
11
import com.spice.profitmandi.common.util.*;
13
import com.spice.profitmandi.common.util.Utils;
12
import com.spice.profitmandi.common.web.util.ResponseSender;
14
import com.spice.profitmandi.common.web.util.ResponseSender;
13
import com.spice.profitmandi.dao.entity.catalog.*;
15
import com.spice.profitmandi.dao.entity.catalog.*;
14
import com.spice.profitmandi.dao.entity.fofo.*;
16
import com.spice.profitmandi.dao.entity.fofo.*;
15
import com.spice.profitmandi.dao.entity.transaction.PriceDrop;
17
import com.spice.profitmandi.dao.entity.transaction.PriceDrop;
16
import com.spice.profitmandi.dao.entity.transaction.PriceDropIMEI;
18
import com.spice.profitmandi.dao.entity.transaction.PriceDropIMEI;
Line 585... Line 587...
585
				model.addAttribute("mop", tagListing.getMop());
587
				model.addAttribute("mop", tagListing.getMop());
586
			}
588
			}
587
			model.addAttribute("modelName", item.getItemDescriptionNoColor());
589
			model.addAttribute("modelName", item.getItemDescriptionNoColor());
588
			if (isAdmin) {
590
			if (isAdmin) {
589
				schemes = schemeService.selectSchemeByPartnerType(partnerType, date, searchModel, isAdmin, offset, limit)
591
				schemes = schemeService.selectSchemeByPartnerType(partnerType, date, searchModel, isAdmin, offset, limit)
590
						.stream().filter(x -> {
-
 
591
							return (x.getId() != 411 && x.getId() != 612) || date1.isBefore(LocalDate.of(2021, 12, 1));
592
						.stream().filter(x -> x.getId() != 411 && x.getId() != 612).collect(Collectors.toList());
592
						}).collect(Collectors.toList());
-
 
593
				// Remove 411 and 612
593
				// Remove 411 and 612
594
				this.setSchemeAmountModel(schemes);
594
				this.setSchemeAmountModel(schemes);
595
				model.addAttribute("schemes", schemes);
595
				model.addAttribute("schemes", schemes);
596
				// For 7720(HR) remove investment
596
				// For 7720(HR) remove investment
597
				//int nlc = this.getNlc(item, loginDetails.getFofoId(), schemes, tagListing, searchModel);
597
				//int nlc = this.getNlc(item, loginDetails.getFofoId(), schemes, tagListing, searchModel);
Line 1245... Line 1245...
1245
		return "schemes-download";
1245
		return "schemes-download";
1246
	}
1246
	}
1247
 
1247
 
1248
	@RequestMapping(value = "/schemes/download", method = RequestMethod.GET)
1248
	@RequestMapping(value = "/schemes/download", method = RequestMethod.GET)
1249
	public ResponseEntity<?> downloadInventoryItemAgingByInterval(HttpServletRequest request,
1249
	public ResponseEntity<?> downloadInventoryItemAgingByInterval(HttpServletRequest request,
1250
																  @RequestParam(name = ProfitMandiConstants.START_DATE_TIME) String startDateTimeString,
1250
																  @RequestParam LocalDateTime startDateTime,
1251
																  @RequestParam(name = ProfitMandiConstants.END_DATE_TIME) String endDateTimeString, Model model)
1251
																  @RequestParam LocalDateTime endDateTime)
1252
			throws ProfitMandiBusinessException {
1252
			throws ProfitMandiBusinessException {
1253
		LocalDateTime startDateTime = StringUtils.toDateTime(startDateTimeString,
-
 
1254
				DateTimePattern.DD_MM_yyyy_T_HH_MM_SS);
-
 
1255
		LocalDateTime endDateTime = StringUtils.toDateTime(endDateTimeString, DateTimePattern.DD_MM_yyyy_T_HH_MM_SS);
-
 
1256
 
1253
 
1257
		List<SchemeModel> schemeModels = schemeService.getAllSchemeModels(startDateTime, endDateTime);
1254
		List<SchemeModel> schemeModels = schemeService.getAllSchemeModels(startDateTime, endDateTime);
1258
 
1255
 
1259
		ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
1256
		ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
1260
		ExcelUtils.writeSchemeModels(schemeModels, byteArrayOutputStream);
1257
		ExcelUtils.writeSchemeModels(schemeModels, byteArrayOutputStream);