chatparam.php

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

<?php
namespace Bitrix\Im\Model;
 
use Bitrix\Main\Entity;
use Bitrix\Main;

class ChatParamTable extends Entity\DataManager
{
    public static function getTableName()
    {
        return 'b_im_chat_param';
    }

    public static function getMap()
    {
        return array(
            'ID' => array(
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ),
            'CHAT_ID' => array(
                'data_type' => 'integer',
                'required' => true,
            ),
            'PARAM_NAME' => array(
                'data_type' => 'string',
                'required' => true,
                'validation' => array(__CLASS__, 'validateParamName'),
            ),
            'PARAM_VALUE' => array(
                'data_type' => 'string',
                'validation' => array(__CLASS__, 'validateParamValue'),
                'save_data_modification' => array('\Bitrix\Main\Text\Emoji', 'getSaveModificator'),
                'fetch_data_modification' => array('\Bitrix\Main\Text\Emoji', 'getFetchModificator'),
            ),
            'PARAM_JSON' => array(
                'data_type' => 'text',
                'save_data_modification' => array('\Bitrix\Main\Text\Emoji', 'getSaveModificator'),
                'fetch_data_modification' => array('\Bitrix\Main\Text\Emoji', 'getFetchModificator'),
            ),
        );
    }

    public static function validateParamName()
    {
        return array(
            new Entity\Validator\Length(null, 100),
        );
    }

    public static function validateParamValue()
    {
        return array(
            new Entity\Validator\Length(null, 100),
        );
    }

    public static function deleteBatch(array $filter)
    {
        $whereSql = \Bitrix\Main\Entity\Query::buildFilterSql(static::getEntity(), $filter);
 
        if ($whereSql <> '')
        {
            $tableName = static::getTableName();
            $connection = Main\Application::getConnection();
            $connection->queryExecute("DELETE FROM {$tableName} WHERE {$whereSql}");
        }
    }
}