@@ -50,11 +50,11 @@ discard block |
||
50 | 50 | |
51 | 51 | use TArrayTools; |
52 | 52 | |
53 | - const TYPE_UNKNOWN = 'Unknown'; // not trusted |
|
54 | - const TYPE_PASSIVE = 'Passive'; // Minimum information about Federated Circles are broadcasted if a member belongs to the circle. |
|
55 | - const TYPE_EXTERNAL = 'External'; // info about Federated Circles and their members are broadcasted if a member belongs to the circle. |
|
56 | - const TYPE_TRUSTED = 'Trusted'; // everything about Federated Circles are broadcasted. |
|
57 | - const TYPE_GLOBALSCALE = 'GlobalScale'; // every Circle is broadcasted, |
|
53 | + const TYPE_UNKNOWN = 'Unknown'; // not trusted |
|
54 | + const TYPE_PASSIVE = 'Passive'; // Minimum information about Federated Circles are broadcasted if a member belongs to the circle. |
|
55 | + const TYPE_EXTERNAL = 'External'; // info about Federated Circles and their members are broadcasted if a member belongs to the circle. |
|
56 | + const TYPE_TRUSTED = 'Trusted'; // everything about Federated Circles are broadcasted. |
|
57 | + const TYPE_GLOBALSCALE = 'GlobalScale'; // every Circle is broadcasted, |
|
58 | 58 | |
59 | 59 | public static $LIST_TYPE = [ |
60 | 60 | self::TYPE_UNKNOWN, |
@@ -454,7 +454,7 @@ discard block |
||
454 | 454 | ]; |
455 | 455 | |
456 | 456 | if ($this->getAuthSigned() !== '') { |
457 | - $data['auth-signed'] = $this->getAlgorithm() . ':' . $this->getAuthSigned(); |
|
457 | + $data['auth-signed'] = $this->getAlgorithm().':'.$this->getAuthSigned(); |
|
458 | 458 | } |
459 | 459 | |
460 | 460 | return array_filter(array_merge($data, parent::jsonSerialize())); |
@@ -469,17 +469,17 @@ discard block |
||
469 | 469 | * @throws RemoteNotFoundException |
470 | 470 | */ |
471 | 471 | public function importFromDatabase(array $data, string $prefix = ''): INC22QueryRow { |
472 | - if ($this->getInt($prefix . 'id', $data) === 0) { |
|
472 | + if ($this->getInt($prefix.'id', $data) === 0) { |
|
473 | 473 | throw new RemoteNotFoundException(); |
474 | 474 | } |
475 | 475 | |
476 | - $this->setDbId($this->getInt($prefix . 'id', $data)); |
|
477 | - $this->import($this->getArray($prefix . 'item', $data)); |
|
478 | - $this->setOrigData($this->getArray($prefix . 'item', $data)); |
|
479 | - $this->setType($this->get($prefix . 'type', $data)); |
|
480 | - $this->setInterface($this->getInt($prefix . 'interface', $data)); |
|
481 | - $this->setInstance($this->get($prefix . 'instance', $data)); |
|
482 | - $this->setId($this->get($prefix . 'href', $data)); |
|
476 | + $this->setDbId($this->getInt($prefix.'id', $data)); |
|
477 | + $this->import($this->getArray($prefix.'item', $data)); |
|
478 | + $this->setOrigData($this->getArray($prefix.'item', $data)); |
|
479 | + $this->setType($this->get($prefix.'type', $data)); |
|
480 | + $this->setInterface($this->getInt($prefix.'interface', $data)); |
|
481 | + $this->setInstance($this->get($prefix.'instance', $data)); |
|
482 | + $this->setId($this->get($prefix.'href', $data)); |
|
483 | 483 | |
484 | 484 | return $this; |
485 | 485 | } |
@@ -33,11 +33,9 @@ |
||
33 | 33 | |
34 | 34 | |
35 | 35 | use daita\MySmallPhpTools\Exceptions\SignatoryException; |
36 | -use daita\MySmallPhpTools\Exceptions\SignatureException; |
|
37 | 36 | use daita\MySmallPhpTools\Traits\TArrayTools; |
38 | 37 | use OC\URLGenerator; |
39 | 38 | use OCA\Circles\AppInfo\Application; |
40 | -use OCA\Circles\Exceptions\UnknownInterfaceException; |
|
41 | 39 | use OCA\Circles\Service\ConfigService; |
42 | 40 | use OCA\Circles\Service\InterfaceService; |
43 | 41 | use OCA\Circles\Service\RemoteStreamService; |
@@ -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 |
@@ -644,7 +644,7 @@ |
||
644 | 644 | * @param string $alias |
645 | 645 | * @param IFederatedUser|null $initiator |
646 | 646 | * @param string $field |
647 | - * @param string $helpedAlias |
|
647 | + * @param string $helperAlias |
|
648 | 648 | * |
649 | 649 | * @throws RequestBuilderException |
650 | 650 | */ |
@@ -361,7 +361,7 @@ discard block |
||
361 | 361 | } |
362 | 362 | |
363 | 363 | if ($circle->getDisplayName() !== '') { |
364 | - $this->searchInDBField('display_name', '%' . $circle->getDisplayName() . '%'); |
|
364 | + $this->searchInDBField('display_name', '%'.$circle->getDisplayName().'%'); |
|
365 | 365 | } |
366 | 366 | } |
367 | 367 | |
@@ -377,7 +377,7 @@ discard block |
||
377 | 377 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance) |
378 | 378 | ->leftJoin( |
379 | 379 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance, |
380 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance') |
|
380 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance') |
|
381 | 381 | ); |
382 | 382 | } catch (RequestBuilderException $e) { |
383 | 383 | } |
@@ -430,7 +430,7 @@ discard block |
||
430 | 430 | $expr = $this->expr(); |
431 | 431 | $this->leftJoin( |
432 | 432 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote, |
433 | - $expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
433 | + $expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
434 | 434 | ); |
435 | 435 | } |
436 | 436 | |
@@ -458,12 +458,12 @@ discard block |
||
458 | 458 | $this->leftJoin( |
459 | 459 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember, |
460 | 460 | $expr->andX( |
461 | - $expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'), |
|
461 | + $expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'), |
|
462 | 462 | $expr->eq( |
463 | - $aliasRemoteMember . '.instance', |
|
463 | + $aliasRemoteMember.'.instance', |
|
464 | 464 | $this->createNamedParameter($remoteInstance->getInstance()) |
465 | 465 | ), |
466 | - $expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
466 | + $expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
467 | 467 | ) |
468 | 468 | ); |
469 | 469 | } |
@@ -495,21 +495,21 @@ discard block |
||
495 | 495 | $this->leftJoin( |
496 | 496 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle, |
497 | 497 | $expr->andX( |
498 | - $expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'), |
|
499 | - $expr->emptyString($aliasRemoteCircle . '.instance'), |
|
500 | - $expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
498 | + $expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'), |
|
499 | + $expr->emptyString($aliasRemoteCircle.'.instance'), |
|
500 | + $expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
501 | 501 | ) |
502 | 502 | ); |
503 | 503 | $this->leftJoin( |
504 | 504 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner, |
505 | 505 | $expr->andX( |
506 | - $expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'), |
|
506 | + $expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'), |
|
507 | 507 | $expr->eq( |
508 | - $aliasRemoteCircleOwner . '.instance', |
|
508 | + $aliasRemoteCircleOwner.'.instance', |
|
509 | 509 | $this->createNamedParameter($remoteInstance->getInstance()) |
510 | 510 | ), |
511 | 511 | $expr->eq( |
512 | - $aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
512 | + $aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
513 | 513 | ) |
514 | 514 | ) |
515 | 515 | ); |
@@ -542,16 +542,16 @@ discard block |
||
542 | 542 | $expr = $this->expr(); |
543 | 543 | $orX = $expr->orX(); |
544 | 544 | $orX->add( |
545 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
545 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE)) |
|
546 | 546 | ); |
547 | 547 | |
548 | 548 | $orExtOrPassive = $expr->orX(); |
549 | 549 | $orExtOrPassive->add( |
550 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
550 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL)) |
|
551 | 551 | ); |
552 | 552 | if (!$sensitive) { |
553 | 553 | $orExtOrPassive->add( |
554 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
554 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
555 | 555 | ); |
556 | 556 | } else { |
557 | 557 | if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) { |
@@ -560,8 +560,8 @@ discard block |
||
560 | 560 | } |
561 | 561 | |
562 | 562 | $orInstance = $expr->orX(); |
563 | - $orInstance->add($expr->isNotNull($aliasRemoteMember . '.instance')); |
|
564 | - $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner . '.instance')); |
|
563 | + $orInstance->add($expr->isNotNull($aliasRemoteMember.'.instance')); |
|
564 | + $orInstance->add($expr->isNotNull($aliasRemoteCircleOwner.'.instance')); |
|
565 | 565 | |
566 | 566 | $andExternal = $expr->andX(); |
567 | 567 | $andExternal->add($orExtOrPassive); |
@@ -570,13 +570,13 @@ discard block |
||
570 | 570 | $orExtOrTrusted = $expr->orX(); |
571 | 571 | $orExtOrTrusted->add($andExternal); |
572 | 572 | $orExtOrTrusted->add( |
573 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
573 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)) |
|
574 | 574 | ); |
575 | 575 | |
576 | 576 | $andTrusted = $expr->andX(); |
577 | 577 | $andTrusted->add($orExtOrTrusted); |
578 | 578 | $andTrusted->add($this->exprLimitBitwise('config', Circle::CFG_FEDERATED, $aliasCircle)); |
579 | - $andTrusted->add($expr->emptyString($aliasOwner . '.instance')); |
|
579 | + $andTrusted->add($expr->emptyString($aliasOwner.'.instance')); |
|
580 | 580 | $orX->add($andTrusted); |
581 | 581 | |
582 | 582 | $this->andWhere($orX); |
@@ -603,7 +603,7 @@ discard block |
||
603 | 603 | } |
604 | 604 | $this->leftJoin( |
605 | 605 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
606 | - $expr->eq($aliasMember . '.circle_id', $alias . '.unique_id') |
|
606 | + $expr->eq($aliasMember.'.circle_id', $alias.'.unique_id') |
|
607 | 607 | ); |
608 | 608 | |
609 | 609 | $this->filterDirectMembership($aliasMember, $member); |
@@ -624,30 +624,30 @@ discard block |
||
624 | 624 | |
625 | 625 | if ($member->getUserId() !== '') { |
626 | 626 | $andX->add( |
627 | - $expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId())) |
|
627 | + $expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId())) |
|
628 | 628 | ); |
629 | 629 | } |
630 | 630 | |
631 | 631 | if ($member->getSingleId() !== '') { |
632 | 632 | $andX->add( |
633 | - $expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId())) |
|
633 | + $expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId())) |
|
634 | 634 | ); |
635 | 635 | } |
636 | 636 | |
637 | 637 | if ($member->getUserType() > 0) { |
638 | 638 | $andX->add( |
639 | - $expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType())) |
|
639 | + $expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType())) |
|
640 | 640 | ); |
641 | 641 | } |
642 | 642 | |
643 | 643 | $andX->add( |
644 | - $expr->eq($aliasMember . '.instance', $this->createNamedParameter($this->getInstance($member))) |
|
644 | + $expr->eq($aliasMember.'.instance', $this->createNamedParameter($this->getInstance($member))) |
|
645 | 645 | ); |
646 | 646 | |
647 | 647 | if ($member->getLevel() > 0) { |
648 | 648 | $andX->add( |
649 | 649 | $expr->gte( |
650 | - $aliasMember . '.level', |
|
650 | + $aliasMember.'.level', |
|
651 | 651 | $this->createNamedParameter($member->getLevel(), IQueryBuilder::PARAM_INT) |
652 | 652 | ) |
653 | 653 | ); |
@@ -688,7 +688,7 @@ discard block |
||
688 | 688 | $helperAlias, |
689 | 689 | CoreRequestBuilder::TABLE_CIRCLE, |
690 | 690 | $aliasCircle, |
691 | - $expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field) |
|
691 | + $expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field) |
|
692 | 692 | ); |
693 | 693 | |
694 | 694 | if (!is_null($initiator)) { |
@@ -719,7 +719,7 @@ discard block |
||
719 | 719 | $this->generateCircleSelectAlias($aliasInvitedBy) |
720 | 720 | ->leftJoin( |
721 | 721 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasInvitedBy, |
722 | - $expr->eq($aliasMember . '.invited_by', $aliasInvitedBy . '.unique_id') |
|
722 | + $expr->eq($aliasMember.'.invited_by', $aliasInvitedBy.'.unique_id') |
|
723 | 723 | ); |
724 | 724 | |
725 | 725 | $this->leftJoinOwner($aliasInvitedBy); |
@@ -750,7 +750,7 @@ discard block |
||
750 | 750 | $this->generateCircleSelectAlias($aliasBasedOn) |
751 | 751 | ->leftJoin( |
752 | 752 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn, |
753 | - $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id') |
|
753 | + $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id') |
|
754 | 754 | ); |
755 | 755 | |
756 | 756 | if (!is_null($initiator)) { |
@@ -783,9 +783,9 @@ discard block |
||
783 | 783 | ->leftJoin( |
784 | 784 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
785 | 785 | $expr->andX( |
786 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field), |
|
786 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field), |
|
787 | 787 | $expr->eq( |
788 | - $aliasMember . '.level', |
|
788 | + $aliasMember.'.level', |
|
789 | 789 | $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT) |
790 | 790 | ) |
791 | 791 | ) |
@@ -823,10 +823,10 @@ discard block |
||
823 | 823 | ->leftJoin( |
824 | 824 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
825 | 825 | $expr->andX( |
826 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId), |
|
827 | - $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId), |
|
826 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId), |
|
827 | + $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId), |
|
828 | 828 | $expr->gte( |
829 | - $aliasMember . '.level', |
|
829 | + $aliasMember.'.level', |
|
830 | 830 | $this->createNamedParameter(Member::LEVEL_MEMBER, self::PARAM_INT) |
831 | 831 | ) |
832 | 832 | ) |
@@ -859,7 +859,7 @@ discard block |
||
859 | 859 | |
860 | 860 | $this->leftJoin( |
861 | 861 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
862 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field) |
|
862 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field) |
|
863 | 863 | ); |
864 | 864 | |
865 | 865 | // if (!$this->getBool('getData', $options, false)) { |
@@ -873,8 +873,8 @@ discard block |
||
873 | 873 | ->leftJoin( |
874 | 874 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
875 | 875 | $expr->andX( |
876 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'), |
|
877 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id') |
|
876 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'), |
|
877 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id') |
|
878 | 878 | ) |
879 | 879 | ); |
880 | 880 | |
@@ -891,12 +891,12 @@ discard block |
||
891 | 891 | $aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options); |
892 | 892 | $this->leftJoin( |
893 | 893 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership, |
894 | - $expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId)) |
|
894 | + $expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId)) |
|
895 | 895 | ); |
896 | 896 | |
897 | 897 | $orX = $expr->orX( |
898 | - $expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field), |
|
899 | - $expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId)) |
|
898 | + $expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field), |
|
899 | + $expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId)) |
|
900 | 900 | ); |
901 | 901 | |
902 | 902 | $this->andWhere($orX); |
@@ -916,7 +916,7 @@ discard block |
||
916 | 916 | |
917 | 917 | $expr = $this->expr(); |
918 | 918 | $aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS); |
919 | - $this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId))); |
|
919 | + $this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId))); |
|
920 | 920 | } |
921 | 921 | |
922 | 922 | |
@@ -940,7 +940,7 @@ discard block |
||
940 | 940 | $this->leftJoin( |
941 | 941 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
942 | 942 | // $expr->andX( |
943 | - $expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field) |
|
943 | + $expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field) |
|
944 | 944 | // $expr->eq($aliasMembership . '.single_id', $alias . '.single_id') |
945 | 945 | // ) |
946 | 946 | ); |
@@ -954,8 +954,8 @@ discard block |
||
954 | 954 | ->leftJoin( |
955 | 955 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom, |
956 | 956 | $expr->andX( |
957 | - $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'), |
|
958 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id') |
|
957 | + $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'), |
|
958 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id') |
|
959 | 959 | ) |
960 | 960 | ); |
961 | 961 | } |
@@ -1021,7 +1021,7 @@ discard block |
||
1021 | 1021 | $aliasMembership, |
1022 | 1022 | $expr->andX( |
1023 | 1023 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), |
1024 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field) |
|
1024 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field) |
|
1025 | 1025 | ) |
1026 | 1026 | ); |
1027 | 1027 | |
@@ -1034,8 +1034,8 @@ discard block |
||
1034 | 1034 | $this->leftJoin( |
1035 | 1035 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator, |
1036 | 1036 | $expr->andX( |
1037 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'), |
|
1038 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id') |
|
1037 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'), |
|
1038 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id') |
|
1039 | 1039 | ) |
1040 | 1040 | ); |
1041 | 1041 | |
@@ -1043,8 +1043,8 @@ discard block |
||
1043 | 1043 | $this->leftJoin( |
1044 | 1044 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
1045 | 1045 | $expr->andX( |
1046 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'), |
|
1047 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id') |
|
1046 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'), |
|
1047 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id') |
|
1048 | 1048 | ) |
1049 | 1049 | ); |
1050 | 1050 | |
@@ -1063,7 +1063,7 @@ discard block |
||
1063 | 1063 | $aliasInheritedByMembership = $this->generateAlias($aliasInheritedBy, self::MEMBERSHIPS); |
1064 | 1064 | $this->generateMembershipSelectAlias($aliasMembership, $aliasInheritedByMembership); |
1065 | 1065 | } catch (RequestBuilderException $e) { |
1066 | - \OC::$server->getLogger()->log(3, '-- ' . $e->getMessage()); |
|
1066 | + \OC::$server->getLogger()->log(3, '-- '.$e->getMessage()); |
|
1067 | 1067 | } |
1068 | 1068 | } |
1069 | 1069 | |
@@ -1087,7 +1087,7 @@ discard block |
||
1087 | 1087 | $orX = $expr->orX(); |
1088 | 1088 | $orX->add( |
1089 | 1089 | $expr->andX( |
1090 | - $expr->gte($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
1090 | + $expr->gte($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
1091 | 1091 | ) |
1092 | 1092 | ); |
1093 | 1093 | |
@@ -1095,7 +1095,7 @@ discard block |
||
1095 | 1095 | $orX->add( |
1096 | 1096 | $expr->andX( |
1097 | 1097 | $this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $alias), |
1098 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
1098 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
1099 | 1099 | ) |
1100 | 1100 | ); |
1101 | 1101 | } |
@@ -1104,7 +1104,7 @@ discard block |
||
1104 | 1104 | } |
1105 | 1105 | if ($this->getBool('canBeVisitor', $options, false)) { |
1106 | 1106 | // TODO: should find a better way, also filter on remote initiator on non-federated ? |
1107 | - $orX->add($expr->gte($alias . '.config', $this->createNamedParameter(0))); |
|
1107 | + $orX->add($expr->gte($alias.'.config', $this->createNamedParameter(0))); |
|
1108 | 1108 | } |
1109 | 1109 | if ($this->getBool('canBeVisitorOnOpen', $options, false)) { |
1110 | 1110 | $andOpen = $expr->andX(); |
@@ -1172,21 +1172,21 @@ discard block |
||
1172 | 1172 | $expr = $this->expr(); |
1173 | 1173 | $andPassive = $expr->andX(); |
1174 | 1174 | $andPassive->add( |
1175 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
1175 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)) |
|
1176 | 1176 | ); |
1177 | 1177 | |
1178 | 1178 | $orMemberOrLevel = $expr->orX(); |
1179 | 1179 | $orMemberOrLevel->add( |
1180 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance') |
|
1180 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance') |
|
1181 | 1181 | ); |
1182 | 1182 | // TODO: do we need this ? (display members from the local instance) |
1183 | 1183 | $orMemberOrLevel->add( |
1184 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance') |
|
1184 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance') |
|
1185 | 1185 | ); |
1186 | 1186 | |
1187 | 1187 | $orMemberOrLevel->add( |
1188 | 1188 | $expr->eq( |
1189 | - $this->getDefaultSelectAlias() . '.level', |
|
1189 | + $this->getDefaultSelectAlias().'.level', |
|
1190 | 1190 | $this->createNamedParameter(Member::LEVEL_OWNER) |
1191 | 1191 | ) |
1192 | 1192 | ); |
@@ -1224,11 +1224,11 @@ discard block |
||
1224 | 1224 | ) |
1225 | 1225 | ->leftJoin( |
1226 | 1226 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache, |
1227 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid') |
|
1227 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid') |
|
1228 | 1228 | ) |
1229 | 1229 | ->leftJoin( |
1230 | 1230 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages, |
1231 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id') |
|
1231 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id') |
|
1232 | 1232 | ); |
1233 | 1233 | } |
1234 | 1234 | |
@@ -1250,8 +1250,8 @@ discard block |
||
1250 | 1250 | $this->leftJoin( |
1251 | 1251 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild, |
1252 | 1252 | $expr->andX( |
1253 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'), |
|
1254 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id') |
|
1253 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'), |
|
1254 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id') |
|
1255 | 1255 | ) |
1256 | 1256 | ); |
1257 | 1257 | |
@@ -1301,13 +1301,13 @@ discard block |
||
1301 | 1301 | $this->leftJoin( |
1302 | 1302 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint, |
1303 | 1303 | $expr->andX( |
1304 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'), |
|
1305 | - $expr->eq($aliasMountpoint . '.single_id', $aliasMountMemberships . '.single_id') |
|
1304 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'), |
|
1305 | + $expr->eq($aliasMountpoint.'.single_id', $aliasMountMemberships.'.single_id') |
|
1306 | 1306 | ) |
1307 | 1307 | ); |
1308 | 1308 | |
1309 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint'); |
|
1310 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash'); |
|
1309 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint'); |
|
1310 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash'); |
|
1311 | 1311 | } |
1312 | 1312 | |
1313 | 1313 | |
@@ -1411,10 +1411,10 @@ discard block |
||
1411 | 1411 | */ |
1412 | 1412 | public function generateAlias(string $base, string $extension, ?array &$options = []): string { |
1413 | 1413 | $search = str_replace('_', '.', $base); |
1414 | - $path = $search . '.' . $extension; |
|
1414 | + $path = $search.'.'.$extension; |
|
1415 | 1415 | if (!$this->validKey($path, self::$SQL_PATH) |
1416 | 1416 | && !in_array($extension, $this->getArray($search, self::$SQL_PATH))) { |
1417 | - throw new RequestBuilderException($extension . ' not found in ' . $search); |
|
1417 | + throw new RequestBuilderException($extension.' not found in '.$search); |
|
1418 | 1418 | } |
1419 | 1419 | |
1420 | 1420 | if (!is_array($options)) { |
@@ -1423,15 +1423,15 @@ discard block |
||
1423 | 1423 | |
1424 | 1424 | $optionPath = ''; |
1425 | 1425 | foreach (explode('.', $path) as $p) { |
1426 | - $optionPath = trim($optionPath . '.' . $p, '.'); |
|
1426 | + $optionPath = trim($optionPath.'.'.$p, '.'); |
|
1427 | 1427 | $options = array_merge( |
1428 | 1428 | $options, |
1429 | - $this->getArray($optionPath . '.' . self::OPTIONS, self::$SQL_PATH), |
|
1430 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options) |
|
1429 | + $this->getArray($optionPath.'.'.self::OPTIONS, self::$SQL_PATH), |
|
1430 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options) |
|
1431 | 1431 | ); |
1432 | 1432 | } |
1433 | 1433 | |
1434 | - return $base . '_' . $extension; |
|
1434 | + return $base.'_'.$extension; |
|
1435 | 1435 | } |
1436 | 1436 | |
1437 | 1437 | |
@@ -1451,7 +1451,7 @@ discard block |
||
1451 | 1451 | } else { |
1452 | 1452 | $k = $arr; |
1453 | 1453 | } |
1454 | - $path[$k] = $prefix . '_' . $k . '_'; |
|
1454 | + $path[$k] = $prefix.'_'.$k.'_'; |
|
1455 | 1455 | } |
1456 | 1456 | |
1457 | 1457 | return $path; |
@@ -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; |
@@ -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 | } |