CPerfomanceHistory::GetList

static function GetList($arOrder, $arFilter = array())
{
	global $DB;

	if (!is_array($arOrder))
		$arOrder = array();
	if (count($arOrder) < 1)
		$arOrder = array(
			"ID" => "DESC",
		);

	$arQueryOrder = array();
	foreach ($arOrder as $strColumn => $strDirection)
	{
		$strColumn = mb_strtoupper($strColumn);
		$strDirection = mb_strtoupper($strDirection) == "ASC"? "ASC": "DESC";
		switch ($strColumn)
		{
		case "ID":
			$arQueryOrder[$strColumn] = $strColumn." ".$strDirection;
			break;
		}
	}

	static $arWhereFields = array(
		"ID" => array(
			"TABLE_ALIAS" => "h",
			"FIELD_NAME" => "ID",
			"FIELD_TYPE" => "int",
			"JOIN" => false,
		),
	);

	$obQueryWhere = new CSQLWhere;
	$obQueryWhere->SetFields($arWhereFields);

	$strSql = "
		SELECT
			h.*
			,".$DB->DateToCharFunction("h.TIMESTAMP_X")." TIMESTAMP_X
		FROM
			b_perf_history h
	";
	if (!is_array($arFilter))
		$arFilter = array();
	if ($strQueryWhere = $obQueryWhere->GetQuery($arFilter))
	{
		$strSql .= "
			WHERE
			".$strQueryWhere."
		";
	}
	if (count($arQueryOrder) > 0)
	{
		$strSql .= "
			ORDER BY
			".implode(", ", $arQueryOrder)."
		";
	}

	return $DB->Query($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
}