Subversion Repositories SmartDukaan

package com.spice.profitmandi.dao.repository.cs;

import java.util.List;
import java.util.Optional;

import javax.swing.SortOrder;

import org.springframework.stereotype.Repository;

import com.spice.profitmandi.dao.entity.cs.Ticket;
import com.spice.profitmandi.dao.entity.cs.TicketSearchType;
import com.spice.profitmandi.dao.enumuration.cs.EscalationType;

@Repository
public interface TicketRepository {
        void persist(Ticket ticket);
        Ticket selectById(int ticketId);
        List<Ticket> selectAllByAssignee(int assigneeId, Optional<Boolean> resolved, int offset, int limit);
        List<Ticket> selectAllByCreator(int creatorId, Optional<Boolean> resolved,SortOrder sortOrder,int offset, int limit);
        List<Ticket> selectAll(int offset, int limit, Optional<Boolean> resolved);
        List<Ticket> selectAllEscalated(Optional<Boolean> resolved, int offset, int limit);
        List<Ticket> selectAllEscalatedByCreator(int fofoId, Optional<Boolean> resolved, int offset, int limit);
        List<Ticket> selectAllEscalatedByAssignee(int assigneId, Optional<Boolean> resolved, int offset, int limit);
        public long selectAllCountByCreator(int creatorId, Optional<Boolean> resolved);
        public List<Ticket> selectAllByEscalatedUserType(int authUser,EscalationType escalationType,int offset,int limit);
        public long selectAllCountByEscalatedUserType(int authUser,EscalationType escalationType);
        public Long selectAllCount();
        public List<Ticket> selectAllNotClosedTickets();
        public List<Ticket> selectAllByAssignee(int assigneeId, Optional<Boolean> resolved, SortOrder sortOrder,TicketSearchType ticketSearchType,int searchTerm, int offset,
                        int limit);
        public List<Ticket> selectAllByTicketIds(List<Integer> ticketIds);
        public long selectAllCountByAssignee(int assigneeId,Optional<Boolean> resolved,TicketSearchType ticketSearchType,int searchTerm);
        public List<Ticket> selectAllManagerTicket(int authUserId, SortOrder sortOrder,Optional<Boolean> resolved,TicketSearchType ticketSearchType,int searchTerm,int offset, int limit);
        public long selectAllCountByManagerTicket(int authUserId,Optional<Boolean> resolved,TicketSearchType ticketSearchType, int searchTerm);
        public List<Ticket> selectAllResolvedMarkedTicketByCreator(int assigneeId);     
}