From 2f2006691270d2788e32ca3eeae5a3b2faed0fc1 Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Thu, 15 Jul 2021 17:29:16 +0800 Subject: [PATCH] 202107015 --- gc-user/src/main/java/com/xzx/gc/user/service/DistribService.java | 5 +++++ gc-user/src/main/resources/mapper/user/AccountMapper.xml | 10 +++++----- 2 files changed, 10 insertions(+), 5 deletions(-) diff --git a/gc-user/src/main/java/com/xzx/gc/user/service/DistribService.java b/gc-user/src/main/java/com/xzx/gc/user/service/DistribService.java index 4767b5a..b9a3738 100644 --- a/gc-user/src/main/java/com/xzx/gc/user/service/DistribService.java +++ b/gc-user/src/main/java/com/xzx/gc/user/service/DistribService.java @@ -262,6 +262,11 @@ public ViewDistribInfoVo viewDistribInfo(String id) { //获取团长基本信息 + ViewDistribInfoVo viewDistribInfoVo = accountMapper.selectDistribByAccountId(id); + if(StrUtil.isNotEmpty(viewDistribInfoVo.getNickname())){ + String decode = StringUtils.decode(viewDistribInfoVo.getNickname()); + viewDistribInfoVo.setNickname(decode); + } return accountMapper.selectDistribByAccountId(id); } diff --git a/gc-user/src/main/resources/mapper/user/AccountMapper.xml b/gc-user/src/main/resources/mapper/user/AccountMapper.xml index 368208f..03dadbb 100644 --- a/gc-user/src/main/resources/mapper/user/AccountMapper.xml +++ b/gc-user/src/main/resources/mapper/user/AccountMapper.xml @@ -240,13 +240,13 @@ a.order_no orderNo, a.score scoreReward, a.amount amountReward, - sum(c.score) score, - sum(c.score/40) amount + (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 xzx_user_head_details a - LEFT JOIN xzx_jhy_order b on a.order_no = b.order_no - LEFT JOIN xzx_jhy_order_items c on b.id=c.order_id - where a.head_user_id = #{userId} + LEFT JOIN xzx_jhy_order b ON a.order_no = b.order_no + WHERE + a.head_user_id = #{userId} </select> -- Gitblit v1.9.1