| Line 16... |
Line 16... |
| 16 |
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
|
16 |
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;
|
| 17 |
import com.spice.profitmandi.dao.model.TicketViewModel;
|
17 |
import com.spice.profitmandi.dao.model.TicketViewModel;
|
| 18 |
|
18 |
|
| 19 |
@Repository
|
19 |
@Repository
|
| 20 |
public interface TicketRepository {
|
20 |
public interface TicketRepository {
|
| 21 |
void persist(Ticket ticket);
|
21 |
void persist(Ticket ticket);
|
| 22 |
|
22 |
|
| 23 |
Ticket selectById(int ticketId);
|
23 |
Ticket selectById(int ticketId);
|
| 24 |
|
24 |
|
| 25 |
List<Ticket> selectAllByAssignee(int assigneeId, Optional<Boolean> resolved, int offset, int limit);
|
25 |
List<Ticket> selectAllByAssignee(int assigneeId, Optional<Boolean> resolved, int offset, int limit);
|
| 26 |
|
26 |
|
| 27 |
List<Ticket> selectAllByCreator(int creatorId, Optional<Boolean> resolved, SortOrder sortOrder, int offset,
|
27 |
List<Ticket> selectAllByCreator(int creatorId, Optional<Boolean> resolved, SortOrder sortOrder);
|
| 28 |
int limit);
|
- |
|
| 29 |
|
28 |
|
| 30 |
List<Ticket> selectAll(int offset, int limit, Optional<Boolean> resolved);
|
29 |
List<Ticket> selectAll(int offset, int limit, Optional<Boolean> resolved);
|
| 31 |
|
30 |
|
| 32 |
List<Ticket> selectAllEscalated(Optional<Boolean> resolved, int offset, int limit);
|
31 |
List<Ticket> selectAllEscalated(Optional<Boolean> resolved, int offset, int limit);
|
| 33 |
|
32 |
|
| 34 |
List<Ticket> selectAllEscalatedByCreator(int fofoId, Optional<Boolean> resolved, int offset, int limit);
|
33 |
List<Ticket> selectAllEscalatedByCreator(int fofoId, Optional<Boolean> resolved, int offset, int limit);
|
| 35 |
|
34 |
|
| 36 |
List<Ticket> selectAllEscalatedByAssignee(int assigneId, Optional<Boolean> resolved, int offset, int limit);
|
35 |
List<Ticket> selectAllEscalatedByAssignee(int assigneId, Optional<Boolean> resolved, int offset, int limit);
|
| 37 |
|
36 |
|
| 38 |
public long selectAllCountByCreator(int creatorId, Optional<Boolean> resolved);
|
37 |
public long selectAllCountByCreator(int creatorId, Optional<Boolean> resolved);
|
| 39 |
|
38 |
|
| 40 |
public List<Ticket> selectAllByEscalatedUserType(int authUser, EscalationType escalationType, int offset,
|
39 |
public List<Ticket> selectAllByEscalatedUserType(int authUser, EscalationType escalationType, int offset, int limit);
|
| 41 |
int limit);
|
- |
|
| 42 |
|
40 |
|
| 43 |
public long selectAllCountByEscalatedUserType(int authUser, EscalationType escalationType);
|
41 |
public long selectAllCountByEscalatedUserType(int authUser, EscalationType escalationType);
|
| 44 |
|
42 |
|
| 45 |
public Long selectAllCount();
|
43 |
public Long selectAllCount();
|
| 46 |
|
44 |
|
| 47 |
public List<Ticket> selectAllNotClosedTickets();
|
45 |
public List<Ticket> selectAllNotClosedTickets();
|
| 48 |
|
46 |
|
| 49 |
public List<Ticket> selectAllOpenTicketByRetailer(int fofoId);
|
47 |
public List<Ticket> selectAllOpenTicketByRetailer(int fofoId);
|
| 50 |
|
48 |
|
| 51 |
public Map<Integer, Long> selectAllOpenTicketsGroupByRetailer();
|
49 |
public Map<Integer, Long> selectAllOpenTicketsGroupByRetailer();
|
| 52 |
|
50 |
|
| 53 |
public List<Ticket> selectAllByAssignee(int assigneeId, Optional<Boolean> resolved, SortOrder sortOrder,
|
51 |
public List<Ticket> selectAllByAssignee(int assigneeId, Optional<Boolean> resolved, SortOrder sortOrder, TicketSearchType ticketSearchType, int searchTerm);
|
| 54 |
TicketSearchType ticketSearchType, int searchTerm, int offset, int limit);
|
- |
|
| 55 |
|
52 |
|
| 56 |
public List<Ticket> selectAllByTicketIds(List<Integer> ticketIds);
|
53 |
public List<Ticket> selectAllByTicketIds(List<Integer> ticketIds);
|
| 57 |
|
54 |
|
| 58 |
public long selectAllCountByAssignee(int assigneeId, Optional<Boolean> resolved, TicketSearchType ticketSearchType,
|
55 |
public long selectAllCountByAssignee(int assigneeId, Optional<Boolean> resolved, TicketSearchType ticketSearchType, int searchTerm);
|
| 59 |
int searchTerm);
|
- |
|
| 60 |
|
56 |
|
| 61 |
public List<Ticket> selectAllManagerTicket(int authUserId, SortOrder sortOrder, Optional<Boolean> resolved,
|
57 |
public List<Ticket> selectAllManagerTicket(int authUserId, SortOrder sortOrder, Optional<Boolean> resolved, TicketSearchType ticketSearchType, int searchTerm);
|
| 62 |
TicketSearchType ticketSearchType, int searchTerm, int offset, int limit);
|
- |
|
| 63 |
|
58 |
|
| 64 |
public long selectAllCountByManagerTicket(int authUserId, Optional<Boolean> resolved,
|
59 |
public long selectAllCountByManagerTicket(int authUserId, Optional<Boolean> resolved, TicketSearchType ticketSearchType, int searchTerm);
|
| 65 |
TicketSearchType ticketSearchType, int searchTerm);
|
- |
|
| 66 |
|
60 |
|
| 67 |
public List<Ticket> selectAllResolvedMarkedTicketByCreator(int assigneeId);
|
61 |
public List<Ticket> selectAllResolvedMarkedTicketByCreator(int assigneeId);
|
| 68 |
|
62 |
|
| 69 |
public List<Ticket> selectAllNotClosedTicketsWithStatus(ActivityType activityType);
|
63 |
public List<Ticket> selectAllNotClosedTicketsWithStatus(ActivityType activityType);
|
| 70 |
|
64 |
|
| 71 |
public Map<AuthUser, Long> selectAllAuthUserTicketCount(Optional<Boolean> resolved);
|
65 |
public Map<AuthUser, Long> selectAllAuthUserTicketCount(Optional<Boolean> resolved);
|
| 72 |
|
66 |
|
| 73 |
public List<TicketViewModel> selectRecentClosedTicket(int fofoId, LocalDateTime startDate);
|
67 |
public List<TicketViewModel> selectRecentClosedTicket(int fofoId, LocalDateTime startDate);
|
| 74 |
}
|
68 |
}
|
| 75 |
|
69 |
|