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