From 47aed74050e956919f2eee588fbab15607cf4029 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期二, 31 十月 2023 17:20:31 +0800
Subject: [PATCH] zjh 2023/10/31--1
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjDwDeptMapper.java | 4 +++-
1 files changed, 3 insertions(+), 1 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjDwDeptMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjDwDeptMapper.java
index c79c8a5..9b2310e 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjDwDeptMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjDwDeptMapper.java
@@ -78,7 +78,9 @@
@Select("\n" +
"SELECT aa.bg_type, aa.dw_name,aa.batch,aa.dept,sum(aa.people_count) people_count,sum(aa.yj_count) yj_count,(sum(aa.people_count)-sum(aa.yj_count))wj_count FROM (\n" +
"\n" +
- "SELECT '鍥綋' bg_type, a.company dw_name,COUNT(DISTINCT a.team_no) batch,a.department dept,COUNT(*) people_count, 0 yj_count,0 wj_count FROM tj_reservation a WHERE a.deleted=0 AND a.grouping_id IN (\n" +
+ "SELECT '鍥綋' bg_type, r.cn_name dw_name,COUNT(DISTINCT a.team_no) batch,a.department dept,COUNT(*) people_count, 0 yj_count,0 wj_count FROM tj_reservation a " +
+ "LEFT JOIN dict_comp r ON a.company_id=r.drug_manufacturer_id" +
+ " WHERE a.deleted=0 AND a.grouping_id IN (\n" +
"\n" +
" SELECT b.id FROM tj_dw_grouping b WHERE b.deleted=0 AND b.dw_dept_id=#{dwDeptId}\n" +
"\t \n" +
--
Gitblit v1.8.0