org.youngmonkeys.ezyplatform.admin.repo

Interface AdminAdminRepository

All Superinterfaces:

org.youngmonkeys.ezyplatform.repo.AdminRepository, com.tvd12.ezyfox.database.service.EzyCountSerivce, com.tvd12.ezyfox.database.service.EzyCrudService<Long,org.youngmonkeys.ezyplatform.entity.Admin>, com.tvd12.ezydata.database.EzyDatabaseRepository<Long,org.youngmonkeys.ezyplatform.entity.Admin>, com.tvd12.ezyfox.database.service.EzyDeleteAllService, com.tvd12.ezyfox.database.service.EzyDeleteByIdService<Long>, com.tvd12.ezyfox.database.service.EzyDeleteByIdsService<Long>, com.tvd12.ezyfox.database.service.EzyDeleteService<Long>, com.tvd12.ezyfox.database.repository.EzyEmptyRepository<Long,org.youngmonkeys.ezyplatform.entity.Admin>, com.tvd12.ezyfox.database.service.EzyFindAllService<org.youngmonkeys.ezyplatform.entity.Admin>, com.tvd12.ezyfox.database.service.EzyFindByField<org.youngmonkeys.ezyplatform.entity.Admin>, com.tvd12.ezyfox.database.service.EzyFindById<Long,org.youngmonkeys.ezyplatform.entity.Admin>, com.tvd12.ezyfox.database.service.EzyFindListByField<org.youngmonkeys.ezyplatform.entity.Admin>, com.tvd12.ezyfox.database.service.EzyFindListByIds<Long,org.youngmonkeys.ezyplatform.entity.Admin>, com.tvd12.ezyfox.database.service.EzyFindService<Long,org.youngmonkeys.ezyplatform.entity.Admin>, com.tvd12.ezyfox.database.service.EzySaveManyService<org.youngmonkeys.ezyplatform.entity.Admin>, com.tvd12.ezyfox.database.service.EzySaveOneSerivce<org.youngmonkeys.ezyplatform.entity.Admin>, com.tvd12.ezyfox.database.service.EzySaveService<org.youngmonkeys.ezyplatform.entity.Admin>

public interface AdminAdminRepository
extends org.youngmonkeys.ezyplatform.repo.AdminRepository, com.tvd12.ezydata.database.EzyDatabaseRepository<Long,org.youngmonkeys.ezyplatform.entity.Admin>

Field Summary

Fields inherited from interface com.tvd12.ezydata.database.EzyDatabaseRepository

CLASS, PREFIX_COUNT, PREFIX_COUNT_BY, PREFIX_DELETE, PREFIX_DELETE_BY, PREFIX_FETCH, PREFIX_FIND_BY, PREFIX_UPDATE

Method Summary

Modifier and Type	Method	Description
List<org.youngmonkeys.ezyplatform.entity.Admin>	findActiveSuperAdmins(com.tvd12.ezyfox.util.Next next)
List<org.youngmonkeys.ezyplatform.result.IdNameResult>	findAdminNamesByKeyword(String likeKeyword, com.tvd12.ezyfox.util.Next next)
List<org.youngmonkeys.ezyplatform.result.IdNameResult>	findAdminNamesByKeywordAndRoleIds(Collection<Long> roleIds, String likeKeyword, com.tvd12.ezyfox.util.Next next)
List<org.youngmonkeys.ezyplatform.result.IdNameResult>	findAdminNamesByKeywordAndRoleNames(Collection<String> roleNames, String likeKeyword, com.tvd12.ezyfox.util.Next next)
List<org.youngmonkeys.ezyplatform.result.IdNameResult>	findAdminNamesByKeywordPrefix(String keywordPrefix, com.tvd12.ezyfox.util.Next next)
List<org.youngmonkeys.ezyplatform.result.IdNameResult>	findAdminNamesByKeywordPrefixAndRoleIds(Collection<Long> roleIds, String keywordPrefix, com.tvd12.ezyfox.util.Next next)
List<org.youngmonkeys.ezyplatform.result.IdNameResult>	findAdminNamesByKeywordPrefixAndRoleNames(Collection<String> roleNames, String keywordPrefix, com.tvd12.ezyfox.util.Next next)
List<org.youngmonkeys.ezyplatform.entity.Admin>	findAdminsByRoleIds(Collection<Long> roleIds)
List<org.youngmonkeys.ezyplatform.entity.Admin>	findAdminsByRoleNames(Collection<String> roleNames)
List<org.youngmonkeys.ezyplatform.entity.Admin>	findAdminsByUpdatedAtAndIdPaginationAsc(LocalDateTime updatedAtInclusive, long idExclusive, com.tvd12.ezyfox.util.Next next)
org.youngmonkeys.ezyplatform.result.UpdatedAtValueResult	findFirstUpdatedAt()

