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
	DISTINCT sm.*
FROM
	sys_menu sm, sys_user_role sur, sys_role_menu srm
WHERE
	sur.user_id = ?
	AND sur.role_id = srm.role_id
	AND srm.menu_id = sm.id
	AND sm.del_flag = '0'
ORDER BY
	sm.order_num;
`

var Selectall_nav_tree_admin = `
SELECT
	DISTINCT sm.*
FROM
	sys_menu sm
WHERE
	sm.del_flag = '0'
ORDER BY
	sm.order_num;
`