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