捐献完成列表返回增加疾病诊断名称,捐献确认列表添加终止案例过滤
| | |
| | | sd.BloodType AS bloodtype, |
| | | sd.idcardno AS idcardno, |
| | | sd.id AS infoid, |
| | | sd.diagnosisname, |
| | | sdc.ID AS id, |
| | | sdc.DonorNo AS donorno, |
| | | sdc.IsBodyDonation AS isbodydonation, |
| | |
| | | <if test="infoid != null">and sd.id = #{infoid}</if> |
| | | <if test="completeState != null and completeState != ''">and sdc.complete_state = #{completeState}</if> |
| | | </where> |
| | | order by sd.InpatientNo desc |
| | | order by sd.ReportTime desc |
| | | <if test="pageNum != null and pageSize != null">limit #{pageNum},#{pageSize}</if> |
| | | </select> |
| | | |
| | |
| | | LEFT JOIN service_relativesconfirmation sr ON sd.ID = sr.InfoID and sd.del_flag = 0 |
| | | AND sr.del_flag = 0 |
| | | <where> |
| | | sd.termination_case = 0 |
| | | <if test="infoid != null">AND sd.ID = #{infoid}</if> |
| | | <if test="recordstate != null and recordstate != ''">AND sd.RecordState = #{recordstate}</if> |
| | | <if test="caseNo != null and caseNo != ''">AND sd.case_no = #{caseNo}</if> |