Administrator
2025-05-15 53fb465627a1c82648259d9645a4ddc4c2612bae
fix(MallOrderInfoMapper):修复订单积分计算错误

-将 b.original_price 修改为 c.original_price,以修正积分价格计算公式
1 files modified
2 ■■■ changed files
src/main/resources/mapper/modules/MallOrderInfoMapper.xml 2 ●●● patch | view | raw | blame | history
src/main/resources/mapper/modules/MallOrderInfoMapper.xml
@@ -418,7 +418,7 @@
        a.* ,
        b.* ,
        b.score_amount as item_score_amount ,
        FLOOR(b.original_price * d.static_prop) as item_score_price ,
        FLOOR(c.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