From 2712f20cb96e50fb2849d6dc6ef34d25ddfaf9e8 Mon Sep 17 00:00:00 2001
From: sinake <sinake1@qq.com>
Date: 星期一, 21 九月 2026 16:45:44 +0800
Subject: [PATCH] 捐献器官统计明细列表
---
ruoyi-project/src/main/resources/mapper/project/ServiceTotalsMapper.xml | 5 ++---
1 files changed, 2 insertions(+), 3 deletions(-)
diff --git a/ruoyi-project/src/main/resources/mapper/project/ServiceTotalsMapper.xml b/ruoyi-project/src/main/resources/mapper/project/ServiceTotalsMapper.xml
index da3af29..fee68bf 100644
--- a/ruoyi-project/src/main/resources/mapper/project/ServiceTotalsMapper.xml
+++ b/ruoyi-project/src/main/resources/mapper/project/ServiceTotalsMapper.xml
@@ -46,13 +46,12 @@
<select id="organ" parameterType="com.ruoyi.project.domain.ServiceTotals"
resultType="ServiceTotalsOrgan">
SELECT DATE_FORMAT(a.organ_start_time, '%Y-%m') donateTime,a.OrganName organName, COUNT(*) getCount,c.RegisterCountyName area,
- COUNT(IF(b.transplantstate=3, true, NULL)) useCount ,COUNT(IF(d.complete_state=4, true, NULL)) deprecateCount
+ COUNT(IF(b.transplantstate=3, true, NULL)) useCount ,COUNT(IF(b.transplantstate=4, true, NULL)) deprecateCount
FROM service_donationwitnessorgan a
LEFT JOIN service_donatecomporgan b ON a.InfoID=b.InfoID AND a.OrganName=b.OrganName
LEFT JOIN service_donatebaseinfo c ON a.InfoID=c.ID
- LEFT JOIN service_donatecompletioninfo d ON d.InfoID=a.InfoID
<where>
- a.del_flag=0 and b.del_flag=0 and c.del_flag=0 and d.del_flag=0
+ a.del_flag=0 and b.del_flag=0 and c.del_flag=0
<if test="area != null and area != ''">
and a.InfoID in (select id FROM service_donatecompletioninfo where RegisterCountyName>=#{area} )
</if>
--
Gitblit v1.9.3