Completed
Pull Request — master (#637)
by Maxence
48s
created
lib/Db/CoreQueryBuilder.php 1 patch
Spacing   +79 added lines, -79 removed lines patch added patch discarded remove patch
@@ -395,7 +395,7 @@  discard block
 block discarded – undo
395 395
 		}
396 396
 
397 397
 		if ($circle->getDisplayName() !== '') {
398
-			$this->searchInDBField('display_name', '%' . $circle->getDisplayName() . '%');
398
+			$this->searchInDBField('display_name', '%'.$circle->getDisplayName().'%');
399 399
 		}
400 400
 		if ($circle->getConfig() > 0) {
401 401
 			$this->limitBitwise('config', $circle->getConfig());
@@ -414,7 +414,7 @@  discard block
 block discarded – undo
414 414
 			$this->generateRemoteInstanceSelectAlias($aliasRemoteInstance)
415 415
 				 ->leftJoin(
416 416
 					 $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance,
417
-					 $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance')
417
+					 $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance')
418 418
 				 );
419 419
 		} catch (RequestBuilderException $e) {
420 420
 		}
@@ -467,7 +467,7 @@  discard block
 block discarded – undo
467 467
 		$expr = $this->expr();
468 468
 		$this->leftJoin(
469 469
 			$this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote,
470
-			$expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance()))
470
+			$expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance()))
471 471
 		);
472 472
 	}
473 473
 
@@ -495,12 +495,12 @@  discard block
 block discarded – undo
495 495
 		$this->leftJoin(
496 496
 			$this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember,
497 497
 			$expr->andX(
498
-				$expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'),
498
+				$expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'),
499 499
 				$expr->eq(
500
-					$aliasRemoteMember . '.instance',
500
+					$aliasRemoteMember.'.instance',
501 501
 					$this->createNamedParameter($remoteInstance->getInstance())
502 502
 				),
503
-				$expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER))
503
+				$expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER))
504 504
 			)
505 505
 		);
506 506
 	}
@@ -532,21 +532,21 @@  discard block
 block discarded – undo
532 532
 		$this->leftJoin(
533 533
 			$this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle,
534 534
 			$expr->andX(
535
-				$expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'),
536
-				$expr->emptyString($aliasRemoteCircle . '.instance'),
537
-				$expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER))
535
+				$expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'),
536
+				$expr->emptyString($aliasRemoteCircle.'.instance'),
537
+				$expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER))
538 538
 			)
539 539
 		);
540 540
 		$this->leftJoin(
541 541
 			$this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner,
542 542
 			$expr->andX(
543
-				$expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'),
543
+				$expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'),
544 544
 				$expr->eq(
545
-					$aliasRemoteCircleOwner . '.instance',
545
+					$aliasRemoteCircleOwner.'.instance',
546 546
 					$this->createNamedParameter($remoteInstance->getInstance())
547 547
 				),
548 548
 				$expr->eq(
549
-					$aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)
549
+					$aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)
550 550
 				)
551 551
 			)
552 552
 		);
@@ -579,16 +579,16 @@  discard block
 block discarded – undo
579 579
 		$expr = $this->expr();
580 580
 		$orX = $expr->orX();
581 581
 		$orX->add(
582
-			$expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE))
582
+			$expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE))
583 583
 		);
584 584
 
585 585
 		$orExtOrPassive = $expr->orX();
586 586
 		$orExtOrPassive->add(
587
-			$expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))
587
+			$expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))
588 588
 		);
589 589
 		if (!$sensitive) {
590 590
 			$orExtOrPassive->add(
591
-				$expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))
591
+				$expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))
592 592
 			);
593 593
 		} else {
594 594
 			if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) {
@@ -597,8 +597,8 @@  discard block
 block discarded – undo
597 597
 		}
598 598
 
599 599
 		$orInstance = $expr->orX();
600
-		$orInstance->add($expr->isNotNull($aliasRemoteMember . '.instance'));
601
-		$orInstance->add($expr->isNotNull($aliasRemoteCircleOwner . '.instance'));
600
+		$orInstance->add($expr->isNotNull($aliasRemoteMember.'.instance'));
601
+		$orInstance->add($expr->isNotNull($aliasRemoteCircleOwner.'.instance'));
602 602
 
603 603
 		$andExternal = $expr->andX();
604 604
 		$andExternal->add($orExtOrPassive);
