动态节点树 多级分类 php jquery ajax json mysql 点击进入菜单

最新推荐文章于 2021-02-16 05:24:27 发布
最新推荐文章于 2021-02-16 05:24:27 发布
阅读量1.6k 收藏 2
点赞数
分类专栏： json 文章标签： json mysql jquery php ajax menu
版权声明：本文为博主原创文章，遵循 CC 4.0 BY-SA 版权协议，转载请附上原文出处链接和本声明。
本文链接：https://blog.csdn.net/ibmfahsion/article/details/7744877
版权

直接生成的调用动态节点树

<!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:;" οnclick="clickMenu('1');" 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<meta http-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 "\" οnclick=\"";
  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";
?>

ibmfashion
关注
  • 0
    点赞
  • 踩
  • 2
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
专栏目录
jstree 文件系统 web php 数据库
11-27
用jstree插件实现的web文件系统，php和javascript，包含数据库，可以保存和更新用户在front end的修改。
通达OA2015-缓存的使用
IT人生
11-27 2827
通达OA2015
json+jsp+jQuery小例子
12-16
json_jsp_jQuery 无刷新登录，客户端传出数据，传回json的值，解析成介绍对象
jQuery多级树形分类折叠菜单.zip
05-24
jQuery多级树形分类折叠菜单基于jquery-1.7.2.min.js制作，json树形菜单。
解决jQuery ajax动态新增节点无法触发点击事件的问题
12-29
解决jQuery ajax动态新增节点无法触发事件问题的两种解决方法，为了达到更好的演示效果，假设在某个页面的body下有以下结构的代码： <li class=demo1>a1 <li class=demo1>a2 <li class=demo1>a3</l
JQuery Ajax 异步操作之动态添加节点功能
10-19
异步操作动态添加节点，导致在代码中给添加的节点全局绑定事件或者获取元素无效，问题出在哪里呢？下文给大家介绍下，感兴趣的朋友参考下吧
jQuery Simple Tree Ajax无限级树形菜单插件php版
10-22
jQuery Simple Tree Ajax无限级树形菜单插件php版 兼容性非常好，可异步加载，支持拖拽。插件本身只支持HTML节点加载的，网上有人进行扩展了，用了JSON，不过个人感觉这对速度影响实在微乎其微，还是直接封装出HTML...
jquery和json加PHP实现的二级联动
12-26
jquery和json加PHP实现的二级联动
php+jquery+json级联菜单
liuzp111的专栏
09-10 1260
If, for some reason you need to force a single object to be an array, you can use array_values() -- this can be necessary if you have an array with only one entry, as json_encode will assign it as an
jsTree与PHP+MYSQL联动
02-28
1.更改配置文件config.php，配置mysql密码和端口等信息 2.新建数据库，导入sql文件 3.执行就行了
php 通用tree (树形)
热门推荐
chaojie2009的专栏
04-20 1万+
<?php /** * @author [email protected] * @date 2012-04-14 * @des 通用树形 * */ class Tree{ /** * 生成树型结构所需要的2维数组 * @var array */ public $arr = array(); /** * 生成树型结构所需修饰符号，可以换成图片 * @va
jsTree 通过ajax 获取json数据 加载树形菜单
qq_42717786的博客
08-15 2749
var ajaxTreeSample = function() { $("#tree_4").jstree({ "core" : { "themes" : { "responsive": false }, // so ...
php从数据库读取菜单数据并树状显示
AlvinHu
04-04 3195
数据库表结构 mcp_node表; 字段(node_code, node_name,node_pcode); node_code为区域编码,node_name为区域名称,node_pcode为父区域编码 ,祖先父区域编码为0. 预期效果: 代码实现部分: //按照区域字段查询属于该区域管辖的所有节点 //$area_field 系统管理所属区域
Jquery+ztree+json+webservice+mysql制作树形菜单+ajax列表页面
求知若饥,虚心若愚
07-19 1647
Jquery+ztree+json+webservice+mysql制作树形菜单+ajax列表页面  aspx文件： http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">http://www.w3.org/1999/x
【转载】无限级分类的简单实例
diandu3502的博客
06-29 97
转载来源：http://www.yiichina.com/tutorial/470 //模拟一个分类数组 $area = array( array('id'=>1,'name'=>'安徽','parent'=>0), array('id'=>2,'name'=>'海淀','parent'=>7), array('id'=&g...
php无限分类 树状菜单经典代码
dengfei00100的专栏
12-29 4316
<?php header("content-type:text/html;charset=utf-8"); $conn = mysql_connect('127.0.0.1', 'root', ''); $s = mysql_select_db("local_df", $conn); mysql_query("set names utf8"); $sq
java json 取节点路径_php获取json数据所有的节点路径
weixin_33599503的博客
02-16 255
function iterTree($data) {$retData = array();$data = json_decode($data, true);if (!is_array($data) && empty($data)) {echo 'error !' ."n";} else {$queue = array();foreach ($data as $field =>...
jquery移除json节点
最新发布
07-12
要使用 jQuery 移除 JSON 节点，你需要先将 JSON 字符串解析成 JavaScript 对象，然后使用 jQuery 的方法来操作对象，最后将对象转换回 JSON 字符串。 以下是一个示例代码，演示如何使用 jQuery 移除 JSON 对象中的...

“相关推荐”对你有帮助么？

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

个

红包个数最小为10个

元

红包金额最低5元

当前余额3.43元 前往充值 >
需支付：10.00元
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付元
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。

余额充值