@@ -377,8 +377,8 @@ discard block |
||
| 377 | 377 | $andX = []; |
| 378 | 378 | foreach (explode(' ', $circle->getDisplayName()) as $word) { |
| 379 | 379 | $andX[] = $expr->iLike( |
| 380 | - $this->getDefaultSelectAlias() . '.' . 'display_name', |
|
| 381 | - $this->createNamedParameter('%' . $word . '%') |
|
| 380 | + $this->getDefaultSelectAlias().'.'.'display_name', |
|
| 381 | + $this->createNamedParameter('%'.$word.'%') |
|
| 382 | 382 | ); |
| 383 | 383 | } |
| 384 | 384 | } |
@@ -407,7 +407,7 @@ discard block |
||
| 407 | 407 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance) |
| 408 | 408 | ->leftJoin( |
| 409 | 409 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance, |
| 410 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance') |
|
| 410 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance') |
|
| 411 | 411 | ); |
| 412 | 412 | } catch (RequestBuilderException $e) { |
| 413 | 413 | } |
@@ -459,7 +459,7 @@ discard block |
||
| 459 | 459 | $expr = $this->expr(); |
| 460 | 460 | $this->leftJoin( |
| 461 | 461 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote, |
| 462 | - $expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
| 462 | + $expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
| 463 | 463 | ); |
| 464 | 464 | } |
| 465 | 465 | |
@@ -487,12 +487,12 @@ discard block |
||
| 487 | 487 | $this->leftJoin( |
| 488 | 488 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember, |
| 489 | 489 | $expr->andX( |
| 490 | - $expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'), |
|
| 490 | + $expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'), |
|
| 491 | 491 | $expr->eq( |
| 492 | - $aliasRemoteMember . '.instance', |
|
| 492 | + $aliasRemoteMember.'.instance', |
|
| 493 | 493 | $this->createNamedParameter($remoteInstance->getInstance()) |
| 494 | 494 | ), |
| 495 | - $expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 495 | + $expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 496 | 496 | ) |
| 497 | 497 | ); |
| 498 | 498 | } |
@@ -524,21 +524,21 @@ discard block |
||
| 524 | 524 | $this->leftJoin( |
| 525 | 525 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle, |
| 526 | 526 | $expr->andX( |
| 527 | - $expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'), |
|
| 528 | - $expr->emptyString($aliasRemoteCircle . '.instance'), |
|
| 529 | - $expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 527 | + $expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'), |
|
| 528 | + $expr->emptyString($aliasRemoteCircle.'.instance'), |
|
| 529 | + $expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 530 | 530 | ) |
| 531 | 531 | ); |
| 532 | 532 | $this->leftJoin( |
| 533 | 533 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner, |
| 534 | 534 | $expr->andX( |
| 535 | - $expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'), |
|
| 535 | + $expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'), |
|
| 536 | 536 | $expr->eq( |
| 537 | - $aliasRemoteCircleOwner . '.instance', |
|
| 537 | + $aliasRemoteCircleOwner.'.instance', |
|
| 538 | 538 | $this->createNamedParameter($remoteInstance->getInstance()) |
| 539 | 539 | ), |
| 540 | 540 | $expr->eq( |
| 541 | - $aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
| 541 | + $aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
| 542 | 542 | ) |
| 543 | 543 | ) |
| 544 | 544 | ); |
@@ -569,11 +569,11 @@ discard block |
||
| 569 | 569 | $aliasRemoteCircleOwner = $this->generateAlias($aliasRemoteCircle, self::OWNER); |
| 570 | 570 | |
| 571 | 571 | $expr = $this->expr(); |
| 572 | - $orX = [$expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE))]; |
|
| 572 | + $orX = [$expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE))]; |
|
| 573 | 573 | |
| 574 | - $orExtOrPassive = [$expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))]; |
|
| 574 | + $orExtOrPassive = [$expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))]; |
|
| 575 | 575 | if (!$sensitive) { |
| 576 | - $orExtOrPassive[] = $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)); |
|
| 576 | + $orExtOrPassive[] = $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)); |
|
| 577 | 577 | } else { |
| 578 | 578 | if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) { |
| 579 | 579 | $orExtOrPassive[] = $this->limitRemoteVisibility_Sensitive_Members($aliasRemote); |
@@ -581,8 +581,8 @@ discard block |
||
| 581 | 581 | } |
| 582 | 582 | |
| 583 | 583 | $orInstance = $expr->orX( |
| 584 | - $expr->isNotNull($aliasRemoteMember . '.instance'), |
|
| 585 | - $expr->isNotNull($aliasRemoteCircleOwner . '.instance'), |
|
| 584 | + $expr->isNotNull($aliasRemoteMember.'.instance'), |
|
| 585 | + $expr->isNotNull($aliasRemoteCircleOwner.'.instance'), |
|
| 586 | 586 | ); |
| 587 | 587 | |
| 588 | 588 | $andExternal = $expr->andX( |
@@ -592,13 +592,13 @@ discard block |
||
| 592 | 592 | |
| 593 | 593 | $orExtOrTrusted = $expr->orX( |
| 594 | 594 | $andExternal, |
| 595 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)), |
|
| 595 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)), |
|
| 596 | 596 | ); |
| 597 | 597 | |
| 598 | 598 | $orX[] = $expr->andX( |
| 599 | 599 | $orExtOrTrusted, |
| 600 | 600 | $this->exprLimitBitwise('config', Circle::CFG_FEDERATED, $aliasCircle), |
| 601 | - $expr->emptyString($aliasOwner . '.instance'), |
|
| 601 | + $expr->emptyString($aliasOwner.'.instance'), |
|
| 602 | 602 | ); |
| 603 | 603 | |
| 604 | 604 | $this->andWhere($expr->orX(...$orX)); |
@@ -625,7 +625,7 @@ discard block |
||
| 625 | 625 | } |
| 626 | 626 | $this->innerJoin( |
| 627 | 627 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 628 | - $expr->eq($aliasMember . '.circle_id', $alias . '.unique_id') |
|
| 628 | + $expr->eq($aliasMember.'.circle_id', $alias.'.unique_id') |
|
| 629 | 629 | ); |
| 630 | 630 | |
| 631 | 631 | $this->filterDirectMembership($aliasMember, $member); |
@@ -650,12 +650,12 @@ discard block |
||
| 650 | 650 | $aliasCircle, |
| 651 | 651 | 'circles_membership', |
| 652 | 652 | $aliasMembership, |
| 653 | - $this->expr()->eq($aliasCircle . '.unique_id', $aliasMembership . '.circle_id') |
|
| 653 | + $this->expr()->eq($aliasCircle.'.unique_id', $aliasMembership.'.circle_id') |
|
| 654 | 654 | ); |
| 655 | 655 | |
| 656 | 656 | $this->andWhere( |
| 657 | 657 | $this->expr()->eq( |
| 658 | - $aliasMembership . '.single_id', |
|
| 658 | + $aliasMembership.'.single_id', |
|
| 659 | 659 | $this->createNamedParameter($federatedUser->getSingleId()) |
| 660 | 660 | ) |
| 661 | 661 | ); |
@@ -675,22 +675,22 @@ discard block |
||
| 675 | 675 | $andX = []; |
| 676 | 676 | |
| 677 | 677 | if ($member->getUserId() !== '') { |
| 678 | - $andX[] = $expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId())); |
|
| 678 | + $andX[] = $expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId())); |
|
| 679 | 679 | } |
| 680 | 680 | |
| 681 | 681 | if ($member->getSingleId() !== '') { |
| 682 | - $andX[] = $expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId())); |
|
| 682 | + $andX[] = $expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId())); |
|
| 683 | 683 | } |
| 684 | 684 | |
| 685 | 685 | if ($member->getUserType() > 0) { |
| 686 | - $andX[] = $expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType())); |
|
| 686 | + $andX[] = $expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType())); |
|
| 687 | 687 | } |
| 688 | 688 | |
| 689 | 689 | $this->limitToInstance($this->getInstance($member)); |
| 690 | 690 | |
| 691 | 691 | if ($member->getLevel() > 0) { |
| 692 | 692 | $andX[] = $expr->gte( |
| 693 | - $aliasMember . '.level', |
|
| 693 | + $aliasMember.'.level', |
|
| 694 | 694 | $this->createNamedParameter($member->getLevel(), IQueryBuilder::PARAM_INT) |
| 695 | 695 | ); |
| 696 | 696 | } |
@@ -730,7 +730,7 @@ discard block |
||
| 730 | 730 | $helperAlias, |
| 731 | 731 | CoreRequestBuilder::TABLE_CIRCLE, |
| 732 | 732 | $aliasCircle, |
| 733 | - $expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field) |
|
| 733 | + $expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field) |
|
| 734 | 734 | ); |
| 735 | 735 | |
| 736 | 736 | if (!is_null($initiator)) { |
@@ -764,7 +764,7 @@ discard block |
||
| 764 | 764 | $this->generateCircleSelectAlias($aliasBasedOn) |
| 765 | 765 | ->leftJoin( |
| 766 | 766 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn, |
| 767 | - $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id') |
|
| 767 | + $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id') |
|
| 768 | 768 | ); |
| 769 | 769 | |
| 770 | 770 | if (!is_null($initiator)) { |
@@ -797,9 +797,9 @@ discard block |
||
| 797 | 797 | ->leftJoin( |
| 798 | 798 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 799 | 799 | $expr->andX( |
| 800 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field), |
|
| 800 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field), |
|
| 801 | 801 | $expr->eq( |
| 802 | - $aliasMember . '.level', |
|
| 802 | + $aliasMember.'.level', |
|
| 803 | 803 | $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT) |
| 804 | 804 | ) |
| 805 | 805 | ) |
@@ -831,7 +831,7 @@ discard block |
||
| 831 | 831 | |
| 832 | 832 | $expr = $this->expr(); |
| 833 | 833 | |
| 834 | - $on = $expr->andX($expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field)); |
|
| 834 | + $on = $expr->andX($expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field)); |
|
| 835 | 835 | |
| 836 | 836 | // limit on membership level if requested |
| 837 | 837 | $minLevel = $probe->getMinimumLevel(); |
@@ -872,8 +872,8 @@ discard block |
||
| 872 | 872 | ->leftJoin( |
| 873 | 873 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 874 | 874 | $expr->andX( |
| 875 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId), |
|
| 876 | - $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId), |
|
| 875 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId), |
|
| 876 | + $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId), |
|
| 877 | 877 | $this->exprGt('level', Member::LEVEL_MEMBER, true, $aliasMember) |
| 878 | 878 | ) |
| 879 | 879 | ); |
@@ -905,7 +905,7 @@ discard block |
||
| 905 | 905 | |
| 906 | 906 | $this->leftJoin( |
| 907 | 907 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
| 908 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field) |
|
| 908 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field) |
|
| 909 | 909 | ); |
| 910 | 910 | |
| 911 | 911 | // if (!$this->getBool('getData', $options, false)) { |
@@ -919,8 +919,8 @@ discard block |
||
| 919 | 919 | ->leftJoin( |
| 920 | 920 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
| 921 | 921 | $expr->andX( |
| 922 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'), |
|
| 923 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id') |
|
| 922 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'), |
|
| 923 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id') |
|
| 924 | 924 | ) |
| 925 | 925 | ); |
| 926 | 926 | |
@@ -937,12 +937,12 @@ discard block |
||
| 937 | 937 | $aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options); |
| 938 | 938 | $this->leftJoin( |
| 939 | 939 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership, |
| 940 | - $expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId)) |
|
| 940 | + $expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId)) |
|
| 941 | 941 | ); |
| 942 | 942 | |
| 943 | 943 | $orX = $expr->orX( |
| 944 | - $expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field), |
|
| 945 | - $expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId)) |
|
| 944 | + $expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field), |
|
| 945 | + $expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId)) |
|
| 946 | 946 | ); |
| 947 | 947 | |
| 948 | 948 | $this->andWhere($orX); |
@@ -963,11 +963,11 @@ discard block |
||
| 963 | 963 | |
| 964 | 964 | $expr = $this->expr(); |
| 965 | 965 | $aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS); |
| 966 | - $this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId))); |
|
| 966 | + $this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId))); |
|
| 967 | 967 | if ($level > 1) { |
| 968 | 968 | $this->andWhere( |
| 969 | 969 | $expr->gte( |
| 970 | - $aliasMembership . '.level', |
|
| 970 | + $aliasMembership.'.level', |
|
| 971 | 971 | $this->createNamedParameter($level, IQueryBuilder::PARAM_INT) |
| 972 | 972 | ) |
| 973 | 973 | ); |
@@ -995,8 +995,8 @@ discard block |
||
| 995 | 995 | $this->leftJoin( |
| 996 | 996 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
| 997 | 997 | $expr->andX( |
| 998 | - $expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field), |
|
| 999 | - $expr->eq($aliasMembership . '.single_id', $alias . '.single_id') |
|
| 998 | + $expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field), |
|
| 999 | + $expr->eq($aliasMembership.'.single_id', $alias.'.single_id') |
|
| 1000 | 1000 | ) |
| 1001 | 1001 | ); |
| 1002 | 1002 | |
@@ -1009,8 +1009,8 @@ discard block |
||
| 1009 | 1009 | ->leftJoin( |
| 1010 | 1010 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom, |
| 1011 | 1011 | $expr->andX( |
| 1012 | - $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'), |
|
| 1013 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id') |
|
| 1012 | + $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'), |
|
| 1013 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id') |
|
| 1014 | 1014 | ) |
| 1015 | 1015 | ); |
| 1016 | 1016 | } |
@@ -1050,7 +1050,7 @@ discard block |
||
| 1050 | 1050 | |
| 1051 | 1051 | $this->leftJoin( |
| 1052 | 1052 | $alias, CoreRequestBuilder::TABLE_TOKEN, $aliasShareToken, |
| 1053 | - $expr->eq($aliasShareToken . '.share_id', $alias . '.' . $field) |
|
| 1053 | + $expr->eq($aliasShareToken.'.share_id', $alias.'.'.$field) |
|
| 1054 | 1054 | ); |
| 1055 | 1055 | } |
| 1056 | 1056 | |
@@ -1092,14 +1092,14 @@ discard block |
||
| 1092 | 1092 | try { |
| 1093 | 1093 | $aliasConfig = $this->generateAlias($alias, self::CONFIG, $options); |
| 1094 | 1094 | $this->selectAlias( |
| 1095 | - $aliasConfig . '.config', |
|
| 1096 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'circle_config' |
|
| 1095 | + $aliasConfig.'.config', |
|
| 1096 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'circle_config' |
|
| 1097 | 1097 | ); |
| 1098 | 1098 | $this->leftJoin( |
| 1099 | 1099 | $alias, |
| 1100 | 1100 | CoreRequestBuilder::TABLE_CIRCLE, |
| 1101 | 1101 | $aliasConfig, |
| 1102 | - $expr->eq($alias . '.circle_id', $aliasConfig . '.unique_id') |
|
| 1102 | + $expr->eq($alias.'.circle_id', $aliasConfig.'.unique_id') |
|
| 1103 | 1103 | ); |
| 1104 | 1104 | } catch (RequestBuilderException $e) { |
| 1105 | 1105 | } |
@@ -1137,7 +1137,7 @@ discard block |
||
| 1137 | 1137 | $aliasMembership, |
| 1138 | 1138 | $expr->andX( |
| 1139 | 1139 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), |
| 1140 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field) |
|
| 1140 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field) |
|
| 1141 | 1141 | ) |
| 1142 | 1142 | ); |
| 1143 | 1143 | |
@@ -1155,10 +1155,10 @@ discard block |
||
| 1155 | 1155 | try { |
| 1156 | 1156 | $aliasMembershipCircle = $this->generateAlias($aliasMembership, self::CONFIG, $options); |
| 1157 | 1157 | $orXMembershipCircle = $expr->orX(...array_map( |
| 1158 | - function (string $alias) use ($aliasMembershipCircle) { |
|
| 1158 | + function(string $alias) use ($aliasMembershipCircle) { |
|
| 1159 | 1159 | return $this->expr()->eq( |
| 1160 | - $alias . '.circle_id', |
|
| 1161 | - $aliasMembershipCircle . '.unique_id' |
|
| 1160 | + $alias.'.circle_id', |
|
| 1161 | + $aliasMembershipCircle.'.unique_id' |
|
| 1162 | 1162 | ); |
| 1163 | 1163 | }, |
| 1164 | 1164 | $listMembershipCircleAlias |
@@ -1189,7 +1189,7 @@ discard block |
||
| 1189 | 1189 | $aliasDirectInitiator, |
| 1190 | 1190 | $expr->andX( |
| 1191 | 1191 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasDirectInitiator), |
| 1192 | - $expr->eq($aliasDirectInitiator . '.circle_id', $helperAlias . '.' . $field) |
|
| 1192 | + $expr->eq($aliasDirectInitiator.'.circle_id', $helperAlias.'.'.$field) |
|
| 1193 | 1193 | ) |
| 1194 | 1194 | ); |
| 1195 | 1195 | } catch (RequestBuilderException $e) { |
@@ -1203,8 +1203,8 @@ discard block |
||
| 1203 | 1203 | $this->leftJoin( |
| 1204 | 1204 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator, |
| 1205 | 1205 | $expr->andX( |
| 1206 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'), |
|
| 1207 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id') |
|
| 1206 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'), |
|
| 1207 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id') |
|
| 1208 | 1208 | ) |
| 1209 | 1209 | ); |
| 1210 | 1210 | |
@@ -1212,8 +1212,8 @@ discard block |
||
| 1212 | 1212 | $this->leftJoin( |
| 1213 | 1213 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
| 1214 | 1214 | $expr->andX( |
| 1215 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'), |
|
| 1216 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id') |
|
| 1215 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'), |
|
| 1216 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id') |
|
| 1217 | 1217 | ) |
| 1218 | 1218 | ); |
| 1219 | 1219 | |
@@ -1258,8 +1258,8 @@ discard block |
||
| 1258 | 1258 | ->leftJoin( |
| 1259 | 1259 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator, |
| 1260 | 1260 | $expr->andX( |
| 1261 | - $expr->eq($aliasInitiator . '.circle_id', $alias . '.unique_id'), |
|
| 1262 | - $expr->eq($aliasInitiator . '.' . $field, $helperAlias . '.inheritance_first'), |
|
| 1261 | + $expr->eq($aliasInitiator.'.circle_id', $alias.'.unique_id'), |
|
| 1262 | + $expr->eq($aliasInitiator.'.'.$field, $helperAlias.'.inheritance_first'), |
|
| 1263 | 1263 | ) |
| 1264 | 1264 | ); |
| 1265 | 1265 | // |
@@ -1295,15 +1295,15 @@ discard block |
||
| 1295 | 1295 | if (!$this->getBool('filterPersonalCircles', $options, false)) { |
| 1296 | 1296 | $orX[] = $expr->andX( |
| 1297 | 1297 | $this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $aliasMembershipCircle), |
| 1298 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
| 1298 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
| 1299 | 1299 | ); |
| 1300 | 1300 | } |
| 1301 | 1301 | |
| 1302 | 1302 | $minimumLevel = $this->getInt('minimumLevel', $options); |
| 1303 | 1303 | $orXLevelCheck = $expr->orX(...array_map( |
| 1304 | - function (string $alias) use ($minimumLevel) { |
|
| 1304 | + function(string $alias) use ($minimumLevel) { |
|
| 1305 | 1305 | return $this->expr()->gte( |
| 1306 | - $alias . '.level', |
|
| 1306 | + $alias.'.level', |
|
| 1307 | 1307 | $this->createNamedParameter($minimumLevel, self::PARAM_INT) |
| 1308 | 1308 | ); |
| 1309 | 1309 | }, |
@@ -1383,13 +1383,13 @@ discard block |
||
| 1383 | 1383 | private function limitRemoteVisibility_Sensitive_Members(string $alias): ICompositeExpression { |
| 1384 | 1384 | $expr = $this->expr(); |
| 1385 | 1385 | return $expr->andX( |
| 1386 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)), |
|
| 1386 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)), |
|
| 1387 | 1387 | $expr->orX( |
| 1388 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance'), |
|
| 1388 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance'), |
|
| 1389 | 1389 | // TODO: do we need this ? (display members from the local instance) |
| 1390 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance'), |
|
| 1390 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance'), |
|
| 1391 | 1391 | $expr->eq( |
| 1392 | - $this->getDefaultSelectAlias() . '.level', |
|
| 1392 | + $this->getDefaultSelectAlias().'.level', |
|
| 1393 | 1393 | $this->createNamedParameter(Member::LEVEL_OWNER) |
| 1394 | 1394 | ), |
| 1395 | 1395 | ), |
@@ -1424,11 +1424,11 @@ discard block |
||
| 1424 | 1424 | ) |
| 1425 | 1425 | ->leftJoin( |
| 1426 | 1426 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache, |
| 1427 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid') |
|
| 1427 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid') |
|
| 1428 | 1428 | ) |
| 1429 | 1429 | ->leftJoin( |
| 1430 | 1430 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages, |
| 1431 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id') |
|
| 1431 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id') |
|
| 1432 | 1432 | ); |
| 1433 | 1433 | } |
| 1434 | 1434 | |
@@ -1450,8 +1450,8 @@ discard block |
||
| 1450 | 1450 | $this->leftJoin( |
| 1451 | 1451 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild, |
| 1452 | 1452 | $expr->andX( |
| 1453 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'), |
|
| 1454 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id') |
|
| 1453 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'), |
|
| 1454 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id') |
|
| 1455 | 1455 | ) |
| 1456 | 1456 | ); |
| 1457 | 1457 | |
@@ -1509,13 +1509,13 @@ discard block |
||
| 1509 | 1509 | $this->leftJoin( |
| 1510 | 1510 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint, |
| 1511 | 1511 | $expr->andX( |
| 1512 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'), |
|
| 1513 | - $expr->eq($aliasMountpoint . '.single_id', $this->createNamedParameter($federatedUser->getSingleId())) |
|
| 1512 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'), |
|
| 1513 | + $expr->eq($aliasMountpoint.'.single_id', $this->createNamedParameter($federatedUser->getSingleId())) |
|
| 1514 | 1514 | ) |
| 1515 | 1515 | ); |
| 1516 | 1516 | |
| 1517 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint'); |
|
| 1518 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash'); |
|
| 1517 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint'); |
|
| 1518 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash'); |
|
| 1519 | 1519 | } |
| 1520 | 1520 | |
| 1521 | 1521 | |
@@ -1623,10 +1623,10 @@ discard block |
||
| 1623 | 1623 | */ |
| 1624 | 1624 | public function generateAlias(string $base, string $extension, ?array &$options = []): string { |
| 1625 | 1625 | $search = str_replace('_', '.', $base); |
| 1626 | - $path = $search . '.' . $extension; |
|
| 1626 | + $path = $search.'.'.$extension; |
|
| 1627 | 1627 | if (!$this->validKey($path, $this->getSqlPath()) |
| 1628 | 1628 | && !in_array($extension, $this->getArray($search, $this->getSqlPath()))) { |
| 1629 | - throw new RequestBuilderException($extension . ' not found in ' . $search); |
|
| 1629 | + throw new RequestBuilderException($extension.' not found in '.$search); |
|
| 1630 | 1630 | } |
| 1631 | 1631 | |
| 1632 | 1632 | if (!is_array($options)) { |
@@ -1635,15 +1635,15 @@ discard block |
||
| 1635 | 1635 | |
| 1636 | 1636 | $optionPath = ''; |
| 1637 | 1637 | foreach (explode('.', $path) as $p) { |
| 1638 | - $optionPath = trim($optionPath . '.' . $p, '.'); |
|
| 1638 | + $optionPath = trim($optionPath.'.'.$p, '.'); |
|
| 1639 | 1639 | $options = array_merge( |
| 1640 | 1640 | $options, |
| 1641 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->getSqlPath()), |
|
| 1642 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options) |
|
| 1641 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->getSqlPath()), |
|
| 1642 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options) |
|
| 1643 | 1643 | ); |
| 1644 | 1644 | } |
| 1645 | 1645 | |
| 1646 | - return $base . '_' . $extension; |
|
| 1646 | + return $base.'_'.$extension; |
|
| 1647 | 1647 | } |
| 1648 | 1648 | |
| 1649 | 1649 | |
@@ -1663,7 +1663,7 @@ discard block |
||
| 1663 | 1663 | } else { |
| 1664 | 1664 | $k = $arr; |
| 1665 | 1665 | } |
| 1666 | - $path[$k] = $prefix . '_' . $k . '_'; |
|
| 1666 | + $path[$k] = $prefix.'_'.$k.'_'; |
|
| 1667 | 1667 | } |
| 1668 | 1668 | |
| 1669 | 1669 | return $path; |