From 1e91dc33009cfdc951b2642877f40280b51c3089 Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 28 二月 2025 15:17:01 +0800
Subject: [PATCH] zjh20250228

---
 ltkj-admin/src/main/java/com/ltkj/web/controller/system/SysConfigController.java |  302 ++++++++++++++++++++++++++++++++++++++++++++------
 1 files changed, 266 insertions(+), 36 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 b10d3dd..7698bfc 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,24 +1,36 @@
 package com.ltkj.web.controller.system;
 
-import java.util.List;
-import java.util.Locale;
+import java.text.SimpleDateFormat;
+import java.util.*;
+import javax.annotation.Resource;
 import javax.servlet.http.HttpServletResponse;
 
+import cn.hutool.core.date.DateTime;
+import cn.hutool.core.date.DateUtil;
+import cn.hutool.extra.pinyin.PinyinUtil;
+import cn.hutool.json.JSONUtil;
 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.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;
 import org.springframework.validation.annotation.Validated;
-import org.springframework.web.bind.annotation.DeleteMapping;
-import org.springframework.web.bind.annotation.GetMapping;
-import org.springframework.web.bind.annotation.PathVariable;
-import org.springframework.web.bind.annotation.PostMapping;
-import org.springframework.web.bind.annotation.PutMapping;
-import org.springframework.web.bind.annotation.RequestBody;
-import org.springframework.web.bind.annotation.RequestMapping;
-import org.springframework.web.bind.annotation.RestController;
+import org.springframework.web.bind.annotation.*;
 import com.ltkj.common.annotation.Log;
 import com.ltkj.common.constant.UserConstants;
 import com.ltkj.common.core.controller.BaseController;
@@ -37,26 +49,50 @@
 @RestController
 @RequestMapping("/system/config")
 @Api(tags = "A---PC绔弬鏁伴厤缃帴鍙i泦")
