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