一个树形菜单的好类

最新推荐文章于 2024-09-09 15:53:30 发布

qwerwrqwe

最新推荐文章于 2024-09-09 15:53:30 发布

阅读量202

点赞数

分类专栏：前端开发

前端开发专栏收录该内容

2 篇文章 0 订阅

订阅专栏

本文介绍了一种使用PHP从数据库中获取数据并构建复杂的树形菜单系统的实现方法。通过联合查询结合多个表中的信息，并利用递归函数生成HTML结构，最终实现了动态展示组织结构的功能。此外，还介绍了如何使用jQuery Treeview插件来增强用户体验。

摘要由CSDN通过智能技术生成

转载：http://blog.csdn.net/super_ufo/article/details/4554149

表结构

CREATE TABLE IF NOT EXISTS `treenode` (
`node_id` int(11) NOT NULL auto_increment,
`node_path` varchar(255) NOT NULL default '',
`node_depth` int(11) NOT NULL default '0',
`node_order` int(11) NOT NULL default '0',
`node_title` varchar(255) NOT NULL default '',
`node_type` tinyint(4) NOT NULL default '0',
`node_has_childs` tinyint(4) NOT NULL default '0',
PRIMARY KEY (`node_id`),
KEY `node_id` (`node_id`),
KEY `node_path` (`node_path`),
KEY `node_depth` (`node_depth`),
KEY `node_order` (`node_order`),
KEY `node_title` (`node_title`),
KEY `node_has_childs` (`node_has_childs`)
) TYPE=MyISAM;

CREATE TABLE   IF NOT EXISTS `team` (
   `team_id`      int(11) NOT NULL ,
`team_name` varchar(255) NOT NULL default '',
`team_des`     int(11) NOT NULL default '0',
    PRIMARY KEY (`team_id`),
    KEY `team_name` (`team_name`)
) TYPE=MyISAM;

CREATE TABLE   IF NOT EXISTS `contacts` (
`contacts_id` int(11) NOT NULL ,
`contacts_name` varchar(255) NOT NULL default '',
`contacts_des` varchar(255) NOT NULL default '',
`contacts_company` varchar(255) NOT NULL default '',
`contacts_address` varchar(255) NOT NULL default '',
`contacts_profession` varchar(255) NOT NULL default '',
`contacts_offphone` int(16)   NULL ,
`contacts_mobile` int(12)   NULL ,
`contacts_homephone` int(16) NULL ,
`contacts_age` int(3) NULL ,
`contacts_sex` varchar(2) NOT NULL default '' ,
`contacts_fax` int(16) NULL ,
`contacts_group` varchar(255) NOT NULL default '',
PRIMARY KEY (`contacts_id`),
KEY `contacts_name` (`contacts_name`),
KEY `contacts_group` (`contacts_group`),
KEY `contacts_company` (`contacts_company`),
KEY `contacts_profession` (`contacts_profession`)
) TYPE=MyISAM;

$sqlmenu = "select * from ( (select node_id ,node_path ,node_depth ,node_order ,node_title ,node_type,node_has_childs, b.parent as parent from treenode as a ,team as b where a.node_id=b.team_id order by a.node_path asc) union (select node_id ,node_path ,node_depth ,node_order ,node_title ,node_type,node_has_childs,c.contacts_group as parent from treenode as a ,contacts as c where a.node_id=c.contacts_id order by a.node_path asc) ) as d order by d.node_depth,node_id asc ";
本语句查询结果：

+---------+-----------+------------+------------+------------+-----------+-----------------+--------+
| node_id | node_path | node_depth | node_order | node_title | node_type | node_has_childs | parent |
+---------+-----------+------------+------------+------------+-----------+-----------------+--------+
|       1 | x         |          1 |          0 | 开发部 |         0 |              16 | 0      |
|       2 | x         |          1 |          1 | 销售部 |         0 |               0 | 0      |
|       3 | x         |          1 |          1 | 生产部 |         0 |               3 | 0      |
|     226 | x         |          1 |          0 | 人事部 |         0 |               1 | 0      |
|       5 | x.3       |          2 |          2 | 生产部2 |         0 |              11 | 3      |
|       6 | x.3       |          2 |          3 | 生产部3 |         0 |               3 | 3      |
|     190 | x.3       |          2 |          0 | liuniuyou |         1 |               0 | 3      |
|     195 | x.1       |          2 |          0 | 开发部0 |         0 |               1 | 1      |
|     220 | x.3       |          2 |          0 | hello      |         1 |               0 | 3      |
|     227 | x.226     |          2 |          0 | kugoo      |         1 |               0 | 226    |
|     193 | x.3.5     |          3 |          0 | 22         |         1 |               0 | 5      |
|     228 | x.3.6     |          3 |          0 | 22         |         1 |               0 | 6      |
|     229 | x.1.195   |          3 |          0 | 1          |         1 |               0 | 195    |

