package com.gxx.manage.base.dao;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import com.gxx.manage.base.vo.Permission;
import com.gxx.manage.base.vo.Role;
import com.gxx.manage.base.vo.User;

@Repository
public interface UserMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(User record);

    int insertSelective(User record);

    User selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(User record);

    int updateByPrimaryKey(User record);

    /**
     * 根据姓名查用户
     * @param name
     * @return
     */
    User getUserByName(String name);
    
    /**
     * 根据用户ID查询角色集合
     * @param userId
     * @return
     */
    @Select("SELECT * FROM ROLE WHERE ID IN(SELECT ROLE_ID FROM USER_ROLE WHERE USER_ID=#{userId})")
    List<Role> queryRolesByUserId(@Param("userId")int userId);
    
    /**
     * 根据角色ID查询权限集合
     * @param roleId
     * @return
     */
    @Select("SELECT * FROM PERMISSION WHERE ID IN(SELECT PERMISSION_ID FROM ROLE_PERMISSION WHERE ROLE_ID=#{roleId})")
    List<Permission> queryPermissionsByRoleId(@Param("roleId")int roleId);
}