001.<?
002. include"chksession.php";
003. include"function.php";
004. include"connect.php";
005. $id_order=$_GET["id"];
006. $time=$_GET['datetime'];
007.
008.
009.
010.
011. function thaicurrentday($date, $days, $months, $years)
012. {
013.
014. $datevalue = explode("-", $date);
015.
016. $currentday = date("Y-m-d", mktime(0, 0, 0, $datevalue[1] + $months, $datevalue[2] + $days, $datevalue[0] + $years));
017.
018. $datearray = explode("-", $currentday);
019.
020. return $datearray[2] . "/" . $datearray[1] . "/" . ($datearray[0]+543);
021. }
022.$table = mysql_query("SELECT * FROM bookdate") or die ("Query Error : SELECT goodssup <" . mysql_error() . ">");
023. $field = mysql_fetch_array($table);
024. $fid_bookdate = $field["id_bookdate"];
025. $fddayexpire = $field["dayexpire"];
026.
027. mysql_query("SET NAMES utf8") or die (mysql_error());
028. $sess_adminid=session_id();
029. $username= $_SESSION[sess_username];
030.
031.
032.
033. $table = mysql_query("SELECT MAX(id) AS id_order FROM `order`") or die ("Query Error : SELECT `order` <" . mysql_error() . ">");
034. $field = mysql_fetch_array($table);
035. $id_order = $field["id_order"];
036. $date = $field["date"];
037.
038.
039.
040.
041.
042. $tableorder = mysql_query("SELECT `order`.id,`order`.member_id,`order`.status_pay,`order`.date,`order`.datetime,order_detail.id,order_detail.id_order,order_detail.product_id,order_detail.amount1,product.id,product.name_pr,product.detail,product.price,product.price2,product.price3,product.amount,member.name,member.surname,member.address,member.phone FROM `order`,order_detail,product,member WHERE (`order`.id='$id_order')AND(order_detail.id_order=`order`.id) AND(member.id=`order`.member_id) AND(product.id=order_detail.product_id)") or die ("Query Error : SELECT order " . mysql_error() . ">");
043. $field = mysql_fetch_array($tableorder);
044.$name_pr=$field["name_pr"];
045.
046.$amount1=$field["amount"];
047. $price2=$field["price2"];
048. $price3=$field["price3"];
049. $status=$field["status_pay"];
050. $status_pro=$field["status_pro"];
051. $id_pr=$field["id"];
052.
053. $tableorder1 = mysql_query("SELECT `order`.id,`order`.date,`order`.datetime,`order`.member_id,`order`.status_pay,`order`.status_pro,member.id,member.name,member.surname,member.address,member.phone FROM `order`,member WHERE (`order`.id='$id_order')AND(`order`.member_id=member.id)") or die ("Query Error : SELECT order <" . mysql_error() . ">");
054. $field2 = mysql_fetch_array($tableorder1);
055.
056.$id_mem=$field2["id"];
057.$name=$field2["name"];
058.$surname=$field2["surname"];
059.$address=$field2["address"];
060.$phone=$field2["phone"];
061. $date1=$field2["date"];
062.
063. $status=$field2["status_pay"];
064. $status_pro=$field2["status_pro"];
065. $id_pr=$field2["product_id"];
066.
067.
068.
069.
070.?>
071.
072.
073.
076.<head>
077.<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
078.<title>ใบสั่งซื้อ</title>
079.
080.
081.<link href="OTOPSatun/style.css" rel="stylesheet" type="text/css" />
082.<style type="text/css">
083.<!--
084..style6 {
085. font-size: 14px;
086. font-family: "MS Sans Serif", Tahoma, "Cordia New";
087.}
088..style8 {
089. font-family: "MS Sans Serif", Tahoma, "Cordia New";
090. font-size: 16px;
091.}
092..style11 {text-decoration: none; font-family: Tahoma, "MS Sans Serif", CordiaUPC;}
093..style12 {font-family: "MS Sans Serif", Tahoma, "Cordia New"}
094..style13 {
095. color: #000000;
096. text-decoration: none;
097. font-size: 14px;
098. font-weight: bold;
099.}
100..style14 {
101. text-decoration: none;
102. color: #993399;
103. font-size: 14px;
104. font-weight: bold;
105.}
106..style30 {font-size: 14px}
107..style33 {text-decoration: none; color: #000000;}
108..style34 {
109. font-family: "MS Sans Serif", Tahoma, "Cordia New";
110. font-weight: bold;
111.}
112..style39 {text-decoration: none; color: #FF0000;}
113..style48 {font-size: 14px; font-family: "MS Sans Serif", Tahoma, "Cordia New"; font-weight: bold; }
114..style55 {font-family: "MS Sans Serif", Tahoma, "Cordia New"; font-size: 16px; font-weight: bold; }
115..style20 {font-family: Geneva, Arial, Helvetica, sans-serif;
116. color: #000000;
117.}
118..style46 {text-decoration: none}
119..style47 {color: #000000}
120..style49 {color: #000000; text-decoration: none; font-size: 12px;}
121..style54 {font-family: "MS Sans Serif", Tahoma, "Cordia New"; color: #000000; font-size: 16px; font-weight: bold; }
122..style60 {text-decoration: none; font-family: Tahoma, "MS Sans Serif", CordiaUPC; font-size: 18px; }
123..style61 {font-size: 16px}
124..style62 {text-decoration: none; color: #000000; font-size: 16px; }
125.-->
126.</style>
127.</head>
128.
129.<body>
130.
131. <table width="730" border="0" align="center" cellpadding="0" cellspacing="0">
132.
133. <tr>
134.
135. <th scope="col"> </th>
136. <th width="355" scope="col"> </th>
137. <th width="347" scope="col"> </th>
138. <th scope="col"> </th>
139.
140. </tr>
141. <tr>
142. <th width="15" height="29" scope="col"> </th>
143. <th colspan="2" align="center" scope="col"><span class="black_14 style8"><span class="style60">ใบสั่งซื้อสินค้า</span></span></th>
144. <th width="13" scope="col"> </th>
145. </tr>
146. <tr>
147. <td> </td>
148. <td align="left" valign="top" class="black_13"> </td>
149. <td align="right" valign="top"> </td>
150. <td> </td>
151. </tr>
152.
153. <tr>
154. <td> </td>
155. <td align="left" valign="top" class="black_13"><strong class="black_12"><span class="style6">เลขที่ใบสั่งซื้อ</span> <span class="style6">: </span></strong><strong><? echo $id_order;?></strong></td>
156. <td align="right" valign="top"><strong class="black_12 style12"><span class="style13 style12 style61"> วันที่ : <?php echo thaicurrentday(date("Y-m-d"), 0, 0, 0); ?> เวลา : <?php echo date("h:i:s"); ?></span><span class="style14"> </span></strong></td>
157. <td> </td>
158. </tr>
159. <tr>
160. <td> </td>
161. <td> </td>
162. <td> </td>
163. <td> </td>
164. </tr>
165. <tr>
166. <td><span class="style30"></span></td>
167. <td class="style48">ร้านตุ๊กตาโครเชต์</td>
168. <td> </td>
169. <td> </td>
170. </tr>
171. <tr>
172. <td><span class="style30"></span></td>
173. <td colspan="2" class="black_12"><span class="style48">189/2 หมู่ 2 ตำบลธงชัย อำเภอบางสะพาน </span></td>
174. <td> </td>
175. </tr>
176. <tr>
177. <td><span class="style30"></span></td>
178. <td class="style48"><span class="style49"><span class="style30">จังหวัดประจวบคีรีขันธ์ </span></span>77190</td>
179. <td align="right" class="black_12"><div align="left"><span class="style6"><strong><span class="style33"> รหัสลูกค้า</span><span class="style33"> : <span class="style48"><span class="style55"><? echo $id_mem;?></span></span> </span> </strong></span></div></td>
180. <td> </td>
181. </tr>
182. <tr>
183. <td><span class="style30"></span></td>
184. <td><span class="black_12 style12 style30"><span class="style12 style11"><span class="style12 style11"><strong><span class="style11 style12">เบอร์โทรศัพท์ 08-4320-8468 </span></strong></span></span></span></td>
185. <td align="right"><div align="left"><span class="black_13 style12 style30"><span class="style34"> ชื่อ-สกุล : <span class="black_12"><span class="style48"><span class="style20"><span class="style55"><? echo $name;?></span></span></span></span>-<span class="black_12"><span class="style48"><span class="style20"><span class="style55"><? echo $surname;?></span></span></span></span></span></span></div></td>
186. <td> </td>
187. </tr>
188.
189. <tr>
190. <td> </td>
191. <td> </td>
192. <td><div align="left"><span class="style6"><strong> โทรศัพท:์</strong> <strong><span class="style20"><span class="style55"><? echo $phone;?></span></span> </strong></span></div></td>
193. <td> </td>
194. </tr>
195.
196. <tr>
197.
198. <td> </td>
199.
200. <td colspan="2" align="center"><table width="602" border="1" cellpadding="0" cellspacing="0">
201.
202. <tr>
203.
204.
205. <th width="88" align="center" bordercolor="#000000" bgcolor="#E8E8E9" scope="col"><strong class="style6">รหัสสินค้า</strong></th>
206.
207. <th width="195" align="center" bordercolor="#000000" bgcolor="#E8E8E9" scope="col"><strong class="style6">ชื่อสินค้า</strong></th>
208. <th width="86" align="center" bordercolor="#000000" bgcolor="#E8E8E9" scope="col"><strong class="style6">ราคา</strong></th>
209. <th width="56" align="center" bordercolor="#000000" bgcolor="#E8E8E9" scope="col"><strong class="style6">จำนวน</strong></th>
210. <th width="72" align="center" bordercolor="#000000" bgcolor="#E8E8E9" scope="col"><strong class="style6">ค่าจัดส่ง</strong></th>
211. <th width="91" align="center" bordercolor="#000000" bgcolor="#E8E8E9" scope="col"><span class="style6"><strong>รวมเงิน</strong></span></th>
212.
213. </tr>
214. <?
215.
216. while($field = mysql_fetch_array($tableorder))
217.{
218.
219.?>
220.
221.
222.
223.
224.
225. <tr>
226.
227. <td align="left" bordercolor="#000000" class="black_13 style12">
228.
229. <div align="center"><span class="style30"> <strong><?php echo $field["product_id"]; ?></strong></span> </div></td>
230.
231. <td align="left" bordercolor="#000000" class="black_13 style12 style30"> <strong><?php echo $field["name_pr"]; ?></strong></td>
232. <td align="right" bordercolor="#000000" class="black_13 style12 style30"><strong><?php echo number_format( $field["price2"], 2, ".", ","); ?></strong> </td>
233. <td align="center" bordercolor="#000000"><span class="black_13 style12 style30"><span class="style12 style30 style11"><strong><?php echo number_format( $field["amount1"], 0 ,".", ","); ?></strong></span></span></td>
234. <td align="right" bordercolor="#000000"><span class="black_13 style12 style30"><span class="style12 style30 style11"><strong><strong><?php echo number_format( $field["price3"], 2, ".", ","); ?></strong> </strong></span></span></td>
235. <td width="91" align="right" bordercolor="#000000"><span class="black_13 style12 style30"><span class="style12 style30 style11"><span class="style8"><strong><strong><span class="style33"><span class="style46"><strong><span class="style47"><strong>
236. <?=number_format($field["price2"]*$field["amount1"]+$field["price3"],2,".",",")?>
237.
238. </strong></span></strong></span></span></strong></strong></span></span></span> </td>
239.
240. </tr>
241.
242. <?
243. $sum+=$field["price2"]*$field["amount1"]+$field["price3"];?>
244.
245.
246.
247.
248. <?
249.
250. }
251.
252.?>
253.
254.
255. </table>
256. </td>
257. <td> </td>
258. </tr>
259.
260. <tr>
261. <td> </td>
262. <td> </td>
263. <td> </td>
264. <td> </td>
265.
266. </tr>
267. <tr>
268. <td> </td>
269. <td colspan="2" align="right"> </td>
270. <td> </td>
271. </tr>
272. <tr>
273. <td> </td>
274. <td colspan="2" align="right"><table width="357" border="0" align="right" cellpadding="2" cellspacing="0">
275. <tr>
276. <th width="240" height="23" align="right" class="black_14_underline" scope="col"><span class="style6"><strong>ยอดรวมทั้งสิ้น</strong></span></th>
277. <th width="9" align="center" class="black_13 style12 style30" scope="col">:</th>
278. <th width="53" align="right" class="black_14" scope="col"><span class="style6"><span class="bubble_14"><strong class="black_13 style12 style30">
279. <?=number_format($sum ,2, ".", ",");?>
280. </strong></span></span></th>
281. <th width="86" align="right" class="black_14" scope="col"><div align="left"><span class="style6"><strong>บาท </strong></span></div></th>
282. </tr>
283. </table></td>
284. <td> </td>
285. </tr>
286. <tr>
287. <td> </td>
288. <td colspan="2" align="right"> </td>
289. <td> </td>
290. </tr>
291. <tr>
292. <td> </td>
293. <td colspan="2"> </td>
294. <td> </td>
295. </tr>
296. <tr>
297. <td> </td>
298. <td colspan="2" align="right"> </td>
299. <td> </td>
300. </tr>
301. <tr>
302. <td> </td>
303. <td colspan="2"> </td>
304. <td> </td>
305. </tr>
306. <tr>
307. <td> </td>
308. <td colspan="2"> </td>
309. <td> </td>
310. </tr>
311. <tr>
312. <td> </td>
313. <td colspan="2" align="left">
314.
315.
316. <!-- แสดงกำหนดวันสิ้นสุดชำระเงินค่ามัดจำ โดยเรียกใช้ฟังก์ชั่น thaicurrentday เพื่อแสดงวันที่ภาษาไทย โดยบวกจำนวนวันที่ต้องชำระเงินมัดจำ สมมติ กำหนดไว้ 5 วัน ก็จะบวกจากวันปัจจุบันไปอีก 5 วัน เช่น 2010-05-02 -> 07/05/2010 -->
317. <span class="style6"><strong><span class="style39">หมายเหตุ : </span><span class="style62">กรุณาชำระเงินก่อนวันที่ : </span></strong></span><span class="style62"><strong class="black_12 style12"><?php echo thaicurrentday(date("Y-m-d"), $fddayexpire, 0, 0); ?></strong><strong></strong></span><span class="style6"><span class="style61"><strong><span class="style33"> (<?php echo $fddayexpire; ?> วัน)</span></strong></span></span> </td>
318. <td> </td>
319. </tr>
320. <tr>
321. <td> </td>
322. <td> </td>
323. <td> </td>
324. <td> </td>
325. </tr>
326. <tr>
327. <td> </td>
328. <td colspan="2" class="style6"><strong>สามารถชำระเงินได้ที่ตู้ ATM หรือเคาน์เตอร์ธนาคาร</strong></td>
329. <td> </td>
330. </tr>
331. <tr>
332. <td> </td>
333. <td colspan="2"> </td>
334. <td> </td>
335. </tr>
336. <tr>
337. <td> </td>
338. <td colspan="2"><table width="700" border="1" align="center" cellpadding="0" cellspacing="0">
339. <tr>
340. <th width="140" align="center" bordercolor="#000000" bgcolor="#E8E8E9" class="style6" scope="col">ชื่อธนาคาร</th>
341. <th width="106" align="center" bordercolor="#000000" bgcolor="#E8E8E9" class="style6" scope="col">สาขา</th>
342. <th width="127" bordercolor="#000000" bgcolor="#E8E8E9" class="style6" scope="col">เลขที่บัญชี</th>
343. <th width="151" align="center" bordercolor="#000000" bgcolor="#E8E8E9" class="style6" scope="col">ชื่อบัญชี</th>
344. <th width="164" align="center" bordercolor="#000000" bgcolor="#E8E8E9" class="style6" scope="col">ประเภทบัญชี</th>
345. </tr>
346. <tr>
347. <td align="left" valign="middle" bordercolor="#000000" class="style6"> กรุงไทย</td>
348. <td align="left" valign="middle" bordercolor="#000000"> <span class="style12">พระนคร</span></td>
349. <td align="center" valign="middle" bordercolor="#000000" class="style6">7310157788</td>
350. <td align="left" valign="middle" bordercolor="#000000" class="style6"> รุ่งอรุณ ปานสีสุข </td>
351. <td align="left" valign="middle" bordercolor="#000000"><div align="center"><span class="style12">ออมทรัพย์</span></div></td>
352. </tr>
353. </table></td>
354. <td> </td>
355. </tr>
356.
357. <tr>
358. <td> </td>
359. <td> </td>
360. <td> </td>
361. <td> </td>
362. </tr>
363. <tr>
364. <td> </td>
365. <td class="style6"> </td>
366. <td> </td>
367. <td> </td>
368. </tr>
369. <tr>
370. <td> </td>
371. <td class="style6"><strong>ชื่อ-ที่อยู่ในการจัดส่งสินค้า</strong></td>
372. <td> </td>
373. <td> </td>
374. </tr>
375. <tr>
376. <td> </td>
377. <td colspan="2" align="center"> </td>
378. <td> </td>
379. </tr>
380. <tr>
381. <td> </td>
382. <td colspan="2" align="center"><table width="646" border="0" cellspacing="0" cellpadding="0">
383. <tr>
384. <th width="49" align="right" scope="col"><span class="black_13 style12 style30"><span class="style34">คุณ</span></span></th>
385. <th width="4" align="left" scope="col"> </th>
386. <th width="466" align="left" class="black_13" scope="col"><span class="style6"><span class="black_13 style12 style30"><span class="style34"><span class="black_12"><span class="style48"><span class="style20"><span class="style55"><? echo $name;?></span></span></span></span> <span class="black_12"><span class="style48"><span class="style20"><span class="style55"><? echo $surname;?></span></span></span></span></span></span></span></th>
387. </tr>
388. <tr>
389. <td> </td>
390. <td width="4"> </td>
391. <td align="left" class="black_13"><span class="style6"><span class="style54"><? echo $address;?></span></span></td>
392. </tr>
393. </table></td>
394. <td> </td>
395. </tr>
396. <tr>
397. <td> </td>
398. <td> </td>
399. <td> </td>
400. <td> </td>
401. </tr>
402. <tr>
403. <td> </td>
404. <td colspan="2" align="center"> </td>
405. <td> </td>
406. </tr>
407. <tr>
408. <td> </td>
409. <td colspan="2" align="center"> <input onClick="javascript:window.print()" type="button" value="พิมพ์" />
410. <input type="submit" name="Submit" value="กลับหน้าหลัก"onClick="window.location='main.php'"/></td><td> </td>
411. </tr>
412. <tr>
413. <td> </td>
414. <td> </td>
415. <td> </td>
416. <td> </td>
417.
418. </tr>
419. </table>
420.
421.</body>
422.</html>
