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;
|
|
/**
|
* <p>
|
* Mapper 接口
|
* </p>
|
*
|
* @author YuZhiTong
|
* @since 2025-04-17
|
*/
|
public interface TbUserMapper extends BaseMapper<TbUser> {
|
/*
|
* 用户所属导航菜单
|
* */
|
@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<MenuList> FindUserRoleList(String username);
|
|
/*
|
* 导航菜单信息
|
* */
|
@Select("SELECT DISTINCT m.id, m.name as label,meta, m.parent_id FROM menu m")
|
public List<MenuListDtoAll> FindUserRoleListAll();
|
}
|
