usertogroup.php

<?php
 
namespace Bitrix\Socialnetwork;
 
use Bitrix\Main\Entity;
use Bitrix\Main\ModuleManager;
use Bitrix\Main\NotImplementedException;
use Bitrix\Main\ORM\Query\Join;
 
class UserToGroupTable extends Entity\DataManager
{
    public const ROLE_OWNER = SONET_ROLES_OWNER;
    public const ROLE_MODERATOR = SONET_ROLES_MODERATOR;
    public const ROLE_USER = SONET_ROLES_USER;
    public const ROLE_BAN = SONET_ROLES_BAN;
    public const ROLE_REQUEST = SONET_ROLES_REQUEST;
 
    public const INITIATED_BY_USER = SONET_INITIATED_BY_USER;
    public const INITIATED_BY_GROUP = SONET_INITIATED_BY_GROUP;
 
    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 ];
    }
 
    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' => array(self::INITIATED_BY_USER, self::INITIATED_BY_GROUP),
            ),
            '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() ?? [];
    }
}