Package com.bytedesk.service.quality_statistic

Interface QualityStatisticRepository

All Superinterfaces:

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

public interface QualityStatisticRepository
extends org.springframework.data.jpa.repository.JpaRepository<QualityStatisticEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<QualityStatisticEntity>

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
Boolean	existsByUid(String uid)
Optional<QualityStatisticEntity>	findByAgentUidAndDateAndDeletedFalse(String agentUid, String date)
List<QualityStatisticEntity>	findByChannelAndDeletedFalse(String channel)
Optional<QualityStatisticEntity>	findByOrgUidAndDateAndDeletedFalse(String orgUid, String date)
List<QualityStatisticEntity>	findByOrgUidAndDateBetween(String orgUid, String startDate, String endDate)
Optional<QualityStatisticEntity>	findByOrgUidAndTypeAndDateAndDeletedFalse(String orgUid, String type, String date)
Optional<QualityStatisticEntity>	findByRobotUidAndDateAndDeletedFalse(String robotUid, String date)
Optional<QualityStatisticEntity>	findByUid(String uid)
Optional<QualityStatisticEntity>	findByWorkgroupUidAndDateAndDeletedFalse(String workgroupUid, String date)

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

existsByUid

Boolean existsByUid(String uid)

findByOrgUidAndDateAndDeletedFalse

Optional<QualityStatisticEntity> findByOrgUidAndDateAndDeletedFalse(String orgUid,
 String date)

findByOrgUidAndTypeAndDateAndDeletedFalse

Optional<QualityStatisticEntity> findByOrgUidAndTypeAndDateAndDeletedFalse(String orgUid,
 String type,
 String date)

findByWorkgroupUidAndDateAndDeletedFalse

Optional<QualityStatisticEntity> findByWorkgroupUidAndDateAndDeletedFalse(String workgroupUid,
 String date)

findByAgentUidAndDateAndDeletedFalse

Optional<QualityStatisticEntity> findByAgentUidAndDateAndDeletedFalse(String agentUid,
 String date)

findByRobotUidAndDateAndDeletedFalse

Optional<QualityStatisticEntity> findByRobotUidAndDateAndDeletedFalse(String robotUid,
 String date)

findByOrgUidAndDateBetween

@Query("SELECT q FROM QualityStatisticEntity q WHERE q.orgUid = :orgUid AND q.date BETWEEN :startDate AND :endDate AND q.deleted = false")
List<QualityStatisticEntity> findByOrgUidAndDateBetween(@Param("orgUid")
 String orgUid,
 @Param("startDate")
 String startDate,
 @Param("endDate")
 String endDate)

findByChannelAndDeletedFalse

List<QualityStatisticEntity> findByChannelAndDeletedFalse(String channel)