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/LimsShebeiYiqiXinxiMapper.java | 46 ++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 46 insertions(+), 0 deletions(-)
diff --git a/jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsShebeiYiqiXinxiMapper.java b/jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsShebeiYiqiXinxiMapper.java
new file mode 100644
index 0000000..f496ff9
--- /dev/null
+++ b/jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsShebeiYiqiXinxiMapper.java
@@ -0,0 +1,46 @@
+package jnpf.limsMapper;
+
+import jnpf.base.mapper.SuperMapper;
+import jnpf.limsEntity.LimsShebeiYiqiXinxiEntity;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Select;
+
+import java.time.LocalDateTime;
+
+@Mapper
+public interface LimsShebeiYiqiXinxiMapper extends SuperMapper<LimsShebeiYiqiXinxiEntity> {
+
+ @Select("SELECT EXISTS (" +
+ "SELECT 1 FROM lims_shebei_yiqi_shiyong " +
+ "WHERE yiqi_id = #{yiqiId} " +
+ "AND jiaoyan_shijian >= #{startTime} " +
+ "AND jiaoyan_shijian < #{endTime}" +
+ ")")
+ boolean existsTodayJiaoyan(@Param("yiqiId") String yiqiId,
+ @Param("startTime") LocalDateTime startTime,
+ @Param("endTime") LocalDateTime endTime);
+
+ @Select("SELECT EXISTS (" +
+ "SELECT 1 FROM lims_shebei_yiqi_xinxi yiqi " +
+ "WHERE yiqi.f_id = #{yiqiId} " +
+ "AND yiqi.shifou_richang_jiaoyan = 'yes' " +
+ "AND NOT EXISTS (" +
+ "SELECT 1 FROM lims_shebei_yiqi_shiyong shiyong " +
+ "WHERE shiyong.yiqi_id = #{yiqiId} " +
+ "AND shiyong.jiaoyan_shijian >= #{startTime} " +
+ "AND shiyong.jiaoyan_shijian < #{endTime}" +
+ ")" +
+ ")")
+ boolean requiresTodayJiaoyan(@Param("yiqiId") String yiqiId,
+ @Param("startTime") LocalDateTime startTime,
+ @Param("endTime") LocalDateTime endTime);
+
+ @Select("SELECT EXISTS (" +
+ "SELECT 1 FROM lims_shebei_yiqi_shiyong " +
+ "WHERE yiqi_id = #{yiqiId} " +
+ "AND shiyong_kaishi_shijian IS NOT NULL " +
+ "AND shiyong_jieshu_shijian IS NULL" +
+ ")")
+ boolean existsUsingYiqi(@Param("yiqiId") String yiqiId);
+}
--
Gitblit v1.8.0