add:-商户列表需要增加下单次数统计(已退款、已取消、待付款的不统计在内）

cloudroam

2024-11-14 53b823e2b1444e33f359fba79f8ff1e078253891

add:-商户列表需要增加下单次数统计(已退款、已取消、待付款的不统计在内）

 src/main/java/com/mzl/flower/dto/response/customer/CustomerDTO.java

@@ -58,4 +58,6 @@
    private Boolean isEnabled;

    private UserGrowthRecordDTO userGrowthRecord;

    private Integer orderNum;
}

 src/main/resources/mapper/customer/CustomerMapper.xml

@@ -9,7 +9,8 @@
            c.*,
            p.name as partnerName,
            u.nick_name,
            u.tel
            u.tel,
            (select count(o.id) from t_order o where o.create_by = c.user_id  and o.deleted=0 and o.status_backend not in ('PENDING','CANCEL','REFUND')) as orderNum
        FROM
            t_customer_info c
                LEFT JOIN t_user u ON c.user_id = u.id left join t_partner_info p on c.partner_id = p.id where c.deleted = 0