CSupportHolidays::GetSLAByID

static function GetSLAByID($id, $needObj = false)
{
	$err_mess = (self::err_mess())."
Function: GetList
Line: ";
	global $DB, $USER, $APPLICATION;		
	$table_s2h = self::table_s2h;
	$table_sla = self::table_sla;
	$id = intval($id);

	$strSql = "
		SELECT
			S2H.HOLIDAYS_ID,
			S2H.SLA_ID,
			SLA.NAME
		FROM
			$table_s2h S2H
			INNER JOIN $table_sla SLA
				ON S2H.SLA_ID = SLA.ID
					AND S2H.HOLIDAYS_ID = $id
		ORDER BY
			SLA.NAME
		";
	$res = $DB->Query($strSql, false, $err_mess.__LINE__);
	if(!$needObj) return $res;
	$f_s = new CSupportTableFields(self::$sla2holidays, CSupportTableFields::C_Table);
	$f_s->RemoveExistingRows();
	while ($resR = $res->Fetch()) 
	{
		$f_s->AddRow();
		$f_s->FromArray($resR);
	}
	return $f_s;
}