package com.doumee.dao.business;

import com.baomidou.mybatisplus.core.conditions.Wrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.baomidou.mybatisplus.core.toolkit.Constants;
import com.doumee.dao.business.model.Notice;
import com.doumee.dao.web.response.MeetingListResponse;
import com.doumee.dao.web.response.NoticeCardResponse;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * @author 江蹄蹄
 * @date 2023/05/04 18:18
 */
public interface NoticeMapper extends BaseMapper<Notice> {


    @Select(" select n.* from  (select * from notice a where a.type =  0  " +
            " union" +
            " select * from notice b  where b.type = 1  and b.MEMBER_ID = #{memberId} ) n  " +
            " order by n.CREATE_DATE desc ")
    IPage<NoticeCardResponse> noticePage(IPage<NoticeCardResponse> page, @Param("memberId") Integer memberId);


    @Select(" select * from notice a where ( a.MEMBER_ID = #{userId} or a.TYPE = 0 )   order by CREATE_DATE  desc   limit 1   ")
    NoticeCardResponse newNotice(@Param("userId") Integer userId);



    @Select(" select * from notice a where a.id = #{id}   ")
    NoticeCardResponse getNoticeDetail(@Param("id") Integer id);


}