usertransacttable.php

<?php
 
namespace Bitrix\Sale\Internals;
 
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Fields\BooleanField;
use Bitrix\Main\ORM\Fields\DatetimeField;
use Bitrix\Main\ORM\Fields\FloatField;
use Bitrix\Main\ORM\Fields\IntegerField;
use Bitrix\Main\ORM\Fields\Relations\Reference;
use Bitrix\Main\ORM\Fields\StringField;
use Bitrix\Main\ORM\Fields\TextField;
use Bitrix\Main\ORM\Fields\Validators\LengthValidator;
use Bitrix\Main\ORM\Query\Join;
use Bitrix\Main\Type\DateTime;
 
class UserTransactTable extends DataManager
{
    public static function getTableName()
    {
        return 'b_sale_user_transact';
    }
 
    public static function getMap()
    {
        return [
            'ID' =>
                (new IntegerField('ID'))
                    ->configurePrimary(true)
                    ->configureAutocomplete(true)
            ,
            'USER_ID' =>
                (new IntegerField('USER_ID'))
                    ->configureRequired(true)
            ,
            'TIMESTAMP_X' =>
                (new DatetimeField('TIMESTAMP_X'))
                    ->configureDefaultValue(
                        static function()
                        {
                            return new DateTime();
                        }
                    )
            ,
            'TRANSACT_DATE' =>
                (new DatetimeField('TRANSACT_DATE'))
                    ->configureRequired(true)
            ,
            'AMOUNT' =>
                (new FloatField('AMOUNT'))
                    ->configureDefaultValue(0.0000)
            ,
            'CURRENCY' =>
                (new StringField('CURRENCY'))
                    ->configureRequired(true)
                    ->addValidator(new LengthValidator(null, 3))
            ,
            'DEBIT' => (new BooleanField('DEBIT'))
                ->configureValues('N', 'Y')
                ->configureDefaultValue('N')
            ,
            'ORDER_ID' => (new IntegerField('ORDER_ID')),
            'DESCRIPTION' =>
                (new StringField('DESCRIPTION'))
                    ->configureRequired(true)
                    ->addValidator(new LengthValidator(null, 255))
            ,
            'NOTES' => (new TextField('NOTES')),
            'PAYMENT_ID' => (new IntegerField('PAYMENT_ID')),
            'EMPLOYEE_ID' => (new IntegerField('EMPLOYEE_ID')),
            //
            new Reference(
                'ORDER',
                OrderTable::class,
                Join::on('this.ORDER_ID', 'ref.ID')
            ),
            new Reference(
                'PAYMENT',
                PaymentTable::class,
                Join::on('this.PAYMENT_ID', 'ref.ID')
            ),
        ];
    }
}