| | |
| | | <if test="condition.statusBackend != null and condition.statusBackend != ''"> |
| | | AND q.status_backend = #{condition.statusBackend} |
| | | </if> |
| | | <if test="condition.startDate != null"> |
| | | AND q.payment_time >= #{condition.startDate} |
| | | </if> |
| | | <if test="condition.endDate != null"> |
| | | AND q.payment_time <= #{condition.endDate} |
| | | </if> |
| | | <if test="condition.createStartDate != null"> |
| | | AND q.create_time >= #{condition.createStartDate} |
| | | AND q.payment_time >= #{condition.createStartDate} |
| | | </if> |
| | | <if test="condition.createEndDate != null"> |
| | | AND q.create_time <= #{condition.createEndDate} |
| | | AND q.payment_time <= #{condition.createEndDate} |
| | | </if> |
| | | <!-- <if test="condition.createStartDate != null">--> |
| | | <!-- AND q.create_time >= #{condition.createStartDate}--> |
| | | <!-- </if>--> |
| | | <!-- <if test="condition.createEndDate != null">--> |
| | | <!-- AND q.create_time <= #{condition.createEndDate}--> |
| | | <!-- </if>--> |
| | | <if test="condition.partnerId != null"> |
| | | AND q.partner_id = #{condition.partnerId} |
| | | </if> |