<?php
try {
	require_once("core/class/class_db.php");
	require_once("modules/moreq/moreq_tables_definition.php");
} catch (Exception $e){
	echo $e->getMessage().' // ';
}


$coll_id="letterbox_coll"; // N'est indiqué que parce que la gestion des collections n'est pas encore intégrée

$table_name=_CLASSIFICATION_SCHEME_VIEW; 
$id=$_REQUEST["mr_classification_scheme_id"];

$db=new dbquery();
// Getting max available for current user
$where_clause=$_SESSION['user']['security'][$coll_id]['CLASS']['where'];
$sql="select mr_aggregation_id, mr_title, level_number, mr_classification_code, parent_mr_aggregation_id from $table_name where parent_mr_classification_scheme_id=$id and $where_clause";

try {
	$db->connect();
	$db->query($sql);
	$queryResult=array();
	$ids=array();
	$parentIds=array();
	$result=array();
	while($queryLine=$db->fetch_object()){
		$queryResult[$queryLine->mr_aggregation_id]="{'id':'".$queryLine->mr_aggregation_id."','txt':'".$queryLine->mr_title."','tooltip':'Level: ".$queryLine->level_number." - Code: ".$queryLine->mr_classification_code."','canhavechildren':true}";
		$ids[]=$queryLine->mr_aggregation_id;
		$parentIds[]=$queryLine->parent_mr_aggregation_id;
	}
	$nbResults=count($ids);
	for($i=0;$i<$nbResults;$i++){
		if(!in_array($parentIds[$i],$ids))
        {
			// Current aggregation has no given parent amongst query results (so it is root)
			$result[]=$queryResult[$ids[$i]];
		}
	}
	$result="[".implode(",",$result)."]";
	$db->disconnect();
} catch (Exception $e) {
	echo "Impossible to get object id=$id // ";
}
header('Content-type: application/json');
echo $result;