. */ /** * @brief Show the tree * * @file * @author Laurent Giovannoni * @date $date$ * @version $Revision$ * @ingroup admin */ require_once("core".DIRECTORY_SEPARATOR."class".DIRECTORY_SEPARATOR."class_request.php"); $core_tools = new core_tools(); $core_tools->load_lang(); $func = new functions(); $db = new dbquery(); $db->connect(); $db1 = new dbquery(); $db1->connect(); $db2 = new dbquery(); $db2->connect(); $db3 = new dbquery(); $db3->connect(); $db4 = new dbquery(); $db4->connect(); $nb_trees = count($_SESSION['doctypes_chosen_tree']); $core_tools->load_html(); $core_tools->load_header(); $f_level = array(); ?> query("select d.doctypes_first_level_id, d.doctypes_first_level_label from ".$_SESSION['tablename']['fold_foldertypes_doctypes_level1']." g, ".$_SESSION['tablename']['doctypes_first_level']." d where g.foldertype_id = '".$_SESSION['doctypes_chosen_tree']."' and g.doctypes_first_level_id = d.doctypes_first_level_id and d.enabled = 'Y' order by d.doctypes_first_level_label"); while($res1 = $db1->fetch_object()) { $s_level = array(); $db2->query("select doctypes_second_level_id, doctypes_second_level_label from ".$_SESSION['tablename']['doctypes_second_level']." where doctypes_first_level_id = ".$res1->doctypes_first_level_id." and enabled = 'Y'"); while($res2 = $db2->fetch_object()) { $doctypes = array(); $db3->query("select type_id, description from ".$_SESSION['tablename']['doctypes']." where doctypes_first_level_id = ".$res1->doctypes_first_level_id." and doctypes_second_level_id = ".$res2->doctypes_second_level_id." and enabled = 'Y' "); while($res3 = $db3->fetch_object()) { $results = array(); array_push($doctypes, array('type_id' => $res3->type_id, 'description' => $func->show_string($res3->description), "results" => $results)); } array_push($s_level, array('doctypes_second_level_id' => $res2->doctypes_second_level_id, 'doctypes_second_level_label' => $func->show_string($res2->doctypes_second_level_label, true), 'doctypes' => $doctypes)); } array_push($f_level, array('doctypes_first_level_id' => $res1->doctypes_first_level_id, 'doctypes_first_level_label' => $func->show_string($res1->doctypes_first_level_label, true), 'second_level' => $s_level)); } for($i=0;$i $fLabel, 'content' => $f_level)); ?>