Subversion Repositories SmartDukaan

Rev

Rev 24559 | Rev 24570 | Go to most recent revision | Show entire file | Ignore whitespace | Details | Blame | Last modification | View Log | RSS feed

Rev 24559 Rev 24569
Line 95... Line 95...
95
	@Autowired
95
	@Autowired
96
	private ActivityRepository activityRepository;
96
	private ActivityRepository activityRepository;
97
 
97
 
98
	@Autowired
98
	@Autowired
99
	private TicketAssignedRepository ticketAssignedRepository;
99
	private TicketAssignedRepository ticketAssignedRepository;
100
	
100
 
101
	@Autowired 
101
	@Autowired
102
	private PartnerRegionRepository partnerRegionRepository;
102
	private PartnerRegionRepository partnerRegionRepository;
103
 
103
 
104
	@GetMapping(value = "/cs/createCategory")
104
	@GetMapping(value = "/cs/createCategory")
105
	public String getCreateCategory(HttpServletRequest request, Model model) {
105
	public String getCreateCategory(HttpServletRequest request, Model model) {
106
		List<TicketCategory> ticketCategories = ticketCategoryRepository.selectAll();
106
		List<TicketCategory> ticketCategories = ticketCategoryRepository.selectAll();
Line 180... Line 180...
180
		model.addAttribute("response", mvcResponseSender.createResponseString(true));
180
		model.addAttribute("response", mvcResponseSender.createResponseString(true));
181
		return "response";
181
		return "response";
182
	}
182
	}
183
 
183
 
184
	@GetMapping(value = "/cs/getPartners")
184
	@GetMapping(value = "/cs/getPartners")
-
 
185
	public String getPartners(HttpServletRequest request,
185
	public String getPartners(HttpServletRequest request,@RequestParam(name="regionId",defaultValue="0")int regionId,Model model) {
186
			@RequestParam(name = "regionId", defaultValue = "0") int regionId, Model model) {
186
		List<Integer> fofoIds = targetSlabService.getfofoIdsFromfofoStore();
187
		List<Integer> fofoIds = targetSlabService.getfofoIdsFromfofoStore();
187
		List<Integer> addedfofoIds=partnerRegionRepository.selectByRegionId(regionId).stream().map(x->x.getFofoId()).collect(Collectors.toList());
188
		List<Integer> addedfofoIds = partnerRegionRepository.selectByRegionId(regionId).stream().map(x -> x.getFofoId())
-
 
189
				.collect(Collectors.toList());
188
		Map<Integer, CustomRetailer> fofoRetailers = retailerService.getFofoRetailers(fofoIds);
190
		Map<Integer, CustomRetailer> fofoRetailers = retailerService.getFofoRetailers(fofoIds);
189
		model.addAttribute("fofoRetailers", fofoRetailers);
191
		model.addAttribute("fofoRetailers", fofoRetailers);
190
		model.addAttribute("addedfofoIds", addedfofoIds);
192
		model.addAttribute("addedfofoIds", addedfofoIds);
191
		return "added-region-partners";
193
		return "added-region-partners";
192
	}
194
	}
-
 
195
 
193
	@GetMapping(value = "/cs/createPartnerRegion")
196
	@GetMapping(value = "/cs/createPartnerRegion")
