| | |
|---|
| | | 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; |
|---|
| | |
|---|
| | | @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); |
|---|
| | | } |
|---|
