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

use Bitrix\Main;
use Bitrix\Main\DB;
use Bitrix\Main\Entity;
use Bitrix\Main\Localization\Loc;

use Bitrix\Sale\Location;
use Bitrix\Sale\Location\DB\Helper;

Loc::loadMessages(__FILE__);

/**
 * Class SiteLinkTable
 *
 * DO NOT WRITE ANYTHING BELOW THIS
 *
 * <<< ORMENTITYANNOTATION
 * @method static EO_SiteLink_Query query()
 * @method static EO_SiteLink_Result getByPrimary($primary, array $parameters = [])
 * @method static EO_SiteLink_Result getById($id)
 * @method static EO_SiteLink_Result getList(array $parameters = [])
 * @method static EO_SiteLink_Entity getEntity()
 * @method static \Bitrix\Sale\Location\Search\EO_SiteLink createObject($setDefaultValues = true)
 * @method static \Bitrix\Sale\Location\Search\EO_SiteLink_Collection createCollection()
 * @method static \Bitrix\Sale\Location\Search\EO_SiteLink wakeUpObject($row)
 * @method static \Bitrix\Sale\Location\Search\EO_SiteLink_Collection wakeUpCollection($rows)
 */
final class SiteLinkTable extends Entity\DataManager
{
	public static function getFilePath()
	{
		return __FILE__;
	}

	public static function getTableName()
	{
		return 'b_sale_loc_search_sitlnk';
	}

	public static function checkTableExists()
	{
		static $tableExists;

		if($tableExists === null)
			$tableExists = Main\HttpApplication::getConnection()->isTableExists(static::getTableName());

		return $tableExists;
	}

	public static function cleanUpData()
	{
		Helper::dropTable(static::getTableName());

		// ORACLE: OK, MSSQL: OK
		$sql = "create table ".static::getTableName()." 
			(
				LOCATION_ID ".Helper::getSqlForDataType('int').",
				SITE_ID ".Helper::getSqlForDataType('char', 2).",

				primary key (LOCATION_ID, SITE_ID)
			)";

		Main\HttpApplication::getConnection()->query($sql);
	}

	public static function initializeData()
	{
		$locationTable = Location\LocationTable::getTableName();
		$groupLocationTable = Location\GroupLocationTable::getTableName();
		$siteLocationTable = Location\SiteLocationTable::getTableName();

		// ORACLE: OK, MSSQL: OK
		$sql = "
			insert into ".static::getTableName()." 
				(LOCATION_ID, SITE_ID) 
			select LC.ID, LS.SITE_ID
				from ".$siteLocationTable." LS
					inner join ".$locationTable." L on LS.LOCATION_ID = L.ID and LS.LOCATION_TYPE = 'L'
					inner join ".$locationTable." LC on LC.LEFT_MARGIN >= L.LEFT_MARGIN and LC.RIGHT_MARGIN <= L.RIGHT_MARGIN
			union 
			select LC.ID, LS.SITE_ID
				from ".$siteLocationTable." LS
					inner join ".$groupLocationTable." LG on LS.LOCATION_ID = LG.LOCATION_GROUP_ID and LS.LOCATION_TYPE = 'G'
					inner join ".$locationTable." L on LG.LOCATION_ID = L.ID
					inner join ".$locationTable." LC on LC.LEFT_MARGIN >= L.LEFT_MARGIN and LC.RIGHT_MARGIN <= L.RIGHT_MARGIN
		";

		Main\HttpApplication::getConnection()->query($sql);
	}

	public static function createIndex()
	{
		Helper::createIndex(static::getTableName(), 'S', array('SITE_ID'));
	}

	public static function getMap()
	{
		return array(

			'LOCATION_ID' => array(
				'data_type' => 'integer',
				'required' => true,
				'primary' => true
			),
			'SITE_ID' => array(
				'data_type' => 'integer',
				'required' => true,
				'primary' => true
			),
		);
	}
}