From a5a931a2291c23588ee741f177efc1366175491c Mon Sep 17 00:00:00 2001 From: xiaoyong931011 <15274802129@163.com> Date: Thu, 18 Aug 2022 14:50:28 +0800 Subject: [PATCH] 20220810 --- src/main/resources/mapper/modules/MallOrderInfoMapper.xml | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) diff --git a/src/main/resources/mapper/modules/MallOrderInfoMapper.xml b/src/main/resources/mapper/modules/MallOrderInfoMapper.xml index 6c3c00d..1baaafd 100644 --- a/src/main/resources/mapper/modules/MallOrderInfoMapper.xml +++ b/src/main/resources/mapper/modules/MallOrderInfoMapper.xml @@ -233,13 +233,13 @@ <select id="selectMemberOrderStatusCnt" resultType="java.util.Map"> select - status, + a.status, count(1) cnt - from mall_order_info + from mall_order_info a inner join mall_order_item b on a.id=b.order_id inner join mall_team_leader c on a.take_unique_code=c.unique_code - where del_flag=2 and member_id=#{memberId} - group by status + where a.del_flag=2 and a.member_id=#{memberId} + group by a.status </select> <select id="getMallOrderDetailById" resultType="cc.mrbird.febs.mall.vo.AdminOrderDetailVo"> -- Gitblit v1.9.1