From 47ff4d8018d550a23ca81a964c226ec173326942 Mon Sep 17 00:00:00 2001 From: zhaowenxuan <chacca165@163.com> Date: 星期一, 16 六月 2025 10:37:22 +0800 Subject: [PATCH] 0616-1 --- ltkj-system/src/main/java/com/ltkj/system/mapper/SysNoticeMapper.java | 11 +++++++++++ 1 files changed, 11 insertions(+), 0 deletions(-) diff --git a/ltkj-system/src/main/java/com/ltkj/system/mapper/SysNoticeMapper.java b/ltkj-system/src/main/java/com/ltkj/system/mapper/SysNoticeMapper.java index 4f08775..822ec7e 100644 --- a/ltkj-system/src/main/java/com/ltkj/system/mapper/SysNoticeMapper.java +++ b/ltkj-system/src/main/java/com/ltkj/system/mapper/SysNoticeMapper.java @@ -3,6 +3,8 @@ import java.util.List; import com.ltkj.system.domain.SysNotice; +import org.apache.ibatis.annotations.Param; +import org.apache.ibatis.annotations.Select; /** * 閫氱煡鍏憡琛� 鏁版嵁灞� @@ -57,4 +59,13 @@ * @return 缁撴灉 */ public int deleteNoticeByIds(Long[] noticeIds); + + @Select("SELECT s.* FROM sys_notice s\n" + + " JOIN sys_notice_user n ON s.notice_id = n.notice_id\n" + + " WHERE DATE(s.create_time) = CURDATE() AND n.user_id = #{userId}") + List<SysNotice> selectAll(@Param("userId") String userId); + + @Select("SELECT s.* FROM sys_notice s\n" + + " WHERE DATE(s.create_time) = CURDATE()") + List<SysNotice> selectAllByAdmin(); } -- Gitblit v1.8.0