<?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_TABLE_NAME; 

$db=new dbquery();

// Getting only classification scheme allowed for the current user
$sql="select distinct cs_full_classification_code, cs_title, mr_classification_scheme_id from "._CLASSIFICATION_SCHEME_VIEW." where ".$_SESSION['user']['security'][$coll_id]['CLASS']['where']." order by cs_full_classification_code";

try {
	$db->connect();
	$db->query($sql);
	$result=array();
	while($queryLine=$db->fetch_object()){
		$result[]="{'id':'".$queryLine->mr_classification_scheme_id."','txt':'".$queryLine->cs_title." (".$queryLine->cs_full_classification_code.")','tooltip':'".$queryLine->cs_title."'}";
	}
	$result="[".implode(",",$result)."]";
	$db->disconnect();
} catch (Exception $e) {
	echo "Impossible to get object id=$id // ";
}
header('Content-type: application/json');
echo $result;