feat(mall): 添加商品积分价格字段

Administrator

2025-05-14 b3810c8cb1fb0b9b33cd42fcabd0cf30bacab37d

feat(mall): 添加商品积分价格字段

- 在 GoodsDetailsSkuVo 和 MallGoodsSku 类中添加 staticPropPrice 字段，用于表示积分价格
- 在 MallGoodsMapper.xml 中添加对应的数据库查询结果映射
- 此修改为商品详情页面展示积分价格提供数据支持

 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;
}

 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;


 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,