- Модуль: tasks
- Путь к файлу: ~/bitrix/modules/tasks/lib/comments/task.php
- Класс: BitrixTasksCommentsTask
- Вызов: Task::getLastCommentTime
static function getLastCommentTime(int $taskId)
{
if (!$taskId || !Forum::includeModule())
{
return false;
}
$query = (new Query(MessageTable::class))
->setSelect([new ExpressionField('LAST', 'MAX(%s)', 'POST_DATE')])
->registerRuntimeField('T', new ReferenceField(
'T',
TaskTable::getEntity(),
Join::on('this.TOPIC_ID', 'ref.FORUM_TOPIC_ID'),
['join_type' => 'inner']
))
->where('T.ID', $taskId)
;
$lastCommentTime = false;
$lastCommentResult = $query->exec();
if ($row = $lastCommentResult->fetch())
{
$lastCommentTime = ($row['LAST'] ?? $lastCommentTime);
}
return $lastCommentTime;
}