Package com.bytedesk.service.queue_member

Interface QueueMemberRepository

All Superinterfaces:

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

public interface QueueMemberRepository
extends org.springframework.data.jpa.repository.JpaRepository<QueueMemberEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<QueueMemberEntity>

Nested Class Summary

Nested classes/interfaces inherited from interface org.springframework.data.jpa.repository.JpaSpecificationExecutor

org.springframework.data.jpa.repository.JpaSpecificationExecutor.SpecificationFluentQuery<T extends Object>

Method Summary

Modifier and Type	Method	Description
Long	countByAgentUidAndDateBetween(String agentUid, ZonedDateTime startDate, ZonedDateTime endDate)
Long	countByOrgUidAndDateBetween(String orgUid, ZonedDateTime startDate, ZonedDateTime endDate)
Long	countByRobotUidAndDateBetween(String orgUid, String robotUid, ZonedDateTime startDate, ZonedDateTime endDate)
Long	countByWorkgroupUidAndDateBetween(String orgUid, String workgroupUid, ZonedDateTime startDate, ZonedDateTime endDate)
List<QueueMemberEntity>	findByOrgUidAndCreatedAtBetweenAndAgentAcceptType(String orgUid, ZonedDateTime startTime, ZonedDateTime endTime, String acceptType)
List<QueueMemberEntity>	findByOrgUidAndCreatedAtBetweenAndResolved(String orgUid, ZonedDateTime startTime, ZonedDateTime endTime, boolean resolved)
Optional<QueueMemberEntity>	findByThreadUid(String threadUid)
Optional<QueueMemberEntity>	findByUid(String uid)

Methods inherited from interface org.springframework.data.repository.CrudRepository

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

Methods inherited from interface org.springframework.data.jpa.repository.JpaRepository

deleteAllByIdInBatch, deleteAllInBatch, deleteAllInBatch, deleteInBatch, findAll, findAll, flush, getById, getOne, getReferenceById, saveAllAndFlush, saveAndFlush

Methods inherited from interface org.springframework.data.jpa.repository.JpaSpecificationExecutor

count, delete, exists, findAll, findAll, findAll, findAll, findBy, findOne

Methods inherited from interface org.springframework.data.repository.ListCrudRepository

findAll, findAllById, saveAll

Methods inherited from interface org.springframework.data.repository.ListPagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.PagingAndSortingRepository

findAll

Methods inherited from interface org.springframework.data.repository.query.QueryByExampleExecutor

count, exists, findAll, findBy, findOne

Method Details

findByUid

Optional<QueueMemberEntity> findByUid(String uid)

findByOrgUidAndCreatedAtBetweenAndResolved

List<QueueMemberEntity> findByOrgUidAndCreatedAtBetweenAndResolved(String orgUid,
 ZonedDateTime startTime,
 ZonedDateTime endTime,
 boolean resolved)

findByOrgUidAndCreatedAtBetweenAndAgentAcceptType

List<QueueMemberEntity> findByOrgUidAndCreatedAtBetweenAndAgentAcceptType(String orgUid,
 ZonedDateTime startTime,
 ZonedDateTime endTime,
 String acceptType)

findByThreadUid

@Query("SELECT qm FROM QueueMemberEntity qm WHERE qm.thread.uid = :threadUid")
Optional<QueueMemberEntity> findByThreadUid(@Param("threadUid")
 String threadUid)

countByOrgUidAndDateBetween

@Query("SELECT COUNT(qm) FROM QueueMemberEntity qm WHERE qm.orgUid = :orgUid AND qm.createdAt >= :startDate AND qm.createdAt <= :endDate")
Long countByOrgUidAndDateBetween(@Param("orgUid")
 String orgUid,
 @Param("startDate")
 ZonedDateTime startDate,
 @Param("endDate")
 ZonedDateTime endDate)

countByWorkgroupUidAndDateBetween

@Query("SELECT COUNT(qm) FROM QueueMemberEntity qm WHERE qm.orgUid = :orgUid AND qm.workgroupQueue IS NOT NULL AND qm.createdAt >= :startDate AND qm.createdAt <= :endDate")
Long countByWorkgroupUidAndDateBetween(@Param("orgUid")
 String orgUid,
 @Param("workgroupUid")
 String workgroupUid,
 @Param("startDate")
 ZonedDateTime startDate,
 @Param("endDate")
 ZonedDateTime endDate)

countByAgentUidAndDateBetween

@Query("SELECT COUNT(qm) FROM QueueMemberEntity qm WHERE qm.thread.agent LIKE CONCAT(\'%\', :agentUid, \'%\') AND qm.createdAt >= :startDate AND qm.createdAt <= :endDate")
Long countByAgentUidAndDateBetween(@Param("agentUid")
 String agentUid,
 @Param("startDate")
 ZonedDateTime startDate,
 @Param("endDate")
 ZonedDateTime endDate)

countByRobotUidAndDateBetween

@Query("SELECT COUNT(qm) FROM QueueMemberEntity qm WHERE qm.orgUid = :orgUid AND qm.robotQueue IS NOT NULL AND qm.createdAt >= :startDate AND qm.createdAt <= :endDate")
Long countByRobotUidAndDateBetween(@Param("orgUid")
 String orgUid,
 @Param("robotUid")
 String robotUid,
 @Param("startDate")
 ZonedDateTime startDate,
 @Param("endDate")
 ZonedDateTime endDate)