ratelocation.php

<?php
namespace Bitrix\Sale\Tax;
 
use Bitrix\Sale;
 
final class RateLocationTable extends Sale\Location\Connector
{
    public static function getFilePath()
    {
        return __FILE__;
    }
 
    public static function getTableName()
    {
        return 'b_sale_tax2location';
    }
 
    public static function getLinkField()
    {
        return 'TAX_RATE_ID';
    }
 
    public static function getTargetEntityName()
    {
        return 'Bitrix\Sale\Tax\Rate';
    }
 
    public static function getLocationLinkField()
    {
        return 'LOCATION_CODE';
    }
 
    public static function getMap()
    {
        return array(
            
            'TAX_RATE_ID' => array(
                'data_type' => 'integer',
                'required' => true,
                'primary' => true
            ),
            'LOCATION_CODE' => array(
                'data_type' => 'string',
                'required' => true,
                'primary' => true
            ),
            'LOCATION_TYPE' => array(
                'data_type' => 'string',
                'default_value' => self::DB_LOCATION_FLAG,
                'required' => true,
                'primary' => true
            ),
 
            // virtual
            'LOCATION' => array(
                'data_type' => '\Bitrix\Sale\Location\Location',
                'reference' => array(
                    '=this.LOCATION_CODE' => 'ref.CODE',
                    '=this.LOCATION_TYPE' => array('?', self::DB_LOCATION_FLAG)
                )
            ),
            'GROUP' => array(
                'data_type' => '\Bitrix\Sale\Location\Group',
                'reference' => array(
                    '=this.LOCATION_CODE' => 'ref.CODE',
                    '=this.LOCATION_TYPE' => array('?', self::DB_GROUP_FLAG)
                )
            ),
 
            'RATE' => array(
                'data_type' => static::getTargetEntityName(),
                'reference' => array(
                    '=this.TAX_RATE_ID' => 'ref.ID'
                )
            ),
        );
    }
}