java-insagent-pc/src/main/java/com/ydtech/modules/admin/dao/SysRoleMenuMapper.java

package com.ydtech.modules.admin.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ydtech.modules.admin.model.SysMenu;
import com.ydtech.modules.admin.model.SysRoleMenu;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

public interface SysRoleMenuMapper extends BaseMapper<SysRoleMenu> {

    String SysMenuSql = "select t.id, t.name, t.parent_id, t.url, t.perms, t.type, t.icon, t.order_num, t.create_by, t.create_time, t.last_update_by, t.last_update_time, t.del_flag from sys_menu t ";
    String sysRoleMenuIdSql = " where t.id in (select menu_id from sys_role_menu t1 left join sys_user_role t2 on t1.role_id=t2.role_id where t2.user_id='${userId}') and del_flag=0 ";
    String SysMenuSqlT1 = SysMenuSql + sysRoleMenuIdSql;


    /**
     * 获取菜单id集
     */
    @Select(SysMenuSqlT1)
    List<SysMenu> gainSysMenuIds(@Param("userId") String userId);

}