From c5a0c0b290cba50f76d17843ac062ffa935b15d6 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期三, 30 十月 2024 18:03:18 +0800
Subject: [PATCH] zjh20241030
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 14 ++++++++++++++
1 files changed, 14 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 b42e88c..4fcb764 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
@@ -5,6 +5,7 @@
import java.util.Map;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
+import com.ltkj.hosp.domain.LtkjJianchajianyanTree;
import com.ltkj.hosp.domain.TjCustomer;
import com.ltkj.hosp.domain.TjOrder;
import com.ltkj.hosp.vodomain.LineChartsVo;
@@ -147,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,
@@ -268,4 +272,14 @@
List<String> getHuoQuBlZlsqdh(@Param("cardId")String cardId,@Param("bldh") String bldh);
@Delete("DELETE FROM ltkj_jianchajianyan_tree WHERE card_id=#{cardId} and jxbz=#{bldh} AND type='澶勭疆'")
Boolean delHuoQuZlsqdh(@Param("cardId")String cardId,@Param("bldh") String bldh);
+
+
+ List<List<?>> getgetBghsList(Map<String,Object> map);
+
+
+ @Select({"<script>","SELECT * FROM ltkj_jianchajianyan_tree a WHERE a.card_id=#{cardId} AND a.jxbz IN ","<foreach collection='bldh' item='id' open='(' separator=',' close=')'>",
+ "#{id}",
+ "</foreach>",
+ "</script>" })
+ List<LtkjJianchajianyanTree> getBuLuXmXinXi(@Param("bldh") List<String> bldh,@Param("cardId")String cardId);
}
--
Gitblit v1.8.0