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