From 95604975d26071d55e270e73784af4787b042d98 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期三, 12 二月 2025 17:32:45 +0800
Subject: [PATCH] zjh20250212

---
 ltkj-admin/src/main/java/com/ltkj/web/controller/system/SysConfigController.java |  175 ++++++++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 170 insertions(+), 5 deletions(-)

diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/SysConfigController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/SysConfigController.java
index f553595..729bdf1 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/system/SysConfigController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/system/SysConfigController.java
@@ -1,8 +1,7 @@
 package com.ltkj.web.controller.system;
 
-import java.util.Date;
-import java.util.List;
-import java.util.Locale;
+import java.text.SimpleDateFormat;
+import java.util.*;
 import javax.annotation.Resource;
 import javax.servlet.http.HttpServletResponse;
 
@@ -11,13 +10,21 @@
 import cn.hutool.extra.pinyin.PinyinUtil;
 import com.ltkj.common.core.domain.entity.SysMenu;
 import com.ltkj.common.utils.SecurityUtils;
+import com.ltkj.framework.datasource.DynamicDataSourceContextHolder;
 import com.ltkj.hosp.domain.DictHosp;
+import com.ltkj.hosp.domain.TjJcycxm;
 import com.ltkj.hosp.domain.TjProject;
-import com.ltkj.hosp.service.IDictHospService;
-import com.ltkj.hosp.service.ITjProjectService;
+import com.ltkj.hosp.mapper.TestMapper;
+import com.ltkj.hosp.service.*;
+import com.ltkj.hosp.sqlDomain.*;
 import com.ltkj.system.service.ISysMenuService;
 import io.swagger.annotations.Api;
 import io.swagger.annotations.ApiOperation;
+import io.swagger.annotations.ApiParam;
+import jodd.util.StringUtil;
+import lombok.extern.slf4j.Slf4j;
+import org.apache.ibatis.annotations.Case;
+import org.apache.ibatis.jdbc.Null;
 import org.springframework.beans.factory.annotation.Autowired;
 import org.springframework.beans.factory.annotation.Value;
 import org.springframework.security.access.prepost.PreAuthorize;
@@ -41,6 +48,7 @@
 @RestController
 @RequestMapping("/system/config")
 @Api(tags = "A---PC绔弬鏁伴厤缃帴鍙i泦")
