001.<?
002.ob_start();
003.session_start();
004.if($_SESSION["userlogin"]=="")
005.{
006.header("location:login_request.php");
007.exit();
008.}
009.
010.require_once('connect.php');
011.?>
012.
013.<head>
014.<meta http-equiv="Content-Type" content="text/html; charset=windows-874" />
015.<title>ใบเสนอราคา (Quotation)</title>
016.<link href="sty.css" rel="stylesheet" type="text/css">
017.<style type="text/css">
018.<!--
019.body {
020. background-color: #CCC;
021.}
022.-->
023.</style></head>
024.
025.<body>
026. <form name ="autoSumForm" action="quotation_add_check.php" method="post" onSubmit="return check()">
027.<table width="720" border="1" align="center" class="coll" cellpadding="0" cellspacing="0">
028.
029. <tr>
030. <td width="2169" height="493" colspan="3" align="left" valign="top">
031.
032. <SCRIPT Language="JavaScript">
033.function startCalc(){
034.interval = setInterval("calc()",1);
035.}
036.function calc(){
037.qua1 = document.autoSumForm.txtQua1.value;
038.unit1 = document.autoSumForm.txtUnit1.value;
039.qua2 = document.autoSumForm.txtQua2.value;
040.unit2 = document.autoSumForm.txtUnit2.value;
041.qua3 = document.autoSumForm.txtQua3.value;
042.unit3 = document.autoSumForm.txtUnit3.value;
043.qua4 = document.autoSumForm.txtQua4.value;
044.unit4 = document.autoSumForm.txtUnit4.value;
045.qua5 = document.autoSumForm.txtQua5.value;
046.unit5 = document.autoSumForm.txtUnit5.value;
047.qua6 = document.autoSumForm.txtQua6.value;
048.unit6 = document.autoSumForm.txtUnit6.value;
049.qua7 = document.autoSumForm.txtQua7.value;
050.unit7 = document.autoSumForm.txtUnit7.value;
051.qua8 = document.autoSumForm.txtQua8.value;
052.unit8 = document.autoSumForm.txtUnit8.value;
053.qua9 = document.autoSumForm.txtQua9.value;
054.unit9 = document.autoSumForm.txtUnit9.value;
055.qua10 = document.autoSumForm.txtQua10.value;
056.unit10 = document.autoSumForm.txtUnit10.value;
057.
058.amount1 = document.autoSumForm.txtAmount1.value = (qua1 * 1) * (unit1 * 1);
059.amount2 = document.autoSumForm.txtAmount2.value = (qua2 * 1) * (unit2 * 1);
060.amount3 = document.autoSumForm.txtAmount3.value = (qua3 * 1) * (unit3 * 1);
061.amount4 = document.autoSumForm.txtAmount4.value = (qua4 * 1) * (unit4 * 1);
062.amount5 = document.autoSumForm.txtAmount5.value = (qua5 * 1) * (unit5 * 1);
063.amount6 = document.autoSumForm.txtAmount6.value = (qua6 * 1) * (unit6 * 1);
064.amount7 = document.autoSumForm.txtAmount7.value = (qua7 * 1) * (unit7 * 1);
065.amount8 = document.autoSumForm.txtAmount8.value = (qua8 * 1) * (unit8 * 1);
066.amount9 = document.autoSumForm.txtAmount9.value = (qua9 * 1) * (unit9 * 1);
067.amount10 = document.autoSumForm.txtAmount10.value = (qua10 * 1) * (unit10 * 1);
068.
069.sum = document.autoSumForm.txtSum.value = (amount1 * 1) + (amount2 * 1) + (amount3 * 1) + (amount4 * 1) + (amount5 * 1) + (amount6 * 1) + (amount7 * 1) + (amount8 * 1) + (amount9 * 1) + (amount10 * 1);
070.
071.total = document.autoSumForm.txtTotal.value = Math.round(((sum * 1) / (1.07))*100)/100;
072.
073.vat = document.autoSumForm.txtVat.value = Math.round(((total) * (7/100))*100)/100
074.
075.
076.}
077.function stopCalc(){
078.clearInterval(interval);
079.}
080.</SCRIPT>
081.
082.
083. <table width="718" border="0" cellpadding="0" cellspacing="0">
084. <tr>
085. <td width="7" class="detail"> </td>
086. <td width="126" class="detail">เรียน (ATTN.) :</td>
087. <td width="120">
088. <input name="txtCust" type="text" id="txtCust" value="" size="20"> </td>
089. <td width="72"> </td>
090. <td width="58"> </td>
091. <td width="181" class="detail"><? echo "เลขที่ใบเสนอราคาล่าสุดคือ"; ?></td>
092. <td width="154" class="detail"><span class="subject2">:
093. <?
094. require("connect.php");
095. $sql = "select * from quotation order by id desc limit 1";
096. $dbquery = mysql_db_query($db, $sql);
097. $date_check=date("Y-m-d");
098.
099. $num_rows = mysql_num_rows($dbquery);
100.
101. $i=0;
102.while ($i < $num_rows)
103.{
104.$result = mysql_fetch_array($dbquery);
105.$id = $result[id];
106.
107.echo "$id";
108.$i++;
109.}
110.
111.?>
112. </span></td>
113. </tr>
114. <tr>
115. <td class="detail"> </td>
116. <td class="detail">ที่อยู่ (Address) :</td>
117. <td colspan="3"><textarea name="txtAddress" cols="35" id="txtAddress"></textarea></td>
118. <td class="detail">เลขที่ใบเสนอราคา(Qt.No.)</td>
119. <td class="detail">: SGM2011/
120. <input name="txtId" type="text" id="txtId" value="" size="4"></td>
121. </tr>
122. <tr>
123. <td class="detail"> </td>
124. <td class="detail">โทรศัพท์ (Tel. No.)</td>
125. <td><input name="txtTel" type="text" id="txtTel" value="" size="12"></td>
126. <td> </td>
127. <td> </td>
128. <td><span class="detail">วันที่เสนอราคา(Qt.Date)</span></td>
129. <td><span class="detail">:
130. <? $date_a=date("Y/m/d");
131. echo "$date_a";
132. ?>
133. </span></td>
134. </tr>
135. <tr>
136. <td class="detail"> </td>
137. <td class="detail">โทรสาร (Fax. No.)</td>
138. <td><input name="txtFax" type="text" id="txtFax" value="" size="12"></td>
139. <td> </td>
140. <td colspan="2"><span class="detail">เงื่อนไขการชำระเงิน(Payment Term)</span></td>
141. <td><span class="detail">
142. <select name= "pay" onChange="s_pay()"id="pay" >
143. <option selected value="">เลือกการชำระเงิน</option>
144. <option value="เงินสด">เงินสด</option>
145. <option value="เครดิต7วัน">เครดิต7วัน</option>
146. <option value="เครดิต15วัน">เครดิต15วัน</option>
147. </select>
148. </span></td>
149. </tr>
150. <tr>
151. <td class="detail"> </td>
152. <td colspan="5" class="detail">บริษัทฯ มีความยินดีเสนอราคาพร้อมรายละเอียดของสินค้าและบริการ ดังรายการต่อไปนี้</td>
153. <td> </td>
154. </tr>
155. <tr>
156. <td class="detail"> </td>
157. <td colspan="5" class="detail">It's our pleasure to submit a quotation for your favorable consideration as follows :</td>
158. <td> </td>
159. </tr>
160. <tr>
161. <td height="264" colspan="7" valign="top"><table width="687" border="1" class="coll" cellpadding="0" cellspacing="0">
162. <tr class="detail">
163. <td width="55" align="center"><p>ลำดับ<br>
164. NO.
165. </p></td>
166. <td width="288" align="center">รายการสินค้า/บริการ<br>
167. Description</td>
168. <td width="78" align="center">จำนวน<br>
169. Quantity</td>
170. <td width="82" align="center">ราคาต่อหน่วย<br>
171. Unit Price</td>
172. <td width="96" align="center">จำนวนเงินรวม<br>
173. Amount</td>
174. </tr>
175. <tr>
176. <td><span class="detail">
177. <input name="txtNo1" type="text" id="txtNo1" value="" size="2">
178. </span></td>
179. <td><input name="txtDes1" type="text" id="txtDes1" value="" size="50"></td>
180. <td><span class="detail">
181. <input name="txtQua1" type=text class="right" id="txtQua1" onFocus="startCalc();" onBlur="stopCalc();" value="" size="4">
182. </span></td>
183. <td><span class="detail">
184. <input name="txtUnit1" type=text class="right" id="txtUnit1" onFocus="startCalc();" onBlur="stopCalc();" value="" size="7">
185. </span></td>
186. <td><span class="detail">
187. <input name="txtAmount1" type="text" id="txtAmount1" value="" size="8">
188. </span></td>
189. </tr>
190. <tr>
191. <td><input name="txtNo2" type="text" id="txtNo2" value="" size="2"></td>
192. <td><input name="txtDes2" type="text" id="txtDes2" value="" size="50"></td>
193. <td><span class="detail">
194. <input name="txtQua2" type=text class="right" id="txtQua2" onFocus="startCalc();" onBlur="stopCalc();" value="" size="4">
195. </span></td>
196. <td><span class="detail">
197. <input name="txtUnit2" type=text class="right" id="txtUnit2" onFocus="startCalc();" onBlur="stopCalc();" value="" size="7">
198. </span></td>
199. <td><span class="detail">
200. <input name="txtAmount2" type="text" id="txtAmount2" value="" size="8">
201. </span></td>
202. </tr>
203. <tr>
204. <td><input name="txtNo3" type="text" id="txtNo3" value="" size="2"></td>
205. <td><input name="txtDes3" type="text" id="txtDes3" value="" size="50"></td>
206. <td><span class="detail">
207. <input name="txtQua3" type=text class="right" id="txtQua3" onFocus="startCalc();" onBlur="stopCalc();" value="" size="4">
208. </span></td>
209. <td><span class="detail">
210. <input name="txtUnit3" type=text class="right" id="txtUnit3" onFocus="startCalc();" onBlur="stopCalc();" value="" size="7">
211. </span></td>
212. <td><span class="detail">
213. <input name="txtAmount3" type="text" id="txtAmount3" value="" size="8">
214. </span></td>
215. </tr>
216. <tr>
217. <td><input name="txtNo4" type="text" id="txtNo4" value="" size="2"></td>
218. <td><input name="txtDes4" type="text" id="txtDes4" value="" size="50"></td>
219. <td><span class="detail">
220. <input name="txtQua4" type=text class="right" id="txtQua4" onFocus="startCalc();" onBlur="stopCalc();" value="" size="4">
221. </span></td>
222. <td><span class="detail">
223. <input name="txtUnit4" type=text class="right" id="txtUnit4" onFocus="startCalc();" onBlur="stopCalc();" value="" size="7">
224. </span></td>
225. <td><span class="detail">
226. <input name="txtAmount4" type="text" id="txtAmount4" value="" size="8">
227. </span></td>
228. </tr>
229. <tr>
230. <td><input name="txtNo5" type="text" id="txtNo5" value="" size="2"></td>
231. <td><input name="txtDes5" type="text" id="txtDes5" value="" size="50"></td>
232. <td><span class="detail">
233. <input name="txtQua5" type=text class="right" id="txtQua5" onFocus="startCalc();" onBlur="stopCalc();" value="" size="4">
234. </span></td>
235. <td><span class="detail">
236. <input name="txtUnit5" type=text class="right" id="txtUnit5" onFocus="startCalc();" onBlur="stopCalc();" value="" size="7">
237. </span></td>
238. <td><span class="detail">
239. <input name="txtAmount5" type="text" id="txtAmount5" value="" size="8">
240. </span></td>
241. </tr>
242. <tr>
243. <td><input name="txtNo6" type="text" id="txtNo6" value="" size="2"></td>
244. <td><input name="txtDes6" type="text" id="txtDes6" value="" size="50"></td>
245. <td><span class="detail">
246. <input name="txtQua6" type=text class="right" id="txtQua6" onFocus="startCalc();" onBlur="stopCalc();" value="" size="4">
247. </span></td>
248. <td><span class="detail">
249. <input name="txtUnit6" type=text class="right" id="txtUnit6" onFocus="startCalc();" onBlur="stopCalc();" value="" size="7">
250. </span></td>
251. <td><span class="detail">
252. <input name="txtAmount6" type="text" id="txtAmount6" value="" size="8">
253. </span></td>
254. </tr>
255. <tr>
256. <td><input name="txtNo7" type="text" id="txtNo7" value="" size="2"></td>
257. <td><input name="txtDes7" type="text" id="txtDes7" value="" size="50"></td>
258. <td><span class="detail">
259. <input name="txtQua7" type=text class="right" id="txtQua7" onFocus="startCalc();" onBlur="stopCalc();" value="" size="4">
260. </span></td>
261. <td><span class="detail">
262. <input name="txtUnit7" type=text class="right" id="txtUnit7" onFocus="startCalc();" onBlur="stopCalc();" value="" size="7">
263. </span></td>
264. <td><span class="detail">
265. <input name="txtAmount7" type="text" id="txtAmount7" value="" size="8">
266. </span></td>
267. </tr>
268. <tr>
269. <td><input name="txtNo8" type="text" id="txtNo8" value="" size="2"></td>
270. <td><input name="txtDes8" type="text" id="txtDes8" value="" size="50"></td>
271. <td><span class="detail">
272. <input name="txtQua8" type=text class="right" id="txtQua8" onFocus="startCalc();" onBlur="stopCalc();" value="" size="4">
273. </span></td>
274. <td><span class="detail">
275. <input name="txtUnit8" type=text class="right" id="txtUnit8" onFocus="startCalc();" onBlur="stopCalc();" value="" size="7">
276. </span></td>
277. <td><span class="detail">
278. <input name="txtAmount8" type="text" id="txtAmount8" value="" size="8">
279. </span></td>
280. </tr>
281. <tr>
282. <td><input name="txtNo9" type="text" id="txtNo9" value="" size="2"></td>
283. <td><input name="txtDes9" type="text" id="txtDes9" value="" size="50"></td>
284. <td><span class="detail">
285. <input name="txtQua9" type=text class="right" id="txtQua9" onFocus="startCalc();" onBlur="stopCalc();" value="" size="4">
286. </span></td>
287. <td><span class="detail">
288. <input name="txtUnit9" type=text class="right" id="txtUnit9" onFocus="startCalc();" onBlur="stopCalc();" value="" size="7">
289. </span></td>
290. <td><span class="detail">
291. <input name="txtAmount9" type="text" id="txtAmount9" value="" size="8">
292. </span></td>
293. </tr>
294. <tr>
295. <td><input name="txtNo10" type="text" id="txtNo10" value="" size="2"></td>
296. <td><input name="txtDes10" type="text" id="txtDes10" value="" size="50"></td>
297. <td><span class="detail">
298. <input name="txtQua10" type=text class="right" id="txtQua10" onFocus="startCalc();" onBlur="stopCalc();" value="" size="4">
299. </span></td>
300. <td><span class="detail">
301. <input name="txtUnit10" type=text class="right" id="txtUnit10" onFocus="startCalc();" onBlur="stopCalc();" value="" size="7">
302. </span></td>
303. <td><span class="detail">
304. <input name="txtAmount10" type="text" id="txtAmount10" value="" size="8">
305. </span></td>
306. </tr>
307. <tr>
308. <td> </td>
309. <td class="detail">จำนวนเงินเป็นตัวอักษร (Total amount in words.)</td>
310. <td colspan="2" class="detail">มูลค่าสินค้า</td>
311. <td><span class="detail">
312. <input name="txtTotal" type=text class="right" id="txtTotal" size="10">
313. </span></td>
314. </tr>
315. <tr>
316. <td rowspan="2"> </td>
317. <td rowspan="2"> </td>
318. <td colspan="2" class="detail">ภาษีมูลค่าเพิ่ม / VAT 7%</td>
319. <td><span class="detail">
320. <input name="txtVat" type=text class="right" id="txtVat" size="10">
321. </span></td>
322. </tr>
323. <tr>
324. <td colspan="2" class="detail">จำนวนเงินรวมทั้งสิ้น</td>
325. <td><span class="detail">
326. <input name="txtSum" type=text class="right" id="txtSum" size="10">
327. </span></td>
328. </tr>
329. <tr>
330. <td> </td>
331. <td colspan="3" class="detail">กำหนดยืนราคา :
332. <select name="dateprice" onChange="d_price()" id="dateprice">
333. <option selected value="">0</option>
334. <option value="7">7</option>
335. <option value="15">15</option>
336. </select>
337. วัน ชื่อผู้ติดต่อ:
338. <input name="txtContact" type="text" id="txtContact" value="" size="20"></td>
339. <td> </td>
340. </tr>
341. <tr>
342. <td> </td>
343. <td colspan="4" valign="middle" class="detail">หมายเหตุ/Remark :
344. <br> <textarea name="txtRemark" cols="95" rows="5" id="txtRemark"></textarea></td>
345. </tr>
346. </table></td>
347. </tr>
348. <tr>
349. <td> </td>
350. <td> </td>
351. <td colspan="4" align="center"><input type="submit" name="btnSubmit" id="btnSubmit" value="สร้างใบเสนอราคา">
352. <input type="reset" name="btnReset" id="btnReset" value="ล้างข้อมูล"></td>
353. <td> </td>
354. </tr>
355. </table>
356. <script language="javascript">
357.function check() {
358.if(document.autoSumForm.txtId.value=="") {
359.alert("กำหนดเลขที่ ใบเสนอราคา ด้วยครับ") ;
360.document.autoSumForm.txtId.focus() ;
361.return false ;
362.}
363.else if(document.autoSumForm.txtId.value.length <= 3){
364.alert('เลขที่ ใบเสนอราคา ต้องมี 4 ตัวขึ้นไปครับ');
365.document.autoSumForm.txtId.focus();
366.return false;
367.}
368.else if(document.autoSumForm.txtCust.value=="") {
369.alert("กรอก ชื่อลูกค้า ด้วยครับ") ;
370.document.autoSumForm.txtCust.focus() ;
371.return false ;
372.}
373.else if(document.autoSumForm.txtAddress.value=="") {
374.alert("กรอก ที่อยู่ลูกค้า ด้วยครับ") ;
375.document.autoSumForm.txtAddress.focus() ;
376.return false ;
377.}
378.else if(document.autoSumForm.txtTel.value=="") {
379.alert("กรอกเบอร์โทรศัพท์ ด้วยครับ") ;
380.document.autoSumForm.txtTel.focus() ;
381.return false ;
382.}
383.else if(document.autoSumForm.txtFax.value=="") {
384.alert("กรอกเบอร์ Fax ด้วยครับ") ;
385.document.autoSumForm.txtFax.focus() ;
386.return false ;
387.}
388.else if(document.autoSumForm.txtNo1.value=="") {
389.alert("ใบเสนอราคา อย่างน้อยต้องมี 1 รายการครับ") ;
390.document.autoSumForm.txtNo1.focus() ;
391.return false ;
392.}
393.else if(document.autoSumForm.txtDes1.value=="") {
394.alert("ใส่ รายการสินค้า/บริการ ด้วยครับ") ;
395.document.autoSumForm.txtDes1.focus() ;
396.return false ;
397.}
398.else if(document.autoSumForm.txtQua1.value=="") {
399.alert("ใส่ จำนวนสินค้า ด้วยครับ") ;
400.document.autoSumForm.txtQua1.focus() ;
401.return false ;
402.}
403.else if(document.autoSumForm.txtUnit1.value=="") {
404.alert("ใส่ ราคาต่อหน่วย ด้วยครับ") ;
405.document.autoSumForm.txtUnit1.focus() ;
406.return false ;
407.}
408.else if(document.autoSumForm.txtContact.value=="") {
409.alert("ใส่ ชื่อผู้ติดต่อ ด้วยครับ") ;
410.document.autoSumForm.txtContact.focus() ;
411.return false ;
412.}
413.
414.else
415.return true ;
416.}
417.
418.</script> </td>
419. </tr>
420.</table>
421.</form>
422.</body>
423.</html>
