ecshop发货查询中加入收货人收货地址发货时间配送方式

$sql = 'SELECT o.order_sn, o.invoice_no, s.shipping_code FROM ' . $GLOBALS['ecs']->table('order_info') . ' AS o' . 

$sql = 'SELECT o.order_sn, o.invoice_no, s.shipping_code,o.consignee, from_unixtime(o.shipping_time,\'%Y-%m-%d %H:%i:%s\') as shippingtime,o.shipping_name, r.region_name AS province FROM ' . $GLOBALS['ecs']->table('order_info') . ' AS o' . 

' LEFT JOIN ' . $GLOBALS['ecs']->table('shipping') . ' AS s ON s.shipping_id = o.shipping_id' .

' LEFT JOIN ' . $GLOBALS['ecs']->table('region') . ' AS r ON r.region_id = o.province' .

{$lang.order_number} {$invoice.order_sn}<br /> {$lang.consignment} {$invoice.invoice_no}<br /> 

<br>收货人：{$invoice.consignee} <br>收货地址：{$invoice.province} <br>发货时间：{$invoice.shippingtime} <br>

$all[$key]['consignee']=sub_str($row['consignee'], 1, false).'**'; 

$all[$key]['consignee']=sub_str($row['consignee'], 1, false).'**';