CLTestMark::GetList

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

	$arSqlSearch = CLTestMark::GetFilter($arFilter);

	$strSqlSearch = "";
	for($i=0; $i '')
			$strSqlSearch .= " AND ".$arSqlSearch[$i]." ";

	$strSql =
	"SELECT TM.* ".
	"FROM b_learn_test_mark TM ".
	"WHERE 1=1 ".
	$strSqlSearch;

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

	$arSqlOrder = [];
	foreach($arOrder as $by=>$order)
	{
		$by = mb_strtolower($by);
		$order = mb_strtolower($order);
		if ($order!="asc")
			$order = "desc";

		if ($by == "id") $arSqlOrder[] = " TM.ID ".$order." ";
		elseif ($by == "mark") $arSqlOrder[] = " TM.MARK ".$order." ";
		elseif ($by == "score") $arSqlOrder[] = " TM.SCORE ".$order." ";
		elseif ($by == "rand") $arSqlOrder[] = CTest::GetRandFunction();
		else
		{
			$arSqlOrder[] = " TM.ID ".$order." ";
			$by = "id";
		}
	}

	$strSqlOrder = "";
	DelDuplicateSort($arSqlOrder);
	for ($i=0; $iQuery($strSql, false, "File: ".__FILE__."
Line: ".__LINE__);
}