@@ -234,7 +234,7 @@ discard block |
||
234 | 234 | try { |
235 | 235 | $reflection = new ReflectionClass($class); |
236 | 236 | } catch (ReflectionException $e) { |
237 | - throw new InvalidItemException('reflection issue with ' . $class); |
|
237 | + throw new InvalidItemException('reflection issue with '.$class); |
|
238 | 238 | } |
239 | 239 | |
240 | 240 | if (!$reflection->implementsInterface(IDeserializable::class)) { |
@@ -354,7 +354,7 @@ discard block |
||
354 | 354 | * @return string |
355 | 355 | */ |
356 | 356 | private function getRef(string $key, string $ref): string { |
357 | - return $this->get($key . '.' . $ref, $this->ref); |
|
357 | + return $this->get($key.'.'.$ref, $this->ref); |
|
358 | 358 | } |
359 | 359 | |
360 | 360 | /** |
@@ -244,7 +244,7 @@ discard block |
||
244 | 244 | return $value; |
245 | 245 | } |
246 | 246 | |
247 | - if (($value = $this->config->getSystemValue(Application::APP_ID . '.' . $key, '')) !== '') { |
|
247 | + if (($value = $this->config->getSystemValue(Application::APP_ID.'.'.$key, '')) !== '') { |
|
248 | 248 | return $value; |
249 | 249 | } |
250 | 250 | |
@@ -478,7 +478,7 @@ discard block |
||
478 | 478 | */ |
479 | 479 | public function getTrustedDomains(): array { |
480 | 480 | return array_map( |
481 | - function (string $address) { |
|
481 | + function(string $address) { |
|
482 | 482 | return strtolower($address); |
483 | 483 | }, $this->config->getSystemValue('trusted_domains', []) |
484 | 484 | ); |
@@ -514,7 +514,7 @@ discard block |
||
514 | 514 | } |
515 | 515 | |
516 | 516 | if (array_key_exists('port', $loopback)) { |
517 | - $loopbackCloudId = $loopback['host'] . ':' . $loopback['port']; |
|
517 | + $loopbackCloudId = $loopback['host'].':'.$loopback['port']; |
|
518 | 518 | } else { |
519 | 519 | $loopbackCloudId = $loopback['host']; |
520 | 520 | } |
@@ -553,13 +553,13 @@ discard block |
||
553 | 553 | $path = $this->getAppValue(self::LOOPBACK_CLOUD_PATH); |
554 | 554 | } |
555 | 555 | |
556 | - $base = $scheme . '://' . $instance . $path; |
|
556 | + $base = $scheme.'://'.$instance.$path; |
|
557 | 557 | |
558 | 558 | if ($route === '') { |
559 | 559 | return $base; |
560 | 560 | } |
561 | 561 | |
562 | - return rtrim($base, '/') . $this->linkToRoute($route, $args); |
|
562 | + return rtrim($base, '/').$this->linkToRoute($route, $args); |
|
563 | 563 | } |
564 | 564 | |
565 | 565 | |
@@ -664,7 +664,7 @@ discard block |
||
664 | 664 | ): string { |
665 | 665 | $name = ($displayName) ? $federatedUser->getDisplayName() : $federatedUser->getUserId(); |
666 | 666 | if ($federatedUser->getUserType() === Member::TYPE_MAIL) { |
667 | - return $name . ' ' . $this->displayInstance( |
|
667 | + return $name.' '.$this->displayInstance( |
|
668 | 668 | $federatedUser->getInstance(), |
669 | 669 | self::DISPLAY_PARENTHESIS |
670 | 670 | ); |
@@ -674,7 +674,7 @@ discard block |
||
674 | 674 | return $name; |
675 | 675 | } |
676 | 676 | |
677 | - return $name . $this->displayInstance($federatedUser->getInstance(), self::DISPLAY_AT); |
|
677 | + return $name.$this->displayInstance($federatedUser->getInstance(), self::DISPLAY_AT); |
|
678 | 678 | } |
679 | 679 | |
680 | 680 | /** |
@@ -690,9 +690,9 @@ discard block |
||
690 | 690 | |
691 | 691 | switch ($type) { |
692 | 692 | case self::DISPLAY_AT: |
693 | - return '@' . $instance; |
|
693 | + return '@'.$instance; |
|
694 | 694 | case self::DISPLAY_PARENTHESIS: |
695 | - return '(' . $instance . ')'; |
|
695 | + return '('.$instance.')'; |
|
696 | 696 | } |
697 | 697 | |
698 | 698 | return $instance; |
@@ -257,7 +257,7 @@ discard block |
||
257 | 257 | public function getInstance(): string { |
258 | 258 | $instance = $this->getHost(); |
259 | 259 | if ($this->getPort() > 0) { |
260 | - $instance .= ':' . $this->getPort(); |
|
260 | + $instance .= ':'.$this->getPort(); |
|
261 | 261 | } |
262 | 262 | |
263 | 263 | return $instance; |
@@ -281,7 +281,7 @@ discard block |
||
281 | 281 | if ($protocol === null) { |
282 | 282 | if (strpos($url, '/') > -1) { |
283 | 283 | [$address, $baseUrl] = explode('/', $url, 2); |
284 | - $this->setBaseUrl('/' . $baseUrl); |
|
284 | + $this->setBaseUrl('/'.$baseUrl); |
|
285 | 285 | } else { |
286 | 286 | $address = $url; |
287 | 287 | } |
@@ -391,7 +391,7 @@ discard block |
||
391 | 391 | continue; |
392 | 392 | } |
393 | 393 | |
394 | - $url = str_replace(':' . $k, $this->data[$k], $url); |
|
394 | + $url = str_replace(':'.$k, $this->data[$k], $url); |
|
395 | 395 | } |
396 | 396 | |
397 | 397 | return $url; |
@@ -408,7 +408,7 @@ discard block |
||
408 | 408 | continue; |
409 | 409 | } |
410 | 410 | |
411 | - $url = str_replace(':' . $k, $this->params[$k], $url); |
|
411 | + $url = str_replace(':'.$k, $this->params[$k], $url); |
|
412 | 412 | } |
413 | 413 | |
414 | 414 | return $url; |
@@ -419,7 +419,7 @@ discard block |
||
419 | 419 | * @return string |
420 | 420 | */ |
421 | 421 | public function getPath(): string { |
422 | - return $this->baseUrl . $this->url; |
|
422 | + return $this->baseUrl.$this->url; |
|
423 | 423 | } |
424 | 424 | |
425 | 425 | |
@@ -436,9 +436,9 @@ discard block |
||
436 | 436 | * @return string |
437 | 437 | */ |
438 | 438 | public function getCompleteUrl(): string { |
439 | - $port = ($this->getPort() > 0) ? ':' . $this->getPort() : ''; |
|
439 | + $port = ($this->getPort() > 0) ? ':'.$this->getPort() : ''; |
|
440 | 440 | |
441 | - return $this->getUsedProtocol() . '://' . $this->getHost() . $port . $this->getParametersUrl(); |
|
441 | + return $this->getUsedProtocol().'://'.$this->getHost().$port.$this->getParametersUrl(); |
|
442 | 442 | } |
443 | 443 | |
444 | 444 | |
@@ -453,7 +453,7 @@ discard block |
||
453 | 453 | public function addHeader($key, $value): Request { |
454 | 454 | $header = $this->get($key, $this->headers); |
455 | 455 | if ($header !== '') { |
456 | - $header .= ', ' . $value; |
|
456 | + $header .= ', '.$value; |
|
457 | 457 | } else { |
458 | 458 | $header = $value; |
459 | 459 | } |
@@ -683,11 +683,11 @@ discard block |
||
683 | 683 | |
684 | 684 | switch ($this->getQueryStringType()) { |
685 | 685 | case self::QS_VAR_ARRAY: |
686 | - return '?' . http_build_query($this->getParams()); |
|
686 | + return '?'.http_build_query($this->getParams()); |
|
687 | 687 | |
688 | 688 | case self::QS_VAR_DUPLICATE: |
689 | 689 | default: |
690 | - return '?' . preg_replace( |
|
690 | + return '?'.preg_replace( |
|
691 | 691 | '/%5B(?:[0-9]|[1-9][0-9]+)%5D=/', '=', http_build_query($this->getParams()) |
692 | 692 | ); |
693 | 693 | } |
@@ -91,7 +91,7 @@ |
||
91 | 91 | RequestResultNotJsonException $e |
92 | 92 | ) { |
93 | 93 | $this->miscService->log( |
94 | - 'Issue while search users from lookup: ' . get_class($e) . ' ' . $e->getMessage() |
|
94 | + 'Issue while search users from lookup: '.get_class($e).' '.$e->getMessage() |
|
95 | 95 | ); |
96 | 96 | |
97 | 97 | return []; |
@@ -313,10 +313,10 @@ |
||
313 | 313 | protected function generateMember(FederatedEvent $event, Circle $circle, Member $member): Member { |
314 | 314 | try { |
315 | 315 | if ($member->getSingleId() !== '') { |
316 | - $userId = $member->getSingleId() . '@' . $member->getInstance(); |
|
316 | + $userId = $member->getSingleId().'@'.$member->getInstance(); |
|
317 | 317 | $federatedUser = $this->federatedUserService->getFederatedUser($userId, Member::TYPE_SINGLE); |
318 | 318 | } else { |
319 | - $userId = $member->getUserId() . '@' . $member->getInstance(); |
|
319 | + $userId = $member->getUserId().'@'.$member->getInstance(); |
|
320 | 320 | $federatedUser = $this->federatedUserService->getFederatedUser( |
321 | 321 | $userId, |
322 | 322 | $member->getUserType() |
@@ -245,7 +245,7 @@ discard block |
||
245 | 245 | } |
246 | 246 | |
247 | 247 | $expr = $qb->expr(); |
248 | - $pf = '' . $this->default_select_alias . '.'; |
|
248 | + $pf = ''.$this->default_select_alias.'.'; |
|
249 | 249 | |
250 | 250 | /** @noinspection PhpMethodParametersCountMismatchInspection */ |
251 | 251 | $qb->selectAlias('u.user_id', 'viewer_userid') |
@@ -259,7 +259,7 @@ discard block |
||
259 | 259 | ->leftJoin( |
260 | 260 | $this->default_select_alias, DeprecatedRequestBuilder::TABLE_MEMBERS, 'u', |
261 | 261 | $expr->andX( |
262 | - $expr->eq('u.circle_id', $pf . 'unique_id'), |
|
262 | + $expr->eq('u.circle_id', $pf.'unique_id'), |
|
263 | 263 | $expr->eq('u.user_id', $qb->createNamedParameter($userId)), |
264 | 264 | $expr->eq('u.instance', $qb->createNamedParameter($instanceId)), |
265 | 265 | $expr->eq('u.user_type', $qb->createNamedParameter($type)) |
@@ -280,7 +280,7 @@ discard block |
||
280 | 280 | } |
281 | 281 | |
282 | 282 | $expr = $qb->expr(); |
283 | - $pf = $this->default_select_alias . '.'; |
|
283 | + $pf = $this->default_select_alias.'.'; |
|
284 | 284 | |
285 | 285 | /** @noinspection PhpMethodParametersCountMismatchInspection */ |
286 | 286 | $qb->selectAlias('o.user_id', 'owner_userid') |
@@ -293,7 +293,7 @@ discard block |
||
293 | 293 | ->leftJoin( |
294 | 294 | $this->default_select_alias, DeprecatedRequestBuilder::TABLE_MEMBERS, 'o', |
295 | 295 | $expr->andX( |
296 | - $expr->eq('o.circle_id', $pf . 'unique_id'), |
|
296 | + $expr->eq('o.circle_id', $pf.'unique_id'), |
|
297 | 297 | $expr->eq('o.level', $qb->createNamedParameter(DeprecatedMember::LEVEL_OWNER)), |
298 | 298 | $expr->eq('o.user_type', $qb->createNamedParameter(DeprecatedMember::TYPE_USER)) |
299 | 299 | ) |
@@ -398,8 +398,8 @@ discard block |
||
398 | 398 | foreach (explode(' ', $circle->getDisplayName()) as $word) { |
399 | 399 | $andX->add( |
400 | 400 | $expr->iLike( |
401 | - $this->getDefaultSelectAlias() . '.' . 'display_name', |
|
402 | - $this->createNamedParameter('%' . $word . '%') |
|
401 | + $this->getDefaultSelectAlias().'.'.'display_name', |
|
402 | + $this->createNamedParameter('%'.$word.'%') |
|
403 | 403 | ) |
404 | 404 | ); |
405 | 405 | } |
@@ -410,8 +410,8 @@ discard block |
||
410 | 410 | foreach (explode(' ', $circle->getDescription()) as $word) { |
411 | 411 | $orDescription->add( |
412 | 412 | $expr->iLike( |
413 | - $this->getDefaultSelectAlias() . '.' . 'description', |
|
414 | - $this->createNamedParameter('%' . $word . '%') |
|
413 | + $this->getDefaultSelectAlias().'.'.'description', |
|
414 | + $this->createNamedParameter('%'.$word.'%') |
|
415 | 415 | ) |
416 | 416 | ); |
417 | 417 | } |
@@ -441,7 +441,7 @@ discard block |
||
441 | 441 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance) |
442 | 442 | ->leftJoin( |
443 | 443 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance, |
444 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance') |
|
444 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance') |
|
445 | 445 | ); |
446 | 446 | } catch (RequestBuilderException $e) { |
447 | 447 | } |
@@ -493,7 +493,7 @@ discard block |
||
493 | 493 | $expr = $this->expr(); |
494 | 494 | $this->leftJoin( |
495 | 495 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote, |
496 | - $expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
496 | + $expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
497 | 497 | ); |
498 | 498 | } |
499 | 499 | |
@@ -521,12 +521,12 @@ discard block |
||
521 | 521 | $this->leftJoin( |
522 | 522 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember, |
523 | 523 | $expr->andX( |
524 | - $expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'), |
|
524 | + $expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'), |
|
525 | 525 | $expr->eq( |
526 | - $aliasRemoteMember . '.instance', |
|
526 | + $aliasRemoteMember.'.instance', |
|
527 | 527 | $this->createNamedParameter($remoteInstance->getInstance()) |
528 | 528 | ), |
529 | - $expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
529 | + $expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
530 | 530 | ) |
531 | 531 | ); |
532 | 532 | } |
@@ -558,21 +558,21 @@ discard block |
||
558 | 558 | $this->leftJoin( |
559 | 559 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle, |
560 | 560 | $expr->andX( |
561 | - $expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'), |
|
562 | - $expr->emptyString($aliasRemoteCircle . '.instance'), |
|
563 | - $expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
561 | + $expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'), |
|
562 | + $expr->emptyString($aliasRemoteCircle.'.instance'), |
|
563 | + $expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
564 | 564 | ) |
565 | 565 | ); |
566 | 566 | $this->leftJoin( |
567 | 567 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner, |
568 | 568 | $expr->andX( |
569 | - $expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'), |
|
569 | + $expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'), |
|
570 | 570 | $expr->eq( |
571 | - $aliasRemoteCircleOwner . '.instance', |
|
571 | + $aliasRemoteCircleOwner.'.instance', |
|
572 | 572 | $this->createNamedParameter($remoteInstance->getInstance()) |
573 | 573 | ), |
574 | 574 | $expr->eq( |
575 | - $aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
575 | + $aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
576 | 576 | ) |
577 | 577 | ) |
578 | 578 | ); |
@@ -605,16 +605,16 @@ discard block |
||
605 | 605 | $expr = $this->expr(); |
606 | 606 | $orX = $expr->orX(); |
607 | 607 | $orX->add( |
608 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
608 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
609 | 609 | ); |
610 | 610 | |
611 | 611 | $orExtOrPassive = $expr->orX(); |
612 | 612 | $orExtOrPassive->add( |
613 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
613 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
614 | 614 | ); |
615 | 615 | if (!$sensitive) { |
616 | 616 | $orExtOrPassive->add( |
617 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
617 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
618 | 618 | ); |
619 | 619 | } else { |
620 | 620 | if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) { |
@@ -623,8 +623,8 @@ discard block |
||
623 | 623 | } |
624 | 624 | |
625 | 625 | $orInstance = $expr->orX(); |
626 | - $orInstance->add($expr->isNotNull($aliasRemoteMember . '.instance')); |
|
627 | - $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner . '.instance')); |
|
626 | + $orInstance->add($expr->isNotNull($aliasRemoteMember.'.instance')); |
|
627 | + $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner.'.instance')); |
|
628 | 628 | |
629 | 629 | $andExternal = $expr->andX(); |
630 | 630 | $andExternal->add($orExtOrPassive); |
@@ -633,13 +633,13 @@ discard block |
||
633 | 633 | $orExtOrTrusted = $expr->orX(); |
634 | 634 | $orExtOrTrusted->add($andExternal); |
635 | 635 | $orExtOrTrusted->add( |
636 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
636 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
637 | 637 | ); |
638 | 638 | |
639 | 639 | $andTrusted = $expr->andX(); |
640 | 640 | $andTrusted->add($orExtOrTrusted); |
641 | 641 | $andTrusted->add($this->exprLimitBitwise('config', Circle::CFG_FEDERATED, $aliasCircle)); |
642 | - $andTrusted->add($expr->emptyString($aliasOwner . '.instance')); |
|
642 | + $andTrusted->add($expr->emptyString($aliasOwner.'.instance')); |
|
643 | 643 | $orX->add($andTrusted); |
644 | 644 | |
645 | 645 | $this->andWhere($orX); |
@@ -666,7 +666,7 @@ discard block |
||
666 | 666 | } |
667 | 667 | $this->innerJoin( |
668 | 668 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
669 | - $expr->eq($aliasMember . '.circle_id', $alias . '.unique_id') |
|
669 | + $expr->eq($aliasMember.'.circle_id', $alias.'.unique_id') |
|
670 | 670 | ); |
671 | 671 | |
672 | 672 | $this->filterDirectMembership($aliasMember, $member); |
@@ -691,12 +691,12 @@ discard block |
||
691 | 691 | $aliasCircle, |
692 | 692 | 'circles_membership', |
693 | 693 | $aliasMembership, |
694 | - $this->expr()->eq($aliasCircle . '.unique_id', $aliasMembership . '.circle_id') |
|
694 | + $this->expr()->eq($aliasCircle.'.unique_id', $aliasMembership.'.circle_id') |
|
695 | 695 | ); |
696 | 696 | |
697 | 697 | $this->andWhere( |
698 | 698 | $this->expr()->eq( |
699 | - $aliasMembership . '.single_id', |
|
699 | + $aliasMembership.'.single_id', |
|
700 | 700 | $this->createNamedParameter($federatedUser->getSingleId()) |
701 | 701 | ) |
702 | 702 | ); |
@@ -717,19 +717,19 @@ discard block |
||
717 | 717 | |
718 | 718 | if ($member->getUserId() !== '') { |
719 | 719 | $andX->add( |
720 | - $expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId())) |
|
720 | + $expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId())) |
|
721 | 721 | ); |
722 | 722 | } |
723 | 723 | |
724 | 724 | if ($member->getSingleId() !== '') { |
725 | 725 | $andX->add( |
726 | - $expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId())) |
|
726 | + $expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId())) |
|
727 | 727 | ); |
728 | 728 | } |
729 | 729 | |
730 | 730 | if ($member->getUserType() > 0) { |
731 | 731 | $andX->add( |
732 | - $expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType())) |
|
732 | + $expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType())) |
|
733 | 733 | ); |
734 | 734 | } |
735 | 735 | |
@@ -738,7 +738,7 @@ discard block |
||
738 | 738 | if ($member->getLevel() > 0) { |
739 | 739 | $andX->add( |
740 | 740 | $expr->gte( |
741 | - $aliasMember . '.level', |
|
741 | + $aliasMember.'.level', |
|
742 | 742 | $this->createNamedParameter($member->getLevel(), IQueryBuilder::PARAM_INT) |
743 | 743 | ) |
744 | 744 | ); |
@@ -779,7 +779,7 @@ discard block |
||
779 | 779 | $helperAlias, |
780 | 780 | CoreRequestBuilder::TABLE_CIRCLE, |
781 | 781 | $aliasCircle, |
782 | - $expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field) |
|
782 | + $expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field) |
|
783 | 783 | ); |
784 | 784 | |
785 | 785 | if (!is_null($initiator)) { |
@@ -810,7 +810,7 @@ discard block |
||
810 | 810 | $this->generateCircleSelectAlias($aliasInvitedBy) |
811 | 811 | ->leftJoin( |
812 | 812 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasInvitedBy, |
813 | - $expr->eq($aliasMember . '.invited_by', $aliasInvitedBy . '.unique_id') |
|
813 | + $expr->eq($aliasMember.'.invited_by', $aliasInvitedBy.'.unique_id') |
|
814 | 814 | ); |
815 | 815 | |
816 | 816 | $this->leftJoinOwner($aliasInvitedBy); |
@@ -841,7 +841,7 @@ discard block |
||
841 | 841 | $this->generateCircleSelectAlias($aliasBasedOn) |
842 | 842 | ->leftJoin( |
843 | 843 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn, |
844 | - $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id') |
|
844 | + $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id') |
|
845 | 845 | ); |
846 | 846 | |
847 | 847 | if (!is_null($initiator)) { |
@@ -874,9 +874,9 @@ discard block |
||
874 | 874 | ->leftJoin( |
875 | 875 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
876 | 876 | $expr->andX( |
877 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field), |
|
877 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field), |
|
878 | 878 | $expr->eq( |
879 | - $aliasMember . '.level', |
|
879 | + $aliasMember.'.level', |
|
880 | 880 | $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT) |
881 | 881 | ) |
882 | 882 | ) |
@@ -914,10 +914,10 @@ discard block |
||
914 | 914 | ->leftJoin( |
915 | 915 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
916 | 916 | $expr->andX( |
917 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId), |
|
918 | - $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId), |
|
917 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId), |
|
918 | + $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId), |
|
919 | 919 | $expr->gte( |
920 | - $aliasMember . '.level', |
|
920 | + $aliasMember.'.level', |
|
921 | 921 | $this->createNamedParameter(Member::LEVEL_MEMBER, self::PARAM_INT) |
922 | 922 | ) |
923 | 923 | ) |
@@ -950,7 +950,7 @@ discard block |
||
950 | 950 | |
951 | 951 | $this->leftJoin( |
952 | 952 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
953 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field) |
|
953 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field) |
|
954 | 954 | ); |
955 | 955 | |
956 | 956 | // if (!$this->getBool('getData', $options, false)) { |
@@ -964,8 +964,8 @@ discard block |
||
964 | 964 | ->leftJoin( |
965 | 965 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
966 | 966 | $expr->andX( |
967 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'), |
|
968 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id') |
|
967 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'), |
|
968 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id') |
|
969 | 969 | ) |
970 | 970 | ); |
971 | 971 | |
@@ -982,12 +982,12 @@ discard block |
||
982 | 982 | $aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options); |
983 | 983 | $this->leftJoin( |
984 | 984 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership, |
985 | - $expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId)) |
|
985 | + $expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId)) |
|
986 | 986 | ); |
987 | 987 | |
988 | 988 | $orX = $expr->orX( |
989 | - $expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field), |
|
990 | - $expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId)) |
|
989 | + $expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field), |
|
990 | + $expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId)) |
|
991 | 991 | ); |
992 | 992 | |
993 | 993 | $this->andWhere($orX); |
@@ -1008,11 +1008,11 @@ discard block |
||
1008 | 1008 | |
1009 | 1009 | $expr = $this->expr(); |
1010 | 1010 | $aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS); |
1011 | - $this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId))); |
|
1011 | + $this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId))); |
|
1012 | 1012 | if ($level > 1) { |
1013 | 1013 | $this->andWhere( |
1014 | 1014 | $expr->gte( |
1015 | - $aliasMembership . '.level', |
|
1015 | + $aliasMembership.'.level', |
|
1016 | 1016 | $this->createNamedParameter($level, IQueryBuilder::PARAM_INT) |
1017 | 1017 | ) |
1018 | 1018 | ); |
@@ -1040,8 +1040,8 @@ discard block |
||
1040 | 1040 | $this->leftJoin( |
1041 | 1041 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
1042 | 1042 | $expr->andX( |
1043 | - $expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field), |
|
1044 | - $expr->eq($aliasMembership . '.single_id', $alias . '.single_id') |
|
1043 | + $expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field), |
|
1044 | + $expr->eq($aliasMembership.'.single_id', $alias.'.single_id') |
|
1045 | 1045 | ) |
1046 | 1046 | ); |
1047 | 1047 | |
@@ -1054,8 +1054,8 @@ discard block |
||
1054 | 1054 | ->leftJoin( |
1055 | 1055 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom, |
1056 | 1056 | $expr->andX( |
1057 | - $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'), |
|
1058 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id') |
|
1057 | + $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'), |
|
1058 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id') |
|
1059 | 1059 | ) |
1060 | 1060 | ); |
1061 | 1061 | } |
@@ -1095,7 +1095,7 @@ discard block |
||
1095 | 1095 | |
1096 | 1096 | $this->leftJoin( |
1097 | 1097 | $alias, CoreRequestBuilder::TABLE_TOKEN, $aliasShareToken, |
1098 | - $expr->eq($aliasShareToken . '.share_id', $alias . '.' . $field) |
|
1098 | + $expr->eq($aliasShareToken.'.share_id', $alias.'.'.$field) |
|
1099 | 1099 | ); |
1100 | 1100 | } |
1101 | 1101 | |
@@ -1137,14 +1137,14 @@ discard block |
||
1137 | 1137 | try { |
1138 | 1138 | $aliasConfig = $this->generateAlias($alias, self::CONFIG, $options); |
1139 | 1139 | $this->selectAlias( |
1140 | - $aliasConfig . '.config', |
|
1141 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'circle_config' |
|
1140 | + $aliasConfig.'.config', |
|
1141 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'circle_config' |
|
1142 | 1142 | ); |
1143 | 1143 | $this->leftJoin( |
1144 | 1144 | $alias, |
1145 | 1145 | CoreRequestBuilder::TABLE_CIRCLE, |
1146 | 1146 | $aliasConfig, |
1147 | - $expr->eq($alias . '.circle_id', $aliasConfig . '.unique_id') |
|
1147 | + $expr->eq($alias.'.circle_id', $aliasConfig.'.unique_id') |
|
1148 | 1148 | ); |
1149 | 1149 | } catch (RequestBuilderException $e) { |
1150 | 1150 | } |
@@ -1182,7 +1182,7 @@ discard block |
||
1182 | 1182 | $aliasMembership, |
1183 | 1183 | $expr->andX( |
1184 | 1184 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), |
1185 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field) |
|
1185 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field) |
|
1186 | 1186 | ) |
1187 | 1187 | ); |
1188 | 1188 | |
@@ -1201,11 +1201,11 @@ discard block |
||
1201 | 1201 | $aliasMembershipCircle = $this->generateAlias($aliasMembership, self::CONFIG, $options); |
1202 | 1202 | $orXMembershipCircle = $expr->orX(); |
1203 | 1203 | array_map( |
1204 | - function (string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { |
|
1204 | + function(string $alias) use ($orXMembershipCircle, $aliasMembershipCircle) { |
|
1205 | 1205 | $orXMembershipCircle->add( |
1206 | 1206 | $this->expr()->eq( |
1207 | - $alias . '.circle_id', |
|
1208 | - $aliasMembershipCircle . '.unique_id' |
|
1207 | + $alias.'.circle_id', |
|
1208 | + $aliasMembershipCircle.'.unique_id' |
|
1209 | 1209 | ) |
1210 | 1210 | ); |
1211 | 1211 | }, |
@@ -1237,7 +1237,7 @@ discard block |
||
1237 | 1237 | $aliasDirectInitiator, |
1238 | 1238 | $expr->andX( |
1239 | 1239 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasDirectInitiator), |
1240 | - $expr->eq($aliasDirectInitiator . '.circle_id', $helperAlias . '.' . $field) |
|
1240 | + $expr->eq($aliasDirectInitiator.'.circle_id', $helperAlias.'.'.$field) |
|
1241 | 1241 | ) |
1242 | 1242 | ); |
1243 | 1243 | } catch (RequestBuilderException $e) { |
@@ -1251,8 +1251,8 @@ discard block |
||
1251 | 1251 | $this->leftJoin( |
1252 | 1252 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator, |
1253 | 1253 | $expr->andX( |
1254 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'), |
|
1255 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id') |
|
1254 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'), |
|
1255 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id') |
|
1256 | 1256 | ) |
1257 | 1257 | ); |
1258 | 1258 | |
@@ -1260,8 +1260,8 @@ discard block |
||
1260 | 1260 | $this->leftJoin( |
1261 | 1261 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
1262 | 1262 | $expr->andX( |
1263 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'), |
|
1264 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id') |
|
1263 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'), |
|
1264 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id') |
|
1265 | 1265 | ) |
1266 | 1266 | ); |
1267 | 1267 | |
@@ -1312,7 +1312,7 @@ discard block |
||
1312 | 1312 | $orX->add( |
1313 | 1313 | $expr->andX( |
1314 | 1314 | $this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $aliasMembershipCircle), |
1315 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
1315 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
1316 | 1316 | ) |
1317 | 1317 | ); |
1318 | 1318 | } |
@@ -1322,10 +1322,10 @@ discard block |
||
1322 | 1322 | $orXLevelCheck = $expr->orX(); |
1323 | 1323 | |
1324 | 1324 | array_map( |
1325 | - function (string $alias) use ($orXLevelCheck, $minimumLevel) { |
|
1325 | + function(string $alias) use ($orXLevelCheck, $minimumLevel) { |
|
1326 | 1326 | $orXLevelCheck->add( |
1327 | 1327 | $this->expr()->gte( |
1328 | - $alias . '.level', |
|
1328 | + $alias.'.level', |
|
1329 | 1329 | $this->createNamedParameter($minimumLevel) |
1330 | 1330 | ) |
1331 | 1331 | ); |
@@ -1415,21 +1415,21 @@ discard block |
||
1415 | 1415 | $expr = $this->expr(); |
1416 | 1416 | $andPassive = $expr->andX(); |
1417 | 1417 | $andPassive->add( |
1418 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
1418 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
1419 | 1419 | ); |
1420 | 1420 | |
1421 | 1421 | $orMemberOrLevel = $expr->orX(); |
1422 | 1422 | $orMemberOrLevel->add( |
1423 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance') |
|
1423 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance') |
|
1424 | 1424 | ); |
1425 | 1425 | // TODO: do we need this ? (display members from the local instance) |
1426 | 1426 | $orMemberOrLevel->add( |
1427 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance') |
|
1427 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance') |
|
1428 | 1428 | ); |
1429 | 1429 | |
1430 | 1430 | $orMemberOrLevel->add( |
1431 | 1431 | $expr->eq( |
1432 | - $this->getDefaultSelectAlias() . '.level', |
|
1432 | + $this->getDefaultSelectAlias().'.level', |
|
1433 | 1433 | $this->createNamedParameter(Member::LEVEL_OWNER) |
1434 | 1434 | ) |
1435 | 1435 | ); |
@@ -1466,11 +1466,11 @@ discard block |
||
1466 | 1466 | ) |
1467 | 1467 | ->leftJoin( |
1468 | 1468 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache, |
1469 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid') |
|
1469 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid') |
|
1470 | 1470 | ) |
1471 | 1471 | ->leftJoin( |
1472 | 1472 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages, |
1473 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id') |
|
1473 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id') |
|
1474 | 1474 | ); |
1475 | 1475 | } |
1476 | 1476 | |
@@ -1492,8 +1492,8 @@ discard block |
||
1492 | 1492 | $this->leftJoin( |
1493 | 1493 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild, |
1494 | 1494 | $expr->andX( |
1495 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'), |
|
1496 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id') |
|
1495 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'), |
|
1496 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id') |
|
1497 | 1497 | ) |
1498 | 1498 | ); |
1499 | 1499 | |
@@ -1543,13 +1543,13 @@ discard block |
||
1543 | 1543 | $this->leftJoin( |
1544 | 1544 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint, |
1545 | 1545 | $expr->andX( |
1546 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'), |
|
1547 | - $expr->eq($aliasMountpoint . '.single_id', $aliasMountMemberships . '.single_id') |
|
1546 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'), |
|
1547 | + $expr->eq($aliasMountpoint.'.single_id', $aliasMountMemberships.'.single_id') |
|
1548 | 1548 | ) |
1549 | 1549 | ); |
1550 | 1550 | |
1551 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint'); |
|
1552 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash'); |
|
1551 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint'); |
|
1552 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash'); |
|
1553 | 1553 | } |
1554 | 1554 | |
1555 | 1555 | |
@@ -1657,10 +1657,10 @@ discard block |
||
1657 | 1657 | */ |
1658 | 1658 | public function generateAlias(string $base, string $extension, ?array &$options = []): string { |
1659 | 1659 | $search = str_replace('_', '.', $base); |
1660 | - $path = $search . '.' . $extension; |
|
1660 | + $path = $search.'.'.$extension; |
|
1661 | 1661 | if (!$this->validKey($path, self::$SQL_PATH) |
1662 | 1662 | && !in_array($extension, $this->getArray($search, self::$SQL_PATH))) { |
1663 | - throw new RequestBuilderException($extension . ' not found in ' . $search); |
|
1663 | + throw new RequestBuilderException($extension.' not found in '.$search); |
|
1664 | 1664 | } |
1665 | 1665 | |
1666 | 1666 | if (!is_array($options)) { |
@@ -1669,15 +1669,15 @@ discard block |
||
1669 | 1669 | |
1670 | 1670 | $optionPath = ''; |
1671 | 1671 | foreach (explode('.', $path) as $p) { |
1672 | - $optionPath = trim($optionPath . '.' . $p, '.'); |
|
1672 | + $optionPath = trim($optionPath.'.'.$p, '.'); |
|
1673 | 1673 | $options = array_merge( |
1674 | 1674 | $options, |
1675 | - $this->getArray($optionPath . '.' . self::OPTIONS, self::$SQL_PATH), |
|
1676 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options) |
|
1675 | + $this->getArray($optionPath.'.'.self::OPTIONS, self::$SQL_PATH), |
|
1676 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options) |
|
1677 | 1677 | ); |
1678 | 1678 | } |
1679 | 1679 | |
1680 | - return $base . '_' . $extension; |
|
1680 | + return $base.'_'.$extension; |
|
1681 | 1681 | } |
1682 | 1682 | |
1683 | 1683 | |
@@ -1697,7 +1697,7 @@ discard block |
||
1697 | 1697 | } else { |
1698 | 1698 | $k = $arr; |
1699 | 1699 | } |
1700 | - $path[$k] = $prefix . '_' . $k . '_'; |
|
1700 | + $path[$k] = $prefix.'_'.$k.'_'; |
|
1701 | 1701 | } |
1702 | 1702 | |
1703 | 1703 | return $path; |
@@ -346,8 +346,8 @@ discard block |
||
346 | 346 | $expr = $qb->expr(); |
347 | 347 | |
348 | 348 | if ($pf === '') { |
349 | - $p = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : ''; |
|
350 | - $qb->andWhere($expr->gte($p . 'level', $qb->createNamedParameter($level))); |
|
349 | + $p = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : ''; |
|
350 | + $qb->andWhere($expr->gte($p.'level', $qb->createNamedParameter($level))); |
|
351 | 351 | |
352 | 352 | return; |
353 | 353 | } |
@@ -376,7 +376,7 @@ discard block |
||
376 | 376 | if ($p === 'g' && !$this->leftJoinedNCGroupAndUser) { |
377 | 377 | continue; |
378 | 378 | } |
379 | - $orX->add($expr->gte($p . '.level', $qb->createNamedParameter($level))); |
|
379 | + $orX->add($expr->gte($p.'.level', $qb->createNamedParameter($level))); |
|
380 | 380 | } |
381 | 381 | |
382 | 382 | return $orX; |
@@ -391,12 +391,12 @@ discard block |
||
391 | 391 | protected function limitToMembersAndAlmost(IQueryBuilder $qb) { |
392 | 392 | $expr = $qb->expr(); |
393 | 393 | |
394 | - $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : ''; |
|
394 | + $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : ''; |
|
395 | 395 | |
396 | 396 | $orX = $expr->orX(); |
397 | - $orX->add($expr->eq($pf . 'status', $qb->createNamedParameter(DeprecatedMember::STATUS_MEMBER))); |
|
398 | - $orX->add($expr->eq($pf . 'status', $qb->createNamedParameter(DeprecatedMember::STATUS_INVITED))); |
|
399 | - $orX->add($expr->eq($pf . 'status', $qb->createNamedParameter(DeprecatedMember::STATUS_REQUEST))); |
|
397 | + $orX->add($expr->eq($pf.'status', $qb->createNamedParameter(DeprecatedMember::STATUS_MEMBER))); |
|
398 | + $orX->add($expr->eq($pf.'status', $qb->createNamedParameter(DeprecatedMember::STATUS_INVITED))); |
|
399 | + $orX->add($expr->eq($pf.'status', $qb->createNamedParameter(DeprecatedMember::STATUS_REQUEST))); |
|
400 | 400 | |
401 | 401 | $qb->andWhere($orX); |
402 | 402 | } |
@@ -409,8 +409,8 @@ discard block |
||
409 | 409 | */ |
410 | 410 | public function limitToDBField(IQueryBuilder $qb, $field, $value) { |
411 | 411 | $expr = $qb->expr(); |
412 | - $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : ''; |
|
413 | - $qb->andWhere($expr->eq($pf . $field, $qb->createNamedParameter($value))); |
|
412 | + $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : ''; |
|
413 | + $qb->andWhere($expr->eq($pf.$field, $qb->createNamedParameter($value))); |
|
414 | 414 | } |
415 | 415 | |
416 | 416 | |
@@ -421,8 +421,8 @@ discard block |
||
421 | 421 | */ |
422 | 422 | private function limitToDBFieldOrGreater(IQueryBuilder $qb, $field, $value) { |
423 | 423 | $expr = $qb->expr(); |
424 | - $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : ''; |
|
425 | - $qb->andWhere($expr->gte($pf . $field, $qb->createNamedParameter($value))); |
|
424 | + $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : ''; |
|
425 | + $qb->andWhere($expr->gte($pf.$field, $qb->createNamedParameter($value))); |
|
426 | 426 | } |
427 | 427 | |
428 | 428 | |
@@ -437,9 +437,9 @@ discard block |
||
437 | 437 | protected function limitToNCGroupUser(IQueryBuilder $qb, $userId = '') { |
438 | 438 | $expr = $qb->expr(); |
439 | 439 | |
440 | - $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias . '.' : ''; |
|
440 | + $pf = ($qb->getType() === QueryBuilder::SELECT) ? $this->default_select_alias.'.' : ''; |
|
441 | 441 | |
442 | - $and = $expr->andX($expr->eq($pf . 'user_id', 'ncgu.gid')); |
|
442 | + $and = $expr->andX($expr->eq($pf.'user_id', 'ncgu.gid')); |
|
443 | 443 | if ($userId !== '') { |
444 | 444 | $and->add($expr->eq('ncgu.uid', $qb->createNamedParameter($userId))); |
445 | 445 | } else { |
@@ -462,7 +462,7 @@ discard block |
||
462 | 462 | } |
463 | 463 | |
464 | 464 | $expr = $qb->expr(); |
465 | - $pf = $this->default_select_alias . '.'; |
|
465 | + $pf = $this->default_select_alias.'.'; |
|
466 | 466 | |
467 | 467 | /** @noinspection PhpMethodParametersCountMismatchInspection */ |
468 | 468 | $qb->selectAlias('lc.type', 'circle_type') |
@@ -471,7 +471,7 @@ discard block |
||
471 | 471 | ->selectAlias('lc.settings', 'circle_settings') |
472 | 472 | ->leftJoin( |
473 | 473 | $this->default_select_alias, DeprecatedRequestBuilder::TABLE_CIRCLES, 'lc', |
474 | - $expr->eq($pf . 'circle_id', 'lc.unique_id') |
|
474 | + $expr->eq($pf.'circle_id', 'lc.unique_id') |
|
475 | 475 | ); |
476 | 476 | } |
477 | 477 |
@@ -422,15 +422,15 @@ |
||
422 | 422 | * @throws FederatedUserNotFoundException |
423 | 423 | */ |
424 | 424 | public function importFromDatabase(array $data, string $prefix = ''): IQueryRow { |
425 | - if ($this->get($prefix . 'single_id', $data) === '') { |
|
425 | + if ($this->get($prefix.'single_id', $data) === '') { |
|
426 | 426 | throw new FederatedUserNotFoundException(); |
427 | 427 | } |
428 | 428 | |
429 | - $this->setSingleId($this->get($prefix . 'single_id', $data)); |
|
430 | - $this->setUserId($this->get($prefix . 'user_id', $data)); |
|
431 | - $this->setUserType($this->getInt($prefix . 'user_type', $data)); |
|
432 | - $this->setDisplayName($this->get($prefix . 'cached_name', $data)); |
|
433 | - $this->setInstance($this->get($prefix . 'instance', $data)); |
|
429 | + $this->setSingleId($this->get($prefix.'single_id', $data)); |
|
430 | + $this->setUserId($this->get($prefix.'user_id', $data)); |
|
431 | + $this->setUserType($this->getInt($prefix.'user_type', $data)); |
|
432 | + $this->setDisplayName($this->get($prefix.'cached_name', $data)); |
|
433 | + $this->setInstance($this->get($prefix.'instance', $data)); |
|
434 | 434 | |
435 | 435 | $this->getManager()->manageImportFromDatabase($this, $data, $prefix); |
436 | 436 |