@@ -607,13 +607,13 @@  discard block
 block discarded – undo
607 607
 		$orExtOrTrusted = $expr->orX();
608 608
 		$orExtOrTrusted->add($andExternal);
609 609
 		$orExtOrTrusted->add(
610
-			$expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED))
610
+			$expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED))
611 611
 		);
612 612
 
613 613
 		$andTrusted = $expr->andX();
614 614
 		$andTrusted->add($orExtOrTrusted);
615 615
 		$andTrusted->add($this->exprLimitBitwise('config', Circle::CFG_FEDERATED, $aliasCircle));
616
-		$andTrusted->add($expr->emptyString($aliasOwner . '.instance'));
616
+		$andTrusted->add($expr->emptyString($aliasOwner.'.instance'));
617 617
 		$orX->add($andTrusted);
618 618
 
619 619
 		$this->andWhere($orX);
@@ -640,7 +640,7 @@  discard block
 block discarded – undo
640 640
 		}
641 641
 		$this->leftJoin(
642 642
 			$this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember,
643
-			$expr->eq($aliasMember . '.circle_id', $alias . '.unique_id')
643
+			$expr->eq($aliasMember.'.circle_id', $alias.'.unique_id')
644 644
 		);
645 645
 
646 646
 		$this->filterDirectMembership($aliasMember, $member);
@@ -661,30 +661,30 @@  discard block
 block discarded – undo
661 661
 
662 662
 		if ($member->getUserId() !== '') {
663 663
 			$andX->add(
664
-				$expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId()))
664
+				$expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId()))
665 665
 			);
666 666
 		}
667 667
 
668 668
 		if ($member->getSingleId() !== '') {
669 669
 			$andX->add(
670
-				$expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId()))
670
+				$expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId()))
671 671
 			);
672 672
 		}
673 673
 
674 674
 		if ($member->getUserType() > 0) {
675 675
 			$andX->add(
676
-				$expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType()))
676
+				$expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType()))
677 677
 			);
678 678
 		}
679 679
 
680 680
 		$andX->add(
681
-			$expr->eq($aliasMember . '.instance', $this->createNamedParameter($this->getInstance($member)))
681
+			$expr->eq($aliasMember.'.instance', $this->createNamedParameter($this->getInstance($member)))
682 682
 		);
683 683
 
684 684
 		if ($member->getLevel() > 0) {
685 685
 			$andX->add(
686 686
 				$expr->gte(
687
-					$aliasMember . '.level',
687
+					$aliasMember.'.level',
688 688
 					$this->createNamedParameter($member->getLevel(), IQueryBuilder::PARAM_INT)
689 689
 				)
690 690
 			);
@@ -715,12 +715,12 @@  discard block
 block discarded – undo
715 715
 
716 716
 		$expr = $this->expr();
717 717
 		$this->selectAlias(
718
-			$this->createFunction('COUNT(`' . $aliasMemberCount . '`.`member_id`)'),
719
-			(($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'population'
718
+			$this->createFunction('COUNT(`'.$aliasMemberCount.'`.`member_id`)'),
719
+			(($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'population'
720 720
 		);
721 721
 		$this->leftJoin(
722 722
 			$alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMemberCount,
723
-			$expr->eq($alias . '.unique_id', $aliasMemberCount . '.circle_id')
723
+			$expr->eq($alias.'.unique_id', $aliasMemberCount.'.circle_id')
724 724
 		);
725 725
 	}
726 726
 
@@ -756,7 +756,7 @@  discard block
 block discarded – undo
756 756
 			$helperAlias,
757 757
 			CoreRequestBuilder::TABLE_CIRCLE,
758 758
 			$aliasCircle,
759
-			$expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field)
759
+			$expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field)
760 760
 		);
761 761
 
762 762
 		if (!is_null($initiator)) {
@@ -787,7 +787,7 @@  discard block
 block discarded – undo
787 787
 		$this->generateCircleSelectAlias($aliasInvitedBy)
788 788
 			 ->leftJoin(
789 789
 				 $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasInvitedBy,
790
-				 $expr->eq($aliasMember . '.invited_by', $aliasInvitedBy . '.unique_id')
790
+				 $expr->eq($aliasMember.'.invited_by', $aliasInvitedBy.'.unique_id')
791 791
 			 );
792 792
 
793 793
 		$this->leftJoinOwner($aliasInvitedBy);
@@ -818,7 +818,7 @@  discard block
 block discarded – undo
818 818
 		$this->generateCircleSelectAlias($aliasBasedOn)
819 819
 			 ->leftJoin(
820 820
 				 $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn,
821
-				 $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id')
821
+				 $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id')
822 822
 			 );
823 823
 
824 824
 		if (!is_null($initiator)) {
@@ -851,9 +851,9 @@  discard block
 block discarded – undo
851 851
 			 ->leftJoin(
852 852
 				 $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember,
853 853
 				 $expr->andX(
854
-					 $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field),
854
+					 $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field),
855 855
 					 $expr->eq(
856
-						 $aliasMember . '.level',
856
+						 $aliasMember.'.level',
857 857
 						 $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT)
858 858
 					 )
859 859
 				 )
@@ -891,10 +891,10 @@  discard block
 block discarded – undo
891 891
 			 ->leftJoin(
892 892
 				 $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember,
893 893
 				 $expr->andX(
894
-					 $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId),
895
-					 $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId),
894
+					 $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId),
895
+					 $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId),
896 896
 					 $expr->gte(
897
-						 $aliasMember . '.level',
897
+						 $aliasMember.'.level',
898 898
 						 $this->createNamedParameter(Member::LEVEL_MEMBER, self::PARAM_INT)
899 899
 					 )
