Completed
Pull Request — master (#551)
by Maxence
03:07
created
lib/Db/CoreQueryBuilder.php 1 patch
Spacing   +55 added lines, -55 removed lines patch added patch discarded remove patch
@@ -162,16 +162,16 @@  discard block
 block discarded – undo
162 162
 		$this->generateMemberSelectAlias($alias, self::PREFIX_MEMBER)
163 163
 			 ->leftJoin(
164 164
 				 $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $alias,
165
-				 $expr->eq($alias . '.circle_id', $this->getDefaultSelectAlias() . '.unique_id')
165
+				 $expr->eq($alias.'.circle_id', $this->getDefaultSelectAlias().'.unique_id')
166 166
 			 );
167 167
 
168 168
 		// TODO: Check in big table if it is better to put condition in andWhere() or in LeftJoin()
169 169
 		$this->andWhere(
170 170
 			$expr->andX(
171
-				$expr->eq($alias . '.user_id', $this->createNamedParameter($member->getUserId())),
172
-				$expr->eq($alias . '.user_type', $this->createNamedParameter($member->getUserType())),
173
-				$expr->eq($alias . '.instance', $this->createNamedParameter($this->getInstance($member))),
174
-				$expr->gte($alias . '.level', $this->createNamedParameter($level))
171
+				$expr->eq($alias.'.user_id', $this->createNamedParameter($member->getUserId())),
172
+				$expr->eq($alias.'.user_type', $this->createNamedParameter($member->getUserType())),
173
+				$expr->eq($alias.'.instance', $this->createNamedParameter($this->getInstance($member))),
174
+				$expr->gte($alias.'.level', $this->createNamedParameter($level))
175 175
 			)
176 176
 		);
177 177
 	}
@@ -192,7 +192,7 @@  discard block
 block discarded – undo
192 192
 			 ->leftJoin(
193 193
 				 $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_CIRCLE, $alias,
194 194
 				 $expr->andX(
195
-					 $expr->eq($alias . '.unique_id', $this->getDefaultSelectAlias() . '.circle_id')
195
+					 $expr->eq($alias.'.unique_id', $this->getDefaultSelectAlias().'.circle_id')
196 196
 				 )
197 197
 			 );
198 198
 
@@ -222,8 +222,8 @@  discard block
 block discarded – undo
222 222
 			 ->leftJoin(
223 223
 				 $circleTableAlias, CoreRequestBuilder::TABLE_MEMBER, $alias,
224 224
 				 $expr->andX(
225
-					 $expr->eq($alias . '.circle_id', $circleTableAlias . '.unique_id'),
226
-					 $expr->eq($alias . '.level', $this->createNamedParameter(Member::LEVEL_OWNER))
225
+					 $expr->eq($alias.'.circle_id', $circleTableAlias.'.unique_id'),
226
+					 $expr->eq($alias.'.level', $this->createNamedParameter(Member::LEVEL_OWNER))
227 227
 				 )
228 228
 			 );
229 229
 	}
@@ -249,11 +249,11 @@  discard block
 block discarded – undo
249 249
 			 ->leftJoin(
250 250
 				 $aliasCircle, CoreRequestBuilder::TABLE_MEMBER, $alias,
251 251
 				 $expr->andX(
252
-					 $expr->eq($alias . '.circle_id', $aliasCircle . '.unique_id'),
253
-					 $expr->eq($alias . '.user_id', $this->createNamedParameter($initiator->getUserId())),
254
-					 $expr->eq($alias . '.user_type', $this->createNamedParameter($initiator->getUserType())),
252
+					 $expr->eq($alias.'.circle_id', $aliasCircle.'.unique_id'),
253
+					 $expr->eq($alias.'.user_id', $this->createNamedParameter($initiator->getUserId())),
254
+					 $expr->eq($alias.'.user_type', $this->createNamedParameter($initiator->getUserType())),
255 255
 					 $expr->eq(
256
-						 $alias . '.instance', $this->createNamedParameter($this->getInstance($initiator))
256
+						 $alias.'.instance', $this->createNamedParameter($this->getInstance($initiator))
257 257
 					 )
258 258
 				 )
259 259
 			 );
