print_picking.html
2.82 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
<style media="print" type="text/css">.noprint{display:none}</style>
<link rel="stylesheet" type="text/css" media="screen,print" href="{url:@static/css/print.css}" />
<div class="panel">
{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];}
<table style="border-top:none;">
<tr>
<td ><img src="{url:@static/images/logo.png}" /></td>
<td valign="bottom" align="rgiht" width="240"><p>客户:{$order['uname']} <span class="ml_20">电话:{$order['phone']}</span></p></td>
</tr>
</table>
<table >
<tr><td><b>订单号:{$order['order_no']}</b></td><td align="right" width="240px"><b>订购日期:{$order['create_time']}</b></td></tr>
</table>
<table style="border:none;">
<tr><th width="40">序号</th><th width="100">商品货号</th><th width="200">商品名称</th><th width="200">规格</th><th width="80">单价</th><th width="60">数量</th><th width="80">小计</th></tr>
{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']);}
<tr><td>{echo:($key+1)}</td><td>{$item['pro_no']}</td><td>{$item['name']}</td><td>
{if:is_array($spec)}
{list:items=$spec item=$ite }
{$ite['name']}:{$ite['value'][2]}
{/list}
{/if}
</td><td>{$item['goods_price']}</td><td>{$item['goods_nums']}</td><td class="golden">{echo:sprintf("%.2f",($item['goods_price']*$item['goods_nums']))}</td></tr>
{/query}
</table>
{set:$ids = "($order[province],$order[city],$order[county])";$areas=array();}
{query:name=area where= id in $ids}
{set:$area[$item['id']] = $item['name']}
{/query}
<table >
<tr>
<td>订单附言:{$order['user_remark']}</td>
<td width="400">
<ul>
<li><span class="caption">收货人:</span>{$order['accept_name']}</li>
<li><span class="caption">地址:</span>{$area[$order['province']]},{$area[$order['city']]},{$area[$order['county']]},{$order['addr']}</li>
<li><span class="caption">邮编:</span>{$order['zip']}</li>
<li><span class="caption">手机:</span>{$order['mobile']}</li>
<li><span class="caption">配送方式:</span>{$order['exname']}</li>
</ul></td>
</tr>
</table>
<table>
<tr>
<td align="left"><img src="{url:/ajax/test?code=$order[order_no]}"/></td>
<td align="right">Powered By tinyrise.com</td>
</tr>
</table>
<div><input class="button noprint" type="submit" onclick="window.print();" value="打印" /></div>
</div>