{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']);} {/query}
序号商品货号商品名称规格单价数量小计
{echo:($key+1)}{$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']))}
{set:$ids = "($order[province],$order[city],$order[county])";$areas=array();} {query:name=area where= id in $ids} {set:$area[$item['id']] = $item['name']} {/query}
订单附言:{$order['user_remark']}
  • 收货人:{$order['accept_name']}
  • 地址:{$area[$order['province']]},{$area[$order['city']]},{$area[$order['county']]},{$order['addr']}
  • 邮编:{$order['zip']}
  • 手机:{$order['mobile']}
  • 配送方式:{$order['exname']}
Powered By tinyrise.com