WebSVN – SmartDukaan – Diff – /trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/LeadController.java

 import javax.transaction.Transactional;
 import org.apache.logging.log4j.LogManager;
 import org.apache.logging.log4j.Logger;
 import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.cache.annotation.Cacheable;
 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.web.bind.annotation.RequestPart;
 import org.springframework.web.multipart.MultipartFile;
 import com.google.gson.Gson;
 import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
-import com.spice.profitmandi.common.model.ChartInvestmentModel;
-import com.spice.profitmandi.common.model.Data;
-import com.spice.profitmandi.common.model.DataInvestmentModel;
 import com.spice.profitmandi.common.model.Legend;
 import com.spice.profitmandi.common.model.OptionModel;
 import com.spice.profitmandi.common.model.PieLables;
 import com.spice.profitmandi.common.model.ProfitMandiConstants;
 import com.spice.profitmandi.common.util.FileUtil;
 import com.spice.profitmandi.dao.entity.auth.AuthUser;
-import com.spice.profitmandi.dao.entity.cs.Position;
-import com.spice.profitmandi.dao.entity.fofo.PartnerDailyInvestment;
 import com.spice.profitmandi.dao.entity.user.Lead;
 import com.spice.profitmandi.dao.entity.user.LeadActivity;
 import com.spice.profitmandi.dao.enumuration.dtr.LeadStatus;
 import com.spice.profitmandi.dao.model.ChartLeadModel;
 import com.spice.profitmandi.dao.model.CreateLeacdActivityRequest;
 import com.spice.profitmandi.dao.model.CreateRefferalRequest;
 import com.spice.profitmandi.dao.model.DataLeadModel;
 import com.spice.profitmandi.dao.model.LeadIvoryModel;
 import com.spice.profitmandi.dao.model.LeadStatusData;
