EC显示订单相关内容
CREATE TABLE `ecs_shipping_status` ( `id` INT( 5 ) NOT NULL, `shipping_status` VARCHAR( 10 ) NOT NULL , PRIMARY KEY ( `id` ) ) ENGINE = MYISAM ; INSERT INTO `ecs_shipping_status` (`id` ,`shipping_status`) VALUES ( '0', '未发货' '1', '已发货' '2', '已取消' '3', '备货中' '4', '已发货(部分商品)' );
以上代码是添加一个发货状态表,并将对应的状态添加入表中。
TRUNCATE TABLE `table_name`删除表单,建议先在本地数据库调试好,再进行网络修正。
$sql = 'SELECT o.order_sn, o.invoice_no,o.consignee,st.shipping_status, 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' . ' LEFT JOIN ' . $GLOBALS['ecs']->table('shipping_status') . ' AS st ON st.id = o.shipping_status' . " WHERE o.invoice_no > ''AND shipping_status = " . SS_SHIPPED . ORDER BY shipping_time DESC LIMIT 10";
以上代码是修正index.php中涉及sql代码,
之后再前台需要地方调用,如:
<marquee scrollamount='1' scrolldelay='3' direction= 'UP' width="98%" height="40"> <!-- 发货单查询{foreach from=$invoice_list item=invoice} --> {$invoice.order_sn} {$invoice.consignee} {$invoice.shipping_status|truncate:3:"...":true} <div class="blank"></div> <!-- 结束发货单查询{/foreach}--> </marquee>
获取收件人,订单号以及订单状态。
其中<marquee scrollamount='1' scrolldelay='3' direction= 'UP' width="98%" height="40"/>内容向上滚动,
$all[$key]['consignee']=sub_str($row['consignee'], 1, false).'**';获取的名称只显示姓,
名用**代替。