<?php

class CAllCatalogLoad
{
	function GetList($arOrder=Array("LAST_USED"=>"DESC"), $arFilter=Array())
	{
		global $DB;
		$arSqlSearch = Array();

		if(!is_array($arFilter))
			$filter_keys = Array();
		else
			$filter_keys = array_keys($arFilter);

		for ($i = 0, $max = count($filter_keys); $i < $max; $i++)
		{
			$val = $DB->ForSql($arFilter[$filter_keys[$i]]);
			if ($val == '') continue;

			$key = $filter_keys[$i];
			if ($key[0]=="!")
			{
				$key = mb_substr($key, 1);
				$bInvert = true;
			}
			else
				$bInvert = false;

			switch(mb_strtoupper($key))
			{
				case "NAME":
					$arSqlSearch[] = "CL.NAME ".($bInvert? "<>" : "=")." '".$val."'";
					break;
				case "TYPE":
					$arSqlSearch[] = "CL.TYPE ".($bInvert? "<>" : "=")." '".$val."'";
					break;
			}
		}

		$strSqlSearch = "";
		for ($i = 0, $max = count($arSqlSearch); $i < $max; $i++)
		{
			$strSqlSearch .= " AND ";
			$strSqlSearch .= " (".$arSqlSearch[$i].") ";
		}

		$strSql =
			"SELECT CL.NAME, CL.VALUE, CL.TYPE, CL.LAST_USED ".
			"FROM b_catalog_load CL ".
			"WHERE 1 = 1 ".
			"	".$strSqlSearch." ";

		$arSqlOrder = Array();
		foreach ($arOrder as $by=>$order)
		{
			$by = mb_strtoupper($by);
			$order = mb_strtoupper($order);
			if ($order!="ASC") $order = "DESC";

			if ($by == "NAME") $arSqlOrder[] = " CL.NAME ".$order." ";
			elseif ($by == "TYPE") $arSqlOrder[] = " CL.TYPE ".$order." ";
			else
			{
				$arSqlOrder[] = " CL.LAST_USED ".$order." ";
				$by = "LAST_USED";
			}
		}

		$strSqlOrder = "";
		DelDuplicateSort($arSqlOrder);
		for ($i = 0, $max = count($arSqlOrder); $i < $max; $i++)
		{
			if ($i==0)
				$strSqlOrder = " ORDER BY ";
			else
				$strSqlOrder .= ", ";

			$strSqlOrder .= $arSqlOrder[$i];
		}

		$strSql .= $strSqlOrder;

		return $DB->Query($strSql);
	}

	function Add($arFields)
	{
		global $DB;

		if ($arFields["TYPE"]!="E") $arFields["TYPE"] = "I";

		$arInsert = $DB->PrepareInsert("b_catalog_load", $arFields);

		$strSql =
			"INSERT INTO b_catalog_load(".$arInsert[0].") ".
			"VALUES(".$arInsert[1].")";
		$DB->Query($strSql);

		return true;
	}

	function Delete($ID)
	{
		global $DB;
		return $DB->Query("DELETE FROM b_catalog_load WHERE NAME = '".intval($ID)."' ", true);
	}

	function SetLastUsed($NAME, $TYPE)
	{
		global $DB;

		$DB->Query(
			"UPDATE b_catalog_load SET ".
			"	LAST_USED = 'N' ".
			"WHERE TYPE = '".$DB->ForSql($TYPE)."'");

		$DB->Query(
			"UPDATE b_catalog_load SET ".
			"	LAST_USED = 'Y' ".
			"WHERE NAME = '".$DB->ForSql($NAME)."' ".
			"	AND TYPE = '".$DB->ForSql($TYPE)."'");

		return true;
	}
}