设为首页 收藏本站

运维网

 找回密码
 立即注册
查看: 812|回复: 0

[经验分享] 动态节点树 多级分类 php jquery ajax json mysql 点击进入菜单

[复制链接]
zidong
累计签到：1 天
连续签到：1 天
发表于 2016-10-23 10:31:37 | 显示全部楼层 |阅读模式
　　直接生成的调用动态节点树
　　<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

　　<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<link rel="stylesheet" type="text/css" href="/theme/3/style.css" />
<link rel="stylesheet" type="text/css" href="/theme/3/menu_left.css" />
<script language="JavaScript" src="/inc/js/menu_left.js"></script>
<script language="JavaScript" src="/inc/js/hover_tr.js"></script>
<script type="text/javascript" src="/inc/js_lang.php"></script>
</head>
<body>
<ul>
<li><a href="javascript:;"  target="dept_main" title="点击伸缩列表" id="link_1"><span>部门列表</span></a></li>
<div id="module_1" class="moduleContainer treeList" style=""><div id="tree"></div>
<link rel="stylesheet" type="text/css" href="/images/org/ui.dynatree.css">
<script type="text/javascript" src="/inc/js_lang.php"></script>
<script type="text/javascript" src="/inc/js/tree.js"></script>
<script type="text/javascript">
var tree = new Tree("tree", "/inc/dept_list/tree.php?DEPT_ID=0&PARA_URL=/general/system/dept/dept_edit.php&e=&PARA_TARGET=dept_main&PRIV_NO_FLAG=1&PARA_ID=&PARA_VALUE=&showButton=0&MODULE_ID=&MANAGE_FLAG=&DEPT_PRIV=1&USER_SELECT_FLAG=", '/images/org/', false,3, {"minExpandLevel":2});
tree.BuildTree();
</script>
</div>
</ul>
</body>
</html>

　　
　　————————————————————————————————————————————————————————————————————————————
　　生成json的php文件tree.php
　　<?php
　　
function deptListTree( $PARENT_ID )
{
global $connection;
global $LOGIN_USER_ID;
global $LOGIN_DEPT_ID;
global $LOGIN_USER_PRIV;
global $PARA_URL;
global $PARA_TARGET;
global $PARA_ID;
global $PARA_VALUE;
global $showButton;
global $DEPT_PRIV;
global $DEPT_ID_STR;
global $MODULE_ID;
global $USER_SELECT_FLAG;
global $MANAGE_FLAG;
global $MYOA_CHARSET;
$query = "SELECT * from DEPARTMENT where DEPT_PARENT='".$PARENT_ID."' order by DEPT_NO";
$cursor1 = exequery( $connection, $query );
while ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$DEPT_ID1 = $ROW['DEPT_ID'];
$DEPT_NAME1 = $ROW['DEPT_NAME'];
$DEPT_NAME1 = htmlspecialchars( $DEPT_NAME1 );
$DEPT_NAME1 = stripslashes( $DEPT_NAME1 );
$IS_ORG = $ROW['IS_ORG'];
if ( $DEPT_PRIV == 4 )
{
if ( $DEPT_ID1 == $LOGIN_DEPT_ID )
{
$DEPT_PRIV1 = 1;
}
else
{
$DEPT_PRIV1 = 0;
}
}
else
{
$DEPT_PRIV1 = is_dept_priv( $DEPT_ID1, $DEPT_PRIV, $DEPT_ID_STR, $USER_SELECT_FLAG );
}
if ( $DEPT_PRIV1 == 0 )
{
if ( $DEPT_PRIV == "" )
{
$DEPT_PRIV = getpostprivbyuserid( $LOGIN_USER_ID );
}
}
if ( !( $DEPT_PRIV == 6 ) )
{
$TITLE = $DEPT_PRIV1 == 1 ? "{$DEPT_NAME1}" : $DEPT_NAME1;
$URL = $TARGET = $JSON = "";
if ( $PARA_URL != "" && $DEPT_PRIV1 == 1 )
{
if ( $PARA_ID == "" )
{
$URL = "{$PARA_URL}?DEPT_ID={$DEPT_ID1}&MODULE_ID={$MODULE_ID}";
}
else
{
$URL = "{$PARA_URL}?DEPT_ID={$DEPT_ID1}&MANAGE_FLAG={$MANAGE_FLAG}&MODULE_ID={$MODULE_ID}&{$PARA_ID}=".str_replace( ".", "&", $PARA_VALUE );
}
$TARGET = $PARA_TARGET;
}
$CHILD_COUNT = 0;
$query = "SELECT 1 from DEPARTMENT where DEPT_PARENT='".$DEPT_ID1."'";
$cursor2 = exequery( $connection, $query );
if ( $ROW1 = mysql_fetch_array( $cursor2 ) )
{
++$CHILD_COUNT;
}
$IS_LAZY = FALSE;
if ( 0 < $CHILD_COUNT )
{
$JSON = "/inc/dept_list/tree.php?DEPT_ID=".$DEPT_ID1."&MANAGE_FLAG={$MANAGE_FLAG}&PARA_URL={$PARA_URL}&PARA_TARGET={$PARA_TARGET}&PARA_ID={$PARA_ID}&PARA_VALUE={$PARA_VALUE}&showButton={$showButton}&MODULE_ID={$MODULE_ID}&DEPT_PRIV={$DEPT_PRIV}&USER_SELECT_FLAG={$USER_SELECT_FLAG}";
$IS_LAZY = TRUE;
}
$ONCHECK = $showButton && $DEPT_PRIV1 == "1" ? "click_node" : "";
$DEPT_ARRAY[] = array(
"title" => td_iconv( $TITLE, $MYOA_CHARSET, "utf-8" ),
"isFolder" => TRUE,
"isLazy" => $IS_LAZY,
"key" => "dept_".$DEPT_ID1,
"dept_id" => $DEPT_ID1,
"icon" => $IS_ORG == 1 ? "org.png" : FALSE,
"url" => td_iconv( $URL, $MYOA_CHARSET, "utf-8" ),
"tooltip" => td_iconv( $DEPT_NAME1, $MYOA_CHARSET, "utf-8" ),
"json" => td_iconv( $JSON, $MYOA_CHARSET, "utf-8" ),
"target" => $TARGET,
"onCheck" => td_iconv( $ONCHECK, $MYOA_CHARSET, "utf-8" )
);
}
}
return $DEPT_ARRAY;
}
　　include_once( "inc/auth.php" );
include_once( "inc/utility_all.php" );
include_once( "inc/utility_org.php" );
ob_end_clean( );
$PARENT_ID = $DEPT_ID;
if ( $MODULE_ID != "" )
{
if ( $DEPT_PRIV == "2" )
{
$query1 = "SELECT DEPT_ID from MODULE_PRIV where UID='".$LOGIN_UID."' and MODULE_ID='{$MODULE_ID}'";
$cursor1 = exequery( $connection, $query1 );
if ( $ROW = mysql_fetch_array( $cursor1 ) )
{
$DEPT_ID_STR = $ROW['DEPT_ID'];
}
}
}
else if ( $MODULE_ID == "" && $DEPT_PRIV == "2" )
{
$query = "SELECT POST_DEPT from USER where UID='".$LOGIN_UID."'";
$cursor = exequery( $connection, $query );
if ( $ROW = mysql_fetch_array( $cursor ) )
{
$DEPT_ID_STR = $ROW['POST_DEPT'];
}
}
if ( $PARENT_ID == 0 )
{
include_once( "inc/cache/Cache.php" );
$UNIT_NAME = $td_cache->get( "SYS_UNIT" );
$ONCHECK = $showButton && $DEPT_PRIV == "1" ? "click_node" : "";
$DEPT_ARRAY = deptlisttree( $PARENT_ID );
$ORG_ARRAY = array(
"title" => td_iconv( $UNIT_NAME, $MYOA_CHARSET, "utf-8" ),
"isFolder" => TRUE,
"isLazy" => FALSE,
"expand" => TRUE,
"key" => "dept_0",
"dept_id" => "0",
"icon" => "root.png",
"tooltip" => td_iconv( $UNIT_NAME, $MYOA_CHARSET, "utf-8" ),
"children" => $DEPT_ARRAY,
"onCheck" => td_iconv( $ONCHECK, $MYOA_CHARSET, "utf-8" )
);
}
else
{
$ORG_ARRAY = deptlisttree( $PARENT_ID );
}
echo json_encode( $ORG_ARRAY );
?>

