- Модуль: workflow
- Путь к файлу: ~/bitrix/modules/workflow/classes/mysql/workflow.php
- Класс: CWorkflow
- Вызов: CWorkflow::GetFileList
static function GetFileList($DOCUMENT_ID)
{
$err_mess = (CAllWorkflow::err_mess())."
Function: GetFileList
Line: ";
global $DB;
$DOCUMENT_ID = intval($DOCUMENT_ID);
$strSql = "
SELECT
F.*, D.SITE_ID,
".$DB->DateToCharFunction("F.TIMESTAMP_X")." TIMESTAMP_X,
concat('(',U.LOGIN,') ',ifnull(U.NAME,''),' ',ifnull(U.LAST_NAME,'')) USER_NAME
FROM
b_workflow_document D
INNER JOIN b_workflow_file F ON (F.DOCUMENT_ID = D.ID)
LEFT JOIN b_user U ON (U.ID = F.MODIFIED_BY)
WHERE
D.ID = ".$DOCUMENT_ID."
ORDER BY
F.TIMESTAMP_X desc
";
$z = $DB->Query($strSql, false, $err_mess.__LINE__);
return $z;
}