@@ -276,9 +276,9 @@  discard block
 block discarded – undo
276 276
 		$this->leftJoin(
277 277
 			$this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $alias,
278 278
 			$expr->andX(
279
-				$expr->eq($alias . '.circle_id', $this->getDefaultSelectAlias() . '.unique_id'),
280
-				$expr->eq($alias . '.instance', $this->createNamedParameter($instance)),
281
-				$expr->gte($alias . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER))
279
+				$expr->eq($alias.'.circle_id', $this->getDefaultSelectAlias().'.unique_id'),
280
+				$expr->eq($alias.'.instance', $this->createNamedParameter($instance)),
281
+				$expr->gte($alias.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER))
282 282
 			)
283 283
 		);
284 284
 	}
@@ -298,7 +298,7 @@  discard block
 block discarded – undo
298 298
 		$expr = $this->expr();
299 299
 		$this->leftJoin(
300 300
 			$this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $alias,
301
-			$expr->eq($alias . '.instance', $this->createNamedParameter($instance))
301
+			$expr->eq($alias.'.instance', $this->createNamedParameter($instance))
302 302
 		);
303 303
 	}
304 304
 
@@ -317,15 +317,15 @@  discard block
 block discarded – undo
317 317
 		// - 4 (Visible to everyone)
318 318
 		$orX = $expr->orX();
319 319
 		$orX->add(
320
-			$expr->andX($expr->gte($alias . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)))
320
+			$expr->andX($expr->gte($alias.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)))
321 321
 		);
322 322
 		$orX->add(
323 323
 			$expr->andX(
324
-				$expr->bitwiseAnd($aliasCircle . '.config', Circle::CFG_PERSONAL),
325
-				$expr->eq($alias . '.level', $this->createNamedParameter(Member::LEVEL_OWNER))
324
+				$expr->bitwiseAnd($aliasCircle.'.config', Circle::CFG_PERSONAL),
325
+				$expr->eq($alias.'.level', $this->createNamedParameter(Member::LEVEL_OWNER))
326 326
 			)
327 327
 		);
328
-		$orX->add($expr->bitwiseAnd($aliasCircle . '.config', Circle::CFG_VISIBLE));
328
+		$orX->add($expr->bitwiseAnd($aliasCircle.'.config', Circle::CFG_VISIBLE));
329 329
 		$this->andWhere($orX);
330 330
 
331 331
 
@@ -360,10 +360,10 @@  discard block
 block discarded – undo
360 360
 		$expr = $this->expr();
361 361
 
362 362
 		$orHidden = $expr->orX();
363
-		$orHidden->add($expr->bitwiseAnd($alias . '.config', Circle::CFG_SINGLE));
364
-		$orHidden->add($expr->bitwiseAnd($alias . '.config', Circle::CFG_HIDDEN));
365
-		$orHidden->add($expr->bitwiseAnd($alias . '.config', Circle::CFG_BACKEND));
366
-		$this->andWhere($this->createFunction('NOT') . $orHidden);
363
+		$orHidden->add($expr->bitwiseAnd($alias.'.config', Circle::CFG_SINGLE));
364
+		$orHidden->add($expr->bitwiseAnd($alias.'.config', Circle::CFG_HIDDEN));
365
+		$orHidden->add($expr->bitwiseAnd($alias.'.config', Circle::CFG_BACKEND));
366
+		$this->andWhere($this->createFunction('NOT').$orHidden);
367 367
 	}
368 368
 
369 369
 
@@ -392,33 +392,33 @@  discard block
 block discarded – undo
392 392
 
393 393
 		$orX = $expr->orX();
394 394
 		$orX->add(
395
-			$expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBAL_SCALE))
395
+			$expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBAL_SCALE))
396 396
 		);
397 397
 
398 398
 		$orExtOrPassive = $expr->orX();
399 399
 		$orExtOrPassive->add(
400
-			$expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))
400
+			$expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))
401 401
 		);
