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