+@Slf4j
 public class SysConfigController extends BaseController {
     @Autowired
     private ISysConfigService configService;
     @Autowired
     private ISysMenuService menuService;
+    @Resource
+    private IDictHospService dictHospService;
+    @Value ("${token.secret_key}")
+    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;
+
     /**
      * 鑾峰彇鍙傛暟閰嶇疆鍒楄〃
      */
 //    @PreAuthorize("@ss.hasPermi('system:config:list')")
-    @GetMapping("/list")
-    @ApiOperation(value = "鑾峰彇鍙傛暟閰嶇疆鍒楄〃")
+    @GetMapping ("/list")
+    @ApiOperation (value = "鑾峰彇鍙傛暟閰嶇疆鍒楄〃")
     public TableDataInfo list(SysConfig config) {
         startPage();
         List<SysConfig> list = configService.selectConfigList(config);
         return getDataTable(list);
     }
 
-    @Log(title = "鍙傛暟绠$悊", businessType = BusinessType.EXPORT)
+    @Log (title = "鍙傛暟绠$悊", businessType = BusinessType.EXPORT)
 //    @PreAuthorize("@ss.hasPermi('system:config:export')")
-    @PostMapping("/export")
+    @PostMapping ("/export")
     public void export(HttpServletResponse response, SysConfig config) {
         List<SysConfig> list = configService.selectConfigList(config);
         ExcelUtil<SysConfig> util = new ExcelUtil<SysConfig>(SysConfig.class);
@@ -67,7 +103,7 @@
      * 鏍规嵁鍙傛暟缂栧彿鑾峰彇璇︾粏淇℃伅
      */
 //    @PreAuthorize("@ss.hasPermi('system:config:query')")
-    @GetMapping(value = "/{configId}")
+    @GetMapping (value = "/{configId}")
     public AjaxResult getInfo(@PathVariable Long configId) {
         return success(configService.selectConfigById(configId));
     }
@@ -75,8 +111,8 @@
     /**
      * 鏍规嵁鍙傛暟閿悕鏌ヨ鍙傛暟鍊�
      */
-    @GetMapping(value = "/configKey/{configKey}")
-    @ApiOperation(value = "鏍规嵁鍙傛暟閿悕鏌ヨ鍙傛暟鍊�")
+    @GetMapping (value = "/configKey/{configKey}")
+    @ApiOperation (value = "鏍规嵁鍙傛暟閿悕鏌ヨ鍙傛暟鍊�")
     public AjaxResult getConfigKey(@PathVariable String configKey) {
         return success(configService.selectConfigByKey(configKey));
     }
@@ -85,14 +121,14 @@
      * 鏂板鍙傛暟閰嶇疆
      */
 //    @PreAuthorize("@ss.hasPermi('system:config:add')")
-    @Log(title = "鍙傛暟绠$悊", businessType = BusinessType.INSERT)
+    @Log (title = "鍙傛暟绠$悊", businessType = BusinessType.INSERT)
     @PostMapping
     public AjaxResult add(@Validated @RequestBody SysConfig config) {
         if (UserConstants.NOT_UNIQUE.equals(configService.checkConfigKeyUnique(config))) {
             return error("鏂板鍙傛暟'" + config.getConfigName() + "'澶辫触锛屽弬鏁伴敭鍚嶅凡瀛樺湪");
         }
         String configValue = config.getConfigValue();
-        if(configValue.length()==1) configValue = config.getConfigValue().toUpperCase(Locale.ROOT);
+        if (configValue.length() == 1) configValue = config.getConfigValue().toUpperCase(Locale.ROOT);
 
         config.setConfigValue(configValue);
         config.setCreateBy(getUsername());
@@ -103,7 +139,7 @@
      * 淇敼鍙傛暟閰嶇疆
      */
 //    @PreAuthorize("@ss.hasPermi('system:config:edit')")
-    @Log(title = "鍙傛暟绠$悊", businessType = BusinessType.UPDATE)
+    @Log (title = "鍙傛暟绠$悊", businessType = BusinessType.UPDATE)
     @PutMapping
     public AjaxResult edit(@Validated @RequestBody SysConfig config) {
         if (UserConstants.NOT_UNIQUE.equals(configService.checkConfigKeyUnique(config))) {
@@ -111,21 +147,21 @@
         }
 
         String configValue = config.getConfigValue();
-        if(configValue.length()==1) configValue = config.getConfigValue().toUpperCase(Locale.ROOT);
+        if (configValue.length() == 1) configValue = config.getConfigValue().toUpperCase(Locale.ROOT);
         config.setConfigValue(configValue);
         config.setUpdateBy(getUsername());
         int i = configService.updateConfig(config);
-        if(i>0){
-            if(config.getConfigId()==113){
-                SysMenu byId = menuService.getById(2305);
-                if("Y".equals(configValue)){
-                    byId.setVisible("0");
-                }
-                if("N".equals(configValue)){
-                    byId.setVisible("1");
-                }
-                menuService.updateById(byId);
-            }
+        if (i > 0) {
+//            if (config.getConfigId() == 113) {
+//                SysMenu byId = menuService.getById(2305);
+//                if ("Y".equals(configValue)) {
+//                    byId.setVisible("0");
+//                }
+//                if ("N".equals(configValue)) {
+//                    byId.setVisible("1");
+//                }
+//                menuService.updateById(byId);
+//            }
         }
         return toAjax(i);
     }
@@ -134,8 +170,8 @@
      * 鍒犻櫎鍙傛暟閰嶇疆
      */
 //    @PreAuthorize("@ss.hasPermi('system:config:remove')")
-    @Log(title = "鍙傛暟绠$悊", businessType = BusinessType.DELETE)
-    @DeleteMapping("/{configIds}")
+    @Log (title = "鍙傛暟绠$悊", businessType = BusinessType.DELETE)
+    @DeleteMapping ("/{configIds}")
     public AjaxResult remove(@PathVariable Long[] configIds) {
         configService.deleteConfigByIds(configIds);
         return success();
@@ -145,11 +181,205 @@
      * 鍒锋柊鍙傛暟缂撳瓨
      */
 //    @PreAuthorize("@ss.hasPermi('system:config:remove')")
-    @Log(title = "鍙傛暟绠$悊", businessType = BusinessType.CLEAN)
-    @DeleteMapping("/refreshCache")
+    @Log (title = "鍙傛暟绠$悊", businessType = BusinessType.CLEAN)
+    @DeleteMapping ("/refreshCache")
     public AjaxResult refreshCache() {
         configService.resetConfigCache();
         return success();
     }
 
+
+    @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.size());
+                log.info(awsList.toString());
+                testMapper.delWsxmjg(s);
+                log.info("鍒犻櫎澶栭�侀」鐩垚鍔�");
+                awsService.saveBatch(awsList);
+                log.info("淇濆瓨澶栭�侀」鐩垚鍔�");
+            }
+            List<LtkjHysqd> hysqdList = testMapper.getCcXZxYyLtkjHysqdByLisVi(s);
+            log.info("鍘焗ysqdList->{} 缁撴灉", JSONUtil.parseObj(hysqdList));
+            List<LtkjHysqd> wssq = testMapper.getWsxmLtkjHysqdByLisVi(s);
+            if(null !=wssq && !wssq.isEmpty()){
+                log.info("澶栭�侀」涓�->{} 缁撴灉",wssq.toString());
+                hysqdList.addAll(wssq);
+            }
+            if (null != hysqdList && !hysqdList.isEmpty()) {
+                log.info("鐜癶ysqdList->{} 缁撴灉", JSONUtil.parseObj(hysqdList));
+                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) {
+        try {
+            List<DictHosp> list = dictHospService.list();
+            DateTime dateTime1 = DateUtil.offsetMonth(new Date(), day);
+            for (DictHosp dictHosp : list) {
+                String mallMerchantSecretKey = SecurityUtils.getMallMerchantSecretKey(secret, dictHosp.getHospAreaId(), dictHosp.getHospAreaName(), dateTime1);
+                dictHosp.setSecretKey(mallMerchantSecretKey);
+                dictHosp.setExpirationTime(dateTime1);
+                dictHosp.setUpdateTime(new Date());
+                dictHospService.updateById(dictHosp);
+            }
+            return AjaxResult.success();
+        } catch (Exception e) {
+            e.printStackTrace();
+        }
+        return AjaxResult.error();
+    }
+
+
+    @GetMapping ("/gxxmpym")//鎵ц
+    @ApiOperation(value = "涓�閿悓姝ユ洿鏂伴」鐩嫾闊崇爜")
+    public AjaxResult gxxmpym() {
+        try {
+            List<TjProject> list = projectService.list();
+            for (TjProject project : list) {
+                project.setProEngName(PinyinUtil.getFirstLetter(project.getProName(),""));
+                projectService.updateById(project);
+            }
+            return AjaxResult.success();
+        } catch (Exception e) {
+            e.printStackTrace();
+        }
+        return AjaxResult.error();
+    }
+
+
+
+    @GetMapping ("/tbhisproprice")//鍚屾his椤圭洰鍗曚环淇℃伅
+    @PreAuthorize("@ss.hasPermi('system:config:tbhisproprice')")
+    public AjaxResult tbhisproprice() {
+         configService.tbhisproprice();
+        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(StringUtil.isNotBlank(jcsqd.getJgzt())){
+                            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