spacecompositiontable.php

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

<?php
namespace Bitrix\Socialnetwork\Internals\Space\Composition;
 
use Bitrix\Main\ArgumentException;
use Bitrix\Main\ObjectPropertyException;
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Data\Result;
use Bitrix\Main\ORM\Fields\ArrayField;
use Bitrix\Main\ORM\Fields\IntegerField;
use Bitrix\Main\SystemException;

 
class SpaceCompositionTable extends DataManager
{
    public static function getTableName(): string
    {
        return 'b_sonet_space_composition';
    }

    public static function getMap(): array
    {
        return [
            (new IntegerField('ID'))
                ->configurePrimary()
                ->configureAutocomplete(),
            (new IntegerField('USER_ID'))
                ->configureRequired(),
            (new IntegerField('SPACE_ID'))
                ->configureRequired(),
            (new ArrayField('SETTINGS'))
                ->configureRequired()
                ->configureSerializationJson(),
        ];
    }
 
    public static function getObjectClass(): string
    {
        return SpaceCompositionObject::class;
    }
 
    public static function getCollectionClass(): string
    {
        return SpaceCompositionCollection::class;
    }

    public static function isDataFilled(int $userId, int $spaceId): bool
    {
        $composition = static::getByIds($userId, $spaceId);
 
        return !is_null($composition);
    }
 
    public static function fill(int $userId, int $spaceId, array $settings): Result
    {
        $composition = (new SpaceCompositionObject())
            ->setUserId($userId)
            ->setSpaceId($spaceId)
            ->setSettings($settings);
 
        return $composition->save();
    }

    public static function getByIds(int $userId, int $spaceId = 0): ?SpaceCompositionObject
    {
        $query = static::query();
        $query
            ->setSelect(['*'])
            ->where('USER_ID', $userId)
            ->where('SPACE_ID', $spaceId)
            ->setLimit(1);
 
        return $query->exec()->fetchObject();
    }
}