select
<if test="ygdm != null">
HLXJLIST.ZLHS as ygdm,(select ygxm from EMPLIST where EMPLIST.YGDM = HLXJLIST.ZLHS) as ygxm,
</if>
count(1) as txfscs,
hemolist.TXFS,(select txfsmc from txfsdict where txfsdict.txfs = hemolist.txfs) as txfsmc
from HLXJLIST,hemolist,AREADEV
where HEMOLIST.SBID = AREADEV.SBID
and HLXJLIST.Xtxh = hemolist.xtxh
<if test="ygdm != null">
and HLXJLIST.ZLHS = #{ygdm}
</if>
AND HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP}
AND HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP}
and HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
<if test="ygdm != null">
group by ZLHS,txfs
</if>
<if test="ygdm == null">
group by txfs
</if>
order by txfs
</select>
<select id="getSingleTxgzl" parameterType="java.util.Map" resultMap="txgzlReport">
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
1 as CCZL,
'穿刺' as CCZLMC,
'cchs' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, VASLIST, TLLXDICT, AREADEV
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.CCHS = EMPLIST.YGDM AND
HEMOLIST.TLXH = VASLIST.TLXH AND
VASLIST.TLLX = TLLXDICT.JLID AND
HEMOLIST.SBID = AREADEV.SBID AND
TLLXDICT.TLTYPE = 1 AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
2 as CCZL,
'治疗' as CCZLMC,
'zlhs' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, AREADEV
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.SBID = AREADEV.SBID AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
3 as CCZL,
'导管' as CCZLMC,
'dgrc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, VASLIST, TLLXDICT, AREADEV
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.CCHS = EMPLIST.YGDM AND
HEMOLIST.TLXH = VASLIST.TLXH AND
VASLIST.TLLX = TLLXDICT.JLID AND
HEMOLIST.SBID = AREADEV.SBID AND
TLLXDICT.TLTYPE = 2 AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
4 as CCZL,
'导管溶栓' as CCZLMC,
'dgrsrc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, HLJLLIST, HLJLLIST_QTSJ, AREADEV
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.XTXH = HLJLLIST.XTXH AND
HLJLLIST.JLID = HLJLLIST_QTSJ.JLID AND
HEMOLIST.SBID = AREADEV.SBID AND
HLJLLIST_QTSJ.QTSJID = 9 AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
5 as CCZL,
'新内瘘穿刺' as CCZLMC,
'xnlccrc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, HLJLLIST, HLJLLIST_QTSJ, AREADEV
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.XTXH = HLJLLIST.XTXH AND
HLJLLIST.JLID = HLJLLIST_QTSJ.JLID AND
HEMOLIST.SBID = AREADEV.SBID AND
HLJLLIST_QTSJ.QTSJID = 10 AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
6 as CCZL,
'第一班' as CCZLMC,
'zblb1rc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, AREADEV
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.SBID = AREADEV.SBID AND
HEMOLIST.ZBLB = 1 AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
7 as CCZL,
'第二班' as CCZLMC,
'zblb2rc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, AREADEV
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.SBID = AREADEV.SBID AND
HEMOLIST.ZBLB = 2 AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
8 as CCZL,
'第三班' as CCZLMC,
'zblb3rc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, AREADEV
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.SBID = AREADEV.SBID AND
HEMOLIST.ZBLB = 3 AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
9 as CCZL,
'第四班' as CCZLMC,
'zblb4rc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, AREADEV
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.SBID = AREADEV.SBID AND
HEMOLIST.ZBLB = 4 AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
10 as CCZL,
'无肝素' as CCZLMC,
'wgsrc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, AREADEV
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.SBID = AREADEV.SBID AND
HEMOLIST.KYFA = 3 AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
11 as CCZL,
'住院' as CCZLMC,
'zyrc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, AREADEV
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.SBID = AREADEV.SBID AND
HEMOLIST.BRLY = 2 AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
12 as CCZL,
'人造血管' as CCZLMC,
'rzxgrc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, AREADEV, VASLIST, TLLXDICT
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.SBID = AREADEV.SBID AND
HEMOLIST.TLXH = VASLIST.TLXH AND
VASLIST.TLLX = TLLXDICT.JLID AND
(TLLXDICT.LXMC = '人造血管' or VASLIST.TLBW IN (SELECT DMSB FROM DICTLIST WHERE DMLB = 44 AND DMMC = '人造血管')) AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
13 as CCZL,
'血液透析' as CCZLMC,
'hdrc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, AREADEV, TXFSDICT
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.SBID = AREADEV.SBID AND
HEMOLIST.TXFS = TXFSDICT.TXFS AND
TXFSDICT.TXFSMC = 'HD' AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
14 as CCZL,
'滤过' as CCZLMC,
'hdfrc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, AREADEV, TXFSDICT
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.SBID = AREADEV.SBID AND
HEMOLIST.TXFS = TXFSDICT.TXFS AND
TXFSDICT.TXFSMC = 'HDF' AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
15 as CCZL,
'灌流' as CCZLMC,
'hprc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, AREADEV, TXFSDICT
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.SBID = AREADEV.SBID AND
HEMOLIST.TXFS = TXFSDICT.TXFS AND
TXFSDICT.GLBZ = 1 AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
SELECT EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
16 as CCZL,
'UFHD' as CCZLMC,
'hfhd' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST, HEMOLIST, EMPLIST, AREADEV, TXFSDICT
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.SBID = AREADEV.SBID AND
HEMOLIST.TXFS = TXFSDICT.TXFS AND
TXFSDICT.TXFSMC = 'UFHD' AND
EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR} AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
UNION ALL
select
EMPLIST.YGDM,
EMPLIST.YGXM,
HEMOLIST.XTXH,
18 as CCZL,
'透析不满3.5h人次' as CCZLMC,
'txbmrc' as pydm,
<if test="tjjd == 1">
to_char(HEMOLIST.JZSJ, 'yyyy"年"') as PROJECTDATE
</if>
<if test="tjjd == 2">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"') as PROJECTDATE
</if>
<if test="tjjd == 3">
to_char(HEMOLIST.JZSJ,'yyyy"年"mm"月"dd"日"') as PROJECTDATE
</if>
<if test="tjjd == 4">
to_char(HEMOLIST.JZSJ,'yyyy"年"q"季度"') as PROJECTDATE
</if>
FROM HLXJLIST,HEMOLIST,EMPLIST,AREADEV
WHERE HLXJLIST.XTXH = HEMOLIST.XTXH AND
HLXJLIST.ZLHS = EMPLIST.YGDM AND
HEMOLIST.SBID = AREADEV.SBID AND
HEMOLIST.JZSJ >= #{begin,jdbcType=TIMESTAMP} AND
HEMOLIST.JZSJ <= #{end,jdbcType=TIMESTAMP} AND
HEMOLIST.TXZT = 3
and EMPLIST.YGDM = #{ygdm,jdbcType=VARCHAR}
and hlxjlist.ZLSJ < 3.5
<if test="centerid gt 0">
and HEMOLIST.CENTERID = #{centerid,jdbcType=DECIMAL}
</if>
<if test="qyid != null and qyid != ''">
and AREADEV.qyid IN (${qyid})
</if>
<if test="whereClause != null and whereClause != ''">
${whereClause}
</if>
ORDER BY PROJECTDATE 帮我优化一下这个sql