From 87b79ea739ec32bd7d0e493a6ea8525212f6c763 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期六, 10 十月 2026 15:11:17 +0800
Subject: [PATCH] Merge remote-tracking branch 'origin/master' into smartor_ls_261008

---
 smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java | 1074 ++++++++++++++++++++++++++++++++++++++++++++++++++++-------
 1 files changed, 942 insertions(+), 132 deletions(-)

diff --git a/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java
index ade1e54..90c007a 100644
--- a/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java
@@ -9,20 +9,23 @@
 import com.ruoyi.common.core.domain.entity.SysDept;
 import com.ruoyi.common.core.redis.RedisCache;
 import com.ruoyi.common.core.service.IConfigService;
-import com.ruoyi.common.dx.MessageSend;
+import com.ruoyi.message.sms.provider.sltd.ws.MessageSend;
 import com.ruoyi.common.exception.base.BaseException;
 import com.ruoyi.common.utils.*;
 import com.ruoyi.common.utils.http.HttpUtils;
 import com.ruoyi.common.utils.spring.SpringUtils;
+import com.ruoyi.message.SendResult;
+import com.ruoyi.message.sms.SmsSendRequest;
+import com.ruoyi.message.sms.SmsSenderFactory;
+import com.ruoyi.message.wechat.WechatSendRequest;
+import com.ruoyi.message.wechat.WechatSenderFactory;
 import com.ruoyi.system.domain.SysConfig;
 import com.ruoyi.system.mapper.SysConfigMapper;
 import com.ruoyi.system.service.ISysConfigService;
 import com.smartor.common.FtpService;
-import com.smartor.common.MtSubmitSmUtil;
 import com.smartor.common.ScheduleSubtaskBuilder;
 import com.smartor.config.PhoneUtils;
-import com.smartor.domain.DTO.QuestionCountKsOrBqDTO;
-import com.smartor.domain.DTO.ServiceSubtaskDetailDTO;
+import com.smartor.domain.DTO.*;
 import com.smartor.domain.*;
 import com.smartor.domain.VO.*;
 import com.smartor.domain.entity.ServiceSubtaskEntity;
@@ -44,6 +47,9 @@
 
 import java.math.BigDecimal;
 import java.math.RoundingMode;
+import java.net.URLEncoder;
+import java.nio.charset.StandardCharsets;
+import java.security.MessageDigest;
 import java.text.DecimalFormat;
 import java.text.SimpleDateFormat;
 import java.time.*;
@@ -54,6 +60,8 @@
 import java.util.regex.Matcher;
 import java.util.regex.Pattern;
 import java.util.stream.Collectors;
+
+import static cn.hutool.core.convert.Convert.toHex;
 
 /**
  * 鍗曚竴浠诲姟锛堥殢璁匡級Service涓氬姟灞傚鐞�
@@ -160,10 +168,16 @@
     private ISysConfigService configService;
 
     @Autowired
-    private MtSubmitSmUtil mtSubmitSmUtil;
+    private SysConfigMapper sysConfigMapper;
+
+    /**
+     * 娑堟伅鍙戦�佹柟宸ュ巶锛堢煭淇�/寰俊鍏紬鍙凤級锛屾浛浠e師鏉ョ洿鎺ヨ皟鐢ㄥ悇绔欑偣鍙戦�佷唬鐮佺殑鍐欐硶
+     */
+    @Autowired
+    private SmsSenderFactory smsSenderFactory;
 
     @Autowired
-    private SysConfigMapper sysConfigMapper;
+    private WechatSenderFactory wechatSenderFactory;
 
     @Autowired
     private RedisTemplate redisTemplate;
@@ -186,9 +200,6 @@
     @Value("${req_path}")
     private String req_path;
 
-    @Value("${xhsmsPath}")
-    private String xhsmsPath;
-
     @Value("${phoneUpEveryHour}")
     private Integer phoneUpEveryHour;
     @Value("${phoneEndHour}")
@@ -206,6 +217,8 @@
     private ServiceOutPathMapper serviceOutPathMapper;
 
     private static final String KEY_SEP = "\u0001";
+    @Autowired
+    private PatMedOperationItemMapper patMedOperationItemMapper;
 
     /**
      * 鏌ヨ鍗曚竴浠诲姟锛堥殢璁匡級
@@ -628,6 +641,43 @@
     }
 
     /**
+     * 缁熻浠诲姟鍚勭鐘舵�佺殑鏁伴噺锛堝凡浼樺寲锛�
+     * 浼樺寲璇存槑锛�
+     * 1. 浣跨敤鏁版嵁搴撳眰鑱氬悎璁$畻锛屾浛浠e簲鐢ㄥ眰閬嶅巻
+     * 2. 鎬ц兘鎻愬崌 10-100 鍊嶏紙鍙栧喅浜庢暟鎹噺锛�
+     * 3. 闄嶄綆鍐呭瓨鍗犵敤鍜岀綉缁滀紶杈�
+     *
+     * @param serviceSubtaskEntity 鏌ヨ鏉′欢
+     * @return 鍚勭姸鎬佺粺璁$粨鏋�
+     */
+    @Override
+    public Map<String, Object> countByCondition(ServiceSubtaskEntity serviceSubtaskEntity) {
+        // 鐩存帴璋冪敤鏁版嵁搴撶粺璁℃柟娉曪紝鍦ㄦ暟鎹簱灞傚畬鎴愯仛鍚堣绠�
+        Map<String, Object> result = serviceSubtaskMapper.countByCondition(serviceSubtaskEntity);
+        // 澶勭悊绌哄紓甯�
+        if (MapUtils.isEmpty(result)) {
+            result = new HashMap<>();
+            // 纭繚鎵�鏈� key 閮芥湁鍊硷紝閬垮厤绌烘寚閽堝紓甯�
+            // MyBatis 鐨� SUM 鍦ㄦ病鏈夊尮閰嶈鏃朵細杩斿洖 null
+            result.putIfAbsent("wzx", 0);
+            result.putIfAbsent("ysf", 0);
+            result.putIfAbsent("fssb", 0);
+            result.putIfAbsent("yfs", 0);
+            result.putIfAbsent("blq", 0);
+            result.putIfAbsent("total", 0);
+            result.putIfAbsent("wxsf", 0);
+            result.putIfAbsent("xsf", 0);
+            result.putIfAbsent("dsf", 0);
+            result.putIfAbsent("dfs", 0);
+            result.putIfAbsent("yfs", 0);
+            result.putIfAbsent("ywc", 0);
+            result.putIfAbsent("yc", 0);
+            result.putIfAbsent("jg", 0);
+        }
+        return result;
+    }
+
+    /**
      * 鏂板鍗曚竴浠诲姟锛堥殢璁匡級
      *
      * @param serviceSubtask 鍗曚竴浠诲姟锛堥殢璁匡級
@@ -783,6 +833,7 @@
         serviceSubtask.setUpdateTime(DateUtils.getNowDate());
         if (serviceSubtask.getSendstate() != null && serviceSubtask.getSendstate() == 6)
             serviceSubtask.setFinishtime(new Date());
+
         return serviceSubtaskMapper.updateServiceSubtask(serviceSubtask);
     }
 
@@ -1051,8 +1102,8 @@
             //灏嗕换鍔′俊鎭斁鍒版湇鍔¤〃涓�
             ServiceSubtask serviceSubtask = DtoConversionUtils.sourceToTarget(serviceTaskVO, ServiceSubtask.class);
             serviceSubtask.setTaskid(serviceTask.getTaskid().longValue());
-            serviceSubtask.setTemplatename(tempName);
-            serviceSubtask.setTemplateid(tempid);
+            serviceSubtask.setTemplatename(ObjectUtils.isNotEmpty(tempid) ? tempName : serviceTask.getTemplatename());
+            serviceSubtask.setTemplateid(ObjectUtils.isNotEmpty(tempid) ? tempid : serviceTask.getTemplateid());
             serviceSubtask.setLibtemplateid(ObjectUtils.isEmpty(serviceTask.getLibtemplateid()) ? null : Long.valueOf(serviceTask.getLibtemplateid()));
             serviceSubtask.setLibtemplatename(serviceTask.getLibtemplatename());
             //鏂板
@@ -1163,7 +1214,7 @@
                     redisCache.removeElementFromList("cache-3", serviceSubtask.getId().toString());
                     redisCache.removeElementFromList("cache-4", serviceSubtask.getId().toString());
                     //灏嗗嚭鍏ラ櫌琛ㄧ殑鏁版嵁锛岃繕鍘熸垚杩樻湭澶勭悊鐨勭姸鎬�
-                    if (serviceSubtask.getServiceType().equals("2")) {
+                    if (serviceSubtask.getServiceType().equals("2") || serviceSubtask.getServiceType().equals("13")) {
                         ServiceTask st = serviceTaskService.selectServiceTaskByTaskid(serviceSubtask.getTaskid());
                         //濡傛灉浠诲姟鏄暱鏈熶换鍔★紝闇�瑕佸皢璇ユ偅鑰呯殑鍑哄叆闄㈡暟鎹繕鍘熸垚杩樻湭澶勭悊鐨勭姸鎬�
                         if (st != null && st.getLongTask() == 1) {
@@ -1184,6 +1235,16 @@
                                 patMedOuthosp.setServerState("0");
                                 patMedOuthospService.updatePatMedOuthosp(patMedOuthosp);
                             }
+                        }
+                    } else if (serviceSubtask.getServiceType().equals("19")) {
+                        ServiceTask st = serviceTaskService.selectServiceTaskByTaskid(serviceSubtask.getTaskid());
+                        //濡傛灉浠诲姟鏄暱鏈熶换鍔★紝闇�瑕佸皢璇ユ偅鑰呯殑鍑洪櫌璇︽儏鐘舵�佽繕鍘熸垚杩樻湭澶勭悊鐨勭姸鎬�
+                        if (st != null && st.getLongTask() == 1
+                                && ObjectUtils.isNotEmpty(serviceSubtask.getOperationItemId())) {
+                            PatMedOperationItem patMedOperationItem = new PatMedOperationItem();
+                            patMedOperationItem.setOpercheckFlag("0");
+                            patMedOperationItem.setId(serviceSubtask.getOperationItemId());
+                            patMedOperationItemMapper.updatePatMedOperationItem(patMedOperationItem);
                         }
                     }
                 }
@@ -1417,6 +1478,8 @@
                     ServiceSubtask serviceSubtask = DtoConversionUtils.sourceToTarget(serviceTaskVO, ServiceSubtask.class);
                     serviceSubtask.setLibtemplateid(ObjectUtils.isEmpty(serviceTaskVO.getLibtemplateid()) ? null : Long.valueOf(serviceTaskVO.getLibtemplateid()));
                     serviceSubtask.setLibtemplatename(serviceTaskVO.getLibtemplatename());
+                    serviceSubtask.setTemplateid(serviceTask.getTemplateid());
+                    serviceSubtask.setTemplatename(serviceTask.getTemplatename());
                     serviceSubtask.setSendname(patTaskRelevance.getName());
                     serviceSubtask.setAge(patTaskRelevance.getAge());
                     serviceSubtask.setSfzh(patTaskRelevance.getSfzh());
@@ -2878,7 +2941,7 @@
      * @return
      */
     @Override
