parent: 95aaeee4 | patch | commit | ignore whitespace
xiaoyong931011
2021-11-11 52ae90b3ad7eb167af53e2b61f10d7bc08860c3d 
20211108
1 files modified
2 ■■■■■ changed files
gc-shop/src/main/resources/mapper/shop/ScoreGoodsMapper.xml 2 ●●●●● patch | view | raw | blame | history 
 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 &lt; 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}))