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 |   22 ++++++++++++++++++++++
 1 files changed, 22 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 34ce21d..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
@@ -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锛�
+     * 璋冪敤鏂规嵁姝ゆ妸棰樺簱棰樼洰瑁佸壀鎴愩�屾湰鏈熺湡姝e湪鐢ㄧ殑妯℃澘銆嶏紝
+     * 浣胯繑鍥炶鏁板彧鐢卞綋鍓嶇敓鏁堢殑闂嵎鍐冲畾锛岃�屼笉鏄搴撳巻鍙茬Н绱��
+     *
+     * @param query 鏌ヨ鏉′欢锛堝鐢� {@link PatSatisfactionReqVO} 鐨勫瓧娈碉級
+     * @param type  service_subtask.type锛�1 璇煶銆�2 闂嵎
+     * @return 鍘婚噸鍚庣殑 libtemplateid 鍒楄〃锛堝彲鑳戒负绌猴級
+     */
+    List<Long> selectSatisfactionActiveTemplateIds(@Param("q") PatSatisfactionReqVO query,
+                                                   @Param("type") String type);
+
     // ================================================================ 濉姤閲忕粺璁�
 
     /**

--
Gitblit v1.9.3