From 524a0867c6e8343607d343a4f708498c21baf9d4 Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期五, 28 二月 2025 15:25:34 +0800
Subject: [PATCH] 修改药品处方从表里拿处方类型以及sqlserver连接去除ssl

---
 ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisApiMethod.java |  343 +++++++++++++++++++++++++++++++++++++++-----------------
 1 files changed, 239 insertions(+), 104 deletions(-)

diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisApiMethod.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisApiMethod.java
index 33ec23a..8761b80 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisApiMethod.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/his/HisApiMethod.java
@@ -297,6 +297,7 @@
                                 detilsDto.setYpmc(i.getYpmc());
                                 detilsDto.setFzbl(i.getFzbl());
                                 detilsDto.setZh(i.getZh());
+                                detilsDto.setCflx(i.getCflx());
                                 outpinmedicapplyDetilsDtos.add(detilsDto);
                             });
                         }
@@ -411,6 +412,7 @@
                             detilsDto.setYpmc(i.getYpmc());
                             detilsDto.setFzbl(i.getFzbl());
                             detilsDto.setZh(i.getZh());
+                            detilsDto.setCflx(i.getCflx());
                             outpinmedicapplyDetilsDtos.add(detilsDto);
                         });
                     }
@@ -536,6 +538,7 @@
                             detilsDto.setYpmc(i.getYpmc());
                             detilsDto.setFzbl(i.getFzbl());
                             detilsDto.setZh(i.getZh());
+                            detilsDto.setCflx(i.getCflx());
                             outpinmedicapplyDetilsDtos.add(detilsDto);
                         });
                     }
@@ -582,64 +585,129 @@
             }
         }
 
