Merge branch 'local_20221104' into huacheng_test
| | |
| | | sr.pay_time, sr.delivery_type, sr.delivery_status, sr.logistics_company, |
| | | sr.logistics_no, sr.create_at, uad.name as receiver_name, uad.phone as receiver_phone, |
| | | group_concat(og.goods_name) |
| | | as goodsName, ss.name as store_name ,ccep.adress |
| | | as goodsName, ss.name as store_name ,ccep.address |
| | | FROM com_shop_flower_order sr LEFT JOIN com_shop_flower_order_goods og ON sr.id = og.order_id |
| | | LEFT JOIN com_shop_flower_goods_attr ga ON og.goods_attr_id = ga.id |
| | | LEFT JOIN sys_user su ON sr.user_id = su.user_id |