ECSHOP如何实现发货滚动显示货人名称_配送方式名称_配送单号及发货日期的方法.doc

ECSHOP如何实现发货滚动显示货人名称、配送方式名称、配送单号及发货日期的方法 秦皇岛商之翼旗下ECSHOP开发中心（68） ECSHOP如何实现发货滚动显示发货人名称、配送方式名称和配送单号及发货日期的方法。 下来说下具体的操作： 修改index.php 找到代码 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; 修改成 function index_get_invoice_query() { $sql = SELECT o.order_sn, o.invoice_no, s.shipping_code,o.consignee, from_unixtime(o.shipping_time,\%Y-%m-%d\) as shippingtime,o.shipping_name, r.region_name AS province FROM . $GLOBALS[ecs]-table(order_info) . AS o . LEFT JOIN . $GLOBALS[ecs]-table(region) . AS r ON r.region_id = vince . 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; 再打开ecshop模板 invoice_query.lbi 文件，删除里面的所有文件，用以下代码代替 meta http-equiv=Content-Type content=text/html; charset=utf-8 !--{if $invoice_list}-- div class=fhgg h2发货通知/h2 div id=mq class=scrollText onmouseover=iScrollAmount=0 onmouseout=iScrollAmount=1 div class=mod3con !-- 发货单查询{foreach name=invoice from=$invoice_list item=invoice} -- div class=vote li class=f2收货人：span {$invoice.consignee}/span/li li class=f2{$lang.order_number}：span{$invoice.order_sn}/span/li li class=f2 kdbh{$invoice.shipping_name}：span{$invoice.invoice_no}/span/li li class=f2发货时间：span{$invoice.shippingtime}/span/li /div !-- 结束发货单查询{/foreach}-- /div/div/div script type=text/javascriptdivheight(invoice);/script !-- {/if} -- script type=text/javascript var oMarquee = document.getElementById(mq); //滚动对象 var iLineHeight = 84; //单行高度，像素 var iLineCount = 10; //实际行数 var iScrollAmount = 1; //每次滚动高度，像素 func