parent: 9fe8f2b9 | patch | commit | ignore whitespace
xiaoyong931011
2021-07-16 860fbaf9195a3169020e706ce7f8655778a8199f 
202107016
1 files modified
4 ■■■■■ changed files
gc-user/src/main/resources/mapper/user/AccountMapper.xml 4 ●●●●● patch | view | raw | blame | history 
 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