package com.cloud.user.dao; import com.cloud.model.sys.SysMenu; import com.cloud.model.sys.SysRoleMenu; import org.apache.ibatis.annotations.Mapper; import org.apache.ibatis.annotations.Param; import org.apache.ibatis.annotations.Select; import java.util.List; import java.util.Map; import java.util.Set; @Mapper public interface SysRoleMenuDao { int insert(SysRoleMenu record); int insertSelective(SysRoleMenu record); Set findPermissionsByRoleIds(@Param("roleIds") Set roleIds, @Param("orgId") Long orgId); Set findMenusByRoleIds(Map params); @Select("select * from sys_menu t where enabled = '0' and delFlag = '0'order by t.sort") List findAll(); @Select("select t.menuId from sys_role_menu t where t.roleId = #{roleId} and t.orgId = #{orgId}") Set findMenuIdsByRoleId(Map params); Integer save(SysMenu menu); Integer update(SysMenu menu); Integer delete(@Param("id") Long id, @Param("orgId") Long orgId); SysMenu findById(@Param("id") Long id, @Param("orgId") Long orgId); void deleteRolePermissionByParams(Map params); List> findMenuByUser(Map map); @Select("select t.menuId from sys_role_menu t where t.roleId in (\n" + "select roleId from sys_role_user where userId = #{userId} and orgId = #{orgId}) and t.orgId = #{orgId}") Set findMenuIdsByUserId(Map params); /** * 查询所有模块 * @param map * @return */ List> findAllMenuByUser(Map map); }