402 402
 		if (!$sensitive) {
403 403
 			$orExtOrPassive->add(
404
-				$expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))
404
+				$expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))
405 405
 			);
406 406
 		}
407 407
 
408 408
 		$andExternal = $expr->andX();
409 409
 		$andExternal->add($orExtOrPassive);
410
-		$andExternal->add($expr->isNotNull($aliasMembers . '.instance'));
410
+		$andExternal->add($expr->isNotNull($aliasMembers.'.instance'));
411 411
 
412 412
 		$orExtOrTrusted = $expr->orX();
413 413
 		$orExtOrTrusted->add($andExternal);
414 414
 		$orExtOrTrusted->add(
415
-			$expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED))
415
+			$expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED))
416 416
 		);
417 417
 
418 418
 		$andTrusted = $expr->andX();
419 419
 		$andTrusted->add($orExtOrTrusted);
420
-		$andTrusted->add($expr->bitwiseAnd($aliasCircle . '.config', Circle::CFG_FEDERATED));
421
-		$andTrusted->add($expr->emptyString($aliasOwner . '.instance'));
420
+		$andTrusted->add($expr->bitwiseAnd($aliasCircle.'.config', Circle::CFG_FEDERATED));
421
+		$andTrusted->add($expr->emptyString($aliasOwner.'.instance'));
422 422
 		$orX->add($andTrusted);
423 423
 
424 424
 		$this->andWhere($orX);
@@ -429,7 +429,7 @@  discard block
 block discarded – undo
429 429
 	 * @param int $flag
430 430
 	 */
431 431
 	public function filterConfig(int $flag): void {
432
-		$this->andWhere($this->expr()->bitwiseAnd($this->getDefaultSelectAlias() . '.config', $flag));
432
+		$this->andWhere($this->expr()->bitwiseAnd($this->getDefaultSelectAlias().'.config', $flag));
433 433
 	}
434 434
 
435 435
 
@@ -440,15 +440,15 @@  discard block
 block discarded – undo
440 440
 	 * @return $this
441 441
 	 */
442 442
 	private function generateCircleSelectAlias(string $alias, string $prefix): self {
443
-		$this->selectAlias($alias . '.unique_id', $prefix . 'unique_id')
444
-			 ->selectAlias($alias . '.name', $prefix . 'name')
445
-			 ->selectAlias($alias . '.alt_name', $prefix . 'alt_name')
446
-			 ->selectAlias($alias . '.description', $prefix . 'description')
447
-			 ->selectAlias($alias . '.settings', $prefix . 'settings')
448
-			 ->selectAlias($alias . '.config', $prefix . 'config')
449
-			 ->selectAlias($alias . '.contact_addressbook', $prefix . 'contact_addressbook')
450
-			 ->selectAlias($alias . '.contact_groupname', $prefix . 'contact_groupname')
451
-			 ->selectAlias($alias . '.creation', $prefix . 'creation');
443
+		$this->selectAlias($alias.'.unique_id', $prefix.'unique_id')
444
+			 ->selectAlias($alias.'.name', $prefix.'name')
445
+			 ->selectAlias($alias.'.alt_name', $prefix.'alt_name')
446
+			 ->selectAlias($alias.'.description', $prefix.'description')
447
+			 ->selectAlias($alias.'.settings', $prefix.'settings')
448
+			 ->selectAlias($alias.'.config', $prefix.'config')
449
+			 ->selectAlias($alias.'.contact_addressbook', $prefix.'contact_addressbook')
450
+			 ->selectAlias($alias.'.contact_groupname', $prefix.'contact_groupname')
451
+			 ->selectAlias($alias.'.creation', $prefix.'creation');
452 452
 
453 453
 		return $this;
454 454
 	}
@@ -460,20 +460,20 @@  discard block
 block discarded – undo
460 460
 	 * @return $this
461 461
 	 */
