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