grouplocation.php

<?php
namespace Bitrix\Sale\Location;
 
class GroupLocationTable extends Connector
{
    public static function getFilePath()
    {
        return __FILE__;
    }
 
    public static function getTableName()
    {
        return 'b_sale_location2location_group';
    }
 
    public static function getTypeField()
    {
        return '';
    }
 
    public static function getLinkField()
    {
        return 'LOCATION_GROUP_ID';
    }
 
    public static function getTargetEntityName()
    {
        return 'Bitrix\Sale\Location\Group';
    }
 
    public static function getUseGroups()
    {
        return false;
    }
 
    public static function getMap()
    {
        return array(
 
            'LOCATION_ID' => array(
                'data_type' => 'integer',
                'primary' => true,
                'required' => true
            ),
 
            'LOCATION_GROUP_ID' => array(
                'data_type' => 'integer',
                'primary' => true,
                'required' => true
            ),
 
            // alias
            'GROUP_ID' => array(
                'data_type' => 'integer',
                'expression' => array(
                    '%u',
                    'LOCATION_GROUP_ID'
                )
            ),
 
            // virtual
            'LOCATION' => array(
                'data_type' => '\Bitrix\Sale\Location\Location',
                'reference' => array(
                    '=this.LOCATION_ID' => 'ref.ID'
                )
            ),
 
            // alias
            'GROUP' => array(
                'data_type' => '\Bitrix\Sale\Location\Group',
                'reference' => array(
                    '=this.LOCATION_GROUP_ID' => 'ref.ID'
                )
            ),
        );
    }
 
    public static function deleteByGroupId($groupId)
    {
        if(intval($groupId) <= 0)
            return;
 
        $con = \Bitrix\Main\Application::getConnection();
        $con->queryExecute("DELETE FROM ".self::getTableName()." WHERE LOCATION_GROUP_ID=".intval($groupId));
    }
}