package com.slcf.dao;

import java.util.List;

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

import com.slcf.pojo.MenuBean;
import com.slcf.pojo.RoleBean;
import com.slcf.pojo.RoleMenu;

@Repository
public interface RoleDao {

	/**
	 * 根据角色名称查询
	 * @param name
	 * @return
	 */
	@Select("select * from tb_role where role_name =#{name}")
	public RoleBean queryRoleByName(String name);
	
	/**
	 * 查询所有
	 * @return
	 */
	@Select("select * from tb_role order by role_id")
	public List<RoleBean> getRoleList();
	
	/**
	 * 分页查询
	 * @param spage
	 * @param epage
	 * @return
	 */
//	@Select("select * from tb_role r  order by r.role_id desc limit #{spage},#{epage}")
	@Select("select top (#{epage}) * from tb_role where role_id not in "
			+ "(select top (#{spage}) role_id from tb_role order by role_id desc) order by role_id desc")
	public List<RoleBean> getRoleListByPage(@Param("spage")int spage,@Param("epage")int epage);
	
	/**
	 * 统计数量
	 * @return
	 */
	@Select("select count(*) from tb_role")
	public int getCount();
	
	/**
	 * 添加角色操作表
	 * @param name
	 * @param type
	 * @param rid
	 * @return
	 */
	@Insert("insert into tb_role_opt(r_id,ropt_name,ropt_type,ropt_time) values(#{rid},#{name},#{type},getdate())")
	public int saveRoleOpt(@Param("name")String name,@Param("type")String type,@Param("rid")int rid);
	
	/**
	 * 添加角色表
	 * @param role
	 * @return
	 */
	@Insert("insert into tb_role(role_name,role_desc,pid) values(#{role_name},#{role_desc},#{pid})")
	public int saveRole(RoleBean role);
	
	/**
	 * 删除角色操作记录表
	 * @param rid
	 * @return
	 */
	@Delete("delete from tb_role_opt where r_id=#{rid}")
	public int delRoleOpt(int rid);
	
	/**
	 * 删除角色表
	 * @param rid
	 * @return
	 */
	@Delete("delete from tb_role where role_id=#{rid}")
	public int delRole(int rid);
	
	/**
	 * 根据id查找
	 * @param rid
	 * @return
	 */
	@Select("select * from tb_role where role_id=#{rid}")
	public RoleBean queryRoleById(int rid);
	
	/**
	 * 跟新角色
	 * @param role
	 * @return
	 */
	@Update("update tb_role set role_name=#{role_name},role_desc=#{role_desc},pid=#{pid} where role_id=#{role_id}")
	public int upRole(RoleBean role);
	
	/**
	 * 查询所有启用父级菜单
	 * @return
	 */
	@Select("select * from tb_menu where parentID=0 and statu='0' ORDER BY menu_id")
	public List<MenuBean> getParentMenuList();
	
	/**
	 * 查询父级菜单下的所有启用子菜单
	 * @param pid
	 * @return
	 */
	@Select("select * from tb_menu where parentID=#{pid} and statu='0' ORDER BY menu_id")
	public List<MenuBean> queryChildMenuByPid(int pid);
	
	/**
	 * 根据角色id查询此角色用有的菜单权限
	 * @param rid
	 * @return
	 */
	@Select("select menu_id from tb_role_menu  where role_id=#{rid} ")
	public List<Integer> queryMenuByRoleId(int rid);
	
	/**
	 * 添加角色菜单表
	 * @param rid
	 * @param mid
	 * @return
	 */
	@Insert("insert into tb_role_menu (menu_id,role_id,auth_code) values(#{mid},#{rid},#{auth_code})")
	public int saveRoleMenu(@Param("rid")int rid,@Param("mid")int mid,@Param("auth_code")String auth_code);
	
	/**
	 * 删除角色菜单表
	 * @param rid
	 * @return
	 */
	@Delete("delete from tb_role_menu where role_id=#{rid}")
	public int delRoleMenu(int rid);
	
	/**
	 * 根据角色id查询
	 * @param rid
	 * @return
	 */
	@Select("select * from tb_role_menu where role_id=#{rid}")
	public List<RoleMenu> queryRoleMenu(int rid);
	
	/**
	 * 根据角色id、菜单id查询用户按钮权限
	 * @param rid
	 * @return
	 */
	@Select("select auth_code from tb_role_menu  where role_id=#{rid} and menu_id=#{menu_id}")
	public String queryAuthStrsByRoleMenu(@Param("rid")int rid, @Param("menu_id")int menu_id);
}