-        //鑽搧鐢宠
+        //鑽搧鐢宠鍘熺増
+//        if(!outpinmedicapplyDetilsDtos.isEmpty()){
+//            OutpinmedicapplyDto dto1=new OutpinmedicapplyDto();
+//            dto1.setHisRegistrationId(cardId);
+//            dto1.setSfzh(customer.getCusIdcard());
+//            dto1.setSqysbm(ysbm);
+//            dto1.setMzksbm(dept);
+//            dto1.setSjrq(date);
+//            String yfbm = configService.selectConfigByKey("chufang_yfbm");
+//            String mzzd = configService.selectConfigByKey("chufang_mzzd");
+//            String czybm = configService.selectConfigByKey("chufang_czybm");
+//            String czyksbm = configService.selectConfigByKey("chufang_czyksbm");
+//            String cflxbm = configService.selectConfigByKey("chufang_cflxbm");
+//            if (czybm.equalsIgnoreCase("N"))
+//                dto1.setCzybm(ysbm);
+//            else dto1.setCzybm(czybm);
+//            if (czyksbm.equalsIgnoreCase("N"))
+//                dto1.setCzyksbm(dept);
+//            else dto1.setCzyksbm(czyksbm);
+//            dto1.setCflxbm(cflxbm);
+//            if (yfbm.equalsIgnoreCase("N"))
+//                dto1.setYfbm("1");
+//            else dto1.setYfbm(yfbm);
+//            dto1.setFyts("1");
+//            if (mzzd.equalsIgnoreCase("N"))
+//                dto1.setMzzd("");
+//            else dto1.setMzzd(mzzd);
+//            dto1.setDetails(outpinmedicapplyDetilsDtos);
+//            AjaxResult result = controller.Outpinmedicapply(dto1);
+//            String result1 = getAjaxResult(result);
+//            JSONObject object = getJSONObject(result1);
+//            String code = object.getStr("ResultCode");
+//            if(null !=code && code.equals("0")){
+//                JSONObject resultData = object.getJSONObject("ResultData");
+////                Map<String, Object> resultDatasss = (Map<String, Object>) resultData.get(0);
+//                String cfh = resultData.getStr("cfh");
+//                log.info("鑽搧鐢宠鍚庣殑澶勬柟鍙锋槸: "+cfh+"  outpinmedicapplyDetilsDtos 閲岄潰鐨勫�间负: "+outpinmedicapplyDetilsDtos.toString());
+//                for (OutpinmedicapplyDetilsDto detilsDto : outpinmedicapplyDetilsDtos) {
+//                    TjCf cf=new TjCf();
+//                    cf.setCardId(cardId);
+//                    cf.setSfzh(customer.getCusIdcard());
+//                    cf.setCfh(cfh);
+//                    cf.setSqysbm(ysbm);
+//                    cf.setSqysxm(ysmc);
+//                    cf.setMzksbn(dept);
+//                    cf.setSqrq(date);
+//                    cf.setCzybm(ysbm);
+//                    cf.setYpbm(detilsDto.getYpbm());
+//                    cf.setYpmc(detilsDto.getYpmc());
+//                    cf.setSl(String.valueOf(detilsDto.getSl()));
+//                    cf.setDj(String.valueOf(detilsDto.getDj()));
+//                    cf.setDcjl(String.valueOf(detilsDto.getDcjl()));
+//                    cf.setPj(String.valueOf(detilsDto.getPj()));
+//                    cf.setJj(String.valueOf(detilsDto.getJj()));
+//                    cf.setCreateTime(new Date());
+//                    cfService.save(cf);
+//                }
+//            }
+//        }
+
+
+        /**
+         * 鑽搧鐢宠 澶勬柟绫诲瀷缁存姢鍦ㄨ嵂鍝佽〃
+         */
         if(!outpinmedicapplyDetilsDtos.isEmpty()){
-            OutpinmedicapplyDto dto1=new OutpinmedicapplyDto();
-            dto1.setHisRegistrationId(cardId);
-            dto1.setSfzh(customer.getCusIdcard());
-            dto1.setSqysbm(ysbm);
-            dto1.setMzksbm(dept);
-            dto1.setSjrq(date);
             String yfbm = configService.selectConfigByKey("chufang_yfbm");
             String mzzd = configService.selectConfigByKey("chufang_mzzd");
             String czybm = configService.selectConfigByKey("chufang_czybm");
             String czyksbm = configService.selectConfigByKey("chufang_czyksbm");
-            String cflxbm = configService.selectConfigByKey("chufang_cflxbm");
-            if (czybm.equalsIgnoreCase("N"))
-                dto1.setCzybm(ysbm);
-            else dto1.setCzybm(czybm);
-            if (czyksbm.equalsIgnoreCase("N"))
-                dto1.setCzyksbm(dept);
-            else dto1.setCzyksbm(czyksbm);
-            dto1.setCflxbm(cflxbm);
-            if (yfbm.equalsIgnoreCase("N"))
-                dto1.setYfbm("1");
-            else dto1.setYfbm(yfbm);
-            dto1.setFyts("1");
-            if (mzzd.equalsIgnoreCase("N"))
-                dto1.setMzzd("");
-            else dto1.setMzzd(mzzd);
-            dto1.setDetails(outpinmedicapplyDetilsDtos);
-            AjaxResult result = controller.Outpinmedicapply(dto1);
-            String result1 = getAjaxResult(result);
-            JSONObject object = getJSONObject(result1);
-            String code = object.getStr("ResultCode");
-            if(null !=code && code.equals("0")){
-                JSONObject resultData = object.getJSONObject("ResultData");
-//                Map<String, Object> resultDatasss = (Map<String, Object>) resultData.get(0);
-                String cfh = resultData.getStr("cfh");
-                log.info("鑽搧鐢宠鍚庣殑澶勬柟鍙锋槸: "+cfh+"  outpinmedicapplyDetilsDtos 閲岄潰鐨勫�间负: "+outpinmedicapplyDetilsDtos.toString());
-                for (OutpinmedicapplyDetilsDto detilsDto : outpinmedicapplyDetilsDtos) {
-                    TjCf cf=new TjCf();
-                    cf.setCardId(cardId);
-                    cf.setSfzh(customer.getCusIdcard());
-                    cf.setCfh(cfh);
-                    cf.setSqysbm(ysbm);
-                    cf.setSqysxm(ysmc);
-                    cf.setMzksbn(dept);
-                    cf.setSqrq(date);
-                    cf.setCzybm(ysbm);
-                    cf.setYpbm(detilsDto.getYpbm());
-                    cf.setYpmc(detilsDto.getYpmc());
-                    cf.setSl(String.valueOf(detilsDto.getSl()));
-                    cf.setDj(String.valueOf(detilsDto.getDj()));
-                    cf.setDcjl(String.valueOf(detilsDto.getDcjl()));
-                    cf.setPj(String.valueOf(detilsDto.getPj()));
-                    cf.setJj(String.valueOf(detilsDto.getJj()));
-                    cf.setCreateTime(new Date());
-                    cfService.save(cf);
+//            String cflxbm = configService.selectConfigByKey("chufang_cflxbm");
+            Map<String, List<OutpinmedicapplyDetilsDto>> listMap = outpinmedicapplyDetilsDtos.stream().collect(Collectors.groupingBy(OutpinmedicapplyDetilsDto::getCflx));
+            listMap.forEach((cflx, details) -> {
+                OutpinmedicapplyDto dto1 = new OutpinmedicapplyDto();
+                dto1.setHisRegistrationId(cardId);
+                dto1.setSfzh(customer.getCusIdcard());
+                dto1.setSqysbm(ysbm);
+                dto1.setMzksbm(dept);
+                dto1.setSjrq(date);
+                if (czybm.equalsIgnoreCase("N"))
+                    dto1.setCzybm(ysbm);
+                else dto1.setCzybm(czybm);
+                if (czyksbm.equalsIgnoreCase("N"))
+                    dto1.setCzyksbm(dept);
+                else dto1.setCzyksbm(czyksbm);
+                dto1.setCflxbm(cflx);
+                if (yfbm.equalsIgnoreCase("N"))
+                    dto1.setYfbm("1");
+                else dto1.setYfbm(yfbm);
+                dto1.setFyts("1");
+                if (mzzd.equalsIgnoreCase("N"))
+                    dto1.setMzzd("");
+                else dto1.setMzzd(mzzd);
+                dto1.setDetails(details);
+                AjaxResult result = controller.Outpinmedicapply(dto1);
+                String result1 = getAjaxResult(result);
+                JSONObject object = getJSONObject(result1);
+                String code = object.getStr("ResultCode");
+                if (null != code && code.equals("0")) {
+                    JSONObject resultData = object.getJSONObject("ResultData");
+                    String cfh = resultData.getStr("cfh");
+                    log.info("鑽搧鐢宠鍚庣殑澶勬柟鍙锋槸: " + cfh + "  outpinmedicapplyDetilsDtos 閲岄潰鐨勫�间负: " + outpinmedicapplyDetilsDtos.toString());
+                    for (OutpinmedicapplyDetilsDto detilsDto : outpinmedicapplyDetilsDtos) {
+                        TjCf cf = new TjCf();
+                        cf.setCardId(cardId);
+                        cf.setSfzh(customer.getCusIdcard());
+                        cf.setCfh(cfh);
+                        cf.setSqysbm(ysbm);
+                        cf.setSqysxm(ysmc);
+                        cf.setMzksbn(dept);
+                        cf.setSqrq(date);
+                        cf.setCzybm(ysbm);
+                        cf.setYpbm(detilsDto.getYpbm());
+                        cf.setYpmc(detilsDto.getYpmc());
+                        cf.setSl(String.valueOf(detilsDto.getSl()));
+                        cf.setDj(String.valueOf(detilsDto.getDj()));
+                        cf.setDcjl(String.valueOf(detilsDto.getDcjl()));
+                        cf.setPj(String.valueOf(detilsDto.getPj()));
+                        cf.setJj(String.valueOf(detilsDto.getJj()));
+                        cf.setCreateTime(new Date());
+                        cfService.save(cf);
+                    }
                 }
-            }
+            });
         }
 
         return AjaxResult.success();
@@ -1515,6 +1583,7 @@
                                 detilsDto.setYpmc(i.getYpmc());
                                 detilsDto.setFzbl(i.getFzbl());
                                 detilsDto.setZh(i.getZh());
+                                detilsDto.setCflx(i.getCflx());
                                 outpinmedicapplyDetilsDtos.add(detilsDto);
                             });
                         }
