Heim > Backend-Entwicklung > PHP-Tutorial > php 获取权限列表函数_PHP教程

php 获取权限列表函数_PHP教程

WBOY
Freigeben: 2016-07-13 17:49:00
Original
826 Leute haben es durchsucht

//获取权限列表 
   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的专栏

www.bkjia.comtruehttp://www.bkjia.com/PHPjc/478387.htmlTechArticle//获取权限列表 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...
Verwandte Etiketten:
Quelle:php.cn
Erklärung dieser Website
Der Inhalt dieses Artikels wird freiwillig von Internetnutzern beigesteuert und das Urheberrecht liegt beim ursprünglichen Autor. Diese Website übernimmt keine entsprechende rechtliche Verantwortung. Wenn Sie Inhalte finden, bei denen der Verdacht eines Plagiats oder einer Rechtsverletzung besteht, wenden Sie sich bitte an admin@php.cn
Beliebte Tutorials
Mehr>
Neueste Downloads
Mehr>
Web-Effekte
Quellcode der Website
Website-Materialien
Frontend-Vorlage