問(wèn)題描述:
默認(rèn)的ECSHOP系統(tǒng),首頁(yè)發(fā)貨查詢(xún)只顯示訂單號(hào)和發(fā)貨單號(hào),如何將送貨地址中的“省份+城市+區(qū)縣” 都顯示出來(lái)呢?
下面是在ECSHOP 2.7.2 官方默認(rèn)模板基礎(chǔ)上的修改教程:
1、
修改 index.php 文件
將
$sql = 'SELECT o.order_sn, o.invoice_no, s.shipping_code FROM ' . $GLOBALS['ecs']->table('order_info') . ' AS o' .
修改為
$sql = 'SELECT o.province,o.city,o.district,o.order_sn, o.invoice_no, s.shipping_code FROM ' . $GLOBALS['ecs']->table('order_info') . ' AS o' .
2、
繼續(xù)修改index.php 文件
找到
$all[$key]['invoice_no'] = $shipping->query((string)$row['invoice_no']);
在它下面增加幾行代碼
$all[$key]['province']=$GLOBALS['db']->getOne("select region_name from ".$GLOBALS['ecs']->table('region')." where region_id=".$row['province']);
$all[$key]['city']=$GLOBALS['db']->getOne("select region_name from ".$GLOBALS['ecs']->table('region')." where region_id=".$row['city']);
$all[$key]['district']=$GLOBALS['db']->getOne("select region_name from ".$GLOBALS['ecs']->table('region')." where region_id=".$row['district']);
3、修改 /themes/default/library/invoice_query.lbi 文件
找到
{$lang.order_number} {$invoice.order_sn}<br />
在它下面增加一行模板標(biāo)簽代碼
{$invoice.province}-{$invoice.city}-{$invoice.district}<br />
到后臺(tái)清除緩存后,刷新首頁(yè)
新聞熱點(diǎn)
疑難解答
圖片精選