@@ -244,7 +244,7 @@ discard block  | 
                                                    ||
| 244 | 244 | return $value;  | 
                                                        
| 245 | 245 | }  | 
                                                        
| 246 | 246 | |
| 247 | -		if (($value = $this->config->getSystemValue(Application::APP_ID . '.' . $key, '')) !== '') { | 
                                                        |
| 247 | +		if (($value = $this->config->getSystemValue(Application::APP_ID.'.'.$key, '')) !== '') { | 
                                                        |
| 248 | 248 | return $value;  | 
                                                        
| 249 | 249 | }  | 
                                                        
| 250 | 250 | |
@@ -478,7 +478,7 @@ discard block  | 
                                                    ||
| 478 | 478 | */  | 
                                                        
| 479 | 479 |  	public function getTrustedDomains(): array { | 
                                                        
| 480 | 480 | return array_map(  | 
                                                        
| 481 | -			function (string $address) { | 
                                                        |
| 481 | +			function(string $address) { | 
                                                        |
| 482 | 482 | return strtolower($address);  | 
                                                        
| 483 | 483 |  			}, $this->config->getSystemValue('trusted_domains', []) | 
                                                        
| 484 | 484 | );  | 
                                                        
@@ -514,7 +514,7 @@ discard block  | 
                                                    ||
| 514 | 514 | }  | 
                                                        
| 515 | 515 | |
| 516 | 516 |  		if (array_key_exists('port', $loopback)) { | 
                                                        
| 517 | - $loopbackCloudId = $loopback['host'] . ':' . $loopback['port'];  | 
                                                        |
| 517 | + $loopbackCloudId = $loopback['host'].':'.$loopback['port'];  | 
                                                        |
| 518 | 518 |  		} else { | 
                                                        
| 519 | 519 | $loopbackCloudId = $loopback['host'];  | 
                                                        
| 520 | 520 | }  | 
                                                        
@@ -553,13 +553,13 @@ discard block  | 
                                                    ||
| 553 | 553 | $path = $this->getAppValue(self::LOOPBACK_CLOUD_PATH);  | 
                                                        
| 554 | 554 | }  | 
                                                        
| 555 | 555 | |
| 556 | - $base = $scheme . '://' . $instance . $path;  | 
                                                        |
| 556 | + $base = $scheme.'://'.$instance.$path;  | 
                                                        |
| 557 | 557 | |
| 558 | 558 |  		if ($route === '') { | 
                                                        
| 559 | 559 | return $base;  | 
                                                        
| 560 | 560 | }  | 
                                                        
| 561 | 561 | |
| 562 | - return rtrim($base, '/') . $this->linkToRoute($route, $args);  | 
                                                        |
| 562 | + return rtrim($base, '/').$this->linkToRoute($route, $args);  | 
                                                        |
| 563 | 563 | }  | 
                                                        
| 564 | 564 | |
| 565 | 565 | |
@@ -664,7 +664,7 @@ discard block  | 
                                                    ||
