From b3810c8cb1fb0b9b33cd42fcabd0cf30bacab37d Mon Sep 17 00:00:00 2001
From: Administrator <15274802129@163.com>
Date: Wed, 14 May 2025 15:02:50 +0800
Subject: [PATCH] feat(mall): 添加商品积分价格字段
---
src/main/resources/mapper/modules/MallGoodsMapper.xml | 2 ++
src/main/java/cc/mrbird/febs/mall/vo/GoodsDetailsSkuVo.java | 3 +++
src/main/java/cc/mrbird/febs/mall/entity/MallGoodsSku.java | 3 +++
3 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/mall/entity/MallGoodsSku.java b/src/main/java/cc/mrbird/febs/mall/entity/MallGoodsSku.java
index f3944ab..fcd4376 100644
--- a/src/main/java/cc/mrbird/febs/mall/entity/MallGoodsSku.java
+++ b/src/main/java/cc/mrbird/febs/mall/entity/MallGoodsSku.java
@@ -47,5 +47,8 @@
@TableField(exist = false)
private BigDecimal skuGoodsWeight;
+ @TableField(exist = false)
+ private String staticPropPrice;
+
private String sample;
}
diff --git a/src/main/java/cc/mrbird/febs/mall/vo/GoodsDetailsSkuVo.java b/src/main/java/cc/mrbird/febs/mall/vo/GoodsDetailsSkuVo.java
index f291658..fe9b190 100644
--- a/src/main/java/cc/mrbird/febs/mall/vo/GoodsDetailsSkuVo.java
+++ b/src/main/java/cc/mrbird/febs/mall/vo/GoodsDetailsSkuVo.java
@@ -32,6 +32,9 @@
@ApiModelProperty(value = "原价")
private BigDecimal originalPrice;
+ @ApiModelProperty(value = "积分价格")
+ private String staticPropPrice;
+
@ApiModelProperty(value = "现价")
private BigDecimal presentPrice;
diff --git a/src/main/resources/mapper/modules/MallGoodsMapper.xml b/src/main/resources/mapper/modules/MallGoodsMapper.xml
index 0535fd5..2203099 100644
--- a/src/main/resources/mapper/modules/MallGoodsMapper.xml
+++ b/src/main/resources/mapper/modules/MallGoodsMapper.xml
@@ -42,6 +42,7 @@
<result property="stock" column="sku_stock" />
<result property="skuVolume" column="sku_volume" />
<result property="originalPrice" column="sku_original_price" />
+ <result property="staticPropPrice" column="sku_static_prop_price" />
<result property="presentPrice" column="sku_present_price" />
<result property="styleId" column="sku_style_id"/>
<result property="goodsId" column="sku_goods_id" />
@@ -72,6 +73,7 @@
c.style_id sku_style_id,
c.goods_weight sku_goods_weight,
c.sample sample,
+ c.original_price*a.static_prop sku_static_prop_price,
c.level_one_price sku_level_one_price,
c.level_two_price sku_level_two_price,
c.level_three_price sku_level_three_price,
--
Gitblit v1.9.1