function GetList($arOrder, $arFilter)
{
/** @global CDatabase $DB */
global $DB;
$arSqlSearch = CTaskReminders::GetFilter($arFilter);
$strSql = "\n\t\t\tSELECT\n\t\t\t\tTR.*,\n\t\t\t\t" . $DB->DateToCharFunction("TR.REMIND_DATE") . " AS REMIND_DATE\n\t\t\tFROM\n\t\t\t\tb_tasks_reminder TR\n\t\t\t" . (sizeof($arSqlSearch) ? "WHERE " . implode(" AND ", $arSqlSearch) : "") . "\n\t\t";
if (!is_array($arOrder)) {
$arOrder = array();
}
foreach ($arOrder as $by => $order) {
$by = strtolower($by);
$order = strtolower($order);
if ($order != "asc") {
$order = "desc";
}
if ($by == "task") {
$arSqlOrder[] = " TR.TASK_ID " . $order . " ";
} elseif ($by == "user") {
$arSqlOrder[] = " TR.USER_ID " . $order . " ";
} elseif ($by == "date") {
$arSqlOrder[] = " TR.REMIND_DATE " . $order . " ";
} elseif ($by == "rand") {
$arSqlOrder[] = CTasksTools::getRandFunction();
} else {
$arSqlOrder[] = " TR.TASK_ID " . $order . " ";
}
}
$strSqlOrder = "";
DelDuplicateSort($arSqlOrder);
$arSqlOrderCnt = count($arSqlOrder);
for ($i = 0; $i < $arSqlOrderCnt; $i++) {
if ($i == 0) {
$strSqlOrder = " ORDER BY ";
} else {
$strSqlOrder .= ",";
}
$strSqlOrder .= $arSqlOrder[$i];
}
$strSql .= $strSqlOrder;
return $DB->Query($strSql, false, "File: " . __FILE__ . "<br>Line: " . __LINE__);
}
