Index

Entity DAO com.soffid.iam.model.RoleAccountEntityDao [Entity]

• Description

DAO methods

• findAllByUserName

  select ra from com.soffid.iam.model.RoleAccountEntity ra
  join ra.account as account
  join account.users as users
  join users.user as user
  left join ra.role as role
  left join role.system as system
  where user.userName = :userName and user.tenant.id = :tenantId and ra.enabled = true
  order by system.name, role.name

  userName

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findAllRolAccountToEndDelegation

  Search delegations to end

  select ra from com.soffid.iam.model.RoleAccountEntity as ra
  where ra.delegateUntil < :now and ra.delegationStatus is not null and ra.role.system.tenant.id=:tenantId and ra.enabled = true

  now

  java.util.Date

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findAllRolAccountToStartDelegation

  Search delegations to start

  select ra from com.soffid.iam.model.RoleAccountEntity as ra
  where ra.delegateSince < :now and (ra.delegateUntil is null or ra.delegateUntil >= :now) and ra.delegationStatus = 'P' and ra.role.system.tenant.id=:tenantId and ra.enabled = true

  now

  java.util.Date

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findByGroupName

  select ra
  from com.soffid.iam.model.RoleAccountEntity ra
  where ra.group.name=:groupName and ra.group.tenant.id = :tenantId and ra.enabled = true

  groupName

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findByUserName

  select ra
  from com.soffid.iam.model.UserEntity user
  inner join user.accounts as accounts
  inner join accounts.account as account
  inner join account.roles as ra
  inner join ra.role as role
  inner join role.system as dispatcher
  where ra.enabled = true and account.type='U' and user.userName = :userName and user.tenant.id=:tenantId
  order by dispatcher.name, role.name
  

  userName

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findByQualifierGroup

  select ra from com.soffid.iam.model.RoleAccountEntity ra
  where ra.group.name=:groupName and ra.group.tenant.id=:tenantId and ra.enabled = true
  

  groupName

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findByInformationSystem

  Gets all granted roles for an information system

  select rolusu from com.soffid.iam.model.RoleAccountEntity rolusu join rolusu.account.users as users join users.user as user where rolusu.role.informationSystem.name = :informationSystem and rolusu.role.system.tenant.id = :tenantId and rolusu.enabled = true order by user.userName, rolusu.role.name, rolusu.role.system.name

  informationSystem

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findByQualifierIS

  select ra from com.soffid.iam.model.RoleAccountEntity ra
  where ra.informationSystem.name=:informationSystem and ra.role.system.tenant.id = :tenantId and ra.enabled = true
  

  informationSystem

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findByRoleAndDomainType

  select ra from com.soffid.iam.model.RoleAccountEntity ra
  left join ra.role role
  where role.name = :roleName and role.system.name = :systemName and
  role.informationSystem.name = :informationSystemName and ra.enabled = true and ra.domainType=:domainType and role.system.tenant.id = :tenantId

  roleName

  java.lang.String

  systemName

  java.lang.String

  informationSystemName

  java.lang.String

  domainType

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findByRoleAndDomainValue

  select ra
  from com.soffid.iam.model.RoleAccountEntity ra
  left join ra.role role
  left join ra.group as gr left join ra.informationSystem informationSystem
  left join ra.domainValue domainValue
  where (role.name = :roleName and role.system.name = :systemName) and
  ra.domainType=:domainType and ra.enabled = true and
  ( gr is null or :groupScope = gr.name) and
  ( informationSystem is null or :informationSystemScope = informationSystem.name) and
  ( domainValue is null or :domainValueId = domainValue.id) and role.system.tenant.id = :tenantId

  roleName

  java.lang.String

  systemName

  java.lang.String

  domainType

  java.lang.String

  groupScope

  java.lang.String

  informationSystemScope

  java.lang.String

  domainValueId

  java.lang.Long

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findByUserAndRule

  select ra from com.soffid.iam.model.RoleAccountEntity ra
  join ra.account.users as useraccount
  where ra.rule.id = :ruleId and useraccount.user.id = :userId and ra.account.type='U' and ra.account.system.tenant.id = :tenantId and ra.enabled = true order by ra.account.name

  userId

  java.lang.Long

  ruleId

  java.lang.Long

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findDelegatedRolAccounts

  Search delegations done by a user

  select ra from com.soffid.iam.model.RoleAccountEntity as ra
  join ra.ownerAccount.users as userAccount join userAccount.user as user where ra.delegationStatus='A' and user.userName = :user and user.tenant.id=:tenantId and ra.enabled = true

  user

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findHistoryByUserName

  select ra
  from com.soffid.iam.model.UserEntity user
  inner join user.accounts as accounts
  inner join accounts.account as account
  inner join account.roles as ra
  inner join ra.role as role
  inner join role.system as dispatcher
  where account.type='U' and user.userName = :userName and user.tenant.id=:tenantId
  order by dispatcher.name, role.name
  

  userName

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findMatching

  select rolsUsuaris from com.soffid.iam.model.RoleAccountEntity rolsUsuaris left join rolsUsuaris.group grup left join rolsUsuaris.informationSystem aplicacio left join rolsUsuaris.domainValue valorDominiAplicacio where rolsUsuaris.account.id = :accountId and rolsUsuaris.role.id = :roleId and (rolsUsuaris.domainType = :domainType) and ((:groupName is null and grup is null) or (grup.name = :groupName)) and ((:informationSystem is null and aplicacio is null) or (aplicacio.name = :informationSystem)) and ((:domainValue is null and valorDominiAplicacio is null) or (valorDominiAplicacio.value = :domainValue)) and rolsUsuaris.account.system.tenant.id = :tenantId and rolsUsuaris.enabled = true

  accountId

  java.lang.Long

  roleId

  java.lang.Long

  domainType

  java.lang.String

  groupName

  java.lang.String

  informationSystem

  java.lang.String

  domainValue

  java.lang.String

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findRolAccountToDisable

  select ra from com.soffid.iam.model.RoleAccountEntity ra
  where ra.endDate < :now and ra.enabled = true and ra.account.system.tenant.id = :tenantId

  now

  java.util.Date

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findRolAccountToEnable

  select ra from com.soffid.iam.model.RoleAccountEntity ra
  where ra.startDate < :now and (ra.endDate is null or ra.endDate >= :now) and ra.enabled = false and ra.account.system.tenant.id = :tenantId

  now

  java.util.Date

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findRoleAccountToEndDelegation

  Search delegations to end

  select ra from com.soffid.iam.model.RoleAccountEntity as ra
  join ra.delegateAccount.users as userAccount join userAccount.user as user where ra.delegateUntil < :now and ra.delegationStatus is not null and user.userName = :user and user.tenant.id=:tenantId and ra.enabled = true

  user

  java.lang.String

  now

  java.util.Date

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• findRoleAccountToStartDelegation

  Search delegations to start

  select ra from com.soffid.iam.model.RoleAccountEntity as ra
  join ra.delegateAccount.users as userAccount join userAccount.user as user where ra.delegateSince < :now and (ra.delegateUntil is null or ra.delegateUntil >= :now) and ra.delegationStatus = 'P' and user.userName = :user and user.tenant.id=:tenantId and ra.enabled = true

  user

  java.lang.String

  now

  java.util.Date

  Returns

  java.util.List< com.soffid.iam.model.RoleAccountEntity >
• update

  entity

  com.soffid.iam.model.RoleAccountEntity

  auditOperation

  java.lang.String

  Returns

  void

DAO Dependencies

• AccountEntity
• InformationSystemEntity
• AuditEntity
• SystemEntity
• GroupEntity
• IssueEntity
• EmailListEntity
• NoticeEntity
• RoleEntity
• RuleEntity
• TaskEntity
• UserEntity
• DomainValueEntity

Managed value objects

• ApplicationAdministration
• ContainerRole
• RoleAccount
• RoleGrant

Service Dependencies

2/28/24