| 664 | 664 |  	): string { | 
                                                        
| 665 | 665 | $name = ($displayName) ? $federatedUser->getDisplayName() : $federatedUser->getUserId();  | 
                                                        
| 666 | 666 |  		if ($federatedUser->getUserType() === Member::TYPE_MAIL) { | 
                                                        
| 667 | - return $name . ' ' . $this->displayInstance(  | 
                                                        |
| 667 | + return $name.' '.$this->displayInstance(  | 
                                                        |
| 668 | 668 | $federatedUser->getInstance(),  | 
                                                        
| 669 | 669 | self::DISPLAY_PARENTHESIS  | 
                                                        
| 670 | 670 | );  | 
                                                        
@@ -674,7 +674,7 @@ discard block  | 
                                                    ||
| 674 | 674 | return $name;  | 
                                                        
| 675 | 675 | }  | 
                                                        
| 676 | 676 | |
| 677 | - return $name . $this->displayInstance($federatedUser->getInstance(), self::DISPLAY_AT);  | 
                                                        |
| 677 | + return $name.$this->displayInstance($federatedUser->getInstance(), self::DISPLAY_AT);  | 
                                                        |
| 678 | 678 | }  | 
                                                        
| 679 | 679 | |
| 680 | 680 | /**  | 
                                                        
@@ -690,9 +690,9 @@ discard block  | 
                                                    ||
| 690 | 690 | |
| 691 | 691 |  		switch ($type) { | 
                                                        
| 692 | 692 | case self::DISPLAY_AT:  | 
                                                        
| 693 | - return '@' . $instance;  | 
                                                        |
| 693 | + return '@'.$instance;  | 
                                                        |
| 694 | 694 | case self::DISPLAY_PARENTHESIS:  | 
                                                        
| 695 | -				return '(' . $instance . ')'; | 
                                                        |
| 695 | +				return '('.$instance.')'; | 
                                                        |
| 696 | 696 | }  | 
                                                        
| 697 | 697 | |
| 698 | 698 | return $instance;  | 
                                                        
@@ -257,7 +257,7 @@ discard block  | 
                                                    ||
| 257 | 257 |  	public function getInstance(): string { | 
                                                        
| 258 | 258 | $instance = $this->getHost();  | 
                                                        
| 259 | 259 |  		if ($this->getPort() > 0) { | 
                                                        
| 260 | - $instance .= ':' . $this->getPort();  | 
                                                        |
| 260 | + $instance .= ':'.$this->getPort();  | 
                                                        |
| 261 | 261 | }  | 
                                                        
| 262 | 262 | |
| 263 | 263 | return $instance;  | 
                                                        
@@ -281,7 +281,7 @@ discard block  | 
                                                    ||
| 281 | 281 |  		if ($protocol === null) { | 
                                                        
| 282 | 282 |  			if (strpos($url, '/') > -1) { | 
                                                        
| 283 | 283 |  				[$address, $baseUrl] = explode('/', $url, 2); | 
                                                        
| 284 | -				$this->setBaseUrl('/' . $baseUrl); | 
                                                        |
| 284 | +				$this->setBaseUrl('/'.$baseUrl); | 
                                                        |
| 285 | 285 |  			} else { | 
                                                        
| 286 | 286 | $address = $url;  | 
                                                        
| 287 | 287 | }  | 
                                                        
@@ -391,7 +391,7 @@ discard block  | 
                                                    ||
| 391 | 391 | continue;  | 
                                                        
| 392 | 392 | }  | 
                                                        
| 393 | 393 | |
| 394 | -			$url = str_replace(':' . $k, $this->data[$k], $url); | 
                                                        |
| 394 | +			$url = str_replace(':'.$k, $this->data[$k], $url); | 
                                                        |
| 395 | 395 | }  | 
                                                        
| 396 | 396 | |
| 397 | 397 | return $url;  | 
                                                        
@@ -408,7 +408,7 @@ discard block  | 
                                                    ||
| 408 | 408 | continue;  | 
                                                        
| 409 | 409 | }  | 
                                                        
| 410 | 410 | |
| 411 | -			$url = str_replace(':' . $k, $this->params[$k], $url); | 
                                                        |
| 411 | +			$url = str_replace(':'.$k, $this->params[$k], $url); | 
                                                        |
| 412 | 412 | }  | 
                                                        
| 413 | 413 | |
| 414 | 414 | return $url;  | 
                                                        
@@ -419,7 +419,7 @@ discard block  | 
                                                    ||
| 419 | 419 | * @return string  | 
                                                        
| 420 | 420 | */  | 
                                                        
| 421 | 421 |  	public function getPath(): string { | 
                                                        
| 422 | - return $this->baseUrl . $this->url;  | 
                                                        |
| 422 | + return $this->baseUrl.$this->url;  | 
                                                        |
| 423 | 423 | }  | 
                                                        
| 424 | 424 | |
| 425 | 425 | |
@@ -436,9 +436,9 @@ discard block  | 
                                                    ||
| 436 | 436 | * @return string  | 
                                                        
| 437 | 437 | */  | 
                                                        
| 438 | 438 |  	public function getCompleteUrl(): string { | 
                                                        
| 439 | - $port = ($this->getPort() > 0) ? ':' . $this->getPort() : '';  | 
                                                        |
| 439 | + $port = ($this->getPort() > 0) ? ':'.$this->getPort() : '';  | 
                                                        |
| 440 | 440 | |
| 441 | - return $this->getUsedProtocol() . '://' . $this->getHost() . $port . $this->getParametersUrl();  | 
                                                        |
| 441 | + return $this->getUsedProtocol().'://'.$this->getHost().$port.$this->getParametersUrl();  | 
                                                        |
| 442 | 442 | }  | 
                                                        
| 443 | 443 | |
| 444 | 444 | |
@@ -453,7 +453,7 @@ discard block  | 
                                                    ||
| 453 | 453 |  	public function addHeader($key, $value): Request { | 
                                                        
| 454 | 454 | $header = $this->get($key, $this->headers);  | 
                                                        
| 455 | 455 |  		if ($header !== '') { | 
                                                        
| 456 | - $header .= ', ' . $value;  | 
                                                        |
| 456 | + $header .= ', '.$value;  | 
                                                        |
| 457 | 457 |  		} else { | 
                                                        
| 458 | 458 | $header = $value;  | 
                                                        
| 459 | 459 | }  | 
                                                        
@@ -683,11 +683,11 @@ discard block  | 
                                                    ||
| 683 | 683 | |
| 684 | 684 |  		switch ($this->getQueryStringType()) { | 
                                                        
| 685 | 685 | case self::QS_VAR_ARRAY:  | 
                                                        
| 686 | - return '?' . http_build_query($this->getParams());  | 
                                                        |
| 686 | + return '?'.http_build_query($this->getParams());  | 
                                                        |
| 687 | 687 | |
| 688 | 688 | case self::QS_VAR_DUPLICATE:  | 
                                                        
| 689 | 689 | default:  | 
                                                        
| 690 | - return '?' . preg_replace(  | 
                                                        |
| 690 | + return '?'.preg_replace(  | 
                                                        |
| 691 | 691 | '/%5B(?:[0-9]|[1-9][0-9]+)%5D=/', '=', http_build_query($this->getParams())  | 
                                                        
| 692 | 692 | );  | 
                                                        
| 693 | 693 | }  | 
                                                        
@@ -91,7 +91,7 @@  | 
                                                    ||
| 91 | 91 | RequestResultNotJsonException $e  | 
                                                        
| 92 | 92 |  		) { | 
                                                        
| 93 | 93 | $this->miscService->log(  | 
                                                        
| 94 | - 'Issue while search users from lookup: ' . get_class($e) . ' ' . $e->getMessage()  | 
                                                        |
| 94 | + 'Issue while search users from lookup: '.get_class($e).' '.$e->getMessage()  | 
                                                        |
| 95 | 95 | );  | 
                                                        
| 96 | 96 | |
| 97 | 97 | return [];  | 
                                                        
@@ -245,7 +245,7 @@ discard block  | 
                                                    ||
| 245 | 245 | }  | 
                                                        
| 246 | 246 | |
| 247 | 247 | $expr = $qb->expr();  | 
                                                        
| 248 | - $pf = '' . $this->default_select_alias . '.';  | 
                                                        |
| 248 | + $pf = ''.$this->default_select_alias.'.';  | 
                                                        |
| 249 | 249 | |
| 250 | 250 | /** @noinspection PhpMethodParametersCountMismatchInspection */  | 
                                                        
| 251 | 251 |  		$qb->selectAlias('u.user_id', 'viewer_userid') | 
                                                        
@@ -259,7 +259,7 @@ discard block  | 
                                                    ||
| 259 | 259 | ->leftJoin(  | 
                                                        
| 260 | 260 | $this->default_select_alias, DeprecatedRequestBuilder::TABLE_MEMBERS, 'u',  | 
                                                        
| 261 | 261 | $expr->andX(  | 
                                                        
| 262 | -		   		$expr->eq('u.circle_id', $pf . 'unique_id'), | 
                                                        |
| 262 | +		   		$expr->eq('u.circle_id', $pf.'unique_id'), | 
                                                        |
| 263 | 263 |  		   		$expr->eq('u.user_id', $qb->createNamedParameter($userId)), | 
                                                        
| 264 | 264 |  		   		$expr->eq('u.instance', $qb->createNamedParameter($instanceId)), | 
                                                        
| 265 | 265 |  		   		$expr->eq('u.user_type', $qb->createNamedParameter($type)) | 
                                                        
@@ -280,7 +280,7 @@ discard block  | 
                                                    ||
| 280 | 280 | }  | 
                                                        
| 281 | 281 | |
| 282 | 282 | $expr = $qb->expr();  | 
                                                        
| 283 | - $pf = $this->default_select_alias . '.';  | 
                                                        |
| 283 | + $pf = $this->default_select_alias.'.';  | 
                                                        |
| 284 | 284 | |
| 285 | 285 | /** @noinspection PhpMethodParametersCountMismatchInspection */  | 
                                                        
| 286 | 286 |  		$qb->selectAlias('o.user_id', 'owner_userid') | 
                                                        
@@ -293,7 +293,7 @@ discard block  | 
                                                    ||
| 293 | 293 | ->leftJoin(  | 
                                                        
| 294 | 294 | $this->default_select_alias, DeprecatedRequestBuilder::TABLE_MEMBERS, 'o',  | 
                                                        
| 295 | 295 | $expr->andX(  | 
                                                        
| 296 | -		   		$expr->eq('o.circle_id', $pf . 'unique_id'), | 
                                                        |
| 296 | +		   		$expr->eq('o.circle_id', $pf.'unique_id'), | 
                                                        |
| 297 | 297 |  		   		$expr->eq('o.level', $qb->createNamedParameter(DeprecatedMember::LEVEL_OWNER)), | 
                                                        
| 298 | 298 |  		   		$expr->eq('o.user_type', $qb->createNamedParameter(DeprecatedMember::TYPE_USER)) | 
                                                        
| 299 | 299 | )  | 
                                                        
@@ -346,8 +346,8 @@ discard block  | 
                                                    ||
| 346 | 346 | $expr = $qb->expr();  | 
                                                        
| 347 | 347 | |
| 348 | 348 |  		if ($pf === '') { | 
                                                        
| 349 | - $p = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : '';  | 
                                                        |
| 350 | - $qb->andWhere($expr->gte($p . 'level', $qb->createNamedParameter($level)));  | 
                                                        |
| 349 | + $p = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : '';  | 
                                                        |
| 350 | + $qb->andWhere($expr->gte($p.'level', $qb->createNamedParameter($level)));  | 
                                                        |
| 351 | 351 | |
| 352 | 352 | return;  | 
                                                        
| 353 | 353 | }  | 
                                                        
@@ -376,7 +376,7 @@ discard block  | 
                                                    ||
| 376 | 376 |  			if ($p === 'g' && !$this->leftJoinedNCGroupAndUser) { | 
                                                        
| 377 | 377 | continue;  | 
                                                        
| 378 | 378 | }  | 
                                                        
| 379 | - $orX->add($expr->gte($p . '.level', $qb->createNamedParameter($level)));  | 
                                                        |
| 379 | + $orX->add($expr->gte($p.'.level', $qb->createNamedParameter($level)));  | 
                                                        |
| 380 | 380 | }  | 
                                                        
| 381 | 381 | |
| 382 | 382 | return $orX;  | 
                                                        
@@ -391,12 +391,12 @@ discard block  | 
                                                    ||
| 391 | 391 |  	protected function limitToMembersAndAlmost(IQueryBuilder $qb) { | 
                                                        
| 392 | 392 | $expr = $qb->expr();  | 
                                                        
| 393 | 393 | |
| 394 | - $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : '';  | 
                                                        |
| 394 | + $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : '';  | 
                                                        |
| 395 | 395 | |
| 396 | 396 | $orX = $expr->orX();  | 
                                                        
| 397 | - $orX->add($expr->eq($pf . 'status', $qb->createNamedParameter(DeprecatedMember::STATUS_MEMBER)));  | 
                                                        |
| 398 | - $orX->add($expr->eq($pf . 'status', $qb->createNamedParameter(DeprecatedMember::STATUS_INVITED)));  | 
                                                        |
| 399 | - $orX->add($expr->eq($pf . 'status', $qb->createNamedParameter(DeprecatedMember::STATUS_REQUEST)));  | 
                                                        |
| 397 | + $orX->add($expr->eq($pf.'status', $qb->createNamedParameter(DeprecatedMember::STATUS_MEMBER)));  | 
                                                        |
| 398 | + $orX->add($expr->eq($pf.'status', $qb->createNamedParameter(DeprecatedMember::STATUS_INVITED)));  | 
                                                        |
| 399 | + $orX->add($expr->eq($pf.'status', $qb->createNamedParameter(DeprecatedMember::STATUS_REQUEST)));  | 
                                                        |
| 400 | 400 | |
| 401 | 401 | $qb->andWhere($orX);  | 
                                                        
| 402 | 402 | }  | 
                                                        
@@ -409,8 +409,8 @@ discard block  | 
                                                    ||
| 409 | 409 | */  | 
                                                        
| 410 | 410 |  	public function limitToDBField(IQueryBuilder $qb, $field, $value) { | 
                                                        
| 411 | 411 | $expr = $qb->expr();  | 
                                                        
| 412 | - $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : '';  | 
                                                        |
| 413 | - $qb->andWhere($expr->eq($pf . $field, $qb->createNamedParameter($value)));  | 
                                                        |
| 412 | + $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : '';  | 
                                                        |
| 413 | + $qb->andWhere($expr->eq($pf.$field, $qb->createNamedParameter($value)));  | 
                                                        |
| 414 | 414 | }  | 
                                                        
| 415 | 415 | |
| 416 | 416 | |
@@ -421,8 +421,8 @@ discard block  | 
                                                    ||
| 421 | 421 | */  | 
                                                        
| 422 | 422 |  	private function limitToDBFieldOrGreater(IQueryBuilder $qb, $field, $value) { | 
                                                        
| 423 | 423 | $expr = $qb->expr();  | 
                                                        
| 424 | - $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : '';  | 
                                                        |
| 425 | - $qb->andWhere($expr->gte($pf . $field, $qb->createNamedParameter($value)));  | 
                                                        |
| 424 | + $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : '';  | 
                                                        |
| 425 | + $qb->andWhere($expr->gte($pf.$field, $qb->createNamedParameter($value)));  | 
                                                        |
| 426 | 426 | }  | 
                                                        
| 427 | 427 | |
| 428 | 428 | |
@@ -437,9 +437,9 @@ discard block  | 
                                                    ||
| 437 | 437 |  	protected function limitToNCGroupUser(IQueryBuilder $qb, $userId = '') { | 
                                                        
| 438 | 438 | $expr = $qb->expr();  | 
                                                        
| 439 | 439 | |
| 440 | - $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : '';  | 
                                                        |
| 440 | + $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : '';  | 
                                                        |
| 441 | 441 | |
| 442 | - $and = $expr->andX($expr->eq($pf . 'user_id', 'ncgu.gid'));  | 
                                                        |
| 442 | + $and = $expr->andX($expr->eq($pf.'user_id', 'ncgu.gid'));  | 
                                                        |
| 443 | 443 |  		if ($userId !== '') { | 
                                                        
| 444 | 444 |  			$and->add($expr->eq('ncgu.uid', $qb->createNamedParameter($userId))); | 
                                                        
| 445 | 445 |  		} else { | 
                                                        
@@ -462,7 +462,7 @@ discard block  | 
                                                    ||
| 462 | 462 | }  | 
                                                        
| 463 | 463 | |
| 464 | 464 | $expr = $qb->expr();  | 
                                                        
| 465 | - $pf = $this->default_select_alias . '.';  | 
                                                        |
| 465 | + $pf = $this->default_select_alias.'.';  | 
                                                        |
| 466 | 466 | |
| 467 | 467 | /** @noinspection PhpMethodParametersCountMismatchInspection */  | 
                                                        
| 468 | 468 |  		$qb->selectAlias('lc.type', 'circle_type') | 
                                                        
@@ -471,7 +471,7 @@ discard block  | 
                                                    ||
| 471 | 471 |  		   ->selectAlias('lc.settings', 'circle_settings') | 
                                                        
| 472 | 472 | ->leftJoin(  | 
                                                        
| 473 | 473 | $this->default_select_alias, DeprecatedRequestBuilder::TABLE_CIRCLES, 'lc',  | 
                                                        
| 474 | - $expr->eq($pf . 'circle_id', 'lc.unique_id')  | 
                                                        |
| 474 | + $expr->eq($pf.'circle_id', 'lc.unique_id')  | 
                                                        |
| 475 | 475 | );  | 
                                                        
| 476 | 476 | }  | 
                                                        
| 477 | 477 | |
@@ -187,11 +187,11 @@ discard block  | 
                                                    ||
| 187 | 187 | $this->federatedUserService->commandLineInitiator($initiator, $initiatorType, $circleId, true);  | 
                                                        
| 188 | 188 | $circle = $this->circleService->getCircle($circleId);  | 
                                                        
| 189 | 189 | |
| 190 | -			$output->writeln('<info>Name</info>: ' . $circle->getName()); | 
                                                        |
| 190 | +			$output->writeln('<info>Name</info>: '.$circle->getName()); | 
                                                        |
| 191 | 191 | $owner = $circle->getOwner();  | 
                                                        
| 192 | -			$output->writeln('<info>Owner</info>: ' . $owner->getUserId() . '@' . $owner->getInstance()); | 
                                                        |
| 192 | +			$output->writeln('<info>Owner</info>: '.$owner->getUserId().'@'.$owner->getInstance()); | 
                                                        |
| 193 | 193 |  			$type = implode(", ", Circle::getCircleFlags($circle, Circle::FLAGS_LONG)); | 
                                                        
| 194 | -			$output->writeln('<info>Config</info>: ' . $type); | 
                                                        |
| 194 | +			$output->writeln('<info>Config</info>: '.$type); | 
                                                        |
| 195 | 195 |  			$output->writeln(' '); | 
                                                        
| 196 | 196 | |
| 197 | 197 | $tree = new TreeNode(null, new SimpleDataStore(['circle' => $circle]));  | 
                                                        
@@ -256,8 +256,7 @@ discard block  | 
                                                    ||
| 256 | 256 | $member,  | 
                                                        
| 257 | 257 |  						$this->input->getOption('display-name') | 
                                                        
| 258 | 258 | ),  | 
                                                        
| 259 | - ($level > 0) ? Member::$DEF_LEVEL[$level] :  | 
                                                        |
| 260 | -						'(' . strtolower($member->getStatus()) . ')', | 
                                                        |
| 259 | +					($level > 0) ? Member::$DEF_LEVEL[$level] : '('.strtolower($member->getStatus()).')', | 
                                                        |
| 261 | 260 | ($member->hasInvitedBy()) ? $this->configService->displayFederatedUser(  | 
                                                        
| 262 | 261 | $member->getInvitedBy(),  | 
                                                        
| 263 | 262 |  						$this->input->getOption('display-name') | 
                                                        
@@ -423,14 +422,14 @@ discard block  | 
                                                    ||
| 423 | 422 |  				$member = $data->gObj('member', Member::class); | 
                                                        
| 424 | 423 | |
| 425 | 424 |  				if ($lineNumber === 1) { | 
                                                        
| 426 | - $line .= '<info>' . $member->getSingleId() . '</info>';  | 
                                                        |
| 425 | + $line .= '<info>'.$member->getSingleId().'</info>';  | 
                                                        |
| 427 | 426 |  					if (!$this->configService->isLocalInstance($member->getInstance())) { | 
                                                        
| 428 | - $line .= '@' . $member->getInstance();  | 
                                                        |
| 427 | + $line .= '@'.$member->getInstance();  | 
                                                        |
| 429 | 428 | }  | 
                                                        
| 430 | -					$line .= ' (' . Member::$DEF_LEVEL[$member->getLevel()] . ')'; | 
                                                        |
| 429 | +					$line .= ' ('.Member::$DEF_LEVEL[$member->getLevel()].')'; | 
                                                        |
| 431 | 430 | |
| 432 | - $line .= ' <info>MemberId</info>: ' . $member->getId();  | 
                                                        |
| 433 | - $line .= ' <info>Name</info>: ' . $this->configService->displayFederatedUser(  | 
                                                        |
| 431 | + $line .= ' <info>MemberId</info>: '.$member->getId();  | 
                                                        |
| 432 | + $line .= ' <info>Name</info>: '.$this->configService->displayFederatedUser(  | 
                                                        |
| 434 | 433 | $member,  | 
                                                        
| 435 | 434 |  						$this->input->getOption('display-name') | 
                                                        
| 436 | 435 | );  | 
                                                        
@@ -438,7 +437,7 @@ discard block  | 
                                                    ||
| 438 | 437 | $line .= ' <info>Source</info>: '  | 
                                                        
| 439 | 438 | . Circle::$DEF_SOURCE[$member->getBasedOn()->getSource()];  | 
                                                        
| 440 | 439 |  					} else { | 
                                                        
| 441 | - $line .= ' <info>Type</info>: ' . Member::$TYPE[$member->getUserType()];  | 
                                                        |
| 440 | + $line .= ' <info>Type</info>: '.Member::$TYPE[$member->getUserType()];  | 
                                                        |
| 442 | 441 | }  | 
                                                        
| 443 | 442 | }  | 
                                                        
| 444 | 443 | |
@@ -451,15 +450,15 @@ discard block  | 
                                                    ||
| 451 | 450 | return $line;  | 
                                                        
| 452 | 451 | }  | 
                                                        
| 453 | 452 | $owner = $circle->getOwner();  | 
                                                        
| 454 | - $line .= '<info>Owner</info>: ' . $owner->getUserId() . '@' . $owner->getInstance();  | 
                                                        |
| 453 | + $line .= '<info>Owner</info>: '.$owner->getUserId().'@'.$owner->getInstance();  | 
                                                        |
| 455 | 454 |  					$type = implode(", ", Circle::getCircleFlags($circle, Circle::FLAGS_LONG)); | 
                                                        
| 456 | - $line .= ($type === '') ? '' : ' <info>Config</info>: ' . $type;  | 
                                                        |
| 455 | + $line .= ($type === '') ? '' : ' <info>Config</info>: '.$type;  | 
                                                        |
| 457 | 456 | }  | 
                                                        
| 458 | 457 |  			} else { | 
                                                        
| 459 | 458 |  				if ($lineNumber === 1 && !is_null($circle)) { | 
                                                        
| 460 | - $line .= '<info>' . $circle->getSingleId() . '</info>';  | 
                                                        |
| 459 | + $line .= '<info>'.$circle->getSingleId().'</info>';  | 
                                                        |
| 461 | 460 |  					if (!$this->configService->isLocalInstance($circle->getInstance())) { | 
                                                        
| 462 | - $line .= '@' . $circle->getInstance();  | 
                                                        |
| 461 | + $line .= '@'.$circle->getInstance();  | 
                                                        |
| 463 | 462 | }  | 
                                                        
| 464 | 463 | }  | 
                                                        
| 465 | 464 | }  | 
                                                        
