thinkphp Rights Management Control (RBAC)

1. Query which apps the current user can access

Select Node.id,node.name from Rice_role as role, rice_role_user as user,
Rice_access as access, rice_node as node where user.user_id=3 and
User.role_id=role.id and (Access.role_id=role.id or (Access.role_id=role.pid and role.pid!=0))

and Role.status=1 and Access.node_id=node.id and Node.level=1 and Node.status=1 GROUP by ID

2. Query which modules the current user can access

SELECT Node.id, Node.name
From Rice_role as role, rice_role_user as user, rice_access as access, rice_node as node
WHERE user.user_id =3
and user.role_id = Role.id
and (
access.role_id = Role.id
OR (
access.role_id = Role.pid
and Role.pid!=0))
and Role.status =1
and access.node_id = Node.id
and Node.level =2
and Node.pid =1
and Node.status =1 GROUP by ID

3. Query the corresponding method of the specific module

select node.id,node.name from
                     rice_role as role,
                     Rice_role_user as User ,
                     rice_access as Access,
                     Rice_node as Node
                     where user.user_id=3 and user.role_id=role.id and (access.role_id=role.id  or (Access.role_id=role.pid and role.pid!=0)) and Role.status=1 and Access.node_id=no De.id and Node.level=3 and node.pid={$moduleId} and node.status=1  GROUP by ID