@@ -395,7 +395,7 @@ discard block |
||
395 | 395 | } |
396 | 396 | |
397 | 397 | if ($circle->getDisplayName() !== '') { |
398 | - $this->searchInDBField('display_name', '%' . $circle->getDisplayName() . '%'); |
|
398 | + $this->searchInDBField('display_name', '%'.$circle->getDisplayName().'%'); |
|
399 | 399 | } |
400 | 400 | if ($circle->getConfig() > 0) { |
401 | 401 | $this->limitBitwise('config', $circle->getConfig()); |
@@ -414,7 +414,7 @@ discard block |
||
414 | 414 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance) |
415 | 415 | ->leftJoin( |
416 | 416 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance, |
417 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance') |
|
417 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance') |
|
418 | 418 | ); |
419 | 419 | } catch (RequestBuilderException $e) { |
420 | 420 | } |
@@ -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 | } |
@@ -1075,14 +1075,14 @@ discard block |
||
1075 | 1075 | try { |
1076 | 1076 | $aliasConfig = $this->generateAlias($alias, self::CONFIG, $options); |
1077 | 1077 | $this->selectAlias( |
1078 | - $aliasConfig . '.config', |
|
1079 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'circle_config' |
|
1078 | + $aliasConfig.'.config', |
|
1079 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'circle_config' |
|
1080 | 1080 | ); |
1081 | 1081 | $this->leftJoin( |
1082 | 1082 | $alias, |
1083 | 1083 | CoreRequestBuilder::TABLE_CIRCLE, |
1084 | 1084 | $aliasConfig, |
1085 | - $expr->eq($alias . '.circle_id', $aliasConfig . '.unique_id') |
|
1085 | + $expr->eq($alias.'.circle_id', $aliasConfig.'.unique_id') |
|
1086 | 1086 | ); |
1087 | 1087 | } catch (RequestBuilderException $e) { |
1088 | 1088 | } |
@@ -1120,7 +1120,7 @@ discard block |
||
1120 | 1120 | $aliasMembership, |
1121 | 1121 | $expr->andX( |
1122 | 1122 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), |
1123 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field) |
|
1123 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field) |
|
1124 | 1124 | ) |
1125 | 1125 | ); |
1126 | 1126 | |
@@ -1130,7 +1130,7 @@ discard block |
||
1130 | 1130 | $aliasMembership, |
1131 | 1131 | CoreRequestBuilder::TABLE_CIRCLE, |
1132 | 1132 | $aliasMembershipCircle, |
1133 | - $expr->eq($aliasMembership . '.circle_id', $aliasMembershipCircle . '.unique_id') |
|
1133 | + $expr->eq($aliasMembership.'.circle_id', $aliasMembershipCircle.'.unique_id') |
|
1134 | 1134 | ); |
1135 | 1135 | } catch (RequestBuilderException $e) { |
1136 | 1136 | } |
@@ -1151,7 +1151,7 @@ discard block |
||
1151 | 1151 | $aliasDirectInitiator, |
1152 | 1152 | $expr->andX( |
1153 | 1153 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasDirectInitiator), |
1154 | - $expr->eq($aliasDirectInitiator . '.circle_id', $helperAlias . '.' . $field) |
|
1154 | + $expr->eq($aliasDirectInitiator.'.circle_id', $helperAlias.'.'.$field) |
|
1155 | 1155 | ) |
1156 | 1156 | ); |
1157 | 1157 | } catch (RequestBuilderException $e) { |
@@ -1164,8 +1164,8 @@ discard block |
||
1164 | 1164 | $this->leftJoin( |
1165 | 1165 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator, |
1166 | 1166 | $expr->andX( |
1167 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'), |
|
1168 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id') |
|
1167 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'), |
|
1168 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id') |
|
1169 | 1169 | ) |
1170 | 1170 | ); |
1171 | 1171 | |
@@ -1173,8 +1173,8 @@ discard block |
||
1173 | 1173 | $this->leftJoin( |
1174 | 1174 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
1175 | 1175 | $expr->andX( |
1176 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'), |
|
1177 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id') |
|
1176 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'), |
|
1177 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id') |
|
1178 | 1178 | ) |
1179 | 1179 | ); |
1180 | 1180 | |
@@ -1226,7 +1226,7 @@ discard block |
||
1226 | 1226 | $orX->add( |
1227 | 1227 | $expr->andX( |
1228 | 1228 | $this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $aliasMembershipCircle), |
1229 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
1229 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
1230 | 1230 | ) |
1231 | 1231 | ); |
1232 | 1232 | } |
@@ -1315,21 +1315,21 @@ discard block |
||
1315 | 1315 | $expr = $this->expr(); |
1316 | 1316 | $andPassive = $expr->andX(); |
1317 | 1317 | $andPassive->add( |
1318 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
1318 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
1319 | 1319 | ); |
1320 | 1320 | |
1321 | 1321 | $orMemberOrLevel = $expr->orX(); |
1322 | 1322 | $orMemberOrLevel->add( |
1323 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance') |
|
1323 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance') |
|
1324 | 1324 | ); |
1325 | 1325 | // TODO: do we need this ? (display members from the local instance) |
1326 | 1326 | $orMemberOrLevel->add( |
1327 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance') |
|
1327 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance') |
|
1328 | 1328 | ); |
1329 | 1329 | |
1330 | 1330 | $orMemberOrLevel->add( |
1331 | 1331 | $expr->eq( |
1332 | - $this->getDefaultSelectAlias() . '.level', |
|
1332 | + $this->getDefaultSelectAlias().'.level', |
|
1333 | 1333 | $this->createNamedParameter(Member::LEVEL_OWNER) |
1334 | 1334 | ) |
1335 | 1335 | ); |
@@ -1366,11 +1366,11 @@ discard block |
||
1366 | 1366 | ) |
1367 | 1367 | ->leftJoin( |
1368 | 1368 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache, |
1369 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid') |
|
1369 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid') |
|
1370 | 1370 | ) |
1371 | 1371 | ->leftJoin( |
1372 | 1372 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages, |
1373 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id') |
|
1373 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id') |
|
1374 | 1374 | ); |
1375 | 1375 | } |
1376 | 1376 | |
@@ -1392,8 +1392,8 @@ discard block |
||
1392 | 1392 | $this->leftJoin( |
1393 | 1393 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild, |
1394 | 1394 | $expr->andX( |
1395 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'), |
|
1396 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id') |
|
1395 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'), |
|
1396 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id') |
|
1397 | 1397 | ) |
1398 | 1398 | ); |
1399 | 1399 | |
@@ -1443,13 +1443,13 @@ discard block |
||
1443 | 1443 | $this->leftJoin( |
1444 | 1444 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint, |
1445 | 1445 | $expr->andX( |
1446 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'), |
|
1447 | - $expr->eq($aliasMountpoint . '.single_id', $aliasMountMemberships . '.single_id') |
|
1446 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'), |
|
1447 | + $expr->eq($aliasMountpoint.'.single_id', $aliasMountMemberships.'.single_id') |
|
1448 | 1448 | ) |
1449 | 1449 | ); |
1450 | 1450 | |
1451 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint'); |
|
1452 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash'); |
|
1451 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint'); |
|
1452 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash'); |
|
1453 | 1453 | } |
1454 | 1454 | |
1455 | 1455 | |
@@ -1553,10 +1553,10 @@ discard block |
||
1553 | 1553 | */ |
1554 | 1554 | public function generateAlias(string $base, string $extension, ?array &$options = []): string { |
1555 | 1555 | $search = str_replace('_', '.', $base); |
1556 | - $path = $search . '.' . $extension; |
|
1556 | + $path = $search.'.'.$extension; |
|
1557 | 1557 | if (!$this->validKey($path, self::$SQL_PATH) |
1558 | 1558 | && !in_array($extension, $this->getArray($search, self::$SQL_PATH))) { |
1559 | - throw new RequestBuilderException($extension . ' not found in ' . $search); |
|
1559 | + throw new RequestBuilderException($extension.' not found in '.$search); |
|
1560 | 1560 | } |
1561 | 1561 | |
1562 | 1562 | if (!is_array($options)) { |
@@ -1565,15 +1565,15 @@ discard block |
||
1565 | 1565 | |
1566 | 1566 | $optionPath = ''; |
1567 | 1567 | foreach (explode('.', $path) as $p) { |
1568 | - $optionPath = trim($optionPath . '.' . $p, '.'); |
|
1568 | + $optionPath = trim($optionPath.'.'.$p, '.'); |
|
1569 | 1569 | $options = array_merge( |
1570 | 1570 | $options, |
1571 | - $this->getArray($optionPath . '.' . self::OPTIONS, self::$SQL_PATH), |
|
1572 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options) |
|
1571 | + $this->getArray($optionPath.'.'.self::OPTIONS, self::$SQL_PATH), |
|
1572 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options) |
|
1573 | 1573 | ); |
1574 | 1574 | } |
1575 | 1575 | |
1576 | - return $base . '_' . $extension; |
|
1576 | + return $base.'_'.$extension; |
|
1577 | 1577 | } |
1578 | 1578 | |
1579 | 1579 | |
@@ -1593,7 +1593,7 @@ discard block |
||
1593 | 1593 | } else { |
1594 | 1594 | $k = $arr; |
1595 | 1595 | } |
1596 | - $path[$k] = $prefix . '_' . $k . '_'; |
|
1596 | + $path[$k] = $prefix.'_'.$k.'_'; |
|
1597 | 1597 | } |
1598 | 1598 | |
1599 | 1599 | return $path; |
@@ -1610,7 +1610,7 @@ discard block |
||
1610 | 1610 | $expr = $this->expr(); |
1611 | 1611 | $orX = $expr->orX(); |
1612 | 1612 | foreach ($aliases as $alias) { |
1613 | - $orX->add($expr->gte($alias . '.level', $this->createNamedParameter($level))); |
|
1613 | + $orX->add($expr->gte($alias.'.level', $this->createNamedParameter($level))); |
|
1614 | 1614 | } |
1615 | 1615 | |
1616 | 1616 | return $orX; |