payableitem.php

<?php
 
namespace Bitrix\Sale\Internals;
 
use Bitrix\Main;
use Bitrix\Main\ORM\Fields\Relations\Reference;
use Bitrix\Main\ORM\Query\Join;
use Bitrix\Sale;
 
class PayableItemTable extends Main\ORM\Data\DataManager
{
    public static function getTableName()
    {
        return 'b_sale_order_payment_item';
    }
 
    public static function getMap()
    {
        global $DB;
 
        return [
            'ID' => [
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ],
            'ENTITY_ID' => [
                'data_type' => 'integer',
                'required' => true,
            ],
            'ENTITY_TYPE' => [
                'data_type' => 'enum',
                'required' => true,
                'values' => [
                    Sale\Registry::ENTITY_BASKET_ITEM,
                    Sale\Registry::ENTITY_SHIPMENT,
                ]
            ],
            'PAYMENT_ID' => [
                'data_type' => 'integer',
                'required' => true,
            ],
            'DATE_INSERT' => [
                'data_type' => 'datetime'
            ],
            'DATE_INSERT_SHORT' => [
                'data_type' => 'datetime',
                'expression' => [
                    $DB->datetimeToDateFunction('%s'), 'DATE_INSERT'
                ]
            ],
            'QUANTITY' => [
                'data_type' => 'float',
                'required' => true,
            ],
            'XML_ID' => [
                'data_type' => 'string'
            ],
            //
            'PAYMENT' => new Reference(
                'PAYMENT',
                PaymentTable::class,
                Join::on('this.PAYMENT_ID', 'ref.ID')
            ),
            'BASKET' => new Reference(
                'BASKET',
                BasketTable::class,
                Join::on('this.ENTITY_ID', 'ref.ID')->where('this.ENTITY_TYPE', Sale\Registry::ENTITY_BASKET_ITEM)
            ),
            'SHIPMENT' => new Reference(
                'SHIPMENT',
                ShipmentTable::class,
                Join::on('this.ENTITY_ID', 'ref.ID')->where('this.ENTITY_TYPE', Sale\Registry::ENTITY_SHIPMENT)
            ),
        ];
    }
}