194
	public String createPartnerRegion(HttpServletRequest request, Model model) {
197
	public String createPartnerRegion(HttpServletRequest request, Model model) {
195
		List<Region> regions = regionRepository.selectAll();
198
		List<Region> regions = regionRepository.selectAll();
196
		model.addAttribute("regions", regions);
199
		model.addAttribute("regions", regions);
197
		return "create-partner-region";
200
		return "create-partner-region";
Line 324... Line 327...
324
			AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
327
			AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
325
			ticketAssigneds = ticketAssignedRepository.selectByAssigneeId(authUser.getId(), offset, limit);
328
			ticketAssigneds = ticketAssignedRepository.selectByAssigneeId(authUser.getId(), offset, limit);
326
			ticketIds = ticketAssigneds.stream().map(x -> x.getTicketId()).collect(Collectors.toList());
329
			ticketIds = ticketAssigneds.stream().map(x -> x.getTicketId()).collect(Collectors.toList());
327
			tickets = ticketRepository.selectAllByTicketIds(ticketIds);
330
			tickets = ticketRepository.selectAllByTicketIds(ticketIds);
328
			size = ticketAssignedRepository.selectCountByAssigneeId(authUser.getId());
331
			size = ticketAssignedRepository.selectCountByAssigneeId(authUser.getId());
-
 
332
			LOGGER.info(size +"size");
329
			authUserIdAndAuthUserMap = csService.getAuthUserIdAndAuthUserMap(ticketAssigneds);
333
			authUserIdAndAuthUserMap = csService.getAuthUserIdAndAuthUserMap(ticketAssigneds);
330
			Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
334
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
331
			model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
335
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
-
 
336
			
332
		} else {
337
		} else {
333
			tickets = ticketRepository.selectAllByCreator(loginDetails.getFofoId(), Optional.empty(), offset, limit);
338
			tickets = ticketRepository.selectAllByCreator(loginDetails.getFofoId(), Optional.empty(), offset, limit);
334
			authUserIdAndAuthUserMap = csService.getTicketIdAndAuthUserMapUsingTickets(tickets);
339
			authUserIdAndAuthUserMap = csService.getTicketIdAndAuthUserMapUsingTickets(tickets);
335
			size = ticketRepository.selectAllCountByCreator(loginDetails.getFofoId(), Optional.empty());
340
			size = ticketRepository.selectAllCountByCreator(loginDetails.getFofoId(), Optional.empty());
336
 
341
 
Line 363... Line 368...
363
		Map<Integer, AuthUser> authUserIdAndAuthUserMap = null;
368
		Map<Integer, AuthUser> authUserIdAndAuthUserMap = null;
364
		// LOGGER.info(roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds()))));
369
		// LOGGER.info(roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds()))));
365
		if (roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds()))) {
370
		if (roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds()))) {
366
			AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
371
			AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
367
			ticketAssigneds = ticketAssignedRepository.selectByAssigneeId(authUser.getId(), offset, limit);
372
			ticketAssigneds = ticketAssignedRepository.selectByAssigneeId(authUser.getId(), offset, limit);
368
			ticketIds = ticketAssigneds.stream().map(x -> x.getTicketId()).collect(Collectors.toList());
373
				ticketIds = ticketAssigneds.stream().map(x -> x.getTicketId()).collect(Collectors.toList());
369
			tickets = ticketRepository.selectAllByTicketIds(ticketIds);
374
				tickets = ticketRepository.selectAllByTicketIds(ticketIds);
370
			authUserIdAndAuthUserMap = csService.getAuthUserIdAndAuthUserMap(ticketAssigneds);
375
				authUserIdAndAuthUserMap = csService.getAuthUserIdAndAuthUserMap(ticketAssigneds);
371
			Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
376
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
372
			model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
377
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
373
		} else {
378
		} else {
374
			tickets = ticketRepository.selectAllByCreator(loginDetails.getFofoId(), Optional.empty(), offset, limit);
379
			tickets = ticketRepository.selectAllByCreator(loginDetails.getFofoId(), Optional.empty(), offset, limit);
375
			authUserIdAndAuthUserMap = csService.getTicketIdAndAuthUserMapUsingTickets(tickets);
380
			authUserIdAndAuthUserMap = csService.getTicketIdAndAuthUserMapUsingTickets(tickets);
376
		}
381
		}
377
		model.addAttribute("roleType", roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds())));
382
		model.addAttribute("roleType", roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds())));
