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

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


	//---- Parameters
	// INDEXIDTAB = IDs of the services
	// LANG (optional)
	$conn = new MySQL($HOST, $DATABASE, $LOGIN, $PASSWORD);

	$serviceIDsTab =  split("\|", $INDEXIDTAB);

	//---- get data
	$eltByServiceTab = "";
	$titleTab = "";
	$descrTab = "";
	$imgTab = "";
	$nextVal = "";

	$currentPage = 0;
	for($i=0;$i<sizeOf($serviceIDsTab);$i++)
	{
		//---- get number of documents for the service (for page management)
		if ($i > 0)
		{
			$query = "SELECT count(*) as nb FROM servicesdocuments WHERE SERVDOC_SERV_ID='".$serviceIDsTab[$i-1]."'";
			$conn->query($query);
			if ($conn->next_record())
			{
				$currentPage = $currentPage + $conn->field_value("nb");
				$eltByServiceTab.= $nextVal.$currentPage;
			}
		}
		else
	 		$eltByServiceTab = "0";

		if (empty($LANG))
			$query = "SELECT SERV_NAME as SNAME, SERVDOC_TITLE as SDTITLE, SERVDOC_TEXT as SDTEXT, DOC_FILE FROM services, servicesdocuments, documents WHERE SERV_ID=SERVDOC_SERV_ID AND SERVDOC_DOC_ID=DOC_ID AND SERV_ID='".$serviceIDsTab[$i]."' ORDER BY SERVDOC_NBORDER";
		else
		{	$query = "SELECT SERVLANG_NAME as SNAME, SERVDOCLANG_TITLE as SDTITLE, SERVDOCLANG_TEXT as SDTEXT, DOC_FILE 
						FROM services_languages, servicesdocuments, servicesdocuments_languages, documents, languages 
						WHERE SERVLANG_SERV_ID=SERVDOC_SERV_ID 
						  AND SERVDOC_DOC_ID=DOC_ID 
						  AND SERVLANG_SERV_ID='".$serviceIDsTab[$i]."'

						  AND LANG_CODE='".$LANG."'
						  AND LANG_ID=SERVLANG_LANG_ID
						  AND SERVDOCLANG_LANG_ID=LANG_ID
						  
						  AND SERVDOCLANG_SERV_ID=SERVDOC_SERV_ID
						  AND SERVDOCLANG_DOC_ID=SERVDOC_DOC_ID

						  ORDER BY SERVDOC_NBORDER";
		}
		$conn->query($query);

		while($conn->next_record())
		{
			$titleTab.= $nextVal.utf8_encode($conn->field_value("SDTITLE"));
			$descrTab.= $nextVal.utf8_encode($conn->field_value("SDTEXT"));
			$imgTab.= $nextVal.$conn->field_value("DOC_FILE");
			$servTitleTab.= $nextVal.utf8_encode(($i+1).". ".$conn->field_value("SNAME"));
			$nextVal = "|";
		}
	}

	//---- display data
	print "imgTab=".$imgTab;
	print "&titleTab=".$titleTab;
	print "&descrTab=".$descrTab;
	print "&eltByServiceTab=".$eltByServiceTab;
	print "&servTitleTab=".$servTitleTab;
?>