商品信息:
| 货号 | 商品名 | 规格 | 价格 | 数量 | 商品促销 | 小计 |
{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 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}
{/query}