@@ -71,27 +71,27 @@ discard block |
||
| 71 | 71 | public const FLAGS_LONG = 2; |
| 72 | 72 | |
| 73 | 73 | // specific value |
| 74 | - public const CFG_CIRCLE = 0; // only for code readability. Circle is locked by default. |
|
| 75 | - public const CFG_SINGLE = 1; // Circle with only one single member. |
|
| 76 | - public const CFG_PERSONAL = 2; // Personal circle, only the owner can see it. |
|
| 74 | + public const CFG_CIRCLE = 0; // only for code readability. Circle is locked by default. |
|
| 75 | + public const CFG_SINGLE = 1; // Circle with only one single member. |
|
| 76 | + public const CFG_PERSONAL = 2; // Personal circle, only the owner can see it. |
|
| 77 | 77 | |
| 78 | 78 | // bitwise |
| 79 | - public const CFG_SYSTEM = 4; // System Circle (not managed by the official front-end). Meaning some config are limited |
|
| 80 | - public const CFG_VISIBLE = 8; // Visible to everyone, if not visible, people have to know its name to be able to find it |
|
| 81 | - public const CFG_OPEN = 16; // Circle is open, people can join |
|
| 82 | - public const CFG_INVITE = 32; // Adding a member generate an invitation that needs to be accepted |
|
| 83 | - public const CFG_REQUEST = 64; // Request to join Circles needs to be confirmed by a moderator |
|
| 84 | - public const CFG_FRIEND = 128; // Members of the circle can invite their friends |
|
| 85 | - public const CFG_PROTECTED = 256; // Password protected to join/request |
|
| 86 | - public const CFG_NO_OWNER = 512; // no owner, only members |
|
| 87 | - public const CFG_HIDDEN = 1024; // hidden from listing, but available as a share entity |
|
| 88 | - public const CFG_BACKEND = 2048; // Fully hidden, only backend Circles |
|
| 89 | - public const CFG_LOCAL = 4096; // Local even on GlobalScale |
|
| 90 | - public const CFG_ROOT = 8192; // Circle cannot be inside another Circle |
|
| 91 | - public const CFG_CIRCLE_INVITE = 16384; // Circle must confirm when invited in another circle |
|
| 92 | - public const CFG_FEDERATED = 32768; // Federated |
|
| 93 | - public const CFG_MOUNTPOINT = 65536; // Generate a Files folder for this Circle |
|
| 94 | - public const CFG_APP = 131072; // Some features are not available to the OCS API (ie. destroying Circle) |
|
| 79 | + public const CFG_SYSTEM = 4; // System Circle (not managed by the official front-end). Meaning some config are limited |
|
| 80 | + public const CFG_VISIBLE = 8; // Visible to everyone, if not visible, people have to know its name to be able to find it |
|
| 81 | + public const CFG_OPEN = 16; // Circle is open, people can join |
|
| 82 | + public const CFG_INVITE = 32; // Adding a member generate an invitation that needs to be accepted |
|
| 83 | + public const CFG_REQUEST = 64; // Request to join Circles needs to be confirmed by a moderator |
|
| 84 | + public const CFG_FRIEND = 128; // Members of the circle can invite their friends |
|
| 85 | + public const CFG_PROTECTED = 256; // Password protected to join/request |
|
| 86 | + public const CFG_NO_OWNER = 512; // no owner, only members |
|
| 87 | + public const CFG_HIDDEN = 1024; // hidden from listing, but available as a share entity |
|
| 88 | + public const CFG_BACKEND = 2048; // Fully hidden, only backend Circles |
|
| 89 | + public const CFG_LOCAL = 4096; // Local even on GlobalScale |
|
| 90 | + public const CFG_ROOT = 8192; // Circle cannot be inside another Circle |
|
| 91 | + public const CFG_CIRCLE_INVITE = 16384; // Circle must confirm when invited in another circle |
|
| 92 | + public const CFG_FEDERATED = 32768; // Federated |
|
| 93 | + public const CFG_MOUNTPOINT = 65536; // Generate a Files folder for this Circle |
|
| 94 | + public const CFG_APP = 131072; // Some features are not available to the OCS API (ie. destroying Circle) |
|
| 95 | 95 | public static $DEF_CFG_MAX = 262143; |
| 96 | 96 | |
| 97 | 97 | |
@@ -463,7 +463,7 @@ discard block |
||
| 463 | 463 | */ |
| 464 | 464 | public function addInheritedMembers(array $members): self { |
| 465 | 465 | $knownIds = array_map( |
| 466 | - function (Member $member): string { |
|
| 466 | + function(Member $member): string { |
|
| 467 | 467 | return $member->getId(); |
| 468 | 468 | }, $this->inheritedMembers |
| 469 | 469 | ); |
@@ -879,7 +879,7 @@ discard block |
||
| 879 | 879 | $initiatorHelper->mustBeAdmin(); |
| 880 | 880 | $arr['settings'] = $this->getSettings(); |
| 881 | 881 | $arr['invitationCode'] = $this->getCircleInvitation()?->getInvitationCode(); |
| 882 | - } catch (MemberHelperException|MemberLevelException $e) { |
|
| 882 | + } catch (MemberHelperException | MemberLevelException $e) { |
|
| 883 | 883 | } |
| 884 | 884 | } |
| 885 | 885 | |
@@ -895,23 +895,23 @@ discard block |
||
| 895 | 895 | * @throws CircleNotFoundException |
| 896 | 896 | */ |
| 897 | 897 | public function importFromDatabase(array $data, string $prefix = ''): IQueryRow { |
| 898 | - if ($this->get($prefix . 'unique_id', $data) === '') { |
|
| 898 | + if ($this->get($prefix.'unique_id', $data) === '') { |
|
| 899 | 899 | throw new CircleNotFoundException(); |
| 900 | 900 | } |
| 901 | 901 | |
| 902 | - $this->setSingleId($this->get($prefix . 'unique_id', $data)) |
|
| 903 | - ->setName($this->get($prefix . 'name', $data)) |
|
| 904 | - ->setDisplayName($this->get($prefix . 'display_name', $data)) |
|
| 905 | - ->setSanitizedName($this->get($prefix . 'sanitized_name', $data)) |
|
| 906 | - ->setConfig($this->getInt($prefix . 'config', $data)) |
|
| 907 | - ->setSource($this->getInt($prefix . 'source', $data)) |
|
| 908 | - ->setInstance($this->get($prefix . 'instance', $data)) |
|
| 909 | - ->setSettings($this->getArray($prefix . 'settings', $data)) |
|
| 910 | - ->setContactAddressBook($this->getInt($prefix . 'contact_addressbook', $data)) |
|
| 911 | - ->setContactGroupName($this->get($prefix . 'contact_groupname', $data)) |
|
| 912 | - ->setDescription($this->get($prefix . 'description', $data)); |
|
| 913 | - |
|
| 914 | - $creation = $this->get($prefix . 'creation', $data); |
|
| 902 | + $this->setSingleId($this->get($prefix.'unique_id', $data)) |
|
| 903 | + ->setName($this->get($prefix.'name', $data)) |
|
| 904 | + ->setDisplayName($this->get($prefix.'display_name', $data)) |
|
| 905 | + ->setSanitizedName($this->get($prefix.'sanitized_name', $data)) |
|
| 906 | + ->setConfig($this->getInt($prefix.'config', $data)) |
|
| 907 | + ->setSource($this->getInt($prefix.'source', $data)) |
|
| 908 | + ->setInstance($this->get($prefix.'instance', $data)) |
|
| 909 | + ->setSettings($this->getArray($prefix.'settings', $data)) |
|
| 910 | + ->setContactAddressBook($this->getInt($prefix.'contact_addressbook', $data)) |
|
| 911 | + ->setContactGroupName($this->get($prefix.'contact_groupname', $data)) |
|
| 912 | + ->setDescription($this->get($prefix.'description', $data)); |
|
| 913 | + |
|
| 914 | + $creation = $this->get($prefix.'creation', $data); |
|
| 915 | 915 | $dateTime = DateTime::createFromFormat('Y-m-d H:i:s', $creation); |
| 916 | 916 | $timestamp = $dateTime ? $dateTime->getTimestamp() : (int)strtotime($creation); |
| 917 | 917 | $this->setCreation($timestamp); |
@@ -165,8 +165,8 @@ discard block |
||
| 165 | 165 | $qb->filterCircles(CoreQueryBuilder::CIRCLE, $probe); |
| 166 | 166 | if (!is_null($initiator)) { |
| 167 | 167 | $qb->limitToInitiator(CoreQueryBuilder::CIRCLE, $initiator); |
| 168 | - $qb->orderBy($qb->generateAlias(CoreQueryBuilder::CIRCLE, CoreQueryBuilder::INITIATOR) . '.level', 'desc'); |
|
| 169 | - $qb->addOrderBy(CoreQueryBuilder::CIRCLE . '.display_name', 'asc'); |
|
| 168 | + $qb->orderBy($qb->generateAlias(CoreQueryBuilder::CIRCLE, CoreQueryBuilder::INITIATOR).'.level', 'desc'); |
|
| 169 | + $qb->addOrderBy(CoreQueryBuilder::CIRCLE.'.display_name', 'asc'); |
|
| 170 | 170 | $qb->leftJoinCircleInvitation(CoreQueryBuilder::CIRCLE); |
| 171 | 171 | } |
| 172 | 172 | if ($probe->hasFilterMember()) { |
@@ -259,7 +259,7 @@ discard block |
||
| 259 | 259 | $qb->completeProbeWithInitiator(CoreQueryBuilder::CIRCLE, 'single_id', $aliasMembership); |
| 260 | 260 | $qb->andWhere( |
| 261 | 261 | $limit, |
| 262 | - $qb->expr()->in(CoreQueryBuilder::CIRCLE . '.unique_id', $qb->createNamedParameter($ids, IQueryBuilder::PARAM_STR_ARRAY)) |
|
| 262 | + $qb->expr()->in(CoreQueryBuilder::CIRCLE.'.unique_id', $qb->createNamedParameter($ids, IQueryBuilder::PARAM_STR_ARRAY)) |
|
| 263 | 263 | ); |
| 264 | 264 | $qb->resetSqlPath(); |
| 265 | 265 | |
@@ -378,8 +378,8 @@ discard block |
||
| 378 | 378 | $andX = []; |
| 379 | 379 | foreach (explode(' ', $circle->getDisplayName()) as $word) { |
| 380 | 380 | $andX[] = $expr->iLike( |
| 381 | - $this->getDefaultSelectAlias() . '.' . 'display_name', |
|
| 382 | - $this->createNamedParameter('%' . $word . '%') |
|
| 381 | + $this->getDefaultSelectAlias().'.'.'display_name', |
|
| 382 | + $this->createNamedParameter('%'.$word.'%') |
|
| 383 | 383 | ); |
| 384 | 384 | } |
| 385 | 385 | } |
@@ -408,7 +408,7 @@ discard block |
||
| 408 | 408 | $this->generateRemoteInstanceSelectAlias($aliasRemoteInstance) |
| 409 | 409 | ->leftJoin( |
| 410 | 410 | $alias, CoreRequestBuilder::TABLE_REMOTE, $aliasRemoteInstance, |
| 411 | - $expr->eq($alias . '.instance', $aliasRemoteInstance . '.instance') |
|
| 411 | + $expr->eq($alias.'.instance', $aliasRemoteInstance.'.instance') |
|
| 412 | 412 | ); |
| 413 | 413 | } catch (RequestBuilderException $e) { |
| 414 | 414 | } |
@@ -460,7 +460,7 @@ discard block |
||
| 460 | 460 | $expr = $this->expr(); |
| 461 | 461 | $this->leftJoin( |
| 462 | 462 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_REMOTE, $aliasRemote, |
| 463 | - $expr->eq($aliasRemote . '.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
| 463 | + $expr->eq($aliasRemote.'.instance', $this->createNamedParameter($remoteInstance->getInstance())) |
|
| 464 | 464 | ); |
| 465 | 465 | } |
| 466 | 466 | |
@@ -488,12 +488,12 @@ discard block |
||
| 488 | 488 | $this->leftJoin( |
| 489 | 489 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteMember, |
| 490 | 490 | $expr->andX( |
| 491 | - $expr->eq($aliasRemoteMember . '.circle_id', $aliasCircle . '.unique_id'), |
|
| 491 | + $expr->eq($aliasRemoteMember.'.circle_id', $aliasCircle.'.unique_id'), |
|
| 492 | 492 | $expr->eq( |
| 493 | - $aliasRemoteMember . '.instance', |
|
| 493 | + $aliasRemoteMember.'.instance', |
|
| 494 | 494 | $this->createNamedParameter($remoteInstance->getInstance()) |
| 495 | 495 | ), |
| 496 | - $expr->gte($aliasRemoteMember . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 496 | + $expr->gte($aliasRemoteMember.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 497 | 497 | ) |
| 498 | 498 | ); |
| 499 | 499 | } |
@@ -525,21 +525,21 @@ discard block |
||
| 525 | 525 | $this->leftJoin( |
| 526 | 526 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircle, |
| 527 | 527 | $expr->andX( |
| 528 | - $expr->eq($aliasRemoteCircle . '.single_id', $aliasCircle . '.unique_id'), |
|
| 529 | - $expr->emptyString($aliasRemoteCircle . '.instance'), |
|
| 530 | - $expr->gte($aliasRemoteCircle . '.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 528 | + $expr->eq($aliasRemoteCircle.'.single_id', $aliasCircle.'.unique_id'), |
|
| 529 | + $expr->emptyString($aliasRemoteCircle.'.instance'), |
|
| 530 | + $expr->gte($aliasRemoteCircle.'.level', $this->createNamedParameter(Member::LEVEL_MEMBER)) |
|
| 531 | 531 | ) |
| 532 | 532 | ); |
| 533 | 533 | $this->leftJoin( |
| 534 | 534 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasRemoteCircleOwner, |
| 535 | 535 | $expr->andX( |
| 536 | - $expr->eq($aliasRemoteCircle . '.circle_id', $aliasRemoteCircleOwner . '.circle_id'), |
|
| 536 | + $expr->eq($aliasRemoteCircle.'.circle_id', $aliasRemoteCircleOwner.'.circle_id'), |
|
| 537 | 537 | $expr->eq( |
| 538 | - $aliasRemoteCircleOwner . '.instance', |
|
| 538 | + $aliasRemoteCircleOwner.'.instance', |
|
| 539 | 539 | $this->createNamedParameter($remoteInstance->getInstance()) |
| 540 | 540 | ), |
| 541 | 541 | $expr->eq( |
| 542 | - $aliasRemoteCircleOwner . '.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
| 542 | + $aliasRemoteCircleOwner.'.level', $this->createNamedParameter(Member::LEVEL_OWNER) |
|
| 543 | 543 | ) |
| 544 | 544 | ) |
| 545 | 545 | ); |
@@ -570,11 +570,11 @@ discard block |
||
| 570 | 570 | $aliasRemoteCircleOwner = $this->generateAlias($aliasRemoteCircle, self::OWNER); |
| 571 | 571 | |
| 572 | 572 | $expr = $this->expr(); |
| 573 | - $orX = [$expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE))]; |
|
| 573 | + $orX = [$expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_GLOBALSCALE))]; |
|
| 574 | 574 | |
| 575 | - $orExtOrPassive = [$expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))]; |
|
| 575 | + $orExtOrPassive = [$expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_EXTERNAL))]; |
|
| 576 | 576 | if (!$sensitive) { |
| 577 | - $orExtOrPassive[] = $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)); |
|
| 577 | + $orExtOrPassive[] = $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)); |
|
| 578 | 578 | } else { |
| 579 | 579 | if ($this->getDefaultSelectAlias() === CoreQueryBuilder::MEMBER) { |
| 580 | 580 | $orExtOrPassive[] = $this->limitRemoteVisibility_Sensitive_Members($aliasRemote); |
@@ -582,8 +582,8 @@ discard block |
||
| 582 | 582 | } |
| 583 | 583 | |
| 584 | 584 | $orInstance = $expr->orX( |
| 585 | - $expr->isNotNull($aliasRemoteMember . '.instance'), |
|
| 586 | - $expr->isNotNull($aliasRemoteCircleOwner . '.instance'), |
|
| 585 | + $expr->isNotNull($aliasRemoteMember.'.instance'), |
|
| 586 | + $expr->isNotNull($aliasRemoteCircleOwner.'.instance'), |
|
| 587 | 587 | ); |
| 588 | 588 | |
| 589 | 589 | $andExternal = $expr->andX( |
@@ -593,13 +593,13 @@ discard block |
||
| 593 | 593 | |
| 594 | 594 | $orExtOrTrusted = $expr->orX( |
| 595 | 595 | $andExternal, |
| 596 | - $expr->eq($aliasRemote . '.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)), |
|
| 596 | + $expr->eq($aliasRemote.'.type', $this->createNamedParameter(RemoteInstance::TYPE_TRUSTED)), |
|
| 597 | 597 | ); |
| 598 | 598 | |
| 599 | 599 | $orX[] = $expr->andX( |
| 600 | 600 | $orExtOrTrusted, |
| 601 | 601 | $this->exprLimitBitwise('config', Circle::CFG_FEDERATED, $aliasCircle), |
| 602 | - $expr->emptyString($aliasOwner . '.instance'), |
|
| 602 | + $expr->emptyString($aliasOwner.'.instance'), |
|
| 603 | 603 | ); |
| 604 | 604 | |
| 605 | 605 | $this->andWhere($expr->orX(...$orX)); |
@@ -626,7 +626,7 @@ discard block |
||
| 626 | 626 | } |
| 627 | 627 | $this->innerJoin( |
| 628 | 628 | $this->getDefaultSelectAlias(), CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 629 | - $expr->eq($aliasMember . '.circle_id', $alias . '.unique_id') |
|
| 629 | + $expr->eq($aliasMember.'.circle_id', $alias.'.unique_id') |
|
| 630 | 630 | ); |
| 631 | 631 | |
| 632 | 632 | $this->filterDirectMembership($aliasMember, $member); |
@@ -651,12 +651,12 @@ discard block |
||
| 651 | 651 | $aliasCircle, |
| 652 | 652 | 'circles_membership', |
| 653 | 653 | $aliasMembership, |
| 654 | - $this->expr()->eq($aliasCircle . '.unique_id', $aliasMembership . '.circle_id') |
|
| 654 | + $this->expr()->eq($aliasCircle.'.unique_id', $aliasMembership.'.circle_id') |
|
| 655 | 655 | ); |
| 656 | 656 | |
| 657 | 657 | $this->andWhere( |
| 658 | 658 | $this->expr()->eq( |
| 659 | - $aliasMembership . '.single_id', |
|
| 659 | + $aliasMembership.'.single_id', |
|
| 660 | 660 | $this->createNamedParameter($federatedUser->getSingleId()) |
| 661 | 661 | ) |
| 662 | 662 | ); |
@@ -676,22 +676,22 @@ discard block |
||
| 676 | 676 | $andX = []; |
| 677 | 677 | |
| 678 | 678 | if ($member->getUserId() !== '') { |
| 679 | - $andX[] = $expr->eq($aliasMember . '.user_id', $this->createNamedParameter($member->getUserId())); |
|
| 679 | + $andX[] = $expr->eq($aliasMember.'.user_id', $this->createNamedParameter($member->getUserId())); |
|
| 680 | 680 | } |
| 681 | 681 | |
| 682 | 682 | if ($member->getSingleId() !== '') { |
| 683 | - $andX[] = $expr->eq($aliasMember . '.single_id', $this->createNamedParameter($member->getSingleId())); |
|
| 683 | + $andX[] = $expr->eq($aliasMember.'.single_id', $this->createNamedParameter($member->getSingleId())); |
|
| 684 | 684 | } |
| 685 | 685 | |
| 686 | 686 | if ($member->getUserType() > 0) { |
| 687 | - $andX[] = $expr->eq($aliasMember . '.user_type', $this->createNamedParameter($member->getUserType())); |
|
| 687 | + $andX[] = $expr->eq($aliasMember.'.user_type', $this->createNamedParameter($member->getUserType())); |
|
| 688 | 688 | } |
| 689 | 689 | |
| 690 | 690 | $this->limitToInstance($this->getInstance($member)); |
| 691 | 691 | |
| 692 | 692 | if ($member->getLevel() > 0) { |
| 693 | 693 | $andX[] = $expr->gte( |
| 694 | - $aliasMember . '.level', |
|
| 694 | + $aliasMember.'.level', |
|
| 695 | 695 | $this->createNamedParameter($member->getLevel(), IQueryBuilder::PARAM_INT) |
| 696 | 696 | ); |
| 697 | 697 | } |
@@ -731,7 +731,7 @@ discard block |
||
| 731 | 731 | $helperAlias, |
| 732 | 732 | CoreRequestBuilder::TABLE_CIRCLE, |
| 733 | 733 | $aliasCircle, |
| 734 | - $expr->eq($aliasCircle . '.unique_id', $helperAlias . '.' . $field) |
|
| 734 | + $expr->eq($aliasCircle.'.unique_id', $helperAlias.'.'.$field) |
|
| 735 | 735 | ); |
| 736 | 736 | |
| 737 | 737 | if (!is_null($initiator)) { |
@@ -762,7 +762,7 @@ discard block |
||
| 762 | 762 | $this->generateCircleSelectAlias($aliasInvitedBy) |
| 763 | 763 | ->leftJoin( |
| 764 | 764 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasInvitedBy, |
| 765 | - $expr->eq($aliasMember . '.invited_by', $aliasInvitedBy . '.unique_id') |
|
| 765 | + $expr->eq($aliasMember.'.invited_by', $aliasInvitedBy.'.unique_id') |
|
| 766 | 766 | ); |
| 767 | 767 | |
| 768 | 768 | $this->leftJoinOwner($aliasInvitedBy); |
@@ -793,7 +793,7 @@ discard block |
||
| 793 | 793 | $this->generateCircleSelectAlias($aliasBasedOn) |
| 794 | 794 | ->leftJoin( |
| 795 | 795 | $aliasMember, CoreRequestBuilder::TABLE_CIRCLE, $aliasBasedOn, |
| 796 | - $expr->eq($aliasBasedOn . '.unique_id', $aliasMember . '.single_id') |
|
| 796 | + $expr->eq($aliasBasedOn.'.unique_id', $aliasMember.'.single_id') |
|
| 797 | 797 | ); |
| 798 | 798 | |
| 799 | 799 | if (!is_null($initiator)) { |
@@ -826,9 +826,9 @@ discard block |
||
| 826 | 826 | ->leftJoin( |
| 827 | 827 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 828 | 828 | $expr->andX( |
| 829 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $field), |
|
| 829 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$field), |
|
| 830 | 830 | $expr->eq( |
| 831 | - $aliasMember . '.level', |
|
| 831 | + $aliasMember.'.level', |
|
| 832 | 832 | $this->createNamedParameter(Member::LEVEL_OWNER, self::PARAM_INT) |
| 833 | 833 | ) |
| 834 | 834 | ) |
@@ -859,7 +859,7 @@ discard block |
||
| 859 | 859 | $this->generateCircleInvitationSelectAlias($aliasInvitation) |
| 860 | 860 | ->leftJoin( |
| 861 | 861 | $alias, CoreRequestBuilder::TABLE_INVITATIONS, $aliasInvitation, |
| 862 | - $expr->eq($aliasInvitation . '.circle_id', $alias . '.' . $field), |
|
| 862 | + $expr->eq($aliasInvitation.'.circle_id', $alias.'.'.$field), |
|
| 863 | 863 | ); |
| 864 | 864 | } |
| 865 | 865 | |
@@ -885,7 +885,7 @@ discard block |
||
| 885 | 885 | |
| 886 | 886 | $expr = $this->expr(); |
| 887 | 887 | |
| 888 | - $on = $expr->andX($expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field)); |
|
| 888 | + $on = $expr->andX($expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field)); |
|
| 889 | 889 | |
| 890 | 890 | // limit on membership level if requested |
| 891 | 891 | $minLevel = $probe?->getMinimumLevel() ?? 0; |
@@ -926,8 +926,8 @@ discard block |
||
| 926 | 926 | ->leftJoin( |
| 927 | 927 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasMember, |
| 928 | 928 | $expr->andX( |
| 929 | - $expr->eq($aliasMember . '.circle_id', $alias . '.' . $fieldCircleId), |
|
| 930 | - $expr->eq($aliasMember . '.single_id', $alias . '.' . $fieldSingleId), |
|
| 929 | + $expr->eq($aliasMember.'.circle_id', $alias.'.'.$fieldCircleId), |
|
| 930 | + $expr->eq($aliasMember.'.single_id', $alias.'.'.$fieldSingleId), |
|
| 931 | 931 | $this->exprGt('level', Member::LEVEL_MEMBER, true, $aliasMember) |
| 932 | 932 | ) |
| 933 | 933 | ); |
@@ -959,7 +959,7 @@ discard block |
||
| 959 | 959 | |
| 960 | 960 | $this->leftJoin( |
| 961 | 961 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
| 962 | - $expr->eq($aliasMembership . '.circle_id', $alias . '.' . $field) |
|
| 962 | + $expr->eq($aliasMembership.'.circle_id', $alias.'.'.$field) |
|
| 963 | 963 | ); |
| 964 | 964 | |
| 965 | 965 | // if (!$this->getBool('getData', $options, false)) { |
@@ -973,8 +973,8 @@ discard block |
||
| 973 | 973 | ->leftJoin( |
| 974 | 974 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
| 975 | 975 | $expr->andX( |
| 976 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id'), |
|
| 977 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id') |
|
| 976 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id'), |
|
| 977 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id') |
|
| 978 | 978 | ) |
| 979 | 979 | ); |
| 980 | 980 | |
@@ -991,12 +991,12 @@ discard block |
||
| 991 | 991 | $aliasUpstreamMembership = $this->generateAlias($alias, self::UPSTREAM_MEMBERSHIPS, $options); |
| 992 | 992 | $this->leftJoin( |
| 993 | 993 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasUpstreamMembership, |
| 994 | - $expr->eq($aliasUpstreamMembership . '.single_id', $this->createNamedParameter($singleId)) |
|
| 994 | + $expr->eq($aliasUpstreamMembership.'.single_id', $this->createNamedParameter($singleId)) |
|
| 995 | 995 | ); |
| 996 | 996 | |
| 997 | 997 | $orX = $expr->orX( |
| 998 | - $expr->eq($aliasUpstreamMembership . '.circle_id', $alias . '.' . $field), |
|
| 999 | - $expr->eq($alias . '.' . $field, $this->createNamedParameter($singleId)) |
|
| 998 | + $expr->eq($aliasUpstreamMembership.'.circle_id', $alias.'.'.$field), |
|
| 999 | + $expr->eq($alias.'.'.$field, $this->createNamedParameter($singleId)) |
|
| 1000 | 1000 | ); |
| 1001 | 1001 | |
| 1002 | 1002 | $this->andWhere($orX); |
@@ -1017,11 +1017,11 @@ discard block |
||
| 1017 | 1017 | |
| 1018 | 1018 | $expr = $this->expr(); |
| 1019 | 1019 | $aliasMembership = $this->generateAlias($alias, self::MEMBERSHIPS); |
| 1020 | - $this->andWhere($expr->eq($aliasMembership . '.circle_id', $this->createNamedParameter($singleId))); |
|
| 1020 | + $this->andWhere($expr->eq($aliasMembership.'.circle_id', $this->createNamedParameter($singleId))); |
|
| 1021 | 1021 | if ($level > 1) { |
| 1022 | 1022 | $this->andWhere( |
| 1023 | 1023 | $expr->gte( |
| 1024 | - $aliasMembership . '.level', |
|
| 1024 | + $aliasMembership.'.level', |
|
| 1025 | 1025 | $this->createNamedParameter($level, IQueryBuilder::PARAM_INT) |
| 1026 | 1026 | ) |
| 1027 | 1027 | ); |
@@ -1049,8 +1049,8 @@ discard block |
||
| 1049 | 1049 | $this->leftJoin( |
| 1050 | 1050 | $alias, CoreRequestBuilder::TABLE_MEMBERSHIP, $aliasMembership, |
| 1051 | 1051 | $expr->andX( |
| 1052 | - $expr->eq($aliasMembership . '.inheritance_last', $alias . '.' . $field), |
|
| 1053 | - $expr->eq($aliasMembership . '.single_id', $alias . '.single_id') |
|
| 1052 | + $expr->eq($aliasMembership.'.inheritance_last', $alias.'.'.$field), |
|
| 1053 | + $expr->eq($aliasMembership.'.single_id', $alias.'.single_id') |
|
| 1054 | 1054 | ) |
| 1055 | 1055 | ); |
| 1056 | 1056 | |
@@ -1063,8 +1063,8 @@ discard block |
||
| 1063 | 1063 | ->leftJoin( |
| 1064 | 1064 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritanceFrom, |
| 1065 | 1065 | $expr->andX( |
| 1066 | - $expr->eq($aliasMembership . '.circle_id', $aliasInheritanceFrom . '.circle_id'), |
|
| 1067 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInheritanceFrom . '.single_id') |
|
| 1066 | + $expr->eq($aliasMembership.'.circle_id', $aliasInheritanceFrom.'.circle_id'), |
|
| 1067 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInheritanceFrom.'.single_id') |
|
| 1068 | 1068 | ) |
| 1069 | 1069 | ); |
| 1070 | 1070 | } |
@@ -1104,7 +1104,7 @@ discard block |
||
| 1104 | 1104 | |
| 1105 | 1105 | $this->leftJoin( |
| 1106 | 1106 | $alias, CoreRequestBuilder::TABLE_TOKEN, $aliasShareToken, |
| 1107 | - $expr->eq($aliasShareToken . '.share_id', $alias . '.' . $field) |
|
| 1107 | + $expr->eq($aliasShareToken.'.share_id', $alias.'.'.$field) |
|
| 1108 | 1108 | ); |
| 1109 | 1109 | } |
| 1110 | 1110 | |
@@ -1146,14 +1146,14 @@ discard block |
||
| 1146 | 1146 | try { |
| 1147 | 1147 | $aliasConfig = $this->generateAlias($alias, self::CONFIG, $options); |
| 1148 | 1148 | $this->selectAlias( |
| 1149 | - $aliasConfig . '.config', |
|
| 1150 | - (($alias !== $this->getDefaultSelectAlias()) ? $alias . '_' : '') . 'circle_config' |
|
| 1149 | + $aliasConfig.'.config', |
|
| 1150 | + (($alias !== $this->getDefaultSelectAlias()) ? $alias.'_' : '').'circle_config' |
|
| 1151 | 1151 | ); |
| 1152 | 1152 | $this->leftJoin( |
| 1153 | 1153 | $alias, |
| 1154 | 1154 | CoreRequestBuilder::TABLE_CIRCLE, |
| 1155 | 1155 | $aliasConfig, |
| 1156 | - $expr->eq($alias . '.circle_id', $aliasConfig . '.unique_id') |
|
| 1156 | + $expr->eq($alias.'.circle_id', $aliasConfig.'.unique_id') |
|
| 1157 | 1157 | ); |
| 1158 | 1158 | } catch (RequestBuilderException $e) { |
| 1159 | 1159 | } |
@@ -1191,7 +1191,7 @@ discard block |
||
| 1191 | 1191 | $aliasMembership, |
| 1192 | 1192 | $expr->andX( |
| 1193 | 1193 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasMembership), |
| 1194 | - $expr->eq($aliasMembership . '.circle_id', $helperAlias . '.' . $field) |
|
| 1194 | + $expr->eq($aliasMembership.'.circle_id', $helperAlias.'.'.$field) |
|
| 1195 | 1195 | ) |
| 1196 | 1196 | ); |
| 1197 | 1197 | |
@@ -1209,10 +1209,10 @@ discard block |
||
| 1209 | 1209 | try { |
| 1210 | 1210 | $aliasMembershipCircle = $this->generateAlias($aliasMembership, self::CONFIG, $options); |
| 1211 | 1211 | $orXMembershipCircle = $expr->orX(...array_map( |
| 1212 | - function (string $alias) use ($aliasMembershipCircle) { |
|
| 1212 | + function(string $alias) use ($aliasMembershipCircle) { |
|
| 1213 | 1213 | return $this->expr()->eq( |
| 1214 | - $alias . '.circle_id', |
|
| 1215 | - $aliasMembershipCircle . '.unique_id' |
|
| 1214 | + $alias.'.circle_id', |
|
| 1215 | + $aliasMembershipCircle.'.unique_id' |
|
| 1216 | 1216 | ); |
| 1217 | 1217 | }, |
| 1218 | 1218 | $listMembershipCircleAlias |
@@ -1243,7 +1243,7 @@ discard block |
||
| 1243 | 1243 | $aliasDirectInitiator, |
| 1244 | 1244 | $expr->andX( |
| 1245 | 1245 | $this->exprLimit('single_id', $initiator->getSingleId(), $aliasDirectInitiator), |
| 1246 | - $expr->eq($aliasDirectInitiator . '.circle_id', $helperAlias . '.' . $field) |
|
| 1246 | + $expr->eq($aliasDirectInitiator.'.circle_id', $helperAlias.'.'.$field) |
|
| 1247 | 1247 | ) |
| 1248 | 1248 | ); |
| 1249 | 1249 | } catch (RequestBuilderException $e) { |
@@ -1257,8 +1257,8 @@ discard block |
||
| 1257 | 1257 | $this->leftJoin( |
| 1258 | 1258 | $aliasMembership, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator, |
| 1259 | 1259 | $expr->andX( |
| 1260 | - $expr->eq($aliasMembership . '.inheritance_first', $aliasInitiator . '.single_id'), |
|
| 1261 | - $expr->eq($aliasMembership . '.circle_id', $aliasInitiator . '.circle_id') |
|
| 1260 | + $expr->eq($aliasMembership.'.inheritance_first', $aliasInitiator.'.single_id'), |
|
| 1261 | + $expr->eq($aliasMembership.'.circle_id', $aliasInitiator.'.circle_id') |
|
| 1262 | 1262 | ) |
| 1263 | 1263 | ); |
| 1264 | 1264 | |
@@ -1266,8 +1266,8 @@ discard block |
||
| 1266 | 1266 | $this->leftJoin( |
| 1267 | 1267 | $aliasInitiator, CoreRequestBuilder::TABLE_MEMBER, $aliasInheritedBy, |
| 1268 | 1268 | $expr->andX( |
| 1269 | - $expr->eq($aliasMembership . '.single_id', $aliasInheritedBy . '.single_id'), |
|
| 1270 | - $expr->eq($aliasMembership . '.inheritance_last', $aliasInheritedBy . '.circle_id') |
|
| 1269 | + $expr->eq($aliasMembership.'.single_id', $aliasInheritedBy.'.single_id'), |
|
| 1270 | + $expr->eq($aliasMembership.'.inheritance_last', $aliasInheritedBy.'.circle_id') |
|
| 1271 | 1271 | ) |
| 1272 | 1272 | ); |
| 1273 | 1273 | |
@@ -1312,8 +1312,8 @@ discard block |
||
| 1312 | 1312 | ->leftJoin( |
| 1313 | 1313 | $alias, CoreRequestBuilder::TABLE_MEMBER, $aliasInitiator, |
| 1314 | 1314 | $expr->andX( |
| 1315 | - $expr->eq($aliasInitiator . '.circle_id', $alias . '.unique_id'), |
|
| 1316 | - $expr->eq($aliasInitiator . '.' . $field, $helperAlias . '.inheritance_first'), |
|
| 1315 | + $expr->eq($aliasInitiator.'.circle_id', $alias.'.unique_id'), |
|
| 1316 | + $expr->eq($aliasInitiator.'.'.$field, $helperAlias.'.inheritance_first'), |
|
| 1317 | 1317 | ) |
| 1318 | 1318 | ); |
| 1319 | 1319 | // |
@@ -1349,15 +1349,15 @@ discard block |
||
| 1349 | 1349 | if (!$this->getBool('filterPersonalCircles', $options, false)) { |
| 1350 | 1350 | $orX[] = $expr->andX( |
| 1351 | 1351 | $this->exprLimitBitwise('config', Circle::CFG_PERSONAL, $aliasMembershipCircle), |
| 1352 | - $expr->eq($aliasMembership . '.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
| 1352 | + $expr->eq($aliasMembership.'.level', $this->createNamedParameter(Member::LEVEL_OWNER)) |
|
| 1353 | 1353 | ); |
| 1354 | 1354 | } |
| 1355 | 1355 | |
| 1356 | 1356 | $minimumLevel = $this->getInt('minimumLevel', $options); |
| 1357 | 1357 | $orXLevelCheck = $expr->orX(...array_map( |
| 1358 | - function (string $alias) use ($minimumLevel) { |
|
| 1358 | + function(string $alias) use ($minimumLevel) { |
|
| 1359 | 1359 | return $this->expr()->gte( |
| 1360 | - $alias . '.level', |
|
| 1360 | + $alias.'.level', |
|
| 1361 | 1361 | $this->createNamedParameter($minimumLevel, self::PARAM_INT) |
| 1362 | 1362 | ); |
| 1363 | 1363 | }, |
@@ -1437,13 +1437,13 @@ discard block |
||
| 1437 | 1437 | private function limitRemoteVisibility_Sensitive_Members(string $alias): ICompositeExpression { |
| 1438 | 1438 | $expr = $this->expr(); |
| 1439 | 1439 | return $expr->andX( |
| 1440 | - $expr->eq($alias . '.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)), |
|
| 1440 | + $expr->eq($alias.'.type', $this->createNamedParameter(RemoteInstance::TYPE_PASSIVE)), |
|
| 1441 | 1441 | $expr->orX( |
| 1442 | - $expr->eq($this->getDefaultSelectAlias() . '.instance', $alias . '.instance'), |
|
| 1442 | + $expr->eq($this->getDefaultSelectAlias().'.instance', $alias.'.instance'), |
|
| 1443 | 1443 | // TODO: do we need this ? (display members from the local instance) |
| 1444 | - $expr->emptyString($this->getDefaultSelectAlias() . '.instance'), |
|
| 1444 | + $expr->emptyString($this->getDefaultSelectAlias().'.instance'), |
|
| 1445 | 1445 | $expr->eq( |
| 1446 | - $this->getDefaultSelectAlias() . '.level', |
|
| 1446 | + $this->getDefaultSelectAlias().'.level', |
|
| 1447 | 1447 | $this->createNamedParameter(Member::LEVEL_OWNER) |
| 1448 | 1448 | ), |
| 1449 | 1449 | ), |
@@ -1478,11 +1478,11 @@ discard block |
||
| 1478 | 1478 | ) |
| 1479 | 1479 | ->leftJoin( |
| 1480 | 1480 | $aliasShare, CoreRequestBuilder::TABLE_FILE_CACHE, $aliasFileCache, |
| 1481 | - $expr->eq($aliasShare . '.file_source', $aliasFileCache . '.fileid') |
|
| 1481 | + $expr->eq($aliasShare.'.file_source', $aliasFileCache.'.fileid') |
|
| 1482 | 1482 | ) |
| 1483 | 1483 | ->leftJoin( |
| 1484 | 1484 | $aliasFileCache, CoreRequestBuilder::TABLE_STORAGES, $aliasStorages, |
| 1485 | - $expr->eq($aliasFileCache . '.storage', $aliasStorages . '.numeric_id') |
|
| 1485 | + $expr->eq($aliasFileCache.'.storage', $aliasStorages.'.numeric_id') |
|
| 1486 | 1486 | ); |
| 1487 | 1487 | } |
| 1488 | 1488 | |
@@ -1504,8 +1504,8 @@ discard block |
||
| 1504 | 1504 | $this->leftJoin( |
| 1505 | 1505 | $aliasShareMemberships, CoreRequestBuilder::TABLE_SHARE, $aliasShareChild, |
| 1506 | 1506 | $expr->andX( |
| 1507 | - $expr->eq($aliasShareChild . '.parent', $aliasShare . '.id'), |
|
| 1508 | - $expr->eq($aliasShareChild . '.share_with', $aliasShareMemberships . '.single_id') |
|
| 1507 | + $expr->eq($aliasShareChild.'.parent', $aliasShare.'.id'), |
|
| 1508 | + $expr->eq($aliasShareChild.'.share_with', $aliasShareMemberships.'.single_id') |
|
| 1509 | 1509 | ) |
| 1510 | 1510 | ); |
| 1511 | 1511 | |
@@ -1563,13 +1563,13 @@ discard block |
||
| 1563 | 1563 | $this->leftJoin( |
| 1564 | 1564 | $aliasMountMemberships, CoreRequestBuilder::TABLE_MOUNTPOINT, $aliasMountpoint, |
| 1565 | 1565 | $expr->andX( |
| 1566 | - $expr->eq($aliasMountpoint . '.mount_id', $aliasMount . '.mount_id'), |
|
| 1567 | - $expr->eq($aliasMountpoint . '.single_id', $this->createNamedParameter($federatedUser->getSingleId())) |
|
| 1566 | + $expr->eq($aliasMountpoint.'.mount_id', $aliasMount.'.mount_id'), |
|
| 1567 | + $expr->eq($aliasMountpoint.'.single_id', $this->createNamedParameter($federatedUser->getSingleId())) |
|
| 1568 | 1568 | ) |
| 1569 | 1569 | ); |
| 1570 | 1570 | |
| 1571 | - $this->selectAlias($aliasMountpoint . '.mountpoint', $aliasMountpoint . '_mountpoint'); |
|
| 1572 | - $this->selectAlias($aliasMountpoint . '.mountpoint_hash', $aliasMountpoint . '_mountpoint_hash'); |
|
| 1571 | + $this->selectAlias($aliasMountpoint.'.mountpoint', $aliasMountpoint.'_mountpoint'); |
|
| 1572 | + $this->selectAlias($aliasMountpoint.'.mountpoint_hash', $aliasMountpoint.'_mountpoint_hash'); |
|
| 1573 | 1573 | } |
| 1574 | 1574 | |
| 1575 | 1575 | |
@@ -1694,10 +1694,10 @@ discard block |
||
| 1694 | 1694 | */ |
| 1695 | 1695 | public function generateAlias(string $base, string $extension, ?array &$options = []): string { |
| 1696 | 1696 | $search = str_replace('_', '.', $base); |
| 1697 | - $path = $search . '.' . $extension; |
|
| 1697 | + $path = $search.'.'.$extension; |
|
| 1698 | 1698 | if (!$this->validKey($path, $this->getSqlPath()) |
| 1699 | 1699 | && !in_array($extension, $this->getArray($search, $this->getSqlPath()))) { |
| 1700 | - throw new RequestBuilderException($extension . ' not found in ' . $search); |
|
| 1700 | + throw new RequestBuilderException($extension.' not found in '.$search); |
|
| 1701 | 1701 | } |
| 1702 | 1702 | |
| 1703 | 1703 | if (!is_array($options)) { |
@@ -1706,15 +1706,15 @@ discard block |
||
| 1706 | 1706 | |
| 1707 | 1707 | $optionPath = ''; |
| 1708 | 1708 | foreach (explode('.', $path) as $p) { |
| 1709 | - $optionPath = trim($optionPath . '.' . $p, '.'); |
|
| 1709 | + $optionPath = trim($optionPath.'.'.$p, '.'); |
|
| 1710 | 1710 | $options = array_merge( |
| 1711 | 1711 | $options, |
| 1712 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->getSqlPath()), |
|
| 1713 | - $this->getArray($optionPath . '.' . self::OPTIONS, $this->options) |
|
| 1712 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->getSqlPath()), |
|
| 1713 | + $this->getArray($optionPath.'.'.self::OPTIONS, $this->options) |
|
| 1714 | 1714 | ); |
| 1715 | 1715 | } |
| 1716 | 1716 | |
| 1717 | - return $base . '_' . $extension; |
|
| 1717 | + return $base.'_'.$extension; |
|
| 1718 | 1718 | } |
| 1719 | 1719 | |
| 1720 | 1720 | |
@@ -1734,7 +1734,7 @@ discard block |
||
| 1734 | 1734 | } else { |
| 1735 | 1735 | $k = $arr; |
| 1736 | 1736 | } |
| 1737 | - $path[$k] = $prefix . '_' . $k . '_'; |
|
| 1737 | + $path[$k] = $prefix.'_'.$k.'_'; |
|
| 1738 | 1738 | } |
| 1739 | 1739 | |
| 1740 | 1740 | return $path; |
@@ -174,15 +174,15 @@ |
||
| 174 | 174 | * @throws CircleNotFoundException |
| 175 | 175 | */ |
| 176 | 176 | public function importFromDatabase(array $data, string $prefix = ''): IQueryRow { |
| 177 | - if (!$this->get($prefix . 'circle_id', $data)) { |
|
| 177 | + if (!$this->get($prefix.'circle_id', $data)) { |
|
| 178 | 178 | throw new CircleInvitationNotFoundException(); |
| 179 | 179 | } |
| 180 | 180 | |
| 181 | - $this->setCircleId($this->get($prefix . 'circle_id', $data)) |
|
| 182 | - ->setInvitationCode($this->get($prefix . 'invitation_code', $data)) |
|
| 183 | - ->setCreatedBy($this->get($prefix . 'created_by', $data)); |
|
| 181 | + $this->setCircleId($this->get($prefix.'circle_id', $data)) |
|
| 182 | + ->setInvitationCode($this->get($prefix.'invitation_code', $data)) |
|
| 183 | + ->setCreatedBy($this->get($prefix.'created_by', $data)); |
|
| 184 | 184 | |
| 185 | - $created = $this->get($prefix . 'created', $data); |
|
| 185 | + $created = $this->get($prefix.'created', $data); |
|
| 186 | 186 | $dateTime = \DateTime::createFromFormat('Y-m-d H:i:s', $created); |
| 187 | 187 | $timestamp = $dateTime ? $dateTime->getTimestamp() : (int)strtotime($created); |
| 188 | 188 | $this->setCreated($timestamp); |