From 5bbd99ba550aa2e8cd8da36644018981ca1a1921 Mon Sep 17 00:00:00 2001
From: 陈昶聿 <chychen@nbjetron.com>
Date: 星期三, 23 九月 2026 16:58:51 +0800
Subject: [PATCH] 【丽水】更新同步

---
 smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java |  214 ++++++++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 200 insertions(+), 14 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 53f6da1..5ecccd8 100644
--- a/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java
@@ -27,6 +27,7 @@
 import com.smartor.domain.DTO.MzMydScoreRankDTO;
 import com.smartor.domain.DTO.QuestionCountKsOrBqDTO;
 import com.smartor.domain.DTO.ServiceSubtaskDetailDTO;
+import com.smartor.domain.DTO.ServiceSubtaskOptionStatDTO;
 import com.smartor.domain.*;
 import com.smartor.domain.VO.*;
 import com.smartor.domain.entity.ServiceSubtaskEntity;
@@ -631,6 +632,43 @@
             result.putIfAbsent("wxsf", 0);
             result.putIfAbsent("xsf", 0);
             result.putIfAbsent("dsf", 0);
+            result.putIfAbsent("ywc", 0);
+            result.putIfAbsent("yc", 0);
+            result.putIfAbsent("jg", 0);
+        }
+        return result;
+    }
+
+    /**
+     * 缁熻浠诲姟鍚勭鐘舵�佺殑鏁伴噺锛堝凡浼樺寲锛�
+     * 浼樺寲璇存槑锛�
+     * 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);
@@ -5230,13 +5268,13 @@
         return resultMap;
     }
     @Override
-    public List<ServiceSubtaskDetailRatioExport> statQuestionOption(List<Long> taskIds, Date startFinishTime, Date endFinishTime, 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, startFinishTime, endFinishTime, 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<>();
@@ -5246,7 +5284,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())) {
@@ -5275,6 +5315,152 @@
         }
 
         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();
     }
 
     /*
@@ -6052,9 +6238,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");
@@ -6087,14 +6274,11 @@
                     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);
+                    //灏嗙粨鏋滃啓杩沝etail琛紙鏈鐨勬槑缁嗗湪涓婇潰鍖归厤鎴愬姛鏃跺凡缁忕粍瑁呭苟瀛樺叆serviceSubtaskDetailList锛岃繖閲岀洿鎺ヨ惤搴擄紝閬垮厤閲嶅鏂板锛�
+                    serviceSubTaskDetailReq.setServiceSubtaskDetailList(serviceSubtaskDetailList);
+                    serviceSubTaskDetailReq.setGuid(phoneCallReqYQVO.getGuid());
+                    serviceSubTaskDetailReq.setOrgid(phoneCallReqYQVO.getOrgid());
+                    saveQuestionAnswerPhone(serviceSubTaskDetailReq);
                     return phoneCallBackYQVO;
                 }
 
@@ -6197,7 +6381,9 @@
         if (hasFollowUp) {
             //鑾峰彇serviceSubtaskList涓殑鎵�鏈塼askid
             List<Long> taskIds = serviceSubtaskRes.stream().map(ServiceSubtaskRes::getTaskid).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());
+            //鍚屾椂甯︿笂鏈瀵煎嚭鐨勫瓙浠诲姟 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());

--
Gitblit v1.9.3