xiaoyong931011
2022-08-18 a5a931a2291c23588ee741f177efc1366175491c
20220810
1 files modified
8 ■■■■ changed files
src/main/resources/mapper/modules/MallOrderInfoMapper.xml 8 ●●●● patch | view | raw | blame | history
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">