From 79f9fbd9f999e26af3f0bca534d825eb687e092c Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期三, 25 十二月 2024 08:47:24 +0800
Subject: [PATCH] 20241225
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 34 ++++++++++++++++++++++++++++++++++
1 files changed, 34 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 d3f984f..1ef62e1 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
@@ -297,4 +297,38 @@
@Select("SELECT a.sqdh FROM ltkj_jianchajianyan_tree a WHERE a.card_id=#{cardId} AND a.type='妫�楠�' AND a.service = 'lis' GROUP BY a.sqdh")
List<String> getBlJysqdhByLis(String cardId);
+
+
+ @Select("SELECT\n" +
+ " DISTINCT a.tj_number \n" +
+ "FROM\n" +
+ " tj_order_remark a\n" +
+ " JOIN sys_dept b ON b.dept_id = a.dept_id \n" +
+ "WHERE\n" +
+ " a.deleted = 0 \n" +
+ " AND b.org_type = 1 \n" +
+ " AND a.type !=1")
+ List<String> getDingShiTongBuJianYanTjNum();
+
+
+ @Select(" SELECT\n" +
+ " DISTINCT a.tj_number \n" +
+ "FROM\n" +
+ " tj_order_remark a\n" +
+ " JOIN sys_dept b ON b.dept_id = a.dept_id \n" +
+ "WHERE\n" +
+ " a.deleted = 0 \n" +
+ " AND b.org_type = 2 \n" +
+ " AND a.type =0")
+ List<String> getDingShiTongBuJianChaTjNum();
+
+
+
+
+ void tjQiandaodengji(Map<String,Object> map);
+
+ void tjLispacstongbujianyi(Map<String, Object> map);
+
+ List<List<?>> getTjBgdyList(Map<String, Object> map);
+
}
--
Gitblit v1.8.0