| | |
|---|
| | | import org.apache.ibatis.annotations.Select; |
|---|
| | | |
|---|
| | | import java.util.List; |
|---|
| | | import java.util.Map; |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * @Company: 西安路泰科技有限公司 |
|---|
| | |
|---|
| | | "</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); |
|---|
| | | } |
|---|