+@Slf4j
 public class SysConfigController extends BaseController {
     @Autowired
     private ISysConfigService configService;
@@ -52,6 +60,22 @@
     private String secret;
     @Autowired
     private ITjProjectService projectService;
+    @Resource
+    private ITjOrderService orderService;
+    @Autowired
+    private TjJcycxmService jcycxmService;
+    @Resource
+    private LtkjExamJcsqdService jcsqdService;
+    @Resource
+    private LtkjExamJcbgdService jcbgdService;
+    @Resource
+    private LtkjHybgdService ltkjHybgdService;
+    @Resource
+    private LtkjHysqdService ltkjHysqdService;
+    @Resource
+    private TestMapper testMapper;
+    @Autowired
+    private AwsService awsService;
 
     /**
      * 鑾峰彇鍙傛暟閰嶇疆鍒楄〃
@@ -164,6 +188,107 @@
     }
 
 
+    @GetMapping ("/shoudongtbjyjcwsxmjg")
+    @ApiOperation(value = "鎵嬪姩鍚屾妫�楠屾鏌ュ閫侀」鐩粨鏋滄帴鍙�")
+    public AjaxResult shoudongtbjyjcwsxmjg(@RequestParam @ApiParam(value = "jy妫�楠� jc妫�鏌� jyjc妫�楠屽拰妫�鏌�") String tblx,
+                                           @ApiParam(value = "浣撴鍙�")@RequestParam String tjh) {
+
+        log.info("鎵嬪姩鍚屾妫�楠屾垨妫�鏌ョ粨鏋滃紑濮�->{}",DateUtil.format(new Date(),"yyyy-MM-dd HH:mm:ss"));
+        try {
+
+            switch (tblx){
+                case "jy":
+                    tbjianyan(tjh);
+                    log.info("褰撳墠鍚屾鐨勬槸->{} 缁撴灉","妫�楠�");
+                    break;
+                case "jc":
+                    tbjiancha(tjh);
+                    log.info("褰撳墠鍚屾鐨勬槸->{} 缁撴灉","妫�鏌�");
+                    break;
+                case "jyjc":
+                    tbjianyan(tjh);
+                    tbjiancha(tjh);
+                    log.info("褰撳墠鍚屾鐨勬槸->{} 缁撴灉","妫�楠屾鏌�");
+                    break;
+                default:
+                    log.info("娌℃湁鎵惧埌鎵�鍖归厤鐨勫悓姝ョ被鍨�");
+                    return AjaxResult.error("娌℃湁鎵惧埌鎵�鍖归厤鐨勫悓姝ョ被鍨�!");
+            }
+            Map<String, Object> map = new HashMap<>();
+            testMapper.tjplUpdateDetatilByVi(map);
+            Integer object = (Integer) map.get("total");
+            log.info("鎵ц瀛樺偍杩囩▼鍚庡嚭鍙�->{}", object);
+            log.info("鎵嬪姩鍚屾妫�楠屾垨妫�鏌ョ粨鏋滅粨鏉�->{}",DateUtil.format(new Date(),"yyyy-MM-dd HH:mm:ss"));
+            return AjaxResult.success("鍚屾鎴愬姛");
+
+        } catch (Exception e) {
+            log.error(String.valueOf(e));
+        }
+        return AjaxResult.success();
+    }
+
+    private void tbjianyan(String s) {
+        try {
+            List<Aws> awsList = testMapper.getWsxmLtkjHysqdByLisViBySLAVEWS(s);
+            if(null !=awsList && !awsList.isEmpty()){
+                log.info(awsList.toString());
+                testMapper.delWsxmjg(s);
+                log.info("鍒犻櫎澶栭�侀」鐩垚鍔�");
+                awsService.saveBatch(awsList);
+                log.info("淇濆瓨澶栭�侀」鐩垚鍔�");
+            }
+            List<LtkjHysqd> hysqdList = testMapper.getCcXZxYyLtkjHysqdByLisVi(s);
+            List<LtkjHysqd> wssq = testMapper.getWsxmLtkjHysqdByLisVi(s);
+            if(null !=wssq && !wssq.isEmpty())hysqdList.addAll(wssq);
+            if (null != hysqdList && !hysqdList.isEmpty()) {
+                for (LtkjHysqd hysqd : hysqdList) {
+                    LtkjHysqd jybgid = ltkjHysqdService.getLtkjHysqdByTjhAndTmh(hysqd.getTjh(), hysqd.getTmh());
+                    if (null != jybgid) {
+                        ltkjHysqdService.deletedLtkjHysqdByTjhAndTmh(hysqd.getTjh(), hysqd.getTmh());
+                        ltkjHybgdService.deletedLtkjHybgdByTjhAndTmh(hysqd.getTmh());
+                    }
+                    if (ltkjHysqdService.save(hysqd)) {
+                        List<LtkjHybgd> hybgdList = testMapper.getCcXZxYyLtkjHybgdByLisVi(hysqd.getTmh());
+                        List<LtkjHybgd> wsbg = testMapper.getWsxmLtkjHybgdByLisVi(s);
+                        if(null !=wsbg && !wsbg.isEmpty())hybgdList.addAll(wsbg);
+                        ltkjHybgdService.saveBatch(hybgdList);
+                    }
+                }
+                DynamicDataSourceContextHolder.clearDataSourceType();
+            }
+        } catch (Exception e) {
+            log.info("鍚屾妫�楠屾暟鎹け璐�");
+//            throw new RuntimeException(e);
+            log.error(String.valueOf(e));
+        }
+
+    }
+
+
+    private void tbjiancha(String s) {
+
+        try {
+            List<LtkjExamJcsqd> jcsqdList = testMapper.getCcXZxYyPacsLtkjExamJcsqd(s);
+            if (null != jcsqdList && !jcsqdList.isEmpty()) {
+                DynamicDataSourceContextHolder.clearDataSourceType();
+                jcsqdService.deletedLtkjJcsqdByTjhAndTmh(s);
+                jcbgdService.deletedLtkjJcbgdByTjhAndTmh(s);
+                jcsqdService.saveBatch(jcsqdList);
+                List<LtkjExamJcbgd> jcbgdList = testMapper.getCcXZxYyPacsLtkjExamJcbgd(s);
+                DynamicDataSourceContextHolder.clearDataSourceType();
+                if (null != jcbgdList && !jcbgdList.isEmpty()) jcbgdService.saveBatch(jcbgdList);
+                DynamicDataSourceContextHolder.clearDataSourceType();
+            }
+        } catch (Exception e) {
+            log.info("鍚屾妫�鏌ユ暟鎹け璐�");
+//            throw new RuntimeException(e);
+            log.error(String.valueOf(e));
+        }
+    }
+
+
+
+
     @GetMapping ("/zxsq")//鎵ц
     @ApiOperation(value = "zxsq")
     public AjaxResult zx(@RequestParam int day) {
@@ -210,4 +335,44 @@
         return AjaxResult.success();
     }
 
+
+
+    @GetMapping ("/tjjcycxm")//鍚屾his椤圭洰鍗曚环淇℃伅
+//    @PreAuthorize("@ss.hasPermi('system:config:tbhisproprice')")
+    @ApiOperation (value = "tjjcycxm")
+    public AjaxResult tjjcycxm() {
+        String yqbm = configService.selectConfigByKey("common_api_service_hospbm");
+        List<String> jc = orderService.getJianChaTjNum();
+        if (null != jc && !jc.isEmpty()) {
+            for (String s : jc) {
+                jcycxmService.deletedByTjh(s);
+                List<LtkjExamJcsqd> list = jcsqdService.getLtkjJcsqdByTjh(s);
+                if(null !=list && !list.isEmpty()){
+                    for (LtkjExamJcsqd jcsqd : list) {
+                        if(jcsqd.getJgbx().contains("銆�")){
+                            String[] split = jcsqd.getJgzt().split("銆�");
+                            for (String jg : split) {
+                                if(StringUtil.isNotBlank(jg) && !jg.contains("鏈寮傚父")
+                                        && !jg.contains("鏈鏄庢樉寮傚父") && !jg.contains("鏈鍗犱綅")
+                                        && !jg.contains("鏈鏄庢樉")&& !jg.contains("姝e父")&& !jg.contains("鍙屼晶妞庨棿瀛旀棤鐙獎")&& !jg.contains("鏃犳畩")){
+                                    TjJcycxm jcycxm=new TjJcycxm();
+                                    jcycxm.setTjh(s);
+                                    jcycxm.setYqid(yqbm);
+                                    String[] split1 = jcsqd.getJcxmid().split(";");
+                                    jcycxm.setProId(split1[0]);
+                                    jcycxm.setProName(jcsqd.getJcxmmc());
+                                    jcycxm.setCreateTime(new Date());
+                                    jcycxm.setJcjg(jg);
+                                    jcycxmService.save(jcycxm);
+                                }
+                            }
+                        }
+                    }
+                }
+
+            }
+        }
+        return AjaxResult.success();
+    }
+
 }

--
Gitblit v1.8.0