　　输出结果：
　　{} 个json格式数据
　　
　　————————————————————
　　menu_left调用
　　
　　include_once( "inc/auth.php" );
ob_end_clean( );
echo "<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">\r\n<html xmlns=\"http://www.w3.org/1999/xhtml\">\r\n<head>\r\n<title></title>\r\n<metahttp-equiv=\"Content-Type\" content=\"text/html; charset=gb2312\" />\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/theme/";
echo $LOGIN_THEME;
echo "/style.css\" />\r\n<link rel=\"stylesheet\" type=\"text/css\" href=\"/theme/";
echo $LOGIN_THEME;
echo "/menu_left.css\" />\r\n<script language=\"JavaScript\" src=\"/inc/js/menu_left.js\"></script>\r\n<script language=\"JavaScript\" src=\"/inc/js/hover_tr.js\"></script>\r\n<script type=\"text/javascript\" src=\"/inc/js_lang.php\"></script>\r\n";
echo $SCRIPT != "" ? "<script>\n".$SCRIPT."</script>" : "";
echo "</head>\r\n<body>\r\n";
if ( is_array( $MENU_HEAD ) )
{
echo "<div class=\"";
echo $MENU_HEAD['class'] == "" ? "head" : $MENU_HEAD['class'];
echo "\">";
if ( $MENU_HEAD['img'] )
{
echo "<img src=\"";
echo $MENU_HEAD['img'];
echo "\" align=\"absMiddle\">";
}
echo $MENU_HEAD['text'];
echo "</div>\r\n";
}
echo "<ul>\r\n";
$I = 0;
foreach ( $MENU_LEFT as $MENU )
{
++$I;
echo " <li><a href=\"";
echo $MENU['href'] == "" ? "javascript:;" : $MENU['href'];
echo "\" onclick=\"";
echo $MENU['onclick'] == "clickMenu" ? "clickMenu('".$I."');" : $MENU['onclick'];
echo "\" target=\"";
echo $MENU['target'] == "" ? "user_main" : $MENU['target'];
echo "\" title=\"";
echo $MENU['title'] == "" ? $MENU['text'] : $MENU['title'];
echo "\" id=\"link_";
echo $I;
echo "\"";
echo !$MENU['onclick'] && $MENU['module'] && !stristr( $MENU['module_style'], "display:none" ) ? " class=\"active\"" : "";
echo "><span>";
if ( $MENU['img'] != "" )
{
echo "<img src=\"";
echo $MENU['img'];
echo "\" width=\"16\" height=\"16\" align=\"absmiddle\"> ";
}
echo $MENU['text'];
echo "</span></a></li>\r\n";
if ( is_array( $MENU['module'] ) )
{
while ( list( $key, $value ) = each( &$MENU['module'] ) )
{
$$key = $value;
}
echo " <div id=\"module_";
echo $I;
echo "\" class=\"moduleContainer treeList\" style=\"";
echo $MENU['module_style'];
echo "\">";
include_once( $include_file );
echo "</div>\r\n";
}
else if ( $MENU['module'] != "" )
{
echo " <div id=\"module_";
echo $I;
echo "\" class=\"moduleContainer\" style=\"";
echo $MENU['module_style'];
echo "\">";
echo $MENU['module'];
echo "</div>\r\n";
}
}
echo "</ul>\r\n";
if ( $MENU_BOTTOM )
{
echo " <div id=\"MenuBottom\">";
echo $MENU_BOTTOM;
echo "</div>\r\n";
}
echo "</body>\r\n</html>\r\n";
?>

