workgroup.php

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

<?php

namespace Bitrix\Socialnetwork\Helper;
 
use Bitrix\Main\AccessDeniedException;
use Bitrix\Main\Application;
use Bitrix\Main\ArgumentException;
use Bitrix\Main\Entity\Query;
use Bitrix\Main\Entity\ReferenceField;
use Bitrix\Main\NotImplementedException;
use Bitrix\Main\ObjectNotFoundException;
use Bitrix\Main\Config\Option;
use Bitrix\Main\DB\SqlExpression;
use Bitrix\Main\Loader;
use Bitrix\Main\Localization\Loc;
use Bitrix\Main\ModuleManager;
use Bitrix\Main\ORM\Query\Join;
use Bitrix\Main\SystemException;
use Bitrix\Socialnetwork\Collab\CollabFeature;
use Bitrix\Socialnetwork\EO_WorkgroupPin;
use Bitrix\Socialnetwork\FeatureTable;
use Bitrix\Socialnetwork\FeaturePermTable;
use Bitrix\Socialnetwork\Integration\Intranet\Settings;
use Bitrix\Socialnetwork\Integration\Pull\PushService;
use Bitrix\Socialnetwork\Integration\Pull;
use Bitrix\Socialnetwork\WorkgroupPinTable;
use Bitrix\Socialnetwork\WorkgroupTable;
use Bitrix\Socialnetwork\UserToGroupTable;
use Bitrix\Socialnetwork\Item;
use Bitrix\Socialnetwork\Helper;
 
class Workgroup
{
    public static function isUsersHaveCommonGroups(int $userId, int $targetUserId, bool $includeInvited = false): bool
    {
        $roles = UserToGroupTable::getRolesMember();
        if ($includeInvited)
        {
            $roles[] = UserToGroupTable::ROLE_REQUEST;
        }
 
        $selfJoin = (new ReferenceField(
            'TARGET',
            UserToGroupTable::getEntity(),
            Join::on('this.GROUP_ID', 'ref.GROUP_ID')
                ->where('ref.USER_ID', $targetUserId)
                ->whereIn('ref.ROLE', $roles)
        ))->configureJoinType(Join::TYPE_INNER);
 
        $query = UserToGroupTable::query()
            ->setSelect([Query::expr('CNT')->count('ID')])
            ->registerRuntimeField($selfJoin)
            ->where('USER_ID', $userId)
            ->whereIn('ROLE', $roles);
 
        $result = $query->exec()->fetch();
        $count = (int)$result['CNT'];
 
        return $count > 0;
    }
 
    public static function getSprintDurationList(): array
    {
        static $result = null;
 
        if ($result === null)
        {
            $oneWeek = \DateInterval::createFromDateString('1 week')->format('%d') * 86400;
            $twoWeek = \DateInterval::createFromDateString('2 weeks')->format('%d') * 86400;
            $threeWeek = \DateInterval::createFromDateString('3 weeks')->format('%d') * 86400;
            $fourWeek = \DateInterval::createFromDateString('4 weeks')->format('%d') * 86400;
 
            $result = [
                $oneWeek => [
                    'TITLE' => Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_TYPE_PROJECT_SCRUM_SPRINT_DURATION_ONE_WEEK'),
                ],
                $twoWeek => [
                    'TITLE' => Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_TYPE_PROJECT_SCRUM_SPRINT_DURATION_TWO_WEEK'),
                    'DEFAULT' => true,
                ],
                $threeWeek => [
                    'TITLE' => Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_TYPE_PROJECT_SCRUM_SPRINT_DURATION_THREE_WEEK'),
                ],
                $fourWeek => [
                    'TITLE' => Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_TYPE_PROJECT_SCRUM_SPRINT_DURATION_FOUR_WEEK'),
                ],
            ];
        }
 
        return $result;
    }
 
    public static function getSprintDurationValues(): array
    {
        $list = static::getSprintDurationList();
 
        $result = [];
        foreach ($list as $key => $item)
        {
            $result[$key] = $item['TITLE'];
        }
 
        return $result;
    }
 
    public static function getSprintDurationDefaultKey()
    {
        $list = static::getSprintDurationList();
        $result = array_key_first($list);
        foreach ($list as $key => $item)
        {
            if (
                isset($item['DEFAULT'])
                && $item['DEFAULT'] === true
            )
            {
                $result = $key;
                break;
            }
        }
 
        return $result;
    }
 
    public static function getScrumTaskResponsibleList(): array
    {
        return [
            'A' => Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_TYPE_PROJECT_SCRUM_TASK_RESPONSIBLE_AUTHOR'),
            'M' => Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_TYPE_PROJECT_SCRUM_TASK_RESPONSIBLE_MASTER'),
        ];
    }
 
    public static function getTypeCodeByParams($params)
    {
        $result = false;
 
        if (empty($params['fields']))
        {
            return $result;
        }
 
        $typesList = (
            !empty($params['typesList'])
                ? $params['typesList']
                : self::getTypes($params)
        );
 
        foreach ($typesList as $code => $type)
        {
            if (
                (
                    !isset($params['fields']['OPENED'])
                    || $params['fields']['OPENED'] === $type['OPENED']
                )
                && (
                    !isset($params['fields']['VISIBLE'])
                    || $params['fields']['VISIBLE'] === $type['VISIBLE']
                )
                && $params['fields']['PROJECT'] === $type['PROJECT']
                && $params['fields']['EXTERNAL'] === $type['EXTERNAL']
                && (
                    !isset($params['fields']['SCRUM_PROJECT'])
                    || (
                        isset($type['SCRUM_PROJECT'])
                        && $params['fields']['SCRUM_PROJECT'] === $type['SCRUM_PROJECT']
                    )
                )
            )
            {
                $result = $code;
                break;
            }
        }
 
        return $result;
    }
 
    public static function getProjectTypeCodeByParams($params)
    {
        $result = false;
 
        if (empty($params['fields']))
        {
            return $result;
        }
 
        $typesList = (
            !empty($params['typesList'])
                ? $params['typesList']
                : static::getProjectPresets($params)
        );
 
        foreach ($typesList as $code => $type)
        {
            if (
                ($params['fields']['PROJECT'] ?? '') === ($type['PROJECT'] ?? '')
                && $params['fields']['SCRUM_PROJECT'] === $type['SCRUM_PROJECT']
            )
            {
                $result = $code;
                break;
            }
        }
 
        return $result;
    }
 
    public static function getConfidentialityTypeCodeByParams($params)
    {
        $result = false;
 
        if (empty($params['fields']))
        {
            return $result;
        }
 
        $typesList = (
            !empty($params['typesList'])
                ? $params['typesList']
                : self::getConfidentialityPresets($params)
        );
 
        foreach ($typesList as $code => $type)
        {
            if (
                ($params['fields']['OPENED'] ?? '') === ($type['OPENED'] ?? '')
                && (
                    isset($params['fields']['VISIBLE'])
                    && $params['fields']['VISIBLE'] === $type['VISIBLE']
                )
                && ($params['fields']['PROJECT'] ?? '') === ($type['PROJECT'] ?? '')
            )
            {
                $result = $code;
                break;
            }
        }
 
        return $result;
    }
 
    public static function getTypeByCode($params = [])
    {
        $result = false;
 
        if (
            !is_array($params)
            || empty($params['code'])
        )
        {
            return $result;
        }
 
        $code = $params['code'];
        $typesList = (
            !empty($params['typesList'])
                ? $params['typesList']
                : self::getTypes($params)
        );
 
        if (
            !empty($typesList)
            && is_array($typesList)
            && !empty($typesList[$code])
        )
        {
            $result = $typesList[$code];
        }
 
        return $result;
    }
 
    public static function getEditFeaturesAvailability()
    {
        static $result = null;
 
        if ($result !== null)
        {
            return $result;
        }
 
        $result = true;
 
        if (!ModuleManager::isModuleInstalled('bitrix24'))
        {
            return $result;
        }
 
        if (\CBitrix24::isNfrLicense())
        {
            return $result;
        }
 
        if (\CBitrix24::isDemoLicense())
        {
            return $result;
        }
 
        if (
            \CBitrix24::getLicenseType() !== 'project'
            || !Option::get('socialnetwork', 'demo_edit_features', false)
        )
        {
            return $result;
        }
 
        $result = false; // static!
 
        return $result;
    }

