You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

826 B

Raw Permalink Blame History

deleteRoleFunction

删除所有的功能的角色配置

delete from core_role_function where function_id in ( #join(ids)# )

getFunctionIdByRole

获得角色对应的功能id

select function_id from core_role_function where role_id=#roleId#

getFunctionIdByUser

获得角色对应的功能id

SELECT GROUP_CONCAT(CONCAT(FUNCTION_ID,',',(SELECT PARENT_ID FROM core_function WHERE ID = t.FUNCTION_ID))) function_ids FROM core_role_function t LEFT JOIN core_user_role a ON a.ROLE_ID = t.ROLE_ID WHERE a.user_id = #userId#

getQueryFunctionAndRoleData

获得所有查询功能，并查询角色对应的功能信息。

select f.*,r.data_access_type from core_role_function r left join core_function f on r.function_id=f.id where r.role_id=#roleId# and f.type='FN1'