usertogroup.php

См. документацию.

<?php

namespace Bitrix\Socialnetwork;
 
use Bitrix\Main\Entity;
use Bitrix\Main\ModuleManager;
use Bitrix\Main\NotImplementedException;
use Bitrix\Main\ORM\Data\Internal\DeleteByFilterTrait;
use Bitrix\Main\ORM\Data\Internal\MergeTrait;
use Bitrix\Main\ORM\Query\Join;
use Bitrix\Socialnetwork\Internals\Member\MemberEntityCollection;
use Bitrix\Socialnetwork\Space\Member;

class UserToGroupTable extends Entity\DataManager
{
    use MergeTrait;
    use DeleteByFilterTrait;

    public const ROLE_OWNER = 'A';

    public const ROLE_MODERATOR = 'E';

    public const ROLE_USER = 'K';

    public const ROLE_BAN = 'T';

    public const ROLE_REQUEST = 'Z';

    public const INITIATED_BY_USER = 'U';

    public const INITIATED_BY_GROUP = 'G';
 
    public const INITIATED_BY_STRUCTURE = 'S';
 
    public static function getObjectClass(): string
    {
        return Member::class;
    }
 
    public static function getCollectionClass(): string
    {
        return MemberEntityCollection::class;
    }

    public static function getTableName(): string
    {
        return 'b_sonet_user2group';
    }
 
    public static function getUfId(): string
    {
        return 'USER_TO_WORKGROUP';
    }

    public static function getRolesAll(): array
    {
        return [ self::ROLE_OWNER, self::ROLE_MODERATOR, self::ROLE_USER, self::ROLE_BAN, self::ROLE_REQUEST ];
    }

    public static function getRolesMember(): array
    {
        return [ self::ROLE_OWNER, self::ROLE_MODERATOR, self::ROLE_USER ];
    }

    public static function getInitiatedByAll(): array
    {
        return [ self::INITIATED_BY_USER, self::INITIATED_BY_GROUP, self::INITIATED_BY_STRUCTURE ];
    }

    public static function getMap(): array
    {
        return array(
            'ID' => array(
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ),
            'USER_ID' => array(
                'data_type' => 'integer',
            ),
            'USER' => array(
                'data_type' => (ModuleManager::isModuleInstalled('intranet') ? 'Bitrix\Intranet\UserTable' : 'Bitrix\Main\UserTable'),
                'reference' => array('=this.USER_ID' => 'ref.ID'),
                'join_type' => Join::TYPE_INNER,
            ),
            'GROUP_ID' => array(
                'data_type' => 'integer',
            ),
            'GROUP' => array(
                'data_type' => 'Bitrix\Socialnetwork\WorkgroupTable',
                'reference' => array('=this.GROUP_ID' => 'ref.ID'),
                'join_type' => Join::TYPE_INNER,
            ),
            'ROLE' => array(
                'data_type' => 'enum',
                'values' => array(self::ROLE_OWNER, self::ROLE_MODERATOR, self::ROLE_USER, self::ROLE_BAN, self::ROLE_REQUEST),
            ),
            'AUTO_MEMBER' => array(
                'data_type' => 'boolean',
                'values' => array('N','Y'),
            ),
            'DATE_CREATE' => array(
                'data_type' => 'datetime',
            ),
            'DATE_UPDATE' => array(
                'data_type' => 'datetime',
            ),
            'INITIATED_BY_TYPE' => array(
                'data_type' => 'enum',
                'values' => [ self::INITIATED_BY_USER, self::INITIATED_BY_GROUP, self::INITIATED_BY_STRUCTURE ],
            ),
            'INITIATED_BY_USER_ID' => array(
                'data_type' => 'integer',
            ),
            'INITIATED_BY_USER' => array(
                'data_type' => 'Bitrix\Main\UserTable',
                'reference' => array('=this.INITIATED_BY_USER_ID' => 'ref.ID'),
            ),
            'MESSAGE' => array(
                'data_type' => 'text',
            ),
        );
    }

    public static function add(array $data)
    {
        throw new NotImplementedException("Use CSocNetUserToGroup class.");
    }

    public static function update($primary, array $data)
    {
        throw new NotImplementedException("Use CSocNetUserToGroup class.");
    }

    public static function delete($primary)
    {
        throw new NotImplementedException("Use CSocNetUserToGroup class.");
    }
 
    public static function getGroupModerators(int $groupId): array
    {
        $query = UserToGroupTable::query()
            ->setDistinct()
            ->setSelect(['USER_ID'])
            ->where('GROUP_ID', '=', $groupId)
            ->where('ROLE', '<=', UserToGroupTable::ROLE_MODERATOR)
            ->exec();
 
        return $query->fetchAll() ?? [];
    }
}