Package com.bytedesk.service.quality_appeal

Interface QualityAppealRepository

All Superinterfaces:

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

public interface QualityAppealRepository
extends org.springframework.data.jpa.repository.JpaRepository<QualityAppealEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<QualityAppealEntity>

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

existsByUid

Boolean existsByUid(String uid)

countByOrgUidAndDateBetween

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

countByWorkgroupUidAndDateBetween

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

countByAgentUidAndDateBetween

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

countByRobotUidAndDateBetween

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