From 4ee42556139749bf6f29d47b912da0be6c37da2a Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Thu, 15 May 2025 11:29:39 +0800
Subject: [PATCH] feat(mall): 添加商品 SKU静态属性价格字段
---
src/main/resources/mapper/modules/MallGoodsSkuMapper.xml | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diff --git a/src/main/resources/mapper/modules/MallGoodsSkuMapper.xml b/src/main/resources/mapper/modules/MallGoodsSkuMapper.xml
index 507ef26..502b48a 100644
--- a/src/main/resources/mapper/modules/MallGoodsSkuMapper.xml
+++ b/src/main/resources/mapper/modules/MallGoodsSkuMapper.xml
@@ -6,6 +6,7 @@
<select id="selectSkuInfoById" resultType="cc.mrbird.febs.mall.entity.MallGoodsSku">
select
a.*,
+ FLOOR(a.original_price*c.static_prop) staticPropPrice,
b.name styleName,
c.goods_name goodsName
from mall_goods_sku a
--
Gitblit v1.9.1