From cc25bc0eec2d50da39d62f9896ed4d5e66805366 Mon Sep 17 00:00:00 2001 From: zjh <1084500556@qq.com> Date: 星期五, 11 七月 2025 18:04:05 +0800 Subject: [PATCH] zjh20250711 --- ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderDetailMapper.java | 6 +++++- 1 files changed, 5 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 030a92d..6c53e73 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 @@ -208,7 +208,7 @@ "FROM `tj_order_detail` \n" + "where order_id=#{orderId}\n" + "and pro_id IN\n" + - "(select pro_id from tj_project where pro_parent_id=#{proParentId})") + "(select pro_id from tj_project where pro_parent_id=#{proParentId} and deleted=0 and pro_status=0)") 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); @@ -303,4 +303,8 @@ " LEFT JOIN sys_dept d ON p.dept_id = d.dept_id\n" + " WHERE order_id = #{orderId} AND p.pro_parent_id <>0 AND o.is_return = #{type}") List<ProFcListVo> getFcList(@Param("orderId") Long orderId, @Param("type") Integer type); + + + @Select("call newpacsJianChaData(#{tjnumber,mode=IN},1)") + List<TjOrderDetail> newgetDetailByOrderIdAndParId(String tjNumber); } -- Gitblit v1.8.0