workgrouppin.php

<?php
namespace Bitrix\Socialnetwork;
 
use Bitrix\Main\Entity;
use Bitrix\Socialnetwork\Internals\Pin\Pin;
use Bitrix\Socialnetwork\Internals\Pin\PinCollection;
 
class WorkgroupPinTable extends Entity\DataManager
{
    public static function getTableName(): string
    {
        return 'b_sonet_group_pin';
    }
 
    public static function getMap(): array
    {
        return [
            'ID' => [
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ],
            'USER_ID' => [
                'data_type' => 'integer',
            ],
            'USER' => [
                'data_type' => '\Bitrix\Main\User',
                'reference' => [ '=this.USER_ID' => 'ref.ID' ],
            ],
            'GROUP_ID' => [
                'data_type' => 'integer',
            ],
            'GROUP' => [
                'data_type' => '\Bitrix\Socialnetwork\Workgroup',
                'reference' => [ '=this.GROUP_ID' => 'ref.ID' ],
            ],
            'CONTEXT' => [
                'data_type' => 'string',
            ],
        ];
    }
 
    public static function getSelectExpression(): string
    {
        $tableName = static::getTableName();
 
        return "
            CASE WHEN
                EXISTS(
                    SELECT 'x'
                    FROM {$tableName}
                    WHERE
                        GROUP_ID = %s
                        AND USER_ID = %s
                        AND CONTEXT = %s
                )
                THEN 'Y'
                ELSE 'N'
            END
        ";
    }
 
    public static function getObjectClass(): string
    {
        return Pin::class;
    }
 
    public static function getCollectionClass(): string
    {
        return PinCollection::class;
    }
}