
- 帖子
- 18
- 积分
- 132
- 体力
- 66 点
- 金币
- 56
- 威望
- 1
- 来自
- taiwan
|
8楼
发表于 2013-3-11 17:43
| 只看该作者
調用發貨單的function:
/**
* 调用发货单查询
*
* @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;
}
=================
模版賦值的語法:
$smarty->assign('invoice_list', index_get_invoice_query()); // 发货查询
======================================================
把這2個東西搬到你想顯示的頁面去,再想辦法開發唄 |
|