php 获取权限列表函数

//获取权限列表
public function getPriveList($id){
$sql="SELECT m.id, m.name
FROM jh_user AS u, jh_role AS r, jh_role_user AS ru, jh_prive AS p, jh_menu AS m
WHERE u.id = ru.user_id
AND ru.role_id = r.id
AND r.id = p.role_id
AND m.id = p.menu_id
AND m.status =1
AND m.level =1
AND u.id ={$id}";
$rs=$this->query($sql);
//$row=$this->fetch_assoc($rs);
$m1=array();
while ($row=$this->fetch_assoc($rs)){
$m1[]=$row;
}
$prive=array();
foreach ($m1 as $key=>$v){
$priveId=$v['id'];
$priveName=$v['name'];
$prive[strtoupper($priveName)]=array();
$sql2="SELECT m.id, m.name
FROM jh_user AS u, jh_role AS r, jh_role_user AS ru, jh_prive AS p, jh_menu AS m
WHERE u.id = ru.user_id
AND ru.role_id = r.id
AND r.id = p.role_id
AND m.id = p.menu_id
AND m.status =1
AND m.level =2
AND m.pid ={$priveId}
AND u.id ={$id}";
$rs2=$this->query($sql2);
$m2=array();
while ($row2=$this->fetch_assoc($rs2)){
$m2[]=$row2;
}
//判断公共模块 www.2cto.com
$Public=array();
foreach ($m2 as $key =>$m){
$pId=$m['id'];
$pName=$m['name'];
if('PUBLIC'==strtoupper($m['name'])){
$sql3="SELECT m.id, m.name
FROM jh_user AS u, jh_role AS r, jh_role_user AS ru, jh_prive AS p, jh_menu AS m
WHERE u.id = ru.user_id
AND ru.role_id = r.id
AND r.id = p.role_id
AND m.id = p.menu_id
AND m.status =1
AND m.level =3
AND m.pid ={$pId}
AND u.id ={$id}";
$rs3=$this->query($sql3);
$m3=array();
while ($row3=$this->fetch_assoc($rs3)){
$m3[]=$row3;
}
foreach ($m3 as $val){
$Public[$val['name']]=$val['id'];
}
//print_r( $m2[$key]);
unset($m2[$key]);
break;
}
}
// print_r($Public);

foreach ($m2 as $key =>$m){
$pId=$m['id'];
$pName=$m['name'];
$sql4="SELECT m.id, m.name
FROM jh_user AS u, jh_role AS r, jh_role_user AS ru, jh_prive AS p, jh_menu AS m
WHERE u.id = ru.user_id
AND ru.role_id = r.id
AND r.id = p.role_id
AND m.id = p.menu_id
AND m.status =1
AND m.level =3
AND m.pid ={$pId}
AND u.id ={$id}";
$rs4=$this->query($sql4);
$m4=array();
while ($row4=$this->fetch_assoc($rs4)){
$m4[]=$row4;
}
$action=array();
foreach ($m4 as $va){
$action[$va['name']]=$va['id'];
}
$action+=$Public;
$prive[strtoupper($priveName)][strtoupper($pName)] =array_change_key_case($action,CASE_UPPER);
}
}
print_r($prive);
}

摘自 chaojie2009的专栏