From 4f60ffbbc73de024fd11146a7c73698044b2504b Mon Sep 17 00:00:00 2001
From: xiaoyong931011 <15274802129@163.com>
Date: Fri, 16 Jul 2021 10:13:33 +0800
Subject: [PATCH] 202107016

---
 gc-user/src/main/java/com/xzx/gc/user/vo/UserHeadInfoVo.java |    3 +++
 gc-user/src/main/resources/mapper/user/AccountMapper.xml     |    3 ++-
 2 files changed, 5 insertions(+), 1 deletions(-)

diff --git a/gc-user/src/main/java/com/xzx/gc/user/vo/UserHeadInfoVo.java b/gc-user/src/main/java/com/xzx/gc/user/vo/UserHeadInfoVo.java
index fb13e47..5342f80 100644
--- a/gc-user/src/main/java/com/xzx/gc/user/vo/UserHeadInfoVo.java
+++ b/gc-user/src/main/java/com/xzx/gc/user/vo/UserHeadInfoVo.java
@@ -22,6 +22,9 @@
     @ApiModelProperty(value="累计金额")
     private BigDecimal amount;
 
+    @ApiModelProperty(value="累计积分")
+    private BigDecimal score;
+
     @ApiModelProperty(value="累计单数")
     private Integer orderCnt;
 
diff --git a/gc-user/src/main/resources/mapper/user/AccountMapper.xml b/gc-user/src/main/resources/mapper/user/AccountMapper.xml
index 03dadbb..980ac42 100644
--- a/gc-user/src/main/resources/mapper/user/AccountMapper.xml
+++ b/gc-user/src/main/resources/mapper/user/AccountMapper.xml
@@ -227,7 +227,8 @@
             b.mobile_phone phone,
             a.CREATED_TIME createTime,
             (select IFNULL(count(1), 0) from xzx_user_head_details where user_id = a.user_id and head_user_id = #{id}) orderCnt,
-            (select IFNULL(sum(amount), 0) from xzx_user_head_details where user_id = a.user_id and head_user_id = #{id}) amount
+            (select IFNULL(sum(amount), 0) from xzx_user_head_details where user_id = a.user_id and head_user_id = #{id}) amount,
+            (select IFNULL(sum(score), 0) from xzx_user_head_details where user_id = a.user_id and head_user_id = #{id}) score
         FROM
             xzx_user_head_relate a
                 LEFT JOIN xzx_user_info b on a.user_id = b.user_id

--
Gitblit v1.9.1