{query:name=order as od fields=od.*,cu.phone as uphone,us.name as uname 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 where= od.id eq $id/} {set:$order = $items[0];}

客户:{$order['uname']}   电话:{$order['uphone']}

订单号:{$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']))}
订单附言:{$order['user_remark']}
  • 商品价格:{$currency_symbol}{$order['payable_amount']} {$currency_unit}
  • 配送费用:{$order['real_freight']} {$currency_unit}
  • 支付手续费:{$order['handling_fee']} {$currency_unit}
  • 订单优惠:-{$order['discount_amount']} {$currency_unit}
  • {if:$order['voucher_id']} {set:$voucher= unserialize($order['voucher']);}
  • 代金券:-{$voucher['value']} {$currency_unit}
  • {/if}
  • 应付总金额:{$currency_symbol}{$order['order_amount']} {$currency_unit}
Powered By tinyrise.com