@@ -71,7 +71,7 @@ discard block |
||
| 71 | 71 | * @param IQueryBuilder $qb |
| 72 | 72 | * @param int $id |
| 73 | 73 | */ |
| 74 | - protected function limitToId(IQueryBuilder &$qb, $id) { |
|
| 74 | + protected function limitToId(IQueryBuilder & $qb, $id) { |
|
| 75 | 75 | $this->limitToDBField($qb, 'id', $id); |
| 76 | 76 | } |
| 77 | 77 | |
@@ -82,7 +82,7 @@ discard block |
||
| 82 | 82 | * @param IQueryBuilder $qb |
| 83 | 83 | * @param int $uniqueId |
| 84 | 84 | */ |
| 85 | - protected function limitToUniqueId(IQueryBuilder &$qb, $uniqueId) { |
|
| 85 | + protected function limitToUniqueId(IQueryBuilder & $qb, $uniqueId) { |
|
| 86 | 86 | $this->limitToDBField($qb, 'unique_id', $uniqueId); |
| 87 | 87 | } |
| 88 | 88 | |
@@ -93,7 +93,7 @@ discard block |
||
| 93 | 93 | * @param IQueryBuilder $qb |
| 94 | 94 | * @param string $token |
| 95 | 95 | */ |
| 96 | - protected function limitToToken(IQueryBuilder &$qb, $token) { |
|
| 96 | + protected function limitToToken(IQueryBuilder & $qb, $token) { |
|
| 97 | 97 | $this->limitToDBField($qb, 'token', $token); |
| 98 | 98 | } |
| 99 | 99 | |
@@ -106,7 +106,7 @@ discard block |
||
| 106 | 106 | * |
| 107 | 107 | * @internal param int $circleId |
| 108 | 108 | */ |
| 109 | - protected function limitToUserId(IQueryBuilder &$qb, $userId) { |
|
| 109 | + protected function limitToUserId(IQueryBuilder & $qb, $userId) { |
|
| 110 | 110 | $this->limitToDBField($qb, 'user_id', $userId); |
| 111 | 111 | } |
| 112 | 112 | |
@@ -117,7 +117,7 @@ discard block |
||
| 117 | 117 | * @param IQueryBuilder $qb |
| 118 | 118 | * @param string $circleUniqueId |
| 119 | 119 | */ |
| 120 | - protected function limitToCircleId(IQueryBuilder &$qb, $circleUniqueId) { |
|
| 120 | + protected function limitToCircleId(IQueryBuilder & $qb, $circleUniqueId) { |
|
| 121 | 121 | $this->limitToDBField($qb, 'circle_id', $circleUniqueId); |
| 122 | 122 | |
| 123 | 123 | } |
@@ -129,15 +129,15 @@ discard block |
||
| 129 | 129 | * @param IQueryBuilder $qb |
| 130 | 130 | * @param string $circleUniqueId |
| 131 | 131 | */ |
| 132 | - protected function limitToShortenUniqueId(IQueryBuilder &$qb, $circleUniqueId) { |
|
| 132 | + protected function limitToShortenUniqueId(IQueryBuilder & $qb, $circleUniqueId) { |
|
| 133 | 133 | $expr = $qb->expr(); |
| 134 | - $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : ''; |
|
| 134 | + $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : ''; |
|
| 135 | 135 | |
| 136 | 136 | $qb->andWhere( |
| 137 | 137 | $expr->eq( |
| 138 | 138 | $qb->createNamedParameter($circleUniqueId), |
| 139 | 139 | $qb->createFunction( |
| 140 | - 'LEFT(' . $pf . 'unique_id' . ', ' . Circle::UNIQUEID_SHORT_LENGTH . ')' |
|
| 140 | + 'LEFT('.$pf.'unique_id'.', '.Circle::UNIQUEID_SHORT_LENGTH.')' |
|
| 141 | 141 | ) |
| 142 | 142 | ) |
| 143 | 143 | ); |
@@ -151,7 +151,7 @@ discard block |
||
| 151 | 151 | * @param IQueryBuilder $qb |
| 152 | 152 | * @param int $groupId |
| 153 | 153 | */ |
| 154 | - protected function limitToGroupId(IQueryBuilder &$qb, $groupId) { |
|
| 154 | + protected function limitToGroupId(IQueryBuilder & $qb, $groupId) { |
|
| 155 | 155 | $this->limitToDBField($qb, 'group_id', $groupId); |
| 156 | 156 | } |
| 157 | 157 | |
@@ -162,7 +162,7 @@ discard block |
||
| 162 | 162 | * @param IQueryBuilder $qb |
| 163 | 163 | * @param string $name |
| 164 | 164 | */ |
| 165 | - protected function limitToName(IQueryBuilder &$qb, $name) { |
|
| 165 | + protected function limitToName(IQueryBuilder & $qb, $name) { |
|
| 166 | 166 | $this->limitToDBField($qb, 'name', $name); |
| 167 | 167 | } |
| 168 | 168 | |
@@ -174,12 +174,12 @@ discard block |
||
| 174 | 174 | * @param int $level |
| 175 | 175 | * @param string|array $pf |
| 176 | 176 | */ |
| 177 | - protected function limitToLevel(IQueryBuilder &$qb, $level, $pf = '') { |
|
| 177 | + protected function limitToLevel(IQueryBuilder & $qb, $level, $pf = '') { |
|
| 178 | 178 | $expr = $qb->expr(); |
| 179 | 179 | |
| 180 | 180 | if ($pf === '') { |
| 181 | - $p = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : ''; |
|
| 182 | - $qb->andWhere($expr->gte($p . 'level', $qb->createNamedParameter($level))); |
|
| 181 | + $p = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : ''; |
|
| 182 | + $qb->andWhere($expr->gte($p.'level', $qb->createNamedParameter($level))); |
|
| 183 | 183 | |
| 184 | 184 | return; |
| 185 | 185 | } |
@@ -194,7 +194,7 @@ discard block |
||
| 194 | 194 | if ($p === 'g' && !$this->leftJoinedNCGroupAndUser) { |
| 195 | 195 | continue; |
| 196 | 196 | } |
| 197 | - $orX->add($expr->gte($p . '.level', $qb->createNamedParameter($level))); |
|
| 197 | + $orX->add($expr->gte($p.'.level', $qb->createNamedParameter($level))); |
|
| 198 | 198 | } |
| 199 | 199 | |
| 200 | 200 | $qb->andWhere($orX); |
@@ -206,15 +206,15 @@ discard block |
||
| 206 | 206 | * |
| 207 | 207 | * @param IQueryBuilder $qb |
| 208 | 208 | */ |
| 209 | - protected function limitToMembersAndAlmost(IQueryBuilder &$qb) { |
|
| 209 | + protected function limitToMembersAndAlmost(IQueryBuilder & $qb) { |
|
| 210 | 210 | $expr = $qb->expr(); |
| 211 | 211 | |
| 212 | - $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : ''; |
|
| 212 | + $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : ''; |
|
| 213 | 213 | |
| 214 | 214 | $orX = $expr->orX(); |
| 215 | - $orX->add($expr->eq($pf . 'status', $qb->createNamedParameter(Member::STATUS_MEMBER))); |
|
| 216 | - $orX->add($expr->eq($pf . 'status', $qb->createNamedParameter(Member::STATUS_INVITED))); |
|
| 217 | - $orX->add($expr->eq($pf . 'status', $qb->createNamedParameter(Member::STATUS_REQUEST))); |
|
| 215 | + $orX->add($expr->eq($pf.'status', $qb->createNamedParameter(Member::STATUS_MEMBER))); |
|
| 216 | + $orX->add($expr->eq($pf.'status', $qb->createNamedParameter(Member::STATUS_INVITED))); |
|
| 217 | + $orX->add($expr->eq($pf.'status', $qb->createNamedParameter(Member::STATUS_REQUEST))); |
|
| 218 | 218 | |
| 219 | 219 | $qb->andWhere($orX); |
| 220 | 220 | } |
@@ -225,10 +225,10 @@ discard block |
||
| 225 | 225 | * @param string $field |
| 226 | 226 | * @param string|integer $value |
| 227 | 227 | */ |
| 228 | - private function limitToDBField(IQueryBuilder &$qb, $field, $value) { |
|
| 228 | + private function limitToDBField(IQueryBuilder & $qb, $field, $value) { |
|
| 229 | 229 | $expr = $qb->expr(); |
| 230 | - $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : ''; |
|
| 231 | - $qb->andWhere($expr->eq($pf . $field, $qb->createNamedParameter($value))); |
|
| 230 | + $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : ''; |
|
| 231 | + $qb->andWhere($expr->eq($pf.$field, $qb->createNamedParameter($value))); |
|
| 232 | 232 | } |
| 233 | 233 | |
| 234 | 234 | |
@@ -243,9 +243,9 @@ discard block |
||
| 243 | 243 | protected function limitToNCGroupUser(IQueryBuilder $qb, $userId = '') { |
| 244 | 244 | $expr = $qb->expr(); |
| 245 | 245 | |
| 246 | - $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : ''; |
|
| 246 | + $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : ''; |
|
| 247 | 247 | |
| 248 | - $and = $expr->andX($expr->eq($pf . 'group_id', 'ncgu.gid')); |
|
| 248 | + $and = $expr->andX($expr->eq($pf.'group_id', 'ncgu.gid')); |
|
| 249 | 249 | if ($userId !== '') { |
| 250 | 250 | $and->add($expr->eq('ncgu.uid', $qb->createNamedParameter($userId))); |
| 251 | 251 | } else { |
@@ -264,15 +264,15 @@ discard block |
||
| 264 | 264 | * |
| 265 | 265 | * @deprecated not used (14/07/17) |
| 266 | 266 | */ |
| 267 | - protected function rightJoinCircles(IQueryBuilder &$qb) { |
|
| 267 | + protected function rightJoinCircles(IQueryBuilder & $qb) { |
|
| 268 | 268 | $expr = $qb->expr(); |
| 269 | - $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : ''; |
|
| 269 | + $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : ''; |
|
| 270 | 270 | |
| 271 | 271 | $qb->from(self::TABLE_CIRCLES, 'c') |
| 272 | 272 | ->andWhere( |
| 273 | 273 | $expr->eq( |
| 274 | - $pf . 'circle_id', |
|
| 275 | - $qb->createFunction('LEFT(c.unique_id, ' . Circle::UNIQUEID_SHORT_LENGTH . ')') |
|
| 274 | + $pf.'circle_id', |
|
| 275 | + $qb->createFunction('LEFT(c.unique_id, '.Circle::UNIQUEID_SHORT_LENGTH.')') |
|
| 276 | 276 | ) |
| 277 | 277 | ); |
| 278 | 278 | } |
@@ -303,7 +303,7 @@ discard block |
||
| 303 | 303 | $expr->eq('ncgu.gid', 'g.group_id'), |
| 304 | 304 | $expr->eq( |
| 305 | 305 | 'g.circle_id', $qb->createFunction( |
| 306 | - 'LEFT(' . $field . ', ' . Circle::UNIQUEID_SHORT_LENGTH . ')' |
|
| 306 | + 'LEFT('.$field.', '.Circle::UNIQUEID_SHORT_LENGTH.')' |
|
| 307 | 307 | ) |
| 308 | 308 | ) |
| 309 | 309 | ) |