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
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
|
<?
require("inc/configure.php");
require("inc/global.php");
require("inc/checklogin.php");
?>
<?php
$quotationno = $_GET['quotationno'];
$sql = "SELECT
a.quotationno, a.custid, a.custno
, a.custnameeng, a.telno, a.faxno
, a.email, b.username, a.orderdate
, a.billaddress, a.discount, paymentmethod
, paymentterm, sum(c.amount)-a.discount as totalamount
, a.status, a.attn
, licno, modelno, chassisno, caryear
from OM_QUOTATION_HDR a
, SYS_USER b
, OM_QUOTATION_DTL c
, SYS_PAYMENTMETHOD d
, SYS_PAYMENTTERM e
where a.salesid = b.userid
and a.quotationno = c.quotationno
and a.quotationno = $quotationno
and a.paymentmethodid = d.paymentmethodid
and a.paymenttermid = e.paymenttermid
and salesman = 1
group by
a.quotationno, a.custid, a.custno
, a.custnameeng, a.telno, a.faxno
, a.orderdate, b.username, a.discount
, paymentmethod, paymentterm, a.status
, a.attn";
$result = mysql_query($sql);
if ($row = mysql_fetch_array($result,MYSQL_ASSOC))
{
$custno = $row{'custno'};
$catid = $row{'catid'};
$custnameeng = $row{'custnameeng'};
$telno = $row{'telno'};
$faxno = $row{'faxno'};
$email = $row{'email'};
$salesman = $row{'username'};
$orderdate = $row{'orderdate'};
$totalamount = $row{'totalamount'};
$billaddress = $row{'billaddress'};
$attn = $row{'attn'};
$paymentmethodid = $row{'paymentmethodid'};
$paymenttermid = $row{'paymenttermid'};
$headerdiscount = $row{'discount'};
$deliverymethod = $row{'deliverymethod'};
$status = $row{'status'};
$paymentmethod = $row{'paymentmethod'};
$paymentterm = $row{'paymentterm'};
$licno = $row{'licno'};
$modelno = $row{'modelno'};
$chassisno = $row{'chassisno'};
$caryear = $row{'caryear'};
}
?>
<?php
//header("Content-Type: application/vnd.ms-excel");
//header("Expires: 0");
//header("Cache-Control: must-revalidate, post-check=0, pre-check=0");
?>
<html>
<head>
<title></title>
<meta http-equiv="Content-Language" content="big5">
<meta http-equiv="Content-Type" content="text/html; charset=big5">
</head>
<body>
<table width="840" border="0" cellpadding="1" cellspacing="2">
<tr><td bgcolor="#ffffff" colspan="3" align="center">駿 興 汽 車 (香 港) 有 限 公 司</td></tr>
<tr><td bgcolor="#ffffff" colspan="3" align="center">Chun Hing Motors (HK) Limited</td></tr>
<tr><td bgcolor="#ffffff" colspan="3" align="center">香港九龍觀塘偉業街 154號地下 154 Wai Yip Street, G/F., Kwun Tong, Kowloon HK</td></tr>
<tr><td bgcolor="#ffffff" colspan="3" align="center">電話：(852) 2950 4808 傳真：(852) 2950 4218</td></tr>
<tr><td bgcolor="#ffffff" colspan="3" align="center">電郵：chunhingmotors@netvigator.com</td></tr>
<tr><td width="250"></td><td bgcolor="#ffffff" rowspan="2" align="center">發 INVOICE 票</td><td bgcolor="#ffffff" colspan="2">No.</td></tr>
<tr><td width="250"></td><td width="250" bgcolor="#ffffff">日期 Date:</td></tr>
</table>
<table width="840" border="0" cellpadding="1" cellspacing="2" bgcolor="#000000">
<tr><td bgcolor="#ffffff" colspan="2" height="30">客戶資料 Customer detail</td><td bgcolor="#ffffff" colspan="5">車輛資料 Vehicle Data</td></tr>
<tr><td bgcolor="#ffffff" width="100">姓名 Name :</td>
<td bgcolor="#ffffff" width="240"></td>
<td bgcolor="#ffffff" width="100">車牌 Lic No. :</td>
<td bgcolor="#ffffff" colspan="4"></td></tr>
<tr><td bgcolor="#ffffff">地址 Addrs :</td><td bgcolor="#ffffff"></td><td bgcolor="#ffffff">型號 Model :</td><td bgcolor="#ffffff" colspan="4"></td></tr>
<tr><td bgcolor="#ffffff">電話 Tel :</td><td bgcolor="#ffffff"></td><td bgcolor="#ffffff">車身 Chas No. :</td><td bgcolor="#ffffff" colspan="4"></td></tr>
<tr><td bgcolor="#ffffff">傳真 Fax :</td><td bgcolor="#ffffff"></td><td bgcolor="#ffffff">里數 Mileage :</td><td bgcolor="#ffffff" colspan="4"></td></tr>
<tr><td bgcolor="#ffffff" colspan="3" align="center" height="60">維修及更換零件項目 Service/Parts replacement item</td>
<td bgcolor="#ffffff" align="center" width="100">單價<br>Unit price</td>
<td bgcolor="#ffffff" align="center" width="100">數量<br>Qty</td>
<td bgcolor="#ffffff" align="center" width="100">折扣<br>Discount</td>
<td bgcolor="#ffffff" align="center" width="100">金額<br>Total</td>
<tr><td bgcolor="#ffffff" colspan="6" align="right" height="60">連工料 總計 Total HK$</td>
<td bgcolor="#ffffff" align="right"></td></tr>
</table>
<table width="840" border="0" cellpadding="1" cellspacing="2" bgcolor="#FFFFFF">
<tr><td width="340">For on behalf of Chun Hing Motors (HK) Ltd<br>駿興汽車 (香港) 有限公司</td>
<td width="50"></td>
<td width="200"></td>
<td width="250"></td></tr>
<tr><td colspan="4" height="50"></td></tr>
<tr><td></td>
<td></td>
<td align="right">上述維修巳查驗收妥<br>Certified service received</td>
<td></td></tr>
<tr><td height="1" bgcolor="#000000"></td>
<td></td>
<td></td>
<td height="1" bgcolor="#000000"></td></tr>
<tr><td></td>
<td></td>
<td></td>
<td align="right">簽署 Signature</td></tr>
</table>
<table>
<tr><td>付款 :</td><td>現金/支票</td></tr>
<tr><td></td><td>支票抬頭請付 駿興汽車(香港)有限公司 "Chun Hing Motors (HK) Ltd."</td></tr>
<tr><td></td><td>或直接存入 中國銀行 A/C No. 0128 73000 85124</td></tr>
</table>
</body>
</html>
|