    public static function getByFeatureOperation(array $params = []): array
    {
        global $USER, $CACHE_MANAGER;
 
        $result = [];
 
        $feature = (string)($params['feature'] ?? '');
        $operation = (string)($params['operation'] ?? '');
        $userId = (int)(
            isset($params['userId'])
                ? (int)$params['userId']
                : (is_object($USER) && $USER instanceof \CUser ? $USER->getId() : 0)
        );
 
        if (
            $feature === ''
            || $operation === ''
            || $userId <= 0
        )
        {
            return $result;
        }
 
        $isIntranet = \Bitrix\Socialnetwork\Integration\Intranet\User::isIntranet($userId) ? 'Y' : 'N';
 
        $featuresSettings = \CSocNetAllowed::getAllowedFeatures();
        if (
            empty($featuresSettings)
            || empty($featuresSettings[$feature])
            || empty($featuresSettings[$feature]['allowed'])
            || empty($featuresSettings[$feature]['operations'])
            || empty($featuresSettings[$feature]['operations'][$operation])
            || empty($featuresSettings[$feature]['operations'][$operation][FeatureTable::FEATURE_ENTITY_TYPE_GROUP])
            || !in_array(FeatureTable::FEATURE_ENTITY_TYPE_GROUP, $featuresSettings[$feature]['allowed'], true)
        )
        {
            return $result;
        }
 
        $cacheTTL = 3600 * 24 * 30;
        $cacheDir = '/sonet/features_perms_v3/' . FeatureTable::FEATURE_ENTITY_TYPE_GROUP . '/list/' . $userId;
        $cacheId = implode(' ', [ 'entities_list', $feature, $operation, $userId ]);
 
        $cache = new \CPHPCache();
        if ($cache->initCache($cacheTTL, $cacheId, $cacheDir))
        {
            $cacheValue = $cache->getVars();
            if (is_array($cacheValue))
            {
                $result = $cacheValue;
            }
        }
        else
        {
            $cache->startDataCache();
            $CACHE_MANAGER->startTagCache($cacheDir);
 
            $CACHE_MANAGER->registerTag('sonet_group');
            $CACHE_MANAGER->registerTag('sonet_features');
            $CACHE_MANAGER->registerTag('sonet_features2perms');
            $CACHE_MANAGER->registerTag('sonet_user2group');
 
            $defaultRole = $featuresSettings[$feature]['operations'][$operation][FeatureTable::FEATURE_ENTITY_TYPE_GROUP];
 
            $query = new \Bitrix\Main\Entity\Query(WorkgroupTable::getEntity());
            $query->addFilter('=ACTIVE', 'Y');
 
            if (
                (
                    !is_array($featuresSettings[$feature]['minoperation'])
                    || !in_array($operation, $featuresSettings[$feature]['minoperation'], true)
                )
                && Option::get('socialnetwork', 'work_with_closed_groups', 'N') !== 'Y'
            )
            {
                $query->addFilter('!=CLOSED', 'Y');
            }
 
            if (\Bitrix\Socialnetwork\Integration\Extranet\User::isCollaber($userId))
            {
                $query->where('TYPE', Item\Workgroup\Type::Collab->value);
            }
 
            $query->addSelect('ID');
 
            $query->registerRuntimeField(
                '',
                new \Bitrix\Main\Entity\ReferenceField('F',
                    FeatureTable::getEntity(),
                    [
                        '=ref.ENTITY_TYPE' => new SqlExpression('?s', FeatureTable::FEATURE_ENTITY_TYPE_GROUP),
                        '=ref.ENTITY_ID' => 'this.ID',
                        '=ref.FEATURE' => new SqlExpression('?s', $feature),
                    ],
                    [ 'join_type' => 'LEFT' ]
                )
            );
            $query->addSelect('F.ID', 'FEATURE_ID');
 
            $query->registerRuntimeField(
                '',
                new \Bitrix\Main\Entity\ReferenceField('FP',
                    FeaturePermTable::getEntity(),
                    [
                        '=ref.FEATURE_ID' => 'this.FEATURE_ID',
                        '=ref.OPERATION_ID' => new SqlExpression('?s', $operation),
                    ],
                    [ 'join_type' => 'LEFT' ]
                )
            );
 
            $query->registerRuntimeField(new \Bitrix\Main\Entity\ExpressionField(
                'PERM_ROLE_CALCULATED',
                'COALESCE(%s, \''.$defaultRole.'\')',
                [ 'FP.ROLE', 'FP.ROLE' ]
            ));
 
            $query->registerRuntimeField(
                '',
                new \Bitrix\Main\Entity\ReferenceField('UG',
                    UserToGroupTable::getEntity(),
                    [
                        '=ref.GROUP_ID' => 'this.ID',
                        '=ref.USER_ID' => new SqlExpression($userId),
                    ],
                    [ 'join_type' => 'LEFT' ]
                )
            );
 
            $query->registerRuntimeField(new \Bitrix\Main\Entity\ExpressionField(
                'HAS_ACCESS',
                '
                CASE
                    WHEN
                    (
                        COALESCE(%s, \''. FeaturePermTable::PERM_USER . '\') != \''. FeaturePermTable::PERM_EMPLOYEE . '\' AND
                        (
                            %s NOT IN (\''.FeaturePermTable::PERM_OWNER.'\', \''.FeaturePermTable::PERM_MODERATOR.'\', \''.FeaturePermTable::PERM_USER.'\')
                            OR %s >= %s
                        )
                    ) THEN \'Y\'
                    WHEN
                    (
                        COALESCE(%s, \''. FeaturePermTable::PERM_USER . '\') = \''. FeaturePermTable::PERM_EMPLOYEE . '\'
                        AND 
                        (
                            %s <= \''. FeaturePermTable::PERM_USER . '\'
                        )
                        AND \''. $isIntranet . '\' = \'Y\'
                    )
                    THEN \'Y\'
                    ELSE \'N\'
                END',
                [
                    'FP.ROLE',
                    'PERM_ROLE_CALCULATED',
                    'PERM_ROLE_CALCULATED', 'UG.ROLE',
                    'FP.ROLE',
                    'UG.ROLE',
                ]
            ));
 
            $query->addFilter('=HAS_ACCESS', 'Y');
 
            $res = $query->exec();
 
            while ($row = $res->fetch())
            {
                $result[] = [
                    'ID' => (int) $row['ID'],
                ];
            }
 
            $CACHE_MANAGER->endTagCache();
            $cache->endDataCache($result);
        }
 
        return $result;
    }
 
    public static function checkAnyOpened(array $idList = []): bool
    {
        if (empty($idList))
        {
            return false;
        }
 
        $res = WorkgroupTable::getList([
            'filter' => [
                '@ID' => $idList,
                '=OPENED' => 'Y',
                '=VISIBLE' => 'Y',
            ],
            'select' => [ 'ID' ],
            'limit' => 1,
        ]);
        if ($res->fetch())
        {
            return true;
        }
 
        return false;
    }
 
    public static function getPermissions(array $params = []): array
    {
        global $USER, $APPLICATION;
 
        static $result = [];
 
        $userId = (int)($params['userId'] ?? (is_object($USER) ? $USER->getId() : 0));
        $groupId = (int)($params['groupId'] ?? 0);
        if ($groupId <= 0)
        {
            $APPLICATION->throwException('Empty workgroup Id', 'SONET_HELPER_WORKGROUP_EMPTY_GROUP');
        }
 
        if (
            empty($result[$userId] ?? null)
            || !($result[$userId][$groupId] ?? null)
        )
        {
            $group = Item\Workgroup::getById($groupId);
            if (!$group)
            {
                return self::getEmptyPermissions();
            }
            $groupFields = $group->getFields();
            if (empty($groupFields))
            {
                return self::getEmptyPermissions();
            }
 
            $result[$userId][$groupId] = \CSocNetUserToGroup::initUserPerms(
                $userId,
                $groupFields,
                \CSocNetUser::isCurrentUserModuleAdmin(),
            );
        }
 
        if (is_array($result[$userId][$groupId]))
        {
            return $result[$userId][$groupId];
        }
 
        return self::getEmptyPermissions();
    }
 
    public static function getEmptyPermissions(): array
    {
        return [
            'Operations' => false,
            'UserRole' => false,
            'UserIsMember' => false,
            'UserIsAutoMember' => false,
            'InitiatedByType' => false,
            'InitiatedByUserId' => false,
            'UserIsOwner' => false,
            'UserIsScrumMaster' => false,
            'UserCanInitiate' => false,
            'UserCanProcessRequestsIn' => false,
            'UserCanViewGroup' => false,
            'UserCanAutoJoinGroup' => false,
            'UserCanModifyGroup' => false,
            'UserCanModerateGroup' => false,
            'UserCanSpamGroup' => false,
        ];
    }
 
    public static function isGroupCopyFeatureEnabled(): bool
    {
        $isB24Installed = ModuleManager::isModuleInstalled('bitrix24') && Loader::includeModule('bitrix24');
        
        if (!$isB24Installed)
        {
            return true;
        }
        
        return Feature::isFeatureEnabled(Feature::PROJECTS_COPY);
    }
 
    public static function isProjectAccessFeatureEnabled(): bool
    {
        $isB24Installed = ModuleManager::isModuleInstalled('bitrix24') && Loader::includeModule('bitrix24');
 
        if (!$isB24Installed)
        {
            return true;
        }
 
        return Feature::isFeatureEnabled(Feature::PROJECTS_ACCESS_PERMISSIONS);
    }
 
    public static function setArchive(array $fields = []): bool
    {
        global $APPLICATION;
 
        if (!isset($fields['archive']))
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED'));
        }
 
        $groupId = (int)($fields['groupId'] ?? 0);
        $archive = (bool)$fields['archive'];
        $currentUserId = User::getCurrentUserId();
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        $filter = [
            'ID' => $groupId,
        ];
 
        $isCurrentUserAdmin = static::isCurrentUserModuleAdmin();
 
        if (!$isCurrentUserAdmin)
        {
            $filter['CHECK_PERMISSIONS'] = $currentUserId;
        }
 
        $res = \CSocNetGroup::getList([], $filter);
        if (!($groupFields = $res->fetch()))
        {
            throw new ObjectNotFoundException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_GROUP_NO_FOUND'));
        }
 
        if (!Helper\Workgroup\Access::canModify([
            'groupId' => $groupId,
        ]))
        {
            throw new AccessDeniedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_NO_PERMS'));
        }
 
        if (!\CSocNetGroup::update($groupId, [ 'CLOSED' => ($archive ? 'Y' : 'N') ], false, true, false))
        {
            if ($ex = $APPLICATION->getException())
            {
                $errorMessage = $ex->getString();
                $errorCode = $ex->getId();
            }
            else
            {
                $errorMessage = Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED');
                $errorCode = 100;
            }
 
            throw new SystemException($errorMessage, $errorCode);
        }
 
        return true;
    }
 
    public static function setOwner(array $fields = []): bool
    {
        global $APPLICATION;
 
        $groupId = (int) ($fields['groupId'] ?? 0);
        $newOwnerId = (int) ($fields['userId'] ?? 0);
        $currentUserId = User::getCurrentUserId();
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if ($newOwnerId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_USER_ID'));
        }
 
        $filter = [
            'ID' => $groupId,
        ];
 
        $isCurrentUserAdmin = static::isCurrentUserModuleAdmin();
 
        if (!$isCurrentUserAdmin)
        {
            $filter['CHECK_PERMISSIONS'] = $currentUserId;
        }
 
        $res = \CSocNetGroup::getList([], $filter);
        if (!($groupFields = $res->fetch()))
        {
            throw new ObjectNotFoundException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_GROUP_NO_FOUND'));
        }
 
        $groupPerms = static::getPermissions([
            'groupId' => $groupId,
        ]);
 
        if (!$groupPerms['UserCanModifyGroup'])
        {
            throw new AccessDeniedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_NO_PERMS'));
        }
 
        if (!\CSocNetUserToGroup::setOwner($newOwnerId, $groupFields['ID'], $groupFields))
        {
            if ($ex = $APPLICATION->getException())
            {
                $errorMessage = $ex->getString();
            }
            else
            {
                $errorMessage = Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED');
            }
 
            throw new \Exception($errorMessage, 100);
        }
 
        return true;
    }
 
    public static function setScrumMaster(array $fields = []): bool
    {
        $groupId = (int)($fields['groupId'] ?? 0);
        $newScrumMasterId = (int)($fields['userId'] ?? 0);
        $currentUserId = User::getCurrentUserId();
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if ($newScrumMasterId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_USER_ID'));
        }
 
        if (!Helper\Workgroup\Access::canSetScrumMaster([
            'userId' => $newScrumMasterId,
            'groupId' => $groupId,
        ]))
        {
            throw new AccessDeniedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_NO_PERMS'));
        }
 
        if (!\CSocNetGroup::Update($groupId, [
            'SCRUM_MASTER_ID' => $newScrumMasterId,
        ]))
        {
            throw new \Exception(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED'), 100);
        }
 
        $relation = UserToGroupTable::getList([
            'filter' => [
                'USER_ID' => $newScrumMasterId,
                'GROUP_ID' => $groupId,
            ],
            'select' => [ 'ID', 'ROLE' ],
        ])->fetchObject();
 
        if ($relation)
        {
            if (
                !in_array($relation->getRole(), [UserToGroupTable::ROLE_OWNER, UserToGroupTable::ROLE_MODERATOR], true)
                && !\CSocNetUserToGroup::Update($relation->getId(), [
                    'ROLE' => UserToGroupTable::ROLE_MODERATOR,
                ])
            )
            {
                throw new \Exception(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED'), 100);
            }
        }
        else
        {
            static $helper = null;
            if (!$helper)
            {
                $connection = Application::getConnection();
                $helper = $connection->getSqlHelper();
            }
 
            if (!\CSocNetUserToGroup::Add([
                'AUTO_MEMBER' => 'N',
                'USER_ID' => $newScrumMasterId,
                'GROUP_ID' => $groupId,
                'ROLE' => UserToGroupTable::ROLE_MODERATOR,
                'INITIATED_BY_TYPE' => UserToGroupTable::INITIATED_BY_GROUP,
                'INITIATED_BY_USER_ID' => $currentUserId,
                '=DATE_CREATE' => $helper->getCurrentDateTimeFunction(),
                '=DATE_UPDATE' => $helper->getCurrentDateTimeFunction(),
            ]))
            {
                throw new \RuntimeException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED'), 100);
            }
        }
 
        return true;
    }
 
    public static function setModerator(array $fields = []): bool
    {
        global $APPLICATION;
 
        $groupId = (int)($fields['groupId'] ?? 0);
        $userId = (int)($fields['userId'] ?? 0);
        $currentUserId = User::getCurrentUserId();
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if ($userId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_USER_ID'));
        }
 
        try
        {
            $relation = static::getRelation([
                '=GROUP_ID' => $groupId,
                '=USER_ID' => $userId,
            ]);
        }
        catch (\Exception $e)
        {
            throw new \Exception($e->getMessage(), $e->getCode());
        }
 
        if (!Helper\Workgroup\Access::canSetModerator([
            'userId' => $userId,
            'groupId' => $groupId,
        ]))
        {
            throw new AccessDeniedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_NO_PERMS'));
        }
 
        if (!\CSocNetUserToGroup::transferMember2Moderator(
            $currentUserId,
            $groupId,
            [ $relation->getId() ]
        ))
        {
            if ($ex = $APPLICATION->getException())
            {
                $errorMessage = $ex->getString();
            }
            else
            {
                $errorMessage = Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED');
            }
 
            throw new \Exception($errorMessage, 100);
        }
 
        return true;
    }
 
    public static function removeModerator(array $fields = []): bool
    {
        global $APPLICATION;
 
        $groupId = (int)($fields['groupId'] ?? 0);
        $userId = (int)($fields['userId'] ?? 0);
        $currentUserId = User::getCurrentUserId();
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if ($userId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_USER_ID'));
        }
 
        try
        {
            $relation = static::getRelation([
                '=GROUP_ID' => $groupId,
                '=USER_ID' => $userId,
            ]);
        }
        catch (\Exception $e)
        {
            throw new \Exception($e->getMessage(), $e->getCode());
        }
 
        if (!Helper\Workgroup\Access::canRemoveModerator([
            'userId' => $userId,
            'groupId' => $groupId,
        ]))
        {
            throw new AccessDeniedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_NO_PERMS'));
        }
 
        if (!\CSocNetUserToGroup::TransferModerator2Member(
            $currentUserId,
            $groupId,
            [ $relation->getId() ]
        ))
        {
            if ($ex = $APPLICATION->getException())
            {
                $errorMessage = $ex->getString();
            }
            else
            {
                $errorMessage = Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED');
            }
 
            throw new \Exception($errorMessage, 100);
        }
 
        return true;
    }
 
    public static function setModerators(array $fields = []): bool
    {
        $groupId = (int)($fields['groupId'] ?? 0);
        $userIds = array_map('intval', array_filter($fields['userIds'] ?? []));
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        $currentUserId = User::getCurrentUserId();
        $isCurrentUserModuleAdmin = static::isCurrentUserModuleAdmin();
 
        $groupPerms = static::getPermissions(['groupId' => $groupId]);
        if (!$groupPerms || (!$groupPerms['UserCanModifyGroup'] && !$isCurrentUserModuleAdmin))
        {
            throw new AccessDeniedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_NO_PERMS'));
        }
 
        $currentModeratorRelations = static::getCurrentModeratorRelations($groupId);
        $moderatorsToAdd = array_diff($userIds, array_keys($currentModeratorRelations));
        $moderatorsToRemove = array_diff_key($currentModeratorRelations, array_fill_keys($userIds, true));
 
        if (!empty($moderatorsToRemove))
        {
            \CSocNetUserToGroup::TransferModerator2Member(
                $currentUserId,
                $groupId,
                $moderatorsToRemove
            );
        }
 
        if (!empty($moderatorsToAdd))
        {
            [$ownerRelations, $memberRelations, $otherRelations] = static::getUserRelations($groupId, $moderatorsToAdd);
 
            if (!empty($memberRelations))
            {
                \CSocNetUserToGroup::transferMember2Moderator(
                    $currentUserId,
                    $groupId,
                    $memberRelations
                );
            }
 
            $moderatorsToAdd = array_diff($moderatorsToAdd, array_keys($memberRelations), array_keys($ownerRelations));
            foreach ($moderatorsToAdd as $userId)
            {
                if (array_key_exists($userId, $otherRelations))
                {
                    $relationId = static::transferToModerators($otherRelations[$userId]);
                }
                else
                {
                    $relationId = static::addToModerators($userId, $groupId);
                }
 
                if ($relationId)
                {
                    static::sendNotifications($userId, $groupId, $relationId);
                }
            }
        }
 
        return true;
    }
 
    private static function getCurrentModeratorRelations(int $groupId): array
    {
        $currentModeratorRelations = [];
 
        $relationResult = UserToGroupTable::getList([
            'select' => ['ID', 'USER_ID'],
            'filter' => [
                'GROUP_ID' => $groupId,
                '=ROLE' => UserToGroupTable::ROLE_MODERATOR,
            ],
        ]);
        while ($relation = $relationResult->fetch())
        {
            $currentModeratorRelations[$relation['USER_ID']] = $relation['ID'];
        }
 
        return $currentModeratorRelations;
    }
 
    private static function getUserRelations(int $groupId, array $userIds): array
    {
        $ownerRelations = [];
        $memberRelations = [];
        $otherRelations = [];
 
        $relationResult = UserToGroupTable::getList([
            'select' => ['ID', 'USER_ID', 'ROLE'],
            'filter' => [
                'GROUP_ID' => $groupId,
                '@USER_ID' => $userIds,
            ],
        ]);
        while ($relation = $relationResult->fetch())
        {
            $id = $relation['ID'];
            $userId = $relation['USER_ID'];
 
            switch ($relation['ROLE'])
            {
                case UserToGroupTable::ROLE_OWNER:
                    $ownerRelations[$userId] = $id;
                    break;
 
                case UserToGroupTable::ROLE_USER:
                    $memberRelations[$userId] = $id;
                    break;
 
                default:
                    $otherRelations[$userId] = $id;
                    break;
            }
        }
 
        return [$ownerRelations, $memberRelations, $otherRelations];
    }
 
    private static function transferToModerators(int $relationId)
    {
        return \CSocNetUserToGroup::update(
            $relationId,
            [
                'ROLE' => UserToGroupTable::ROLE_MODERATOR,
                '=DATE_UPDATE' => \CDatabase::CurrentTimeFunction(),
            ]
        );
    }
 
    private static function addToModerators(int $userId, int $groupId)
    {
        return \CSocNetUserToGroup::add([
            'USER_ID' => $userId,
            'GROUP_ID' => $groupId,
            'ROLE' => UserToGroupTable::ROLE_MODERATOR,
            '=DATE_CREATE' => \CDatabase::CurrentTimeFunction(),
            '=DATE_UPDATE' => \CDatabase::CurrentTimeFunction(),
            'MESSAGE' => '',
            'INITIATED_BY_TYPE' => UserToGroupTable::INITIATED_BY_GROUP,
            'INITIATED_BY_USER_ID' => User::getCurrentUserId(),
            'SEND_MAIL' => 'N',
        ]);
    }
 
    private static function sendNotifications(int $userId, int $groupId, int $relationId): void
    {
        \CSocNetUserToGroup::notifyModeratorAdded([
            'userId' => User::getCurrentUserId(),
            'groupId' => $groupId,
            'relationId' => $relationId,
        ]);
        Item\UserToGroup::addInfoToChat([
            'group_id' => $groupId,
            'user_id' => $userId,
            'action' => Item\UserToGroup::CHAT_ACTION_IN,
            'sendMessage' => false,
            'role' => UserToGroupTable::ROLE_MODERATOR,
        ]);
    }
 
    public static function join(array $fields = []): bool
    {
        $groupId = (int)($fields['groupId'] ?? 0);
        $userId = (int)($fields['userId'] ?? User::getCurrentUserId());
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if ($userId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_USER_ID'));
        }
 
        if (!Helper\Workgroup\Access::canJoin([
            'userId' => $userId,
            'groupId' => $groupId,
        ]))
        {
            throw new AccessDeniedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_NO_PERMS'));
        }
 
        $relation = UserToGroupTable::getList([
            'filter' => [
                'USER_ID' => $userId,
                'GROUP_ID' => $groupId,
            ],
            'select' => [ 'ID', 'ROLE', 'INITIATED_BY_TYPE' ],
        ])->fetchObject();
 
        if (
            $relation
            && $relation->getRole() === UserToGroupTable::ROLE_REQUEST
            && $relation->getInitiatedByType() === UserToGroupTable::INITIATED_BY_GROUP
        )
        {
            if (!\CSocNetUserToGroup::userConfirmRequestToBeMember($userId, $relation->getId(), false))
            {
                throw new \RuntimeException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED'));
            }
 
            $confirmationNeeded = false;
        }
        else
        {
            $requestConfirmUrl = \CComponentEngine::MakePathFromTemplate(Path::get('group_requests_path_template'), [ 'group_id' => $groupId ]);
            if (!\CSocNetUserToGroup::sendRequestToBeMember($userId, $groupId, '', $requestConfirmUrl, false))
            {
                throw new \RuntimeException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED'));
            }
 
            $confirmationNeeded = !(WorkgroupTable::getList([
                'filter' => [
                    'ID' => $groupId,
                ],
                'select' => [ 'OPENED' ],
            ])->fetchObject()->getOpened());
        }
 
        return $confirmationNeeded;
    }
 
    public static function leave(array $fields = []): bool
    {
        $groupId = (int)($fields['groupId'] ?? 0);
        $userId = (int)($fields['userId'] ?? User::getCurrentUserId());
 
        if (!Helper\Workgroup\Access::canLeave([
            'userId' => $userId,
            'groupId' => $groupId,
        ]))
        {
            throw new AccessDeniedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_NO_PERMS'));
        }
 
        if (!\CSocNetUserToGroup::deleteRelation($userId, $groupId))
        {
            throw new \RuntimeException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED'));
        }
 
        return true;
    }
 
    public static function deleteOutgoingRequest(array $fields = []): bool
    {
        $groupId = (int)($fields['groupId'] ?? 0);
        $userId = (int)($fields['userId'] ?? 0);
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if ($userId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_USER_ID'));
        }
 
        try
        {
            $relation = static::getRelation([
                '=GROUP_ID' => $groupId,
                '=USER_ID' => $userId,
            ]);
        }
        catch (\Exception $e)
        {
            throw new \Exception($e->getMessage(), $e->getCode());
        }
 
        if (!Helper\Workgroup\Access::canDeleteOutgoingRequest([
            'userId' => $userId,
            'groupId' => $groupId,
        ]))
        {
            throw new AccessDeniedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_NO_PERMS'));
        }
 
        try
        {
            self::deleteRelation([
                'relationId' => $relation->getId(),
            ]);
        }
        catch (\Exception $e)
        {
            throw new \Exception($e->getMessage(), $e->getCode());
        }
 
        return true;
    }
 
    public static function deleteIncomingRequest(array $fields = []): bool
    {
        $groupId = (int)($fields['groupId'] ?? 0);
        $userId = (int)($fields['userId'] ?? 0);
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if ($userId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_USER_ID'));
        }
 
        try
        {
            $relation = static::getRelation([
                '=GROUP_ID' => $groupId,
                '=USER_ID' => $userId,
            ]);
        }
        catch (\Exception $e)
        {
            throw new \Exception($e->getMessage(), $e->getCode());
        }
 
        if (!Helper\Workgroup\Access::canDeleteIncomingRequest([
            'userId' => $userId,
            'groupId' => $groupId,
        ]))
        {
            throw new AccessDeniedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_NO_PERMS'));
        }
 
        try
        {
            self::deleteRelation([
                'relationId' => $relation->getId(),
            ]);
        }
        catch (\Exception $e)
        {
            throw new \Exception($e->getMessage(), $e->getCode());
        }
 
        return true;
    }
 
    public static function exclude(array $fields = []): bool
    {
        global $APPLICATION;
 
        $groupId = (int)($fields['groupId'] ?? 0);
        $userId = (int)($fields['userId'] ?? 0);
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if ($userId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_USER_ID'));
        }
 
        try
        {
            $relation = static::getRelation([
                '=GROUP_ID' => $groupId,
                '=USER_ID' => $userId,
            ]);
        }
        catch (\Exception $e)
        {
            throw new \Exception($e->getMessage(), $e->getCode());
        }
 
        if (!Helper\Workgroup\Access::canExclude([
            'userId' => $userId,
            'groupId' => $groupId,
        ]))
        {
            throw new AccessDeniedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_NO_PERMS'));
        }
 
        if (!\CSocNetUserToGroup::delete($relation->getId(), true))
        {
            if ($ex = $APPLICATION->getException())
            {
                $errorMessage = $ex->getString();
            }
            else
            {
                $errorMessage = Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED');
            }
 
            throw new \Exception($errorMessage, 100);
        }
 
        (new Pull\Unsubscribe())->resetByTags(
            (new Pull\Tag())->getTasksProjects($groupId),
            [$userId]
        );
 
        return true;
    }
 
    public static function deleteRelation(array $fields = []): bool
    {
        global $APPLICATION;
 
        $relationId = (int)($fields['relationId'] ?? 0);
 
        if ($relationId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_RELATION_ID'));
        }
 
        try
        {
            $relation = static::getRelation([
                '=ID' => $relationId,
            ]);
        }
        catch (\Exception $e)
        {
            throw new \Exception($e->getMessage(), $e->getCode());
        }
 
        if (!\CSocNetUserToGroup::delete($relation->getId()))
        {
            if ($ex = $APPLICATION->getException())
            {
                $errorMessage = $ex->getString();
            }
            else
            {
                $errorMessage = Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED');
            }
 
            throw new \Exception($errorMessage, 100);
        }
 
        return true;
    }
 
    public static function acceptIncomingRequest(array $fields = []): bool
    {
        global $APPLICATION;
 
        $groupId = (int)($fields['groupId'] ?? 0);
        $userId = (int)($fields['userId'] ?? 0);
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if ($userId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_USER_ID'));
        }
 
        try
        {
            $relation = static::getRelation([
                '=GROUP_ID' => $groupId,
                '=USER_ID' => $userId,
            ]);
        }
        catch (\Exception $e)
        {
            throw new \Exception($e->getMessage(), $e->getCode());
        }
 
        if (!Helper\Workgroup\Access::canProcessIncomingRequest([
            'userId' => $userId,
            'groupId' => $groupId,
        ]))
        {
            throw new AccessDeniedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_NO_PERMS'));
        }
 
        if (!\CSocNetUserToGroup::confirmRequestToBeMember(
            User::getCurrentUserId(),
            $groupId,
            [ $relation->getId() ]
        ))
        {
            if ($ex = $APPLICATION->getException())
            {
                $errorMessage = $ex->getString();
            }
            else
            {
                $errorMessage = Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED');
            }
 
            throw new \Exception($errorMessage, 100);
        }
 
        return true;
    }
 
    public static function acceptOutgoingRequest(array $fields = []): bool
    {
        global $APPLICATION;
 
        $groupId = (int) ($fields['groupId'] ?? 0);
        $userId = (int) ($fields['userId'] ?? 0);
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if ($userId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_USER_ID'));
        }
 
        try
        {
            $relation = static::getRelation([
                '=GROUP_ID' => $groupId,
                '=USER_ID' => $userId,
            ]);
        }
        catch (\Exception $e)
        {
            throw new \Exception($e->getMessage(), $e->getCode());
        }
 
        if (!\CSocNetUserToGroup::UserConfirmRequestToBeMember($userId, $relation->getId()))
        {
            if ($ex = $APPLICATION->getException())
            {
                $errorMessage = $ex->getString();
            }
            else
            {
                $errorMessage = Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED');
            }
 
            throw new \Exception($errorMessage, 100);
        }
 
        return true;
    }
 
    public static function rejectOutgoingRequest(array $fields = []): bool
    {
        global $APPLICATION;
 
        $groupId = (int) ($fields['groupId'] ?? 0);
        $userId = (int) ($fields['userId'] ?? 0);
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if ($userId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_USER_ID'));
        }
 
        try
        {
            $relation = static::getRelation([
                '=GROUP_ID' => $groupId,
                '=USER_ID' => $userId,
            ]);
        }
        catch (\Exception $e)
        {
            throw new \Exception($e->getMessage(), $e->getCode());
        }
 
        if (!\CSocNetUserToGroup::userRejectRequestToBeMember($userId, $relation->getId()))
        {
            if ($ex = $APPLICATION->getException())
            {
                $errorMessage = $ex->getString();
            }
            else
            {
                $errorMessage = Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED');
            }
 
            throw new \Exception($errorMessage, 100);
        }
 
        return true;
    }
 
    public static function rejectIncomingRequest(array $fields = []): bool
    {
        global $APPLICATION;
 
        $groupId = (int)($fields['groupId'] ?? 0);
        $userId = (int)($fields['userId'] ?? 0);
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if ($userId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_USER_ID'));
        }
 
        try
        {
            $relation = static::getRelation([
                '=GROUP_ID' => $groupId,
                '=USER_ID' => $userId,
            ]);
        }
        catch (\Exception $e)
        {
            throw new \Exception($e->getMessage(), $e->getCode());
        }
 
        if (!Helper\Workgroup\Access::canProcessIncomingRequest([
            'userId' => $userId,
            'groupId' => $groupId,
        ]))
        {
            throw new AccessDeniedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_NO_PERMS'));
        }
 
        if (!\CSocNetUserToGroup::rejectRequestToBeMember(
            User::getCurrentUserId(),
            $groupId,
            [ $relation->getId() ]
        ))
        {
            if ($ex = $APPLICATION->getException())
            {
                $errorMessage = $ex->getString();
            }
            else
            {
                $errorMessage = Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED');
            }
 
            throw new \Exception($errorMessage, 100);
        }
 
        return true;
    }
 
    public static function disconnectDepartment(array $fields = []): bool
    {
        global $APPLICATION;
 
        $departmentId = (int)($fields['departmentId'] ?? 0);
        $groupId = (int)($fields['groupId'] ?? 0);
 
        if ($groupId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if ($departmentId <= 0)
        {
            throw new ArgumentException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_DEPARTMENT_ID'));
        }
 
        if (!ModuleManager::isModuleInstalled('intranet'))
        {
            throw new NotImplementedException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED'));
        }
 
        $workgroup = Item\Workgroup::getById($groupId);
        if (!$workgroup)
        {
            throw new ObjectNotFoundException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_WRONG_GROUP_ID'));
        }
 
        if (!isset($workgroup->getFields()['UF_SG_DEPT']))
        {
            throw new \Exception(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED'));
        }
 
        $workgroupFields = $workgroup->getFields();
        $currentDepartmentsList = $workgroupFields['UF_SG_DEPT']['VALUE'];
 
        if (
            !is_array($currentDepartmentsList)
            || empty($currentDepartmentsList)
        )
        {
            throw new \Exception(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED'));
        }
 
        $currentDepartmentsList = array_map('intval', array_unique($currentDepartmentsList));
 
        if (!\CSocNetGroup::update(
            $groupId,
            [
                'NAME' => $workgroupFields['NAME'],
                'UF_SG_DEPT' => array_diff($currentDepartmentsList, [ $departmentId ]),
            ]
        ))
        {
            if ($ex = $APPLICATION->getException())
            {
                $errorMessage = $ex->getString();
            }
            else
            {
                $errorMessage = Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_OPERATION_FAILED');
            }
 
            throw new \Exception($errorMessage, 100);
        }
 
        return true;
    }
 
    protected static function getRelation(array $filter = []): \Bitrix\Socialnetwork\EO_UserToGroup
    {
        $res = UserToGroupTable::getList([
            'filter' => $filter,
            'select' => [ 'ID', 'USER_ID', 'GROUP_ID', 'ROLE', 'INITIATED_BY_TYPE', 'INITIATED_BY_USER_ID', 'AUTO_MEMBER' ],
        ]);
 
        if (!$result = $res->fetchObject())
        {
            throw new ObjectNotFoundException(Loc::getMessage('SOCIALNETWORK_HELPER_WORKGROUP_ERROR_RELATION_NOT_FOUND'));
        }
 
        return $result;
    }

    public static function canCreate(array $params = []): bool
    {
        return Helper\Workgroup\Access::canCreate($params);
    }
 
    public static function isCurrentUserModuleAdmin(bool $checkSession = false): bool
    {
        $result = null;
        if ($result === null)
        {
            $result = \CSocNetUser::isCurrentUserModuleAdmin(SITE_ID, $checkSession);
        }
 
        return $result;
    }

    public static function getCurrentUserId(): int
    {
        return User::getCurrentUserId();
    }
 
    public static function getProjectPresets($params = []): array
    {
        static $useProjects = null;
        static $extranetInstalled = null;
 
        if ($extranetInstalled === null)
        {
            $extranetInstalled = self::isExtranetInstalled();
        }
 
        $entityOptions = [];
        if (!empty($params['entityOptions']) && is_array($params['entityOptions']))
        {
            $entityOptions = $params['entityOptions'];
        }
 
        $result = [];
        $sort = 0;
 
        if ($useProjects === null)
        {
            $useProjects = (
                ModuleManager::isModuleInstalled('intranet')
                && self::checkEntityOption([ 'project' ], $entityOptions)
            );
        }
 
        if ($useProjects)
        {
            if (self::checkEntityOption([ '!landing', '!scrum' ], $entityOptions))
            {
                $result['project'] = [
                    'SORT' => $sort += 10,
                    'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_PROJECT_PRESET_PROJECT'),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_PROJECT_PRESET_PROJECT_DESC'),
                    'VISIBLE' => 'Y',
                    'OPENED' => 'Y',
                    'PROJECT' => 'Y',
                    'SCRUM_PROJECT' => 'N',
                    'EXTERNAL' => 'N',
                ];
            }
 
            if (self::checkEntityOption([ 'scrum', '!extranet', '!landing' ], $entityOptions))
            {
                $result['scrum'] = [
                    'SORT' => $sort += 10,
                    'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_PROJECT_PRESET_SCRUM'),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_PROJECT_PRESET_SCRUM_DESC'),
                    'VISIBLE' => 'N',
                    'OPENED' => 'N',
                    'PROJECT' => 'Y',
                    'SCRUM_PROJECT' => 'Y',
                    'EXTERNAL' => 'N',
                ];
            }
        }
 
        if (self::checkEntityOption([ '!scrum' ], $entityOptions))
        {
            if (self::checkEntityOption(['!landing', '!flow'], $entityOptions))
            {
                $result['collab'] = [
                    'SORT' => $sort += 10,
                    'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_PROJECT_PRESET_COLLAB'),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_PROJECT_PRESET_COLLAB_DESC'),
                    'VISIBLE' => 'Y',
                    'OPENED' => 'Y',
                    'PROJECT' => 'N',
                    'SCRUM_PROJECT' => 'N',
                    'EXTERNAL' => 'Y',
                ];
 
                if (!CollabFeature::isFeatureEnabledInPortalSettings())
                {
                    $result['collab']['LIMIT_FEATURE'] = Settings::LIMIT_FEATURES['collab'];
                }
            }
 
            $result['group'] = [
                'SORT' => $sort += 10,
                'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_PROJECT_PRESET_GROUP'),
                'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_PROJECT_PRESET_GROUP_DESC'),
                'VISIBLE' => 'Y',
                'OPENED' => 'Y',
                'PROJECT' => 'N',
                'SCRUM_PROJECT' => 'N',
                'EXTERNAL' => 'N',
            ];
        }
 
        return $result;
    }
 
    public static function getConfidentialityPresets(array $params = []): array
    {
        static $useProjects = null;
 
        $currentExtranetSite = (
            !empty($params)
            && isset($params['currentExtranetSite'])
            && $params['currentExtranetSite']
        );
 
        $entityOptions = (
            !empty($params['entityOptions'])
            && is_array($params['entityOptions'])
                ? $params['entityOptions']
                : []
        );
 
        $result = [];
        $sort = 0;
 
        if ($useProjects === null)
        {
            $useProjects = (
                ModuleManager::isModuleInstalled('intranet')
                && self::checkEntityOption([ 'project' ], $entityOptions)
            );
        }
 
        if (!$currentExtranetSite)
        {
            if (self::checkEntityOption([ 'open', '!extranet', '!landing' ], $entityOptions))
            {
                $result['open'] = [
                    'SORT' => $sort += 10,
                    'NAME' => ($useProjects ? Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_OPEN') : Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_OPEN')),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_OPEN_DESC3'),
                    'VISIBLE' => 'Y',
                    'OPENED' => 'Y',
                    'EXTERNAL' => 'N',
                ];
            }
 
            if (self::checkEntityOption([ '!open', '!extranet', '!landing' ], $entityOptions))
            {
                $result['closed'] = [
                    'SORT' => $sort += 10,
                    'NAME' => ($useProjects ? Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_CLOSED') : Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_CLOSED')),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_CLOSED_DESC3'),
                    'VISIBLE' => 'Y',
                    'OPENED' => 'N',
                    'EXTERNAL' => 'N',
                ];
            }
 
            if (self::checkEntityOption([ '!open', '!extranet', '!landing' ], $entityOptions))
            {
                $result['secret'] = [
                    'SORT' => $sort += 10,
                    'NAME' => ($useProjects ?
                        Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_SECRET_1')
                        : Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_SECRET_1')
                    ),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_SECRET_DESC3_1'),
                    'VISIBLE' => 'N',
                    'OPENED' => 'N',
                    'EXTERNAL' => 'N',
                ];
            }
        }
 
        return $result;
    }
 
