• Модуль: 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;
}