Subversion Repositories SmartDukaan

Rev

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

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