From 60ade5154522a042c816abaa1840751011ae0371 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期二, 29 九月 2026 19:15:03 +0800
Subject: [PATCH] 1.省立同德满度问题处理 2.门急诊数据采集优化

---
 smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java |  206 ++++++++++++++++++++++++++++++++++++++++-----------
 1 files changed, 160 insertions(+), 46 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 9b046f6..bcca0f4 100644
--- a/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java
@@ -14,7 +14,6 @@
 import com.ruoyi.common.exception.base.BaseException;
 import com.ruoyi.common.utils.*;
 import com.ruoyi.common.utils.http.HttpUtils;
-import com.ruoyi.common.utils.sms.smsUtils;
 import com.ruoyi.common.utils.spring.SpringUtils;
 import com.ruoyi.system.domain.SysConfig;
 import com.ruoyi.system.mapper.SysConfigMapper;
@@ -23,11 +22,7 @@
 import com.smartor.common.MtSubmitSmUtil;
 import com.smartor.common.ScheduleSubtaskBuilder;
 import com.smartor.config.PhoneUtils;
-import com.smartor.domain.DTO.MydTrendReqDTO;
-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.DTO.*;
 import com.smartor.domain.*;
 import com.smartor.domain.VO.*;
 import com.smartor.domain.entity.ServiceSubtaskEntity;
@@ -632,6 +627,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);
@@ -5559,52 +5591,102 @@
         }
 
         List<ServiceSubtaskDetailRatioExport> serviceSubtaskDetailRatioExports = serviceSubtaskMapper.statQuestionOptionBySubtaskIds(subtaskIds, startOutHospTime, endOutHospTime, startFinishTime, endFinishTime, scoreStart, scoreEnd, scriptContent, valueType);
-        // 澶勭悊 targetvalue锛氭寜 & 鍒嗗壊鎴愬鏉¤褰�
+        // 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;
     }
 
     /**
@@ -5898,10 +5980,42 @@
         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;
+        }
+    }
+
+    /**
      * Ai 鍖归厤閫夐」
      *
      * @param questionText

--
Gitblit v1.9.3