From f6aa75199f79c3fbe74de4c72c3271234e781341 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期二, 28 五月 2024 18:03:22 +0800
Subject: [PATCH] 将单独查询的sql 统一
---
ltkj-hosp/src/main/resources/mapper/TjOrderDetailMapper.xml | 15 +++++++++++++++
ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderDetailServiceImpl.java | 5 +++++
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java | 2 +-
ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderDetailService.java | 2 ++
4 files changed, 23 insertions(+), 1 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java
index 59ebe3e..4210147 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java
@@ -159,7 +159,7 @@
"(select pro_id from tj_project where pro_parent_id=#{proParentId})")
public List<TjOrderDetail> getDetailByOrderIdAndParId(@Param("orderId")Long orderId,@Param("proParentId")Long proParentId);
-
+ public List<TjOrderDetail> getDetailByOrderIdAndParIds(@Param("orderId")Long orderId,@Param("proParentIds")List<Long> proParentIds);
@Select("call pro_lis_sqdbgd(1,#{tjnumber,mode=IN})")
// @Select("select * from test_detail")
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderDetailService.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderDetailService.java
index 5060183..ba7723e 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderDetailService.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/ITjOrderDetailService.java
@@ -101,6 +101,8 @@
public List<TjOrderDetail> getDetailByOrderIdAndParId(Long orderId,Long proParentId);
+ public List<TjOrderDetail> getDetailByOrderIdAndParIds(Long orderId,List<Long> proParentIds);
+
List<TjOrderDetail> addHuaYanTable(String tjnumber);
}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderDetailServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderDetailServiceImpl.java
index af80276..1279f57 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderDetailServiceImpl.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/TjOrderDetailServiceImpl.java
@@ -160,6 +160,11 @@
}
@Override
+ public List<TjOrderDetail> getDetailByOrderIdAndParIds(Long orderId, List<Long> proParentIds) {
+ return tjOrderDetailMapper.getDetailByOrderIdAndParIds(orderId,proParentIds);
+ }
+
+ @Override
public List<TjOrderDetail> addHuaYanTable(String tjnumber) {
return tjOrderDetailMapper.addHuaYanTable(tjnumber);
}
diff --git a/ltkj-hosp/src/main/resources/mapper/TjOrderDetailMapper.xml b/ltkj-hosp/src/main/resources/mapper/TjOrderDetailMapper.xml
index 015eb72..2a6c481 100644
--- a/ltkj-hosp/src/main/resources/mapper/TjOrderDetailMapper.xml
+++ b/ltkj-hosp/src/main/resources/mapper/TjOrderDetailMapper.xml
@@ -64,6 +64,21 @@
<include refid="selectTjOrderDetailVo"/>
where order_detail_id = #{orderDetailId}
</select>
+ <select id="getDetailByOrderIdAndParIds" resultType="com.ltkj.hosp.domain.TjOrderDetail">
+ SELECT CONCAT(t.update_by,',',p.pro_parent_id) AS update_by,
+ t.order_detail_id,t.order_id,t.pro_id,t.pro_type,t.stan_id,t.pro_result,t.pro_advice,t.tj_status,t.create_time,t.create_by,t.update_time,t.exception_desc,t.is_addition,t.is_return,t.flowing_water_id,t.is_sampling,t.result_type,t.yq_deadline,t.create_id,t.update_id,t.conclusion,t.advice,t.is_positive
+ FROM tj_order_detail t
+ JOIN(
+ SELECT pro_id,pro_parent_id
+ FROM tj_project
+ WHERE pro_parent_id IN
+ <foreach collection="proParentIds" item="proParentId" open="(" separator="," close=")">
+ #{proParentId}
+ </foreach>
+ ) p
+ ON t.pro_id = p.pro_id
+ WHERE t.order_id = #{orderId}
+ </select>
<insert id="insertTjOrderDetail" parameterType="TjOrderDetail">
insert into tj_order_detail
--
Gitblit v1.8.0