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

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