{query:name=doc_invoice as od fields=od.*,ex.name as exname join=left join express_company as ex on od.express_company_id eq ex.id where=od.id eq $id /}
{set:$invoice = $items[0]; $area_ids=array($invoice['province'],$invoice['city'],$invoice['county']);$area_ids = implode(',',$area_ids);$areas=array();}
{query:name=area where=id in ($area_ids)}
{set:$areas[$item['id']]=$item['name']}
{/query}
收货人信息:
订单编号: | {$invoice['order_no']} | 发货单号: | {$invoice['invoice_no']} |
物流公司: | {$invoice['exname']} | 物流单号: | {$invoice['express_no']} |
收货人: | {$invoice['accept_name']} | 联系手机: | {$invoice['mobile']} |
联系电话: | {$invoice['phone']} | 邮编: | {$invoice['zip']} |
发货时间: | {$invoice['create_time']} | 发货人: | {$invoice['admin']} |
收货地址: | {$areas[$invoice['province']]},{$areas[$invoice['city']]},{$areas[$invoice['county']]}{$invoice['addr']} |
商品详情:
货号 | 商品名 | 规格 | 价格 | 数量 | 小计 |
{query:name=doc_invoice as di fields=go.name,pr.pro_no,od.spec,od.goods_price,od.goods_nums join= left join order_goods as od on od.order_id eq di.order_id left join products as pr on od.product_id eq pr.id left join goods as go on od.goods_id eq go.id where=di.id eq $id}
{set:$spec = unserialize($item['spec']);}
{$item['pro_no']} | {$item['name']} |
{if:is_array($spec)}
{list:items=$spec item=$ite }
{$ite['name']}:{$ite['value'][2]}
{/list}
{/if}
| {$item['goods_price']} | {$item['goods_nums']} | {echo:sprintf("%.2f",($item['goods_price']*$item['goods_nums']))} |
{/query}