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

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


	//---- Parameters
	// LOC_ID = id of the location
	// TITLE = title of the guide
	// THEME = the theme
	// INDEXIDTAB = IDs of each element
	// LANG (optional)
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);
	$conn2 = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	//---- update or create images
	$idTab = split("\|", $INDEXIDTAB);


	//---- get lang ID
	$langID = "";
	if (!empty($LANG))
	{
		$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");

		//---- get brochure ID
		$broID = -1;
		$query = "SELECT brochures.BRO_ID as eltID
			FROM brochures, compositionslocalities, compositions
			WHERE brochures.BRO_THEM_ID = '".$themID."'
			AND compositionslocalities.COMPOSLOC_OBJ_ID = brochures.BRO_ID
			AND compositionslocalities.COMPOSLOC_LOC_ID = '".$LOC_ID."'
			AND compositions.COMPOS_ID = compositionslocalities.COMPOSLOC_COMPOS_ID
			AND compositions.COMPOS_TYPE = 'BRO' ORDER BY brochures.BRO_ID";
		$conn->query($query);
		if ($conn->next_record())
		{	$broID = $conn->field_value("eltID");

			if ($idTab[0] == "")
			{
				//---- delete brochure
				$query = "DELETE FROM brochures WHERE BRO_ID='".$broID."'";
				$conn->query($query);

				//---- delete brochure language
				$query = "DELETE FROM brochures_language WHERE BROLANG_BRO_ID='".$broID."'";
				$conn->query($query);

				//---- delete old items from brochuresdocuments
				$query = "DELETE FROM brochuresdocuments WHERE BD_BRO_ID='".$broID."'";
				$conn->query($query);

				//---- delete old items from brochuresservices
				$query = "DELETE FROM brochuresservices WHERE BS_BRO_ID='".$broID."'";
				$conn->query($query);
			}
			else
			{
				//---- update brochures
				$query = "UPDATE brochures SET BRO_TITLE=\"".addslashes($TITLE)."\" WHERE BRO_ID='".$broID."'";
				$conn->query($query);

				if ($langID != "")
				{
					//---- check if lang exist for zhis brochure
					$query = "SELECT * FROM brochures_languages WHERE BROLANG_BRO_ID='".$broID."' AND BROLANG_LANG_ID='".$langID."'";
					$conn->query($query);
					if ($conn->next_record())
						$query = "UPDATE brochures_languages SET BROLANG_TITLE=\"".addslashes($TITLE)."\" WHERE BROLANG_BRO_ID='".$broID."' AND BROLANG_LANG_ID='".$langID."'";
					else
						$query = "INSERT brochures_languages (BROLANG_BRO_ID, BROLANG_LANG_ID, BROLANG_TITLE) VALUES ('".$broID."', '".$langID."', \"".addslashes($TITLE)."\")";
					$conn->query($query);
				}

				//---- delete old items from brochuresdocuments
				$query = "DELETE FROM brochuresdocuments WHERE BD_BRO_ID='".$broID."'";
				$conn->query($query);

				//---- delete old items from brochuresservices
				$query = "DELETE FROM brochuresservices WHERE BS_BRO_ID='".$broID."'";
				$conn->query($query);

				//---- insert new elements
				$nbOrder = 1;
				for($i=0;$i<sizeOf($idTab);$i++)
				{
					$query = "INSERT INTO brochuresservices (BS_BRO_ID, BS_SERV_ID, BS_ORDERNB)";
					$query.= " VALUES ('".$broID."', '".$idTab[$i]."', '".($i+1)."')";
					$conn->query($query);
/*
					//---- get all documents of the service
					$query2 = "SELECT * FROM services, servicesdocuments WHERE SERV_ID=SERVDOC_SERV_ID AND SERV_ID='".$idTab[$i]."' ORDER BY SERVDOC_NBORDER";
					$conn2->query($query2);

					while($conn2->next_record())
					{
						$query = "INSERT INTO brochuresdocuments (BD_BRO_ID, BD_DOC_ID, BD_TITLE, BD_DESCRIPTION, BD_ORDER)";
						$query.= " VALUES ('".$broID."', '".$conn2->field_value("SERVDOC_DOC_ID")."', \"".addslashes($conn2->field_value("SERVDOC_TITLE"))."\", \"".addslashes($conn2->field_value("SERVDOC_TEXT"))."\", '".$nbOrder."')";
						$conn->query($query);
						$nbOrder++;
					}*/
				}
			}
		}
		else if ($idTab[0] != "")
		{	//---- create brochure

			//---- get category
			$catID = -1;
			$query = "SELECT CAT_ID FROM categories WHERE CAT_TITLE='Brochure'";
			$conn->query($query);
			if ($conn->next_record())
				$catID = $conn->field_value("CAT_ID");

			//---- insert brochure
			$query = "INSERT INTO brochures (BRO_CAT_ID, BRO_THEM_ID, BRO_TITLE)";
			$query.= " VALUES ('".$catID."', '".$themID."', \"".addslashes($TITLE)."\")";
			$conn->query($query);

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

			if ($langID != "")
			{
				$query = "INSERT brochures_languages (BROLANG_BRO_ID, BROLANG_LANG_ID, BROLANG_TITLE) VALUES ('".$broID."', '".$langID."', \"".addslashes($TITLE)."\")";
				$conn->query($query);
			}

			//---- delete old items from brochuresdocuments
			$query = "DELETE FROM brochuresdocuments WHERE BD_BRO_ID='".$broID."'";
			$conn->query($query);

			//---- delete old items from brochuresservices
			$query = "DELETE FROM brochuresservices WHERE BS_BRO_ID='".$broID."'";
			$conn->query($query);

			//---- insert new elements
			$nbOrder = 1;
			for($i=0;$i<sizeOf($idTab);$i++)
			{
				$query = "INSERT INTO brochuresservices (BS_BRO_ID, BS_SERV_ID, BS_ORDERNB)";
				$query.= " VALUES ('".$broID."', '".$idTab[$i]."', '".($i+1)."')";
				$conn->query($query);
/*
				//---- get all documents of the service
				$query2 = "SELECT * FROM services, servicesdocuments WHERE SERV_ID=SERVDOC_SERV_ID AND SERV_ID='".$idTab[$i]."' ORDER BY SERVDOC_NBORDER";
				$conn2->query($query2);

				while($conn2->next_record())
				{
					$query = "INSERT INTO brochuresdocuments (BD_BRO_ID, BD_DOC_ID, BD_TITLE, BD_DESCRIPTION, BD_ORDER)";
					$query.= " VALUES ('".$broID."', '".$conn2->field_value("SERVDOC_DOC_ID")."', \"".addslashes($conn2->field_value("SERVDOC_TITLE"))."\", \"".addslashes($conn2->field_value("SERVDOC_TEXT"))."\", '".$nbOrder."')";
					$conn->query($query);
					$nbOrder++;
				}*/
			}

			//---- get compositions ID
			$composID = -1;
			$query = "SELECT COMPOS_ID FROM compositions WHERE COMPOS_TITLE='Brochure'";
			$conn->query($query);
			if ($conn->next_record())
				$composID = $conn->field_value("COMPOS_ID");

			//---- get regions ID
			$regionID = -1;
			$query = "SELECT LOC_CAT_ID FROM localities WHERE LOC_ID='".$LOC_ID."'";
			$conn->query($query);
			if ($conn->next_record())
				$regionID = $conn->field_value("LOC_CAT_ID");

			//---- get orderNumber
			$orderNum = 1;
			$query = "SELECT COMPOSLOC_ORDER FROM compositionslocalities WHERE COMPOSLOC_LOC_ID='".$LOC_ID."' AND COMPOSLOC_CAT_ID='".$regionID."' ORDER BY COMPOSLOC_ORDER";
			$conn->query($query);
			if ($conn->next_record())
				$orderNum = $conn->field_value("COMPOSLOC_ORDER") + 1;

			//---- insert composition in compositionslocalities
			$query = "INSERT INTO compositionslocalities (COMPOSLOC_LOC_ID, COMPOSLOC_OBJ_ID, COMPOSLOC_COMPOS_ID, COMPOSLOC_CAT_ID, COMPOSLOC_ORDER)";
			$query.= " VALUES ('".$LOC_ID."', '".$broID."', '".$composID."', '".$regionID."', '".$orderNum."')";
			$conn->query($query);
		}

		//---- display data
		print "RESULT=done";
	}
	else
		print "RESUL=error0";
?>