900 900
 				 )
@@ -927,7 +927,7 @@  discard block
 block discarded – undo
927 927
 
928 928
 		$this->leftJoin(
929 929
 			$alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership,
930
-			$expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field)
930
+			$expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field)
931 931
 		);
932 932
 
933 933
 //		if (!$this->getBool('getData', $options, false)) {
@@ -941,8 +941,8 @@  discard block
 block discarded – undo
941 941
 			 ->leftJoin(
942 942
 				 $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy,
943 943
 				 $expr->andX(
944
-					 $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'),
945
-					 $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id')
944
+					 $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'),
945
+					 $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id')
946 946
 				 )
947 947
 			 );
948 948
 
@@ -959,12 +959,12 @@  discard block
 block discarded – undo
959 959
 		$aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options);
960 960
 		$this->leftJoin(
961 961
 			$alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership,
962
-			$expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId))
962
+			$expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId))
963 963
 		);
964 964
 
965 965
 		$orX = $expr->orX(
966
-			$expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field),
967
-			$expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId))
966
+			$expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field),
967
+			$expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId))
968 968
 		);
969 969
 
970 970
 		$this->andWhere($orX);
@@ -985,11 +985,11 @@  discard block
 block discarded – undo
985 985
 
986 986
 		$expr = $this->expr();
987 987
 		$aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS);
988
-		$this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId)));
988
+		$this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId)));
989 989
 		if ($level > 1) {
990 990
 			$this->andWhere(
991 991
 				$expr->gte(
992
-					$aliasMembership . '.level',
992
+					$aliasMembership.'.level',
993 993
 					$this->createNamedParameter($level, IQueryBuilder::PARAM_INT)
994 994
 				)
995 995
 			);
@@ -1017,8 +1017,8 @@  discard block
 block discarded – undo
1017 1017
 		$this->leftJoin(
1018 1018
 			$alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership,
1019 1019
 			$expr->andX(
1020
-				$expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field),
1021
-				$expr->eq($aliasMembership . '.single_id', $alias . '.single_id')
1020
+				$expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field),
1021
+				$expr->eq($aliasMembership.'.single_id', $alias.'.single_id')
1022 1022
 			)
1023 1023
 		);
1024 1024
 
@@ -1031,8 +1031,8 @@  discard block
 block discarded – undo
1031 1031
 			 ->leftJoin(
1032 1032
 				 $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom,
1033 1033
 				 $expr->andX(
1034
-					 $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'),
1035
-					 $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id')
1034
+					 $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'),
1035
+					 $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id')
1036 1036
 				 )
1037 1037
 			 );
1038 1038
 	}
@@ -1075,14 +1075,14 @@  discard block
 block discarded – undo
