From ebd34d72e213ca6f2adbad4b977faf55e5c172e4 Mon Sep 17 00:00:00 2001
From: lige <bestlige@outlook.com>
Date: 星期二, 02 一月 2024 16:05:08 +0800
Subject: [PATCH] 职业健康报表既往病史sql
---
ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAskHistorysMapper.java | 5 +++++
ltkj-admin/src/main/java/com/ltkj/web/jmreport/ReportDataController.java | 17 +++++++++++++++++
2 files changed, 22 insertions(+), 0 deletions(-)
diff --git a/ltkj-admin/src/main/java/com/ltkj/web/jmreport/ReportDataController.java b/ltkj-admin/src/main/java/com/ltkj/web/jmreport/ReportDataController.java
index bdbbc7b..a77f2df 100644
--- a/ltkj-admin/src/main/java/com/ltkj/web/jmreport/ReportDataController.java
+++ b/ltkj-admin/src/main/java/com/ltkj/web/jmreport/ReportDataController.java
@@ -5,6 +5,7 @@
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.ltkj.common.utils.StringUtils;
import com.ltkj.hosp.domain.*;
+import com.ltkj.hosp.mapper.TjAskHistorysMapper;
import com.ltkj.hosp.service.*;
import com.ltkj.system.service.ISysDeptService;
import io.swagger.annotations.Api;
@@ -63,6 +64,10 @@
private ITjStandardService tjStandardService;
@Resource
private ITjAdviceService tjAdviceService;
+
+
+ @Resource
+ private TjAskHistorysMapper tjAskHistorysMapper;
/**
* 璇ヤ綋妫�鍙锋槸鍚﹀彲鐢熸垚瀵兼鍗�
@@ -391,4 +396,16 @@
}
+
+ /**
+ * 鑱屼笟鍋ュ悍鎶ュ憡鏌ヨ鏃㈠線鐥呭彶
+ */
+ @GetMapping("/jiwangbingshi")
+ @ApiOperation(value = "鑱屼笟鍋ュ悍鎶ュ憡鏌ヨ鏃㈠線鐥呭彶")
+ public String jiwangbingshi(@RequestParam("tjNumber") String tjNumber) {
+ final String jiwangbingshi = tjAskHistorysMapper.jiwangbingshi(tjNumber);
+ return jiwangbingshi;
+ }
+
+
}
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAskHistorysMapper.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAskHistorysMapper.java
index 64e986f..334a173 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAskHistorysMapper.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjAskHistorysMapper.java
@@ -24,4 +24,9 @@
"</foreach>",
"</script>" })
String getZhengZhuangStr(@Param("ids")List<String> ids);
+
+
+ @Select("SELECT IF((SELECT COUNT(*) from (SELECT b.* FROM tj_ask_medical_history a left join tj_ask_historys b on a.ask_id=b.ask_id where a.tj_num='${tjNumber}') c where c.icd_id IN ('376','11907','30123','11197','15435'))>0,(SELECT REPLACE((SELECT REPLACE((SELECT REPLACE((SELECT REPLACE((SELECT REPLACE('1銆佹棤寮傚父2銆佽倽鐐�3銆佽偤缁撴牳4銆佺毊鑲よ繃鏁�5銆佸績鑴忕柧鐥�6銆侀珮琛�鍘�',(SELECT IFNULL((SELECT c.disease_name from (SELECT b.* FROM tj_ask_medical_history a left join tj_ask_historys b on a.ask_id=b.ask_id where a.tj_num='${tjNumber}') c where c.icd_id='11197'),'') aaa),'楂樿鍘嬧垰')),(SELECT IFNULL((SELECT c.disease_name from (SELECT b.* FROM tj_ask_medical_history a left join tj_ask_historys b on a.ask_id=b.ask_id where a.tj_num='${tjNumber}') c where c.icd_id='15435'),'') aaa),'鑲濈値鈭�') as a),(SELECT IFNULL((SELECT c.disease_name from (SELECT b.* FROM tj_ask_medical_history a left join tj_ask_historys b on a.ask_id=b.ask_id where a.tj_num='${tjNumber}') c where c.icd_id='376'),'') aaa),'鑲虹粨鏍糕垰') as bb),(SELECT IFNULL((SELECT c.disease_name from (SELECT b.* FROM tj_ask_medical_history a left join tj_ask_historys b\n" +
+ "on a.ask_id=b.ask_id where a.tj_num='${tjNumber}') c where c.icd_id='30123'),'') aaa) ,'鐨偆杩囨晱鈭�')),(SELECT IFNULL((SELECT c.disease_name from (SELECT b.* FROM tj_ask_medical_history a left join tj_ask_historys b on a.ask_id=b.ask_id where a.tj_num='${tjNumber}') c where c.icd_id='11907'),'') aaa),'蹇冭剰鐤剧梾鈭�') '鏃㈠線鐥呭彶'),'1銆佹棤寮傚父(鈭�) 2銆佽倽鐐� 3銆佽偤缁撴牳 4銆佺毊鑲よ繃鏁� 5銆佸績鑴忕柧鐥� 6銆侀珮琛�鍘�') '鏃㈠線鐥呭彶'")
+ String jiwangbingshi(String tjNumber);
}
--
Gitblit v1.8.0