@@ -396,8 +396,8 @@ discard block  | 
                                                    ||
| 396 | 396 |  			foreach (explode(' ', $circle->getDisplayName()) as $word) { | 
                                                        
| 397 | 397 | $andX->add(  | 
                                                        
| 398 | 398 | $expr->iLike(  | 
                                                        
| 399 | - $this->getDefaultSelectAlias() . '.' . 'display_name',  | 
                                                        |
| 400 | -						$this->createNamedParameter('%' . $word . '%') | 
                                                        |
| 399 | + $this->getDefaultSelectAlias().'.'.'display_name',  | 
                                                        |
| 400 | +						$this->createNamedParameter('%'.$word.'%') | 
                                                        |
| 401 | 401 | )  | 
                                                        
| 402 | 402 | );  | 
                                                        
| 403 | 403 | }  | 
                                                        
@@ -408,8 +408,8 @@ discard block  | 
                                                    ||
| 408 | 408 |  			foreach (explode(' ', $circle->getDescription()) as $word) { | 
                                                        
| 409 | 409 | $orDescription->add(  | 
                                                        
| 410 | 410 | $expr->iLike(  | 
                                                        
| 411 | - $this->getDefaultSelectAlias() . '.' . 'description',  | 
                                                        |
| 412 | -						$this->createNamedParameter('%' . $word . '%') | 
                                                        |
| 411 | + $this->getDefaultSelectAlias().'.'.'description',  | 
                                                        |
| 412 | +						$this->createNamedParameter('%'.$word.'%') | 
                                                        |
| 413 | 413 | )  | 
                                                        
| 414 | 414 | );  | 
                                                        
| 415 | 415 | }  | 
                                                        
