Subversion Repositories SmartDukaan

Rev

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

Rev 24701 Rev 24747
Line 33... Line 33...
33
import com.spice.profitmandi.dao.entity.cs.Position;
33
import com.spice.profitmandi.dao.entity.cs.Position;
34
import com.spice.profitmandi.dao.entity.cs.Region;
34
import com.spice.profitmandi.dao.entity.cs.Region;
35
import com.spice.profitmandi.dao.entity.cs.Ticket;
35
import com.spice.profitmandi.dao.entity.cs.Ticket;
36
import com.spice.profitmandi.dao.entity.cs.TicketAssigned;
36
import com.spice.profitmandi.dao.entity.cs.TicketAssigned;
37
import com.spice.profitmandi.dao.entity.cs.TicketCategory;
37
import com.spice.profitmandi.dao.entity.cs.TicketCategory;
-
 
38
import com.spice.profitmandi.dao.entity.cs.TicketSearchType;
38
import com.spice.profitmandi.dao.entity.cs.TicketSubCategory;
39
import com.spice.profitmandi.dao.entity.cs.TicketSubCategory;
39
import com.spice.profitmandi.dao.entity.fofo.ActivityType;
40
import com.spice.profitmandi.dao.entity.fofo.ActivityType;
40
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
41
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
41
import com.spice.profitmandi.dao.enumuration.cs.TicketStatus;
42
import com.spice.profitmandi.dao.enumuration.cs.TicketStatus;
42
import com.spice.profitmandi.dao.repository.auth.AuthRepository;
43
import com.spice.profitmandi.dao.repository.auth.AuthRepository;
Line 320... Line 321...
320
	@PostMapping(value = "/cs/createTicket")
321
	@PostMapping(value = "/cs/createTicket")
321
	public String createTicket(HttpServletRequest request, @RequestParam(name = "categoryId") int categoryId,
322
	public String createTicket(HttpServletRequest request, @RequestParam(name = "categoryId") int categoryId,
322
			@RequestParam(name = "subCategoryId") int subCategoryId, @RequestParam(name = "message") String message,
323
			@RequestParam(name = "subCategoryId") int subCategoryId, @RequestParam(name = "message") String message,
323
			Model model) throws Exception {
324
			Model model) throws Exception {
324
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
325
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
325
		List<Ticket> tickets = ticketRepository.selectAllByCreator(loginDetails.getFofoId(), Optional.of(true),SortOrder.DESCENDING,0, 10);
326
		List<Ticket> tickets = ticketRepository.selectAllByCreator(loginDetails.getFofoId(), Optional.of(true),
-
 
327
				SortOrder.DESCENDING, 0, 10);
326
		if (tickets.size() > 3 || tickets.size() == 3) {
328
		if (tickets.size() > 3 || tickets.size() == 3) {
327
			model.addAttribute("response", mvcResponseSender.createResponseString(false));
329
			model.addAttribute("response", mvcResponseSender.createResponseString(false));
328
		} else {
330
		} else {
329
			csService.createTicket(loginDetails.getFofoId(), categoryId, subCategoryId, message);
331
			csService.createTicket(loginDetails.getFofoId(), categoryId, subCategoryId, message);
330
			model.addAttribute("response", mvcResponseSender.createResponseString(true));
332
			model.addAttribute("response", mvcResponseSender.createResponseString(true));
Line 340... Line 342...
340
			@RequestParam(name = "limit", defaultValue = "10") int limit, Model model)
342
			@RequestParam(name = "limit", defaultValue = "10") int limit, Model model)
341
			throws ProfitMandiBusinessException {
343
			throws ProfitMandiBusinessException {
342
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
344
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
343
		List<Ticket> tickets = null;
345
		List<Ticket> tickets = null;
344
		List<TicketAssigned> ticketAssigneds = null;
346
		List<TicketAssigned> ticketAssigneds = null;
345
		//List<Integer> ticketIds = null;
347
		// List<Integer> ticketIds = null;
346
		long size = 0;
348
		long size = 0;
347
		Map<Integer, AuthUser> authUserIdAndAuthUserMap = null;
349
		Map<Integer, AuthUser> authUserIdAndAuthUserMap = null;
348
		// LOGGER.info(roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds()))));
350
		// LOGGER.info(roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds()))));
349
		if (roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds()))) {
351
		if (roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds()))) {
350
			AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
352
			AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
351
			LOGGER.info(ticketStatus);
353
			LOGGER.info(ticketStatus);
352
			LOGGER.info(sortOrder);
354
			LOGGER.info(sortOrder);
353
			tickets = ticketRepository.selectAllByAssignee(authUser.getId(),
355
			tickets = ticketRepository.selectAllByAssignee(authUser.getId(),
354
					Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), sortOrder, offset, limit);
356
					Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), sortOrder, offset, limit);
