CAllTicketSLA::Set

static function Set($arFields, $id, $checkRights=true)
{
	$err_mess = (CAllTicketSLA::err_mess())."
Function: Set
Line: ";
	global $DB, $USER, $APPLICATION;
	$id = intval($id);
	$table = "b_ticket_sla";
	$isDemo = $isSupportClient = $isSupportTeam = $isAdmin = $isAccess = $userID = null;
	CTicket::GetRoles($isDemo, $isSupportClient, $isSupportTeam, $isAdmin, $isAccess, $userID, $checkRights);
	if ($isAdmin)
	{
		$validDeadlineSource = !isset($arFields['DEADLINE_SOURCE']) || in_array($arFields['DEADLINE_SOURCE'], array('', 'DATE_CREATE'), true);

		if (CTicket::CheckFields($arFields, $id, array("NAME","TIMETABLE_ID")) && $validDeadlineSource)
		{
			$arFields_i = CTicket::PrepareFields($arFields, $table, $id);
			if (intval($id)>0)
			{
				$DB->Update($table, $arFields_i, "WHERE ID=".intval($id), $err_mess.__LINE__);
			}
			else
			{
				$id = $DB->Insert($table, $arFields_i, $err_mess.__LINE__);
			}

			if (intval($id)>0)
			{
				if (is_set($arFields, "arGROUPS"))
				{
					$DB->Query("DELETE FROM b_ticket_sla_2_user_group WHERE SLA_ID = $id", false, $err_mess.__LINE__);
					if (is_array($arFields["arGROUPS"]) && count($arFields["arGROUPS"])>0)
					{
						foreach($arFields["arGROUPS"] as $groupID)
						{
							$groupID = intval($groupID);
							if ($groupID>0)
							{
								$strSql = "INSERT INTO b_ticket_sla_2_user_group (SLA_ID, GROUP_ID) VALUES ($id, $groupID)";
								$DB->Query($strSql, false, $err_mess.__LINE__);
							}
						}
					}
				}

				if (is_set($arFields, "arSITES"))
				{
					$DB->Query("DELETE FROM b_ticket_sla_2_site WHERE SLA_ID = $id", false, $err_mess.__LINE__);
					if (is_array($arFields["arSITES"]) && count($arFields["arSITES"])>0)
					{
						foreach($arFields["arSITES"] as $siteID)
						{
							//if (strlen($FIRST_SITE_ID)<=0) $FIRST_SITE_ID = $siteID;
							$FIRST_SITE_ID = $siteID;
							$siteID = $DB->ForSql($siteID);
							$strSql = "INSERT INTO b_ticket_sla_2_site (SLA_ID, SITE_ID) VALUES ($id, '$siteID')";
							$DB->Query($strSql, false, $err_mess.__LINE__);
						}
					}
				}

				if (is_set($arFields, "arCATEGORIES"))
				{
					$DB->Query("DELETE FROM b_ticket_sla_2_category WHERE SLA_ID = $id", false, $err_mess.__LINE__);
					if (is_array($arFields["arCATEGORIES"]) && count($arFields["arCATEGORIES"])>0)
					{
						foreach($arFields["arCATEGORIES"] as $categoryID)
						{
							$categoryID = intval($categoryID);
							$strSql = "INSERT INTO b_ticket_sla_2_category (SLA_ID, CATEGORY_ID) VALUES ($id, $categoryID)";
							$DB->Query($strSql, false, $err_mess.__LINE__);
						}
					}
				}

				if (is_set($arFields, "arCRITICALITIES"))
				{
					$DB->Query("DELETE FROM b_ticket_sla_2_criticality WHERE SLA_ID = $id", false, $err_mess.__LINE__);
					if (is_array($arFields["arCRITICALITIES"]) && count($arFields["arCRITICALITIES"])>0)
					{
						foreach($arFields["arCRITICALITIES"] as $criticalityID)
						{
							$criticalityID = intval($criticalityID);
							$strSql = "INSERT INTO b_ticket_sla_2_criticality (SLA_ID, CRITICALITY_ID) VALUES ($id, $criticalityID)";
							$DB->Query($strSql, false, $err_mess.__LINE__);
						}
					}
				}

				if (is_set($arFields, "arMARKS"))
				{
					$DB->Query("DELETE FROM b_ticket_sla_2_mark WHERE SLA_ID = $id", false, $err_mess.__LINE__);
					if (is_array($arFields["arMARKS"]) && count($arFields["arMARKS"])>0)
					{
						foreach($arFields["arMARKS"] as $markID)
						{
							$markID = intval($markID);
							$strSql = "INSERT INTO b_ticket_sla_2_mark (SLA_ID, MARK_ID) VALUES ($id, $markID)";
							$DB->Query($strSql, false, $err_mess.__LINE__);
						}
					}
				}

				/*
				if (is_set($arFields, "arSHEDULE"))
				{
					$DB->Query("DELETE FROM b_ticket_sla_shedule WHERE SLA_ID = $id", false, $err_mess.__LINE__);
					if (is_array($arFields["arSHEDULE"]) && count($arFields["arSHEDULE"])>0)
					{
						while(list($weekday, $arSHEDULE) = each($arFields["arSHEDULE"]))
						{
							$arF = array(
								"SLA_ID"			=> $id,
								"WEEKDAY_NUMBER"	=> intval($weekday),
								"OPEN_TIME"			=> "'".$DB->ForSql($arSHEDULE["OPEN_TIME"], 10)."'",
								);
							if ($arSHEDULE["OPEN_TIME"]=="CUSTOM" && is_array($arSHEDULE["CUSTOM_TIME"]) && count($arSHEDULE["CUSTOM_TIME"])>0)
							{
								foreach($arSHEDULE["CUSTOM_TIME"] as $ar)
								{
									if (strlen(trim($ar["MINUTE_FROM"]))>0 || strlen(trim($ar["MINUTE_TILL"]))>0)
									{
										$minute_from = strlen($ar["MINUTE_FROM"])>0 ? $ar["MINUTE_FROM"] : "00:00";
										$a = explode(":",$minute_from);
										$minute_from = intval($a[0]*60 + $a[1]);
										$arF["MINUTE_FROM"] = $minute_from;

										$minute_till = strlen($ar["MINUTE_TILL"])>0 ? $ar["MINUTE_TILL"] : "23:59";
										$a = explode(":",$minute_till);
										$minute_till = intval($a[0]*60 + $a[1]);
										$arF["MINUTE_TILL"] = $minute_till;

										$DB->Insert("b_ticket_sla_shedule", $arF, $err_mess.__LINE__);
									}
								}
							}
							else $DB->Insert("b_ticket_sla_shedule", $arF, $err_mess.__LINE__);
						}
					}
				}
				*/

				$FIRST_SITE_ID = $FIRST_SITE_ID <> '' ? "'".$DB->ForSql($FIRST_SITE_ID)."'" : "null";
				$DB->Update($table, array("FIRST_SITE_ID" => $FIRST_SITE_ID), "WHERE ID=".intval($id), $err_mess.__LINE__);
			}
		}
	}
	else
	{
		//$APPLICATION->ThrowException(GetMessage("SUP_ERROR_ACCESS_DENIED"));
		$arMsg = Array();
		$arMsg[] = array("id"=>"PERMISSION", "text"=> GetMessage("SUP_ERROR_ACCESS_DENIED"));
		$e = new CAdminException($arMsg);
		$APPLICATION->ThrowException($e);
	}
	CSupportTimetableCache::toCache( array( "SLA_ID"=> $id ) );
	return $id;
}