-    @Cacheable(value = "sfStatistics", key = "T(org.springframework.util.DigestUtils).md5DigestAsHex(#serviceSubtaskCountReq.toString().getBytes())", unless = "#result == null or #result.isEmpty()")
+//    @Cacheable(value = "sfStatistics", key = "T(org.springframework.util.DigestUtils).md5DigestAsHex(#serviceSubtaskCountReq.toString().getBytes())", unless = "#result == null or #result.isEmpty()")
     public List<ServiceSubtaskStatistic> getSfStatistics(ServiceSubtaskCountReq serviceSubtaskCountReq) {
         log.info("getSfStatistics鐨勫叆鍙備负锛歿}", serviceSubtaskCountReq);
         String drcode = "drcode";
@@ -3000,6 +3063,8 @@
         ssRate.setOrgid(serviceSubtaskCountReq.getOrgid());
         ssRate.setStarttime(serviceSubtaskCountReq.getStartTime());
         ssRate.setEndtime(serviceSubtaskCountReq.getEndTime());
+        ssRate.setStartOutHospTime(serviceSubtaskCountReq.getHospitalStartTime());
+        ssRate.setEndOutHospTime(serviceSubtaskCountReq.getHospitalEndTime());
         ssRate.setVisitCount(serviceSubtaskCountReq.getVisitCount());
         ssRate.setServiceTypeList(serviceSubtaskCountReq.getServiceType());
         if (serviceSubtaskCountReq.getEndTime() != null && new Date().before(serviceSubtaskCountReq.getEndTime())) {
@@ -3091,6 +3156,8 @@
             if (serviceSubtaskCountReq.getEndTime() != null && new Date().before(serviceSubtaskCountReq.getEndTime())) {
                 ss.setEndtime(new Date());
             }
+            ss.setStartOutHospTime(serviceSubtaskCountReq.getHospitalStartTime());
+            ss.setEndOutHospTime(serviceSubtaskCountReq.getHospitalEndTime());
             Double jsRate = serviceSubtaskMapper.selectTimelyRate(ss);
             statistic.setRate(jsRate);
             if (ObjectUtils.isNotEmpty(statistic)) {
@@ -4156,10 +4223,8 @@
         serviceOutPath.setUpdateTime(new Date());
         serviceOutPath.setUrl(url);
         iServiceOutPathService.updateServiceOutPath(serviceOutPath);
-        Map<String, String> map = new HashMap<>();
-        map.put("phone", serviceSubtask.getPhone());
-        map.put("content", sendMagParam.getContent());
-        HttpUtil.postJsonRequest(xhsmsPath, new Gson().toJson(map));
+        //鐭俊鍙戦�佸凡鏀跺彛鍒� ruoyi-message 妯″潡锛涗笌鍘熷疄鐜颁竴鑷达細涓嶅垽鏂彂閫佺粨鏋�
+        smsSenderFactory.send(active, SmsSendRequest.of(serviceSubtask.getPhone(), sendMagParam.getContent(), serviceSubtask.getOrgid()));
         redisCache.setCacheObject(subTaskId + "recordAccept-hungup", "1", 10, TimeUnit.MINUTES);
         if (StringUtils.isNotEmpty(serviceSubtask.getRemark()))
             serviceSubtask.setRemark("鐢佃瘽鍙戦�佹嫆鎺�,鐭俊琛ュ伩鍙戦�佹垚鍔�");
@@ -5079,6 +5144,12 @@
         String subId = rsaPublicKeyExample.encryptedData(serviceSubtask.getId().toString(), pub_key);
         String taskId = rsaPublicKeyExample.encryptedData(serviceSubtask.getTaskid().toString(), pub_key);
 
+        //涓芥按涓尰闄㈠彂閫佺殑鏄井淇″叕浼楀彿
+        if (StringUtils.isNotEmpty(serviceSubtask.getOrgid()) && serviceSubtask.getOrgid().equals("47231022633110211A2101")) {
+            resultMap = wechatSubTask(subid);
+            return resultMap;
+        }
+
         //鍙戦�佹暟鎹殑灏佽
         ServiceOutPath serviceOutPath = new ServiceOutPath();
         serviceOutPath.setParam1(taskId);
@@ -5109,9 +5180,11 @@
             sendMagParam.setContent(smsContemt.replace("${wjurl}", sendMagParam.getUrl()));
         }
 
+        //鐭俊鍙戦�侊細鍚勭珯鐐瑰鎺ユ柟寮忓樊寮傝緝澶э紝宸叉敹鍙e埌 ruoyi-message 妯″潡
         if (active.equals("nhfy")) {
-            Map<String, Object> smsResult = mtSubmitSmUtil.submitSm(sendMagParam.getPhone(), sendMagParam.getContent());
-            if (smsResult != null && smsResult.get("result") != null && smsResult.get("result").toString().equals("0")) {
+            SendResult smsResult = smsSenderFactory.send(active,
+                    SmsSendRequest.of(sendMagParam.getPhone(), sendMagParam.getContent(), serviceSubtask.getOrgid()));
+            if (smsResult.isOk()) {
                 resultMap.put("code", "200");
                 resultMap.put("msg", "鍙戦�佹垚鍔�");
                 serviceSubtask.setRemark(StringUtils.isNotEmpty(serviceSubtask.getRemark()) ? serviceSubtask.getRemark() + ";鐭俊鍙戦�佹垚鍔�(鎵嬪姩鎻愪氦)" : "鐭俊鍙戦�佹垚鍔�(鎵嬪姩鎻愪氦)");
@@ -5123,14 +5196,88 @@
         return resultMap;
     }
 
+    public Map<String,Object> wechatSubTask(Long subid){
+        log.info("wechatSubTask鐨勫叆鍙備负锛歿}", subid);
+        Map<String, Object> resultMap = new HashMap<>();
+        resultMap.put("code", "500");
+        resultMap.put("msg", "鍙戦�佸け璐�");
+        try{
+            //鑾峰彇闅忚鐨勫熀鏈俊鎭�
+            ServiceSubtask serviceSubtask = selectServiceSubtaskById(subid);
+            //鑾峰彇鎮h�呬俊鎭�
+            PatArchive patArchive = patArchiveMapper.selectPatArchiveByPatid(serviceSubtask.getPatid());
+
+            RSAPublicKeyExample rsaPublicKeyExample = new RSAPublicKeyExample();
+            String patid = rsaPublicKeyExample.encryptedData(serviceSubtask.getPatid().toString(), pub_key);
+            String subId = rsaPublicKeyExample.encryptedData(serviceSubtask.getId().toString(), pub_key);
+            String taskId = rsaPublicKeyExample.encryptedData(serviceSubtask.getTaskid().toString(), pub_key);
+            String url = localIP + ":" + req_path + "/outsideChainwt?param1=" + taskId + "&param2=" + patid + "&param3="
+                    + URLEncoder.encode(serviceSubtask.getTaskName(), StandardCharsets.UTF_8.toString()) + "&param5=false"
+                    + "$param6=" + subId;
+
+            ServiceOutPath serviceOutPath = new ServiceOutPath();
+            serviceOutPath.setParam1(taskId);
+            serviceOutPath.setParam2(patid);
+            serviceOutPath.setParam3(serviceSubtask.getTaskName());
+            serviceOutPath.setParam6(subId);
+            serviceOutPath.setCreateTime(new Date());
+            serviceOutPath.setOrgid(serviceSubtask.getOrgid());
+            iServiceOutPathService.insertServiceOutPath(serviceOutPath);
+            String format = String.format("%03X", serviceOutPath.getId());
+            serviceOutPath.setRadix(format);
+            serviceOutPath.setUpdateTime(new Date());
+            serviceOutPath.setUrl(url);
+            iServiceOutPathService.updateServiceOutPath(serviceOutPath);
+
+
+            //his鎮h�卛d鏍¢獙锛堜笌鍘熷疄鐜颁竴鑷达細鍏堟牎楠岃繖涓�椤癸級
+            if (StringUtils.isEmpty(serviceSubtask.getPatidHis())) {
+                resultMap.put("code", -1);
+                resultMap.put("message", "鍙戦�佸紓甯革細" + "銆愬叕浼楀彿銆戝叕浼楀彿鍙戦�佸け璐�,his绯荤粺鐨勬偅鑰卛d涓虹┖");
+                return resultMap;
+            }
+
+            //鏈烘瀯閰嶇疆鏍¢獙銆佹姤鏂囩鍚嶄笌杩斿洖鍒ゅ畾鍧囧凡鏀跺彛鍒� ruoyi-message 鐨勫彂閫佹柟瀹炵幇
+            WechatSendRequest wechatRequest = new WechatSendRequest();
+            wechatRequest.setOrgid(serviceSubtask.getOrgid());
+            wechatRequest.setIdCard(serviceSubtask.getSfzh());
+            wechatRequest.setUrl(url);
+            wechatRequest.setTitle(serviceSubtask.getTaskName());
+            wechatRequest.setContent(serviceSubtask.getTaskDesc());
+            wechatRequest.setPhone(patArchive.getTelcode());
+            wechatRequest.setPatientName(serviceSubtask.getSendname());
+            wechatRequest.setPatidHis(patArchive.getPatidHis());
+            SendResult wechatResult = wechatSenderFactory.send(active, wechatRequest);
+
+            //鍙戦�佸畬鎴愬悗锛屼慨鏀圭姸鎬�
+            serviceSubtask.setSendstate(3L);
+            if (wechatResult.isOk()) {
+                serviceSubtask.setResult("success");
+                resultMap.put("code", "200");
+                resultMap.put("msg", "鍙戦�佹垚鍔�");
+            } else {
+                log.error("銆恠fHandlle銆戝叕浼楀彿鍙戦�佸け璐ワ紝鎮h�呬俊鎭細{}锛岄敊璇俊鎭細{}", serviceSubtask, wechatResult.getMessage());
+                resultMap.put("code", -1);
+                resultMap.put("message", "銆愬叕浼楀彿銆戝叕浼楀彿鍙戦�佸け璐�");
+                return resultMap;
+            }
+        } catch (Exception e) {
+            String guid = UUID.randomUUID().toString();
+            log.error("銆恠fHandlle銆戦暱鏈熶换鍔″叕浼楀彿鍙戦�佸け璐ワ紝鍘熷洜锛歿}锛孏UID锛歿}", e.getMessage(), guid);
+            resultMap.put("code", -1);
+            resultMap.put("message", "銆愬叕浼楀彿銆戦暱鏈熶换鍔″叕浼楀彿鍙戦�佸け璐ワ紝鍘熷洜锛�" + e.getMessage());
+            return resultMap;
+        }
+        return resultMap;
+    }
     @Override
-    public List<ServiceSubtaskDetailRatioExport> statQuestionOption(List<Long> taskIds, Date startOutHospTime, Date endOutHospTime, String scriptContent, Double scoreStart, Double scoreEnd, String valueType) {
+    public List<ServiceSubtaskDetailRatioExport> statQuestionOption(List<Long> taskIds, Date startFinishTime, Date endFinishTime, Date startOutHospTime, Date endOutHospTime, String scriptContent, Double scoreStart, Double scoreEnd, String valueType, List<Long> subtaskIds) {
         //鍏堟竻鐞嗕竴涓嬮噸澶嶆暟鎹�
         List<Long> repeatIds = serviceSubtaskDetailMapper.selectRepeatDetailIds();
         if (!CollectionUtils.isEmpty(repeatIds)) {
             serviceSubtaskDetailMapper.deleteRepeatDetailByIds(repeatIds);
         }
-        List<ServiceSubtaskDetailRatioExport> serviceSubtaskDetailRatioExports = serviceSubtaskMapper.statQuestionOption(taskIds, startOutHospTime, endOutHospTime, scoreStart, scoreEnd, scriptContent, valueType);
+        List<ServiceSubtaskDetailRatioExport> serviceSubtaskDetailRatioExports = serviceSubtaskMapper.statQuestionOption(taskIds, startOutHospTime, endOutHospTime, startFinishTime, endFinishTime, scoreStart, scoreEnd, scriptContent, valueType, subtaskIds);
 
         // 澶勭悊 targetvalue锛氭寜 & 鍒嗗壊鎴愬鏉¤褰�
         List<ServiceSubtaskDetailRatioExport> result = new ArrayList<>();
@@ -5140,7 +5287,9 @@
                 // 濡傛灉鏈夊鏉$洰鏍囧�硷紝鎷嗗垎鎴愬琛�
                 for (String value : values) {
                     //鍏堝幓 result 涓煡涓�涓嬶紝鏈夋病鏈夎繖涓� questiontext 鍜屽搴旂殑 targetvalue
-                    ServiceSubtaskDetailRatioExport existingExport = result.stream().filter(e -> e.getQuestiontext().equals(export.getQuestiontext()) && value.trim().equals(e.getTargetvalue())).findFirst().orElse(null);
+                    //娉ㄦ剰蹇呴』甯︿笂 taskid 涓�璧峰尮閰嶏細鍚﹀垯浼氭妸鍒殑浠诲姟鐨勬暟鎹~鍒版湰浠诲姟鐨勮涓婏紝
+                    //瀵艰嚧瀵煎嚭鐨勩�屾暟閲�/姣斾緥銆嶅拰璇ヨ鐨勩�屼换鍔″悕绉�/浠诲姟缂栧彿銆嶅涓嶄笂锛堝悓涓�浠诲姟鍚屼竴棰樺嚭鐜颁袱涓笉鍚屽垎姣嶏級
+                    ServiceSubtaskDetailRatioExport existingExport = result.stream().filter(e -> Objects.equals(e.getTaskid(), export.getTaskid()) && e.getQuestiontext().equals(export.getQuestiontext()) && value.trim().equals(e.getTargetvalue())).findFirst().orElse(null);
                     if (existingExport != null && existingExport.getRatio().equals("0") && existingExport.getCount().equals("0")) {
                         //濡傛灉瀛樺湪锛屽垯灏� result 閲岀殑杩欎釜闂鎵�瀵瑰簲鐨� Targetvalue=value 杩欐潯鏁版嵁鏇存柊鎴愬綋鍓嶈繖鏉℃暟鎹�
                         if (value.equals(export.getOptionresult())) {
@@ -5171,138 +5320,381 @@
         return result;
     }
 
+    @Override
+    public List<ServiceSubtaskDetailRatioExport> statMydQuestionOptionForExport(List<Long> subtaskIds, String questiontext) {
+        List<ServiceSubtaskDetailRatioExport> result = new ArrayList<>();
+        if (CollectionUtils.isEmpty(subtaskIds)) {
+            return result;
+        }
+        List<ServiceSubtaskOptionStatDTO> statList = serviceSubtaskMapper.statMydQuestionOptionForExport(subtaskIds, questiontext);
+        if (CollectionUtils.isEmpty(statList)) {
+            return result;
+        }
+        return buildMydOptionRows(statList);
+    }
+
+    /**
+     * 鎶娿�屼换鍔�+棰樼洰+閫夐」銆嶇殑浣滅瓟缁熻鎷兼垚瀵煎嚭鐨勩�岄棶棰樿鎯呭崰姣斻�嶈
+     * <ul>
+     *     <li>閫夐」娓呭崟锛氶鐩厤缃繃鐨勯�夐」鍦� targetvalue锛堢敤 & 杩炴帴锛夐噷锛屽叏閮ㄥ垪鍑猴紝娌′汉閫夌殑鏄剧ず 0</li>
+     *     <li>鏁伴噺锛氭偅鑰呴�変腑鐨勯�夐」鍦� asrtext 閲岋紙澶氶�夐鏄�孉&B銆嶏級锛屾瘡涓�変腑椤瑰悇璁颁竴娆′汉鏁帮紝涓�涓偅鑰呭彧绠椾竴鏉℃槑缁�</li>
+     *     <li>姣斾緥锛氭暟閲� / 璇ラ浣滅瓟鎮h�呮暟锛屾墍浠ュ崟閫夐鍚勯�夐」鏁伴噺涔嬪拰 = 璇ラ浣滅瓟鎮h�呮暟</li>
+     *     <li>鍒嗘暟锛氳閫夐」鏄庣粏鐨� score 涔嬪拰锛涘閫夎鎸夐�変腑椤逛唤鏁板潎鍒嗭紝淇濊瘉鍚勯�夐」鍒嗘暟涔嬪拰 = 鏄庣粏鍒嗘暟涔嬪拰</li>
+     * </ul>
+     */
+    private static List<ServiceSubtaskDetailRatioExport> buildMydOptionRows(List<ServiceSubtaskOptionStatDTO> statList) {
+        List<ServiceSubtaskDetailRatioExport> result = new ArrayList<>();
+
+        // 鎸夈�屼换鍔� + 棰樼洰銆嶅垎缁勶紝淇濇寔 SQL 鐨勯『搴忥紙鍏堥鐩悗浠诲姟锛�
+        Map<String, List<ServiceSubtaskOptionStatDTO>> grouped = new LinkedHashMap<>();
+        for (ServiceSubtaskOptionStatDTO stat : statList) {
+            String key = stat.getTaskid() + "\u0001" + stat.getQuestiontext();
+            grouped.computeIfAbsent(key, k -> new ArrayList<>()).add(stat);
+        }
+
+        for (List<ServiceSubtaskOptionStatDTO> group : grouped.values()) {
+            ServiceSubtaskOptionStatDTO first = group.get(0);
+            // 閫夐」 -> 浜烘暟锛坙ong[1] 渚夸簬绱姞锛夛紝椤哄簭鍗冲嚭鐜伴『搴�
+            Map<String, long[]> countMap = new LinkedHashMap<>();
+            Map<String, BigDecimal> scoreMap = new LinkedHashMap<>();
+
+            for (ServiceSubtaskOptionStatDTO stat : group) {
+                // targetvalue = 鏈鎵�鏈夐�夐」鐨勬竻鍗曪紝娌′汉閫夌殑涔熻鍒楀嚭鏉�
+                List<String> options = splitOptions(stat.getTargetvalue());
+                // asrtext = 鎮h�呭疄闄呴�変腑鐨勯�夐」锛屽閫夐浼氭槸銆岄�変腑椤�1&閫変腑椤�2銆�
+                List<String> chosenOptions = splitOptions(stat.getOptionresult());
+                for (String option : options) {
+                    countMap.computeIfAbsent(option, k -> new long[1]);
+                    scoreMap.computeIfAbsent(option, k -> BigDecimal.ZERO);
+                }
+
+                long patientCount = stat.getPatientCount() == null ? 0L : stat.getPatientCount();
+                BigDecimal scoreSum = stat.getScoreSum() == null ? BigDecimal.ZERO : stat.getScoreSum();
+
+                if (!chosenOptions.isEmpty()) {
+                    BigDecimal[] scoreParts = splitScore(scoreSum, chosenOptions.size());
+                    for (int i = 0; i < chosenOptions.size(); i++) {
+                        String chosen = chosenOptions.get(i);
+                        // 閫変腑鐨勯�夐」鍙兘涓嶅湪閰嶇疆娓呭崟閲岋紙鍘嗗彶鏁版嵁锛夛紝琛ヤ竴琛�
+                        countMap.computeIfAbsent(chosen, k -> new long[1]);
+                        scoreMap.computeIfAbsent(chosen, k -> BigDecimal.ZERO);
+                        countMap.get(chosen)[0] += patientCount;
+                        scoreMap.put(chosen, scoreMap.get(chosen).add(scoreParts[i]));
+                    }
+                } else if (options.size() == 1) {
+                    // 娌℃湁 asrtext锛堟湭绛�/鏃犲簲绛旓級鏃讹紝鍙湁鍞竴閫夐」鎵嶈兘纭畾褰掑睘
+                    countMap.get(options.get(0))[0] += patientCount;
+                    scoreMap.put(options.get(0), scoreMap.get(options.get(0)).add(scoreSum));
+                }
+            }
+
+            long total = 0L;
+            for (long[] count : countMap.values()) total += count[0];
+
+            for (Map.Entry<String, long[]> entry : countMap.entrySet()) {
+                long count = entry.getValue()[0];
+                ServiceSubtaskDetailRatioExport row = new ServiceSubtaskDetailRatioExport();
+                row.setQuestiontext(first.getQuestiontext());
+                row.setOptionresult(entry.getKey());
+                row.setTargetvalue(entry.getKey());
+                row.setCount(String.valueOf(count));
+                row.setRatio(formatRatio(count, total));
+                row.setScore(formatScore(scoreMap.get(entry.getKey())));
+                row.setTaskname(first.getTaskName());
+                row.setTaskid(first.getTaskid());
+                row.setValueType(first.getValueType());
+                result.add(row);
+            }
+        }
+        return result;
+    }
+
+    /**
+     * 鎶婁竴鏉℃槑缁嗙殑鍒嗘暟鎸夐�変腑椤逛唤鏁板潎鍒嗭紝浣欐暟琛ョ粰绗竴涓紝淇濊瘉鍚勪唤涔嬪拰 = 鍘熷垎鏁�
+     */
+    private static BigDecimal[] splitScore(BigDecimal total, int parts) {
+        BigDecimal[] result = new BigDecimal[parts];
+        if (parts <= 0) {
+            return result;
+        }
+        BigDecimal each = total.divide(BigDecimal.valueOf(parts), 2, RoundingMode.HALF_UP);
+        for (int i = 0; i < parts; i++) {
+            result[i] = each;
+        }
+        result[0] = result[0].add(total.subtract(each.multiply(BigDecimal.valueOf(parts))));
+        return result;
+    }
+
+    /**
+     * 鎷嗗垎棰樼洰閰嶇疆鐨勯�夐」锛堝涓�夐」鐢� & 杩炴帴锛夛紝椤哄甫鍘绘帀鍏ㄨ/鍗婅绌虹櫧
+     */
+    private static List<String> splitOptions(String targetvalue) {
+        List<String> options = new ArrayList<>();
+        if (StringUtils.isEmpty(targetvalue)) {
+            return options;
+        }
+        for (String part : targetvalue.split("&")) {
+            String option = trimAll(part);
+            if (StringUtils.isNotEmpty(option) && !options.contains(option)) {
+                options.add(option);
+            }
+        }
+        return options;
+    }
+
+    /**
+     * 姣斾緥锛氭暟閲� / 璇ラ浣滅瓟鎮h�呮暟锛屼繚鐣欎袱浣嶅皬鏁�
+     */
+    private static String formatRatio(long count, long total) {
+        if (total <= 0) {
+            return "0.00%";
+        }
+        return BigDecimal.valueOf(count * 100.0 / total).setScale(2, RoundingMode.HALF_UP).toPlainString() + "%";
+    }
+
+    /**
+     * 鍒嗘暟涔嬪拰锛氬幓鎺夊浣欑殑灏忔暟浣嶏紙0.00 -> 0锛�
+     */
+    private static String formatScore(BigDecimal score) {
+        if (score == null) {
+            return "0";
+        }
+        BigDecimal value = score.stripTrailingZeros();
+        if (value.scale() < 0) {
+            value = value.setScale(0);
+        }
+        return value.toPlainString();
+    }
+
     /*
      * 鏍规嵁绉戝鎴栫梾鍖虹粺璁¢棶鍗烽�夐」(绉戝銆侀鐩煡璇㈢殑绉戝璇勫垎琛�)
      */
     @Override
-    public List<QuestionCountKsOrBqDTO> statQuestionOptionByKsOrBq(QuestionCountKsOrBqVO vo) {
+    public Map<String, Map<String, List<QuestionCountKsOrBqDTO>>> statQuestionOptionByKsOrBq(QuestionCountKsOrBqVO vo) {
+
+        // 1. 鏌ユ槑缁�
         List<QuestionCountKsOrBqDTO> sourceList = serviceSubtaskMapper.statQuestionOptionByKsOrBq(vo);
         if (CollectionUtils.isEmpty(sourceList)) {
-            return Collections.emptyList();
+            return Collections.emptyMap();
         }
 
+        // 2. 鍒ゆ柇鎸夌瀹よ繕鏄寜鐥呭尯
         boolean byDept = vo.getLeaveldeptcodes() != null;
         boolean byDistrict = !byDept && vo.getLeavehospitaldistrictcodes() != null;
         if (!byDept && !byDistrict) {
-            return Collections.emptyList();
+            return Collections.emptyMap();
         }
 
+        // 3. key = 绉戝/鐥呭尯 + 棰樼洰 + 閫夐」
         Map<String, QuestionCountKsOrBqDTO> map = new LinkedHashMap<>();
 
         for (QuestionCountKsOrBqDTO dto : sourceList) {
+
             if (StringUtils.isEmpty(dto.getTargetvalue())) {
                 continue;
             }
 
+            // 鍒嗙粍鍚嶏細绉戝 鎴� 鐥呭尯
             String groupName = byDept ? dto.getDeptname() : dto.getLeavehospitaldistrictname();
             if (StringUtils.isEmpty(groupName)) {
                 continue;
             }
 
-            // 鍏抽敭锛氫袱杈归兘鐢� trimAll锛屽吋瀹瑰叏瑙掔┖鏍�
-            String asrtext = trimAll(dto.getAsrtext());
-            String questionKey = dto.getTaskid() + "\u0001" + trimAll(dto.getQeustionText());
+            String asrtext = trimAll(dto.getAsrtext());            // 鐢ㄦ埛瀹為檯閫変腑鐨勯�夐」
+            String questionText = trimAll(dto.getQuestionText());  // 棰樼洰
+            if (StringUtils.isEmpty(questionText)) {
+                continue;
+            }
 
+            // 鎷嗗垎 targetvalue锛屾瘡涓�夐」閮借鏈変竴鏉¤褰�
             for (String raw : dto.getTargetvalue().split("&")) {
-                String option = trimAll(raw);      // 鈫� 淇鐐癸細鐢� trimAll 鑰屼笉鏄� trim
+
+                String option = trimAll(raw);
                 if (option.isEmpty()) {
                     continue;
                 }
 
-                String key = buildKey(groupName, option, questionKey);
+                // key = 绉戝/鐥呭尯 + 棰樼洰 + 閫夐」
+                String key = buildKey(groupName, questionText, option);
+
                 QuestionCountKsOrBqDTO item = map.get(key);
                 if (item == null) {
                     item = DtoConversionUtils.sourceToTarget(dto, QuestionCountKsOrBqDTO.class);
-                    item.setTargetvalue(option);       // 杈撳嚭鐨� targetvalue 灏辨槸褰撳墠閫夐」
+                    item.setTargetvalue(option);
                     item.setAsrtext(option);
+                    item.setQuestionText(dto.getQuestionText());
                     item.setAnswerCount("0");
+                    item.setSingleScore("0");
                     map.put(key, item);
                 }
 
+                // 鍙湁褰撳墠閫夐」 == 鐢ㄦ埛瀹為檯閫変腑鐨勯�夐」锛屾墠绱姞
                 if (option.equals(asrtext)) {
-                    item.setAnswerCount(String.valueOf(parseCount(item.getAnswerCount()) + 1));
-                    item.setSingleScore(String.valueOf(new BigDecimal(item.getSingleScore()).add(new BigDecimal(dto.getSingleScore()))));
+                    int count = parseCount(item.getAnswerCount()) + 1;
+                    item.setAnswerCount(String.valueOf(count));
+
+                    BigDecimal totalScore = new BigDecimal(item.getSingleScore())
+                            .add(new BigDecimal(dto.getSingleScore() == null ? "0" : dto.getSingleScore()));
+                    item.setSingleScore(totalScore.toPlainString());
                 }
             }
         }
-        ArrayList<QuestionCountKsOrBqDTO> questionCountKsOrBqDTOS = new ArrayList<>(map.values());
-        for (QuestionCountKsOrBqDTO questionCountKsOrBqDTO : questionCountKsOrBqDTOS) {
-            String singleScore = questionCountKsOrBqDTO.getSingleScore();
-            String answerCount = questionCountKsOrBqDTO.getAnswerCount();
+
+        // 4. 璁$畻骞冲潎鍒�
+        for (QuestionCountKsOrBqDTO dto : map.values()) {
+            String answerCount = dto.getAnswerCount();
+            String singleScore = dto.getSingleScore();
 
             BigDecimal avg;
             if (StringUtils.isEmpty(answerCount)
                     || BigDecimal.ZERO.compareTo(new BigDecimal(answerCount.trim())) == 0) {
-                // 闄ゆ暟涓� 0锛岄伩鍏� / by zero
                 avg = BigDecimal.ZERO;
             } else {
-                avg = new BigDecimal(singleScore)
+                avg = new BigDecimal(singleScore == null ? "0" : singleScore)
                         .divide(new BigDecimal(answerCount.trim()), 2, RoundingMode.HALF_UP);
             }
-            questionCountKsOrBqDTO.setAvgScore(avg.toPlainString());
-
+            dto.setAvgScore(avg.toPlainString());
         }
 
-        return questionCountKsOrBqDTOS;
+        // 5. 杞垚 Map<String, Map<String, List<QuestionCountKsOrBqDTO>>>
+        //    绗竴灞� key锛氱瀹�/鐥呭尯
+        //    绗簩灞� key锛氶鐩�
+        //    绗簩灞� value锛氳棰樼洰涓嬬殑鎵�鏈夐�夐」鍒楄〃
+        Map<String, Map<String, List<QuestionCountKsOrBqDTO>>> result = new LinkedHashMap<>();
+
+        for (QuestionCountKsOrBqDTO dto : map.values()) {
+
+            // 鍒嗙粍鍚�
+            String groupName = byDept ? dto.getDeptname() : dto.getLeavehospitaldistrictname();
+            if (StringUtils.isEmpty(groupName)) {
+                continue;
+            }
+
+            // 棰樼洰鍚�
+            String questionText = dto.getQuestionText();
+            if (StringUtils.isEmpty(questionText)) {
+                continue;
+            }
+
+            // 绗竴灞傦細绉戝/鐥呭尯
+            Map<String, List<QuestionCountKsOrBqDTO>> questionMap =
+                    result.computeIfAbsent(groupName, k -> new LinkedHashMap<>());
+
+            // 绗簩灞傦細棰樼洰
+            List<QuestionCountKsOrBqDTO> optionList =
+                    questionMap.computeIfAbsent(questionText, k -> new ArrayList<>());
+
+            optionList.add(dto);
+        }
+
+        return result;
     }
 
-
-
     @Override
-    public List<ServiceSubtaskDetailRatioExport> statQuestionOptionBySubtaskIds(List<Long> subtaskIds, Date startOutHospTime, Date endOutHospTime, String scriptContent, Double scoreStart, Double scoreEnd, String valueType) {
+    public List<ServiceSubtaskDetailRatioExport> statQuestionOptionBySubtaskIds(List<Long> subtaskIds, Date startOutHospTime, Date endOutHospTime, Date startFinishTime, Date endFinishTime, String scriptContent, Double scoreStart, Double scoreEnd, String valueType) {
         //鍏堟竻鐞嗕竴涓嬮噸澶嶆暟鎹�
         List<Long> repeatIds = serviceSubtaskDetailMapper.selectRepeatDetailIds();
         if (!CollectionUtils.isEmpty(repeatIds)) {
             serviceSubtaskDetailMapper.deleteRepeatDetailByIds(repeatIds);
         }
 
-        List<ServiceSubtaskDetailRatioExport> serviceSubtaskDetailRatioExports = serviceSubtaskMapper.statQuestionOptionBySubtaskIds(subtaskIds, startOutHospTime, endOutHospTime, scoreStart, scoreEnd, scriptContent, valueType);
-        // 澶勭悊 targetvalue锛氭寜 & 鍒嗗壊鎴愬鏉¤褰�
+        List<ServiceSubtaskDetailRatioExport> serviceSubtaskDetailRatioExports = serviceSubtaskMapper.statQuestionOptionBySubtaskIds(subtaskIds, startOutHospTime, endOutHospTime, startFinishTime, endFinishTime, scoreStart, scoreEnd, scriptContent, valueType);
+        // SQL 宸叉寜銆岄鐩� + 閫夐」銆嶆眹鎬绘暟閲忥紝杩欓噷鍐嶆寜棰樼洰鍚堝苟锛堜笉鍚屾ā鏉跨殑 targetvalue 閫夐」椤哄簭涓嶅悓锛屽悓涓�閫夐」浼氭媶鎴愬琛岋級锛�
+        // 骞舵妸娌′汉閫夌殑閫夐」琛ユ垚 0 琛屻�佹寜鍚勯�夐」鏁伴噺涔嬪拰閲嶇畻姣斾緥
+        return mergeMydOptionRows(serviceSubtaskDetailRatioExports);
+    }
+
+    /**
+     * 鎶� SQL 杩斿洖鐨勩�岄鐩� + 閫夐」銆嶆槑缁嗗悎骞舵垚銆屼竴琛屼竴涓�夐」銆�
+     * <ul>
+     *     <li>鍚屼竴棰樼洰涓嬬浉鍚� optionresult 鐨勬暟閲忕疮鍔狅細鍘熷疄鐜伴亣鍒板悓鍚嶉�夐」鐩存帴 continue锛�
+     *         姣忎釜閫夐」鍙細淇濈暀绗竴鏉℃槑缁嗙殑鏁伴噺锛屽浠诲姟/澶氭偅鑰呯殑椤规暟鍏ㄨ涓㈡帀锛屽墠绔�屾暟閲忋�嶆案杩滃彧鏈� 1</li>
+     *     <li>閫夐」娓呭崟鍙� targetvalue锛堢敤 &amp; 杩炴帴锛夛紝娌′汉閫夌殑閫夐」琛� 0 琛岋紝鍓嶇鍥哄畾鍏垪鎵嶈兘娓叉煋</li>
+     *     <li>姣斾緥 = 璇ラ�夐」鏁伴噺 / 璇ラ鍚勯�夐」鏁伴噺涔嬪拰锛屼繚璇佷竴閬撻鍚勯�夐」姣斾緥鍚堣 100%</li>
+     * </ul>
+     *
+     * @param rows SQL 鏄庣粏
+     */
+    private List<ServiceSubtaskDetailRatioExport> mergeMydOptionRows(List<ServiceSubtaskDetailRatioExport> rows) {
         List<ServiceSubtaskDetailRatioExport> result = new ArrayList<>();
-        for (ServiceSubtaskDetailRatioExport export : serviceSubtaskDetailRatioExports) {
-            if (StringUtils.isNotEmpty(export.getTargetvalue()) && export.getTargetvalue().contains("&")) {
-                String[] values = export.getTargetvalue().split("&");
-                // 濡傛灉鏈夊鏉$洰鏍囧�硷紝鎷嗗垎鎴愬琛�
-                for (String value : values) {
-                    //鍏堝幓 result 涓煡涓�涓嬶紝鏈夋病鏈夎繖涓� questiontext 鍜屽搴旂殑 targetvalue
-                    ServiceSubtaskDetailRatioExport existingExport = result.stream().filter(e -> {
-                        if (e == null || export == null) {
-                            return false;
-                        }
-                        String q1 = e.getQuestiontext() != null ? e.getQuestiontext() : "";
-                        String q2 = export.getQuestiontext() != null ? export.getQuestiontext() : "";
-                        String t1 = value.trim();
-                        String t2 = e.getTargetvalue() != null ? e.getTargetvalue() : "";
-                        return q1.equals(q2) && t1.equals(t2);
-                    }).findFirst().orElse(null);
-                    if (existingExport != null && "0".equals(existingExport.getRatio()) && "0".equals(existingExport.getCount())) {
-                        //濡傛灉瀛樺湪锛屽垯灏� result 閲岀殑杩欎釜闂鎵�瀵瑰簲鐨� Targetvalue=value 杩欐潯鏁版嵁鏇存柊鎴愬綋鍓嶈繖鏉℃暟鎹�
-                        if (value.equals(export.getOptionresult())) {
-                            existingExport.setRatio(export.getRatio());
-                            existingExport.setScore(export.getScore());
-                            existingExport.setCount(export.getCount());
-                            existingExport.setOptionresult(export.getOptionresult());
-                        }
-                    } else if (existingExport != null && !"0".equals(existingExport.getRatio())) {
-                        continue;
-                    } else {
-                        ServiceSubtaskDetailRatioExport newExport = DtoConversionUtils.sourceToTarget(export, ServiceSubtaskDetailRatioExport.class);
-                        newExport.setTargetvalue(value.trim()); // targetvalue 鏄剧ず鍗曚釜閫夐」
-                        if (!value.equals(export.getOptionresult())) {
-                            newExport.setOptionresult(null);
-                            newExport.setCount("0");
-                            newExport.setRatio("0");
-                        }
-                        result.add(newExport);
-                    }
+        if (CollectionUtils.isEmpty(rows)) {
+            return result;
+        }
+
+        // key -> 閫夐」 -> 鏁伴噺锛岀敤 LinkedHashMap 淇濆簭锛氶�夐」椤哄簭娌跨敤闂嵎閰嶇疆 targetvalue 鐨勯『搴�
+        Map<String, Map<String, long[]>> countMap = new LinkedHashMap<>();
+        Map<String, Map<String, String>> scoreMap = new LinkedHashMap<>();
+        Map<String, ServiceSubtaskDetailRatioExport> templateMap = new LinkedHashMap<>();
+
+        for (ServiceSubtaskDetailRatioExport row : rows) {
+            if (row == null) {
+                continue;
+            }
+            String key = row.getQuestiontext();
+            if (key == null) {
+                continue;
+            }
+            Map<String, long[]> counts = countMap.computeIfAbsent(key, k -> new LinkedHashMap<>());
+            Map<String, String> scores = scoreMap.computeIfAbsent(key, k -> new LinkedHashMap<>());
+            templateMap.putIfAbsent(key, row);
+
+            // 棰樼洰閰嶇疆鐨勯�夐」娓呭崟锛氭病浜洪�夌殑閫夐」涔熻鍒楀嚭鏉ワ紙鏁伴噺涓� 0锛�
+            for (String option : splitOptions(row.getTargetvalue())) {
+                counts.computeIfAbsent(option, k -> new long[1]);
+            }
+
+            // 鎮h�呭疄闄呴�変腑鐨勯�夐」锛氬閫夐 asrtext 鏄�岄�夐」1&閫夐」2銆嶏紝鍗曢��/闂瓟棰樻槸鏁存鏂囨湰
+            List<String> chosenOptions = "2".equals(row.getValueType())
+                    ? splitOptions(row.getOptionresult())
+                    : singleOption(row.getOptionresult());
+            if (chosenOptions.isEmpty()) {
+                // 鏈綔绛旓細涓嶈繘浠讳綍閫夐」锛屼篃涓嶈繘鍒嗘瘝
+                continue;
+            }
+            long count = parseCount(row.getCount());
+            for (String chosen : chosenOptions) {
+                // 閫変腑鐨勯�夐」鍙兘涓嶅湪閰嶇疆娓呭崟閲岋紙鍘嗗彶鏁版嵁锛夛紝琛ヤ竴琛岋紝鏁伴噺涓嶈兘涓�
+                counts.computeIfAbsent(chosen, k -> new long[1])[0] += count;
+                if (StringUtils.isNotEmpty(row.getScore()) && StringUtils.isEmpty(scores.get(chosen))) {
+                    scores.put(chosen, row.getScore());
                 }
-            } else {
-                // targetvalue 涓嶅寘鍚� &锛岀洿鎺ユ坊鍔犲埌缁撴灉
-                result.add(export);
             }
         }
 
+        for (Map.Entry<String, Map<String, long[]>> entry : countMap.entrySet()) {
+            ServiceSubtaskDetailRatioExport template = templateMap.get(entry.getKey());
+            Map<String, String> scores = scoreMap.get(entry.getKey());
+            long total = 0L;
+            for (long[] count : entry.getValue().values()) {
+                total += count[0];
+            }
+            for (Map.Entry<String, long[]> optionEntry : entry.getValue().entrySet()) {
+                String option = optionEntry.getKey();
+                long count = optionEntry.getValue()[0];
+                ServiceSubtaskDetailRatioExport merged = DtoConversionUtils.sourceToTarget(template, ServiceSubtaskDetailRatioExport.class);
+                merged.setQuestiontext(template.getQuestiontext());
+                merged.setTargetvalue(option);
+                // 娌′汉閫夌殑閫夐」 optionresult 缃┖锛屽墠绔寜 targetvalue 鍏滃簳灞曠ず锛屼繚鎸佸師鏈夊睍绀哄彛寰�
+                merged.setOptionresult(count > 0 ? option : null);
+                merged.setCount(String.valueOf(count));
+                merged.setRatio(formatRatio(count, total));
+                merged.setScore(StringUtils.isNotEmpty(scores.get(option)) ? scores.get(option) : template.getScore());
+                result.add(merged);
+            }
+        }
         return result;
+    }
+
+    /**
+     * 鍗曢��/闂瓟棰樼殑浣滅瓟鏂囨湰锛氫笉鎸� &amp; 鎷嗭紝閬垮厤鎶婇棶绛旈鐨勬枃鏈瓟妗堟媶鍧�
+     */
+    private static List<String> singleOption(String answer) {
+        List<String> options = new ArrayList<>();
+        String text = trimAll(answer);
+        if (StringUtils.isNotEmpty(text)) {
+            options.add(text);
+        }
+        return options;
     }
 
     /**
@@ -5526,6 +5918,34 @@
         return content;
     }
 
+    /**
+     * 婊℃剰搴﹁秼鍔挎煡璇�
+     *
+     * @param mydTrendReqVO
+     * @return
+     */
+    @Override
+    public List<MydTrendReqDTO> mydTrend(MydTrendReqVO mydTrendReqVO) {
+        List<MydTrendReqDTO> list = serviceSubtaskMapper.mydTrend(mydTrendReqVO.getStartFinishTime(), mydTrendReqVO.getEndFinishTime(), mydTrendReqVO.getType());
+        if (mydTrendReqVO.getType().equals("week")) list = getWeekDate(mydTrendReqVO, list);
+        if (mydTrendReqVO.getType().equals("year")) list = getYearDate(mydTrendReqVO, list);
+        if (mydTrendReqVO.getType().equals("month")) list = getMonthDate(mydTrendReqVO, list);
+        if (mydTrendReqVO.getType().equals("day")) list = getDayDate(mydTrendReqVO, list);
+        return list;
+    }
+
+    @Override
+    public List<MydTrendReqDTO> sltdMydTotalByDimension(MydTrendReqVO mydTrendReqVO) {
+        List<MydTrendReqDTO> list = null;
+        if (mydTrendReqVO.getDimensionType().equals("1"))
+            list = serviceSubtaskMapper.sltdMydTotalByDimension(mydTrendReqVO.getStartFinishTime(), mydTrendReqVO.getEndFinishTime(), mydTrendReqVO.getType());
+        else if (mydTrendReqVO.getDimensionType().equals("2"))
+            list = serviceSubtaskMapper.sltdMydTotalByYQ(mydTrendReqVO.getStartFinishTime(), mydTrendReqVO.getEndFinishTime(), mydTrendReqVO.getType());
+
+        return list;
+    }
+
+
     public ServiceSubtask boxedServiceSubtask(ServiceTask serviceTask, ServiceTaskdept serviceTaskdept, PatArchive patArchive) {
         ServiceSubtask serviceSubtask = DtoConversionUtils.sourceToTarget(serviceTask, ServiceSubtask.class);
         serviceSubtask.setTaskid(serviceTask.getTaskid());
@@ -5568,7 +5988,39 @@
         Date newDate = new Date();
         serviceSubtask.setLongSendTime(newDate);
         serviceSubtask.setVisitTime(newDate);
+        // 闄㈠尯锛�/scanGenerateSubtask 鏄尶鍚嶆帴鍙o紙SecurityConfig permitAll锛夛紝鍙栦笉鍒扮櫥褰曠敤鎴凤紱
+        // 鑰� service_task.campusid 鍦ㄦ湰搴撴槸鍗犱綅鍊� '1'锛岀洿鎺ユ部鐢ㄤ細璁╃粺璁℃帴鍙o紙@AddOrgId 鎸夐櫌鍖鸿繃婊わ級鏌ヤ笉鍒版暟鎹��
+        // 杩欓噷鐢ㄤ换鍔¢厤缃殑鐥呭尯锛堝叾娆$瀹わ級鍙嶆煡 sys_dept.campusid 钀藉簱锛屼繚璇侀棶鍗风粺璁¤兘鎸夐櫌鍖哄彇鍒般��
+        String campusIdByDept = queryCampusIdByDeptCode(serviceSubtask.getLeavehospitaldistrictcode(), serviceTask.getOrgid());
+        if (StringUtils.isEmpty(campusIdByDept)) {
+            campusIdByDept = queryCampusIdByDeptCode(serviceSubtask.getDeptcode(), serviceTask.getOrgid());
+        }
+        if (StringUtils.isNotEmpty(campusIdByDept)) {
+            serviceSubtask.setCampusid(campusIdByDept);
+        }
+        // 鍙厤浜嗙瀹わ紙娌℃湁鐥呭尯锛夌殑婊℃剰搴︿换鍔★細杩欓亾绛斿嵎鍦ㄦ寜鐥呭尯绛涢�夌殑鎶ヨ〃閲岀粺璁′笉鍒帮紝鐣欐棩蹇椾究浜庤繍缁村彂鐜�
+        if (StringUtils.isEmpty(serviceSubtask.getLeavehospitaldistrictcode())
+                && ("6".equals(serviceSubtask.getServiceType()) || "14".equals(serviceSubtask.getServiceType()))) {
+            log.warn("銆愭壂鐮佺敓鎴愪换鍔°�戞弧鎰忓害瀛愪换鍔℃病鏈夌梾鍖猴紝鎸夌梾鍖虹瓫閫夌殑鎶ヨ〃灏嗙粺璁′笉鍒拌绛斿嵎锛歵askid={}, deptcode={}, campusid={}",
+                    serviceSubtask.getTaskid(), serviceSubtask.getDeptcode(), serviceSubtask.getCampusid());
+        }
         return serviceSubtask;
+    }
+
+    /**
+     * 鎸夌瀹�/鐥呭尯缂栫爜鍙嶆煡鎵�灞為櫌鍖猴紙鏌ヤ笉鍒拌繑鍥� null锛�
+     */
+    private String queryCampusIdByDeptCode(String deptCode, String orgid) {
+        if (StringUtils.isEmpty(deptCode)) {
+            return null;
+        }
+        try {
+            SysDept sysDept = sysDept2Mapper.selectDeptByCode(deptCode, orgid);
+            return sysDept == null ? null : sysDept.getCampusid();
+        } catch (Exception e) {
+            log.warn("鎸夌紪鐮佸弽鏌ラ櫌鍖哄け璐ワ細deptCode={}, orgid={}, err={}", deptCode, orgid, e.getMessage());
+            return null;
+        }
     }
 
     /**
@@ -5770,6 +6222,8 @@
         String voiceText = phoneCallReqYQVO.getAsrtext();
         String questionText = StringUtils.isNotEmpty(ivrTaskTemplateScriptVO.getIvrtext()) ? ivrTaskTemplateScriptVO.getIvrtext() : ivrTaskTemplateScriptVO.getScriptContent();
         Integer matched = -1;
+        log.info("AI鍖归厤:url = {},questionText = {},voiceText = {},options = {},uuid ={}",
+                url,questionText,voiceText,options,uuid);
         matched = matchOptionIndex(url, questionText, voiceText, options, uuid);
         //璇存槑鍖归厤姝g‘浜�
         if (matched != null && matched >= 0) {
@@ -5863,7 +6317,8 @@
                 phoneCallBackYQVO.setValue(phoneCallBackYQVO.getCommonValue() + serviceTask.getJsy());
                 //璁板綍鐘舵��
                 setFailPreachForm(serviceSubtask, "3", "鐢佃瘽鎷ㄦ墦宸插畬鎴�", "9");
-                return phoneCallBackYQVO;
+                back = phoneCallBackYQVO;
+                return back;
             }
 
             flag = 1;
@@ -5871,9 +6326,10 @@
             redisCache.deleteObject(phoneCallReqYQVO.getUuid() + "PlayEventCallbackPlaystop");
 //                        //鑾峰彇涓嬩竴棰�
             log.error("鑾峰彇涓嬩竴棰樼殑淇℃伅锛歿}", ivrTaskTemplateScriptVO);
-            if (ivrTaskTemplateScriptVO.getBranchFlag().equals("1") || ivrTaskTemplateScriptVO.getBranchFlag().equals("0") && ivrTaskTemplateScriptVO.getNextScriptno() != null && ivrTaskTemplateScriptVO.getNextScriptno() != 0) {
+            //branchFlag涓簄ull鏃舵寜鍒嗘敮0澶勭悊锛岄伩鍏峃PE
+            if ("1".equals(ivrTaskTemplateScriptVO.getBranchFlag()) || "0".equals(ivrTaskTemplateScriptVO.getBranchFlag()) && ivrTaskTemplateScriptVO.getNextScriptno() != null && ivrTaskTemplateScriptVO.getNextScriptno() != 0) {
                 Long nextQuestion = null;
-                if (ivrTaskTemplateScriptVO.getBranchFlag().equals("1")) {
+                if ("1".equals(ivrTaskTemplateScriptVO.getBranchFlag())) {
                     nextQuestion = chosenOption.getNextQuestion();
                     //鏇存柊鍒嗘暟
                     double score = redisCache.getCacheObject(phoneCallReqYQVO.getUuid() + "SCORE");
@@ -5906,15 +6362,9 @@
                     redisCache.setCacheObject(phoneCallReqYQVO.getUuid() + "- jsy", serviceTask.getJsy(), 120, TimeUnit.MINUTES);
                     phoneCallBackYQVO.setType("text");
                     phoneCallBackYQVO.setValue(phoneCallBackYQVO.getCommonValue() + serviceTask.getJsy());
-                    //灏嗙粨鏋滃啓杩沝etail琛�
-                    ServiceSubTaskDetailReq ssdReq = new ServiceSubTaskDetailReq();
-                    List<ServiceSubtaskDetail> serviceSubtaskDetailList2 = new ArrayList<>();
-                    serviceSubtaskDetailList.add(getServiceSubtaskDetail(phoneCallReqYQVO, ivrTaskTemplateScriptVO, serviceSubtask, ivrTaskTemplate));
-                    serviceSubTaskDetailReq.setServiceSubtaskDetailList(serviceSubtaskDetailList2);
-                    ssdReq.setGuid(phoneCallReqYQVO.getGuid());
-                    ssdReq.setOrgid(phoneCallReqYQVO.getOrgid());
-                    saveQuestionAnswerPhone(ssdReq);
-                    return phoneCallBackYQVO;
+                    //鏄庣粏鍦ㄦ湰棰樺尮閰嶆垚鍔熸椂宸茶惤搴擄紙瑙佷笂鏂� saveQuestionAnswerPhone锛夛紝杩欓噷涓嶅啀閲嶅淇濆瓨
+                    back = phoneCallBackYQVO;
+                    return back;
                 }
 
                 for (IvrTaskTemplateScript script : ivrTaskTemplateScripts) {
@@ -5931,6 +6381,15 @@
                         redisCache.deleteObject(phoneCallReqYQVO.getTaskid().trim() + "&&" + "mate" + "&&" + phoneCallReqYQVO.getUuid());
                     }
                 }
+                //涓嬩竴棰樿剼鏈病鎵惧埌鏃讹紝鍏滃簳閲嶉棶褰撳墠棰橈紝閬垮厤璋冪敤鏂硅鍒や负鏈鐞嗚�岄��鍥炴鍒欒瘑鍒�
+                if (StringUtils.isEmpty(phoneCallBackYQVO.getValue())) {
+                    log.error("涓嬩竴棰樿剼鏈湭鎵惧埌锛岄噸闂綋鍓嶉锛宯extQuestion锛歿}", nextQuestion);
+                    phoneCallBackYQVO.setType("text");
+                    phoneCallBackYQVO.setSilent_interval(ivrTaskTemplate.getSilencetime().intValue());
+                    phoneCallBackYQVO.setValue(phoneCallBackYQVO.getCommonValue() + getObject(serviceSubtask, questionText));
+                }
+                back = phoneCallBackYQVO;
+                return back;
             } else if (ivrTaskTemplateScriptVO.getNextScriptno() == null || ivrTaskTemplateScriptVO.getNextScriptno() == 0) {
                 ServiceTask serviceTask1 = serviceTaskService.selectServiceTaskByTaskid(serviceSubtask.getTaskid());
                 phoneCallBackYQVO.setType("text");
@@ -5959,33 +6418,101 @@
                 //鍦╮edis涓繚瀛樹竴涓嬬粨鏉熻锛屽湪璋冪敤鎸傜數璇濈殑鏂规硶鏃跺垹闄�
                 ServiceTask serviceTask = serviceTaskService.selectServiceTaskByTaskid(serviceSubtask.getTaskid());
                 redisCache.setCacheObject(phoneCallReqYQVO.getUuid() + "- jsy", serviceTask.getJsy(), 120, TimeUnit.MINUTES);
-//                                return phoneCallBackYQVO;
+                //缁撴潫璇凡鎷艰繘杩斿洖鍊硷紝鎸傛満鐢卞钩鍙版寜杩斿洖鍊兼墽琛�
+                back = phoneCallBackYQVO;
+                return back;
 
             }
         } else {
-            log.info("娌℃湁鍖归厤涓�----------------------------");
-            //flag=0,璇存槑娌� 鍖归厤涓婏紝涔熻鎶婃偅鑰呰鐨勮瘽璁板綍涓嬫潵
-            if (matched == ivrTaskTemplateScriptVO.getIvrTaskScriptTargetoptionList().size() - 1 && flag == 0) {
-                ServiceSubTaskDetailReq serviceSubTaskDetailReq = new ServiceSubTaskDetailReq();
-                List<ServiceSubtaskDetail> serviceSubtaskDetailList = new ArrayList<>();
-                ServiceSubtaskDetail serviceSubtaskDetail = getServiceSubtaskDetail(phoneCallReqYQVO, ivrTaskTemplateScriptVO, serviceSubtask, ivrTaskTemplate);
-                //淇敼涓�涓嬭闊宠矾寰勶紙鏀规垚鍓嶇鍙互璁块棶鐨勶紝瀛樺埌鏁版嵁搴撲腑锛�
-                if (StringUtils.isNotEmpty(serviceSubtaskDetail.getQuestionvoice())) {
-                    String questionvoice = serviceSubtaskDetail.getQuestionvoice();
-                    String[] split = questionvoice.split("\\\\");
-                    if (split.length > 0) {
-                        String lastPart = split[split.length - 1];
-                        serviceSubtaskDetail.setQuestionvoice(voicePathPrefix + lastPart);
+            //AI娌℃湁鍖归厤涓婏細鐢盇I鍒嗘敮鑷繁鎸�"娌¢棶娓呭氨閲嶉棶"鐨勬鏁板鐞嗭紝涓嶅啀閫�鍥炴鍒欒瘑鍒�
+            log.info("ai娌℃湁鍖归厤涓�----------------------------");
+            //娌″尮閰嶄笂涔熻鎶婃偅鑰呰鐨勮瘽璁板綍涓嬫潵锛坢atchedtext缃┖锛屼笌姝e垯璺緞鍙e緞涓�鑷达級
+            ServiceSubTaskDetailReq serviceSubTaskDetailReq = new ServiceSubTaskDetailReq();
+            List<ServiceSubtaskDetail> serviceSubtaskDetailList = new ArrayList<>();
+            ServiceSubtaskDetail serviceSubtaskDetail = getServiceSubtaskDetail(phoneCallReqYQVO, ivrTaskTemplateScriptVO, serviceSubtask, ivrTaskTemplate);
+            //淇敼涓�涓嬭闊宠矾寰勶紙鏀规垚鍓嶇鍙互璁块棶鐨勶紝瀛樺埌鏁版嵁搴撲腑锛�
+            if (StringUtils.isNotEmpty(serviceSubtaskDetail.getQuestionvoice())) {
+                String questionvoice = serviceSubtaskDetail.getQuestionvoice();
+                String[] split = questionvoice.split("\\\\");
+                if (split.length > 0) {
+                    String lastPart = split[split.length - 1];
+                    serviceSubtaskDetail.setQuestionvoice(voicePathPrefix + lastPart);
+                }
+            }
+            serviceSubtaskDetailList.add(serviceSubtaskDetail);
+            //濡傛灉娌℃湁 鍖归厤涓婏紝杩欎釜蹇呴』涓簄ull
+            serviceSubtaskDetailList.get(0).setMatchedtext("");
+            serviceSubTaskDetailReq.setServiceSubtaskDetailList(serviceSubtaskDetailList);
+            serviceSubTaskDetailReq.setGuid(phoneCallReqYQVO.getGuid());
+            serviceSubTaskDetailReq.setOrgid(phoneCallReqYQVO.getOrgid());
+            saveQuestionAnswerPhone(serviceSubTaskDetailReq);
+
+            String mateKey = phoneCallReqYQVO.getTaskid().trim() + "&&" + "mate" + "&&" + phoneCallReqYQVO.getUuid();
+            Integer count = null;
+            Object countObj = redisCache.getCacheObject(mateKey);
+            if (ObjectUtils.isNotEmpty(countObj)) count = (Integer) countObj;
+            if (count != null && count >= ivrTaskTemplate.getMateNum()) {
+                //娌″尮閰嶆鏁板凡缁忕敤婊★紝涓嶈兘鍐嶉噸闂簡
+                boolean noNextQuestion = ("0".equals(ivrTaskTemplateScriptVO.getBranchFlag()) || "1".equals(ivrTaskTemplateScriptVO.getBranchFlag()))
+                        && (ivrTaskTemplateScriptVO.getNextScriptno() == null || ivrTaskTemplateScriptVO.getNextScriptno() == 0);
+                if (noNextQuestion) {
+                    //宸茬粡鏄渶鍚庝竴棰橈紝鐩存帴鎸傛満
+                    ServiceTask serviceTask1 = serviceTaskService.selectServiceTaskByTaskid(serviceSubtask.getTaskid());
+                    phoneCallBackYQVO.setType("text");
+                    phoneCallBackYQVO.setSilent_interval(ivrTaskTemplate.getSilencetime().intValue());
+                    phoneCallBackYQVO.setValue(phoneCallBackYQVO.getCommonValue() + serviceTask1.getJsy());
+                    //鏇存柊涓�涓嬪垎鏁�
+                    Double score = null;
+                    Object scoreObj = redisCache.getCacheObject(phoneCallReqYQVO.getUuid() + "SCORE");
+                    if (ObjectUtils.isNotEmpty(scoreObj)) score = (Double) scoreObj;
+                    serviceSubtask.setScore(String.valueOf(score));
+                    serviceSubtask.setFinishtime(new Date());
+                    serviceSubtask.setSendstate(6L);
+                    serviceSubtask.setRemark("鐢佃瘽鎷ㄦ墦宸插畬鎴�");
+                    serviceSubtaskMapper.updateServiceSubtask(serviceSubtask);
+                    //璁板綍鐘舵��
+                    setFailPreachForm(serviceSubtask, "3", "鐢佃瘽鎷ㄦ墦宸插畬鎴�", "9");
+                    //鍦╮edis涓繚瀛樹竴涓嬬粨鏉熻锛屽湪璋冪敤鎸傜數璇濈殑鏂规硶鏃跺垹闄�
+                    ServiceTask serviceTask = serviceTaskService.selectServiceTaskByTaskid(serviceSubtask.getTaskid());
+                    redisCache.setCacheObject(phoneCallReqYQVO.getUuid() + "- jsy", serviceTask.getJsy(), 120, TimeUnit.MINUTES);
+                    //鍘籸edis涓紝鎶婅瀛愪换鍔D鍒犻櫎
+                    Long id = serviceSubtask.getId();
+                    Map<String, String> map = delRedisValue(null, id.toString());
+                    if (ObjectUtils.isNotEmpty(map)) {
+                        redisCache.setCacheObject(map.get("cacheName"), map.get("val"));
+                        redisCache.deleteObject(serviceSubtask.getId() + "-" + serviceSubtask.getPhone());
+                        redisCache.deleteObject(phoneCallReqYQVO.getUuid() + "SCORE");
+                    }
+                } else {
+                    //杩樻湁涓嬩竴棰橈紝鎸塶extScriptno缁х画鎻愰棶
+                    for (IvrTaskTemplateScript script : ivrTaskTemplateScripts) {
+                        if (script.getSort() == ivrTaskTemplateScriptVO.getNextScriptno().intValue()) {
+                            phoneCallBackYQVO.setType("text");
+                            phoneCallBackYQVO.setSilent_interval(ivrTaskTemplate.getSilencetime().intValue());
+                            String scriptContent = StringUtils.isNotEmpty(script.getIvrtext()) ? script.getIvrtext() : script.getScriptContent();
+                            phoneCallBackYQVO.setValue(phoneCallBackYQVO.getCommonValue() + getObject(serviceSubtask, scriptContent));
+                            //灏嗚鎮h�呯殑Redis涓殑棰樼洰ID锛岃繘琛屼慨鏀�
+                            redisCache.setCacheObject(phoneCallReqYQVO.getTaskid().trim() + "-" + phoneCallReqYQVO.getPhone().trim(), script.getId().toString(), 120, TimeUnit.MINUTES);
+                            //鏇存柊涓�涓嬪垎鏁�
+                            Double score = null;
+                            Object scoreObj = redisCache.getCacheObject(phoneCallReqYQVO.getUuid() + "SCORE");
+                            if (ObjectUtils.isNotEmpty(scoreObj)) score = (Double) scoreObj;
+                            score = BigDecimal.valueOf(score).add(new BigDecimal(script.getScore())).doubleValue();
+                            redisCache.setCacheObject(phoneCallReqYQVO.getUuid() + "SCORE", score, 120, TimeUnit.MINUTES);
+                            //鎹㈤鎴愬姛锛屾病鍖归厤娆℃暟娓呴浂
+                            redisCache.deleteObject(mateKey);
+                        }
                     }
                 }
-                serviceSubtaskDetailList.add(serviceSubtaskDetail);
-                //濡傛灉娌℃湁 鍖归厤涓婏紝杩欎釜蹇呴』涓簄ull
-                serviceSubtaskDetailList.get(0).setMatchedtext("");
-                serviceSubTaskDetailReq.setServiceSubtaskDetailList(serviceSubtaskDetailList);
-                serviceSubTaskDetailReq.setGuid(phoneCallReqYQVO.getGuid());
-                serviceSubTaskDetailReq.setOrgid(phoneCallReqYQVO.getOrgid());
-                saveQuestionAnswerPhone(serviceSubTaskDetailReq);
+            } else {
+                //杩樻病闂弧娆℃暟锛岀敤noMatchText寮曞鎮h�呴噸绛�
+                redisCache.setCacheObject(mateKey, count == null ? 1 : count + 1, 120, TimeUnit.MINUTES);
+                phoneCallBackYQVO.setType("text");
+                phoneCallBackYQVO.setSilent_interval(ivrTaskTemplate.getSilencetime().intValue());
+                phoneCallBackYQVO.setValue(ivrTaskTemplateScriptVO.getNoMatchText() + getObject(serviceSubtask, StringUtils.isNotEmpty(ivrTaskTemplateScriptVO.getIvrtext()) ? ivrTaskTemplateScriptVO.getIvrtext() : ivrTaskTemplateScriptVO.getScriptContent()));
             }
+            back = phoneCallBackYQVO;
+            return back;
         }
         return back;
     }
@@ -5994,20 +6521,37 @@
     /**
      * 闂缁撴灉鍗犳瘮
      *
-     * @param questionResultVO
+     * @param sltdMydTotalVO
      * @param serviceSubtaskRes
      * @return
      */
-    public List<ServiceSubtaskDetailRatioExport> getDetailRatio(QuestionResultVO questionResultVO, List<ServiceSubtaskRes> serviceSubtaskRes) {
+    public List<ServiceSubtaskDetailRatioExport> getDetailRatio(SltdMydTotalVO sltdMydTotalVO, List<ServiceSubtaskRes> serviceSubtaskRes) {
         List<ServiceSubtaskDetailRatioExport> serviceSubtaskDetailRatioExports = null;
-        if (StringUtils.isNotEmpty(questionResultVO.getServiceType()) && questionResultVO.getServiceType().equals("2")) {
+        List<String> serviceTypeList = sltdMydTotalVO.getServiceTypeList();
+        if (CollectionUtils.isEmpty(serviceTypeList)) {
+            log.warn("getDetailRatio 鏈紶 serviceTypeList锛屾棤娉曠粺璁¢棶棰樺崰姣�");
+            return serviceSubtaskDetailRatioExports;
+        }
+        // 鍒ゆ柇鍙e緞锛�2=闅忚锛堟寜 taskid 缁熻锛夛紝6/14=婊℃剰搴︼紙鎸� subtask id 缁熻锛�
+        boolean hasFollowUp = serviceTypeList.contains("2");
+        boolean hasSatisfaction = serviceTypeList.contains("6") || serviceTypeList.contains("14");
+        if (hasFollowUp && hasSatisfaction) {
+            //serviceType锛屽嵆鏈夐殢璁垮張鏈夋弧鎰忓害锛屾殏鏃舵病娉曠粺璁�
+            log.warn("getDetailRatio 鏆備笉鏀寔鍚屾椂缁熻闅忚(2)涓庢弧鎰忓害(6/14)锛宻erviceTypeList={}", serviceTypeList);
+            return serviceSubtaskDetailRatioExports;
+        }
+        if (hasFollowUp) {
             //鑾峰彇serviceSubtaskList涓殑鎵�鏈塼askid
             List<Long> taskIds = serviceSubtaskRes.stream().map(ServiceSubtaskRes::getTaskid).filter(ObjectUtils::isNotEmpty).distinct().collect(Collectors.toList());
-            serviceSubtaskDetailRatioExports = statQuestionOption(taskIds, questionResultVO.getStartOutHospTime(), questionResultVO.getEndOutHospTime(), questionResultVO.getQuestionContent(), questionResultVO.getStartScore(), questionResultVO.getEndScore(), questionResultVO.getValueType());
-        } else if (StringUtils.isNotEmpty(questionResultVO.getServiceType()) && questionResultVO.getServiceType().equals("6")) {
+            //鍚屾椂甯︿笂鏈瀵煎嚭鐨勫瓙浠诲姟 id锛氳銆岄棶棰樿鎯呭崰姣斻�嶅彧缁熻杩欐壒鎮h�咃紝涓庛�屾偅鑰呴殢璁夸俊鎭〃鍗曘�嶅彛寰勪竴鑷�
+            List<Long> subtaskIds = serviceSubtaskRes.stream().map(ServiceSubtaskRes::getId).filter(ObjectUtils::isNotEmpty).distinct().collect(Collectors.toList());
+            serviceSubtaskDetailRatioExports = statQuestionOption(taskIds, sltdMydTotalVO.getStartFinishTime(), sltdMydTotalVO.getEndFinishTime(), sltdMydTotalVO.getStartOutHospTime(), sltdMydTotalVO.getEndOutHospTime(), sltdMydTotalVO.getQuestionContent(), sltdMydTotalVO.getStartScore(), sltdMydTotalVO.getEndScore(), sltdMydTotalVO.getValueType(), subtaskIds);
+        } else if (hasSatisfaction) {
             //婊℃剰搴︾粺璁� 锛堥�氳繃 subtask 鐨� id 鍘荤粺璁★級
             List<Long> subtaskIds = serviceSubtaskRes.stream().map(ServiceSubtaskRes::getId).collect(Collectors.toList());
-            serviceSubtaskDetailRatioExports = statQuestionOptionBySubtaskIds(subtaskIds, questionResultVO.getStartOutHospTime(), questionResultVO.getEndOutHospTime(), questionResultVO.getQuestionContent(), questionResultVO.getStartScore(), questionResultVO.getEndScore(), questionResultVO.getValueType());
+            serviceSubtaskDetailRatioExports = statQuestionOptionBySubtaskIds(subtaskIds, sltdMydTotalVO.getStartOutHospTime(), sltdMydTotalVO.getEndOutHospTime(), sltdMydTotalVO.getStartFinishTime(), sltdMydTotalVO.getEndFinishTime(), sltdMydTotalVO.getQuestionContent(), sltdMydTotalVO.getStartScore(), sltdMydTotalVO.getEndScore(), sltdMydTotalVO.getValueType());
+        } else {
+            log.warn("getDetailRatio 鏆備笉鏀寔鐨� serviceTypeList={}锛堜粎鏀寔 2 鎴� 6/14锛�", serviceTypeList);
         }
         return serviceSubtaskDetailRatioExports;
     }
@@ -6070,15 +6614,12 @@
     private static Boolean isBlankChar(char c) {
         return c == '\u3000'          // 鍏ㄨ绌烘牸
                 || c == ' '            // 鍗婅绌烘牸
-                || c == '\t'
-                || c == '\n'
-                || c == '\r'
-                || c == '\f'
-                || Character.isWhitespace(c);
+                || c == '\t' || c == '\n' || c == '\r' || c == '\f' || Character.isWhitespace(c);
     }
 
-    private String buildKey(String groupName, String option, String questionKey) {
-        return questionKey + KEY_SEP + groupName + KEY_SEP + option;
+
+    private String buildKey(String groupName, String questionText, String option) {
+        return groupName + "\u0001" + questionText + "\u0001" + option;
     }
 
     private static int parseCount(String s) {
@@ -6091,4 +6632,273 @@
             return 0;
         }
     }
+
+    private List<MydTrendReqDTO> getWeekDate(MydTrendReqVO mydTrendReqVO, List<MydTrendReqDTO> list) {
+        // 1. 璁$畻鎬诲懆鏁帮紙鍜� SQL 閲岀殑鍏紡淇濇寔涓�鑷达級
+        long days = (mydTrendReqVO.getEndFinishTime().getTime() - mydTrendReqVO.getStartFinishTime().getTime()) / (1000L * 60 * 60 * 24);
+        int totalWeeks = (int) (days / 7) + 1;
+
+        // 2. 宸叉湁鏁版嵁锛歱eriod -> totalScore
+        Map<Integer, String> exist = new HashMap<>();
+        for (MydTrendReqDTO row : list) {
+            // period 鏄暟瀛楋紝鍙兘鏄� Integer / Long / BigDecimal锛岀粺涓�杞� int
+            int p = Integer.parseInt(StringUtils.isNotEmpty(row.getPeriod()) ? row.getPeriod() : "0");
+            exist.put(p, row.getTotalScore() != null ? row.getTotalScore() : "0");
+            // 涓嬮潰杩欒鎸変綘鐨勫師閫昏緫淇濈暀锛堣櫧鐒剁湅璧锋潵鏈夌偣澶氫綑锛�
+            exist.put(p, String.valueOf(row.getTotalScore() != null ? row.getTotalScore() : 0));
+        }
+
+        // 3. 琛ュ叏 1..totalWeeks
+        List<MydTrendReqDTO> result = new ArrayList<>(totalWeeks);
+
+        // 鑾峰彇鏁翠綋鐨勫紑濮嬫椂闂�
+        long startTimeMillis = mydTrendReqVO.getStartFinishTime().getTime();
+        long endTimeMillis = mydTrendReqVO.getEndFinishTime().getTime();
+        long oneWeekMillis = 7L * 24 * 60 * 60 * 1000; // 涓�鍛ㄧ殑姣鏁�
+
+        for (int i = 1; i <= totalWeeks; i++) {
+            MydTrendReqDTO row = new MydTrendReqDTO();
+            row.setPeriod(String.valueOf(i));
+            row.setTotalScore(exist.getOrDefault(i, "0"));
+
+            // -------- 鏂板锛氳缃瘡鍛ㄧ殑 startDate 鍜� endDate --------
+            // 褰撳墠鍛ㄥ紑濮嬫椂闂� = 鏁翠綋寮�濮嬫椂闂� + (i - 1) * 7澶�
+            long currentStartMillis = startTimeMillis + (long) (i - 1) * oneWeekMillis;
+
+            // 褰撳墠鍛ㄧ粨鏉熸椂闂� = 褰撳墠鍛ㄥ紑濮嬫椂闂� + 7澶� - 1姣锛堜繚璇佹槸杩欎竴鍛ㄧ殑鏈�鍚庝竴鍒伙級
+            long currentEndMillis = currentStartMillis + oneWeekMillis - 1;
+
+            // 濡傛灉鏄渶鍚庝竴鍛紝缁撴潫鏃堕棿涓嶈兘瓒呰繃鏁翠綋鐨� endTime
+            if (i == totalWeeks) {
+                currentEndMillis = endTimeMillis;
+            }
+
+            row.setStartDate(new Date(currentStartMillis));
+            row.setEndDate(new Date(currentEndMillis));
+            // ----------------------------------------------------
+
+            result.add(row);
+        }
+
+        return result;
+    }
+
+    private List<MydTrendReqDTO> getYearDate(MydTrendReqVO mydTrendReqVO, List<MydTrendReqDTO> list) {
+        // 鑾峰彇鏁翠綋寮�濮嬪拰缁撴潫鏃堕棿
+        Date startTime = mydTrendReqVO.getStartFinishTime();
+        Date endTime = mydTrendReqVO.getEndFinishTime();
+
+        // 1. 璁$畻骞翠唤鑼冨洿
+        // 浣跨敤 Calendar 鑾峰彇璧峰骞翠唤鍜岀粨鏉熷勾浠�
+        Calendar cal = Calendar.getInstance();
+        cal.setTime(startTime);
+        int startYear = cal.get(Calendar.YEAR);
+
+        cal.setTime(endTime);
+        int endYear = cal.get(Calendar.YEAR);
+
+        // 鎬诲勾鏁� (鍖呭惈棣栧熬)
+        int totalYears = endYear - startYear + 1;
+
+        // 2. 宸叉湁鏁版嵁锛歱eriod -> totalScore (鍋囪 period 瀛樼殑鏄勾浠藉瓧绗︿覆锛屽 "2024")
+        Map<String, String> exist = new HashMap<>();
+        for (MydTrendReqDTO row : list) {
+            String period = row.getPeriod() != null ? row.getPeriod() : "";
+            exist.put(period, row.getTotalScore() != null ? row.getTotalScore() : "0");
+        }
+
+        // 3. 琛ュ叏鎵�鏈夊勾浠�
+        List<MydTrendReqDTO> result = new ArrayList<>(totalYears);
+
+        for (int i = 0; i < totalYears; i++) {
+            int currentYear = startYear + i;
+            String periodKey = String.valueOf(currentYear);
+
+            MydTrendReqDTO row = new MydTrendReqDTO();
+            row.setPeriod(periodKey);
+            // 濡傛灉娌℃湁璇ュ勾浠界殑鏁版嵁锛岄粯璁ょ粰 "0"
+            row.setTotalScore(exist.getOrDefault(periodKey, "0"));
+
+            // -------- 璁剧疆璇ュ勾浠界殑 startDate 鍜� endDate --------
+            Calendar yearCal = Calendar.getInstance();
+            // 璁剧疆涓鸿骞寸殑 1鏈�1鏃� 00:00:00
+            yearCal.set(currentYear, Calendar.JANUARY, 1, 0, 0, 0);
+            yearCal.set(Calendar.MILLISECOND, 0);
+            row.setStartDate(yearCal.getTime());
+
+            // 璁剧疆涓鸿骞寸殑 12鏈�31鏃� 23:59:59
+            yearCal.set(currentYear, Calendar.DECEMBER, 31, 23, 59, 59);
+            yearCal.set(Calendar.MILLISECOND, 999);
+            row.setEndDate(yearCal.getTime());
+            // ----------------------------------------------------
+
+            result.add(row);
+        }
+
+        return result;
+    }
+
+    private List<MydTrendReqDTO> getMonthDate(MydTrendReqVO mydTrendReqVO, List<MydTrendReqDTO> list) {
+        // 鑾峰彇鏁翠綋寮�濮嬪拰缁撴潫鏃堕棿
+        Date startTime = mydTrendReqVO.getStartFinishTime();
+        Date endTime = mydTrendReqVO.getEndFinishTime();
+
+        // 1. 璁$畻鏈堜唤鑼冨洿
+        Calendar cal = Calendar.getInstance();
+        cal.setTime(startTime);
+        int startYear = cal.get(Calendar.YEAR);
+        int startMonth = cal.get(Calendar.MONTH); // 娉ㄦ剰锛欳alendar.MONTH 浠� 0 寮�濮�
+
+        cal.setTime(endTime);
+        int endYear = cal.get(Calendar.YEAR);
+        int endMonth = cal.get(Calendar.MONTH);
+
+        // 鎬绘湀鏁� = (缁撴潫骞� - 寮�濮嬪勾) * 12 + (缁撴潫鏈� - 寮�濮嬫湀) + 1
+        int totalMonths = (endYear - startYear) * 12 + (endMonth - startMonth) + 1;
+
+        // 2. 宸叉湁鏁版嵁锛歱eriod -> totalScore (period 瀛樼殑鏄湀浠藉瓧绗︿覆锛屽 "2024-06")
+        Map<String, String> exist = new HashMap<>();
+        for (MydTrendReqDTO row : list) {
+            String period = row.getPeriod() != null ? row.getPeriod() : "";
+            exist.put(period, row.getTotalScore() != null ? row.getTotalScore() : "0");
+        }
+
+        // 3. 琛ュ叏鎵�鏈夋湀浠�
+        List<MydTrendReqDTO> result = new ArrayList<>(totalMonths);
+
+        Calendar monthCal = Calendar.getInstance();
+        monthCal.set(startYear, startMonth, 1, 0, 0, 0);
+        monthCal.set(Calendar.MILLISECOND, 0);
+
+        for (int i = 0; i < totalMonths; i++) {
+            int currentYear = monthCal.get(Calendar.YEAR);
+            int currentMonth = monthCal.get(Calendar.MONTH) + 1; // 杞垚 1-12 鏈�
+
+            // 鎷兼帴 period锛屾牸寮忥細yyyy-MM锛屾瘮濡� "2024-06"
+            // 濡傛灉浣犲笇鏈涙槸 "2024-6"锛屽彲浠ユ妸 String.format 鏀规垚 currentMonth
+            String periodKey = String.format("%04d-%02d", currentYear, currentMonth);
+
+            MydTrendReqDTO row = new MydTrendReqDTO();
+            row.setPeriod(periodKey);
+            row.setTotalScore(exist.getOrDefault(periodKey, "0"));
+
+            // -------- 璁剧疆璇ユ湀鐨� startDate 鍜� endDate --------
+            // 褰撴湀寮�濮嬫椂闂达細1鍙� 00:00:00.000
+            Calendar startCal = (Calendar) monthCal.clone();
+            row.setStartDate(startCal.getTime());
+
+            // 褰撴湀缁撴潫鏃堕棿锛氫笅涓湀1鍙� 00:00:00.000 鍑� 1 姣
+            Calendar endCal = (Calendar) monthCal.clone();
+            endCal.add(Calendar.MONTH, 1);
+            endCal.add(Calendar.MILLISECOND, -1);
+            row.setEndDate(endCal.getTime());
+            // ----------------------------------------------------
+
+            result.add(row);
+
+            // 杩涘叆涓嬩竴涓湀
+            monthCal.add(Calendar.MONTH, 1);
+        }
+
+        return result;
+    }
+
+    private List<MydTrendReqDTO> getDayDate(MydTrendReqVO mydTrendReqVO, List<MydTrendReqDTO> list) {
+        // 鑾峰彇鏁翠綋寮�濮嬪拰缁撴潫鏃堕棿
+        Date startTime = mydTrendReqVO.getStartFinishTime();
+        Date endTime = mydTrendReqVO.getEndFinishTime();
+
+        // 1. 璁$畻鎬诲ぉ鏁�
+        long oneDayMillis = 24L * 60 * 60 * 1000;
+        // 娉ㄦ剰锛氳繖閲屽彧绠楁棩鏈熷樊锛屼笉鑰冭檻鏃跺垎绉掞紝鍚﹀垯鍙兘宸竴澶�
+        Calendar startCal = Calendar.getInstance();
+        startCal.setTime(startTime);
+        startCal.set(Calendar.HOUR_OF_DAY, 0);
+        startCal.set(Calendar.MINUTE, 0);
+        startCal.set(Calendar.SECOND, 0);
+        startCal.set(Calendar.MILLISECOND, 0);
+
+        Calendar endCal = Calendar.getInstance();
+        endCal.setTime(endTime);
+        endCal.set(Calendar.HOUR_OF_DAY, 0);
+        endCal.set(Calendar.MINUTE, 0);
+        endCal.set(Calendar.SECOND, 0);
+        endCal.set(Calendar.MILLISECOND, 0);
+
+        long days = (endCal.getTimeInMillis() - startCal.getTimeInMillis()) / oneDayMillis;
+        int totalDays = (int) days + 1;
+
+        // 2. 宸叉湁鏁版嵁锛歱eriod -> totalScore (period 瀛樼殑鏄棩鏈熷瓧绗︿覆锛屽 "2024-06-01")
+        Map<String, String> exist = new HashMap<>();
+        for (MydTrendReqDTO row : list) {
+            String period = row.getPeriod() != null ? row.getPeriod() : "";
+            exist.put(period, row.getTotalScore() != null ? row.getTotalScore() : "0");
+        }
+
+        // 3. 琛ュ叏鎵�鏈夋棩鏈�
+        List<MydTrendReqDTO> result = new ArrayList<>(totalDays);
+
+        Calendar dayCal = (Calendar) startCal.clone();
+        for (int i = 0; i < totalDays; i++) {
+            // 鎷兼帴 period锛屾牸寮忥細yyyy-MM-dd
+            String periodKey = String.format("%04d-%02d-%02d", dayCal.get(Calendar.YEAR), dayCal.get(Calendar.MONTH) + 1, dayCal.get(Calendar.DAY_OF_MONTH));
+
+            MydTrendReqDTO row = new MydTrendReqDTO();
+            row.setPeriod(periodKey);
+            row.setTotalScore(exist.getOrDefault(periodKey, "0"));
+
+            // -------- 璁剧疆璇ュぉ鐨� startDate 鍜� endDate --------
+            Calendar startOfDay = (Calendar) dayCal.clone();
+            row.setStartDate(startOfDay.getTime());
+
+            Calendar endOfDay = (Calendar) dayCal.clone();
+            endOfDay.set(Calendar.HOUR_OF_DAY, 23);
+            endOfDay.set(Calendar.MINUTE, 59);
+            endOfDay.set(Calendar.SECOND, 59);
+            endOfDay.set(Calendar.MILLISECOND, 999);
+            row.setEndDate(endOfDay.getTime());
+            // ----------------------------------------------------
+
+            result.add(row);
+
+            // 杩涘叆涓嬩竴澶�
+            dayCal.add(Calendar.DAY_OF_MONTH, 1);
+        }
+
+        return result;
+    }
+
+    /**
+     * 闂ㄨ瘖婊℃剰搴︾患鍚堝緱鍒嗘帓鍚嶏紙鎸夌瀹ゆ垨鐥呭尯锛�
+     * <p>
+     * 缁煎悎婊℃剰搴� = 危(璇勫垎鏄庣粏鏉冮噸) / 璇勫垎鏄庣粏鏉℃暟 脳 100%锛�
+     * 鏉冮噸鍙彇 1銆�0.8銆�0.6銆�0.4銆�0.2 浜旀。锛堝緢婊℃剰銆佹弧鎰忋�佷竴鑸�佷笉婊℃剰銆佸緢涓嶆弧鎰忥級銆�
+     *
+     * @param mzMydScoreRankVO 鏌ヨ鏉′欢
+     * @return 鎺掑悕缁撴灉锛屽悕娆′粠 1 寮�濮嬮『搴忕紪鍙�
+     */
+    @Override
+    public List<MzMydScoreRankDTO> mzMydScoreRank(MzMydScoreRankVO mzMydScoreRankVO) {
+        if (StringUtils.isEmpty(mzMydScoreRankVO.getDimensionType())) {
+            mzMydScoreRankVO.setDimensionType("1");
+        }
+        if (CollectionUtils.isEmpty(mzMydScoreRankVO.getServiceTypes())) {
+          List<String> list=new ArrayList<>(Arrays.asList("14"));
+            mzMydScoreRankVO.setServiceTypes(list);
+        }
+        List<MzMydScoreRankDTO> list = serviceSubtaskMapper.selectMzMydScoreRank(mzMydScoreRankVO);
+        if (CollectionUtils.isEmpty(list)) {
+            return new ArrayList<>();
+        }
+        // 鍚嶆锛歋QL 宸叉寜缁煎悎寰楀垎闄嶅簭杩斿洖锛岃繖閲岄『搴忕紪鍙�
+        for (int i = 0; i < list.size(); i++) {
+            list.get(i).setRank(i + 1);
+        }
+        return list;
+    }
+
+    // ---------------------------------------------------------------------
+    // 璇存槑锛氬師绉佹湁 getWXCode / encode 宸查殢鍙戦�佹柟涓�璧锋敹鍙e埌 ruoyi-message 妯″潡
+    // 锛圶inHuaMpApi锛夛紝姝ゅ宸插垹闄わ紝閬垮厤涓変唤鎷疯礉鍚勫啓涓�濂楃鍚嶉�昏緫銆�
+    // ---------------------------------------------------------------------
 }

--
Gitblit v1.9.3