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

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


	//---- Parameters
	// LOCID = ID of the location
	// LANG
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);


	//---- get leisure services
/*	$query = "SELECT distinct SERV_DESC_ID FROM servicesleisure, services, servicesdocuments, documents
				WHERE SERVLEI_SERV_ID=SERV_ID
				AND SERVDOC_DOC_ID=DOC_ID 
				AND SERVDOC_SERV_ID=SERV_ID 
				AND SERVLEI_LOC_ID='".$LOCID."'
				ORDER BY SERV_DESC_ID";
*/
	$query = "SELECT distinct SERV_DESC_ID FROM thematics, services
				WHERE THEM_ID=SERV_THEM_ID
				AND SERV_LOC_ID='".$LOCID."'
				AND THEM_NAME='Activities'
				AND SERV_ID NOT IN (SELECT SERVD_SERV_ID FROM services_details)
				ORDER BY SERV_DESC_ID";
	$conn->query($query);

	$separator = "";
	while($conn->next_record())
	{
		$leisureServDescID.= $separator.$conn->field_value("SERV_DESC_ID");
		$separator = "|";
	}


	//---- get lodging services
/*	$query = "SELECT distinct SERV_DESC_ID FROM serviceslodging, services, servicesdocuments, documents
				WHERE SERVLOD_SERV_ID=SERV_ID
				AND SERVDOC_DOC_ID=DOC_ID 
				AND SERVDOC_SERV_ID=SERV_ID 
				AND SERVLOD_LOC_ID='".$LOCID."'
				ORDER BY SERV_DESC_ID";
*/
	$query = "SELECT distinct SERV_DESC_ID FROM thematics, services
				WHERE THEM_ID=SERV_THEM_ID
				AND SERV_LOC_ID='".$LOCID."'
				AND THEM_NAME='Lodging'
				AND SERV_ID NOT IN (SELECT SERVD_SERV_ID FROM services_details)
				ORDER BY SERV_DESC_ID";
	$conn->query($query);

	$separator = "";
	while($conn->next_record())
	{
		$lodgingServDescID.= $separator.$conn->field_value("SERV_DESC_ID");
		$separator = "|";
	}


	//---- get transport services
/*	$query = "SELECT distinct SERV_DESC_ID FROM servicestransport, services, servicesdocuments, documents
				WHERE SERVTRANS_SERV_ID=SERV_ID
				AND SERVDOC_DOC_ID=DOC_ID 
				AND SERVDOC_SERV_ID=SERV_ID 
				AND SERV_NBDAYS <> 0
				AND SERVTRANS_FROM_ID='".$LOCID."'
				ORDER BY SERV_DESC_ID";
*/
	$query = "SELECT distinct SERV_DESC_ID FROM thematics, services
				WHERE THEM_ID=SERV_THEM_ID
				AND SERV_NBDAYS <> 0
				AND SERV_LOC_ID='".$LOCID."'
				AND THEM_NAME='Transport'
				AND SERV_ID NOT IN (SELECT SERVD_SERV_ID FROM services_details)
				ORDER BY SERV_DESC_ID";
	$conn->query($query);

	$separator = "";
	while($conn->next_record())
	{
		$transportServDescID.= $separator.$conn->field_value("SERV_DESC_ID");
		$separator = "|";
	}


		//---- get wellness services
	$query = "SELECT distinct SERV_DESC_ID FROM thematics, services
				WHERE THEM_ID=SERV_THEM_ID
				AND SERV_NBDAYS <> 0
				AND SERV_LOC_ID='".$LOCID."'
				AND THEM_NAME='Wellness'
				AND SERV_ID NOT IN (SELECT SERVD_SERV_ID FROM services_details)
				ORDER BY SERV_DESC_ID";
	$conn->query($query);

	$separator = "";
	while($conn->next_record())
	{
		$wellnessServDescID.= $separator.$conn->field_value("SERV_DESC_ID");
		$separator = "|";
	}


	//---- get locName
	$query = "SELECT * FROM localities WHERE LOC_ID='".$LOCID."'";
	$conn->query($query);
	if ($conn->next_record())
		$LOCNAME = $conn->field_value("LOC_NAME");


	print "leisureServDescID=".$leisureServDescID;
	print "&lodgingServDescID=".$lodgingServDescID;
	print "&transportServDescID=".$transportServDescID;
	print "&wellnessServDescID=".$wellnessServDescID;
	print "&locName=".utf8_encode($LOCNAME);
?>