Exemplo n.º 1
0
 function Update()
 {
     if (CSupportUpdate::CurrentVersionLowerThanUpdateVersion()) {
         $dbType = CSupportUpdate::GetBD();
         $res = self::AlterTables($dbType);
         if (!$res) {
             return false;
         }
         $res = self::SeparateSLAandTimeTable($dbType);
         if (!$res) {
             return false;
         }
         CSupportTimetableCache::toCache();
         CTicketReminder::RecalculateSupportDeadline();
         CTicketReminder::StartAgent();
         CSupportUpdate::ChangeCurrentVersion();
         self::SetHotKeys();
     }
 }
Exemplo n.º 2
0
 function AgentFunction()
 {
     //IS_OVERDUE
     //IS_NOTIFIED
     //SUPPORT_DEADLINE
     //SUPPORT_DEADLINE_NOTIFY
     global $DB;
     $err_mess = CAllTicketReminder::err_mess() . "<br>Function: AgentFunction<br>Line: ";
     if (CSupportUpdate::CurrentVersionLowerThanUpdateVersion()) {
         return "CTicketReminder::AgentFunction();";
     }
     CTimeZone::Disable();
     $cyrrDateTime = $DB->CharToDateFunction(GetTime(time(), "FULL"));
     CTimeZone::Enable();
     $strSql = "\n\t\t\tSELECT\n\t\t\t\tT.ID ID,\n\t\t\t\tT.SITE_ID,\n\t\t\t\t" . $DB->DateToCharFunction("T.SUPPORT_DEADLINE_NOTIFY", "FULL") . " SUPPORT_DEADLINE_NOTIFY,\n\t\t\t\t" . $DB->DateToCharFunction("T.SUPPORT_DEADLINE", "FULL") . " SUPPORT_DEADLINE,\n\t\t\t\tT.ID_1_USER_M_AFTER_SUP_M\t\n\t\t\tFROM\n\t\t\t\tb_ticket T\t\t\t\t\t\n\t\t\tWHERE\n\t\t\t\tT.LAST_MESSAGE_BY_SUPPORT_TEAM = 'N'\n\t\t\t\tAND T.SUPPORT_DEADLINE_NOTIFY <= {$cyrrDateTime}\n\t\t\t\tAND T.SUPPORT_DEADLINE_NOTIFY IS NOT NULL\n\t\t\t\tAND T.ID_1_USER_M_AFTER_SUP_M > 0\n\t\t\t\tAND T.IS_OVERDUE = 'N'\n\t\t\t\tAND T.IS_NOTIFIED = 'N'\n\t\t\t\tAND T.DATE_CLOSE IS NULL\n\t\t";
     $rsTicket = $DB->Query($strSql, false, $err_mess . __LINE__);
     while ($arrTicket = $rsTicket->Fetch()) {
         self::SupportDeadlineNotify($arrTicket);
     }
     $strSql = "\n\t\t\tSELECT\n\t\t\t\tT.*,\n\t\t\t\tTM.ID TM_ID,\n\t\t\t\tTM.C_NUMBER TM_C_NUMBER\n\t\t\tFROM\n\t\t\t\tb_ticket T\n\t\t\t\tLEFT JOIN b_ticket_message TM\n\t\t\t\t\tON T.ID_1_USER_M_AFTER_SUP_M\t= TM.ID\t\n\t\t\tWHERE\n\t\t\t\tT.LAST_MESSAGE_BY_SUPPORT_TEAM = 'N'\n\t\t\t\tAND T.SUPPORT_DEADLINE <= {$cyrrDateTime}\n\t\t\t\tAND T.IS_OVERDUE = 'N'\n\t\t\t\tAND T.DATE_CLOSE IS NULL\n\t\t";
     $rsTicket = $DB->Query($strSql, false, $err_mess . __LINE__);
     while ($arrTicket = $rsTicket->Fetch()) {
         self::SupportDeadline($arrTicket);
     }
     return "CTicketReminder::AgentFunction();";
 }
Exemplo n.º 3
0
<?php

global $DB, $APPLICATION;
require_once $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/admin_tools.php";
require_once $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/main/filter_tools.php";
IncludeModuleLangFile(__FILE__);
IncludeModuleLangFile($_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/support/errors.php");
require_once $_SERVER["DOCUMENT_ROOT"] . "/bitrix/modules/support/support_tools.php";
$db_type = strtolower($DB->type);
CModule::AddAutoloadClasses("support", array("CTicket" => "classes/" . $db_type . "/support.php", "CTicketDictionary" => "classes/" . $db_type . "/dictionary.php", "CTicketSLA" => "classes/" . $db_type . "/sla.php", "CTicketReminder" => "classes/" . $db_type . "/reminder.php", "CSupportSuperCoupon" => "classes/general/coupons.php", "CSupportEMail" => "classes/general/email.php", "CSupportUserGroup" => "classes/general/usergroup.php", "CSupportUser2UserGroup" => "classes/general/usertousergroup.php", "CSupportTableFields" => "classes/general/tablefields.php", "CSupportTimetable" => "classes/general/timetable.php", "CSupportTools" => "classes/general/tools.php", "CSupportHolidays" => "classes/general/holidays.php", "CSupportTimetableCache" => "classes/general/timetablecache.php", "CSupportSearch" => "classes/general/search.php", "CSupportUpdate" => "classes/" . $db_type . "/update.php"));
CSupportUpdate::Update();