From 52ae90b3ad7eb167af53e2b61f10d7bc08860c3d Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Thu, 11 Nov 2021 17:02:14 +0800 Subject: [PATCH] 20211108 --- gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml | 2 +- 1 files changed, 1 insertions(+), 1 deletions(-) diff --git a/gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml b/gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml index 76638ae..b35247d 100644 --- a/gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml +++ b/gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml @@ -105,7 +105,7 @@ and a.id=#{record.id} </if> <if test="record.isQg != null and record.isQg != ''"> - and a.is_qg=#{record.isQg} and a.qg_end_time > now() + and a.is_qg=#{record.isQg} and a.qg_end_time > now() and a.qg_start_time < now() </if> <if test="record.cateId != null and record.cateId != ''"> and (a.category_id = #{record.cateId} or a.category_id in (select id from xzx_score_goods_category where parent_id=#{record.cateId})) -- Gitblit v1.9.1