• Модуль: learning
  • Путь к файлу: ~/bitrix/modules/learning/classes/general/attempt.php
  • Класс: CAllTestAttempt
  • Вызов: CAllTestAttempt::getSpeedFieldSql
static function getSpeedFieldSql()
{
	$connection = BitrixMainApplication::getConnection();
	if ($connection instanceof BitrixMainDBMssqlConnection)
	{
		return "DATEDIFF(s, A.DATE_START, A.DATE_END) / A.QUESTIONS";
	}
	elseif ($connection instanceof BitrixMainDBOracleConnection)
	{
		return "round((A.DATE_END-A.DATE_START)*86400) / A.QUESTIONS";
	}
	else
	{
		return "round((unix_timestamp(IFNULL(A.DATE_END, A.DATE_START))-unix_timestamp(A.DATE_START)) / A.QUESTIONS)";
	}
}