@@ -394,7 +394,7 @@ discard block |
||
394 | 394 | } |
395 | 395 | |
396 | 396 | if ($circle->getDisplayName() !== '') { |
397 | - $this->searchInDBField('display_name', '%' . $circle->getDisplayName() . '%'); |
|
397 | + $this->searchInDBField('display_name', '%'.$circle->getDisplayName().'%'); |
|
398 | 398 | } |
399 | 399 | if ($circle->getSource() > 0) { |
400 | 400 | $this->limitInt('source', $circle->getSource()); |
@@ -416,7 +416,7 @@ discard block |
||
416 | 416 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance) |
417 | 417 | ->leftJoin( |
418 | 418 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance, |
419 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance') |
|
419 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance') |
|
420 | 420 | ); |
421 | 421 | } catch (RequestBuilderException $e) { |
422 | 422 | } |
@@ -468,7 +468,7 @@ discard block |
||
468 | 468 | $expr = $this->expr(); |
469 | 469 | $this->leftJoin( |
470 | 470 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote, |
471 | - $expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
471 | + $expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
472 | 472 | ); |
473 | 473 | } |
474 | 474 | |
@@ -496,12 +496,12 @@ discard block |
||
496 | 496 | $this->leftJoin( |
497 | 497 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember, |
498 | 498 | $expr->andX( |
499 | - $expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'), |
|
499 | + $expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'), |
|
500 | 500 | $expr->eq( |
501 | - $aliasRemoteMember . '.instance', |
|
501 | + $aliasRemoteMember.'.instance', |
|
502 | 502 | $this->createNamedParameter($remoteInstance->getInstance()) |
503 | 503 | ), |
504 | - $expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
504 | + $expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
505 | 505 | ) |
506 | 506 | ); |
507 | 507 | } |
@@ -533,21 +533,21 @@ discard block |
||
533 | 533 | $this->leftJoin( |
534 | 534 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle, |
535 | 535 | $expr->andX( |
536 | - $expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'), |
|
537 | - $expr->emptyString($aliasRemoteCircle . '.instance'), |
|
538 | - $expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
536 | + $expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'), |
|
537 | + $expr->emptyString($aliasRemoteCircle.'.instance'), |
|
538 | + $expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
539 | 539 | ) |
540 | 540 | ); |
541 | 541 | $this->leftJoin( |
542 | 542 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner, |
543 | 543 | $expr->andX( |
544 | - $expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'), |
|
544 | + $expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'), |
|
545 | 545 | $expr->eq( |
546 | - $aliasRemoteCircleOwner . '.instance', |
|
546 | + $aliasRemoteCircleOwner.'.instance', |
|
547 | 547 | $this->createNamedParameter($remoteInstance->getInstance()) |
548 | 548 | ), |
549 | 549 | $expr->eq( |
550 | - $aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
550 | + $aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
551 | 551 | ) |
552 | 552 | ) |
553 | 553 | ); |
@@ -580,16 +580,16 @@ discard block |
||
580 | 580 | $expr = $this->expr(); |
581 | 581 | $orX = $expr->orX(); |
582 | 582 | $orX->add( |
583 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
583 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
584 | 584 | ); |
585 | 585 | |
586 | 586 | $orExtOrPassive = $expr->orX(); |
587 | 587 | $orExtOrPassive->add( |
588 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
588 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
589 | 589 | ); |
590 | 590 | if (!$sensitive) { |
591 | 591 | $orExtOrPassive->add( |
592 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
592 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
593 | 593 | ); |
594 | 594 | } else { |
595 | 595 | if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) { |
@@ -598,8 +598,8 @@ discard block |
||
598 | 598 | } |
599 | 599 | |
600 | 600 | $orInstance = $expr->orX(); |
601 | - $orInstance->add($expr->isNotNull($aliasRemoteMember . '.instance')); |
|
602 | - $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner . '.instance')); |
|
601 | + $orInstance->add($expr->isNotNull($aliasRemoteMember.'.instance')); |
|
602 | + $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner.'.instance')); |
|
603 | 603 | |
604 | 604 | $andExternal = $expr->andX(); |
605 | 605 | $andExternal->add($orExtOrPassive); |
@@ -608,13 +608,13 @@ discard block |
||
608 | 608 | $orExtOrTrusted = $expr->orX(); |
609 | 609 | $orExtOrTrusted->add($andExternal); |
610 | 610 | $orExtOrTrusted->add( |
611 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
611 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
612 | 612 | ); |
613 | 613 | |
614 | 614 | $andTrusted = $expr->andX(); |
615 | 615 | $andTrusted->add($orExtOrTrusted); |
616 | 616 | $andTrusted->add($this->exprLimitBitwise('config', Circle::CFG_FEDERATED, $aliasCircle)); |
617 | - $andTrusted->add($expr->emptyString($aliasOwner . '.instance')); |
|
617 | + $andTrusted->add($expr->emptyString($aliasOwner.'.instance')); |
|
618 | 618 | $orX->add($andTrusted); |
619 | 619 | |
620 | 620 | $this->andWhere($orX); |
@@ -641,7 +641,7 @@ discard block |
||
641 | 641 | } |
642 | 642 | $this->leftJoin( |
643 | 643 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
644 | - $expr->eq($aliasMember . '.circle_id', $alias . '.unique_id') |
|
644 | + $expr->eq($aliasMember.'.circle_id', $alias.'.unique_id') |
|
645 | 645 | ); |
646 | 646 | |
647 | 647 | $this->filterDirectMembership($aliasMember, $member); |
@@ -662,30 +662,30 @@ discard block |
||
662 | 662 | |
663 | 663 | if ($member->getUserId() !== '') { |
664 | 664 | $andX->add( |
665 | - $expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId())) |
|
665 | + $expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId())) |
|
666 | 666 | ); |
667 | 667 | } |
668 | 668 | |
669 | 669 | if ($member->getSingleId() !== '') { |
670 | 670 | $andX->add( |
671 | - $expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId())) |
|
671 | + $expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId())) |
|
672 | 672 | ); |
673 | 673 | } |
674 | 674 | |
675 | 675 | if ($member->getUserType() > 0) { |
676 | 676 | $andX->add( |
677 | - $expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType())) |
|
677 | + $expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType())) |
|
678 | 678 | ); |
679 | 679 | } |
680 | 680 | |
681 | 681 | $andX->add( |
682 | - $expr->eq($aliasMember . '.instance', $this->createNamedParameter($this->getInstance($member))) |
|
682 | + $expr->eq($aliasMember.'.instance', $this->createNamedParameter($this->getInstance($member))) |
|
683 | 683 | ); |
684 | 684 | |
685 | 685 | if ($member->getLevel() > 0) { |
686 | 686 | $andX->add( |
687 | 687 | $expr->gte( |
688 | - $aliasMember . '.level', |
|
688 | + $aliasMember.'.level', |
|
689 | 689 | $this->createNamedParameter($member->getLevel(), IQueryBuilder::PARAM_INT) |
690 | 690 | ) |
691 | 691 | ); |
@@ -716,12 +716,12 @@ discard block |
||
716 | 716 | |
717 | 717 | $expr = $this->expr(); |
718 | 718 | $this->selectAlias( |
719 | - $this->createFunction('COUNT(`' . $aliasMemberCount . '`.`member_id`)'), |
|
720 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'population' |
|
719 | + $this->createFunction('COUNT(`'.$aliasMemberCount.'`.`member_id`)'), |
|
720 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'population' |
|
721 | 721 | ); |
722 | 722 | $this->leftJoin( |
723 | 723 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMemberCount, |
724 | - $expr->eq($alias . '.unique_id', $aliasMemberCount . '.circle_id') |
|
724 | + $expr->eq($alias.'.unique_id', $aliasMemberCount.'.circle_id') |
|
725 | 725 | ); |
726 | 726 | } |
727 | 727 | |
@@ -757,7 +757,7 @@ discard block |
||
757 | 757 | $helperAlias, |
758 | 758 | CoreRequestBuilder::TABLE_CIRCLE, |
759 | 759 | $aliasCircle, |
760 | - $expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field) |
|
760 | + $expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field) |
|
761 | 761 | ); |
762 | 762 | |
763 | 763 | if (!is_null($initiator)) { |
@@ -788,7 +788,7 @@ discard block |
||
788 | 788 | $this->generateCircleSelectAlias($aliasInvitedBy) |
789 | 789 | ->leftJoin( |
790 | 790 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasInvitedBy, |
791 | - $expr->eq($aliasMember . '.invited_by', $aliasInvitedBy . '.unique_id') |
|
791 | + $expr->eq($aliasMember.'.invited_by', $aliasInvitedBy.'.unique_id') |
|
792 | 792 | ); |
793 | 793 | |
794 | 794 | $this->leftJoinOwner($aliasInvitedBy); |
@@ -819,7 +819,7 @@ discard block |
||
819 | 819 | $this->generateCircleSelectAlias($aliasBasedOn) |
820 | 820 | ->leftJoin( |
821 | 821 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn, |
822 | - $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id') |
|
822 | + $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id') |
|
823 | 823 | ); |
824 | 824 | |
825 | 825 | if (!is_null($initiator)) { |
@@ -852,9 +852,9 @@ discard block |
||
852 | 852 | ->leftJoin( |
853 | 853 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
854 | 854 | $expr->andX( |
855 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field), |
|
855 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field), |
|
856 | 856 | $expr->eq( |
857 | - $aliasMember . '.level', |
|
857 | + $aliasMember.'.level', |
|
858 | 858 | $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT) |
859 | 859 | ) |
860 | 860 | ) |
@@ -892,10 +892,10 @@ discard block |
||
892 | 892 | ->leftJoin( |
893 | 893 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
894 | 894 | $expr->andX( |
895 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId), |
|
896 | - $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId), |
|
895 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId), |
|
896 | + $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId), |
|
897 | 897 | $expr->gte( |
898 | - $aliasMember . '.level', |
|
898 | + $aliasMember.'.level', |
|
899 | 899 | $this->createNamedParameter(Member::LEVEL_MEMBER, self::PARAM_INT) |
900 | 900 | ) |
901 | 901 | ) |
@@ -928,7 +928,7 @@ discard block |
||
928 | 928 | |
929 | 929 | $this->leftJoin( |
930 | 930 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
931 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field) |
|
931 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field) |
|
932 | 932 | ); |
933 | 933 | |
934 | 934 | // if (!$this->getBool('getData', $options, false)) { |
@@ -942,8 +942,8 @@ discard block |
||
942 | 942 | ->leftJoin( |
943 | 943 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
944 | 944 | $expr->andX( |
945 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'), |
|
946 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id') |
|
945 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'), |
|
946 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id') |
|
947 | 947 | ) |
948 | 948 | ); |
949 | 949 | |
@@ -960,12 +960,12 @@ discard block |
||
960 | 960 | $aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options); |
961 | 961 | $this->leftJoin( |
962 | 962 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership, |
963 | - $expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId)) |
|
963 | + $expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId)) |
|
964 | 964 | ); |
965 | 965 | |
966 | 966 | $orX = $expr->orX( |
967 | - $expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field), |
|
968 | - $expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId)) |
|
967 | + $expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field), |
|
968 | + $expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId)) |
|
969 | 969 | ); |
970 | 970 | |
971 | 971 | $this->andWhere($orX); |
@@ -986,11 +986,11 @@ discard block |
||
986 | 986 | |
987 | 987 | $expr = $this->expr(); |
988 | 988 | $aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS); |
989 | - $this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId))); |
|
989 | + $this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId))); |
|
990 | 990 | if ($level > 1) { |
991 | 991 | $this->andWhere( |
992 | 992 | $expr->gte( |
993 | - $aliasMembership . '.level', |
|
993 | + $aliasMembership.'.level', |
|
994 | 994 | $this->createNamedParameter($level, IQueryBuilder::PARAM_INT) |
995 | 995 | ) |
996 | 996 | ); |
@@ -1018,8 +1018,8 @@ discard block |
||
1018 | 1018 | $this->leftJoin( |
1019 | 1019 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
1020 | 1020 | $expr->andX( |
1021 | - $expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field), |
|
1022 | - $expr->eq($aliasMembership . '.single_id', $alias . '.single_id') |
|
1021 | + $expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field), |
|
1022 | + $expr->eq($aliasMembership.'.single_id', $alias.'.single_id') |
|
1023 | 1023 | ) |
1024 | 1024 | ); |
1025 | 1025 | |
@@ -1032,8 +1032,8 @@ discard block |
||
1032 | 1032 | ->leftJoin( |
1033 | 1033 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom, |
1034 | 1034 | $expr->andX( |
1035 | - $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'), |
|
1036 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id') |
|
1035 | + $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'), |
|
1036 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id') |
|
1037 | 1037 | ) |
1038 | 1038 | ); |
1039 | 1039 | } |
@@ -1066,7 +1066,7 @@ discard block |
||
1066 | 1066 | |
1067 | 1067 | $this->leftJoin( |
1068 | 1068 | $alias, CoreRequestBuilder::TABLE_TOKEN, $aliasShareToken, |
1069 | - $expr->eq($aliasShareToken . '.share_id', $alias . '.' . $field) |
|
1069 | + $expr->eq($aliasShareToken.'.share_id', $alias.'.'.$field) |
|
1070 | 1070 | ); |
1071 | 1071 | } |
1072 | 1072 | |
@@ -1108,14 +1108,14 @@ discard block |
||
1108 | 1108 | try { |
1109 | 1109 | $aliasConfig = $this->generateAlias($alias, self::CONFIG, $options); |
1110 | 1110 | $this->selectAlias( |
1111 | - $aliasConfig . '.config', |
|
1112 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'circle_config' |
|
1111 | + $aliasConfig.'.config', |
|
1112 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'circle_config' |
|
1113 | 1113 | ); |
1114 | 1114 | $this->leftJoin( |
1115 | 1115 | $alias, |
1116 | 1116 | CoreRequestBuilder::TABLE_CIRCLE, |
1117 | 1117 | $aliasConfig, |
1118 | - $expr->eq($alias . '.circle_id', $aliasConfig . '.unique_id') |
|
1118 | + $expr->eq($alias.'.circle_id', $aliasConfig.'.unique_id') |
|
1119 | 1119 | ); |
1120 | 1120 | } catch (RequestBuilderException $e) { |
1121 | 1121 | } |
@@ -1153,7 +1153,7 @@ discard block |
||
1153 | 1153 | $aliasMembership, |
1154 | 1154 | $expr->andX( |
1155 | 1155 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), |
1156 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field) |
|
1156 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field) |
|
1157 | 1157 | ) |
1158 | 1158 | ); |
1159 | 1159 | |
@@ -1171,11 +1171,11 @@ discard block |
||
1171 | 1171 | $aliasMembershipCircle = $this->generateAlias($aliasMembership, self::CONFIG, $options); |
1172 | 1172 | $orXMembershipCircle = $expr->orX(); |
1173 | 1173 | array_map( |
1174 | - function (string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { |
|
1174 | + function(string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { |
|
1175 | 1175 | $orXMembershipCircle->add( |
1176 | 1176 | $this->expr()->eq( |
1177 | - $alias . '.circle_id', |
|
1178 | - $aliasMembershipCircle . '.unique_id' |
|
1177 | + $alias.'.circle_id', |
|
1178 | + $aliasMembershipCircle.'.unique_id' |
|
1179 | 1179 | ) |
1180 | 1180 | ); |
1181 | 1181 | }, |
@@ -1207,7 +1207,7 @@ discard block |
||
1207 | 1207 | $aliasDirectInitiator, |
1208 | 1208 | $expr->andX( |
1209 | 1209 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasDirectInitiator), |
1210 | - $expr->eq($aliasDirectInitiator . '.circle_id', $helperAlias . '.' . $field) |
|
1210 | + $expr->eq($aliasDirectInitiator.'.circle_id', $helperAlias.'.'.$field) |
|
1211 | 1211 | ) |
1212 | 1212 | ); |
1213 | 1213 | } catch (RequestBuilderException $e) { |
@@ -1220,8 +1220,8 @@ discard block |
||
1220 | 1220 | $this->leftJoin( |
1221 | 1221 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator, |
1222 | 1222 | $expr->andX( |
1223 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'), |
|
1224 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id') |
|
1223 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'), |
|
1224 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id') |
|
1225 | 1225 | ) |
1226 | 1226 | ); |
1227 | 1227 | |
@@ -1229,8 +1229,8 @@ discard block |
||
1229 | 1229 | $this->leftJoin( |
1230 | 1230 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
1231 | 1231 | $expr->andX( |
1232 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'), |
|
1233 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id') |
|
1232 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'), |
|
1233 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id') |
|
1234 | 1234 | ) |
1235 | 1235 | ); |
1236 | 1236 | |
@@ -1281,7 +1281,7 @@ discard block |
||
1281 | 1281 | $orX->add( |
1282 | 1282 | $expr->andX( |
1283 | 1283 | $this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $aliasMembershipCircle), |
1284 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
1284 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
1285 | 1285 | ) |
1286 | 1286 | ); |
1287 | 1287 | } |
@@ -1291,10 +1291,10 @@ discard block |
||
1291 | 1291 | $orXLevelCheck = $expr->orX(); |
1292 | 1292 | |
1293 | 1293 | array_map( |
1294 | - function (string $alias) use ($orXLevelCheck, $minimumLevel) { |
|
1294 | + function(string $alias) use ($orXLevelCheck, $minimumLevel) { |
|
1295 | 1295 | $orXLevelCheck->add( |
1296 | 1296 | $this->expr()->gte( |
1297 | - $alias . '.level', |
|
1297 | + $alias.'.level', |
|
1298 | 1298 | $this->createNamedParameter($minimumLevel) |
1299 | 1299 | ) |
1300 | 1300 | ); |
@@ -1380,21 +1380,21 @@ discard block |
||
1380 | 1380 | $expr = $this->expr(); |
1381 | 1381 | $andPassive = $expr->andX(); |
1382 | 1382 | $andPassive->add( |
1383 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
1383 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
1384 | 1384 | ); |
1385 | 1385 | |
1386 | 1386 | $orMemberOrLevel = $expr->orX(); |
1387 | 1387 | $orMemberOrLevel->add( |
1388 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance') |
|
1388 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance') |
|
1389 | 1389 | ); |
1390 | 1390 | // TODO: do we need this ? (display members from the local instance) |
1391 | 1391 | $orMemberOrLevel->add( |
1392 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance') |
|
1392 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance') |
|
1393 | 1393 | ); |
1394 | 1394 | |
1395 | 1395 | $orMemberOrLevel->add( |
1396 | 1396 | $expr->eq( |
1397 | - $this->getDefaultSelectAlias() . '.level', |
|
1397 | + $this->getDefaultSelectAlias().'.level', |
|
1398 | 1398 | $this->createNamedParameter(Member::LEVEL_OWNER) |
1399 | 1399 | ) |
1400 | 1400 | ); |
@@ -1431,11 +1431,11 @@ discard block |
||
1431 | 1431 | ) |
1432 | 1432 | ->leftJoin( |
1433 | 1433 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache, |
1434 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid') |
|
1434 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid') |
|
1435 | 1435 | ) |
1436 | 1436 | ->leftJoin( |
1437 | 1437 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages, |
1438 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id') |
|
1438 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id') |
|
1439 | 1439 | ); |
1440 | 1440 | } |
1441 | 1441 | |
@@ -1457,8 +1457,8 @@ discard block |
||
1457 | 1457 | $this->leftJoin( |
1458 | 1458 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild, |
1459 | 1459 | $expr->andX( |
1460 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'), |
|
1461 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id') |
|
1460 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'), |
|
1461 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id') |
|
1462 | 1462 | ) |
1463 | 1463 | ); |
1464 | 1464 | |
@@ -1508,13 +1508,13 @@ discard block |
||
1508 | 1508 | $this->leftJoin( |
1509 | 1509 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint, |
1510 | 1510 | $expr->andX( |
1511 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'), |
|
1512 | - $expr->eq($aliasMountpoint . '.single_id', $aliasMountMemberships . '.single_id') |
|
1511 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'), |
|
1512 | + $expr->eq($aliasMountpoint.'.single_id', $aliasMountMemberships.'.single_id') |
|
1513 | 1513 | ) |
1514 | 1514 | ); |
1515 | 1515 | |
1516 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint'); |
|
1517 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash'); |
|
1516 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint'); |
|
1517 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash'); |
|
1518 | 1518 | } |
1519 | 1519 | |
1520 | 1520 | |
@@ -1618,10 +1618,10 @@ discard block |
||
1618 | 1618 | */ |
1619 | 1619 | public function generateAlias(string $base, string $extension, ?array &$options = []): string { |
1620 | 1620 | $search = str_replace('_', '.', $base); |
1621 | - $path = $search . '.' . $extension; |
|
1621 | + $path = $search.'.'.$extension; |
|
1622 | 1622 | if (!$this->validKey($path, self::$SQL_PATH) |
1623 | 1623 | && !in_array($extension, $this->getArray($search, self::$SQL_PATH))) { |
1624 | - throw new RequestBuilderException($extension . ' not found in ' . $search); |
|
1624 | + throw new RequestBuilderException($extension.' not found in '.$search); |
|
1625 | 1625 | } |
1626 | 1626 | |
1627 | 1627 | if (!is_array($options)) { |
@@ -1630,15 +1630,15 @@ discard block |
||
1630 | 1630 | |
1631 | 1631 | $optionPath = ''; |
1632 | 1632 | foreach (explode('.', $path) as $p) { |
1633 | - $optionPath = trim($optionPath . '.' . $p, '.'); |
|
1633 | + $optionPath = trim($optionPath.'.'.$p, '.'); |
|
1634 | 1634 | $options = array_merge( |
1635 | 1635 | $options, |
1636 | - $this->getArray($optionPath . '.' . self::OPTIONS, self::$SQL_PATH), |
|
1637 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options) |
|
1636 | + $this->getArray($optionPath.'.'.self::OPTIONS, self::$SQL_PATH), |
|
1637 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options) |
|
1638 | 1638 | ); |
1639 | 1639 | } |
1640 | 1640 | |
1641 | - return $base . '_' . $extension; |
|
1641 | + return $base.'_'.$extension; |
|
1642 | 1642 | } |
1643 | 1643 | |
1644 | 1644 | |
@@ -1658,7 +1658,7 @@ discard block |
||
1658 | 1658 | } else { |
1659 | 1659 | $k = $arr; |
1660 | 1660 | } |
1661 | - $path[$k] = $prefix . '_' . $k . '_'; |
|
1661 | + $path[$k] = $prefix.'_'.$k.'_'; |
|
1662 | 1662 | } |
1663 | 1663 | |
1664 | 1664 | return $path; |