CAllTicketReminder::AgentFunction

static function AgentFunction()
{
	//IS_OVERDUE
	//IS_NOTIFIED
	//SUPPORT_DEADLINE
	//SUPPORT_DEADLINE_NOTIFY
	global $DB;
	$err_mess = (CAllTicketReminder::err_mess())."
Function: AgentFunction
Line: ";

	CTimeZone::Disable();
	$cyrrDateTime = $DB->CharToDateFunction(GetTime(time(), "FULL"));
	CTimeZone::Enable();
	
	$strSql = "
		SELECT
			T.ID ID,
			T.SITE_ID,
			" . $DB->DateToCharFunction("T.SUPPORT_DEADLINE_NOTIFY", "FULL") . " SUPPORT_DEADLINE_NOTIFY,
			" . $DB->DateToCharFunction("T.SUPPORT_DEADLINE", "FULL") . " SUPPORT_DEADLINE,
			T.ID_1_USER_M_AFTER_SUP_M	
		FROM
			b_ticket T					
		WHERE
			T.LAST_MESSAGE_BY_SUPPORT_TEAM = 'N'
			AND T.SUPPORT_DEADLINE_NOTIFY <= $cyrrDateTime
			AND T.SUPPORT_DEADLINE_NOTIFY IS NOT NULL
			AND T.ID_1_USER_M_AFTER_SUP_M > 0
			AND T.IS_OVERDUE = 'N'
			AND T.IS_NOTIFIED = 'N'
			AND T.DATE_CLOSE IS NULL
	";
	$rsTicket = $DB->Query($strSql, false, $err_mess . __LINE__);
	while($arrTicket = $rsTicket->Fetch())
	{
		self::SupportDeadlineNotify($arrTicket);
	}
	
	$strSql = "
		SELECT
			T.*,
			TM.ID TM_ID,
			TM.C_NUMBER TM_C_NUMBER,
			S.NAME SLA_NAME
		FROM
			b_ticket T
			LEFT JOIN b_ticket_sla S
				ON T.SLA_ID = S.ID
			LEFT JOIN b_ticket_message TM
				ON T.ID_1_USER_M_AFTER_SUP_M	= TM.ID	
		WHERE
			T.LAST_MESSAGE_BY_SUPPORT_TEAM = 'N'
			AND T.SUPPORT_DEADLINE <= $cyrrDateTime
			AND T.IS_OVERDUE = 'N'
			AND T.DATE_CLOSE IS NULL
	";
	$rsTicket = $DB->Query($strSql, false, $err_mess . __LINE__);
	
	while($arrTicket = $rsTicket->Fetch())
	{
		self::SupportDeadline($arrTicket);
	}
	return "CTicketReminder::AgentFunction();";
}