@@ -393,7 +393,7 @@ discard block |
||
| 393 | 393 | } |
| 394 | 394 | |
| 395 | 395 | if ($circle->getDisplayName() !== '') { |
| 396 | - $this->searchInDBField('display_name', '%' . $circle->getDisplayName() . '%'); |
|
| 396 | + $this->searchInDBField('display_name', '%'.$circle->getDisplayName().'%'); |
|
| 397 | 397 | } |
| 398 | 398 | if ($circle->getSource() > 0) { |
| 399 | 399 | $this->limitInt('source', $circle->getSource()); |
@@ -415,7 +415,7 @@ discard block |
||
| 415 | 415 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance) |
| 416 | 416 | ->leftJoin( |
| 417 | 417 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance, |
| 418 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance') |
|
| 418 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance') |
|
| 419 | 419 | ); |
| 420 | 420 | } catch (RequestBuilderException $e) { |
| 421 | 421 | } |
@@ -467,7 +467,7 @@ discard block |
||
| 467 | 467 | $expr = $this->expr(); |
| 468 | 468 | $this->leftJoin( |
| 469 | 469 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote, |
| 470 | - $expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
| 470 | + $expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
| 471 | 471 | ); |
| 472 | 472 | } |
| 473 | 473 | |
@@ -495,12 +495,12 @@ discard block |
||
| 495 | 495 | $this->leftJoin( |
| 496 | 496 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember, |
| 497 | 497 | $expr->andX( |
| 498 | - $expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'), |
|
| 498 | + $expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'), |
|
| 499 | 499 | $expr->eq( |
| 500 | - $aliasRemoteMember . '.instance', |
|
| 500 | + $aliasRemoteMember.'.instance', |
|
| 501 | 501 | $this->createNamedParameter($remoteInstance->getInstance()) |
| 502 | 502 | ), |
| 503 | - $expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 503 | + $expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 504 | 504 | ) |
| 505 | 505 | ); |
| 506 | 506 | } |
@@ -532,21 +532,21 @@ discard block |
||
| 532 | 532 | $this->leftJoin( |
| 533 | 533 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle, |
| 534 | 534 | $expr->andX( |
| 535 | - $expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'), |
|
| 536 | - $expr->emptyString($aliasRemoteCircle . '.instance'), |
|
| 537 | - $expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 535 | + $expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'), |
|
| 536 | + $expr->emptyString($aliasRemoteCircle.'.instance'), |
|
| 537 | + $expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 538 | 538 | ) |
| 539 | 539 | ); |
| 540 | 540 | $this->leftJoin( |
| 541 | 541 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner, |
| 542 | 542 | $expr->andX( |
| 543 | - $expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'), |
|
| 543 | + $expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'), |
|
| 544 | 544 | $expr->eq( |
| 545 | - $aliasRemoteCircleOwner . '.instance', |
|
| 545 | + $aliasRemoteCircleOwner.'.instance', |
|
| 546 | 546 | $this->createNamedParameter($remoteInstance->getInstance()) |
| 547 | 547 | ), |
| 548 | 548 | $expr->eq( |
| 549 | - $aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
| 549 | + $aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
| 550 | 550 | ) |
| 551 | 551 | ) |
| 552 | 552 | ); |
@@ -579,16 +579,16 @@ discard block |
||
| 579 | 579 | $expr = $this->expr(); |
| 580 | 580 | $orX = $expr->orX(); |
| 581 | 581 | $orX->add( |
| 582 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
| 582 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
| 583 | 583 | ); |
| 584 | 584 | |
| 585 | 585 | $orExtOrPassive = $expr->orX(); |
| 586 | 586 | $orExtOrPassive->add( |
| 587 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
| 587 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
| 588 | 588 | ); |
| 589 | 589 | if (!$sensitive) { |
| 590 | 590 | $orExtOrPassive->add( |
| 591 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 591 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 592 | 592 | ); |
| 593 | 593 | } else { |
| 594 | 594 | if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) { |
@@ -597,8 +597,8 @@ discard block |
||
| 597 | 597 | } |
| 598 | 598 | |
| 599 | 599 | $orInstance = $expr->orX(); |
| 600 | - $orInstance->add($expr->isNotNull($aliasRemoteMember . '.instance')); |
|
| 601 | - $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner . '.instance')); |
|
| 600 | + $orInstance->add($expr->isNotNull($aliasRemoteMember.'.instance')); |
|
| 601 | + $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner.'.instance')); |
|
| 602 | 602 | |
| 603 | 603 | $andExternal = $expr->andX(); |
| 604 | 604 | $andExternal->add($orExtOrPassive); |
@@ -607,13 +607,13 @@ discard block |
||
| 607 | 607 | $orExtOrTrusted = $expr->orX(); |
| 608 | 608 | $orExtOrTrusted->add($andExternal); |
| 609 | 609 | $orExtOrTrusted->add( |
| 610 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
| 610 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
| 611 | 611 | ); |
| 612 | 612 | |
| 613 | 613 | $andTrusted = $expr->andX(); |
| 614 | 614 | $andTrusted->add($orExtOrTrusted); |
| 615 | 615 | $andTrusted->add($this->exprLimitBitwise('config', Circle::CFG_FEDERATED, $aliasCircle)); |
| 616 | - $andTrusted->add($expr->emptyString($aliasOwner . '.instance')); |
|
| 616 | + $andTrusted->add($expr->emptyString($aliasOwner.'.instance')); |
|
| 617 | 617 | $orX->add($andTrusted); |
| 618 | 618 | |
| 619 | 619 | $this->andWhere($orX); |
@@ -640,7 +640,7 @@ discard block |
||
| 640 | 640 | } |
| 641 | 641 | $this->leftJoin( |
| 642 | 642 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 643 | - $expr->eq($aliasMember . '.circle_id', $alias . '.unique_id') |
|
| 643 | + $expr->eq($aliasMember.'.circle_id', $alias.'.unique_id') |
|
| 644 | 644 | ); |
| 645 | 645 | |
| 646 | 646 | $this->filterDirectMembership($aliasMember, $member); |
@@ -661,30 +661,30 @@ discard block |
||
| 661 | 661 | |
| 662 | 662 | if ($member->getUserId() !== '') { |
| 663 | 663 | $andX->add( |
| 664 | - $expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId())) |
|
| 664 | + $expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId())) |
|
| 665 | 665 | ); |
| 666 | 666 | } |
| 667 | 667 | |
| 668 | 668 | if ($member->getSingleId() !== '') { |
| 669 | 669 | $andX->add( |
| 670 | - $expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId())) |
|
| 670 | + $expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId())) |
|
| 671 | 671 | ); |
| 672 | 672 | } |
| 673 | 673 | |
| 674 | 674 | if ($member->getUserType() > 0) { |
| 675 | 675 | $andX->add( |
| 676 | - $expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType())) |
|
| 676 | + $expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType())) |
|
| 677 | 677 | ); |
| 678 | 678 | } |
| 679 | 679 | |
| 680 | 680 | $andX->add( |
| 681 | - $expr->eq($aliasMember . '.instance', $this->createNamedParameter($this->getInstance($member))) |
|
| 681 | + $expr->eq($aliasMember.'.instance', $this->createNamedParameter($this->getInstance($member))) |
|
| 682 | 682 | ); |
| 683 | 683 | |
| 684 | 684 | if ($member->getLevel() > 0) { |
| 685 | 685 | $andX->add( |
| 686 | 686 | $expr->gte( |
| 687 | - $aliasMember . '.level', |
|
| 687 | + $aliasMember.'.level', |
|
| 688 | 688 | $this->createNamedParameter($member->getLevel(), IQueryBuilder::PARAM_INT) |
| 689 | 689 | ) |
| 690 | 690 | ); |
@@ -715,12 +715,12 @@ discard block |
||
| 715 | 715 | |
| 716 | 716 | $expr = $this->expr(); |
| 717 | 717 | $this->selectAlias( |
| 718 | - $this->createFunction('COUNT(`' . $aliasMemberCount . '`.`member_id`)'), |
|
| 719 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'population' |
|
| 718 | + $this->createFunction('COUNT(`'.$aliasMemberCount.'`.`member_id`)'), |
|
| 719 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'population' |
|
| 720 | 720 | ); |
| 721 | 721 | $this->leftJoin( |
| 722 | 722 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMemberCount, |
| 723 | - $expr->eq($alias . '.unique_id', $aliasMemberCount . '.circle_id') |
|
| 723 | + $expr->eq($alias.'.unique_id', $aliasMemberCount.'.circle_id') |
|
| 724 | 724 | ); |
| 725 | 725 | } |
| 726 | 726 | |
@@ -756,7 +756,7 @@ discard block |
||
| 756 | 756 | $helperAlias, |
| 757 | 757 | CoreRequestBuilder::TABLE_CIRCLE, |
| 758 | 758 | $aliasCircle, |
| 759 | - $expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field) |
|
| 759 | + $expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field) |
|
| 760 | 760 | ); |
| 761 | 761 | |
| 762 | 762 | if (!is_null($initiator)) { |
@@ -787,7 +787,7 @@ discard block |
||
| 787 | 787 | $this->generateCircleSelectAlias($aliasInvitedBy) |
| 788 | 788 | ->leftJoin( |
| 789 | 789 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasInvitedBy, |
| 790 | - $expr->eq($aliasMember . '.invited_by', $aliasInvitedBy . '.unique_id') |
|
| 790 | + $expr->eq($aliasMember.'.invited_by', $aliasInvitedBy.'.unique_id') |
|
| 791 | 791 | ); |
| 792 | 792 | |
| 793 | 793 | $this->leftJoinOwner($aliasInvitedBy); |
@@ -818,7 +818,7 @@ discard block |
||
| 818 | 818 | $this->generateCircleSelectAlias($aliasBasedOn) |
| 819 | 819 | ->leftJoin( |
| 820 | 820 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn, |
| 821 | - $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id') |
|
| 821 | + $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id') |
|
| 822 | 822 | ); |
| 823 | 823 | |
| 824 | 824 | if (!is_null($initiator)) { |
@@ -851,9 +851,9 @@ discard block |
||
| 851 | 851 | ->leftJoin( |
| 852 | 852 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 853 | 853 | $expr->andX( |
| 854 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field), |
|
| 854 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field), |
|
| 855 | 855 | $expr->eq( |
| 856 | - $aliasMember . '.level', |
|
| 856 | + $aliasMember.'.level', |
|
| 857 | 857 | $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT) |
| 858 | 858 | ) |
| 859 | 859 | ) |
@@ -891,10 +891,10 @@ discard block |
||
| 891 | 891 | ->leftJoin( |
| 892 | 892 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 893 | 893 | $expr->andX( |
| 894 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId), |
|
| 895 | - $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId), |
|
| 894 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId), |
|
| 895 | + $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId), |
|
| 896 | 896 | $expr->gte( |
| 897 | - $aliasMember . '.level', |
|
| 897 | + $aliasMember.'.level', |
|
| 898 | 898 | $this->createNamedParameter(Member::LEVEL_MEMBER, self::PARAM_INT) |
| 899 | 899 | ) |
| 900 | 900 | ) |
@@ -927,7 +927,7 @@ discard block |
||
| 927 | 927 | |
| 928 | 928 | $this->leftJoin( |
| 929 | 929 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
| 930 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field) |
|
| 930 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field) |
|
| 931 | 931 | ); |
| 932 | 932 | |
| 933 | 933 | // if (!$this->getBool('getData', $options, false)) { |
@@ -941,8 +941,8 @@ discard block |
||
| 941 | 941 | ->leftJoin( |
| 942 | 942 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
| 943 | 943 | $expr->andX( |
| 944 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'), |
|
| 945 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id') |
|
| 944 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'), |
|
| 945 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id') |
|
| 946 | 946 | ) |
| 947 | 947 | ); |
| 948 | 948 | |
@@ -959,12 +959,12 @@ discard block |
||
| 959 | 959 | $aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options); |
| 960 | 960 | $this->leftJoin( |
| 961 | 961 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership, |
| 962 | - $expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId)) |
|
| 962 | + $expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId)) |
|
| 963 | 963 | ); |
| 964 | 964 | |
| 965 | 965 | $orX = $expr->orX( |
| 966 | - $expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field), |
|
| 967 | - $expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId)) |
|
| 966 | + $expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field), |
|
| 967 | + $expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId)) |
|
| 968 | 968 | ); |
| 969 | 969 | |
| 970 | 970 | $this->andWhere($orX); |
@@ -985,11 +985,11 @@ discard block |
||
| 985 | 985 | |
| 986 | 986 | $expr = $this->expr(); |
| 987 | 987 | $aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS); |
| 988 | - $this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId))); |
|
| 988 | + $this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId))); |
|
| 989 | 989 | if ($level > 1) { |
| 990 | 990 | $this->andWhere( |
| 991 | 991 | $expr->gte( |
| 992 | - $aliasMembership . '.level', |
|
| 992 | + $aliasMembership.'.level', |
|
| 993 | 993 | $this->createNamedParameter($level, IQueryBuilder::PARAM_INT) |
| 994 | 994 | ) |
| 995 | 995 | ); |
@@ -1017,8 +1017,8 @@ discard block |
||
| 1017 | 1017 | $this->leftJoin( |
| 1018 | 1018 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
| 1019 | 1019 | $expr->andX( |
| 1020 | - $expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field), |
|
| 1021 | - $expr->eq($aliasMembership . '.single_id', $alias . '.single_id') |
|
| 1020 | + $expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field), |
|
| 1021 | + $expr->eq($aliasMembership.'.single_id', $alias.'.single_id') |
|
| 1022 | 1022 | ) |
| 1023 | 1023 | ); |
| 1024 | 1024 | |
@@ -1031,8 +1031,8 @@ discard block |
||
| 1031 | 1031 | ->leftJoin( |
| 1032 | 1032 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom, |
| 1033 | 1033 | $expr->andX( |
| 1034 | - $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'), |
|
| 1035 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id') |
|
| 1034 | + $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'), |
|
| 1035 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id') |
|
| 1036 | 1036 | ) |
| 1037 | 1037 | ); |
| 1038 | 1038 | } |
@@ -1065,7 +1065,7 @@ discard block |
||
| 1065 | 1065 | |
| 1066 | 1066 | $this->leftJoin( |
| 1067 | 1067 | $alias, CoreRequestBuilder::TABLE_TOKEN, $aliasShareToken, |
| 1068 | - $expr->eq($aliasShareToken . '.share_id', $alias . '.' . $field) |
|
| 1068 | + $expr->eq($aliasShareToken.'.share_id', $alias.'.'.$field) |
|
| 1069 | 1069 | ); |
| 1070 | 1070 | } |
| 1071 | 1071 | |
@@ -1107,14 +1107,14 @@ discard block |
||
| 1107 | 1107 | try { |
| 1108 | 1108 | $aliasConfig = $this->generateAlias($alias, self::CONFIG, $options); |
| 1109 | 1109 | $this->selectAlias( |
| 1110 | - $aliasConfig . '.config', |
|
| 1111 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'circle_config' |
|
| 1110 | + $aliasConfig.'.config', |
|
| 1111 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'circle_config' |
|
| 1112 | 1112 | ); |
| 1113 | 1113 | $this->leftJoin( |
| 1114 | 1114 | $alias, |
| 1115 | 1115 | CoreRequestBuilder::TABLE_CIRCLE, |
| 1116 | 1116 | $aliasConfig, |
| 1117 | - $expr->eq($alias . '.circle_id', $aliasConfig . '.unique_id') |
|
| 1117 | + $expr->eq($alias.'.circle_id', $aliasConfig.'.unique_id') |
|
| 1118 | 1118 | ); |
| 1119 | 1119 | } catch (RequestBuilderException $e) { |
| 1120 | 1120 | } |
@@ -1152,7 +1152,7 @@ discard block |
||
| 1152 | 1152 | $aliasMembership, |
| 1153 | 1153 | $expr->andX( |
| 1154 | 1154 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), |
| 1155 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field) |
|
| 1155 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field) |
|
| 1156 | 1156 | ) |
| 1157 | 1157 | ); |
| 1158 | 1158 | |
@@ -1162,7 +1162,7 @@ discard block |
||
| 1162 | 1162 | $aliasMembership, |
| 1163 | 1163 | CoreRequestBuilder::TABLE_CIRCLE, |
| 1164 | 1164 | $aliasMembershipCircle, |
| 1165 | - $expr->eq($aliasMembership . '.circle_id', $aliasMembershipCircle . '.unique_id') |
|
| 1165 | + $expr->eq($aliasMembership.'.circle_id', $aliasMembershipCircle.'.unique_id') |
|
| 1166 | 1166 | ); |
| 1167 | 1167 | } catch (RequestBuilderException $e) { |
| 1168 | 1168 | } |
@@ -1183,7 +1183,7 @@ discard block |
||
| 1183 | 1183 | $aliasDirectInitiator, |
| 1184 | 1184 | $expr->andX( |
| 1185 | 1185 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasDirectInitiator), |
| 1186 | - $expr->eq($aliasDirectInitiator . '.circle_id', $helperAlias . '.' . $field) |
|
| 1186 | + $expr->eq($aliasDirectInitiator.'.circle_id', $helperAlias.'.'.$field) |
|
| 1187 | 1187 | ) |
| 1188 | 1188 | ); |
| 1189 | 1189 | } catch (RequestBuilderException $e) { |
@@ -1196,8 +1196,8 @@ discard block |
||
| 1196 | 1196 | $this->leftJoin( |
| 1197 | 1197 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator, |
| 1198 | 1198 | $expr->andX( |
| 1199 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'), |
|
| 1200 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id') |
|
| 1199 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'), |
|
| 1200 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id') |
|
| 1201 | 1201 | ) |
| 1202 | 1202 | ); |
| 1203 | 1203 | |
@@ -1205,8 +1205,8 @@ discard block |
||
| 1205 | 1205 | $this->leftJoin( |
| 1206 | 1206 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
| 1207 | 1207 | $expr->andX( |
| 1208 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'), |
|
| 1209 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id') |
|
| 1208 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'), |
|
| 1209 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id') |
|
| 1210 | 1210 | ) |
| 1211 | 1211 | ); |
| 1212 | 1212 | |
@@ -1257,7 +1257,7 @@ discard block |
||
| 1257 | 1257 | $orX->add( |
| 1258 | 1258 | $expr->andX( |
| 1259 | 1259 | $this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $aliasMembershipCircle), |
| 1260 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
| 1260 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
| 1261 | 1261 | ) |
| 1262 | 1262 | ); |
| 1263 | 1263 | } |
@@ -1342,21 +1342,21 @@ discard block |
||
| 1342 | 1342 | $expr = $this->expr(); |
| 1343 | 1343 | $andPassive = $expr->andX(); |
| 1344 | 1344 | $andPassive->add( |
| 1345 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 1345 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 1346 | 1346 | ); |
| 1347 | 1347 | |
| 1348 | 1348 | $orMemberOrLevel = $expr->orX(); |
| 1349 | 1349 | $orMemberOrLevel->add( |
| 1350 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance') |
|
| 1350 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance') |
|
| 1351 | 1351 | ); |
| 1352 | 1352 | // TODO: do we need this ? (display members from the local instance) |
| 1353 | 1353 | $orMemberOrLevel->add( |
| 1354 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance') |
|
| 1354 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance') |
|
| 1355 | 1355 | ); |
| 1356 | 1356 | |
| 1357 | 1357 | $orMemberOrLevel->add( |
| 1358 | 1358 | $expr->eq( |
| 1359 | - $this->getDefaultSelectAlias() . '.level', |
|
| 1359 | + $this->getDefaultSelectAlias().'.level', |
|
| 1360 | 1360 | $this->createNamedParameter(Member::LEVEL_OWNER) |
| 1361 | 1361 | ) |
| 1362 | 1362 | ); |
@@ -1393,11 +1393,11 @@ discard block |
||
| 1393 | 1393 | ) |
| 1394 | 1394 | ->leftJoin( |
| 1395 | 1395 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache, |
| 1396 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid') |
|
| 1396 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid') |
|
| 1397 | 1397 | ) |
| 1398 | 1398 | ->leftJoin( |
| 1399 | 1399 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages, |
| 1400 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id') |
|
| 1400 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id') |
|
| 1401 | 1401 | ); |
| 1402 | 1402 | } |
| 1403 | 1403 | |
@@ -1419,8 +1419,8 @@ discard block |
||
| 1419 | 1419 | $this->leftJoin( |
| 1420 | 1420 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild, |
| 1421 | 1421 | $expr->andX( |
| 1422 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'), |
|
| 1423 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id') |
|
| 1422 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'), |
|
| 1423 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id') |
|
| 1424 | 1424 | ) |
| 1425 | 1425 | ); |
| 1426 | 1426 | |
@@ -1470,13 +1470,13 @@ discard block |
||
| 1470 | 1470 | $this->leftJoin( |
| 1471 | 1471 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint, |
| 1472 | 1472 | $expr->andX( |
| 1473 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'), |
|
| 1474 | - $expr->eq($aliasMountpoint . '.single_id', $aliasMountMemberships . '.single_id') |
|
| 1473 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'), |
|
| 1474 | + $expr->eq($aliasMountpoint.'.single_id', $aliasMountMemberships.'.single_id') |
|
| 1475 | 1475 | ) |
| 1476 | 1476 | ); |
| 1477 | 1477 | |
| 1478 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint'); |
|
| 1479 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash'); |
|
| 1478 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint'); |
|
| 1479 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash'); |
|
| 1480 | 1480 | } |
| 1481 | 1481 | |
| 1482 | 1482 | |
@@ -1580,10 +1580,10 @@ discard block |
||
| 1580 | 1580 | */ |
| 1581 | 1581 | public function generateAlias(string $base, string $extension, ?array &$options = []): string { |
| 1582 | 1582 | $search = str_replace('_', '.', $base); |
| 1583 | - $path = $search . '.' . $extension; |
|
| 1583 | + $path = $search.'.'.$extension; |
|
| 1584 | 1584 | if (!$this->validKey($path, self::$SQL_PATH) |
| 1585 | 1585 | && !in_array($extension, $this->getArray($search, self::$SQL_PATH))) { |
| 1586 | - throw new RequestBuilderException($extension . ' not found in ' . $search); |
|
| 1586 | + throw new RequestBuilderException($extension.' not found in '.$search); |
|
| 1587 | 1587 | } |
| 1588 | 1588 | |
| 1589 | 1589 | if (!is_array($options)) { |
@@ -1592,15 +1592,15 @@ discard block |
||
| 1592 | 1592 | |
| 1593 | 1593 | $optionPath = ''; |
| 1594 | 1594 | foreach (explode('.', $path) as $p) { |
| 1595 | - $optionPath = trim($optionPath . '.' . $p, '.'); |
|
| 1595 | + $optionPath = trim($optionPath.'.'.$p, '.'); |
|
| 1596 | 1596 | $options = array_merge( |
| 1597 | 1597 | $options, |
| 1598 | - $this->getArray($optionPath . '.' . self::OPTIONS, self::$SQL_PATH), |
|
| 1599 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options) |
|
| 1598 | + $this->getArray($optionPath.'.'.self::OPTIONS, self::$SQL_PATH), |
|
| 1599 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options) |
|
| 1600 | 1600 | ); |
| 1601 | 1601 | } |
| 1602 | 1602 | |
| 1603 | - return $base . '_' . $extension; |
|
| 1603 | + return $base.'_'.$extension; |
|
| 1604 | 1604 | } |
| 1605 | 1605 | |
| 1606 | 1606 | |
@@ -1620,7 +1620,7 @@ discard block |
||
| 1620 | 1620 | } else { |
| 1621 | 1621 | $k = $arr; |
| 1622 | 1622 | } |
| 1623 | - $path[$k] = $prefix . '_' . $k . '_'; |
|
| 1623 | + $path[$k] = $prefix.'_'.$k.'_'; |
|
| 1624 | 1624 | } |
| 1625 | 1625 | |
| 1626 | 1626 | return $path; |
@@ -1637,7 +1637,7 @@ discard block |
||
| 1637 | 1637 | $expr = $this->expr(); |
| 1638 | 1638 | $orX = $expr->orX(); |
| 1639 | 1639 | foreach ($aliases as $alias) { |
| 1640 | - $orX->add($expr->gte($alias . '.level', $this->createNamedParameter($level))); |
|
| 1640 | + $orX->add($expr->gte($alias.'.level', $this->createNamedParameter($level))); |
|
| 1641 | 1641 | } |
| 1642 | 1642 | |
| 1643 | 1643 | return $orX; |