    protected static function checkEntityOption(array $keysList = [], array $entityOptions = []): bool
    {
        $result = true;
 
        foreach ($keysList as $key)
        {
            if (
                !empty($entityOptions)
                && (
                    (
                        isset($entityOptions[$key])
                        && !$entityOptions[$key]
                    )
                    || (
                        preg_match('/^\!(\w+)$/', $key, $matches)
                        && isset($entityOptions[$matches[1]])
                        && $entityOptions[$matches[1]]
                    )
                )
            )
            {
                $result = false;
                break;
            }
        }
 
        return $result;
    }
 
    public static function getPresets($params = []): array
    {
        static $useProjects = null;
        static $extranetInstalled = null;
        static $landingInstalled = null;
 
        if ($extranetInstalled === null)
        {
            $extranetInstalled = self::isExtranetInstalled();
        }
 
        if ($landingInstalled === null)
        {
            $landingInstalled = ModuleManager::isModuleInstalled('landing');
        }
 
        $currentExtranetSite = (
            !empty($params)
            && isset($params['currentExtranetSite'])
            && $params['currentExtranetSite']
        );
 
        $entityOptions = (
            !empty($params)
            && is_array($params['entityOptions'])
            && !empty($params['entityOptions'])
                ? $params['entityOptions']
                : []
        );
 
        $fullMode = (
            !empty($params)
            && isset($params['fullMode'])
            && $params['fullMode']
        );
 
        $result = [];
        $sort = 0;
 
        if ($useProjects === null)
        {
            $useProjects = (
                ModuleManager::isModuleInstalled('intranet')
                && self::checkEntityOption([ 'project' ], $entityOptions)
            );
        }
 
        if (!$currentExtranetSite)
        {
            if (self::checkEntityOption([ 'open', '!extranet', '!landing' ], $entityOptions))
            {
                $result['project-open'] = [
                    'SORT' => $sort += 10,
                    'NAME' => ($useProjects ? Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_OPEN') : Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_OPEN')),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_OPEN_DESC'),
                    'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_OPEN_DESC2'),
                    'VISIBLE' => 'Y',
                    'OPENED' => 'Y',
                    'PROJECT' => ($useProjects ? 'Y' : 'N' ),
                    'EXTERNAL' => 'N',
                    'TILE_CLASS' => 'social-group-tile-item-cover-open ' . ($useProjects ? 'social-group-tile-item-icon-project-open' : 'social-group-tile-item-icon-group-open'),
                ];
            }
 
