light-apiengine-feature/models/Sql_SysMenu.go

package models

var SqlSelectRoleMenuByUserId = `
SELECT 
	sys_menu.*
FROM
	sys_user
LEFT JOIN
	sys_user_role
ON
	sys_user.id = sys_user_role.user_id
LEFT JOIN
	sys_role_menu
ON
	sys_user_role.role_id = sys_role_menu.role_id
LEFT JOIN
	sys_menu
ON
	sys_menu.id = sys_role_menu.menu_id
WHERE
	sys_user.id = ?
`

//获取角色菜单
var SqlFindRoleMenu = `
SELECT sys_menu.*
FROM sys_role
LEFT JOIN
	sys_role_menu
ON
	sys_role.id = sys_role_menu.role_id
LEFT JOIN
	sys_menu
ON
	sys_menu.id = sys_role_menu.menu_id
WHERE
	sys_role.id = ?
`

var SqlFindUserPermissions = `
SELECT 
	sys_menu.perms
FROM
	sys_user
LEFT JOIN
	sys_user_role
ON
	sys_user.id = sys_user_role.user_id
LEFT JOIN
	sys_role_menu
ON
	sys_user_role.role_id = sys_role_menu.role_id
LEFT JOIN
	sys_menu
ON
	sys_menu.id = sys_role_menu.menu_id
WHERE
	sys_user.id = ?
	and sys_menu.type = 2
`

//查找导航栏
var Selectall_nav_tree = `
SELECT sys_menu.*
FROM
	sys_user
LEFT JOIN
	sys_user_role
ON
	sys_user.id = sys_user_role.user_id
LEFT JOIN
	sys_role_menu
ON
	sys_user_role.role_id = sys_role_menu.role_id
LEFT JOIN
	sys_menu
ON
	sys_menu.id = sys_role_menu.menu_id
WHERE
	sys_user.id = ?
	AND	sys_menu.type != 2 
	GROUP BY sys_menu.id
	ORDER BY sys_menu.order_num asc
`