462 462
 	private function generateMemberSelectAlias(string $alias, string $prefix): self {
463
-		$this->selectAlias($alias . '.circle_id', $prefix . 'circle_id')
464
-			 ->selectAlias($alias . '.single_id', $prefix . 'single_id')
465
-			 ->selectAlias($alias . '.user_id', $prefix . 'user_id')
466
-			 ->selectAlias($alias . '.user_type', $prefix . 'user_type')
467
-			 ->selectAlias($alias . '.member_id', $prefix . 'member_id')
468
-			 ->selectAlias($alias . '.instance', $prefix . 'instance')
469
-			 ->selectAlias($alias . '.cached_name', $prefix . 'cached_name')
470
-			 ->selectAlias($alias . '.cached_update', $prefix . 'cached_update')
471
-			 ->selectAlias($alias . '.status', $prefix . 'status')
472
-			 ->selectAlias($alias . '.level', $prefix . 'level')
473
-			 ->selectAlias($alias . '.note', $prefix . 'note')
474
-			 ->selectAlias($alias . '.contact_id', $prefix . 'contact_id')
475
-			 ->selectAlias($alias . '.contact_meta', $prefix . 'contact_meta')
476
-			 ->selectAlias($alias . '.joined', $prefix . 'joined');
463
+		$this->selectAlias($alias.'.circle_id', $prefix.'circle_id')
464
+			 ->selectAlias($alias.'.single_id', $prefix.'single_id')
465
+			 ->selectAlias($alias.'.user_id', $prefix.'user_id')
466
+			 ->selectAlias($alias.'.user_type', $prefix.'user_type')
467
+			 ->selectAlias($alias.'.member_id', $prefix.'member_id')
468
+			 ->selectAlias($alias.'.instance', $prefix.'instance')
469
+			 ->selectAlias($alias.'.cached_name', $prefix.'cached_name')
470
+			 ->selectAlias($alias.'.cached_update', $prefix.'cached_update')
471
+			 ->selectAlias($alias.'.status', $prefix.'status')
472
+			 ->selectAlias($alias.'.level', $prefix.'level')
473
+			 ->selectAlias($alias.'.note', $prefix.'note')
474
+			 ->selectAlias($alias.'.contact_id', $prefix.'contact_id')
475
+			 ->selectAlias($alias.'.contact_meta', $prefix.'contact_meta')
476
+			 ->selectAlias($alias.'.joined', $prefix.'joined');
477 477
 
478 478
 		return $this;
479 479
 	}
Please login to merge, or discard this patch.
lib/Model/Member.php 1 patch
Spacing   +17 added lines, -17 removed lines patch added patch discarded remove patch
@@ -548,29 +548,29 @@  discard block
 block discarded – undo
548 548
 	 * @throws MemberNotFoundException
549 549
 	 */