Methods inherited from interface org.youngmonkeys.ezyplatform.repo.AdminRepository

findAdminAvatarCoverImageIdsById, findAdminIdByUuid, findAdminNameById, findAdminNamesByIds, findAdminUuidNameById, findAdminUuidNameByUuid, findAdminUuidNamesByIds, findAllAdminStatuses, findByUuidIn

Methods inherited from interface com.tvd12.ezyfox.database.service.EzyCountSerivce

count

Methods inherited from interface com.tvd12.ezyfox.database.service.EzySaveOneSerivce

save

Methods inherited from interface com.tvd12.ezyfox.database.service.EzySaveManyService

save, save

Methods inherited from interface com.tvd12.ezyfox.database.service.EzyFindById

containsById, findById, findByIdOptional

Methods inherited from interface com.tvd12.ezyfox.database.service.EzyFindListByIds

findListByIds

Methods inherited from interface com.tvd12.ezyfox.database.service.EzyFindByField

containsByField, findByField, findByFieldOptional

Methods inherited from interface com.tvd12.ezyfox.database.service.EzyFindListByField

findListByField, findListByField

Methods inherited from interface com.tvd12.ezyfox.database.service.EzyFindAllService

findAll, findAll

Methods inherited from interface com.tvd12.ezyfox.database.service.EzyDeleteAllService

deleteAll

Methods inherited from interface com.tvd12.ezyfox.database.service.EzyDeleteByIdService

delete

Methods inherited from interface com.tvd12.ezyfox.database.service.EzyDeleteByIdsService

deleteByIds

Method Detail

findAdminNamesByKeyword

@EzyQuery(value="SELECT e.id, e.username, e.displayName FROM Admin e WHERE e.phone LIKE CONCAT(\'%\',?0,\'%\') OR e.email LIKE CONCAT(\'%\',?0,\'%\') OR e.displayName LIKE CONCAT(\'%\',?0,\'%\') OR e.username LIKE CONCAT(\'%\',?0,\'%\')")
List<org.youngmonkeys.ezyplatform.result.IdNameResult> findAdminNamesByKeyword(String likeKeyword,
                                                                                                                                                                                                                                                                                                                              com.tvd12.ezyfox.util.Next next)

findAdminNamesByKeywordPrefix

@EzyQuery(value="SELECT e.id, e.username, e.displayName FROM Admin e INNER JOIN DataIndex a ON e.id = a.dataId WHERE a.dataType = \'ezy_admins\' AND a.keyword LIKE CONCAT(?0,\'%\')")
List<org.youngmonkeys.ezyplatform.result.IdNameResult> findAdminNamesByKeywordPrefix(String keywordPrefix,
                                                                                                                                                                                                                                                                            com.tvd12.ezyfox.util.Next next)

findAdminNamesByKeywordAndRoleIds

@EzyQuery(value="SELECT DISTINCT(e.id), e.username, e.displayName FROM Admin e INNER JOIN AdminRole a ON e.id = a.adminId WHERE a.roleId IN ?0 AND (e.phone LIKE CONCAT(\'%\',?1,\'%\') OR e.email LIKE CONCAT(\'%\',?1,\'%\') OR e.displayName LIKE CONCAT(\'%\',?1,\'%\') OR e.username LIKE CONCAT(\'%\',?1,\'%\'))")
List<org.youngmonkeys.ezyplatform.result.IdNameResult> findAdminNamesByKeywordAndRoleIds(Collection<Long> roleIds,
                                                                                                                                                                                                                                                                                                                                                                                                                  String likeKeyword,
                                                                                                                                                                                                                                                                                                                                                                                                                  com.tvd12.ezyfox.util.Next next)

findAdminNamesByKeywordPrefixAndRoleIds

