From 7913a655b4f017eea4e8f95e34232143f92ecaaf Mon Sep 17 00:00:00 2001 From: liusheng <337615773@qq.com> Date: 星期五, 21 三月 2025 18:22:08 +0800 Subject: [PATCH] 代码提交 --- smartor/src/main/java/com/smartor/service/impl/PatMedInhospServiceImpl.java | 19 +++++++++ smartor/src/main/resources/mapper/smartor/PatMedInhospMapper.xml | 23 +++++++---- ruoyi-admin/src/main/resources/application-druid.yml | 16 ++++---- smartor/src/main/java/com/smartor/service/impl/ServiceExternalServiceImpl.java | 13 ++++++ smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskDetailServiceImpl.java | 4 +- smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskAnswerServiceImpl.java | 7 +++ smartor/src/main/java/com/smartor/mapper/PatMedInhospMapper.java | 2 + 7 files changed, 63 insertions(+), 21 deletions(-) diff --git a/ruoyi-admin/src/main/resources/application-druid.yml b/ruoyi-admin/src/main/resources/application-druid.yml index 8fefd43..8466ffb 100644 --- a/ruoyi-admin/src/main/resources/application-druid.yml +++ b/ruoyi-admin/src/main/resources/application-druid.yml @@ -18,16 +18,16 @@ # password: Smartor.2023 # driverClassName: com.mysql.cj.jdbc.Driver # # 鏂板崕 - url: jdbc:mysql://192.168.191.181:3308/smartor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 - username: smartor - password: Smartor.2023 - driverClassName: com.mysql.cj.jdbc.Driver +# url: jdbc:mysql://192.168.191.181:3308/smartor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 +# username: smartor +# password: Smartor.2023 +# driverClassName: com.mysql.cj.jdbc.Driver # # 鍏徃浜� -# url: jdbc:mysql://116.62.18.175:6002/smartor?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 -# username: hxsoft -# password: Hxerp2000 -# driverClassName: com.mysql.cj.jdbc.Driver + url: jdbc:mysql://116.62.18.175:6002/smartor_lisui?useUnicode=true&characterEncoding=utf8&zeroDateTimeBehavior=convertToNull&useSSL=true&serverTimezone=GMT%2B8 + username: hxsoft + password: Hxerp2000 + driverClassName: com.mysql.cj.jdbc.Driver # 浠庡簱鏁版嵁婧� diff --git a/smartor/src/main/java/com/smartor/mapper/PatMedInhospMapper.java b/smartor/src/main/java/com/smartor/mapper/PatMedInhospMapper.java index cf4f822..acb6246 100644 --- a/smartor/src/main/java/com/smartor/mapper/PatMedInhospMapper.java +++ b/smartor/src/main/java/com/smartor/mapper/PatMedInhospMapper.java @@ -24,6 +24,8 @@ */ public PatMedInhosp selectPatMedInhospByInhospid(Long inhospid); + public String getTagnameBypatid(Long patid); + /** * 鏌ヨ鎮h�呬綇闄㈣褰曞垪琛� * diff --git a/smartor/src/main/java/com/smartor/service/impl/PatMedInhospServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/PatMedInhospServiceImpl.java index 9bb730c..2ef79d9 100644 --- a/smartor/src/main/java/com/smartor/service/impl/PatMedInhospServiceImpl.java +++ b/smartor/src/main/java/com/smartor/service/impl/PatMedInhospServiceImpl.java @@ -83,7 +83,12 @@ */ @Override public List<PatMedInhosp> selectPatMedInhospList(PatMedInhosp patMedInhosp) { - return patMedInhospMapper.selectPatMedInhospList(patMedInhosp); + List<PatMedInhosp> patMedInhospList = patMedInhospMapper.selectPatMedInhospList(patMedInhosp); + for (PatMedInhosp patMedInhosp1 : patMedInhospList) { + String tagname = patMedInhospMapper.getTagnameBypatid(patMedInhosp1.getPatid()); + patMedInhosp1.setTagname(tagname); + } + return patMedInhospList; } /** @@ -206,6 +211,10 @@ patMedInhosp.setInhospstate("1"); List<PatMedInhosp> patMedInhosps = patMedInhospMapper.selectPatMedInhospList(patMedInhosp); log.error("dealOutHospInfo闇�瑕佸鐞嗙殑鍑洪櫌鎮h�呬俊鎭細{}", patMedInhosps); + for (PatMedInhosp patMedInhosp1 : patMedInhosps) { + String tagname = patMedInhospMapper.getTagnameBypatid(patMedInhosp1.getPatid()); + patMedInhosp1.setTagname(tagname); + } for (PatMedInhosp patMedInhosp1 : patMedInhosps) { //鍏堟牴鎹瀹ゅ幓service_check鏌ヨcheck_visit_flag鏄牴鎹�滅瀹も�濋殢璁匡紝杩樻槸鏍规嵁鈥滅涓�璇婃柇鈥濋殢璁� @@ -284,6 +293,10 @@ patMedInhosp.setCheckFlag("0"); patMedInhosp.setInhospstate("0"); List<PatMedInhosp> patMedInhospList = patMedInhospMapper.selectPatMedInhospList(patMedInhosp); + for (PatMedInhosp patMedInhosp1 : patMedInhosps) { + String tagname = patMedInhospMapper.getTagnameBypatid(patMedInhosp1.getPatid()); + patMedInhosp1.setTagname(tagname); + } if (CollectionUtils.isNotEmpty(patMedInhospList) && patMedInhospList.size() > 0) { dealInHospInfo(patMedInhospList); } @@ -305,6 +318,10 @@ @Override public List<PatMedInhosp> getDocAndPat(PatMedInhosp patMedInhosp) { List<PatMedInhosp> patMedInhospList = patMedInhospMapper.selectPatMedInhospList(patMedInhosp); + for (PatMedInhosp patMedInhosp1 : patMedInhospList) { + String tagname = patMedInhospMapper.getTagnameBypatid(patMedInhosp1.getPatid()); + patMedInhosp1.setTagname(tagname); + } if (StringUtils.isNotEmpty(patMedInhosp.getPatname()) || StringUtils.isNotEmpty(patMedInhosp.getNurseName()) || StringUtils.isNotEmpty(patMedInhosp.getDrname())) { //鑾峰彇澶栭儴瀵煎叆淇℃伅,骞跺皢澶栭儴鎮h�呮斁鍒皃atMedInhospList涓� PatArchiveImport patArchiveImport = new PatArchiveImport(); diff --git a/smartor/src/main/java/com/smartor/service/impl/ServiceExternalServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/ServiceExternalServiceImpl.java index bb2faa7..2b2cc4e 100644 --- a/smartor/src/main/java/com/smartor/service/impl/ServiceExternalServiceImpl.java +++ b/smartor/src/main/java/com/smartor/service/impl/ServiceExternalServiceImpl.java @@ -246,6 +246,10 @@ PatMedInhosp patMedInhosp = new PatMedInhosp(); patMedInhosp.setInhospno(externalInHospPatientInfo.getZhuYuanHao()); List<PatMedInhosp> patMedInhospList = patMedInhospMapper.selectPatMedInhospList(patMedInhosp); + for (PatMedInhosp patMedInhosp1 : patMedInhospList) { + String tagname = patMedInhospMapper.getTagnameBypatid(patMedInhosp1.getPatid()); + patMedInhosp1.setTagname(tagname); + } if (CollectionUtils.isNotEmpty(patMedInhospList)) { Map<String, Object> JiuZhenXX = (Map<String, Object>) yeWuXX.get("JiuZhenXX"); PatMedInhosp patMedInhosp1 = patMedInhospList.get(0); @@ -309,7 +313,10 @@ PatMedInhosp patMedInhosp = new PatMedInhosp(); patMedInhosp.setInhospno(externalInHospPatientInfo.getZhuYuanHao()); List<PatMedInhosp> patMedInhospList = patMedInhospMapper.selectPatMedInhospList(patMedInhosp); - + for (PatMedInhosp patMedInhosp1 : patMedInhospList) { + String tagname = patMedInhospMapper.getTagnameBypatid(patMedInhosp1.getPatid()); + patMedInhosp1.setTagname(tagname); + } Map<String, Object> JiuZhenXX = (Map<String, Object>) yeWuXX.get("JiuZhenXX"); PatMedInhosp patMedInhosp1 = new PatMedInhosp(); if (CollectionUtils.isNotEmpty(patMedInhospList)) patMedInhosp1 = patMedInhospList.get(0); @@ -373,6 +380,10 @@ PatMedInhosp patMedInhosp = new PatMedInhosp(); patMedInhosp.setInhospno(externalInHospPatientInfo.getZhuYuanHao()); List<PatMedInhosp> patMedInhospList = patMedInhospMapper.selectPatMedInhospList(patMedInhosp); + for (PatMedInhosp patMedInhosp1 : patMedInhospList) { + String tagname = patMedInhospMapper.getTagnameBypatid(patMedInhosp1.getPatid()); + patMedInhosp1.setTagname(tagname); + } if (CollectionUtils.isNotEmpty(patMedInhospList)) { Map<String, Object> JiuZhenXX = (Map<String, Object>) yeWuXX.get("JiuZhenXX"); PatMedInhosp patMedInhosp1 = patMedInhospList.get(0); 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 f127144..265a0c7 100644 --- a/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskAnswerServiceImpl.java +++ b/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskAnswerServiceImpl.java @@ -155,7 +155,12 @@ for (String key : allKeys) { String[] split = key.split("-"); //鍏堝垽鏂紝鏄笉鏄綋鍓嶆彁浜や汉鐨勶紝涓嶆槸褰撳墠鎻愪氦浜虹殑锛岃烦杩� - if (ObjectUtils.isNotEmpty(split[0]) && ObjectUtils.isNotEmpty(split[1]) && Long.valueOf(split[0]) != pid && Long.valueOf(split[1]) != tid) { + try { + if (ObjectUtils.isNotEmpty(split[0]) && ObjectUtils.isNotEmpty(split[1]) && Long.valueOf(split[0]) != pid && Long.valueOf(split[1]) != tid) { + continue; + } + } catch (Exception e) { + //杩欓噷涔嬫墍浠ヨ澶勭悊寮傚父锛屾槸鍥犱负鏈夌殑KEY灏变笉鏄垜浠鐨凨EY,娌℃湁鍘绘埅鍙栵紱鏈夊紓甯镐笉澶勭悊锛岀洿鎺ヤ笅涓�涓� continue; } if (key.contains("-WJscriptCache")) { diff --git a/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskDetailServiceImpl.java b/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskDetailServiceImpl.java index 6554d27..706566b 100644 --- a/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskDetailServiceImpl.java +++ b/smartor/src/main/java/com/smartor/service/impl/ServiceSubtaskDetailServiceImpl.java @@ -246,7 +246,6 @@ Long totalCount = serviceSubtaskDetailTargets.stream().filter(target -> target.getMatchedtext() == null || target.getMatchedtext().isEmpty()).mapToLong(target -> target.getCount() != null ? target.getCount() : 0) // 纭繚 count 涓� 0 濡傛灉涓� null .sum(); - Long allShowCount = 0L; // 閬嶅巻鍒楄〃锛屽皢 matchedText 涓�""璧嬪�肩粰 null @@ -272,7 +271,8 @@ target.setTargetShowCount(allShowCount.toString()); BigDecimal count = new BigDecimal(target.getCount() != null ? target.getCount().toString() : "0"); BigDecimal allCount = new BigDecimal(allShowCount.toString()); - target.setPercentage(count.divide(allCount, 2, RoundingMode.HALF_UP).toString()); + if (allCount.compareTo(BigDecimal.ZERO) == 0) + target.setPercentage(count.divide(allCount, 2, RoundingMode.HALF_UP).toString()); } } diff --git a/smartor/src/main/resources/mapper/smartor/PatMedInhospMapper.xml b/smartor/src/main/resources/mapper/smartor/PatMedInhospMapper.xml index 332b6ca..9a114e5 100644 --- a/smartor/src/main/resources/mapper/smartor/PatMedInhospMapper.xml +++ b/smartor/src/main/resources/mapper/smartor/PatMedInhospMapper.xml @@ -170,14 +170,14 @@ b.deptid, b.leaveldeptid, b.long_task_reason, - b.schemetime, - COALESCE ( - ( - SELECT string_agg(d.tagname, ', ') - FROM pat_archivetag d - WHERE d.patid = a.id - AND d.del_flag = 0 - ), '') AS tagname + b.schemetime + -- COALESCE ( + -- ( + -- SELECT GROUP_CONCAT(d.tagname, ', ') + -- FROM pat_archivetag d + -- WHERE d.patid = a.id + -- AND d.del_flag = 0 + -- ), '') AS tagname FROM pat_med_inhosp b JOIN @@ -359,6 +359,13 @@ order by b.inhospid desc </select> + <select id="getTagnameBypatid" parameterType="Long" resultType="string"> + SELECT GROUP_CONCAT(d.tagname, ', ') + FROM pat_archivetag d + WHERE d.patid = #{patid} + AND d.del_flag = 0 + </select> + <select id="selectPatMedInhospByInhospid" parameterType="Long" resultMap="PatMedInhospResult"> <include refid="selectPatMedInhospVo"/> -- Gitblit v1.9.3