@@ -399,8 +399,8 @@ discard block |
||
| 399 | 399 | foreach (explode(' ', $circle->getDisplayName()) as $word) { |
| 400 | 400 | $andX->add( |
| 401 | 401 | $expr->iLike( |
| 402 | - $this->getDefaultSelectAlias() . '.' . 'display_name', |
|
| 403 | - $this->createNamedParameter('%' . $word . '%') |
|
| 402 | + $this->getDefaultSelectAlias().'.'.'display_name', |
|
| 403 | + $this->createNamedParameter('%'.$word.'%') |
|
| 404 | 404 | ) |
| 405 | 405 | ); |
| 406 | 406 | } |
@@ -411,8 +411,8 @@ discard block |
||
| 411 | 411 | foreach (explode(' ', $circle->getDescription()) as $word) { |
| 412 | 412 | $orDescription->add( |
| 413 | 413 | $expr->iLike( |
| 414 | - $this->getDefaultSelectAlias() . '.' . 'description', |
|
| 415 | - $this->createNamedParameter('%' . $word . '%') |
|
| 414 | + $this->getDefaultSelectAlias().'.'.'description', |
|
| 415 | + $this->createNamedParameter('%'.$word.'%') |
|
| 416 | 416 | ) |
| 417 | 417 | ); |
| 418 | 418 | } |
@@ -442,7 +442,7 @@ discard block |
||
| 442 | 442 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance) |
| 443 | 443 | ->leftJoin( |
| 444 | 444 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance, |
| 445 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance') |
|
| 445 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance') |
|
| 446 | 446 | ); |
| 447 | 447 | } catch (RequestBuilderException $e) { |
| 448 | 448 | } |
@@ -494,7 +494,7 @@ discard block |
||
| 494 | 494 | $expr = $this->expr(); |
| 495 | 495 | $this->leftJoin( |
| 496 | 496 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote, |
| 497 | - $expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
| 497 | + $expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
| 498 | 498 | ); |
| 499 | 499 | } |
| 500 | 500 | |
@@ -522,12 +522,12 @@ discard block |
||
| 522 | 522 | $this->leftJoin( |
| 523 | 523 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember, |
| 524 | 524 | $expr->andX( |
| 525 | - $expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'), |
|
| 525 | + $expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'), |
|
| 526 | 526 | $expr->eq( |
| 527 | - $aliasRemoteMember . '.instance', |
|
| 527 | + $aliasRemoteMember.'.instance', |
|
| 528 | 528 | $this->createNamedParameter($remoteInstance->getInstance()) |
| 529 | 529 | ), |
| 530 | - $expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 530 | + $expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 531 | 531 | ) |
| 532 | 532 | ); |
| 533 | 533 | } |
@@ -559,21 +559,21 @@ discard block |
||
| 559 | 559 | $this->leftJoin( |
| 560 | 560 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle, |
| 561 | 561 | $expr->andX( |
| 562 | - $expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'), |
|
| 563 | - $expr->emptyString($aliasRemoteCircle . '.instance'), |
|
| 564 | - $expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 562 | + $expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'), |
|
| 563 | + $expr->emptyString($aliasRemoteCircle.'.instance'), |
|
| 564 | + $expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 565 | 565 | ) |
| 566 | 566 | ); |
| 567 | 567 | $this->leftJoin( |
| 568 | 568 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner, |
| 569 | 569 | $expr->andX( |
| 570 | - $expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'), |
|
| 570 | + $expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'), |
|
| 571 | 571 | $expr->eq( |
| 572 | - $aliasRemoteCircleOwner . '.instance', |
|
| 572 | + $aliasRemoteCircleOwner.'.instance', |
|
| 573 | 573 | $this->createNamedParameter($remoteInstance->getInstance()) |
| 574 | 574 | ), |
| 575 | 575 | $expr->eq( |
| 576 | - $aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
| 576 | + $aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
| 577 | 577 | ) |
| 578 | 578 | ) |
| 579 | 579 | ); |
@@ -606,16 +606,16 @@ discard block |
||
| 606 | 606 | $expr = $this->expr(); |
| 607 | 607 | $orX = $expr->orX(); |
| 608 | 608 | $orX->add( |
| 609 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
| 609 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
| 610 | 610 | ); |
| 611 | 611 | |
| 612 | 612 | $orExtOrPassive = $expr->orX(); |
| 613 | 613 | $orExtOrPassive->add( |
| 614 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
| 614 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
| 615 | 615 | ); |
| 616 | 616 | if (!$sensitive) { |
| 617 | 617 | $orExtOrPassive->add( |
| 618 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 618 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 619 | 619 | ); |
| 620 | 620 | } else { |
| 621 | 621 | if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) { |
@@ -624,8 +624,8 @@ discard block |
||
| 624 | 624 | } |
| 625 | 625 | |
| 626 | 626 | $orInstance = $expr->orX(); |
| 627 | - $orInstance->add($expr->isNotNull($aliasRemoteMember . '.instance')); |
|
| 628 | - $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner . '.instance')); |
|
| 627 | + $orInstance->add($expr->isNotNull($aliasRemoteMember.'.instance')); |
|
| 628 | + $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner.'.instance')); |
|
| 629 | 629 | |
| 630 | 630 | $andExternal = $expr->andX(); |
| 631 | 631 | $andExternal->add($orExtOrPassive); |
@@ -634,13 +634,13 @@ discard block |
||
| 634 | 634 | $orExtOrTrusted = $expr->orX(); |
| 635 | 635 | $orExtOrTrusted->add($andExternal); |
| 636 | 636 | $orExtOrTrusted->add( |
| 637 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
| 637 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
| 638 | 638 | ); |
| 639 | 639 | |
| 640 | 640 | $andTrusted = $expr->andX(); |
| 641 | 641 | $andTrusted->add($orExtOrTrusted); |
| 642 | 642 | $andTrusted->add($this->exprLimitBitwise('config', Circle::CFG_FEDERATED, $aliasCircle)); |
| 643 | - $andTrusted->add($expr->emptyString($aliasOwner . '.instance')); |
|
| 643 | + $andTrusted->add($expr->emptyString($aliasOwner.'.instance')); |
|
| 644 | 644 | $orX->add($andTrusted); |
| 645 | 645 | |
| 646 | 646 | $this->andWhere($orX); |
@@ -667,7 +667,7 @@ discard block |
||
| 667 | 667 | } |
| 668 | 668 | $this->innerJoin( |
| 669 | 669 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 670 | - $expr->eq($aliasMember . '.circle_id', $alias . '.unique_id') |
|
| 670 | + $expr->eq($aliasMember.'.circle_id', $alias.'.unique_id') |
|
| 671 | 671 | ); |
| 672 | 672 | |
| 673 | 673 | $this->filterDirectMembership($aliasMember, $member); |
@@ -692,12 +692,12 @@ discard block |
||
| 692 | 692 | $aliasCircle, |
| 693 | 693 | 'circles_membership', |
| 694 | 694 | $aliasMembership, |
| 695 | - $this->expr()->eq($aliasCircle . '.unique_id', $aliasMembership . '.circle_id') |
|
| 695 | + $this->expr()->eq($aliasCircle.'.unique_id', $aliasMembership.'.circle_id') |
|
| 696 | 696 | ); |
| 697 | 697 | |
| 698 | 698 | $this->andWhere( |
| 699 | 699 | $this->expr()->eq( |
| 700 | - $aliasMembership . '.single_id', |
|
| 700 | + $aliasMembership.'.single_id', |
|
| 701 | 701 | $this->createNamedParameter($federatedUser->getSingleId()) |
| 702 | 702 | ) |
| 703 | 703 | ); |
@@ -718,19 +718,19 @@ discard block |
||
| 718 | 718 | |
| 719 | 719 | if ($member->getUserId() !== '') { |
| 720 | 720 | $andX->add( |
| 721 | - $expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId())) |
|
| 721 | + $expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId())) |
|
| 722 | 722 | ); |
| 723 | 723 | } |
| 724 | 724 | |
| 725 | 725 | if ($member->getSingleId() !== '') { |
| 726 | 726 | $andX->add( |
| 727 | - $expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId())) |
|
| 727 | + $expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId())) |
|
| 728 | 728 | ); |
| 729 | 729 | } |
| 730 | 730 | |
| 731 | 731 | if ($member->getUserType() > 0) { |
| 732 | 732 | $andX->add( |
| 733 | - $expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType())) |
|
| 733 | + $expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType())) |
|
| 734 | 734 | ); |
| 735 | 735 | } |
| 736 | 736 | |
@@ -739,7 +739,7 @@ discard block |
||
| 739 | 739 | if ($member->getLevel() > 0) { |
| 740 | 740 | $andX->add( |
| 741 | 741 | $expr->gte( |
| 742 | - $aliasMember . '.level', |
|
| 742 | + $aliasMember.'.level', |
|
| 743 | 743 | $this->createNamedParameter($member->getLevel(), IQueryBuilder::PARAM_INT) |
| 744 | 744 | ) |
| 745 | 745 | ); |
@@ -780,7 +780,7 @@ discard block |
||
| 780 | 780 | $helperAlias, |
| 781 | 781 | CoreRequestBuilder::TABLE_CIRCLE, |
| 782 | 782 | $aliasCircle, |
| 783 | - $expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field) |
|
| 783 | + $expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field) |
|
| 784 | 784 | ); |
| 785 | 785 | |
| 786 | 786 | if (!is_null($initiator)) { |
@@ -811,7 +811,7 @@ discard block |
||
| 811 | 811 | $this->generateCircleSelectAlias($aliasInvitedBy) |
| 812 | 812 | ->leftJoin( |
| 813 | 813 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasInvitedBy, |
| 814 | - $expr->eq($aliasMember . '.invited_by', $aliasInvitedBy . '.unique_id') |
|
| 814 | + $expr->eq($aliasMember.'.invited_by', $aliasInvitedBy.'.unique_id') |
|
| 815 | 815 | ); |
| 816 | 816 | |
| 817 | 817 | $this->leftJoinOwner($aliasInvitedBy); |
@@ -842,7 +842,7 @@ discard block |
||
| 842 | 842 | $this->generateCircleSelectAlias($aliasBasedOn) |
| 843 | 843 | ->leftJoin( |
| 844 | 844 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn, |
| 845 | - $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id') |
|
| 845 | + $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id') |
|
| 846 | 846 | ); |
| 847 | 847 | |
| 848 | 848 | if (!is_null($initiator)) { |
@@ -875,9 +875,9 @@ discard block |
||
| 875 | 875 | ->leftJoin( |
| 876 | 876 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 877 | 877 | $expr->andX( |
| 878 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field), |
|
| 878 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field), |
|
| 879 | 879 | $expr->eq( |
| 880 | - $aliasMember . '.level', |
|
| 880 | + $aliasMember.'.level', |
|
| 881 | 881 | $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT) |
| 882 | 882 | ) |
| 883 | 883 | ) |
@@ -909,9 +909,9 @@ discard block |
||
| 909 | 909 | ->innerJoin( |
| 910 | 910 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
| 911 | 911 | $expr->andX( |
| 912 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field), |
|
| 912 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field), |
|
| 913 | 913 | $expr->eq( |
| 914 | - $aliasMembership . '.level', |
|
| 914 | + $aliasMembership.'.level', |
|
| 915 | 915 | $this->createNamedParameter( |
| 916 | 916 | Member::LEVEL_MEMBER, |
| 917 | 917 | self::PARAM_INT |
@@ -952,10 +952,10 @@ discard block |
||
| 952 | 952 | ->leftJoin( |
| 953 | 953 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 954 | 954 | $expr->andX( |
| 955 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId), |
|
| 956 | - $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId), |
|
| 955 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId), |
|
| 956 | + $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId), |
|
| 957 | 957 | $expr->gte( |
| 958 | - $aliasMember . '.level', |
|
| 958 | + $aliasMember.'.level', |
|
| 959 | 959 | $this->createNamedParameter(Member::LEVEL_MEMBER, self::PARAM_INT) |
| 960 | 960 | ) |
| 961 | 961 | ) |
@@ -988,7 +988,7 @@ discard block |
||
| 988 | 988 | |
| 989 | 989 | $this->leftJoin( |
| 990 | 990 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
| 991 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field) |
|
| 991 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field) |
|
| 992 | 992 | ); |
| 993 | 993 | |
| 994 | 994 | // if (!$this->getBool('getData', $options, false)) { |
@@ -1002,8 +1002,8 @@ discard block |
||
| 1002 | 1002 | ->leftJoin( |
| 1003 | 1003 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
| 1004 | 1004 | $expr->andX( |
| 1005 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'), |
|
| 1006 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id') |
|
| 1005 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'), |
|
| 1006 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id') |
|
| 1007 | 1007 | ) |
| 1008 | 1008 | ); |
| 1009 | 1009 | |
@@ -1020,12 +1020,12 @@ discard block |
||
| 1020 | 1020 | $aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options); |
| 1021 | 1021 | $this->leftJoin( |
| 1022 | 1022 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership, |
| 1023 | - $expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId)) |
|
| 1023 | + $expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId)) |
|
| 1024 | 1024 | ); |
| 1025 | 1025 | |
| 1026 | 1026 | $orX = $expr->orX( |
| 1027 | - $expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field), |
|
| 1028 | - $expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId)) |
|
| 1027 | + $expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field), |
|
| 1028 | + $expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId)) |
|
| 1029 | 1029 | ); |
| 1030 | 1030 | |
| 1031 | 1031 | $this->andWhere($orX); |
@@ -1046,11 +1046,11 @@ discard block |
||
| 1046 | 1046 | |
| 1047 | 1047 | $expr = $this->expr(); |
| 1048 | 1048 | $aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS); |
| 1049 | - $this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId))); |
|
| 1049 | + $this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId))); |
|
| 1050 | 1050 | if ($level > 1) { |
| 1051 | 1051 | $this->andWhere( |
| 1052 | 1052 | $expr->gte( |
| 1053 | - $aliasMembership . '.level', |
|
| 1053 | + $aliasMembership.'.level', |
|
| 1054 | 1054 | $this->createNamedParameter($level, IQueryBuilder::PARAM_INT) |
| 1055 | 1055 | ) |
| 1056 | 1056 | ); |
@@ -1078,8 +1078,8 @@ discard block |
||
| 1078 | 1078 | $this->leftJoin( |
| 1079 | 1079 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
| 1080 | 1080 | $expr->andX( |
| 1081 | - $expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field), |
|
| 1082 | - $expr->eq($aliasMembership . '.single_id', $alias . '.single_id') |
|
| 1081 | + $expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field), |
|
| 1082 | + $expr->eq($aliasMembership.'.single_id', $alias.'.single_id') |
|
| 1083 | 1083 | ) |
| 1084 | 1084 | ); |
| 1085 | 1085 | |
@@ -1092,8 +1092,8 @@ discard block |
||
| 1092 | 1092 | ->leftJoin( |
| 1093 | 1093 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom, |
| 1094 | 1094 | $expr->andX( |
| 1095 | - $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'), |
|
| 1096 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id') |
|
| 1095 | + $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'), |
|
| 1096 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id') |
|
| 1097 | 1097 | ) |
| 1098 | 1098 | ); |
| 1099 | 1099 | } |
@@ -1133,7 +1133,7 @@ discard block |
||
| 1133 | 1133 | |
| 1134 | 1134 | $this->leftJoin( |
| 1135 | 1135 | $alias, CoreRequestBuilder::TABLE_TOKEN, $aliasShareToken, |
| 1136 | - $expr->eq($aliasShareToken . '.share_id', $alias . '.' . $field) |
|
| 1136 | + $expr->eq($aliasShareToken.'.share_id', $alias.'.'.$field) |
|
| 1137 | 1137 | ); |
| 1138 | 1138 | } |
| 1139 | 1139 | |
@@ -1175,14 +1175,14 @@ discard block |
||
| 1175 | 1175 | try { |
| 1176 | 1176 | $aliasConfig = $this->generateAlias($alias, self::CONFIG, $options); |
| 1177 | 1177 | $this->selectAlias( |
| 1178 | - $aliasConfig . '.config', |
|
| 1179 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'circle_config' |
|
| 1178 | + $aliasConfig.'.config', |
|
| 1179 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'circle_config' |
|
| 1180 | 1180 | ); |
| 1181 | 1181 | $this->leftJoin( |
| 1182 | 1182 | $alias, |
| 1183 | 1183 | CoreRequestBuilder::TABLE_CIRCLE, |
| 1184 | 1184 | $aliasConfig, |
| 1185 | - $expr->eq($alias . '.circle_id', $aliasConfig . '.unique_id') |
|
| 1185 | + $expr->eq($alias.'.circle_id', $aliasConfig.'.unique_id') |
|
| 1186 | 1186 | ); |
| 1187 | 1187 | } catch (RequestBuilderException $e) { |
| 1188 | 1188 | } |
@@ -1220,7 +1220,7 @@ discard block |
||
| 1220 | 1220 | $aliasMembership, |
| 1221 | 1221 | $expr->andX( |
| 1222 | 1222 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), |
| 1223 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field) |
|
| 1223 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field) |
|
| 1224 | 1224 | ) |
| 1225 | 1225 | ); |
| 1226 | 1226 | |
@@ -1239,11 +1239,11 @@ discard block |
||
| 1239 | 1239 | $aliasMembershipCircle = $this->generateAlias($aliasMembership, self::CONFIG, $options); |
| 1240 | 1240 | $orXMembershipCircle = $expr->orX(); |
| 1241 | 1241 | array_map( |
| 1242 | - function (string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { |
|
| 1242 | + function(string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { |
|
| 1243 | 1243 | $orXMembershipCircle->add( |
| 1244 | 1244 | $this->expr()->eq( |
| 1245 | - $alias . '.circle_id', |
|
| 1246 | - $aliasMembershipCircle . '.unique_id' |
|
| 1245 | + $alias.'.circle_id', |
|
| 1246 | + $aliasMembershipCircle.'.unique_id' |
|
| 1247 | 1247 | ) |
| 1248 | 1248 | ); |
| 1249 | 1249 | }, |
@@ -1275,7 +1275,7 @@ discard block |
||
| 1275 | 1275 | $aliasDirectInitiator, |
| 1276 | 1276 | $expr->andX( |
| 1277 | 1277 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasDirectInitiator), |
| 1278 | - $expr->eq($aliasDirectInitiator . '.circle_id', $helperAlias . '.' . $field) |
|
| 1278 | + $expr->eq($aliasDirectInitiator.'.circle_id', $helperAlias.'.'.$field) |
|
| 1279 | 1279 | ) |
| 1280 | 1280 | ); |
| 1281 | 1281 | } catch (RequestBuilderException $e) { |
@@ -1289,8 +1289,8 @@ discard block |
||
| 1289 | 1289 | $this->leftJoin( |
| 1290 | 1290 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator, |
| 1291 | 1291 | $expr->andX( |
| 1292 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'), |
|
| 1293 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id') |
|
| 1292 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'), |
|
| 1293 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id') |
|
| 1294 | 1294 | ) |
| 1295 | 1295 | ); |
| 1296 | 1296 | |
@@ -1298,8 +1298,8 @@ discard block |
||
| 1298 | 1298 | $this->leftJoin( |
| 1299 | 1299 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
| 1300 | 1300 | $expr->andX( |
| 1301 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'), |
|
| 1302 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id') |
|
| 1301 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'), |
|
| 1302 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id') |
|
| 1303 | 1303 | ) |
| 1304 | 1304 | ); |
| 1305 | 1305 | |
@@ -1350,7 +1350,7 @@ discard block |
||
| 1350 | 1350 | $orX->add( |
| 1351 | 1351 | $expr->andX( |
| 1352 | 1352 | $this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $aliasMembershipCircle), |
| 1353 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
| 1353 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
| 1354 | 1354 | ) |
| 1355 | 1355 | ); |
| 1356 | 1356 | } |
@@ -1360,10 +1360,10 @@ discard block |
||
| 1360 | 1360 | $orXLevelCheck = $expr->orX(); |
| 1361 | 1361 | |
| 1362 | 1362 | array_map( |
| 1363 | - function (string $alias) use ($orXLevelCheck, $minimumLevel) { |
|
| 1363 | + function(string $alias) use ($orXLevelCheck, $minimumLevel) { |
|
| 1364 | 1364 | $orXLevelCheck->add( |
| 1365 | 1365 | $this->expr()->gte( |
| 1366 | - $alias . '.level', |
|
| 1366 | + $alias.'.level', |
|
| 1367 | 1367 | $this->createNamedParameter($minimumLevel) |
| 1368 | 1368 | ) |
| 1369 | 1369 | ); |
@@ -1453,21 +1453,21 @@ discard block |
||
| 1453 | 1453 | $expr = $this->expr(); |
| 1454 | 1454 | $andPassive = $expr->andX(); |
| 1455 | 1455 | $andPassive->add( |
| 1456 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 1456 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 1457 | 1457 | ); |
| 1458 | 1458 | |
| 1459 | 1459 | $orMemberOrLevel = $expr->orX(); |
| 1460 | 1460 | $orMemberOrLevel->add( |
| 1461 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance') |
|
| 1461 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance') |
|
| 1462 | 1462 | ); |
| 1463 | 1463 | // TODO: do we need this ? (display members from the local instance) |
| 1464 | 1464 | $orMemberOrLevel->add( |
| 1465 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance') |
|
| 1465 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance') |
|
| 1466 | 1466 | ); |
| 1467 | 1467 | |
| 1468 | 1468 | $orMemberOrLevel->add( |
| 1469 | 1469 | $expr->eq( |
| 1470 | - $this->getDefaultSelectAlias() . '.level', |
|
| 1470 | + $this->getDefaultSelectAlias().'.level', |
|
| 1471 | 1471 | $this->createNamedParameter(Member::LEVEL_OWNER) |
| 1472 | 1472 | ) |
| 1473 | 1473 | ); |
@@ -1504,11 +1504,11 @@ discard block |
||
| 1504 | 1504 | ) |
| 1505 | 1505 | ->leftJoin( |
| 1506 | 1506 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache, |
| 1507 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid') |
|
| 1507 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid') |
|
| 1508 | 1508 | ) |
| 1509 | 1509 | ->leftJoin( |
| 1510 | 1510 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages, |
| 1511 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id') |
|
| 1511 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id') |
|
| 1512 | 1512 | ); |
| 1513 | 1513 | } |
| 1514 | 1514 | |
@@ -1530,8 +1530,8 @@ discard block |
||
| 1530 | 1530 | $this->leftJoin( |
| 1531 | 1531 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild, |
| 1532 | 1532 | $expr->andX( |
| 1533 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'), |
|
| 1534 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id') |
|
| 1533 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'), |
|
| 1534 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id') |
|
| 1535 | 1535 | ) |
| 1536 | 1536 | ); |
| 1537 | 1537 | |
@@ -1581,13 +1581,13 @@ discard block |
||
| 1581 | 1581 | $this->leftJoin( |
| 1582 | 1582 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint, |
| 1583 | 1583 | $expr->andX( |
| 1584 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'), |
|
| 1585 | - $expr->eq($aliasMountpoint . '.single_id', $aliasMountMemberships . '.single_id') |
|
| 1584 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'), |
|
| 1585 | + $expr->eq($aliasMountpoint.'.single_id', $aliasMountMemberships.'.single_id') |
|
| 1586 | 1586 | ) |
| 1587 | 1587 | ); |
| 1588 | 1588 | |
| 1589 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint'); |
|
| 1590 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash'); |
|
| 1589 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint'); |
|
| 1590 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash'); |
|
| 1591 | 1591 | } |
| 1592 | 1592 | |
| 1593 | 1593 | |
@@ -1695,10 +1695,10 @@ discard block |
||
| 1695 | 1695 | */ |
| 1696 | 1696 | public function generateAlias(string $base, string $extension, ?array &$options = []): string { |
| 1697 | 1697 | $search = str_replace('_', '.', $base); |
| 1698 | - $path = $search . '.' . $extension; |
|
| 1698 | + $path = $search.'.'.$extension; |
|
| 1699 | 1699 | if (!$this->validKey($path, $this->getSqlPath()) |
| 1700 | 1700 | && !in_array($extension, $this->getArray($search, $this->getSqlPath()))) { |
| 1701 | - throw new RequestBuilderException($extension . ' not found in ' . $search); |
|
| 1701 | + throw new RequestBuilderException($extension.' not found in '.$search); |
|
| 1702 | 1702 | } |
| 1703 | 1703 | |
| 1704 | 1704 | if (!is_array($options)) { |
@@ -1707,15 +1707,15 @@ discard block |
||
| 1707 | 1707 | |
| 1708 | 1708 | $optionPath = ''; |
| 1709 | 1709 | foreach (explode('.', $path) as $p) { |
| 1710 | - $optionPath = trim($optionPath . '.' . $p, '.'); |
|
| 1710 | + $optionPath = trim($optionPath.'.'.$p, '.'); |
|
| 1711 | 1711 | $options = array_merge( |
| 1712 | 1712 | $options, |
| 1713 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->getSqlPath()), |
|
| 1714 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options) |
|
| 1713 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->getSqlPath()), |
|
| 1714 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options) |
|
| 1715 | 1715 | ); |
| 1716 | 1716 | } |
| 1717 | 1717 | |
| 1718 | - return $base . '_' . $extension; |
|
| 1718 | + return $base.'_'.$extension; |
|
| 1719 | 1719 | } |
| 1720 | 1720 | |
| 1721 | 1721 | |
@@ -1735,7 +1735,7 @@ discard block |
||
| 1735 | 1735 | } else { |
| 1736 | 1736 | $k = $arr; |
| 1737 | 1737 | } |
| 1738 | - $path[$k] = $prefix . '_' . $k . '_'; |
|
| 1738 | + $path[$k] = $prefix.'_'.$k.'_'; |
|
| 1739 | 1739 | } |
| 1740 | 1740 | |
| 1741 | 1741 | return $path; |
@@ -580,7 +580,7 @@ discard block |
||
| 580 | 580 | |
| 581 | 581 | $i = 1; |
| 582 | 582 | while (true) { |
| 583 | - $testDisplayName = $baseDisplayName . (($i > 1) ? ' (' . $i . ')' : ''); |
|
| 583 | + $testDisplayName = $baseDisplayName.(($i > 1) ? ' ('.$i.')' : ''); |
|
| 584 | 584 | $test = new Circle(); |
| 585 | 585 | $test->setDisplayName($testDisplayName); |
| 586 | 586 | |
@@ -613,7 +613,7 @@ discard block |
||
| 613 | 613 | |
| 614 | 614 | $i = 1; |
| 615 | 615 | while (true) { |
| 616 | - $testSanitizedName = $baseSanitizedName . (($i > 1) ? ' (' . $i . ')' : ''); |
|
| 616 | + $testSanitizedName = $baseSanitizedName.(($i > 1) ? ' ('.$i.')' : ''); |
|
| 617 | 617 | |
| 618 | 618 | $test = new Circle(); |
| 619 | 619 | $test->setSanitizedName($testSanitizedName); |
@@ -755,7 +755,7 @@ discard block |
||
| 755 | 755 | |
| 756 | 756 | |
| 757 | 757 | private function generateGetCirclesCacheKey(FederatedUser $federatedUser, string $probeSum): string { |
| 758 | - return $federatedUser->getSingleId() . '#' . $probeSum; |
|
| 758 | + return $federatedUser->getSingleId().'#'.$probeSum; |
|
| 759 | 759 | } |
| 760 | 760 | |
| 761 | 761 | |