- Модуль: timeman
- Путь к файлу: ~/bitrix/modules/timeman/classes/mysql/timeman_entry.php
- Класс: CTimeManEntry
- Вызов: CTimeManEntry::_GetLastQuery
static function _GetLastQuery($USER_ID)
{
global $DB;
return '
SELECT
E.*,
'.$DB->DateToCharFunction("TIMESTAMP_X", "FULL").' TIMESTAMP_X,
'.$DB->DateToCharFunction("DATE_START", "FULL").' DATE_START,
'.$DB->DateToCharFunction("DATE_FINISH", "FULL").' DATE_FINISH
FROM b_timeman_entries E
WHERE USER_ID=''.intval($USER_ID).''
ORDER BY ID DESC
LIMIT 0,1
';
}