From 26d1f59f0266672398975ba0337bb3d8267c2d95 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期一, 12 十月 2026 15:36:52 +0800
Subject: [PATCH] 满意度扫码BUG修改

---
 smartor/src/main/java/com/smartor/mapper/ServiceSubtaskDetailTraceMapper.java |   36 +++++++++++++++++++++++++++++++++++-
 1 files changed, 35 insertions(+), 1 deletions(-)

diff --git a/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskDetailTraceMapper.java b/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskDetailTraceMapper.java
index cb7a2fa..a13006a 100644
--- a/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskDetailTraceMapper.java
+++ b/smartor/src/main/java/com/smartor/mapper/ServiceSubtaskDetailTraceMapper.java
@@ -1,10 +1,12 @@
 package com.smartor.mapper;
 
 import java.util.List;
+import java.util.Map;
 
 import com.smartor.domain.VO.DetailTraceDealVO;
 import com.smartor.domain.VO.ServiceSubtaskDetailTraceVO;
 import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
 import com.smartor.domain.ServiceSubtaskDetailTrace;
 
 /**
@@ -32,7 +34,39 @@
     public List<ServiceSubtaskDetailTrace> selectServiceSubtaskDetailTtraceList(ServiceSubtaskDetailTraceVO ServiceSubtaskDetailTtrace);
 
 
-    public List<ServiceSubtaskDetailTrace> tracedeallist(DetailTraceDealVO detailTraceDealVO);
+    /**
+     * 寮傚父闂澶勭悊鎯呭喌鏌ヨ锛氬綋鍓嶉〉鐨勯棶棰樺垎缁勮仛鍚堬紙涓�涓� SQL 鎷垮埌鏈〉姣忎釜闂鐨勫紓甯告暟銆佸凡澶勭悊/鏈鐞嗘暟锛�
+     * <p>
+     * 鍒嗛〉鎸夈�岄棶棰樸�嶇淮搴︿笅鎺紝涓嶅啀鎶婃暣琛� trace 鏄庣粏鎷夊洖 Java 鍐嶅垎缁�
+     *
+     * @param vo 鏌ヨ鏉′欢锛坧ageNum 涓� offset锛屼笌 PageUtils.getOffset 涓�鑷达級
+     * @return 姣忚鍚� questiontext銆乻criptid銆乼emplateType銆乪xceptionFillNum銆亂esDeal銆乶oDeal
+     */
+    public List<Map<String, Object>> selectTraceDealGroups(@Param("vo") DetailTraceDealVO vo);
+
+    /**
+     * 寮傚父闂澶勭悊鎯呭喌鏌ヨ锛氶棶棰樻�绘暟锛堝垎椤� total锛屾寜 questiontext 鍘婚噸锛�
+     */
+    public long countTraceDealQuestions(@Param("vo") DetailTraceDealVO vo);
+
+    /**
+     * 寮傚父闂澶勭悊鎯呭喌鏌ヨ锛氬叏閲忔眹鎬伙紙涓嶅彈鍒嗛〉褰卞搷锛�
+     *
+     * @return totalException 寮傚父鎬绘暟銆亂esDeal 宸插鐞嗘暟
+     */
+    public Map<String, Object> sumTraceDeal(@Param("vo") DetailTraceDealVO vo);
+
+    /**
+     * 寮傚父闂澶勭悊鎯呭喌鏌ヨ锛氬綋鍓嶉〉闂鐨勮礋璐g瀹わ紙鎸� todeptcode 鍘婚噸锛�
+     */
+    public List<Map<String, Object>> selectTraceDealDepts(@Param("vo") DetailTraceDealVO vo,
+                                                         @Param("questiontexts") List<String> questiontexts);
+
+    /**
+     * 寮傚父闂澶勭悊鎯呭喌鏌ヨ锛氬綋鍓嶉〉闂鐨勬渶鏂板鐞嗕汉鍜屽鐞嗘椂闂达紙handle_time 鏈�澶х殑涓�鏉★級
+     */
+    public List<Map<String, Object>> selectTraceDealLatestHandle(@Param("vo") DetailTraceDealVO vo,
+                                                                @Param("questiontexts") List<String> questiontexts);
 
     /**
      * 鏂板闅忚浠诲姟寮傚父璁板綍璺熻釜

--
Gitblit v1.9.3