From fd5d67411cc7afa7aff2b0a53da7c8075a20fe03 Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Tue, 13 May 2025 17:13:58 +0800
Subject: [PATCH] fix: 修改商品类型查询逻辑 - 移除了商品类型为1 和非 3 时对现价不为 0 的限制 - 统一了商品类型查询条件，提高了查询的准确性
---
src/main/resources/mapper/modules/MallGoodsMapper.xml | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/src/main/resources/mapper/modules/MallGoodsMapper.xml b/src/main/resources/mapper/modules/MallGoodsMapper.xml
index 6bc8228..0535fd5 100644
--- a/src/main/resources/mapper/modules/MallGoodsMapper.xml
+++ b/src/main/resources/mapper/modules/MallGoodsMapper.xml
@@ -127,7 +127,7 @@
and a.is_normal = #{record.isNormal}
</if>
<if test="record.goodsType != null and record.goodsType != '' and record.goodsType == 1">
- and a.goods_type = #{record.goodsType} and a.present_price != 0
+ and a.goods_type = #{record.goodsType}
</if>
<if test="record.goodsType != null and record.goodsType != '' and record.goodsType == 2">
and a.goods_type = #{record.goodsType}
@@ -369,7 +369,7 @@
and a.is_normal = #{record.isNormal}
</if>
<if test="record.goodsType != null and record.goodsType != '' and record.goodsType != 3">
- and a.goods_type = #{record.goodsType} and a.present_price != 0
+ and a.goods_type = #{record.goodsType}
</if>
<if test="record.goodsType == 3">
and a.present_price = 0
--
Gitblit v1.9.1