区间查询

取交集的区间查询

两个区间段只要有交集就查出来

<if test='(startTime != "" and startTime != null) and (endTime == null or endTime == "")'>
    AND csrw.endtime >= #{startTime}
</if>

<if test='(startTime == "" or startTime == null) and (endTime != null and endTime != "")'>
    AND csrw.createtime <= #{endTime}
</if>

<if test='(startTime != "" and startTime != null) and (endTime != null and endTime != "")'>
    AND !(csrw.endtime < #{startTime} OR csrw.endtime > #{startTime})
</if>