- Модуль: main
- Путь к файлу: ~/bitrix/modules/main/classes/general/rating_rule.php
- Класс: CRatingRule
- Вызов: CRatingRule::GetVetting
static function GetVetting($arFilter, $arSort)
{
global $DB;
$err_mess = (CRatingRule::err_mess())."
Function: GetVetting
Line: ";
$arSqlSearch = array();
if (is_array($arFilter))
{
$filter_keys = array_keys($arFilter);
for ($i=0; $i$val)
{
$ord = (mb_strtoupper($val) <> "ASC"? "DESC":"ASC");
switch(mb_strtoupper($key))
{
case "ID":
$sOrder .= ", ID ".$ord;
break;
case "RULE_ID":
$sOrder .= ", RULE_ID ".$ord;
break;
case "ENTITY_TYPE_ID":
$sOrder .= ", ENTITY_TYPE_ID ".$ord;
break;
case "ENTITY_ID":
$sOrder .= ", ENTITY_ID ".$ord;
break;
case "APPLIED":
$sOrder .= ", APPLIED ".$ord;
break;
}
}
if ($sOrder == '')
$sOrder = "ID ASC";
$strSqlOrder = " ORDER BY ".TrimEx($sOrder,",");
$strSql = "SELECT * FROM b_rating_rule_vetting WHERE $strSqlSearch $strSqlOrder";
return $DB->Query($strSql, false, $err_mess.__LINE__);
}