@@ -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 | ) |
@@ -398,8 +398,8 @@ discard block |
||
| 398 | 398 | foreach (explode(' ', $circle->getDisplayName()) as $word) { |
| 399 | 399 | $andX->add( |
| 400 | 400 | $expr->iLike( |
| 401 | - $this->getDefaultSelectAlias() . '.' . 'display_name', |
|
| 402 | - $this->createNamedParameter('%' . $word . '%') |
|
| 401 | + $this->getDefaultSelectAlias().'.'.'display_name', |
|
| 402 | + $this->createNamedParameter('%'.$word.'%') |
|
| 403 | 403 | ) |
| 404 | 404 | ); |
| 405 | 405 | } |
@@ -410,8 +410,8 @@ discard block |
||
| 410 | 410 | foreach (explode(' ', $circle->getDescription()) as $word) { |
| 411 | 411 | $orDescription->add( |
| 412 | 412 | $expr->iLike( |
| 413 | - $this->getDefaultSelectAlias() . '.' . 'description', |
|
| 414 | - $this->createNamedParameter('%' . $word . '%') |
|
| 413 | + $this->getDefaultSelectAlias().'.'.'description', |
|
| 414 | + $this->createNamedParameter('%'.$word.'%') |
|
| 415 | 415 | ) |
| 416 | 416 | ); |
| 417 | 417 | } |
@@ -441,7 +441,7 @@ discard block |
||
| 441 | 441 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance) |
| 442 | 442 | ->leftJoin( |
| 443 | 443 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance, |
| 444 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance') |
|
| 444 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance') |
|
| 445 | 445 | ); |
| 446 | 446 | } catch (RequestBuilderException $e) { |
| 447 | 447 | } |
@@ -493,7 +493,7 @@ discard block |
||
| 493 | 493 | $expr = $this->expr(); |
| 494 | 494 | $this->leftJoin( |
| 495 | 495 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote, |
| 496 | - $expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
| 496 | + $expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
| 497 | 497 | ); |
| 498 | 498 | } |
| 499 | 499 | |
@@ -521,12 +521,12 @@ discard block |
||
| 521 | 521 | $this->leftJoin( |
| 522 | 522 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember, |
| 523 | 523 | $expr->andX( |
| 524 | - $expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'), |
|
| 524 | + $expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'), |
|
| 525 | 525 | $expr->eq( |
| 526 | - $aliasRemoteMember . '.instance', |
|
| 526 | + $aliasRemoteMember.'.instance', |
|
| 527 | 527 | $this->createNamedParameter($remoteInstance->getInstance()) |
| 528 | 528 | ), |
| 529 | - $expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 529 | + $expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 530 | 530 | ) |
| 531 | 531 | ); |
| 532 | 532 | } |
@@ -558,21 +558,21 @@ discard block |
||
| 558 | 558 | $this->leftJoin( |
| 559 | 559 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle, |
| 560 | 560 | $expr->andX( |
| 561 | - $expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'), |
|
| 562 | - $expr->emptyString($aliasRemoteCircle . '.instance'), |
|
| 563 | - $expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 561 | + $expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'), |
|
| 562 | + $expr->emptyString($aliasRemoteCircle.'.instance'), |
|
| 563 | + $expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 564 | 564 | ) |
| 565 | 565 | ); |
| 566 | 566 | $this->leftJoin( |
| 567 | 567 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner, |
| 568 | 568 | $expr->andX( |
| 569 | - $expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'), |
|
| 569 | + $expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'), |
|
| 570 | 570 | $expr->eq( |
| 571 | - $aliasRemoteCircleOwner . '.instance', |
|
| 571 | + $aliasRemoteCircleOwner.'.instance', |
|
| 572 | 572 | $this->createNamedParameter($remoteInstance->getInstance()) |
| 573 | 573 | ), |
| 574 | 574 | $expr->eq( |
| 575 | - $aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
| 575 | + $aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
| 576 | 576 | ) |
| 577 | 577 | ) |
| 578 | 578 | ); |
@@ -605,16 +605,16 @@ discard block |
||
| 605 | 605 | $expr = $this->expr(); |
| 606 | 606 | $orX = $expr->orX(); |
| 607 | 607 | $orX->add( |
| 608 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
| 608 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
| 609 | 609 | ); |
| 610 | 610 | |
| 611 | 611 | $orExtOrPassive = $expr->orX(); |
| 612 | 612 | $orExtOrPassive->add( |
| 613 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
| 613 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
| 614 | 614 | ); |
| 615 | 615 | if (!$sensitive) { |
| 616 | 616 | $orExtOrPassive->add( |
| 617 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 617 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 618 | 618 | ); |
| 619 | 619 | } else { |
| 620 | 620 | if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) { |
@@ -623,8 +623,8 @@ discard block |
||
| 623 | 623 | } |
| 624 | 624 | |
| 625 | 625 | $orInstance = $expr->orX(); |
| 626 | - $orInstance->add($expr->isNotNull($aliasRemoteMember . '.instance')); |
|
| 627 | - $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner . '.instance')); |
|
| 626 | + $orInstance->add($expr->isNotNull($aliasRemoteMember.'.instance')); |
|
| 627 | + $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner.'.instance')); |
|
| 628 | 628 | |
| 629 | 629 | $andExternal = $expr->andX(); |
| 630 | 630 | $andExternal->add($orExtOrPassive); |
@@ -633,13 +633,13 @@ discard block |
||
| 633 | 633 | $orExtOrTrusted = $expr->orX(); |
| 634 | 634 | $orExtOrTrusted->add($andExternal); |
| 635 | 635 | $orExtOrTrusted->add( |
| 636 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
| 636 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
| 637 | 637 | ); |
| 638 | 638 | |
| 639 | 639 | $andTrusted = $expr->andX(); |
| 640 | 640 | $andTrusted->add($orExtOrTrusted); |
| 641 | 641 | $andTrusted->add($this->exprLimitBitwise('config', Circle::CFG_FEDERATED, $aliasCircle)); |
| 642 | - $andTrusted->add($expr->emptyString($aliasOwner . '.instance')); |
|
| 642 | + $andTrusted->add($expr->emptyString($aliasOwner.'.instance')); |
|
| 643 | 643 | $orX->add($andTrusted); |
| 644 | 644 | |
| 645 | 645 | $this->andWhere($orX); |
@@ -666,7 +666,7 @@ discard block |
||
| 666 | 666 | } |
| 667 | 667 | $this->innerJoin( |
| 668 | 668 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 669 | - $expr->eq($aliasMember . '.circle_id', $alias . '.unique_id') |
|
| 669 | + $expr->eq($aliasMember.'.circle_id', $alias.'.unique_id') |
|
| 670 | 670 | ); |
| 671 | 671 | |
| 672 | 672 | $this->filterDirectMembership($aliasMember, $member); |
@@ -691,12 +691,12 @@ discard block |
||
| 691 | 691 | $aliasCircle, |
| 692 | 692 | 'circles_membership', |
| 693 | 693 | $aliasMembership, |
| 694 | - $this->expr()->eq($aliasCircle . '.unique_id', $aliasMembership . '.circle_id') |
|
| 694 | + $this->expr()->eq($aliasCircle.'.unique_id', $aliasMembership.'.circle_id') |
|
| 695 | 695 | ); |
| 696 | 696 | |
| 697 | 697 | $this->andWhere( |
| 698 | 698 | $this->expr()->eq( |
| 699 | - $aliasMembership . '.single_id', |
|
| 699 | + $aliasMembership.'.single_id', |
|
| 700 | 700 | $this->createNamedParameter($federatedUser->getSingleId()) |
| 701 | 701 | ) |
| 702 | 702 | ); |
@@ -717,19 +717,19 @@ discard block |
||
| 717 | 717 | |
| 718 | 718 | if ($member->getUserId() !== '') { |
| 719 | 719 | $andX->add( |
| 720 | - $expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId())) |
|
| 720 | + $expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId())) |
|
| 721 | 721 | ); |
| 722 | 722 | } |
| 723 | 723 | |
| 724 | 724 | if ($member->getSingleId() !== '') { |
| 725 | 725 | $andX->add( |
| 726 | - $expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId())) |
|
| 726 | + $expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId())) |
|
| 727 | 727 | ); |
| 728 | 728 | } |
| 729 | 729 | |
| 730 | 730 | if ($member->getUserType() > 0) { |
| 731 | 731 | $andX->add( |
| 732 | - $expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType())) |
|
| 732 | + $expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType())) |
|
| 733 | 733 | ); |
| 734 | 734 | } |
| 735 | 735 | |
@@ -738,7 +738,7 @@ discard block |
||
| 738 | 738 | if ($member->getLevel() > 0) { |
| 739 | 739 | $andX->add( |
| 740 | 740 | $expr->gte( |
| 741 | - $aliasMember . '.level', |
|
| 741 | + $aliasMember.'.level', |
|
| 742 | 742 | $this->createNamedParameter($member->getLevel(), IQueryBuilder::PARAM_INT) |
| 743 | 743 | ) |
| 744 | 744 | ); |
@@ -779,7 +779,7 @@ discard block |
||
| 779 | 779 | $helperAlias, |
| 780 | 780 | CoreRequestBuilder::TABLE_CIRCLE, |
| 781 | 781 | $aliasCircle, |
| 782 | - $expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field) |
|
| 782 | + $expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field) |
|
| 783 | 783 | ); |
| 784 | 784 | |
| 785 | 785 | if (!is_null($initiator)) { |
@@ -810,7 +810,7 @@ discard block |
||
| 810 | 810 | $this->generateCircleSelectAlias($aliasInvitedBy) |
| 811 | 811 | ->leftJoin( |
| 812 | 812 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasInvitedBy, |
| 813 | - $expr->eq($aliasMember . '.invited_by', $aliasInvitedBy . '.unique_id') |
|
| 813 | + $expr->eq($aliasMember.'.invited_by', $aliasInvitedBy.'.unique_id') |
|
| 814 | 814 | ); |
| 815 | 815 | |
| 816 | 816 | $this->leftJoinOwner($aliasInvitedBy); |
@@ -841,7 +841,7 @@ discard block |
||
| 841 | 841 | $this->generateCircleSelectAlias($aliasBasedOn) |
| 842 | 842 | ->leftJoin( |
| 843 | 843 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn, |
| 844 | - $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id') |
|
| 844 | + $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id') |
|
| 845 | 845 | ); |
| 846 | 846 | |
| 847 | 847 | if (!is_null($initiator)) { |
@@ -874,9 +874,9 @@ discard block |
||
| 874 | 874 | ->leftJoin( |
| 875 | 875 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 876 | 876 | $expr->andX( |
| 877 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field), |
|
| 877 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field), |
|
| 878 | 878 | $expr->eq( |
| 879 | - $aliasMember . '.level', |
|
| 879 | + $aliasMember.'.level', |
|
| 880 | 880 | $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT) |
| 881 | 881 | ) |
| 882 | 882 | ) |
@@ -914,10 +914,10 @@ discard block |
||
| 914 | 914 | ->leftJoin( |
| 915 | 915 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 916 | 916 | $expr->andX( |
| 917 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId), |
|
| 918 | - $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId), |
|
| 917 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId), |
|
| 918 | + $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId), |
|
| 919 | 919 | $expr->gte( |
| 920 | - $aliasMember . '.level', |
|
| 920 | + $aliasMember.'.level', |
|
| 921 | 921 | $this->createNamedParameter(Member::LEVEL_MEMBER, self::PARAM_INT) |
| 922 | 922 | ) |
| 923 | 923 | ) |
@@ -950,7 +950,7 @@ discard block |
||
| 950 | 950 | |
| 951 | 951 | $this->leftJoin( |
| 952 | 952 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
| 953 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field) |
|
| 953 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field) |
|
| 954 | 954 | ); |
| 955 | 955 | |
| 956 | 956 | // if (!$this->getBool('getData', $options, false)) { |
@@ -964,8 +964,8 @@ discard block |
||
| 964 | 964 | ->leftJoin( |
| 965 | 965 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
| 966 | 966 | $expr->andX( |
| 967 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'), |
|
| 968 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id') |
|
| 967 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'), |
|
| 968 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id') |
|
| 969 | 969 | ) |
| 970 | 970 | ); |
| 971 | 971 | |
@@ -982,12 +982,12 @@ discard block |
||
| 982 | 982 | $aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options); |
| 983 | 983 | $this->leftJoin( |
| 984 | 984 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership, |
| 985 | - $expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId)) |
|
| 985 | + $expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId)) |
|
| 986 | 986 | ); |
| 987 | 987 | |
| 988 | 988 | $orX = $expr->orX( |
| 989 | - $expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field), |
|
| 990 | - $expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId)) |
|
| 989 | + $expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field), |
|
| 990 | + $expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId)) |
|
| 991 | 991 | ); |
| 992 | 992 | |
| 993 | 993 | $this->andWhere($orX); |
@@ -1008,11 +1008,11 @@ discard block |
||
| 1008 | 1008 | |
| 1009 | 1009 | $expr = $this->expr(); |
| 1010 | 1010 | $aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS); |
| 1011 | - $this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId))); |
|
| 1011 | + $this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId))); |
|
| 1012 | 1012 | if ($level > 1) { |
| 1013 | 1013 | $this->andWhere( |
| 1014 | 1014 | $expr->gte( |
| 1015 | - $aliasMembership . '.level', |
|
| 1015 | + $aliasMembership.'.level', |
|
| 1016 | 1016 | $this->createNamedParameter($level, IQueryBuilder::PARAM_INT) |
| 1017 | 1017 | ) |
| 1018 | 1018 | ); |
@@ -1040,8 +1040,8 @@ discard block |
||
| 1040 | 1040 | $this->leftJoin( |
| 1041 | 1041 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
| 1042 | 1042 | $expr->andX( |
| 1043 | - $expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field), |
|
| 1044 | - $expr->eq($aliasMembership . '.single_id', $alias . '.single_id') |
|
| 1043 | + $expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field), |
|
| 1044 | + $expr->eq($aliasMembership.'.single_id', $alias.'.single_id') |
|
| 1045 | 1045 | ) |
| 1046 | 1046 | ); |
| 1047 | 1047 | |
@@ -1054,8 +1054,8 @@ discard block |
||
| 1054 | 1054 | ->leftJoin( |
| 1055 | 1055 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom, |
| 1056 | 1056 | $expr->andX( |
| 1057 | - $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'), |
|
| 1058 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id') |
|
| 1057 | + $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'), |
|
| 1058 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id') |
|
| 1059 | 1059 | ) |
| 1060 | 1060 | ); |
| 1061 | 1061 | } |
@@ -1095,7 +1095,7 @@ discard block |
||
| 1095 | 1095 | |
| 1096 | 1096 | $this->leftJoin( |
| 1097 | 1097 | $alias, CoreRequestBuilder::TABLE_TOKEN, $aliasShareToken, |
| 1098 | - $expr->eq($aliasShareToken . '.share_id', $alias . '.' . $field) |
|
| 1098 | + $expr->eq($aliasShareToken.'.share_id', $alias.'.'.$field) |
|
| 1099 | 1099 | ); |
| 1100 | 1100 | } |
| 1101 | 1101 | |
@@ -1137,14 +1137,14 @@ discard block |
||
| 1137 | 1137 | try { |
| 1138 | 1138 | $aliasConfig = $this->generateAlias($alias, self::CONFIG, $options); |
| 1139 | 1139 | $this->selectAlias( |
| 1140 | - $aliasConfig . '.config', |
|
| 1141 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'circle_config' |
|
| 1140 | + $aliasConfig.'.config', |
|
| 1141 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'circle_config' |
|
| 1142 | 1142 | ); |
| 1143 | 1143 | $this->leftJoin( |
| 1144 | 1144 | $alias, |
| 1145 | 1145 | CoreRequestBuilder::TABLE_CIRCLE, |
| 1146 | 1146 | $aliasConfig, |
| 1147 | - $expr->eq($alias . '.circle_id', $aliasConfig . '.unique_id') |
|
| 1147 | + $expr->eq($alias.'.circle_id', $aliasConfig.'.unique_id') |
|
| 1148 | 1148 | ); |
| 1149 | 1149 | } catch (RequestBuilderException $e) { |
| 1150 | 1150 | } |
@@ -1182,7 +1182,7 @@ discard block |
||
| 1182 | 1182 | $aliasMembership, |
| 1183 | 1183 | $expr->andX( |
| 1184 | 1184 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), |
| 1185 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field) |
|
| 1185 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field) |
|
| 1186 | 1186 | ) |
| 1187 | 1187 | ); |
| 1188 | 1188 | |
@@ -1201,11 +1201,11 @@ discard block |
||
| 1201 | 1201 | $aliasMembershipCircle = $this->generateAlias($aliasMembership, self::CONFIG, $options); |
| 1202 | 1202 | $orXMembershipCircle = $expr->orX(); |
| 1203 | 1203 | array_map( |
| 1204 | - function (string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { |
|
| 1204 | + function(string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { |
|
| 1205 | 1205 | $orXMembershipCircle->add( |
| 1206 | 1206 | $this->expr()->eq( |
| 1207 | - $alias . '.circle_id', |
|
| 1208 | - $aliasMembershipCircle . '.unique_id' |
|
| 1207 | + $alias.'.circle_id', |
|
| 1208 | + $aliasMembershipCircle.'.unique_id' |
|
| 1209 | 1209 | ) |
| 1210 | 1210 | ); |
| 1211 | 1211 | }, |
@@ -1237,7 +1237,7 @@ discard block |
||
| 1237 | 1237 | $aliasDirectInitiator, |
| 1238 | 1238 | $expr->andX( |
| 1239 | 1239 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasDirectInitiator), |
| 1240 | - $expr->eq($aliasDirectInitiator . '.circle_id', $helperAlias . '.' . $field) |
|
| 1240 | + $expr->eq($aliasDirectInitiator.'.circle_id', $helperAlias.'.'.$field) |
|
| 1241 | 1241 | ) |
| 1242 | 1242 | ); |
| 1243 | 1243 | } catch (RequestBuilderException $e) { |
@@ -1251,8 +1251,8 @@ discard block |
||
| 1251 | 1251 | $this->leftJoin( |
| 1252 | 1252 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator, |
| 1253 | 1253 | $expr->andX( |
| 1254 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'), |
|
| 1255 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id') |
|
| 1254 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'), |
|
| 1255 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id') |
|
| 1256 | 1256 | ) |
| 1257 | 1257 | ); |
| 1258 | 1258 | |
@@ -1260,8 +1260,8 @@ discard block |
||
| 1260 | 1260 | $this->leftJoin( |
| 1261 | 1261 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
| 1262 | 1262 | $expr->andX( |
| 1263 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'), |
|
| 1264 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id') |
|
| 1263 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'), |
|
| 1264 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id') |
|
| 1265 | 1265 | ) |
| 1266 | 1266 | ); |
| 1267 | 1267 | |
@@ -1312,7 +1312,7 @@ discard block |
||
| 1312 | 1312 | $orX->add( |
| 1313 | 1313 | $expr->andX( |
| 1314 | 1314 | $this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $aliasMembershipCircle), |
| 1315 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
| 1315 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
| 1316 | 1316 | ) |
| 1317 | 1317 | ); |
| 1318 | 1318 | } |
@@ -1322,10 +1322,10 @@ discard block |
||
| 1322 | 1322 | $orXLevelCheck = $expr->orX(); |
| 1323 | 1323 | |
| 1324 | 1324 | array_map( |
| 1325 | - function (string $alias) use ($orXLevelCheck, $minimumLevel) { |
|
| 1325 | + function(string $alias) use ($orXLevelCheck, $minimumLevel) { |
|
| 1326 | 1326 | $orXLevelCheck->add( |
| 1327 | 1327 | $this->expr()->gte( |
| 1328 | - $alias . '.level', |
|
| 1328 | + $alias.'.level', |
|
| 1329 | 1329 | $this->createNamedParameter($minimumLevel) |
| 1330 | 1330 | ) |
| 1331 | 1331 | ); |
@@ -1415,21 +1415,21 @@ discard block |
||
| 1415 | 1415 | $expr = $this->expr(); |
| 1416 | 1416 | $andPassive = $expr->andX(); |
| 1417 | 1417 | $andPassive->add( |
| 1418 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 1418 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 1419 | 1419 | ); |
| 1420 | 1420 | |
| 1421 | 1421 | $orMemberOrLevel = $expr->orX(); |
| 1422 | 1422 | $orMemberOrLevel->add( |
| 1423 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance') |
|
| 1423 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance') |
|
| 1424 | 1424 | ); |
| 1425 | 1425 | // TODO: do we need this ? (display members from the local instance) |
| 1426 | 1426 | $orMemberOrLevel->add( |
| 1427 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance') |
|
| 1427 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance') |
|
| 1428 | 1428 | ); |
| 1429 | 1429 | |
| 1430 | 1430 | $orMemberOrLevel->add( |
| 1431 | 1431 | $expr->eq( |
| 1432 | - $this->getDefaultSelectAlias() . '.level', |
|
| 1432 | + $this->getDefaultSelectAlias().'.level', |
|
| 1433 | 1433 | $this->createNamedParameter(Member::LEVEL_OWNER) |
| 1434 | 1434 | ) |
| 1435 | 1435 | ); |
@@ -1466,11 +1466,11 @@ discard block |
||
| 1466 | 1466 | ) |
| 1467 | 1467 | ->leftJoin( |
| 1468 | 1468 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache, |
| 1469 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid') |
|
| 1469 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid') |
|
| 1470 | 1470 | ) |
| 1471 | 1471 | ->leftJoin( |
| 1472 | 1472 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages, |
| 1473 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id') |
|
| 1473 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id') |
|
| 1474 | 1474 | ); |
| 1475 | 1475 | } |
| 1476 | 1476 | |
@@ -1492,8 +1492,8 @@ discard block |
||
| 1492 | 1492 | $this->leftJoin( |
| 1493 | 1493 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild, |
| 1494 | 1494 | $expr->andX( |
| 1495 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'), |
|
| 1496 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id') |
|
| 1495 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'), |
|
| 1496 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id') |
|
| 1497 | 1497 | ) |
| 1498 | 1498 | ); |
| 1499 | 1499 | |
@@ -1543,13 +1543,13 @@ discard block |
||
| 1543 | 1543 | $this->leftJoin( |
| 1544 | 1544 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint, |
| 1545 | 1545 | $expr->andX( |
| 1546 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'), |
|
| 1547 | - $expr->eq($aliasMountpoint . '.single_id', $aliasMountMemberships . '.single_id') |
|
| 1546 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'), |
|
| 1547 | + $expr->eq($aliasMountpoint.'.single_id', $aliasMountMemberships.'.single_id') |
|
| 1548 | 1548 | ) |
| 1549 | 1549 | ); |
| 1550 | 1550 | |
| 1551 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint'); |
|
| 1552 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash'); |
|
| 1551 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint'); |
|
| 1552 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash'); |
|
| 1553 | 1553 | } |
| 1554 | 1554 | |
| 1555 | 1555 | |
@@ -1657,10 +1657,10 @@ discard block |
||
| 1657 | 1657 | */ |
| 1658 | 1658 | public function generateAlias(string $base, string $extension, ?array &$options = []): string { |
| 1659 | 1659 | $search = str_replace('_', '.', $base); |
| 1660 | - $path = $search . '.' . $extension; |
|
| 1660 | + $path = $search.'.'.$extension; |
|
| 1661 | 1661 | if (!$this->validKey($path, self::$SQL_PATH) |
| 1662 | 1662 | && !in_array($extension, $this->getArray($search, self::$SQL_PATH))) { |
| 1663 | - throw new RequestBuilderException($extension . ' not found in ' . $search); |
|
| 1663 | + throw new RequestBuilderException($extension.' not found in '.$search); |
|
| 1664 | 1664 | } |
| 1665 | 1665 | |
| 1666 | 1666 | if (!is_array($options)) { |
@@ -1669,15 +1669,15 @@ discard block |
||
| 1669 | 1669 | |
| 1670 | 1670 | $optionPath = ''; |
| 1671 | 1671 | foreach (explode('.', $path) as $p) { |
| 1672 | - $optionPath = trim($optionPath . '.' . $p, '.'); |
|
| 1672 | + $optionPath = trim($optionPath.'.'.$p, '.'); |
|
| 1673 | 1673 | $options = array_merge( |
| 1674 | 1674 | $options, |
| 1675 | - $this->getArray($optionPath . '.' . self::OPTIONS, self::$SQL_PATH), |
|
| 1676 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options) |
|
| 1675 | + $this->getArray($optionPath.'.'.self::OPTIONS, self::$SQL_PATH), |
|
| 1676 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options) |
|
| 1677 | 1677 | ); |
| 1678 | 1678 | } |
| 1679 | 1679 | |
| 1680 | - return $base . '_' . $extension; |
|
| 1680 | + return $base.'_'.$extension; |
|
| 1681 | 1681 | } |
| 1682 | 1682 | |
| 1683 | 1683 | |
@@ -1697,7 +1697,7 @@ discard block |
||
| 1697 | 1697 | } else { |
| 1698 | 1698 | $k = $arr; |
| 1699 | 1699 | } |
| 1700 | - $path[$k] = $prefix . '_' . $k . '_'; |
|
| 1700 | + $path[$k] = $prefix.'_'.$k.'_'; |
|
| 1701 | 1701 | } |
| 1702 | 1702 | |
| 1703 | 1703 | return $path; |
@@ -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 | } |