550 550
 	public function importFromDatabase(array $data, string $prefix = ''): INC21QueryRow {
551
-		if (!array_key_exists($prefix . 'member_id', $data)) {
551
+		if (!array_key_exists($prefix.'member_id', $data)) {
552 552
 			throw new MemberNotFoundException();
553 553
 		}
554 554
 
555
-		$this->setId($this->get($prefix . 'member_id', $data));
556
-		$this->setCircleId($this->get($prefix . 'circle_id', $data));
557
-		$this->setSingleId($this->get($prefix . 'single_id', $data));
558
-		$this->setUserId($this->get($prefix . 'user_id', $data));
559
-		$this->setUserType($this->getInt($prefix . 'user_type', $data));
560
-		$this->setInstance($this->get($prefix . 'instance', $data));
561
-		$this->setLevel($this->getInt($prefix . 'level', $data));
562
-		$this->setStatus($this->get($prefix . 'status', $data));
563
-		$this->setCachedName($this->get($prefix . 'cached_name', $data));
564
-		$this->setNote($this->get($prefix . 'note', $data));
565
-		$this->setContactId($this->get($prefix . 'contact_id', $data));
566
-		$this->setContactMeta($this->get($prefix . 'contact_meta', $data));
567
-
568
-		$cachedUpdate = $this->get($prefix . 'cached_update', $data);
555
+		$this->setId($this->get($prefix.'member_id', $data));
556
+		$this->setCircleId($this->get($prefix.'circle_id', $data));
557
+		$this->setSingleId($this->get($prefix.'single_id', $data));
558
+		$this->setUserId($this->get($prefix.'user_id', $data));
559
+		$this->setUserType($this->getInt($prefix.'user_type', $data));
560
+		$this->setInstance($this->get($prefix.'instance', $data));
561
+		$this->setLevel($this->getInt($prefix.'level', $data));
562
+		$this->setStatus($this->get($prefix.'status', $data));
563
+		$this->setCachedName($this->get($prefix.'cached_name', $data));
564
+		$this->setNote($this->get($prefix.'note', $data));
565
+		$this->setContactId($this->get($prefix.'contact_id', $data));
566
+		$this->setContactMeta($this->get($prefix.'contact_meta', $data));
567
+
568
+		$cachedUpdate = $this->get($prefix.'cached_update', $data);
569 569
 		if ($cachedUpdate !== '') {
570 570
 			$this->setCachedUpdate(DateTime::createFromFormat('Y-m-d H:i:s', $cachedUpdate)->getTimestamp());
571 571
 		}
572 572
 
573
-		$joined = $this->get($prefix . 'joined', $data);
573
+		$joined = $this->get($prefix.'joined', $data);
574 574
 		if ($joined !== '') {
575 575
 			$this->setJoined(DateTime::createFromFormat('Y-m-d H:i:s', $joined)->getTimestamp());
576 576
 		}
@@ -599,7 +599,7 @@  discard block
 block discarded – undo
599 599
 
600 600
 		if (!$level) {
601 601
 			$all = implode(', ', array_values(self::$DEF_LEVEL));
602
-			throw new MemberLevelException('Available levels: ' . $all);
602
+			throw new MemberLevelException('Available levels: '.$all);
603 603
 		}
604 604
 
605 605
 		return (int)$level;
Please login to merge, or discard this patch.
lib/Model/Federated/RemoteInstance.php 1 patch
Spacing   +6 added lines, -6 removed lines patch added patch discarded remove patch
@@ -49,11 +49,11 @@  discard block
 block discarded – undo
49 49
 
50 50
 	use TArrayTools;
51 51
 
52
-	const TYPE_UNKNOWN = 'Unknown';    // not trusted
53
-	const TYPE_PASSIVE = 'Passive';    // Minimum information about Federated Circles are broadcasted if a member belongs to the circle.
54
-	const TYPE_EXTERNAL = 'External';  // info about Federated Circles and their members are broadcasted  if a member belongs to the circle.
55
-	const TYPE_TRUSTED = 'Trusted';    // everything about Federated Circles are broadcasted.
56
-	const TYPE_GLOBAL_SCALE = 'GlobalScale';  // every Circle is broadcasted,
52
+	const TYPE_UNKNOWN = 'Unknown'; // not trusted
53
+	const TYPE_PASSIVE = 'Passive'; // Minimum information about Federated Circles are broadcasted if a member belongs to the circle.
54
+	const TYPE_EXTERNAL = 'External'; // info about Federated Circles and their members are broadcasted  if a member belongs to the circle.
55
+	const TYPE_TRUSTED = 'Trusted'; // everything about Federated Circles are broadcasted.
56
+	const TYPE_GLOBAL_SCALE = 'GlobalScale'; // every Circle is broadcasted,
57 57
 
58 58
 	const TEST = 'test';
59 59
 	const INCOMING = 'incoming';
@@ -399,7 +399,7 @@  discard block
 block discarded – undo
399 399
 		];
400 400
 
401 401
 		if ($this->getAuthSigned() !== '') {
402
-			$data['auth-signed'] = $this->getAlgorithm() . ':' . $this->getAuthSigned();
402
+			$data['auth-signed'] = $this->getAlgorithm().':'.$this->getAuthSigned();
403 403
 		}
404 404
 
405 405
 		return array_filter(array_merge($data, parent::jsonSerialize()));
Please login to merge, or discard this patch.