Subversion Repositories SmartDukaan

Rev

Rev 32701 | Rev 32703 | Go to most recent revision | Details | Compare with Previous | Last modification | View Log | RSS feed

Rev Author Line No. Line
25899 tejbeer 1 
package com.spice.profitmandi.web.controller;
2 
 
30487 tejbeer 3 
import java.io.IOException;
30416 tejbeer 4 
import java.time.LocalDate;
5 
import java.time.LocalDateTime;
30433 tejbeer 6 
import java.time.format.DateTimeFormatter;
30416 tejbeer 7 
import java.util.ArrayList;
8 
import java.util.Arrays;
9 
import java.util.Comparator;
10 
import java.util.HashMap;
11 
import java.util.List;
12 
import java.util.Map;
13 
import java.util.Map.Entry;
14 
import java.util.Set;
15 
import java.util.stream.Collectors;
16 
 
17 
import javax.servlet.http.HttpServletRequest;
18 
 
31677 amit.gupta 19 
import com.spice.profitmandi.common.enumuration.ActivationType;
32701 amit.gupta 20 
import com.spice.profitmandi.common.web.client.RestClient;
21 
import com.spice.profitmandi.service.FofoUser;
30433 tejbeer 22 
import org.apache.commons.csv.CSVRecord;
30416 tejbeer 23 
import org.apache.logging.log4j.LogManager;
24 
import org.apache.logging.log4j.Logger;
25 
import org.springframework.beans.factory.annotation.Autowired;
26 
import org.springframework.format.annotation.DateTimeFormat;
30487 tejbeer 27 
import org.springframework.http.HttpHeaders;
28 
import org.springframework.http.HttpStatus;
30416 tejbeer 29 
import org.springframework.http.MediaType;
30 
import org.springframework.http.ResponseEntity;
31 
import org.springframework.stereotype.Controller;
32 
import org.springframework.transaction.annotation.Transactional;
33 
import org.springframework.ui.Model;
32701 amit.gupta 34 
import org.springframework.web.bind.annotation.*;
30433 tejbeer 35 
import org.springframework.web.multipart.MultipartFile;
30416 tejbeer 36 
 
30487 tejbeer 37 
import com.mongodb.DBObject;
31249 tejbeer 38 
import com.spice.profitmandi.common.enumuration.MessageType;
25899 tejbeer 39 
import com.spice.profitmandi.common.exception.ProfitMandiBusinessException;
25952 tejbeer 40 
import com.spice.profitmandi.common.model.CustomRetailer;
27117 tejbeer 41 
import com.spice.profitmandi.common.model.ProfitMandiConstants;
31249 tejbeer 42 
import com.spice.profitmandi.common.model.SendNotificationModel;
30433 tejbeer 43 
import com.spice.profitmandi.common.util.FileUtil;
31249 tejbeer 44 
import com.spice.profitmandi.common.util.FormattingUtils;
25899 tejbeer 45 
import com.spice.profitmandi.common.web.util.ResponseSender;
46 
import com.spice.profitmandi.dao.entity.auth.AuthUser;
30077 tejbeer 47 
import com.spice.profitmandi.dao.entity.auth.PartnerCollectionPlan;
30416 tejbeer 48 
import com.spice.profitmandi.dao.entity.auth.PartnerCollectionRemark;
30077 tejbeer 49 
import com.spice.profitmandi.dao.entity.auth.PartnerSecondaryPlan;
30416 tejbeer 50 
import com.spice.profitmandi.dao.entity.cs.Ticket;
51 
import com.spice.profitmandi.dao.entity.cs.TicketCategory;
52 
import com.spice.profitmandi.dao.entity.cs.TicketSubCategory;
25899 tejbeer 53 
import com.spice.profitmandi.dao.entity.dtr.User;
25952 tejbeer 54 
import com.spice.profitmandi.dao.entity.dtr.UserAccount;
28935 tejbeer 55 
import com.spice.profitmandi.dao.entity.fofo.FofoStore;
30087 tejbeer 56 
import com.spice.profitmandi.dao.entity.fofo.PartnerDailyInvestment;
28935 tejbeer 57 
import com.spice.profitmandi.dao.entity.fofo.PartnerOnBoardingPanel;
25952 tejbeer 58 
import com.spice.profitmandi.dao.entity.user.FranchiseeActivity;
59 
import com.spice.profitmandi.dao.entity.user.FranchiseeVisit;
25899 tejbeer 60 
import com.spice.profitmandi.dao.entity.user.Lead;
61 
import com.spice.profitmandi.dao.entity.user.LeadActivity;
31249 tejbeer 62 
import com.spice.profitmandi.dao.entity.user.VisitRequest;
30416 tejbeer 63 
import com.spice.profitmandi.dao.enumuration.auth.CollectionRemark;
31249 tejbeer 64 
import com.spice.profitmandi.dao.enumuration.dtr.CommunicationType;
25952 tejbeer 65 
import com.spice.profitmandi.dao.enumuration.dtr.FranchiseeActivityStatus;
66 
import com.spice.profitmandi.dao.enumuration.dtr.FranchiseeVisitStatus;
25899 tejbeer 67 
import com.spice.profitmandi.dao.enumuration.dtr.LeadStatus;
28935 tejbeer 68 
import com.spice.profitmandi.dao.enumuration.dtr.StoreTimeline;
31249 tejbeer 69 
import com.spice.profitmandi.dao.enumuration.dtr.VisitStatus;
30416 tejbeer 70 
import com.spice.profitmandi.dao.model.CreateRefferalRequest;
71 
import com.spice.profitmandi.dao.model.OnBoardingTimelineModel;
72 
import com.spice.profitmandi.dao.model.PartnerCollectionPlanModel;
73 
import com.spice.profitmandi.dao.model.PartnerCollectionRemarkModel;
74 
import com.spice.profitmandi.dao.model.PartnerSecondaryPlanModel;
75 
import com.spice.profitmandi.dao.model.PartnerTargetAchievementModel;
76 
import com.spice.profitmandi.dao.model.TargetModel;
77 
import com.spice.profitmandi.dao.model.TicketViewModel;
78 
import com.spice.profitmandi.dao.model.UserCart;
31249 tejbeer 79 
import com.spice.profitmandi.dao.model.UserVisitModel;
80 
import com.spice.profitmandi.dao.model.VisitDescriptionModel;
81 
import com.spice.profitmandi.dao.model.VisitSummaryModel;
25899 tejbeer 82 
import com.spice.profitmandi.dao.repository.auth.AuthRepository;
30104 tejbeer 83 
import com.spice.profitmandi.dao.repository.auth.AuthUserPartnerMappingRepository;
30077 tejbeer 84 
import com.spice.profitmandi.dao.repository.auth.PartnerCollectionPlanRepository;
30416 tejbeer 85 
import com.spice.profitmandi.dao.repository.auth.PartnerCollectionRemarkRepository;
30077 tejbeer 86 
import com.spice.profitmandi.dao.repository.auth.PartnerSecondaryPlanRepository;
25952 tejbeer 87 
import com.spice.profitmandi.dao.repository.cs.CsService;
30416 tejbeer 88 
import com.spice.profitmandi.dao.repository.cs.TicketCategoryRepository;
89 
import com.spice.profitmandi.dao.repository.cs.TicketRepository;
90 
import com.spice.profitmandi.dao.repository.cs.TicketSubCategoryRepository;
91 
import com.spice.profitmandi.dao.repository.dtr.FofoStoreRepository;
92 
import com.spice.profitmandi.dao.repository.dtr.FranchiseeActivityRepository;
93 
import com.spice.profitmandi.dao.repository.dtr.FranchiseeVisitRepository;
94 
import com.spice.profitmandi.dao.repository.dtr.LeadActivityRepository;
95 
import com.spice.profitmandi.dao.repository.dtr.LeadRepository;
30487 tejbeer 96 
import com.spice.profitmandi.dao.repository.dtr.Mongo;
30416 tejbeer 97 
import com.spice.profitmandi.dao.repository.dtr.PartnerOnBoardingPanelRepository;
98 
import com.spice.profitmandi.dao.repository.dtr.UserAccountRepository;
99 
import com.spice.profitmandi.dao.repository.dtr.UserRepository;
31249 tejbeer 100 
import com.spice.profitmandi.dao.repository.dtr.VisitRequestRepository;
30087 tejbeer 101 
import com.spice.profitmandi.dao.repository.fofo.PartnerDailyInvestmentRepository;
30077 tejbeer 102 
import com.spice.profitmandi.dao.repository.transaction.OrderRepository;
31249 tejbeer 103 
import com.spice.profitmandi.service.AuthService;
104 
import com.spice.profitmandi.service.NotificationService;
30348 tejbeer 105 
import com.spice.profitmandi.service.PartnerCollectionService;
25952 tejbeer 106 
import com.spice.profitmandi.service.user.RetailerService;
28935 tejbeer 107 
import com.spice.profitmandi.service.user.StoreTimelineTatService;
25952 tejbeer 108 
import com.spice.profitmandi.web.req.CreateFranchiseeRequest;
109 
import com.spice.profitmandi.web.res.Partner;
30416 tejbeer 110 
 
25899 tejbeer 111 
import io.swagger.annotations.ApiImplicitParam;
112 
import io.swagger.annotations.ApiImplicitParams;
113 
 