1075 1075
 		try {
1076 1076
 			$aliasConfig = $this->generateAlias($alias, self::CONFIG, $options);
1077 1077
 			$this->selectAlias(
1078
-				$aliasConfig . '.config',
1079
-				(($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'circle_config'
1078
+				$aliasConfig.'.config',
1079
+				(($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'circle_config'
1080 1080
 			);
1081 1081
 			$this->leftJoin(
1082 1082
 				$alias,
1083 1083
 				CoreRequestBuilder::TABLE_CIRCLE,
1084 1084
 				$aliasConfig,
1085
-				$expr->eq($alias . '.circle_id', $aliasConfig . '.unique_id')
1085
+				$expr->eq($alias.'.circle_id', $aliasConfig.'.unique_id')
1086 1086
 			);
1087 1087
 		} catch (RequestBuilderException $e) {
1088 1088
 		}
@@ -1120,7 +1120,7 @@  discard block
 block discarded – undo
1120 1120
 			$aliasMembership,
1121 1121
 			$expr->andX(
1122 1122
 				$this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership),
1123
-				$expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field)
1123
+				$expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field)
1124 1124
 			)
1125 1125
 		);
1126 1126
 
@@ -1130,7 +1130,7 @@  discard block
 block discarded – undo
1130 1130
 				$aliasMembership,
1131 1131
 				CoreRequestBuilder::TABLE_CIRCLE,
1132 1132
 				$aliasMembershipCircle,
1133
-				$expr->eq($aliasMembership . '.circle_id', $aliasMembershipCircle . '.unique_id')
1133
+				$expr->eq($aliasMembership.'.circle_id', $aliasMembershipCircle.'.unique_id')
1134 1134
 			);
1135 1135
 		} catch (RequestBuilderException $e) {
1136 1136
 		}
@@ -1151,7 +1151,7 @@  discard block
 block discarded – undo
1151 1151
 						 $aliasDirectInitiator,
1152 1152
 						 $expr->andX(
1153 1153
 							 $this->exprLimit('single_id', $initiator->getSingleId(), $aliasDirectInitiator),
1154
-							 $expr->eq($aliasDirectInitiator . '.circle_id', $helperAlias . '.' . $field)
1154
+							 $expr->eq($aliasDirectInitiator.'.circle_id', $helperAlias.'.'.$field)
1155 1155
 						 )
1156 1156
 					 );
1157 1157
 			} catch (RequestBuilderException $e) {
@@ -1164,8 +1164,8 @@  discard block
 block discarded – undo
1164 1164
 			$this->leftJoin(
1165 1165
 				$aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator,
1166 1166
 				$expr->andX(
1167
-					$expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'),
1168
-					$expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id')
1167
+					$expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'),
1168
+					$expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id')
1169 1169
 				)
1170 1170
 			);
1171 1171
 
@@ -1173,8 +1173,8 @@  discard block
 block discarded – undo
1173 1173
 			$this->leftJoin(
1174 1174
 				$aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy,
1175 1175
 				$expr->andX(
1176
-					$expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'),
1177
-					$expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id')
1176
+					$expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'),
1177
+					$expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id')
1178 1178
 				)
1179 1179
 			);
1180 1180
 
@@ -1226,7 +1226,7 @@  discard block
 block discarded – undo
1226 1226
 			$orX->add(
1227 1227
 				$expr->andX(
1228 1228
 					$this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $aliasMembershipCircle),
1229
-					$expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER))
1229
+					$expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER))
1230 1230
 				)
1231 1231
 			);
1232 1232
 		}
@@ -1315,21 +1315,21 @@  discard block
 block discarded – undo
1315 1315
 		$expr = $this->expr();
1316 1316
 		$andPassive = $expr->andX();
1317 1317
 		$andPassive->add(
1318
-			$expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))
1318
+			$expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE))
1319 1319
 		);
1320 1320
 
1321 1321
 		$orMemberOrLevel = $expr->orX();
1322 1322
 		$orMemberOrLevel->add(
1323
-			$expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance')
1323
+			$expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance')
1324 1324
 		);
1325 1325
 		// TODO: do we need this ? (display members from the local instance)
1326 1326
 		$orMemberOrLevel->add(
1327
-			$expr->emptyString($this->getDefaultSelectAlias() . '.instance')
1327
+			$expr->emptyString($this->getDefaultSelectAlias().'.instance')
1328 1328
 		);
1329 1329
 
1330 1330
 		$orMemberOrLevel->add(
1331 1331
 			$expr->eq(
1332
-				$this->getDefaultSelectAlias() . '.level',
1332
+				$this->getDefaultSelectAlias().'.level',
1333 1333
 				$this->createNamedParameter(Member::LEVEL_OWNER)
1334 1334
 			)
1335 1335
 		);
