| @@ 94-120 (lines=27) @@ | ||
| 91 | * @param InstitutionAuthorizationRepositoryFilter $authorizationRepositoryFilter |
|
| 92 | * @return Query |
|
| 93 | */ |
|
| 94 | public function createSearchQuery(VerifiedSecondFactorQuery $query) |
|
| 95 | { |
|
| 96 | $queryBuilder = $this->createQueryBuilder('sf'); |
|
| 97 | ||
| 98 | // Modify query to filter on authorization |
|
| 99 | $this->authorizationRepositoryFilter->filter($queryBuilder, $query->authorizationContext, 'sf.id', 'sf.institution', 'iac'); |
|
| 100 | ||
| 101 | if ($query->identityId) { |
|
| 102 | $queryBuilder |
|
| 103 | ->andWhere('sf.identityId = :identityId') |
|
| 104 | ->setParameter('identityId', (string) $query->identityId); |
|
| 105 | } |
|
| 106 | ||
| 107 | if ($query->secondFactorId) { |
|
| 108 | $queryBuilder |
|
| 109 | ->andWhere('sf.id = :secondFactorId') |
|
| 110 | ->setParameter('secondFactorId', (string) $query->secondFactorId); |
|
| 111 | } |
|
| 112 | ||
| 113 | if (is_string($query->registrationCode)) { |
|
| 114 | $queryBuilder |
|
| 115 | ->andWhere('sf.registrationCode = :registrationCode') |
|
| 116 | ->setParameter('registrationCode', $query->registrationCode); |
|
| 117 | } |
|
| 118 | ||
| 119 | return $queryBuilder->getQuery(); |
|
| 120 | } |
|
| 121 | ||
| 122 | public function removeByIdentityId(IdentityId $identityId) |
|
| 123 | { |
|
| @@ 74-101 (lines=28) @@ | ||
| 71 | * @param IdentityQuery $query |
|
| 72 | * @return \Doctrine\ORM\Query |
|
| 73 | */ |
|
| 74 | public function createSearchQuery( |
|
| 75 | IdentityQuery $query |
|
| 76 | ) { |
|
| 77 | $queryBuilder = $this->createQueryBuilder('i'); |
|
| 78 | ||
| 79 | // Modify query to filter on authorization |
|
| 80 | $this->authorizationRepositoryFilter->filter($queryBuilder, $query->authorizationContext, 'i.id', 'i.institution', 'iac'); |
|
| 81 | ||
| 82 | if ($query->nameId) { |
|
| 83 | $queryBuilder |
|
| 84 | ->andWhere('i.nameId = :nameId') |
|
| 85 | ->setParameter('nameId', $query->nameId); |
|
| 86 | } |
|
| 87 | ||
| 88 | if ($query->email) { |
|
| 89 | $queryBuilder |
|
| 90 | ->andWhere('MATCH_AGAINST(i.email, :email) > 0') |
|
| 91 | ->setParameter('email', $query->email); |
|
| 92 | } |
|
| 93 | ||
| 94 | if ($query->commonName) { |
|
| 95 | $queryBuilder |
|
| 96 | ->andWhere('MATCH_AGAINST(i.commonName, :commonName) > 0') |
|
| 97 | ->setParameter('commonName', $query->commonName); |
|
| 98 | } |
|
| 99 | ||
| 100 | return $queryBuilder->getQuery(); |
|
| 101 | } |
|
| 102 | ||
| 103 | /** |
|
| 104 | * @param string[] $nameIds |
|