CRM项目数据库将用户与对应的操作权限链接起来实现权限限定------CRM项目

旧约Alatus

已于 2024-03-03 19:29:36 修改

阅读量397

点赞数

分类专栏： CRM项目数据库 # MySQL 文章标签： mysql sql 数据库后端 database mybatis 架构

于 2024-03-03 16:37:40 首次发布

本文链接：https://blog.csdn.net/2201_75960169/article/details/136433645

版权

CRM项目同时被 3 个专栏收录

142 篇文章 0 订阅

订阅专栏

数据库

62 篇文章 0 订阅

订阅专栏

MySQL

9 篇文章 0 订阅

订阅专栏

SELECT 
	*
 FROM 
	t_permission tp 
	LEFT JOIN t_role_permission trp 
	ON tp.`id` = trp.`permission_id`
	LEFT JOIN t_role tr 
	ON tr.`id` = trp.`role_id`
	LEFT JOIN t_user_role tur
	ON tur.`role_id` = tr.`id`
 WHERE 
	tp.type = 'menu' &&
	tur.`user_id` = 2
SELECT
   *
FROM
   t_permission tp
   LEFT JOIN t_role_permission trp
   ON tp.`id` = trp.`permission_id`
   LEFT JOIN t_role tr
   ON tr.`id` = trp.`role_id`
   LEFT JOIN t_user_role tur
   ON tur.`role_id` = tr.`id`
WHERE
   tp.type = 'menu' &&
   tur.`user_id` = 2

SELECT 
	tp.*,
	childTp.`id` cid,childTp.`name` cname,childTp.`url` curl,childTp.`icon` cicon	
 FROM 
	t_permission tp
	LEFT JOIN t_permission childTp
	ON tp.`id` = childTp.`parent_id`
	LEFT JOIN t_role_permission trp 
	ON tp.`id` = trp.`permission_id`
	LEFT JOIN t_role tr 
	ON tr.`id` = trp.`role_id`
	LEFT JOIN t_user_role tur
	ON tur.`role_id` = tr.`id`
 WHERE 
	tp.type = 'menu' &&
	tur.`user_id` = 2 &&
	childTp.`type` = 'menu'
SELECT
   tp.*,
   childTp.`id` cid,childTp.`name` cname,childTp.`url` curl,childTp.`icon` cicon
FROM
   t_permission tp
   LEFT JOIN t_permission childTp
   ON tp.`id` = childTp.`parent_id`
   LEFT JOIN t_role_permission trp
   ON tp.`id` = trp.`permission_id`
   LEFT JOIN t_role tr
   ON tr.`id` = trp.`role_id`
   LEFT JOIN t_user_role tur
   ON tur.`role_id` = tr.`id`
WHERE
   tp.type = 'menu' &&
   tur.`user_id` = 2 &&
   childTp.`type` = 'menu'