From f0a09ee996ab2605869844d6a3d812709e2bf0fa Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期五, 16 十月 2026 16:07:25 +0800
Subject: [PATCH] 任务模块、电话模块
---
ruoyi-satisfaction/src/main/java/com/ruoyi/satisfaction/mapper/SatisfactionMapper.java | 23 +++++++++++++++++++++--
1 files changed, 21 insertions(+), 2 deletions(-)
diff --git a/ruoyi-satisfaction/src/main/java/com/ruoyi/satisfaction/mapper/SatisfactionMapper.java b/ruoyi-satisfaction/src/main/java/com/ruoyi/satisfaction/mapper/SatisfactionMapper.java
index 44d3189..34ce21d 100644
--- a/ruoyi-satisfaction/src/main/java/com/ruoyi/satisfaction/mapper/SatisfactionMapper.java
+++ b/ruoyi-satisfaction/src/main/java/com/ruoyi/satisfaction/mapper/SatisfactionMapper.java
@@ -22,8 +22,8 @@
/**
* 婊℃剰搴︾粺璁� Mapper 鎺ュ彛銆�
* <p>
- * 杩佺Щ璇存槑锛氭柟娉曞師鏈暎钀藉湪 {@code com.smartor.mapper.ServiceSubtaskMapper} 涓�
- * {@code com.smartor.mapper.ServiceSubtaskDetailMapper} 涓紝婊℃剰搴︽ā鍧楀寲鍚庨泦涓埌姝ゅ銆�
+ * 杩佺Щ璇存槑锛氭柟娉曞師鏈暎钀藉湪 {@code com.ruoyi.task.mapper.ServiceSubtaskMapper} 涓�
+ * {@code com.ruoyi.task.mapper.ServiceSubtaskDetailMapper} 涓紝婊℃剰搴︽ā鍧楀寲鍚庨泦涓埌姝ゅ銆�
* <p>
* 鏈ā鍧楄嚜甯� SQL锛�<b>鐩存帴鏌ヨ</b> {@code service_subtask} / {@code service_subtask_detail}锛�
* 浠ュ強妯℃澘鍒嗙被琛紱涓嶄緷璧栦换浣曞叾瀹冩ā鍧楃殑 Mapper銆�
@@ -85,6 +85,25 @@
*/
List<Map<String, Object>> selectSatisfactionFillPersonCount(SatisfactionStatQuery query);
+ /**
+ * 銆愭寜 妯℃澘 + 闂銆戠粺璁＄瓟棰樹汉鏁帮紙{@code count(distinct ssd.sub_id)}锛夈��
+ * <p>
+ * <b>涓轰粈涔堝崟鐙姞杩欎竴鏉�</b>锛歿@code /statistics} 鐨勩�岀瓟棰樹汉鏁� / 鏈瓟棰樹汉鏁般�嶅繀椤讳笌
+ * 銆屽彂閫佷汉鏁般�嶏紙{@link #selectSatisfactionSendCount}锛屼篃鏄汉鏁帮級鍚屽彛寰勩��
+ * 鍘熷疄鐜拌鐢� {@link #selectSatisfactionFillStatByMatchedtext} 鐨� {@code count(*)}锛堟槑缁�<b>琛屾暟</b>锛夛紝
+ * 鑰屼竴鏉� {@code (sub_id, questiontext)} 鍙兘鏈夊琛屾槑缁嗭紙澶氶�夐」 / 閲嶅鏄庣粏锛夛紝
+ * 瀵艰嚧銆屾湭绛旈浜烘暟 = 鍙戦�佷汉鏁� 鈭� 鏄庣粏琛屾暟銆嶅嚭鐜拌礋鏁帮紙瀹炴祴 -120锛夈��
+ * <p>
+ * 鈿狅笍 骞冲潎鍒� / 鏈�楂樺垎 / 鏈�浣庡垎 / 鍚勯�夐」鍗犳瘮浠嶄娇鐢ㄦ槑缁嗚鏁帮紙閭ｄ簺鍙ｅ緞鏈潵灏辨寜琛岃锛夛紝鏈敼鍔ㄣ��
+ * <p>
+ * 闄よ仛鍚堥敭涓� {@code distinct} 澶栵紝from/where 涓� {@link #selectSatisfactionFillStatByMatchedtext}
+ * 瀹屽叏涓�鑷达紝淇濊瘉涓よ�呯粺璁＄殑鏄悓涓�鎵规暟鎹��
+ *
+ * @param query 鑱氬悎鏌ヨ鏉′欢
+ * @return 姣忚鍚� libtemplateid銆乹uestiontext銆乧nt锛堜汉鏁帮級
+ */
+ List<Map<String, Object>> selectSatisfactionFillPersonCountByQuestion(SatisfactionStatQuery query);
+
// ================================================================ 鐪佺珛鍚屽痉锛氳秼鍔夸笌缁村害
/**
--
Gitblit v1.9.3