355
			size = ticketRepository.selectAllCountByAssignee(authUser.getId(),Optional.of(TicketStatus.CLOSED.equals(ticketStatus)));
357
			size = ticketRepository.selectAllCountByAssignee(authUser.getId(),
-
 
358
					Optional.of(TicketStatus.CLOSED.equals(ticketStatus)));
356
			LOGGER.info(size + "size");
359
			LOGGER.info(size + "size");
-
 
360
			ticketAssigneds = ticketAssignedRepository
357
			ticketAssigneds=ticketAssignedRepository.selectByTicketIds(tickets.stream().map(x->x.getId()).collect(Collectors.toList()));
361
					.selectByTicketIds(tickets.stream().map(x -> x.getId()).collect(Collectors.toList()));
358
			authUserIdAndAuthUserMap = csService.getAuthUserIdAndAuthUserMap(ticketAssigneds);
362
			authUserIdAndAuthUserMap = csService.getAuthUserIdAndAuthUserMap(ticketAssigneds);
359
			Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
363
			Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
360
			model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
364
			model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
361
 
365
 
362
		} else {
366
		} else {
363
			LOGGER.info(ticketStatus);
367
			LOGGER.info(ticketStatus);
364
			LOGGER.info(sortOrder);
368
			LOGGER.info(sortOrder);
365
			LOGGER.info(TicketStatus.CLOSED.equals(ticketStatus));
369
			LOGGER.info(TicketStatus.CLOSED.equals(ticketStatus));
366
			tickets = ticketRepository.selectAllByCreator(loginDetails.getFofoId(),
370
			tickets = ticketRepository.selectAllByCreator(loginDetails.getFofoId(),
367
					Optional.of(TicketStatus.CLOSED.equals(ticketStatus)),sortOrder,offset, limit);
371
					Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), sortOrder, offset, limit);
368
			size = ticketRepository.selectAllCountByCreator(loginDetails.getFofoId(),
372
			size = ticketRepository.selectAllCountByCreator(loginDetails.getFofoId(),
369
					Optional.of(TicketStatus.CLOSED.equals(ticketStatus)));
373
					Optional.of(TicketStatus.CLOSED.equals(ticketStatus)));
370
		}
374
		}
371
		authUserIdAndAuthUserMap = csService.getTicketIdAndAuthUserMapUsingTickets(tickets);
375
		authUserIdAndAuthUserMap = csService.getTicketIdAndAuthUserMapUsingTickets(tickets);
372
 
376
 
Line 401... Line 405...
401
			@RequestParam(name = "limit", defaultValue = "10") int limit, Model model)
405
			@RequestParam(name = "limit", defaultValue = "10") int limit, Model model)
402
			throws ProfitMandiBusinessException {
406
			throws ProfitMandiBusinessException {
403
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
407
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
404
		List<Ticket> tickets = null;
408
		List<Ticket> tickets = null;
405
		List<TicketAssigned> ticketAssigneds = null;
409
		List<TicketAssigned> ticketAssigneds = null;
406
		//List<Integer> ticketIds = null;
410
		// List<Integer> ticketIds = null;
407
		Map<Integer, AuthUser> authUserIdAndAuthUserMap = null;
411
		Map<Integer, AuthUser> authUserIdAndAuthUserMap = null;
408
		// LOGGER.info(roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds()))));
412
		// LOGGER.info(roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds()))));
409
		if (roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds()))) {
413
		if (roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds()))) {
410
			AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
414
			AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
411
			tickets = ticketRepository.selectAllByAssignee(authUser.getId(),
415
			tickets = ticketRepository.selectAllByAssignee(authUser.getId(),
412
					Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), sortOrder, offset, limit);
416
					Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), sortOrder, offset, limit);
-
 
417
			ticketAssigneds = ticketAssignedRepository
413
			ticketAssigneds=ticketAssignedRepository.selectByTicketIds(tickets.stream().map(x->x.getId()).collect(Collectors.toList()));
418
					.selectByTicketIds(tickets.stream().map(x -> x.getId()).collect(Collectors.toList()));
414
			authUserIdAndAuthUserMap = csService.getAuthUserIdAndAuthUserMap(ticketAssigneds);
419
			authUserIdAndAuthUserMap = csService.getAuthUserIdAndAuthUserMap(ticketAssigneds);
415
			Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
420
			Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
416
			model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
421
			model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
417
		} else {
422
		} else {
-
 
423
			tickets = ticketRepository.selectAllByCreator(loginDetails.getFofoId(),
418
			tickets = ticketRepository.selectAllByCreator(loginDetails.getFofoId(), Optional.of(TicketStatus.CLOSED.equals(ticketStatus)),sortOrder,offset, limit);
424
					Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), sortOrder, offset, limit);
