@@ -78,7 +78,7 @@ |
||
78 | 78 | $tables = $schema->getTables(); |
79 | 79 | foreach ($tables as $table) { |
80 | 80 | $tableName = $table->getName(); |
81 | - if (substr($tableName, 0, 8 + strlen($prefix)) === $prefix . 'circles_') { |
|
81 | + if (substr($tableName, 0, 8 + strlen($prefix)) === $prefix.'circles_') { |
|
82 | 82 | $tableName = substr($tableName, strlen($prefix)); |
83 | 83 | $schema->dropTable($tableName); |
84 | 84 | } |
@@ -104,16 +104,16 @@ |
||
104 | 104 | } catch (Exception $e) { |
105 | 105 | $this->e($e); |
106 | 106 | |
107 | - return $membership->getSingleId() . ' is not ' . $inheritance . ' of ' |
|
108 | - . $membership->getCircleId() . ' anymore'; |
|
107 | + return $membership->getSingleId().' is not '.$inheritance.' of ' |
|
108 | + . $membership->getCircleId().' anymore'; |
|
109 | 109 | } |
110 | 110 | |
111 | - return $federatedUser->getUserId() . ' (' . Member::$TYPE[$federatedUser->getUserType()] |
|
112 | - . ') is not ' . $inheritance . ' of ' . $membership->getCircleId() . ' anymore'; |
|
111 | + return $federatedUser->getUserId().' ('.Member::$TYPE[$federatedUser->getUserType()] |
|
112 | + . ') is not '.$inheritance.' of '.$membership->getCircleId().' anymore'; |
|
113 | 113 | }, $event->getMemberships() |
114 | 114 | ); |
115 | 115 | |
116 | - $this->log(3, $prefix . implode('. ', $memberships)); |
|
116 | + $this->log(3, $prefix.implode('. ', $memberships)); |
|
117 | 117 | } |
118 | 118 | |
119 | 119 | } |
@@ -104,16 +104,16 @@ |
||
104 | 104 | } catch (Exception $e) { |
105 | 105 | $this->e($e); |
106 | 106 | |
107 | - return $membership->getSingleId() . ' is now ' . $inheritance . ' of ' |
|
107 | + return $membership->getSingleId().' is now '.$inheritance.' of ' |
|
108 | 108 | . $membership->getCircleId(); |
109 | 109 | } |
110 | 110 | |
111 | - return $federatedUser->getUserId() . ' (' . Member::$TYPE[$federatedUser->getUserType()] |
|
112 | - . ') is now ' . $inheritance . ' of ' . $membership->getCircleId(); |
|
111 | + return $federatedUser->getUserId().' ('.Member::$TYPE[$federatedUser->getUserType()] |
|
112 | + . ') is now '.$inheritance.' of '.$membership->getCircleId(); |
|
113 | 113 | }, $event->getMemberships() |
114 | 114 | ); |
115 | 115 | |
116 | - $this->log(3, $prefix . implode('. ', $memberships)); |
|
116 | + $this->log(3, $prefix.implode('. ', $memberships)); |
|
117 | 117 | } |
118 | 118 | |
119 | 119 | } |
@@ -96,13 +96,13 @@ discard block |
||
96 | 96 | $circle = $event->getCircle(); |
97 | 97 | $eventType = ($event->getType() === CircleGenericEvent::INVITED) ? 'invited' : 'joined'; |
98 | 98 | |
99 | - $info = 'A new member have been added (' . $eventType . ') to a Circle. '; |
|
99 | + $info = 'A new member have been added ('.$eventType.') to a Circle. '; |
|
100 | 100 | |
101 | - $info .= 'userId: ' . $member->getUserId() . '; userType: ' . Member::$TYPE[$member->getUserType( |
|
101 | + $info .= 'userId: '.$member->getUserId().'; userType: '.Member::$TYPE[$member->getUserType( |
|
102 | 102 | )] |
103 | - . '; singleId: ' . $member->getSingleId() . '; memberId: ' . $member->getId() |
|
104 | - . '; isLocal: ' . json_encode($member->isLocal()) . '; level: ' |
|
105 | - . Member::$DEF_LEVEL[$member->getLevel()] . '; '; |
|
103 | + . '; singleId: '.$member->getSingleId().'; memberId: '.$member->getId() |
|
104 | + . '; isLocal: '.json_encode($member->isLocal()).'; level: ' |
|
105 | + . Member::$DEF_LEVEL[$member->getLevel()].'; '; |
|
106 | 106 | |
107 | 107 | $memberships = array_map( |
108 | 108 | function(Membership $membership) { |
@@ -111,22 +111,22 @@ discard block |
||
111 | 111 | ); |
112 | 112 | |
113 | 113 | $listMemberships = (count($memberships) > 0) ? implode(', ', $memberships) : 'none'; |
114 | - $info .= 'circleName: ' . $circle->getDisplayName() . '; circleId: ' . $circle->getSingleId() |
|
115 | - . '; Circle memberships: ' . $listMemberships . '.'; |
|
114 | + $info .= 'circleName: '.$circle->getDisplayName().'; circleId: '.$circle->getSingleId() |
|
115 | + . '; Circle memberships: '.$listMemberships.'.'; |
|
116 | 116 | |
117 | 117 | if ($member->getUserType() === Member::TYPE_CIRCLE) { |
118 | 118 | $basedOn = $member->getBasedOn(); |
119 | 119 | $members = array_map( |
120 | 120 | function(Member $member) { |
121 | - return $member->getUserId() . ' (' . Member::$TYPE[$member->getUserType()] . ')'; |
|
121 | + return $member->getUserId().' ('.Member::$TYPE[$member->getUserType()].')'; |
|
122 | 122 | }, $basedOn->getInheritedMembers() |
123 | 123 | ); |
124 | 124 | |
125 | - $info .= ' Member is a Circle (singleId: ' . $basedOn->getSingleId() |
|
126 | - . ') that contains those inherited members: ' . implode(', ', $members); |
|
125 | + $info .= ' Member is a Circle (singleId: '.$basedOn->getSingleId() |
|
126 | + . ') that contains those inherited members: '.implode(', ', $members); |
|
127 | 127 | } |
128 | 128 | |
129 | - $this->log(3, $prefix . $info); |
|
129 | + $this->log(3, $prefix.$info); |
|
130 | 130 | } |
131 | 131 | } |
132 | 132 |
@@ -186,11 +186,11 @@ discard block |
||
186 | 186 | $this->federatedUserService->commandLineInitiator($initiator, $initiatorType, $circleId, true); |
187 | 187 | $circle = $this->circleService->getCircle($circleId); |
188 | 188 | |
189 | - $output->writeln('<info>Name</info>: ' . $circle->getName()); |
|
189 | + $output->writeln('<info>Name</info>: '.$circle->getName()); |
|
190 | 190 | $owner = $circle->getOwner(); |
191 | - $output->writeln('<info>Owner</info>: ' . $owner->getUserId() . '@' . $owner->getInstance()); |
|
191 | + $output->writeln('<info>Owner</info>: '.$owner->getUserId().'@'.$owner->getInstance()); |
|
192 | 192 | $type = implode(", ", Circle::getCircleFlags($circle, Circle::FLAGS_LONG)); |
193 | - $output->writeln('<info>Config</info>: ' . $type); |
|
193 | + $output->writeln('<info>Config</info>: '.$type); |
|
194 | 194 | $output->writeln(' '); |
195 | 195 | |
196 | 196 | $tree = new NC22TreeNode(null, new SimpleDataStore(['circle' => $circle])); |
@@ -254,8 +254,7 @@ discard block |
||
254 | 254 | ($this->input->getOption('display-name')) ? |
255 | 255 | $member->getBasedOn()->getDisplayName() : $member->getUserId(), |
256 | 256 | $this->configService->displayInstance($member->getInstance()), |
257 | - ($level > 0) ? Member::$DEF_LEVEL[$level] : |
|
258 | - '(' . strtolower($member->getStatus()) . ')' |
|
257 | + ($level > 0) ? Member::$DEF_LEVEL[$level] : '('.strtolower($member->getStatus()).')' |
|
259 | 258 | ] |
260 | 259 | ); |
261 | 260 | } |
@@ -414,18 +413,18 @@ discard block |
||
414 | 413 | $member = $data->gObj('member', Member::class); |
415 | 414 | |
416 | 415 | if ($lineNumber === 1) { |
417 | - $line .= '<info>' . $member->getSingleId() . '</info>'; |
|
416 | + $line .= '<info>'.$member->getSingleId().'</info>'; |
|
418 | 417 | if (!$this->configService->isLocalInstance($member->getInstance())) { |
419 | - $line .= '@' . $member->getInstance(); |
|
418 | + $line .= '@'.$member->getInstance(); |
|
420 | 419 | } |
421 | - $line .= ' (' . Member::$DEF_LEVEL[$member->getLevel()] . ')'; |
|
420 | + $line .= ' ('.Member::$DEF_LEVEL[$member->getLevel()].')'; |
|
422 | 421 | |
423 | - $line .= ' <info>MemberId</info>: ' . $member->getId(); |
|
422 | + $line .= ' <info>MemberId</info>: '.$member->getId(); |
|
424 | 423 | $name = ($this->input->getOption('display-name')) ? |
425 | 424 | $member->getBasedOn()->getDisplayName() : $member->getUserId(); |
426 | - $line .= ' <info>Name</info>: ' . $name; |
|
425 | + $line .= ' <info>Name</info>: '.$name; |
|
427 | 426 | $source = ($member->hasBasedOn()) ? $member->getBasedOn()->getSource() : ''; |
428 | - $line .= ' <info>Source</info>: ' . Circle::$DEF_SOURCE[$source]; |
|
427 | + $line .= ' <info>Source</info>: '.Circle::$DEF_SOURCE[$source]; |
|
429 | 428 | } |
430 | 429 | |
431 | 430 | if ($lineNumber === 2) { |
@@ -437,16 +436,16 @@ discard block |
||
437 | 436 | return $line; |
438 | 437 | } |
439 | 438 | $owner = $circle->getOwner(); |
440 | - $line .= '<info>Owner</info>: ' . $owner->getUserId() . '@' . $owner->getInstance(); |
|
439 | + $line .= '<info>Owner</info>: '.$owner->getUserId().'@'.$owner->getInstance(); |
|
441 | 440 | $type = implode(", ", Circle::getCircleFlags($circle, Circle::FLAGS_LONG)); |
442 | - $line .= ($type === '') ? '' : ' <info>Config</info>: ' . $type; |
|
441 | + $line .= ($type === '') ? '' : ' <info>Config</info>: '.$type; |
|
443 | 442 | } |
444 | 443 | |
445 | 444 | } else { |
446 | 445 | if ($lineNumber === 1 && !is_null($circle)) { |
447 | - $line .= '<info>' . $circle->getSingleId() . '</info>'; |
|
446 | + $line .= '<info>'.$circle->getSingleId().'</info>'; |
|
448 | 447 | if (!$this->configService->isLocalInstance($circle->getInstance())) { |
449 | - $line .= '@' . $circle->getInstance(); |
|
448 | + $line .= '@'.$circle->getInstance(); |
|
450 | 449 | } |
451 | 450 | } |
452 | 451 | } |
@@ -717,29 +717,29 @@ discard block |
||
717 | 717 | * @throws MemberNotFoundException |
718 | 718 | */ |
719 | 719 | public function importFromDatabase(array $data, string $prefix = ''): INC22QueryRow { |
720 | - if ($this->get($prefix . 'single_id', $data) === '') { |
|
720 | + if ($this->get($prefix.'single_id', $data) === '') { |
|
721 | 721 | throw new MemberNotFoundException(); |
722 | 722 | } |
723 | 723 | |
724 | - $this->setId($this->get($prefix . 'member_id', $data)); |
|
725 | - $this->setCircleId($this->get($prefix . 'circle_id', $data)); |
|
726 | - $this->setSingleId($this->get($prefix . 'single_id', $data)); |
|
727 | - $this->setUserId($this->get($prefix . 'user_id', $data)); |
|
728 | - $this->setUserType($this->getInt($prefix . 'user_type', $data)); |
|
729 | - $this->setInstance($this->get($prefix . 'instance', $data)); |
|
730 | - $this->setLevel($this->getInt($prefix . 'level', $data)); |
|
731 | - $this->setStatus($this->get($prefix . 'status', $data)); |
|
732 | - $this->setDisplayName($this->get($prefix . 'cached_name', $data)); |
|
733 | - $this->setNote($this->get($prefix . 'note', $data)); |
|
734 | - $this->setContactId($this->get($prefix . 'contact_id', $data)); |
|
735 | - $this->setContactMeta($this->get($prefix . 'contact_meta', $data)); |
|
736 | - |
|
737 | - $cachedUpdate = $this->get($prefix . 'cached_update', $data); |
|
724 | + $this->setId($this->get($prefix.'member_id', $data)); |
|
725 | + $this->setCircleId($this->get($prefix.'circle_id', $data)); |
|
726 | + $this->setSingleId($this->get($prefix.'single_id', $data)); |
|
727 | + $this->setUserId($this->get($prefix.'user_id', $data)); |
|
728 | + $this->setUserType($this->getInt($prefix.'user_type', $data)); |
|
729 | + $this->setInstance($this->get($prefix.'instance', $data)); |
|
730 | + $this->setLevel($this->getInt($prefix.'level', $data)); |
|
731 | + $this->setStatus($this->get($prefix.'status', $data)); |
|
732 | + $this->setDisplayName($this->get($prefix.'cached_name', $data)); |
|
733 | + $this->setNote($this->get($prefix.'note', $data)); |
|
734 | + $this->setContactId($this->get($prefix.'contact_id', $data)); |
|
735 | + $this->setContactMeta($this->get($prefix.'contact_meta', $data)); |
|
736 | + |
|
737 | + $cachedUpdate = $this->get($prefix.'cached_update', $data); |
|
738 | 738 | if ($cachedUpdate !== '') { |
739 | 739 | $this->setDisplayUpdate(DateTime::createFromFormat('Y-m-d H:i:s', $cachedUpdate)->getTimestamp()); |
740 | 740 | } |
741 | 741 | |
742 | - $joined = $this->get($prefix . 'joined', $data); |
|
742 | + $joined = $this->get($prefix.'joined', $data); |
|
743 | 743 | if ($joined !== '') { |
744 | 744 | $this->setJoined(DateTime::createFromFormat('Y-m-d H:i:s', $joined)->getTimestamp()); |
745 | 745 | } |
@@ -813,7 +813,7 @@ discard block |
||
813 | 813 | public static function parseLevelInt(int $level): int { |
814 | 814 | if (!array_key_exists($level, self::$DEF_LEVEL)) { |
815 | 815 | $all = implode(', ', array_keys(self::$DEF_LEVEL)); |
816 | - throw new ParseMemberLevelException('Available levels: ' . $all, 121); |
|
816 | + throw new ParseMemberLevelException('Available levels: '.$all, 121); |
|
817 | 817 | } |
818 | 818 | |
819 | 819 | return $level; |
@@ -832,7 +832,7 @@ discard block |
||
832 | 832 | |
833 | 833 | if (!$level) { |
834 | 834 | $all = implode(', ', array_values(self::$DEF_LEVEL)); |
835 | - throw new ParseMemberLevelException('Available levels: ' . $all, 121); |
|
835 | + throw new ParseMemberLevelException('Available levels: '.$all, 121); |
|
836 | 836 | } |
837 | 837 | |
838 | 838 | return (int)$level; |
@@ -853,7 +853,7 @@ discard block |
||
853 | 853 | $type = array_search($typeString, Member::$TYPE); |
854 | 854 | if ($type === false) { |
855 | 855 | $all = implode(', ', array_values(self::$TYPE)); |
856 | - throw new UserTypeNotFoundException('Available types: ' . $all); |
|
856 | + throw new UserTypeNotFoundException('Available types: '.$all); |
|
857 | 857 | } |
858 | 858 | |
859 | 859 | return (int)$type; |
@@ -144,7 +144,7 @@ |
||
144 | 144 | $circle = new Circle(); |
145 | 145 | $circle->importFromDatabase( |
146 | 146 | $data, |
147 | - CoreQueryBuilder::HELPER . '_' . CoreQueryBuilder::CIRCLE . '_' |
|
147 | + CoreQueryBuilder::HELPER.'_'.CoreQueryBuilder::CIRCLE.'_' |
|
148 | 148 | ); |
149 | 149 | |
150 | 150 | return $circle; |
@@ -265,7 +265,7 @@ discard block |
||
265 | 265 | * @param int $config |
266 | 266 | */ |
267 | 267 | public function limitToConfigFlag(int $config): void { |
268 | - $this->andWhere($this->expr()->bitwiseAnd($this->getDefaultSelectAlias() . '.config', $config)); |
|
268 | + $this->andWhere($this->expr()->bitwiseAnd($this->getDefaultSelectAlias().'.config', $config)); |
|
269 | 269 | } |
270 | 270 | |
271 | 271 | |
@@ -349,7 +349,7 @@ discard block |
||
349 | 349 | } |
350 | 350 | |
351 | 351 | if ($circle->getDisplayName() !== '') { |
352 | - $this->searchInDBField('display_name', '%' . $circle->getDisplayName() . '%'); |
|
352 | + $this->searchInDBField('display_name', '%'.$circle->getDisplayName().'%'); |
|
353 | 353 | } |
354 | 354 | } |
355 | 355 | |
@@ -365,7 +365,7 @@ discard block |
||
365 | 365 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance) |
366 | 366 | ->leftJoin( |
367 | 367 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance, |
368 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance') |
|
368 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance') |
|
369 | 369 | ); |
370 | 370 | } catch (RequestBuilderException $e) { |
371 | 371 | } |
@@ -418,7 +418,7 @@ discard block |
||
418 | 418 | $expr = $this->expr(); |
419 | 419 | $this->leftJoin( |
420 | 420 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote, |
421 | - $expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
421 | + $expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
422 | 422 | ); |
423 | 423 | } |
424 | 424 | |
@@ -446,12 +446,12 @@ discard block |
||
446 | 446 | $this->leftJoin( |
447 | 447 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember, |
448 | 448 | $expr->andX( |
449 | - $expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'), |
|
449 | + $expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'), |
|
450 | 450 | $expr->eq( |
451 | - $aliasRemoteMember . '.instance', |
|
451 | + $aliasRemoteMember.'.instance', |
|
452 | 452 | $this->createNamedParameter($remoteInstance->getInstance()) |
453 | 453 | ), |
454 | - $expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
454 | + $expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
455 | 455 | ) |
456 | 456 | ); |
457 | 457 | } |
@@ -483,21 +483,21 @@ discard block |
||
483 | 483 | $this->leftJoin( |
484 | 484 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle, |
485 | 485 | $expr->andX( |
486 | - $expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'), |
|
487 | - $expr->emptyString($aliasRemoteCircle . '.instance'), |
|
488 | - $expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
486 | + $expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'), |
|
487 | + $expr->emptyString($aliasRemoteCircle.'.instance'), |
|
488 | + $expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
489 | 489 | ) |
490 | 490 | ); |
491 | 491 | $this->leftJoin( |
492 | 492 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner, |
493 | 493 | $expr->andX( |
494 | - $expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'), |
|
494 | + $expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'), |
|
495 | 495 | $expr->eq( |
496 | - $aliasRemoteCircleOwner . '.instance', |
|
496 | + $aliasRemoteCircleOwner.'.instance', |
|
497 | 497 | $this->createNamedParameter($remoteInstance->getInstance()) |
498 | 498 | ), |
499 | 499 | $expr->eq( |
500 | - $aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
500 | + $aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
501 | 501 | ) |
502 | 502 | ) |
503 | 503 | ); |
@@ -530,16 +530,16 @@ discard block |
||
530 | 530 | $expr = $this->expr(); |
531 | 531 | $orX = $expr->orX(); |
532 | 532 | $orX->add( |
533 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
533 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
534 | 534 | ); |
535 | 535 | |
536 | 536 | $orExtOrPassive = $expr->orX(); |
537 | 537 | $orExtOrPassive->add( |
538 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
538 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
539 | 539 | ); |
540 | 540 | if (!$sensitive) { |
541 | 541 | $orExtOrPassive->add( |
542 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
542 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
543 | 543 | ); |
544 | 544 | } else { |
545 | 545 | if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) { |
@@ -548,8 +548,8 @@ discard block |
||
548 | 548 | } |
549 | 549 | |
550 | 550 | $orInstance = $expr->orX(); |
551 | - $orInstance->add($expr->isNotNull($aliasRemoteMember . '.instance')); |
|
552 | - $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner . '.instance')); |
|
551 | + $orInstance->add($expr->isNotNull($aliasRemoteMember.'.instance')); |
|
552 | + $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner.'.instance')); |
|
553 | 553 | |
554 | 554 | $andExternal = $expr->andX(); |
555 | 555 | $andExternal->add($orExtOrPassive); |
@@ -558,13 +558,13 @@ discard block |
||
558 | 558 | $orExtOrTrusted = $expr->orX(); |
559 | 559 | $orExtOrTrusted->add($andExternal); |
560 | 560 | $orExtOrTrusted->add( |
561 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
561 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
562 | 562 | ); |
563 | 563 | |
564 | 564 | $andTrusted = $expr->andX(); |
565 | 565 | $andTrusted->add($orExtOrTrusted); |
566 | - $andTrusted->add($expr->bitwiseAnd($aliasCircle . '.config', Circle::CFG_FEDERATED)); |
|
567 | - $andTrusted->add($expr->emptyString($aliasOwner . '.instance')); |
|
566 | + $andTrusted->add($expr->bitwiseAnd($aliasCircle.'.config', Circle::CFG_FEDERATED)); |
|
567 | + $andTrusted->add($expr->emptyString($aliasOwner.'.instance')); |
|
568 | 568 | $orX->add($andTrusted); |
569 | 569 | |
570 | 570 | $this->andWhere($orX); |
@@ -591,7 +591,7 @@ discard block |
||
591 | 591 | } |
592 | 592 | $this->leftJoin( |
593 | 593 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
594 | - $expr->eq($aliasMember . '.circle_id', $alias . '.unique_id') |
|
594 | + $expr->eq($aliasMember.'.circle_id', $alias.'.unique_id') |
|
595 | 595 | ); |
596 | 596 | |
597 | 597 | $this->filterDirectMembership($aliasMember, $member); |
@@ -612,28 +612,28 @@ discard block |
||
612 | 612 | |
613 | 613 | if ($member->getUserId() !== '') { |
614 | 614 | $andX->add( |
615 | - $expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId())) |
|
615 | + $expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId())) |
|
616 | 616 | ); |
617 | 617 | } |
618 | 618 | |
619 | 619 | if ($member->getSingleId() !== '') { |
620 | 620 | $andX->add( |
621 | - $expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId())) |
|
621 | + $expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId())) |
|
622 | 622 | ); |
623 | 623 | } |
624 | 624 | |
625 | 625 | if ($member->getUserType() > 0) { |
626 | 626 | $andX->add( |
627 | - $expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType())) |
|
627 | + $expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType())) |
|
628 | 628 | ); |
629 | 629 | } |
630 | 630 | |
631 | 631 | $andX->add( |
632 | - $expr->eq($aliasMember . '.instance', $this->createNamedParameter($this->getInstance($member))) |
|
632 | + $expr->eq($aliasMember.'.instance', $this->createNamedParameter($this->getInstance($member))) |
|
633 | 633 | ); |
634 | 634 | |
635 | 635 | if ($member->getLevel() > 0) { |
636 | - $andX->add($expr->gte($aliasMember . '.level', $this->createNamedParameter($member->getLevel()))); |
|
636 | + $andX->add($expr->gte($aliasMember.'.level', $this->createNamedParameter($member->getLevel()))); |
|
637 | 637 | } |
638 | 638 | |
639 | 639 | $this->andWhere($andX); |
@@ -671,7 +671,7 @@ discard block |
||
671 | 671 | $helperAlias, |
672 | 672 | CoreRequestBuilder::TABLE_CIRCLE, |
673 | 673 | $aliasCircle, |
674 | - $expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field) |
|
674 | + $expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field) |
|
675 | 675 | ); |
676 | 676 | |
677 | 677 | if (!is_null($initiator)) { |
@@ -706,7 +706,7 @@ discard block |
||
706 | 706 | $this->generateCircleSelectAlias($aliasBasedOn) |
707 | 707 | ->leftJoin( |
708 | 708 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn, |
709 | - $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id') |
|
709 | + $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id') |
|
710 | 710 | ); |
711 | 711 | |
712 | 712 | if (!is_null($initiator)) { |
@@ -739,9 +739,9 @@ discard block |
||
739 | 739 | ->leftJoin( |
740 | 740 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
741 | 741 | $expr->andX( |
742 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field), |
|
742 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field), |
|
743 | 743 | $expr->eq( |
744 | - $aliasMember . '.level', |
|
744 | + $aliasMember.'.level', |
|
745 | 745 | $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT) |
746 | 746 | ) |
747 | 747 | ) |
@@ -779,10 +779,10 @@ discard block |
||
779 | 779 | ->leftJoin( |
780 | 780 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
781 | 781 | $expr->andX( |
782 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId), |
|
783 | - $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId), |
|
782 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId), |
|
783 | + $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId), |
|
784 | 784 | $expr->gte( |
785 | - $aliasMember . '.level', |
|
785 | + $aliasMember.'.level', |
|
786 | 786 | $this->createNamedParameter(Member::LEVEL_MEMBER, self::PARAM_INT) |
787 | 787 | ) |
788 | 788 | ) |
@@ -812,7 +812,7 @@ discard block |
||
812 | 812 | |
813 | 813 | $this->leftJoin( |
814 | 814 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
815 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field) |
|
815 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field) |
|
816 | 816 | ); |
817 | 817 | |
818 | 818 | // if (!$this->getBool('getData', $options, false)) { |
@@ -826,8 +826,8 @@ discard block |
||
826 | 826 | ->leftJoin( |
827 | 827 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
828 | 828 | $expr->andX( |
829 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'), |
|
830 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id') |
|
829 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'), |
|
830 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id') |
|
831 | 831 | ) |
832 | 832 | ); |
833 | 833 | |
@@ -844,12 +844,12 @@ discard block |
||
844 | 844 | $aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options); |
845 | 845 | $this->leftJoin( |
846 | 846 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership, |
847 | - $expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId)) |
|
847 | + $expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId)) |
|
848 | 848 | ); |
849 | 849 | |
850 | 850 | $orX = $expr->orX( |
851 | - $expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field), |
|
852 | - $expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId)) |
|
851 | + $expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field), |
|
852 | + $expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId)) |
|
853 | 853 | ); |
854 | 854 | |
855 | 855 | $this->andWhere($orX); |
@@ -869,7 +869,7 @@ discard block |
||
869 | 869 | |
870 | 870 | $expr = $this->expr(); |
871 | 871 | $aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS); |
872 | - $this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId))); |
|
872 | + $this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId))); |
|
873 | 873 | } |
874 | 874 | |
875 | 875 | |
@@ -893,7 +893,7 @@ discard block |
||
893 | 893 | $this->leftJoin( |
894 | 894 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
895 | 895 | // $expr->andX( |
896 | - $expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field) |
|
896 | + $expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field) |
|
897 | 897 | // $expr->eq($aliasMembership . '.single_id', $alias . '.single_id') |
898 | 898 | // ) |
899 | 899 | ); |
@@ -907,8 +907,8 @@ discard block |
||
907 | 907 | ->leftJoin( |
908 | 908 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom, |
909 | 909 | $expr->andX( |
910 | - $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'), |
|
911 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id') |
|
910 | + $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'), |
|
911 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id') |
|
912 | 912 | ) |
913 | 913 | ); |
914 | 914 | } |
@@ -974,7 +974,7 @@ discard block |
||
974 | 974 | $aliasMembership, |
975 | 975 | $expr->andX( |
976 | 976 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), |
977 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field) |
|
977 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field) |
|
978 | 978 | ) |
979 | 979 | ); |
980 | 980 | |
@@ -987,8 +987,8 @@ discard block |
||
987 | 987 | $this->leftJoin( |
988 | 988 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator, |
989 | 989 | $expr->andX( |
990 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'), |
|
991 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id') |
|
990 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'), |
|
991 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id') |
|
992 | 992 | ) |
993 | 993 | ); |
994 | 994 | |
@@ -996,8 +996,8 @@ discard block |
||
996 | 996 | $this->leftJoin( |
997 | 997 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
998 | 998 | $expr->andX( |
999 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'), |
|
1000 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id') |
|
999 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'), |
|
1000 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id') |
|
1001 | 1001 | ) |
1002 | 1002 | ); |
1003 | 1003 | |
@@ -1016,7 +1016,7 @@ discard block |
||
1016 | 1016 | $aliasInheritedByMembership = $this->generateAlias($aliasInheritedBy, self::MEMBERSHIPS); |
1017 | 1017 | $this->generateMembershipSelectAlias($aliasMembership, $aliasInheritedByMembership); |
1018 | 1018 | } catch (RequestBuilderException $e) { |
1019 | - \OC::$server->getLogger()->log(3, '-- ' . $e->getMessage()); |
|
1019 | + \OC::$server->getLogger()->log(3, '-- '.$e->getMessage()); |
|
1020 | 1020 | } |
1021 | 1021 | } |
1022 | 1022 | |
@@ -1040,30 +1040,30 @@ discard block |
||
1040 | 1040 | $orX = $expr->orX(); |
1041 | 1041 | $orX->add( |
1042 | 1042 | $expr->andX( |
1043 | - $expr->gte($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
1043 | + $expr->gte($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
1044 | 1044 | ) |
1045 | 1045 | ); |
1046 | 1046 | |
1047 | 1047 | if ($getPersonalCircle) { |
1048 | 1048 | $orX->add( |
1049 | 1049 | $expr->andX( |
1050 | - $expr->bitwiseAnd($alias . '.config', Circle::CFG_PERSONAL), |
|
1051 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
1050 | + $expr->bitwiseAnd($alias.'.config', Circle::CFG_PERSONAL), |
|
1051 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
1052 | 1052 | ) |
1053 | 1053 | ); |
1054 | 1054 | } |
1055 | 1055 | if (!$this->getBool('mustBeMember', $options, true)) { |
1056 | - $orX->add($expr->bitwiseAnd($alias . '.config', Circle::CFG_VISIBLE)); |
|
1056 | + $orX->add($expr->bitwiseAnd($alias.'.config', Circle::CFG_VISIBLE)); |
|
1057 | 1057 | } |
1058 | 1058 | if ($this->getBool('canBeVisitor', $options, false)) { |
1059 | 1059 | // TODO: should find a better way, also filter on remote initiator on non-federated ? |
1060 | - $orX->add($expr->gte($alias . '.config', $this->createNamedParameter(0))); |
|
1060 | + $orX->add($expr->gte($alias.'.config', $this->createNamedParameter(0))); |
|
1061 | 1061 | } |
1062 | 1062 | if ($this->getBool('canBeVisitorOnOpen', $options, false)) { |
1063 | 1063 | $andOpen = $expr->andX(); |
1064 | - $andOpen->add($expr->bitwiseAnd($alias . '.config', Circle::CFG_OPEN)); |
|
1064 | + $andOpen->add($expr->bitwiseAnd($alias.'.config', Circle::CFG_OPEN)); |
|
1065 | 1065 | $andOpen->add( |
1066 | - $this->createFunction('NOT') . $expr->bitwiseAnd($alias . '.config', Circle::CFG_REQUEST) |
|
1066 | + $this->createFunction('NOT').$expr->bitwiseAnd($alias.'.config', Circle::CFG_REQUEST) |
|
1067 | 1067 | ); |
1068 | 1068 | $orX->add($andOpen); |
1069 | 1069 | } |
@@ -1108,7 +1108,7 @@ discard block |
||
1108 | 1108 | $hide = $expr->andX(); |
1109 | 1109 | foreach (Circle::$DEF_CFG as $cfg => $v) { |
1110 | 1110 | if ($flag & $cfg) { |
1111 | - $hide->add($this->createFunction('NOT') . $expr->bitwiseAnd($aliasCircle . '.config', $cfg)); |
|
1111 | + $hide->add($this->createFunction('NOT').$expr->bitwiseAnd($aliasCircle.'.config', $cfg)); |
|
1112 | 1112 | } |
1113 | 1113 | } |
1114 | 1114 | |
@@ -1127,21 +1127,21 @@ discard block |
||
1127 | 1127 | $expr = $this->expr(); |
1128 | 1128 | $andPassive = $expr->andX(); |
1129 | 1129 | $andPassive->add( |
1130 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
1130 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
1131 | 1131 | ); |
1132 | 1132 | |
1133 | 1133 | $orMemberOrLevel = $expr->orX(); |
1134 | 1134 | $orMemberOrLevel->add( |
1135 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance') |
|
1135 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance') |
|
1136 | 1136 | ); |
1137 | 1137 | // TODO: do we need this ? (display members from the local instance) |
1138 | 1138 | $orMemberOrLevel->add( |
1139 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance') |
|
1139 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance') |
|
1140 | 1140 | ); |
1141 | 1141 | |
1142 | 1142 | $orMemberOrLevel->add( |
1143 | 1143 | $expr->eq( |
1144 | - $this->getDefaultSelectAlias() . '.level', |
|
1144 | + $this->getDefaultSelectAlias().'.level', |
|
1145 | 1145 | $this->createNamedParameter(Member::LEVEL_OWNER) |
1146 | 1146 | ) |
1147 | 1147 | ); |
@@ -1157,7 +1157,7 @@ discard block |
||
1157 | 1157 | * @param int $flag |
1158 | 1158 | */ |
1159 | 1159 | public function filterConfig(string $aliasCircle, int $flag): void { |
1160 | - $this->andWhere($this->expr()->bitwiseAnd($aliasCircle . '.config', $flag)); |
|
1160 | + $this->andWhere($this->expr()->bitwiseAnd($aliasCircle.'.config', $flag)); |
|
1161 | 1161 | } |
1162 | 1162 | |
1163 | 1163 | |
@@ -1188,11 +1188,11 @@ discard block |
||
1188 | 1188 | ) |
1189 | 1189 | ->leftJoin( |
1190 | 1190 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache, |
1191 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid') |
|
1191 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid') |
|
1192 | 1192 | ) |
1193 | 1193 | ->leftJoin( |
1194 | 1194 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages, |
1195 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id') |
|
1195 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id') |
|
1196 | 1196 | ); |
1197 | 1197 | } |
1198 | 1198 | |
@@ -1214,8 +1214,8 @@ discard block |
||
1214 | 1214 | $this->leftJoin( |
1215 | 1215 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild, |
1216 | 1216 | $expr->andX( |
1217 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'), |
|
1218 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id') |
|
1217 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'), |
|
1218 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id') |
|
1219 | 1219 | ) |
1220 | 1220 | ); |
1221 | 1221 | |
@@ -1265,13 +1265,13 @@ discard block |
||
1265 | 1265 | $this->leftJoin( |
1266 | 1266 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint, |
1267 | 1267 | $expr->andX( |
1268 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'), |
|
1269 | - $expr->eq($aliasMountpoint . '.single_id', $aliasMountMemberships . '.single_id') |
|
1268 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'), |
|
1269 | + $expr->eq($aliasMountpoint.'.single_id', $aliasMountMemberships.'.single_id') |
|
1270 | 1270 | ) |
1271 | 1271 | ); |
1272 | 1272 | |
1273 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint'); |
|
1274 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash'); |
|
1273 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint'); |
|
1274 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash'); |
|
1275 | 1275 | } |
1276 | 1276 | |
1277 | 1277 | |
@@ -1375,10 +1375,10 @@ discard block |
||
1375 | 1375 | */ |
1376 | 1376 | public function generateAlias(string $base, string $extension, ?array &$options = []): string { |
1377 | 1377 | $search = str_replace('_', '.', $base); |
1378 | - $path = $search . '.' . $extension; |
|
1378 | + $path = $search.'.'.$extension; |
|
1379 | 1379 | if (!$this->validKey($path, self::$SQL_PATH) |
1380 | 1380 | && !in_array($extension, $this->getArray($search, self::$SQL_PATH))) { |
1381 | - throw new RequestBuilderException($extension . ' not found in ' . $search); |
|
1381 | + throw new RequestBuilderException($extension.' not found in '.$search); |
|
1382 | 1382 | } |
1383 | 1383 | |
1384 | 1384 | if (!is_array($options)) { |
@@ -1387,15 +1387,15 @@ discard block |
||
1387 | 1387 | |
1388 | 1388 | $optionPath = ''; |
1389 | 1389 | foreach (explode('.', $path) as $p) { |
1390 | - $optionPath = trim($optionPath . '.' . $p, '.'); |
|
1390 | + $optionPath = trim($optionPath.'.'.$p, '.'); |
|
1391 | 1391 | $options = array_merge( |
1392 | 1392 | $options, |
1393 | - $this->getArray($optionPath . '.' . self::OPTIONS, self::$SQL_PATH), |
|
1394 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options) |
|
1393 | + $this->getArray($optionPath.'.'.self::OPTIONS, self::$SQL_PATH), |
|
1394 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options) |
|
1395 | 1395 | ); |
1396 | 1396 | } |
1397 | 1397 | |
1398 | - return $base . '_' . $extension; |
|
1398 | + return $base.'_'.$extension; |
|
1399 | 1399 | } |
1400 | 1400 | |
1401 | 1401 | |
@@ -1415,7 +1415,7 @@ discard block |
||
1415 | 1415 | } else { |
1416 | 1416 | $k = $arr; |
1417 | 1417 | } |
1418 | - $path[$k] = $prefix . '_' . $k . '_'; |
|
1418 | + $path[$k] = $prefix.'_'.$k.'_'; |
|
1419 | 1419 | } |
1420 | 1420 | |
1421 | 1421 | return $path; |
@@ -221,8 +221,8 @@ discard block |
||
221 | 221 | $qb->filterDirectMembership(CoreQueryBuilder::MEMBER, $filter); |
222 | 222 | } |
223 | 223 | |
224 | - $qb->orderBy($qb->getDefaultSelectAlias() . '.level', 'desc'); |
|
225 | - $qb->addOrderBy($qb->getDefaultSelectAlias() . '.cached_name', 'asc'); |
|
224 | + $qb->orderBy($qb->getDefaultSelectAlias().'.level', 'desc'); |
|
225 | + $qb->addOrderBy($qb->getDefaultSelectAlias().'.cached_name', 'asc'); |
|
226 | 226 | |
227 | 227 | return $this->getItemsFromRequest($qb); |
228 | 228 | } |
@@ -246,8 +246,8 @@ discard block |
||
246 | 246 | $qb->limitToMembersByInheritance(CoreQueryBuilder::MEMBER, $singleId); |
247 | 247 | |
248 | 248 | $aliasMembership = $qb->generateAlias(CoreQueryBuilder::MEMBER, CoreQueryBuilder::MEMBERSHIPS); |
249 | - $qb->orderBy($aliasMembership . '.inheritance_depth', 'asc') |
|
250 | - ->addGroupBy($aliasMembership . '.inheritance_depth'); |
|
249 | + $qb->orderBy($aliasMembership.'.inheritance_depth', 'asc') |
|
250 | + ->addGroupBy($aliasMembership.'.inheritance_depth'); |
|
251 | 251 | |
252 | 252 | return $this->getItemsFromRequest($qb); |
253 | 253 | } |
@@ -283,7 +283,7 @@ discard block |
||
283 | 283 | $qb = $this->getMemberSelectSql(); |
284 | 284 | $qb->limitToCircleId($circleId); |
285 | 285 | |
286 | - $qb->andwhere($qb->expr()->nonEmptyString(CoreQueryBuilder::MEMBER . '.instance')); |
|
286 | + $qb->andwhere($qb->expr()->nonEmptyString(CoreQueryBuilder::MEMBER.'.instance')); |
|
287 | 287 | |
288 | 288 | return array_map( |
289 | 289 | function(Member $member): string { |
@@ -339,7 +339,7 @@ discard block |
||
339 | 339 | */ |
340 | 340 | public function searchFederatedUsers(string $needle): array { |
341 | 341 | $qb = $this->getMemberSelectSql(); |
342 | - $qb->searchInDBField('user_id', '%' . $needle . '%'); |
|
342 | + $qb->searchInDBField('user_id', '%'.$needle.'%'); |
|
343 | 343 | |
344 | 344 | return $this->getItemsFromRequest($qb, true); |
345 | 345 | } |