Subversion Repositories SmartDukaan

Rev

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

Rev 35592 Rev 35626
Line 75... Line 75...
75 
     * CRM users need to see ALL tickets to respond to partner communications.
 75 
     * CRM users need to see ALL tickets to respond to partner communications.
76 
     */
 76 
     */
77 
    List<Ticket> selectAllTickets(Optional<Boolean> resolved, SortOrder sortOrder, TicketSearchType ticketSearchType, int searchTerm);
 77 
    List<Ticket> selectAllTickets(Optional<Boolean> resolved, SortOrder sortOrder, TicketSearchType ticketSearchType, int searchTerm);
78 
 
 78 
 
79 
    long selectAllTicketsCount(Optional<Boolean> resolved, TicketSearchType ticketSearchType, int searchTerm);
 79 
    long selectAllTicketsCount(Optional<Boolean> resolved, TicketSearchType ticketSearchType, int searchTerm);
- 
 
 80 
 
- 
 
 81 
    /**
- 
 
 82 
     * Select all tickets with pagination, visibility filtering, and text search.
- 
 
 83 
     * Visibility logic: Show ticket if subcategory.visibility=true OR subcategory.categoryId is in userCategoryIds.
- 
 
 84 
     * Search covers: ticket ID, partner name, category name, subcategory name, creator name.
- 
 
 85 
     */
- 
 
 86 
    List<Ticket> selectAllTicketsPaginated(
- 
 
 87 
            Optional<Boolean> resolved,
- 
 
 88 
            SortOrder sortOrder,
- 
 
 89 
            TicketSearchType searchType,
- 
 
 90 
            int searchTerm,
- 
 
 91 
            String searchText,
- 
 
 92 
            List<Integer> userCategoryIds,
- 
 
 93 
            int offset,
- 
 
 94 
            int limit
- 
 
 95 
    );
- 
 
 96 
 
- 
 
 97 
    long selectAllTicketsPaginatedCount(
- 
 
 98 
            Optional<Boolean> resolved,
- 
 
 99 
            TicketSearchType searchType,
- 
 
 100 
            int searchTerm,
- 
 
 101 
            String searchText,
- 
 
 102 
            List<Integer> userCategoryIds
- 
 
 103 
    );
- 
 
 104 
 
- 
 
 105 
    /**
- 
 
 106 
     * Select tickets assigned to a user with pagination and text search.
- 
 
 107 
     */
- 
 
 108 
    List<Ticket> selectAllByAssigneePaginated(
- 
 
 109 
            int assigneeId,
- 
 
 110 
            Optional<Boolean> resolved,
- 
 
 111 
            SortOrder sortOrder,
- 
 
 112 
            TicketSearchType searchType,
- 
 
 113 
            int searchTerm,
- 
 
 114 
            String searchText,
- 
 
 115 
            int offset,
- 
 
 116 
            int limit
- 
 
 117 
    );
- 
 
 118 
 
- 
 
 119 
    long selectAllByAssigneePaginatedCount(
- 
 
 120 
            int assigneeId,
- 
 
 121 
            Optional<Boolean> resolved,
- 
 
 122 
            TicketSearchType searchType,
- 
 
 123 
            int searchTerm,
- 
 
 124 
            String searchText
- 
 
 125 
    );
- 
 
 126 
 
- 
 
 127 
    /**
- 
 
 128 
     * Select manager tickets with pagination and text search.
- 
 
 129 
     */
- 
 
 130 
    List<Ticket> selectAllManagerTicketPaginated(
- 
 
 131 
            int authUserId,
- 
 
 132 
            SortOrder sortOrder,
- 
 
 133 
            Optional<Boolean> resolved,
- 
 
 134 
            TicketSearchType searchType,
- 
 
 135 
            int searchTerm,
- 
 
 136 
            String searchText,
- 
 
 137 
            int offset,
- 
 
 138 
            int limit
- 
 
 139 
    );
- 
 
 140 
 
- 
 
 141 
    long selectAllCountByManagerTicketPaginated(
- 
 
 142 
            int authUserId,
- 
 
 143 
            Optional<Boolean> resolved,
- 
 
 144 
            TicketSearchType searchType,
- 
 
 145 
            int searchTerm,
- 
 
 146 
            String searchText
- 
 
 147 
    );
80 
}
 148 
}
81 

            149