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