{query:name=order as od fields=od.*,cu.phone as uphone,us.name as uname,ex.name as exname join=left join customer as cu on od.user_id eq cu.user_id left join user as us on od.user_id eq us.id left join express as ex on od.express eq ex.express_company_id where= od.id eq $id/}
{set:$order = $items[0];}
客户:{$order['uname']} 电话:{$order['phone']}
订单号:{$order['order_no']}
订购日期:{$order['create_time']}
序号
商品货号
商品名称
规格
单价
数量
小计
{query:name=order_goods as od fields=go.name,pr.pro_no,pr.spec,od.goods_price,od.goods_nums join= 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=order_id eq $id}
{set:$spec = unserialize($item['spec']);}