currencyrate.php

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

<?php
 
namespace Bitrix\Currency;
 
use Bitrix\Main\Application;
use Bitrix\Main\Localization\Loc;
use Bitrix\Main\ORM;
use Bitrix\Main\Type;

 
class CurrencyRateTable extends ORM\Data\DataManager
{
    public static function getTableName(): string
    {
        return 'b_catalog_currency_rate';
    }

    public static function getMap(): array
    {
        return [
            'ID' => (new ORM\Fields\IntegerField('ID'))
                ->configurePrimary(true)
                ->configureAutocomplete(true)
                ->configureTitle(Loc::getMessage('CURRENCY_RATE_ENTITY_ID_FIELD'))
            ,
            'CURRENCY' => (new ORM\Fields\StringField('CURRENCY'))
                ->addValidator(new ORM\Fields\Validators\LengthValidator(null, 3))
                ->configureTitle(Loc::getMessage('CURRENCY_RATE_ENTITY_CURRENCY_FIELD'))
            ,
            'BASE_CURRENCY' => (new ORM\Fields\StringField('BASE_CURRENCY'))
                ->configureTitle(Loc::getMessage('CURRENCY_RATE_ENTITY_BASE_CURRENCY_FIELD'))
            ,
            'DATE_RATE' => (new ORM\Fields\DateField('DATE_RATE'))
                ->configureTitle(Loc::getMessage('CURRENCY_RATE_ENTITY_DATE_RATE_FIELD'))
            ,
            'RATE_CNT' => (new ORM\Fields\IntegerField('RATE_CNT'))
                ->configureTitle(Loc::getMessage('CURRENCY_RATE_ENTITY_RATE_CNT_FIELD'))
            ,
            'RATE' => (new ORM\Fields\FloatField('RATE'))
                ->configureRequired(true)
                ->configureTitle(Loc::getMessage('CURRENCY_RATE_ENTITY_RATE_FIELD'))
            ,
            'CREATED_BY' => (new ORM\Fields\IntegerField('CREATED_BY'))
                ->configureTitle(Loc::getMessage('CURRENCY_RATE_ENTITY_CREATED_BY_FIELD'))
            ,
            'DATE_CREATE' => (new ORM\Fields\DatetimeField('DATE_CREATE'))
                ->configureDefaultValue(static fn() => new Type\DateTime())
                ->configureTitle(Loc::getMessage('CURRENCY_RATE_ENTITY_DATE_CREATE_FIELD'))
            ,
            'MODIFIED_BY' => (new ORM\Fields\IntegerField('MODIFIED_BY'))
                ->configureTitle(Loc::getMessage('CURRENCY_RATE_ENTITY_MODIFIED_BY_FIELD'))
            ,
            'TIMESTAMP_X' => (new ORM\Fields\DatetimeField('TIMESTAMP_X'))
                ->configureRequired(true)
                ->configureDefaultValue(static fn() => new Type\DateTime())
                ->configureTitle(Loc::getMessage('CURRENCY_RATE_ENTITY_TIMESTAMP_X_FIELD'))
            ,
            'CREATED_BY_USER' => (new ORM\Fields\Relations\Reference(
                    'CREATED_BY_USER',
                    'Bitrix\Main\User',
                    ORM\Query\Join::on('this.CREATED_BY', 'ref.ID')
                ))->configureJoinType(ORM\Query\Join::TYPE_LEFT)
            ,
            'MODIFIED_BY_USER' => (new ORM\Fields\Relations\Reference(
                    'MODIFIED_BY_USER',
                    'Bitrix\Main\User',
                    ORM\Query\Join::on('this.MODIFIED_BY', 'ref.ID')
                ))->configureJoinType(ORM\Query\Join::TYPE_LEFT)
            ,
        ];
    }

    public static function deleteByCurrency(string $currency): void
    {
        $currency = trim($currency);
        if ($currency === '')
        {
            return;
        }
        $conn = Application::getConnection();
        $helper = $conn->getSqlHelper();
        $conn->queryExecute(
            'delete from ' . $helper->quote(self::getTableName())
            . ' where ' . $helper->quote('CURRENCY') . ' = \'' . $helper->forSql($currency) . '\''
        );
        unset($helper, $conn);
 
        static::cleanCache();
    }
}