fix
Helius
2021-12-20 9969769cd09e0f8046feefa18efebb7951baa936
fix
2 files modified
4 ■■■■ changed files
gc-order/src/main/java/com/xzx/gc/order/vo/JhyOrderListVo.java 3 ●●●●● patch | view | raw | blame | history
gc-order/src/main/resources/mapper/order/JhyOrderMapper.xml 1 ●●●● patch | view | raw | blame | history
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