package com.panzhihua.service_user.dao;
|
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Select;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.panzhihua.common.model.vos.user.NoticeUnReadVO;
|
import com.panzhihua.service_user.model.dos.SysUserNoticeDO;
|
|
/**
|
* @program: springcloud_k8s_panzhihuazhihuishequ
|
* @description: 通知
|
* @author: huang.hongfa weixin hhf9596 qq 959656820
|
* @create: 2021-01-04 17:24
|
**/
|
@Mapper
|
public interface SysUserNoticeDAO extends BaseMapper<SysUserNoticeDO> {
|
|
@Select("SELECT \n" + "COUNT(case WHEN type=1 then id else null end )activityUnread,\n"
|
+ "COUNT(case WHEN type=2 then id else null end )serviceUnread,\n"
|
+ "COUNT(case WHEN type=3 then id else null end )systemUnread,\n"
|
+ "COUNT(case WHEN type=4 then id else null end )scoreUnread\n" + "FROM\n" + "sys_user_notice \n" + "WHERE\n"
|
+ "user_id =#{userId} and `status`=0")
|
NoticeUnReadVO noticeUnreadNum(Long userId);
|
}
|
