| | |
|---|
| | | " sr.wx_tarde_no, sr.status, sr.pay_status, sr.receiver_id, \n" + |
|---|
| | | " sr.total_amount, sr.discount_amount, sr.pay_amount, sr.pay_type, \n" + |
|---|
| | | " sr.pay_time, sr.delivery_type, sr.delivery_status, sr.logistics_company, \n" + |
|---|
| | | " sr.logistics_no, sr.create_at, uad.name as receiver_name, uad.phone as receiver_phone, group_concat(og.goods_name) as goodsName \n" + |
|---|
| | | " 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 \n" + |
|---|
| | | " FROM com_shop_order sr LEFT JOIN com_shop_order_goods og ON sr.id = og.order_id \n" + |
|---|
| | | " LEFT JOIN com_shop_goods_attr ga ON og.goods_attr_id = ga.id \n" + |
|---|
| | | " LEFT JOIN sys_user su ON sr.user_id = su.user_id \n" + |
|---|
