<?php
/**
 * Bitrix Framework
 * @package bitrix
 * @subpackage sale
 * @copyright 2001-2012 Bitrix
 */
namespace Bitrix\Sale\Location;

/**
 * Class GroupLocationTable
 *
 * DO NOT WRITE ANYTHING BELOW THIS
 *
 * <<< ORMENTITYANNOTATION
 * @method static EO_GroupLocation_Query query()
 * @method static EO_GroupLocation_Result getByPrimary($primary, array $parameters = [])
 * @method static EO_GroupLocation_Result getById($id)
 * @method static EO_GroupLocation_Result getList(array $parameters = [])
 * @method static EO_GroupLocation_Entity getEntity()
 * @method static \Bitrix\Sale\Location\EO_GroupLocation createObject($setDefaultValues = true)
 * @method static \Bitrix\Sale\Location\EO_GroupLocation_Collection createCollection()
 * @method static \Bitrix\Sale\Location\EO_GroupLocation wakeUpObject($row)
 * @method static \Bitrix\Sale\Location\EO_GroupLocation_Collection wakeUpCollection($rows)
 */
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));
	}
}