From 34981c30a78e8bbd7791131059a9210f9928b62c Mon Sep 17 00:00:00 2001
From: 刘光辉 <347230014@qq.com>
Date: 星期四, 17 九月 2026 09:24:09 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master' into master

---
 jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsMessageEventMapper.java |   26 ++++++++++++++++++++++++++
 1 files changed, 26 insertions(+), 0 deletions(-)

diff --git a/jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsMessageEventMapper.java b/jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsMessageEventMapper.java
new file mode 100644
index 0000000..8fbd48d
--- /dev/null
+++ b/jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsMessageEventMapper.java
@@ -0,0 +1,26 @@
+package jnpf.limsMapper;
+
+import jnpf.base.mapper.SuperMapper;
+import jnpf.limsEntity.LimsMessageEventEntity;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Insert;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+
+@Mapper
+public interface LimsMessageEventMapper extends SuperMapper<LimsMessageEventEntity> {
+    @Insert("INSERT INTO lims_message_event (id, tenant_id, event_code, biz_id, remind_stage, occurrence_key, " +
+            "recipient_snapshot, parameter_snapshot, status, recipient_count, sent_count, failed_count, " +
+            "retry_count, created_time, last_modify_time) VALUES (#{id}, #{tenantId}, #{eventCode}, #{bizId}, " +
+            "#{remindStage}, #{occurrenceKey}, #{recipientSnapshot}, #{parameterSnapshot}, #{status}, " +
+            "#{recipientCount}, #{sentCount}, #{failedCount}, #{retryCount}, #{createdTime}, #{lastModifyTime}) " +
+            "ON CONFLICT (tenant_id, occurrence_key) DO NOTHING")
+    int insertIfAbsent(LimsMessageEventEntity entity);
+
+    @Select("SELECT * FROM lims_message_event WHERE tenant_id = #{tenantId} AND occurrence_key = #{occurrenceKey} LIMIT 1")
+    LimsMessageEventEntity selectByOccurrenceKey(@Param("tenantId") String tenantId,
+                                                  @Param("occurrenceKey") String occurrenceKey);
+
+    @Select("SELECT * FROM lims_message_event WHERE id = #{id}")
+    LimsMessageEventEntity selectEvent(@Param("id") String id);
+}

--
Gitblit v1.8.0