From 25c40344055ff5f688df2f5b566ef3eb8bf73709 Mon Sep 17 00:00:00 2001 From: 陶杰 <1378534974@qq.com> Date: 星期六, 09 十一月 2024 20:56:49 +0800 Subject: [PATCH] 1.我的订单-打印:修改成支付时间查询 --- src/main/resources/mapper/payment/OrderMapper.xml | 16 ++++++++-------- 1 files changed, 8 insertions(+), 8 deletions(-) diff --git a/src/main/resources/mapper/payment/OrderMapper.xml b/src/main/resources/mapper/payment/OrderMapper.xml index 5e6e22a..6a3fc18 100644 --- a/src/main/resources/mapper/payment/OrderMapper.xml +++ b/src/main/resources/mapper/payment/OrderMapper.xml @@ -183,18 +183,18 @@ <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> -- Gitblit v1.9.3