currencylang.php

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

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

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

    public static function getMap(): array
    {
        return [
            'CURRENCY' => (new ORM\Fields\StringField('CURRENCY'))
                ->configurePrimary(true)
                ->addValidator(new ORM\Fields\Validators\LengthValidator(null, 3))
                ->configureTitle(Loc::getMessage('CURRENCY_LANG_ENTITY_CURRENCY_FIELD'))
            ,
            'LID' => (new ORM\Fields\StringField('LID'))
                ->configurePrimary(true)
                ->addValidator(new ORM\Fields\Validators\LengthValidator(2, 2))
                ->configureTitle(Loc::getMessage('CURRENCY_LANG_ENTITY_LID_FIELD'))
            ,
            'FORMAT_STRING' => (new ORM\Fields\StringField('FORMAT_STRING'))
                ->configureRequired(true)
                ->addValidator(new ORM\Fields\Validators\LengthValidator(null, 50))
                ->configureTitle(Loc::getMessage('CURRENCY_LANG_ENTITY_FORMAT_STRING_FIELD'))
            ,
            'FULL_NAME' => (new ORM\Fields\StringField('FULL_NAME'))
                ->addValidator(new ORM\Fields\Validators\LengthValidator(null, 50))
                ->configureTitle(Loc::getMessage('CURRENCY_LANG_ENTITY_FULL_NAME_FIELD'))
            ,
            'DEC_POINT' => (new ORM\Fields\StringField('DEC_POINT'))
                ->configureDefaultValue('.')
                ->addValidator(new ORM\Fields\Validators\LengthValidator(null, 16))
                ->configureTitle(Loc::getMessage('CURRENCY_LANG_ENTITY_DEC_POINT_FIELD'))
            ,
            'THOUSANDS_SEP' => (new ORM\Fields\StringField('THOUSANDS_SEP'))
                ->configureDefaultValue(' ')
                ->addValidator(new ORM\Fields\Validators\LengthValidator(null, 16))
                ->configureTitle(Loc::getMessage('CURRENCY_LANG_ENTITY_THOUSANDS_SEP_FIELD'))
            ,
            'DECIMALS' => (new ORM\Fields\IntegerField('DECIMALS'))
                ->configureDefaultValue(2)
                ->configureTitle(Loc::getMessage('CURRENCY_LANG_ENTITY_DECIMALS_FIELD'))
            ,
            'THOUSANDS_VARIANT' => (new ORM\Fields\StringField('THOUSANDS_VARIANT'))
                ->addValidator(new ORM\Fields\Validators\LengthValidator(null, 1))
                ->configureTitle(Loc::getMessage('CURRENCY_LANG_ENTITY_THOUSANDS_VARIANT_FIELD'))
            ,
            'HIDE_ZERO' => (new ORM\Fields\BooleanField('HIDE_ZERO'))
                ->configureValues('N', 'Y')
                ->configureDefaultValue('N')
                ->configureTitle(Loc::getMessage('CURRENCY_LANG_ENTITY_HIDE_ZERO_FIELD'))
            ,
            'CREATED_BY' => (new ORM\Fields\IntegerField('CREATED_BY'))
                ->configureTitle(Loc::getMessage('CURRENCY_LANG_ENTITY_CREATED_BY_FIELD'))
            ,
            'DATE_CREATE' => (new ORM\Fields\DatetimeField('DATE_CREATE'))
                ->configureDefaultValue(static fn() => new Type\DateTime())
                ->configureTitle(Loc::getMessage('CURRENCY_LANG_ENTITY_DATE_CREATE_FIELD'))
            ,
            'MODIFIED_BY' => (new ORM\Fields\IntegerField('MODIFIED_BY'))
                ->configureTitle(Loc::getMessage('CURRENCY_LANG_ENTITY_MODIFIED_BY_FIELD'))
            ,
            'TIMESTAMP_X' => (new ORM\Fields\DatetimeField('TIMESTAMP_X'))
                ->configureRequired(true)
                ->configureDefaultValue(static fn() => new Type\DateTime())
                ->configureTitle(Loc::getMessage('CURRENCY_LANG_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)
            ,
            'LANGUAGE' => (new ORM\Fields\Relations\Reference(
                'LANGUAGE',
                'Bitrix\Main\Localization\Language',
                ORM\Query\Join::on('this.LID', 'ref.LID')
            ))->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();
    }

    public static function cleanCache(): void
    {
        parent::cleanCache();
        CurrencyTable::cleanCache();
    }
 
    public static function onLanguageAddHandler(array|Event $event): void
    {
        if ($event instanceof Event)
        {
            $primary = $event->getParameter('primary');
            $languageId = $primary['LID'] ?? null;
        }
        else
        {
            $languageId = $event['LID'] ?? null;
        }
 
        if (!$languageId)
        {
            return;
        }
 
        self::addCurrencyLanguagesByLanguageId((string)$languageId);
    }
 
    private static function addCurrencyLanguagesByLanguageId(string $languageId): void
    {
        $existCurrencies = \Bitrix\Currency\CurrencyTable::getList(['select' => ['CURRENCY']])->fetchAll();
        foreach ($existCurrencies as $existCurrency)
        {
            $existsCurrencyCode = $existCurrency['CURRENCY'];
            $currencyLangData = CurrencyLangTable::getRow(
                [
                    'select' => ['CURRENCY', 'LID'],
                    'filter' => [
                        '=CURRENCY' => $existsCurrencyCode,
                        '=LID' => $languageId,
                    ],
                ],
            );
            if ($currencyLangData)
            {
                continue;
            }
 
            $currencyClassifierData = CurrencyClassifier::getCurrency(
                $existsCurrencyCode,
                [$languageId]
            );
            if (!$currencyClassifierData)
            {
                continue;
            }
 
            $languageData = $currencyClassifierData[mb_strtoupper($languageId)];
            $datetimeEntity = new \Bitrix\Main\DB\SqlExpression(
                \Bitrix\Main\Application::getConnection()->getSqlHelper()->getCurrentDateTimeFunction()
            );
            self::add([
                'CURRENCY' => $existsCurrencyCode,
                'LID' => $languageId,
                'FORMAT_STRING' => str_replace('#VALUE#', '#', $languageData['FORMAT_STRING']),
                'FULL_NAME' => $languageData['FULL_NAME'],
                'DEC_POINT' => $languageData['DEC_POINT'],
                'THOUSANDS_SEP' => null,
                'DECIMALS' => $languageData['DECIMALS'],
                'THOUSANDS_VARIANT' => $languageData['THOUSANDS_VARIANT'],
                'HIDE_ZERO' => 'Y',
                'CREATED_BY' => null,
                'DATE_CREATE' => $datetimeEntity,
                'MODIFIED_BY' => null,
                'TIMESTAMP_X' => $datetimeEntity,
            ]);
            \Bitrix\Currency\CurrencyManager::clearCurrencyCache();
        }
    }
}