| | |
| | | and a.id=#{record.id} |
| | | </if> |
| | | <if test="record.isQg != null and record.isQg != ''"> |
| | | and a.is_qg=#{record.isQg} and now() > a.qg_end_time |
| | | and a.is_qg=#{record.isQg} and a.qg_end_time > now() |
| | | </if> |
| | | <if test="record.cateId != null and record.cateId != ''"> |
| | | and (a.category_id = #{record.cateId} or a.category in (select id from xzx_score_goods_category where parent_id=#{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})) |
| | | </if> |
| | | </where> |
| | | group by a.id |