Exemple #1
0
 public static function AgentFunction()
 {
     //IS_OVERDUE
     //IS_NOTIFIED
     //SUPPORT_DEADLINE
     //SUPPORT_DEADLINE_NOTIFY
     global $DB;
     $err_mess = CAllTicketReminder::err_mess() . "<br>Function: AgentFunction<br>Line: ";
     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\t\tS.NAME SLA_NAME\n\t\t\tFROM\n\t\t\t\tb_ticket T\n\t\t\t\tLEFT JOIN b_ticket_sla S\n\t\t\t\t\tON T.SLA_ID = S.ID\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();";
 }
Exemple #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: ";

		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();";
	}