function dep_data($fid = 0, $userview) { global $db; $query = $db->query("SELECT * FROM " . DB_TABLEPRE . "department where father='{$fid}' ORDER BY id Asc"); $html = ''; while ($row = $db->fetch_array($query)) { $blog = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "department where father='" . $row['id'] . "' ORDER BY id Asc"); $user = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "user WHERE departmentid ='" . $row['id'] . "'"); //$html.= 'var subarr'.$fid.' = [];'.chr(13).chr(10); $html .= 'subarr' . $fid . '.push( {' . chr(13) . chr(10); $html .= ' "id" : "1' . $row['id'] . '",' . chr(13) . chr(10); $html .= ' "text" : "' . $row['name'] . '",' . chr(13) . chr(10); $html .= ' "value" : "department",' . chr(13) . chr(10); $html .= ' "showcheck" : true,' . chr(13) . chr(10); $html .= ' complete : true,' . chr(13) . chr(10); $html .= ' "isexpand" : false,' . chr(13) . chr(10); $html .= ' "checkstate" : 0,' . chr(13) . chr(10); if ($blog['id'] != '' || $user['id'] != '') { $html .= ' "hasChildren" : true,' . chr(13) . chr(10); $html .= ' "ChildNodes" : subarr' . $row[id] . '' . chr(13) . chr(10); } else { $html .= ' "hasChildren" : false' . chr(13) . chr(10); } $html .= ' });' . chr(13) . chr(10); if ($blog['id'] != '' || $user['id'] != '') { echo 'var subarr' . $row['id'] . ' = [];' . chr(13) . chr(10); if ($blog['id'] != '') { dep_data($row['id'], $userview); } if ($user['id'] != '') { dep_data_user($row['id'], $userview); } } } echo $html; }
$html .= ' "isexpand" : false,' . chr(13) . chr(10); $html .= ' "checkstate" : 0,' . chr(13) . chr(10); if ($blog['id'] != '' || $user['id'] != '') { $html .= ' "hasChildren" : true,' . chr(13) . chr(10); $html .= ' "ChildNodes" : subarr' . $row[id] . '' . chr(13) . chr(10); } else { $html .= ' "hasChildren" : false' . chr(13) . chr(10); } $html .= '});' . chr(13) . chr(10); if ($blog['id'] != '' || $user['id'] != '') { echo 'var subarr' . $row['id'] . ' = [];' . chr(13) . chr(10); if ($blog['id'] != '') { dep_data($row['id'], $userview); } if ($user['id'] != '') { dep_data_user($row['id'], $userview); } } //if($user['id']!=''){ //echo 'var subarr'.$row['id'].' = [];'.chr(13).chr(10); //dep_data_user($row['id']); //} } echo $html; ?> root["ChildNodes"] = arr; return root; } //treedata = [createNode()]; treedata = [createNode()];