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

 import com.spice.profitmandi.dao.repository.transaction.UserWalletRepository;
 import com.spice.profitmandi.service.AuthService;
 import com.spice.profitmandi.service.PartnerCollectionService;
 import com.spice.profitmandi.service.RbmTargetService;
 import com.spice.profitmandi.service.catalog.BrandsService;
+import com.spice.profitmandi.service.order.OrderService;
 import com.spice.profitmandi.service.user.RetailerService;
 import com.spice.profitmandi.web.model.LoginDetails;
 import com.spice.profitmandi.web.util.CookiesProcessor;
 import com.spice.profitmandi.web.util.MVCResponseSender;
 import org.apache.commons.csv.CSVRecord;
     @Autowired
     private ResponseSender<?> responseSender;
     @Autowired
     private BrandsService brandsService;
+    @Autowired
+    OrderService orderService;
     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 = "All") List<String> color, @RequestParam(name = "leadDate", required = false, defaultValue = "") LocalDate leadDate, Model model) throws Exception {
         cm.setOptions(om);
         return cm;
+    }
+    @RequestMapping(value = "/downloadDateWiseLead", method = RequestMethod.GET)
+    public ResponseEntity<?> getdownloadLeadDataByDate(HttpServletRequest request, @RequestParam(name = "leadStatus", required = false, defaultValue = "All") List<LeadStatus> leadStatus, @RequestParam(name = "color", required = false, defaultValue = "All") List<String> color, @RequestParam(name = "leadDate", required = false, defaultValue = "") LocalDate leadDate, Model model) throws Exception {
+        LoginDetails fofoDetails = cookiesProcessor.getCookiesObject(request);
+        String emailId = fofoDetails.getEmailId();
+        LocalDateTime localDateTime = null;
+        if (leadDate != null) {
+            localDateTime = leadDate.atStartOfDay();
+        }
+        List<Lead> leads = new ArrayList<>();
+        AuthUser authUser = authRepository.selectByEmailOrMobile(emailId);
+        model.addAttribute("colors", color);
+        Map<Integer, List<LeadActivity>> leadActivityMap = new HashMap<>();
+        boolean authPositon = positionRepository.hasCategory(authUser.getId(), ProfitMandiConstants.TICKET_CATEGORY_SALES);
+        List<Integer> authUserIds = null;
+        LOGGER.info("color111" + color);
+        List<Lead> leadFollowUp = new ArrayList<>();
+        if (authPositon) {
+            authUserIds = authService.getAllReportees(authUser.getId());
+            authUserIds.add(authUser.getId());
+            LOGGER.info("authIds" + authUserIds);
+            LOGGER.info("leadStatus" + leadStatus);
+            if (localDateTime == null) {
+                if (!leadStatus.contains(LeadStatus.followUp)) {
+                    leads = leadRepository.selectAllByColorStatusAndUpdatedTimestampAndAuthIds(leadStatus, authUserIds, color, LocalDateTime.now().minusMonths(1));
+                }
+                if (leadStatus.contains(LeadStatus.followUp) || leadStatus.contains(LeadStatus.All)) {
+                    leadFollowUp = leadRepository.selectByAssignAuthIdsAndStatus(authUserIds, LeadStatus.followUp);
+                    leads.addAll(leadFollowUp);
+                }
+            } else {
+                if (!leadStatus.contains(LeadStatus.followUp)) {
+                    leads = leadRepository.selectAllByColorStatusAndUpdatedTimestampAndAuthIds(leadStatus, authUserIds, color, localDateTime);
+                }
+                if (leadStatus.contains(LeadStatus.followUp) || leadStatus.contains(LeadStatus.All)) {
+                    leadFollowUp = leadRepository.selectByAssignAuthIdsAndStatus(authUserIds, LeadStatus.followUp);
+                    leads.addAll(leadFollowUp);
+                }
+            }
+        } else {
+            if (localDateTime == null) {
+                if (!leadStatus.contains(LeadStatus.followUp)) {
+                    leads = leadRepository.selectAllByColorStatusAndUpdatedTimestamp(leadStatus, color, LocalDateTime.now().minusMonths(1));
+                }
+                if (leadStatus.contains(LeadStatus.followUp) || leadStatus.contains(LeadStatus.All)) {
+                    leadFollowUp = leadRepository.selectAllByStatus(LeadStatus.followUp);
+                    leads.addAll(leadFollowUp);
+                }
+                LOGGER.info("leadlocalDateTime1" + leads);
+            } else {
+                if (!leadStatus.contains(LeadStatus.followUp)) {
+                    leads = leadRepository.selectAllByColorStatusAndUpdatedTimestamp(leadStatus, color, localDateTime);
+                }
+                if (leadStatus.contains(LeadStatus.followUp) || leadStatus.contains(LeadStatus.All)) {
+                    leadFollowUp = leadRepository.selectAllByStatus(LeadStatus.followUp);
+                    leads.addAll(leadFollowUp);
+                }
+                LOGGER.info("leadlocalDateTime2" + leads);
+            }
+        }
+        leadActivityMap = leadActivityRepository.selectAllByleadIds(leads.stream().map(x -> x.getId()).collect(Collectors.toList())).stream().collect(Collectors.groupingBy(LeadActivity::getLeadId, Collectors.toList()));
+        List<Integer> authIds = new ArrayList<>();
+        if (!leads.isEmpty()) {
+            authIds.addAll(leads.stream().map(x -> x.getAssignTo()).collect(Collectors.toList()));
+        }
+        Map<Integer, AuthUser> authIdAndAuthUserMap = authRepository.selectAllAuthUserByIds(authIds).stream().collect(Collectors.toMap(x -> x.getId(), x -> x));
+        List<List<?>> rows = new ArrayList<>();
+        for (Lead lead : leads) {
+            List<LeadActivity> activities = leadActivityMap.get(lead.getId());
+            String scheduleTimestamp = (activities != null && !activities.isEmpty())
+                    ? FormattingUtils.format(activities.get(0).getSchelduleTimestamp())
+                    : null;
+            Double potental = 0d;
+            String outLetName = "";
+            if (lead.getPotential() >= 0) {
+                potental = lead.getPotential();
+            } else if (activities != null && !activities.isEmpty()) {
+                potental = activities.get(0).getPotential();
+            } else potental = 0d;
+            if (lead.getOutLetName() != null) {
+                outLetName = lead.getOutLetName();
+            } else if (activities != null && !activities.isEmpty()) {
+                outLetName = activities.get(0).getOutletName();
+            } else outLetName = "-";
+            String assignTo = "-";
+            if (authIdAndAuthUserMap.get(lead.getAssignTo()) != null) {
+                assignTo = authIdAndAuthUserMap.get(lead.getAssignTo()).getFirstName() + " " + authIdAndAuthUserMap.get(lead.getAssignTo()).getLastName();
+            } else assignTo = "-";
+            rows.add(Arrays.asList(lead.getSource(), lead.getFullName(), outLetName, potental, lead.getLeadMobile(),
+                    lead.getAddress(), lead.getCity(), lead.getState(), lead.getCreatedBy(), lead.getStatus(),
+                    FormattingUtils.format(lead.getCreatedTimestamp()), FormattingUtils.format(lead.getUpdatedTimestamp()), scheduleTimestamp, FormattingUtils.format(lead.getClosureTimestamp()), assignTo, lead.getColor()));
+        }
+//        #if($leadActivityMap.get($lead.getId()).get(0).getSchelduleTimestamp())
+        org.apache.commons.io.output.ByteArrayOutputStream baos = FileUtil.getCSVByteStream(
+                Arrays.asList("Source", "Partner Name", "Outlet Name", "Potential", "Mobile", "Address", "City", "State",
+                        "Created By", "Status", "Created On", "Updated On", "Scheduled Timestamp", "Closure Timestamp", "Assign To", "Color"
+                ),
+                rows);
+        ResponseEntity<?> responseEntity = orderService.downloadReportInCsv(baos, rows, "Lead Details ");
+        return responseEntity;
+    }
     @RequestMapping(value = "/getClosedLead", method = RequestMethod.GET)
     public String getClosedLead(HttpServletRequest request, @RequestParam(name = "offset", defaultValue = "0") int offset, @RequestParam(name = "limit", defaultValue = "10") int limit, @RequestParam(name = "searchTerm", required = false, defaultValue = "") String searchTerm, Model model) throws Exception {
         List<AuthUser> authUsers = authRepository.selectAllActiveUser();
         List<Lead> leads = null;

Subversion Repositories SmartDukaan

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