mybatis集合查询

<?xml version="1.0" encoding="UTF-8" ?>  
<!DOCTYPE mapper PUBLIC    
"-//mybatis.org//DTD Mapper 3.0//EN"    
"http://mybatis.org/dtd/mybatis-3-mapper.dtd" >
<mapper namespace="com.neusoft.searchservice.xztwopublic.model.CountColumn">


<select id="getCommitOrSaveCount" parameterType="map" resultType="countColumn">
<!--行政许可提交 -->
select count(0) as Count from t_xzxk t where commitorsave='1' and isremove='0'
<if test="countColumn.startDate != null ">
AND TO_CHAR(SJC, 'yyyy-MM-dd')<![CDATA[ >= ]]> TO_CHAR(#{countColumn.startDate}, 'yyyy-MM-dd')
</if>
<if test="countColumn.endDate != null ">
AND TO_CHAR(SJC, 'yyyy-MM-dd')<![CDATA[ <= ]]> TO_CHAR(#{countColumn.endDate}, 'yyyy-MM-dd')
</if>
<if test="dpIdsArray != null">
AND T.DEPARTID IN 
<foreach collection="dpIdsArray" item="dpids" open="(" separator="," close=")">
#{dpids}   
    </foreach>
   </if>
   <!--行政许可保存  -->
union all 
   select count(0) as Count from t_xzxk t where commitorsave='0' and isremove='0'
<if test="countColumn.startDate != null ">
AND TO_CHAR(SJC, 'yyyy-MM-dd')<![CDATA[ >= ]]> TO_CHAR(#{countColumn.startDate}, 'yyyy-MM-dd')
</if>
<if test="countColumn.endDate != null ">
AND TO_CHAR(SJC, 'yyyy-MM-dd')<![CDATA[ <= ]]> TO_CHAR(#{countColumn.endDate}, 'yyyy-MM-dd')
</if>
<if test="dpIdsArray != null">
AND T.DEPARTID IN 
<foreach collection="dpIdsArray" item="dpids" open="(" separator="," close=")">
#{dpids}   
    </foreach>
   </if>
   <!-- 行政处罚提交 -->
union all 
select count(0) as Count from t_xzcf  where commitorsave='1' and isremove='0'
<if test="countColumn.startDate != null ">
AND TO_CHAR(SJC, 'yyyy-MM-dd')<![CDATA[ >= ]]> TO_CHAR(#{countColumn.startDate}, 'yyyy-MM-dd')
</if>
<if test="countColumn.endDate != null ">
AND TO_CHAR(SJC, 'yyyy-MM-dd')<![CDATA[ <= ]]> TO_CHAR(#{countColumn.endDate}, 'yyyy-MM-dd')
</if>
<if test="dpIdsArray != null">
AND DEPARTID IN 
<foreach collection="dpIdsArray" item="dpids" open="(" separator="," close=")">
#{dpids}   
    </foreach>
   </if>
    <!-- 行政处罚保存 -->
union all 
select count(0) as Count from t_xzcf  where commitorsave='0' and isremove='0'
<if test="countColumn.startDate != null ">
AND TO_CHAR(SJC, 'yyyy-MM-dd')<![CDATA[ >= ]]> TO_CHAR(#{countColumn.startDate}, 'yyyy-MM-dd')
</if>
<if test="countColumn.endDate != null ">
AND TO_CHAR(SJC, 'yyyy-MM-dd')<![CDATA[ <= ]]> TO_CHAR(#{countColumn.endDate}, 'yyyy-MM-dd')
</if>
<if test="dpIdsArray != null">
AND DEPARTID IN 
<foreach collection="dpIdsArray" item="dpids" open="(" separator="," close=")">
#{dpids}   
    </foreach>
   </if>
</select>

</mapper>