fix(member): 修正会员累计订单统计

Administrator

2025-05-19 61a8a1b57718b83b6f8ac09e817fabf09e96fdc0

fix(member): 修正会员累计订单统计

- 将数据源从 mall_achieve_record 表更改为 mall_order_info 表
- 添加订单状态为 4 的条件，确保只统计已完成的订单

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

@@ -512,9 +512,10 @@
                SELECT
                count(c.id)
                FROM
                mall_achieve_record c
                mall_order_info c
                WHERE
                a.id = c.member_id
                    and c.status = 4
                ),
                0
            ) orderCnt,
@@ -523,9 +524,10 @@
                SELECT
                sum(b.amount)
                FROM
                mall_achieve_record b
                mall_order_info b
                WHERE
                a.id = b.member_id
                    and b.status = 4
                ),
                0
            ) amount