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