function tree_de($id, $wid, $uid) { global $db; $query = $db->query("SELECT * FROM " . DB_TABLEPRE . "department where father='" . $id . "' ORDER BY id Asc"); $html .= '<ul>'; while ($rowl = $db->fetch_array($query)) { $blog = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "department where father='" . $rowl['id'] . "' ORDER BY id Asc"); $user = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "user WHERE departmentid = '" . $rowl['id'] . "'"); if ($uid != '') { $uid = $db->fetch_one_array("SELECT departmentid FROM " . DB_TABLEPRE . "user WHERE id= '" . $uid . "'"); } $html .= '<li '; if ($uid['departmentid'] != $rowl['id']) { $html .= 'isexpand="false"'; } $html .= '>'; $html .= ' <span>' . $rowl['name'] . '</span>'; if ($blog['id'] != '') { tree_de($rowl['id'], $wid, $uid); } if ($user['id'] != '') { tree_user($rowl['id'], $wid, $uid); } $html .= '</li>'; } $html .= '</ul>'; echo $html; }
$blog = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "department where father='" . $rowl['id'] . "' ORDER BY id Asc"); $user = $db->fetch_one_array("SELECT * FROM " . DB_TABLEPRE . "user WHERE departmentid = '" . $rowl['id'] . "'"); if ($_GET['uid'] != '') { $uid = $db->fetch_one_array("SELECT departmentid FROM " . DB_TABLEPRE . "user WHERE id= '" . $_GET['uid'] . "'"); } echo '<li '; if ($uid['departmentid'] != $rowl['id']) { echo 'isexpand="false"'; } echo '>'; echo ' <span>' . $rowl['name'] . '</span>'; if ($blog['id'] != '') { tree_de($rowl['id'], $_GET['wid'], $_GET['uid']); } if ($user['id'] != '') { tree_user($rowl['id'], $_GET['wid'], $_GET['uid']); } echo '</li>'; } ?> </ul> </div> </div> </td> <td valign="top"> <!--右边开始--> <input type="hidden" name="wid" value="<?php echo $_GET['wid'];