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