From fd05507e8595739c80f485d67fdeeed91708f746 Mon Sep 17 00:00:00 2001
From: zjh <zjh@888>
Date: 星期四, 21 十二月 2023 16:32:14 +0800
Subject: [PATCH] zjh 本地 2023/12/21 -1
---
ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java | 204 +++++++++++++++++++++++++++++++++++++-------------
1 files changed, 151 insertions(+), 53 deletions(-)
diff --git a/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java b/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java
index 27ff245..4031f4c 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/controller/sqlserver/TjSqlController.java
@@ -1,18 +1,41 @@
package com.ltkj.web.controller.sqlserver;
+import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
+import com.fasterxml.jackson.core.JsonProcessingException;
+import com.fasterxml.jackson.databind.ObjectMapper;
import com.ltkj.common.core.controller.BaseController;
import com.ltkj.common.core.domain.AjaxResult;
+import com.ltkj.common.core.redis.RedisCache;
import com.ltkj.common.enums.DataSourceType;
import com.ltkj.framework.datasource.DynamicDataSourceContextHolder;
+import com.ltkj.hosp.domain.TjCustomer;
+import com.ltkj.hosp.domain.TjOrder;
+import com.ltkj.hosp.domain.TjOrderRemark;
import com.ltkj.hosp.service.*;
import com.ltkj.hosp.sqlDomain.*;
import com.ltkj.hosp.mapper.TestMapper;
+import com.ltkj.system.service.ISysDeptService;
import io.swagger.annotations.Api;
import io.swagger.annotations.ApiOperation;
+import org.checkerframework.checker.units.qual.A;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.data.redis.core.ConvertingCursor;
+import org.springframework.data.redis.core.Cursor;
+import org.springframework.data.redis.core.RedisTemplate;
+import org.springframework.data.redis.core.ScanOptions;
+import org.springframework.data.redis.serializer.RedisSerializer;
import org.springframework.web.bind.annotation.*;
import javax.annotation.Resource;
+import java.sql.ResultSet;
+import java.sql.SQLException;
+import java.util.ArrayList;
+import java.util.HashMap;
import java.util.List;
+import java.util.Map;
+
+import static com.ltkj.framework.datasource.DynamicDataSourceContextHolder.log;
+import static org.apache.poi.hemf.record.emfplus.HemfPlusRecordType.save;
@RestController
@@ -38,6 +61,71 @@
private LtkjHybgdService ltkjHybgdService;
@Resource
private LtkjHysqdService ltkjHysqdService;
+ @Autowired
+ public RedisTemplate<Object,Object> redisTemplate;
+ @Resource
+ private ITjCustomerService tjCustomerService;
+ @Resource
+ private RedisCache redisCache;
+ @Resource
+ private TjAsyncService asyncService;
+ @Resource
+ private ITjOrderRemarkService remarkService;
+ @Resource
+ private ITjOrderService orderService;
+ @Resource
+ private ISysDeptService deptService;
+ @GetMapping("/getRedisValue")
+ @ApiOperation(value = "娴嬭瘯redis妯＄硦鏌ヨ")
+ public AjaxResult getRedisValue(@RequestParam int aa,
+ @RequestParam(defaultValue = "1") Integer page,
+ @RequestParam(defaultValue = "10") Integer pageSize,
+ @RequestParam(required = false) String deptId,
+ @RequestParam(required = false) String tjName,
+ @RequestParam(required = false) String tjNum) throws SQLException, JsonProcessingException {
+// long start = System.currentTimeMillis();
+// //闇�瑕佸尮閰嶇殑key
+// ScanOptions options = ScanOptions.scanOptions()
+// //杩欓噷鎸囧畾姣忔鎵弿key鐨勬暟閲�(寰堝鍗氬鐬庤瑕佹寚瀹欼nteger.MAX_VALUE锛岃繖鏍风殑璇濊窡 keys鏈変粈涔堝尯鍒紵)
+// .count(10000)
+// .match(aa+"*").build();
+// RedisSerializer<String> redisSerializer = (RedisSerializer<String>) redisTemplate.getKeySerializer();
+// Cursor cursor = redisTemplate.executeWithStickyConnection(redisConnection -> new ConvertingCursor<>(redisConnection.scan(options), redisSerializer::deserialize));
+// List<Object> result = new ArrayList<>();
+// while(cursor.hasNext()){
+// String s = cursor.next().toString();
+// redisCache.deleteObject(s);
+// }
+// //鍒囪杩欓噷涓�瀹氳鍏抽棴锛屽惁鍒欎細鑰楀敖杩炴帴鏁般�傛姤Cannot get Jedis connection; nested exception is redis.clients.jedis.exceptions.JedisException: Could not get a
+// cursor.close();
+//// System.out.println(result);
+// log.info("scan鎵弿鍏辫�楁椂锛歿} ms key鏁伴噺锛歿}",System.currentTimeMillis()-start,result.size());
+// Map<String,Object>map=new HashMap<>();
+// map.put("result",result);
+// map.put("scan鎵弿鍏辫�楁椂锛歿} ms key鏁伴噺锛歿}",System.currentTimeMillis()-start+result.size());
+// List<TjOrderRemark> list = remarkService.list(new LambdaQueryWrapper<TjOrderRemark>().ne(TjOrderRemark::getType,2).groupBy(TjOrderRemark::getTjNumber));
+// for (TjOrderRemark remark : list) {
+// TjOrder orderByTjNum = orderService.getOrderByTjNum(remark.getTjNumber());
+// if(null !=orderByTjNum){
+// asyncService.dockerSetWjCustomerByRedis(orderByTjNum.getOrderId(),remark.getDeptId());
+// asyncService.dockerSetYjCustomerByRedis(orderByTjNum.getOrderId(),remark.getDeptId());
+// }
+// }
+ if(null==deptId) deptId="";
+ if(null==tjName) tjName="";
+ if(null==tjNum) tjNum="";
+
+// List<Map<String, Object>> map = deptService.getSysDeptYjWjCustomerList(deptId, tjName, tjNum, aa, page, pageSize);
+// List<ResultSet> map = deptService.getSysDeptYjWjCustomerList1(deptId, tjName, tjNum, aa, page, pageSize);
+// ResultSet resultSet = deptService.getSysDeptYjWjCustomerList12(deptId, tjName, tjNum, aa, page, pageSize);
+// while (resultSet.next()){
+// String anInt = resultSet.getString(1);
+// System.out.println(anInt);
+// }
+
+ Map<String,Object> map = deptService.getSysDeptYjWjCustomerList13(deptId, tjName, tjNum, aa, page, pageSize);
+ return AjaxResult.success(map);
+ }
@GetMapping("/getMiddleDetail")
@@ -72,6 +160,7 @@
@GetMapping("/getTjPat")
+ @ApiOperation(value = "娴嬭瘯getTjPat")
public AjaxResult getTjPat() {
List<LtkjTjPat> list = testMapper.getTjPat();
DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
@@ -80,6 +169,31 @@
}
DynamicDataSourceContextHolder.clearDataSourceType();
return AjaxResult.success(list);
+ }
+
+
+ @GetMapping("/getTjPatByIdCard")
+ @ApiOperation(value = "鏍规嵁韬唤璇佸彿娴嬭瘯getTjPat")
+ public AjaxResult getTjPatByIdCard(@RequestParam String idCard) {
+ LtkjTjPat tjPatByIdCard = testMapper.getTjPatByIdCard(idCard.trim());
+ if(null != tjPatByIdCard){
+ String fcardNo = tjPatByIdCard.getFcardNo();
+ if(null !=fcardNo){
+ fcardNo=fcardNo.trim();
+ tjPatByIdCard.setFcardNo(fcardNo);
+ }
+ LtkjTjPat ltkjTjPat = tjvLtkjvtjpatService.getLtkjTjPatByCusIdCard(idCard);
+ if(null==ltkjTjPat){
+ tjvLtkjvtjpatService.save(tjPatByIdCard);
+ }
+ }
+ DynamicDataSourceContextHolder.clearDataSourceType();
+ //鍐嶆牴鎹韩浠借瘉鍙峰啓customer琛�
+ TjCustomer tjCustomer = tjCustomerService.getTjCustomerByCusIdCard(idCard);
+ if(null == tjCustomer){
+ testMapper.getTjPatByCusId(idCard);
+ }
+ return AjaxResult.success(tjPatByIdCard);
}
@GetMapping("/getExamJcbgd")
@@ -127,69 +241,53 @@
}
- @GetMapping("/getLtkjTjPatById")
- public AjaxResult getLtkjTjPatById(String id) {
- LtkjTjPat one = testMapper.getTjPatById(id);
+
+ @GetMapping("/getTjPatByCusId")
+ public AjaxResult getTjPatByCusId(String cusId) {
+ testMapper.getTjPatByCusId(cusId);
+ return AjaxResult.success();
+ }
+
+
+ @GetMapping("/saveMiddleHeadByPatId")
+ public AjaxResult saveMiddleHeadByPatId(String id) {
+ List<LtkjMiddleHead> one = testMapper.saveMiddleHeadByPatId(id);
DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
- final boolean save = tjvLtkjvtjpatService.save(one);
+ for (LtkjMiddleHead ltkjMiddleHead : one) {
+ final boolean save = headService.save(ltkjMiddleHead);
+ }
DynamicDataSourceContextHolder.clearDataSourceType();
return AjaxResult.success(save);
}
- @GetMapping("/getMiddleDetailById")
- public AjaxResult getMiddleDetailById(String id) {
- LtkjMiddleDetail one = testMapper.getMiddleDetailById(id);
+ @GetMapping("/getMiddleDetailByHeadId")
+ public AjaxResult getMiddleDetailByHeadId(String id) {
+ List<LtkjMiddleDetail> one = testMapper.getMiddleDetailByHeadId(id);
+ for (LtkjMiddleDetail ltkjMiddleDetail : one) {
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ final boolean save = middleDetailService.save(ltkjMiddleDetail);
+ DynamicDataSourceContextHolder.clearDataSourceType();
+ }
+ return AjaxResult.success(one);
+ }
+
+ @GetMapping("/test")
+ public AjaxResult getHysqdByTmh(String id) {
+ List<LtkjHysqd> one = testMapper.getHysqdByTmh(id);
DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
- final boolean save = middleDetailService.save(one);
+ ltkjHysqdService.saveBatch(one);
DynamicDataSourceContextHolder.clearDataSourceType();
- return AjaxResult.success(save);
+ for (LtkjHysqd ltkjHysqd : one) {
+ List<LtkjHybgd> one1 = testMapper.getHybgdByTmh(ltkjHysqd.getTmh());
+ DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
+ ltkjHybgdService.saveBatch(one1);
+ DynamicDataSourceContextHolder.clearDataSourceType();
+ }
+
+ return AjaxResult.success();
}
- @GetMapping("/getMiddleHeadById")
- public AjaxResult getMiddleHeadById(String id) {
- LtkjMiddleHead one = testMapper.getMiddleHeadById(id);
- DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
- final boolean save = headService.save(one);
- DynamicDataSourceContextHolder.clearDataSourceType();
- return AjaxResult.success(save);
- }
-
- @GetMapping("/getExamJcbgdById")
- public AjaxResult getExamJcbgdById(String id) {
- LtkjExamJcbgd one = testMapper.getExamJcbgdById(id);
- DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
- final boolean save = ltkjExamJcbgdService.save(one);
- DynamicDataSourceContextHolder.clearDataSourceType();
- return AjaxResult.success(save);
- }
-
- @GetMapping("/getExamJcsqdById")
- public AjaxResult getExamJcsqdById(String id) {
- LtkjExamJcsqd one = testMapper.getExamJcsqdById(id);
- DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
- final boolean save = ltkjExamJcsqdService.save(one);
- DynamicDataSourceContextHolder.clearDataSourceType();
- return AjaxResult.success(save);
- }
-
- @GetMapping("/getHybgdById")
- public AjaxResult getHybgdById(String id) {
- LtkjHybgd one = testMapper.getHybgdById(id);
- DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
- final boolean save = ltkjHybgdService.save(one);
- DynamicDataSourceContextHolder.clearDataSourceType();
- return AjaxResult.success(save);
- }
-
- @GetMapping("/getHysqdById")
- public AjaxResult getHysqdById(String id) {
- LtkjHysqd one = testMapper.getHysqdById(id);
- DynamicDataSourceContextHolder.setDataSourceType(DataSourceType.MASTER.name());
- final boolean save = ltkjHysqdService.save(one);
- DynamicDataSourceContextHolder.clearDataSourceType();
- return AjaxResult.success(save);
- }
}
--
Gitblit v1.8.0