package com.hxzk.gps.mapper.User; import com.hxzk.gps.controller.User.Results.MenuList; import com.hxzk.gps.controller.User.Results.MenuListDtoAll; import com.hxzk.gps.entity.User.TbUser; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import org.apache.ibatis.annotations.Select; import java.util.List; /** *

* Mapper 接口 *

* * @author YuZhiTong * @since 2025-04-17 */ public interface TbUserMapper extends BaseMapper { /* * 用户所属导航菜单 * */ @Select("SELECT m.id,m.path,m.name,m.component,m.redirect,m.parent_id,m.meta from tb_user u join rolemenu r on r.`role_id` = u.`jueseid` join menu m on m.id = r.`menu_id` where u.username = #{username}") public List FindUserRoleList(String username); /* * 导航菜单信息 * */ @Select("SELECT DISTINCT m.id, m.name as label,meta, m.parent_id FROM menu m") public List FindUserRoleListAll(); }