<?php

/************************************************************************************
*加载菜单
************************************************************************************/
$sqlmenu = "select * from ( (select node_id ,node_path ,node_depth ,node_order ,node_title ,node_type,node_has_childs, b.parent as parent from treenode as a ,team as b where a.node_id=b.team_id order by a.node_path asc) union (select node_id ,node_path ,node_depth ,node_order ,node_title ,node_type,node_has_childs,c.contacts_group as parent from treenode as a ,contacts as c where a.node_id=c.contacts_id order by a.node_path asc) ) as d order by d.node_depth,node_id asc ";
$nodes = $pDB->FetchTable($sqlmenu,true);

foreach ($nodes as $key=>$value){
if($value['parent']==0)
  $menu_node['x']["$value[node_id]"] = array('title' => $value['node_title'],'type'=>$value['node_type']);
else{
   $level = explode('.',$value['node_path']);
   $key_str= '$menu_node[/'x/']';
   for($i=1; $i<count($level); $i++){
              $key_str.= "['".$level[$i]."']";
   }
      $key_str.= "['".$value['node_id']."']";
      $eval_str= $key_str. "['title'] ='".$value['node_title']."';". $key_str. "['type'] ='".$value['node_type']."';";
   eval ($eval_str);
}
}

$menu = creat_htmlul_tree($menu_node['x']);

$smarty->assign("menu", $menu);

#递归得到树形菜单结构

function creat_htmlul_tree($aNodes) {
  static $sTreeContent = "<ul id='browser2' class='filetree treeview-famfamfam'>";
#echo "<pre>"; ;print_r($aNodes); echo "</pre>";
  foreach( $aNodes as $k=>$v ) {
   if(count($v) > 2 && $k!='title' && $k!='type') {
    if($v['type']==0)
     $sTreeContent .= "<li><span class='folder'><a href='?menu=phonecontact&nodetype=".$v['type']."&prekey=".$k."'>".$v['title']."</a></span><ul>";
    else
     $sTreeContent .= "<li><span class='file'><a href='?menu=phonecontact&nodetype=".$v['type']."&prekey=".$k."'>".$v['title']."</a></span><ul>";

    creat_htmlul_tree($v);
    $sTreeContent .= '</li>';
   } else {
                if($k!='title' && $k!='type'){
     if($v['type']==0)
      $sTreeContent .= "<li><span class='folder'><a href='?menu=phonecontact&nodetype=".$v['type']."&prekey=".$k."'>".$v['title']."</a></span></li>";
     else
      $sTreeContent .= "<li><span class='file'><a href='?menu=phonecontact&nodetype=".$v['type']."&prekey=".$k."'>".$v['title']."</a></span></li>";
    }
   }
  }

         $sTreeContent.="</ul>";
  #echo htmlentities($sTreeContent);
  return $sTreeContent;
}

tpl 页面

{literal}
<script type="text/javascript">
$(document).ready(function(){
$("#browser1").treeview({
  collapsed: false,
  unique: true,
  persist: "cookie",
  cookieId: "navigationtree1"
});

$("#browser2").treeview({
  persist: "cookie",
  collapsed: true,
  unique: false,
  cookieId: "navigationtree2"
});
$("#browser3").treeview({
  persist: "location",
  collapsed: true,
  unique: true
});
$("#browser4").treeview({
  persist: "location",
  collapsed: true,
  unique: true
});
$("#browser5").treeview({
     animated: "slow",
  persist: "location",
  collapsed: true,//是否都折叠
  unique: true//同一层次只允许展开一个
});
});
</script>
{/literal}