gc-order/src/main/java/com/xzx/gc/order/vo/JhyOrderListVo.java
@@ -81,4 +81,7 @@ @ApiModelProperty(value = "回收/kg") private String recycleKg; @ApiModelProperty(value = "用户下单数量") private Integer userOrderCnt; } gc-order/src/main/resources/mapper/order/JhyOrderMapper.xml
@@ -25,6 +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 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