@@ 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 |