feat(mall): 新增订单项的积分金额和积分价格字段- 在 MallOrderInfoMapper.xml 中添加了 item_score_am...

Administrator

2025-05-15 535c81a311bcd54b7ef5aa3f02b3cddc19b854d1

feat(mall): 新增订单项的积分金额和积分价格字段- 在 MallOrderInfoMapper.xml 中添加了 item_score_amount 和 item_score_price 字段的映射
- 在 MallOrderItem 实体类中添加了 itemScorePrice 字段
- 更新了 selectNewApiOrderListInPage 查询，加入了积分金额和积分价格的计算

 src/main/java/cc/mrbird/febs/mall/entity/MallOrderItem.java

@@ -64,4 +64,7 @@

    @TableField(exist = false)
    private BigDecimal itemScoreAmount;

    @TableField(exist = false)
    private BigDecimal itemScorePrice;
}

 src/main/resources/mapper/modules/MallOrderInfoMapper.xml

@@ -397,6 +397,9 @@
            <result property="goodsId" column="goods_id" />
            <result property="skuId" column="sku_id" />
            <result property="goodsName" column="goods_name" />
            <result property="itemScoreAmount" column="item_score_amount" />
            <result property="itemScorePrice" column="item_score_price" />
            <result property="goodsName" column="goods_name" />
            <result property="styleName" column="style_name" />
            <result property="skuName" column="sku_name" />
            <result property="skuImage" column="sku_image" />
@@ -412,11 +415,16 @@

    <select id="selectNewApiOrderListInPage" resultMap="NewOrderInfoMap">
        select
        a.*
        ,express.express_no
        a.* ,
        b.* ,
        b.score_amount as item_score_amount ,
        FLOOR(b.original_price * d.static_prop) as item_score_price ,
               express.express_no
        from mall_order_info a
            left join mall_express_info express on a.id=express.order_id
            left join mall_order_item b on a.id=b.order_id
            left join mall_goods_sku c on c.id=b.sku_id
            left join mall_goods d on d.id=b.goods_id
        <where>
            a.del_flag=2
            <if test="record.memberId != null">