| | |
|---|
| | | and a.del_flag=0 |
|---|
| | | AND t.del_flag=0 |
|---|
| | | <if test="orgid != null and orgid != ''"> |
|---|
| | | and a.orgid = #{orgid} |
|---|
| | | and t.orgid = #{orgid} |
|---|
| | | </if> |
|---|
| | | <if test="leavehospitaldistrictcodes != null and leavehospitaldistrictcodes.size() > 0"> |
|---|
| | | AND t.leavehospitaldistrictcode IN |
|---|
| | |
|---|
| | | FROM |
|---|
| | | service_subtask_detail ssd |
|---|
| | | INNER JOIN service_subtask ss ON ssd.sub_id = ss.id |
|---|
| | | WHERE |
|---|
| | | ss.del_flag=0 |
|---|
| | | WHERE 1=1 |
|---|
| | | AND ss.del_flag=0 |
|---|
| | | AND ssd.del_flag = 0 |
|---|
| | | <if test="orgid != null and orgid != ''"> |
|---|
| | | AND ss.orgid = #{orgid} |
|---|
| | |
|---|
| | | <if test="orgid != null and orgid != ''"> |
|---|
| | | and ss.orgid = #{orgid} |
|---|
| | | </if> |
|---|
| | | AND IFNULL(ssd.matchedtext,ssd.asrtext) IS NOT NULL |
|---|
| | | AND IFNULL(ssd.matchedtext,ssd.asrtext) != '' |
|---|
| | | <if test="leavehospitaldistrictcodes != null and leavehospitaldistrictcodes.size() > 0"> |
|---|
| | | AND ss.leavehospitaldistrictcode IN |
|---|
| | | <foreach collection="leavehospitaldistrictcodes" item="leavehospitaldistrictcode" open="(" separator="," |
|---|