@@ -1366,11 +1366,11 @@  discard block
 block discarded – undo
1366 1366
 			 )
1367 1367
 			 ->leftJoin(
1368 1368
 				 $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache,
1369
-				 $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid')
1369
+				 $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid')
1370 1370
 			 )
1371 1371
 			 ->leftJoin(
1372 1372
 				 $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages,
1373
-				 $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id')
1373
+				 $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id')
1374 1374
 			 );
1375 1375
 	}
1376 1376
 
@@ -1392,8 +1392,8 @@  discard block
 block discarded – undo
1392 1392
 		$this->leftJoin(
1393 1393
 			$aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild,
1394 1394
 			$expr->andX(
1395
-				$expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'),
1396
-				$expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id')
1395
+				$expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'),
1396
+				$expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id')
1397 1397
 			)
1398 1398
 		);
1399 1399
 
@@ -1443,13 +1443,13 @@  discard block
 block discarded – undo
1443 1443
 		$this->leftJoin(
1444 1444
 			$aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint,
1445 1445
 			$expr->andX(
1446
-				$expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'),
1447
-				$expr->eq($aliasMountpoint . '.single_id', $aliasMountMemberships . '.single_id')
1446
+				$expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'),
1447
+				$expr->eq($aliasMountpoint.'.single_id', $aliasMountMemberships.'.single_id')
1448 1448
 			)
1449 1449
 		);
1450 1450
 
1451
-		$this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint');
1452
-		$this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash');
1451
+		$this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint');
1452
+		$this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash');
1453 1453
 	}
1454 1454
 
1455 1455
 
@@ -1553,10 +1553,10 @@  discard block
 block discarded – undo
1553 1553
 	 */
1554 1554
 	public function generateAlias(string $base, string $extension, ?array &$options = []): string {
1555 1555
 		$search = str_replace('_', '.', $base);
1556
-		$path = $search . '.' . $extension;
1556
+		$path = $search.'.'.$extension;
1557 1557
 		if (!$this->validKey($path, self::$SQL_PATH)
1558 1558
 			&& !in_array($extension, $this->getArray($search, self::$SQL_PATH))) {
1559
-			throw new RequestBuilderException($extension . ' not found in ' . $search);
1559
+			throw new RequestBuilderException($extension.' not found in '.$search);
1560 1560
 		}
1561 1561
 
1562 1562
 		if (!is_array($options)) {
@@ -1565,15 +1565,15 @@  discard block
 block discarded – undo
1565 1565
 
1566 1566
 		$optionPath = '';
1567 1567
 		foreach (explode('.', $path) as $p) {
1568
-			$optionPath = trim($optionPath . '.' . $p, '.');
1568
+			$optionPath = trim($optionPath.'.'.$p, '.');
1569 1569
 			$options = array_merge(
1570 1570
 				$options,
1571
-				$this->getArray($optionPath . '.' . self::OPTIONS, self::$SQL_PATH),
1572
-				$this->getArray($optionPath . '.' . self::OPTIONS, $this->options)
1571
+				$this->getArray($optionPath.'.'.self::OPTIONS, self::$SQL_PATH),
1572
+				$this->getArray($optionPath.'.'.self::OPTIONS, $this->options)
1573 1573
 			);
1574 1574
 		}
1575 1575
 
1576
-		return $base . '_' . $extension;
1576
+		return $base.'_'.$extension;
1577 1577
 	}
1578 1578
 
1579 1579
 
@@ -1593,7 +1593,7 @@  discard block
 block discarded – undo
1593 1593
 			} else {
1594 1594
 				$k = $arr;
1595 1595
 			}
1596
-			$path[$k] = $prefix . '_' . $k . '_';
1596
+			$path[$k] = $prefix.'_'.$k.'_';
1597 1597
 		}
1598 1598
 
1599 1599
 		return $path;
@@ -1610,7 +1610,7 @@  discard block
 block discarded – undo
1610 1610
 		$expr = $this->expr();
1611 1611
 		$orX = $expr->orX();
1612 1612
 		foreach ($aliases as $alias) {
1613
-			$orX->add($expr->gte($alias . '.level', $this->createNamedParameter($level)));
1613
+			$orX->add($expr->gte($alias.'.level', $this->createNamedParameter($level)));
1614 1614
 		}
1615 1615
 
1616 1616
 		return $orX;
Please login to merge, or discard this patch.