114 
@Controller
115 
@Transactional(rollbackFor = Throwable.class)
116 
public class LeadController {
31677 amit.gupta 117 
    private static final Logger LOGGER = LogManager.getLogger(LeadController.class);
118 
    @Autowired
119 
    private ResponseSender<?> responseSender;
25899 tejbeer 120 
 
31677 amit.gupta 121 
    @Autowired
122 
    private AuthRepository authRepository;
25899 tejbeer 123 
 
31677 amit.gupta 124 
    @Autowired
125 
    private LeadRepository leadRepository;
25899 tejbeer 126 
 
31677 amit.gupta 127 
    @Autowired
128 
    private CsService csService;
25952 tejbeer 129 
 
31677 amit.gupta 130 
    @Autowired
131 
    private UserRepository userRepository;
25952 tejbeer 132 
 
31677 amit.gupta 133 
    @Autowired
134 
    private UserAccountRepository userAccountRepository;
25952 tejbeer 135 
 
31677 amit.gupta 136 
    @Autowired
137 
    private com.spice.profitmandi.dao.repository.user.UserRepository userUserRepository;
25952 tejbeer 138 
 
31677 amit.gupta 139 
    @Autowired
140 
    private RetailerService retailerService;
25952 tejbeer 141 
 
31677 amit.gupta 142 
    @Autowired
143 
    private LeadActivityRepository leadActivityRepository;
25899 tejbeer 144 
 
31677 amit.gupta 145 
    @Autowired
146 
    private FranchiseeVisitRepository franchiseeVisitRepository;
25952 tejbeer 147 
 
31677 amit.gupta 148 
    @Autowired
149 
    private FranchiseeActivityRepository franchiseeActivityRepository;
25952 tejbeer 150 
 
31677 amit.gupta 151 
    @Autowired
152 
    private PartnerOnBoardingPanelRepository partnerOnBoardingPanelRepository;
28935 tejbeer 153 
 
31677 amit.gupta 154 
    @Autowired
155 
    private FofoStoreRepository fofoStoreRepository;
28935 tejbeer 156 
 
31677 amit.gupta 157 
    @Autowired
158 
    private StoreTimelineTatService storeTimelineTatService;
28935 tejbeer 159 
 
31677 amit.gupta 160 
    @Autowired
161 
    private PartnerCollectionService partnerCollectionService;
30348 tejbeer 162 
 
31677 amit.gupta 163 
    @Autowired
164 
    private TicketRepository ticketRepository;
30416 tejbeer 165 
 
31677 amit.gupta 166 
    @Autowired
167 
    private TicketCategoryRepository ticketCategoryRepository;
30416 tejbeer 168 
 
31677 amit.gupta 169 
    @Autowired
170 
    private TicketSubCategoryRepository ticketSubCategoryRepository;
30416 tejbeer 171 
 
31677 amit.gupta 172 
    @Autowired
173 
    private PartnerCollectionRemarkRepository partnerCollectionRemarkRepository;
30416 tejbeer 174 
 
31677 amit.gupta 175 
    @Autowired
176 
    private Mongo mongoClient;
30487 tejbeer 177 
 
31677 amit.gupta 178 
    @Autowired
179 
    private OrderRepository orderRepository;
30487 tejbeer 180 
 
31677 amit.gupta 181 
    @Autowired
182 
    private PartnerCollectionPlanRepository partnerCollectionPlanRepository;
30487 tejbeer 183 
 
31677 amit.gupta 184 
    @Autowired
185 
    private PartnerSecondaryPlanRepository partnerSecondaryPlanRepository;
30487 tejbeer 186 
 
31677 amit.gupta 187 
    @Autowired
188 
    private PartnerDailyInvestmentRepository partnerDailyInvestmentRepository;
30487 tejbeer 189 
 
31677 amit.gupta 190 
    @Autowired
191 
    private AuthUserPartnerMappingRepository authUserPartnerMappingRepository;
30487 tejbeer 192 
 
31677 amit.gupta 193 
    @Autowired
194 
    private VisitRequestRepository visitRequestRepository;
31249 tejbeer 195 
 
31677 amit.gupta 196 
    @Autowired
197 
    private AuthService authService;
31249 tejbeer 198 
 
31677 amit.gupta 199 
    @Autowired
200 
    private NotificationService notificationService;
31249 tejbeer 201 
 
31677 amit.gupta 202 
    @RequestMapping(value = "/lead", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
203 
    @ApiImplicitParams({
204 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
205 
    public ResponseEntity<?> LeadUser(HttpServletRequest request,
206 
                                      @RequestBody CreateRefferalRequest createRefferalRequest) throws Exception {
207 
        Lead lead = new Lead();
208 
        lead.setFirstName(createRefferalRequest.getFirstName());
209 
        lead.setLastName(createRefferalRequest.getLastName());
210 
        lead.setLeadMobile(createRefferalRequest.getMobile());
211 
        lead.setState(createRefferalRequest.getState());
212 
        lead.setCity(createRefferalRequest.getCity());
213 
        lead.setAddress(createRefferalRequest.getAddress());
214 
        lead.setCreatedTimestamp(LocalDateTime.now());
215 
        lead.setUpdatedTimestamp(LocalDateTime.now());
216 
        lead.setStatus(createRefferalRequest.getStatus());
217 
        lead.setSource(createRefferalRequest.getSource());
218 
        lead.setNotinterestedReason(createRefferalRequest.getReason());
219 
        if (createRefferalRequest.getColorCheck() == true) {
220 
            lead.setColor("Green");
221 
        } else {
222 
            lead.setColor("Yellow");
223 
        }
224 
        AuthUser authUser = authRepository.selectByGmailId(createRefferalRequest.getReffereeEmail());
225 
        String authUserName = authUser.getFirstName() + " " + authUser.getLastName();
226 
        lead.setCreatedBy(authUserName);
227 
        lead.setAuthId(authUser.getId());
228 
        lead.setAssignTo(authUser.getId());
25899 tejbeer 229 
 
31677 amit.gupta 230 
        leadRepository.persist(lead);
231 
        LeadActivity leadActivity = new LeadActivity();
232 
        leadActivity.setLeadId(lead.getId());
233 
        leadActivity.setRemark(createRefferalRequest.getRemark());
25899 tejbeer 234 
 
31677 amit.gupta 235 
        leadActivity.setAuthId(authUser.getId());
31249 tejbeer 236 
 
31677 amit.gupta 237 
        if (createRefferalRequest.getStatus().equals(LeadStatus.followUp)) {
238 
            leadActivity.setSchelduleTimestamp(createRefferalRequest.getSchelduleTimestamp());
239 
            leadActivity.setCommunicationType(createRefferalRequest.getCommunicationType());
31249 tejbeer 240 
 
31677 amit.gupta 241 
            if (leadActivity.getCommunicationType().equals(CommunicationType.VISIT)) {
31249 tejbeer 242 
 
31677 amit.gupta 243 
                visitRequestRepository.createVisitRequest(lead.getId(), "lead", lead.getAssignTo(),
244 
                        createRefferalRequest.getSchelduleTimestamp());
245 
            }
246 
            //
247 
            leadActivity.setClosureTimestamp(createRefferalRequest.getClosureTimestamp());
248 
            lead.setClosureTimestamp(createRefferalRequest.getClosureTimestamp());
249 
        } else {
250 
            leadActivity.setSchelduleTimestamp(null);
251 
            leadActivity.setClosureTimestamp(null);
252 
            lead.setClosureTimestamp(null);
253 
        }
254 
        leadActivity.setCreatedTimestamp(LocalDateTime.now());
255 
        leadActivityRepository.persist(leadActivity);
25899 tejbeer 256 
 
31677 amit.gupta 257 
        return responseSender.ok(true);
258 
    }
25899 tejbeer 259 
 
31677 amit.gupta 260 
    @RequestMapping(value = "/lead-description", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
261 
    @ApiImplicitParams({
262 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
263 
    public ResponseEntity<?> leadDescription(HttpServletRequest request, @RequestParam(name = "gmailId") String gmailId,
264 
                                             @RequestParam(name = "status") LeadStatus status) throws ProfitMandiBusinessException {
265 
        AuthUser authUser = authRepository.selectByGmailId(gmailId);
266 
        List<Lead> leads = null;
267 
        LOGGER.info("emails" + status);
31249 tejbeer 268 
 
31677 amit.gupta 269 
        List<VisitRequest> visitRequests = visitRequestRepository.selectByAuthIdAndDate(authUser.getId(),
270 
                LocalDate.now());
271 
        Map<Integer, List<VisitRequest>> visitRequestMap = null;
272 
        if (!visitRequests.isEmpty()) {
273 
            visitRequestMap = visitRequests.stream().collect(Collectors.groupingBy(x -> x.getVisitId()));
274 
        }
275 
        if (status.equals(LeadStatus.followUp)) {
30306 tejbeer 276 
 
31677 amit.gupta 277 
            leads = leadRepository.selectLeadsScheduledBetweenDate(Arrays.asList(authUser.getId()), null, null);
31249 tejbeer 278 
 
31677 amit.gupta 279 
            if (visitRequestMap != null) {
280 
                for (Lead lead : leads) {
281 
                    List<VisitRequest> visitRequest = visitRequestMap.get(lead.getId());
31249 tejbeer 282 
 
31677 amit.gupta 283 
                    if (visitRequest != null) {
284 
                        if (visitRequest.size() > 1) {
31249 tejbeer 285 
 
31677 amit.gupta 286 
                            Comparator<VisitRequest> visitComparato = Comparator
287 
                                    .comparing(VisitRequest::getCreatedTimestamp);
31249 tejbeer 288 
 
31677 amit.gupta 289 
                            VisitRequest youngestVisit = visitRequest.stream().max(visitComparato).get();
290 
                            lead.setVisitStatus(youngestVisit.getStatus());
31249 tejbeer 291 
 
31677 amit.gupta 292 
                        } else {
293 
                            lead.setVisitStatus(visitRequest.get(0).getStatus());
31249 tejbeer 294 
 
31677 amit.gupta 295 
                        }
296 
                    }
31249 tejbeer 297 
 
31677 amit.gupta 298 
                }
299 
            }
31249 tejbeer 300 
 
31677 amit.gupta 301 
            leads = leads.stream()
302 
                    .sorted(Comparator.comparing(Lead::getScheduledTimestamp,
303 
                            Comparator.nullsFirst(Comparator.reverseOrder())))
304 
                    .collect(Collectors
305 
                            .toList());/*
306 
             * Collections.sort(leads, (o1, o2) -> { if (o1.getScheduledTimestamp() != null
307 
             * && o2.getScheduledTimestamp() != null) { return
308 
             * o1.getScheduledTimestamp().isBefore(o2.getScheduledTimestamp()) ? -1 : 1; }
309 
             * else if (o1.getScheduledTimestamp() != null) { return 1; } else { return -1;
310 
             * } });
311 
             */
30306 tejbeer 312 
 
31677 amit.gupta 313 
        } else {
314 
            leads = leadRepository.selectByAssignAuthIdAndStatus(authUser.getId(), status);
30294 tejbeer 315 
 
31677 amit.gupta 316 
        }
25979 tejbeer 317 
 
31677 amit.gupta 318 
        return responseSender.ok(leads);
25899 tejbeer 319 
 
31677 amit.gupta 320 
    }
25899 tejbeer 321 
 
31677 amit.gupta 322 
    @RequestMapping(value = "/getlead", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
323 
    @ApiImplicitParams({
324 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
325 
    public ResponseEntity<?> getLead(HttpServletRequest request, @RequestParam(name = "id") int id)
326 
            throws ProfitMandiBusinessException {
25899 tejbeer 327 
 
31677 amit.gupta 328 
        List<LeadActivity> leadActivities = leadActivityRepository.selectBYLeadId(id);
329 
        Lead lead = leadRepository.selectById(id);
330 
        lead.setLeadActivities(leadActivities);
331 
        return responseSender.ok(lead);
25899 tejbeer 332 
 
31677 amit.gupta 333 
    }
25899 tejbeer 334 
 
31677 amit.gupta 335 
    @RequestMapping(value = "/leadUpdate", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
336 
    @ApiImplicitParams({
337 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
338 
    public ResponseEntity<?> leadUpdate(HttpServletRequest request, @RequestParam(name = "id") int id,
339 
                                        @RequestParam(name = "status") LeadStatus status, @RequestParam(name = "colorCheck") Boolean colorCheck,
340 
                                        @RequestParam(name = "remark") String remark, @RequestParam(name = "reason") String reason,
341 
                                        @RequestParam(name = "schelduleTimestamp") @DateTimeFormat(iso = DateTimeFormat.ISO.DATE_TIME) LocalDateTime schelduleTimestamp,
342 
                                        @RequestParam(name = "closureTimestamp") @DateTimeFormat(iso = DateTimeFormat.ISO.DATE_TIME) LocalDateTime closureTimestamp,
343 
                                        @RequestParam(name = "communicationType") CommunicationType communicationType)
344 
            throws ProfitMandiBusinessException {
25899 tejbeer 345 
 
31677 amit.gupta 346 
        Lead lead = leadRepository.selectById(id);
25899 tejbeer 347 
 
31677 amit.gupta 348 
        LeadActivity leadActivity = new LeadActivity();
349 
        lead.setStatus(status);
350 
        lead.setNotinterestedReason(reason);
351 
        leadActivity.setRemark(remark);
352 
        leadActivity.setLeadId(id);
353 
        leadActivity.setCreatedTimestamp(LocalDateTime.now());
354 
        leadActivity.setSchelduleTimestamp(null);
355 
        leadActivity.setClosureTimestamp(null);
356 
        leadActivity.setAuthId(lead.getAssignTo());
357 
        lead.setUpdatedTimestamp(LocalDateTime.now());
358 
        if (colorCheck == true) {
359 
            lead.setColor("Green");
360 
        } else {
361 
            lead.setColor("Yellow");
362 
        }
363 
        if (status == LeadStatus.followUp) {
25899 tejbeer 364 
 
31677 amit.gupta 365 
            if (schelduleTimestamp != null) {
31249 tejbeer 366 
 
31677 amit.gupta 367 
                leadActivity.setCommunicationType(communicationType);
31249 tejbeer 368 
 
31677 amit.gupta 369 
                if (leadActivity.getCommunicationType().equals(CommunicationType.VISIT)) {
31249 tejbeer 370 
 
31677 amit.gupta 371 
                    visitRequestRepository.createVisitRequest(lead.getId(), "lead", lead.getAssignTo(),
372 
                            schelduleTimestamp);
373 
                }
31249 tejbeer 374 
 
31677 amit.gupta 375 
            }
376 
            leadActivity.setSchelduleTimestamp(schelduleTimestamp);
377 
            leadActivity.setClosureTimestamp(closureTimestamp);
378 
            lead.setClosureTimestamp(closureTimestamp);
26250 tejbeer 379 
 
31677 amit.gupta 380 
        } else {
26250 tejbeer 381 
 
31677 amit.gupta 382 
            leadActivity.setSchelduleTimestamp(null);
383 
            leadActivity.setClosureTimestamp(null);
384 
            lead.setClosureTimestamp(null);
26244 tejbeer 385 
 
31677 amit.gupta 386 
        }
387 
        leadActivityRepository.persist(leadActivity);
388 
        return responseSender.ok(true);
25899 tejbeer 389 
 
31677 amit.gupta 390 
    }
25952 tejbeer 391 
 
31677 amit.gupta 392 
    @RequestMapping(value = ProfitMandiConstants.URL_NEW_LEAD, method = RequestMethod.POST)
393 
    public ResponseEntity<?> newLead(HttpServletRequest request,
394 
                                     @RequestBody CreateRefferalRequest createRefferalRequest) throws ProfitMandiBusinessException {
395 
        LOGGER.info("requested url : " + request.getRequestURL().toString());
396 
        Lead lead = new Lead();
397 
        lead.setAddress(createRefferalRequest.getCity());
398 
        Long.parseLong(createRefferalRequest.getMobile());
399 
        if (createRefferalRequest.getMobile().length() != 10) {
400 
            throw new ProfitMandiBusinessException("Mobile Number", createRefferalRequest.getMobile(),
401 
                    "Number should be of 10 digits");
402 
        }
403 
        lead.setLeadMobile(createRefferalRequest.getMobile());
404 
        lead.setCity(createRefferalRequest.getCity());
405 
        lead.setState(createRefferalRequest.getState());
406 
        lead.setLastName(createRefferalRequest.getLastName());
407 
        if (lead.getState().equals("Uttar Pradesh")) {
408 
            lead.setAssignTo(53);
409 
        } else if (lead.getState().equals("Haryana")) {
410 
            lead.setAssignTo(53);
411 
        } else if (lead.getState().equals("Delhi")) {
412 
            lead.setAssignTo(53);
413 
        } else {
414 
            // Assign to sm
415 
            lead.setAssignTo(53);
416 
            // Assign to neha
417 
            // lead.setAssignTo(1);
418 
        }
419 
        lead.setAuthId(lead.getAssignTo());
420 
        lead.setCreatedBy("daily-sync");
421 
        lead.setSource("SD-WEB");
422 
        lead.setFirstName(createRefferalRequest.getFirstName());
423 
        lead.setStatus(LeadStatus.followUp);
424 
        lead.setColor("yellow");
425 
        lead.setCreatedTimestamp(LocalDateTime.now());
426 
        lead.setUpdatedTimestamp(LocalDateTime.now());
427 
        leadRepository.persist(lead);
27117 tejbeer 428 
 
31677 amit.gupta 429 
        return responseSender.ok(true);
27117 tejbeer 430 
 
31677 amit.gupta 431 
    }
27117 tejbeer 432 
 
31677 amit.gupta 433 
    @RequestMapping(value = "/getPartnersList", method = RequestMethod.GET)
434 
    @ApiImplicitParams({
435 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
436 
    public ResponseEntity<?> getPartners(HttpServletRequest request, @RequestParam(name = "gmailId") String gmailId)
437 
            throws ProfitMandiBusinessException {
25952 tejbeer 438 
 
31677 amit.gupta 439 
        AuthUser authUser = authRepository.selectByGmailId(gmailId);
25952 tejbeer 440 
 
31677 amit.gupta 441 
        Map<String, Set<String>> storeGuyMap = csService.getAuthUserPartnerEmailMapping();
25952 tejbeer 442 
 
31677 amit.gupta 443 
        Set<String> emails = storeGuyMap.get(authUser.getEmailId());
444 
        LOGGER.info("emails" + emails);
445 
        List<User> users = userRepository.selectAllByEmailIds(new ArrayList<>(emails));
446 
        List<Partner> partners = new ArrayList<>();
447 
        for (User user : users) {
25952 tejbeer 448 
 
31677 amit.gupta 449 
            UserAccount uc = userAccountRepository.selectSaholicByUserId(user.getId());
450 
            com.spice.profitmandi.dao.entity.user.User userInfo = userUserRepository.selectById(uc.getAccountKey());
451 
            CustomRetailer customRetailer = retailerService.getFofoRetailer(userInfo.getId());
25952 tejbeer 452 
 
31677 amit.gupta 453 
            Partner partner = new Partner();
454 
            partner.setBusinessName(customRetailer.getBusinessName());
455 
            partner.setPartnerId(customRetailer.getPartnerId());
456 
            partner.setCartId(customRetailer.getCartId());
457 
            partner.setEmail(customRetailer.getEmail());
458 
            partner.setGstNumber(customRetailer.getGstNumber());
459 
            partner.setDisplayName(customRetailer.getDisplayName());
460 
            partner.setCity(customRetailer.getAddress().getCity());
461 
            partner.setUserId(user.getId());
462 
            partners.add(partner);
463 
        }
464 
        LOGGER.info("partners" + partners);
465 
        return responseSender.ok(partners);
466 
    }
25952 tejbeer 467 
 
31677 amit.gupta 468 
    @RequestMapping(value = "/franchise-first-visit", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
469 
    @ApiImplicitParams({
470 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
471 
    public ResponseEntity<?> FranchiseFirstVisit(HttpServletRequest request,
472 
                                                 @RequestBody CreateFranchiseeRequest createFranchiseeRequest) throws Exception {
25952 tejbeer 473 
 
31677 amit.gupta 474 
        FranchiseeVisit franchiseeVisit = new FranchiseeVisit();
475 
        franchiseeVisit.setFofoId(createFranchiseeRequest.getFofoId());
476 
        CustomRetailer customRetailer = retailerService.getFofoRetailer(createFranchiseeRequest.getFofoId());
25952 tejbeer 477 
 
31677 amit.gupta 478 
        franchiseeVisit.setPartnerName(customRetailer.getBusinessName());
479 
        franchiseeVisit.setAgenda(createFranchiseeRequest.getAgenda());
480 
        franchiseeVisit.setCreatedTimestamp(LocalDateTime.now());
481 
        franchiseeVisit.setUpdatedTimestamp(LocalDateTime.now());
482 
        franchiseeVisit.setStatus(FranchiseeVisitStatus.OPEN);
483 
        franchiseeVisit.setScheduleTimestamp(createFranchiseeRequest.getFirstSchelduleTimestamp());
484 
        // change
485 
        AuthUser authUser = authRepository.selectByGmailId(createFranchiseeRequest.getCreatedBy());
25952 tejbeer 486 
 
31677 amit.gupta 487 
        String authUserName = authUser.getFirstName() + " " + authUser.getLastName();
488 
        franchiseeVisit.setCreatedBy(authUserName);
489 
        franchiseeVisit.setAuthId(authUser.getId());
25952 tejbeer 490 
 
31677 amit.gupta 491 
        franchiseeVisitRepository.persist(franchiseeVisit);
25952 tejbeer 492 
 
31677 amit.gupta 493 
        FranchiseeActivity franchiseeActivity = new FranchiseeActivity();
494 
        franchiseeActivity.setAction(FranchiseeActivityStatus.FOLLOWUP);
495 
        franchiseeActivity.setFranchiseeVisitd(franchiseeVisit.getId());
496 
        franchiseeActivity.setResolution(createFranchiseeRequest.getResolution());
497 
        franchiseeActivity.setSchelduleTimestamp(createFranchiseeRequest.getFirstSchelduleTimestamp());
31249 tejbeer 498 
 
31677 amit.gupta 499 
        franchiseeActivity.setCreatedTimestamp(LocalDateTime.now());
500 
        franchiseeActivityRepository.persist(franchiseeActivity);
31249 tejbeer 501 
 
31677 amit.gupta 502 
        franchiseeVisit.setFranchiseActivityId(franchiseeActivity.getId());
31249 tejbeer 503 
 
31677 amit.gupta 504 
        visitRequestRepository.createVisitRequest(franchiseeVisit.getId(), "franchiseeVisit", authUser.getId(),
505 
                createFranchiseeRequest.getFirstSchelduleTimestamp());
31249 tejbeer 506 
 
31677 amit.gupta 507 
        return responseSender.ok(true);
508 
    }
25952 tejbeer 509 
 
31677 amit.gupta 510 
    @RequestMapping(value = "/franchise-visit", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
511 
    @ApiImplicitParams({
512 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
513 
    public ResponseEntity<?> FranchiseVisit(HttpServletRequest request,
514 
                                            @RequestBody CreateFranchiseeRequest createFranchiseeRequest) throws Exception {
25952 tejbeer 515 
 
31677 amit.gupta 516 
        FranchiseeVisit franchiseeVisit = franchiseeVisitRepository.selectById(createFranchiseeRequest.getId());
517 
        franchiseeVisit.setFofoId(createFranchiseeRequest.getFofoId());
518 
        CustomRetailer customRetailer = retailerService.getFofoRetailer(createFranchiseeRequest.getFofoId());
25952 tejbeer 519 
 
31677 amit.gupta 520 
        franchiseeVisit.setPartnerName(customRetailer.getBusinessName());
521 
        franchiseeVisit.setAgenda(createFranchiseeRequest.getAgenda());
522 
        franchiseeVisit.setPartnerRemark(createFranchiseeRequest.getPartnerRemark());
523 
        franchiseeVisit.setOutsideVisibity(createFranchiseeRequest.getOutsideVisibity());
524 
        franchiseeVisit.setInstoreVisibility(createFranchiseeRequest.getInstoreVisibility());
525 
        franchiseeVisit.setOutsideStock(createFranchiseeRequest.getOutsideStock());
526 
        franchiseeVisit.setSystemKnowledge(createFranchiseeRequest.getSystemKnowledge());
527 
        franchiseeVisit.setWorkingDevice(createFranchiseeRequest.getWorkingDevice());
528 
        franchiseeVisit.setWorkingPrinter(createFranchiseeRequest.getWorkingPrinter());
529 
        franchiseeVisit.setCarryBags(createFranchiseeRequest.getCarryBags());
530 
        franchiseeVisit.setSmartdukaanTshirt(createFranchiseeRequest.getSmartdukaanTshirt());
531 
        franchiseeVisit.setLatestDummies(createFranchiseeRequest.getLatestDummies());
532 
        franchiseeVisit.setInvestment(createFranchiseeRequest.getInvestment());
533 
        franchiseeVisit.setMtd(createFranchiseeRequest.getMtd());
534 
        franchiseeVisit.setHygiene(createFranchiseeRequest.getHygiene());
535 
        franchiseeVisit.setCreatedTimestamp(LocalDateTime.now());
536 
        franchiseeVisit.setUpdatedTimestamp(LocalDateTime.now());
537 
        franchiseeVisit.setInformedAboutOnline(createFranchiseeRequest.getOnline());
538 
        franchiseeVisit.setPendingBilling(createFranchiseeRequest.getPendingBilling());
539 
        if (createFranchiseeRequest.getAction().equals(FranchiseeActivityStatus.FOLLOWUP)) {
540 
            franchiseeVisit.setStatus(FranchiseeVisitStatus.OPEN);
541 
        } else {
542 
            franchiseeVisit.setStatus(FranchiseeVisitStatus.CLOSE);
543 
        }
25952 tejbeer 544 
 
31677 amit.gupta 545 
        // AuthUser authUser =
546 
        // authRepository.selectByGmailId(createFranchiseeRequest.getCreatedBy());
547 
        // change
548 
        AuthUser authUser = authRepository.selectByGmailId(createFranchiseeRequest.getCreatedBy());
25952 tejbeer 549 
 
31677 amit.gupta 550 
        String authUserName = authUser.getFirstName() + " " + authUser.getLastName();
551 
        franchiseeVisit.setCreatedBy(authUserName);
552 
        franchiseeVisit.setAuthId(authUser.getId());
25952 tejbeer 553 
 
31677 amit.gupta 554 
        franchiseeVisitRepository.persist(franchiseeVisit);
25952 tejbeer 555 
 
31677 amit.gupta 556 
        FranchiseeActivity franchiseeActivity = new FranchiseeActivity();
557 
        franchiseeActivity.setAction(createFranchiseeRequest.getAction());
558 
        franchiseeActivity.setFranchiseeVisitd(franchiseeVisit.getId());
559 
        franchiseeActivity.setResolution(createFranchiseeRequest.getResolution());
560 
        if (createFranchiseeRequest.getAction().equals(FranchiseeActivityStatus.FOLLOWUP)) {
561 
            franchiseeActivity.setSchelduleTimestamp(createFranchiseeRequest.getSchelduleTimestamp());
31249 tejbeer 562 
 
31677 amit.gupta 563 
            visitRequestRepository.createVisitRequest(franchiseeVisit.getId(), "franchiseeVisit",
564 
                    franchiseeVisit.getAuthId(), createFranchiseeRequest.getSchelduleTimestamp());
565 
        } else {
566 
            franchiseeActivity.setSchelduleTimestamp(null);
567 
        }
568 
        franchiseeActivity.setCreatedTimestamp(LocalDateTime.now());
569 
        franchiseeActivityRepository.persist(franchiseeActivity);
25952 tejbeer 570 
 
31677 amit.gupta 571 
        franchiseeVisit.setFranchiseActivityId(franchiseeActivity.getId());
572 
        return responseSender.ok(true);
573 
    }
25952 tejbeer 574 
 
31677 amit.gupta 575 
    @RequestMapping(value = "/getFranchiseVisit", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
576 
    @ApiImplicitParams({
577 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
578 
    public ResponseEntity<?> getFranchiseVisit(HttpServletRequest request,
579 
                                               @RequestParam(name = "gmailId") String gmailId, @RequestParam(name = "status") FranchiseeVisitStatus status,
580 
                                               @RequestParam(name = "offset", defaultValue = "0") int offset,
581 
                                               @RequestParam(name = "limit", defaultValue = "10") int limit) throws ProfitMandiBusinessException {
582 
        AuthUser authUser = authRepository.selectByGmailId(gmailId);
583 
        List<VisitRequest> visitRequests = visitRequestRepository.selectByAuthIdAndDate(authUser.getId(),
584 
                LocalDate.now());
585 
        Map<Integer, List<VisitRequest>> visitRequestMap = null;
586 
        if (!visitRequests.isEmpty()) {
587 
            visitRequestMap = visitRequests.stream().collect(Collectors.groupingBy(x -> x.getVisitId()));
588 
        }
589 
        List<FranchiseeVisit> franchiseeVisits = franchiseeVisitRepository.selectByAuthIdAndStatus(authUser.getId(),
590 
                status, offset, limit);
25952 tejbeer 591 
 
31677 amit.gupta 592 
        for (FranchiseeVisit fv : franchiseeVisits) {
593 
            if (visitRequestMap != null) {
31249 tejbeer 594 
 
31677 amit.gupta 595 
                List<VisitRequest> visitRequest = visitRequestMap.get(fv.getId());
596 
                if (visitRequest != null) {
597 
                    if (visitRequest.size() > 1) {
31249 tejbeer 598 
 
31677 amit.gupta 599 
                        Comparator<VisitRequest> visitComparato = Comparator
600 
                                .comparing(VisitRequest::getCreatedTimestamp);
31249 tejbeer 601 
 
31677 amit.gupta 602 
                        VisitRequest youngestVisit = visitRequest.stream().max(visitComparato).get();
603 
                        fv.setVisitStatus(youngestVisit.getStatus());
31249 tejbeer 604 
 
31677 amit.gupta 605 
                    } else {
606 
                        fv.setVisitStatus(visitRequest.get(0).getStatus());
31249 tejbeer 607 
 
31677 amit.gupta 608 
                    }
609 
                }
610 
            }
611 
            if (fv.getFranchiseActivityId() != 0) {
612 
                FranchiseeActivity fA = franchiseeActivityRepository.selectById(fv.getFranchiseActivityId());
613 
                fv.setFranchiseeActivity(fA);
614 
            }
31249 tejbeer 615 
 
31677 amit.gupta 616 
        }
25952 tejbeer 617 
 
31677 amit.gupta 618 
        return responseSender.ok(franchiseeVisits);
25952 tejbeer 619 
 
31677 amit.gupta 620 
    }
25952 tejbeer 621 
 
31677 amit.gupta 622 
    @RequestMapping(value = "/getFranchiseActivity", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
623 
    @ApiImplicitParams({
624 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
625 
    public ResponseEntity<?> getFranchiseActivity(HttpServletRequest request, @RequestParam(name = "id") int id)
626 
            throws ProfitMandiBusinessException {
25952 tejbeer 627 
 
31677 amit.gupta 628 
        List<FranchiseeActivity> franchiseeActivities = franchiseeActivityRepository.selectByFranchiseeVisitId(id);
629 
        return responseSender.ok(franchiseeActivities);
25952 tejbeer 630 
 
31677 amit.gupta 631 
    }
25952 tejbeer 632 
 
31677 amit.gupta 633 
    @RequestMapping(value = "/getFranchiseeInfo", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
634 
    @ApiImplicitParams({
635 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
636 
    public ResponseEntity<?> getFranchiseeInfo(HttpServletRequest request, @RequestParam(name = "id") int id)
637 
            throws ProfitMandiBusinessException {
638 
        FranchiseeVisit franchiseeVisit = franchiseeVisitRepository.selectById(id);
25952 tejbeer 639 
 
31677 amit.gupta 640 
        List<DBObject> mobileBrands = mongoClient.getAllBrandsToDisplay(3);
30487 tejbeer 641 
 
31677 amit.gupta 642 
        List<String> brands = mobileBrands.stream().filter(x -> (boolean) x.get("active"))
643 
                .map(x -> (String) x.get("name")).collect(Collectors.toList());
30487 tejbeer 644 
 
31677 amit.gupta 645 
        franchiseeVisit.setBrands(brands);
30487 tejbeer 646 
 
31677 amit.gupta 647 
        return responseSender.ok(franchiseeVisit);
25952 tejbeer 648 
 
31677 amit.gupta 649 
    }
25952 tejbeer 650 
 
31677 amit.gupta 651 
    @RequestMapping(value = "/franchise-visit-update", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
652 
    @ApiImplicitParams({
653 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
654 
    public ResponseEntity<?> franchiseVisitUpdate(HttpServletRequest request, @RequestParam(name = "id") int id,
655 
                                                  @RequestParam(name = "action") FranchiseeActivityStatus action,
656 
                                                  @RequestParam(name = "resolution") String resolution,
657 
                                                  @RequestParam(name = "schelduleTimestamp") @DateTimeFormat(iso = DateTimeFormat.ISO.DATE_TIME) LocalDateTime schelduleTimestamp)
658 
            throws ProfitMandiBusinessException {
659 
        FranchiseeVisit franchiseeVisit = franchiseeVisitRepository.selectById(id);
25952 tejbeer 660 
 
31677 amit.gupta 661 
        FranchiseeActivity franchiseeActivity = new FranchiseeActivity();
25952 tejbeer 662 
 
31677 amit.gupta 663 
        if (action == FranchiseeActivityStatus.FOLLOWUP) {
30487 tejbeer 664 
 
31677 amit.gupta 665 
            if (schelduleTimestamp != null) {
31249 tejbeer 666 
 
31677 amit.gupta 667 
                visitRequestRepository.createVisitRequest(franchiseeVisit.getId(), "franchiseeVisit",
668 
                        franchiseeVisit.getAuthId(), schelduleTimestamp);
669 
            }
31249 tejbeer 670 
 
31677 amit.gupta 671 
            franchiseeActivity.setSchelduleTimestamp(schelduleTimestamp);
672 
            franchiseeVisit.setStatus(FranchiseeVisitStatus.OPEN);
673 
            franchiseeVisit.setUpdatedTimestamp(LocalDateTime.now());
674 
            franchiseeVisitRepository.persist(franchiseeVisit);
25952 tejbeer 675 
 
31677 amit.gupta 676 
        } else {
30487 tejbeer 677 
 
31677 amit.gupta 678 
            franchiseeActivity.setSchelduleTimestamp(null);
679 
            franchiseeVisit.setFranchiseActivityId(franchiseeActivity.getId());
680 
            franchiseeVisit.setStatus(FranchiseeVisitStatus.CLOSE);
681 
            franchiseeVisit.setUpdatedTimestamp(LocalDateTime.now());
682 
            franchiseeVisitRepository.persist(franchiseeVisit);
25952 tejbeer 683 
 
31677 amit.gupta 684 
        }
25952 tejbeer 685 
 
31677 amit.gupta 686 
        franchiseeActivity.setResolution(resolution);
687 
        franchiseeActivity.setFranchiseeVisitd(franchiseeVisit.getId());
688 
        franchiseeActivity.setAction(action);
30487 tejbeer 689 
 
31677 amit.gupta 690 
        franchiseeActivity.setCreatedTimestamp(LocalDateTime.now());
691 
        franchiseeActivityRepository.persist(franchiseeActivity);
30487 tejbeer 692 
 
31677 amit.gupta 693 
        franchiseeVisit.setFranchiseActivityId(franchiseeActivity.getId());
694 
        franchiseeVisit.setStatus(FranchiseeVisitStatus.OPEN);
695 
        franchiseeVisit.setUpdatedTimestamp(LocalDateTime.now());
696 
        franchiseeVisitRepository.persist(franchiseeVisit);
30487 tejbeer 697 
 
31677 amit.gupta 698 
        return responseSender.ok(true);
25952 tejbeer 699 
 
31677 amit.gupta 700 
    }
28935 tejbeer 701 
 
31677 amit.gupta 702 
    @RequestMapping(value = "/onBoardingTimelineStatus", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
703 
    @ApiImplicitParams({
704 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
705 
    public ResponseEntity<?> onBoardingTimelineStatus(HttpServletRequest request, Model model)
706 
            throws ProfitMandiBusinessException {
707 
        int userId = (int) request.getAttribute("userId");
708 
        UserCart uc = userAccountRepository.getUserCart(userId);
709 
        FofoStore fs = fofoStoreRepository.selectByRetailerId(uc.getUserId());
710 
        PartnerOnBoardingPanel partnerOnBoardingPanel = partnerOnBoardingPanelRepository.selectByCode(fs.getCode());
711 
        Map<StoreTimeline, OnBoardingTimelineModel> timelineStatus = null;
712 
        LOGGER.info("partnerOnBoardingPanel" + partnerOnBoardingPanel);
713 
        if (partnerOnBoardingPanel != null) {
28935 tejbeer 714 
 
31677 amit.gupta 715 
            timelineStatus = storeTimelineTatService.getTimeline(partnerOnBoardingPanel.getId());
716 
        }
717 
        List<OnBoardingTimelineModel> onBoardingModel = new ArrayList<>();
718 
        if (timelineStatus != null) {
719 
            onBoardingModel = timelineStatus.values().stream().skip(2).map(x -> x).collect(Collectors.toList());
720 
        }
721 
        return responseSender.ok(onBoardingModel);
28935 tejbeer 722 
 
31677 amit.gupta 723 
    }
28982 tejbeer 724 
 
31677 amit.gupta 725 
    @RequestMapping(value = "/onBoardingTimelineVisibility", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
726 
    @ApiImplicitParams({
727 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
728 
    public ResponseEntity<?> onBoardingTimelineVisibility(HttpServletRequest request, Model model)
729 
            throws ProfitMandiBusinessException {
730 
        int userId = (int) request.getAttribute("userId");
731 
        UserCart uc = userAccountRepository.getUserCart(userId);
28982 tejbeer 732 
 
31677 amit.gupta 733 
        FofoStore fs = fofoStoreRepository.selectByRetailerId(uc.getUserId());
734 
        PartnerOnBoardingPanel partnerOnBoardingPanel = partnerOnBoardingPanelRepository.selectByCode(fs.getCode());
735 
        boolean status = true;
736 
        if (partnerOnBoardingPanel != null) {
28982 tejbeer 737 
 
31677 amit.gupta 738 
            status = storeTimelineTatService.getTimelineCompleted(partnerOnBoardingPanel.getId());
739 
        }
28982 tejbeer 740 
 
31677 amit.gupta 741 
        LOGGER.info("status" + status);
28983 tejbeer 742 
 
31677 amit.gupta 743 
        return responseSender.ok(status);
28982 tejbeer 744 
 
31677 amit.gupta 745 
    }
30077 tejbeer 746 
 
31677 amit.gupta 747 
    @RequestMapping(value = "/getPartnerTarget", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
748 
    @ApiImplicitParams({
749 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
750 
    public ResponseEntity<?> getPartnerTarget(HttpServletRequest request,
751 
                                              @RequestParam String gmailId, @RequestParam String dayValue, @RequestParam ActivationType activationType)
752 
            throws ProfitMandiBusinessException {
30077 tejbeer 753 
 
31677 amit.gupta 754 
        AuthUser authUser = authRepository.selectByGmailId(gmailId);
755 
        Map<String, Set<Integer>> storeGuyMap = csService.getAuthUserPartnerIdMapping();
756 
        Set<Integer> fofoIds = storeGuyMap.get(authUser.getEmailId());
757 
        List<String> brands = Arrays.asList("Vivo", "Samsung", "Oppo", "Itel", "Almost New", "Others");
30078 tejbeer 758 
 
31677 amit.gupta 759 
        float totalPartnerTargetSecondary = 0;
760 
        float totalPartnerTargetCollection = 0;
761 
        float totalPartnerAchievementSecondary = 0;
762 
        float totalPartnerAchievementCollection = 0;
763 
        TargetModel tm = new TargetModel();
764 
        Map<Integer, PartnerDailyInvestment> partnerDailyInvestmentMap = new HashMap<>();
765 
        Map<Integer, Long> partnerTicketCount = ticketRepository.selectAllOpenTicketsGroupByRetailer();
30416 tejbeer 766 
 
31677 amit.gupta 767 
        LOGGER.info("partnerTicketCount {}", partnerTicketCount);
30416 tejbeer 768 
 
31677 amit.gupta 769 
        List<PartnerTargetAchievementModel> ptams = new ArrayList<>();
30077 tejbeer 770 
 
31677 amit.gupta 771 
        if (fofoIds != null && fofoIds.size() > 0) {
31728 amit.gupta 772 
            LOGGER.info("fofoIds {}", fofoIds );
31727 amit.gupta 773 
            List<Integer> fofoIdList = fofoStoreRepository.selectByRetailerIds(new ArrayList<>(fofoIds)).stream()
31677 amit.gupta 774 
                    .filter(x -> (!x.isInternal() && (activationType == null || x.getActivationType().equals(activationType))))
775 
                    .map(x -> x.getId()).collect(Collectors.toList());
31728 amit.gupta 776 
            LOGGER.info("fofoIdList {}", fofoIdList );
31677 amit.gupta 777 
            LocalDateTime startDate = LocalDate.now().atStartOfDay();
30077 tejbeer 778 
 
31677 amit.gupta 779 
            if (dayValue.equals("previous")) {
780 
                startDate = LocalDate.now().minusDays(1).atStartOfDay();
30138 tejbeer 781 
 
31677 amit.gupta 782 
            }
30087 tejbeer 783 
 
31686 amit.gupta 784 
            if (fofoIdList.size() > 0) {
30453 tejbeer 785 
 
31686 amit.gupta 786 
                List<PartnerDailyInvestment> partnerDailyInvestments = partnerDailyInvestmentRepository
787 
                        .selectAll(fofoIdList, startDate.toLocalDate().minusDays(1));
30087 tejbeer 788 
 
31686 amit.gupta 789 
                if (!partnerDailyInvestments.isEmpty()) {
790 
                    partnerDailyInvestmentMap = partnerDailyInvestments.stream()
791 
                            .collect(Collectors.toMap(x -> x.getFofoId(), x -> x));
792 
                }
30077 tejbeer 793 
 
31686 amit.gupta 794 
                Map<Integer, CustomRetailer> customRetailerMap = retailerService.getAllFofoRetailers();
30426 tejbeer 795 
 
31686 amit.gupta 796 
                Map<Integer, CustomRetailer> customRetailers = fofoIdList.stream().map(x -> customRetailerMap.get(x))
797 
                        .filter(x -> x != null).collect(Collectors.toList()).stream()
798 
                        .collect(Collectors.toMap(x -> x.getPartnerId(), x -> x));
30330 tejbeer 799 
 
31686 amit.gupta 800 
                List<Integer> remarkIds = partnerCollectionRemarkRepository.selectMaxRemarkId(fofoIdList);
30453 tejbeer 801 
 
31686 amit.gupta 802 
                LOGGER.info("remarkIds {}", remarkIds);
30453 tejbeer 803 
 
31686 amit.gupta 804 
                long todayCollectionCount = 0;
805 
                if (!remarkIds.isEmpty()) {
806 
                    todayCollectionCount = partnerCollectionRemarkRepository
807 
                            .selectByAuthIdAndIds(authUser.getId(), remarkIds).stream()
808 
                            .filter(x -> x.getCreateTimestamp().toLocalDate().equals(LocalDate.now()))
809 
                            .collect(Collectors.counting());
30453 tejbeer 810 
 
31686 amit.gupta 811 
                }
30330 tejbeer 812 
 
31686 amit.gupta 813 
                Map<Integer, PartnerCollectionPlanModel> CollectionMap = partnerCollectionService
814 
                        .getCollectionMap(fofoIdList, startDate);
30077 tejbeer 815 
 
31686 amit.gupta 816 
                Map<Integer, List<PartnerSecondaryPlanModel>> partnerSecondayPlans = orderRepository
817 
                        .selectPartnerSecondaryGroupByBrand(fofoIdList, startDate.toLocalDate()).stream()
818 
                        .collect(Collectors.groupingBy(x -> x.getFofoId()));
30077 tejbeer 819 
 
31686 amit.gupta 820 
                LOGGER.info("partnerSecondayPlans {}", partnerSecondayPlans);
821 
                for (Entry<Integer, CustomRetailer> customRetailerEntry : customRetailers.entrySet()) {
822 
                    int fofoId = customRetailerEntry.getKey();
823 
                    CustomRetailer customRetailer = customRetailerEntry.getValue();
824 
                    float totalSecondaryPlan = 0;
825 
                    float totalSecondaryAchivement = 0;
30077 tejbeer 826 
 
31686 amit.gupta 827 
                    PartnerTargetAchievementModel ptam = new PartnerTargetAchievementModel();
828 
                    ptam.setFofoId(fofoId);
829 
                    ptam.setBusinessName(customRetailer.getBusinessName());
830 
                    ptam.setMobile(customRetailer.getMobileNumber());
30087 tejbeer 831 
 
31686 amit.gupta 832 
                    if (partnerDailyInvestmentMap.get(fofoId) != null) {
833 
                        ptam.setWalletAmount(partnerDailyInvestmentMap.get(fofoId).getWalletAmount());
834 
                        ptam.setShortInvestment(partnerDailyInvestmentMap.get(fofoId).getShortInvestment());
835 
                    }
30808 tejbeer 836 
 
31686 amit.gupta 837 
                    if (CollectionMap.get(fofoId) != null) {
838 
                        PartnerCollectionPlanModel collectionPlan = CollectionMap.get(fofoId);
30330 tejbeer 839 
 
31686 amit.gupta 840 
                        ptam.setRemark(collectionPlan.getRemark());
841 
                        ptam.setMessage(collectionPlan.getMessage());
842 
                        ptam.setRemarkTimestamp(collectionPlan.getRemarkTimestamp());
843 
                        ptam.setRank(collectionPlan.getRank());
844 
                        Integer authId = collectionPlan.getAuthId();
30330 tejbeer 845 
 
31686 amit.gupta 846 
                        Map<Integer, String> rankColorMap = ProfitMandiConstants.Rank_Color_Map;
30416 tejbeer 847 
 
31686 amit.gupta 848 
                        ptam.setCollectionColor(rankColorMap.get(collectionPlan.getRank()));
30077 tejbeer 849 
 
31686 amit.gupta 850 
                        LOGGER.info("authId" + authId);
30137 tejbeer 851 
 
31686 amit.gupta 852 
                        if (collectionPlan.getTargetPlan() != null && collectionPlan.getCommittedDate() != null) {
853 
                            float targetCollection = 0;
30330 tejbeer 854 
 
31686 amit.gupta 855 
                            if (collectionPlan.getRank() == 2 && collectionPlan.getAchievementPlan() != null) {
856 
                                targetCollection = collectionPlan.getTargetPlan() - collectionPlan.getAchievementPlan();
857 
                            } else {
858 
                                targetCollection = collectionPlan.getTargetPlan();
31677 amit.gupta 859 
                            }
30451 tejbeer 860 
 
31677 amit.gupta 861 
                            if (authId != null && authId == authUser.getId()) {
30822 tejbeer 862 
 
31686 amit.gupta 863 
                                if (!collectionPlan.getCommittedDate().isAfter(startDate)) {
864 
                                    totalPartnerTargetCollection += targetCollection;
865 
                                }
31677 amit.gupta 866 
                            }
30822 tejbeer 867 
 
31686 amit.gupta 868 
                            ptam.setCollectionTarget(targetCollection);
869 
 
870 
                            if (collectionPlan.getRank() == 2 && collectionPlan.getAchievementPlan() != null
871 
                                    && collectionPlan.getWalletTimestamp() != null
872 
                                    && collectionPlan.getWalletTimestamp().toLocalDate().equals(startDate.toLocalDate())) {
873 
                                if (authId != null && authId == authUser.getId()) {
874 
 
875 
                                    totalPartnerAchievementCollection += collectionPlan.getAchievementPlan();
876 
                                }
877 
                                ptam.setCollectionAchievement(collectionPlan.getAchievementPlan());
878 
                            } else if (collectionPlan.getCommittedDate().toLocalDate().isEqual(startDate.toLocalDate())
879 
                                    && collectionPlan.getAchievementPlan() != null) {
880 
                                if (authId != null && authId == authUser.getId()) {
881 
 
882 
                                    totalPartnerAchievementCollection += collectionPlan.getAchievementPlan();
883 
                                }
884 
                                ptam.setCollectionAchievement(collectionPlan.getAchievementPlan());
885 
 
31677 amit.gupta 886 
                            }
31686 amit.gupta 887 
                        }
30822 tejbeer 888 
 
31686 amit.gupta 889 
                        if (authId != null && authId != authUser.getId()) {
890 
                            ptam.setAuthUser(authRepository.selectById(authId));
891 
 
31677 amit.gupta 892 
                        }
30087 tejbeer 893 
 
31686 amit.gupta 894 
                        if (collectionPlan.getCommittedDate() != null) {
30087 tejbeer 895 
 
31686 amit.gupta 896 
                            ptam.setCollectionCommitmentDate(collectionPlan.getCommittedDate().toLocalDate());
897 
                        }
30087 tejbeer 898 
 
31677 amit.gupta 899 
                    }
30821 tejbeer 900 
 
31686 amit.gupta 901 
                    // Secondary
30077 tejbeer 902 
 
31686 amit.gupta 903 
                    PartnerSecondaryPlanModel otherPartnerSecondaryPlanModel = null;
904 
                    Map<String, PartnerSecondaryPlanModel> secondaryModelMap = new HashMap<>();
905 
                    if (partnerSecondayPlans.get(fofoId) != null) {
906 
                        long otherBrandSecondary = 0;
907 
                        for (PartnerSecondaryPlanModel pspm : partnerSecondayPlans.get(fofoId)) {
908 
                            Integer authId = pspm.getAuthId();
909 
                            if (!brands.contains(pspm.getBrand())) {
910 
                                if (pspm.getAchievementPlan() != null) {
911 
                                    otherBrandSecondary += pspm.getAchievementPlan();
912 
                                }
913 
                            } else {
914 
                                otherPartnerSecondaryPlanModel = pspm;
915 
                            }
916 
                            if (pspm.getTargetPlan() != null) {
917 
                                totalSecondaryPlan += pspm.getTargetPlan();
918 
                            }
30330 tejbeer 919 
 
31677 amit.gupta 920 
                            if (pspm.getAchievementPlan() != null) {
31686 amit.gupta 921 
                                totalSecondaryAchivement += pspm.getAchievementPlan();
31677 amit.gupta 922 
                            }
30087 tejbeer 923 
 
31686 amit.gupta 924 
                            if (pspm.getCommittedDate() != null) {
30137 tejbeer 925 
 
31686 amit.gupta 926 
                                ptam.setSecondaryCommitmentDate(pspm.getCommittedDate().toLocalDate());
927 
                            }
928 
                            if (authId != null && authId == authUser.getId()) {
30137 tejbeer 929 
 
31686 amit.gupta 930 
                                if (pspm.getTargetPlan() != null && pspm.getCommittedDate() != null) {
30087 tejbeer 931 
 
31686 amit.gupta 932 
                                    if (pspm.getCommittedDate().isEqual(startDate)) {
933 
                                        totalPartnerTargetSecondary += pspm.getTargetPlan();
934 
                                    }
935 
                                }
30087 tejbeer 936 
 
31686 amit.gupta 937 
                                if (pspm.getAchievementPlan() != null) {
938 
                                    totalPartnerAchievementSecondary += pspm.getAchievementPlan();
31677 amit.gupta 939 
                                }
31686 amit.gupta 940 
 
31677 amit.gupta 941 
                            }
31686 amit.gupta 942 
                        }
943 
                        if (otherPartnerSecondaryPlanModel != null) {
944 
                            otherPartnerSecondaryPlanModel.setAchievementPlan(otherBrandSecondary);
945 
                        }
946 
                        secondaryModelMap = partnerSecondayPlans.get(fofoId).stream()
947 
                                .filter(x -> brands.contains(x.getBrand()))
948 
                                .collect(Collectors.toMap(x -> x.getBrand(), x -> x));
30087 tejbeer 949 
 
31686 amit.gupta 950 
                        if (secondaryModelMap.containsKey("Others")) {
951 
                            PartnerSecondaryPlanModel psp = secondaryModelMap.get("Others");
952 
                            psp.setAchievementPlan(otherBrandSecondary);
953 
                        } else {
954 
                            secondaryModelMap.put("Others", new PartnerSecondaryPlanModel(fofoId, "Others", (long) 0,
955 
                                    otherBrandSecondary, authUser.getId(), null));
956 
                        }
957 
                        for (String brand : brands) {
958 
                            if (!secondaryModelMap.containsKey(brand)) {
959 
                                secondaryModelMap.put(brand, new PartnerSecondaryPlanModel(fofoId, brand, (long) 0,
960 
                                        (long) 0, authUser.getId(), null));
31677 amit.gupta 961 
                            }
31686 amit.gupta 962 
                        }
30087 tejbeer 963 
 
31686 amit.gupta 964 
                        for (Entry<String, PartnerSecondaryPlanModel> secondaryModelEntry : secondaryModelMap.entrySet()) {
965 
                            Integer authId = secondaryModelEntry.getValue().getAuthId();
966 
                            if (authId != null && authId != authUser.getId()) {
967 
                                secondaryModelEntry.getValue().setAuthUser(authRepository.selectById(authId));
968 
                                ptam.setSecondaryColor("red");
969 
                            }
970 
 
31677 amit.gupta 971 
                        }
30077 tejbeer 972 
 
31686 amit.gupta 973 
                        ptam.setPartnerSecondaryModel(secondaryModelMap);
974 
                        ptam.setTotalSecondaryPlan(totalSecondaryPlan);
975 
                        ptam.setTotalSecondaryAchievement(totalSecondaryAchivement);
976 
                        // Secondary
977 
 
31677 amit.gupta 978 
                    } else {
31686 amit.gupta 979 
                        for (String brand : brands) {
980 
                            PartnerSecondaryPlanModel pspm = new PartnerSecondaryPlanModel();
981 
                            pspm.setAchievementPlan((long) 0);
982 
                            pspm.setTargetPlan((long) 0);
983 
                            pspm.setBrand(brand);
984 
                            pspm.setFofoId(fofoId);
985 
                            secondaryModelMap.put(brand, pspm);
31677 amit.gupta 986 
                        }
31686 amit.gupta 987 
                        ptam.setPartnerSecondaryModel(secondaryModelMap);
31677 amit.gupta 988 
                    }
30077 tejbeer 989 
 
31686 amit.gupta 990 
                    if (!partnerTicketCount.isEmpty()) {
991 
                        if (partnerTicketCount.get(fofoId) != null) {
992 
                            ptam.setTicketCount(partnerTicketCount.get(fofoId));
993 
                        } else {
994 
                            ptam.setTicketCount(0);
995 
 
31677 amit.gupta 996 
                        }
997 
                    }
30087 tejbeer 998 
 
31686 amit.gupta 999 
                    ptams.add(ptam);
30077 tejbeer 1000 
 
31677 amit.gupta 1001 
                }
30077 tejbeer 1002 
 
31686 amit.gupta 1003 
                tm.setTotalPartnerTargetCollection(totalPartnerTargetCollection);
1004 
                tm.setTotalPartnerTargetSecondary(totalPartnerTargetSecondary);
1005 
                tm.setTotalPartnerSecondary(totalPartnerAchievementSecondary);
1006 
                tm.setTotalPartnerCollection(totalPartnerAchievementCollection);
1007 
                tm.setTodayCollectionCount((int) todayCollectionCount);
30416 tejbeer 1008 
 
31686 amit.gupta 1009 
                tm.setTargetAchievement(ptams.stream().sorted(Comparator.comparing(PartnerTargetAchievementModel::getRank))
1010 
                        .collect(Collectors.toList()));
30416 tejbeer 1011 
 
31677 amit.gupta 1012 
            }
30077 tejbeer 1013 
 
31677 amit.gupta 1014 
        }
1015 
        return responseSender.ok(tm);
30077 tejbeer 1016 
 
31677 amit.gupta 1017 
    }
32587 ranu 1018 
//TODO:Amit
31677 amit.gupta 1019 
    @RequestMapping(value = "/target", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
1020 
    @ApiImplicitParams({
1021 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
1022 
    public ResponseEntity<?> createPartnerTarget(HttpServletRequest request,
1023 
                                                 @RequestBody PartnerTargetAchievementModel ptam) throws ProfitMandiBusinessException {
30077 tejbeer 1024 
 
31677 amit.gupta 1025 
        LOGGER.info("ptam" + ptam);
30089 tejbeer 1026 
 
31677 amit.gupta 1027 
        AuthUser authUser = authRepository.selectByGmailId(ptam.getCreatedBy());
30077 tejbeer 1028 
 
31677 amit.gupta 1029 
        if (ptam.getCollectionCommitmentDate().isAfter(LocalDate.now())
1030 
                || ptam.getCollectionCommitmentDate().isEqual(LocalDate.now())) {
1031 
            PartnerCollectionPlan partnerCollectionPlan = partnerCollectionPlanRepository
1032 
                    .selectByLocalDate(LocalDate.now(), ptam.getFofoId(), true);
1033 
            LOGGER.info("pcp" + partnerCollectionPlan);
30077 tejbeer 1034 
 
31677 amit.gupta 1035 
            if (partnerCollectionPlan == null) {
1036 
                if (ptam.getCollectionTarget() > 0) {
30087 tejbeer 1037 
 
31677 amit.gupta 1038 
                    partnerCollectionPlan = new PartnerCollectionPlan();
1039 
                    partnerCollectionPlan.setCreateTimestamp(LocalDateTime.now());
1040 
                    partnerCollectionPlan.setAuthId(authUser.getId());
1041 
                    partnerCollectionPlan.setFofoId(ptam.getFofoId());
1042 
                    partnerCollectionPlan.setActive(true);
1043 
                    partnerCollectionPlan.setCollectionPlan(ptam.getCollectionTarget());
1044 
                    partnerCollectionPlan.setUpdatedTimestamp(LocalDateTime.now());
1045 
                    partnerCollectionPlan.setCommitedTimestamp(ptam.getCollectionCommitmentDate().atStartOfDay());
1046 
                    partnerCollectionPlanRepository.persist(partnerCollectionPlan);
30416 tejbeer 1047 
 
31677 amit.gupta 1048 
                }
30087 tejbeer 1049 
 
31677 amit.gupta 1050 
            } else {
30087 tejbeer 1051 
 
31677 amit.gupta 1052 
                if (partnerCollectionPlan.getCollectionPlan() != ptam.getCollectionTarget()) {
1053 
                    float totalCollectionPlan = partnerCollectionPlan.getCollectionPlan() + 10000;
1054 
                    if (authUser.getId() == partnerCollectionPlan.getAuthId()) {
30087 tejbeer 1055 
 
31677 amit.gupta 1056 
                        if (authUser.getEmailId().equals("tarun.verma@smartdukaan.com")
1057 
                                || authUser.getEmailId().equals("rakesh.sonawane@smartdukaan.com")
1058 
                                || ptam.getCollectionTarget() >= totalCollectionPlan) {
1059 
                            partnerCollectionPlan.setCollectionPlan(ptam.getCollectionTarget());
1060 
                            partnerCollectionPlan.setActive(true);
1061 
                            partnerCollectionPlan
1062 
                                    .setCommitedTimestamp(ptam.getCollectionCommitmentDate().atStartOfDay());
1063 
                            partnerCollectionPlan.setUpdatedTimestamp(LocalDateTime.now());
1064 
                        } else {
1065 
                            throw new ProfitMandiBusinessException("collection target", "",
1066 
                                    "collection target should be more than " + totalCollectionPlan);
1067 
                        }
30087 tejbeer 1068 
 
31677 amit.gupta 1069 
                    } else {
30137 tejbeer 1070 
 
31677 amit.gupta 1071 
                        if (authUser.getEmailId().equals("tarun.verma@smartdukaan.com")
1072 
                                || authUser.getEmailId().equals("rakesh.sonawane@smartdukaan.com")
1073 
                                || ptam.getCollectionTarget() >= totalCollectionPlan) {
30137 tejbeer 1074 
 
31677 amit.gupta 1075 
                            partnerCollectionPlan.setActive(false);
1076 
                            partnerCollectionPlan.setUpdatedTimestamp(LocalDateTime.now());
1077 
                            partnerCollectionPlan = new PartnerCollectionPlan();
1078 
                            partnerCollectionPlan.setCreateTimestamp(LocalDateTime.now());
1079 
                            partnerCollectionPlan.setAuthId(authUser.getId());
1080 
                            partnerCollectionPlan.setFofoId(ptam.getFofoId());
1081 
                            partnerCollectionPlan.setActive(true);
1082 
                            partnerCollectionPlan
1083 
                                    .setCommitedTimestamp(ptam.getSecondaryCommitmentDate().atStartOfDay());
1084 
                            partnerCollectionPlan.setCollectionPlan(ptam.getCollectionTarget());
1085 
                            partnerCollectionPlan.setUpdatedTimestamp(LocalDateTime.now());
1086 
                            partnerCollectionPlanRepository.persist(partnerCollectionPlan);
1087 
                        } else {
1088 
                            throw new ProfitMandiBusinessException("collection target", "",
1089 
                                    "collection target should be more than " + totalCollectionPlan);
1090 
                        }
1091 
                    }
1092 
                }
30137 tejbeer 1093 
 
31677 amit.gupta 1094 
                if ((LocalDate.now().atStartOfDay().equals(ptam.getCollectionCommitmentDate().atStartOfDay())
1095 
                        || ptam.getCollectionCommitmentDate().atStartOfDay().isAfter(LocalDate.now().atStartOfDay()))
1096 
                        && partnerCollectionPlan.getCollectionPlan() == ptam.getCollectionTarget()) {
1097 
                    partnerCollectionPlan.setCommitedTimestamp(ptam.getCollectionCommitmentDate().atStartOfDay());
1098 
                    partnerCollectionPlan.setUpdatedTimestamp(LocalDateTime.now());
1099 
                }
30416 tejbeer 1100 
 
31677 amit.gupta 1101 
            }
30433 tejbeer 1102 
 
31677 amit.gupta 1103 
            PartnerCollectionRemark pcr = new PartnerCollectionRemark();
1104 
            pcr.setFofoId(ptam.getFofoId());
1105 
            pcr.setAuthId(authUser.getId());
1106 
            pcr.setMessage("Collection plan for" + ptam.getCollectionCommitmentDate());
1107 
            pcr.setRemark(CollectionRemark.COLLECTION_PLAN);
1108 
            pcr.setCreateTimestamp(LocalDateTime.now());
1109 
            partnerCollectionRemarkRepository.persist(pcr);
1110 
        } else {
1111 
            throw new ProfitMandiBusinessException("Date", "",
1112 
                    "you can't select the back date " + ptam.getCollectionCommitmentDate());
1113 
        }
30077 tejbeer 1114 
 
31677 amit.gupta 1115 
        for (Entry<String, PartnerSecondaryPlanModel> pspm : ptam.getPartnerSecondaryModel().entrySet()) {
30087 tejbeer 1116 
 
31677 amit.gupta 1117 
            if (ptam.getCollectionCommitmentDate().isAfter(LocalDate.now())
1118 
                    || ptam.getCollectionCommitmentDate().isEqual(LocalDate.now())) {
1119 
                PartnerSecondaryPlanModel plan = pspm.getValue();
1120 
                PartnerSecondaryPlan psp = partnerSecondaryPlanRepository.selectByLocalDateBrand(plan.getBrand(),
1121 
                        LocalDate.now(), ptam.getFofoId(), true);
1122 
                LOGGER.info("psp" + psp);
30087 tejbeer 1123 
 
31677 amit.gupta 1124 
                if (psp == null) {
1125 
                    if (plan.getTargetPlan() != null && plan.getTargetPlan() > 0) {
30087 tejbeer 1126 
 
31677 amit.gupta 1127 
                        psp = new PartnerSecondaryPlan();
1128 
                        psp.setAuthId(authUser.getId());
1129 
                        psp.setBrand(pspm.getKey());
1130 
                        psp.setFofoId(pspm.getValue().getFofoId());
1131 
                        psp.setSecondaryPlan(pspm.getValue().getTargetPlan());
1132 
                        psp.setCreateTimestamp(LocalDateTime.now());
1133 
                        psp.setUpdatedTimestamp(LocalDateTime.now());
1134 
                        psp.setCommitedTimestamp(ptam.getSecondaryCommitmentDate().atStartOfDay());
1135 
                        psp.setActive(true);
1136 
                        partnerSecondaryPlanRepository.persist(psp);
1137 
                    }
30087 tejbeer 1138 
 
31677 amit.gupta 1139 
                } else {
1140 
                    if (plan.getTargetPlan() != psp.getSecondaryPlan()) {
1141 
                        float totalSecondaryPlan = psp.getSecondaryPlan() + 10000;
1142 
                        if (authUser.getId() == plan.getAuthId()) {
1143 
                            if (authUser.getEmailId().equals("tarun.verma@smartdukaan.com")
1144 
                                    || authUser.getEmailId().equals("rakesh.sonawane@smartdukaan.com")
1145 
                                    || plan.getTargetPlan() >= totalSecondaryPlan) {
1146 
                                psp.setSecondaryPlan(pspm.getValue().getTargetPlan());
1147 
                                psp.setCommitedTimestamp(ptam.getSecondaryCommitmentDate().atStartOfDay());
1148 
                                psp.setUpdatedTimestamp(LocalDateTime.now());
1149 
                                psp.setActive(true);
1150 
                            } else {
1151 
                                throw new ProfitMandiBusinessException("secondary target", "",
1152 
                                        "secondary target should be more than " + totalSecondaryPlan);
1153 
                            }
30087 tejbeer 1154 
 
31677 amit.gupta 1155 
                        } else {
30087 tejbeer 1156 
 
31677 amit.gupta 1157 
                            if (authUser.getEmailId().equals("tarun.verma@smartdukaan.com")
1158 
                                    || authUser.getEmailId().equals("rakesh.sonawane@smartdukaan.com")
1159 
                                    || plan.getTargetPlan() >= totalSecondaryPlan) {
30087 tejbeer 1160 
 
31677 amit.gupta 1161 
                                psp.setUpdatedTimestamp(LocalDateTime.now());
1162 
                                psp.setActive(false);
1163 
                                psp = new PartnerSecondaryPlan();
1164 
                                psp.setAuthId(authUser.getId());
1165 
                                psp.setBrand(pspm.getKey());
1166 
                                psp.setFofoId(pspm.getValue().getFofoId());
1167 
                                psp.setSecondaryPlan(pspm.getValue().getTargetPlan());
1168 
                                psp.setCommitedTimestamp(ptam.getSecondaryCommitmentDate().atStartOfDay());
1169 
                                psp.setCreateTimestamp(LocalDateTime.now());
1170 
                                psp.setUpdatedTimestamp(LocalDateTime.now());
1171 
                                psp.setActive(true);
1172 
                                partnerSecondaryPlanRepository.persist(psp);
1173 
                            } else {
1174 
                                throw new ProfitMandiBusinessException("secondary target", "",
1175 
                                        "secondary target should be more than " + totalSecondaryPlan);
1176 
                            }
1177 
                        }
1178 
                    }
30137 tejbeer 1179 
 
31677 amit.gupta 1180 
                    if ((LocalDate.now().atStartOfDay().equals(ptam.getSecondaryCommitmentDate().atStartOfDay())
1181 
                            || ptam.getSecondaryCommitmentDate().atStartOfDay().isAfter(LocalDate.now().atStartOfDay()))
1182 
                            && plan.getTargetPlan() == psp.getSecondaryPlan()) {
1183 
                        psp.setCommitedTimestamp(ptam.getSecondaryCommitmentDate().atStartOfDay());
1184 
                        psp.setUpdatedTimestamp(LocalDateTime.now());
1185 
                    }
30137 tejbeer 1186 
 
31677 amit.gupta 1187 
                }
1188 
            } else {
1189 
                throw new ProfitMandiBusinessException("Date", "",
1190 
                        "you can't select the back date " + ptam.getSecondaryCommitmentDate());
1191 
            }
30137 tejbeer 1192 
 
31677 amit.gupta 1193 
        }
30077 tejbeer 1194 
 
31677 amit.gupta 1195 
        return responseSender.ok(true);
30137 tejbeer 1196 
 
31677 amit.gupta 1197 
    }
30077 tejbeer 1198 
 
31677 amit.gupta 1199 
    @RequestMapping(value = "/viewTickets", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
1200 
    @ApiImplicitParams({
30416 tejbeer 1201 
 
31677 amit.gupta 1202 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
1203 
    public ResponseEntity<?> viewTickets(HttpServletRequest request, @RequestParam int fofoId)
1204 
            throws ProfitMandiBusinessException {
1205 
        List<Ticket> tickets = ticketRepository.selectAllOpenTicketByRetailer(fofoId);
30416 tejbeer 1206 
 
31677 amit.gupta 1207 
        List<TicketViewModel> viewList = new ArrayList<>();
1208 
        for (Ticket ticket : tickets) {
30416 tejbeer 1209 
 
31677 amit.gupta 1210 
            TicketViewModel ticketViewModel = new TicketViewModel();
1211 
            ticketViewModel.setId(ticket.getId());
1212 
            TicketSubCategory ticketSubCategory = ticketSubCategoryRepository.selectById(ticket.getSubCategoryId());
1213 
            TicketCategory ticketCategory = ticketCategoryRepository.selectById(ticketSubCategory.getCategoryId());
30416 tejbeer 1214 
 
31677 amit.gupta 1215 
            ticketViewModel.setCategoryName(ticketCategory.getName());
1216 
            ticketViewModel.setSubCategoryName(ticketSubCategory.getName());
1217 
            ticketViewModel.setCreatedTimestamp(ticket.getCreateTimestamp());
30416 tejbeer 1218 
 
31677 amit.gupta 1219 
            viewList.add(ticketViewModel);
1220 
        }
1221 
        return responseSender.ok(viewList);
30416 tejbeer 1222 
 
31677 amit.gupta 1223 
    }
30416 tejbeer 1224 
 
31677 amit.gupta 1225 
    @RequestMapping(value = "/viewRecentTickets", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
1226 
    @ApiImplicitParams({
30416 tejbeer 1227 
 
31677 amit.gupta 1228 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
1229 
    public ResponseEntity<?> viewRecentTickets(HttpServletRequest request, @RequestParam int fofoId)
1230 
            throws ProfitMandiBusinessException {
1231 
        List<TicketViewModel> viewList = ticketRepository.selectRecentClosedTicket(fofoId,
1232 
                LocalDateTime.now().minusDays(20));
30416 tejbeer 1233 
 
31677 amit.gupta 1234 
        return responseSender.ok(viewList);
30416 tejbeer 1235 
 
31677 amit.gupta 1236 
    }
30416 tejbeer 1237 
 
31677 amit.gupta 1238 
    @RequestMapping(value = "/createTicket", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
1239 
    @ApiImplicitParams({
30416 tejbeer 1240 
 
31677 amit.gupta 1241 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
1242 
    public ResponseEntity<?> createTicket(HttpServletRequest request) throws ProfitMandiBusinessException {
1243 
        List<TicketCategory> ticketCategories = csService.getAllTicketCategotyFromSubCategory();
30460 tejbeer 1244 
 
31677 amit.gupta 1245 
        return responseSender.ok(ticketCategories);
1246 
    }
30416 tejbeer 1247 
 
31677 amit.gupta 1248 
    @RequestMapping(value = "/getSubCategoriesByCategoryId", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
1249 
    @ApiImplicitParams({
1250 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
30416 tejbeer 1251 
 
31677 amit.gupta 1252 
    public ResponseEntity<?> getSubCategoriesByCategoryId(HttpServletRequest request,
1253 
                                                          @RequestParam(name = "categoryId", defaultValue = "0") int categoryId, Model model) {
1254 
        List<TicketSubCategory> ticketSubCategories = ticketSubCategoryRepository.selectAll(categoryId);
1255 
        LOGGER.info(ticketSubCategories);
1256 
        return responseSender.ok(ticketSubCategories);
1257 
    }
30416 tejbeer 1258 
 
31677 amit.gupta 1259 
    @RequestMapping(value = "/createTicket", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
1260 
    @ApiImplicitParams({
30416 tejbeer 1261 
 
31677 amit.gupta 1262 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
1263 
    public ResponseEntity<?> createTicket(HttpServletRequest request, @RequestParam(name = "categoryId") int categoryId,
1264 
                                          @RequestParam(name = "subCategoryId") int subCategoryId, @RequestParam(name = "message") String message,
1265 
                                          @RequestParam(name = "fofoId") int fofoId) throws Exception {
30460 tejbeer 1266 
 
31677 amit.gupta 1267 
        int id = (int) request.getAttribute("userId");
30460 tejbeer 1268 
 
31677 amit.gupta 1269 
        LOGGER.info("id" + id);
30460 tejbeer 1270 
 
31677 amit.gupta 1271 
        User user = userRepository.selectById(id);
30460 tejbeer 1272 
 
31677 amit.gupta 1273 
        AuthUser authUser = authRepository.selectByEmailOrMobile(user.getEmailId());
30460 tejbeer 1274 
 
31677 amit.gupta 1275 
        List<Ticket> tickets = ticketRepository.selectAllResolvedMarkedTicketByCreator(fofoId);
1276 
        if (tickets.size() > 3 || tickets.size() == 3) {
1277 
            return responseSender.ok(false);
1278 
        } else {
1279 
            csService.createTicket(fofoId, categoryId, subCategoryId, message);
30416 tejbeer 1280 
 
31677 amit.gupta 1281 
            PartnerCollectionRemark pcr = new PartnerCollectionRemark();
1282 
            pcr.setFofoId(fofoId);
1283 
            pcr.setAuthId(authUser.getId());
1284 
            pcr.setMessage("Ticket Created");
1285 
            pcr.setRemark(CollectionRemark.TICKET_CREATED);
1286 
            pcr.setCreateTimestamp(LocalDateTime.now());
1287 
            partnerCollectionRemarkRepository.persist(pcr);
30460 tejbeer 1288 
 
31677 amit.gupta 1289 
        }
1290 
        return responseSender.ok(true);
1291 
    }
30416 tejbeer 1292 
 
31677 amit.gupta 1293 
    @RequestMapping(value = "/getCollectionRemark", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
1294 
    @ApiImplicitParams({
30416 tejbeer 1295 
 
31677 amit.gupta 1296 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
1297 
    public ResponseEntity<?> getCollectionRemark(HttpServletRequest request) throws ProfitMandiBusinessException {
1298 
        List<CollectionRemark> remarks = Arrays.asList(CollectionRemark.values()).stream()
1299 
                .filter(x -> !x.equals(CollectionRemark.COLLECTION_PLAN)).collect(Collectors.toList());
1300 
        return responseSender.ok(remarks);
1301 
    }
30416 tejbeer 1302 
 
32701 amit.gupta 1303 
    @Autowired
1304 
    RestClient restClient;
1305 
 
1306 
    @RequestMapping(value = "/click2call/{fofoId}", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
1307 
    public ResponseEntity<?> createPartnerCollectionRemark(HttpServletRequest request, @PathVariable int fofoId) throws Exception {
1308 
        int id = (int) request.getAttribute("userId");
1309 
        User user = userRepository.selectById(id);
1310 
        AuthUser authUser = authRepository.selectByEmailOrMobile(user.getEmailId());
1311 
        String fromMobile = authUser.getMobileNumber();
1312 
 
1313 
        com.spice.profitmandi.dao.entity.user.User fofoUser = userUserRepository.selectById(fofoId);
32702 amit.gupta 1314 
        String toMobile = retailerService.getAllFofoRetailers().get(fofoId).getMobileNumber();
32701 amit.gupta 1315 
 
1316 
        String url = String.format("https://ccs1.smartpingcc.io/v2/clickToCall/para?&user_id=71287091&token=InCfClzwFUtLUW610faI&from=%s&to=%s", fromMobile, toMobile);
1317 
        restClient.get(url, null, null);
1318 
 
1319 
        return responseSender.ok(true);
1320 
    }
1321 
 
31677 amit.gupta 1322 
    @RequestMapping(value = "/createPartnerColectionRemark", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
1323 
    @ApiImplicitParams({
30416 tejbeer 1324 
 
31677 amit.gupta 1325 
            @ApiImplicitParam(name = "Auth-Token", value = "Auth-Token", required = true, dataType = "string", paramType = "header")})
32587 ranu 1326 
    public ResponseEntity<?> createPartnerCollectionRemark(HttpServletRequest request,
31677 amit.gupta 1327 
                                                          @RequestBody PartnerCollectionRemarkModel partnerCollectionRemarkModel)
1328 
            throws ProfitMandiBusinessException {
1329 
        AuthUser authUser = authRepository.selectByGmailId(partnerCollectionRemarkModel.getGmailId());
30416 tejbeer 1330 
 
31677 amit.gupta 1331 
        PartnerCollectionRemark pcr = new PartnerCollectionRemark();
1332 
        pcr.setFofoId(partnerCollectionRemarkModel.getFofoId());
1333 
        pcr.setAuthId(authUser.getId());
1334 
        pcr.setMessage(partnerCollectionRemarkModel.getMessage());
1335 
        pcr.setRemark(partnerCollectionRemarkModel.getRemark());
1336 
        pcr.setCreateTimestamp(LocalDateTime.now());
1337 
        partnerCollectionRemarkRepository.persist(pcr);
1338 
        return responseSender.ok(true);
30416 tejbeer 1339 
 
31677 amit.gupta 1340 
    }
30433 tejbeer 1341 
 
31677 amit.gupta 1342 
    @RequestMapping(value = "/uploadFranchiseeVisit", method = RequestMethod.POST)
1343 
    public ResponseEntity<?> readCsvFileAndSetLead(HttpServletRequest request, @RequestPart MultipartFile multipartFile)
1344 
            throws Throwable {
30433 tejbeer 1345 
 
31677 amit.gupta 1346 
        int id = (int) request.getAttribute("userId");
30433 tejbeer 1347 
 
31677 amit.gupta 1348 
        LOGGER.info("id" + id);
30433 tejbeer 1349 
 
31677 amit.gupta 1350 
        User user = userRepository.selectById(id);
30433 tejbeer 1351 
 
31677 amit.gupta 1352 
        AuthUser authUser = authRepository.selectByEmailOrMobile(user.getEmailId());
30433 tejbeer 1353 
 
31677 amit.gupta 1354 
        String fileName = multipartFile.getName();
1355 
        String fileNames = multipartFile.getOriginalFilename();
30433 tejbeer 1356 
 
31677 amit.gupta 1357 
        LOGGER.info("fileName" + fileName);
1358 
        LOGGER.info("fileNames" + fileNames);
30433 tejbeer 1359 
 
31677 amit.gupta 1360 
        List<CSVRecord> records = FileUtil.readFile(multipartFile);
30433 tejbeer 1361 
 
31677 amit.gupta 1362 
        for (CSVRecord record : records) {
1363 
            FranchiseeVisit franchiseeVisit = new FranchiseeVisit();
1364 
            franchiseeVisit.setFofoId(Integer.parseInt(record.get(0)));
1365 
            CustomRetailer customRetailer = retailerService.getFofoRetailer(Integer.parseInt(record.get(0)));
30433 tejbeer 1366 
 
31677 amit.gupta 1367 
            franchiseeVisit.setPartnerName(customRetailer.getBusinessName());
1368 
            franchiseeVisit.setAgenda(record.get(1));
1369 
            franchiseeVisit.setCreatedTimestamp(LocalDateTime.now());
1370 
            franchiseeVisit.setUpdatedTimestamp(LocalDateTime.now());
1371 
            franchiseeVisit.setStatus(FranchiseeVisitStatus.OPEN);
30433 tejbeer 1372 
 
31677 amit.gupta 1373 
            DateTimeFormatter formatter = DateTimeFormatter.ofPattern("dd-MM-yyyy");
1374 
            LOGGER.info(record.get(1));
1375 
            LocalDate dateTime = LocalDate.parse(record.get(2), formatter);
30433 tejbeer 1376 
 
31677 amit.gupta 1377 
            franchiseeVisit.setScheduleTimestamp(dateTime.atStartOfDay());
1378 
            // change
30433 tejbeer 1379 
 
31677 amit.gupta 1380 
            String authUserName = authUser.getFirstName() + " " + authUser.getLastName();
1381 
            franchiseeVisit.setCreatedBy(authUserName);
1382 
            franchiseeVisit.setAuthId(authUser.getId());
30433 tejbeer 1383 
 
31677 amit.gupta 1384 
            franchiseeVisitRepository.persist(franchiseeVisit);
30433 tejbeer 1385 
 
31677 amit.gupta 1386 
            return responseSender.ok(true);
1387 
        }
30433 tejbeer 1388 
 
31677 amit.gupta 1389 
        return responseSender.ok(true);
30433 tejbeer 1390 
 
31677 amit.gupta 1391 
    }
30487 tejbeer 1392 
 
31677 amit.gupta 1393 
    @RequestMapping(value = "/downloadFranchiseeVisitTemplate", method = RequestMethod.GET)
1394 
    public ResponseEntity<?> downloadFranchiseeVisitTemplate(HttpServletRequest request) throws Exception {
30487 tejbeer 1395 
 
31677 amit.gupta 1396 
        // ByteArrayOutputStream byteArrayOutputStream = new ByteArrayOutputStream();
30487 tejbeer 1397 
 
31677 amit.gupta 1398 
        List<List<?>> rows = new ArrayList<>();
30487 tejbeer 1399 
 
31677 amit.gupta 1400 
        org.apache.commons.io.output.ByteArrayOutputStream byteArrayOutputStream = FileUtil
1401 
                .getCSVByteStream(Arrays.asList("Partner Id", "Agenda", "Schedule Timestamp"), rows);
30487 tejbeer 1402 
 
31677 amit.gupta 1403 
        try {
1404 
            byteArrayOutputStream.close();
1405 
        } catch (IOException e) {
1406 
            // TODO Auto-generated catch block
1407 
            e.printStackTrace();
1408 
        }
30487 tejbeer 1409 
 
31677 amit.gupta 1410 
        String filename = "template.csv";
1411 
        HttpHeaders headers = new HttpHeaders();
1412 
        headers.add("Content-Type", "application/csv");
1413 
        headers.setContentDispositionFormData(filename, filename);
30487 tejbeer 1414 
 
31677 amit.gupta 1415 
        headers.setCacheControl("must-revalidate, post-check=0, pre-check=0");
30487 tejbeer 1416 
 
31677 amit.gupta 1417 
        ResponseEntity<byte[]> response = new ResponseEntity<byte[]>(byteArrayOutputStream.toByteArray(), headers,
1418 
                HttpStatus.OK);
1419 
        return response;
30544 tejbeer 1420 
 
31677 amit.gupta 1421 
    }
30542 tejbeer 1422 
 
31677 amit.gupta 1423 
    @RequestMapping(value = "/markVisitAttendance", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
1424 
    public ResponseEntity<?> markVisitAttendance(HttpServletRequest request, @RequestParam(name = "id") int id)
1425 
            throws ProfitMandiBusinessException {
1426 
        FranchiseeVisit franchiseeVisit = franchiseeVisitRepository.selectById(id);
30542 tejbeer 1427 
 
31677 amit.gupta 1428 
        franchiseeVisit.setVisitTimestamp(LocalDateTime.now());
30542 tejbeer 1429 
 
31677 amit.gupta 1430 
        return responseSender.ok(true);
30542 tejbeer 1431 
 
31677 amit.gupta 1432 
    }
31249 tejbeer 1433 
 
31677 amit.gupta 1434 
    @RequestMapping(value = "/getVisitRequests", method = RequestMethod.GET, produces = MediaType.APPLICATION_JSON_VALUE)
1435 
    public ResponseEntity<?> getVisitRequests(HttpServletRequest request,
1436 
                                              @RequestParam(name = "gmailId") String gmailId, Model model) throws Exception {
31249 tejbeer 1437 
 
31677 amit.gupta 1438 
        AuthUser authUser = authRepository.selectByGmailId(gmailId);
31249 tejbeer 1439 
 
31677 amit.gupta 1440 
        List<Integer> authUserIds = authService.getAllReportees(authUser.getId());
1441 
        List<VisitSummaryModel> visitSummary = new ArrayList<>();
31249 tejbeer 1442 
 
31677 amit.gupta 1443 
        if (!authUserIds.isEmpty()) {
1444 
            List<AuthUser> authUsers = authRepository.selectAllAuthUserByIds(authUserIds);
31249 tejbeer 1445 
 
31677 amit.gupta 1446 
            List<VisitRequest> allVisitRequests = visitRequestRepository.selectByAuthIdsAndDate(authUserIds,
1447 
                    LocalDate.now().minusDays(7), Arrays.asList(VisitStatus.approved, VisitStatus.pending));
1448 
            LOGGER.info("allVisitRequests {}", allVisitRequests);
31249 tejbeer 1449 
 
31677 amit.gupta 1450 
            if (!allVisitRequests.isEmpty()) {
31249 tejbeer 1451 
 
31677 amit.gupta 1452 
                List<Integer> leadIds = allVisitRequests.stream().filter(x -> x.getVisitType().equals("lead"))
1453 
                        .map(x -> x.getVisitId()).collect(Collectors.toList());
1454 
                List<Lead> leads = new ArrayList<>();
1455 
                if (!leadIds.isEmpty()) {
1456 
                    leads = leadRepository.selectAllByIds(leadIds);
31249 tejbeer 1457 
 
31677 amit.gupta 1458 
                    for (Lead lead : leads) {
1459 
                        List<LeadActivity> leadActivities = leadActivityRepository.selectBYLeadId(lead.getId());
1460 
                        lead.setScheduledTimestamp(leadActivities.get(0).getSchelduleTimestamp());
1461 
                        lead.setLeadActivity(leadActivities.get(0));
1462 
                    }
1463 
                }
1464 
                List<Integer> franchiseeIds = allVisitRequests.stream()
1465 
                        .filter(x -> x.getVisitType().equals("franchiseeVisit")).map(x -> x.getVisitId())
1466 
                        .collect(Collectors.toList());
1467 
                List<FranchiseeVisit> franchiseeVisits = new ArrayList<>();
1468 
                if (!franchiseeIds.isEmpty()) {
1469 
                    franchiseeVisits = franchiseeVisitRepository.selectAllByIds(franchiseeIds);
1470 
                    LOGGER.info("franchiseeVisits {}", franchiseeVisits);
31249 tejbeer 1471 
 
31677 amit.gupta 1472 
                    for (FranchiseeVisit franchiseeVisit : franchiseeVisits) {
1473 
                        List<FranchiseeActivity> franchiseeActivities = franchiseeActivityRepository
1474 
                                .selectByFranchiseeVisitId(franchiseeVisit.getId());
1475 
                        LOGGER.info("franchiseeActivities {}", franchiseeActivities);
31249 tejbeer 1476 
 
31677 amit.gupta 1477 
                        franchiseeVisit.setScheduleTimestamp(franchiseeActivities.get(0).getSchelduleTimestamp());
1478 
                        franchiseeVisit.setFranchiseeActivity(franchiseeActivities.get(0));
1479 
                    }
31249 tejbeer 1480 
 
31677 amit.gupta 1481 
                }
31249 tejbeer 1482 
 
31677 amit.gupta 1483 
                Map<LocalDate, List<VisitRequest>> dateWiseVisitRequest = allVisitRequests.stream()
1484 
                        .collect(Collectors.groupingBy(x -> x.getScheduleTimestamp().toLocalDate()));
31249 tejbeer 1485 
 
31677 amit.gupta 1486 
                for (Entry<LocalDate, List<VisitRequest>> visitEntry : dateWiseVisitRequest.entrySet()) {
31249 tejbeer 1487 
 
31677 amit.gupta 1488 
                    LocalDate date = visitEntry.getKey();
1489 
                    List<VisitRequest> visitRequests = visitEntry.getValue();
31249 tejbeer 1490 
 
31677 amit.gupta 1491 
                    VisitSummaryModel visitSummaryModel = new VisitSummaryModel();
31249 tejbeer 1492 
 
31677 amit.gupta 1493 
                    visitSummaryModel.setDate(date);
1494 
                    List<Integer> dateWiseLeadEntry = visitRequests.stream()
1495 
                            .filter(x -> x.getVisitType().equals("lead")).map(x -> x.getVisitId())
1496 
                            .collect(Collectors.toList());
31249 tejbeer 1497 
 
31677 amit.gupta 1498 
                    List<Integer> dateWiseFranchiseeIds = visitRequests.stream()
1499 
                            .filter(x -> x.getVisitType().equals("franchiseeVisit")).map(x -> x.getVisitId())
1500 
                            .collect(Collectors.toList());
31249 tejbeer 1501 
 
31677 amit.gupta 1502 
                    Map<Integer, List<Lead>> filteredLeadsMap = null;
1503 
                    if (!leads.isEmpty()) {
1504 
                        filteredLeadsMap = leads.stream().filter(x -> dateWiseLeadEntry.contains(x.getId()))
1505 
                                .collect(Collectors.groupingBy(x -> x.getAssignTo()));
31249 tejbeer 1506 
 
31677 amit.gupta 1507 
                    }
31249 tejbeer 1508 
 
31677 amit.gupta 1509 
                    Map<Integer, List<FranchiseeVisit>> filteredFranchiseeVisitsMap = null;
31249 tejbeer 1510 
 
31677 amit.gupta 1511 
                    if (!franchiseeVisits.isEmpty()) {
1512 
                        filteredFranchiseeVisitsMap = franchiseeVisits.stream()
1513 
                                .filter(x -> dateWiseFranchiseeIds.contains(x.getId()))
1514 
                                .collect(Collectors.groupingBy(x -> x.getAuthId()));
31249 tejbeer 1515 
 
31677 amit.gupta 1516 
                    }
31249 tejbeer 1517 
 
31677 amit.gupta 1518 
                    List<UserVisitModel> userVisits = new ArrayList<>();
31249 tejbeer 1519 
 
31677 amit.gupta 1520 
                    for (AuthUser auth : authUsers) {
1521 
                        UserVisitModel userVisitModel = new UserVisitModel();
1522 
                        List<VisitDescriptionModel> visitDescriptions = new ArrayList<>();
31249 tejbeer 1523 
 
31677 amit.gupta 1524 
                        List<Lead> authLeads = new ArrayList<>();
1525 
                        if (filteredLeadsMap != null) {
1526 
                            authLeads = filteredLeadsMap.get(auth.getId());
31249 tejbeer 1527 
 
31677 amit.gupta 1528 
                        }
31249 tejbeer 1529 
 
31677 amit.gupta 1530 
                        if (authLeads != null && !authLeads.isEmpty()) {
1531 
                            userVisitModel.setAuthUser(auth.getFullName());
31249 tejbeer 1532 
 
31677 amit.gupta 1533 
                            for (Lead lead : authLeads) {
31249 tejbeer 1534 
 
31677 amit.gupta 1535 
                                VisitRequest visitRequest = visitRequests.stream().filter(
1536 
                                                x -> x.getVisitId() == lead.getId() && x.getCreatedBy() == lead.getAssignTo())
1537 
                                        .findAny().orElse(null);
1538 
                                VisitDescriptionModel visitDescriptionModel = new VisitDescriptionModel();
1539 
                                visitDescriptionModel.setVisitId(visitRequest.getId());
1540 
                                visitDescriptionModel.setVisitName(lead.getFirstName());
1541 
                                visitDescriptionModel.setCity(lead.getCity());
1542 
                                visitDescriptionModel.setState(lead.getState());
1543 
                                visitDescriptionModel.setScheduleTime(lead.getScheduledTimestamp());
1544 
                                visitDescriptionModel.setStatus(visitRequest.getStatus());
1545 
                                visitDescriptionModel.setRemarks(lead.getLeadActivity().getRemark());
1546 
                                visitDescriptionModel.setVisitType(visitRequest.getVisitType());
1547 
                                visitDescriptions.add(visitDescriptionModel);
31249 tejbeer 1548 
 
31677 amit.gupta 1549 
                            }
1550 
                        }
31249 tejbeer 1551 
 
31677 amit.gupta 1552 
                        List<FranchiseeVisit> authfranchiseeVisit = new ArrayList<>();
1553 
                        if (filteredFranchiseeVisitsMap != null) {
1554 
                            authfranchiseeVisit = filteredFranchiseeVisitsMap.get(auth.getId());
31249 tejbeer 1555 
 
31677 amit.gupta 1556 
                        }
31249 tejbeer 1557 
 
31677 amit.gupta 1558 
                        if (authfranchiseeVisit != null && !authfranchiseeVisit.isEmpty()) {
1559 
                            userVisitModel.setAuthUser(auth.getFullName());
31249 tejbeer 1560 
 
31677 amit.gupta 1561 
                            for (FranchiseeVisit franchiseeVisit : authfranchiseeVisit) {
31249 tejbeer 1562 
 
31677 amit.gupta 1563 
                                VisitRequest visitRequest = visitRequests.stream()
1564 
                                        .filter(x -> x.getVisitId() == franchiseeVisit.getId()
1565 
                                                && x.getCreatedBy() == franchiseeVisit.getAuthId())
1566 
                                        .findAny().orElse(null);
31249 tejbeer 1567 
 
31677 amit.gupta 1568 
                                CustomRetailer customRetailer = retailerService
1569 
                                        .getFofoRetailer(franchiseeVisit.getFofoId());
1570 
                                VisitDescriptionModel visitDescriptionModel = new VisitDescriptionModel();
1571 
                                visitDescriptionModel.setVisitId(visitRequest.getId());
1572 
                                visitDescriptionModel.setVisitName(franchiseeVisit.getPartnerName());
1573 
                                visitDescriptionModel.setCity(customRetailer.getAddress().getCity());
1574 
                                visitDescriptionModel.setState(customRetailer.getAddress().getState());
1575 
                                visitDescriptionModel.setScheduleTime(
1576 
                                        franchiseeVisit.getFranchiseeActivity().getSchelduleTimestamp());
1577 
                                visitDescriptionModel.setStatus(visitRequest.getStatus());
1578 
                                visitDescriptionModel.setRemarks(franchiseeVisit.getAgenda());
1579 
                                visitDescriptionModel.setVisitType(visitRequest.getVisitType());
31249 tejbeer 1580 
 
31677 amit.gupta 1581 
                                visitDescriptions.add(visitDescriptionModel);
31249 tejbeer 1582 
 
31677 amit.gupta 1583 
                            }
1584 
                        }
31249 tejbeer 1585 
 
31677 amit.gupta 1586 
                        userVisitModel.setVisitDescriptions(visitDescriptions);
1587 
                        LOGGER.info("userVisit {}", userVisitModel);
31249 tejbeer 1588 
 
31677 amit.gupta 1589 
                        if (userVisitModel.getAuthUser() != null) {
1590 
                            userVisits.add(userVisitModel);
1591 
                        }
31249 tejbeer 1592 
 
31677 amit.gupta 1593 
                    }
31249 tejbeer 1594 
 
31677 amit.gupta 1595 
                    visitSummaryModel.setUserVisits(userVisits);
31249 tejbeer 1596 
 
31677 amit.gupta 1597 
                    visitSummary.add(visitSummaryModel);
31249 tejbeer 1598 
 
31677 amit.gupta 1599 
                }
31249 tejbeer 1600 
 
31677 amit.gupta 1601 
            }
31249 tejbeer 1602 
 
31677 amit.gupta 1603 
        }
1604 
        return responseSender.ok(visitSummary);
31249 tejbeer 1605 
 
31677 amit.gupta 1606 
    }
31249 tejbeer 1607 
 
31677 amit.gupta 1608 
    @RequestMapping(value = "/visitRequest", method = RequestMethod.POST, produces = MediaType.APPLICATION_JSON_VALUE)
1609 
    public ResponseEntity<?> visitRequest(HttpServletRequest request, @RequestParam(name = "gmailId") String gmailId,
1610 
                                          @RequestParam(name = "visitId") int visitId, @RequestParam(name = "status") VisitStatus status, Model model)
1611 
            throws Exception {
1612 
        AuthUser authUser = authRepository.selectByGmailId(gmailId);
31249 tejbeer 1613 
 
31677 amit.gupta 1614 
        VisitRequest visitRequest = visitRequestRepository.selectById(visitId);
1615 
        visitRequest.setActionedBy(authUser.getId());
1616 
        visitRequest.setStatus(status);
1617 
        visitRequest.setUpdatedTimestamp(LocalDateTime.now());
1618 
        if (status.equals(VisitStatus.approved)) {
1619 
            visitRequest.setApprovedTimestamp(LocalDateTime.now());
1620 
        }
31249 tejbeer 1621 
 
31677 amit.gupta 1622 
        SendNotificationModel sendNotificationModel = new SendNotificationModel();
1623 
        sendNotificationModel.setCampaignName("Visit Request");
1624 
        sendNotificationModel.setExpiresat(LocalDateTime.now().plusDays(1));
1625 
        sendNotificationModel.setTitle("Visit Request");
1626 
        String message = "Visit Request has been " + status + " for scheduled time on "
1627 
                + visitRequest.getScheduleTimestamp().toLocalDate();
31249 tejbeer 1628 
 
31677 amit.gupta 1629 
        sendNotificationModel.setMessage(message);
1630 
        sendNotificationModel.setMessageType(MessageType.notification);
1631 
        User user = userRepository.selectByEmailId(gmailId);
1632 
        sendNotificationModel.setUserIds(new ArrayList<>(user.getId()));
31249 tejbeer 1633 
 
31677 amit.gupta 1634 
        notificationService.sendNotificationToAll(sendNotificationModel);
31249 tejbeer 1635 
 
31677 amit.gupta 1636 
        return responseSender.ok(true);
31249 tejbeer 1637 
 
31677 amit.gupta 1638 
    }
31249 tejbeer 1639 
 
30077 tejbeer 1640 
}