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/LimsWendingxingKaocaJihuaZhouqiMapper.java | 52 ++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 52 insertions(+), 0 deletions(-)
diff --git a/jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsWendingxingKaocaJihuaZhouqiMapper.java b/jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsWendingxingKaocaJihuaZhouqiMapper.java
new file mode 100644
index 0000000..2a03927
--- /dev/null
+++ b/jnpf-lims/jnpf-lims-biz/src/main/java/jnpf/limsMapper/LimsWendingxingKaocaJihuaZhouqiMapper.java
@@ -0,0 +1,52 @@
+package jnpf.limsMapper;
+
+import jnpf.base.mapper.SuperMapper;
+import jnpf.limsEntity.LimsWendingxingJianceZhixingVo;
+import jnpf.limsEntity.LimsWendingxingKaocaJihuaZhouqiEntity;
+import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Result;
+import org.apache.ibatis.annotations.Results;
+import org.apache.ibatis.annotations.Select;
+
+@Mapper
+public interface LimsWendingxingKaocaJihuaZhouqiMapper
+ extends SuperMapper<LimsWendingxingKaocaJihuaZhouqiEntity> {
+
+ /**
+ * 鏌ヨ宸插畬鎴愬彇鏍蜂笖鍏佽缁х画鎵ц鐨勭ǔ瀹氭�у懆鏈熸暟鎹��
+ */
+ @Select("SELECT a.f_id AS id, a.kaoca_jihua_id, a.zhouqi, a.zhouqi_danwei, "
+ + "a.pihao, a.shiqu_shuliang, a.yangpin_danwei, a.jiancha_xiangmu_ids, "
+ + "a.jiancha_xiangmu_mingcheng, b.yangpin_mingcheng, "
+ + "b.yangpin_bianhao, b.guige, "
+ + "b.changqi_fangzhi_tiaojian, b.fenlei AS leixin, b.zhiliang_biaozhun, "
+ + "b.quyangren, b.quyang_riqi, c.zhiliang_biaozhun_id,c.yangpin_id "
+ + "FROM lims_wendingxing_kaoca_jihua_zhouqi a "
+ + "INNER JOIN lims_wendingxing_quyangdan b ON a.kaoca_jihua_id = b.jihua_id "
+ + "INNER JOIN lims_wendingxing_kaoca_jihua c ON a.kaoca_jihua_id = c.f_id "
+ + "WHERE a.shifou_jixu_zhixing = 'yes' "
+ + "AND a.pihao = b.pihao AND a.f_id = #{jihuaZhouqiId} LIMIT 1")
+ @Results(id = "wendingxingJianceZhixingResult", value = {
+ @Result(column = "id", property = "id", id = true),
+ @Result(column = "kaoca_jihua_id", property = "kaocaJihuaId"),
+ @Result(column = "zhouqi", property = "zhouqi"),
+ @Result(column = "zhouqi_danwei", property = "zhouqiDanwei"),
+ @Result(column = "pihao", property = "pihao"),
+ @Result(column = "shiqu_shuliang", property = "shiquShuliang"),
+ @Result(column = "yangpin_danwei", property = "yangpinDanwei"),
+ @Result(column = "jiancha_xiangmu_ids", property = "jianchaXiangmuIds"),
+ @Result(column = "jiancha_xiangmu_mingcheng", property = "jianchaXiangmuMingcheng"),
+ @Result(column = "yangpin_mingcheng", property = "yangpinMingcheng"),
+ @Result(column = "yangpin_id", property = "yangpinId"),
+ @Result(column = "yangpin_bianhao", property = "yangpinBianhao"),
+ @Result(column = "guige", property = "guige"),
+ @Result(column = "changqi_fangzhi_tiaojian", property = "changqiFangzhiTiaojian"),
+ @Result(column = "leixin", property = "leixin"),
+ @Result(column = "zhiliang_biaozhun", property = "zhiliangBiaozhun"),
+ @Result(column = "zhiliang_biaozhun_id", property = "zhiliangBiaozhunId"),
+ @Result(column = "quyangren", property = "quyangren"),
+ @Result(column = "quyang_riqi", property = "quyangRiqi")
+ })
+ LimsWendingxingJianceZhixingVo selectJianceZhixing(@Param("jihuaZhouqiId") String jihuaZhouqiId);
+}
--
Gitblit v1.8.0