@@ -439,7 +439,7 @@ discard block  | 
                                                    ||
| 439 | 439 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance)  | 
                                                        
| 440 | 440 | ->leftJoin(  | 
                                                        
| 441 | 441 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance,  | 
                                                        
| 442 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance')  | 
                                                        |
| 442 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance')  | 
                                                        |
| 443 | 443 | );  | 
                                                        
| 444 | 444 |  		} catch (RequestBuilderException $e) { | 
                                                        
| 445 | 445 | }  | 
                                                        
@@ -491,7 +491,7 @@ discard block  | 
                                                    ||
| 491 | 491 | $expr = $this->expr();  | 
                                                        
| 492 | 492 | $this->leftJoin(  | 
                                                        
| 493 | 493 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote,  | 
                                                        
| 494 | - $expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance()))  | 
                                                        |
| 494 | + $expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance()))  | 
                                                        |
| 495 | 495 | );  | 
                                                        
| 496 | 496 | }  | 
                                                        
| 497 | 497 | |
@@ -519,12 +519,12 @@ discard block  | 
                                                    ||
| 519 | 519 | $this->leftJoin(  | 
                                                        
| 520 | 520 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember,  | 
                                                        
| 521 | 521 | $expr->andX(  | 
                                                        
| 522 | - $expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'),  | 
                                                        |
| 522 | + $expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'),  | 
                                                        |
| 523 | 523 | $expr->eq(  | 
                                                        
| 524 | - $aliasRemoteMember . '.instance',  | 
                                                        |
| 524 | + $aliasRemoteMember.'.instance',  | 
                                                        |
| 525 | 525 | $this->createNamedParameter($remoteInstance->getInstance())  | 
                                                        
| 526 | 526 | ),  | 
                                                        
| 527 | - $expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER))  | 
                                                        |
| 527 | + $expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER))  | 
                                                        |
| 528 | 528 | )  | 
                                                        
| 529 | 529 | );  | 
                                                        
| 530 | 530 | }  | 
                                                        
@@ -556,21 +556,21 @@ discard block  | 
                                                    ||
