时间交叉查询:
<if test="applyBeginDate != null">
AND APPLY_END_DATE >= TRUNC(#{applyBeginDate})
<if test="applyEndDate == null">
AND TRUNC(#{applyBeginDate})+1 > D.APPLY_BEGIN_DATE
</if>
</if>
<if test="applyEndDate != null">
AND TRUNC(#{applyEndDate})+1 > D.APPLY_BEGIN_DATE
<if test="applyBeginDate == null">
AND APPLY_END_DATE >= TRUNC(#{applyEndDate})
</if>
</if>
时间不交叉查询:
<if test="applyWorkBeginDate != null">
AND APPLY_WORK_BEGIN_DATE >= #{applyWorkBeginDate}
</if>
<if test="applyWorkEndDate != null">
AND APPLY_WORK_END_DATE <= #{applyWorkEndDate}
</if>