usertransacttable.php

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

<?php
 
namespace Bitrix\Sale\Internals;
 
use Bitrix\Main\ORM\Data\DataManager;
use Bitrix\Main\ORM\Event;
use Bitrix\Main\ORM\EventResult;
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')
            ),
        ];
    }

    public static function onBeforeAdd(Event $event): EventResult
    {
        $result = new EventResult;
        $data = $event->getParameter('fields');
        if (!isset($data['TIMESTAMP_X']))
        {
            $result->modifyFields([
                'TIMESTAMP_X' => new DateTime(),
            ]);
        }
 
        return $result;
    }

    public static function onBeforeUpdate(Event $event): EventResult
    {
        $result = new EventResult;
        $data = $event->getParameter('fields');
        if (!isset($data['TIMESTAMP_X']))
        {
            $result->modifyFields([
                'TIMESTAMP_X' => new DateTime(),
            ]);
        }
 
        return $result;
    }
}