Interface CallConferenceRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<CallConferenceEntity,Long>, org.springframework.data.jpa.repository.JpaRepository<CallConferenceEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<CallConferenceEntity>, org.springframework.data.repository.ListCrudRepository<CallConferenceEntity,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<CallConferenceEntity,Long>, org.springframework.data.repository.PagingAndSortingRepository<CallConferenceEntity,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<CallConferenceEntity>, org.springframework.data.repository.Repository<CallConferenceEntity,Long>

public interface CallConferenceRepository extends org.springframework.data.jpa.repository.JpaRepository<CallConferenceEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<CallConferenceEntity>
Call会议室仓库接口
  • Method Details

    • findByUid

      根据UID查找会议室
    • findByConferenceName

      Optional<CallConferenceEntity> findByConferenceName(String conferenceName)
      根据会议室名称查找会议室
    • findByEnabledTrue

      List<CallConferenceEntity> findByEnabledTrue()
      查找启用的会议室
    • findByEnabledFalse

      List<CallConferenceEntity> findByEnabledFalse()
      查找禁用的会议室
    • findByCreator

      List<CallConferenceEntity> findByCreator(String creator)
      根据创建者查找会议室
    • findByRecordEnabledTrue

      List<CallConferenceEntity> findByRecordEnabledTrue()
      查找启用录音的会议室
    • findByConferenceNameContainingIgnoreCase

      org.springframework.data.domain.Page<CallConferenceEntity> findByConferenceNameContainingIgnoreCase(String conferenceName, org.springframework.data.domain.Pageable pageable)
      根据会议室名称模糊搜索
    • findByDescriptionContainingIgnoreCase

      org.springframework.data.domain.Page<CallConferenceEntity> findByDescriptionContainingIgnoreCase(String description, org.springframework.data.domain.Pageable pageable)
      根据描述模糊搜索
    • existsByConferenceName

      boolean existsByConferenceName(String conferenceName)
      检查会议室名称是否存在
    • findPasswordProtectedConferences

      @Query("SELECT c FROM CallConferenceEntity c WHERE c.password IS NOT NULL AND c.password != \'\'") List<CallConferenceEntity> findPasswordProtectedConferences()
      查找有密码保护的会议室
    • findPublicConferences

      @Query("SELECT c FROM CallConferenceEntity c WHERE c.password IS NULL OR c.password = \'\'") List<CallConferenceEntity> findPublicConferences()
      查找无密码保护的会议室
    • findByMaxMembersBetween

      List<CallConferenceEntity> findByMaxMembersBetween(Integer minMembers, Integer maxMembers)
      根据最大成员数量范围查找会议室
    • countByEnabledTrue

      long countByEnabledTrue()
      统计启用的会议室数量
    • countByRecordEnabledTrue

      long countByRecordEnabledTrue()
      统计启用录音的会议室数量
    • countByCreator

      long countByCreator(String creator)
      根据创建者统计会议室数量
    • findByCreatorAndEnabledTrue

      List<CallConferenceEntity> findByCreatorAndEnabledTrue(String creator)
      查找指定创建者的启用会议室
    • findConferencesWithMemberLimit

      @Query("SELECT c FROM CallConferenceEntity c WHERE c.maxMembers IS NOT NULL AND c.maxMembers > 0") List<CallConferenceEntity> findConferencesWithMemberLimit()
      查找有最大成员限制的会议室
    • findConferencesWithoutMemberLimit

      @Query("SELECT c FROM CallConferenceEntity c WHERE c.maxMembers IS NULL OR c.maxMembers <= 0") List<CallConferenceEntity> findConferencesWithoutMemberLimit()
      查找无成员限制的会议室