PageRenderTime 47ms CodeModel.GetById 15ms RepoModel.GetById 0ms app.codeStats 0ms

/inc/amfphp/administration/printorder.php

https://github.com/EmranAhmed/wp-easycart
PHP | 577 lines | 369 code | 171 blank | 37 comment | 53 complexity | 7525d727d8c3555d0e089f978a709db1 MD5 | raw file
  1. <?php
  2. /*
  3. ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
  4. ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
  5. //All Code and Design is copyrighted by Level Four Development, llc
  6. //
  7. //Level Four Development, LLC provides this code "as is" without warranty of any kind, either express or implied,
  8. //including but not limited to the implied warranties of merchantability and/or fitness for a particular purpose.
  9. //
  10. //Only licensed users may use this code and storfront for live purposes. All other use is prohibited and may be
  11. //subject to copyright violation laws. If you have any questions regarding proper use of this code, please
  12. //contact Level Four Development, llc and EasyCart prior to use.
  13. //
  14. //All use of this storefront is subject to our terms of agreement found on Level Four Development, llc's website.
  15. ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
  16. ////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
  17. */
  18. //load our connection settings
  19. require_once('../../../../../../wp-config.php');
  20. //set our connection variables
  21. $dbhost = DB_HOST;
  22. $dbname = DB_NAME;
  23. $dbuser = DB_USER;
  24. $dbpass = DB_PASSWORD;
  25. //make a connection to our database
  26. mysql_connect($dbhost, $dbuser, $dbpass);
  27. mysql_select_db ($dbname);
  28. if (!function_exists("GetSQLValueString")) {
  29. function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "")
  30. {
  31. $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  32. $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
  33. switch ($theType) {
  34. case "text":
  35. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  36. break;
  37. case "long":
  38. case "int":
  39. $theValue = ($theValue != "") ? intval($theValue) : "NULL";
  40. break;
  41. case "double":
  42. $theValue = ($theValue != "") ? "'" . doubleval($theValue) . "'" : "NULL";
  43. break;
  44. case "date":
  45. $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
  46. break;
  47. case "defined":
  48. $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
  49. break;
  50. }
  51. return $theValue;
  52. }
  53. }
  54. $editFormAction = $_SERVER['PHP_SELF'];
  55. if (isset($_SERVER['QUERY_STRING'])) {
  56. $editFormAction .= "?" . htmlentities($_SERVER['QUERY_STRING']);
  57. }
  58. $requestID = "-1";
  59. if (isset($_GET['reqID'])) {
  60. $requestID = $_GET['reqID'];
  61. }
  62. $usersqlquery = sprintf("SELECT ec_user.*, ec_role.admin_access FROM ec_user LEFT JOIN ec_role ON (ec_user.user_level = ec_role.role_label) WHERE ec_user.password = '%s' AND (ec_user.user_level = 'admin' OR ec_role.admin_access = 1)", mysql_real_escape_string($requestID));
  63. $userresult = mysql_query($usersqlquery) or die(mysql_error());
  64. $users = mysql_fetch_assoc($userresult);
  65. if ($users || is_user_logged_in()) {
  66. $KTColParam1_orderdetails = "-1";
  67. if (isset($_GET["OrderID"])) {
  68. $KTColParam1_orderdetails = (get_magic_quotes_gpc()) ? $_GET["OrderID"] : addslashes($_GET["OrderID"]);
  69. }
  70. $query_orderdetails = sprintf("SELECT ec_order.*, ec_orderdetail.*, ec_orderstatus.order_status, UNIX_TIMESTAMP(ec_order.order_date) AS orderdate_timestamp FROM ((ec_order LEFT JOIN ec_orderdetail ON ec_orderdetail.order_id = ec_order.order_id) LEFT JOIN ec_orderstatus ON ec_order.orderstatus_id = ec_orderstatus.status_id) WHERE ec_order.order_id = %s ORDER BY ec_orderdetail.product_id", GetSQLValueString($KTColParam1_orderdetails, "int"));
  71. $orderdetails = mysql_query($query_orderdetails) or die(mysql_error());
  72. $row_orderdetails = mysql_fetch_assoc($orderdetails);
  73. $totalRows_orderdetails = mysql_num_rows($orderdetails);
  74. $query_rsorderstatus = "SELECT * FROM ec_orderstatus";
  75. $rsorderstatus = mysql_query($query_rsorderstatus) or die(mysql_error());
  76. $row_rsorderstatus = mysql_fetch_assoc($rsorderstatus);
  77. $totalRows_rsorderstatus = mysql_num_rows($rsorderstatus);
  78. $query_settingsRS = "SELECT * FROM ec_setting";
  79. $settingsRS = mysql_query($query_settingsRS) or die(mysql_error());
  80. $row_settingsRS = mysql_fetch_assoc($settingsRS);
  81. $totalRows_settingsRS = mysql_num_rows($settingsRS);
  82. ?>
  83. <html>
  84. <head>
  85. <meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
  86. <title>Print Order</title>
  87. <style type="text/css">
  88. <!--
  89. .style1 {
  90. font-weight: bold
  91. }
  92. .style2 {
  93. color: #FF0000;
  94. font-weight: bold;
  95. }
  96. .style3 {
  97. color: #FF0000
  98. }
  99. .fontstyle {
  100. font-family: Arial, Helvetica, sans-serif;
  101. font-weight: normal;
  102. }
  103. .sizesmallfont {
  104. font-size: 11px;
  105. }
  106. .sizemediumfont {
  107. font-size: 14px;
  108. }
  109. -->
  110. </style>
  111. </head>
  112. <body>
  113. <table width="800" border="0" align="center" cellpadding="0" cellspacing="0">
  114. <tr class="fontstyle">
  115. <td height="125" colspan="3" bgcolor="#FFFFFF" class="tableheadingbg"><img src="<?php echo get_option( 'ec_option_email_logo' ); ?>"></td>
  116. </tr>
  117. <tr class="fontstyle">
  118. <td width="442" height="25" bgcolor="#CCCCCC" class="tableheadingbg"><div align="left">
  119. <input name="Print Order" type="submit" class="buttontext" id="Print Order" value="Print Order" onClick="window.print()">
  120. </div></td>
  121. <td width="140" bgcolor="#CCCCCC" class="tableheadingbg" style="font-weight: bold"><div align="right" class="sizemediumfont">Order Status:</div></td>
  122. <td width="218" align="right" bgcolor="#CCCCCC" class="sizemediumfont" style="font-weight: bold"><?php echo utf8_decode($row_orderdetails['order_status']); ?>&nbsp;&nbsp;</td>
  123. </tr>
  124. <tr>
  125. <td height="119" colspan="3"><span class="fontstyle"><!-- address billing/shipping information -->
  126. </span>
  127. <table width="800" border="0" align="center" cellpadding="0" cellspacing="0" class="KT_tngtable">
  128. <tr>
  129. <td width="400" class="style1"><div align="left"><span class="sizemediumfont"><span class="fontstyle"><strong>&nbsp;Shipping Information </strong></span></span></div></td>
  130. <td width="400" class="style1"><div align="left"><span class="sizemediumfont"><span class="fontstyle"><strong>Billing Information </strong></span></span></div></td>
  131. </tr>
  132. <?php
  133. // Show IF Conditional region8
  134. if (@$row_orderdetails['billing_address_line_1'] == "" && @$row_orderdetails['billing_city'] == ""&& @$row_orderdetails['billing_zip'] == "") {
  135. ?>
  136. <tr>
  137. <td colspan="2">&nbsp;</td>
  138. </tr>
  139. <?php
  140. // else Conditional region8
  141. } else { ?>
  142. <tr>
  143. <td width="400"><span class="sizesmallfont"><span class="fontstyle">&nbsp;<?php echo utf8_decode($row_orderdetails['shipping_first_name']); ?> <?php echo utf8_decode($row_orderdetails['shipping_last_name']); ?></span></span></td>
  144. <td width="400"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['billing_first_name']); ?> <?php echo utf8_decode($row_orderdetails['billing_last_name']); ?></span></span></div></td>
  145. </tr>
  146. <tr>
  147. <td width="400"><span class="sizesmallfont"><span class="fontstyle">&nbsp;<?php echo utf8_decode($row_orderdetails['shipping_address_line_1']); ?></span></span></td>
  148. <td width="400"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['billing_address_line_1']); ?></span></span></div></td>
  149. </tr>
  150. <tr>
  151. <td width="400"><span class="sizesmallfont"><span class="fontstyle">&nbsp;<?php echo utf8_decode($row_orderdetails['shipping_address_line_2']); ?></span></span></td>
  152. <td width="400"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['billing_address_line_2']); ?></span></span></div></td>
  153. </tr>
  154. <tr>
  155. <td width="400"><span class="sizesmallfont"><span class="fontstyle">&nbsp;<?php echo utf8_decode($row_orderdetails['shipping_city']); ?>, <?php echo utf8_decode($row_orderdetails['shipping_state']); ?> <?php echo utf8_decode($row_orderdetails['shipping_zip']); ?></span></span></td>
  156. <td width="400"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['billing_city']); ?>, <?php echo utf8_decode($row_orderdetails['billing_state']); ?> <?php echo utf8_decode($row_orderdetails['billing_zip']); ?></span></span></div></td>
  157. </tr>
  158. <tr>
  159. <td><span class="sizesmallfont"><span class="fontstyle">&nbsp;Country: <?php echo utf8_decode($row_orderdetails['shipping_country']); ?></span></span></td>
  160. <td><span class="sizesmallfont"><span class="fontstyle">Country: <?php echo utf8_decode($row_orderdetails['billing_country']); ?></span></span></td>
  161. </tr>
  162. <?php }
  163. // endif Conditional region8
  164. ?>
  165. <tr>
  166. <td width="400"><span class="sizesmallfont"><span class="fontstyle"><strong>&nbsp;Phone:</strong> <?php echo utf8_decode($row_orderdetails['shipping_phone']); ?></span></span></td>
  167. <td width="400"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><strong>Email:</strong>&nbsp; <a href="mailto:<?php echo utf8_decode($row_orderdetails['user_email']); ?>"><?php echo utf8_decode($row_orderdetails['user_email']); ?></a></span></span></div></td>
  168. </tr>
  169. </table></td>
  170. </tr>
  171. <tr>
  172. <td height="34" colspan="3" valign="top"><span class="fontstyle"><!-- order comments section table -->
  173. </span>
  174. <table width="800" border="0" align="center" cellpadding="0" cellspacing="0" class="KT_tngtable">
  175. <tr>
  176. <td width="121" class="sizemediumfont"><span class="fontstyle"><strong>&nbsp;Order Number:</strong> </span></td>
  177. <td width="134" class="sizesmallfont"><div align="left"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['order_id']); ?></span></div></td>
  178. <td width="148" class="sizesmallfont">&nbsp;</td>
  179. <td width="126" class="sizemediumfont"><div align="left"><span class="fontstyle"><strong>Order Date: </strong></span></div></td>
  180. <td width="271" class="sizesmallfont"><div align="left"><span class="fontstyle"><?php echo date('F j, Y',$row_orderdetails['orderdate_timestamp']); ?></span></div>
  181. <div align="left"></div></td>
  182. </tr>
  183. <tr>
  184. <td class="sizemediumfont"><span class="fontstyle"><strong>&nbsp;Coupon Code:</strong></span></td>
  185. <td colspan="2" class="sizesmallfont"><span class="fontstyle">
  186. <?php
  187. // Show IF Conditional region22
  188. if ($row_orderdetails['promo_code'] != '0' || $row_orderdetails['promo_code'] != '') {
  189. ?>
  190. <?php echo utf8_decode($row_orderdetails['promo_code']); ?>
  191. <?php
  192. // else Conditional region22
  193. } else { ?>
  194. NO COUPON CODE USED
  195. <?php }
  196. // endif Conditional region22
  197. ?>
  198. </span></td>
  199. <td class="sizemediumfont"><span class="fontstyle"><strong>Total Weight:</strong></span></td>
  200. <td class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['order_weight']); ?></span></td>
  201. </tr>
  202. <tr>
  203. <td colspan="5" class="sizemediumfont"> <span class="fontstyle"><strong>&nbsp;Customer Notes:</strong>&nbsp;&nbsp;<span class="sizesmallfont"><?php echo utf8_decode($row_orderdetails['order_customer_notes']); ?></span></span></td>
  204. </tr>
  205. <tr>
  206. <td colspan="5">&nbsp;</td>
  207. </tr>
  208. <tr>
  209. <td colspan="5">&nbsp;</td>
  210. </tr>
  211. </table></td>
  212. </tr>
  213. <tr>
  214. <td colspan="3"><span class="fontstyle"><!--Shipping table -->
  215. </span>
  216. <table width="800" border="0" align="center" cellpadding="0" cellspacing="0" class="tableheadingbg">
  217. <tr>
  218. <td width="180" bgcolor="#CCCCCC"><div align="left"><span class="sizemediumfont"><span class="fontstyle"><strong>&nbsp;ORDER DETAILS </strong></span></span></div></td>
  219. <td width="368" align="right" bgcolor="#CCCCCC"><div class="style2"></div>
  220. <span class="sizemediumfont"><span class="fontstyle"> Shipping Carrier:<br>
  221. Tracking Number:<br>
  222. Shipping Method:</span></span></td>
  223. <td width="252" align="right" bgcolor="#CCCCCC"><span class="sizemediumfont"><span class="fontstyle">
  224. <div class="style2">
  225. <?php echo utf8_decode($row_orderdetails['shipping_carrier']); ?>&nbsp;&nbsp;<br>
  226. <?php echo utf8_decode($row_orderdetails['tracking_number']); ?>&nbsp;&nbsp;<br>
  227. </span> </span>
  228. <div align="right"></div>
  229. <div align="right" class="style2"> <span class="sizemediumfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['shipping_method']); ?>&nbsp;&nbsp; </span></span></div></td>
  230. </tr>
  231. </table>
  232. <span class="fontstyle">
  233. <!--table headings -->
  234. </span>
  235. <table width="800" border="0" align="center" cellpadding="0" cellspacing="0" class="KT_tngtable">
  236. <tr>
  237. <td width="120"><div align="center"><span class="sizemediumfont"><span class="fontstyle"><strong>Quantity</strong></span></span></div></td>
  238. <td width="385"><span class="sizemediumfont"><span class="fontstyle"><strong>Item</strong></span></span></td>
  239. <td width="100"><div align="left"><span class="sizemediumfont"><span class="fontstyle"><strong>Model/SKU</strong></span></span></div></td>
  240. <td width="100"><div align="left"><span class="sizemediumfont"><span class="fontstyle"><strong>Ind. Price </strong></span></span></div></td>
  241. <td width="100"><div align="right"><span class="sizemediumfont"><span class="fontstyle"><strong>Total Price</strong></span></span></div></td>
  242. </tr>
  243. </table></td>
  244. </tr>
  245. <tr>
  246. <td colspan="3" valign="bottom"><span class="fontstyle">
  247. <?php
  248. $rows_orderdetails = 2;
  249. $cols_orderdetails = ceil($totalRows_orderdetails/ 2);
  250. for ($i=0; $i<$rows_orderdetails; $i++) {
  251. for ($j=0; $j<$cols_orderdetails; $j++) {
  252. $currentIndex_orderdetails = $i + $rows_orderdetails * $j;
  253. if (@mysql_data_seek($orderdetails, $currentIndex_orderdetails)) {
  254. $row_orderdetails = mysql_fetch_assoc($orderdetails); ?>
  255. <!-- order details if statements -->
  256. </span>
  257. <table border="0" cellpadding="0" cellspacing="0" class="KT_tngtable">
  258. <tr>
  259. <td height="30" width="120" valign="top" class="style1"><div align="center"><span class="sizesmallfont"><span class="fontstyle"><b><?php echo utf8_decode($row_orderdetails['quantity']); ?></b></span></span></div></td>
  260. <td width="385" valign="top" class="style1"><span class="sizesmallfont"><span class="fontstyle"><b><?php echo utf8_decode($row_orderdetails['title']); ?></b><br>
  261. </span> </span>
  262. <table width="240" border="0" align="center" cellpadding="0" cellspacing="0">
  263. <?php
  264. // Show IF Conditional option1area
  265. if (@$row_orderdetails['is_giftcard'] == 1 ) {
  266. ?>
  267. <tr>
  268. <td width="125" style="text-align: left"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><em>Gift Card Delivery: </em></span></span></div></td>
  269. <td><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['gift_card_delivery_method']); ?></span></span></td>
  270. </tr>
  271. <tr>
  272. <td width="125" style="text-align: left"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><em>Gift Card To: </em></span></span></div></td>
  273. <td><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['gift_card_to_name']); ?></span></span></td>
  274. </tr>
  275. <tr>
  276. <td width="125" style="text-align: left"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><em>Gift Card From: </em></span></span></div></td>
  277. <td><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['gift_card_from_name']); ?></span></span></td>
  278. </tr>
  279. <tr>
  280. <td width="125" valign="top" style="text-align: left"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><em>Gift Card Message: </em></span></span></div></td>
  281. <td><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['gift_card_message']); ?></span></span></td>
  282. </tr>
  283. <?php }
  284. // endif Conditional option1area
  285. ?>
  286. <?php
  287. // Show IF Conditional option1area
  288. $emptyvalue = '';
  289. $zerovalue = '0';
  290. if (@$row_orderdetails['optionitem_name_1'] != $emptyvalue && @$row_orderdetails['optionitem_name_1'] != $zerovalue) {
  291. ?>
  292. <tr>
  293. <td width="125" style="text-align: left"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><em>Option 1: </em></span></span></div></td>
  294. <td><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['optionitem_name_1']); ?></span></span></td>
  295. </tr>
  296. <?php }
  297. // endif Conditional option1area
  298. ?>
  299. <?php
  300. // Show IF Conditional region2
  301. $emptyvalue = '';
  302. $zerovalue = '0';
  303. if (@$row_orderdetails['optionitem_name_2'] != $emptyvalue && @$row_orderdetails['optionitem_name_2'] != $zerovalue) {
  304. ?>
  305. <tr>
  306. <td width="125" style="text-align: left"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><em>Option 2: </em></span></span></div></td>
  307. <td><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['optionitem_name_2']); ?></span></span></td>
  308. </tr>
  309. <?php }
  310. // endif Conditional region2
  311. ?>
  312. <?php
  313. // Show IF Conditional region3
  314. $emptyvalue = '';
  315. $zerovalue = '0';
  316. if (@$row_orderdetails['optionitem_name_3'] != $emptyvalue && @$row_orderdetails['optionitem_name_3'] != $zerovalue) {
  317. ?>
  318. <tr>
  319. <td width="125" style="text-align: left"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><em>Option 3: </em></span></span></div></td>
  320. <td><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['optionitem_name_3']); ?></span></span></td>
  321. </tr>
  322. <?php }
  323. // endif Conditional region3
  324. ?>
  325. <?php
  326. // Show IF Conditional region4
  327. $emptyvalue = '';
  328. $zerovalue = '0';
  329. if (@$row_orderdetails['optionitem_name_4'] != $emptyvalue && @$row_orderdetails['optionitem_name_4'] != $zerovalue) {
  330. ?>
  331. <tr>
  332. <td width="125" style="text-align: left"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><em>Option 4: </em></span></span></div></td>
  333. <td><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['optionitem_name_4']); ?></span></span></td>
  334. </tr>
  335. <?php }
  336. // endif Conditional region4
  337. ?>
  338. <?php
  339. // Show IF Conditional region5
  340. $emptyvalue = '';
  341. $zerovalue = '0';
  342. if (@$row_orderdetails['optionitem_name_5'] != $emptyvalue && @$row_orderdetails['optionitem_name_5'] != $zerovalue) {
  343. ?>
  344. <tr>
  345. <td width="125" style="text-align: left"><div align="left"><span class="sizesmallfont"><span class="fontstyle"><em>Option 5: </em></span></span></div></td>
  346. <td><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['optionitem_name_5']); ?></span></span></td>
  347. </tr>
  348. <?php }
  349. // endif Conditional region5
  350. ?>
  351. </table></td>
  352. <td width="100" valign="top"><div align="center"><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode($row_orderdetails['model_number']); ?>&nbsp;</span></span></div></td>
  353. <td width="100" valign="top"><div align="center"><span class="sizesmallfont"><span class="fontstyle"><?php echo utf8_decode(number_format($row_orderdetails['unit_price'], 2)); ?></span></span></div></td>
  354. <td width="100" valign="top"><div align="right"> <span class="sizesmallfont"><span class="fontstyle"><b><?php echo utf8_decode(number_format($row_orderdetails['total_price'], 2)); ?> </b></span></span></div></td>
  355. </tr>
  356. </table>
  357. <span class="fontstyle">
  358. <?php
  359. } else {
  360. echo '<td>&nbsp;</td>';
  361. } // end if;
  362. } //end for 2
  363. if ($i != $rows_orderdetails-1) {
  364. echo "";
  365. }
  366. } // end for 1
  367. ?>
  368. &nbsp;</span></td>
  369. </tr>
  370. <tr>
  371. <td colspan="3" align="right"><span class="fontstyle"><!--totals, shipping, taxes table -->
  372. </span>
  373. <table width="800" border="0" align="center" cellpadding="0" cellspacing="0" class="KT_tngtable">
  374. <tr>
  375. <td align="right" class="total"><div align="right"><span class="sizemediumfont"><span class="fontstyle"><strong>Sales Tax:</strong>&nbsp;</span></span></div></td>
  376. <td width="100" class="total"><div align="right"><span class="sizemediumfont"><span class="fontstyle"><?php echo utf8_decode(number_format($row_orderdetails['tax_total'], 2)); ?></span></span></div></td>
  377. </tr>
  378. <tr>
  379. <td align="right" class="total"><span class="sizemediumfont"><span class="fontstyle"><strong>Shipping:</strong>&nbsp;</span></span></td>
  380. <td width="100" class="total"><div align="right"><span class="sizemediumfont"><span class="fontstyle"><?php echo utf8_decode(number_format($row_orderdetails['shipping_total'], 2)); ?></span></span></div></td>
  381. </tr>
  382. <tr>
  383. <td align="right" class="total"><div align="left">
  384. <div align="right"><span class="sizemediumfont"><span class="fontstyle"><strong>Discounts Total:</strong>&nbsp;</span></span></div>
  385. </div></td>
  386. <td width="100" class="total"><div align="right"><span class="sizemediumfont"><span class="fontstyle"><?php echo utf8_decode(number_format($row_orderdetails['discount_total'], 2)); ?></span></span></div></td>
  387. </tr>
  388. <tr>
  389. <td align="right" class="total"><div align="left">
  390. <div align="right"><span class="sizemediumfont"><span class="fontstyle"><strong>Order Total:</strong>&nbsp;</span></span></div>
  391. </div></td>
  392. <td width="100" class="total"><div align="right"><span class="sizemediumfont"><span class="fontstyle"><?php echo utf8_decode(number_format($row_orderdetails['grand_total'], 2)); ?></span></span></div></td>
  393. </tr>
  394. </table></td>
  395. </tr>
  396. </table>
  397. </body>
  398. </html>
  399. <?php
  400. } else {
  401. echo "Not Authorized...";
  402. }
  403. mysql_free_result($orderdetails);
  404. mysql_free_result($rsorderstatus);
  405. mysql_free_result($settingsRS);
  406. ?>