| 556 | 556 | $this->leftJoin(  | 
                                                        
| 557 | 557 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle,  | 
                                                        
| 558 | 558 | $expr->andX(  | 
                                                        
| 559 | - $expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'),  | 
                                                        |
| 560 | - $expr->emptyString($aliasRemoteCircle . '.instance'),  | 
                                                        |
| 561 | - $expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER))  | 
                                                        |
| 559 | + $expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'),  | 
                                                        |
| 560 | + $expr->emptyString($aliasRemoteCircle.'.instance'),  | 
                                                        |
| 561 | + $expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER))  | 
                                                        |
| 562 | 562 | )  | 
                                                        
| 563 | 563 | );  | 
                                                        
| 564 | 564 | $this->leftJoin(  | 
                                                        
| 565 | 565 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner,  | 
                                                        
| 566 | 566 | $expr->andX(  | 
                                                        
| 567 | - $expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'),  | 
                                                        |
| 567 | + $expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'),  | 
                                                        |
| 568 | 568 | $expr->eq(  | 
                                                        
| 569 | - $aliasRemoteCircleOwner . '.instance',  | 
                                                        |
| 569 | + $aliasRemoteCircleOwner.'.instance',  | 
                                                        |
| 570 | 570 | $this->createNamedParameter($remoteInstance->getInstance())  | 
                                                        
| 571 | 571 | ),  | 
                                                        
| 572 | 572 | $expr->eq(  | 
                                                        
| 573 | - $aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)  | 
                                                        |
| 573 | + $aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)  | 
                                                        |
| 574 | 574 | )  | 
                                                        
| 575 | 575 | )  | 
                                                        
| 576 | 576 | );  | 
                                                        
@@ -603,16 +603,16 @@ discard block  | 
                                                    ||
| 603 | 603 | $expr = $this->expr();  | 
                                                        
| 604 | 604 | $orX = $expr->orX();  | 
                                                        
| 605 | 605 | $orX->add(  | 
                                                        
| 606 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE))  | 
                                                        |
| 606 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE))  | 
                                                        |
| 607 | 607 | );  | 
                                                        
| 608 | 608 | |
| 609 | 609 | $orExtOrPassive = $expr->orX();  | 
                                                        
| 610 | 610 | $orExtOrPassive->add(  | 
                                                        
| 611 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))  | 
                                                        |
| 611 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))  | 
                                                        |
| 612 | 612 | );  | 
                                                        
| 613 | 613 |  		if (!$sensitive) { | 
                                                        
| 614 | 614 | $orExtOrPassive->add(  | 
                                                        
| 615 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))  | 
                                                        |
| 615 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))  | 
                                                        |
| 616 | 616 | );  | 
                                                        
| 617 | 617 |  		} else { | 
                                                        
| 618 | 618 |  			if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) { | 
                                                        
@@ -621,8 +621,8 @@ discard block  | 
                                                    ||
| 621 | 621 | }  | 
                                                        
| 622 | 622 | |
| 623 | 623 | $orInstance = $expr->orX();  | 
                                                        
| 624 | - $orInstance->add($expr->isNotNull($aliasRemoteMember . '.instance'));  | 
                                                        |
| 625 | - $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner . '.instance'));  | 
                                                        |
| 624 | + $orInstance->add($expr->isNotNull($aliasRemoteMember.'.instance'));  | 
                                                        |
| 625 | + $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner.'.instance'));  | 
                                                        |
| 626 | 626 | |
| 627 | 627 | $andExternal = $expr->andX();  | 
                                                        
| 628 | 628 | $andExternal->add($orExtOrPassive);  | 
                                                        
@@ -631,13 +631,13 @@ discard block  | 
                                                    ||
| 631 | 631 | $orExtOrTrusted = $expr->orX();  | 
                                                        
| 632 | 632 | $orExtOrTrusted->add($andExternal);  | 
                                                        
| 633 | 633 | $orExtOrTrusted->add(  | 
                                                        
| 634 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED))  | 
                                                        |
| 634 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED))  | 
                                                        |
| 635 | 635 | );  | 
                                                        
| 636 | 636 | |
| 637 | 637 | $andTrusted = $expr->andX();  | 
                                                        
| 638 | 638 | $andTrusted->add($orExtOrTrusted);  | 
                                                        
| 639 | 639 |  		$andTrusted->add($this->exprLimitBitwise('config', Circle::CFG_FEDERATED, $aliasCircle)); | 
                                                        
| 640 | - $andTrusted->add($expr->emptyString($aliasOwner . '.instance'));  | 
                                                        |
| 640 | + $andTrusted->add($expr->emptyString($aliasOwner.'.instance'));  | 
                                                        |
| 641 | 641 | $orX->add($andTrusted);  | 
                                                        
| 642 | 642 | |
| 643 | 643 | $this->andWhere($orX);  | 
                                                        
@@ -664,7 +664,7 @@ discard block  | 
                                                    ||
| 664 | 664 | }  | 
                                                        
| 665 | 665 | $this->innerJoin(  | 
                                                        
| 666 | 666 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember,  | 
                                                        
| 667 | - $expr->eq($aliasMember . '.circle_id', $alias . '.unique_id')  | 
                                                        |
| 667 | + $expr->eq($aliasMember.'.circle_id', $alias.'.unique_id')  | 
                                                        |
| 668 | 668 | );  | 
                                                        
| 669 | 669 | |
| 670 | 670 | $this->filterDirectMembership($aliasMember, $member);  | 
                                                        
@@ -689,12 +689,12 @@ discard block  | 
                                                    ||
| 689 | 689 | $aliasCircle,  | 
                                                        
| 690 | 690 | 'circles_membership',  | 
                                                        
| 691 | 691 | $aliasMembership,  | 
                                                        
| 692 | - $this->expr()->eq($aliasCircle . '.unique_id', $aliasMembership . '.circle_id')  | 
                                                        |
| 692 | + $this->expr()->eq($aliasCircle.'.unique_id', $aliasMembership.'.circle_id')  | 
                                                        |
| 693 | 693 | );  | 
                                                        
| 694 | 694 | |
| 695 | 695 | $this->andWhere(  | 
                                                        
| 696 | 696 | $this->expr()->eq(  | 
                                                        
| 697 | - $aliasMembership . '.single_id',  | 
                                                        |
| 697 | + $aliasMembership.'.single_id',  | 
                                                        |
| 698 | 698 | $this->createNamedParameter($federatedUser->getSingleId())  | 
                                                        
| 699 | 699 | )  | 
                                                        
| 700 | 700 | );  | 
                                                        
@@ -715,19 +715,19 @@ discard block  | 
                                                    ||
| 715 | 715 | |
| 716 | 716 |  		if ($member->getUserId() !== '') { | 
                                                        
| 717 | 717 | $andX->add(  | 
                                                        
| 718 | - $expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId()))  | 
                                                        |
| 718 | + $expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId()))  | 
                                                        |
| 719 | 719 | );  | 
                                                        
| 720 | 720 | }  | 
                                                        
| 721 | 721 | |
| 722 | 722 |  		if ($member->getSingleId() !== '') { | 
                                                        
| 723 | 723 | $andX->add(  | 
                                                        
| 724 | - $expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId()))  | 
                                                        |
| 724 | + $expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId()))  | 
                                                        |
| 725 | 725 | );  | 
                                                        
| 726 | 726 | }  | 
                                                        
| 727 | 727 | |
| 728 | 728 |  		if ($member->getUserType() > 0) { | 
                                                        
| 729 | 729 | $andX->add(  | 
                                                        
| 730 | - $expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType()))  | 
                                                        |
| 730 | + $expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType()))  | 
                                                        |
| 731 | 731 | );  | 
                                                        
| 732 | 732 | }  | 
                                                        