419
			authUserIdAndAuthUserMap = csService.getTicketIdAndAuthUserMapUsingTickets(tickets);
425
			authUserIdAndAuthUserMap = csService.getTicketIdAndAuthUserMapUsingTickets(tickets);
420
		}
426
		}
421
		model.addAttribute("roleType", roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds())));
427
		model.addAttribute("roleType", roleManager.isAdmin(new HashSet<>(loginDetails.getRoleIds())));
422
		Map<Integer, TicketSubCategory> subCategoryIdAndSubCategoryMap = csService
428
		Map<Integer, TicketSubCategory> subCategoryIdAndSubCategoryMap = csService
423
				.getSubCategoryIdAndSubCategoryMap(tickets);
429
				.getSubCategoryIdAndSubCategoryMap(tickets);
Line 518... Line 524...
518
 
524
 
519
	@GetMapping(value = "/cs/managerTicket")
525
	@GetMapping(value = "/cs/managerTicket")
520
	public String getL2L3AndL4Tickets(HttpServletRequest request,
526
	public String getL2L3AndL4Tickets(HttpServletRequest request,
521
			@RequestParam(name = "orderby", defaultValue = "DESCENDING") SortOrder sortOrder,
527
			@RequestParam(name = "orderby", defaultValue = "DESCENDING") SortOrder sortOrder,
522
			@RequestParam(name = "ticketStatus", defaultValue = "OPENED") TicketStatus ticketStatus,
528
			@RequestParam(name = "ticketStatus", defaultValue = "OPENED") TicketStatus ticketStatus,
-
 
529
			@RequestParam(name = "ticketSearchType", defaultValue = "") TicketSearchType ticketSearchType,
-
 
530
			@RequestParam(name = "searchTerm", defaultValue = "0") int searchTerm,
523
			@RequestParam(name = "offset", defaultValue = "0") int offset,
531
			@RequestParam(name = "offset", defaultValue = "0") int offset,
524
			@RequestParam(name = "limit", defaultValue = "10") int limit, Model model)
532
			@RequestParam(name = "limit", defaultValue = "10") int limit, Model model)
525
			throws ProfitMandiBusinessException {
533
			throws ProfitMandiBusinessException {
526
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
534
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
527
		long size = 0;
535
		long size = 0;
Line 531... Line 539...
531
		if (loginDetails.getEmailId().equals("amandeep.singh@smartdukaan.com")) {
539
		if (loginDetails.getEmailId().equals("amandeep.singh@smartdukaan.com")) {
532
			tickets = ticketRepository.selectAll(offset, limit, Optional.empty());
540
			tickets = ticketRepository.selectAll(offset, limit, Optional.empty());
533
			authUserListMap = csService.getAuthUserList(tickets, authUser);
541
			authUserListMap = csService.getAuthUserList(tickets, authUser);
534
			size = ticketRepository.selectAllCount();
542
			size = ticketRepository.selectAllCount();
535
		} else {
543
		} else {
-
 
544
			if (ticketSearchType == null) {
-
 
545
				tickets = ticketRepository.selectAllManagerTicket(authUser.getId(), sortOrder,
-
 
546
						Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), null, searchTerm, offset, limit);
-
 
547
				size = ticketRepository.selectAllCountByManagerTicket(authUser.getId(),
-
 
548
						Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), null, 0);
-
 
549
			} else {
536
			tickets = ticketRepository.selectAllManagerTicket(authUser.getId(), sortOrder, Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), offset, limit);
550
				tickets = ticketRepository.selectAllManagerTicket(authUser.getId(), sortOrder,
-
 
551
						Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), ticketSearchType, searchTerm, offset,
-
 
552
						limit);
-
 
553
				size = ticketRepository.selectAllCountByManagerTicket(authUser.getId(),
-
 
554
						Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), ticketSearchType, searchTerm);
-
 
555
			}
537
			authUserListMap = csService.getAuthUserList(tickets, authUser);
556
			authUserListMap = csService.getAuthUserList(tickets, authUser);
538
			size = ticketRepository.selectAllCountByManagerTicket(authUser.getId(), Optional.of(TicketStatus.CLOSED.equals(ticketStatus)));
-
 
-
 
557
 
539
			if (tickets.size() > 0) {
558
			if (tickets.size() > 0) {
540
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
559
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
541
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
560
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
542
			}
561
			}
543
		}
562
		}
Line 555... Line 574...
555
		model.addAttribute("ticketStatusValues", TicketStatus.values());
574
		model.addAttribute("ticketStatusValues", TicketStatus.values());
