Subversion Repositories SmartDukaan

Rev

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