chatindex.php

<?php
namespace Bitrix\Im\Model;
 
use Bitrix\Main,
    Bitrix\Main\Application,
    Bitrix\Main\Entity,
    Bitrix\Main\Error,
    Bitrix\Main\DB\SqlExpression
;
 
 
class ChatIndexTable extends Main\Entity\DataManager
{
    use Main\ORM\Data\Internal\DeleteByFilterTrait;
 
    public static function getTableName()
    {
        return 'b_im_chat_index';
    }
 
    public static function getMap()
    {
        return array(
            'CHAT_ID' => array(
                'data_type' => 'integer',
                'primary' => true,
            ),
            'SEARCH_TITLE' => array(
                'data_type' => 'string',
                'validation' => array(__CLASS__, 'validateTitle'),
            ),
            'SEARCH_CONTENT' => array(
                'data_type' => 'text',
            ),
        );
    }
 
    public static function validateTitle()
    {
        return array(
            new Entity\Validator\Length(null, 255),
        );
    }
 
    protected static function getMergeFields()
    {
        return array('CHAT_ID');
    }
 
    public static function merge(array $data)
    {
        $result = new Entity\AddResult();
 
        $helper = Application::getConnection()->getSqlHelper();
        $insertData = $data;
        $updateData = $data;
        $mergeFields = static::getMergeFields();
 
        foreach ($mergeFields as $field)
        {
            unset($updateData[$field]);
        }
 
        $versionMain = \Bitrix\Main\ModuleManager::getVersion('main');
        $isPgCompatible = (version_compare($versionMain, '24.0.0') >= 0);//todo: Remove it in future version
 
        if (isset($updateData['SEARCH_CONTENT']))
        {
            if ($isPgCompatible)
            {
                $field = new SqlExpression('?v', 'SEARCH_CONTENT');
            }
            else
            {
                $field = 'SEARCH_CONTENT';
            }
            $updateData['SEARCH_CONTENT'] = new SqlExpression($helper->getConditionalAssignment($field, $updateData['SEARCH_CONTENT']));
        }
 
        if (isset($updateData['SEARCH_TITLE']))
        {
            if ($isPgCompatible)
            {
                $field = new SqlExpression('?v', 'SEARCH_TITLE');
            }
            else
            {
                $field = 'SEARCH_TITLE';
            }
            $updateData['SEARCH_TITLE'] = new SqlExpression($helper->getConditionalAssignment($field, $updateData['SEARCH_TITLE']));
        }
 
        $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;
    }
 
    public static function updateIndex($id, $primaryField, array $updateData): Main\ORM\Data\UpdateResult
    {
        $result = new Main\ORM\Data\UpdateResult();
        $helper = Application::getConnection()->getSqlHelper();
 
        if (isset($updateData[$primaryField]))
        {
            unset($updateData[$primaryField]);
        }
 
        if (isset($updateData['SEARCH_CONTENT']))
        {
            $updateData['SEARCH_CONTENT'] = new SqlExpression($helper->getConditionalAssignment('SEARCH_CONTENT', $updateData['SEARCH_CONTENT']));
        }
 
        if (isset($updateData['SEARCH_TITLE']))
        {
            $updateData['SEARCH_TITLE'] = new SqlExpression($helper->getConditionalAssignment('SEARCH_TITLE', $updateData['SEARCH_TITLE']));
        }
 
        $update = $helper->prepareUpdate(
            static::getTableName(),
            $updateData
        );
 
        if ($update[0] !== '')
        {
            Application::getConnection()->query(
                "UPDATE " . static::getTableName() . " SET " . $update[0] . " WHERE " . $primaryField . " = " . $id
            );
        }
 
        return $result;
    }
}