| 733 | 733 | |
@@ -736,7 +736,7 @@ discard block  | 
                                                    ||
| 736 | 736 |  		if ($member->getLevel() > 0) { | 
                                                        
| 737 | 737 | $andX->add(  | 
                                                        
| 738 | 738 | $expr->gte(  | 
                                                        
| 739 | - $aliasMember . '.level',  | 
                                                        |
| 739 | + $aliasMember.'.level',  | 
                                                        |
| 740 | 740 | $this->createNamedParameter($member->getLevel(), IQueryBuilder::PARAM_INT)  | 
                                                        
| 741 | 741 | )  | 
                                                        
| 742 | 742 | );  | 
                                                        
@@ -777,7 +777,7 @@ discard block  | 
                                                    ||
| 777 | 777 | $helperAlias,  | 
                                                        
| 778 | 778 | CoreRequestBuilder::TABLE_CIRCLE,  | 
                                                        
| 779 | 779 | $aliasCircle,  | 
                                                        
| 780 | - $expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field)  | 
                                                        |
| 780 | + $expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field)  | 
                                                        |
| 781 | 781 | );  | 
                                                        
| 782 | 782 | |
| 783 | 783 |  		if (!is_null($initiator)) { | 
                                                        
@@ -808,7 +808,7 @@ discard block  | 
                                                    ||
| 808 | 808 | $this->generateCircleSelectAlias($aliasInvitedBy)  | 
                                                        
| 809 | 809 | ->leftJoin(  | 
                                                        
| 810 | 810 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasInvitedBy,  | 
                                                        
| 811 | - $expr->eq($aliasMember . '.invited_by', $aliasInvitedBy . '.unique_id')  | 
                                                        |
| 811 | + $expr->eq($aliasMember.'.invited_by', $aliasInvitedBy.'.unique_id')  | 
                                                        |
| 812 | 812 | );  | 
                                                        
| 813 | 813 | |
| 814 | 814 | $this->leftJoinOwner($aliasInvitedBy);  | 
                                                        
@@ -839,7 +839,7 @@ discard block  | 
                                                    ||
| 839 | 839 | $this->generateCircleSelectAlias($aliasBasedOn)  | 
                                                        
| 840 | 840 | ->leftJoin(  | 
                                                        
| 841 | 841 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn,  | 
                                                        
| 842 | - $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id')  | 
                                                        |
| 842 | + $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id')  | 
                                                        |
| 843 | 843 | );  | 
                                                        
| 844 | 844 | |
| 845 | 845 |  		if (!is_null($initiator)) { | 
                                                        
@@ -872,9 +872,9 @@ discard block  | 
                                                    ||
| 872 | 872 | ->leftJoin(  | 
                                                        
| 873 | 873 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember,  | 
                                                        
| 874 | 874 | $expr->andX(  | 
                                                        
| 875 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field),  | 
                                                        |
| 875 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field),  | 
                                                        |
| 876 | 876 | $expr->eq(  | 
                                                        
| 877 | - $aliasMember . '.level',  | 
                                                        |
| 877 | + $aliasMember.'.level',  | 
                                                        |
| 878 | 878 | $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT)  | 
                                                        
| 879 | 879 | )  | 
                                                        
| 880 | 880 | )  | 
                                                        
@@ -906,9 +906,9 @@ discard block  | 
                                                    ||
| 906 | 906 | ->innerJoin(  | 
                                                        
| 907 | 907 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership,  | 
                                                        
| 908 | 908 | $expr->andX(  | 
                                                        
| 909 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field),  | 
                                                        |
| 909 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field),  | 
                                                        |
| 910 | 910 | $expr->eq(  | 
                                                        
| 911 | - $aliasMembership . '.level',  | 
                                                        |
| 911 | + $aliasMembership.'.level',  | 
                                                        |
| 912 | 912 | $this->createNamedParameter(  | 
                                                        
| 913 | 913 | Member::LEVEL_MEMBER,  | 
                                                        
| 914 | 914 | self::PARAM_INT  | 
                                                        
@@ -949,10 +949,10 @@ discard block  | 
                                                    ||
| 949 | 949 | ->leftJoin(  | 
                                                        
| 950 | 950 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember,  | 
                                                        
| 951 | 951 | $expr->andX(  | 
                                                        
| 952 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId),  | 
                                                        |
| 953 | - $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId),  | 
                                                        |
| 952 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId),  | 
                                                        |
| 953 | + $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId),  | 
                                                        |
| 954 | 954 | $expr->gte(  | 
                                                        
| 955 | - $aliasMember . '.level',  | 
                                                        |
| 955 | + $aliasMember.'.level',  | 
                                                        |
| 956 | 956 | $this->createNamedParameter(Member::LEVEL_MEMBER, self::PARAM_INT)  | 
                                                        
| 957 | 957 | )  | 
                                                        
| 958 | 958 | )  | 
                                                        
@@ -985,7 +985,7 @@ discard block  | 
                                                    ||
| 985 | 985 | |
| 986 | 986 | $this->leftJoin(  | 
                                                        
| 987 | 987 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership,  | 
                                                        
| 988 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field)  | 
                                                        |
| 988 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field)  | 
                                                        |
| 989 | 989 | );  | 
                                                        
| 990 | 990 | |
| 991 | 991 |  //		if (!$this->getBool('getData', $options, false)) { | 
                                                        
@@ -999,8 +999,8 @@ discard block  | 
                                                    ||
| 999 | 999 | ->leftJoin(  | 
                                                        
| 1000 | 1000 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy,  | 
                                                        
| 1001 | 1001 | $expr->andX(  | 
                                                        
| 1002 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'),  | 
                                                        |
| 1003 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id')  | 
                                                        |
| 1002 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'),  | 
                                                        |
| 1003 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id')  | 
                                                        |
| 1004 | 1004 | )  | 
                                                        
| 1005 | 1005 | );  | 
                                                        
| 1006 | 1006 | |
@@ -1017,12 +1017,12 @@ discard block  | 
                                                    ||
| 1017 | 1017 | $aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options);  | 
                                                        
| 1018 | 1018 | $this->leftJoin(  | 
                                                        
| 1019 | 1019 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership,  | 
                                                        
| 1020 | - $expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId))  | 
                                                        |
| 1020 | + $expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId))  | 
                                                        |
| 1021 | 1021 | );  | 
                                                        
| 1022 | 1022 | |
| 1023 | 1023 | $orX = $expr->orX(  | 
                                                        
| 1024 | - $expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field),  | 
                                                        |
| 1025 | - $expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId))  | 
                                                        |
| 1024 | + $expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field),  | 
                                                        |
| 1025 | + $expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId))  | 
                                                        |
| 1026 | 1026 | );  | 
                                                        
| 1027 | 1027 | |
| 1028 | 1028 | $this->andWhere($orX);  | 
                                                        
@@ -1043,11 +1043,11 @@ discard block  | 
                                                    ||
| 1043 | 1043 | |
| 1044 | 1044 | $expr = $this->expr();  | 
                                                        
| 1045 | 1045 | $aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS);  | 
                                                        
| 1046 | - $this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId)));  | 
                                                        |
| 1046 | + $this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId)));  | 
                                                        |
