CSupportHolidays::Set

static function Set($arFields, $arFieldsSLA) //$arFields, $arFieldsSLA = array(0 => array("HOLIDAYS_ID" => 1, "SLA_ID" => 1), 1 => array("HOLIDAYS_ID" => 2, "SLA_ID" => 2) ...)
{
	global $DB, $APPLICATION;
	$err_mess = (self::err_mess())."
Function: Set
Line: ";
	$isDemo = null;
	$isSupportClient = null;
	$isSupportTeam = null;
	$isAdmin = null;
	$isAccess = null;
	$userID = null;
	CTicket::GetRoles($isDemo, $isSupportClient, $isSupportTeam, $isAdmin, $isAccess, $userID);
	if(!$isAdmin)
	{
		$arMsg = Array();
		$arMsg[] = array("id"=>"PERMISSION", "text"=> GetMessage("SUP_ERROR_ACCESS_DENIED"));
		$e = new CAdminException($arMsg);
		$APPLICATION->ThrowException($e);
		return false;
	}

	if(is_array($arFields))
	{
		$f = new CSupportTableFields(self::$holidays);
		$f->FromArray($arFields);
	}
	else $f = $arFields;
	if(is_array($arFieldsSLA))
	{
		$f_s = new CSupportTableFields(self::$sla2holidays, CSupportTableFields::C_Table);
		$f_s->FromTable($arFieldsSLA);
	}
	else $f_s = $arFieldsSLA;
	
			
	$table = self::table;
	$table_s2h = self::table_s2h; 
	
	$isNew = ($f->ID <= 0);

	$objError = new CAdminException(array());
	if($f->NAME == '')
	{
		$objError->AddMessage(array("text" => GetMessage('SUP_ERROR_EMPTY_NAME')));
	}
	if($f->OPEN_TIME == '')
	{
		$objError->AddMessage(array("text" => GetMessage('SUP_ERROR_EMPTY_OPEN_TIME')));
	}
	$zd = mktime(0, 0, 0, 1, 1, 2010);
	if($f->DATE_FROM < $zd || $f->DATE_FROM === null || $f->DATE_TILL < $zd || $f->DATE_TILL === null || $f->DATE_FROM > $f->DATE_TILL)
	{
		if($f->DATE_FROM < $zd || $f->DATE_FROM === null)
		{
			$f->DATE_FROM = time() + CTimeZone::GetOffset();
		}

		if($f->DATE_TILL < $zd || $f->DATE_TILL === null)
		{
			$f->DATE_TILL = time() + CTimeZone::GetOffset();
		}
		$objError->AddMessage(array("text" => GetMessage('SUP_ERROR_EMPTY_DATE')));
	}

	if(count($objError->GetMessages())>0)
	{
		$APPLICATION->ThrowException($objError);
		return false;
	}
	
	$arFields_i = $f->ToArray(CSupportTableFields::ALL, array(CSupportTableFields::NOT_NULL), true);
	$res = 0;
	if(count($arFields_i) > 0)
	{
		if($isNew)
		{
			$res = $DB->Insert($table, $arFields_i, $err_mess . __LINE__);
			$f->ID = $res;
		}
		else
		{
			$res = $DB->Update($table, $arFields_i, "WHERE ID=" . $f->ID . "", $err_mess . __LINE__);
		}
	}
	
	if(intval($res) <= 0)
	{
		$APPLICATION->ThrowException(GetMessage('SUP_ERROR_DB_ERROR'));
		return false;
	}
	
	$DB->Query("DELETE FROM $table_s2h WHERE HOLIDAYS_ID = " . $f->ID, false, $err_mess . __LINE__);
	$f_s->ResetNext();
	while($f_s->Next())
	{
		$f_s->HOLIDAYS_ID = $f->ID;
		if($f_s->SLA_ID > 0)
		{
			$strSql = "INSERT INTO " . $table_s2h . "(SLA_ID, HOLIDAYS_ID) VALUES (" . $f_s->SLA_ID . ", " . $f_s->HOLIDAYS_ID . ")";
			$res = $DB->Query($strSql, false, $err_mess . __LINE__);
		}
	}
	
	CSupportTimetableCache::toCache(array("SLA_ID"=> $f_s->getColumn("SLA_ID")));
	
	return $f->ID;
}