- Модуль: form
- Путь к файлу: ~/bitrix/modules/form/classes/mysql/form_cformresult.php
- Класс: CFormResult
- Вызов: CFormResult::GetByID
static function GetByID($ID)
{
global $DB, $strError;
$err_mess = (CFormResult::err_mess())."
Function: GetByID
Line: ";
$ID = intval($ID);
$strSql = "
SELECT
R.*,
".$DB->DateToCharFunction("R.DATE_CREATE")." DATE_CREATE,
".$DB->DateToCharFunction("R.TIMESTAMP_X")." TIMESTAMP_X,
F.IMAGE_ID, F.DESCRIPTION, F.DESCRIPTION_TYPE, F.SHOW_RESULT_TEMPLATE, F.PRINT_RESULT_TEMPLATE, F.EDIT_RESULT_TEMPLATE, F.NAME,
F.SID,
F.SID VARNAME,
S.TITLE STATUS_TITLE,
S.DESCRIPTION STATUS_DESCRIPTION,
S.CSS STATUS_CSS
FROM
b_form_result R,
b_form_status S,
b_form F
WHERE
R.ID = $ID
and F.ID = R.FORM_ID
and R.STATUS_ID = S.ID
";
$res = $DB->Query($strSql, false, $err_mess.__LINE__);
return $res;
}