From a388fa446b4bbfed0250dcdcbe32ac250b8b19c5 Mon Sep 17 00:00:00 2001
From: KKSU <15274802129@163.com>
Date: Mon, 18 Nov 2024 16:04:08 +0800
Subject: [PATCH] fix(mall): 修复商城会员查询的 SQL 语句

---
 src/main/resources/mapper/modules/MallMemberMapper.xml |    4 +++-
 1 files changed, 3 insertions(+), 1 deletions(-)

diff --git a/src/main/resources/mapper/modules/MallMemberMapper.xml b/src/main/resources/mapper/modules/MallMemberMapper.xml
index 405cf4f..5677764 100644
--- a/src/main/resources/mapper/modules/MallMemberMapper.xml
+++ b/src/main/resources/mapper/modules/MallMemberMapper.xml
@@ -39,7 +39,9 @@
                 </if>
             </if>
         </where>
-        GROUP BY m.id order by m.CREATED_TIME desc
+        GROUP BY
+        m.id, a.NAME, c.balance, c.score, c.prize_score, c.commission, vipConfig.NAME
+        order by m.CREATED_TIME desc
     </select>
 
     <select id="getMallMemberInfoById" resultType="cc.mrbird.febs.mall.vo.MallMemberVo">

--
Gitblit v1.9.1