Merge branch 'local_20221104' into huacheng_test
| | |
| | | private Integer status; |
| | | |
| | | @ApiModelProperty(value = "自提点id") |
| | | private Integer pointId; |
| | | private Long pointId; |
| | | |
| | | @ApiModelProperty(value = "商户id") |
| | | private Long storeId; |
| | |
| | | resultType="com.panzhihua.common.model.vos.community.convenient.ConvenientElevatingPointVO"> |
| | | SELECT ccep.*,count(csfo.id) delivery_order_num ,sum(og.amount) delivery_goods_num |
| | | FROM com_convenient_elevating_point ccep |
| | | LEFT JOIN com_shop_flower_order ON ccep.id = csfo.point_id |
| | | LEFT JOIN com_shop_flower_order csfo ON ccep.id = csfo.point_id |
| | | LEFT JOIN com_shop_flower_order_goods og ON og.order_id = csfo.id |
| | | WHERE |
| | | csfo.`status` = 1 |