From 1b88746f85ed05f571d0ef0307f6b68db4157ee2 Mon Sep 17 00:00:00 2001
From: 陈昶聿 <chychen@nbjetron.com>
Date: 星期五, 05 六月 2026 01:02:51 +0800
Subject: [PATCH] 【丽水】getSpecialSfStatistics 获取专病随访统计比例
---
smartor/src/main/java/com/smartor/domain/ServiceSubtaskCountReq.java | 18 ++++++++++++++++++
smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml | 26 +++++++++++++++++++++++---
2 files changed, 41 insertions(+), 3 deletions(-)
diff --git a/smartor/src/main/java/com/smartor/domain/ServiceSubtaskCountReq.java b/smartor/src/main/java/com/smartor/domain/ServiceSubtaskCountReq.java
index ff0f0b8..b2c3a5d 100644
--- a/smartor/src/main/java/com/smartor/domain/ServiceSubtaskCountReq.java
+++ b/smartor/src/main/java/com/smartor/domain/ServiceSubtaskCountReq.java
@@ -182,6 +182,24 @@
@ApiModelProperty(value = "瓒呴摼鎺ョ粺璁″垪琛ㄧ被鍨�")
private String hyperLinkInfoType;
+ @ApiModelProperty(value = "浠诲姟ID", required = true)
+ private Long taskId;
+
+ @ApiModelProperty(value = "taskIds闆嗗悎")
+ private List<Long> taskIds;
+
+ @ApiModelProperty(value = "浠诲姟鍚嶇О")
+ private String taskName;
+
+ @ApiModelProperty(value = "taskNamee闆嗗悎")
+ private List<String> taskNames;
+
+ @ApiModelProperty(value = "鐤剧梾鐥呯")
+ private String diagType;
+
+ @ApiModelProperty(value = "diagType闆嗗悎")
+ private List<String> diagTypes;
+
/**
* pageNum
*/
diff --git a/smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml b/smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml
index effc758..c09a81c 100644
--- a/smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml
+++ b/smartor/src/main/resources/mapper/smartor/ServiceSubtaskMapper.xml
@@ -1508,6 +1508,7 @@
<select id="getSpecialSfStatistics" parameterType="com.smartor.domain.ServiceSubtaskCountReq"
resultMap="ServiceSubtaskStatisticResult">
select
+ a.task_name,
COUNT(1) AS discharge_count,
SUM(CASE WHEN b.sendstate = 4 THEN 1 ELSE 0 END) AS non_follow_up,
SUM(CASE WHEN b.sendstate = 4 and b.task_situation = 6 THEN 1 ELSE 0 END) AS filter_count,
@@ -1542,6 +1543,27 @@
</if>
<if test="diagType != null and diagType != ''">
and a.diag_type = #{diagType}
+ </if>
+ <if test="taskIds != null and taskIds.size() > 0">
+ AND a.task_id IN
+ <foreach collection="taskIds" item="taskIdItem" open="(" separator=","
+ close=")">
+ #{taskIdItem}
+ </foreach>
+ </if>
+ <if test="taskNames != null and taskNames.size() > 0">
+ AND a.task_name IN
+ <foreach collection="taskNames" item="taskNameItem" open="(" separator=","
+ close=")">
+ #{taskNameItem}
+ </foreach>
+ </if>
+ <if test="diagTypes != null and diagTypes.size() > 0">
+ AND a.diag_type IN
+ <foreach collection="diagTypes" item="diagTypeItem" open="(" separator=","
+ close=")">
+ #{diagTypeItem}
+ </foreach>
</if>
<if test="leavehospitaldistrictcodes != null and leavehospitaldistrictcodes.size() > 0">
AND b.leavehospitaldistrictcode IN
@@ -1585,9 +1607,7 @@
<if test="visitCount != null and visitCount > 1">
AND b.visit_count > 1
</if>
- <if test="groupKey != null and groupKey != ''">
- GROUP BY ${groupKey}
- </if>
+ GROUP BY a.task_name
</select>
<select id="getSfStatisticsGroupKey" parameterType="com.smartor.domain.ServiceSubtaskCountReq"
--
Gitblit v1.9.3