From b25c3b5188e402695f3792ad7da53e452682cd80 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期一, 12 十月 2026 19:43:07 +0800
Subject: [PATCH] 满意度统计BUG修改
---
ruoyi-satisfaction/src/main/java/com/ruoyi/satisfaction/mapper/SatisfactionMapper.java | 19 +++++++++++++++++++
1 files changed, 19 insertions(+), 0 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..073c9ef 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
@@ -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