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

$table_name=_CLASSIFICATION_SCHEME_VIEW;
$id=$_REQUEST["mr_aggregation_id"];
$coll_id="letterbox_coll"; // N'est indiqué que parce que la gestion des collections n'est pas encore intégrée

$db=new dbquery();
$where_clause=$_SESSION['user']['security'][$coll_id]['CLASS']['where'];
$sql="select mr_aggregation_id, mr_title, level_number, mr_classification_code from $table_name where parent_mr_aggregation_id=$id and $where_clause order by mr_classification_code";

try {
	$db->connect();
	$db->query($sql);
     $result = array();
	// Constructing result
	while($queryLine=$db->fetch_object()){
		$result[]="{ 'id':'".$queryLine->mr_aggregation_id."','txt':'".$queryLine->mr_title."', 'tooltip':'Level: ".$queryLine->level_number." - Code: ".$queryLine->mr_classification_code."', 'canhavechildren':true } ";
	}
	// String formating in JSON
    $result="[".implode(",",$result)."]";

 
	$db->disconnect();
} catch (Exception $e) {
	echo "Impossible to get object id=$id // ";
}
header('Content-type: application/json');
echo $result;