556
		model.addAttribute("orderByValues", SortOrder.values());
575
		model.addAttribute("orderByValues", SortOrder.values());
557
		model.addAttribute("selectedticketStatus", ticketStatus);
576
		model.addAttribute("selectedticketStatus", ticketStatus);
558
		model.addAttribute("selectedorderby", sortOrder);
577
		model.addAttribute("selectedorderby", sortOrder);
559
		model.addAttribute("tickets", tickets);
578
		model.addAttribute("tickets", tickets);
-
 
579
		model.addAttribute("ticketSearchTypes", TicketSearchType.values());
-
 
580
		model.addAttribute("ticketSearchType", ticketSearchType.getValue());
-
 
581
		model.addAttribute("searchTerm", searchTerm);
560
		model.addAttribute("authUserListMap", authUserListMap);
582
		model.addAttribute("authUserListMap", authUserListMap);
561
		model.addAttribute("subCategoryIdAndSubCategoryMap", subCategoryIdAndSubCategoryMap);
583
		model.addAttribute("subCategoryIdAndSubCategoryMap", subCategoryIdAndSubCategoryMap);
562
		return "managerTicket";
584
		return "managerTicket";
563
	}
585
	}
564
 
586
 
565
	@GetMapping(value = "/cs/managerTicket-paginated")
587
	@GetMapping(value = "/cs/managerTicket-paginated")
566
	public String getL2L3AndL4TicketsPaginated(HttpServletRequest request,
588
	public String getL2L3AndL4TicketsPaginated(HttpServletRequest request,
567
			@RequestParam(name = "orderby", defaultValue = "DESCENDING") SortOrder sortOrder,
589
			@RequestParam(name = "orderby", defaultValue = "DESCENDING") SortOrder sortOrder,
568
			@RequestParam(name = "ticketStatus", defaultValue = "OPENED") TicketStatus ticketStatus,
590
			@RequestParam(name = "ticketStatus", defaultValue = "OPENED") TicketStatus ticketStatus,
-
 
591
			@RequestParam(name = "ticketSearchType", defaultValue = "") TicketSearchType ticketSearchType,
-
 
592
			@RequestParam(name = "searchTerm", defaultValue = "0") int searchTerm,
569
			@RequestParam(name = "offset", defaultValue = "0") int offset,
593
			@RequestParam(name = "offset", defaultValue = "0") int offset,
570
			@RequestParam(name = "limit", defaultValue = "10") int limit, Model model)
594
			@RequestParam(name = "limit", defaultValue = "10") int limit, Model model)
571
			throws ProfitMandiBusinessException {
595
			throws ProfitMandiBusinessException {
572
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
596
		LoginDetails loginDetails = cookiesProcessor.getCookiesObject(request);
573
		AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
597
		AuthUser authUser = authRepository.selectByEmailOrMobile(loginDetails.getEmailId());
Line 575... Line 599...
575
		List<Ticket> tickets = null;
599
		List<Ticket> tickets = null;
576
		if (loginDetails.getEmailId().equals("amandeep.singh@smartdukaan.com")) {
600
		if (loginDetails.getEmailId().equals("amandeep.singh@smartdukaan.com")) {
577
			tickets = ticketRepository.selectAll(offset, limit, Optional.empty());
601
			tickets = ticketRepository.selectAll(offset, limit, Optional.empty());
578
			authUserListMap = csService.getAuthUserList(tickets, authUser);
602
			authUserListMap = csService.getAuthUserList(tickets, authUser);
579
		} else {
603
		} else {
-
 
604
			if (ticketSearchType == null) {
-
 
605
				tickets = ticketRepository.selectAllManagerTicket(authUser.getId(), sortOrder,
-
 
606
						Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), null, searchTerm, offset, limit);
580
			
607
			} else {
581
			tickets = ticketRepository.selectAllManagerTicket(authUser.getId(), sortOrder, Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), offset, limit);
608
				tickets = ticketRepository.selectAllManagerTicket(authUser.getId(), sortOrder,
-
 
609
						Optional.of(TicketStatus.CLOSED.equals(ticketStatus)), ticketSearchType, searchTerm, offset,
-
 
610
						limit);
-
 
611
			}
582
			authUserListMap = csService.getAuthUserList(tickets, authUser);
612
			authUserListMap = csService.getAuthUserList(tickets, authUser);
583
			if (tickets.size() > 0) {
613
			if (tickets.size() > 0) {
584
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
614
				Map<Integer, CustomRetailer> fofoIdsAndCustomRetailer = csService.getPartnerByFofoIds(tickets);
585
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
615
				model.addAttribute("fofoIdsAndCustomRetailer", fofoIdsAndCustomRetailer);
586
			}
616
			}