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 |  771 +++++++++++++++++++++++++++++++++++++++++++++++++++++++----
 1 files changed, 719 insertions(+), 52 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 580958d..5ecccd8 100644
--- a/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskServiceImpl.java
@@ -10,9 +10,11 @@
 import com.ruoyi.common.core.redis.RedisCache;
 import com.ruoyi.common.core.service.IConfigService;
 import com.ruoyi.common.dx.MessageSend;
+import com.ruoyi.common.enums.WxGZHEnum;
 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;
@@ -21,8 +23,11 @@
 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.*;
 import com.smartor.domain.VO.*;
 import com.smartor.domain.entity.ServiceSubtaskEntity;
@@ -44,6 +49,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 +62,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涓氬姟灞傚鐞�
@@ -630,6 +640,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 鍗曚竴浠诲姟锛堥殢璁匡級
@@ -785,6 +832,7 @@
         serviceSubtask.setUpdateTime(DateUtils.getNowDate());
         if (serviceSubtask.getSendstate() != null && serviceSubtask.getSendstate() == 6)
             serviceSubtask.setFinishtime(new Date());
+
         return serviceSubtaskMapper.updateServiceSubtask(serviceSubtask);
     }
 
@@ -1053,8 +1101,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());
             //鏂板
@@ -1429,6 +1477,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());
@@ -5091,6 +5141,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);
@@ -5135,14 +5191,90 @@
         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);
+
+
+            //鑾峰彇寰俊鍏紬鍙疯姹備俊鎭牴鎹満鏋処D
+            List<String> wxqqxx = WxGZHEnum.getDescByCode(serviceSubtask.getOrgid());
+            if (CollectionUtils.isEmpty(wxqqxx) || wxqqxx.size() < 4) {
+                resultMap.put("code", -1);
+                resultMap.put("message", "鍙戦�佸紓甯革細" + "銆愬叕浼楀彿銆戣鏈烘瀯鐨勫叕浼楀彿閰嶇疆淇℃伅涓嶅叏锛屾棤娉曢�氳繃鍏紬鍙峰彂閫�");
+                return resultMap;
+            }
+
+            if (StringUtils.isEmpty(serviceSubtask.getPatidHis())) {
+                resultMap.put("code", -1);
+                resultMap.put("message", "鍙戦�佸紓甯革細" + "銆愬叕浼楀彿銆戝叕浼楀彿鍙戦�佸け璐�,his绯荤粺鐨勬偅鑰卛d涓虹┖");
+                return resultMap;
+            }
+            String wxCode = "";
+            wxCode = getWXCode(serviceSubtask.getSfzh(), url, serviceSubtask.getTaskName(), serviceSubtask.getTaskDesc(), patArchive.getTelcode(), serviceSubtask.getSendname(), patArchive.getPatidHis(), wxqqxx);
+            Map map = JSONObject.parseObject(wxCode, Map.class);
+            Boolean wxCodeSuccess = false;
+            if (!map.isEmpty() && map.get("succ") != null) {
+                wxCodeSuccess = (boolean) map.get("succ");
+            }
+
+            //鍙戦�佸畬鎴愬悗锛屼慨鏀圭姸鎬�
+            serviceSubtask.setSendstate(3L);
+            if (wxCodeSuccess) {
+                serviceSubtask.setResult("success");
+                resultMap.put("code", "200");
+                resultMap.put("msg", "鍙戦�佹垚鍔�");
+            } else {
+                log.error("銆恠fHandlle銆戝叕浼楀彿鍙戦�佸け璐ワ紝鎮h�呬俊鎭細{}锛岄敊璇俊鎭細{}", serviceSubtask, map.get("msg"));
+                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<>();
@@ -5152,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())) {
@@ -5183,92 +5317,285 @@
         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);
+        List<ServiceSubtaskDetailRatioExport> serviceSubtaskDetailRatioExports = serviceSubtaskMapper.statQuestionOptionBySubtaskIds(subtaskIds, startOutHospTime, endOutHospTime, startFinishTime, endFinishTime, scoreStart, scoreEnd, scriptContent, valueType);
         // 澶勭悊 targetvalue锛氭寜 & 鍒嗗壊鎴愬鏉¤褰�
         List<ServiceSubtaskDetailRatioExport> result = new ArrayList<>();
         for (ServiceSubtaskDetailRatioExport export : serviceSubtaskDetailRatioExports) {
@@ -5537,6 +5864,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);
@@ -5883,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");
@@ -5918,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;
                 }
 
@@ -6006,20 +6359,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;
     }
@@ -6082,15 +6452,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) {
@@ -6103,4 +6470,304 @@
             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;
+    }
+
+    private String getWXCode(String idcard, String url, String taskName, String taskDesc, String phone, String setPatientname, String setPatientid, List<String> wxqqxx) {
+        XinHuaWXReq xinHuaWXReq = new XinHuaWXReq();
+        xinHuaWXReq.setIdcard(idcard);
+        xinHuaWXReq.setUrl(url);
+        xinHuaWXReq.setPatientid(setPatientid);
+        xinHuaWXReq.setPatientname(setPatientname);
+        xinHuaWXReq.setMobile(phone);
+        xinHuaWXReq.setMedcardno(null);
+        xinHuaWXReq.setTitlename(taskName);
+        xinHuaWXReq.setContent(taskDesc);
+        xinHuaWXReq.setAppid(wxqqxx.get(1));
+        log.info("銆恎etWXCode銆戝井淇″叕浼楀彿璇锋眰鍙傛暟锛歿}", xinHuaWXReq);
+        String body = new Gson().toJson(xinHuaWXReq);
+        String encode = encode(wxqqxx.get(2).concat(body));
+        Map<String, String> headerMap = new HashMap<>();
+        headerMap.put("sign", encode);
+        String result = HttpUtils.sendPostByHeader(wxqqxx.get(3), body, headerMap);
+        log.info("銆恎etWXCode銆戝井淇″叕浼楀彿杩斿洖鍙傛暟锛歿}", result);
+        JSONObject jsonObject = JSONObject.parseObject(result);
+        String code = (String) jsonObject.toString();
+        return code;
+    }
+    public String encode(String arg) {
+        if (arg == null) {
+            arg = "";
+        }
+        MessageDigest md5 = null;
+        try {
+            md5 = MessageDigest.getInstance("MD5");
+            md5.update(arg.getBytes("UTF-8"));
+        } catch (Exception e) {
+            e.printStackTrace();
+        }
+        return toHex(md5.digest());
+    }
 }

--
Gitblit v1.9.3