location.php

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

<?php
namespace Bitrix\Sale\Location\Name;
 
use Bitrix\Main;
use Bitrix\Main\Entity;
use Bitrix\Sale\Location;
use Bitrix\Main\Localization\Loc;
 
Loc::loadMessages(__FILE__);

class LocationTable extends NameEntity
{
    public static function getFilePath()
    {
        return __FILE__;
    }
 
    public static function getTableName()
    {
        return 'b_sale_loc_name';
    }
 
    public static function add(array $data)
    {
        if($data['NAME'] <> '')
        {
            $data['NAME_UPPER'] = mb_strtoupper($data['NAME']); // bitrix to upper
 
            if(!isset($data['NAME_NORM']) && isset($data['LANGUAGE_ID']))
            {
                $data['NAME_NORM'] = Location\Normalizer\Builder::build($data['LANGUAGE_ID'])->normalize($data['NAME']);
            }
        }
 
        return parent::add($data);
    }
 
    public static function update($primary, array $data)
    {
        if($data['NAME'] <> '')
        {
            $data['NAME_UPPER'] = mb_strtoupper($data['NAME']); // bitrix to upper
 
            if(!isset($data['NAME_NORM']) && isset($data['LANGUAGE_ID']))
            {
                $data['NAME_NORM'] = Location\Normalizer\Builder::build($data['LANGUAGE_ID'])->normalize($data['NAME']);
            }
        }
 
        return parent::update($primary, $data);
    }
 
    public static function getReferenceFieldName()
    {
        return 'LOCATION_ID';
    }
 
    public static function getMap()
    {
        return array(
 
            'ID' => array(
                'data_type' => 'integer',
                'primary' => true,
                'autocomplete' => true,
            ),
            'NAME' => array(
                'data_type' => 'string',
                'required' => true,
                'title' => Loc::getMessage('SALE_LOCATION_NAME_LOCATION_ENTITY_NAME_FIELD')
            ),
            'NAME_UPPER' => array(
                'data_type' => 'string',
            ),
            'SHORT_NAME' => array(
                'data_type' => 'string',
                'title' => Loc::getMessage('SALE_LOCATION_NAME_LOCATION_ENTITY_SHORT_NAME_FIELD')
            ),
            'NAME_NORM' => array(
                'data_type' => 'string',
            ),
            'LANGUAGE_ID' => array(
                'data_type' => 'string',
                'required' => true,
                'title' => Loc::getMessage('SALE_LOCATION_NAME_LOCATION_ENTITY_LANGUAGE_ID_FIELD')
            ),
 
            'LOCATION_ID' => array(
                'data_type' => 'integer',
                'required' => true,
                'title' => Loc::getMessage('SALE_LOCATION_NAME_LOCATION_ENTITY_LOCATION_ID_FIELD')
            ),
            'LOCATION' => array(
                'data_type' => 'Bitrix\Sale\Location\Location',
                'required' => true,
                'reference' => array(
                    '=this.LOCATION_ID' => 'ref.ID'
                )
            ),
 
            'CNT' => array(
                'data_type' => 'integer',
                'expression' => array(
                    'count(*)'
                )
            ),
        );
    }
}