-import com.spice.profitmandi.dao.model.StateGstRateModel;
 import com.spice.profitmandi.dao.repository.auth.AuthRepository;
 import com.spice.profitmandi.dao.repository.cs.PositionRepository;
 import com.spice.profitmandi.dao.repository.dtr.LeadActivityRepository;
 import com.spice.profitmandi.dao.repository.dtr.LeadRepository;
 import com.spice.profitmandi.dao.repository.inventory.StateRepository;
 	List<LeadStatus> status = Arrays.asList(LeadStatus.notInterested, LeadStatus.finalized);
 	@RequestMapping(value = "/getOpenLead", method = RequestMethod.GET)
 	public String getOpenLead(HttpServletRequest request,
 			@RequestParam(name = "leadStatus", required = false, defaultValue = "All") List<LeadStatus> leadStatus,
-			@RequestParam(name = "color", required = false, defaultValue = "") List<String> color, Model model)
+			@RequestParam(name = "color", required = false, defaultValue = "") List<String> color,
+			@RequestParam(name = "leadDate", required = false, defaultValue = "") LocalDate leadDate, Model model)
 			throws Exception {
+		LocalDateTime localDateTime = null;
+		LOGGER.info("color" + color);
+		LOGGER.info("leadDate" + leadDate);
+		if (leadDate != null) {
+			localDateTime = leadDate.atStartOfDay();
+		}
+		if (color == null) {
+			color.add("");
+		}
+		LOGGER.info("localDateTime" + localDateTime);
 		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
 		String emailId = loginDetails.getEmailId();
 		AuthUser authUser = authRepository.selectByEmailOrMobile(emailId);
 		boolean authPositon = positionRepository.hasCategory(authUser.getId(),
 				ProfitMandiConstants.TICKET_CATEGORY_SALES);
 		if (leadStatus.contains(LeadStatus.All)) {
+			leadStatus.add(LeadStatus.pending);
+			leadStatus.add(LeadStatus.notInterested);
-			leadStatus.addAll(Arrays.asList(LeadStatus.values()));
+			leadStatus.add(LeadStatus.finalized);
+		}
 		List<Lead> leads = null;
+		model.addAttribute("colors", color);
 		Map<Integer, LeadActivity> leadActivityMap = new HashMap<>();
 		List<Integer> authUserIds = null;
 		if (!color.isEmpty()) {
 			if (color.contains("All")) {
 				color.add("yellow");
 				color.add("green");
+			}
+			LOGGER.info("color111" + color);
 			if (authPositon) {
 				authUserIds = authService.getAllReportees(authUser.getId());
 				authUserIds.add(authUser.getId());
 				LOGGER.info("authIds" + authUserIds);
-				leads = leadRepository.selectAllByColorStatusAndUpdatedTimestampAndAuthIds(leadStatus, authUserIds,
-						color, LocalDateTime.now().withDayOfMonth(1).minusMonths(3));
+				if (leadStatus.contains(LeadStatus.All)) {
+					if (localDateTime == null) {
+						leads = leadRepository.selectAllByColorStatusAndUpdatedTimestampAndAuthIds(leadStatus,
+								authUserIds, color, LocalDate.now().atStartOfDay().withDayOfMonth(1).minusMonths(1));
+						List<Lead> leadFollowUp = leadRepository.selectAllByStatus(LeadStatus.followUp);
+						leads.addAll(leadFollowUp);
+					}
+					else {
+						leads = leadRepository.selectAllByColorStatusAndUpdatedTimestampAndAuthIds(leadStatus,
+								authUserIds, color, localDateTime);
+						List<Lead> leadFollowUp = leadRepository.selectAllByStatus(LeadStatus.followUp);
+						leads.addAll(leadFollowUp);
+					}
+				} else
+				{
+					if (localDateTime == null) {
+						leads = leadRepository.selectAllByColorStatusAndUpdatedTimestampAndAuthIds(leadStatus,
+								authUserIds, color, LocalDate.now().atStartOfDay().withDayOfMonth(1).minusMonths(1));
-			} else {
+					} else {
+						leads = leadRepository.selectAllByColorStatusAndUpdatedTimestampAndAuthIds(leadStatus,
+								authUserIds, color, localDateTime);
+					}
+				}
-				leads = leadRepository.selectAllByColorStatusAndUpdatedTimestamp(leadStatus, color,
-						LocalDateTime.now().withDayOfMonth(1).minusMonths(3));
+			}
+			else {
+				if (leadStatus.contains(LeadStatus.All)) {
+					if (localDateTime == null) {
+						leads = leadRepository.selectAllByColorStatusAndUpdatedTimestamp(leadStatus, color,
+								LocalDate.now().atStartOfDay().withDayOfMonth(1).minusMonths(1));
+						List<Lead> leadFollowUp = leadRepository.selectAllByStatus(LeadStatus.followUp);
+						leads.addAll(leadFollowUp);
+						LOGGER.info("leadlocalDateTime1" + leads);
+					} else {
+						leads = leadRepository.selectAllByColorStatusAndUpdatedTimestamp(leadStatus, color,
+								localDateTime);
+						LOGGER.info("leadlocalDateTime2" + leads);
+					}
+				}
-		} else {
+				else {
+					if (localDateTime == null) {
+						leads = leadRepository.selectAllByColorStatusAndUpdatedTimestamp(leadStatus, color,
+								LocalDate.now().atStartOfDay().withDayOfMonth(1).minusMonths(1));
+						LOGGER.info("leadlocalDateTime3" + leads);
+					} else {
+						leads = leadRepository.selectAllByColorStatusAndUpdatedTimestamp(leadStatus, color,
+								localDateTime);
+						LOGGER.info("leadlocalDateTime4" + leads);
+					}
+				}
+			}
+		}
+		else {
 			if (authPositon) {
 				authUserIds = authService.getAllReportees(authUser.getId());
 				authUserIds.add(authUser.getId());
 				LOGGER.info("authIds" + authUserIds);
-				leads = leadRepository.selectAllByStatusAndUpdatedTimestampAndAuthId(leadStatus,
+				if (leadStatus.contains(LeadStatus.All)) {
-						LocalDateTime.now().withDayOfMonth(1).minusMonths(3), authUserIds);
+					if (localDateTime == null) {
+						leads = leadRepository.selectAllByStatusAndUpdatedTimestampAndAuthId(leadStatus,
+								LocalDate.now().atStartOfDay().withDayOfMonth(1).minusMonths(1), authUserIds);
+						List<Lead> leadFollowUp = leadRepository.selectAllByStatus(LeadStatus.followUp);
+						leads.addAll(leadFollowUp);
+						LOGGER.info("leadlocalDateTime1" + leads);
+					}
-			} else {
+					else {
+						leads = leadRepository.selectAllByStatusAndUpdatedTimestampAndAuthId(leadStatus, localDateTime,
+								authUserIds);
+						List<Lead> leadFollowUp = leadRepository.selectAllByStatus(LeadStatus.followUp);
+						leads.addAll(leadFollowUp);
+						LOGGER.info("leadlocalDateTime1" + leads);
+					}
+				}
+				else {
+					if (localDateTime == null) {
-				leads = leadRepository.selectAllByStatusAndUpdatedTimestamp(leadStatus,
+						leads = leadRepository.selectAllByStatusAndUpdatedTimestampAndAuthId(leadStatus,
-						LocalDateTime.now().withDayOfMonth(1).minusMonths(3));
+								LocalDate.now().atStartOfDay().withDayOfMonth(1).minusMonths(1), authUserIds);
+					}
+					else {
+						leads = leadRepository.selectAllByStatusAndUpdatedTimestampAndAuthId(leadStatus, localDateTime,
+								authUserIds);
+					}
+				}
+			}
+			else {
+				if (leadStatus.contains(LeadStatus.All)) {
+					if (localDateTime == null) {
+						leads = leadRepository.selectAllByStatusAndUpdatedTimestamp(leadStatus,
+								LocalDate.now().atStartOfDay().withDayOfMonth(1).minusMonths(1));
-			// List<Lead> leads = leadRepository.selectAllBylistStatus(leadStatus);
+						List<Lead> leadFollowUp = leadRepository.selectAllByStatus(LeadStatus.followUp);
+						leads.addAll(leadFollowUp);
+						LOGGER.info("leadlocalDateTime1" + leads);
+					}
+					else {
+						leads = leadRepository.selectAllByStatusAndUpdatedTimestamp(leadStatus, localDateTime);
+						List<Lead> leadFollowUp = leadRepository.selectAllByStatus(LeadStatus.followUp);
+						leads.addAll(leadFollowUp);
+						LOGGER.info("leadlocalDateTime1" + leads);
+					}
+				}
+				else {
-			if (!leads.isEmpty()) {
+					if (localDateTime == null) {
-				leads.addAll(leadRepository.selectAllByStatus(LeadStatus.pending));
+						leads = leadRepository.selectAllByStatusAndUpdatedTimestamp(leadStatus,
+								LocalDate.now().atStartOfDay().withDayOfMonth(1).minusMonths(1));
+						LOGGER.info("manish!233" + leads);
+					}
+					else {
+						leads = leadRepository.selectAllByStatusAndUpdatedTimestamp(leadStatus, localDateTime);
+					}
+				}
+			}
+			// List<Lead> leads = leadRepository.selectAllBylistStatus(leadStatus);
+		}
 		if (authPositon && authUserIds.size() > 0) {
 			List<String> leadCreators = new ArrayList<>();
 			leadCreators.add("daily-sync");
 			leadCreators.addAll(authRepository.selectAllAuthUserByIds(authUserIds).stream().map(x -> x.getFullName())
 		weekDates.add(curDate.minusDays(7).toLocalDate());
 		LOGGER.info("lastDate" + lastDate);
 		model.addAttribute("weekDates", weekDates);
+		model.addAttribute("leadDate", leadDate);
 		model.addAttribute("lastDate", lastDate);
 		model.addAttribute("stateNames", stateNames);
 		model.addAttribute("authUsers", authUsers);
 		model.addAttribute("lead", leads);
 		model.addAttribute("leadStatus", LeadStatus.values());
 		model.addAttribute("leadLasts", leadLasts);
 		model.addAttribute("leadThirds", leadThirds);
 		model.addAttribute("leadSeconds", leadSeconds);
 		model.addAttribute("leadFirsts", leadFirsts);
 		model.addAttribute("lwDays", lwDays);
-		model.addAttribute("colors", color);
 		model.addAttribute("selectedLeadStatus", leadStatus.get(0));
 		return "lead";
+	}
 		LOGGER.info("hotLeadsMap" + hotLeadsMap);
 		ChartLeadModel cm = new ChartLeadModel();
 		HashSet<LeadStatus> labels = new HashSet<LeadStatus>();
 		labels.addAll(leadStatusMap.keySet());
 		HashSet<String> hotLeads = new HashSet<String>();
 		hotLeads.addAll(leadStatusMap.keySet().stream().map(x -> x.toString()).collect(Collectors.toSet()));
 		hotLeads.add("HotLead");
 		HashSet<String> hotLeadKeys = new HashSet<String>();
 		hotLeadKeys.add("HotLead");
 		List<String> hotLeadGreen = new ArrayList<>(hotLeadKeys);
 		List<LeadStatus> labelList = new ArrayList<>(labels);
 		List<String> backgroundColor = new ArrayList<>();
 		LOGGER.info("hotLeadKeys" + hotLeadKeys);
 		List<Long> values = new ArrayList<>();
 			if (label.equals(LeadStatus.followUp)) {
 				backgroundColor.add("#9ACD32");
+			}
 			if (label.equals(LeadStatus.finalized)) {
 				backgroundColor.add("blue");
 			}
+		}
-		for ( String hotLeadList : hotLeadGreen){
+		for (String hotLeadList : hotLeadGreen) {
-			if(hotLeadList.equals("HotLead"))
+			if (hotLeadList.equals("HotLead")) {
-			{
 				backgroundColor.add("green");
 				values.add(hotLeadsMap.get("Green"));
+			}
+		}
 		LOGGER.info("labelList" + labelList);
 		LOGGER.info("backgroundColor" + backgroundColor);
 		LOGGER.info("labelsChartLead" + labels);
 		model.addAttribute("response", mvcResponseSender.createResponseString(true));
 		return "response";
+	}
 	@RequestMapping(value = "/downloadIvoryLead", method = RequestMethod.GET)
 	public ResponseEntity<?> downloadDelayDayTemplate(HttpServletRequest request) throws Exception {
 		List<List<?>> rows = new ArrayList<>();
 		org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil
-				.getCSVByteStream(Arrays.asList("created_time", "Name", "email","Mobile","state","city"), rows);
+				.getCSVByteStream(Arrays.asList("created_time", "Name", "email", "Mobile", "state", "city"), rows);
 		final HttpHeaders headers = new HttpHeaders();
 		headers.set("Content-Type", "text/csv");
 		headers.set("Content-disposition", "inline; filename=Ivory.format.csv");
 		headers.setContentLength(baos.toByteArray().length);
 		final InputStream inputStream = new ByteArrayInputStream(baos.toByteArray());
 		final InputStreamResource inputStreamResource = new InputStreamResource(inputStream);
 		return new ResponseEntity<InputStreamResource>(inputStreamResource, headers, HttpStatus.OK);
+	}
 	@RequestMapping(value = "/csvFileAndSetLead", method = RequestMethod.POST)
 	public String readCsvFileAndSetLead(HttpServletRequest request, Model model, HttpServletResponse response,
 			@RequestPart MultipartFile file) throws Throwable {
 		LOGGER.info("file" + file.toString());
 			lead.setState(leadIvoryModel.getState());
 			lead.setCity(leadIvoryModel.getCity());
 			lead.setAddress("NOT AVAILABLE");
 			AuthUser authUser = authRepository.selectById(4);
-			if(leadIvoryModel.getCreatedTime() != null) {
+			if (leadIvoryModel.getCreatedTime() != null) {
-			lead.setCreatedTimestamp(leadIvoryModel.getCreatedTime());
+				lead.setCreatedTimestamp(leadIvoryModel.getCreatedTime());
-			}
-			else
+			} else {
-			{
 				lead.setCreatedTimestamp(LocalDateTime.now());
+			}
 			lead.setUpdatedTimestamp(LocalDateTime.now());
 			lead.setStatus(LeadStatus.pending);
 			lead.setAssignTo(authUser.getId());
 			lead.setSource("IVORY");

Subversion Repositories SmartDukaan

(root)/trunk/profitmandi-fofo/src/main/java/com/spice/profitmandi/web/controller/LeadController.java – Rev 29426 → 29445