xml文件的sql语句如下:
SELECT SUM(COLLECT_ITEM_OUTPUT_VALUE) as collectItemOutputValue,STATIS_TIME
FROM t_ep_statistical_data
<where>
DATE_FORMAT(STATIS_TIME,'%Y-%m-%d') >=#{startTime}
AND
DATE_FORMAT(STATIS_TIME,'%Y-%m-%d') <=DATE_SUB(DATE_add(#{endTime},INTERVAL 1 MONTH),INTERVAL 1 DAY)
AND COLLECT_ITEM_ID = #{statisticalData.collectItemId}
AND STATISTICAL_PERIOD = 0
<if test="statisticalData.dataType!=null">
AND DATA_TYPE = #{statisticalData.dataType}
</if>
<if test="statisticalData.deptId!=null">
AND DEPT_ID = #{statisticalData.deptId}
</if>
<if test="statisticalData.collectSiteId!=null">
AND COLLECT_SITE_ID = #{statisticalData.collectSiteId}
</if>
<if test="statisticalData.monitorType!=null">
AND MONITOR_TYPE = #{statisticalData.monitorType}
<