1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
| package com.ltkj.hosp.mapper;
|
| import com.baomidou.mybatisplus.core.mapper.BaseMapper;
| import com.ltkj.hosp.domain.TjAdvice;
| import com.ltkj.hosp.domain.TjAskHistorys;
| import org.apache.ibatis.annotations.Mapper;
| import org.apache.ibatis.annotations.Param;
| import org.apache.ibatis.annotations.Select;
|
| import java.util.List;
| import java.util.Map;
|
| /**
| * @Company: 西安路泰科技有限公司
| * @Author: lige
| * @Date: 2023/4/11 17:53
| */
| @Mapper
| public interface TjAskHistorysMapper extends BaseMapper<TjAskHistorys> {
|
|
| @Select({"<script>", "select", "GROUP_CONCAT(pro_name ORDER BY pro_name) AS names", "from dict_zhengzhuang", "where id in",
| "<foreach collection='ids' item='id' open='(' separator=',' close=')'>",
| "#{id}",
| "</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}' and b.type='既往病') 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}' and b.type='既往病') 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}' and b.type='既往病') 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}' and b.type='既往病') 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}' and b.type='既往病') 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}' and b.type='既往病') c where c.icd_id='11907'),'') aaa),'心脏疾病√') '既往病史'),'1、无异常√ 2、肝炎 3、肺结核 4、皮肤过敏 5、心脏疾病 6、高血压') '既往病史' ,\n" +
| "(SELECT GROUP_CONCAT(hh.a SEPARATOR ',') from (SELECT b.disease_name a FROM tj_ask_medical_history a left join tj_ask_historys b on a.ask_id=b.ask_id where a.tj_num='${tjNumber}' and b.type='既往病' and b.icd_id not IN ('376','11907','30123','11197','15435')) hh) '其他'")
| Map<String,String> jiwangbingshi(String tjNumber);
| }
|
|
