CAllPerfomanceTable::GetList

function GetList($arSelect, $arFilter, $arOrder = array(), $arNavParams = false)
{
	global $DB;

	$arFields = $this->GetTableFields();

	if (!is_array($arSelect))
		$arSelect = array();
	if (count($arSelect) < 1)
		$arSelect = array_keys($arFields);

	if (!is_array($arOrder))
		$arOrder = array();

	$arQueryOrder = array();
	foreach ($arOrder as $strColumn => $strDirection)
	{
		$strDirection = mb_strtoupper($strDirection) == "ASC"? "ASC": "DESC";
		if (array_key_exists($strColumn, $arFields))
		{
			$arSelect[] = $strColumn;
			if ($arFields[$strColumn] == "datetime" || $arFields[$strColumn] == "date")
				$arQueryOrder[$strColumn] = $this->escapeColumn("TMP_".$strColumn)." ".$strDirection;
			else
				$arQueryOrder[$strColumn] = $this->escapeColumn($strColumn)." ".$strDirection;
		}
	}

	$arQuerySelect = array();
	foreach ($arSelect as $strColumn)
	{
		if (array_key_exists($strColumn, $arFields))
		{
			if ($arFields[$strColumn] == "datetime" || $arFields[$strColumn] == "date")
			{
				$arQuerySelect["TMP_".$strColumn] = "t.".$this->escapeColumn($strColumn)." TMP_".$strColumn;
				$arQuerySelect[$strColumn] = $DB->DateToCharFunction("t.".$this->escapeColumn($strColumn), "SHORT")." ".$this->escapeColumn($strColumn);
				$arQuerySelect["FULL_".$strColumn] = $DB->DateToCharFunction("t.".$this->escapeColumn($strColumn), "FULL")." FULL_".$strColumn;
				$arQuerySelect["SHORT_".$strColumn] = $DB->DateToCharFunction("t.".$this->escapeColumn($strColumn), "SHORT")." SHORT_".$strColumn;
			}
			else
			{
				$arQuerySelect[$strColumn] = "t.".$this->escapeColumn($strColumn);
			}
		}
	}

	foreach ($arFields as $FIELD_NAME => $FIELD_TYPE)
	{
		$arFields[$FIELD_NAME] = array(
			"TABLE_ALIAS" => "t",
			"FIELD_NAME" => "t.".$this->escapeColumn($FIELD_NAME),
			"FIELD_TYPE" => $FIELD_TYPE,
			"JOIN" => false,
			//"LEFT_JOIN" => "lt",
		);
	}
	$obQueryWhere = new CSQLWhere;
	$obQueryWhere->SetFields($arFields);

	if (count($arQuerySelect) < 1)
		$arQuerySelect = array("*" => "t.*");

	$strSelect = "SELECT ".implode(", ", $arQuerySelect)."n";

	$strSql = "FROM ".$this->escapeTable($this->TABLE_NAME)." tn";
	$strQueryWhere = $obQueryWhere->GetQuery($arFilter);
	if ($strQueryWhere)
	{
		$strSql .= "WHERE ".$strQueryWhere."n";
	}
	$strOrder = $arQueryOrder ? "ORDER BY ".implode(", ", $arQueryOrder) : "";

	if (!is_array($arNavParams))
	{
		$dbr = $DB->Query($strSelect.$strSql.$strOrder, false, "File: ".__FILE__."
Line: ".__LINE__);
	}
	elseif ($arNavParams["nTopCount"] > 0)
	{
		$strSql = $strSelect.$strSql.$strOrder."nLIMIT ".intval($arNavParams["nTopCount"]);
		if ($arNavParams["nOffset"] > 0)
		{
			$strSql .= " OFFSET ".intval($arNavParams["nOffset"]);
		}
		$dbr = $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
	}
	else
	{
		$res_cnt = $DB->Query("SELECT count('x') CNT ".$strSql);
		$ar_cnt = $res_cnt->Fetch();
		if (isset($arNavParams["bOnlyCount"]) && $arNavParams["bOnlyCount"] === true)
		{
			return $ar_cnt["CNT"];
		}

		$dbr = new CDBResult();
		$dbr->NavQuery($strSelect.$strSql.$strOrder, $ar_cnt["CNT"], $arNavParams);
	}

	$dbr->is_filtered = ($strQueryWhere <> '');

	return $dbr;
}