From 09f75e1b4ee21241940ad26b91462ea15c5e4f00 Mon Sep 17 00:00:00 2001
From: liusheng <337615773@qq.com>
Date: 星期五, 03 七月 2026 09:25:29 +0800
Subject: [PATCH] 1.短信功能提交 2.优化随访详情页 3.导出两个sheet

---
 smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskAnswerServiceImpl.java |  269 ++++++++++++++++++++++++++++++++++++++++-------------
 1 files changed, 203 insertions(+), 66 deletions(-)

diff --git a/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskAnswerServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskAnswerServiceImpl.java
index 37106c8..07484ad 100644
--- a/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskAnswerServiceImpl.java
+++ b/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskAnswerServiceImpl.java
@@ -14,9 +14,7 @@
 import com.smartor.domain.VO.ServiceSubtaskDetailTraceVO;
 import com.smartor.domain.entity.ServiceSubtaskEntity;
 import com.smartor.mapper.*;
-import com.smartor.service.IServiceSubtaskAnswerService;
-import com.smartor.service.IServiceSubtaskDetailTraceService;
-import com.smartor.service.IServiceTaskService;
+import com.smartor.service.*;
 import com.sun.org.apache.bcel.internal.generic.NEW;
 import lombok.extern.slf4j.Slf4j;
 import org.apache.commons.collections4.CollectionUtils;
@@ -75,6 +73,18 @@
 
     @Autowired
     private IServiceSubtaskDetailTraceService traceService;
+
+    @Autowired
+    private ISvyTaskTemplateService svyTaskTemplateService;
+
+    @Autowired
+    private ISvyLibTemplateScriptService svyLibTemplateScriptService;
+
+    @Autowired
+    private IIvrTaskTemplateService ivrTaskTemplateService;
+
+    @Autowired
+    private IIvrLibaTemplateScriptService ivrLibaTemplateScriptService;
 
     @Value("${pri_key}")
     private String pri_key;
@@ -154,6 +164,7 @@
     public Integer saveQuestionAnswer(ServiceSubTaskAnswerReq serviceSubTaskAnswerReq, Long flag) {
         Long tid = null;
         Long pid = null;
+        Long subid = null;
         Double score = null;
         Long isabno = 0L;
         Set<String> allKeys = redisCache.getAllKeys();
@@ -164,16 +175,19 @@
             if (flag == 0) {
                 tid = Long.valueOf(rsaPublicKeyExample.decryptedData(serviceSubTaskAnswerReq.getParam1(), pri_key));
                 pid = Long.valueOf(rsaPublicKeyExample.decryptedData(serviceSubTaskAnswerReq.getParam2(), pri_key));
+                if (StringUtils.isNotEmpty(serviceSubTaskAnswerReq.getParam6()))
+                    subid = Long.valueOf(rsaPublicKeyExample.decryptedData(serviceSubTaskAnswerReq.getParam6(), pri_key));
             } else if (flag == 1) {
                 tid = Long.valueOf(serviceSubTaskAnswerReq.getParam1());
                 pid = Long.valueOf(serviceSubTaskAnswerReq.getParam2());
+                subid = Long.valueOf(serviceSubTaskAnswerReq.getParam6());
             }
             if (serviceSubTaskAnswerReq.getType() != null && serviceSubTaskAnswerReq.getType() == 2) {
                 allKeys = new HashSet<>();
-                allKeys.add(pid + "-" + tid + "-WJscriptCache");
+                allKeys.add(pid + "-" + tid + "-" + subid + "-WJscriptCache");
             } else if (serviceSubTaskAnswerReq.getType() != null && serviceSubTaskAnswerReq.getType() == 1) {
                 allKeys = new HashSet<>();
-                allKeys.add(pid + "-" + tid + "-SFscriptCache");
+                allKeys.add(pid + "-" + tid + "-" + subid + "-SFscriptCache");
             }
         }
 
