PageRenderTime 79ms CodeModel.GetById 30ms RepoModel.GetById 1ms app.codeStats 1ms

/application/views/pages/admin/hksearch.php

https://bitbucket.org/chadsaun/ifrogz-panel
PHP | 2017 lines | 1777 code | 43 blank | 197 comment | 271 complexity | fad700ead043ed0546b9fdc9e42bec87 MD5 | raw file
    

  1. <?php
    2. 

  2. //This code is copyright (c) Internet Business Solutions SL, all rights reserved.
    3. 

  3. //The contents of this file are protect under law as the intellectual property of Internet
    4. 

  4. //Business Solutions SL. Any use, reproduction, disclosure or copying of any kind 
    5. 

  5. //without the express and written permission of Internet Business Solutions SL is forbidden.
    6. 

  6. //Author: Vince Reid, vince@virtualred.net
    7. 

  7. include('init.php');
    8. 

  8. include(APPPATH.'views/pages/admin/cartmisc.php');
    9. 

  9. include_once(IFZROOT.'kohana.php');
    10. 

  10. session_register('order_id_commas');
    11. 

  11. $lisuccess=0;
    12. 

  12. if(@$dateadjust=="") $dateadjust=0;
    13. 

  13. if(@$dateformatstr == "") $dateformatstr = "m/d/Y";
    14. 

  14. $admindatestr="Y-m-d";
    15. 

  15. if(@$admindateformat=="") $admindateformat=0;
    16. 

  16. if($admindateformat==1)
    17. 

  17. 	$admindatestr="m/d/Y";
    18. 

  18. elseif($admindateformat==2)
    19. 

  19. 	$admindatestr="d/m/Y";
    20. 

  20. if(@$storesessionvalue=="") $storesessionvalue="virtualstore".time();
    21. 

  21. $doedit=FALSE;
    22. 

  22. function editfunc($data,$col,$size){
    23. 

  23. 	global $doedit;
    24. 

  24. 	if($doedit) return('<input type="text" id="' . $col . '" name="' . $col . '" value="' . str_replace('"','&quot;',$data) . '" size="' . $size . '">'); else return($data);
    25. 

  25. }
    26. 

  26. function editnumeric($data,$col,$size){
    27. 

  27. 	global $doedit;
    28. 

  28. 	if($doedit) return('<input type="text" id="' . $col . '" name="' . $col . '" value="' . number_format($data,2,'.','') . '" size="' . $size . '">'); else return(FormatEuroCurrency($data));
    29. 

  29. }
    30. 

  30. if(@$_SESSION["loggedon"] != $storesessionvalue && trim(@$_COOKIE["WRITECKL"])!=""){
    31. 

  31. 	$config = RBI_Kohana::config('database.default_ifrogz');
    32. 

  32. 	$config = $config['connection'];
    33. 

  33. 	$db=mysql_connect($config['hostname'], $config['username'], $config['password']);
    34. 

  34. 	mysql_select_db($config['database']) or die ('RBI connection failed.</td></tr></table></body></html>');
    35. 

  35. 	$rbiSQL = 'SELECT * 
    36. 

  36. 			   FROM employee 
    37. 

  37. 			   WHERE username="'.mysql_real_escape_string(unstripslashes(trim(@$_COOKIE["WRITECKL"]))).'" and password="'.mysql_real_escape_string(unstripslashes(trim(@$_COOKIE["WRITECKP"]))).'"';
    38. 

  38. 	$rs_rbi = mysql_query($rbiSQL);
    39. 

  39. 	if(mysql_num_rows($rs_rbi) > 0) {
    40. 

  40. 		@$_SESSION["loggedon"] = $storesessionvalue;
    41. 

  41. 	}else{
    42. 

  42. 		$lisuccess=2;
    43. 

  43. 	}
    44. 

  44. 	mysql_free_result($rs_rbi);
    45. 

  45. 

  46. 	include(APPPATH.'views/partials/admin/dbconnection.php');
    47. 

  47. }
    48. 

  48. if(($_SESSION["loggedon"] != $storesessionvalue && $lisuccess!=2) || @$disallowlogin==TRUE) exit();
    49. 

  49. if($lisuccess==2){
    50. 

  50. ?>
    51. 

  51. 	  <table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="" align="center">
    52. 

  52.         <tr>
    53. 

  53.           <td width="100%">
    54. 

  54.             <table width="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="">
    55. 

  55. 			  <tr> 
    56. 

  56.                 <td width="100%" colspan="4" align="center"><p>&nbsp;</p><p>&nbsp;</p>
    57. 

  57. 				  <p><strong><?php print $yyOpFai?></strong></p><p>&nbsp;</p>
    58. 

  58. 				  <p><?php print $yyCorCoo?> <?php print $yyCorLI?> <a href="/admin/login.php"><?php print $yyClkHer?></a>.</p>
    59. 

  59. 				</td>
    60. 

  60. 			  </tr>
    61. 

  61. 			</table>
    62. 

  62. 		  </td>
    63. 

  63. 		</tr>
    64. 

  64. 	  </table>
    65. 

  65. <?php
    66. 

  66. }else{
    67. 

  67. $success=true;
    68. 

  68. $alreadygotadmin = getadminsettings();
    69. 

  69. if(@$_GET["id"] != ""){
    70. 

  70. 	$sSQL = "SELECT cartProdId,cartProdName,cartProdPrice,cartQuantity,cartID FROM cart WHERE cartOrderID=" . $_GET["id"];
    71. 

  71. 	$allorders = mysql_query($sSQL) or print(mysql_error());
    72. 

  72. }
    73. 

  73. 

  74. $numstatus=0;
    75. 

  75. $sSQL = "SELECT statID,statPrivate FROM orderstatus WHERE statPrivate<>'' ORDER BY statID";
    76. 

  76. $result = mysql_query($sSQL) or print(mysql_error());
    77. 

  77. while($rs = mysql_fetch_assoc($result)){
    78. 

  78. 	$allstatus[$numstatus++]=$rs;
    79. 

  79. }
    80. 

  80. mysql_free_result($result);
    81. 

  81. 

  82. if(@$_GET["id"] != ""){
    83. 

  83. 	$statetaxrate=0;
    84. 

  84. 	$countrytaxrate=0;
    85. 

  85. 	$hsttaxrate=0;
    86. 

  86. 	$countryorder=0;
    87. 

  87. 	$sSQL = "SELECT ordID,ordName,ordAddress,ordAddress2,ordCity,ordState,ordZip,ordCountry,ordEmail,ordPhone,ordShipName,ordShipAddress,ordShipAddress2,ordShipCity,ordShipState,ordShipZip,ordShipCountry,ordPayProvider,ordAuthNumber,ordTransID,ordTotal,ordDate,ordStateTax,ordCountryTax,ordHSTTax,ordShipping,ordShipType,ordIP,ordAffiliate,ordDiscount,ordHandling,ordDiscountText,ordComLoc,ordExtra1,ordExtra2,ordAddInfo,ordCNum,ordStatusInfo,ordSupportInfo,order_changed,ordStatus,ord_cert_amt,ord_cert_id,ordPoApo,ordShipPoApo,ordEID FROM orders LEFT JOIN payprovider ON payprovider.payProvID=orders.ordPayProvider WHERE ordID='" . $_GET["id"] . "'
    88. 

  88. AND ordEID!=34";
    89. 

  89. 	$result = mysql_query($sSQL) or print(mysql_error());
    90. 

  90. 	$alldata = mysql_fetch_array($result);
    91. 

  91. 	$alldata["ordDate"] = strtotime($alldata["ordDate"]);
    92. 

  92. 	mysql_free_result($result);
    93. 

  93. 	if($doedit){
    94. 

  94. 		print '<form method="post" name="editform" action="/admin/orders.php" onsubmit="return confirmedit()"><input type="hidden" name="orderid" value="' . $_GET["id"] . '" /><input type="hidden" name="doedit" value="true" />';
    95. 

  95. 		$overridecurrency=TRUE;
    96. 

  96. 		$orcsymbol="";
    97. 

  97. 		$orcdecplaces=2;
    98. 

  98. 		$orcpreamount=TRUE;
    99. 

  99. 		$orcdecimals=".";
    100. 

  100. 		$orcthousands="";
    101. 

  101. 	}
    102. 

  102. ?>
    103. 

  103. <script language="JavaScript" type="text/javascript" src="http://assets.ifrogz.com/lib/packages/scriptaculous-js/1.5.1/prototype.js"></script>
    104. 

  104. <script language="JavaScript" type="text/javascript" src="http://assets.ifrogz.com/lib/packages/scriptaculous-js/1.5.1/scriptaculous.js"></script>
    105. 

  105. <script language="JavaScript" type="text/javascript">
    106. 

  106. <!--
    107. 

  107. var newwin="";
    108. 

  108. var plinecnt=0;
    109. 

  109. function openemailpopup(id) {
    110. 

  110.   popupWin = window.open('/admin/popupemail.php?'+id,'emailpopup','menubar=no, scrollbars=no, width=300, height=250, directories=no,location=no,resizable=yes,status=no,toolbar=no')
    111. 

  111. }
    112. 

  112. function updateoptions(id){
    113. 

  113. 	prodid = document.getElementById('prodid'+id).value;
    114. 

  114. 	if(prodid != ''){
    115. 

  115. 		newwin = window.open('/admin/popupemail.php?prod='+prodid+'&index='+id,'updateopts','menubar=no, scrollbars=no, width=50, height=40, directories=no,location=no,resizable=yes,status=no,toolbar=no');
    116. 

  116. 	}
    117. 

  117. 	return(false);
    118. 

  118. }
    119. 

  119. function extraproduct(plusminus){
    120. 

  120. var productspan=document.getElementById('productspan');
    121. 

  121. if(plusminus=='+'){
    122. 

  122. productspan.innerHTML=productspan.innerHTML.replace(/<!--NEXTPRODUCTCOMMENT-->/,'<!--PLINE'+plinecnt+'--><tr><td valign="top"><input type="button" value="..." onclick="updateoptions('+(plinecnt+1000)+')">&nbsp;<input name="prodid'+(plinecnt+1000)+'" size="18" id="prodid'+(plinecnt+1000)+'"></td><td valign="top"><input type="text" id="prodname'+(plinecnt+1000)+'" name="prodname'+(plinecnt+1000)+'" size="24"></td><td><span id="optionsspan'+(plinecnt+1000)+'">-</span></td><td valign="top"><input type="text" id="quant'+(plinecnt+1000)+'" name="quant'+(plinecnt+1000)+'" size="5" value="1"></td><td valign="top"><input type="text" id="price'+(plinecnt+1000)+'" name="price'+(plinecnt+1000)+'" value="0" size="7"><br /><input type="hidden" id="optdiffspan'+(plinecnt+1000)+'" value="0"></td><td>&nbsp;</td></tr><!--PLINEEND'+plinecnt+'--><!--NEXTPRODUCTCOMMENT-->');
    123. 

  123. plinecnt++;
    124. 

  124. }else{
    125. 

  125. if(plinecnt>0){
    126. 

  126. plinecnt--;
    127. 

  127. var restr = '<!--PLINE'+plinecnt+'-->(.|\\n)+<!--PLINEEND'+plinecnt+'-->';
    128. 

  128. //alert(restr);
    129. 

  129. var re = new RegExp(restr);
    130. 

  130. productspan.innerHTML=productspan.innerHTML.replace(re,'');
    131. 

  131. }
    132. 

  132. }
    133. 

  133. }
    134. 

  134. function confirmedit(){
    135. 

  135. 	if(updateClicked) {
    136. 

  136. 		if(confirm('<?php print str_replace("'","\'",$yyChkRec)?>'))
    137. 

  137. 			return(true);
    138. 

  138. 		return(false);
    139. 

  139. 	}
    140. 

  140. 	if(cloneClicked) {
    141. 

  141. 		if(confirm('Are you sure you want to clone this order?'))
    142. 

  142. 			return(true);
    143. 

  143. 		return(false);
    144. 

  144. 	}
    145. 

  145. }
    146. 

  146. 

  147. 

  148. function checkAIM(frm) {
    149. 

  149. 	if(frm.aim_type.selectedIndex==0) {
    150. 

  150. 		alert("Please choose a transaction type.");
    151. 

  151. 		frm.aim_type.focus();
    152. 

  152. 		return false;
    153. 

  153. 	}else if(frm.aim_txn=='') {
    154. 

  154. 		alert("A transaction number is required.");
    155. 

  155. 		frm.aim_txn.focus();
    156. 

  156. 		return false;
    157. 

  157. 	}else if(frm.aim_amt=='') {
    158. 

  158. 		alert("Please enter an amount.");
    159. 

  159. 		frm.aim_amt.focus();
    160. 

  160. 		return false;
    161. 

  161. 	}
    162. 

  162. 	
    163. 

  163. 	return true;
    164. 

  164. }
    165. 

  165. 

  166. function toggleTXN() {
    167. 

  167. 	if($('div_trans').style.display=='' || $('div_trans').style.display==undefined) {
    168. 

  168. 		//$('div_trans').style.display = 'none';
    169. 

  169. 		Effect.BlindUp('div_trans');
    170. 

  170. 		$('btn_add_txn').value = 'Credit or Void';
    171. 

  171. 	}else if($('div_trans').style.display=='none') {
    172. 

  172. 		//$('div_trans').style.display = '';
    173. 

  173. 		Effect.BlindDown('div_trans');
    174. 

  174. 		$('btn_add_txn').value = 'Hide Credit or Void';
    175. 

  175. 	}
    176. 

  176. }
    177. 

  177. 

  178. function toggleCharge() {
    179. 

  179. 	if($('div_charge').style.display=='' || $('div_charge').style.display==undefined) {
    180. 

  180. 		//$('div_charge').style.display = 'none';
    181. 

  181. 		Effect.BlindUp('div_charge');
    182. 

  182. 		$('btn_charge').value = 'Charge CC';
    183. 

  183. 	}else if($('div_charge').style.display=='none') {
    184. 

  184. 		//$('div_charge').style.display = '';
    185. 

  185. 		Effect.BlindDown('div_charge');
    186. 

  186. 		$('btn_charge').value = 'Hide Charge CC';
    187. 

  187. 	}
    188. 

  188. }
    189. 

  189. 

  190. function togglePrcAdd() {
    191. 

  191. 	if($('div_prc_add').style.display=='' || $('div_prc_add').style.display==undefined) {
    192. 

  192. 		//$('div_charge').style.display = 'none';
    193. 

  193. 		Effect.BlindUp('div_prc_add');
    194. 

  194. 		$('btn_prc_add').value = 'Add Price Adjustment';
    195. 

  195. 	}else if($('div_prc_add').style.display=='none') {
    196. 

  196. 		//$('div_charge').style.display = '';
    197. 

  197. 		Effect.BlindDown('div_prc_add');
    198. 

  198. 		$('btn_prc_add').value = 'Hide Price Adjustment';
    199. 

  199. 	}
    200. 

  200. }
    201. 

  201. 

  202. //-->
    203. 

  203. </script>
    204. 

  204. <style type="text/css">
    205. 

  205. a img{
    206. 

  206. 	border: 0;
    207. 

  207. }
    208. 

  208. </style>
    209. 

  209. <span id="productspan">
    210. 

  210. <table width="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="">
    211. 

  211.             <?php		if($isprinter && @$invoiceheader != ""){ ?>
    212. 

  212.             <tr>
    213. 

  213.               <td colspan="6"><?php print $invoiceheader?></td>
    214. 

  214.             </tr>
    215. 

  215.             <?php		} ?>
    216. 

  216.             <tr 	<? if(!empty($alldata["ordEID"])) echo 'bgcolor="#FA6561"'?>>
    217. 

  217.               <td colspan="6" align="center"><strong><?php print $xxOrdNum . " " . $alldata["ordID"] . "<br /><br />" . date($dateformatstr, $alldata["ordDate"]) . " " . date("H:i", $alldata["ordDate"])?></strong></td>
    218. 

  218.             </tr>
    219. 

  219.             <?php		if($isprinter && @$invoiceaddress != ""){ ?>
    220. 

  220.             <tr>
    221. 

  221.               <td colspan="6"><?php print $invoiceaddress?></td>
    222. 

  222.             </tr>
    223. 

  223.             <?php		} ?>
    224. 

  224.             <?php		if(trim(@$extraorderfield1)!=""){ ?>
    225. 

  225.             <tr>
    226. 

  226.               <td width="23%" align="right"><strong><?php print $extraorderfield1 ?>:</strong></td>
    227. 

  227.               <td align="left" colspan="5"><?php print editfunc($alldata["ordExtra1"],"ordextra1",25)?></td>
    228. 

  228.             </tr>
    229. 

  229.             <?php		} ?>
    230. 

  230.             <tr>
    231. 

  231.               <td width="23%" align="right"><strong><?php print $xxName?>:</strong></td>
    232. 

  232.               <td colspan="3" align="left"><?php print editfunc($alldata["ordName"],"name",25)?></td>
    233. 

  233.               <td width="25%" align="right">
    234. 

  234.                   <strong><?php print $xxEmail?>:</strong></td>
    235. 

  235.               <td width="24%" align="left"><?php
    236. 

  236. 				if($isprinter || $doedit) print editfunc($alldata["ordEmail"],"email",25); else print '<a href="mailto:' . $alldata["ordEmail"] . '">' . $alldata["ordEmail"] . '</a>';?></td>
    237. 

  237.             </tr>
    238. 

  238.             <tr>
    239. 

  239.               <td align="right"><strong><?php print $xxAddress?>:</strong></td>
    240. 

  240.               <td colspan="3" align="left"<?php if(@$useaddressline2==TRUE) print ' colspan="3"'?>><?php print editfunc($alldata["ordAddress"],"address",25)?></td>
    241. 

  241.               <?php	if(@$useaddressline2==TRUE){ ?>
    242. 

  242.             </tr>
    243. 

  243.             <tr>
    244. 

  244.               <td align="right"><strong><?php print $xxAddress2?>:</strong></td>
    245. 

  245.               <td colspan="3" align="left"><?php print editfunc($alldata["ordAddress2"],"address2",25)?></td>
    246. 

  246.               <?php	} ?>
    247. 

  247.               <td align="right"><strong><?php print $xxCity?>:</strong></td>
    248. 

  248.               <td align="left"><?php print editfunc($alldata["ordCity"],"city",25)?></td>
    249. 

  249.             </tr>
    250. 

  250.             <tr>
    251. 

  251.               <td align="right"><strong><?php print $xxAllSta?>:</strong></td>
    252. 

  252.               <td align="left"><?php print editfunc($alldata["ordState"],"state",25)?></td>
    253. 

  253.               <td align="right"><strong>APO/PO:</strong></td>
    254. 

  254.               <td align="left"><input <?php if (!(strcmp($alldata["ordPoApo"],1))) {echo "checked=\"checked\"";} ?> <? if($doedit) echo ''; else echo 'disabled="disabled"'; ?> name="APO" type="checkbox" value="1" /></td>
    255. 

  255.               <td align="right"><strong><?php print $xxCountry?>:</strong></td>
    256. 

  256.               <td align="left"><?php
    257. 

  257. 			if($doedit){
    258. 

  258. 				$foundmatch=FALSE;
    259. 

  259. 				print '<select name="country" size="1">';
    260. 

  260. 				$sSQL = "SELECT countryName,countryTax,countryOrder FROM countries ORDER BY countryOrder DESC, countryName";
    261. 

  261. 				$result = mysql_query($sSQL) or print(mysql_error());
    262. 

  262. 				while($rs2 = mysql_fetch_array($result)){
    263. 

  263. 					print '<option value="' . str_replace('"','&quot;',$rs2["countryName"]) . '"';
    264. 

  264. 					if($alldata["ordCountry"]==$rs2["countryName"]){
    265. 

  265. 						print ' selected';
    266. 

  266. 						$foundmatch=TRUE;
    267. 

  267. 						$countrytaxrate=$rs2["countryTax"];
    268. 

  268. 						$countryorder=$rs2["countryOrder"];
    269. 

  269. 					}
    270. 

  270. 					print '>' . $rs2["countryName"] . "</option>\r\n";			}
    271. 

  271. 				mysql_free_result($result);
    272. 

  272. 				if(! $foundmatch) print '<option value="' . str_replace('"','&quot;',$alldata["ordCountry"]) . '" selected>' . $alldata["ordCountry"] . "</option>\r\n";
    273. 

  273. 				print '</select>';
    274. 

  274. 				if($countryorder==2){
    275. 

  275. 					$sSQL = "SELECT stateTax FROM states WHERE stateAbbrev='" . mysql_real_escape_string($alldata["ordState"]) . "'";
    276. 

  276. 					$result = mysql_query($sSQL) or print(mysql_error());
    277. 

  277. 					if($rs2 = mysql_fetch_array($result))
    278. 

  278. 						$statetaxrate = $rs2["stateTax"];
    279. 

  279. 				}
    280. 

  280. 				if($alldata["ordStateTax"]==0)$statetaxrate=0; 
    281. 

  281. 			}else
    282. 

  282. 				print $alldata["ordCountry"];?></td>
    283. 

  283.             </tr>
    284. 

  284.             <tr>
    285. 

  285.               <td align="right"><strong><?php print $xxZip?>:</strong></td>
    286. 

  286.               <td colspan="3" align="left"><?php print editfunc($alldata["ordZip"],"zip",15)?></td>
    287. 

  287.               <td align="right"><strong><?php print $xxPhone?>:</strong></td>
    288. 

  288.               <td align="left"><?php print editfunc($alldata["ordPhone"],"phone",25)?></td>
    289. 

  289.             </tr>
    290. 

  290.             <?php if(trim(@$extraorderfield2)!=""){ ?>
    291. 

  291.             <tr>
    292. 

  292.               <td align="right"><strong><?php print @$extraorderfield2 ?>:</strong></td>
    293. 

  293.               <td align="left" colspan="5"><?php print editfunc($alldata["ordExtra2"],"ordextra2",25)?></td>
    294. 

  294.             </tr>
    295. 

  295.             <?php } ?>
    296. 

  296.             <?php if(! $isprinter){ ?>
    297. 

  297.             <tr>
    298. 

  298.               <td align="right"><strong>IP Address:</strong></td>
    299. 

  299.               <td colspan="3" align="left"><?php print editfunc($alldata["ordIP"],"ipaddress",15)?></td>
    300. 

  300.               <td align="right"><strong><?php print $yyAffili?>:</strong></td>
    301. 

  301.               <td align="left"><?php print editfunc($alldata["ordAffiliate"],"PARTNER",15)?></td>
    302. 

  302.             </tr>
    303. 

  303.             <?php }
    304. 

  304. 	  if(trim($alldata["ordDiscountText"])!=""){ ?>
    305. 

  305.             <tr>
    306. 

  306.               <td align="right" valign="top"><strong><?php print $xxAppDs?>:</strong></td>
    307. 

  307.               <td align="left" colspan="5"><?php print editfunc($alldata["ordDiscountText"],"discounttext",25)?></td>
    308. 

  308.             </tr>
    309. 

  309.             <?php }
    310. 

  310. 	  if(trim($alldata["ordShipName"]) != "" || trim($alldata["ordShipAddress"]) != "" || trim($alldata["ordShipCity"]) != "" || $doedit){ ?>
    311. 

  311.             <tr>
    312. 

  312.               <td align="center" colspan="6"><strong><?php print $xxShpDet?>.</strong></td>
    313. 

  313.             </tr>
    314. 

  314.             <tr>
    315. 

  315.               <td align="right"><strong><?php print $xxName?>:</strong></td>
    316. 

  316.               <td align="left" colspan="5"><?php print editfunc($alldata["ordShipName"],"sname",25)?></td>
    317. 

  317.             </tr>
    318. 

  318.             <tr>
    319. 

  319.               <td align="right"><strong><?php print $xxAddress?>:</strong></td>
    320. 

  320.               <td colspan="3" align="left"<?php if(@$useaddressline2==TRUE) print ' colspan="3"'?>><?php print editfunc($alldata["ordShipAddress"],"saddress",25)?></td>
    321. 

  321.               <?php	if(@$useaddressline2==TRUE){ ?>
    322. 

  322.             </tr>
    323. 

  323.             <tr>
    324. 

  324.               <td align="right"><strong><?php print $xxAddress2?>:</strong></td>
    325. 

  325.               <td colspan="3" align="left"><?php print editfunc($alldata["ordShipAddress2"],"saddress2",25)?></td>
    326. 

  326.               <?php	} ?>
    327. 

  327.               <td align="right"><strong><?php print $xxCity?>:</strong></td>
    328. 

  328.               <td align="left"><?php print editfunc($alldata["ordShipCity"],"scity",25)?></td>
    329. 

  329.             </tr>
    330. 

  330.             <tr>
    331. 

  331.               <td align="right"><strong><?php print $xxAllSta?>:</strong></td>
    332. 

  332.               <td align="left"><?php print editfunc($alldata["ordShipState"],"sstate",25)?></td>
    333. 

  333.               <td align="right"><strong>APO/PO:</strong></td>
    334. 

  334.               <td align="left"><input name="ShipAPO" type="checkbox" id="ShipAPO" value="1" <?php if (!(strcmp($alldata["ordShipPoApo"],1))) {echo "checked=\"checked\"";} ?> <? if($doedit) echo ''; else echo 'disabled="disabled"'; ?>></td>
    335. 

  335.               <td align="right"><strong><?php print $xxCountry?>:</strong></td>
    336. 

  336.               <td align="left"><?php
    337. 

  337. 			if($doedit){
    338. 

  338. 				if(trim($alldata["ordShipName"]) != "" || trim($alldata["ordShipAddress"]) != "") $usingshipcountry=TRUE; else $usingshipcountry=FALSE;
    339. 

  339. 				$foundmatch=FALSE;
    340. 

  340. 				print '<select name="scountry" size="1">';
    341. 

  341. 				$sSQL = "SELECT countryName,countryTax,countryOrder FROM countries ORDER BY countryOrder DESC, countryName";
    342. 

  342. 				$result = mysql_query($sSQL) or print(mysql_error());
    343. 

  343. 				while($rs2 = mysql_fetch_array($result)){
    344. 

  344. 					print '<option value="' . str_replace('"','&quot;',$rs2["countryName"]) . '"';
    345. 

  345. 					if($alldata["ordShipCountry"]==$rs2["countryName"]){
    346. 

  346. 						print ' selected';
    347. 

  347. 						$foundmatch=TRUE;
    348. 

  348. 						if($usingshipcountry) $countrytaxrate=$rs2["countryTax"];
    349. 

  349. 						$countryorder=$rs2["countryOrder"];
    350. 

  350. 					}
    351. 

  351. 					print '>' . $rs2["countryName"] . "</option>\r\n";			}
    352. 

  352. 				mysql_free_result($result);
    353. 

  353. 				if(! $foundmatch) print '<option value="' . str_replace('"','&quot;',$alldata["ordShipCountry"]) . '" selected>' . $alldata["ordShipCountry"] . "</option>\r\n";
    354. 

  354. 				print '</select>';
    355. 

  355. 				if($countryorder==2 && $usingshipcountry){
    356. 

  356. 					$sSQL = "SELECT stateTax FROM states WHERE stateName='" . mysql_real_escape_string($alldata["ordShipState"]) . "'";
    357. 

  357. 					$result = mysql_query($sSQL) or print(mysql_error());
    358. 

  358. 					if($rs2 = mysql_fetch_array($result))
    359. 

  359. 						$statetaxrate = $rs2["stateTax"];
    360. 

  360. 				}
    361. 

  361. 			}else
    362. 

  362. 				print $alldata["ordShipCountry"]?></td>
    363. 

  363.             </tr>
    364. 

  364.             <tr>
    365. 

  365.               <td align="right"><strong><?php print $xxZip?>:</strong></td>
    366. 

  366.               <td align="left" colspan="5"><?php print editfunc($alldata["ordShipZip"],"szip",15)?></td>
    367. 

  367.             </tr>
    368. 

  368.             <?php }
    369. 

  369. 	  if($alldata["ordShipType"] != "" || $alldata["ordComLoc"]>0 || $doedit){ ?>
    370. 

  370.             <tr>
    371. 

  371.               <td align="right"><strong><?php print $xxShpMet?>:</strong></td>
    372. 

  372.               <td colspan="3" align="left"><?php 
    373. 

  373. 			    if($doedit && $alldata["ordStatus"]<=3){
    374. 

  374. 					print editfunc($alldata["ordShipType"],"shipmethod",25);?>
    375. 

  375.                   <a href="javascript:void(0);" onclick="$('shipmethod').value='Standard';">Standard</a> <a href="javascript:void(0);" onclick="$('shipmethod').value='FedEx Express';">FedEx</a> <a href="javascript:void(0);" onclick="$('shipmethod').value='International';">Int</a>
    376. 

  376.                   <? }else{
    377. 

  377. 					echo $alldata["ordShipType"].'<input type="hidden" name="shipmethod" value="'.$alldata["ordShipType"].'" />';
    378. 

  378. 				}
    379. 

  379. 				if(! $doedit && ($alldata["ordComLoc"]&2)==2) print $xxWtIns?>
    380. 

  380.               </td>
    381. 

  381.               <td align="right"><strong><?php print $xxCLoc?>:</strong></td>
    382. 

  382.               <td align="left"><?php	if($doedit){
    383. 

  383. 											print '<select name="commercialloc" size="1">';
    384. 

  384. 											print '<option value="N">' . $yyNo . '</option>';
    385. 

  385. 											print '<option value="Y"' . (($alldata["ordComLoc"]&1)==1 ? ' selected' : '') . '>' . $yyYes . '</option>';
    386. 

  386. 											print '</select>';
    387. 

  387. 										}else{
    388. 

  388. 											if(($alldata["ordComLoc"]&1)==1) print $yyYes; else print $yyNo;
    389. 

  389. 										}?></td>
    390. 

  390.             </tr>
    391. 

  391.             <?php	if($doedit){ ?>
    392. 

  392.             <tr>
    393. 

  393.               <td align="right"><strong><?php print $xxShpIns?>:</strong></td>
    394. 

  394.               <td align="left" colspan="5"><?php
    395. 

  395. 										print '<select name="wantinsurance" size="1">';
    396. 

  396. 										print '<option value="N">' . $yyNo . '</option>';
    397. 

  397. 										print '<option value="Y"' . (($alldata["ordComLoc"]&2)==2 ? ' selected' : '') . '>' . $yyYes . '</option>';
    398. 

  398. 										print '</select>';
    399. 

  399. 			?></td>
    400. 

  400.             </tr>
    401. 

  401.             <?php	}
    402. 

  402. 	  }
    403. 

  403. 		$ordAuthNumber = trim($alldata["ordAuthNumber"]);
    404. 

  404. 		$ordTransID = trim($alldata["ordTransID"]);
    405. 

  405. 		if(! $isprinter && ($ordAuthNumber != "" || $ordTransID != "" || $doedit)){ ?>
    406. 

  406.             <tr>
    407. 

  407.               <td align="right"><strong><?php print $yyAutCod?>:</strong></td>
    408. 

  408.               <td colspan="3" align="left"><?php print editfunc($ordAuthNumber,"ordAuthNumber",15) ?></td>
    409. 

  409.               <td align="right"><strong><?php print $yyTranID?>:</strong></td>
    410. 

  410.               <td align="left"><?php print editfunc($ordTransID,"ordTransID",15) ?></td>
    411. 

  411.             </tr>
    412. 

  412.             <?php	}
    413. 

  413. 

  414. 		// BOL#s ADDED BY CHAD JUL 27,06
    415. 

  415. 		$sql_bol = "SELECT * FROM bol WHERE ordID = " . $alldata["ordID"];
    416. 

  416. 		$res_bol = mysql_query($sql_bol) or print(mysql_error());
    417. 

  417. 		if(mysql_num_rows($res_bol) > 0) {
    418. 

  418. 			$row_bol = mysql_fetch_assoc($res_bol);
    419. 

  419. ?>
    420. 

  420.             <tr>
    421. 

  421.               <td align="right"><strong>Express BOL#:</strong></td>
    422. 

  422.               <td colspan="3"><?=$row_bol['exBOL']?></td>
    423. 

  423.               <?php
    424. 

  424. 			if(!empty($row_bol['smBOL'])) {
    425. 

  425. ?>
    426. 

  426.               <td align="right"><strong>Smart Mail BOL#:</strong></td>
    427. 

  427.               <td><?=$row_bol['smBOL']?></td>
    428. 

  428.               <?php
    429. 

  429. 			}
    430. 

  430. 			if(!empty($row_bol['gmBOL'])) {
    431. 

  431. ?>
    432. 

  432.               <td align="right"><strong>Global Mail BOL#:</strong></td>
    433. 

  433.               <td><?=$row_bol['gmBOL']?></td>
    434. 

  434.               <?php
    435. 

  435. 			}
    436. 

  436. ?>
    437. 

  437.             </tr>
    438. 

  438.             <?php
    439. 

  439. 		}
    440. 

  440. 		// ADD ENDED
    441. 

  441. 

  442. 		$ordAddInfo = Trim($alldata["ordAddInfo"]);
    443. 

  443. 		if($ordAddInfo != "" || $doedit){ ?>
    444. 

  444.             <tr>
    445. 

  445.               <td align="right" valign="top"><strong><?php print $xxAddInf?>:</strong></td>
    446. 

  446.               <td align="left" colspan="5"><?php
    447. 

  447. 			if($doedit)
    448. 

  448. 				print '<textarea name="ordAddInfo" cols="50" rows="4" wrap=virtual>' . $ordAddInfo . '</textarea>';
    449. 

  449. 			else
    450. 

  450. 				print str_replace(array("\r\n","\n"),array("<br />","<br />"),$ordAddInfo); ?></td>
    451. 

  451.             </tr>
    452. 

  452.             <?php	}
    453. 

  453. if(! $isprinter){
    454. 

  454. 		if(! $doedit) print '<form method="post" action="/admin/orders.php"><input type="hidden" name="updatestatus" value="1" /><input type="hidden" name="orderid" value="' . @$_GET["id"] . '" />';
    455. 

  455. ?>
    456. 

  456.             <tr>
    457. 

  457.               <td align="right" valign="top"><strong><?php print $yyStaInf?>:</strong></td>
    458. 

  458.               <td align="left" colspan="5"><textarea name="ordStatusInfo" cols="50" rows="4" wrap="virtual"><?php print $alldata["ordStatusInfo"]?></textarea>
    459. 

  459.                   <?php if(! $doedit) print '<input type="submit" value="' . $yyUpdate . '" />'?></td>
    460. 

  460.             </tr>
    461. 

  461.             <? if($doedit) { ?>
    462. 

  462.             <tr>
    463. 

  463.               <td align="right" valign="top"><strong><?php print $yySupInf?>:</strong></td>
    464. 

  464.               <td align="left" colspan="5"><textarea name="ordSupportInfo" cols="50" rows="4" wrap="virtual"><?php print $alldata["ordSupportInfo"]?></textarea>
    465. 

  465.                   <?php if(! $doedit) print '<input type="submit" value="' . $yyUpdate . '" />'?></td>
    466. 

  466.             </tr>
    467. 

  467.             <? } ?>
    468. 

  468.             <?php	if(($alldata["ordPayProvider"]==3 || $alldata["ordPayProvider"]==13) && $alldata["ordAuthNumber"] != ""){ ?>
    469. 

  469.             <!--<tr>
    470. 

  470. 			  <td align="center" colspan="6">
    471. 

  471. 				<input type="button" value="Capture Funds" onclick="javascript:openemailpopup('oid=<?php print $alldata["ordID"]?>')" />			  </td>
    472. 

  472. 			</tr>-->
    473. 

  473.             <?php	}
    474. 

  474. 		if(! $doedit) print '</form>';
    475. 

  475. 	if((int)$alldata["ordPayProvider"]==10){ ?>
    476. 

  476.             <tr>
    477. 

  477.               <td align="center" colspan="6"><hr width="50%" />
    478. 

  478.               </td>
    479. 

  479.             </tr>
    480. 

  480.             <?php	if(@$_SERVER["HTTPS"] != "on" && (@$_SERVER["SERVER_PORT"] != "443") && @$nochecksslserver != TRUE){ ?>
    481. 

  481.             <tr>
    482. 

  482.               <td align="center" colspan="6"><strong><font color="#FF0000">You do not appear to be viewing this page on a secure (https) connection. Credit card information cannot be shown.</font></strong></td>
    483. 

  483.             </tr>
    484. 

  484.             <?php	}else{
    485. 

  485. 			$ordCNum = $alldata["ordCNum"];
    486. 

  486. 			if($ordCNum != ""){
    487. 

  487. 				$cnumarr = "";
    488. 

  488. 				$encryptmethod = strtolower(@$encryptmethod);
    489. 

  489. 				if($encryptmethod=="none"){
    490. 

  490. 					$cnumarr = explode("&",$ordCNum);
    491. 

  491. 				}elseif($encryptmethod=="mcrypt"){
    492. 

  492. 					if(@$mcryptalg == "") $mcryptalg = MCRYPT_BLOWFISH;
    493. 

  493. 					$td = mcrypt_module_open($mcryptalg, '', 'cbc', '');
    494. 

  494. 					$thekey = @$ccencryptkey;
    495. 

  495. 					$thekey = substr($thekey, 0, mcrypt_enc_get_key_size($td));
    496. 

  496. 					$cnumarr = explode(" ", $ordCNum);
    497. 

  497. 					$iv = @$cnumarr[0];
    498. 

  498. 					$iv = @pack("H" . strlen($iv), $iv);
    499. 

  499. 					$ordCNum = @pack("H" . strlen(@$cnumarr[1]), @$cnumarr[1]);
    500. 

  500. 					mcrypt_generic_init($td, $thekey, $iv);
    501. 

  501. 					$cnumarr = explode("&", mdecrypt_generic($td, $ordCNum));
    502. 

  502. 					mcrypt_generic_deinit($td);
    503. 

  503. 					mcrypt_module_close($td);
    504. 

  504. 				}else{
    505. 

  505. 					print '<tr><td colspan="4">WARNING: $encryptmethod is not set. Please see http://www.ecommercetemplates.com/phphelp/ecommplus/parameters.asp#encryption</td></tr>';
    506. 

  506. 				}
    507. 

  507. 			} ?>
    508. 

  508.             <tr>
    509. 

  509.               <td align="right" colspan="4"><strong><?php print $xxCCName?>:</strong></td>
    510. 

  510.               <td align="left" colspan="2"><?php
    511. 

  511. 			if(@$encryptmethod!=""){
    512. 

  512. 					if(is_array(@$cnumarr)) print URLDecode(@$cnumarr[4]);
    513. 

  513. 			} ?></td>
    514. 

  514.             </tr>
    515. 

  515.             <tr>
    516. 

  516.               <td align="right" colspan="4"><strong><?php print $yyCarNum?>:</strong></td>
    517. 

  517.               <td align="left" colspan="2"><?php
    518. 

  518. 			if($ordCNum != ""){
    519. 

  519. 				if(is_array($cnumarr)) print $cnumarr[0];
    520. 

  520. 			}else{
    521. 

  521. 				print "(no data)";
    522. 

  522. 			} ?></td>
    523. 

  523.             </tr>
    524. 

  524.             <tr>
    525. 

  525.               <td align="right" colspan="4"><strong><?php print $yyExpDat?>:</strong></td>
    526. 

  526.               <td align="left" colspan="2"><?php
    527. 

  527. 			if(@$encryptmethod!=""){
    528. 

  528. 					if(is_array(@$cnumarr)) print @$cnumarr[1];
    529. 

  529. 			} ?></td>
    530. 

  530.             </tr>
    531. 

  531.             <tr>
    532. 

  532.               <td align="right" colspan="4"><strong>CVV Code:</strong></td>
    533. 

  533.               <td align="left" colspan="2"><?php
    534. 

  534. 			if(@$encryptmethod!=""){
    535. 

  535. 					if(is_array(@$cnumarr)) print @$cnumarr[2];
    536. 

  536. 			} ?></td>
    537. 

  537.             </tr>
    538. 

  538.             <tr>
    539. 

  539.               <td align="right" colspan="4"><strong>Issue Number:</strong></td>
    540. 

  540.               <td align="left" colspan="2"><?php
    541. 

  541. 			if(@$encryptmethod!=""){
    542. 

  542. 					if(is_array(@$cnumarr)) print @$cnumarr[3];
    543. 

  543. 			} ?></td>
    544. 

  544.             </tr>
    545. 

  545.             <?php		if($ordCNum != "" && !$doedit){ ?>
    546. 

  546.             <form method="post" action="/admin/orders.php?id=<?php print $_GET["id"]?>">
    547. 

  547.               <input type="hidden" name="delccdets" value="<?php print $_GET["id"]?>" />
    548. 

  548.               <tr>
    549. 

  549.                 <td align="center" colspan="6"><input name="submit" type="submit" value="<?php print $yyDelCC?>" /></td>
    550. 

  550.               </tr>
    551. 

  551.             </form>
    552. 

  552. 		    <?php		}
    553. 

  553. 		}
    554. 

  554. 	}
    555. 

  555. } // isprinter ?>
    556. 

  556.             <tr>
    557. 

  557.               <td align="center" colspan="6">&nbsp;<br /></td>
    558. 

  558.             </tr>
    559. 

  559.           </table>
    560. 

  560. 		  <tr>
    561. 

  561. 		    <table width="100%" border="1" cellspacing="0" cellpadding="4" bordercolor="#999999" style="border-collapse: collapse">
    562. 

  562. 		      <tr>
    563. 

  563. 		        <td><strong><?php print $xxPrId?></strong></td>
    564. 

  564. 			    <td><strong><?php print $xxPrNm?></strong></td>
    565. 

  565. 			    <td><strong><?php print $xxPrOpts?></strong></td>
    566. 

  566. 			    <td><strong><?php print $xxQuant?></strong></td>
    567. 

  567. 			    <td><strong>&nbsp;</strong></td>
    568. 

  568.   <?php	if($doedit) print '<td align="center"><strong>DEL</strong></td>' ?>
    569. 

  569. 	          </tr>
    570. 

  570.   <?php
    571. 

  571. 	$totoptpricediff = 0;
    572. 

  572. 	if(mysql_num_rows($allorders)>0){
    573. 

  573. 		$totoptpricediff = 0;
    574. 

  574. 		$rowcounter=0;
    575. 

  575. 		while($rsOrders = mysql_fetch_assoc($allorders)){
    576. 

  576. 			$optpricediff = 0;
    577. 

  577. ?>
    578. 

  578. 		      <tr>
    579. 

  579. 		        <td valign="top" nowrap><?php if($doedit) print '<input type="button" value="..." onclick="updateoptions(' . $rowcounter . ')">&nbsp;<input type="hidden" name="cartid' . $rowcounter . '" value="' . str_replace('"','&quot;',$rsOrders["cartID"]) . '" />'?><strong><?php print editfunc($rsOrders["cartProdId"],'prodid' . $rowcounter,18)?></strong></td>
    580. 

  580. 			    <td valign="top">
    581. 

  581. 			      <?php print editfunc($rsOrders["cartProdName"],'prodname' . $rowcounter,24)?><br />
    582. 

  582. 			      <? 
    583. 

  583. 				$sql_cert="SELECT cert_id,cert_code FROM certificates WHERE cert_order_id=".$_GET["id"]." AND cert_prod_id='".$rsOrders["cartProdId"]."'";
    584. 

  584. 				//echo $sql_cert;
    585. 

  585. 				$result_cert=mysql_query($sql_cert);
    586. 

  586. 				if(mysql_num_rows($result_cert)>0) {
    587. 

  587. 					while($row_cert=mysql_fetch_assoc($result_cert)){?>					
    588. 

  588. 			      <stong>(<?=$row_cert['cert_code']?>)</strong> <a href="/admin/certs.php?mode=1&amp;sbcode=<?=$row_cert['cert_id']?>">view</a> | <a href="/admin/certs.php?mode=2&amp;sbcode=<?=$row_cert['cert_id']?>">history</a><br />
    589. 

  589. 			      <? } 
    590. 

  590. 				}?>	
    591. 

  591. 			      <? 
    592. 

  592. 				$sql_down="SELECT * FROM digitaldownloads WHERE orderID=".$_GET["id"]." AND type='".$rsOrders["cartProdId"]."'";
    593. 

  593. 				//echo $sql_cert;
    594. 

  594. 				$result_down=mysql_query($sql_down);
    595. 

  595. 				if(mysql_num_rows($result_down)>0) {?>
    596. 

  596. 			      <ol style="margin:2px;">
    597. 

  597. 			        <? while($row_down=mysql_fetch_assoc($result_down)){?>					
    598. 

  598. 			        
    599. 

  599. 			        <li style="margin:1px; font-weight:bold;">License ID: <?=$row_down['licenseID']?><br />
    600. 

  600. 		            Password: <?=$row_down['password']?></li>
    601. 

  601. 				  <? 	  } ?>
    602. 

  602. 			        </ol>
    603. 

  603. 				  <? }?>		        </td>
    604. 

  604. 			    <td valign="top"><?php
    605. 

  605. 			if($doedit) print '<span id="optionsspan' . $rowcounter . '">';
    606. 

  606. 			$sSQL = "SELECT coOptGroup,coCartOption,coPriceDiff,coOptID,optGroup,optStyleID,coExtendShipping,ui.display_image,ui.org_img_name FROM cartoptions LEFT JOIN options ON cartoptions.coOptID=options.optID LEFT JOIN uploaded_images ui ON cartoptions.coCartOption=ui.id WHERE coCartID=" . $rsOrders["cartID"] . " ORDER BY coID";
    607. 

  607. 			$result = mysql_query($sSQL) or print(mysql_error());
    608. 

  608. 			if(mysql_num_rows($result) > 0){
    609. 

  609. 				if($doedit) print '<table border="0" cellspacing="0" cellpadding="1" width="100%">';
    610. 

  610. 				while($rs2 = mysql_fetch_array($result)){
    611. 

  611. 					$imgsrc='';
    612. 

  612. 					$imgname='';
    613. 

  613. 					if(!empty($rs2["display_image"])) {
    614. 

  614. 						$imgsrc='<br /><img src="/imguploads/img_screen/'.$rs2["display_image"].'.gif" align="top"><div style="font-size:9px;">(If the image does not appear there is a problem with the custom screen upload)</div>';
    615. 

  615. 						$imgname='<br />&nbsp;&nbsp;&nbsp;-Image Name: '.$rs2["org_img_name"];
    616. 

  616. 					}					
    617. 

  617. 					if($doedit){
    618. 

  618. 						print '<tr><td align="right"><strong>' . $rs2["coOptGroup"] . ':</strong></td><td>';
    619. 

  619. 						if(is_null($rs2["optGroup"])){
    620. 

  620. 							print 'xxxxxx';
    621. 

  621. 						}else{
    622. 

  622. 							$sSQL="SELECT optID," . getlangid("optName",32) . ",optPriceDiff,optType,optFlags,optStock,optPriceDiff AS optDims FROM options INNER JOIN optiongroup ON options.optGroup=optiongroup.optGrpID WHERE optGroup=" . $rs2["optGroup"] . ' ORDER BY optID';
    623. 

  623. 							$result2 = mysql_query($sSQL) or print(mysql_error());
    624. 

  624. 							if($rsl = mysql_fetch_assoc($result2)){
    625. 

  625. 								if(abs($rsl["optType"])==2){
    626. 

  626. 									print '<select onchange="dorecalc(true)" name="optn' . $rowcounter . '_' . $rs2["coOptID"] . '" id="optn' . $rowcounter . '_' . $rs2["coOptID"] . '" size="1">';
    627. 

  627. 									do {
    628. 

  628. 										print '<option value="' . $rsl["optID"] . "|" . (($rsl["optFlags"] & 1) == 1 ? ($rsOrders["cartProdPrice"]*$rsl["optPriceDiff"])/100.0 : $rsl["optPriceDiff"]) . '"';
    629. 

  629. 										if($rsl["optID"]==$rs2["coOptID"]) print ' selected';
    630. 

  630. 										print '>' . $rsl[getlangid("optName",32)];
    631. 

  631. 										if((double)$rsl["optPriceDiff"] != 0){
    632. 

  632. 											print ' ';
    633. 

  633. 											if((double)$rsl["optPriceDiff"] > 0) print '+';
    634. 

  634. 											if(($rsl["optFlags"] & 1) == 1)
    635. 

  635. 												print number_format(($rsOrders["cartProdPrice"]*$rsl["optPriceDiff"])/100.0,2,'.','');
    636. 

  636. 											else
    637. 

  637. 												print number_format($rsl["optPriceDiff"],2,'.','');
    638. 

  638. 										}
    639. 

  639. 										print '</option>';
    640. 

  640. 									} while($rsl = mysql_fetch_array($result2));
    641. 

  641. 									print '</select>';
    642. 

  642. 								}else{
    643. 

  643. 									print "<input type='hidden' name='optn" . $rowcounter . '_' . $rs2["coOptID"] . "' value='" . $rsl["optID"] . "' /><textarea wrap='virtual' name='voptn" . $rowcounter . '_' . $rs2["coOptID"] . "' id='voptn". $rowcounter. '_' . $rs2["coOptID"] . "' cols='30' rows='3'>";
    644. 

  644. 									print $rs2["coCartOption"] . '</textarea>';
    645. 

  645. 								}
    646. 

  646. 							}
    647. 

  647. 						}
    648. 

  648. 						print "</td></tr>";
    649. 

  649. 					}else{						
    650. 

  650. 						$extend_shipping='';
    651. 

  651. 						if(!empty($rs2["coExtendShipping"])) $extend_shipping=' <span style="color:#FF0000;font-weight:bold;">(This option increases shipping time by '.$rs2["coExtendShipping"]. ' days)</span>';
    652. 

  652. 						print '<strong>' . $rs2["coOptGroup"] . ':</strong> ' . str_replace(array("\r\n","\n"),array("<br />","<br />"),$rs2["coCartOption"]).' ' .$imgname.' '.$imgsrc.$cert_code. $extend_shipping . '<br />';
    653. 

  653. 					}
    654. 

  654. 					if($doedit)
    655. 

  655. 						$optpricediff += $rs2["coPriceDiff"];
    656. 

  656. 					else
    657. 

  657. 						$rsOrders["cartProdPrice"] += $rs2["coPriceDiff"];
    658. 

  658. 				}
    659. 

  659. 				if($doedit) print '</table>';
    660. 

  660. 			}else{
    661. 

  661. 				print '-';
    662. 

  662. 			}
    663. 

  663. 			mysql_free_result($result);
    664. 

  664. 			if($doedit) print '</span>' ?></td>
    665. 

  665. 			    <td valign="top"><?php print editfunc($rsOrders["cartQuantity"],'quant' . $rowcounter . '" onchange="dorecalc(true)',5)?></td>
    666. 

  666. 			    <td valign="top"><?php /*?><?php if($doedit) print editnumeric($rsOrders["cartProdPrice"],'price' . $rowcounter . '" onchange="dorecalc(true)',7); else print FormatEuroCurrency($rsOrders["cartProdPrice"]*$rsOrders["cartQuantity"])?>
    667. 

  667. <?php				if($doedit){
    668. 

  668. 						print '<input type="hidden" id="optdiffspan' . $rowcounter . '" value="' . $optpricediff . '">';
    669. 

  669. 						$totoptpricediff += ($optpricediff*$rsOrders["cartQuantity"]);
    670. 

  670. 					}
    671. 

  671. 			?><?php */?></td>
    672. 

  672.   <?php		if($doedit) print '<td align="center"><input type="checkbox" name="del_' . $rowcounter . '" id="del_' . $rowcounter . '" value="yes" /></td>' ?>
    673. 

  673. 	          </tr>
    674. 

  674.   <?php		$rowcounter++;
    675. 

  675. 		}
    676. 

  676. 	}
    677. 

  677. ?>
    678. 

  678.   <!--NEXTPRODUCTCOMMENT-->
    679. 

  679.   <?php /*?><?php if($doedit){ ?>
    680. 

  680. 			<tr>
    681. 

  681. 			  <td align="right" colspan="4">
    682. 

  682. 				<table width="100%" border="0" cellspacing="0" cellpadding="0">
    683. 

  683. 				  <tr>
    684. 

  684. 					<td align="center"><?php if($doedit) print '<input style="width:30px;" type="button" value="-" onclick="extraproduct(\'-\')"> ' . $yyMoProd . ' <input style="width:30px;" type="button" value="+" onclick="extraproduct(\'+\')"> &nbsp; <input type="button" value="' . $yyRecal . '" onclick="dorecalc(false)">'?></td>
    685. 

  685. 					<td align="right"><strong>Options Total:</strong></td>
    686. 

  686. 				  </tr>
    687. 

  687. 				</table></td>
    688. 

  688. 			  <td align="left" colspan="2"><span id="optdiffspan"><?php print number_format($totoptpricediff, 2, '.', '')?></span></td>
    689. 

  689. 			</tr>
    690. 

  690. <?php } ?>
    691. 

    692. 

  692. 			<tr>
    693. 

  693. 			  <td align="right" colspan="4"><strong><?php print $xxOrdTot?>:</strong></td>
    694. 

  694. 			  <td align="left"><div id="ordTot"><?php echo sprintf("%.2f",$alldata["ordTotal"]); ?></div><input name="ordtotal" id="ordtotal" type="hidden" value="<?php echo $alldata["ordTotal"] ?>" /></td>
    695. 

  695. <?php		if($doedit) print '<td align="center">&nbsp;</td>' ?>
    696. 

  696. 			</tr>
    697. 

  697. 			<?php
    698. 

  698. 	$runTot = $alldata["ordTotal"];
    699. 

  699. 	$sql = "SELECT * FROM price_adj WHERE ordID = " . $_GET['id'] . " ORDER BY ordering";
    700. 

  700. 	$res = mysql_query($sql) or print(mysql_error());
    701. 

  701. 	if(mysql_num_rows($res) > 0) {
    702. 

  702. 		$k=1;
    703. 

  703. 		$prcTot = 0;
    704. 

  704. ?>
    705. 

  705. 			<tr>
    706. 

  706. 				<td>&nbsp;</td>
    707. 

  707. 				<td>&nbsp;</td>
    708. 

  708. 				<td>&nbsp;</td>
    709. 

  709. 				<td>&nbsp;</td>
    710. 

  710. 				<td>&nbsp;</td>
    711. 

  711. 			</tr>
    712. 

  712. <?php
    713. 

  713. 		while($row=mysql_fetch_assoc($res)) {
    714. 

  714. 			$price = 0;
    715. 

  715. 			$disp_price = 0;
    716. 

  716. 			$amount = '';
    717. 

  717. 			
    718. 

  718. 			if($row['type'] == 'credit') {
    719. 

  719. 				if($row['amt_type'] == 'percentage') {
    720. 

  720. 					$price = $runTot * ($row['amt'] * .01);
    721. 

  721. 					$runTot -= $price;
    722. 

  722. 					$prcTot -= $price;
    723. 

  723. 					$disp_price = '-'.(int)$row['amt'].'%';
    724. 

  724. 					$amount = '-'.money_format("%!.2n",$price);
    725. 

  725. 				}else{
    726. 

  726. 					$price = '$-'.money_format("%!.2n",$row['amt']);
    727. 

  727. 					$runTot -= $row['amt'];
    728. 

  728. 					$prcTot -= $row['amt'];
    729. 

  729. 					$disp_price = $price;
    730. 

  730. 					$amount = '-'.money_format("%!.2n",$row['amt']);
    731. 

  731. 				}
    732. 

  732. 			}else{
    733. 

  733. 				if($row['amt_type'] == 'percentage') {
    734. 

  734. 					$price = $runTot * ($row['amt'] * .01);
    735. 

  735. 					$runTot += $price;
    736. 

  736. 					$prcTot += $price;
    737. 

  737. 					$disp_price = (int)$row['amt'].'%';
    738. 

  738. 					$amount = money_format("%.2n",$price);
    739. 

  739. 				}else{
    740. 

  740. 					$price = money_format("%.2n",$row['amt']);
    741. 

  741. 					$runTot += $row['amt'];
    742. 

  742. 					$prcTot += $row['amt'];
    743. 

  743. 					$disp_price = $price;
    744. 

  744. 					$amount = money_format("%.2n",$row['amt']);
    745. 

  745. 				}
    746. 

  746. 			}
    747. 

  747. ?>
    748. 

  748. 			<tr>
    749. 

  749. 				<td colspan="3" style="font-weight: bold; text-align: right">Price Adjustment <?=$k?>:</td>
    750. 

  750. 				<td align="left"<?=(strstr($disp_price,"-"))?' style="color: red"':''?>><?=$disp_price?></td>
    751. 

  751. 				<td align="left"<?=(strstr($disp_price,"-"))?' style="color: red"':''?>><?=$amount?></td>
    752. 

  752. 			</tr>
    753. 

  753. <?php
    754. 

  754. 			$k++;
    755. 

  755. 		}
    756. 

  756. ?>
    757. 

  757. 			<tr>
    758. 

  758. 				<td>&nbsp;</td>
    759. 

  759. 				<td>&nbsp;</td>
    760. 

  760. 				<td>&nbsp;</td>
    761. 

  761. 				<td>&nbsp;</td>
    762. 

  762. 				<td>&nbsp;</td>
    763. 

  763. 			</tr>
    764. 

  764. <?php
    765. 

  765. 	}
    766. 

  766. ?>
    767. 

  767. <?php if((double)$alldata["ordShipping"]!=0.0 || $doedit){ ?>
    768. 

  768. 			<tr>
    769. 

  769. 			  <td align="right" colspan="4"><strong><?php print $xxShippg?>:</strong></td>
    770. 

  770. 			  <td align="left"><?php print editnumeric($alldata["ordShipping"],"ordShipping",7)?></td>
    771. 

  771. <?php		if($doedit) print '<td align="center">&nbsp;</td>' ?>
    772. 

  772. 			</tr>
    773. 

  773. <?php }
    774. 

  774. 	  if((double)$alldata["ordHandling"]!=0.0 || $doedit){ ?>
    775. 

  775. 			<tr>
    776. 

  776. 			  <td align="right" colspan="4"><strong><?php print $xxHndlg?>:</strong></td>
    777. 

  777. 			  <td align="left"><?php print editnumeric($alldata["ordHandling"],"ordHandling",7)?></td>
    778. 

  778. <?php		if($doedit) print '<td align="center">&nbsp;</td>' ?>
    779. 

  779. 			</tr>
    780. 

  780. <?php }
    781. 

  781. 	  if((double)$alldata["ordDiscount"]!=0.0 || $doedit){ ?>
    782. 

  782. 			<tr>
    783. 

  783. 			  <td align="right" colspan="4"><strong><?php print $xxDscnts?>:</strong></td>
    784. 

  784. 			  <td align="left"><font color="#FF0000"><?php print editnumeric($alldata["ordDiscount"],"ordDiscount",7)?></font></td>
    785. 

  785. <?php		if($doedit) print '<td align="center">&nbsp;</td>' ?>
    786. 

  786. 			</tr>
    787. 

  787. <?php }
    788. 

  788. 	  if((double)$alldata["ord_cert_amt"]!=0.0 || $doedit){ 
    789. 

  789. 			$sqlcert="SELECT cert_code FROM certificates WHERE cert_id=".$alldata["ord_cert_id"];
    790. 

  790. 			$resultcert=mysql_query($sqlcert);
    791. 

  791. 			$rowcert=mysql_fetch_assoc($resultcert);
    792. 

  792. 			?>
    793. 

  793. 			<tr>
    794. 

  794. 			  <td align="right" colspan="4"><strong><?='('.$rowcert["cert_code"].')'?> <?php print $xxGCerts?>:</strong></td>
    795. 

  795. 			  <td align="left"><font color="#FF0000"><?php print editnumeric($alldata["ord_cert_amt"],"ord_cert_amt",7)?></font></td>
    796. 

  796. <?php		if($doedit) print '<td align="center">&nbsp;</td>' ?>
    797. 

  797. 			</tr>
    798. 

  798. <?php }
    799. 

  799. 	  if((double)$alldata["ordStateTax"]!=0.0 || $doedit){ ?>
    800. 

  800. 			<tr>
    801. 

  801. 			  <td align="right" colspan="4"><strong><?php print $xxStaTax?>:</strong></td>
    802. 

  802. 			  <td align="left"><?php print editnumeric($alldata["ordStateTax"],"ordStateTax",7)//$alldata["ordStateTax"]?></td>
    803. 

  803. <?php		if($doedit) print '<td align="center" nowrap><input type="text" name="staterate" id="staterate" size="1" value="' . $statetaxrate . '">%</td>' ?>
    804. 

  804. 			</tr>
    805. 

  805. <?php }
    806. 

  806. 	  if((double)$alldata["ordCountryTax"]!=0.0 || $doedit){ ?>
    807. 

  807. 			<tr>
    808. 

  808. 			  <td align="right" colspan="4"><strong><?php print $xxCntTax?>:</strong></td>
    809. 

  809. 			  <td align="left"><?php print editnumeric($alldata["ordCountryTax"],"ordCountryTax",7)?></td>
    810. 

  810. <?php		if($doedit) print '<td align="center" nowrap><input type="text" name="countryrate" id="countryrate" size="1" value="' . $countrytaxrate . '">%</td>' ?>
    811. 

  811. 			</tr>
    812. 

  812. <?php }
    813. 

  813. 	  if((double)$alldata["ordHSTTax"]!=0.0 || ($doedit && @$canadataxsystem)){ ?>
    814. 

  814. 			<tr>
    815. 

  815. 			  <td align="right" colspan="4"><strong><?php print $xxHST?>:</strong></td>
    816. 

  816. 			  <td align="left"><?php print editnumeric($alldata["ordHSTTax"],"ordHSTTax",7)?></td>
    817. 

  817. <?php		if($doedit) print '<td align="center" nowrap><input type="text" name="hstrate" id="hstrate" size="1" value="' . $hsttaxrate . '">%</td>' ?>
    818. 

  818. 			</tr>
    819. 

  819. <?php } ?>
    820. 

  820. 			<tr>
    821. 

  821. 			  <td align="right" colspan="4"><strong><?php print $xxGndTot?>:</strong></td>
    822. 

  822. 			  <td align="left"><span id="grandtotalspan"><?php print FormatEuroCurrency(($alldata["ordTotal"]+$alldata["ordStateTax"]+$alldata["ordCountryTax"]+$alldata["ordHSTTax"]+$alldata["ordShipping"]+$alldata["ordHandling"]+$prcTot)-$alldata["ordDiscount"]-$alldata["ord_cert_amt"])?></span></td>
    823. 

  823. <?php		if($doedit) print '<td align="center">&nbsp;</td>' ?>
    824. 

  824. 			</tr>
    825. 

  825. 	  </table>
    826. 

  826. </span>
    827. 

  827. 		  </td>
    828. 

  828. 		</tr>
    829. 

  829. <?php	if($isprinter && @$invoicefooter != ""){ ?>
    830. 

  830. 		<tr> 
    831. 

  831.           <td width="100%"><?php print $invoicefooter?></td>
    832. 

  832. 		</tr>
    833. 

  833. <?php	}elseif($doedit){ ?>
    834. 

  834. 		<tr> 
    835. 

  835.           <td align="center" width="100%">&nbsp;<br /><input type="submit" value="<?php print $yyUpdate?>" onclick="updateClicked=true; cloneClicked=false;" />&nbsp;<input type="submit" name="clone" value="Clone Order" onclick="updateClicked=false; cloneClicked=true;" /><br />&nbsp;</td>
    836. 

  836. 		</tr>
    837. 

  837. <?php	} ?><?php */?>
    838. 

  838. 	        </table>
    839. 

  839. 		    <?php
    840. 

  840. 	if($doedit) print '</form>';
    841. 

  841. 	if($doedit){
    842. 

  842. 	// ADDED by Chad Jun-06-06
    843. 

  843. 	// PRICE ADJUSTMENTS
    844. 

  844. ?>
    845. 

  845. 		    
    846. 

  846. 	        <h2><a name="prc_adj"></a>Price Adjustments</h2>
    847. 

  847. 		    <?php
    848. 

  848. 	if(!empty($_GET['adj_err'])) {
    849. 

  849. ?>
    850. 

  850. 		    <div style="margin: 5px auto; color: #FF0000; font-weight: bold; text-align: center"><?=$_GET['adj_err']?>
    851. 

  851. 	        </div>
    852. 

  852. 		    <?php
    853. 

  853. 	}elseif(!empty($_GET['adj_msg'])) {
    854. 

  854. ?>
    855. 

  855. 		    <div style="margin: 5px auto; color: #009900; font-weight: bold; text-align: center"><?=$_GET['adj_msg']?>
    856. 

  856. 	        </div>
    857. 

  857. 		    <?php
    858. 

  858. 	}
    859. 

  859. ?>
    860. 

  860. 	        <table width="95%" cellpadding="3" cellspacing="0" border="1" style="margin: 0 auto 5px auto; border: 1px solid #BFC9E0; border-collapse: collapse">
    861. 

  861. 	            <tr style="background-color: #BFC9E0; color: #194C7F">
    862. 

  862. 		            <th width="60" style="text-align: center">Type</th>
    863. 

  863. 			  <th width="80" style="text-align: center">Amount Type</th>
    864. 

  864. 			  <th width="80" style="text-align: center">Amount</th>
    865. 

  865. 			  <th width="150" style="text-align: center">Date</th>
    866. 

  866. 			  <th>Note</th>
    867. 

  867.   <?php
    868. 

  868. if(strstr($_SESSION['employee']['permissions'],"all") || $_SESSION['employee']['id']==19 || $_SESSION['employee']['id']==12 || $_SESSION['employee']['id']==2) {
    869. 

  869. ?>
    870. 

  870. 		            <th width="28">Edit</th>
    871. 

  871. 			  <th width="28">Delete</th>
    872. 

  872. 			  <th width="28">Move Up</th>
    873. 

  873. 			  <th width="28">Move Down</th>
    874. 

  874.   <?php
    875. 

  875. }
    876. 

  876. ?>
    877. 

  877.                 </tr>
    878. 

  878.   <?php
    879. 

  879. 	$sql = "SELECT * FROM price_adj WHERE ordID = " . $_GET["id"] . " ORDER BY ordering";
    880. 

  880. 	$res = mysql_query($sql) or print(mysql_error());
    881. 

  881. 	
    882. 

  882. 	$num_rows = mysql_num_rows($res);
    883. 

  883. 	if($num_rows > 0) {
    884. 

  884. 		$j=0;
    885. 

  885. 		while($row=mysql_fetch_assoc($res)) {
    886. 

  886. ?>
    887. 

  887. 	            <tr<?=($j%0==0?'':' style="background-color: #E6E9F5"')?>>
    888. 

  888. 		            <td style="text-align: center"><?=$row['type']?></td>
    889. 

  889. 			  <td style="text-align: center"><?=$row['amt_type']?></td>
    890. 

  890. 			  <td style="text-align: right"><?=$row['amt']?></td>
    891. 

  891. 			  <td style="text-align: left"><?=date("n/j/Y g:i a",strtotime($row['date']))?></td>
    892. 

  892. 			  <td style="text-align: left"><?=$row['note']?></td>
    893. 

  893.   <?php
    894. 

  894. if(strstr($_SESSION['employee']['permissions'],"all") || $_SESSION['employee']['id']==19 || $_SESSION['employee']['id']==12 || $_SESSION['employee']['id']==2) {
    895. 

  895. ?>
    896. 

  896. 		            <td style="text-align: center"><a href="/admin/editprcadj.php?pa_id=<?=$row['id']?>&action=edit" onclick="window.open(this.href,'edit_txn','left=700,top=100,width=550,height=150,toolbar=0'); return false;"><img src="/lib/images/misc/edit.gif" height="24" width="24" /></a></td>
    897. 

  897. 			  <td style="text-align: center"><a href="/admin/editprcadj.php?pa_id=<?=$row['id']?>&action=delete" onclick="window.open(this.href,'edit_txn','left=700,top=100,width=550,height=150,toolbar=0'); return false;"><img src="/lib/images/misc/delete.gif" width="24" height="24" /></a></td>
    898. 

  898. 			  <td style="text-align: center"><? if($row['ordering']!=1){?><a href="/admin/mvprcadj.php?pa_id=<?=$row['id']?>&pa_ordID=<?=$row['ordID']?>&position=<?=$row['ordering']?>&action=moveup" onclick=""><img src="/lib/images/misc/arrow_up.png" width="24" height="24" /></a><? } ?></td>
    899. 

  899. 			  <td style="text-align: center"><? if($row['ordering']!=$num_rows){?><a href="/admin/mvprcadj.php?pa_id=<?=$row['id']?>&pa_ordID=<?=$row['ordID']?>&position=<?=$row['ordering']?>&action=movedown" onclick=""><img src="/lib/images/misc/arrow_down.png" width="24" height="24" /></a><? } ?></td>
    900. 

  900.   <?php
    901. 

  901. }
    902. 

  902. ?>
    903. 

  903.                 </tr>
    904. 

  904.   <?php
    905. 

  905. 			$j++;
    906. 

  906. 		}
    907. 

  907. 	}else{
    908. 

  908. ?>
    909. 

  909. 	            <tr>
    910. 

  910. 		            <td colspan="9" style="text-align: center; font-weight: bold">No Price Adjustments Found</td>
    911. 

  911. 		  </tr>
    912. 

  912.   <?php
    913. 

  913. 	}
    914. 

  914. ?>
    915. 

  915.                 </table>
    916. 

  916. 		    <?php
    917. 

  917. if(strstr($_SESSION['employee']['permissions'],"all") || $_SESSION['employee']['id']==19 || $_SESSION['employee']['id']==12 || $_SESSION['employee']['id']==2) {
    918. 

  918. ?>
    919. 

  919. 		    
    920. 

  920. 	        <input type="button" id="btn_prc_add" value="Add Price Adjustment" onclick="togglePrcAdd();" />
    921. 

  921. 		    
    922. 

  922. 	        <div id="div_prc_add" style="display: none">
    923. 

  923. 	            <form id="adj_frm" name="adj_frm" method="post" action="/admin/ordersprocess.php">
    924. 

  924. 	              <table cellpadding="3" cellspacing="0" border="1" style="margin: 0 auto 5px auto; border: 1px solid #BFC9E0; border-collapse: collapse">
    925. 

  925. 		              <tr style="background-color: #BFC9E0; color: #194C7F">
    926. 

  926. 		                <td colspan="2" style="text-align: center; font-weight: bold; font-size: 14px">Add Price Adjustment</td>
    927. 

  927. 			  </tr>
    928. 

  928. 		              <tr>
    929. 

  929. 		                <td style="font-weight: bold">Type:</td>
    930. 

  930. 				  <td>
    931. 

  931. 				    <select id="adj_type" name="adj_type">
    932. 

  932. 				      <option value="" selected="selected">Choose...</option>
    933. 

  933. 				      <option value="credit">Credit</option>
    934. 

  934. 				      <option value="debit">Debit</option>
    935. 

  935. 				      </select>				    </td>
    936. 

  936. 			  </tr>
    937. 

  937. 		              <tr>
    938. 

  938. 		                <td style="font-weight: bold">Amt Type:</td>
    939. 

  939. 				  <td>
    940. 

  940. 				    <select id="adj_amt_type" name="adj_amt_type">
    941. 

  941. 				      <option value="" selected="selected">Choose...</option>
    942. 

  942. 				      <option value="fixed">Fixed</option>
    943. 

  943. 				      <option value="percentage">Percentage</option>
    944. 

  944. 				      </select>				    </td>
    945. 

  945. 			  </tr>
    946. 

  946. 		              <tr>
    947. 

  947. 		                <td style="font-weight: bold">Amount:</td>
    948. 

  948. 				  <td><input id="adj_amt" name="adj_amt" type="text" value="" /></td>
    949. 

  949. 			  </tr>
    950. 

  950. 		              <tr>
    951. 

  951. 		                <td style="font-weight: bold">Note:</td>
    952. 

  952. 				  <td><textarea id="adj_note" name="adj_note"></textarea></td>
    953. 

  953. 			  </tr>
    954. 

  954. 		              <tr>
    955. 

  955. 		                <td colspan="2" style="text-align: center"><input type="submit" id="adj_submit" name="adj_submit" value="Add" /></td>
    956. 

  956. 			  </tr>
    957. 

  957.                   </table>
    958. 

  958. 		  <input type="hidden" id="adj_ordID" name="adj_ordID" value="<?=$_GET["id"]?>" />
    959. 

  959. 	              <input type="hidden" id="adj_doedit" name="adj_doedit" value="<?=$_GET["doedit"]?>" />
    960. 

  960.                 </form>
    961. 

  961. 	      </div>
    962. 

  962. 		    <?php
    963. 

  963. }
    964. 

  964. 	// ADD ENDED
    965. 

  965. 

  966. 	// ADDED by Chad Jun-05-06
    967. 

  967. 	// TRANSACTIONS
    968. 

  968. 	$sql = "SELECT * FROM transactions WHERE ordID = " . $_GET["id"];
    969. 

  969. 	$res = mysql_query($sql) or print(mysql_error());
    970. 

  970. ?>
    971. 

  971. 	        <h2><a name="aim"></a>Transactions</h2>
    972. 

  972. 		    <?php
    973. 

  973. 	if(!empty($_GET['aim_err'])) {
    974. 

  974. ?>
    975. 

  975. 		    <div style="margin: 5px auto; color: #FF0000; font-weight: bold; text-align: center"><?=$_GET['aim_err']?>
    976. 

  976. 	        </div>
    977. 

  977. 		    <?php
    978. 

  978. 	}elseif(!empty($_GET['aim_msg'])) {
    979. 

  979. ?>
    980. 

  980. 		    <div style="margin: 5px auto; color: #009900; font-weight: bold; text-align: center"><?=$_GET['aim_msg']?>
    981. 

  981. 	        </div>
    982. 

  982. 		    <?php
    983. 

  983. 	}
    984. 

  984. ?>
    985. 

  985. 	        <table width="95%" cellpadding="3" cellspacing="0" border="1" style="margin: 0 auto 5px auto; border: 1px solid #BFC9E0; border-collapse: collapse">
    986. 

  986. 	            <tr style="background-color: #BFC9E0; color: #194C7F">
    987. 

  987. 		            <th width="85" style="text-align: center">Type</th>
    988. 

  988. 			  <th width="60" style="text-align: right">Amount</th>
    989. 

  989. 			  <th width="80" style="text-align: center">TXN</th>
    990. 

  990. 			  <th width="120" style="text-align: left">Date</th>
    991. 

  991. 			  <th>Note</th>
    992. 

  992. 		  </tr>
    993. 

  993.   <?php
    994. 

  994. 	while($row=mysql_fetch_assoc($res)) {
    995. 

  995. ?>
    996. 

  996. 	            <tr>
    997. 

  997. 		            <td style="text-align: center"><?=$row['type']?></td>
    998. 

  998. 			  <td style="text-align: center"><?=money_format("%.2n",$row['amt'])?></td>
    999. 

  999. 			  <td style="text-align: center"><?=$row['txn']?></td>
    1000. 

  1000. 			  <td style="text-align: center"><?=date("n/j/Y g:i a",strtotime($row['date_received']))?></td>
    1001. 

  1001. 			  <td><?=$row['note']?></td>
    1002. 

  1002. 		  </tr>
    1003. 

  1003.   <?php	
    1004. 

  1004. 	}
    1005. 

  1005. ?>
    1006. 

  1006.                 </table>
    1007. 

  1007. 		    <?php
    1008. 

  1008. if(strstr($_SESSION['employee']['permissions'],"all") || $_SESSION['employee']['id']==9 || $_SESSION['employee']['id']==12 || $_SESSION['employee']['id']==2) {
    1009. 

  1009. ?>
    1010. 

  1010.           <input type="button" id="btn_add_txn" value="Credit or Void" onclick="toggleTXN();" />
    1011. 

  1011. 		    
    1012. 

  1012.           <div id="div_trans" style="display: none">
    1013. 

  1013.             <form id="aim_frm" name="aim_frm" method="post" action="/admin/ordersprocess.php" onsubmit="return checkAIM(this);">
    1014. 

  1014.               <table cellpadding="3" cellspacing="0" border="1" style="margin: 5px auto 5px auto; border: 1px solid #BFC9E0; border-collapse: collapse">
    1015. 

  1015.                 <tr style="background-color: #BFC9E0; color: #194C7F">
    1016. 

  1016.                   <td colspan="4" style="text-align: center; font-weight: bold; font-size: 14px">Credit or Void a Transaction</td>
    1017. 

  1017. 		  </tr>
    1018. 

  1018.                 <tr>
    1019. 

  1019.                   <th style="text-align: center">Type</th>
    1020. 

  1020. 			  <th style="text-align: center">TXN</th>
    1021. 

  1021. 			  <th style="text-align: center">Amount</th>
    1022. 

  1022. 			  <th>Note</th>
    1023. 

  1023. 		  </tr>
    1024. 

  1024.                 <tr>
    1025. 

  1025.                   <td valign="top">
    1026. 

  1026.                     <select name="aim_type" id="aim_type">
    1027. 

  1027.                       <option value="" selected="selected">Choose...</option>
    1028. 

  1028.                       <option value="CREDIT">Credit</option>
    1029. 

  1029.                       <option value="VOID">Void</option>
    1030. 

  1030.                       </select>                    </td>
    1031. 

  1031. 			  <td valign="top"><input type="text" id="aim_txn" name="aim_txn" value="" autocomplete="off" /></td>
    1032. 

  1032. 			  <td valign="top"><input type="text" id="aim_amt" name="aim_amt" value="" autocomplete="off" /></td>
    1033. 

  1033. 			  <td valign="top"><textarea id="aim_note" name="aim_note"></textarea></td>
    1034. 

  1034. 		  </tr>
    1035. 

  1035.                 <tr>
    1036. 

  1036.                   <td colspan="4" style="text-align: right"><input type="submit" id="aim_submit" name="aim_submit" value="Submit" /></td>
    1037. 

  1037. 		  </tr>
    1038. 

  1038.               </table>
    1039. 

  1039. 	  <input type="hidden" id="aim_inv" name="aim_inv" value="<?=$_GET["id"]?>" />
    1040. 

  1040.   <?php
    1041. 

  1041. $tmp = explode(" ",$alldata["ordName"]);
    1042. 

  1042. ?>
    1043. 

  1043.               <input type="hidden" id="aim_fname" name="aim_fname" value="<?=$tmp[0]?>" />
    1044. 

  1044.               <input type="hidden" id="aim_lname" name="aim_lname" value="<?=(!empty($tmp[1]))?$tmp[1]:''?>" />
    1045. 

  1045.               <input type="hidden" id="aim_doedit" name="aim_doedit" value="<?=$_GET['doedit']?>" />
    1046. 

  1046.             </form>
    1047. 

  1047.           </div>
    1048. 

  1048. 		    <input type="button" id="btn_charge" value="Charge CC" onclick="toggleCharge();" style="display: block; margin: 5px 5px 5px 0" />
    1049. 

  1049. 		    
    1050. 

  1050.           <div id="div_charge" style="display: none">
    1051. 

  1051.             <? 
    1052. 

  1052. 		if(!empty($alldata["ordEID"])){
    1053. 

  1053. 			$sql_eid="SELECT * FROM customers WHERE custID=".$alldata["ordEID"];
    1054. 

  1054. 			$result_eid=mysql_query($sql_eid);
    1055. 

  1055. 			if(mysql_num_rows($result_eid)>0){
    1056. 

  1056. 				$row_eid=mysql_fetch_assoc($result_eid);
    1057. 

  1057. 			}
    1058. 

  1058. 		}
    1059. 

  1059. 	?>
    1060. 

  1060.             <form id="frmCharge" name="frmCharge" method="post" action="/admin/ordersprocess.php">
    1061. 

  1061.               <table cellpadding="3" cellspacing="0" border="1" style="margin: 5px auto 5px auto; border: 1px solid #BFC9E0; border-collapse: collapse">
    1062. 

  1062.                 <tr style="background-color: #BFC9E0; color: #194C7F">
    1063. 

  1063.                   <td colspan="2" style="font-size: 14px; font-weight: bold; text-align: center">Authorize &amp; Capture</td>
    1064. 

  1064. 		  </tr>
    1065. 

  1065.                 <tr>
    1066. 

  1066.                   <td>First Name:</td>
    1067. 

  1067. 			  <td><input type="text" id="am_fname" name="am_fname" value="<?=$row_eid['Name']?>" /></td>
    1068. 

  1068. 		  </tr>
    1069. 

  1069.                 <tr>
    1070. 

  1070.                   <td>Last Name:</td>
    1071. 

  1071. 			  <td><input type="text" id="am_lname" name="am_lname" value="" /></td>
    1072. 

  1072. 		  </tr>
    1073. 

  1073.                 <tr>
    1074. 

  1074.                   <td>Address:</td>
    1075. 

  1075. 			  <td><input type="text" id="am_address" name="am_address" value="<?=$row_eid['Address']?>" /></td>
    1076. 

  1076. 		  </tr>
    1077. 

  1077.                 <tr>
    1078. 

  1078.                   <td>Address 2:</td>
    1079. 

  1079. 			  <td><input type="text" id="am_address2" name="am_address2" value="<?=$row_eid['Address2']?>" /></td>
    1080. 

  1080. 		  </tr>
    1081. 

  1081.                 <tr>
    1082. 

  1082.                   <td>City:</td>
    1083. 

  1083. 			  <td><input type="text" id="am_city" name="am_city" value="<?=$row_eid['City']?>" /></td>
    1084. 

  1084. 		  </tr>
    1085. 

  1085.                 <tr>
    1086. 

  1086.                   <td>State:</td>
    1087. 

  1087. 			  <td><input type="text" id="am_state" name="am_state" value="<? if(!empty($row_eid['State2'])) echo $row_eid['State2']; else echo $row_eid['State']; ?>" /></td>
    1088. 

  1088. 		  </tr>
    1089. 

  1089.                 <tr>
    1090. 

  1090.                   <td>Zip:</td>
    1091. 

  1091. 			  <td><input type="text" id="am_zip" name="am_zip" value="<?=$row_eid['Zip']?>" /></td>
    1092. 

  1092. 		  </tr>
    1093. 

  1093.                 <tr>
    1094. 

  1094.                   <td>Amount:</td>
    1095. 

  1095. 			  <td><input type="text" id="am_amt" name="am_amt" value="" autocomplete="off" /></td>
    1096. 

  1096. 		  </tr>
    1097. 

  1097.                 <tr>
    1098. 

  1098.                   <td>CC#:</td>
    1099. 

  1099. 			  <td><input type="text" id="am_cc_num" name="am_cc_num" value="<?=Decrypt($row_eid['ccNum'], $cart_misc)?>" autocomplete="off" /></td>
    1100. 

  1100. 		  </tr>
    1101. 

  1101.                 <tr>
    1102. 

  1102.                   <td>Exp. Date:</td>
    1103. 

  1103. 			  <td> 
    1104. 

  1104. 			    <select id="am_exp_mon" name="am_exp_mon">
    1105. 

  1105.   <?
    1106. 

  1106. 		$ccexp=explode('/',$row_eid['ccExp']);
    1107. 

  1107. 		for($i=1; $i<=12; $i++)
    1108. 

  1108. 		{
    1109. 

  1109. 			if($i<10)
    1110. 

  1110. 				$i = '0'.$i;
    1111. 

  1111. 			if($i == $ccexp[0])
    1112. 

  1112. 				echo '<option value="'.$i.'" selected="selected">'.$i.'</option>';
    1113. 

  1113. 			else if(date('n') == $i )
    1114. 

  1114. 				echo '<option value="'.$i.'" selected="selected">'.$i.'</option>';
    1115. 

  1115. 			else
    1116. 

  1116. 				echo '<option value="'.$i.'">'.$i.'</option>';
    1117. 

  1117. 		}
    1118. 

  1118. ?>
    1119. 

  1119. 			      </select>&nbsp;/&nbsp;
    1120. 

  1120. 			    <select id="am_exp_year" name="am_exp_year">
    1121. 

  1121.   <?
    1122. 

  1122. 		$cur_year = date('Y');
    1123. 

  1123. 		for($i=($cur_year); $i<=$cur_year+10; $i++)
    1124. 

  1124. 		{
    1125. 

  1125. 			if($i == $ccexp[1])
    1126. 

  1126. 				echo '<option value="'.$i.'" selected="selected">'.$i.'</option>';
    1127. 

  1127. 			elseif(date('Y') == $i || $i==$ccexp[1])
    1128. 

  1128. 				echo '<option value="'.$i.'" selected="selected">'.$i.'</option>';
    1129. 

  1129. 			else
    1130. 

  1130. 				echo '<option value="'.$i.'">'.$i.'</option>';
    1131. 

  1131. 		}
    1132. 

  1132. ?>				
    1133. 

  1133. 			      </select>			    </td>
    1134. 

  1134. 		  </tr>
    1135. 

  1135.                 <tr>
    1136. 

  1136.                   <td>CCV:</td>
    1137. 

  1137. 			  <td><input type="text" id="am_ccv" name="am_ccv" value="<?=$row_eid['ccCCV']?>" autocomplete="off" /></td>
    1138. 

  1138. 		  </tr>
    1139. 

  1139.                 <tr>
    1140. 

  1140.                   <td colspan="2" style="text-align: center"><input type="submit" id="am_submit" name="am_submit" value="Submit" /></td>
    1141. 

  1141. 		  </tr>
    1142. 

  1142.               </table>
    1143. 

  1143. 	  <input type="hidden" id="am_inv" name="am_inv" value="<?=$_GET["id"]?>" />
    1144. 

  1144.               <input type="hidden" id="am_type" name="am_type" value="AUTH_CAPTURE" />
    1145. 

  1145.               <input type="hidden" id="am_doedit" name="am_doedit" value="<?=$_GET['doedit']?>" />
    1146. 

  1146.             </form>
    1147. 

  1147.           </div>
    1148. 

  1148. 		    <?php
    1149. 

  1149. }
    1150. 

  1150. } // End of User permission check
    1151. 

  1151. 

  1152. 	// ADDED by Chad Apr-04-06
    1153. 

  1153. 	// LOCATION HISTORY
    1154. 

  1154. 	$qry = "SELECT * FROM location WHERE ordID = '".$_GET["id"]."'";
    1155. 

  1155. 	$res = mysql_query($qry) or print(mysql_error());
    1156. 

  1156. ?>
    1157. 

  1157. 		    <table width="300" cellpadding="3" cellspacing="0" style="margin: 10px auto; font-family: Verdana, Arial, Helvetica, sans-serif; border: 1px solid #4B1610; border-collapse: collapse">
    1158. 

  1158. 		      <tr style="border-bottom: 1px solid #4B1610">
    1159. 

  1159. 		        <td colspan="2" style="text-align: center; background-color: #4B1610; color: #FFFFFF; font-weight: bold">Location History</td>
    1160. 

  1160. 			  </tr>
    1161. 

  1161.   <?php
    1162. 

  1162. 	$i=0;
    1163. 

  1163. 	if(mysql_num_rows($res) > 0 ) {
    1164. 

  1164. 		while($row = mysql_fetch_assoc($res)) {
    1165. 

  1165. ?>
    1166. 

  1166. 		      <tr style="background-color: #<?=($i%2==0)?'903E36':'903E36'?>; border-bottom: 1px solid #4B1610">
    1167. 

  1167. 		        <td width="50%" style="color: #FFFFFF"><?=$row['location']?></td>
    1168. 

  1168. 				  <td style="color: #FFFFFF"><?=$row['stamp']?></td>
    1169. 

  1169. 			  </tr>
    1170. 

  1170.   <?php
    1171. 

  1171. 			$i++;
    1172. 

  1172. 		}
    1173. 

  1173. 	}else{
    1174. 

  1174. ?>
    1175. 

  1175. 		      <tr>
    1176. 

  1176. 		        <td colspan="2" style="text-align: center">No location found</td>
    1177. 

  1177. 			  </tr>
    1178. 

  1178.   <?php
    1179. 

  1179. 	}
    1180. 

  1180. ?>
    1181. 

  1181. 	        </table>
    1182. 

  1182. 		    <?php
    1183. 

  1183. 	// ADD ENDED
    1184. 

  1184. 	
    1185. 

  1185. 	// ADDED by Chad Apr-04-06
    1186. 

  1186. 	// FEDEX TRACKING
    1187. 

  1187. 	$qry = "SELECT * FROM fedex WHERE ordID = '".$_GET["id"]."'";
    1188. 

  1188. 	$res = mysql_query($qry);
    1189. 

  1189. 	if(mysql_num_rows($res) > 0) {
    1190. 

  1190. 		$row = mysql_fetch_assoc($res);
    1191. 

  1191. 		$trackNum = $row['trackNum'];
    1192. 

  1192. 		if(!empty($trackNum)) {
    1193. 

  1193. 			include(DOCROOT.'includes/fedex/fedexdc.php');
    1194. 

  1194. 			$fed = new FedExDC();
    1195. 

  1195. 			$track_Ret = $fed->track(
    1196. 

  1196. 				array(
    1197. 

  1197. 					'1537' => $trackNum, //Tracking Number
    1198. 

  1198. 					'1534' =>'Y' // detail_scan_indicator (Show me all the tracking data)
    1199. 

  1199. 				)
    1200. 

  1200. 			);
    1201. 

  1201. 			
    1202. 

  1202. 			$ctr = 0;
    1203. 

  1203. 			$hasChanged = false;
    1204. 

  1204. 			$isDelivered = false;
    1205. 

  1205. 			for($i=1; $i<=$track_Ret[1584]; $i++) {
    1206. 

  1206. 				// See Customer Service Page for displaying results
    1207. 

  1207. 	?>
    1208. 

  1208. 		    <div style="margin: 10px auto; border: 2px solid #2C578A; width: 550px">
    1209. 

  1209. 		      <table align="center" width="550" border="0" cellpadding="3" cellspacing="0" style="font-size: 10px; font-family: Verdana, Arial, Helvetica, sans-serif">
    1210. 

  1210. 		        <tr>
    1211. 

  1211. 		          <th colspan="2" style="font-size: 18px; background-color: #2C578A; color: #FFF; font-weight: bold; text-align: left">Fed<span style="margin-left: -3px; color: #FF6600">Ex</span></th>
    1212. 

  1212. 				  <th colspan="3" style="font-size: 14px; text-align: right; background-color: #2C578A; color: #FFF; font-weight: bold">Tracking# <?=$trackNum?></th>
    1213. 

  1213. 			  </tr>
    1214. 

  1214. 		        <?php
    1215. 

  1215. 			if(!empty($track_Ret['1339-'.$i]))
    1216. 

  1216. 			{
    1217. 

  1217. 				$tmp_date = $track_Ret['1339-'.$i];
    1218. 

  1218. 				$est_del = substr($tmp_date,0,4).'-'.substr($tmp_date,4,2).'-'.substr($tmp_date,6,2);
    1219. 

  1219. 	?>
    1220. 

  1220. 		        <tr>
    1221. 

  1221. 		          <td colspan="5" style="background-color: #2C578A; height: 15px">&nbsp;</td>
    1222. 

  1222. 			  </tr>
    1223. 

  1223. 		        <tr>
    1224. 

  1224. 		          <td colspan="5" style="background-color: #DFE7FF"><strong>Estimated Delivery Date:</strong> <?=date('M j, Y',strtotime($est_del))?></td>
    1225. 

  1225. 			  </tr>
    1226. 

  1226. 		        <?php
    1227. 

  1227. 			}
    1228. 

  1228. 	?>
    1229. 

  1229. 		        <tr>
    1230. 

  1230. 		          <th align="left" width="150" colspan="2" style="background-color: #2C578A; color: #FFF; font-weight: bold">Date/Time</th>
    1231. 

  1231. 				  <th align="left" style="background-color: #2C578A; color: #FFF; font-weight: bold">Activity</th>
    1232. 

  1232. 				  <th align="left" style="background-color: #2C578A; color: #FFF; font-weight: bold">Location</th>
    1233. 

  1233. 				  <th align="left" style="background-color: #2C578A; color: #FFF; font-weight: bold">Details</th>
    1234. 

  1234. 			  </tr>
    1235. 

  1235. 		        <?php
    1236. 

  1236. 				for($j=1; $j<=$track_Ret['1715-'.$i]; $j++)
    1237. 

  1237. 				{
    1238. 

  1238. 					$date = $track_Ret['1162-'.$i.'-'.$j];
    1239. 

  1239. 					$year = substr($date,0,4);
    1240. 

  1240. 					$mon = substr($date,4,2);
    1241. 

  1241. 					$day = substr($date,6,2);
    1242. 

  1242. 					$hrs = substr($track_Ret['1163-'.$i.'-'.$j],0,2);
    1243. 

  1243. 					$min = substr($track_Ret['1163-'.$i.'-'.$j],2,2);
    1244. 

  1244. 					$sec = substr($track_Ret['1163-'.$i.'-'.$j],4,2);
    1245. 

  1245. 					
    1246. 

  1246. 					$date = $year.'-'.$mon.'-'.$day.' '.$hrs.':'.$min.':'.$sec;
    1247. 

  1247. 					$unixDate = strtotime($date);
    1248. 

  1248. 					
    1249. 

  1249. 					if(empty($track_Ret['1161-'.$i.'-'.$j]))
    1250. 

  1250. 					{
    1251. 

  1251. 						$state = $track_Ret['1164-'.$i.'-'.$j];
    1252. 

  1252. 					}
    1253. 

  1253. 					else
    1254. 

  1254. 					{
    1255. 

  1255. 						$state = $track_Ret['1161-'.$i.'-'.$j];
    1256. 

  1256. 					}
    1257. 

  1257. 										
    1258. 

  1258. 					if(date('Ymd',$unixDate) != date('Ymd',$last_date))
    1259. 

  1259. 					{
    1260. 

  1260. 						$ctr++;
    1261. 

  1261. 						$hasChanged = true;
    1262. 

  1262. 					}
    1263. 

  1263. 					
    1264. 

  1264. 					if($track_Ret['1159-'.$i.'-'.$j] == 'Delivered' && empty($track_Ret['1711-'.$i.'-'.$j]))
    1265. 

  1265. 					{
    1266. 

  1266. 						$isDelivered = true;
    1267. 

  1267. 					}
    1268. 

  1268. 	?>
    1269. 

  1269. 		        <tr style="background-color: #<?=($ctr%2==0)?'FFF':'DFE7FF'?>">
    1270. 

  1270. 		          <?php
    1271. 

  1271. 						if($hasChanged)
    1272. 

  1272. 						{
    1273. 

  1273. 			?>
    1274. 

  1274. 		          <td style="text-align: left" valign="top">
    1275. 

  1275. 		            <span style="font-weight: bold"><?=date('M j, Y',$unixDate)?></span>		            </td>
    1276. 

  1276. 				    <td valign="top" style="text-align: right; border-right: 1px solid #<?=($ctr%2!=0)?'FFF':'DFE7FF'?>"><?=date('g:i A',$unixDate)?></td>
    1277. 

  1277. 			  <?php
    1278. 

  1278. 							$hasChanged = false;
    1279. 

  1279. 						}
    1280. 

  1280. 						else
    1281. 

  1281. 						{
    1282. 

  1282. 			?>
    1283. 

  1283. 		          <td valign="top" colspan="2" style="text-align: right; border-right: 1px solid #<?=($ctr%2!=0)?'FFF':'DFE7FF'?>"><?=date('g:i A',$unixDate)?></td>
    1284. 

  1284. 			  <?php
    1285. 

  1285. 						}
    1286. 

  1286. 			?>		
    1287. 

  1287. 		          </td>
    1288. 

  1288. 		        <td valign="top" style="border-right: 1px solid #<?=($ctr%2!=0)?'FFF':'DFE7FF'?>"><?=($isDelivered)?'<strong>':''?><?=$track_Ret['1159-'.$i.'-'.$j]?><?=($isDelivered)?'</strong>':''?></td>
    1289. 

  1289. 				  <td valign="top" style="border-right: 1px solid #<?=($ctr%2!=0)?'FFF':'DFE7FF'?>"><?=$track_Ret['1160-'.$i.'-'.$j]?>, <?=$state?></td>
    1290. 

  1290. 				  <td valign="top"><?=$track_Ret['1711-'.$i.'-'.$j]?></td>
    1291. 

  1291. 					  </tr>
    1292. 

  1292. 		        <?php
    1293. 

  1293. 					if($isDelivered)
    1294. 

  1294. 					{
    1295. 

  1295. 						$isDelivered = false;
    1296. 

  1296. 					}
    1297. 

  1297. 					
    1298. 

  1298. 					$last_date = $unixDate;
    1299. 

  1299. 				}
    1300. 

  1300. 			}
    1301. 

  1301. 	?>
    1302. 

  1302. 	          </table>
    1303. 

  1303.           </div>
    1304. 

  1304. 		    <?php
    1305. 

  1305. 		}
    1306. 

  1306. 	}
    1307. 

  1307. 	// ADD ENDED
    1308. 

  1308. 	
    1309. 

  1309. 	// ADDED by Chad Apr-03-06
    1310. 

  1310. 	// DHL AND USPS TRACKING
    1311. 

  1311. 	$qry = "SELECT * FROM dhl WHERE custPackID = '".$_GET["id"]."'";
    1312. 

  1312. 	$res = mysql_query($qry) or print(mysql_error());
    1313. 

  1313. 	if(mysql_num_rows($res) > 0) {
    1314. 

  1314. 		$row = mysql_fetch_assoc($res);
    1315. 

  1315. 		$trackNum = $row['DHLGMTrackNum'];
    1316. 

  1316. 		if(!empty($trackNum)) {
    1317. 

  1317. 			$ch = curl_init();
    1318. 

  1318. 			curl_setopt($ch,CURLOPT_URL,"http://api.smartmail.com/tnt2.cfm?number=$trackNum&criteria=3&type=wddx&custid=rband&passwd=sm36732");
    1319. 

  1319. 			//curl_setopt($ch, CURLOPT_POST, 1);
    1320. 

  1320. 			curl_setopt($ch,CURLOPT_HEADER,0);
    1321. 

  1321. 			curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    1322. 

  1322. 			//curl_setopt($ch, CURLOPT_POSTFIELDS, "number=$trackNum&criteria=3&type=wddx&custid=rband&passwd=sm36732");
    1323. 

  1323. 			$res = curl_exec($ch);
    1324. 

  1324. 			curl_close($ch);
    1325. 

  1325. 			$info = wddx_deserialize($res);
    1326. 

  1326. 			if(empty($info['Detail'][0])) { //If no errors
    1327. 

  1327. ?>
    1328. 

  1328. 		    <div style="height: 20px"></div>
    1329. 

  1329. 		    <table align="center" width="500" cellpadding="3" cellspacing="0" style="border: 1px solid #FFFFFF">
    1330. 

  1330. 		      <tr>
    1331. 

  1331. 		        <td colspan="2" style="color: #FFFFFF; background-color: #CC0000; text-align: center; font-weight: bold; font-size: 18px">DHL Tracking</td>
    1332. 

  1332. 			    </tr>
    1333. 

  1333.   <?php
    1334. 

  1334. 				if(!empty($info['TRACK_PKUP_DATE'][0])) {
    1335. 

  1335. ?>
    1336. 

  1336. 		      <tr>
    1337. 

  1337. 		        <td style="background-color: #FFCC00; text-align: left; font-weight: bold"><?=$info['TRACK_PKUP_DATE'][0]?></td>
    1338. 

  1338. 				  <td bordercolor="#FFFFFF" style="background-color: #FFCC00">Picked Up by SmartMail</td>
    1339. 

  1339. 			    </tr>
    1340. 

  1340.   <?php
    1341. 

  1341. 				}
    1342. 

  1342. 				if(!empty($info['TRACK_RECV_DATE'][0])) {
    1343. 

  1343. ?>
    1344. 

  1344. 		      <tr>
    1345. 

  1345. 		        <td style="background-color: #FFCC00; text-align: left; font-weight: bold"><?=$info['TRACK_RECV_DATE'][0]?></td>
    1346. 

  1346. 				  <td bordercolor="#FFFFFF" style="background-color: #FFCC00">Arrived at Smart Center</td>
    1347. 

  1347. 			    </tr>
    1348. 

  1348.   <?php
    1349. 

  1349. 				}
    1350. 

  1350. 				if(!empty($info['TRACK_ENCD_DATE'][0])) {
    1351. 

  1351. ?>
    1352. 

  1352. 		      <tr>
    1353. 

  1353. 		        <td style="background-color: #FFCC00; text-align: left; font-weight: bold"><?=$info['TRACK_ENCD_DATE'][0]?></td>
    1354. 

  1354. 				  <td bordercolor="#FFFFFF" style="background-color: #FFCC00">Processed and Verified</td>
    1355. 

  1355. 			    </tr>
    1356. 

  1356.   <?php
    1357. 

  1357. 				}
    1358. 

  1358. 				if(!empty($info['TRACK_DNSD_DATE'][0])) {
    1359. 

  1359. ?>
    1360. 

  1360. 		      <tr>
    1361. 

  1361. 		        <td style="background-color: #FFCC00; text-align: left; font-weight: bold"><?=$info['TRACK_DNSD_DATE'][0]?></td>
    1362. 

  1362. 				  <td bordercolor="#FFFFFF" style="background-color: #FFCC00">Sent via <?=(!empty($info['TRACK_DNDC'][0]))?$info['TRACK_DNDC'][0]:"SmartMail"?></td>
    1363. 

  1363. 			    </tr>
    1364. 

  1364.   <?php
    1365. 

  1365. 				}
    1366. 

  1366. 				if(!empty($info['TRACK_DNRC_DATE'][0])) {
    1367. 

  1367. ?>
    1368. 

  1368. 		      <tr>
    1369. 

  1369. 		        <td style="background-color: #FFCC00; text-align: left; font-weight: bold"><?=$info['TRACK_DNRC_DATE'][0]?></td>
    1370. 

  1370. 				  <td bordercolor="#FFFFFF" style="background-color: #FFCC00">Received</td>
    1371. 

  1371. 			    </tr>
    1372. 

  1372.   <?php
    1373. 

  1373. 				}
    1374. 

  1374. 				if(!empty($info['TRACK_MFST_DATE'][0])) {
    1375. 

  1375. ?>
    1376. 

  1376. 		      <tr>
    1377. 

  1377. 		        <td style="background-color: #FFCC00; text-align: left; font-weight: bold"><?=$info['TRACK_MFST_DATE'][0]?></td>
    1378. 

  1378. 				  <td bordercolor="#FFFFFF" style="background-color: #FFCC00">Mail Delivered to Post Office</td>
    1379. 

  1379. 			    </tr>
    1380. 

  1380.   <?php
    1381. 

  1381. 				}
    1382. 

  1382. ?>
    1383. 

  1383. 		      </table>
    1384. 

  1384. 		    <?php
    1385. 

  1385. 				// CHECK USPS TRACKING INFO
    1386. 

  1386. 				if(!empty($info['TRACK_DELV_CONF'][0])) {
    1387. 

  1387. 					$ch = curl_init();
    1388. 

  1388. 					curl_setopt($ch,CURLOPT_URL,"http://Production.ShippingAPIs.com/ShippingAPI.dll");
    1389. 

  1389. 					curl_setopt($ch, CURLOPT_POST, 1);
    1390. 

  1390. 					curl_setopt($ch,CURLOPT_HEADER,0);
    1391. 

  1391. 					curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
    1392. 

  1392. 					curl_setopt($ch, CURLOPT_POSTFIELDS, 'API=TrackV2&XML=<TrackFieldRequest USERID="268REMIN3619"><TrackID ID="'.$info['TRACK_DELV_CONF'][0].'"></TrackID></TrackFieldRequest>');
    1393. 

  1393. 					$res = curl_exec($ch);
    1394. 

  1394. 					curl_close($ch);
    1395. 

  1395. 					
    1396. 

  1396. 					include(APPPATH.'views/pages/admin/xml2array.php');
    1397. 

  1397. 					
    1398. 

  1398. 					$xmlData = new xml2array();
    1399. 

  1399. 					$uspsData = $xmlData -> parseXMLintoarray($res);
    1400. 

  1400. ?>
    1401. 

  1401. 		    <div style="margin: 5px auto; width: 500px">
    1402. 

  1402. 		      
    1403. 

  1403. 		      <div style="margin: 0; height: 5px; background-color: #CC0000"></div>
    1404. 

  1404. 			    <div style="margin: 0; padding: 2px; background-color: #0066CB; color: #FFFFFF; font-weight: bold; font-size: 18px; text-align: center">USPS Tracking<br /><span style="font-size: 11px">Tracking # <?=$info['TRACK_DELV_CONF'][0]?></span></div>
    1405. 

  1405. 			    <div style="margin: 0; height: 7px; background-color: #98CCFF"></div>
    1406. 

  1406. 			    <div style="margin: 2px 0 0 0; background-color: #E3F1FC; border: 1px solid #89B9E7">
    1407. 

  1407.   <?php				
    1408. 

  1408. 					if(is_array($uspsData['TrackResponse']['TrackInfo']['Error'])) {
    1409. 

  1409. 						echo '<div style="margin: 0; text-align: center; font-weight: bold">Error Getting USPS Tracking Information</div>';
    1410. 

  1410. 					}else{
    1411. 

  1411. 						if(is_array($uspsData['TrackResponse']['TrackInfo']['TrackSummary'])) {
    1412. 

  1412. 							$eventTime = $uspsData['TrackResponse']['TrackInfo']['TrackSummary']['EventDate'].' '.$uspsData['TrackResponse']['TrackInfo']['TrackSummary']['EventTime'];
    1413. 

  1413. ?>
    1414. 

  1414. 				    <div style="margin: 0; padding: 3px; background-color: #89B9E7; color: #FFFFFF; font-weight: bold">Event Summary</div>
    1415. 

  1415. 				    <div style="margin: 0">
    1416. 

  1416. 				      <table width="500" border="0" cellpadding="3" cellspacing="0" style="margin: 2px;">
    1417. 

  1417. 					      <tr>
    1418. 

  1418. 					        <td valign="top" style="font-weight: bold"><?=$eventTime?></td>
    1419. 

  1419. 							  <td valign="top"><?=$uspsData['TrackResponse']['TrackInfo']['TrackSummary']['EventCity']?>, <?=$uspsData['TrackResponse']['TrackInfo']['TrackSummary']['EventState']?></td>
    1420. 

  1420. 							  <td valign="top"><?=$uspsData['TrackResponse']['TrackInfo']['TrackSummary']['Event']?></td>
    1421. 

  1421. 						  </tr>
    1422. 

  1422. 			          </table>
    1423. 

  1423. 				    </div>
    1424. 

  1424.   <?php
    1425. 

  1425. 						}
    1426. 

  1426. 						if(is_array($uspsData['TrackResponse']['TrackInfo']['TrackDetail'])) {
    1427. 

  1427. ?>
    1428. 

  1428. 				    <div style="margin: 0; padding: 3px; background-color: #89B9E7; color: #FFFFFF; font-weight: bold">Tracking Details</div>
    1429. 

  1429. 				    <table width="500" border="0" align="center" cellpadding="3" cellspacing="0" style="margin: 2px;">
    1430. 

  1430.   <?php
    1431. 

  1431. 							if(is_array($uspsData['TrackResponse']['TrackInfo']['TrackDetail'][0])){
    1432. 

  1432. 								for($i=0; $i<count($uspsData['TrackResponse']['TrackInfo']['TrackDetail']); $i++) {
    1433. 

  1433. 									$eventTime = $uspsData['TrackResponse']['TrackInfo']['TrackDetail'][$i]['EventDate'].' '.$uspsData['TrackResponse']['TrackInfo']['TrackDetail'][$i]['EventTime'];
    1434. 

  1434. ?>
    1435. 

  1435. 					    <tr>
    1436. 

  1436. 					      <td valign="top" style="font-weight: bold"><?=$eventTime?></td>
    1437. 

  1437. 						    <td valign="top"><?=$uspsData['TrackResponse']['TrackInfo']['TrackDetail'][$i]['EventCity']?>, <?=$uspsData['TrackResponse']['TrackInfo']['TrackDetail'][$i]['EventState']?></td>
    1438. 

  1438. 						    <td valign="top"><?=$uspsData['TrackResponse']['TrackInfo']['TrackDetail'][$i]['Event']?></td>
    1439. 

  1439. 					    </tr>
    1440. 

  1440.   <?php
    1441. 

  1441. 								} // End of TrackDetail Loop
    1442. 

  1442. 							}else{
    1443. 

  1443. 								$eventTime = $uspsData['TrackResponse']['TrackInfo']['TrackDetail']['EventDate'].' '.$uspsData['TrackResponse']['TrackInfo']['TrackDetail']['EventTime'];
    1444. 

  1444. ?>
    1445. 

  1445. 					    <tr>
    1446. 

  1446. 					      <td valign="top" style="font-weight: bold"><?=$eventTime?></td>
    1447. 

  1447. 						    <td valign="top"><?=$uspsData['TrackResponse']['TrackInfo']['TrackDetail']['EventCity']?>, <?=$uspsData['TrackResponse']['TrackInfo']['TrackDetail']['EventState']?></td>
    1448. 

  1448. 						    <td valign="top"><?=$uspsData['TrackResponse']['TrackInfo']['TrackDetail']['Event']?></td>
    1449. 

  1449. 					    </tr>
    1450. 

  1450.   <?php
    1451. 

  1451. 							}
    1452. 

  1452. ?>
    1453. 

  1453. 			        </table>
    1454. 

  1454.   <?php
    1455. 

  1455. 						} // End of displaying all Tracking Details
    1456. 

  1456. 					} // End of displaying all USPS tracking information
    1457. 

  1457. ?>
    1458. 

  1458. 		        </div>
    1459. 

  1459. 			</div>
    1460. 

  1460. 		    <?php
    1461. 

  1461. 				}
    1462. 

  1462. 			}
    1463. 

  1463. 		}
    1464. 

  1464. 	}
    1465. 

  1465. 	
    1466. 

  1466. 	// ADD ENDED
    1467. 

  1467. 	
    1468. 

  1468. }elseif(!empty($_REQUEST['ship_to_logan'])) {
    1469. 

  1469. ?>
    1470. 

  1470.             <h2 style="margin-left: 20px">Provide Reason for Change of Status to Shipping from Logan</h2>
    1471. 

  1471. 		    <form id="mainform" action="<?=$_SERVER['PHP_SELF']?>" method="post">
    1472. 

  1472. 		      <table align="center" width="100%" border="0" cellspacing="1" cellpadding="2" bgcolor="" style="margin-top: 20px;">
    1473. 

  1473. 		        <tr>
    1474. 

  1474. 		          <td colspan="6">&nbsp;</td>
    1475. 

  1475. 			  <td align="center"><strong>Master Reason for Change</strong><br /><textarea name="master_reason" id="master_reason" rows="2" cols="17"></textarea></td>
    1476. 

  1476. 		  </tr>
    1477. 

  1477. 		        <tr bgcolor="#030133">
    1478. 

  1478. 		          <td align="center"><strong><font color="#E7EAEF"><?php print $yyOrdId?></font></strong></td>
    1479. 

  1479. 			  <td align="center"><strong><font color="#E7EAEF"><?php print $yyName?></font></strong></td>
    1480. 

  1480. 			  <td align="center"><strong><font color="#E7EAEF"><?php print $yyShipMe?></font></strong></td>
    1481. 

  1481. 			  <td align="center"><strong><font color="#E7EAEF">Status</font></strong></td>
    1482. 

  1482. 			  <td align="center"><strong><font color="#E7EAEF"><?php print $yyBatDate?></font></strong></td>
    1483. 

  1483. 			  <td align="center"><strong><font color="#E7EAEF"><?php print $yyOrdDate?></font></strong></td>
    1484. 

  1484. 			  <td align="center"><strong><font color="#E7EAEF">Reason for Change</font></strong></td>
    1485. 

  1485. 		  </tr>
    1486. 

  1486.   <?php
    1487. 

  1487. 	foreach($_REQUEST['orders'] as $order) {
    1488. 

  1488. 		$sql = "SELECT * FROM orders WHERE ordID = " . $order;
    1489. 

  1489. 		$res = mysql_query($sql) or print(mysql_error());
    1490. 

  1490. 		$row = mysql_fetch_assoc($res);
    1491. 

  1491. 		
    1492. 

  1492. 		$sql_st = "SELECT os.statPrivate FROM orderstatus os, orders o
    1493. 

  1493. 				   WHERE o.ordStatus = os.statID
    1494. 

  1494. 				   AND o.ordID = " . $order;
    1495. 

  1495. 		$res_st = mysql_query($sql_st) or print(mysql_error());
    1496. 

  1496. 		$row_st = mysql_fetch_assoc($res_st);
    1497. 

  1497. 		
    1498. 

  1498. 		$sql_b = "select * from location l where ordID = ". $order ." and l.location = 'Packing'";
    1499. 

  1499. 		$result_b = mysql_query($sql_b);
    1500. 

  1500. 		$row_b = mysql_fetch_assoc($result_b);
    1501. 

  1501. 		
    1502. 

  1502. 		if(@$bgcolor=="#E7EAEF") $bgcolor="#EAECEB"; else $bgcolor="#E7EAEF";
    1503. 

  1503. ?>
    1504. 

  1504. 		        <tr bgcolor="<?=$bgcolor?>">
    1505. 

  1505. 		          <td align="center"><?=$row['ordID']?></td>
    1506. 

  1506. 			  <td align="center"><?=$row['ordName']?></td>
    1507. 

  1507. 			  <td align="center"><?=$row['ordShipType']?></td>
    1508. 

  1508. 			  <td align="center"><?=$row_st['statPrivate']?><input name="oldstatus_<?=$order?>" type="text" value="<?=$row['ordStatus']?>" /></td>
    1509. 

  1509. 			  <td align="center"><?=$row_b['stamp']?></td>
    1510. 

  1510. 			  <td align="center"><?=$row['ordDate']?></td>
    1511. 

  1511. 			  <td align="center"><textarea name="reason<?=$order?>" rows="2" cols="17"></textarea></td>
    1512. 

  1512. 		  </tr>
    1513. 

  1513.   <?php
    1514. 

  1514. 	}
    1515. 

  1515. ?>
    1516. 

  1516. 		        <tr>
    1517. 

  1517. 		          <td colspan="7" align="center"><input type="submit" id="ship_to_logan_final" name="ship_to_logan_final" value="Update Statuses" /></td>
    1518. 

  1518. 		  </tr>
    1519. 

  1519. 	          </table>
    1520. 

  1520. 	          </form>
    1521. 

  1521. 		    <p>&nbsp;</p>
    1522. 

  1522. 		    <?php
    1523. 

  1523. }elseif(!empty($_REQUEST['ship_to_logan_final'])) {
    1524. 

  1524. 	$aReasons = array();
    1525. 

  1525. 	$i=0;
    1526. 

  1526. 	foreach($_REQUEST as $key => $request) {
    1527. 

  1527. 		if(eregi("^reason",$key)) {
    1528. 

  1528. 			$aReasons[$i]['order'] = substr($key,6);
    1529. 

  1529. 			$aReasons[$i]['oldstatus'] = $_REQUEST['oldstatus_'.substr($key,6)];
    1530. 

  1530. 			if(!empty($_REQUEST['master_reason'])) {
    1531. 

  1531. 				$aReasons[$i]['reason'] = $_REQUEST['master_reason'];
    1532. 

  1532. 			}else{
    1533. 

  1533. 				$aReasons[$i]['reason'] = $request;
    1534. 

  1534. 			}
    1535. 

  1535. 			$i++;
    1536. 

  1536. 		}
    1537. 

  1537. 	}
    1538. 

  1538. 	//showarray($aReasons); exit();
    1539. 

  1539. 	for($i=0; $i<count($aReasons); $i++) {
    1540. 

  1540. 		$sql = "UPDATE orders 
    1541. 

  1541. 				SET ordStatus = 10, ordStatusDate = '".date("Y-m-d H:i:s")."'
    1542. 

  1542. 				WHERE ordID = " . $aReasons[$i]['order'];
    1543. 

  1543. 		$res = mysql_query($sql) or print(mysql_error());
    1544. 

  1544. 		
    1545. 

  1545. 		setNewLocation(10,$aReasons[$i]['order'],'Manual',$aReasons[$i]['reason']);
    1546. 

  1546. 		//release stock if old status !=10 and >=3
    1547. 

  1547. 		if($aReasons[$i]['oldstatus']!=10 && $aReasons[$i]['oldstatus']!=17 && $aReasons[$i]['oldstatus']>=3) release_stock($smOrdId);
    1548. 

  1548. 	}	
    1549. 

  1549. ?>	
    1550. 

  1550.             <script language="JavaScript" type="text/javascript">
    1551. 

  1551. <!--
    1552. 

  1552. setTimeout("window.location = '/admin/hksearch.php'",4000);
    1553. 

  1553. // -->
    1554. 

  1554.             </script>
    1555. 

  1555.             <table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="" align="center">
    1556. 

  1556.               <tr>
    1557. 

  1557.                 <td width="100%">
    1558. 

  1558.                   <table width="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="">
    1559. 

  1559.                     <tr> 
    1560. 

  1560.                       <td width="100%" colspan="4" align="center"><br /><strong><?php print $yyUpdSuc?></strong><br /><br />You will now be forwarded to the HK Search Page<br /><br />
    1561. 

  1561. 		                      <?php print $yyNoAuto?> <a href="javascript:window.location='/admin/hksearch.php'"><strong><?php print $yyClkHer?></strong></a>.<br /><br />
    1562. 

  1562. 		                      <img src="/lib/images/misc/clearpixel.gif" width="300" height="3" alt="" /></td>
    1563. 

  1563. 			    </tr>
    1564. 

  1564.                   </table>		    </td>
    1565. 

  1565. 		  </tr>
    1566. 

  1566.                   </table>
    1567. 

  1567. 		    <?php
    1568. 

  1568. }elseif(!empty($_REQUEST['send_packing'])) {
    1569. 

  1569. ?>
    1570. 

  1570.             <h2 style="margin-left: 20px">Provide Reason for Change of Status to Packing</h2>
    1571. 

  1571. 		    <form id="mainform" action="<?=$_SERVER['PHP_SELF']?>" method="post">
    1572. 

  1572. 		      <table align="center" width="100%" border="0" cellspacing="1" cellpadding="2" bgcolor="" style="margin-top: 20px;">
    1573. 

  1573. 		        <tr>
    1574. 

  1574. 		          <td colspan="6">&nbsp;</td>
    1575. 

  1575. 			  <td align="center"><strong>Master Reason for Change</strong><br /><textarea name="master_reason" id="master_reason" rows="2" cols="17"></textarea></td>
    1576. 

  1576. 		  </tr>
    1577. 

  1577. 		        <tr bgcolor="#030133">
    1578. 

  1578. 		          <td align="center"><strong><font color="#E7EAEF"><?php print $yyOrdId?></font></strong></td>
    1579. 

  1579. 			  <td align="center"><strong><font color="#E7EAEF"><?php print $yyName?></font></strong></td>
    1580. 

  1580. 			  <td align="center"><strong><font color="#E7EAEF"><?php print $yyShipMe?></font></strong></td>
    1581. 

  1581. 			  <td align="center"><strong><font color="#E7EAEF">Status</font></strong></td>
    1582. 

  1582. 			  <td align="center"><strong><font color="#E7EAEF"><?php print $yyBatDate?></font></strong></td>
    1583. 

  1583. 			  <td align="center"><strong><font color="#E7EAEF"><?php print $yyOrdDate?></font></strong></td>
    1584. 

  1584. 			  <td align="center"><strong><font color="#E7EAEF">Reason for Change</font></strong></td>
    1585. 

  1585. 		  </tr>
    1586. 

  1586.   <?php
    1587. 

  1587. 	foreach($_REQUEST['orders'] as $order) {
    1588. 

  1588. 		$sql = "SELECT * FROM orders WHERE ordID = " . $order;
    1589. 

  1589. 		$res = mysql_query($sql) or print(mysql_error());
    1590. 

  1590. 		$row = mysql_fetch_assoc($res);
    1591. 

  1591. 		
    1592. 

  1592. 		$sql_st = "SELECT os.statPrivate FROM orderstatus os, orders o
    1593. 

  1593. 				   WHERE o.ordStatus = os.statID
    1594. 

  1594. 				   AND o.ordID = " . $order;
    1595. 

  1595. 		$res_st = mysql_query($sql_st) or print(mysql_error());
    1596. 

  1596. 		$row_st = mysql_fetch_assoc($res_st);
    1597. 

  1597. 		
    1598. 

  1598. 		// Get Batch Date
    1599. 

  1599. 		$sql_b = "select * from location l where ordID = ". $order ." and l.location = 'Packing'";
    1600. 

  1600. 		$result_b = mysql_query($sql_b);
    1601. 

  1601. 		$row_b = mysql_fetch_assoc($result_b);
    1602. 

  1602. 		
    1603. 

  1603. 		if(@$bgcolor=="#E7EAEF") $bgcolor="#EAECEB"; else $bgcolor="#E7EAEF";
    1604. 

  1604. ?>
    1605. 

  1605. 		        <tr bgcolor="<?=$bgcolor?>">
    1606. 

  1606. 		          <td align="center"><?=$row['ordID']?></td>
    1607. 

  1607. 			  <td align="center"><?=$row['ordName']?></td>
    1608. 

  1608. 			  <td align="center"><?=$row['ordShipType']?></td>
    1609. 

  1609. 			  <td align="center"><?=$row_st['statPrivate']?></td>
    1610. 

  1610. 			  <td align="center"><?=$row_b['stamp']?></td>
    1611. 

  1611. 			  <td align="center"><?=$row['ordDate']?></td>
    1612. 

  1612. 			  <td align="center"><textarea name="reason<?=$order?>" rows="2" cols="17"></textarea></td>
    1613. 

  1613. 		  </tr>
    1614. 

  1614.   <?php
    1615. 

  1615. 	}
    1616. 

  1616. ?>
    1617. 

  1617. 		        <tr>
    1618. 

  1618. 		          <td colspan="7" align="center"><input type="submit" id="send_packing_final" name="send_packing_final" value="Update Statuses" /></td>
    1619. 

  1619. 		  </tr>
    1620. 

  1620. 	          </table>
    1621. 

  1621. 	          </form>
    1622. 

  1622. 		    <p>&nbsp;</p>
    1623. 

  1623. 		    <?php
    1624. 

  1624. }elseif(!empty($_REQUEST['send_packing_final'])) {
    1625. 

  1625. 	$aReasons = array();
    1626. 

  1626. 	$i=0;
    1627. 

  1627. 	foreach($_REQUEST as $key => $request) {
    1628. 

  1628. 		if(eregi("^reason",$key)) {
    1629. 

  1629. 			$aReasons[$i]['order'] = substr($key,6);
    1630. 

  1630. 			if(!empty($_REQUEST['master_reason'])) {
    1631. 

  1631. 				$aReasons[$i]['reason'] = $_REQUEST['master_reason'];
    1632. 

  1632. 			}else{
    1633. 

  1633. 				$aReasons[$i]['reason'] = $request;
    1634. 

  1634. 			}
    1635. 

  1635. 			$i++;
    1636. 

  1636. 		}
    1637. 

  1637. 	}
    1638. 

  1638. 	//showarray($aReasons); exit();
    1639. 

  1639. 	for($i=0; $i<count($aReasons); $i++) {
    1640. 

  1640. 		$sql = "UPDATE orders 
    1641. 

  1641. 				SET ordStatus = 6, ordStatusDate = '".date("Y-m-d H:i:s")."'
    1642. 

  1642. 				WHERE ordID = " . $aReasons[$i]['order'];
    1643. 

  1643. 		$res = mysql_query($sql) or print(mysql_error());
    1644. 

  1644. 		
    1645. 

  1645. 		setNewLocation(6,$aReasons[$i]['order'],'Manual',$aReasons[$i]['reason']);
    1646. 

  1646. 	}	
    1647. 

  1647. ?>	
    1648. 

  1648.             <script language="JavaScript" type="text/javascript">
    1649. 

  1649. <!--
    1650. 

  1650. setTimeout("window.location = '/admin/hksearch.php'",4000);
    1651. 

  1651. // -->
    1652. 

  1652.             </script>
    1653. 

  1653.             <table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="" align="center">
    1654. 

  1654.               <tr>
    1655. 

  1655.                 <td width="100%">
    1656. 

  1656.                   <table width="100%" border="0" cellspacing="0" cellpadding="2" bgcolor="">
    1657. 

  1657.                     <tr> 
    1658. 

  1658.                       <td width="100%" colspan="4" align="center"><br /><strong><?php print $yyUpdSuc?></strong><br /><br />You will now be forwarded to the HK Search Page<br /><br />
    1659. 

  1659. 		                      <?php print $yyNoAuto?> <a href="javascript:window.location='/admin/hksearch.php'"><strong><?php print $yyClkHer?></strong></a>.<br /><br />
    1660. 

  1660. 		                      <img src="/lib/images/misc/clearpixel.gif" width="300" height="3" alt="" /></td>
    1661. 

  1661. 			    </tr>
    1662. 

  1662.                   </table>		    </td>
    1663. 

  1663. 		  </tr>
    1664. 

  1664.                   </table>
    1665. 

  1665. 		    <?php
    1666. 

  1666. }else{
    1667. 

  1667. 	if(@$_POST["sd"] != "")
    1668. 

  1668. 		$sd = @$_POST["sd"];
    1669. 

  1669. 	elseif(@$_GET["sd"] != "")
    1670. 

  1670. 		$sd = @$_GET["sd"];
    1671. 

  1671. 	else
    1672. 

  1672. 		$sd = date($admindatestr, time() + ($dateadjust*60*60));
    1673. 

  1673. 	if(@$_POST["ed"] != "")
    1674. 

  1674. 		$ed = @$_POST["ed"];
    1675. 

  1675. 	elseif(@$_GET["ed"] != "")
    1676. 

  1676. 		$ed = @$_GET["ed"];
    1677. 

  1677. 	else
    1678. 

  1678. 		$ed = date($admindatestr, time() + ($dateadjust*60*60));
    1679. 

  1679. 	$sd = parsedate($sd);
    1680. 

  1680. 	$ed = parsedate($ed);
    1681. 

  1681. 	if($sd > $ed) $ed = $sd;
    1682. 

  1682. 	$fromdate = trim(@$_POST["fromdate"]);
    1683. 

  1683. 	$todate = trim(@$_POST["todate"]);
    1684. 

  1684. 	$ordid = trim(str_replace('"',"",str_replace("'","",@$_POST["ordid"])));
    1685. 

  1685. 	$origsearchtext = trim(unstripslashes(@$_POST["searchtext"]));
    1686. 

  1686. 	$searchtext = trim(mysql_real_escape_string(unstripslashes(@$_POST["searchtext"])));
    1687. 

  1687. 	$ordstatus = "";
    1688. 

  1688. 	if(@$_POST["powersearch"]=="1" && !empty($_POST['searchby'])){
    1689. 

  1689. 		$sSQL = "SELECT o.ordID,ordName,ordDate, ordAuthNumber, ordShipType,l.stamp,ordStatus,ordTotal-ordDiscount AS ordTot,ordTransID,ordEID FROM orders o INNER JOIN location l ON l.ordID=o.ordID WHERE ordStatus>=0  ";
    1690. 

  1690. 		$addcomma = "";
    1691. 

  1691. 		if(is_array(@$_POST["ordstatus"])){
    1692. 

  1692. 			foreach($_POST["ordstatus"] as $objValue){
    1693. 

  1693. 				if(is_array($objValue))$objValue=$objValue[0];
    1694. 

  1694. 				$ordstatus .= $addcomma . $objValue;
    1695. 

  1695. 				$addcomma = ",";
    1696. 

  1696. 			}
    1697. 

  1697. 		}else
    1698. 

  1698. 			$ordstatus = trim((string)@$_POST["ordstatus"]);
    1699. 

  1699. 		//discounts
    1700. 

  1700. 		
    1701. 

  1701. 			if($_POST['searchby'] == "invoice" && $_POST['invoice_number'] != ""){
    1702. 

  1702. 				$sSQL .= ' AND o.ordID="'.$_POST['invoice_number'].'" group by o.ordID';
    1703. 

  1703. 			}
    1704. 

  1704. 			elseif($_POST['searchby'] == "status" && $_POST['ordstatus'] != ""){
    1705. 

  1705. 				if($ordstatus == 9999) {	
    1706. 

  1706. 					$ordstatus = '3,4,6';
    1707. 

  1707. 				}
    1708. 

  1708. 				$sSQL .= " AND ordStatus IN (".$ordstatus.") group by o.ordID";
    1709. 

  1709. 			}
    1710. 

  1710. 			elseif($_POST['searchby'] == "name" && $_POST['order_name'] != ""){
    1711. 

  1711. 				$sSQL .= " AND (ordName like '%" . $_POST['order_name'] . "%' or ordShipName like '%" . $_POST['order_name'] . "%') group by o.ordID";
    1712. 

  1712. 			}
    1713. 

  1713. 			elseif($_POST['searchby'] == "batches" && $_POST['batch_to'] != "" && $_POST['batch_from'] != ""){
    1714. 

  1714. 				$sSQL .= ' AND l.statNum=6 AND l.stamp BETWEEN "' . $_POST['batch_from'] . ' 00:00:00" AND "' . $_POST['batch_to'] . ' 23:59:59"';
    1715. 

  1715. 			}
    1716. 

  1716. 		$sSQL .= " ORDER BY ordID DESC".(($_POST['batches_to'] != "" && $_POST['batches_from'] != "")?',l.stamp DESC':'');
    1717. 

  1717. 	}else{
    1718. 

  1718. 		$sSQL = "SELECT * FROM orders WHERE ordStatus = 6"; // Purposely querying 0 results for default view
    1719. 

  1719. 	}
    1720. 

  1720. 	$alldata = mysql_query($sSQL) or print(mysql_error());
    1721. 

  1721. 	$num_of_listed = mysql_num_rows($alldata);
    1722. 

  1722. 	//echo $sSQL;
    1723. 

  1723. 	//showarray($_POST);
    1724. 

  1724. ?>
    1725. 

  1725.             <script language="JavaScript" type="text/javascript" src="/lib/js/util/popcalendar.js"></script>
    1726. 

  1726.             <script language="JavaScript" type="text/javascript" src="http://assets.ifrogz.com/lib/packages/scriptaculous-js/1.5.1/prototype.js"></script>
    1727. 

  1727.             <script language="JavaScript" type="text/javascript" src="http://assets.ifrogz.com/lib/packages/scriptaculous-js/1.5.1/scriptaculous.js"></script>
    1728. 

  1728.             <script language="JavaScript" type="text/javascript">
    1729. 

  1729. <!--
    1730. 

  1730. function showCell() {
    1731. 

  1731. 	var val = $('searchby').value;
    1732. 

  1732. 	
    1733. 

  1733. 	if(val == 'invoice') {
    1734. 

  1734. 		resetCells();
    1735. 

  1735. 		$('invoice').style.display = 'block';
    1736. 

  1736. 	}else if(val == 'batches') {
    1737. 

  1737. 		resetCells();
    1738. 

  1738. 		$('batches').style.display = 'block';
    1739. 

  1739. 	}else if(val == 'name') {
    1740. 

  1740. 		resetCells();
    1741. 

  1741. 		$('name').style.display = 'block';
    1742. 

  1742. 	}else if(val == 'status') {
    1743. 

  1743. 		resetCells();
    1744. 

  1744. 		$('status').style.display = 'block';
    1745. 

  1745. 	}
    1746. 

  1746. }
    1747. 

  1747. 

  1748. function resetCells() {
    1749. 

  1749. 	$('invoice').style.display = 'none';
    1750. 

  1750. 	$('batches').style.display = 'none';
    1751. 

  1751. 	$('name').style.display = 'none';
    1752. 

  1752. 	$('status').style.display = 'none';
    1753. 

  1753. }
    1754. 

  1754. 

  1755. function delrec(id) {
    1756. 

  1756. cmsg = "<?php print $yyConDel?>\n"
    1757. 

  1757. if (confirm(cmsg)) {
    1758. 

  1758. 	document.mainform.id.value = id;
    1759. 

  1759. 	document.mainform.act.value = "delete";
    1760. 

  1760. 	document.mainform.sd.value="<?php print date($admindatestr, $sd)?>";
    1761. 

  1761. 	document.mainform.ed.value="<?php print date($admindatestr, $ed)?>";
    1762. 

  1762. 	document.mainform.submit();
    1763. 

  1763. }
    1764. 

  1764. }
    1765. 

  1765. function authrec(id) {
    1766. 

  1766. var aucode;
    1767. 

  1767. cmsg = "<?php print $yyEntAuth?>"
    1768. 

  1768. if ((aucode=prompt(cmsg,'<?php print $yyManAut?>')) != null) {
    1769. 

  1769. 	document.mainform.id.value = id;
    1770. 

  1770. 	document.mainform.act.value = "authorize";
    1771. 

  1771. 	document.mainform.authcode.value = aucode;
    1772. 

  1772. 	document.mainform.sd.value="<?php print date($admindatestr, $sd)?>";
    1773. 

  1773. 	document.mainform.ed.value="<?php print date($admindatestr, $ed)?>";
    1774. 

  1774. 	document.mainform.submit();
    1775. 

  1775. }
    1776. 

  1776. }
    1777. 

  1777. function checkcontrol(tt,evt){
    1778. 

  1778. <?php if(strstr(@$HTTP_SERVER_VARS["HTTP_USER_AGENT"], "Gecko")){ ?>
    1779. 

  1779. theevnt = evt;
    1780. 

  1780. return;
    1781. 

  1781. <?php }else{ ?>
    1782. 

  1782. theevnt=window.event;
    1783. 

  1783. <?php } ?>
    1784. 

  1784. if(theevnt.ctrlKey){
    1785. 

  1785. 	maxitems=document.mainform.maxitems.value;
    1786. 

  1786. 	for(index=0;index<maxitems;index++){
    1787. 

  1787. 		if(eval('document.mainform.ordstatus'+index+'.length') > tt.selectedIndex){
    1788. 

  1788. 			eval('document.mainform.ordstatus'+index+'.selectedIndex='+tt.selectedIndex);
    1789. 

  1789. 			eval('document.mainform.ordstatus'+index+'.options['+tt.selectedIndex+'].selected=true');
    1790. 

  1790. 		}
    1791. 

  1791. 	}
    1792. 

  1792. }
    1793. 

  1793. }
    1794. 

  1794. function displaysearch(){
    1795. 

  1795. thestyle = document.getElementById('searchspan').style;
    1796. 

  1796. if(thestyle.display=='none')
    1797. 

  1797. 	thestyle.display = 'block';
    1798. 

  1798. else
    1799. 

  1799. 	thestyle.display = 'none';
    1800. 

  1800. }
    1801. 

  1801. function checkprinter(tt,evt){
    1802. 

  1802. <?php if(strstr(@$HTTP_SERVER_VARS["HTTP_USER_AGENT"], "Gecko")){ ?>
    1803. 

  1803. if(evt.ctrlKey || evt.altKey || document.mainform.ctrlmod[document.mainform.ctrlmod.selectedIndex].value=="1"){
    1804. 

  1804. 	tt.href += "&printer=true";
    1805. 

  1805. 	window.location.href = tt.href;
    1806. 

  1806. }
    1807. 

  1807. if(document.mainform.ctrlmod[document.mainform.ctrlmod.selectedIndex].value=="2"){
    1808. 

  1808. 	tt.href += "&doedit=true";
    1809. 

  1809. 	window.location.href = tt.href;
    1810. 

  1810. }
    1811. 

  1811. <?php }else{ ?>
    1812. 

  1812. theevnt=window.event;
    1813. 

  1813. if(theevnt.ctrlKey || document.mainform.ctrlmod[document.mainform.ctrlmod.selectedIndex].value=="1")tt.href += "&printer=true";
    1814. 

  1814. if(document.mainform.ctrlmod[document.mainform.ctrlmod.selectedIndex].value=="2")tt.href += "&doedit=true";
    1815. 

  1815. <?php } ?>
    1816. 

  1816. return(true);
    1817. 

  1817. }
    1818. 

  1818. // -->
    1819. 

  1819.             </script>
    1820. 

  1820. 		    
    1821. 

  1821.             <table border="0" cellspacing="0" cellpadding="0" width="100%" bgcolor="">
    1822. 

  1822.               <tr>
    1823. 

  1823.                 <td width="100%" align="center">
    1824. 

  1824.   <?php	$themask = 'yyyy-mm-dd';
    1825. 

  1825. 		if($admindateformat==1)
    1826. 

  1826. 			$themask='mm/dd/yyyy';
    1827. 

  1827. 		elseif($admindateformat==2)
    1828. 

  1828. 			$themask='dd/mm/yyyy';
    1829. 

  1829. 		if(! $success) print "<p><font color='#FF0000'>" . $errmsg . "</font></p>"; ?>
    1830. 

  1830.                   <span name="searchspan" id="searchspan" >
    1831. 

  1831.                   <table width="100%" border="0" cellspacing="1" cellpadding="1" bgcolor="">
    1832. 

  1832.                     <form method="post" action="/admin/hksearch.php" name="psearchform">
    1833. 

  1833.                     <input type="hidden" name="powersearch" value="1" />
    1834. 

  1834.                     <tr bgcolor="#030133"><td colspan="7"><strong><font color="#E7EAEF">&nbsp;<?php print $yyPowSea?></font></strong></td></tr>
    1835. 

  1835.                     <tr bgcolor="#E7EAEF"> 
    1836. 

  1836.                       <td align="right" width="15%"><strong>Search By:</strong></td>
    1837. 

  1837. 				  <td align="left" width="15%">
    1838. 

  1838. 				    <select id="searchby" name="searchby" onchange="showCell();">
    1839. 

  1839. 				      <option value="status"<?=($_POST['searchby']=='status')?' selected="selected"':''?>>Status</option>
    1840. 

  1840. 				      <option value="invoice"<?=($_POST['searchby']=='invoice')?' selected="selected"':''?>>Invoice #</option>
    1841. 

  1841. 				      <option value="batches"<?=($_POST['searchby']=='batches')?' selected="selected"':''?>>Batches</option>
    1842. 

  1842. 				      <option value="name"<?=($_POST['searchby']=='name')?' selected="selected"':''?>>Name</option>
    1843. 

  1843. 				      </select>				    </td>
    1844. 

  1844. 				  <td id="invoice" align="left" style="display:none">
    1845. 

  1845. 				    <strong>Invoice #:</strong> <input name="invoice_number" type="text" id="invoice_number" value="<?=$_POST['invoice_number']?>" />				    </td>
    1846. 

  1846. 				  <td id="batches" align="left" style="display:none">
    1847. 

  1847. 				    <strong>Batches:</strong> between <input type="text" id="batch_from" name="batch_from" value="<?php print $_POST['batch_from']?>" /> <input type="button" onclick="popUpCalendar(this, document.forms.psearchform.batch_from, '<?php print $themask?>', -205)" value='DP' />
    1848. 

  1848. 				    and <input type="text" id="batch_to" name="batch_to" value="<?php print $_POST['batch_to']?>" /> <input type="button" onclick="popUpCalendar(this, document.forms.psearchform.batch_to, '<?php print $themask?>', -205)" value='DP' />				    </td>
    1849. 

  1849. 				  <td id="name" align="left" style="display:none">
    1850. 

  1850. 				    Name: <input type="text" size="24" name="order_name" value="<?php print $_POST['order_name']?>" />				    </td>
    1851. 

  1851. 				  <td id="status" align="left" valign="middle" style="display:none">
    1852. 

  1852. 				    
    1853. 

  1853. 				    <strong><?php print $yyOrdSta?>:</strong>
    1854. 

  1854. 				    &nbsp;<select name="ordstatus[]" size="5" multiple><option value="9999" <?php if(strpos($ordstatus,"9999") !== FALSE) print "selected"?>><?php print $yyAllSta?></option><?php
    1855. 

  1855. 						$ordstatus="";
    1856. 

  1856. 						$addcomma = "";
    1857. 

  1857. 						if(empty($_POST["ordstatus"])) $_POST["ordstatus"]=6;
    1858. 

  1858. 						if(is_array(@$_POST["ordstatus"])){
    1859. 

  1859. 							foreach($_POST["ordstatus"] as $objValue){
    1860. 

  1860. 								if(is_array($objValue))$objValue=$objValue[0];
    1861. 

  1861. 								$ordstatus .= $addcomma . $objValue;
    1862. 

  1862. 								$addcomma = ",";
    1863. 

  1863. 							}
    1864. 

  1864. 						}else
    1865. 

  1865. 							$ordstatus = trim(@$_POST["ordstatus"]);
    1866. 

  1866. 						$ordstatusarr = explode(",", $ordstatus);
    1867. 

  1867. 						for($index=0; $index < $numstatus; $index++){
    1868. 

  1868. 							if(in_array($allstatus[$index]["statID"],array(3,4,6,10))) {
    1869. 

  1869. 								print '<option value="' . $allstatus[$index]["statID"] . '"';
    1870. 

  1870. 								if(is_array($ordstatusarr)){
    1871. 

  1871. 									foreach($ordstatusarr as $objValue)
    1872. 

  1872. 										if($objValue==$allstatus[$index]["statID"]) print " selected";
    1873. 

  1873. 								}
    1874. 

  1874. 								print ">" . $allstatus[$index]["statPrivate"] . "</option>";
    1875. 

  1875. 							}
    1876. 

  1876. 						} ?></select>					</td>
    1877. 

  1877. 			    </tr>
    1878. 

  1878.                     <script type="text/javascript">
    1879. 

  1879. 			  <!--
    1880. 

  1880. 			  resetCells();
    1881. 

  1881. 			  showCell();
    1882. 

  1882. 			  
    1883. 

  1883. 			  function shipLogan(){
    1884. 

  1884. 			  	var resp = confirm("Are you sure you want to update all CHECKED orders to Shipping Logan?");
    1885. 

  1885. 				
    1886. 

  1886. 				return resp;
    1887. 

  1887. 			  }
    1888. 

  1888. 			  
    1889. 

  1889. 			  function sendPacking(){
    1890. 

  1890. 			  	var resp = confirm("Are you sure you want to update all CHECKED orders to Packing?");
    1891. 

  1891. 				
    1892. 

  1892. 				return resp;
    1893. 

  1893. 			  }
    1894. 

  1894. 			  -->
    1895. 

  1895. 			  </script>
    1896. 

  1896.                   </table><input type="submit" value="<?php print $yySearch?>" />
    1897. 

  1897.                   </span>
    1898. 

  1898.                   <table width="100%" border="0" cellspacing="1" cellpadding="2" bgcolor="" style="margin-top: 20px">
    1899. 

  1899. 	                  <tr>
    1900. 

  1900. 	                      <td colspan="7">
    1901. 

  1901. 	                        <?
    1902. 

  1902. 				$sql_status =  "SELECT count( * ) as statcount , os.statPrivate , os.statID
    1903. 

  1903. 								FROM orders o, orderstatus os
    1904. 

  1904. 								WHERE o.ordStatus = os.statID
    1905. 

  1905. 								AND o.ordStatus
    1906. 

  1906. 								BETWEEN 3
    1907. 

  1907. 								AND 10
    1908. 

  1908. 								GROUP BY os.statID,os.statPrivate";
    1909. 

  1909. 				$result_status=mysql_query($sql_status);
    1910. 

  1910. 				while($row_status=mysql_fetch_assoc($result_status)){?>
    1911. 

  1911. 	                        <div style="color:#000066; font-weight:bold; border:#030133 solid 1px; margin:2px; float:left; width:146px;padding:2px; text-align:center; background-color:#E7EAEF;"><?=$row_status['statID'].'-'.$row_status['statPrivate'].': '.$row_status['statcount'] ?></div>
    1912. 

  1912. 			  	  <? } ?>					</td>
    1913. 

  1913. 				  </tr>
    1914. 

  1914. 	                  <tr>
    1915. 

  1915. 	                      <td colspan="3"><input type="submit" id="ship_to_logan" name="ship_to_logan" value="Ship From Logan" onclick="return shipLogan();" />&nbsp;<!--<input type="submit" id="send_packing" name="send_packing" value="Send to Packing" onclick="return sendPacking();" />--></td>
    1916. 

  1916. 				      <td colspan="4" align="right">* Order has Custom Screenz | <span style="background-color:#FA6561; padding:2px;">etailer</span></td>
    1917. 

  1917. 			      </tr>
    1918. 

  1918.                     <tr bgcolor="#030133">
    1919. 

  1919.                       <td align="center">&nbsp;</td>
    1920. 

  1920.                   <td align="center"><strong><font color="#E7EAEF"><?php print $yyOrdId?></font></strong></td>
    1921. 

  1921. 				  <td align="center"><strong><font color="#E7EAEF"><?php print $yyName?></font></strong></td>
    1922. 

  1922. 				  <td align="center"><strong><font color="#E7EAEF"><?php print $yyShipMe?></font></strong></td>
    1923. 

  1923. 				  <td align="center"><strong><font color="#E7EAEF">Status</font></strong></td>
    1924. 

  1924. 				  <td align="center"><strong><font color="#E7EAEF"><?php print $yyBatDate?></font></strong></td>
    1925. 

  1925. 				  <td align="center"><strong><font color="#E7EAEF"><?php print $yyOrdDate?></font></strong></td>
    1926. 

  1926. 			    </tr>
    1927. 

  1927.   <?php
    1928. 

  1928. 	if(mysql_num_rows($alldata) > 0){
    1929. 

  1929. 		$rowcounter=0;
    1930. 

  1930. 		$ordTot=0;
    1931. 

  1931. 		$i=0;
    1932. 

  1932. 		$num_rows_order=mysql_num_rows($alldata);
    1933. 

  1933. 		while($rs = mysql_fetch_assoc($alldata)){
    1934. 

  1934. 			$order_id_array[$i]=$rs["ordID"];
    1935. 

  1935. 			$i++;
    1936. 

  1936. 			if($rs["ordStatus"]>=3) $ordTot += $rs["ordTot"];
    1937. 

  1937. 			if($rs["ordStatus"]>=3) $num_auth_order += 1;
    1938. 

  1938. 			if($rs["ordAuthNumber"]=="" || is_null($rs["ordAuthNumber"])){
    1939. 

  1939. 				$startfont="<font color='#FF0000'>";
    1940. 

  1940. 				$endfont="</font>";
    1941. 

  1941. 			} else{
    1942. 

  1942. 				$startfont="";
    1943. 

  1943. 				$endfont="";
    1944. 

  1944. 			}
    1945. 

  1945. 			if($rs["order_changed"]=='yes'){ 
    1946. 

  1946. 				$startfont="<font color='#00CC00'>";
    1947. 

  1947. 				$endfont="</font>";
    1948. 

  1948. 			}
    1949. 

  1949. 			//check for custom screenz
    1950. 

  1950. 			$hascustomscreen='';
    1951. 

  1951. 			$sql_check="SELECT * FROM cart WHERE cartOrderID=".$rs["ordID"]." AND cartProdID LIKE '%-Custom'";
    1952. 

  1952. 			$result_check=mysql_query($sql_check);
    1953. 

  1953. 			if(mysql_num_rows($result_check)>0) $hascustomscreen='*';
    1954. 

  1954. 			// Get Current Status Name
    1955. 

  1955. 			$sql_st = "SELECT os.statPrivate FROM orderstatus os, orders o 
    1956. 

  1956. 					   WHERE o.ordStatus = os.statID
    1957. 

  1957. 					   AND o.ordID = " . $rs["ordID"];
    1958. 

  1958. 			$res_st = mysql_query($sql_st) or print(mysql_error());
    1959. 

  1959. 			$row_st = mysql_fetch_assoc($res_st);
    1960. 

  1960. 			
    1961. 

  1961. 			if(@$bgcolor=="#E7EAEF") $bgcolor="#EAECEB"; else $bgcolor="#E7EAEF";
    1962. 

  1962. 			if(!empty($rs["ordEID"])) $bgcolor="#FA6561";			
    1963. 

  1963. ?>
    1964. 

  1964.                     <tr bgcolor="<?php print $bgcolor?>">
    1965. 

  1965.                       <td><input type="checkbox" id="orders<?=$i?>" name="orders[]" value="<?=$rs["ordID"]?>" /></td>
    1966. 

  1966.                   <td align="center"><a onclick="return(checkprinter(this,event));" href="/admin/hksearch.php?id=<?php print $rs["ordID"]?>"><?php print "<strong>" . $hascustomscreen.$startfont . $rs["ordID"] . $endfont . "</strong>"?></a></td>
    1967. 

  1967. 				  <td align="center"><a onclick="return(checkprinter(this,event));" href="/admin/hksearch.php?id=<?php print $rs["ordID"]?>"><?php print $startfont . $rs["ordName"] . $endfont?></a></td>
    1968. 

  1968. 				  <td align="center"><a onclick="return(checkprinter(this,event));" href="/admin/hksearch.php?id=<?php print $rs["ordID"]?>"><?php print $startfont . $rs["ordShipType"] . $endfont?></a></td>
    1969. 

  1969. 				  <td align="center"><a onclick="return(checkprinter(this,event));" href="/admin/hksearch.php?id=<?php print $rs["ordID"]?>"><?php print $startfont . $row_st["statPrivate"] . $endfont?></a></td>
    1970. 

  1970. 				  <td align="center">
    1971. 

  1971. 				    <?php 
    1972. 

  1972. 				$sql="select * from location l where ordID = ". $rs["ordID"] ." and l.location = 'Packing'";
    1973. 

  1973. 				$result= mysql_query($sql);
    1974. 

  1974. 				$row= mysql_fetch_assoc($result);
    1975. 

  1975. 				echo $row["stamp"];
    1976. 

  1976. 				?></td>
    1977. 

  1977.   
    1978. 

  1978. 				<td align="center"><font size="1"><?php print $startfont . date($admindatestr . "\<\\b\\r\>H:i:s", strtotime($rs["ordDate"])) . $endfont?></font></td>
    1979. 

  1979. 			    </tr>
    1980. 

  1980.   <?php		$rowcounter++;
    1981. 

  1981. 			if($rowcounter>=1000){
    1982. 

  1982. 				print "<tr><td colspan='6' align='center'><strong>Limit of " . $rowcounter . " orders reached. Please refine your search.</strong></td></tr>";
    1983. 

  1983. 				break;
    1984. 

  1984. 			}
    1985. 

  1985. 		}
    1986. 

  1986. ?>
    1987. 

  1987.                     <tr> 
    1988. 

  1988.                       <td colspan="6" align="left"><?=$num_rows_order?> Orders</td>
    1989. 

  1989. 			    </tr>
    1990. 

  1990.   <?php
    1991. 

  1991. 	}else{
    1992. 

  1992. ?>
    1993. 

  1993.                     <tr> 
    1994. 

  1994.                       <td colspan="9" align="center">
    1995. 

  1995. 	                      <p><?php
    1996. 

  1996. 					if(@$_POST["powersearch"]=="1")
    1997. 

  1997. 						print $yyNoMat1;
    1998. 

  1998. 					elseif($num_of_listed==0)
    1999. 

  1999. 						print "There were no orders found";
    2000. 

  2000. 					?></p>				</td>
    2001. 

  2001. 			    </tr>
    2002. 

  2002.                     <?php if($hasdeleted){ ?>
    2003. 

  2003.                     <tr> 
    2004. 

  2004.                       <td colspan="9"><input type="submit" value="<?php print $yyPurDel?>" onclick="document.mainform.act.value='purge';" /></td>
    2005. 

  2005. 			    </tr>
    2006. 

  2006.                     <?php } ?>
    2007. 

  2007.                     <!--</form>-->
    2008. 

  2008.   <?php
    2009. 

  2009. 	} ?>
    2010. 

  2010.                   </table>		    </td>
    2011. 

  2011. 		  </tr>
    2012. 

  2012.                   </table>
    2013. 

  2013. 		    <?php
    2014. 

  2014. }
    2015. 

  2015. }
    2016. 

  2016. 

  2017. ?>
    2018. 

  2018.