• Модуль: imopenlines
  • Путь к файлу: ~/bitrix/modules/imopenlines/lib/tools/correction.php
  • Класс: BitrixImOpenLinesToolsCorrection
  • Вызов: Correction::getCountSessionsNoDateClose
static function getCountSessionsNoDateClose(): int
{
	$sql = "
		SELECT
			count(*) AS COUNT
		FROM
			b_imopenlines_session_check,
			b_imopenlines_session
		WHERE
			b_imopenlines_session.ID = b_imopenlines_session_check.SESSION_ID AND
			b_imopenlines_session_check.DATE_CLOSE IS NULL
	";

	return (int) Application::getConnection()->queryScalar($sql);
}