org.youngmonkeys.ezyplatform.admin.repo

Interface AdminRoleRepository

All Superinterfaces:

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

public interface AdminRoleRepository
extends org.youngmonkeys.ezyplatform.repo.AdminIdRoleRepository, com.tvd12.ezydata.database.EzyDatabaseRepository<org.youngmonkeys.ezyplatform.entity.AdminRoleId,org.youngmonkeys.ezyplatform.entity.AdminRole>

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 and Description
int	countActiveAdminByRoleId(long roleId)
Optional<org.youngmonkeys.ezyplatform.entity.AdminRole>	findByAdminIdAndRoleName(long adminId, String roleName)
List<RoleAdminCountResult>	getAdminCountsByRoleIds(Collection<Long> roleIds)

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

findAdminIdsByRoleName

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

countActiveAdminByRoleId

@EzyQuery(value="SELECT count(*) FROM AdminRole a INNER JOIN Admin b ON a.adminId = b.id WHERE a.roleId = ?0 AND b.status = \'ACTIVATED\'")
int countActiveAdminByRoleId(long roleId)

findByAdminIdAndRoleName

@EzyQuery(value="SELECT a FROM AdminRole a INNER JOIN AdminRoleName b ON a.roleId = b.id INNER JOIN Admin c ON a.adminId = c.id WHERE a.adminId = ?0 AND b.name = ?1")
Optional<org.youngmonkeys.ezyplatform.entity.AdminRole> findByAdminIdAndRoleName(long adminId,
                                                                                                                                                                                                                                                        String roleName)

getAdminCountsByRoleIds

@EzyQuery(value="SELECT roleId, count(adminId) as adminCount FROM AdminRole WHERE roleId in ?0 GROUP BY roleId")
List<RoleAdminCountResult> getAdminCountsByRoleIds(Collection<Long> roleIds)