|
@@ -21,7 +21,7 @@ discard block |
|
|
block discarded – undo |
|
21
|
21
|
private Security $security, |
|
22
|
22
|
private RequestStack $requestStack |
|
23
|
23
|
) { |
|
24
|
|
- $this->request = $requestStack->getCurrentRequest(); |
|
|
24
|
+ $this->request = $requestStack->getCurrentRequest(); |
|
25
|
25
|
} |
|
26
|
26
|
|
|
27
|
27
|
public function prePersist(People $people) |
|
@@ -121,29 +121,29 @@ discard block |
|
|
block discarded – undo |
|
121
|
121
|
public function checkLink(QueryBuilder $queryBuilder, $resourceClass = null, $applyTo = null, $rootAlias = null): void |
|
122
|
122
|
{ |
|
123
|
123
|
|
|
124
|
|
- $link = $this->request->query->get('link', null); |
|
|
124
|
+ $link = $this->request->query->get('link', null); |
|
125
|
125
|
$company = $this->request->query->get('company', null); |
|
126
|
126
|
$link_type = $this->request->query->get('link_type', null); |
|
127
|
127
|
|
|
128
|
128
|
if ($link_type) { |
|
129
|
|
- $queryBuilder->join(sprintf('%s.' . ($link ? 'company' : 'link'), $rootAlias), 'PeopleLink'); |
|
|
129
|
+ $queryBuilder->join(sprintf('%s.'.($link ? 'company' : 'link'), $rootAlias), 'PeopleLink'); |
|
130
|
130
|
$queryBuilder->andWhere('PeopleLink.link_type IN(:link_type)'); |
|
131
|
131
|
$queryBuilder->setParameter('link_type', $link_type); |
|
132
|
132
|
} |
|
133
|
133
|
|
|
134
|
134
|
if ($company || $link) { |
|
135
|
|
- $queryBuilder->andWhere('PeopleLink.' . ($link ? 'people' : 'company') . ' IN(:people)'); |
|
|
135
|
+ $queryBuilder->andWhere('PeopleLink.'.($link ? 'people' : 'company').' IN(:people)'); |
|
136
|
136
|
$queryBuilder->setParameter('people', preg_replace("/[^0-9]/", "", ($link ?: $company))); |
|
137
|
137
|
} |
|
138
|
138
|
} |
|
139
|
139
|
public function checkCompany($type, QueryBuilder $queryBuilder, $resourceClass = null, $applyTo = null, $rootAlias = null): void |
|
140
|
140
|
{ |
|
141
|
|
- $companies = $this->getMyCompanies(); |
|
142
|
|
- $queryBuilder->andWhere(sprintf('%s.' . $type . ' IN(:companies)', $rootAlias, $rootAlias)); |
|
|
141
|
+ $companies = $this->getMyCompanies(); |
|
|
142
|
+ $queryBuilder->andWhere(sprintf('%s.'.$type.' IN(:companies)', $rootAlias, $rootAlias)); |
|
143
|
143
|
$queryBuilder->setParameter('companies', $companies); |
|
144
|
144
|
|
|
145
|
145
|
if ($payer = $this->request->query->get('company', null)) { |
|
146
|
|
- $queryBuilder->andWhere(sprintf('%s.' . $type . ' IN(:people)', $rootAlias)); |
|
|
146
|
+ $queryBuilder->andWhere(sprintf('%s.'.$type.' IN(:people)', $rootAlias)); |
|
147
|
147
|
$queryBuilder->setParameter('people', preg_replace("/[^0-9]/", "", $payer)); |
|
148
|
148
|
} |
|
149
|
149
|
} |