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  and  t.sys_type='1'";
    String SysMenuSqlT1 = SysMenuSql + sysRoleMenuIdSql;


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


    String SysMenuSql_kzt = "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,p.parent_id as parentId," +
            " pp.NAME AS parentName," +
            " pp.url AS parentUrl  from sys_menu t  left join sys_menu pp ON t.parent_id = pp.id ";
    String sysRoleMenuIdSql_kzt = " 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  and  t.sys_type='${sysType}'";
    String SysMenuSqlT1_kzt = SysMenuSql + sysRoleMenuIdSql;

    @Select(SysMenuSqlT1_kzt)
    List<SysMenu> gainMenuIdsByUserId(@Param("userId") String userId, @Param("sysType") String sysType);
}