From 5c58a8a9fa43c671af54358172f853f02c4acfc7 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期四, 16 一月 2025 21:18:36 +0800
Subject: [PATCH] zjh20250116
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjOrderMapper.java | 9 +++++++++
1 files changed, 9 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 14b4e13..51dcd8e 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
@@ -331,4 +331,13 @@
List<List<?>> getTjBgdyList(Map<String, Object> map);
+ @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")
+ List<String> getJianChaTjNum();
}
--
Gitblit v1.8.0