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

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


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

	if ($LANG == "")
		$LANG = $DEFAULT_LANG;

	//---- 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");

	$theTheme = $THEME;
	if (($THEME == "Activity") || ($THEME == "Package"))
		$theTheme = "Activities";

	//---- get themeID
	$themeID = "";
	$query = "SELECT THEM_ID FROM thematics WHERE THEM_NAME='".$theTheme."'";
	$conn->query($query);
	if ($conn->next_record())
		$themeID = $conn->field_value("THEM_ID");


/*	if ($LANG == $DEFAULT_LANG)
	{	$query = "SELECT distinct SERV_ID, SERV_NAME as mainName, SERVDOC_TITLE as sName, DOC_FILE, SERVDOC_TEXT as sInfo, SERV_NBDAYS, '0' as sPrice, SERV_COMP_ID, SERV_FIELDCARD, SERV_FIELD_STATUS, SERV_PRICE_STATUS, DOC_ID, SERV_ISPUBLIC
					FROM thematics, services, servicesdocuments, documents
					WHERE SERV_THEM_ID=THEM_ID
					AND SERVDOC_DOC_ID=DOC_ID 
					AND SERVDOC_SERV_ID=SERV_ID 
					AND SERV_LOC_ID='".$LOCID."'
					AND SERV_DESC_ID='".$SERVDESCID."'
					AND THEM_NAME='".$theTheme."'";
		$query.= "	ORDER BY SERV_ID, SERVDOC_NBORDER";
	}
	else
	{
		$query = "SELECT distinct SERV_ID, SERVLANG_NAME as mainName, SERVDOCLANG_TITLE as sName, DOC_FILE, SERVDOCLANG_TEXT as sInfo, SERV_NBDAYS, '0' as sPrice, SERV_COMP_ID, SERV_FIELDCARD, SERV_FIELD_STATUS, SERV_PRICE_STATUS, DOC_ID, SERV_ISPUBLIC
					FROM services, servicesdocuments, servicesdocuments_languages, documents, services_languages
					WHERE SERV_THEM_ID='".$themeID."'

					AND SERVLANG_LANG_ID='".$langID."'
					AND SERVLANG_SERV_ID=SERV_ID

					AND SERVDOCLANG_LANG_ID=SERVLANG_LANG_ID
					AND SERVDOCLANG_SERV_ID=SERV_ID
					AND SERVDOCLANG_DOC_ID=SERVDOC_DOC_ID

					AND SERVDOC_DOC_ID=DOC_ID 
					AND SERVDOC_SERV_ID=SERV_ID 
					AND SERV_LOC_ID='".$LOCID."'
					AND SERV_DESC_ID='".$SERVDESCID."'";
		$query.= "	ORDER BY SERV_ID, SERVDOC_NBORDER";
	}
*/


		$query = "SELECT distinct SERV_ID, SERVLANG_NAME as mainName, SERVDOCLANG_TITLE as sName, DOC_FILE, SERVDOCLANG_TEXT as sInfo, SERV_NBDAYS, '0' as sPrice, SERV_COMP_ID, SERV_FIELDCARD, SERV_FIELD_STATUS, SERV_PRICE_STATUS, DOC_ID, SERV_ISPUBLIC
					FROM services 
					LEFT JOIN services_languages ON (SERVLANG_LANG_ID='".$langID."' AND SERVLANG_SERV_ID=SERV_ID)
					JOIN servicesdocuments ON SERVDOC_SERV_ID=SERV_ID
					LEFT JOIN servicesdocuments_languages ON (SERVDOCLANG_LANG_ID='".$langID."' AND SERVDOCLANG_SERV_ID=SERVDOC_SERV_ID AND SERVDOCLANG_DOC_ID=SERVDOC_DOC_ID)
					JOIN documents ON SERVDOC_DOC_ID=DOC_ID

					WHERE SERV_THEM_ID='".$themeID."'
					AND SERV_LOC_ID='".$LOCID."'
					AND SERV_DESC_ID='".$SERVDESCID."'
					ORDER BY SERV_ID, SERVDOC_NBORDER";

		$conn->query($query);


		$separator = "";
		while($conn->next_record())
		{
			$servID.= $separator.$conn->field_value("SERV_ID");
			$servName.= $separator.$conn->field_value("sName");
			$servFile.= $separator.$conn->field_value("DOC_FILE");
			$servInfo.= $separator.$conn->field_value("sInfo");
			$servNbDays.= $separator.$conn->field_value("SERV_NBDAYS");
			$servPrice.= $separator.$conn->field_value("sPrice");
			$servCompID.= $separator.$conn->field_value("SERV_COMP_ID");
			$servDocID.= $separator.$conn->field_value("DOC_ID");
			$servIsPublic.= $separator.$conn->field_value("SERV_ISPUBLIC");

			$servFieldCard.= $separator.$conn->field_value("SERV_FIELDCARD");
			$servFieldStatus.= $separator.$conn->field_value("SERV_FIELD_STATUS");
			$servPriceStatus.= $separator.$conn->field_value("SERV_PRICE_STATUS");
			$servMainTitle.= $separator.$conn->field_value("mainName");

			$separator = "|";


		}

		
		$query = "SELECT distinct SERV_ID, SERV_NAME,'', '', '', '', '', '', SERV_FIELDCARD, SERV_FIELD_STATUS, SERV_PRICE_STATUS, '', SERV_ISPUBLIC 
			FROM services 
			WHERE SERV_THEM_ID='".$themeID."' 
			AND SERV_LOC_ID='".$LOCID."' 
			AND SERV_DESC_ID='".$SERVDESCID."' 
			AND SERV_FIELD_STATUS=''
			ORDER BY SERV_ID";

		$conn->query($query);


		while($conn->next_record())
		{
			$servID.= $separator.$conn->field_value("SERV_ID");
			$servName.= $separator.$conn->field_value("SERV_NAME");
			$servFile.= '';
			$servInfo.= '';
			$servNbDays.= '';
			$servPrice.= '';
			$servCompID.= '';
			$servDocID.= '';
			$servIsPublic.= $separator.$conn->field_value("SERV_ISPUBLIC");

			$servFieldCard.= $separator.$conn->field_value("SERV_FIELDCARD");
			$servFieldStatus.= $separator.$conn->field_value("SERV_FIELD_STATUS");
			$servPriceStatus.= $separator.$conn->field_value("SERV_PRICE_STATUS");
			$servMainTitle.= $separator.$conn->field_value("SERV_NAME");

			$separator = "|";
		}


		print "servID=".$servID;
		print "&servName=".utf8_encode($servName);
		print "&servFile=".utf8_encode($servFile);
		print "&servInfo=".utf8_encode($servInfo);
		print "&servNbDays=".utf8_encode($servNbDays);
		print "&servPrice=".utf8_encode($servPrice);
		print "&servCompID=".utf8_encode($servCompID);
		print "&servDocID=".utf8_encode($servDocID);
		print "&servIsPublic=".utf8_encode($servIsPublic);
		print "&servFieldCard=".utf8_encode($servFieldCard);
		print "&servFieldStatus=".utf8_encode($servFieldStatus);
		print "&servPriceStatus=".utf8_encode($servPriceStatus);

		print "&servMainTitle=".utf8_encode($servMainTitle);
		

?>