CFilterLetter::GetList

static function GetList($arOrder = array("ID"=>"ASC"), $arFilter = array(), $bCount = false)
{
	global $DB;
	$arSqlSearch = array();
	$strSqlSearch = "";
	$arSqlOrder = array();
	$strSqlOrder = "";
	$arFilter = (is_array($arFilter) ? $arFilter : array());
	
	foreach ($arFilter as $key => $val)
	{
		$key_res = CFilterDictionary::GetFilterOperation($key);
		$key = mb_strtoupper($key_res["FIELD"]);
		$strNegative = $key_res["NEGATIVE"];
		$strOperation = $key_res["OPERATION"];

		switch ($key)
		{
			case "LETTER":
			case "REPLACEMENT":
				if ($val == '')
					$arSqlSearch[] = ($strNegative=="Y"?"NOT":"")."(FL.".$key." IS NULL OR LENGTH(FL.".$key.")<=0)";
				else
					$arSqlSearch[] = ($strNegative=="Y"?" FL.".$key." IS NULL OR NOT ":"")."(FL.".$key." ".$strOperation." '".$DB->ForSql($val)."' )";
				break;
			case "DICTIONARY_ID":
			case "ID":
				if ($strOperation!="IN")
				{
					if (intval($val)<=0)
						$arSqlSearch[] = ($strNegative=="Y"?"NOT":"")."(FL.".$key." IS NULL OR FL.".$key."<=0)";
					else
						$arSqlSearch[] = ($strNegative=="Y"?" FL.".$key." IS NULL OR NOT ":"")."(FL.".$key." ".$strOperation." ".intval($val)." )";
				}
				else
				{
					if (!is_array($val))
						$val = explode(',', $val);
					$val_int=array();
					foreach($val as $v)
						$val_int[] = intval($v);
					$val = implode(', ', $val_int);
					$arSqlSearch[] = ($strNegative=="Y"?" NOT ":"")."(FL.".$key." IN (".$DB->ForSql($val).") )";
				}
				break;
		}
	}
	if (!empty($arSqlSearch))
		$strSqlSearch = " AND (".implode(") AND (", $arSqlSearch).") ";

	foreach ($arOrder as $by=>$order)
	{
		$by = mb_strtoupper($by);
		$order = mb_strtoupper($order);
		if ($order!="ASC") $order = "DESC";
		if ($by == "ID") $arSqlOrder[] = " FL.ID ".$order." ";
		elseif ($by == "TITLE") $arSqlOrder[] = " FD.TITLE ".$order." ";
		elseif ($by == "LETTER") $arSqlOrder[] = " FL.LETTER ".$order." ";
		elseif ($by == "REPLACEMENT") $arSqlOrder[] = " FL.REPLACEMENT ".$order." ";
		else
		{
			$arSqlOrder[] = " FL.ID ".$order." ";
			$by = "ID";
		}
	}
	DelDuplicateSort($arSqlOrder); 
	if (!empty($arSqlOrder))
		$strSqlOrder = " ORDER BY ".implode(") AND (", $arSqlOrder);

	if ($bCount)
	{
		$strSql = "SELECT COUNT(FD.ID) as CNT ".
			"FROM b_forum_letter FL, b_forum_dictionary FD ".
			"WHERE (FL.DICTIONARY_ID = FD.ID) ".
			$strSqlSearch;
		$db_res = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
		$iCnt = 0;
		if ($ar_res = $db_res->Fetch())
			$iCnt = intval($ar_res["CNT"]);
		return $iCnt;
	}
	$strSql = 
		"SELECT FL.ID, FL.LETTER, FL.REPLACEMENT, FL.DICTIONARY_ID, FD.TITLE ".
		"FROM b_forum_letter FL, b_forum_dictionary FD ".
		"WHERE (FL.DICTIONARY_ID = FD.ID) ".
		$strSqlSearch.
		$strSqlOrder;
	$db_res = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
	return $db_res;
}