ECSHOP2.72 前台调用 定单号，及收货人，快递号

原来的index_get_invoice_query函数调用时没有调用收货人和收货的省及城市，稍微做一下改进就可以实现在首页订单调用中显示收货人及收货的地区

把index.php中的

/**
* 调用发货单查询
*
* @access private
* @return array
*/
function index_get_invoice_query()
{
$sql = 'SELECT o.order_sn, o.invoice_no, s.shipping_code FROM ' . $GLOBALS['ecs']->table('order_info') . ' AS o' .
' LEFT JOIN ' . $GLOBALS['ecs']->table('shipping') . ' AS s ON s.shipping_id = o.shipping_id' .
" WHERE invoice_no > '' AND shipping_status = " . SS_SHIPPED .
' ORDER BY shipping_time DESC LIMIT 10';
$all = $GLOBALS['db']->getAll($sql);

foreach ($all AS $key => $row)
{
$plugin = ROOT_PATH . 'includes/modules/shipping/' . $row['shipping_code'] . '.php';

if (file_exists($plugin))
{
include_once($plugin);

$shipping = new $row['shipping_code'];
$all[$key]['invoice_no'] = $shipping->query((string)$row['invoice_no']);
}
}

clearstatcache();

return $all;
}

改成:

/**
* 调用发货单查询
*
* @access private
* @return array
*/
function index_get_invoice_query()
{
$sql = 'SELECT o.order_sn, o.consignee, o.invoice_no, s.shipping_code,r1.region_name  as provice-name,r2.region_name as city_name 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 r1 ON r1.region_id = o.province' .
' LEFT JOIN ' . $GLOBALS['ecs']->table('region') . ' AS r2 ON r2.region_id = o.city' .
" WHERE invoice_no > '' AND shipping_status = " . SS_SHIPPED .
' ORDER BY shipping_time DESC LIMIT 10';
$all = $GLOBALS['db']->getAll($sql);

foreach ($all AS $key => $row)
{
$plugin = ROOT_PATH . 'includes/modules/shipping/' . $row['shipping_code'] . '.php';

if (file_exists($plugin))
{
include_once($plugin);

$shipping = new $row['shipping_code'];
$all[$key]['invoice_no'] = $shipping->query((string)$row['invoice_no']);
}
}

clearstatcache();

return $all;
}

这样就可以在invoice_list.lbi中增加显示收货人及收货地址

转载于:https://www.cnblogs.com/wangblognet/archive/2012/12/12/2814831.html