package org.jeecg.modules.system.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.jeecg.modules.system.entity.SysAnnouncementSend;
import org.jeecg.modules.system.model.AnnouncementSendModel;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.extension.plugins.pagination.Page;

/**
 * @Description: 用户通告阅读标记表
 * @Author: jeecg-boot
 * @Date:  2019-02-21
 * @Version: V1.0
 */
public interface SysAnnouncementSendMapper extends BaseMapper<SysAnnouncementSend> {

	/**
	 * 获取我的消息
	 * @param announcementSendModel
	 * @param page
	 * @return
	 */
	public List<AnnouncementSendModel> getMyAnnouncementSendList(Page<AnnouncementSendModel> page,@Param("announcementSendModel") AnnouncementSendModel announcementSendModel);

	/**
	 * 获取一条记录
	 * @param sendId
	 * @return
	 */
	AnnouncementSendModel getOne(@Param("sendId") String sendId);


	/**
	 * 修改为已读消息
	 */
	void updateReaded(@Param("userId") String userId, @Param("annoceIdList") List<String> annoceIdList);

	/**
	 * 清除所有未读消息
	 * @param userId
	 */
	void clearAllUnReadMessage(@Param("userId") String userId);

    /**
     * 根据用户id和通告阅读表的id获取当前用户已阅读的数量
     * 
     * @param id
     * @param userId
     */
    @Select("select count(1) from sys_announcement_send where id=#{id} and user_id = #{userId} and read_flag = 1")
    long getReadCountByUserId(@Param("id") String id, @Param("userId") String userId);

    /**
     * 根据用户id和阅读表的id获取所有阅读的数据
     * 
     * @param ids
     * @param userId
     * @return
     */
    List<String> getReadAnnSendByUserId(@Param("ids") List<String> ids, @Param("userId") String userId);

	/**
	 * 根据业务id、业务类型和用户id获取未读消息
	 * @param busId
	 * @param busType
	 * @param userId
	 * @return
	 */
	List<String> getUnReadAnnByBusAndUserId(@Param("busId")String busId, @Param("busType")String busType, @Param("userId")String userId);
}