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();
}