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); 
   } 
     

TWE-Commerce

一个功能强大的B2B与B2C的购物平台，除了原本OSC功能外，增加更新的功能： 一、 取消了register_globals必须开启的限制 二、 將HTML程式碼与PHP程式碼完全分离，採用了smarty 樣板引擎 三、 每支档案includes所需函数与资料库连结，使的网页显示速度明显提升 四、 检视、购买商品群组权限设定 五、 十八岁以下禁购机制 六、 折价券购物抵扣机制 七、 礼券购物机制

0

查看详情