Line 450... Line 455...
450
			throws ProfitMandiBusinessException {
455
			throws ProfitMandiBusinessException {
451
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
456
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
452
		long size = 0;
457
		long size = 0;
453
		AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
458
		AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
454
		List<Ticket> tickets = null;
459
		List<Ticket> tickets = null;
455
		Map<Integer, List<AuthUser>> authUserListMap=null;
460
		Map<Integer, List<AuthUser>> authUserListMap = null;
456
		if (loginDetails.getEmailId().equals("amandeep.singh@smartdukaan.com")) {
461
		if (loginDetails.getEmailId().equals("amandeep.singh@smartdukaan.com")) {
457
			tickets = ticketRepository.selectAll(offset, limit, Optional.empty());
462
			tickets = ticketRepository.selectAll(offset, limit, Optional.empty());
458
			authUserListMap=csService.getAuthUserList(tickets, EscalationType.L4);
463
			authUserListMap = csService.getAuthUserList(tickets, EscalationType.L4);
459
			size = ticketRepository.selectAllCount();
464
			size = ticketRepository.selectAllCount();
460
		} else {
465
		} else {
461
			tickets = ticketRepository.selectAllByEscalatedUserType(authUser.getId(), EscalationType.L2, offset, limit);
466
			tickets = ticketRepository.selectAllByEscalatedUserType(authUser.getId(), EscalationType.L2, offset, limit);
462
			if (tickets.size() == 0) {
467
			if (tickets.size() == 0) {
463
				tickets = ticketRepository.selectAllByEscalatedUserType(authUser.getId(), EscalationType.L3, offset,
468
				tickets = ticketRepository.selectAllByEscalatedUserType(authUser.getId(), EscalationType.L3, offset,
464
						limit);
469
						limit);
465
				size = ticketRepository.selectAllCountByEscalatedUserType(authUser.getId(), EscalationType.L3);
470
				size = ticketRepository.selectAllCountByEscalatedUserType(authUser.getId(), EscalationType.L3);
466
				authUserListMap=csService.getAuthUserList(tickets, EscalationType.L3);
471
				authUserListMap = csService.getAuthUserList(tickets, EscalationType.L3);
-
 
472
				if(tickets.size()>0) {
467
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
473
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
468
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
474
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
-
 
475
				}
469
			} else {
476
			} else {
470
				size = ticketRepository.selectAllCountByEscalatedUserType(authUser.getId(), EscalationType.L2);
477
				size = ticketRepository.selectAllCountByEscalatedUserType(authUser.getId(), EscalationType.L2);
471
				authUserListMap=csService.getAuthUserList(tickets, EscalationType.L2);
478
				authUserListMap = csService.getAuthUserList(tickets, EscalationType.L2);
472
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
479
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
473
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
480
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
474
			}
481
			}
475
		}
482
		}
476
		if (size < limit) {
483
		if (size < limit) {
Line 506... Line 513...
506
			tickets = ticketRepository.selectAllByEscalatedUserType(authUser.getId(), EscalationType.L2, offset, limit);
513
			tickets = ticketRepository.selectAllByEscalatedUserType(authUser.getId(), EscalationType.L2, offset, limit);
507
			if (tickets.size() == 0) {
514
			if (tickets.size() == 0) {
508
				tickets = ticketRepository.selectAllByEscalatedUserType(authUser.getId(), EscalationType.L3, offset,
515
				tickets = ticketRepository.selectAllByEscalatedUserType(authUser.getId(), EscalationType.L3, offset,
509
						limit);
516
						limit);
510
				authUserListMap = csService.getAuthUserList(tickets, EscalationType.L3);
517
				authUserListMap = csService.getAuthUserList(tickets, EscalationType.L3);
-
 
518
				LOGGER.info(tickets);
-
 
519
				if(tickets.size()>0)
-
 
520
				{
511
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
521
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
512
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
522
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
-
 
523
				}
513
			} else {
524
			} else {
514
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
525
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
515
				authUserListMap=csService.getAuthUserList(tickets, EscalationType.L2);
526
				authUserListMap = csService.getAuthUserList(tickets, EscalationType.L2);
516
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
527
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
517
			}
528
			}
518
		}
529
		}
519
		model.addAttribute("tickets", tickets);
530
		model.addAttribute("tickets", tickets);
520
		Map<Integer, TicketSubCategory> subCategoryIdAndSubCategoryMap = csService
531
		Map<Integer, TicketSubCategory> subCategoryIdAndSubCategoryMap = csService
Line 531... Line 542...
531
		Ticket ticket = ticketRepository.selectById(ticketId);
542
		Ticket ticket = ticketRepository.selectById(ticketId);
532
		List<TicketCategory> ticketCategories = csService.getAllTicketCategotyFromSubCategory();
543
		List<TicketCategory> ticketCategories = csService.getAllTicketCategotyFromSubCategory();
533
		TicketSubCategory ticketSubCategory = ticketSubCategoryRepository.selectById(ticket.getSubCategoryId());
544
		TicketSubCategory ticketSubCategory = ticketSubCategoryRepository.selectById(ticket.getSubCategoryId());
534
		List<TicketSubCategory> ticketSubCategories = ticketSubCategoryRepository
545
		List<TicketSubCategory> ticketSubCategories = ticketSubCategoryRepository
535
				.selectAll(ticketSubCategory.getcategoryId());
546
				.selectAll(ticketSubCategory.getcategoryId());
536
		List<AuthUser> authUsers=authRepository.selectAll();
547
		List<AuthUser> authUsers = authRepository.selectAll();
537
		model.addAttribute("ticket", ticket);
548
		model.addAttribute("ticket", ticket);
538
		model.addAttribute("ticketCategories", ticketCategories);
549
		model.addAttribute("ticketCategories", ticketCategories);
539
		model.addAttribute("ticketSubCategories", ticketSubCategories);
550
		model.addAttribute("ticketSubCategories", ticketSubCategories);
540
		model.addAttribute("authUsers", authUsers);
551
		model.addAttribute("authUsers", authUsers);
541
		return "edit-ticket-modal";
552
		return "edit-ticket-modal";
Line 547... Line 558...
547
			@RequestParam(name = "subCategoryId", defaultValue = "0") int subCategoryId,
558
			@RequestParam(name = "subCategoryId", defaultValue = "0") int subCategoryId,
548
			@RequestParam(name = "categoryId", defaultValue = "0") int categoryId,
559
			@RequestParam(name = "categoryId", defaultValue = "0") int categoryId,
549
			@RequestParam(name = "authUserId", defaultValue = "0") int authUserId, Model model) throws Exception {
560
			@RequestParam(name = "authUserId", defaultValue = "0") int authUserId, Model model) throws Exception {
550
		LOGGER.info(ticketId);
561
		LOGGER.info(ticketId);
551
		Ticket ticket = ticketRepository.selectById(ticketId);
562
		Ticket ticket = ticketRepository.selectById(ticketId);
552
		
-
 
-
 
563
		ticketAssignedRepository.deleteByTicketId(ticketId);
553
		if(ticket.getSubCategoryId()==subCategoryId)
564
		if (ticket.getSubCategoryId() == subCategoryId) {
554
		{
-
 
555
		LOGGER.info(ticket);
565
			LOGGER.info(ticket);
556
		
-
 
557
		TicketAssigned ticketAssigned=ticketAssignedRepository.selectByAssigneeIdAndTicketId(authUserId, ticket.getId());
-
 
558
		if(ticketAssigned==null)
-
 
559
		{
-
 
560
			ticketAssignedRepository.deleteByTicketId(ticketId);
-
 
561
			ticketAssigned=new TicketAssigned();
566
			TicketAssigned ticketAssigned = new TicketAssigned();
562
			ticketAssigned.setTicketId(ticketId);
567
			ticketAssigned.setTicketId(ticketId);
563
			ticketAssigned.setAssineeId(authUserId);
568
			ticketAssigned.setAssineeId(authUserId);
564
			ticketAssignedRepository.persist(ticketAssigned);
569
			ticketAssignedRepository.persist(ticketAssigned);
565
		}
-
 
566
		ticket.setL1AuthUser(authUserId);
570
			ticket.setL1AuthUser(authUserId);
567
		ticket.setSubCategoryId(subCategoryId);
571
			ticket.setSubCategoryId(subCategoryId);
568
		ticket.setUpdateTimestamp(LocalDateTime.now());
572
			ticket.setUpdateTimestamp(LocalDateTime.now());
569
		ticket.setL2EscalationTimestamp(ticket.getUpdateTimestamp().plusDays(2));
573
			ticket.setL2EscalationTimestamp(ticket.getUpdateTimestamp().plusDays(2));
570
		ticket.setL3EscalationTimestamp(ticket.getL2EscalationTimestamp().plusDays(2));
574
			ticket.setL3EscalationTimestamp(ticket.getL2EscalationTimestamp().plusDays(2));
571
		ticket.setLastEscalationTimestamp(ticket.getL3EscalationTimestamp().plusDays(2));
575
			ticket.setLastEscalationTimestamp(ticket.getL3EscalationTimestamp().plusDays(2));
572
		ticketRepository.persist(ticket);
576
			ticketRepository.persist(ticket);
-
 
577
			csService.sendAssignedTicketMail(authRepository.selectById(authUserId), ticket);
573
		model.addAttribute("response", mvcResponseSender.createResponseString(true));
578
			model.addAttribute("response", mvcResponseSender.createResponseString(true));
574
		}
-
 
575
		else
579
		} else {
576
		{
-
 
577
			ticketAssignedRepository.deleteByTicketId(ticketId);
-
 
578
			csService.updateTicket(categoryId,subCategoryId,ticket);	
580
			csService.updateTicket(categoryId, subCategoryId, ticket);
579
			model.addAttribute("response", mvcResponseSender.createResponseString(true));
581
			model.addAttribute("response", mvcResponseSender.createResponseString(true));
580
		}
582
		}
581
		return "response";
583
		return "response";
582
	}
584
	}
583
 
585