From 76d92e0fce529fe55f9231a37a350192175312ec Mon Sep 17 00:00:00 2001
From: 陈昶聿 <chychen@nbjetron.com>
Date: 星期五, 09 一月 2026 15:51:27 +0800
Subject: [PATCH] 【市一】问题统计接口调整
---
smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml | 8 +++-----
1 files changed, 3 insertions(+), 5 deletions(-)
diff --git a/smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml b/smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml
index 86fe53d..f75750b 100644
--- a/smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml
@@ -1342,7 +1342,7 @@
and a.del_flag=0
AND t.del_flag=0
<if test="orgid != null and orgid != ''">
- and a.orgid = #{orgid}
+ and t.orgid = #{orgid}
</if>
<if test="leavehospitaldistrictcodes != null and leavehospitaldistrictcodes.size() > 0">
AND t.leavehospitaldistrictcode IN
@@ -1414,8 +1414,8 @@
FROM
service_subtask_detail ssd
INNER JOIN service_subtask ss ON ssd.sub_id = ss.id
- WHERE
- ss.del_flag=0
+ WHERE 1=1
+ AND ss.del_flag=0
AND ssd.del_flag = 0
<if test="orgid != null and orgid != ''">
AND ss.orgid = #{orgid}
@@ -1477,8 +1477,6 @@
<if test="orgid != null and orgid != ''">
and ss.orgid = #{orgid}
</if>
- AND IFNULL(ssd.matchedtext,ssd.asrtext) IS NOT NULL
- AND IFNULL(ssd.matchedtext,ssd.asrtext) != ''
<if test="leavehospitaldistrictcodes != null and leavehospitaldistrictcodes.size() > 0">
AND ss.leavehospitaldistrictcode IN
<foreach collection="leavehospitaldistrictcodes" item="leavehospitaldistrictcode" open="(" separator=","
--
Gitblit v1.9.3