@@ -183,7 +197,7 @@
             String[] split = key.split("-");
             //鍏堝垽鏂紝鏄笉鏄綋鍓嶆彁浜や汉鐨勶紝涓嶆槸褰撳墠鎻愪氦浜虹殑锛岃烦杩�
             try {
-                if (ObjectUtils.isNotEmpty(split[0]) && ObjectUtils.isNotEmpty(split[1]) && !Long.valueOf(split[0]).equals(pid) && !Long.valueOf(split[1]).equals(tid)) {
+                if (ObjectUtils.isNotEmpty(split[0]) && ObjectUtils.isNotEmpty(split[1]) && !Long.valueOf(split[0]).equals(pid) && !Long.valueOf(split[1]).equals(tid) && !Objects.isNull(split[2]) && !Long.valueOf(split[2]).equals(subid)) {
                     continue;
                 }
             } catch (Exception e) {
@@ -202,7 +216,7 @@
                                 //璇存槑鏄涓�棰�
                                 List<SvyTaskTemplateTargetoption> svyTaskTemplateTargetoptions = cacheList.get(0).getSvyTaskTemplateTargetoptions();
                                 svyTaskTemplateScriptVO.setSvyTaskTemplateTargetoptions(svyTaskTemplateTargetoptions);
-                                Map<String, String> map = setWJInfo(svyTaskTemplateScriptVO, tid, pid, null);
+                                Map<String, String> map = setWJInfo(svyTaskTemplateScriptVO, tid, pid, subid);
                                 if (map == null) continue aa;
                                 if (!Objects.isNull(map.get("nextScriptNo")))
                                     nextScriptno = Long.valueOf(map.get("nextScriptNo"));
@@ -224,7 +238,7 @@
 
                         if (svyTaskTemplateScriptVO.getSort() != null && svyTaskTemplateScriptVO.getSort().equals(nextScriptno)) {
 //                            log.error("svyTaskTemplateScriptVO鐨勫�间负锛歿}", svyTaskTemplateScriptVO);
-                            Map<String, String> map = setWJInfo(svyTaskTemplateScriptVO, Long.valueOf(split[1]), Long.valueOf(split[0]), null);
+                            Map<String, String> map = setWJInfo(svyTaskTemplateScriptVO, Long.valueOf(split[1]), Long.valueOf(split[0]), Objects.isNull(split[2]) ? null : Long.valueOf(split[2]));
                             log.error("nextScriptNo鐨勪俊鎭负锛歿}", map.get("nextScriptNo"));
                             if (!Objects.isNull(map.get("nextScriptNo")))
                                 nextScriptno = Long.valueOf(map.get("nextScriptNo"));
@@ -250,7 +264,7 @@
                                 List<IvrTaskTemplateTargetoption> ivrTaskTemplateTargetoptions = cacheList.get(0).getIvrTaskScriptTargetoptionList();
 //                                List<IvrTaskTemplateTargetoption> ivrTaskTemplateTargetoptions = DtoConversionUtils.sourceToTarget(ivrLibaTemplateTargetoptions, IvrTaskTemplateTargetoption.class);
                                 ivrTaskTemplateScriptVO.setIvrTaskScriptTargetoptionList(ivrTaskTemplateTargetoptions);
-                                Map<String, String> map = setSFInfo(ivrTaskTemplateScriptVO, tid, pid, null);
+                                Map<String, String> map = setSFInfo(ivrTaskTemplateScriptVO, tid, pid, subid);
                                 if (!Objects.isNull(map.get("nextScriptNo")))
                                     nextScriptno = Long.valueOf(map.get("nextScriptNo"));
                                 if (score == null) {
@@ -267,7 +281,7 @@
                         ivrTaskTemplateScriptVO.setIvrTaskScriptTargetoptionList(ivrTaskTemplateTargetoptions);
 
                         if (ivrTaskTemplateScriptVO.getSort() != null && Long.valueOf(ivrTaskTemplateScriptVO.getSort()).equals(nextScriptno)) {
-                            Map<String, String> map = setSFInfo(ivrTaskTemplateScriptVO, Long.valueOf(split[1]), Long.valueOf(split[0]), null);
+                            Map<String, String> map = setSFInfo(ivrTaskTemplateScriptVO, Long.valueOf(split[1]), Long.valueOf(split[0]), Objects.isNull(split[2]) ? null : Long.valueOf(split[2]));
                             log.error("----nextScriptNo2鐨勪俊鎭负锛歿}", map.get("nextScriptNo"));
                             if (!Objects.isNull(map.get("nextScriptNo")))
                                 nextScriptno = Long.valueOf(map.get("nextScriptNo"));
@@ -334,15 +348,24 @@
                 List<SvyTaskTemplateScriptVO> cacheList = serviceSubTaskCacheReq.getSvyTaskTemplateScriptVOS();
                 cacheList.sort(Comparator.comparingLong(SvyTaskTemplateScriptVO::getSort));
                 log.info("闂嵎鍥炵瓟缁撴灉锛歿}", cacheList);
+                // 棰勬煡璇㈠惊鐜腑涓嶅彉鐨勬暟鎹紝閬垮厤姣忛閲嶅鏌ユ暟鎹簱
+                ServiceSubtaskEntity preSubtaskVO = new ServiceSubtaskEntity();
+                preSubtaskVO.setTaskid(tid);
+                preSubtaskVO.setPatid(pid);
+                preSubtaskVO.setSubId(subid);
+                List<ServiceSubtask> preServiceSubtaskList = serviceSubtaskMapper.selectServiceSubtaskList(preSubtaskVO);
+                ServiceTask preServiceTask = serviceTaskService.selectServiceTaskByTaskid(tid);
+                Map<Long, Long> preDetailIdMap = getExistingDetailIdMap(subid);
+                Map<Long, Long> preTraceIdMap = getExistingTraceIdMap(subid);
                 for (int i = 0; i < cacheList.size(); i++) {
                     if (i == 0) {
                         //杩欎釜鏃堕棿瑕佹壘鍒扮涓�棰�
                         for (SvyTaskTemplateScriptVO svyTaskTemplateScriptVO : cacheList) {
                             if (svyTaskTemplateScriptVO.getSort() == 1L) {
                                 //璇存槑鏄涓�棰�
-                                List<SvyTaskTemplateTargetoption> svyTaskTemplateTargetoptions = cacheList.get(0).getSvyTaskTemplateTargetoptions();
+                                List<SvyTaskTemplateTargetoption> svyTaskTemplateTargetoptions = svyTaskTemplateScriptVO.getSvyTaskTemplateTargetoptions();
                                 svyTaskTemplateScriptVO.setSvyTaskTemplateTargetoptions(svyTaskTemplateTargetoptions);
-                                Map<String, String> map = setWJInfo(svyTaskTemplateScriptVO, tid, pid, subid);
+                                Map<String, String> map = setWJInfo(svyTaskTemplateScriptVO, tid, pid, subid, preServiceSubtaskList, preServiceTask, preDetailIdMap, preTraceIdMap);
                                 if (map == null) continue;
                                 if (!Objects.isNull(map.get("nextScriptNo")))
                                     nextScriptno = Long.valueOf(map.get("nextScriptNo"));
@@ -362,7 +385,7 @@
                         svyTaskTemplateScriptVO.setSvyTaskTemplateTargetoptions(svyTaskTemplateTargetoptions);
 
                         if (svyTaskTemplateScriptVO.getSort() != null && svyTaskTemplateScriptVO.getSort().equals(nextScriptno)) {
-                            Map<String, String> map = setWJInfo(svyTaskTemplateScriptVO, tid, pid, subid);
+                            Map<String, String> map = setWJInfo(svyTaskTemplateScriptVO, tid, pid, subid, preServiceSubtaskList, preServiceTask, preDetailIdMap, preTraceIdMap);
                             log.error("nextScriptNo鐨勪俊鎭负锛歿}", map.get("nextScriptNo"));
                             if (!Objects.isNull(map.get("nextScriptNo")))
                                 nextScriptno = Long.valueOf(map.get("nextScriptNo"));
@@ -377,9 +400,7 @@
                 }
             } else if (serviceSubTaskCacheReq.getType() == 1) {
                 List<IvrTaskTemplateScriptVO> cacheList = serviceSubTaskCacheReq.getIvrTaskTemplateScriptVOList();
-                cacheList.sort(Comparator.comparingLong(
-                        vo -> Optional.ofNullable(vo.getSort()).orElse(0)
-                ));
+                cacheList.sort(Comparator.comparingLong(vo -> Optional.ofNullable(vo.getSort()).orElse(0)));
                 log.error("鐢佃瘽闅忚闂嵎鍥炵瓟缁撴灉锛歿}", cacheList.size());
                 for (int i = 0; i < cacheList.size(); i++) {
                     if (i == 0) {
@@ -387,7 +408,7 @@
                         for (IvrTaskTemplateScriptVO ivrTaskTemplateScriptVO : cacheList) {
                             if (ivrTaskTemplateScriptVO.getSort() != null && ivrTaskTemplateScriptVO.getSort() == 1L) {
                                 //璇存槑鏄涓�棰�
-                                List<IvrTaskTemplateTargetoption> ivrTaskTemplateTargetoptions = cacheList.get(0).getIvrTaskScriptTargetoptionList();
+                                List<IvrTaskTemplateTargetoption> ivrTaskTemplateTargetoptions = ivrTaskTemplateScriptVO.getIvrTaskScriptTargetoptionList();
                                 ivrTaskTemplateScriptVO.setIvrTaskScriptTargetoptionList(ivrTaskTemplateTargetoptions);
                                 //瀹冧咯閮芥槸ivr_task_templatescript_id,鎵�浠ヨ繖閲岄渶瑕佽缃竴涓�
                                 ivrTaskTemplateScriptVO.setId(ivrTaskTemplateScriptVO.getScriptID());
@@ -431,6 +452,7 @@
             List<ServiceSubtask> serviceSubtaskList = serviceSubtaskMapper.selectServiceSubtaskList(ssVO);
 
             ServiceSubtask serviceSubtask = new ServiceSubtask();
+            serviceSubtask.setId(subid);
             serviceSubtask.setTaskid(tid);
             serviceSubtask.setPatid(pid);
             serviceSubtask.setSubmit(1L);
@@ -444,7 +466,9 @@
 
             //灏嗗綋鍓嶅彂閫佺姸鎬佹敼鎴�9瀹屾垚
             ServiceSubtaskPreachform serviceSubtaskPreachform = new ServiceSubtaskPreachform();
-            serviceSubtaskPreachform.setPreachform(serviceSubtaskList.get(0).getCurrentPreachform());
+            if (CollectionUtils.isNotEmpty(serviceSubtaskList)) {
+                serviceSubtaskPreachform.setPreachform(serviceSubtaskList.get(0).getCurrentPreachform());
+            }
             serviceSubtaskPreachform.setSubid(serviceSubtask.getId());
             serviceSubtaskPreachform.setTaskid(serviceSubtask.getTaskid());
             List<ServiceSubtaskPreachform> serviceSubtaskPreachforms = serviceSubtaskPreachformMapper.selectServiceSubtaskPreachformList(serviceSubtaskPreachform);
@@ -506,7 +530,7 @@
                             List<SvyTaskTemplateTargetoption> svyTaskTemplateTargetoptions = svyTaskTemplateScriptVOS.get(0).getSvyTaskTemplateTargetoptions();
 //                            List<SvyTaskTemplateTargetoption> svyTaskTemplateTargetoptions = DtoConversionUtils.sourceToTarget(svyTaskTemplateTargetoptions, SvyTaskTemplateTargetoption.class);
                             svyTaskTemplateScriptVO.setSvyTaskTemplateTargetoptions(svyTaskTemplateTargetoptions);
-                            Map<String, String> map = setWJInfo(svyTaskTemplateScriptVO, Long.valueOf(serviceSubTaskMYDAnswerReq.getTaskId()), patid, null);
+                            Map<String, String> map = setWJInfo(svyTaskTemplateScriptVO, Long.valueOf(serviceSubTaskMYDAnswerReq.getTaskId()), patid, serviceSubTaskMYDAnswerReq.getSubId());
                             if (map == null) continue;
                             if (!Objects.isNull(map.get("nextScriptNo")))
                                 nextScriptno = Long.valueOf(map.get("nextScriptNo"));
@@ -530,7 +554,7 @@
 
                     if (svyTaskTemplateScriptVO.getSort() != null && svyTaskTemplateScriptVO.getSort().equals(nextScriptno)) {
                         log.error("svyTaskTemplateScriptVO鐨勫�间负锛歿}", svyTaskTemplateScriptVO);
-                        Map<String, String> map = setWJInfo(svyTaskTemplateScriptVO, Long.valueOf(serviceSubTaskMYDAnswerReq.getTaskId()), patid, null);
+                        Map<String, String> map = setWJInfo(svyTaskTemplateScriptVO, Long.valueOf(serviceSubTaskMYDAnswerReq.getTaskId()), patid, serviceSubTaskMYDAnswerReq.getSubId());
                         log.error("map鐨勪俊鎭负锛歿}", map);
                         if (!Objects.isNull(map.get("nextScriptNo")))
                             nextScriptno = Long.valueOf(map.get("nextScriptNo"));
@@ -639,28 +663,33 @@
             RSAPublicKeyExample rsaPublicKeyExample = new RSAPublicKeyExample();
             Long tid = null;
             Long pid = null;
+            Long subid = null;
             if (flag == 0L) {
                 tid = Long.valueOf(rsaPublicKeyExample.decryptedData(serviceSubTaskCacheReq.getParam1(), pri_key));
                 pid = Long.valueOf(rsaPublicKeyExample.decryptedData(serviceSubTaskCacheReq.getParam2(), pri_key));
+                if (StringUtils.isNotEmpty(serviceSubTaskCacheReq.getParam6()))
+                    subid = Long.valueOf(rsaPublicKeyExample.decryptedData(serviceSubTaskCacheReq.getParam6(), pri_key));
+
             } else if (flag == 1L) {
                 tid = Long.valueOf(serviceSubTaskCacheReq.getParam1());
                 pid = Long.valueOf(serviceSubTaskCacheReq.getParam2());
+                subid = Long.valueOf(serviceSubTaskCacheReq.getParam6());
             }
             if (CollectionUtils.isNotEmpty(serviceSubTaskCacheReq.getSvyTaskTemplateScriptVOS()) && serviceSubTaskCacheReq.getSvyTaskTemplateScriptVOS().size() > 0) {
                 //闂嵎
-                redisCache.deleteObject(pid + "-" + tid + "-WJscriptCache");
-                redisCache.setCacheListRight(pid + "-" + tid + "-WJscriptCache", serviceSubTaskCacheReq.getSvyTaskTemplateScriptVOS());
+                redisCache.deleteObject(pid + "-" + tid + "-" + subid + "-WJscriptCache");
+                redisCache.setCacheListRight(pid + "-" + tid + "-" + subid + "-WJscriptCache", serviceSubTaskCacheReq.getSvyTaskTemplateScriptVOS());
                 //璁剧疆杩囨湡鏃堕棿 3澶�
                 Long tims = Long.valueOf(3 * 24 * 3600);
-                boolean expire = redisCache.expire(pid + "-" + tid + "-WJscriptCache", tims);
+                boolean expire = redisCache.expire(pid + "-" + tid + "-" + subid + "-WJscriptCache", tims);
                 return 1;
             } else if (CollectionUtils.isNotEmpty(serviceSubTaskCacheReq.getIvrTaskTemplateScriptVOList()) && serviceSubTaskCacheReq.getIvrTaskTemplateScriptVOList().size() > 0) {
                 //闂嵎
-                redisCache.deleteObject(pid + "-" + tid + "-SFscriptCache");
-                redisCache.setCacheListRight(pid + "-" + tid + "-SFscriptCache", serviceSubTaskCacheReq.getIvrTaskTemplateScriptVOList());
+                redisCache.deleteObject(pid + "-" + tid + "-" + subid + "-SFscriptCache");
+                redisCache.setCacheListRight(pid + "-" + tid + "-" + subid + "-SFscriptCache", serviceSubTaskCacheReq.getIvrTaskTemplateScriptVOList());
                 //璁剧疆杩囨湡鏃堕棿 3澶�
                 Long tims = Long.valueOf(3 * 24 * 3600);
-                redisCache.expire(pid + "-" + tid + "-SFscriptCache", tims);
+                redisCache.expire(pid + "-" + tid + "-" + subid + "-SFscriptCache", tims);
                 return 1;
             }
         } catch (Exception e) {
@@ -714,19 +743,20 @@
 
     @Override
     public Map<String, Object> selectPatQuestionResult(ServiceSubTaskQueryReq serviceSubTaskQueryReq) {
-        log.error("selectPatQuesTionResult鐨勫叆鍙備负锛歿}", serviceSubTaskQueryReq);
+        log.info("selectPatQuesTionResult鐨勫叆鍙備负锛歿}", serviceSubTaskQueryReq);
         Map<String, Object> map = new HashMap<>();
 
         //鑾峰彇鏈鐨勯棶绛旂粨鏋�
-        Map<String, Object> scriptInfoByCondition = serviceTaskService.getScriptInfoByCondition(serviceSubTaskQueryReq.getTaskid(), serviceSubTaskQueryReq.getPatid(), serviceSubTaskQueryReq.getIsFinish(), serviceSubTaskQueryReq.getPatfrom());
+        Map<String, Object> scriptInfoByCondition = serviceTaskService.getScriptInfoByCondition(serviceSubTaskQueryReq.getTaskid(), serviceSubTaskQueryReq.getPatid(), serviceSubTaskQueryReq.getIsFinish(), serviceSubTaskQueryReq.getPatfrom(), serviceSubTaskQueryReq.getSubId());
         map = getMap(scriptInfoByCondition, serviceSubTaskQueryReq.getSubId(), serviceSubTaskQueryReq.getPatid());
 
         //鑾峰彇涓婃鐨勯棶绛旂粨鏋�
         ServiceSubtask serviceSubtask = serviceSubtaskMapper.selectServiceSubtaskById(serviceSubTaskQueryReq.getSubId());
         map.put("upScriptResult", null);
+        map.put("templateName", serviceSubtask.getTemplatename());
         map.put("upTaskName", null);
         if (ObjectUtils.isNotEmpty(serviceSubtask) && serviceSubtask.getUpid() != null) {
-            Map<String, Object> scriptInfoByCondition2 = serviceTaskService.getScriptInfoByCondition(serviceSubTaskQueryReq.getTaskid(), serviceSubTaskQueryReq.getPatid(), serviceSubTaskQueryReq.getIsFinish(), serviceSubTaskQueryReq.getPatfrom());
+            Map<String, Object> scriptInfoByCondition2 = serviceTaskService.getScriptInfoByCondition(serviceSubTaskQueryReq.getTaskid(), serviceSubTaskQueryReq.getPatid(), serviceSubTaskQueryReq.getIsFinish(), serviceSubTaskQueryReq.getPatfrom(),serviceSubTaskQueryReq.getSubId());
             Map<String, Object> map1 = getMap(scriptInfoByCondition2, Long.valueOf(serviceSubtask.getUpid()), serviceSubTaskQueryReq.getPatid());
             if (!map1.isEmpty()) {
                 map.put("upScriptResult", map1.get("scriptResult"));
@@ -741,29 +771,31 @@
     private Map<String, Object> getMap(Map<String, Object> scriptInfoByCondition, Long subid, Long patid) {
         Map<String, Object> map = new HashMap<>();
         if (ObjectUtils.isNotEmpty(scriptInfoByCondition) && ObjectUtils.isNotEmpty(scriptInfoByCondition.get("script"))) {
-//            log.error("-----------scriptInfoByCondition鐨勫�间负锛歿}", scriptInfoByCondition);
             if (scriptInfoByCondition.get("type").equals("1")) {
                 List<IvrTaskTemplateScriptVO> ivrTaskTemplateScriptVOS = (List<IvrTaskTemplateScriptVO>) scriptInfoByCondition.get("script");
-//                List<IvrLibaTemplateScriptVO> ivrLibaTemplateScriptVOList = DtoConversionUtils.sourceToTarget(ivrTaskTemplateScriptVOS, IvrLibaTemplateScriptVO.class);
+                // 鎵归噺鏌ヨ鎵�鏈夋槑缁嗭紝閬垮厤寰幆涓�愭潯鏌ユ暟鎹簱锛圢+1闂浼樺寲锛�
+                Map<Long, ServiceSubtaskDetail> detailMap = getScriptResultMap(subid, patid);
                 for (IvrTaskTemplateScriptVO ivrTaskTemplateScriptVO : ivrTaskTemplateScriptVOS) {
-                    Map<String, String> scriptResult = getScriptResult(subid, patid, ivrTaskTemplateScriptVO.getId());
-                    if (ObjectUtils.isNotEmpty(scriptResult)) {
-                        ivrTaskTemplateScriptVO.setScriptResult(scriptResult.get("asrtext"));
-                        ivrTaskTemplateScriptVO.setScriptResultId(scriptResult.get("asrtextId"));
+                    ServiceSubtaskDetail detail = detailMap.get(ivrTaskTemplateScriptVO.getId());
+                    if (detail != null) {
+                        ivrTaskTemplateScriptVO.setScriptResult(detail.getAsrtext());
+                        ivrTaskTemplateScriptVO.setScriptResultId(String.valueOf(detail.getId()));
                     }
                 }
                 map.put("scriptResult", ivrTaskTemplateScriptVOS);
                 map.put("taskName", scriptInfoByCondition.get("taskName"));
             } else if (scriptInfoByCondition.get("type").equals("2")) {
                 List<SvyTaskTemplateScriptVO> svyTaskTemplateScriptVOList = (List) scriptInfoByCondition.get("script");
+                // 鎵归噺鏌ヨ鎵�鏈夋槑缁嗭紝閬垮厤寰幆涓�愭潯鏌ユ暟鎹簱锛圢+1闂浼樺寲锛�
+                Map<Long, ServiceSubtaskDetail> detailMap = getScriptResultMap(subid, patid);
                 for (SvyTaskTemplateScriptVO svyTaskTemplateScriptVO : svyTaskTemplateScriptVOList) {
-                    Map<String, String> scriptResult = getScriptResult(subid, patid, svyTaskTemplateScriptVO.getId());
-                    if (ObjectUtils.isNotEmpty(scriptResult)) {
-                        if (StringUtils.isNotEmpty(scriptResult.get("asrtext")))
-                            svyTaskTemplateScriptVO.setScriptResult(StringUtils.isNotEmpty(scriptResult.get("asrtext")) ? scriptResult.get("asrtext").replaceAll("^(\"|')(.*)\\1$", "$2") : "");
-                        svyTaskTemplateScriptVO.setScriptResultId(scriptResult.get("asrtextId"));
-                        if (StringUtils.isNotEmpty(scriptResult.get("answerps")))
-                            svyTaskTemplateScriptVO.setAnswerps(scriptResult.get("answerps"));
+                    ServiceSubtaskDetail detail = detailMap.get(svyTaskTemplateScriptVO.getId());
+                    if (detail != null) {
+                        if (StringUtils.isNotEmpty(detail.getAsrtext()))
+                            svyTaskTemplateScriptVO.setScriptResult(detail.getAsrtext().replaceAll("^(\"|')(.*)\\1$", "$2"));
+                        svyTaskTemplateScriptVO.setScriptResultId(String.valueOf(detail.getId()));
+                        if (StringUtils.isNotEmpty(detail.getAnswerps()))
+                            svyTaskTemplateScriptVO.setAnswerps(detail.getAnswerps());
                     }
                 }
                 map.put("scriptResult", svyTaskTemplateScriptVOList);
@@ -776,6 +808,31 @@
             }
         }
         return map;
+    }
+
+    /**
+     * 鎵归噺鏌ヨ瀛愪换鍔℃槑缁嗗苟鎸塻criptid鍒嗙粍锛岄伩鍏嶅惊鐜腑閫愭潯鏌ユ暟鎹簱
+     *
+     * @param subid 瀛愪换鍔D
+     * @param pid   鎮h�匢D
+     * @return key=scriptid, value=瀵瑰簲鐨勭涓�鏉erviceSubtaskDetail
+     */
+    private Map<Long, ServiceSubtaskDetail> getScriptResultMap(Long subid, Long pid) {
+        ServiceSubtaskDetail query = new ServiceSubtaskDetail();
+        query.setSubId(subid);
+        query.setPatid(pid);
+        List<ServiceSubtaskDetail> details = serviceSubtaskDetailMapper.selectServiceSubtaskDetailList(query);
+        if (CollectionUtils.isEmpty(details)) {
+            return Collections.emptyMap();
+        }
+        Map<Long, ServiceSubtaskDetail> result = new HashMap<>();
+        for (ServiceSubtaskDetail detail : details) {
+            // 鍚屼竴涓猻criptid鍙兘鏈夊鏉¤褰曪紝鍙彇绗竴鏉★紙涓庡師閫昏緫涓�鑷达級
+            if (!result.containsKey(detail.getScriptid())) {
+                result.put(detail.getScriptid(), detail);
+            }
+        }
+        return result;
     }
 
 
@@ -800,7 +857,54 @@
         ServiceSubtaskEntity serviceSubtaskVO = new ServiceSubtaskEntity();
         serviceSubtaskVO.setTaskid(taskid);
         serviceSubtaskVO.setPatid(patid);
+        serviceSubtaskVO.setSubId(subid);
         List<ServiceSubtask> selectServiceSubtaskList = serviceSubtaskMapper.selectServiceSubtaskList(serviceSubtaskVO);
+        ServiceTask serviceTask = serviceTaskService.selectServiceTaskByTaskid(taskid);
+        Map<Long, Long> existingDetailIdMap = getExistingDetailIdMap(subid);
+        Map<Long, Long> existingTraceIdMap = getExistingTraceIdMap(subid);
+        return setWJInfo(svyTaskTemplateScriptVO, taskid, patid, subid, selectServiceSubtaskList, serviceTask, existingDetailIdMap, existingTraceIdMap);
+    }
+
+    /**
+     * 鎵归噺鏌ヨ宸插瓨鍦ㄧ殑鏄庣粏璁板綍ID锛屾寜scriptid鍒嗙粍锛堥伩鍏嶅惊鐜腑閫愭潯鏌ヨ锛�
+     */
+    private Map<Long, Long> getExistingDetailIdMap(Long subid) {
+        if (subid == null) return Collections.emptyMap();
+        ServiceSubtaskDetail query = new ServiceSubtaskDetail();
+        query.setSubId(subid);
+        List<ServiceSubtaskDetail> details = serviceSubtaskDetailMapper.selectServiceSubtaskDetailList(query);
+        if (CollectionUtils.isEmpty(details)) return Collections.emptyMap();
+        Map<Long, Long> map = new HashMap<>();
+        for (ServiceSubtaskDetail d : details) {
+            if ((d.getDelFlag() == null || "0".equals(d.getDelFlag())) && d.getScriptid() != null && !map.containsKey(d.getScriptid())) {
+                map.put(d.getScriptid(), d.getId());
+            }
+        }
+        return map;
+    }
+
+    /**
+     * 鎵归噺鏌ヨ寮傚父璺熻釜璁板綍ID锛屾寜scriptid鍒嗙粍锛堥伩鍏嶅惊鐜腑閫愭潯鏌ヨ锛�
+     */
+    private Map<Long, Long> getExistingTraceIdMap(Long subid) {
+        if (subid == null) return Collections.emptyMap();
+        ServiceSubtaskDetailTraceVO query = new ServiceSubtaskDetailTraceVO();
+        query.setSubId(subid);
+        List<ServiceSubtaskDetailTrace> traces = traceService.selectServiceSubtaskDetailTtraceList(query);
+        if (CollectionUtils.isEmpty(traces)) return Collections.emptyMap();
+        Map<Long, Long> map = new HashMap<>();
+        for (ServiceSubtaskDetailTrace t : traces) {
+            if (t.getScriptid() != null && !map.containsKey(t.getScriptid())) {
+                map.put(t.getScriptid(), t.getId());
+            }
+        }
+        return map;
+    }
+
+    private Map<String, String> setWJInfo(SvyTaskTemplateScriptVO svyTaskTemplateScriptVO, Long taskid, Long patid, Long subid,
+                                           List<ServiceSubtask> selectServiceSubtaskList, ServiceTask serviceTask,
+                                           Map<Long, Long> existingDetailIdMap, Map<Long, Long> existingTraceIdMap) {
+        log.error("-----svyTaskTemplateScriptVO鐨勫�间负锛歿}", svyTaskTemplateScriptVO);
         String score = "0";
         //涓嬮璺宠浆
         String nextScriptNo = null;
@@ -818,6 +922,9 @@
 
             }
             nextScriptNo = svyTaskTemplateScriptVO.getNextScriptno();
+            if (StringUtils.isEmpty(nextScriptNo)) {
+                nextScriptNo = getNextScriptNo(svyTaskTemplateScriptVO.getTemplateID(), svyTaskTemplateScriptVO.getScriptContent());
+            }
             if (svyTaskTemplateScriptVO.getScore() != null) {
                 score = String.valueOf(svyTaskTemplateScriptVO.getScore());
             }
@@ -832,10 +939,14 @@
                     score = String.valueOf(svyTaskTemplateScriptVO.getScore());
                 }
             }
-            nextScriptNo = svyTaskTemplateScriptVO.getNextScriptno().toString();
+            nextScriptNo = svyTaskTemplateScriptVO.getNextScriptno();
+            if (StringUtils.isEmpty(nextScriptNo)) {
+                nextScriptNo = getNextScriptNo(svyTaskTemplateScriptVO.getTemplateID(), svyTaskTemplateScriptVO.getScriptContent());
+            }
         }
-        ServiceTask serviceTask = serviceTaskService.selectServiceTaskByTaskid(taskid);
         serviceSubtaskDetailVO.setQuestiontext(svyTaskTemplateScriptVO.getScriptContent());
+        serviceSubtaskDetailVO.setIsMydException(svyTaskTemplateScriptVO.getIsMydException());
+        serviceSubtaskDetailVO.setDimension(svyTaskTemplateScriptVO.getDimension());
         serviceSubtaskDetailVO.setCategoryid(svyTaskTemplateScriptVO.getCategoryid());
         serviceSubtaskDetailVO.setTaskid(Long.valueOf(taskid));
         serviceSubtaskDetailVO.setTargetid(svyTaskTemplateScriptVO.getTargetid() != null ? svyTaskTemplateScriptVO.getTargetid().intValue() : null);
@@ -847,9 +958,7 @@
         serviceSubtaskDetailVO.setCreateTime(new Date());
         serviceSubtaskDetailVO.setUpdateTime(new Date());
         serviceSubtaskDetailVO.setTemplateType(2);
-        serviceSubtaskDetailVO.setLibTemplateid(CollectionUtils.isNotEmpty(selectServiceSubtaskList) ?
-                (ObjectUtils.isNotEmpty(selectServiceSubtaskList.get(0).getLibtemplateid()) ?
-                        selectServiceSubtaskList.get(0).getLibtemplateid().intValue() : null): null);
+        serviceSubtaskDetailVO.setLibTemplateid(CollectionUtils.isNotEmpty(selectServiceSubtaskList) ? (ObjectUtils.isNotEmpty(selectServiceSubtaskList.get(0).getLibtemplateid()) ? selectServiceSubtaskList.get(0).getLibtemplateid().intValue() : null) : null);
         if (ObjectUtils.isNotEmpty(serviceTask)) {
             serviceSubtaskDetailVO.setGuid(serviceTask.getGuid());
             serviceSubtaskDetailVO.setOrgid(serviceTask.getOrgid());
@@ -858,10 +967,10 @@
         serviceSubtaskDetailVO.setTemplatequestionnum(svyTaskTemplateScriptVO.getId());
         ServiceSubtaskDetail serviceSubtaskDetail = DtoConversionUtils.sourceToTarget(serviceSubtaskDetailVO, ServiceSubtaskDetail.class);
 
-        //鍏堢敤subid鍜宻criptid鏌ヨ涓�涓嬫槸鍚﹀瓨鍦紝濡傛灉瀛樺湪鍒欐洿鏂帮紝涓嶅瓨鍦ㄥ垯鎻掑叆
-        ServiceSubtaskDetailDTO existServiceSubtaskDetail = serviceSubtaskDetailMapper.isExistServiceSubtaskDetail(serviceSubtaskDetailVO.getSubId(), serviceSubtaskDetailVO.getScriptid());
-        if (ObjectUtils.isNotEmpty(existServiceSubtaskDetail)) {
-            serviceSubtaskDetail.setId(existServiceSubtaskDetail.getId());
+        //鍏堢敤subid鍜宻criptid鏌ヨ涓�涓嬫槸鍚﹀瓨鍦紝濡傛灉瀛樺湪鍒欐洿鏂帮紝涓嶅瓨鍦ㄥ垯鎻掑叆锛堜娇鐢ㄩ鏌ヨ鐨凪ap锛岄伩鍏嶉�愭潯鏌ユ暟鎹簱锛�
+        Long existDetailId = existingDetailIdMap.get(serviceSubtaskDetailVO.getScriptid());
+        if (existDetailId != null) {
+            serviceSubtaskDetail.setId(existDetailId);
             serviceSubtaskDetail.setUpdateTime(new Date());
             serviceSubtaskDetailMapper.updateServiceSubtaskDetail(serviceSubtaskDetail);
         } else {
@@ -872,12 +981,12 @@
         SvyTaskTemplateTargetoption stt = null;
         Long isabnormalFlag = 0L;
         for (SvyTaskTemplateTargetoption svyTaskTemplateTargetoption : svyTaskTemplateScriptVO.getSvyTaskTemplateTargetoptions()) {
-            if (svyTaskTemplateTargetoption.getOptioncontent().trim().equals(svyTaskTemplateScriptVO.getScriptResult()))
+            if (StringUtils.isNotEmpty(svyTaskTemplateTargetoption.getOptioncontent()) && svyTaskTemplateTargetoption.getOptioncontent().trim().equals(svyTaskTemplateScriptVO.getScriptResult()))
                 stt = svyTaskTemplateTargetoption;
         }
 
         //鍒ゆ柇涓�涓嬪綋鍓嶇殑闂鏄笉鏄弧鎰忓害闂锛屽苟涓攄utyDeptCode鏄惁鏈夊�硷紝骞朵笖閫夐」鏄笉鏄紓甯搁�夐」锛屽鏋滃叏绗﹀悎锛屽垯寰�婊℃剰搴﹂棶棰樺紓甯歌〃鏂板
-        if (StringUtils.isNotEmpty(svyTaskTemplateScriptVO.getDutyDeptCode()) && 1 == stt.getIsabnormal()) {
+        if (StringUtils.isNotEmpty(svyTaskTemplateScriptVO.getDutyDeptCode()) && stt != null && 1 == stt.getIsabnormal()) {
             isabnormalFlag = 1L;
             ServiceSubtaskDetailTrace subtaskDetailTrace = new ServiceSubtaskDetailTrace();
             subtaskDetailTrace.setDetailId(serviceSubtaskDetail.getId());
@@ -919,23 +1028,16 @@
             subtaskDetailTrace.setUpdateTime(new Date());
             subtaskDetailTrace.setOrgid(selectServiceSubtaskList.get(0).getOrgid());
 
-            ServiceSubtaskDetailTraceVO ssdt = new ServiceSubtaskDetailTraceVO();
-            ssdt.setSubId(subtaskDetailTrace.getSubId());
-            ssdt.setScriptid(subtaskDetailTrace.getScriptid());
-            ssdt.setTemplateType(subtaskDetailTrace.getTemplateType());
-            List<ServiceSubtaskDetailTrace> serviceSubtaskDetailTraces = traceService.selectServiceSubtaskDetailTtraceList(ssdt);
-            if (CollectionUtils.isNotEmpty(serviceSubtaskDetailTraces)) {
-                subtaskDetailTrace.setId(serviceSubtaskDetailTraces.get(0).getId());
+            Long existTraceId = existingTraceIdMap.get(subtaskDetailTrace.getScriptid());
+            if (existTraceId != null) {
+                subtaskDetailTrace.setId(existTraceId);
                 traceService.updateServiceSubtaskDetailTtrace(subtaskDetailTrace);
             } else traceService.insertServiceSubtaskDetailTtrace(subtaskDetailTrace);
         } else if (ObjectUtils.isNotEmpty(stt) && stt.getIsabnormal() != 1L) {
             //杩欓噷涓昏鏄�曞尰鎶や汉鍛樻妸寮傚父閫夐」鏀规垚浜嗛潪寮傚父鐨勶紝杩欓噷灏遍渶瑕佹煡涓�涓嬭繖鏉℃暟鎹槸涓嶆槸鍦ㄦ弧鎰忓害寮傚父琛紝濡傛灉鍦紝鍒欒鍒犻櫎
-            ServiceSubtaskDetailTraceVO subtaskDetailTraceVO = new ServiceSubtaskDetailTraceVO();
-            subtaskDetailTraceVO.setSubId(serviceSubtaskDetailVO.getSubId());
-            subtaskDetailTraceVO.setScriptid(svyTaskTemplateScriptVO.getId());
-            List<ServiceSubtaskDetailTrace> serviceSubtaskDetailTraces = traceService.selectServiceSubtaskDetailTtraceList(subtaskDetailTraceVO);
-            if (CollectionUtils.isNotEmpty(serviceSubtaskDetailTraces)) {
-                traceService.deleteServiceSubtaskDetailTtraceById(serviceSubtaskDetailTraces.get(0).getId());
+            Long existTraceId = existingTraceIdMap.get(svyTaskTemplateScriptVO.getId());
+            if (existTraceId != null) {
+                traceService.deleteServiceSubtaskDetailTtraceById(existTraceId);
             }
         }
 
@@ -953,6 +1055,33 @@
         map.put("isabnormal", isabnormalFlag.toString());
         return map;
     }
+
+    private String getNextScriptNo(Long taskTemplateID, String scriptContent) {
+        SvyTaskTemplate svyTaskTemplate = svyTaskTemplateService.selectSvyTaskTemplateBySvyid(taskTemplateID);
+        SvyLibTemplateScript svyLibTemplateScript = new SvyLibTemplateScript();
+        svyLibTemplateScript.setSvyid(svyTaskTemplate.getTemplateid());
+        svyLibTemplateScript.setScriptContent(scriptContent);
+        List<SvyLibTemplateScript> svyLibTemplateScriptList = svyLibTemplateScriptService.selectSvyLibTemplateScriptList(svyLibTemplateScript);
+        if (CollectionUtils.isNotEmpty(svyLibTemplateScriptList)) {
+            return svyLibTemplateScriptList.get(0).getNextScriptno();
+        }
+        return null;
+    }
+
+    private Long getVoiceNextScriptNo(Long taskTemplateID, String scriptContent) {
+        IvrTaskTemplate ivrTaskTemplate = ivrTaskTemplateService.selectIvrTaskTemplateByID(taskTemplateID);
+        IvrLibaTemplateScript ivrLibaTemplateScript = new IvrLibaTemplateScript();
+        if (StringUtils.isEmpty(ivrTaskTemplate.getLibtemplateid())) return null;
+        ivrLibaTemplateScript.setTemplateid(Long.valueOf(ivrTaskTemplate.getLibtemplateid()));
+        ivrLibaTemplateScript.setScriptContent(scriptContent);
+        List<IvrLibaTemplateScript> ivrLibaTemplateScriptList = ivrLibaTemplateScriptService.selectIvrLibaTemplateScriptList(ivrLibaTemplateScript);
+
+        if (CollectionUtils.isNotEmpty(ivrLibaTemplateScriptList)) {
+            return ivrLibaTemplateScriptList.get(0).getNextScriptno();
+        }
+        return null;
+    }
+
 
     private Boolean sendTaskIds(List<Integer> sendTaskids, ServiceSubtask serviceSubtask) {
         for (Integer taskId : sendTaskids) {
@@ -1041,6 +1170,7 @@
         ServiceSubtaskEntity serviceSubtaskVO = new ServiceSubtaskEntity();
         serviceSubtaskVO.setTaskid(taskid);
         serviceSubtaskVO.setPatid(patid);
+        serviceSubtaskVO.setSubId(subid);
         List<ServiceSubtask> selectServiceSubtaskList = serviceSubtaskMapper.selectServiceSubtaskList(serviceSubtaskVO);
 
         String score = "0";
@@ -1060,6 +1190,10 @@
 
             }
             nextScriptNo = ivrTaskTemplateScriptVO.getNextScriptno() == null ? null : ivrTaskTemplateScriptVO.getNextScriptno().toString();
+            if (StringUtils.isEmpty(nextScriptNo)) {
+                nextScriptNo = "" + getVoiceNextScriptNo(ivrTaskTemplateScriptVO.getTemplateID(), ivrTaskTemplateScriptVO.getScriptContent());
+            }
+
             if (ivrTaskTemplateScriptVO.getScore() != null) {
                 score = String.valueOf(ivrTaskTemplateScriptVO.getScore());
             }
@@ -1078,6 +1212,9 @@
                 serviceSubtaskDetailVO.setMatchedtext(ivrTaskTemplateScriptVO.getQuestionResult() != null ? ivrTaskTemplateScriptVO.getQuestionResult().replaceAll("^\"|\"$", "") : ivrTaskTemplateScriptVO.getIvrtext());
                 serviceSubtaskDetailVO.setScore(ivrTaskTemplateScriptVO.getScore() != null ? ivrTaskTemplateScriptVO.getScore().toString() : "0");
                 nextScriptNo = ivrTaskTemplateScriptVO.getNextScriptno() == null ? null : ivrTaskTemplateScriptVO.getNextScriptno().toString();
+                if (StringUtils.isEmpty(nextScriptNo)) {
+                    nextScriptNo = "" + getVoiceNextScriptNo(ivrTaskTemplateScriptVO.getTemplateID(), ivrTaskTemplateScriptVO.getScriptContent());
+                }
                 if (ivrTaskTemplateScriptVO.getScore() != null) {
                     score = String.valueOf(ivrTaskTemplateScriptVO.getScore());
                 }

--
Gitblit v1.9.3