三级数组查询

三级数组查询

三级数组查询

$data = db::name('AuthRule')->select();
$data = list_to_tree2($data,'id','pid');//aaa($data);
// halt($data);
$this->assign("nodeList", $data);
return $this->fetch();

 

/**
 * 把返回的数据集转换成Tree
 * @access public
 * @param array $list 要转换的数据集
 * @param string $pid parent标记字段
 * @param string $level level标记字段
 * @return array
 */
function list_to_tree2($list, $pk='id',$pid = 'pid',$child = '_child',$root=0) {
    // 创建Tree
    $tree = array();
    if(is_array($list)) {
        // 创建基于主键的数组引用
        $refer = array();
        foreach ($list as $key => $data) {
            $refer[$data[$pk]] =& $list[$key];//取出每个栏目id作为键名,
        }
        foreach ($list as $key => $data) {//开始循环,key从0开始一个一个往下走0123.。。
            // 判断是否存在parent
            $parentId = $data[$pid];//echo $parentId.'|';//0|112|116|117|112输出每个数组里的pid
            if ($root == $parentId) {//key从0开始循环,如果是一级栏目pid==0
                $tree[] =& $list[$key]; //用连接符,吧数组放到tree里面
            }else{
            //如果pid不是0,那就是二级栏目
                if (isset($refer[$parentId])) {
                    $parent =& $refer[$parentId];//用pid去refer数组,匹配出父栏目数组,用连接符拼接到这里
                    $parent[$child][] =& $list[$key];aaa($parent);//将当前二级栏目放到父栏目下,拼接成二维数组
                }
            //仔细看list数组数据格式,第一遍key是0开始循环走的是tree哪里,
            //第二遍从1开始走,走到parent这里,
            }
        }
    }
    return $tree;
}

打印出的数据格式:

 

 

$list = Array
(
    [0] => Array
        (
            [id] => 112
            [name] => /Admin
            [title] => 后台
            [type] => 1
            [node_icon] => 
            [class_icon] => 
            [status] => 1
            [condition] => 
            [sort] => 0
            [pid] => 0
            [level] => 1
            [update_time] => 1532081114
            [create_time] => 1510821470
            [is_display] => 1
        )

    [1] => Array
        (
            [id] => 117
            [name] => /Admin/Index/index
            [title] => 后台首页
            [type] => 1
            [node_icon] => 
            [class_icon] => 
            [status] => 1
            [condition] => 
            [sort] => 0
            [pid] => 116
            [level] => 3
            [update_time] => 1510821714
            [create_time] => 1510821714
            [is_display] => 1
        )
}

$refer = Array
(
    [112] => Array
        (
            [id] => 112
            [name] => /Admin
            [title] => 后台
            [type] => 1
            [node_icon] => 
            [class_icon] => 
            [status] => 1
            [condition] => 
            [sort] => 0
            [pid] => 0
            [level] => 1
            [update_time] => 1532081114
            [create_time] => 1510821470
            [is_display] => 1
        )

    [117] => Array
        (
            [id] => 117
            [name] => /Admin/Index/index
            [title] => 后台首页
            [type] => 1
            [node_icon] => 
            [class_icon] => 
            [status] => 1
            [condition] => 
            [sort] => 0
            [pid] => 116
            [level] => 3
            [update_time] => 1510821714
            [create_time] => 1510821714
            [is_display] => 1
        )
)

$tree = Array
(
    [0] => Array
        (
            [id] => 112
            [name] => /Admin
            [title] => 后台
            [type] => 1
            [node_icon] => 
            [class_icon] => 
            [status] => 1
            [condition] => 
            [sort] => 0
            [pid] => 0
            [level] => 1
            [update_time] => 1532081114
            [create_time] => 1510821470
            [is_display] => 1
        )

)


$parent = Array
(
    [id] => 116
    [name] => /Admin/Index
    [title] => 首页
    [type] => 1
    [node_icon] => 
    [class_icon] => 
    [status] => 1
    [condition] => 
    [sort] => 1
    [pid] => 112
    [level] => 2
    [update_time] => 1510821685
    [create_time] => 1510821685
    [is_display] => 1
    [is_status] => 1
    [_child] => Array
        (
            [0] => Array
                (
                    [id] => 117
                    [name] => /Admin/Index/index
                    [title] => 后台首页
                    [type] => 1
                    [node_icon] => 
                    [class_icon] => 
                    [status] => 1
                    [condition] => 
                    [sort] => 0
                    [pid] => 116
                    [level] => 3
                    [update_time] => 1510821714
                    [create_time] => 1510821714
                    [is_display] => 1
                    [is_status] => 1
                )

        )

)

  

 页面:

<dt>管理权限</dt>
<dd>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="tab rules-data" data-rules="{present name ="$info['rules']"}{$info['rules']}{/present}">
{foreach name="nodeList" item="level1"}
<tr>
    <td style="font-size: 14px;"><label><input name="rules[]" level="1" type="checkbox" obj="node_{$level1.id}" value="{$level1.id}" data="{$level1.id}:1:0" data-id="{$level1.id}" data-pid="0"/> <b class="mac-size">[项目]</b> {$level1.title}</label></td>
</tr>
{present name="level1['_child']"}
{foreach name="level1['_child']" item="level2" }                         
    <tr>
        <td style="padding-left:60px; font-size: 14px;"><label><input name="rules[]" level="2" type="checkbox" obj="node_{$level1.id}_{$level2.id}" value="{$level2.id}"  data="{$level2.id}:2:{$level2.pid}" data-id="{$level2.id}" data-pid="{$level2.pid}"/> <b class="mac-size">[模块]</b> {$level2.title}</label></td>
    </tr>
	{present  name="$level2['_child']"}
	    {volist name="level2['_child']" id="level3"} 
	    <tr ><td style="padding-left: 120px;">
	    	<label><input name="rules[]" level="3" type="checkbox" obj="node_{$level1.id}_{$level2.id}_{$level3.id}" value="{$level3.id}" data="{$level3.id}:3:{$level3.pid}" data-id="{$level3.id}" data-pid="{$level3.pid}"/>  <b class="mac-size">[操作]</b>{$level3.title}</label>
	    </td></tr>
             {present  name="$level3['_child']"} 
           	<tr>
    		  <td style="padding-left: 160px;">
           	    {foreach name="level3['_child']" item="level4" key="k" }
           	    {if condition="$level4.is_display eq 1"}|   {/if}
					<label>
						<input name="rules[]" level="4" type="checkbox" obj="node_{$level1.id}_{$level2.id}_{$level3.id}_{$level4.id}" value="{$level4.id}" data="{$level4.id}:4:{$level4.pid}" data-id="{$level4.id}" data-pid="{$level4.pid}"/> {$level4.title}    
					</label> 
           	    {/foreach}
           	  </td>
			</tr> 
           {/present}
        {/volist} 
   {/present}
{/foreach}
{/present}
{/foreach}

  三级数组查询

上一篇:可爱博客园皮肤美化样式


下一篇:图标Icon(Icon)