From 09f75e1b4ee21241940ad26b91462ea15c5e4f00 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期五, 03 七月 2026 09:25:29 +0800
Subject: [PATCH] 1.短信功能提交 2.优化随访详情页 3.导出两个sheet

---
 smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java |   25 ++++++++++++++++++-------
 1 files changed, 18 insertions(+), 7 deletions(-)

diff --git a/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java b/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java
index 7fb20b5..ce47ee9 100644
--- a/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java
+++ b/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskMapper.java
@@ -126,6 +126,10 @@
 
     public List<ServiceSubtask> getSfStatistics(ServiceSubtaskCountReq serviceSubtaskCountReq);
 
+    public List<ServiceSubtaskStatistic> getSpecialSfStatistics(ServiceSubtaskCountReq serviceSubtaskCountReq);
+
+    public List<ServiceSubtask> getSfStatisticsHyperlink(ServiceSubtaskCountReq serviceSubtaskCountReq);
+
     public List<String> getSfStatisticsGroupKey(ServiceSubtaskCountReq serviceSubtaskCountReq);
 
     public List<ServiceSubtaskCount> getSfStatisticsJoy(ServiceSubtaskCountReq serviceSubtaskCountReq);
@@ -164,13 +168,13 @@
      *
      * @param serviceSubtaskVO 鏌ヨ鏉′欢
      * @return Map<String, Object> 鍖呭惈鍚勭姸鎬佺粺璁℃暟鎹�
-     * wzx: 鏈墽琛屾暟閲�
-     * ysf: 宸查殢璁挎暟閲�
-     * fssb: 鍙戦�佸け璐ユ暟閲�
-     * yfs: 宸插彂閫佹暟閲�
-     * dsf: 寰呴殢璁挎暟閲�
-     * blq: 涓嶇悊鐫暟閲�
-     * yc: 寮傚父鏁伴噺
+     * total: 鎮h�呮湇鍔℃�婚噺
+     * wxsf: 鏃犻渶闅忚鏁伴噺 sendstate != 4
+     * xsf: 闇�闅忚鏁伴噺 sendstate = 4
+     * dsf: 寰呴殢璁挎暟閲� sendstate = 1L, 2L, 3L, 5L, 7L
+     * ywc: 宸插畬鎴愭暟閲� sendstate = 6L
+     * yc: 寮傚父鏁伴噺 excep = '1'
+     * yc: 璀﹀憡鏁伴噺 excep = '2'
      */
     public Map<String, Object> countByCondition(ServiceSubtaskEntity serviceSubtaskVO);
 
@@ -220,4 +224,11 @@
      */
     List<Map<String, Object>> getHeLibraryCount(HeLibraryCountVO heLibraryCountVO);
 
+    /**
+     * 缁熻闂鐨勯�夐」鐨勭櫨鍒嗘瘮
+     * @param taskIds
+     * @return
+     */
+    List<ServiceSubtaskDetailRatioExport> statQuestionOption(@Param("taskIds") List<Long> taskIds);
+
 }

--
Gitblit v1.9.3