| 1047 | 1047 |  		if ($level > 1) { | 
                                                        
| 1048 | 1048 | $this->andWhere(  | 
                                                        
| 1049 | 1049 | $expr->gte(  | 
                                                        
| 1050 | - $aliasMembership . '.level',  | 
                                                        |
| 1050 | + $aliasMembership.'.level',  | 
                                                        |
| 1051 | 1051 | $this->createNamedParameter($level, IQueryBuilder::PARAM_INT)  | 
                                                        
| 1052 | 1052 | )  | 
                                                        
| 1053 | 1053 | );  | 
                                                        
@@ -1075,8 +1075,8 @@ discard block  | 
                                                    ||
| 1075 | 1075 | $this->leftJoin(  | 
                                                        
| 1076 | 1076 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership,  | 
                                                        
| 1077 | 1077 | $expr->andX(  | 
                                                        
| 1078 | - $expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field),  | 
                                                        |
| 1079 | - $expr->eq($aliasMembership . '.single_id', $alias . '.single_id')  | 
                                                        |
| 1078 | + $expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field),  | 
                                                        |
| 1079 | + $expr->eq($aliasMembership.'.single_id', $alias.'.single_id')  | 
                                                        |
| 1080 | 1080 | )  | 
                                                        
| 1081 | 1081 | );  | 
                                                        
| 1082 | 1082 | |
@@ -1089,8 +1089,8 @@ discard block  | 
                                                    ||
| 1089 | 1089 | ->leftJoin(  | 
                                                        
| 1090 | 1090 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom,  | 
                                                        
| 1091 | 1091 | $expr->andX(  | 
                                                        
| 1092 | - $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'),  | 
                                                        |
| 1093 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id')  | 
                                                        |
| 1092 | + $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'),  | 
                                                        |
| 1093 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id')  | 
                                                        |
| 1094 | 1094 | )  | 
                                                        
| 1095 | 1095 | );  | 
                                                        
| 1096 | 1096 | }  | 
                                                        
@@ -1130,7 +1130,7 @@ discard block  | 
                                                    ||
| 1130 | 1130 | |
| 1131 | 1131 | $this->leftJoin(  | 
                                                        
| 1132 | 1132 | $alias, CoreRequestBuilder::TABLE_TOKEN, $aliasShareToken,  | 
                                                        
| 1133 | - $expr->eq($aliasShareToken . '.share_id', $alias . '.' . $field)  | 
                                                        |
| 1133 | + $expr->eq($aliasShareToken.'.share_id', $alias.'.'.$field)  | 
                                                        |
| 1134 | 1134 | );  | 
                                                        
| 1135 | 1135 | }  | 
                                                        
| 1136 | 1136 | |
@@ -1172,14 +1172,14 @@ discard block  | 
                                                    ||
| 1172 | 1172 |  		try { | 
                                                        
| 1173 | 1173 | $aliasConfig = $this->generateAlias($alias, self::CONFIG, $options);  | 
                                                        
| 1174 | 1174 | $this->selectAlias(  | 
                                                        
| 1175 | - $aliasConfig . '.config',  | 
                                                        |
| 1176 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'circle_config'  | 
                                                        |
| 1175 | + $aliasConfig.'.config',  | 
                                                        |
| 1176 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'circle_config'  | 
                                                        |
| 1177 | 1177 | );  | 
                                                        
| 1178 | 1178 | $this->leftJoin(  | 
                                                        
| 1179 | 1179 | $alias,  | 
                                                        
| 1180 | 1180 | CoreRequestBuilder::TABLE_CIRCLE,  | 
                                                        
| 1181 | 1181 | $aliasConfig,  | 
                                                        
| 1182 | - $expr->eq($alias . '.circle_id', $aliasConfig . '.unique_id')  | 
                                                        |
| 1182 | + $expr->eq($alias.'.circle_id', $aliasConfig.'.unique_id')  | 
                                                        |
| 1183 | 1183 | );  | 
                                                        
| 1184 | 1184 |  		} catch (RequestBuilderException $e) { | 
                                                        
| 1185 | 1185 | }  | 
                                                        
@@ -1217,7 +1217,7 @@ discard block  | 
                                                    ||
| 1217 | 1217 | $aliasMembership,  | 
                                                        
| 1218 | 1218 | $expr->andX(  | 
                                                        
| 1219 | 1219 |  				$this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), | 
                                                        
| 1220 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field)  | 
                                                        |
| 1220 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field)  | 
                                                        |
| 1221 | 1221 | )  | 
                                                        
| 1222 | 1222 | );  | 
                                                        
| 1223 | 1223 | |
@@ -1236,11 +1236,11 @@ discard block  | 
                                                    ||
| 1236 | 1236 | $aliasMembershipCircle = $this->generateAlias($aliasMembership, self::CONFIG, $options);  | 
                                                        
| 1237 | 1237 | $orXMembershipCircle = $expr->orX();  | 
                                                        
| 1238 | 1238 | array_map(  | 
                                                        
| 1239 | -				function (string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { | 
                                                        |
| 1239 | +				function(string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { | 
                                                        |
| 1240 | 1240 | $orXMembershipCircle->add(  | 
                                                        
| 1241 | 1241 | $this->expr()->eq(  | 
                                                        
| 1242 | - $alias . '.circle_id',  | 
                                                        |
| 1243 | - $aliasMembershipCircle . '.unique_id'  | 
                                                        |
| 1242 | + $alias.'.circle_id',  | 
                                                        |
| 1243 | + $aliasMembershipCircle.'.unique_id'  | 
                                                        |
| 1244 | 1244 | )  | 
                                                        
| 1245 | 1245 | );  | 
                                                        
| 1246 | 1246 | },  | 
                                                        
@@ -1272,7 +1272,7 @@ discard block  | 
                                                    ||
| 1272 | 1272 | $aliasDirectInitiator,  | 
                                                        
| 1273 | 1273 | $expr->andX(  | 
                                                        
| 1274 | 1274 |  					 		$this->exprLimit('single_id', $initiator->getSingleId(), $aliasDirectInitiator), | 
                                                        
| 1275 | - $expr->eq($aliasDirectInitiator . '.circle_id', $helperAlias . '.' . $field)  | 
                                                        |
| 1275 | + $expr->eq($aliasDirectInitiator.'.circle_id', $helperAlias.'.'.$field)  | 
                                                        |
| 1276 | 1276 | )  | 
                                                        
| 1277 | 1277 | );  | 
                                                        
| 1278 | 1278 |  			} catch (RequestBuilderException $e) { | 
                                                        
@@ -1286,8 +1286,8 @@ discard block  | 
                                                    ||
| 1286 | 1286 | $this->leftJoin(  | 
                                                        
| 1287 | 1287 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator,  | 
                                                        
| 1288 | 1288 | $expr->andX(  | 
                                                        
| 1289 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'),  | 
                                                        |
| 1290 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id')  | 
                                                        |
| 1289 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'),  | 
                                                        |
| 1290 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id')  | 
                                                        |
| 1291 | 1291 | )  | 
                                                        
| 1292 | 1292 | );  | 
                                                        
| 1293 | 1293 | |
@@ -1295,8 +1295,8 @@ discard block  | 
                                                    ||
| 1295 | 1295 | $this->leftJoin(  | 
                                                        
| 1296 | 1296 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy,  | 
                                                        
| 1297 | 1297 | $expr->andX(  | 
                                                        
| 1298 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'),  | 
                                                        |
| 1299 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id')  | 
                                                        |
| 1298 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'),  | 
                                                        |
| 1299 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id')  | 
                                                        |
| 1300 | 1300 | )  | 
                                                        
| 1301 | 1301 | );  | 
                                                        
| 1302 | 1302 | |
@@ -1347,7 +1347,7 @@ discard block  | 
                                                    ||
| 1347 | 1347 | $orX->add(  | 
                                                        
| 1348 | 1348 | $expr->andX(  | 
                                                        
| 1349 | 1349 |  					$this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $aliasMembershipCircle), | 
                                                        
| 1350 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER))  | 
                                                        |
| 1350 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER))  | 
                                                        |
| 1351 | 1351 | )  | 
                                                        
| 1352 | 1352 | );  | 
                                                        
| 1353 | 1353 | }  | 
                                                        
@@ -1357,10 +1357,10 @@ discard block  | 
                                                    ||
| 1357 | 1357 | $orXLevelCheck = $expr->orX();  | 
                                                        
