- Модуль: statistic
- Путь к файлу: ~/bitrix/modules/statistic/classes/mysql/stateventtype.php
- Класс: CStatEventType
- Вызов: CStatEventType::GetByID
static function GetByID($ID)
{
$err_mess = "File: ".__FILE__."
Line: ";
$DB = CDatabase::GetModuleConnection('statistic');
$ID = intval($ID);
$strSql = "
SELECT
E.*,
".$DB->DateToCharFunction("E.DATE_ENTER")." DATE_ENTER,
if (length(E.NAME)>0, E.NAME,
concat(ifnull(E.EVENT1,''),' / ',ifnull(E.EVENT2,''))) EVENT
FROM
b_stat_event E
WHERE
E.ID = '$ID'
";
$res = $DB->Query($strSql, false, $err_mess.__LINE__);
return $res;
}