• Модуль: support
  • Путь к файлу: ~/bitrix/modules/support/classes/general/timetablecache.php
  • Класс: CSupportTimetableCache
  • Вызов: CSupportTimetableCache::InsertDefaultValues
static function InsertDefaultValues()
{
	global $DB;
	$err_mess = (self::err_mess())."
Function: InsertDefaultValues
Line: "; $t_sla_shedule = self::SLA_SHEDULE; $arInsStr = array( "SLA_ID" => 0, "WEEKDAY_NUMBER" => 0, "OPEN_TIME" => "'24H'", "MINUTE_FROM" => 0, "MINUTE_TILL" => 0, "TIMETABLE_ID" => 0, ); $strSql = " SELECT R.TIMETABLE_ID FROM ( SELECT T.ID TIMETABLE_ID, SUM(" . CTicket::isnull( "S.ID", 0 ) .") V FROM b_ticket_timetable T LEFT JOIN $t_sla_shedule S ON T.ID = S.TIMETABLE_ID AND S.TIMETABLE_ID > 0 GROUP BY T.ID ) R WHERE R.V = 0 "; $q = $DB->Query($strSql, false, $err_mess.__LINE__); while ($arrR = $q->Fetch()) { for($i=0;$i<=6;$i++) { $arInsStr["WEEKDAY_NUMBER"] = $i; $arInsStr["TIMETABLE_ID"] = intval($arrR["TIMETABLE_ID"]); $DB->Insert($t_sla_shedule, $arInsStr, $err_mess . __LINE__); } } }