From 14f9208da19b7030a1c65a40897f9f4146a74d44 Mon Sep 17 00:00:00 2001
From: 赵文轩 <1652863494@qq.com>
Date: 星期五, 01 十一月 2024 08:37:14 +0800
Subject: [PATCH] 增加申请业务类型
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
index 12d6efc..cf0a8bf 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java
@@ -148,6 +148,9 @@
@Select("SELECT * FROM tj_order WHERE tj_number = #{tjNum} AND deleted='0' ")
public TjOrder getOrderByTjNum(String tjNum);
+ @Select("SELECT * FROM tj_order WHERE card_id = #{cardId} AND deleted='0' ")
+ public TjOrder getOrderByCardId(String cardId);
+
List<TjOrder> getTjOrderList(@Param("tjNum")String tjNum,
@Param("checkStatus")Integer checkStatus,
@Param("compId")Long compId,
@@ -244,6 +247,27 @@
@Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id=#{cardId} AND a.type='妫�楠�' GROUP BY a.sqdh")
List<String> getHuoQuJysqdh(String cardId);
+
+ /**
+ * 鏌ヨ闈炶ˉ褰曢」鐩�
+ * LIS浣滃簾鏌ヨ
+ * @param cardId
+ * @return
+ */
+ @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id= #{cardId} AND a.type='妫�楠�' AND a.jxbz IS NULL GROUP BY a.sqdh")
+ List<String> getHuoQuJysqdhNotBuLu(String cardId);
+
+ /**
+ * 鏌ヨ琛ュ綍椤圭洰
+ * LIS浣滃簾鏌ヨ
+ * @param cardId
+ * @return
+ */
+ @Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id= #{cardId} AND a.type='妫�楠�' AND a.jxbz IS NOT NULL GROUP BY a.sqdh")
+ List<String> getHuoQuJysqdhBuLu(String cardId);
+
+
+
@Delete("DELETE FROM ltkj_jianchajianyan_tree WHERE card_id=#{cardId} AND type='妫�楠�'")
Boolean delHuoQuJysqdh(String cardId);
--
Gitblit v1.8.0