messageaccess.php

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

<?php
 
namespace Bitrix\Mail\Internals;
 
use Bitrix\Main\Entity;
use Bitrix\Main\ORM\Data\Internal\DeleteByFilterTrait;

class MessageAccessTable extends Entity\DataManager
{
    use DeleteByFilterTrait;
 
    const ENTITY_TYPE_NO_BIND = 'NO_BIND';
    const ENTITY_TYPE_TASKS_TASK = 'TASKS_TASK';
    const ENTITY_TYPE_CRM_ACTIVITY = 'CRM_ACTIVITY';
    const ENTITY_TYPE_BLOG_POST = 'BLOG_POST';
    const ENTITY_TYPE_IM_CHAT = 'IM_CHAT';
    const ENTITY_TYPE_CALENDAR_EVENT = 'CALENDAR_EVENT';
 
    public static function getFilePath()
    {
        return __FILE__;
    }
 
    public static function getTableName()
    {
        return 'b_mail_message_access';
    }
 
    public static function getMap()
    {
        return array(
            'TOKEN' => array(
                'data_type' => 'string',
                'primary'   => true,
            ),
            'MAILBOX_ID' => array(
                'data_type' => 'integer',
                'required'  => true,
            ),
            'MESSAGE_ID' => array(
                'data_type' => 'integer',
                'required'  => true,
            ),
            'ENTITY_UF_ID' => array(
                'data_type' => 'integer',
                'required'  => true,
            ),
            'ENTITY_TYPE' => array(
                'data_type' => 'string',
                'required'  => true,
            ),
            'ENTITY_ID' => array(
                'data_type' => 'integer',
                'required'  => true,
            ),
            'SECRET' => array(
                'data_type' => 'string',
                'required'  => true,
            ),
            'OPTIONS' => array(
                'data_type'  => 'text',
                'serialized' => true,
            ),
            new Entity\ReferenceField(
                'CRM_ACTIVITY',
                '\Bitrix\Crm\ActivityTable',
                array(
                    '=this.ENTITY_TYPE' => array('?s', self::ENTITY_TYPE_CRM_ACTIVITY),
                    '=this.ENTITY_ID' => 'ref.ID',
                )
            ),
        );
    }
 

    public static function getBinds(int $mailboxId, int $messageId): array
    {
        $binds = MessageAccessTable::query()
            ->where('MAILBOX_ID', $mailboxId)
            ->where('MESSAGE_ID', $messageId)
            ->setDistinct()
            ->setSelect([
                'ENTITY_TYPE',
                'ENTITY_ID',
            ])
            ->fetchAll();
 
        return array_map(fn(array $bind): string => "{$bind['ENTITY_TYPE']}-{$bind['ENTITY_ID']}", $binds);
    }
 
}