@@ -1623,6 +1692,7 @@
                             detilsDto.setYpmc(i.getYpmc());
                             detilsDto.setFzbl(i.getFzbl());
                             detilsDto.setZh(i.getZh());
+                            detilsDto.setCflx(i.getCflx());
                             outpinmedicapplyDetilsDtos.add(detilsDto);
                         });
                     }
@@ -1744,6 +1814,7 @@
                             detilsDto.setYpmc(i.getYpmc());
                             detilsDto.setFzbl(i.getFzbl());
                             detilsDto.setZh(i.getZh());
+                            detilsDto.setCflx(i.getCflx());
                             outpinmedicapplyDetilsDtos.add(detilsDto);
                         });
                     }
@@ -1790,64 +1861,128 @@
             }
         }
 
-        //鑽搧鐢宠
+        //鑽搧鐢宠 鍘熺増
+//        if(!outpinmedicapplyDetilsDtos.isEmpty()){
+//            OutpinmedicapplyDto dto1=new OutpinmedicapplyDto();
+//            dto1.setHisRegistrationId(cardId);
+//            dto1.setSfzh(customer.getCusIdcard());
+//            dto1.setSqysbm(ysbm);
+//            dto1.setMzksbm(dept);
+//            dto1.setSjrq(date);
+//            String yfbm = configService.selectConfigByKey("chufang_yfbm");
+//            String mzzd = configService.selectConfigByKey("chufang_mzzd");
+//            String czybm = configService.selectConfigByKey("chufang_czybm");
+//            String czyksbm = configService.selectConfigByKey("chufang_czyksbm");
+//            String cflxbm = configService.selectConfigByKey("chufang_cflxbm");
+//            if (czybm.equalsIgnoreCase("N"))
+//                dto1.setCzybm(ysbm);
+//            else dto1.setCzybm(czybm);
+//            if (czyksbm.equalsIgnoreCase("N"))
+//                dto1.setCzyksbm(dept);
+//            else dto1.setCzyksbm(czyksbm);
+//            dto1.setCflxbm(cflxbm);
+//            if (yfbm.equalsIgnoreCase("N"))
+//                dto1.setYfbm("1");
+//            else dto1.setYfbm(yfbm);
+//            dto1.setFyts("1");
+//            if (mzzd.equalsIgnoreCase("N"))
+//                dto1.setMzzd("");
+//            else dto1.setMzzd(mzzd);
+//            dto1.setDetails(outpinmedicapplyDetilsDtos);
+//            AjaxResult result = controller.Outpinmedicapply(dto1);
+//            String result1 = getAjaxResult(result);
+//            JSONObject object = getJSONObject(result1);
+//            String code = object.getStr("ResultCode");
+//            if(null !=code && code.equals("0")){
+//                JSONObject resultData = object.getJSONObject("ResultData");
+////                Map<String, Object> resultDatasss = (Map<String, Object>) resultData.get(0);
+//                String cfh = resultData.getStr("cfh");
+//                log.info("鑽搧鐢宠鍚庣殑澶勬柟鍙锋槸: "+cfh+"  outpinmedicapplyDetilsDtos 閲岄潰鐨勫�间负: "+outpinmedicapplyDetilsDtos.toString());
+//                for (OutpinmedicapplyDetilsDto detilsDto : outpinmedicapplyDetilsDtos) {
+//                    TjCf cf=new TjCf();
+//                    cf.setCardId(cardId);
+//                    cf.setSfzh(customer.getCusIdcard());
+//                    cf.setCfh(cfh);
+//                    cf.setSqysbm(ysbm);
+//                    cf.setSqysxm(ysmc);
+//                    cf.setMzksbn(dept);
+//                    cf.setSqrq(date);
+//                    cf.setCzybm(ysbm);
+//                    cf.setYpbm(detilsDto.getYpbm());
+//                    cf.setYpmc(detilsDto.getYpmc());
+//                    cf.setSl(String.valueOf(detilsDto.getSl()));
+//                    cf.setDj(String.valueOf(detilsDto.getDj()));
+//                    cf.setDcjl(String.valueOf(detilsDto.getDcjl()));
+//                    cf.setPj(String.valueOf(detilsDto.getPj()));
+//                    cf.setJj(String.valueOf(detilsDto.getJj()));
+//                    cf.setCreateTime(new Date());
+//                    cfService.save(cf);
+//                }
+//            }
+//        }
+
+        /**
+         * 鑽搧鐢宠 澶勬柟绫诲瀷缁存姢鍦ㄨ嵂鍝佽〃
+         */
         if(!outpinmedicapplyDetilsDtos.isEmpty()){
-            OutpinmedicapplyDto dto1=new OutpinmedicapplyDto();
-            dto1.setHisRegistrationId(cardId);
-            dto1.setSfzh(customer.getCusIdcard());
-            dto1.setSqysbm(ysbm);
-            dto1.setMzksbm(dept);
-            dto1.setSjrq(date);
             String yfbm = configService.selectConfigByKey("chufang_yfbm");
             String mzzd = configService.selectConfigByKey("chufang_mzzd");
             String czybm = configService.selectConfigByKey("chufang_czybm");
             String czyksbm = configService.selectConfigByKey("chufang_czyksbm");
-            String cflxbm = configService.selectConfigByKey("chufang_cflxbm");
-            if (czybm.equalsIgnoreCase("N"))
-                dto1.setCzybm(ysbm);
-            else dto1.setCzybm(czybm);
-            if (czyksbm.equalsIgnoreCase("N"))
-                dto1.setCzyksbm(dept);
-            else dto1.setCzyksbm(czyksbm);
-            dto1.setCflxbm(cflxbm);
-            if (yfbm.equalsIgnoreCase("N"))
-                dto1.setYfbm("1");
-            else dto1.setYfbm(yfbm);
-            dto1.setFyts("1");
-            if (mzzd.equalsIgnoreCase("N"))
-                dto1.setMzzd("");
-            else dto1.setMzzd(mzzd);
-            dto1.setDetails(outpinmedicapplyDetilsDtos);
-            AjaxResult result = controller.Outpinmedicapply(dto1);
-            String result1 = getAjaxResult(result);
-            JSONObject object = getJSONObject(result1);
-            String code = object.getStr("ResultCode");
-            if(null !=code && code.equals("0")){
-                JSONObject resultData = object.getJSONObject("ResultData");
-//                Map<String, Object> resultDatasss = (Map<String, Object>) resultData.get(0);
-                String cfh = resultData.getStr("cfh");
-                log.info("鑽搧鐢宠鍚庣殑澶勬柟鍙锋槸: "+cfh+"  outpinmedicapplyDetilsDtos 閲岄潰鐨勫�间负: "+outpinmedicapplyDetilsDtos.toString());
-                for (OutpinmedicapplyDetilsDto detilsDto : outpinmedicapplyDetilsDtos) {
-                    TjCf cf=new TjCf();
-                    cf.setCardId(cardId);
-                    cf.setSfzh(customer.getCusIdcard());
-                    cf.setCfh(cfh);
-                    cf.setSqysbm(ysbm);
-                    cf.setSqysxm(ysmc);
-                    cf.setMzksbn(dept);
-                    cf.setSqrq(date);
-                    cf.setCzybm(ysbm);
-                    cf.setYpbm(detilsDto.getYpbm());
-                    cf.setYpmc(detilsDto.getYpmc());
-                    cf.setSl(String.valueOf(detilsDto.getSl()));
-                    cf.setDj(String.valueOf(detilsDto.getDj()));
-                    cf.setDcjl(String.valueOf(detilsDto.getDcjl()));
-                    cf.setPj(String.valueOf(detilsDto.getPj()));
-                    cf.setJj(String.valueOf(detilsDto.getJj()));
-                    cf.setCreateTime(new Date());
-                    cfService.save(cf);
+//            String cflxbm = configService.selectConfigByKey("chufang_cflxbm");
+            Map<String, List<OutpinmedicapplyDetilsDto>> listMap = outpinmedicapplyDetilsDtos.stream().collect(Collectors.groupingBy(OutpinmedicapplyDetilsDto::getCflx));
+            listMap.forEach((cflx, details) -> {
+                OutpinmedicapplyDto dto1 = new OutpinmedicapplyDto();
+                dto1.setHisRegistrationId(cardId);
+                dto1.setSfzh(customer.getCusIdcard());
+                dto1.setSqysbm(ysbm);
+                dto1.setMzksbm(dept);
+                dto1.setSjrq(date);
+                if (czybm.equalsIgnoreCase("N"))
+                    dto1.setCzybm(ysbm);
+                else dto1.setCzybm(czybm);
+                if (czyksbm.equalsIgnoreCase("N"))
+                    dto1.setCzyksbm(dept);
+                else dto1.setCzyksbm(czyksbm);
+                dto1.setCflxbm(cflx);
+                if (yfbm.equalsIgnoreCase("N"))
+                    dto1.setYfbm("1");
+                else dto1.setYfbm(yfbm);
+                dto1.setFyts("1");
+                if (mzzd.equalsIgnoreCase("N"))
+                    dto1.setMzzd("");
+                else dto1.setMzzd(mzzd);
+                dto1.setDetails(details);
+                AjaxResult result = controller.Outpinmedicapply(dto1);
+                String result1 = getAjaxResult(result);
+                JSONObject object = getJSONObject(result1);
+                String code = object.getStr("ResultCode");
+                if (null != code && code.equals("0")) {
+                    JSONObject resultData = object.getJSONObject("ResultData");
+                    String cfh = resultData.getStr("cfh");
+                    log.info("鑽搧鐢宠鍚庣殑澶勬柟鍙锋槸: " + cfh + "  outpinmedicapplyDetilsDtos 閲岄潰鐨勫�间负: " + outpinmedicapplyDetilsDtos.toString());
+                    for (OutpinmedicapplyDetilsDto detilsDto : outpinmedicapplyDetilsDtos) {
+                        TjCf cf = new TjCf();
+                        cf.setCardId(cardId);
+                        cf.setSfzh(customer.getCusIdcard());
+                        cf.setCfh(cfh);
+                        cf.setSqysbm(ysbm);
+                        cf.setSqysxm(ysmc);
+                        cf.setMzksbn(dept);
+                        cf.setSqrq(date);
+                        cf.setCzybm(ysbm);
+                        cf.setYpbm(detilsDto.getYpbm());
+                        cf.setYpmc(detilsDto.getYpmc());
+                        cf.setSl(String.valueOf(detilsDto.getSl()));
+                        cf.setDj(String.valueOf(detilsDto.getDj()));
+                        cf.setDcjl(String.valueOf(detilsDto.getDcjl()));
+                        cf.setPj(String.valueOf(detilsDto.getPj()));
+                        cf.setJj(String.valueOf(detilsDto.getJj()));
+                        cf.setCreateTime(new Date());
+                        cfService.save(cf);
+                    }
                 }
-            }
+            });
         }
 
         return AjaxResult.success();

--
Gitblit v1.8.0