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.bean.MeetingCondition;
import com.slcf.pojo.ConsumerBean;
import com.slcf.pojo.GroupBean;
import com.slcf.pojo.MeetingBean;
import com.slcf.pojo.MeetingConsumerBean;

/**
 * 会议Dao映射层
 * @author Administrator
 * @date 2018年8月14日
 */
@Repository
public interface MeetingDao {
    /**
	 * 根据会议编号验证是否唯一
	 * @param meetingNo
	 * @return
	 */
	@Select("select * from tb_meeting where f_MeetingNo=#{meetingNo}")
	public MeetingBean getMeetingByNo(String meetingNo);
	
	/**
	 * 分页查询所有会议
	 * @param spage
	 * @param epage
	 * @return
	 */
//	@Select("select top (#{epage}) * from tb_meeting a,tb_meeting_room b where a.f_RoomId=b.f_RoomId and f_MeetingNo not in "
//			+ "(select top (#{spage}) f_MeetingNo from tb_meeting order by f_MeetingDateTime desc) order by f_MeetingDateTime desc")	
//	public List<MeetingBean> getMeetingList(@Param("spage")int spage,@Param("epage")int epage);
	public List<MeetingBean> getMeetingList(MeetingCondition meeting);
	
	/**
	 * 统计会议数量
	 * @return
	 */
//	@Select("select count(*) from tb_meeting")
//	public int getCount();
	public int getCount(MeetingCondition meeting);
	
	/**
	 * 添加会议
	 * @param meetingBean
	 * @return
	 */
	@Insert("insert into tb_meeting(f_MeetingNo,f_MeetingName,f_RoomId,f_MeetingDateTime, "
			+ " f_MeetingEndDate,f_SignStartTime,f_SignEndTime,f_Content,f_Notes) "
			+ " values(#{f_MeetingNo},#{f_MeetingName},#{f_RoomId}, "
			+ " CONVERT(datetime,#{f_MeetingDateTime},120), "
			+ " CONVERT(datetime,#{f_MeetingEndDate},120), "
			+ " CONVERT(datetime,#{f_SignStartTime},120), "
			+ " CONVERT(datetime,#{f_SignEndTime},120), "
			+ " #{f_Content},#{f_Notes})")
	public int saveMeeting(MeetingBean meetingBean);
	
	/**
	 * 根据No删除
	 * @param meetingNo
	 * @return
	 */
	@Delete("delete from tb_meeting where f_MeetingNo=#{meetingNo}")
	public int delMeetingByNo(String meetingNo);
	
	/**
	 * 根据会议编号查找
	 * @param meetingNo
	 * @return
	 */
	@Select("select * from tb_meeting where f_MeetingNo=#{meetingNo}")
	public MeetingBean quertMeetingByNo(String meetingNo);
	
	/**
	 * 更新会议
	 * @param meetingBean
	 * @return
	 */
	@Update("update tb_meeting set "			
			+ " f_MeetingName=#{f_MeetingName}, "
			+ " f_RoomId=#{f_RoomId}, "
			+ " f_MeetingDateTime=#{f_MeetingDateTime}, "
			+ " f_MeetingEndDate=#{f_MeetingEndDate}, "
			+ " f_SignStartTime=#{f_SignStartTime}, "
			+ " f_SignEndTime=#{f_SignEndTime}, "
			+ " f_Content=#{f_Content}, "
			+ " f_Notes=#{f_Notes} "
			+ " where f_MeetingNo=#{f_MeetingNo}")
	public int upMeeting(MeetingBean meetingBean);
	
	/**
	 * 检查会议时间是否占用
	 * @return
	 */
	@Select("select count(*) from tb_meeting "
			+ " where f_RoomId=#{f_RoomId} and ((#{f_SignStartTime}>f_SignStartTime and #{f_SignStartTime}<f_MeetingEndDate) "
			+ " or (#{f_MeetingEndDate}>f_SignStartTime and #{f_MeetingEndDate}<f_MeetingEndDate))")
	public int checkMeetingDate(MeetingBean meetingBean);
	
	/**
	 * 查询会议参会人员id
	 * @param rid
	 * @return
	 */
	@Select("select f_ConsumerID from tb_meeting_consumer where f_MeetingNO=#{rid}")
	public List<Integer> queryConsumerByNo(String rid);
	
	/**
	 * 查询所有部门
	 * @return
	 */
	@Select("select * from t_b_Group")
	public List<GroupBean> getGroupList();
	
	/**
	 * 查询部门下所有人员信息
	 * @return
	 */
	@Select("select * from t_b_Consumer where f_GroupID=#{Gid}")
	public List<ConsumerBean> queryConsumerByGid(Long Gid);
	
	/**
	 * 根据会议编号查询参会人员
	 * @param meetingNo
	 * @return
	 */
	@Select("select * from tb_meeting_consumer where f_MeetingNO=#{meetingNo}")
	public List<MeetingConsumerBean> queryMeetingConsumer(String meetingNo);
	
	/**
	 * 删除会议人员信息
	 * @param meetingNo
	 * @return
	 */
	@Delete("delete from tb_meeting_consumer where f_MeetingNO=#{meetingNo}")
	public int delMeetingConsumer(String meetingNo);
	
	/**
	 * 添加会议人员
	 * @param meetingNo
	 * @param mid
	 * @return
	 */
	@Insert("insert into tb_meeting_consumer(f_MeetingNO,f_ConsumerID) values(#{meetingNo},#{mid})")
	public int saveMeetingConsumer(@Param("meetingNo")String meetingNo,@Param("mid")int mid);
}