From 33de5e90c14e44e1639c961a48e338c1da3d5624 Mon Sep 17 00:00:00 2001
From: zjh <zjh@888>
Date: 星期三, 26 六月 2024 16:51:56 +0800
Subject: [PATCH] zjh 本地 2024/06/26 --2

---
 ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCheckController.java |  164 ++++++++++++++++++++++++++++++++----------------------
 1 files changed, 98 insertions(+), 66 deletions(-)

diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCheckController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCheckController.java
index 355843d..f9779ba 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCheckController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/TjCheckController.java
@@ -2,6 +2,7 @@
 
 import cn.hutool.core.date.DateTime;
 import cn.hutool.core.date.DateUtil;
+import cn.hutool.core.util.StrUtil;
 import cn.hutool.json.JSONArray;
 import cn.hutool.json.JSONObject;
 import cn.hutool.json.JSONUtil;
@@ -40,6 +41,7 @@
 import org.springframework.web.bind.annotation.*;
 
 import javax.annotation.Resource;
+import java.math.BigDecimal;
 import java.util.*;
 import java.util.stream.Collectors;
 
@@ -316,6 +318,7 @@
     @GetMapping("/dataSynchronization")
     @ApiOperation(value = "鍚屾sql server鏁版嵁鍒版湰鍦版暟鎹簱鏁版嵁鎺ュ彛")
     @RepeatSubmit
