io.xiaper.jpa.repository

接口 ThreadRepository

所有超级接口:

org.springframework.data.repository.CrudRepository<Thread,Long>, org.springframework.data.jpa.repository.JpaRepository<Thread,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor, org.springframework.data.repository.PagingAndSortingRepository<Thread,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<Thread>, org.springframework.data.repository.Repository<Thread,Long>

@Repository
public interface ThreadRepository
extends org.springframework.data.jpa.repository.JpaRepository<Thread,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor

作者:

xiaper.io

方法概要

限定符和类型	方法和说明
Long	countByAgentsContainsAndClosed(User agent, boolean closed)
List<Thread>	findByAgentAndClosed(User agent, boolean closed)
List<Thread>	findByAgentAndTypeAndDeletedSetNotContains(User agent, String type, User user)
org.springframework.data.domain.Page<Thread>	findByAgentsContainsAndClosed(User agent, boolean closed, org.springframework.data.domain.Pageable pageable)
List<Thread>	findByClosed(boolean close) 所有结束/未结束会话
List<Thread>	findByCreatedAtBetween(Date startAt, Date endAt) 某个时间段内进入的会话thread
List<Thread>	findByGroup_MembersContainsAndGroup_DismissedAndType(User user, boolean dismissed, String type)
List<Thread>	findByStartedAtBetweenAndType(Date startAt, Date endAt, String type) 某个时间段内开始的客服会话
Optional<Thread>	findByTid(String tid)
org.springframework.data.domain.Page<Thread>	findByTimestampAfterAndAgentsContains(Date timestamp, User agent, org.springframework.data.domain.Pageable pageable) 找出某个客服*时间至现在的所有会话
List<Thread>	findByTimestampBeforeAndTypeAndClosedOrderByIdAsc(Date timestamp, String type, boolean closed) 查询某个时间点之前，而且是否关闭的会话
Optional<Thread>	findByTypeAndAgentsContainsAndAgentsContains(String type, User agent1, User agent2) 查询一对一会话的thread
org.springframework.data.domain.Page<Thread>	findByVisitor(User visitor, org.springframework.data.domain.Pageable pageable)
List<Thread>	findByVisitorAndClosed(User visitor, boolean closed)
List<Thread>	findByVisitorAndSessionIdAndClosed(User visitor, String sessionId, boolean closed)
org.springframework.data.domain.Page<Thread>	findByWorkGroup_UserAndClosedAndAgentNotNull(User user, boolean closed, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<Thread>	findByWorkGroup_UserAndClosedAndAgentNotNullOrAgentOrAgent_User(User user, boolean closed, User user1, User user2, org.springframework.data.domain.Pageable pageable)
org.springframework.data.domain.Page<Thread>	findByWorkGroup_UsersContainsAndClosedAndWorkGroup_AdminAndAgentNotNull(User user, boolean closed, User admin, org.springframework.data.domain.Pageable pageable)
Optional<Thread>	findFirstByContactAndAgent(User contact, User agent)
Optional<Thread>	findFirstByGroup(Group group)
Optional<Thread>	findFirstByVisitorAndAgentAndAppointedAndClosed(User visitor, User agent, boolean appointed, boolean closed)
Optional<Thread>	findFirstByVisitorAndWorkGroupAndAppointedAndClosed(User visitor, WorkGroup workGroup, boolean appointed, boolean closed)

从接口继承的方法 org.springframework.data.jpa.repository.JpaRepository

deleteAllInBatch, deleteInBatch, findAll, findAll, findAll, findAll, findAllById, flush, getOne, saveAll, saveAndFlush

从接口继承的方法 org.springframework.data.repository.PagingAndSortingRepository

findAll

从接口继承的方法 org.springframework.data.repository.CrudRepository

count, delete, deleteAll, deleteAll, deleteById, existsById, findById, save

从接口继承的方法 org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findOne

从接口继承的方法 org.springframework.data.jpa.repository.JpaSpecificationExecutor

count, findAll, findAll, findAll, findOne

方法详细资料

findFirstByVisitorAndWorkGroupAndAppointedAndClosed

Optional<Thread> findFirstByVisitorAndWorkGroupAndAppointedAndClosed(User visitor,
                                                                     WorkGroup workGroup,
                                                                     boolean appointed,
                                                                     boolean closed)

findFirstByVisitorAndAgentAndAppointedAndClosed

Optional<Thread> findFirstByVisitorAndAgentAndAppointedAndClosed(User visitor,
                                                                 User agent,
                                                                 boolean appointed,
                                                                 boolean closed)

findByTid

Optional<Thread> findByTid(String tid)

findFirstByContactAndAgent

Optional<Thread> findFirstByContactAndAgent(User contact,
                                            User agent)

findFirstByGroup

Optional<Thread> findFirstByGroup(Group group)

findByAgentsContainsAndClosed

org.springframework.data.domain.Page<Thread> findByAgentsContainsAndClosed(User agent,
                                                                           boolean closed,
                                                                           org.springframework.data.domain.Pageable pageable)

findByWorkGroup_UserAndClosedAndAgentNotNull

org.springframework.data.domain.Page<Thread> findByWorkGroup_UserAndClosedAndAgentNotNull(User user,
                                                                                          boolean closed,
                                                                                          org.springframework.data.domain.Pageable pageable)

findByWorkGroup_UserAndClosedAndAgentNotNullOrAgentOrAgent_User

org.springframework.data.domain.Page<Thread> findByWorkGroup_UserAndClosedAndAgentNotNullOrAgentOrAgent_User(User user,
                                                                                                             boolean closed,
                                                                                                             User user1,
                                                                                                             User user2,
                                                                                                             org.springframework.data.domain.Pageable pageable)

findByWorkGroup_UsersContainsAndClosedAndWorkGroup_AdminAndAgentNotNull

org.springframework.data.domain.Page<Thread> findByWorkGroup_UsersContainsAndClosedAndWorkGroup_AdminAndAgentNotNull(User user,
                                                                                                                     boolean closed,
                                                                                                                     User admin,
                                                                                                                     org.springframework.data.domain.Pageable pageable)

findByVisitor

org.springframework.data.domain.Page<Thread> findByVisitor(User visitor,
                                                           org.springframework.data.domain.Pageable pageable)

findByTimestampAfterAndAgentsContains

org.springframework.data.domain.Page<Thread> findByTimestampAfterAndAgentsContains(Date timestamp,
                                                                                   User agent,
                                                                                   org.springframework.data.domain.Pageable pageable)

找出某个客服*时间至现在的所有会话

参数:

timestamp - 时间

agent - 客服

pageable - 分页

返回:

会话列表

findByTimestampBeforeAndTypeAndClosedOrderByIdAsc

List<Thread> findByTimestampBeforeAndTypeAndClosedOrderByIdAsc(Date timestamp,
                                                               String type,
                                                               boolean closed)

查询某个时间点之前，而且是否关闭的会话

参数:

timestamp - 时间

type - 类型

closed - 是否关闭

返回:

会话列表

findByCreatedAtBetween

List<Thread> findByCreatedAtBetween(Date startAt,
                                    Date endAt)

某个时间段内进入的会话thread

参数:

startAt - 开始时间

endAt - 结束时间

返回:

会话列表

findByStartedAtBetweenAndType

List<Thread> findByStartedAtBetweenAndType(Date startAt,
                                           Date endAt,
                                           String type)

某个时间段内开始的客服会话

参数:

startAt - 开始时间

endAt - 结束时间

type - 类型

返回:

会话列表

findByClosed

List<Thread> findByClosed(boolean close)

所有结束/未结束会话

参数:

close - 是否结束

返回:

会话

countByAgentsContainsAndClosed

Long countByAgentsContainsAndClosed(User agent,
                                    boolean closed)

findByVisitorAndClosed

List<Thread> findByVisitorAndClosed(User visitor,
                                    boolean closed)

findByVisitorAndSessionIdAndClosed

List<Thread> findByVisitorAndSessionIdAndClosed(User visitor,
                                                String sessionId,
                                                boolean closed)

findByAgentAndClosed

List<Thread> findByAgentAndClosed(User agent,
                                  boolean closed)

findByTypeAndAgentsContainsAndAgentsContains

Optional<Thread> findByTypeAndAgentsContainsAndAgentsContains(String type,
                                                              User agent1,
                                                              User agent2)

查询一对一会话的thread

参数:

type - 类型

agent1 - 客服

agent2 - 客服

返回:

会话

findByAgentAndTypeAndDeletedSetNotContains

List<Thread> findByAgentAndTypeAndDeletedSetNotContains(User agent,
                                                        String type,
                                                        User user)

findByGroup_MembersContainsAndGroup_DismissedAndType

List<Thread> findByGroup_MembersContainsAndGroup_DismissedAndType(User user,
                                                                  boolean dismissed,
                                                                  String type)