- Модуль: statistic
- Путь к файлу: ~/bitrix/modules/statistic/classes/general/stateventtype.php
- Класс: CAllStatEventType
- Вызов: CAllStatEventType::GetByEvents
static function GetByEvents($event1, $event2)
{
$err_mess = "File: ".__FILE__."
Line: ";
$DB = CDatabase::GetModuleConnection('statistic');
$event1 = $DB->ForSql(trim($event1),200);
$event2 = $DB->ForSql(trim($event2),200);
$where1 = ($event1 == '') ? "(EVENT1='' or EVENT1 is null)" : "(EVENT1 = '$event1')";
$where2 = ($event2 == '') ? "(EVENT2='' or EVENT2 is null)" : "(EVENT2 = '$event2')";
$strSql = "
SELECT
ID as EVENT_ID,
ID as TYPE_ID,
DYNAMIC_KEEP_DAYS,
KEEP_DAYS,
DATE_ENTER,
".$DB->DateToCharFunction("DATE_ENTER")." DATE_ENTER_STR
FROM
b_stat_event
WHERE $where1 and $where2
";
$w = $DB->Query($strSql, false, $err_mess.__LINE__);
return $w;
}