| 1358 | 1358 | |
| 1359 | 1359 | array_map(  | 
                                                        
| 1360 | -			function (string $alias) use ($orXLevelCheck, $minimumLevel) { | 
                                                        |
| 1360 | +			function(string $alias) use ($orXLevelCheck, $minimumLevel) { | 
                                                        |
| 1361 | 1361 | $orXLevelCheck->add(  | 
                                                        
| 1362 | 1362 | $this->expr()->gte(  | 
                                                        
| 1363 | - $alias . '.level',  | 
                                                        |
| 1363 | + $alias.'.level',  | 
                                                        |
| 1364 | 1364 | $this->createNamedParameter($minimumLevel)  | 
                                                        
| 1365 | 1365 | )  | 
                                                        
| 1366 | 1366 | );  | 
                                                        
@@ -1450,21 +1450,21 @@ discard block  | 
                                                    ||
| 1450 | 1450 | $expr = $this->expr();  | 
                                                        
| 1451 | 1451 | $andPassive = $expr->andX();  | 
                                                        
| 1452 | 1452 | $andPassive->add(  | 
                                                        
| 1453 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))  | 
                                                        |
| 1453 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))  | 
                                                        |
| 1454 | 1454 | );  | 
                                                        
| 1455 | 1455 | |
| 1456 | 1456 | $orMemberOrLevel = $expr->orX();  | 
                                                        
| 1457 | 1457 | $orMemberOrLevel->add(  | 
                                                        
| 1458 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance')  | 
                                                        |
| 1458 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance')  | 
                                                        |
| 1459 | 1459 | );  | 
                                                        
| 1460 | 1460 | // TODO: do we need this ? (display members from the local instance)  | 
                                                        
| 1461 | 1461 | $orMemberOrLevel->add(  | 
                                                        
| 1462 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance')  | 
                                                        |
| 1462 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance')  | 
                                                        |
| 1463 | 1463 | );  | 
                                                        
| 1464 | 1464 | |
| 1465 | 1465 | $orMemberOrLevel->add(  | 
                                                        
| 1466 | 1466 | $expr->eq(  | 
                                                        
| 1467 | - $this->getDefaultSelectAlias() . '.level',  | 
                                                        |
| 1467 | + $this->getDefaultSelectAlias().'.level',  | 
                                                        |
| 1468 | 1468 | $this->createNamedParameter(Member::LEVEL_OWNER)  | 
                                                        
| 1469 | 1469 | )  | 
                                                        
| 1470 | 1470 | );  | 
                                                        
@@ -1501,11 +1501,11 @@ discard block  | 
                                                    ||
| 1501 | 1501 | )  | 
                                                        
| 1502 | 1502 | ->leftJoin(  | 
                                                        
| 1503 | 1503 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache,  | 
                                                        
| 1504 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid')  | 
                                                        |
| 1504 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid')  | 
                                                        |
| 1505 | 1505 | )  | 
                                                        
| 1506 | 1506 | ->leftJoin(  | 
                                                        
| 1507 | 1507 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages,  | 
                                                        
| 1508 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id')  | 
                                                        |
| 1508 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id')  | 
                                                        |
| 1509 | 1509 | );  | 
                                                        
| 1510 | 1510 | }  | 
                                                        
| 1511 | 1511 | |
@@ -1527,8 +1527,8 @@ discard block  | 
                                                    ||
| 1527 | 1527 | $this->leftJoin(  | 
                                                        
| 1528 | 1528 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild,  | 
                                                        
| 1529 | 1529 | $expr->andX(  | 
                                                        
| 1530 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'),  | 
                                                        |
| 1531 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id')  | 
                                                        |
| 1530 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'),  | 
                                                        |
| 1531 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id')  | 
                                                        |
| 1532 | 1532 | )  | 
                                                        
| 1533 | 1533 | );  | 
                                                        
| 1534 | 1534 | |
@@ -1578,13 +1578,13 @@ discard block  | 
                                                    ||
| 1578 | 1578 | $this->leftJoin(  | 
                                                        
| 1579 | 1579 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint,  | 
                                                        
| 1580 | 1580 | $expr->andX(  | 
                                                        
| 1581 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'),  | 
                                                        |
| 1582 | - $expr->eq($aliasMountpoint . '.single_id', $aliasMountMemberships . '.single_id')  | 
                                                        |
| 1581 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'),  | 
                                                        |
| 1582 | + $expr->eq($aliasMountpoint.'.single_id', $aliasMountMemberships.'.single_id')  | 
                                                        |
| 1583 | 1583 | )  | 
                                                        
| 1584 | 1584 | );  | 
                                                        
| 1585 | 1585 | |
| 1586 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint');  | 
                                                        |
| 1587 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash');  | 
                                                        |
| 1586 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint');  | 
                                                        |
| 1587 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash');  | 
                                                        |
| 1588 | 1588 | }  | 
                                                        
| 1589 | 1589 | |
| 1590 | 1590 | |
@@ -1692,10 +1692,10 @@ discard block  | 
                                                    ||
| 1692 | 1692 | */  | 
                                                        
| 1693 | 1693 |  	public function generateAlias(string $base, string $extension, ?array &$options = []): string { | 
                                                        
| 1694 | 1694 |  		$search = str_replace('_', '.', $base); | 
                                                        
| 1695 | - $path = $search . '.' . $extension;  | 
                                                        |
| 1695 | + $path = $search.'.'.$extension;  | 
                                                        |
| 1696 | 1696 | if (!$this->validKey($path, $this->getSqlPath())  | 
                                                        
| 1697 | 1697 |  			&& !in_array($extension, $this->getArray($search, $this->getSqlPath()))) { | 
                                                        
| 1698 | - throw new RequestBuilderException($extension . ' not found in ' . $search);  | 
                                                        |
| 1698 | + throw new RequestBuilderException($extension.' not found in '.$search);  | 
                                                        |
| 1699 | 1699 | }  | 
                                                        
| 1700 | 1700 | |
| 1701 | 1701 |  		if (!is_array($options)) { | 
                                                        
@@ -1704,15 +1704,15 @@ discard block  | 
                                                    ||
| 1704 | 1704 | |
| 1705 | 1705 | $optionPath = '';  | 
                                                        
| 1706 | 1706 |  		foreach (explode('.', $path) as $p) { | 
                                                        
| 1707 | - $optionPath = trim($optionPath . '.' . $p, '.');  | 
                                                        |
| 1707 | + $optionPath = trim($optionPath.'.'.$p, '.');  | 
                                                        |
| 1708 | 1708 | $options = array_merge(  | 
                                                        
| 1709 | 1709 | $options,  | 
                                                        
| 1710 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->getSqlPath()),  | 
                                                        |
| 1711 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options)  | 
                                                        |
| 1710 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->getSqlPath()),  | 
                                                        |
| 1711 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options)  | 
                                                        |
| 1712 | 1712 | );  | 
                                                        
| 1713 | 1713 | }  | 
                                                        
| 1714 | 1714 | |
| 1715 | - return $base . '_' . $extension;  | 
                                                        |
| 1715 | + return $base.'_'.$extension;  | 
                                                        |
| 1716 | 1716 | }  | 
                                                        
| 1717 | 1717 | |
| 1718 | 1718 | |
@@ -1732,7 +1732,7 @@ discard block  | 
                                                    ||
| 1732 | 1732 |  			} else { | 
                                                        
| 1733 | 1733 | $k = $arr;  | 
                                                        
| 1734 | 1734 | }  | 
                                                        
| 1735 | - $path[$k] = $prefix . '_' . $k . '_';  | 
                                                        |
| 1735 | + $path[$k] = $prefix.'_'.$k.'_';  | 
                                                        |
| 1736 | 1736 | }  | 
                                                        
| 1737 | 1737 | |
| 1738 | 1738 | return $path;  |