Get permission List
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);
$m 1=array ();
while ($row = $this->fetch_assoc ($rs)) {
$m 1[]= $row;
}
$prive =array ();
foreach ($m 1 as $key = = $v) {
$priveId = $v [' id '];
$priveName = $v [' name '];
$prive [Strtoupper ($priveName)]=array ();
$sql 2= "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} ";
$rs 2= $this->query ($sql 2);
$m 2=array ();
while ($row 2= $this->fetch_assoc ($rs 2)) {
$m 2[]= $row 2;
}
Judging public module www.2cto.com
$Public =array ();
foreach ($m 2 as $key = = $m) {
$pId = $m [' id '];
$pName = $m [' name '];
if (' Public ' ==strtoupper ($m [' Name '])} {
$sql 3= "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} ";
$rs 3= $this->query ($sql 3);
$m 3=array ();
while ($row 3= $this->fetch_assoc ($rs 3)) {
$m 3[]= $row 3;
}
foreach ($m 3 as $val) {
$Public [$val [' Name ']]= $val [' id '];
}
Print_r ($m 2[$key]);
unset ($m 2[$key]);
Break
}
}
Print_r ($Public);
foreach ($m 2 as $key = = $m) {
$pId = $m [' id '];
$pName = $m [' name '];
$sql 4= "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} ";
$rs 4= $this->query ($sql 4);
$m 4=array ();
while ($row 4= $this->fetch_assoc ($rs 4)) {
$m 4[]= $row 4;
}
$action =array ();
foreach ($m 4 as $va) {
$action [$va [' Name ']]= $va [' id '];
}
$action + = $Public;
$prive [Strtoupper ($priveName)][strtoupper ($pName)] =array_change_key_case ($action, Case_upper);
}
}
Print_r ($prive);
}
Excerpt from chaojie2009 's column
http://www.bkjia.com/PHPjc/478387.html www.bkjia.com true http://www.bkjia.com/PHPjc/478387.html techarticle //Get permission list 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.us ...