202107016

xiaoyong931011

2021-07-16 860fbaf9195a3169020e706ce7f8655778a8199f

202107016

 gc-user/src/main/resources/mapper/user/AccountMapper.xml

@@ -252,8 +252,8 @@
            a.order_no orderNo,
            a.score scoreReward,
            a.amount amountReward,
            a.nick_name nickname,
            a.mobile_phone phone,
            c.nick_name nickname,
            c.mobile_phone phone,
            (select sum(score) from xzx_jhy_order_items where b.id = order_id) score,
            (select sum(score/ 40) from xzx_jhy_order_items where b.id = order_id) amount
        FROM