001.<?php
002.session_start();
003.include "function.php";
004.include "dbconfig.php";
005.include "config.php";
006.conndb();
007.
008.function get_send_method_name($send_method_id)
009.{
010. $query = "select * from send_method_tb where id = '$send_method_id'";
011. $result= mysql_query($query);
012. $row = mysql_fetch_array($result);
013. return $row['method_name'];
014.}
015.
016.function get_send_method_price($send_method_id)
017.{
018. $query = "select * from send_method_tb where id = '$send_method_id'";
019. $result= mysql_query($query);
020. $row = mysql_fetch_array($result);
021. return $row['method_price'];
022.}
023.
024.$send_method_id = $_POST['send_method_id'];
025.
026.$money_total = $_SESSION['total'] + get_send_method_price($send_method_id);
027.$fullname = $_POST['fullname'];
028.$tel = $_POST['tel'];
029.$email = $_POST['email'];
030.$address = $_POST['address'];
031.$remarks = $_POST['remarks'];
032.$order_datetime = date("Y-m-d H:i:s");
033.
034.$member_id = $_POST['member_id'];
035.
036.
037.$insert1 = "insert into orders(order_id,order_status,update_qty_ok,money_total,member_id,fullname,tel,email,address,remarks,order_datetime) VALUES ('','รอการชำระเงิน','N','$money_total','$member_id','$fullname','$tel','$email','$address','$remarks','$order_datetime')";
038.$result1 = mysql_query($insert1);
039.$order_id = mysql_insert_id();
040.
041.
042.foreach ($_SESSION['SHOPPING_CART'] as $itemNumber => $item) {
043.
044. $qty = $item['qty'];
045. $price = $item['price'];
046. $product_name = $item['name'];
047. $product_id = $item['product_id'];
048.
049.
050. $insert2 = "insert into orderdetails(orderdetails_id,order_id,product_id,product_name,qty,price) VALUES ('','$order_id','$product_id','$product_name','$qty','$price')";
051. $result2 = mysql_query($insert2);
052.}
053.
054. $send_method_price_tmp = get_send_method_price($send_method_id);
055. $send_method_name_tmp = get_send_method_name($send_method_id);
056.
057. $insert3 = "insert into orderdetails(orderdetails_id,order_id,product_id,product_name,qty,price) VALUES ('','$order_id',-1,'$send_method_name_tmp','1','$send_method_price_tmp')";
058. $result3 = mysql_query($insert3);
059.
060.
061.
062.
063.$mess .= $email_body."
064.<center><br><hr width=550>
065.<p><b><font size=5>Product invoice</font></b><br></p>
066.
067.
068. <table width=550 border=1 cellpadding=0 cellspacing=0>
069. <tr>
070. <td colspan=4>
071. <center>
072.<table width=100% cellpadding=0 cellspacing=0>
073. <tr>
074.
075. <td width=50%> <b><font color=red>Order number : $order_id</font></b></td>
076. <td width=50%> <b><font color=red>Order date / time : ".convert_datetime($order_datetime)."</font></b></font></b></td>
077. </tr>
078.
079.</table>
080. </center>
081. </td>
082. </tr>
083.
084. <tr>
085. <td width=235 bgcolor=#FFFFCC>
086. <font color=#000080><center>Product Name</center></font></td>
087. <td width=120 bgcolor=#FFFFCC>
088. <font color=#000080><center>Price/Unit</center></font></td>
089. <td width=55 bgcolor=#FFFFCC>
090. <font color=#000080><center>Unit</center></font></td>
091. <td width=140 bgcolor=#FFFFCC>
092. <font color=#000080><center>Total</center></font></td>
093. </tr>";
094.
095.
096. foreach ($_SESSION['SHOPPING_CART'] as $itemNumber => $item) {
097.
098.
099.$mess .= "
100.
101. <tr>
102. <td width=235 bgcolor=#CCFFFF> ".$item['name']." </td>
103. <td width=120 bgcolor=#CCFFFF><div align=right>".number_format($item['price'],2,'.',',')." </div></td>
104. <td width=55 bgcolor=#CCFFFF><div align=right>".number_format($item['qty'],0,'.',',')." </div></td>
105. <td width=140 bgcolor=#CCFFFF><div align=right>".number_format($item['qty'] * $item['price'],2,'.',',')." </div></td>
106. </tr>
107.
108.";
109.
110.
111. }
112.
113.
114.$mess .= "
115.
116. <tr>
117. <td width=235 bgcolor=#CCFFFF> ".$send_method_name_tmp." </td>
118. <td width=120 bgcolor=#CCFFFF><div align=right>".number_format($send_method_price_tmp,2,'.',',')." </div></td>
119. <td width=55 bgcolor=#CCFFFF><div align=right>".number_format(1,0,'.',',')." </div></td>
120. <td width=140 bgcolor=#CCFFFF><div align=right>".number_format($send_method_price_tmp,2,'.',',')." </div></td>
121. </tr>
122.
123.";
124.
125.
126.
127.$mess .= "
128. <tr id=itemtotal>
129. <td width=410 bgcolor=#FFFFCC colspan=3 valign=middle><div align=left>
130. <b><font color=#008000> Total price</font></b></div></td>
131. <td width=140 bgcolor=#FFFFCC valign=middle>
132. <div align=right><b><font color=#008000>".number_format($_SESSION['total']+$send_method_price_tmp,2,'.',',')." baht </font></b></div></td>
133. </tr>";
134.
135.
136.if($use_vat == 1)
137.{
138.
139.
140.$mess .= "
141. <tr id=itemvat>
142. <td width=410 bgcolor=#FFFFCC colspan=3 valign=middle><div align=left>
143. <b><font color=#008000> VAT (7%)</font></b></div></td>
144. <td width=140 bgcolor=#FFFFCC valign=middle>
145. <div align=right><b><font color=#008000>".number_format(0.07*($_SESSION['total']+$send_method_price_tmp),2,'.',',')." baht </font></b></div></td>
146. </tr>";
147.
148.$mess .= "
149. <tr id=itemnettotal>
150. <td width=410 bgcolor=#FFFFCC colspan=3 valign=middle><div align=left>
151. <b><font color=#008000> VAT included (7%)</font></b></div></td>
152. <td width=140 bgcolor=#FFFFCC valign=middle>
153. <div align=right><b><font color=#008000>".number_format($_SESSION['total']+$send_method_price_tmp + 0.07*($_SESSION['total']+$send_method_price_tmp),2,'.',',')." baht </font></b></div></td>
154. </tr>";
155.
156.
157.
158.}
159.
160.
161.
162.$mess .= "
163.
164.</table>
165.
166.
167.<br>
168.
169.<table width=500 border=0 cellspacing=5 cellpadding=0>
170.<tr>
171.<td width=30% class=bodytext>Name :</td>
172.<td width=70%>$fullname</td>
173.</tr>
174.<tr>
175.<td>Email :</td>
176.<td>$email</td>
177.</tr>
178.<tr>
179.<td>Phone :</td>
180.<td>$tel</td>
181.</tr>
182.<tr>
183.<td valign=top>Adress :</td>
184.<td>$address</td>
185.</tr>
186.<tr>
187.<td valign=top>Note :</td>
188.<td>$remarks</td>
189.</tr>
190.</table>
191.
192.</center>
193.";
194.
195.$mess = str_replace("#fullname#",$fullname,$mess);
196.$mess = str_replace("#web_tracking#",$web_url."/tracking.php",$mess);
197.
198.
199.$strFromName = $fullname;
200.$strFromEmail = $email;
201.$strTo = $admin_email;
202.$strSubject = "=?tis-620?B?".base64_encode($email_title)."?=";
203.
204.
205.
206.
207.
208.$header = "MIME-Version: 1.0\n";
209.$header .= "Content-type: text/html; charset=tis-620\n";
210.$header .= "From: $strFromEmail\n";
211.$header .= "Return-Path: $strFromEmail\n";
212.$header .= "Reply-To: $strFromEmail\n";
213.$header .= "To: $strTo\n";
214.$header .= "Sent: ".date("jS F Y, g:i a")."\n";
215.$header .= "X-Mailer: PHP/".phpversion()."\n";
216.$header .= "X-Priority: 1\n";
217.$header .= "X-MSmail-Priority: High\n";
218.
219.mail($strTo,$strSubject,$mess, $header);
220.
221.
222.?>
223.
224.<html>
225.
226.<head>
227.<meta http-equiv="Content-Type" content="text/html; charset=tis-620">
228.<title>Your Shopping Cart</title>
229.
230.<STYLE type=text/css>
231. A:link { color: #0000cc; text-decoration:none}
232. A:visited {color: #0000cc; text-decoration: none}
233. A:hover {color: red; text-decoration: none}
234. </STYLE>
235.<style type="text/css">
236.<!--
237.small { font-family: Arial, Helvetica, sans-serif; font-size: 8pt; }
238.input, textarea { font-family: Arial, Helvetica, sans-serif; font-size: 9pt; }
239.b { font-family: Arial, Helvetica, sans-serif; font-size: 11pt; }
240.big { font-family: Arial, Helvetica, sans-serif; font-size: 14pt; }
241.strong { font-family: Arial, Helvetica, sans-serif; font-size: 11pt; font-weight : extra-bold; }
242.font, td { font-family: Arial, Helvetica, sans-serif; font-size: 11pt; }
243.BODY { font-size: 9pt; font-family: Arial, Helvetica, sans-serif; }
244.-->
245.</style>
246.
247.<script language="javascript">
248.var win = null;
249.function NewWindow(mypage,myname,w,h,scroll){
250.LeftPosition = (screen.width) ? (screen.width-w)/2 : 0;
251.TopPosition = (screen.height) ? (screen.height-h)/2 : 0;
252.settings =
253.'height='+h+',width='+w+',top='+TopPosition+',left='+LeftPosition+',scrollbars='+scroll+',resizable'
254.win = window.open(mypage,myname,settings)
255.}
256.</script>
257.</head>
258.
259.<body>
260.<center>
261.<div id="shoppingCartDisplay">
262.
263. <center><img src="images/shopping_cart_header.gif"></center>
264.
265.<table border="0" cellpadding="2" cellspacing="0" width="750" style="border-collapse: collapse" bordercolor="#111111">
266.
267.<tr bgcolor="#FFFFCC" height="40">
268.<td width="100%"><div align="center"><b>:: Order results ::</b></div>
269.</td>
270.</tr>
271.
272.<tr bgcolor="#fbdbe8">
273.<td width="100%"><br>
274.<div align="center"><font color="green"><b>Success !! Your order information has been saved to the database.</b></font>
275.<br><br><a href="print.php?order_id=<?=$order_id; ?>" onclick="NewWindow(this.href,'print_order','800','500','yes');return false"><img src="images/printer.png" width="60" border="0"><br>Print your order</a>
276.<br><br>
277.</div>
278.</td>
279.</tr>
280.
281.</table>
282.
283.</div>
284.</center>
285.
286.</body>
287.</html>
เดี๋ยวจะหาโค้ดมาแปะให้ดูนะคะ
