app多角色菜单权限合并

guoshilong

2023-06-13 86dff1d678838a157c1cf67cdd9381e40d7af96e

app多角色菜单权限合并

 skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/MenuMapper.java

@@ -183,7 +183,7 @@
     */
    List<MenuDTO> authRoutes(List<Long> roleIds);

    List<MenuVO> selectAppMenu(@Param("roleId") String roleId);
    List<MenuVO> selectAppMenu(@Param("ids") String[] ids);

    WebMenuVO selectWebTopMenu();


 skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/mapper/MenuMapper.xml

@@ -483,14 +483,16 @@
    </select>

    <select id="selectAppMenu" resultType="cn.gistack.system.vo.MenuVO">
        SELECT MENU.* FROM BLADE_MENU MENU
        SELECT DISTINCT MENU.* FROM BLADE_MENU MENU
        LEFT JOIN BLADE_MENU TOPMENU ON TOPMENU.ID = MENU.PARENT_ID
        LEFT JOIN BLADE_ROLE_MENU BRM ON BRM.MENU_ID = MENU.ID
        WHERE TOPMENU.NAME='app'
        AND BRM.ROLE_ID = #{roleId}
        AND BRM.ROLE_ID IN
        <foreach collection="ids" index="index" item="item" open="(" separator="," close=")">
            #{item}
        </foreach>
        AND MENU.IS_DELETED = 0
                ORDER BY MENU.SORT ASC

        ORDER BY MENU.SORT ASC
    </select>

    <resultMap id="webMenu" type="cn.gistack.system.vo.WebMenuVO">

 skjcmanager/skjcmanager-service/skjcmanager-system/src/main/java/cn/gistack/system/service/impl/MenuServiceImpl.java

@@ -308,7 +308,8 @@

    @Override
    public List<MenuVO> getAppMenu(String roleId) {
        return baseMapper.selectAppMenu(roleId);
        String[] ids = roleId.split(",");
        return baseMapper.selectAppMenu(ids);
    }

    @Override