@@ -164,7 +164,7 @@ discard block |
||
| 164 | 164 | ], |
| 165 | 165 | self::MEMBERSHIPS => [ |
| 166 | 166 | self::CIRCLE => [ |
| 167 | - self::MEMBERSHIPS => [ // needed ? |
|
| 167 | + self::MEMBERSHIPS => [// needed ? |
|
| 168 | 168 | self::CONFIG, |
| 169 | 169 | self::INITIATOR |
| 170 | 170 | ], |
@@ -409,7 +409,7 @@ discard block |
||
| 409 | 409 | } |
| 410 | 410 | |
| 411 | 411 | if ($circle->getDisplayName() !== '') { |
| 412 | - $this->searchInDBField('display_name', '%' . $circle->getDisplayName() . '%'); |
|
| 412 | + $this->searchInDBField('display_name', '%'.$circle->getDisplayName().'%'); |
|
| 413 | 413 | } |
| 414 | 414 | if ($circle->getSource() > 0) { |
| 415 | 415 | $this->limitInt('source', $circle->getSource()); |
@@ -431,7 +431,7 @@ discard block |
||
| 431 | 431 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance) |
| 432 | 432 | ->leftJoin( |
| 433 | 433 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance, |
| 434 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance') |
|
| 434 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance') |
|
| 435 | 435 | ); |
| 436 | 436 | } catch (RequestBuilderException $e) { |
| 437 | 437 | } |
@@ -483,7 +483,7 @@ discard block |
||
| 483 | 483 | $expr = $this->expr(); |
| 484 | 484 | $this->leftJoin( |
| 485 | 485 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote, |
| 486 | - $expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
| 486 | + $expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
| 487 | 487 | ); |
| 488 | 488 | } |
| 489 | 489 | |
@@ -511,12 +511,12 @@ discard block |
||
| 511 | 511 | $this->leftJoin( |
| 512 | 512 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember, |
| 513 | 513 | $expr->andX( |
| 514 | - $expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'), |
|
| 514 | + $expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'), |
|
| 515 | 515 | $expr->eq( |
| 516 | - $aliasRemoteMember . '.instance', |
|
| 516 | + $aliasRemoteMember.'.instance', |
|
| 517 | 517 | $this->createNamedParameter($remoteInstance->getInstance()) |
| 518 | 518 | ), |
| 519 | - $expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 519 | + $expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 520 | 520 | ) |
| 521 | 521 | ); |
| 522 | 522 | } |
@@ -548,21 +548,21 @@ discard block |
||
| 548 | 548 | $this->leftJoin( |
| 549 | 549 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle, |
| 550 | 550 | $expr->andX( |
| 551 | - $expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'), |
|
| 552 | - $expr->emptyString($aliasRemoteCircle . '.instance'), |
|
| 553 | - $expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 551 | + $expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'), |
|
| 552 | + $expr->emptyString($aliasRemoteCircle.'.instance'), |
|
| 553 | + $expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 554 | 554 | ) |
| 555 | 555 | ); |
| 556 | 556 | $this->leftJoin( |
| 557 | 557 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner, |
| 558 | 558 | $expr->andX( |
| 559 | - $expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'), |
|
| 559 | + $expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'), |
|
| 560 | 560 | $expr->eq( |
| 561 | - $aliasRemoteCircleOwner . '.instance', |
|
| 561 | + $aliasRemoteCircleOwner.'.instance', |
|
| 562 | 562 | $this->createNamedParameter($remoteInstance->getInstance()) |
| 563 | 563 | ), |
| 564 | 564 | $expr->eq( |
| 565 | - $aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
| 565 | + $aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
| 566 | 566 | ) |
| 567 | 567 | ) |
| 568 | 568 | ); |
@@ -595,16 +595,16 @@ discard block |
||
| 595 | 595 | $expr = $this->expr(); |
| 596 | 596 | $orX = $expr->orX(); |
| 597 | 597 | $orX->add( |
| 598 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
| 598 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
| 599 | 599 | ); |
| 600 | 600 | |
| 601 | 601 | $orExtOrPassive = $expr->orX(); |
| 602 | 602 | $orExtOrPassive->add( |
| 603 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
| 603 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
| 604 | 604 | ); |
| 605 | 605 | if (!$sensitive) { |
| 606 | 606 | $orExtOrPassive->add( |
| 607 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 607 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 608 | 608 | ); |
| 609 | 609 | } else { |
| 610 | 610 | if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) { |
@@ -613,8 +613,8 @@ discard block |
||
| 613 | 613 | } |
| 614 | 614 | |
| 615 | 615 | $orInstance = $expr->orX(); |
| 616 | - $orInstance->add($expr->isNotNull($aliasRemoteMember . '.instance')); |
|
| 617 | - $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner . '.instance')); |
|
| 616 | + $orInstance->add($expr->isNotNull($aliasRemoteMember.'.instance')); |
|
| 617 | + $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner.'.instance')); |
|
| 618 | 618 | |
| 619 | 619 | $andExternal = $expr->andX(); |
| 620 | 620 | $andExternal->add($orExtOrPassive); |
@@ -623,13 +623,13 @@ discard block |
||
| 623 | 623 | $orExtOrTrusted = $expr->orX(); |
| 624 | 624 | $orExtOrTrusted->add($andExternal); |
| 625 | 625 | $orExtOrTrusted->add( |
| 626 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
| 626 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
| 627 | 627 | ); |
| 628 | 628 | |
| 629 | 629 | $andTrusted = $expr->andX(); |
| 630 | 630 | $andTrusted->add($orExtOrTrusted); |
| 631 | 631 | $andTrusted->add($this->exprLimitBitwise('config', Circle::CFG_FEDERATED, $aliasCircle)); |
| 632 | - $andTrusted->add($expr->emptyString($aliasOwner . '.instance')); |
|
| 632 | + $andTrusted->add($expr->emptyString($aliasOwner.'.instance')); |
|
| 633 | 633 | $orX->add($andTrusted); |
| 634 | 634 | |
| 635 | 635 | $this->andWhere($orX); |
@@ -656,7 +656,7 @@ discard block |
||
| 656 | 656 | } |
| 657 | 657 | $this->innerJoin( |
| 658 | 658 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 659 | - $expr->eq($aliasMember . '.circle_id', $alias . '.unique_id') |
|
| 659 | + $expr->eq($aliasMember.'.circle_id', $alias.'.unique_id') |
|
| 660 | 660 | ); |
| 661 | 661 | |
| 662 | 662 | $this->filterDirectMembership($aliasMember, $member); |
@@ -677,19 +677,19 @@ discard block |
||
| 677 | 677 | |
| 678 | 678 | if ($member->getUserId() !== '') { |
| 679 | 679 | $andX->add( |
| 680 | - $expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId())) |
|
| 680 | + $expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId())) |
|
| 681 | 681 | ); |
| 682 | 682 | } |
| 683 | 683 | |
| 684 | 684 | if ($member->getSingleId() !== '') { |
| 685 | 685 | $andX->add( |
| 686 | - $expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId())) |
|
| 686 | + $expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId())) |
|
| 687 | 687 | ); |
| 688 | 688 | } |
| 689 | 689 | |
| 690 | 690 | if ($member->getUserType() > 0) { |
| 691 | 691 | $andX->add( |
| 692 | - $expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType())) |
|
| 692 | + $expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType())) |
|
| 693 | 693 | ); |
| 694 | 694 | } |
| 695 | 695 | |
@@ -698,7 +698,7 @@ discard block |
||
| 698 | 698 | if ($member->getLevel() > 0) { |
| 699 | 699 | $andX->add( |
| 700 | 700 | $expr->gte( |
| 701 | - $aliasMember . '.level', |
|
| 701 | + $aliasMember.'.level', |
|
| 702 | 702 | $this->createNamedParameter($member->getLevel(), IQueryBuilder::PARAM_INT) |
| 703 | 703 | ) |
| 704 | 704 | ); |
@@ -739,7 +739,7 @@ discard block |
||
| 739 | 739 | $helperAlias, |
| 740 | 740 | CoreRequestBuilder::TABLE_CIRCLE, |
| 741 | 741 | $aliasCircle, |
| 742 | - $expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field) |
|
| 742 | + $expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field) |
|
| 743 | 743 | ); |
| 744 | 744 | |
| 745 | 745 | if (!is_null($initiator)) { |
@@ -770,7 +770,7 @@ discard block |
||
| 770 | 770 | $this->generateCircleSelectAlias($aliasInvitedBy) |
| 771 | 771 | ->leftJoin( |
| 772 | 772 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasInvitedBy, |
| 773 | - $expr->eq($aliasMember . '.invited_by', $aliasInvitedBy . '.unique_id') |
|
| 773 | + $expr->eq($aliasMember.'.invited_by', $aliasInvitedBy.'.unique_id') |
|
| 774 | 774 | ); |
| 775 | 775 | |
| 776 | 776 | $this->leftJoinOwner($aliasInvitedBy); |
@@ -801,7 +801,7 @@ discard block |
||
| 801 | 801 | $this->generateCircleSelectAlias($aliasBasedOn) |
| 802 | 802 | ->leftJoin( |
| 803 | 803 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn, |
| 804 | - $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id') |
|
| 804 | + $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id') |
|
| 805 | 805 | ); |
| 806 | 806 | |
| 807 | 807 | if (!is_null($initiator)) { |
@@ -834,9 +834,9 @@ discard block |
||
| 834 | 834 | ->leftJoin( |
| 835 | 835 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 836 | 836 | $expr->andX( |
| 837 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field), |
|
| 837 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field), |
|
| 838 | 838 | $expr->eq( |
| 839 | - $aliasMember . '.level', |
|
| 839 | + $aliasMember.'.level', |
|
| 840 | 840 | $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT) |
| 841 | 841 | ) |
| 842 | 842 | ) |
@@ -874,10 +874,10 @@ discard block |
||
| 874 | 874 | ->leftJoin( |
| 875 | 875 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 876 | 876 | $expr->andX( |
| 877 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId), |
|
| 878 | - $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId), |
|
| 877 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId), |
|
| 878 | + $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId), |
|
| 879 | 879 | $expr->gte( |
| 880 | - $aliasMember . '.level', |
|
| 880 | + $aliasMember.'.level', |
|
| 881 | 881 | $this->createNamedParameter(Member::LEVEL_MEMBER, self::PARAM_INT) |
| 882 | 882 | ) |
| 883 | 883 | ) |
@@ -910,7 +910,7 @@ discard block |
||
| 910 | 910 | |
| 911 | 911 | $this->leftJoin( |
| 912 | 912 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
| 913 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field) |
|
| 913 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field) |
|
| 914 | 914 | ); |
| 915 | 915 | |
| 916 | 916 | // if (!$this->getBool('getData', $options, false)) { |
@@ -924,8 +924,8 @@ discard block |
||
| 924 | 924 | ->leftJoin( |
| 925 | 925 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
| 926 | 926 | $expr->andX( |
| 927 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'), |
|
| 928 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id') |
|
| 927 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'), |
|
| 928 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id') |
|
| 929 | 929 | ) |
| 930 | 930 | ); |
| 931 | 931 | |
@@ -942,12 +942,12 @@ discard block |
||
| 942 | 942 | $aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options); |
| 943 | 943 | $this->leftJoin( |
| 944 | 944 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership, |
| 945 | - $expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId)) |
|
| 945 | + $expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId)) |
|
| 946 | 946 | ); |
| 947 | 947 | |
| 948 | 948 | $orX = $expr->orX( |
| 949 | - $expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field), |
|
| 950 | - $expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId)) |
|
| 949 | + $expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field), |
|
| 950 | + $expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId)) |
|
| 951 | 951 | ); |
| 952 | 952 | |
| 953 | 953 | $this->andWhere($orX); |
@@ -968,11 +968,11 @@ discard block |
||
| 968 | 968 | |
| 969 | 969 | $expr = $this->expr(); |
| 970 | 970 | $aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS); |
| 971 | - $this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId))); |
|
| 971 | + $this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId))); |
|
| 972 | 972 | if ($level > 1) { |
| 973 | 973 | $this->andWhere( |
| 974 | 974 | $expr->gte( |
| 975 | - $aliasMembership . '.level', |
|
| 975 | + $aliasMembership.'.level', |
|
| 976 | 976 | $this->createNamedParameter($level, IQueryBuilder::PARAM_INT) |
| 977 | 977 | ) |
| 978 | 978 | ); |
@@ -1000,8 +1000,8 @@ discard block |
||
| 1000 | 1000 | $this->leftJoin( |
| 1001 | 1001 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
| 1002 | 1002 | $expr->andX( |
| 1003 | - $expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field), |
|
| 1004 | - $expr->eq($aliasMembership . '.single_id', $alias . '.single_id') |
|
| 1003 | + $expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field), |
|
| 1004 | + $expr->eq($aliasMembership.'.single_id', $alias.'.single_id') |
|
| 1005 | 1005 | ) |
| 1006 | 1006 | ); |
| 1007 | 1007 | |
@@ -1014,8 +1014,8 @@ discard block |
||
| 1014 | 1014 | ->leftJoin( |
| 1015 | 1015 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom, |
| 1016 | 1016 | $expr->andX( |
| 1017 | - $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'), |
|
| 1018 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id') |
|
| 1017 | + $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'), |
|
| 1018 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id') |
|
| 1019 | 1019 | ) |
| 1020 | 1020 | ); |
| 1021 | 1021 | } |
@@ -1055,7 +1055,7 @@ discard block |
||
| 1055 | 1055 | |
| 1056 | 1056 | $this->leftJoin( |
| 1057 | 1057 | $alias, CoreRequestBuilder::TABLE_TOKEN, $aliasShareToken, |
| 1058 | - $expr->eq($aliasShareToken . '.share_id', $alias . '.' . $field) |
|
| 1058 | + $expr->eq($aliasShareToken.'.share_id', $alias.'.'.$field) |
|
| 1059 | 1059 | ); |
| 1060 | 1060 | } |
| 1061 | 1061 | |
@@ -1097,14 +1097,14 @@ discard block |
||
| 1097 | 1097 | try { |
| 1098 | 1098 | $aliasConfig = $this->generateAlias($alias, self::CONFIG, $options); |
| 1099 | 1099 | $this->selectAlias( |
| 1100 | - $aliasConfig . '.config', |
|
| 1101 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'circle_config' |
|
| 1100 | + $aliasConfig.'.config', |
|
| 1101 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'circle_config' |
|
| 1102 | 1102 | ); |
| 1103 | 1103 | $this->leftJoin( |
| 1104 | 1104 | $alias, |
| 1105 | 1105 | CoreRequestBuilder::TABLE_CIRCLE, |
| 1106 | 1106 | $aliasConfig, |
| 1107 | - $expr->eq($alias . '.circle_id', $aliasConfig . '.unique_id') |
|
| 1107 | + $expr->eq($alias.'.circle_id', $aliasConfig.'.unique_id') |
|
| 1108 | 1108 | ); |
| 1109 | 1109 | } catch (RequestBuilderException $e) { |
| 1110 | 1110 | } |
@@ -1142,7 +1142,7 @@ discard block |
||
| 1142 | 1142 | $aliasMembership, |
| 1143 | 1143 | $expr->andX( |
| 1144 | 1144 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), |
| 1145 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field) |
|
| 1145 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field) |
|
| 1146 | 1146 | ) |
| 1147 | 1147 | ); |
| 1148 | 1148 | |
@@ -1160,11 +1160,11 @@ discard block |
||
| 1160 | 1160 | $aliasMembershipCircle = $this->generateAlias($aliasMembership, self::CONFIG, $options); |
| 1161 | 1161 | $orXMembershipCircle = $expr->orX(); |
| 1162 | 1162 | array_map( |
| 1163 | - function (string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { |
|
| 1163 | + function(string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { |
|
| 1164 | 1164 | $orXMembershipCircle->add( |
| 1165 | 1165 | $this->expr()->eq( |
| 1166 | - $alias . '.circle_id', |
|
| 1167 | - $aliasMembershipCircle . '.unique_id' |
|
| 1166 | + $alias.'.circle_id', |
|
| 1167 | + $aliasMembershipCircle.'.unique_id' |
|
| 1168 | 1168 | ) |
| 1169 | 1169 | ); |
| 1170 | 1170 | }, |
@@ -1196,7 +1196,7 @@ discard block |
||
| 1196 | 1196 | $aliasDirectInitiator, |
| 1197 | 1197 | $expr->andX( |
| 1198 | 1198 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasDirectInitiator), |
| 1199 | - $expr->eq($aliasDirectInitiator . '.circle_id', $helperAlias . '.' . $field) |
|
| 1199 | + $expr->eq($aliasDirectInitiator.'.circle_id', $helperAlias.'.'.$field) |
|
| 1200 | 1200 | ) |
| 1201 | 1201 | ); |
| 1202 | 1202 | } catch (RequestBuilderException $e) { |
@@ -1210,8 +1210,8 @@ discard block |
||
| 1210 | 1210 | $this->leftJoin( |
| 1211 | 1211 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator, |
| 1212 | 1212 | $expr->andX( |
| 1213 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'), |
|
| 1214 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id') |
|
| 1213 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'), |
|
| 1214 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id') |
|
| 1215 | 1215 | ) |
| 1216 | 1216 | ); |
| 1217 | 1217 | |
@@ -1219,8 +1219,8 @@ discard block |
||
| 1219 | 1219 | $this->leftJoin( |
| 1220 | 1220 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
| 1221 | 1221 | $expr->andX( |
| 1222 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'), |
|
| 1223 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id') |
|
| 1222 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'), |
|
| 1223 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id') |
|
| 1224 | 1224 | ) |
| 1225 | 1225 | ); |
| 1226 | 1226 | |
@@ -1271,7 +1271,7 @@ discard block |
||
| 1271 | 1271 | $orX->add( |
| 1272 | 1272 | $expr->andX( |
| 1273 | 1273 | $this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $aliasMembershipCircle), |
| 1274 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
| 1274 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
| 1275 | 1275 | ) |
| 1276 | 1276 | ); |
| 1277 | 1277 | } |
@@ -1281,10 +1281,10 @@ discard block |
||
| 1281 | 1281 | $orXLevelCheck = $expr->orX(); |
| 1282 | 1282 | |
| 1283 | 1283 | array_map( |
| 1284 | - function (string $alias) use ($orXLevelCheck, $minimumLevel) { |
|
| 1284 | + function(string $alias) use ($orXLevelCheck, $minimumLevel) { |
|
| 1285 | 1285 | $orXLevelCheck->add( |
| 1286 | 1286 | $this->expr()->gte( |
| 1287 | - $alias . '.level', |
|
| 1287 | + $alias.'.level', |
|
| 1288 | 1288 | $this->createNamedParameter($minimumLevel) |
| 1289 | 1289 | ) |
| 1290 | 1290 | ); |
@@ -1374,21 +1374,21 @@ discard block |
||
| 1374 | 1374 | $expr = $this->expr(); |
| 1375 | 1375 | $andPassive = $expr->andX(); |
| 1376 | 1376 | $andPassive->add( |
| 1377 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 1377 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
| 1378 | 1378 | ); |
| 1379 | 1379 | |
| 1380 | 1380 | $orMemberOrLevel = $expr->orX(); |
| 1381 | 1381 | $orMemberOrLevel->add( |
| 1382 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance') |
|
| 1382 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance') |
|
| 1383 | 1383 | ); |
| 1384 | 1384 | // TODO: do we need this ? (display members from the local instance) |
| 1385 | 1385 | $orMemberOrLevel->add( |
| 1386 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance') |
|
| 1386 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance') |
|
| 1387 | 1387 | ); |
| 1388 | 1388 | |
| 1389 | 1389 | $orMemberOrLevel->add( |
| 1390 | 1390 | $expr->eq( |
| 1391 | - $this->getDefaultSelectAlias() . '.level', |
|
| 1391 | + $this->getDefaultSelectAlias().'.level', |
|
| 1392 | 1392 | $this->createNamedParameter(Member::LEVEL_OWNER) |
| 1393 | 1393 | ) |
| 1394 | 1394 | ); |
@@ -1425,11 +1425,11 @@ discard block |
||
| 1425 | 1425 | ) |
| 1426 | 1426 | ->leftJoin( |
| 1427 | 1427 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache, |
| 1428 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid') |
|
| 1428 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid') |
|
| 1429 | 1429 | ) |
| 1430 | 1430 | ->leftJoin( |
| 1431 | 1431 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages, |
| 1432 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id') |
|
| 1432 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id') |
|
| 1433 | 1433 | ); |
| 1434 | 1434 | } |
| 1435 | 1435 | |
@@ -1451,8 +1451,8 @@ discard block |
||
| 1451 | 1451 | $this->leftJoin( |
| 1452 | 1452 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild, |
| 1453 | 1453 | $expr->andX( |
| 1454 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'), |
|
| 1455 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id') |
|
| 1454 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'), |
|
| 1455 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id') |
|
| 1456 | 1456 | ) |
| 1457 | 1457 | ); |
| 1458 | 1458 | |
@@ -1502,13 +1502,13 @@ discard block |
||
| 1502 | 1502 | $this->leftJoin( |
| 1503 | 1503 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint, |
| 1504 | 1504 | $expr->andX( |
| 1505 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'), |
|
| 1506 | - $expr->eq($aliasMountpoint . '.single_id', $aliasMountMemberships . '.single_id') |
|
| 1505 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'), |
|
| 1506 | + $expr->eq($aliasMountpoint.'.single_id', $aliasMountMemberships.'.single_id') |
|
| 1507 | 1507 | ) |
| 1508 | 1508 | ); |
| 1509 | 1509 | |
| 1510 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint'); |
|
| 1511 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash'); |
|
| 1510 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint'); |
|
| 1511 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash'); |
|
| 1512 | 1512 | } |
| 1513 | 1513 | |
| 1514 | 1514 | |
@@ -1612,10 +1612,10 @@ discard block |
||
| 1612 | 1612 | */ |
| 1613 | 1613 | public function generateAlias(string $base, string $extension, ?array &$options = []): string { |
| 1614 | 1614 | $search = str_replace('_', '.', $base); |
| 1615 | - $path = $search . '.' . $extension; |
|
| 1615 | + $path = $search.'.'.$extension; |
|
| 1616 | 1616 | if (!$this->validKey($path, self::$SQL_PATH) |
| 1617 | 1617 | && !in_array($extension, $this->getArray($search, self::$SQL_PATH))) { |
| 1618 | - throw new RequestBuilderException($extension . ' not found in ' . $search); |
|
| 1618 | + throw new RequestBuilderException($extension.' not found in '.$search); |
|
| 1619 | 1619 | } |
| 1620 | 1620 | |
| 1621 | 1621 | if (!is_array($options)) { |
@@ -1624,15 +1624,15 @@ discard block |
||
| 1624 | 1624 | |
| 1625 | 1625 | $optionPath = ''; |
| 1626 | 1626 | foreach (explode('.', $path) as $p) { |
| 1627 | - $optionPath = trim($optionPath . '.' . $p, '.'); |
|
| 1627 | + $optionPath = trim($optionPath.'.'.$p, '.'); |
|
| 1628 | 1628 | $options = array_merge( |
| 1629 | 1629 | $options, |
| 1630 | - $this->getArray($optionPath . '.' . self::OPTIONS, self::$SQL_PATH), |
|
| 1631 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options) |
|
| 1630 | + $this->getArray($optionPath.'.'.self::OPTIONS, self::$SQL_PATH), |
|
| 1631 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options) |
|
| 1632 | 1632 | ); |
| 1633 | 1633 | } |
| 1634 | 1634 | |
| 1635 | - return $base . '_' . $extension; |
|
| 1635 | + return $base.'_'.$extension; |
|
| 1636 | 1636 | } |
| 1637 | 1637 | |
| 1638 | 1638 | |
@@ -1652,7 +1652,7 @@ discard block |
||
| 1652 | 1652 | } else { |
| 1653 | 1653 | $k = $arr; |
| 1654 | 1654 | } |
| 1655 | - $path[$k] = $prefix . '_' . $k . '_'; |
|
| 1655 | + $path[$k] = $prefix.'_'.$k.'_'; |
|
| 1656 | 1656 | } |
| 1657 | 1657 | |
| 1658 | 1658 | return $path; |
@@ -320,18 +320,18 @@ |
||
| 320 | 320 | * @throws MembershipNotFoundException |
| 321 | 321 | */ |
| 322 | 322 | public function importFromDatabase(array $data, string $prefix = ''): IQueryRow { |
| 323 | - if ($this->get($prefix . 'single_id', $data) === '') { |
|
| 323 | + if ($this->get($prefix.'single_id', $data) === '') { |
|
| 324 | 324 | throw new MembershipNotFoundException(); |
| 325 | 325 | } |
| 326 | 326 | |
| 327 | - $this->setSingleId($this->get($prefix . 'single_id', $data)); |
|
| 328 | - $this->setCircleId($this->get($prefix . 'circle_id', $data)); |
|
| 329 | - $this->setLevel($this->getInt($prefix . 'level', $data)); |
|
| 330 | - $this->setCircleConfig($this->getInt($prefix . 'circle_config', $data)); |
|
| 331 | - $this->setInheritanceFirst($this->get($prefix . 'inheritance_first', $data)); |
|
| 332 | - $this->setInheritanceLast($this->get($prefix . 'inheritance_last', $data)); |
|
| 333 | - $this->setInheritancePath($this->getArray($prefix . 'inheritance_path', $data)); |
|
| 334 | - $this->setInheritanceDepth($this->getInt($prefix . 'inheritance_depth', $data)); |
|
| 327 | + $this->setSingleId($this->get($prefix.'single_id', $data)); |
|
| 328 | + $this->setCircleId($this->get($prefix.'circle_id', $data)); |
|
| 329 | + $this->setLevel($this->getInt($prefix.'level', $data)); |
|
| 330 | + $this->setCircleConfig($this->getInt($prefix.'circle_config', $data)); |
|
| 331 | + $this->setInheritanceFirst($this->get($prefix.'inheritance_first', $data)); |
|
| 332 | + $this->setInheritanceLast($this->get($prefix.'inheritance_last', $data)); |
|
| 333 | + $this->setInheritancePath($this->getArray($prefix.'inheritance_path', $data)); |
|
| 334 | + $this->setInheritanceDepth($this->getInt($prefix.'inheritance_depth', $data)); |
|
| 335 | 335 | |
| 336 | 336 | $this->getManager()->manageImportFromDatabase($this, $data, $prefix); |
| 337 | 337 | |