From 3eeaad61513758f2e05277995fb2af3a21f72b35 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期四, 05 十二月 2024 08:55:00 +0800
Subject: [PATCH] zjh20241205-1
---
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 d3f984f..a6affca 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,28 @@
@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 !=1")
+ List<String> getDingShiTongBuJianChaTjNum();
}
--
Gitblit v1.8.0