chatpinnedmessage.php

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

<?php
namespace Bitrix\Im\Model;
 
use Bitrix\Im\Model\ChatTable;
use Bitrix\Im\Model\MessageTable;
use Bitrix\Im\Model\UserTable;
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Fields\DatetimeField;
use Bitrix\Main\ORM\Fields\IntegerField;
use Bitrix\Main\ORM\Fields\Relations\Reference;
use Bitrix\Main\ORM\Query\Join;
use Bitrix\Main\Type\DateTime;

 
class ChatPinnedMessageTable extends DataManager
{
    public static function getTableName()
    {
        return 'b_im_chat_pinned_message';
    }

    public static function getMap()
    {
        return [
            'ID' => new IntegerField(
                'ID',
                [
                    'primary' => true,
                    'autocomplete' => true,
                ]
            ),
            'CHAT_ID' => new IntegerField(
                'CHAT_ID',
                []
            ),
            'MESSAGE_ID' => new IntegerField(
                'MESSAGE_ID',
                []
            ),
            'PIN_AUTHOR_ID' => new IntegerField(
                'PIN_AUTHOR_ID',
                []
            ),
            'DATE_CREATE' => new DatetimeField(
                'DATE_CREATE',
                [
                    'required' => true,
                    'default_value' => static function() {
                        return new DateTime();
                    }
                ]
            ),
            'MESSAGE' => (new Reference(
                'MESSAGE',
                MessageTable::class,
                Join::on('this.MESSAGE_ID', 'ref.ID')
            ))->configureJoinType(Join::TYPE_INNER),
            'CHAT' => (new Reference(
                'CHAT',
                ChatTable::class,
                Join::on('this.CHAT_ID', 'ref.ID')
            ))->configureJoinType(Join::TYPE_INNER),
            'PIN_AUTHOR' => (new Reference(
                'PIN_AUTHOR',
                UserTable::class,
                Join::on('this.PIN_AUTHOR_ID', 'ref.ID')
            ))->configureJoinType(Join::TYPE_LEFT)
        ];
    }
}