package com.slcf.dao;
|
|
import java.util.List;
|
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
import org.springframework.stereotype.Repository;
|
|
import com.slcf.pojo.MenuBean;
|
import com.slcf.pojo.UserBean;
|
|
@Repository
|
public interface LoginDao {
|
|
/**
|
* 根据用户id查找父级菜单
|
* @param id 登陆用户的id
|
* @return
|
*/
|
@Select("select m.menu_id,m.menu_name,m.parentID,m.icon,m.url from tb_menu m,"
|
+ "tb_role_menu rm,tb_role r,tb_user_role ur,tb_user u "
|
+ "WHERE m.menu_id=rm.menu_id and rm.role_id=r.role_id and "
|
+ "r.role_id=ur.role_id and ur.user_id =u.user_id and m.statu=0 and m.parentID=0 and u.user_id=#{id} ORDER BY m.menu_id")
|
public List<MenuBean> getParenMenuByUserId(int id);
|
|
/**
|
* 根据父级菜单id查找对应的子级菜单id
|
* @param pid
|
* @return
|
*/
|
@Select("select b.menu_id,b.menu_name,b.parentID,b.icon,b.url ,b.statu from ( "
|
+ "select m.menu_id ,m.menu_name,m.parentID,m.icon,m.url,m.statu from tb_menu m, "
|
+ "tb_role_menu rm,tb_role r,tb_user_role ur,tb_user u WHERE m.menu_id=rm.menu_id "
|
+ "and rm.role_id=r.role_id and r.role_id=ur.role_id and ur.user_id =u.user_id and "
|
+ "m.statu=0 and m.parentID!=0 and u.user_id=#{uid} )b WHERE b.statu=0 and b.parentID=#{pid} "
|
+ "ORDER BY b.menu_id")
|
public List<MenuBean> getChildMenuByPid(@Param("uid")int uid,@Param("pid")int pid);
|
|
/**
|
* 根据登陆账号查询用户信息
|
* @param name
|
* @return
|
*/
|
@Select("select * from tb_user u where u.user_account=#{name}")
|
public UserBean getInfoByAccount(String name);
|
|
/**
|
* 根据用户id，查询角色list
|
* @param id
|
* @return
|
*/
|
@Select("select role_id from tb_user_role where user_id=#{id}")
|
public List<String> getRolesByUserId(int id);
|
}
|