@EzyQuery(value="SELECT DISTINCT(e.id), e.username, e.displayName FROM Admin e INNER JOIN AdminRole a ON e.id = a.adminId INNER JOIN DataIndex b ON e.id = b.dataId WHERE a.roleId IN ?0 AND b.dataType = \'ezy_admins\' AND b.keyword LIKE CONCAT(?1,\'%\')")
List<org.youngmonkeys.ezyplatform.result.IdNameResult> findAdminNamesByKeywordPrefixAndRoleIds(Collection<Long> roleIds,
                                                                                                                                                                                                                                                                                                                                                              String keywordPrefix,
                                                                                                                                                                                                                                                                                                                                                              com.tvd12.ezyfox.util.Next next)

findAdminNamesByKeywordAndRoleNames

@EzyQuery(value="SELECT DISTINCT(e.id), e.username, e.displayName FROM Admin e INNER JOIN AdminRole a ON e.id = a.adminId INNER JOIN AdminRoleName b ON b.id = a.roleId WHERE b.name IN ?0 AND (e.phone LIKE CONCAT(\'%\',?1,\'%\') OR e.email LIKE CONCAT(\'%\',?1,\'%\') OR e.displayName LIKE CONCAT(\'%\',?1,\'%\') OR e.username LIKE CONCAT(\'%\',?1,\'%\'))")
List<org.youngmonkeys.ezyplatform.result.IdNameResult> findAdminNamesByKeywordAndRoleNames(Collection<String> roleNames,
                                                                                                                                                                                                                                                                                                                                                                                                                                                                String likeKeyword,
                                                                                                                                                                                                                                                                                                                                                                                                                                                                com.tvd12.ezyfox.util.Next next)

findAdminNamesByKeywordPrefixAndRoleNames

@EzyQuery(value="SELECT DISTINCT(e.id), e.username, e.displayName FROM Admin e INNER JOIN AdminRole a ON e.id = a.adminId INNER JOIN AdminRoleName b ON b.id = a.roleId INNER JOIN DataIndex c ON e.id = c.dataId WHERE b.name IN ?0 AND c.dataType = \'ezy_admins\' AND c.keyword LIKE CONCAT(?1,\'%\')")
List<org.youngmonkeys.ezyplatform.result.IdNameResult> findAdminNamesByKeywordPrefixAndRoleNames(Collection<String> roleNames,
                                                                                                                                                                                                                                                                                                                                                                                                            String keywordPrefix,
                                                                                                                                                                                                                                                                                                                                                                                                            com.tvd12.ezyfox.util.Next next)

findActiveSuperAdmins

@EzyQuery(value="SELECT a FROM Admin a INNER JOIN AdminRole b ON a.id = b.adminId INNER JOIN AdminRoleName c ON b.roleId = c.id WHERE c.name = \'super_admin\' AND a.status = \'ACTIVATED\'")
List<org.youngmonkeys.ezyplatform.entity.Admin> findActiveSuperAdmins(com.tvd12.ezyfox.util.Next next)

findAdminsByRoleIds

@EzyQuery(value="SELECT DISTINCT a FROM Admin a INNER JOIN AdminRole b ON a.id = b.adminId WHERE b.roleId IN ?0")
List<org.youngmonkeys.ezyplatform.entity.Admin> findAdminsByRoleIds(Collection<Long> roleIds)

findAdminsByRoleNames

@EzyQuery(value="SELECT DISTINCT a FROM Admin a INNER JOIN AdminRole b ON a.id = b.adminId INNER JOIN AdminRoleName c ON b.roleId = c.id WHERE c.name IN ?0")
List<org.youngmonkeys.ezyplatform.entity.Admin> findAdminsByRoleNames(Collection<String> roleNames)

findAdminsByUpdatedAtAndIdPaginationAsc

@EzyQuery(value="SELECT e FROM Admin e WHERE e.updatedAt > ?0 OR (e.updatedAt = ?0 AND e.id > ?1)ORDER BY e.updatedAt ASC, e.id ASC")
List<org.youngmonkeys.ezyplatform.entity.Admin> findAdminsByUpdatedAtAndIdPaginationAsc(LocalDateTime updatedAtInclusive,
                                                                                                                                                                                                                              long idExclusive,
                                                                                                                                                                                                                              com.tvd12.ezyfox.util.Next next)

findFirstUpdatedAt

@EzyQuery(value="SELECT e.updatedAt FROM Admin e ORDER BY e.updatedAt ASC")
org.youngmonkeys.ezyplatform.result.UpdatedAtValueResult findFirstUpdatedAt()