From 13a31edf7f569cdcf15d3c43a476a2c947f47fbf Mon Sep 17 00:00:00 2001
From: wlzboy <66905212@qq.com>
Date: 星期日, 09 十一月 2025 22:33:24 +0800
Subject: [PATCH] feat: 增加hospdata表，同步sqlserver过来
---
ruoyi-admin/src/main/java/com/ruoyi/web/controller/system/HospDataController.java | 121 ++++++++++++++++++++++++++++++++++++++-
1 files changed, 116 insertions(+), 5 deletions(-)
diff --git a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/system/HospDataController.java b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/system/HospDataController.java
index e8da24b..ca8d171 100644
--- a/ruoyi-admin/src/main/java/com/ruoyi/web/controller/system/HospDataController.java
+++ b/ruoyi-admin/src/main/java/com/ruoyi/web/controller/system/HospDataController.java
@@ -4,6 +4,7 @@
import com.ruoyi.common.core.domain.AjaxResult;
import com.ruoyi.system.domain.HospData;
import com.ruoyi.system.mapper.HospDataMapper;
+import com.ruoyi.system.service.ISQLHospDataService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;
@@ -14,6 +15,8 @@
/**
* 鍖婚櫌鏁版嵁Controller
+ * 浠嶮ySQL鐨則b_hosp_data琛ㄦ煡璇㈠尰闄㈡暟鎹�
+ * hospId瀵瑰簲legacy_hosp_id瀛楁锛堟棫绯荤粺鐨勫尰闄D锛�
*
* @author ruoyi
* @date 2024-01-16
@@ -24,23 +27,131 @@
@Autowired
private HospDataMapper hospDataMapper;
+
+ @Autowired
+ private ISQLHospDataService sqlHospDataService;
/**
- * 鎼滅储鍖婚櫌
- * 鏀寔鏍规嵁鍖婚櫌鍚嶇О鎴栧湴鍧�杩涜妯＄硦鎼滅储
+ * 鎼滅储鍖婚櫌锛堜粠MySQL tb_hosp_data琛ㄦ煡璇級
+ * 鏀寔鏍规嵁鍖婚櫌鍚嶇О銆佸湴鍧�銆佸湴鍩熻繘琛屾ā绯婃悳绱�
+ * @param keyword 鎼滅储鍏抽敭璇嶏紙鍖婚櫌鍚嶇О銆佸湴鍧�銆佺畝绉般�佺渷甯傚尯锛�
+ * @param deptId 閮ㄩ棬ID锛堢敤浜庢牴鎹儴闂ㄥ尯鍩熼厤缃繃婊ゅ尰闄級
*/
@GetMapping("/search")
- public AjaxResult searchHospitals(@RequestParam(value = "keyword", required = false) String keyword) {
- List<HospData> list = hospDataMapper.searchHospitals(keyword);
+ public AjaxResult searchHospitals(
+ @RequestParam(value = "keyword", required = false) String keyword,
+ @RequestParam(value = "deptId", required = false) Long deptId) {
+ List<HospData> list;
+
+ // 濡傛灉keyword涓虹┖锛屼娇鐢ㄩ儴闂ㄥ尯鍩熻繃婊ゆ煡璇�
+ if (keyword == null || keyword.trim().isEmpty()) {
+ if (deptId != null) {
+ list = hospDataMapper.searchHospitalsByDeptRegion(null, deptId);
+ } else {
+ list = hospDataMapper.searchHospitals(null, null);
+ }
+ } else {
+
+ list = hospDataMapper.searchHospitals(keyword, null);
+
+ }
+
+ // 纭繚"瀹朵腑"鍦ㄧ粨鏋滀腑
+ Integer homeHospId = hospDataMapper.getHomeHospId();
+ if(homeHospId > 0 && !list.isEmpty() && list.stream().noneMatch(hospData -> hospData.getHospId().equals(homeHospId))) {
+ HospData hospData = hospDataMapper.selectHospDataById(homeHospId);
+ if (hospData != null) {
+ list.add(0, hospData);
+ }
+ }
return success(list);
}
/**
- * 鏍规嵁ID鑾峰彇鍖婚櫌璇︽儏
+ * 鏍规嵁ID鑾峰彇鍖婚櫌璇︽儏锛堜粠MySQL tb_hosp_data琛ㄦ煡璇級
+ * @param hospId 鍖婚櫌ID锛堝搴攍egacy_hosp_id锛�
*/
@GetMapping("/detail")
public AjaxResult getHospitalDetail(@RequestParam("hospId") Integer hospId) {
HospData hospital = hospDataMapper.selectHospDataById(hospId);
return success(hospital);
}
+
+ /**
+ * 鑾峰彇甯哥敤杞嚭鍖婚櫌鍒楄〃锛堜粠MySQL tb_hosp_data琛ㄦ煡璇級
+ * @param serviceOrdClass 鍒嗗叕鍙哥紪鐮侊紙service_order_class锛�
+ * @param region 鍦板煙鍏抽敭璇嶏紙鍙�夛級
+ */
+ @GetMapping("/frequent/out")
+ public AjaxResult getFrequentOutHospitals(
+ @RequestParam("serviceOrdClass") String serviceOrdClass,
+ @RequestParam(value = "region", required = false) String region) {
+ // 鏌ヨ甯哥敤杞嚭鍖婚櫌ID鍒楄〃
+ logger.info("getFrequentOutHospitals 浼犲叆鐨� serviceOrdClass :{}",serviceOrdClass);
+ List<Integer> hospIds = sqlHospDataService.selectFrequentOutHospitalIds(serviceOrdClass);
+ logger.info(" getFrequentOutHospitals 鏌ヨ鍑烘潵鐨� hospIds :{}",hospIds.toArray().length);
+ if (hospIds.isEmpty()) {
+ return success();
+ }
+
+ // 鏍规嵁ID鍒楄〃鏌ヨ鍖婚櫌璇︽儏
+ List<HospData> hospitals = hospDataMapper.selectHospDataByIds(hospIds, region);
+
+ return success(hospitals);
+ }
+
+ /**
+ * 鑾峰彇甯哥敤杞叆鍖婚櫌鍒楄〃锛堜粠MySQL tb_hosp_data琛ㄦ煡璇級
+ * @param serviceOrdClass 鍒嗗叕鍙哥紪鐮侊紙service_order_class锛�
+ * @param region 鍦板煙鍏抽敭璇嶏紙鍙�夛級
+ */
+ @GetMapping("/frequent/in")
+ public AjaxResult getFrequentInHospitals(
+ @RequestParam("serviceOrdClass") String serviceOrdClass,
+ @RequestParam(value = "region", required = false) String region) {
+ // 鏌ヨ甯哥敤杞叆鍖婚櫌ID鍒楄〃
+ logger.info("getFrequentInHospitals 浼犲叆鐨� serviceOrdClass {}",serviceOrdClass);
+ List<Integer> hospIds = sqlHospDataService.selectFrequentInHospitalIds(serviceOrdClass);
+ logger.info("getFrequentInHospitals 鏌ヨ鍑烘潵鐨� hospIds {}",hospIds.toArray().length);
+ if (hospIds.isEmpty()) {
+ return success();
+ }
+ Integer homeHospId=hospDataMapper.getHomeHospId();
+
+ // 鏍规嵁ID鍒楄〃鏌ヨ鍖婚櫌璇︽儏
+ List<HospData> hospitals = hospDataMapper.selectHospDataByIds(hospIds, region);
+ if(homeHospId>0) {
+
+ HospData hospData= hospDataMapper.selectHospDataById(homeHospId);
+ hospitals.add(0,hospData);
+ }
+ return success(hospitals);
+ }
+
+ /**
+ * 鏍规嵁閮ㄩ棬鍖哄煙閰嶇疆鎼滅储鍖婚櫌锛堜粠MySQL tb_hosp_data琛ㄦ煡璇紝鏀寔鐪併�佸競銆佸幙/鍖虹瓑澶氱骇鍖哄煙锛�
+ * @param keyword 鎼滅储鍏抽敭璇�
+ * @param deptId 閮ㄩ棬ID
+ */
+ @GetMapping("/search/by-dept-region")
+ public AjaxResult searchHospitalsByDeptRegion(
+ @RequestParam(value = "keyword", required = false) String keyword,
+ @RequestParam("deptId") Long deptId) {
+ logger.info("鏍规嵁閮ㄩ棬鍖哄煙閰嶇疆鎼滅储鍖婚櫌锛歞eptId={}, keyword={}", deptId, keyword);
+
+ // 璋冪敤Mapper鏌ヨ锛岃嚜鍔ㄦ牴鎹儴闂ㄧ殑鍖哄煙閰嶇疆杩囨护鍖婚櫌
+ List<HospData> hospitals = hospDataMapper.searchHospitalsByDeptRegion(keyword, deptId);
+ logger.info("鏌ヨ鍒板尰闄㈡暟閲忥細{}", hospitals.size());
+
+ // 纭繚"瀹朵腑"鍦ㄧ粨鏋滀腑
+ Integer homeHospId = hospDataMapper.getHomeHospId();
+ if (homeHospId > 0 && hospitals.stream().noneMatch(h -> h.getHospId().equals(homeHospId))) {
+ HospData homeHosp = hospDataMapper.selectHospDataById(homeHospId);
+ if (homeHosp != null) {
+ hospitals.add(0, homeHosp);
+ }
+ }
+
+ return success(hospitals);
+ }
}
--
Gitblit v1.9.1