Package com.bytedesk.call.users

Interface CallUserRepository

All Superinterfaces:
org.springframework.data.repository.CrudRepository<CallUserEntity,Long>, org.springframework.data.jpa.repository.JpaRepository<CallUserEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<CallUserEntity>, org.springframework.data.repository.ListCrudRepository<CallUserEntity,Long>, org.springframework.data.repository.ListPagingAndSortingRepository<CallUserEntity,Long>, org.springframework.data.repository.PagingAndSortingRepository<CallUserEntity,Long>, org.springframework.data.repository.query.QueryByExampleExecutor<CallUserEntity>, org.springframework.data.repository.Repository<CallUserEntity,Long>
public interface CallUserRepository extends org.springframework.data.jpa.repository.JpaRepository<CallUserEntity,Long>, org.springframework.data.jpa.repository.JpaSpecificationExecutor<CallUserEntity>
Call用户仓库接口

  • Method Details

    • findByUid

      Optional<CallUserEntity> findByUid(String uid)
      根据UID查找用户

    • findByUsername

      Optional<CallUserEntity> findByUsername(String username)
      根据用户名查找用户

    • findByUsernameAndDomain

      Optional<CallUserEntity> findByUsernameAndDomain(String username, String domain)
      根据用户名和域名查找用户

    • findByEmail

      List<CallUserEntity> findByEmail(String email)
      根据邮箱查找用户

    • findByEnabledTrue

      List<CallUserEntity> findByEnabledTrue()
      查找启用的用户

    • findByDomain

      List<CallUserEntity> findByDomain(String domain)
      根据域名查找用户

    • findByDomain

      org.springframework.data.domain.Page<CallUserEntity> findByDomain(String domain, org.springframework.data.domain.Pageable pageable)
      根据域名查找用户（分页）

    • findByAccountcode

      List<CallUserEntity> findByAccountcode(String accountcode)
      根据账户代码查找用户

    • existsByUsername

      boolean existsByUsername(String username)
      检查用户名是否存在

    • existsByUsernameAndDomain

      boolean existsByUsernameAndDomain(String username, String domain)
      检查用户名和域名组合是否存在

    • findByEnabledTrueAndLastRegisterAfter

      List<CallUserEntity> findByEnabledTrueAndLastRegisterAfter(ZonedDateTime cutoffTime)
      查找在线用户（最近指定时间内有注册记录）

    • countByDomain

      long countByDomain(String domain)
      统计域名下的用户数量

    • countByEnabledTrueAndLastRegisterAfter

      long countByEnabledTrueAndLastRegisterAfter(ZonedDateTime cutoffTime)
      统计在线用户数量

    • findOnlineNumbers

      @Query("SELECT u FROM CallUserEntity u WHERE u.enabled = true AND u.lastRegister > :cutoffTime") List<CallUserEntity> findOnlineNumbers(@Param("cutoffTime") ZonedDateTime cutoffTime)
      查找在线用户（最近5分钟内有注册记录）

    • findByUsernameContainingIgnoreCase

      org.springframework.data.domain.Page<CallUserEntity> findByUsernameContainingIgnoreCase(String username, org.springframework.data.domain.Pageable pageable)
      根据用户名模糊搜索

    • findByDisplayNameContainingIgnoreCase

      org.springframework.data.domain.Page<CallUserEntity> findByDisplayNameContainingIgnoreCase(String displayName, org.springframework.data.domain.Pageable pageable)
      根据显示名称模糊搜索

    • countByEnabledTrue

      long countByEnabledTrue()
      统计启用的用户数量

    • countOnlineNumbers

      @Query("SELECT COUNT(u) FROM CallUserEntity u WHERE u.enabled = true AND u.lastRegister > :cutoffTime") long countOnlineNumbers(@Param("cutoffTime") ZonedDateTime cutoffTime)
      统计在线用户数量

    • updateLastRegister

      @Query("UPDATE CallUserEntity u SET u.lastRegister = :registerTime, u.registerIp = :registerIp WHERE u.username = :username AND u.domain = :domain") int updateLastRegister(@Param("username") String username, @Param("domain") String domain, @Param("registerTime") ZonedDateTime registerTime, @Param("registerIp") String registerIp)
      更新用户最后注册时间和IP