From ac544c1d85c53e7f51e4ea76aa2489a14aef03d9 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 20 六月 2025 18:57:45 +0800
Subject: [PATCH] zjh20250620
---
ltkj-system/src/main/java/com/ltkj/system/mapper/SysNoticeMapper.java | 14 +++++++++++++-
1 files changed, 13 insertions(+), 1 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..4860800 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
@@ -2,14 +2,17 @@
import java.util.List;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.system.domain.SysNotice;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
/**
* 閫氱煡鍏憡琛� 鏁版嵁灞�
*
* @author ltkj
*/
-public interface SysNoticeMapper {
+public interface SysNoticeMapper extends BaseMapper<SysNotice> {
/**
* 鏌ヨ鍏憡淇℃伅
*
@@ -57,4 +60,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