. */ /** * @brief Script used to populate tree branches * * @file * @author Laurent Giovannoni * @date $date$ * @version $Revision$ * @ingroup admin */ if(isset($_REQUEST['branch_id']) && !empty($_REQUEST['branch_id']) && isset($_REQUEST['IdTree']) && !empty($_REQUEST['IdTree'])) { $string = $_REQUEST['branch']; $search="'branch_level_id'"; $search="#branch_level_id\":(.*)\,#U"; preg_match($search,$string,$out); $count=count($out[0]); if($count == 1) { $find = true; } $branch_level_id = str_replace("branch_level_id\":", "", $out[0]); $branch_level_id = str_replace(",", "", $branch_level_id); $branch_level_id = str_replace("\"", "", $branch_level_id); $core_tools = new core_tools(); $core_tools->load_lang(); $func = new functions(); $tree_id = $_REQUEST['IdTree']; $db = new dbquery(); $db->connect(); $where = ""; if($branch_level_id == "1") { $db->query("select * from ".$_SESSION['tablename']['doctypes_second_level']." where doctypes_first_level_id = '".$_REQUEST['branch_id']."' and enabled ='Y' order by doctypes_second_level_label asc"); $children = array(); while($res = $db->fetch_object()) { array_push($children, array('id' => $res->doctypes_second_level_id, 'tree' => $_SESSION['doctypes_chosen_tree'], 'key_value' => $res->doctypes_second_level_id, 'label_value' => $db->show_string($res->doctypes_second_level_label, true), 'script' => "show_doctypes")); } if(count($children) > 0) { echo "["; for($cpt_level2=0; $cpt_level2< count($children); $cpt_level2++) { echo "{'id':'".$children[$cpt_level2]['id']."', 'txt':'".trim(addslashes($children[$cpt_level2]['label_value']))."', 'canhavechildren' : true, '".$children[$cpt_level2]['script']."' : 'other', 'key_value' : '".trim(addslashes($children[$cpt_level2]['key_value']))."', 'onbeforeopen' : MyBeforeOpen}"; if(isset($children[$cpt_level2+1]['id']) && !empty($children[$cpt_level2+1]['id'])) { echo ','; } } echo "]"; } } if($branch_level_id == "2") { $db->query("select * from ".$_SESSION['tablename']['doctypes']." where doctypes_second_level_id = '".$_REQUEST['branch_id']."' and enabled ='Y' order by description"); $children = array(); while($res = $db->fetch_object()) { array_push($children, array('id' => $res->type_id, 'tree' => $_SESSION['doctypes_chosen_tree'], 'key_value' => $res->type_id, 'label_value' => $db->show_string($res->description, true), 'script' => "other")); } if(count($children) > 0) { echo "["; for($cpt_level3=0; $cpt_level3< count($children); $cpt_level3++) { echo "{'id':'".$children[$cpt_level3]['id']."', 'txt':'".trim(addslashes($children[$cpt_level3]['label_value']))."', 'canhavechildren' : false, '".$children[$cpt_level3]['script']."' : 'default', 'key_value' : '".trim(addslashes($children[$cpt_level3]['key_value']))."', 'img' : 'page.gif'}"; if(isset($children[$cpt_level3+1]['id']) && !empty($children[$cpt_level3+1]['id'])) { echo ','; } } echo "]"; } } } ?>