public static function get_user_menu_list() { $usermenu = mod_member::get_user_menu(ADMINUSERID); $data = array(); $query = pm_db::query("SELECT * FROM iosadm_menu WHERE parent_id=0 AND level=1 AND is_show=1 AND status=1 ORDER BY sort ASC"); $menu_str = ''; $menu_str = '<ul id="sddm">'; $mi = 1; while ($row = pm_db::fetch_one($query)) { if (ADMINLEVEL != 1 && !$usermenu[$row['menu_id']]) { continue; } $menu_str .= '<li><a href="#" onmouseover="mopen(\'m' . $mi . '\')" onmouseout="mclosetime()">' . $row['menu_name'] . '</a><div id="m' . $mi . '" onmouseover="mcancelclosetime()" onmouseout="mclosetime()">'; $secondquery = pm_db::query("SELECT menu_id FROM iosadm_menu WHERE parent_id='{$row['menu_id']}' AND level=2 ORDER BY sort ASC"); $second = pm_db::fetch_all($secondquery); if (!$second) { $query1 = pm_db::query("SELECT * FROM iosadm_menu WHERE parent_id='{$row['menu_id']}' AND level=3 AND status=1 ORDER BY sort ASC"); } else { $string = ''; $string .= "("; foreach ($second as $v) { $string .= "'{$v['menu_id']}',"; } $string = substr($string, 0, -1) . ')'; $query1 = pm_db::query("SELECT * FROM iosadm_menu WHERE parent_id IN {$string} AND level=3 AND status=1 ORDER BY sort ASC"); } while ($row1 = pm_db::fetch_one($query1)) { if (ISSUPERADMIN != 1 && $row['menu_id'] == 3) { if (!in_array($row1['menu_id'], array(4, 7))) { continue; } } if (ADMINLEVEL != 1 && !$usermenu[$row1['menu_id']]) { continue; } $menu_str .= '<a href="' . $row1['act_url'] . '">' . $row1['menu_name'] . '</a>'; } $menu_str .= '</div></li>'; $mi++; } return $menu_str; }
public static function get_sec_thrid_menu() { $get = $_GET; $user_id = ADMINUSERID; $usermenu = mod_member::get_user_menu($user_id); $menu = array(); $query = pm_db::query("SELECT * FROM pm_menu WHERE level=1 AND is_show=1 AND menu_id='{$get['menu_id']}' AND status=1"); while ($row = pm_db::fetch_one($query)) { $secondmenu = array(); $query1 = pm_db::query("SELECT menu_id,menu_name FROM pm_menu WHERE level=2 AND parent_id='{$row['menu_id']}' AND is_show=1 AND status=1"); while ($row1 = pm_db::fetch_one($query1)) { $thirdmenu = array(); $query2 = pm_db::query("SELECT menu_id,menu_name,act_url,actioncode FROM pm_menu WHERE level=3 AND parent_id='{$row1['menu_id']}' AND is_show=1 AND status=1 order by sort desc"); while ($row2 = pm_db::fetch_one($query2)) { $menu[$row1['menu_id']]['f'] = $row1; $menu[$row1['menu_id']]['s'][] = $row2; } } } return $menu; }