From c24d16a37523a49080392610357872ce580cbc38 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期一, 26 十月 2026 14:03:33 +0800
Subject: [PATCH] 代码提交
---
ruoyi-satisfaction/src/main/java/com/ruoyi/satisfaction/mapper/SatisfactionMapper.java | 45 +++++++++++++++++++++++++++++++++++++++++++--
1 files changed, 43 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..268abc8 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銆�
@@ -57,6 +57,28 @@
*/
List<String> selectSatisfactionSubtaskTypes(PatSatisfactionReqVO patSatisfactionReqVO);
+ /**
+ * 婊℃剰搴︾粺璁★細鏈鏉′欢涓�<b>鐪熸涓嬪彂杩囦换鍔�</b>鐨勬ā鏉� id锛堝幓閲嶏級銆�
+ * <p>
+ * <b>涓轰粈涔堥渶瑕佸畠</b>锛歿@code /statistics} 鐨勯鐩潵婧愭槸
+ * {@code SatisfactionScriptMapper.querySvyScriptByCategory} / {@code queryIvrScriptByAssort}锛�
+ * 鍙寜銆屾弧鎰忓害鍒嗙被銆嶅彇搴撻噷鐨勫叏閮ㄩ鐩紝<b>涓嶇湅妯℃澘銆佷笉鐪嬫椂闂�</b>銆�
+ * 棰樺簱閲屾瘡澶氭寕杩涗竴濂楀巻鍙查棶鍗锋ā鏉匡紙棰樼洰杩樺湪銆佷絾浠庢潵娌′笅鍙戣繃浠诲姟锛夛紝
+ * 缁熻缁撴灉灏变細澶氬嚭涓�鏁存壒銆屽緱鍒� 0 / 绛旈浜烘暟 0銆嶇殑琛�
+ * 锛堝疄娴嬶細婊℃剰搴﹀垎绫讳笅 6 濂楁ā鏉� 69 閬撻锛屾湰鏈熷彧鏈� 2 濂� 25 閬撻鏈夋暟鎹級銆�
+ * <p>
+ * 杩欓噷鎸変笌 {@link #selectSatisfactionSubtaskTypes} <b>瀹屽叏鐩稿悓鐨勬潯浠�</b>
+ * 锛坥rgid銆乻erviceTypes銆佺瀹� OR 鐥呭尯銆佺闄㈢瀹� OR 鐥呭尯銆佹椂闂村厹搴曞彛寰勶級鍙栨ā鏉� id锛�
+ * 璋冪敤鏂规嵁姝ゆ妸棰樺簱棰樼洰瑁佸壀鎴愩�屾湰鏈熺湡姝ｅ湪鐢ㄧ殑妯℃澘銆嶏紝
+ * 浣胯繑鍥炶鏁板彧鐢卞綋鍓嶇敓鏁堢殑闂嵎鍐冲畾锛岃�屼笉鏄搴撳巻鍙茬Н绱��
+ *
+ * @param query 鏌ヨ鏉′欢锛堝鐢� {@link PatSatisfactionReqVO} 鐨勫瓧娈碉級
+ * @param type service_subtask.type锛�1 璇煶銆�2 闂嵎
+ * @return 鍘婚噸鍚庣殑 libtemplateid 鍒楄〃锛堝彲鑳戒负绌猴級
+ */
+ List<Long> selectSatisfactionActiveTemplateIds(@Param("q") PatSatisfactionReqVO query,
+ @Param("type") String type);
+
// ================================================================ 濉姤閲忕粺璁�
/**
@@ -85,6 +107,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