gc-order/src/main/resources/mapper/order/JhyOrderMapper.xml | ●●●●● 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