From 132cb0d089c7734f3eb3e858bd741fbc60dbdc9d Mon Sep 17 00:00:00 2001
From: 陈昶聿 <chychen@nbjetron.com>
Date: 星期二, 20 一月 2026 16:46:25 +0800
Subject: [PATCH] 【丽水】获取随访统计比例 查询优化
---
smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java | 62 ++++++++++++++++++++++++++++++
1 files changed, 61 insertions(+), 1 deletions(-)
diff --git a/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java b/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java
index 90a640b..870ef3c 100644
--- a/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java
+++ b/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java
@@ -1,6 +1,7 @@
package com.smartor.mapper;
import com.smartor.domain.*;
+import org.apache.ibatis.annotations.MapKey;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
@@ -31,11 +32,24 @@
*/
public List<ServiceSubtask> selectServiceSubtaskList(ServiceSubtaskVO serviceSubtaskVO);
+ /**
+ * 鐢ㄤ簬琛ュ伩鏌ヨ
+ * @param serviceSubtaskVO
+ * @return
+ */
+ public List<ServiceSubtask> getCompensateServiceSubtaskList(ServiceSubtaskVO serviceSubtaskVO);
+
+ public List<ServiceSubtask> selectServiceSubtaskByDiagname(ServiceSubtask serviceSubtask);
+
+ public List<ServiceSubtask> queryServiceSubtaskList(ServiceSubtaskVO serviceSubtaskVO);
+
+ public List<ServiceSubtask> selectServiceSubtaskBySendstate(ServiceSubtaskVO serviceSubtaskVO);
+
public List<ServiceSubtask> selectServiceSubtaskListByCreateTime(ServiceSubtaskVO serviceSubtaskVO);
public List<ServiceSubtask> selectServiceSubtaskListAgain(ServiceSubtaskVO serviceSubtaskVO);
- public Integer selectSendstateByCondition(ServiceSubtask serviceSubtask);
+ public List<Integer> selectSendstateByCondition(ServiceSubtask serviceSubtask);
/**
* 鏂板鍗曚竴浠诲姟锛堥殢璁匡級
@@ -53,6 +67,14 @@
*/
public Double selectTimelyRate(ServiceSubtask ServiceSubtask);
+ /**
+ * 闅忚鍙婃椂鐜囷細搴旈殢璁挎椂闂�<瀹為檯闅忚鏃堕棿
+ *
+ * @param ServiceSubtask
+ * @return
+ */
+ @MapKey("groupKey")
+ public Map<String, Double> selectTimelyRateBatch(ServiceSubtask ServiceSubtask);
/**
* 闅忚鍙婃椂鐜囪鎯�
*
@@ -99,8 +121,46 @@
public List<ServiceSubtaskCount> getSfStatisticsJoydetails(ServiceSubtaskCountReq serviceSubtaskCountReq);
+ /**
+ * 鑾峰彇闂缁熻缁撴灉锛堥殢璁匡級
+ *
+ * @return 缁撴灉
+ */
+ public List<ServiceSubtaskCount> getSfStatisticsCategory(ServiceSubtaskCountReq serviceSubtaskCountReq);
+
+ /**
+ * 鑾峰彇闂缁熻缁撴灉锛堥殢璁匡級
+ *
+ * @return 缁撴灉
+ */
+ public List<ServiceSubtaskScriptCount> getSfStatisticsScriptDetails(ServiceSubtaskCountReq serviceSubtaskCountReq);
+
+ /**
+ * 鑾峰彇闂鍥炵瓟缁熻缁撴灉锛堥殢璁匡級
+ *
+ * @return 缁撴灉
+ */
+ public List<ServiceSubtaskScriptCount> getSfStatisticsScriptItemDetails(ServiceSubtaskCountReq serviceSubtaskCountReq);
+
+
public List<PatMedRes> getDeptRanking(PatMedReq patMedReq);
public List<ServiceStatisticsResponse> getServiceStatistics(ServiceStatisticsRequest serviceStatisticsRequest);
+ /**
+ * 缁熻浠诲姟鍚勭鐘舵�佺殑鏁伴噺锛堜紭鍖栫増锛�
+ * 鐢ㄤ簬鏇夸唬搴旂敤灞傜殑寰幆缁熻锛岀洿鎺ュ湪鏁版嵁搴撳眰杩涜鑱氬悎璁＄畻
+ *
+ * @param serviceSubtaskVO 鏌ヨ鏉′欢
+ * @return Map<String, Object> 鍖呭惈鍚勭姸鎬佺粺璁℃暟鎹�
+ * wzx: 鏈墽琛屾暟閲�
+ * ysf: 宸查殢璁挎暟閲�
+ * fssb: 鍙戦�佸け璐ユ暟閲�
+ * yfs: 宸插彂閫佹暟閲�
+ * dsf: 寰呴殢璁挎暟閲�
+ * blq: 涓嶇悊鐫暟閲�
+ * yc: 寮傚父鏁伴噺
+ */
+ public Map<String, Object> countByCondition(ServiceSubtaskVO serviceSubtaskVO);
+
}
--
Gitblit v1.9.3