publishertable.php

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

<?php
 
namespace Bitrix\Main\Test\Typography;
 
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Fields\IntegerField;
use Bitrix\Main\ORM\Fields\StringField;
 
use Bitrix\Main\ORM\Fields\Relations\OneToMany;

class PublisherTable extends DataManager
{
    public static function getTableName()
    {
        return '(
            (SELECT 253 AS ID, "Publisher Title 253" AS TITLE, 2 AS BOOKS_COUNT)
            UNION
            (SELECT 254 AS ID, "Publisher Title 254" AS TITLE, 0 AS BOOKS_COUNT)
        )';
    }
 
    public static function getMap()
    {
        return [
            (new IntegerField('ID'))
                ->configurePrimary()
                ->configureAutocomplete(),
 
            (new StringField('TITLE')),
 
            (new IntegerField('BOOKS_COUNT')),
 
            (new OneToMany('BOOKS', BookTable::class, 'PUBLISHER'))
                ->configureJoinType('left')
        ];
    }
 
}