货号 | 商品名 | 规格 | 价格 | 数量 | 小计 |
{query:name=doc_refund as dr fields=go.name,pr.pro_no,od.spec,od.goods_price,od.goods_nums,dr.id join= left join order_goods as od on dr.order_id eq od.order_id 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=dr.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']} | {echo:sprintf("%.2f",($item['goods_price']*$item['goods_nums']))} |
{/query}
{query:name=doc_refund as dr fields=dr.*,od.status,od.delivery_status,us.name as uname, ma.name as mname,od.real_amount,od.real_freight,od.handling_fee,od.taxes,od.adjust_amount,od.order_amount,od.order_amount,od.discount_amount join=left join user as us on dr.user_id eq us.id left join manager as ma on dr.admin_id eq ma.id left join order as od on dr.order_no eq od.order_no where=dr.id eq $id /}
{set:$item = $items[0];}