运维网声明 1、欢迎大家加入本站运维交流群:群②:261659950 群⑤:202807635 群⑦870801961 群⑧679858003
2、本站所有主题由该帖子作者发表，该帖子作者与运维网享有帖子相关版权
3、所有作品的著作权均归原作者享有，请您和我们一样尊重他人的著作权等合法权益。如果您对作品感到满意，请购买正版
4、禁止制作、复制、发布和传播具有反动、淫秽、色情、暴力、凶杀等内容的信息，一经发现立即删除。若您因此触犯法律，一切后果自负，我们对此不承担任何责任
5、所有资源均系网友上传或者通过网络收集，我们仅提供一个展示、介绍、观摩学习的平台，我们不对其内容的准确性、可靠性、正当性、安全性、合法性等负责，亦不承担任何法律责任
6、所有作品仅供您个人学习、研究或欣赏，不得用于商业或者其他用途，否则，一切后果均由您自己承担，我们对此不承担任何法律责任
7、如涉及侵犯版权等问题，请您及时通知我们，我们将立即采取措施予以解决
8、联系人Email：admin@iyunv.com 网址：www.yunweiku.com

所有资源均系网友上传或者通过网络收集,我们仅提供一个展示、介绍、观摩学习的平台,我们不对其承担任何法律责任,如涉及侵犯版权等问题,请您及时通知我们,我们将立即处理,联系人Email:kefu@iyunv.com,QQ:1061981298 本贴地址：https://www.yunweiku.com/thread-290165-1-1.html 上篇帖子： (转)MySQL数据库InnoDB存储引擎的磁盘空间利用率分析 下篇帖子： Mysql/SQLServer数据类型对应的JDBC类型java类型 表
回复

使用道具 举报

返回列表
高级模式
B Color Image Link Quote Code Smilies
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

扫码加入运维网微信交流群X

扫码加入运维网微信交流群

扫描二维码加入运维网微信交流群，最新一手资源尽在官方微信交流群！快快加入我们吧...

扫描微信二维码查看详情

客服 E-mail:iyunvcom@gmail.com

本站由青云提供云计算服务

运维网--中国最专业的运维工程师交流社区

豫ICP备20007574号-1 Copyright © 2012-2025

关于我们

发展历程

联系我们

关注我们

广告服务

广告案例

隐私条款

免责声明

用户登录

用户注册

版主守则

申请版主

手机版

金币获取

帮助中心

每日签到

Good Good

Study

Day Day

UP


客服E-mail:kefu@iyunv.com 客服QQ：1061981298


QQ群⑦：运维网交流群⑦ QQ群⑧：运维网交流群⑧ k8s群：运维网kubernetes交流群


提醒：禁止发布任何违反国家法律、法规的言论与图片等内容；本站内容均来自个人观点与网络等信息，非本站认同之观点.


本站大部分资源是网友从网上搜集分享而来，其版权均归原作者及其网站所有，我们尊重他人的合法权益，如有内容侵犯您的合法权益，请及时与我们联系进行核实删除！



合作伙伴: 青云cloud

快速回复 返回顶部 返回列表