Package com.bytedesk.service.workgroup

Interface WorkgroupRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<WorkgroupEntity,Long>, org.springframework.data.jpa.repository.JpaRepository<WorkgroupEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<WorkgroupEntity>, org.springframework.data.repository.ListCrudRepository<WorkgroupEntity,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<WorkgroupEntity,Long>, org.springframework.data.repository.PagingAndSortingRepository<WorkgroupEntity,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<WorkgroupEntity>, org.springframework.data.repository.Repository<WorkgroupEntity,Long>
public interface WorkgroupRepository extends org.springframework.data.jpa.repository.JpaRepository<WorkgroupEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<WorkgroupEntity>

  • 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)
     
    List<WorkgroupEntity>
    findByAgentsContaining(AgentEntity agent)
    查找包含指定客服的所有工作组
    List<WorkgroupEntity>
    findByAgentUid(String agentUid)
    通过客服UID查找包含该客服的所有工作组
    List<WorkgroupEntity>
    findByDeletedFalse()
     
    List<WorkgroupEntity>
    findByOrgUidAndDeletedFalse(String orgUid)
     
    Optional<WorkgroupEntity>
    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<WorkgroupEntity> findByUid(String uid)

    • existsByUid

      boolean existsByUid(String uid)

    • findByDeletedFalse

      List<WorkgroupEntity> findByDeletedFalse()

    • findByOrgUidAndDeletedFalse

      List<WorkgroupEntity> findByOrgUidAndDeletedFalse(String orgUid)

    • findByAgentsContaining

      List<WorkgroupEntity> findByAgentsContaining(AgentEntity agent)
      查找包含指定客服的所有工作组
      Parameters:
      agent - 客服实体
      Returns:
      包含该客服的工作组列表

    • findByAgentUid

      @Query("SELECT w FROM WorkgroupEntity w JOIN w.agents a WHERE a.uid = :agentUid") List<WorkgroupEntity> findByAgentUid(@Param("agentUid") String agentUid)
      通过客服UID查找包含该客服的所有工作组
      Parameters:
      agentUid - 客服UID
      Returns:
      包含该客服的工作组列表