            if (self::checkEntityOption([ '!open', '!extranet', '!landing' ], $entityOptions))
            {
                $result['project-closed'] = [
                    'SORT' => $sort += 10,
                    'NAME' => ($useProjects ? Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_CLOSED') : Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_CLOSED')),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_CLOSED_DESC'),
                    'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_CLOSED_DESC'),
                    'VISIBLE' => 'N',
                    'OPENED' => 'N',
                    'PROJECT' => ($useProjects ? 'Y' : 'N' ),
                    'EXTERNAL' => 'N',
                    'TILE_CLASS' => 'social-group-tile-item-cover-close ' . ($useProjects ? 'social-group-tile-item-icon-project-close' : 'social-group-tile-item-icon-group-close'),
                ];
            }
 
            if (
                $useProjects
                && self::checkEntityOption([ 'project', 'scrum', '!extranet', '!landing' ], $entityOptions)
            )
            {
                $result['project-scrum'] = [
                    'SORT' => $sort += 10,
                    'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_SCRUM'),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_SCRUM_DESC'),
                    'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_SCRUM_DESC'),
                    'VISIBLE' => 'N',
                    'OPENED' => 'N',
                    'PROJECT' => 'Y',
                    'SCRUM_PROJECT' => 'Y',
                    'EXTERNAL' => 'N',
                    'TILE_CLASS' => 'social-group-tile-item-cover-scrum social-group-tile-item-icon-project-scrum',
                ];
            }
 
            if (
                $fullMode
                && self::checkEntityOption([ '!open', '!extranet', '!landing' ], $entityOptions)
            )
            {
                $result['project-closed-visible'] = [
                    'SORT' => $sort += 10,
                    'NAME' => ($useProjects ? Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_CLOSED_VISIBLE') : Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_CLOSED_VISIBLE')),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_CLOSED_VISIBLE_DESC'),
                    'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_CLOSED_VISIBLE_DESC'),
                    'VISIBLE' => 'Y',
                    'OPENED' => 'N',
                    'PROJECT' => ($useProjects ? 'Y' : 'N' ),
                    'EXTERNAL' => 'N',
                    'TILE_CLASS' => '',
                ];
            }
        }
 
        if (
            $extranetInstalled
            && self::checkEntityOption([ 'extranet', '!landing' ], $entityOptions)
        )
        {
            $result['project-external'] = [
                'SORT' => $sort += 10,
                'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_EXTERNAL'),
                'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_EXTERNAL_DESC'),
                'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GP_EXTERNAL_DESC'),
                'VISIBLE' => 'N',
                'OPENED' => 'N',
                'PROJECT' => ($useProjects ? 'Y' : 'N' ),
                'EXTERNAL' => 'Y',
                'TILE_CLASS' => 'social-group-tile-item-cover-outer social-group-tile-item-icon-project-outer',
            ];
        }
 
        if (
            $landingInstalled
            && self::checkEntityOption([ '!project', 'landing', '!extranet' ], $entityOptions)
        )
        {
            $result['group-landing'] = [
                'SORT' => $sort += 10,
                'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_LANDING2_MSGVER_1'),
                'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_LANDING_DESC2_MSGVER_2'),
                'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_LANDING_DESC2_MSGVER_2'),
                'VISIBLE' => 'N',
                'OPENED' => 'N',
                'PROJECT' => 'N',
                'EXTERNAL' => 'N',
                'LANDING' => 'Y',
                'TILE_CLASS' => 'social-group-tile-item-cover-public social-group-tile-item-icon-group-public',
            ];
        }
 
        return $result;
    }
 
    public static function getTypes($params = []): array
    {
        static $intranetInstalled = null;
        static $extranetInstalled = null;
        static $landingInstalled = null;
 
        if ($intranetInstalled === null)
        {
            $intranetInstalled = ModuleManager::isModuleInstalled('intranet');
        }
 
        if ($extranetInstalled === null)
        {
            $extranetInstalled = static::isExtranetInstalled();
        }
 
        if ($landingInstalled === null)
        {
            $landingInstalled = ModuleManager::isModuleInstalled('landing');
        }
 
        $currentExtranetSite = (
            !empty($params)
            && isset($params['currentExtranetSite'])
            && $params['currentExtranetSite']
        );
 
        $categoryList = [];
        if (!empty($params['category']) && is_array($params['category']))
        {
            $categoryList = $params['category'];
        }
 
        $entityOptions = [];
        if (!empty($params['entityOptions']) && is_array($params['entityOptions']))
        {
            $entityOptions = $params['entityOptions'];
        }
 
        $fullMode = (
            !empty($params)
            && isset($params['fullMode'])
            && $params['fullMode']
        );
 
        $result = [];
        $sort = 0;
 
        if (
            $intranetInstalled
            && (
                empty($categoryList)
                || in_array('projects', $categoryList, true)
            )
        )
        {
            if (!$currentExtranetSite)
            {
                if (self::checkEntityOption([ 'project', 'open', '!extranet', '!landing' ], $entityOptions))
                {
                    $result['project-open'] = array(
                        'SORT' => $sort += 10,
                        'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_OPEN'),
                        'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_OPEN_DESC'),
                        'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_OPEN_DESC2'),
                        'VISIBLE' => 'Y',
                        'OPENED' => 'Y',
                        'PROJECT' => 'Y',
                        'SCRUM_PROJECT' => 'N',
                        'EXTERNAL' => 'N',
                        'TILE_CLASS' => 'social-group-tile-item-cover-open social-group-tile-item-icon-project-open',
                    );
                }
 
                if (self::checkEntityOption([ 'project', '!open', '!extranet', '!landing' ], $entityOptions))
                {
                    $result['project-closed'] = array(
                        'SORT' => $sort += 10,
                        'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_CLOSED'),
                        'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_CLOSED_DESC'),
                        'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_CLOSED_DESC'),
                        'VISIBLE' => 'N',
                        'OPENED' => 'N',
                        'PROJECT' => 'Y',
                        'SCRUM_PROJECT' => 'N',
                        'EXTERNAL' => 'N',
                        'TILE_CLASS' => 'social-group-tile-item-cover-close social-group-tile-item-icon-project-close',
                    );
                }
 
                if (self::checkEntityOption([ 'project', 'scrum', '!extranet', '!landing' ], $entityOptions))
                {
                    $result['project-scrum'] = [
                        'SORT' => $sort += 10,
                        'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_SCRUM2'),
                        'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_SCRUM_DESC2'),
                        'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_SCRUM_DESC2'),
                        'VISIBLE' => 'N',
                        'OPENED' => 'N',
                        'PROJECT' => 'Y',
                        'SCRUM_PROJECT' => 'Y',
                        'EXTERNAL' => 'N',
                        'TILE_CLASS' => 'social-group-tile-item-cover-scrum social-group-tile-item-icon-project-scrum',
                    ];
                }
 
                if (
                    $fullMode
                    && self::checkEntityOption([ 'project', '!open', '!extranet', '!landing' ], $entityOptions)
                )
                {
                    $result['project-closed-visible'] = array(
                        'SORT' => $sort += 10,
                        'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_CLOSED_VISIBLE'),
                        'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_CLOSED_VISIBLE_DESC'),
                        'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_CLOSED_VISIBLE_DESC'),
                        'VISIBLE' => 'Y',
                        'OPENED' => 'N',
                        'PROJECT' => 'Y',
                        'SCRUM_PROJECT' => 'N',
                        'EXTERNAL' => 'N',
                        'TILE_CLASS' => '',
                    );
                }
            }
 
            if (
                $extranetInstalled
                && self::checkEntityOption([ 'project', 'scrum', 'extranet', '!landing' ], $entityOptions)
            )
            {
                $result['project-scrum-extranet'] = [
                    'SORT' => $sort += 10,
                    'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_SCRUM_EXTERNAL'),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_SCRUM_EXTERNAL_DESC'),
                    'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_SCRUM_EXTERNAL_DESC'),
                    'VISIBLE' => 'N',
                    'OPENED' => 'N',
                    'PROJECT' => 'Y',
                    'SCRUM_PROJECT' => 'Y',
                    'EXTERNAL' => 'Y',
                    'TILE_CLASS' => 'social-group-tile-item-cover-scrum social-group-tile-item-icon-project-scrum',
                ];
            }
 
            if (
                $extranetInstalled
                && self::checkEntityOption([ 'project', 'extranet', '!landing' ], $entityOptions)
            )
            {
                $result['project-external'] = array(
                    'SORT' => $sort += 10,
                    'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_EXTERNAL'),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_EXTERNAL_DESC'),
                    'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_PROJECT_EXTERNAL_DESC'),
                    'VISIBLE' => 'N',
                    'OPENED' => 'N',
                    'PROJECT' => 'Y',
                    'SCRUM_PROJECT' => 'N',
                    'EXTERNAL' => 'Y',
                    'TILE_CLASS' => 'social-group-tile-item-cover-outer social-group-tile-item-icon-project-outer',
                );
            }
        }
 
        if (
            !$currentExtranetSite
            && (
                empty($categoryList)
                || in_array('groups', $categoryList)
            )
        )
        {
            if (self::checkEntityOption([ '!project', 'open', '!extranet', '!landing' ], $entityOptions))
            {
                $result['group-open'] = array(
                    'SORT' => $sort += 10,
                    'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_OPEN'),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_OPEN_DESC'),
                    'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_OPEN_DESC2'),
                    'VISIBLE' => 'Y',
                    'OPENED' => 'Y',
                    'PROJECT' => 'N',
                    'SCRUM_PROJECT' => 'N',
                    'EXTERNAL' => 'N',
                    'TILE_CLASS' => 'social-group-tile-item-cover-open social-group-tile-item-icon-group-open',
                );
            }
 
            if (self::checkEntityOption([ '!project', '!open', '!extranet', '!landing' ], $entityOptions))
            {
                $result['group-closed'] = array(
                    'SORT' => $sort += 10,
                    'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_CLOSED'),
                    'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_CLOSED_DESC'),
                    'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_CLOSED_DESC'),
                    'VISIBLE' => 'N',
                    'OPENED' => 'N',
                    'PROJECT' => 'N',
                    'SCRUM_PROJECT' => 'N',
                    'EXTERNAL' => 'N',
                    'TILE_CLASS' => 'social-group-tile-item-cover-close social-group-tile-item-icon-group-close',
                );
                if ($fullMode)
                {
                    $result['group-closed-visible'] = array(
                        'SORT' => $sort = $sort + 10,
                        'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_CLOSED_VISIBLE'),
                        'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_CLOSED_VISIBLE_DESC'),
                        'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_CLOSED_VISIBLE_DESC'),
                        'VISIBLE' => 'Y',
                        'OPENED' => 'N',
                        'PROJECT' => 'N',
                        'SCRUM_PROJECT' => 'N',
                        'EXTERNAL' => 'N',
                        'TILE_CLASS' => '',
                    );
                }
            }
        }
 
        if (
            $extranetInstalled
            && self::checkEntityOption([ '!project', 'extranet', '!landing' ], $entityOptions)
        )
        {
            $result['group-external'] = array(
                'SORT' => $sort += 10,
                'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_EXTERNAL'),
                'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_EXTERNAL_DESC'),
                'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_EXTERNAL_DESC'),
                'VISIBLE' => 'N',
                'OPENED' => 'N',
                'PROJECT' => 'N',
                'SCRUM_PROJECT' => 'N',
                'EXTERNAL' => 'Y',
                'TILE_CLASS' => 'social-group-tile-item-cover-outer social-group-tile-item-icon-group-outer',
            );
        }
 
        if (
            $landingInstalled
            && self::checkEntityOption([ '!project', 'landing', '!extranet' ], $entityOptions)
        )
        {
            $result['group-landing'] = array(
                'SORT' => $sort += 10,
                'NAME' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_LANDING_MSGVER_2'),
                'DESCRIPTION' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_LANDING_DESC_MSGVER_2'),
                'DESCRIPTION2' => Loc::getMessage('SOCIALNETWORK_ITEM_WORKGROUP_TYPE_GROUP_LANDING_DESC_MSGVER_2'),
                'VISIBLE' => 'N',
                'OPENED' => 'N',
                'PROJECT' => 'N',
                'SCRUM_PROJECT' => 'N',
                'EXTERNAL' => 'N',
                'LANDING' => 'Y',
                'TILE_CLASS' => 'social-group-tile-item-cover-public social-group-tile-item-icon-group-public',
            );
        }
 
        return $result;
    }
 
    protected static function isExtranetInstalled(): bool
    {
        return (
            ModuleManager::isModuleInstalled('extranet')
            && Option::get('extranet', 'extranet_site') !== ''
        );
    }
 
    public static function getAvatarTypes(): array
    {
        return self::getDefaultAvatarTypes();
    }
 
    public static function getDefaultAvatarTypes(): array
    {
        return [
            Item\Workgroup\AvatarType::Folder->value => [
                'sort' => 100,
                'mobileUrl' => '/bitrix/images/socialnetwork/workgroup/folder.png',
                'webCssClass' => 'folder',
                'entitySelectorUrl' => '/bitrix/images/socialnetwork/workgroup/folder.png',
            ],
            Item\Workgroup\AvatarType::Checks->value => [
                'sort' => 200,
                'mobileUrl' => '/bitrix/images/socialnetwork/workgroup/checks.png',
                'webCssClass' => 'tasks',
                'entitySelectorUrl' => '/bitrix/images/socialnetwork/workgroup/checks.png',
            ],
            Item\Workgroup\AvatarType::Pie->value => [
                'sort' => 300,
                'mobileUrl' => '/bitrix/images/socialnetwork/workgroup/pie.png',
                'webCssClass' => 'chart',
                'entitySelectorUrl' => '/bitrix/images/socialnetwork/workgroup/pie.png',
            ],
            Item\Workgroup\AvatarType::Bag->value => [
                'sort' => 400,
                'mobileUrl' => '/bitrix/images/socialnetwork/workgroup/bag.png',
                'webCssClass' => 'briefcase',
                'entitySelectorUrl' => '/bitrix/images/socialnetwork/workgroup/bag.png',
            ],
            Item\Workgroup\AvatarType::Members->value => [
                'sort' => 500,
                'mobileUrl' => '/bitrix/images/socialnetwork/workgroup/members.png',
                'webCssClass' => 'group',
                'entitySelectorUrl' => '/bitrix/images/socialnetwork/workgroup/members.png',
            ],
        ];
    }
 
    public static function getColoredAvatarTypes(): array
    {
        $colors = self::getAvatarColors();
 
        $avatarTypes = [];
        foreach ($colors as $color)
        {
            $avatarTypes["space_$color"] = [
                'sort' => 600,
                'mobileUrl' => "/bitrix/images/socialnetwork/workgroup/space_$color.png",
                'webCssClass' => "space_$color",
                'entitySelectorUrl' => "/bitrix/images/socialnetwork/workgroup/space_$color.png",
            ];
        }
 
        return $avatarTypes;
    }
 
    public static function getAvatarColors(): array
    {
        return [
            '55D0E0',
            'FB6DBA',
            '29AD49',
            'C27D3C',
            '05B5AB',
            'A77BDE',
            '90BF00',
            '559BE6',
            'D959CC',
        ];
    }
 
    public static function getAvatarTypeWebCssClass($type = ''): string
    {
        $result = '';
        $types = static::getAvatarTypes();
        if (empty($types[$type]))
        {
            return $result;
        }
 
        return $types[$type]['webCssClass'];
    }
 
    public static function getAvatarEntitySelectorUrl($type = ''): string
    {
        $result = '';
        $types = static::getAvatarTypes();
        if (empty($types[$type]))
        {
            return $result;
        }
 
        return $types[$type]['entitySelectorUrl'];
    }
 
    public static function getAdditionalData(array $params = []): array
    {
        global $USER;
 
        $ids = (
            is_array($params['ids'])
                ? array_filter(
                    array_map(
                        static function($val) { return (int)$val; },
                        $params['ids']
                    ),
                    static function ($val) { return $val > 0; }
                )
                : []
        );
        $features = (
            is_array($params['features'])
                ? array_filter(
                    array_map(
                        static function($val) { return trim((string)$val); },
                        $params['features']
                    ),
                    static function ($val) { return !empty($val); }
                )
                : []
        );
        $mandatoryFeatures = (
            is_array($params['mandatoryFeatures'])
                ? array_filter(
                    array_map(
                        static function($val) { return trim((string)$val); },
                        $params['mandatoryFeatures']
                    ),
                    static function ($val) { return !empty($val); }
                )
            : []
        );
        $currentUserId = (int)($params['currentUserId'] ?? $USER->getId());
        if (empty($ids))
        {
            return $ids;
        }
 
        $featuresSettings = \CSocNetAllowed::getAllowedFeatures();
 
        $result = [];
        $userRoles = [];
 
        $res = UserToGroupTable::getList([
            'filter' => [
                'GROUP_ID' => $ids,
                'USER_ID' => $currentUserId,
            ],
            'select' => [ 'GROUP_ID', 'ROLE', 'INITIATED_BY_TYPE' ],
 
        ]);
        while ($relationFields = $res->fetch())
        {
            $userRoles[(int)$relationFields['GROUP_ID']] = [
                'ROLE' => $relationFields['ROLE'],
                'INITIATED_BY_TYPE' => $relationFields['INITIATED_BY_TYPE'],
            ];
        }
 
        foreach ($features as $feature)
        {
            $activeFeaturesList = (array)\CSocNetFeatures::isActiveFeature(SONET_ENTITY_GROUP, $ids, $feature);
            $filteredIds = array_keys(array_filter($activeFeaturesList, static function($val) { return $val; }));
 
            if (
                empty($filteredIds)
                || !isset($featuresSettings[$feature])
            )
            {
                $permissions = [];
            }
            else
            {
                $minOperationList = $featuresSettings[$feature]['minoperation'];
                if (!is_array($minOperationList))
                {
                    $minOperationList = [ $minOperationList ];
                }
 
                $permissions = [];
                foreach ($minOperationList as $minOperation)
                {
                    $operationPermissions = \CSocNetFeaturesPerms::getOperationPerm(SONET_ENTITY_GROUP, $filteredIds, $feature, $minOperation);
                    foreach ($operationPermissions as $groupId => $role)
                    {
                        if (
                            !isset($permissions[$groupId])
                            || $role > $permissions[$groupId]
                        )
                        {
                            $permissions[$groupId] = $role;
                        }
                    }
                }
            }
 
            foreach ($ids as $id)
            {
                if (!isset($result[$id]))
                {
                    $result[$id] = [];
                }
 
                if (!isset($result[$id]['FEATURES']))
                {
                    $result[$id]['FEATURES'] = [];
                }
 
                if (
                    in_array($feature, $mandatoryFeatures, true)
                    || (
                        isset($permissions[$id])
                        && (
                            !in_array($permissions[$id], UserToGroupTable::getRolesMember(), true)
                            || (
                                isset($userRoles[$id])
                                && $userRoles[$id]['ROLE'] <= $permissions[$id]
                            )
                        )
                    )
                )
                {
                    $result[$id]['FEATURES'][] = $feature;
                }
            }
        }
 
        foreach ($ids as $id)
        {
            $result[$id]['ROLE'] = ($userRoles[$id]['ROLE'] ?? '');
            $result[$id]['INITIATED_BY_TYPE'] = ($userRoles[$id]['INITIATED_BY_TYPE'] ?? '');
        }
 
        return $result;
    }
 
    public static function mutateScrumFormFields(array &$fields = []): void
    {
        if (empty($fields['SCRUM_MASTER_ID']))
        {
            return;
        }
 
        $fields['PROJECT'] = 'Y';
 
        if (empty($fields['SUBJECT_ID']))
        {
            $siteId = (!empty($fields['SITE_ID']) ? $fields['SITE_ID'] : SITE_ID);
 
            $subjectQueryObject = \CSocNetGroupSubject::getList(
                [
                    'SORT' => 'ASC',
                    'NAME' => 'ASC',
                ],
                [
                    'SITE_ID' => $siteId,
                ],
                false,
                false,
                [ 'ID' ]
            );
            if ($subject = $subjectQueryObject->fetch())
            {
                $fields['SUBJECT_ID'] = (int)$subject['ID'];
            }
        }
    }
 
    public static function pin(int $groupId, string $mode = ''): ?bool
    {
        if (
            $groupId <= 0
            || !Helper\Workgroup\Access::canView(['groupId' => $groupId])
            || static::getIsPinned($groupId, $mode)
        )
        {
            return false;
        }
 
        $userId = User::getCurrentUserId();
 
        try
        {
            WorkgroupPinTable::add([
                'GROUP_ID' => $groupId,
                'USER_ID' => $userId,
                'CONTEXT' => $mode,
            ]);
        }
        catch (\Exception $e)
        {
            return null;
        }
 
        static::sendPinChangedPushEvent($groupId, $userId, 'pin');
 
        return true;
    }
 
    public static function unpin(int $groupId, string $mode = ''): ?bool
    {
        if (
            $groupId <= 0
            || !Helper\Workgroup\Access::canView(['groupId' => $groupId])
            || !($isPinned = static::getIsPinned($groupId, $mode))
        )
        {
            return false;
        }
 
        $tableDeleteResult = WorkgroupPinTable::delete($isPinned->get('ID'));
        if (!$tableDeleteResult->isSuccess())
        {
            return null;
        }
 
        static::sendPinChangedPushEvent($groupId, User::getCurrentUserId(), 'unpin');
 
        return true;
    }
 
    private static function getIsPinned(int $groupId, string $mode): ?EO_WorkgroupPin
    {
        $query = WorkgroupPinTable::query();
        $query
            ->setSelect(['ID', 'GROUP_ID', 'USER_ID'])
            ->where('GROUP_ID', $groupId)
            ->where('USER_ID', User::getCurrentUserId())
            ->setLimit(1)
        ;
 
        if ($mode === '')
        {
            $query->where(
                Query::filter()
                    ->logic('or')
                    ->whereNull('CONTEXT')
                    ->where('CONTEXT', '')
            );
        }
        else
        {
            $query->where('CONTEXT', $mode);
        }
 
        return $query->exec()->fetchObject();
    }
 
    private static function sendPinChangedPushEvent(int $groupId, int $userId, string $action): void
    {
        PushService::addEvent(
            [$userId],
            [
                'module_id' => 'socialnetwork',
                'command' => 'workgroup_pin_changed',
                'params' => [
                    'GROUP_ID' => $groupId,
                    'USER_ID' => $userId,
                    'ACTION' => $action,
                ],
            ]
        );
    }
}