Package com.bytedesk.service.quality_check

Interface QualityCheckRepository

All Superinterfaces:

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

public interface QualityCheckRepository
extends org.springframework.data.jpa.repository.JpaRepository<QualityCheckEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<QualityCheckEntity>

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)
Boolean	existsByUid(String uid)
List<QualityCheckEntity>	findByAgentUidAndDateBetween(String agentUid, ZonedDateTime startDate, ZonedDateTime endDate)
List<QualityCheckEntity>	findByOrgUidAndDateBetween(String orgUid, ZonedDateTime startDate, ZonedDateTime endDate)
List<QualityCheckEntity>	findByRobotUidAndDateBetween(String orgUid, String robotUid, ZonedDateTime startDate, ZonedDateTime endDate)
Optional<QualityCheckEntity>	findByUid(String uid)
List<QualityCheckEntity>	findByWorkgroupUidAndDateBetween(String orgUid, String workgroupUid, ZonedDateTime startDate, ZonedDateTime endDate)

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<QualityCheckEntity> findByUid(String uid)

existsByUid

Boolean existsByUid(String uid)

countByOrgUidAndDateBetween

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

countByWorkgroupUidAndDateBetween

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

countByAgentUidAndDateBetween

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

countByRobotUidAndDateBetween

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

findByOrgUidAndDateBetween

@Query("SELECT qc FROM QualityCheckEntity qc WHERE qc.queueMember.orgUid = :orgUid AND qc.createdAt >= :startDate AND qc.createdAt <= :endDate")
List<QualityCheckEntity> findByOrgUidAndDateBetween(@Param("orgUid")
 String orgUid,
 @Param("startDate")
 ZonedDateTime startDate,
 @Param("endDate")
 ZonedDateTime endDate)

findByWorkgroupUidAndDateBetween

@Query("SELECT qc FROM QualityCheckEntity qc WHERE qc.queueMember.orgUid = :orgUid AND qc.queueMember.workgroupQueue IS NOT NULL AND qc.createdAt >= :startDate AND qc.createdAt <= :endDate")
List<QualityCheckEntity> findByWorkgroupUidAndDateBetween(@Param("orgUid")
 String orgUid,
 @Param("workgroupUid")
 String workgroupUid,
 @Param("startDate")
 ZonedDateTime startDate,
 @Param("endDate")
 ZonedDateTime endDate)

findByAgentUidAndDateBetween

@Query("SELECT qc FROM QualityCheckEntity qc WHERE qc.queueMember.thread.agent LIKE CONCAT(\'%\', :agentUid, \'%\') AND qc.createdAt >= :startDate AND qc.createdAt <= :endDate")
List<QualityCheckEntity> findByAgentUidAndDateBetween(@Param("agentUid")
 String agentUid,
 @Param("startDate")
 ZonedDateTime startDate,
 @Param("endDate")
 ZonedDateTime endDate)

findByRobotUidAndDateBetween

@Query("SELECT qc FROM QualityCheckEntity qc WHERE qc.queueMember.orgUid = :orgUid AND qc.queueMember.robotQueue IS NOT NULL AND qc.createdAt >= :startDate AND qc.createdAt <= :endDate")
List<QualityCheckEntity> findByRobotUidAndDateBetween(@Param("orgUid")
 String orgUid,
 @Param("robotUid")
 String robotUid,
 @Param("startDate")
 ZonedDateTime startDate,
 @Param("endDate")
 ZonedDateTime endDate)