Administrator
2 days ago e7712e6cc0e991e10851b913f0434f97dc06ccae
fix(ai): 修复AI会员答题查询中产品状态过滤问题

- 在AiMemberAnswerMapper.xml中添加产品状态过滤条件
- 确保只查询状态为1的活跃产品数据
- 防止已下架产品出现在答题结果中
1 files modified
1 ■■■■ changed files
src/main/resources/mapper/modules/AiMemberAnswerMapper.xml 1 ●●●● patch | view | raw | blame | history
src/main/resources/mapper/modules/AiMemberAnswerMapper.xml
@@ -15,6 +15,7 @@
        left join ai_product b on a.product_id = b.id and b.state = 1
        <where>
            and a.member_id = #{record.memberUuid}
            and b.state = 1
            <if test="record != null">
                <if test="record.state != null">
                    and a.state = #{record.state}