商品信息:
| 货号 | 商品名 | 规格 | 价格 | 数量 | 商品促销 | 小计 |
{query:name=order_goods as od fields=go.img,go.name,pr.pro_no,od.spec,od.goods_price,od.goods_nums,od.prom_goods 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']);}
;}) | {$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']} | {set:$prom=unserialize($item['prom_goods']);}{$prom['prom']['name']} | {echo:sprintf("%.2f",($item['goods_price']*$item['goods_nums']))} |
{/query}
购买人信息:
{query:name=order as o fields=cu.real_name,us.name,us.email,cu.phone,cu.mobile,cu.addr join=left join customer as cu on o.user_id eq cu.user_id left join user as us on o.user_id eq us.id where=o.id eq $id}
用户名: | {$item['name']} | 姓名: | {$item['real_name']} |
手机: | {$item['mobile']} | 电话: | {$item['phone']} |
邮箱: | {$item['email']} | 地址: | {$item['addr']} |
{/query}
{query:name=order as od fields=od.*,ex.name as exname,py.pay_name as payname join=left join express as ex on od.express eq ex.express_company_id left join payment as py on od.payment eq py.id where=od.id eq $id}
{set:$amount = $item['order_amount'];}
订单信息:
订单编号: | {$item['order_no']} | 下单时间: | {$item['create_time']} |
支付方式: | {$item['payname']} | 支付手续费: | {$item['handling_fee']} |
配送方式: | {$item['exname']} | 配送费用: | {$item['payable_freight']} |
实际配送费用: | {$item['real_freight']} | 代金券: | {if:$item['voucher_id']}{set:$voucher=unserialize($item['voucher'])}{$voucher['value']}{else:}-{/if} |
应付商品总金额: | {$item['payable_amount']} | 实付商品总金额: | {$item['real_amount']} |
{if:$item['is_invoice']==1}
{set:$invoice = explode(':',$item['invoice_title'])}
发票类型: | {if:$invoice[0]==1}单位{else:}个人{/if} | 发票抬头: | {$invoice[1]} |
{/if}
发票税金: | {$item['taxes']} | 活动优惠金额: | {$item['discount_amount']} |
原订单总金额: | {echo:sprintf("%.2f",$amount)} 注:记订单在未调价之前的总金额 |
订单折扣或涨价: | {$item['adjust_amount']|0} |
调整后订单总金额: | {$item['order_amount']} 注:总金额不会小于0元 |
调价原因: | {$item['adjust_note']} |
用户备注: | {$item['user_remark']} |
管理人员备注: | {$item['admin_remark']} |
收货人信息:
{/query}