+    @Transactional
     public AjaxResult dataSynchronization(@RequestParam String tjNumber) {
         //鏍规嵁閰嶇疆璋冨彇瀛樺偍杩囩▼ 灏嗕复鏃惰〃鏁版嵁瀛樺叆棰勭害琛�2023.12.12
         final String getInfoFromSqlData = configService.selectConfigByKey("getInfoFromSqlData");
@@ -352,78 +355,89 @@
         //寮�鍚拰his瀵规帴
         if(null !=sfkqdyhis && sfkqdyhis.equals("Y")){
 
-            String baoGaoDan = ltkjHybgdService.getJianYanBaoGaoDan(order.getCardId());
-            if(null !=baoGaoDan){
-                Date dates = new Date();
-                Map<String,Object> map=new HashMap<>();
-                map.put("his_registration_id",order.getCardId());
-                map.put("ksbm","");
-                map.put("pationid","");
-                map.put("ksrq",DateUtil.format(DateUtil.beginOfDay(dates), "yyyy-MM-dd HH:mm:ss"));
-                map.put("jsrq",DateUtil.format(DateUtil.endOfDay(dates), "yyyy-MM-dd HH:mm:ss"));
-                map.put("pagecount",10);
-                map.put("page",1);
-                AjaxResult result = controller.Getlabreportinfo(map);
-                String result1 = getAjaxResult(result);
-                JSONObject object = getJSONObject(result1);
-                String code = object.getStr("ResultCode");
-                if(null ==code || !code.equals("0")){
-                    return AjaxResult.error("鍖栭獙椤圭洰鏆傛椂鏃犵粨鏋�,璇风◢鍚庡悓姝�!!!");
-                }
-                JSONArray data = object.getJSONArray("ResultData");
-                for (Object datum : data) {
-                    JSONObject jsonObject = (JSONObject)datum;
-                    LtkjHysqd jybgid = ltkjHysqdService.getLtkjHysqdByTjhAndTmh(order.getCardId(), jsonObject.getStr("JYBGID"));
-                    if(null !=jybgid){
-                        continue;
+            List<String> baoGaoDans = ltkjHybgdService.getJianYanBaoGaoDan(order.getCardId());
+            if(null !=baoGaoDans && baoGaoDans.size()>0){
+
+//                List<LtkjHysqd> one = testMapper.getHysqdByTmh(order.getCardId());
+//                if (one != null && one.size() > 0) {
+//                    for (LtkjHysqd ltkjHysqd : one) {
+//                        ltkjHysqdService.deletedLtkjHysqdByTjhAndTmh(ltkjHysqd.getTjh(), ltkjHysqd.getTmh());
+//                        ltkjHybgdService.deletedLtkjHybgdByTjhAndTmh(ltkjHysqd.getTmh());
+//                    }
+//                }
+//                for (String baoGaoDan : baoGaoDans) {
+//                    Date dates = new Date();
+                    Map<String,Object> map=new HashMap<>();
+                    map.put("his_registration_id",order.getCardId());
+                    map.put("ksbm","");
+                    map.put("pationid","");
+                    map.put("ksrq",DateUtil.format(DateUtil.beginOfDay(order.getCreateTime()), "yyyy-MM-dd HH:mm:ss"));
+                    map.put("jsrq",DateUtil.format(DateUtil.endOfDay(order.getCreateTime()), "yyyy-MM-dd HH:mm:ss"));
+                    map.put("pagecount",10);
+                    map.put("page",1);
+                    AjaxResult result = controller.Getlabreportinfo(map);
+                    String result1 = getAjaxResult(result);
+                    JSONObject object = getJSONObject(result1);
+                    String code = object.getStr("ResultCode");
+                    if(null ==code || !code.equals("0")){
+                        return AjaxResult.error("鍖栭獙椤圭洰鏆傛椂鏃犵粨鏋�,璇风◢鍚庡悓姝�!!!");
                     }
-                    LtkjHysqd hysqd=new LtkjHysqd();
-                    hysqd.setTjh(order.getCardId());
-                    hysqd.setTmh(jsonObject.getStr("JYBGID"));
-                    hysqd.setBbbh(jsonObject.getStr("BBDM"));
-                    hysqd.setBbmc(jsonObject.getStr("BBMC"));
-                    hysqd.setXmid(jsonObject.getStr("JYXMDM"));
-                    hysqd.setXmmc(jsonObject.getStr("JYXMMC"));
-                    hysqd.setSqsj(jsonObject.getStr("SQRQ"));
-                    hysqd.setSqys(jsonObject.getStr("SQRBH"));
-                    hysqd.setJgsj(jsonObject.getStr("JYBGRQ"));
-                    hysqd.setSqrxm(jsonObject.getStr("SQRXM"));
-                    hysqd.setSqdh(jsonObject.getStr("SQDBH"));
-                    if (ltkjHysqdService.save(hysqd)) {
-                        Map<String,Object> hashMap=new HashMap<>();
-                        hashMap.put("jybgid",hysqd.getTmh());
-                        AjaxResult bgdres = controller.Getlabdetailinfo(hashMap);
-                        String result2 = getAjaxResult(bgdres);
-                        JSONObject object1 = getJSONObject(result2);
-                        String code1 = object1.getStr("ResultCode");
-                        if(null ==code1 || !code1.equals("0")){
-                            return AjaxResult.error("鍖栭獙椤圭洰鏆傛椂鏃犵粨鏋�,璇风◢鍚庡悓姝�!!!");
+                    JSONArray data = object.getJSONArray("ResultData");
+                    for (Object datum : data) {
+                        JSONObject jsonObject = (JSONObject)datum;
+                        LtkjHysqd jybgid = ltkjHysqdService.getLtkjHysqdByTjhAndTmh(order.getCardId(), jsonObject.getStr("JYBGID"));
+                        if(null !=jybgid){
+                            ltkjHysqdService.deletedLtkjHysqdByTjhAndTmh(order.getCardId(),jsonObject.getStr("JYBGID"));
+                            ltkjHybgdService.deletedLtkjHybgdByTjhAndTmh(jybgid.getTmh());
                         }
-                        JSONArray datas = object1.getJSONArray("ResultData");
-                        for (Object o : datas) {
-                            JSONObject js = (JSONObject)o;
+                        LtkjHysqd hysqd=new LtkjHysqd();
+                        hysqd.setTjh(order.getCardId());
+                        hysqd.setTmh(jsonObject.getStr("JYBGID"));
+                        hysqd.setBbbh(jsonObject.getStr("BBDM"));
+                        hysqd.setBbmc(jsonObject.getStr("BBMC"));
+                        hysqd.setXmid(jsonObject.getStr("JYXMDM"));
+                        hysqd.setXmmc(jsonObject.getStr("JYXMMC"));
+                        hysqd.setSqsj(jsonObject.getStr("SQRQ"));
+                        hysqd.setSqys(jsonObject.getStr("SQRBH"));
+                        hysqd.setJgsj(jsonObject.getStr("JYBGRQ"));
+                        hysqd.setSqrxm(jsonObject.getStr("SQRXM"));
+                        hysqd.setSqdh(jsonObject.getStr("SQDBH"));
+                        if (ltkjHysqdService.save(hysqd)) {
+                            Map<String,Object> hashMap=new HashMap<>();
+                            hashMap.put("jybgid",hysqd.getTmh());
+                            AjaxResult bgdres = controller.Getlabdetailinfo(hashMap);
+                            String result2 = getAjaxResult(bgdres);
+                            JSONObject object1 = getJSONObject(result2);
+                            String code1 = object1.getStr("ResultCode");
+                            if(null ==code1 || !code1.equals("0")){
+                                return AjaxResult.error("鍖栭獙椤圭洰鏆傛椂鏃犵粨鏋�,璇风◢鍚庡悓姝�!!!");
+                            }
+                            JSONArray datas = object1.getJSONArray("ResultData");
+                            for (Object o : datas) {
+                                JSONObject js = (JSONObject)o;
 //                            ltkjHybgdService.deletedLtkjHybgdByTjhAndTmh(jsonObject.getStr("JYBGID"));
-                            LtkjHybgd bgd=new LtkjHybgd();
-                            bgd.setTmh(hysqd.getTmh());
-                            bgd.setJcxmid(js.getStr("JCZBDM"));
-                            bgd.setJcxm(js.getStr("JCZBMC"));
-                            bgd.setTdh(js.getStr(""));
-                            bgd.setJyjg(js.getStr("JCZBJG"));
-                            bgd.setJgdw(js.getStr("JLDW"));
-                            bgd.setFwzdz(js.getStr(""));
-                            bgd.setFwzgz(js.getStr(""));
-                            bgd.setFwz(js.getStr("CKZFW"));
-                            bgd.setJysj(js.getStr("BGRQ"));
-                            bgd.setJyys(js.getStr("JCRBH"));
-                            bgd.setShsj(js.getStr("BGRQ"));
-                            bgd.setShsj(js.getStr("BGRQ"));
-                            bgd.setShys(js.getStr("SHRBH"));
-                            bgd.setYcbz(js.getStr("YCTS"));
+                                LtkjHybgd bgd=new LtkjHybgd();
+                                bgd.setTmh(hysqd.getTmh());
+                                bgd.setJcxmid(js.getStr("JCZBDM"));
+                                bgd.setJcxm(js.getStr("JCZBMC"));
+                                bgd.setTdh(js.getStr(""));
+                                bgd.setJyjg(js.getStr("JCZBJG"));
+                                bgd.setJgdw(js.getStr("JLDW"));
+                                bgd.setFwzdz(js.getStr(""));
+                                bgd.setFwzgz(js.getStr(""));
+                                bgd.setFwz(js.getStr("CKZFW"));
+                                bgd.setJysj(js.getStr("BGRQ"));
+                                bgd.setJyys(js.getStr("JCRBH"));
+                                bgd.setShsj(js.getStr("BGRQ"));
+                                bgd.setShsj(js.getStr("BGRQ"));
+                                bgd.setShys(js.getStr("SHRBH"));
+                                bgd.setYcbz(js.getStr("YCTS"));
 //                            bgd.setTpurl(js.getStr(""));
-                            ltkjHybgdService.save(bgd);
+                                ltkjHybgdService.save(bgd);
+                            }
                         }
                     }
-                }
+//                }
                 //鍚屾鍖栭獙椤圭洰
                 testMapper.updateDetailByCall(order.getCardId(), String.valueOf(order.getOrderId()), order.getTjNumber(), UserHoder.getLoginUser().getUserId());
                 //鍚屾妫�鏌ラ」鐩�
@@ -769,6 +783,24 @@
                 if (null != tjOrderDetails && tjOrderDetails.size() > 0) {
                     for (TjOrderDetail tjOrderDetail : tjOrderDetails) {
                         if(remark.getProId().equals(tjOrderDetail.getProId())){
+                            String ckfw = tjOrderDetail.getStanId();
+                            if (StrUtil.isNotBlank(ckfw)) {
+                                try {
+                                    Integer.parseInt(tjOrderDetail.getYcbz());
+                                    String[] split = ckfw.split("-");
+                                    BigDecimal min = new BigDecimal(split[0]);
+                                    BigDecimal max = new BigDecimal(split[1]);
+                                    String proResult = tjOrderDetail.getProResult();
+                                    BigDecimal jyjgval = new BigDecimal(proResult);
+                                    if (jyjgval.compareTo(min) < 0) {
+                                        tjOrderDetail.setYcbz("鈫�");
+                                    } else if (jyjgval.compareTo(max) > 0) {
+                                        tjOrderDetail.setYcbz("鈫�");
+                                    }else {
+                                        tjOrderDetail.setYcbz("");
+                                    }
+                                } catch (NumberFormatException ignored) { }
+                            }
                             if(null !=tjOrderDetail.getYcbz() && !tjOrderDetail.getYcbz().equals("")){
                                 tjOrderDetail.setProResult(tjOrderDetail.getProResult()+" ["+tjOrderDetail.getYcbz()+"]");
                             }

--
Gitblit v1.8.0