Subversion Repositories SmartDukaan

Rev

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

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