sharinglinkmembertable.php

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

<?php
 
namespace Bitrix\Calendar\Internals;
 
use Bitrix\Main\Entity\ReferenceField;
use Bitrix\Main\FileTable;
use Bitrix\Main\Localization\Loc;
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Fields\IntegerField;
use Bitrix\Main\ORM\Fields\Relations\Reference;
use Bitrix\Main\ORM\Query\Join;
use Bitrix\Main\UserTable;

 
class SharingLinkMemberTable extends DataManager
{
    public static function getTableName()
    {
        return 'b_calendar_sharing_link_member';
    }

    public static function getMap()
    {
        return [
            (new IntegerField('ID',
                []
            ))->configureTitle(Loc::getMessage('SHARING_LINK_MEMBER_ENTITY_ID_FIELD'))
                ->configurePrimary()
            ,
            (new IntegerField('LINK_ID',
                []
            ))->configureTitle(Loc::getMessage('SHARING_LINK_MEMBER_ENTITY_LINK_ID_FIELD'))
            ,
            (new IntegerField('MEMBER_ID',
                []
            ))->configureTitle(Loc::getMessage('SHARING_LINK_MEMBER_ENTITY_MEMBER_ID_FIELD'))
            ,
            (new Reference(
                'MEMBER',
                SharingLinkTable::class,
                Join::on('this.LINK_ID', 'ref.ID'),
            )),
            (new ReferenceField(
                'USER',
                UserTable::getEntity(),
                Join::on('this.MEMBER_ID', 'ref.ID'),
                ['join_type' => Join::TYPE_LEFT]
            )),
            (new ReferenceField(
                'IMAGE',
                FileTable::class,
                Join::on('this.USER.PERSONAL_PHOTO', 'ref.ID'),
                ['join_type' => Join::TYPE_LEFT]
            ))
        ];
    }
}