<?
##################
	include("base.php.inc");
	include("mysql.php.inc");
##################

	extract($_GET);
	extract($_POST);
	extract($_SERVER);


	//---- Parameters
	// LOCID
	// THEME
	// SERVID
	// SERVDESCID
	// SERVSTATUS
	// SERVMAINTITLE
	// NBDAYS
	// LANG
	// COMPID = company ID
	// NAMETAB = service name
	// FILETAB = image file
	// INFOTAB = service info
	// DOCIDTAB = image file ID
	// CONDITIONS = read conditions
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);


	//---- get langID
	$langID = 1;
	$query = "SELECT LANG_ID FROM languages WHERE LANG_CODE='".$LANG."'";
	$conn->query($query);
	if ($conn->next_record())
		$langID = $conn->field_value("LANG_ID");


	//---- get theme
	$query = "SELECT * FROM thematics WHERE THEM_NAME='".$THEME."'";
	$conn->query($query);

	if ($conn->next_record())
	{	$themID = $conn->field_value("THEM_ID");

		$isCompound = 0;
		if ($NBDAYS > 1)
			$isCompound = 1;

		$servNameTab = split("\|", $NAMETAB);
		$servFileTab = split("\|", $FILETAB);
		$servInfoTab = split("\|", $INFOTAB);
		$servDocIDTab = split("\|", $DOCIDTAB);

		if (($SERVID != "") && ($SERVID != "-") && ($SERVID != "undefined"))
		{
			//---- update service
			$query = "UPDATE services SET SERV_LOC_ID='".$LOCID."', SERV_THEM_ID='".$themID."', SERV_NAME=\"".addslashes($SERVMAINTITLE)."\", SERV_COMP_ID='".$COMPID."'";
			$query.= ", SERV_DESC_ID='".$SERVDESCID."', SERV_ISPUBLIC='".$SERVSTATUS."', SERV_ISCOMPOUND='".$isCompound."', SERV_NBDAYS='".$NBDAYS."', SERV_CONDITIONS=\"".addslashes($CONDITIONS)."\" WHERE SERV_ID='".$SERVID."'";
			$conn->query($query);

			//---- check if lang exists
			$query = "SELECT SERVLANG_SERV_ID FROM services_languages WHERE SERVLANG_SERV_ID='".$SERVID."' AND SERVLANG_LANG_ID='".$langID."'";
			$conn->query($query);
			if ($conn->next_record())
			{
				//---- update service language
				$query = "UPDATE services_languages SET SERVLANG_NAME=\"".addslashes($SERVMAINTITLE)."\", SERVLANG_CONDITIONS=\"".addslashes($CONDITIONS)."\" WHERE SERVLANG_SERV_ID='".$SERVID."' AND SERVLANG_LANG_ID='".$langID."'";
			}
			else
			{	//---- insert line
				$query = "INSERT INTO services_languages (SERVLANG_SERV_ID, SERVLANG_LANG_ID, SERVLANG_NAME, SERVLANG_CONDITIONS) VALUES ('".$SERVID."', '".$langID."', \"".addslashes($SERVMAINTITLE)."\", \"".addslashes($CONDITIONS)."\")";
			}
			$conn->query($query);
		}
		else
		{	//---- new service
			$query = "INSERT INTO services (SERV_LOC_ID, SERV_THEM_ID, SERV_NAME, SERV_COMP_ID, SERV_DESC_ID, SERV_ISPUBLIC, SERV_ISCOMPOUND, SERV_NBDAYS, SERV_CONDITIONS)";
			$query.= " VALUES ('".$LOCID."', '".$themID."', \"".addslashes($SERVMAINTITLE)."\", '".$COMPID."', '".$SERVDESCID."', '".$SERVSTATUS."', '".$isCompound."', '".$NBDAYS."', \"".addslashes($CONDITIONS)."\")";
			$conn->query($query);

			//---- get SERVID
			$query = "SELECT LAST_INSERT_ID() AS MYID";
			$conn->query($query);
			if ($conn->next_record())
				$SERVID = $conn->field_value("MYID");

			//---- insert service language
			$query = "INSERT INTO services_languages (SERVLANG_SERV_ID, SERVLANG_LANG_ID, SERVLANG_NAME, SERVLANG_CONDITIONS) VALUES ('".$SERVID."', '".$langID."', \"".addslashes($SERVMAINTITLE)."\", \"".addslashes($CONDITIONS)."\")";
			$conn->query($query);
		}


		//---- insert service info (image + text)
		$query = "DELETE FROM servicesdocuments WHERE SERVDOC_SERV_ID='".$SERVID."'";
		$conn->query($query);
		$query = "DELETE FROM servicesdocuments_languages WHERE SERVDOCLANG_SERV_ID='".$SERVID."' AND SERVDOCLANG_LANG_ID='".$langID."'";
		$conn->query($query);

		for($i=0;$i<sizeOf($servDocIDTab);$i++)
		{
			if (($servDocIDTab[$i] == "") || ($servDocIDTab[$i] == "-"))
			{
				//---- create doc and get new ID
				$query = "INSERT INTO documents (DOC_NAME, DOC_FILE, DOC_LOC_ID, DOC_THEM_ID, DOC_KEYWORD, DOC_TYPE, DOC_CREATION_DATE)";
				$query.= " VALUES (\"".addslashes($servNameTab[$i])."\", \"".$servFileTab[$i]."\", '".$LOCID."', '".$themID."', '', 'IMG', now())";
				$conn->query($query);

				$query = "SELECT LAST_INSERT_ID() AS MYID";
				$conn->query($query);
				if ($conn->next_record())
					$servDocIDTab[$i] = $conn->field_value("MYID");
			}

			$query = "INSERT INTO servicesdocuments (SERVDOC_SERV_ID , SERVDOC_DOC_ID, SERVDOC_TITLE, SERVDOC_TEXT, SERVDOC_NBORDER) ";
			$query.= "VALUES ('".$SERVID."', \"".$servDocIDTab[$i]."\", \"".addslashes($servNameTab[$i])."\", \"".addslashes($servInfoTab[$i])."\", '".$i."')";
			$conn->query($query);

			$query = "INSERT INTO servicesdocuments_languages (SERVDOCLANG_SERV_ID , SERVDOCLANG_DOC_ID, SERVDOCLANG_LANG_ID, SERVDOCLANG_TITLE, SERVDOCLANG_TEXT) ";
			$query.= "VALUES ('".$SERVID."', \"".$servDocIDTab[$i]."\", '".$langID."', \"".addslashes($servNameTab[$i])."\", \"".addslashes($servInfoTab[$i])."\")";
			$conn->query($query);
		}

		print "RESULT=done&SERVID=".$SERVID;
	}
	else
		print "RESULT=error0";
?>