calluser.php

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

<?php
 
namespace Bitrix\Im\Model;
 
use Bitrix\Main\Application;
use Bitrix\Main\Error;
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Fields\IntegerField;
use Bitrix\Main\ORM\Fields\StringField;
use Bitrix\Main\ORM\Fields\DatetimeField;
use Bitrix\Main\ORM\Fields\BooleanField;
use Bitrix\Main\ORM\Data\AddResult;

class CallUserTable extends DataManager
{
    public static function getTableName(): string
    {
        return 'b_im_call_user';
    }
 
    public static function getMap(): array
    {
        return [
            new IntegerField('CALL_ID', [
                'primary' => true
            ]),
            new IntegerField('USER_ID', [
                'primary' => true
            ]),
            new StringField('STATE'),
            new DatetimeField('FIRST_JOINED'),
            new DatetimeField('LAST_SEEN'),
            new BooleanField('IS_MOBILE', [
                'values' => ['N', 'Y']
            ]),
            new BooleanField('SHARED_SCREEN', [
                'values' => ['N', 'Y']
            ]),
            new BooleanField('RECORDED', [
                'values' => ['N', 'Y']
            ]),
        ];
    }

    public static function merge(array $data): AddResult
    {
        $result = new AddResult();
 
        $helper = Application::getConnection()->getSqlHelper();
        $insertData = $data;
        $updateData = $data;
        $mergeFields = static::getMergeFields();
        foreach ($mergeFields as $field)
        {
            unset($updateData[$field]);
        }
        $merge = $helper->prepareMerge(
            static::getTableName(),
            static::getMergeFields(),
            $insertData,
            $updateData
        );
 
        if ($merge[0] != "")
        {
            Application::getConnection()->query($merge[0]);
            $id = Application::getConnection()->getInsertedId();
            $result->setId($id);
            $result->setData($data);
        }
        else
        {
            $result->addError(new Error('Error constructing query'));
        }
 
        return $result;
    }

    protected static function getMergeFields(): array
    {
        return ['CALL_ID', 'USER_ID'];
    }
}