fix
Helius
2021-12-20 30b3c45471ccaa864c98706695e683d957f99e60
fix
1 files modified
2 ■■■ changed files
gc-order/src/main/resources/mapper/order/JhyOrderMapper.xml 2 ●●● patch | view | raw | blame | history
gc-order/src/main/resources/mapper/order/JhyOrderMapper.xml
@@ -25,7 +25,7 @@
                else 0 end), 0) recycleKg
            ,c.username jhyName
            ,c.mobile jhyPhone
            ,(select count(1) from xzx_jhy_order x where x.user_id=a.user_id) userOrderCnt
            ,(select count(1) from xzx_jhy_order x where x.user_id=a.user_id and x.status != 5) userOrderCnt
        from xzx_jhy_order a
        inner join xzx_jhy_order_items b on a.id=b.order_id
        left join xzx_jhy_info c on a.jhy_id=c.user_id