{echo:JS::import("form")}
{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']);} {/query}
货号商品名规格价格数量小计
{$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']))}