CAllTicketSLA::GetSheduleArray

static function GetSheduleArray($slaID)
{
	$err_mess = (CAllTicketSLA::err_mess())."
Function: GetSheduleArray
Line: ";
	global $DB, $USER, $APPLICATION;
	$arResult = array();
	$slaID = intval($slaID);
	if ($slaID>0)
	{
		$strSql = "SELECT * FROM b_ticket_sla_shedule WHERE SLA_ID = $slaID ORDER BY WEEKDAY_NUMBER, MINUTE_FROM, MINUTE_TILL";
		$rs = $DB->Query($strSql, false, $err_mess.__LINE__);
		while($ar = $rs->Fetch())
		{
			if ($ar["OPEN_TIME"]=="CUSTOM")
			{
				if (intval($ar["MINUTE_FROM"])>0)
				{
					$h_from = floor($ar["MINUTE_FROM"]/60);
					$m_from = $ar["MINUTE_FROM"] - $h_from*60;
				}
				if (intval($ar["MINUTE_TILL"])>0)
				{
					$h_till = floor($ar["MINUTE_TILL"]/60);
					$m_till = $ar["MINUTE_TILL"] - $h_till*60;
				}
				$arResult[$ar["WEEKDAY_NUMBER"]]["OPEN_TIME"] = $ar["OPEN_TIME"];
				$arResult[$ar["WEEKDAY_NUMBER"]]["CUSTOM_TIME"][] = array(
					"MINUTE_FROM"	=> $ar["MINUTE_FROM"],
					"SECOND_FROM"	=> $ar["MINUTE_FROM"]*60,
					"MINUTE_TILL"	=> $ar["MINUTE_TILL"],
					"SECOND_TILL"	=> $ar["MINUTE_TILL"]*60,
					"FROM"			=> $h_from.":".str_pad($m_from, 2, 0),
					"TILL"			=> $h_till.":".str_pad($m_till, 2, 0)
					);
			}
			else
			{
				$arResult[$ar["WEEKDAY_NUMBER"]] = array("OPEN_TIME" => $ar["OPEN_TIME"]);
			}
			$arResult[$ar["WEEKDAY_NUMBER"]]["WEEKDAY_TITLE"] = GetMessage("SUP_WEEKDAY_".$ar["WEEKDAY_NUMBER"]);
		}
	}
	return $arResult;
}