PageRenderTime 51ms CodeModel.GetById 18ms RepoModel.GetById 1ms app.codeStats 0ms

/application/views/pages/admin/ordersprint.php

https://bitbucket.org/chadsaun/ifrogz-panel
PHP | 865 lines | 650 code | 35 blank | 180 comment | 143 complexity | 752ed6e56dad0d1896a4f3252b6f81f5 MD5 | raw file
    

  1. <?php
    2. 

  2. ini_set("memory_limit","12M");
    3. 

  3. //echo 'test';
    4. 

  4. //session_register('order_id_commas');
    5. 

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

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

  7. //Business Solutions SL. Any use, reproduction, disclosure or copying of any kind 
    8. 

  8. //without the express and written permission of Internet Business Solutions SL is forbidden.
    9. 

  9. //Author: Vince Reid, vince@virtualred.net
    10. 

  10. if(@$dateadjust=="") $dateadjust=0;
    11. 

  11. if(@$dateformatstr == "") $dateformatstr = "m/d/Y";
    12. 

  12. $admindatestr="Y-m-d";
    13. 

  13. if(@$admindateformat=="") $admindateformat=0;
    14. 

  14. if($admindateformat==1)
    15. 

  15. 	$admindatestr="m/d/Y";
    16. 

  16. elseif($admindateformat==2)
    17. 

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

  18. if(@$storesessionvalue=="") $storesessionvalue="virtualstore".time();
    19. 

  19. if(@$_SESSION["loggedon1"] != $storesessionvalue && trim(@$_COOKIE["WRITECKL"])!=""){
    20. 

  20. 	$sSQL="SELECT adminID FROM admin WHERE adminUser='" . mysql_real_escape_string(unstripslashes(trim(@$_COOKIE["WRITECKL"]))) . "' AND adminPassword='" . mysql_real_escape_string(unstripslashes(trim(@$_COOKIE["WRITECKP"]))) . "' AND adminID=1";
    21. 

  21. 	$result = mysql_query($sSQL) or print(mysql_error());
    22. 

  22. 	if(mysql_num_rows($result)>0)
    23. 

  23. 		@$_SESSION["loggedon1"] = $storesessionvalue;
    24. 

  24. 	else
    25. 

  25. 		$lisuccess=2;
    26. 

  26. 	mysql_free_result($result);
    27. 

  27. }
    28. 

  28. if(!empty($file)) {
    29. 

  29. 	if(strstr($file,'_etailer_sz')) $etailer_only='yes';
    30. 

  30. 	if(strstr($file,'_logan')) $shipping_logan='yes';
    31. 

  31. 	$batch_name=$file;//substr($file,0,2)
    32. 

  32. 	//$ourFileHandle = fopen('order_ids/'.$path.'/'.$file, 'r') or die("can't open file");
    33. 

  33. 	//$contents = '';
    34. 

  34. 	/*while (!feof($ourFileHandle)) {
    35. 

  35.   	$contents .= fread($ourFileHandle, 8192);
    36. 

  36. 	}
    37. 

  37. 	fclose($ourFileHandle);*/
    38. 

  38. 	//echo 'contents='.$contents;
    39. 

  39. 	$sql_check="SELECT ordID FROM orders WHERE ordBatch='".$file."' ORDER BY ordShipType,IF(ordShipAddress != '',ordShipState,ordState),ordID";
    40. 

  40. 	$result_check=mysql_query($sql_check)or print(mysql_error());
    41. 

  41. 	if(mysql_num_rows($result_check)==0) {echo "There are no order to print!";exit();}
    42. 

  42. 	$i=0;	
    43. 

  43. 	while($row_check=mysql_fetch_assoc($result_check)) {
    44. 

  44. 		$arr2[$i]=$row_check['ordID'];
    45. 

  45. 		$i++;
    46. 

  46. 	}
    47. 

  47. 	//showarray($arr2);
    48. 

  48. 	mysql_free_result($result_check);
    49. 

  49. 	
    50. 

  50. 	
    51. 

  51. 	
    52. 

  52. 	//$arr2=explode(',',$contents);
    53. 

  53. 	//echo $contents;
    54. 

  54. } else {
    55. 

  55. 	//check that the order has been authorized
    56. 

  56. 	$str_batch_type='';
    57. 

  57. 	
    58. 

  58. 	$screenz=$_GET['screenz'];
    59. 

  59. 	if(!empty($screenz)) {$custom_screenz_show=TRUE;$str_batch_type='_s';}
    60. 

  60. 	else $custom_screenz_show=FALSE;
    61. 

  61. 	//echo $str_batch_type;
    62. 

  62. 	//$apo=$_GET['apo'];
    63. 

  63. 	$etailer_only=$_GET['etailer_only'];
    64. 

  64. 	$etailer=$_GET['etailer'];
    65. 

  65. 	$shipping_logan=$_GET['shipping_logan'];
    66. 

  66. 	$ordStatus=3;
    67. 

  67. 	//if(!empty($shipping_logan)) {$ordStatus=10;$str_batch_type='_dropship';}
    68. 

  68. 	$sql_check="SELECT ordID FROM orders WHERE ordStatus='".$ordStatus."'"; 
    69. 

  69. 	//if(!empty($shipping_logan)) $sql_check.=" AND ordPrinted_logan='0000-00-00 00:00:00'"; 
    70. 

  70. 	if(!empty($etailer_only)){
    71. 

  71. 		$sql_check.=" AND ordEID=34";
    72. 

  72. 		$str_batch_type='_etailer_sz';
    73. 

  73. 	} else {
    74. 

  74. 		$sql_check.=" AND ordEID!=34";
    75. 

  75. 		if(empty($screenz)){
    76. 

  76. 			if(!empty($etailer)) {$sql_check.=" AND ordEID>0";$str_batch_type='_e';}
    77. 

  77. 			else {$sql_check.=" AND ordEID=0";}
    78. 

  78. 			//if(!empty($apo)) {$sql_check.=" AND IF(ordShipAddress != '',ordShipState IN('AA','AE','AP'),ordState IN('AA','AE','AP'))";$str_batch_type='_apo';}
    79. 

  79. 			//else {$sql_check.=" AND IF(ordShipAddress != '',ordShipState NOT IN ('AA','AE','AP'),ordState NOT IN ('AA','AE','AP'))";}
    80. 

  80. 		}
    81. 

  81. 	}
    82. 

  82. 	$sql_check.= " ORDER BY ordShipType,IF(ordShipAddress != '',ordShipState,ordState),ordID";
    83. 

  83. 	//echo $sql_check;
    84. 

  84. 	$result_check=mysql_query($sql_check)or print(mysql_error());
    85. 

  85. 	if(mysql_num_rows($result_check)==0) {echo "There are no order to print!";exit();}
    86. 

  86. 	$i=0;	
    87. 

  87. 	while($row_check=mysql_fetch_assoc($result_check)) {
    88. 

  88. 		$arr2[$i]=$row_check['ordID'];
    89. 

  89. 		$i++;
    90. 

  90. 	}
    91. 

  91. 	//showarray($arr2);
    92. 

  92. 	mysql_free_result($result_check);
    93. 

  93. 	$batch_name=date('Y-m-d H:i:s').$str_batch_type;
    94. 

  94. } 
    95. 

  95. $order_id_commas='';
    96. 

  96. $comma='';
    97. 

  97. $cntarr2=count($arr2);
    98. 

  98. for($i=0,$ii=0;$i<$cntarr2;$i++) {
    99. 

  99. 	$sql="SELECT o.optStyleID,c.cartProdID,co.coOptGroup,co.coCartOption FROM cart c, cartoptions co, options o WHERE c.cartID=co.coCartID AND co.coOptID=o.optID AND c.cartOrderID=".$arr2[$i]."";
    100. 

  100. 	//echo $sql;
    101. 

  101. 	$result=mysql_query($sql);
    102. 

  102. 	$has_custom_screen=0;
    103. 

  103. 	$has_all_custom_screenz=TRUE;
    104. 

  104. 	$img_cust='';
    105. 

  105. 	while($rs=mysql_fetch_assoc($result)){
    106. 

  106. 		if(strstr($rs['coOptGroup'],'Wrap')){
    107. 

  107. 			if(strstr($rs['cartProdID'],'-')) $str_p=substr($rs['cartProdID'],0,1); 
    108. 

  108. 			else $str_p=substr($rs['cartProdID'],0,1).'-'; 
    109. 

  109. 			$str_p.=$rs['optStyleID'];
    110. 

  110. 			//continue;
    111. 

  111. 		}
    112. 

  112. 		//echo 'in';
    113. 

  113. 		if(strstr($rs['cartProdID'],'-Custom')){
    114. 

  114. 			$cartoption_left5=(int)substr($rs['coCartOption'],0,5);
    115. 

  115. 			$sql_custom="SELECT *
    116. 

  116. 						FROM uploaded_images  
    117. 

  117. 						WHERE id = ".$cartoption_left5;
    118. 

  118. 			//echo $sql_custom. '<br />';
    119. 

  119. 			$result_custom=mysql_query($sql_custom);
    120. 

  120. 			if(mysql_num_rows($result_custom)>0){
    121. 

  121. 				$row_custom=mysql_fetch_assoc($result_custom);
    122. 

  122. 				$has_custom_screen++;
    123. 

  123. 				$key=$rs['coCartOption'];
    124. 

  124. 				$img_cust[$key]=$row_custom['display_image'];
    125. 

  125. 				if($row_custom['approved']!='yes'){
    126. 

  126. 					$has_all_custom_screenz=FALSE;
    127. 

  127. 				}
    128. 

  128. 			}
    129. 

  129. 		}
    130. 

  130. 	}
    131. 

  131. 	
    132. 

  132. 	if(!empty($file)){
    133. 

  133. 		$arr[$i]['prod_style']=$str_p;
    134. 

  134. 		$arr[$i]['order_id']=$arr2[$i];
    135. 

  135. 		$arr[$i]['custom_screen']=$has_custom_screen;
    136. 

  136. 		$arr[$i]['custom_screen_img']=$img_cust;
    137. 

  137. 		//$order_id_commas.=$comma.$arr2[$i];
    138. 

  138. 		//$comma=',';
    139. 

  139. 	} elseif($has_all_custom_screenz && $custom_screenz_show && $has_custom_screen>0){ 
    140. 

  140. 		$arr[$ii]['prod_style']=$str_p;
    141. 

  141. 		$arr[$ii]['order_id']=$arr2[$i];
    142. 

  142. 		$arr[$ii]['custom_screen']=$has_custom_screen;
    143. 

  143. 		$arr[$ii]['custom_screen_img']=$img_cust;
    144. 

  144. 		//$order_id_commas.=$comma.$arr2[$i];
    145. 

  145. 		//$comma=',';
    146. 

  146. 		$ii++;
    147. 

  147. 	} elseif($custom_screenz_show==false && $has_custom_screen==0){
    148. 

  148. 

  149. 		$arr[$ii]['prod_style']=$str_p;
    150. 

  150. 		$arr[$ii]['order_id']=$arr2[$i];
    151. 

  151. 		$arr[$ii]['custom_screen']=$has_custom_screen;
    152. 

  152. 		$arr[$ii]['custom_screen_img']=$img_cust;
    153. 

  153. 		//$order_id_commas.=$comma.$arr2[$i];
    154. 

  154. 		//$comma=',';
    155. 

  155. 		$ii++;
    156. 

  156. 

  157. 	}
    158. 

  158. }
    159. 

  159. //unset($arr2);
    160. 

  160. //$arr2='';
    161. 

  161. //if(!empty($arr)) sort($arr);
    162. 

  162. //showarray($arr);
    163. 

  163. //echo $order_id_commas;
    164. 

  164. //exit();
    165. 

  165. // variables
    166. 

  166. //$csv_shipping='"IMPORT CODE","Order","Address1","Address2","city","state","zip","country","TEL","shipping name","shipping address1","shipping address2","shipping city","shipping state","shipping zip","shipping country","shipping type","date","DELIVERY DATE","AWB","LOT"'."\r\n";
    167. 

  167. $rows_per_label=10;//8
    168. 

  168. //$label_height=172;//182
    169. 

  169. //$label_width=170;//340
    170. 

  170. $address_width='';
    171. 

  171. //if($_GET['ptype']=='1'){
    172. 

  172. 	//normal printer
    173. 

  173. 	//$cols=2;//2
    174. 

  174. 	//$rows=5;//5
    175. 

  175. //} else {
    176. 

  176. 	//thermal
    177. 

  177. 	//$cols=1;//1
    178. 

  178. 	//$rows=1;//1
    179. 

  179. //}
    180. 

  180. //if(!empty($shipping_logan)) {
    181. 

  181. 	$cols=2;//2
    182. 

  182. 	$rows=5;//5
    183. 

  183. 	$label_height=222;//182
    184. 

  184. 	$label_width=200;//340
    185. 

  185. //}
    186. 

  186. $labels='';
    187. 

  187. $label_count=0;
    188. 

  188. $str_orderstatus='';
    189. 

  189. $count_arr=count($arr);
    190. 

  190. $report='';
    191. 

  191. for($i=0,$l=0;$l<$count_arr;$i++,$l++) {
    192. 

  192. 	$order_id=$arr[$l]['order_id'];
    193. 

  193. 	$rows_per_label=10;	
    194. 

  194. 	//check for order with gift certificate by mail, drop shipper, and downloads
    195. 

  195. 	$sql_check="SELECT p.p_iscert,p.pDownload,p.pDropship,co.coCartOption,p.pID,p.pWeight FROM cart c LEFT JOIN products p ON c.cartProdID=p.pID LEFT JOIN cartoptions co ON c.cartID=co.coCartID WHERE c.cartOrderID=".$order_id;//,p.pDownload
    196. 

  196. 	//echo $sql_check;
    197. 

  197. 	$result_check=mysql_query($sql_check);
    198. 

  198. 	$num_check=mysql_num_rows($result_check);
    199. 

  199. 	$skip_order=FALSE;
    200. 

  200. 	$count_down=0;
    201. 

  201. 	$count_email_cert=0;
    202. 

  202. 	$count_drop_ship=0;
    203. 

  203. 	$pWeight = 0;
    204. 

  204. 	while($row=mysql_fetch_assoc($result_check)){
    205. 

  205. 		
    206. 

  206. 		//echo $row['pID'].'='.$row['coCartOption'].'<br />';
    207. 

  207. 		if($row['p_iscert']==1 && $row['coCartOption']=="Email") $count_email_cert++; 
    208. 

  208. 		if(($row['p_iscert']==1 && $row['coCartOption']=="Card via Mail") || $row['pDropship']>0) $count_drop_ship++;  //|| $row['pDownload']!=''
    209. 

  209. 		if($row['pDownload']!="") $count_down++;
    210. 

  210. 		$pWeight += $row['pWeight'];
    211. 

  211. 	}
    212. 

  212. 	if($num_check==$count_down || $num_check==$count_email_cert) {$skip_order=TRUE; $new_status=12;}
    213. 

  213. 	//if($count_drop_ship>0 && $count_drop_ship!=$count_email_cert) {$skip_order=TRUE; $new_status=10;}
    214. 

  214. 	if($skip_order) {
    215. 

  215. 		//echo 'skipped';
    216. 

  216. 		if(empty($file) && empty($path)){
    217. 

  217. 			$sql_gift="UPDATE orders SET ordStatus=".$new_status." WHERE ordID=".$order_id;
    218. 

  218. 			mysql_query($sql_gift);
    219. 

  219. 			if(!setNewLocation( $new_status , $order_id )) print("Unable to record location.");
    220. 

  220. 		}
    221. 

  221. 		$str_orderstatus.=$order_id;
    222. 

  222. 		continue;
    223. 

  223. 	}
    224. 

  224. 	$label_count++;
    225. 

  225. 	if(!$skip_order) $arr_packing[$i]=$arr[$l]['order_id'];
    226. 

  226. 	$labels['order_id'][$i]=$arr[$l]['order_id'];
    227. 

  227. 	$labels['label_count'][$i]=$label_count;
    228. 

  228. 	$labels['pWeight'][$i] = $pWeight;
    229. 

  229. 	// address
    230. 

  230. 	$sql_address="SELECT ordPhone,ordName,ordAddress,ordAddress2,ordCity,ordState,ordPoApo,ordZip,ordCountry,ordShipName,ordShipAddress,ordShipAddress2,ordShipCity,ordShipState,ordShipZip,ordShipCountry,ordShipType,ordShipPoApo,ordEID,ordEOrderID FROM orders WHERE ordID=".$order_id;
    231. 

  231. 	$result_address=mysql_query($sql_address);
    232. 

  232. 	$row_address=mysql_fetch_assoc($result_address);
    233. 

  233. 	$labels['shipping'][$i]['eid']=$row_address['ordEID'];	
    234. 

  234. 	$labels['ordEOrderID'][$i]=$row_address["ordEOrderID"];
    235. 

  235. 	$apoOrder=FALSE;
    236. 

  236. 	if($row_address["ordShipAddress"] != "" && ($row_address["ordShipCity"] != "" && $row_address["ordShipZip"] !="" )){
    237. 

  237. 		$labels['shipping'][$i]['name']=strtoupper($row_address["ordShipName"]);
    238. 

  238. 		$labels['shipping'][$i]['address']=strtoupper($row_address["ordShipAddress"]);
    239. 

  239. 		$labels['shipping'][$i]['address2']=strtoupper($row_address["ordShipAddress2"]);
    240. 

  240. 		$labels['shipping'][$i]['city']=strtoupper($row_address["ordShipCity"]);
    241. 

  241. 		$labels['shipping'][$i]['state']=strtoupper($row_address["ordShipState"]);
    242. 

  242. 		$labels['shipping'][$i]['zip']=strtoupper($row_address["ordShipZip"]);
    243. 

  243. 		$labels['shipping'][$i]['country']=strtoupper($row_address["ordShipCountry"]);
    244. 

  244. 		//echo 'state='.$row_address["ordShipState"];
    245. 

  245. 		if(!empty($row_address["ordShipState"])){
    246. 

  246. 			if(stristr('AA,AE,AP',$row_address["ordShipState"])) $apoOrder=TRUE;
    247. 

  247. 	 	}
    248. 

  248. 	 }
    249. 

  249. 	 else{
    250. 

  250. 		$labels['shipping'][$i]['name']=strtoupper($row_address["ordName"]);
    251. 

  251. 		$labels['shipping'][$i]['address']=strtoupper($row_address["ordAddress"]);
    252. 

  252. 		$labels['shipping'][$i]['address2']=strtoupper($row_address["ordAddress2"]);
    253. 

  253. 		$labels['shipping'][$i]['city']=strtoupper($row_address["ordCity"]);
    254. 

  254. 		$labels['shipping'][$i]['state']=strtoupper($row_address["ordState"]);
    255. 

  255. 		$labels['shipping'][$i]['zip']=strtoupper($row_address["ordZip"]);
    256. 

  256. 		$labels['shipping'][$i]['country']=strtoupper($row_address["ordCountry"]);
    257. 

  257. 		if(!empty($row_address["ordState"])){
    258. 

  258. 			if(stristr('AA,AE,AP',$row_address["ordState"])) $apoOrder=TRUE;
    259. 

  259. 		}
    260. 

  260. 	 }
    261. 

  261. 		$labels['shipping'][$i]['phone']=$row_address["ordPhone"];
    262. 

  262. 		if($row_address["ordShipType"]=='Standard' && $labels['shipping'][$i]['country']!='Canada') {
    263. 

  263. 			if($apoOrder)$shipType='Priority - APO';
    264. 

  264. 			else $shipType='USPS';
    265. 

  265. 		}
    266. 

  266. 		elseif($row_address["ordShipType"]=='Priority Mail' && $apoOrder) $shipType='Priority - APO';
    267. 

  267. 		elseif($row_address["ordShipType"]=='Priority Mail') $shipType='Priority';		
    268. 

  268. 		elseif($row_address["ordShipType"]=='FedEx Express') $shipType='FDX';
    269. 

  269. 		elseif($row_address["ordShipType"]=='FedEx Overnight') $shipType='FDX Overnight';
    270. 

  270. 		elseif($row_address["ordShipType"]=='International' || $labels['shipping'][$i]['country']=='Canada' ) $shipType='INTL';
    271. 

  271. 

  272. 		$labels['shipping'][$i]['shiptype']=$shipType;
    273. 

  273. 	
    274. 

  274. 	//hong kong shipping csv
    275. 

  275. 	$csv_shipping.='"","'.$order_id.'","'.$row_address["ordAddress"].'","'.$row_address["ordShipAddress2"].'","'.$row_address["ordCity"].'","'.$row_address["ordState"].'","'.$row_address["ordZip"].'","'.$row_address["ordCountry"].'","'.$row_address["ordPhone"].'","'.$labels['shipping'][$i]['name'].'","'.$labels['shipping'][$i]['address'].'","'.$labels['shipping'][$i]['address2'].'","'.$labels['shipping'][$i]['city'].'","'.$labels['shipping'][$i]['state'].'","'.$labels['shipping'][$i]['zip'].'","'.$labels['shipping'][$i]['country'].'","HKPOST","'.date('Y-m-d').'","","",""'."\r\n";
    276. 

  276. 		 
    277. 

  277. 	$sSQL5 = "SELECT sum(cartQuantity) AS qty_total,c.cartID FROM cart c, products p WHERE c.cartProdID=p.pID AND c.cartCompleted=1 AND c.cartOrderID=" . $order_id;
    278. 

  278. 	//if(empty($shipping_logan)) $sSQL5 .= " AND p.pDropship=0";
    279. 

  279. 	//else $sSQL5 .= " AND p.pDropship>0";
    280. 

  280. 	$sSQL5 .=" GROUP BY c.cartID ORDER BY c.cartProdID";
    281. 

  281. 	//echo $sSQL5;	
    282. 

  282. 	$result5 = mysql_query($sSQL5) or print(mysql_error());
    283. 

  283. 	$num_rows_label=mysql_num_rows($result5); 
    284. 

  284. 	$j=0;
    285. 

  285. 	$k=1;
    286. 

  286. 	while($rs5 = mysql_fetch_assoc($result5)){
    287. 

  287. 		if($j==0) {
    288. 

  288. 			//add screen kit to artwork 
    289. 

  289. 			$sql9= "SELECT cartQuantity,cartProdID 
    290. 

  290. 					FROM cart WHERE cartCompleted=1 
    291. 

  291. 					AND (cartProdID IN('X-1','X-2','X-3','X-4','X-5','X-6','X-7','X-8','X-9','X-Custom','AHX') 
    292. 

  292. 					OR cartProdID LIKE 'AHX-%'
    293. 

  293. 					OR cartProdID IN('Y-1','Y-2','Y-3','Y-4','Y-5','Y-6','Y-7','Y-8','Y-9','Y-Custom','EJY')
    294. 

  294. 					OR cartProdID LIKE 'EJY-%'					
    295. 

  295. 					OR cartProdID IN('V-1','V-2','V-3','V-4','V-5','V-6','V-7','V-8','V-9','V-Custom')
    296. 

  296. 					OR cartProdID IN('U-1','U-2','U-3','U-4','U-5','U-6','U-7','U-8','U-9','U-Custom')
    297. 

  297. 					OR cartProdID IN('T-1','T-2','T-3','T-4','T-5','T-6','T-7','T-8','T-9','T-Custom')					
    298. 

  298. 					OR cartProdID IN('W-1','W-2','W-3','W-4','W-5','W-6','W-7','W-8','W-9','W-Custom','CJW','CCJW','tadpoleCW','tadpoleCCW','tadpoleCW-Custom','tadpoleCCW-Custom','A2gFV','A2gFV-Custom')
    299. 

  299. 					OR cartProdID IN('o_frogzCW','o_frogzCCW','o_frogzCW-Custom','o_frogzCCW-Custom','o_blfrogCW','o_blfrogCCW','o_blfrogCW-Custom','o_blfrogCCW-Custom','o_treadzCJW','o_treadzCCJW','o_treadzCJW-Custom','o_treadzCCJW-Custom','A2gtreadzV-Custom','A2gtreadzV','A2gbullfrogV','A2gbullfrogV-Custom')
    300. 

  300. 					OR cartProdID LIKE 'tadpoleC2U%'
    301. 

  301. 					OR cartProdID LIKE 'tadpoleCC2U%'
    302. 

  302. 					OR cartProdID LIKE 'C2JU%'
    303. 

  303. 					OR cartProdID LIKE 'CC2JU%'
    304. 

  304. 					OR cartProdID LIKE 'o_treadzC2JU%'
    305. 

  305. 					OR cartProdID LIKE 'o_treadzCC2JU%'
    306. 

  306. 					OR cartProdID LIKE 'o_blfrogC2U%'
    307. 

  307. 					OR cartProdID LIKE 'o_blfrogCC2U%'
    308. 

  308. 					OR cartProdID LIKE 'o_frogzC2U%'
    309. 

  309. 					OR cartProdID LIKE 'o_frogzCC2U%'
    310. 

  310. 					OR cartProdID LIKE 'A3T%'
    311. 

  311. 					OR cartProdID LIKE 'A3treadzT%'
    312. 

  312. 					OR cartProdID LIKE 'bumpzC2JU%'
    313. 

  313. 					OR cartProdID LIKE 'bumpzCC2JU%'
    314. 

  314. 					OR cartProdID LIKE 'ribbitzC2JU%'
    315. 

  315. 					OR cartProdID LIKE 'ribbitzCC2JU%'
    316. 

  316. 					OR cartProdID LIKE 'bumpzCJW%'
    317. 

  317. 					OR cartProdID LIKE 'bumpzCCJW%'
    318. 

  318. 					OR cartProdID LIKE 'ribbitzCJW%'
    319. 

  319. 					OR cartProdID LIKE 'ribbitzCCJW%'
    320. 

  320. 					OR cartProdID LIKE 'CJW-%'
    321. 

  321. 					OR cartProdID LIKE 'CCJW-%')
    322. 

  322. 					AND cartOrderID=" . $order_id;
    323. 

  323. 			//echo $sql9;
    324. 

  324. 			$result9=mysql_query($sql9);
    325. 

  325. 			$num_rows_insert=mysql_num_rows($result9);
    326. 

  326. 			if($num_rows_insert>0) {
    327. 

  327. 				$insert_qty='';
    328. 

  328. 				while($row9=mysql_fetch_assoc($result9)) {
    329. 

  329. 					if(strstr($row9['cartProdID'],'X')){
    330. 

  330. 						$insert_qty[0]+=$row9['cartQuantity'];
    331. 

  331. 					} elseif(strstr($row9['cartProdID'],'Y')){
    332. 

  332. 						$insert_qty[1]+=$row9['cartQuantity'];
    333. 

  333. 					} elseif(strstr($row9['cartProdID'],'Z')){
    334. 

  334. 						$insert_qty[2]+=$row9['cartQuantity'];
    335. 

  335. 					/*} elseif(strstr($row9['cartProdID'],'W')){
    336. 

  336. 						$insert_qty[3]+=$row9['cartQuantity'];*/
    337. 

  337. 					} elseif(strstr($row9['cartProdID'],'V')){
    338. 

  338. 						$insert_qty[4]+=$row9['cartQuantity'];
    339. 

  339. 					} elseif(strstr($row9['cartProdID'],'U') || strstr($row9['cartProdID'],'W')){
    340. 

  340. 						$insert_qty[5]+=$row9['cartQuantity'];
    341. 

  341. 					} elseif(strstr($row9['cartProdID'],'T')){
    342. 

  342. 						$insert_qty[6]+=$row9['cartQuantity'];
    343. 

  343. 					}
    344. 

  344. 				}								
    345. 

  345. 				for($p=0;$p<7;$p++){
    346. 

  346. 					if($insert_qty[$p]>0){
    347. 

  347. 						if($p==0) {$str_optgrp='SK-X';$str_optID=3243;} 
    348. 

  348. 						elseif($p==1) {$str_optgrp='SK-Y';$str_optID=3244;}
    349. 

  349. 						elseif($p==2) {$str_optgrp='SK-Z';$str_optID=3245;}
    350. 

  350. 						elseif($p==3) {$str_optgrp='SK-W';$str_optID=3246;}
    351. 

  351. 						elseif($p==4) {$str_optgrp='SK-V';$str_optID=3658;}
    352. 

  352. 						elseif($p==5) {$str_optgrp='SK-U';$str_optID=3737;}
    353. 

  353. 						elseif($p==6) {$str_optgrp='SK-T';$str_optID=4045;}
    354. 

  354. 						//creates running totals for report
    355. 

  355. 						$report[$str_optgrp][0]+=$insert_qty[$p];
    356. 

  356. 						$report[$str_optgrp][1]='Screen Kit';
    357. 

  357. 						$report[$str_optgrp][3]=$str_optID;
    358. 

  358. 						$labels[$i][$j]['prodId_style']=$str_optgrp;
    359. 

  359. 						//
    360. 

  360. 						$labels[$i][$j]['qty']=$insert_qty[$p];
    361. 

  361. 						$labels[$i][$j]['opt_group']=$str_optgrp;
    362. 

  362. 						$labels[$i][$j]['option']='Screen Kit';
    363. 

  363. 						if($j%$rows_per_label==0) {$labels['label'][$i][$j]['new_label']=$k; $labels['label_per_order'][$i]=$k; $k++;}
    364. 

  364. 						$j++;
    365. 

  365. 					}
    366. 

  366. 				}
    367. 

  367. 			}
    368. 

  368. 			mysql_free_result($result9);
    369. 

  369. 		
    370. 

  370. 			//add insert
    371. 

  371. 			$sql7="SELECT cartQuantity FROM cart WHERE cartCompleted=1 AND (cartProdID IN('CC','CCJW','tadpoleCC','tadpoleCCW','tadpoleCCW-Custom','CC2') OR cartProdID LIKE 'CCJW-%' OR cartProdID LIKE 'o_treadzCC%' OR cartProdID LIKE 'o_blfrogCC%' OR cartProdID LIKE 'o_frogzCC%' OR cartProdID LIKE 'CC2JU%' OR cartProdID LIKE 'tadpoleCC%' OR cartProdID LIKE 'bumpzCC%' OR cartProdID LIKE 'ribbitzCC%') AND cartOrderID=" . $order_id;
    372. 

  372. 			$result7=mysql_query($sql7);
    373. 

  373. 			$num_rows_insert=mysql_num_rows($result7);
    374. 

  374. 			if($num_rows_insert>0) {
    375. 

  375. 				$insert_qty=0;
    376. 

  376. 				while($row7=mysql_fetch_assoc($result7)) {
    377. 

  377. 					$insert_qty+=$row7['cartQuantity'];
    378. 

  378. 				}
    379. 

  379. 				//creates running totals for report
    380. 

  380. 				$report['K-1'][0]+=$insert_qty;
    381. 

  381. 				$report['K-1'][1]='Free insert';
    382. 

  382. 				$report['K-1'][3]=3427;
    383. 

  383. 				$labels[$i][$j]['prodId_style']='K-1';
    384. 

  384. 				//
    385. 

  385. 				$labels[$i][$j]['qty']=$insert_qty;
    386. 

  386. 				$labels[$i][$j]['opt_group']='30g Video iPod';
    387. 

  387. 				$labels[$i][$j]['option']='Free insert';
    388. 

  388. 				if($j%$rows_per_label==0) {$labels['label'][$i][$j]['new_label']=$k; $labels['label_per_order'][$i]=$k; $k++;}
    389. 

  389. 				$j++;
    390. 

  390. 			}
    391. 

  391. 			mysql_free_result($result7);
    392. 

  392. 			//Look to see if order is c,b or e and add a belt clip
    393. 

  393. 			$sql7="SELECT cartQuantity FROM cart WHERE cartCompleted=1 AND cartProdID='CCNZ' AND cartOrderID=" . $order_id;
    394. 

  394. 			$result7=mysql_query($sql7);
    395. 

  395. 			$num_rows_insert=mysql_num_rows($result7);
    396. 

  396. 			$belt_clip='-1';
    397. 

  397. 			if($num_rows_insert>0) {
    398. 

  398. 				$insert_qty=0;
    399. 

  399. 				while($row7=mysql_fetch_assoc($result7)) {
    400. 

  400. 					$insert_qty+=$row7['cartQuantity'];
    401. 

  401. 				}
    402. 

  402. 				
    403. 

  403. 				$report['M-2'][0]+=$insert_qty;
    404. 

  404. 				$report['M-2'][1]='Belt Clip';
    405. 

  405. 				$report['M-2'][3]=4072;
    406. 

  406. 				$labels[$i][$j]['prodId_style']='M-2';
    407. 

  407. 				
    408. 

  408. 				$labels[$i][$j]['qty']=$insert_qty;
    409. 

  409. 				$labels[$i][$j]['opt_group']='Ipod';
    410. 

  410. 				$labels[$i][$j]['option']='Video Canz Belt Clip';
    411. 

  411. 				if($j%$rows_per_label==0) {$labels['label'][$i][$j]['new_label']=$k; $labels['label_per_order'][$i]=$k; $k++;}
    412. 

  412. 				$belt_clip=$j;
    413. 

  413. 				$j++;
    414. 

  414. 			}
    415. 

  415. 			mysql_free_result($result7);
    416. 

  416. 			//find any nano and give them a lanyard
    417. 

  417. 			 $sql7="SELECT cartQuantity FROM cart WHERE cartCompleted=1 AND (cartProdID IN('A','AHX','A2') OR cartProdID LIKE 'AHX-%')  AND cartOrderID=" . $order_id;
    418. 

  418. 			$result7=mysql_query($sql7);
    419. 

  419. 			$num_rows_insert=mysql_num_rows($result7);
    420. 

  420. 			$lanyard='-1';
    421. 

  421. 			if($num_rows_insert>0) {
    422. 

  422. 				$insert_qty=0;
    423. 

  423. 				while($row7=mysql_fetch_assoc($result7)) {
    424. 

  424. 					$insert_qty+=$row7['cartQuantity'];
    425. 

  425. 				}
    426. 

  426. 				//creates running totals for report
    427. 

  427. 				$report['L-1'][0]+=$insert_qty;
    428. 

  428. 				$report['L-1'][1]='Lanyard';
    429. 

  429. 				$report['L-1'][3]=2619;
    430. 

  430. 				$labels[$i][$j]['prodId_style']='L-1';
    431. 

  431. 				//
    432. 

  432. 				$labels[$i][$j]['qty']=$insert_qty;
    433. 

  433. 				$labels[$i][$j]['opt_group']='Nano';
    434. 

  434. 				$labels[$i][$j]['option']='Lanyard';
    435. 

  435. 				if($j%$rows_per_label==0) {$labels['label'][$i][$j]['new_label']=$k; $labels['label_per_order'][$i]=$k; $k++;}
    436. 

  436. 				$lanyard=$j;
    437. 

  437. 				$j++;
    438. 

  438. 			}
    439. 

  439. 			mysql_free_result($result7); 
    440. 

  440. 		}
    441. 

  441. 		//cart
    442. 

  442. 		$last_prod='';
    443. 

  443. 		$sql8="SELECT co.coOptID,co.coOptGroup,co.coCartOption,cartProdID FROM cartoptions co, cart c WHERE co.coCartID=c.cartID AND co.coCartID= ".$rs5['cartID']." ORDER BY c.cartProdID";
    444. 

  444. 		$result8 = mysql_query($sql8) or print(mysql_error());
    445. 

  445. 		if(mysql_num_rows($result8)>0) {			
    446. 

  446. 			while($rs8=mysql_fetch_assoc($result8)){
    447. 

  447. 				$sql6="SELECT o.optStyleID,po.poProdID,o.optPantone,p.p_iscert,p.pDownload,o.optGroup,o.optName,o.optBin FROM options o, prodoptions po, products p WHERE o.optGroup=po.poOptionGroup AND po.poProdID=p.pId AND o.optID='".$rs8["coOptID"]."' ORDER BY p.pOrder,po.poProdID,o.optStyleID";
    448. 

  448. 				//echo $sql6.'<br />';
    449. 

  449. 				$result6 = mysql_query($sql6) or print(mysql_error());
    450. 

  450. 				if(mysql_num_rows($result6)>0) {
    451. 

  451. 				$rs6=mysql_fetch_assoc($result6);
    452. 

  452. 					if($rs6['optStyleID']!='none'){
    453. 

  453. 						if($rs6['pDownload']=='' && $rs8['coCartOption']!='Email'){
    454. 

  454. 							/*if(strstr($rs6['poProdID'],'M-1') && $belt_clip>=0) {
    455. 

  455. 								$labels[$i][$belt_clip]['qty']+=$rs5['qty_total'];
    456. 

  456. 								$str_p=$rs6['poProdID'];				
    457. 

  457. 							} else*/ 
    458. 

  458. 							if(strstr($rs6['poProdID'],'L-1') && $lanyard>=0) {					
    459. 

  459. 								$labels[$i][$lanyard]['qty']+=$rs5['qty_total'];
    460. 

  460. 								$str_p=$rs6['poProdID'];				
    461. 

  461. 							} else {
    462. 

  462. 								if($rs6['poProdID'] =='K-1')$str_p='K-1';
    463. 

  463. 								elseif($rs6['optStyleID']=='Class'){
    464. 

  464. 									$str_p='SK-U';
    465. 

  465. 									$report['SK-U'][0]+=$insert_qty[$p];
    466. 

  466. 									$report['SK-U'][1]='Screen Kit';
    467. 

  467. 									$report['SK-U'][3]=3737;
    468. 

  468. 								}
    469. 

  469. 								elseif($rs6['poProdID']=='M-1' || $rs6['poProdID']=='L-1') $str_p=$rs6['poProdID'];
    470. 

  470. 								elseif($rs6['poProdID']=='SK') $str_p=$rs6['poProdID'].'-'.$rs6['optStyleID'];
    471. 

  471. 								elseif(strstr($rs6['poProdID'],'-Custom'))$str_p=$rs8['cartProdID'];
    472. 

  472. 								//elseif(strstr($rs8['cartProdID'],'tadpoleC'))$str_p=$rs8['cartProdID'].'-'.$rs6['optStyleID'];
    473. 

  473. 								elseif(stristr($rs6['poProdID'],'-sale'))$str_p=str_replace('-sale','',$rs6['poProdID']).'-'.$rs6['optStyleID'];
    474. 

  474. 								elseif($rs6['optGroup']>=165 && $rs6['optGroup']<=171){
    475. 

  475. 									$str_p='Art3G-'; 
    476. 

  476. 									$str_p.=$rs6['optStyleID'];
    477. 

  477. 								}
    478. 

  478. 								elseif(strstr($rs6['poProdID'],'-')){
    479. 

  479. 									$str_p='Art-'; 
    480. 

  480. 									$str_p.=$rs6['optStyleID'];
    481. 

  481. 								} elseif($rs6['p_iscert']!=0){
    482. 

  482. 									$str_p=$rs8['cartProdID'].'-Hard';										
    483. 

  483. 								} else { 
    484. 

  484. 									$str_p=$rs6['poProdID'].'-'; 
    485. 

  485. 									$str_p.=$rs6['optStyleID'];	
    486. 

  486. 								}		
    487. 

  487. 								//check for dublicates
    488. 

  488. 								$error_this=FALSE;
    489. 

  489. 								if(!strstr($rs6['poProdID'],'-Custom')){
    490. 

  490. 									$cnt_this=count($labels[$i]);
    491. 

  491. 									for($jj=0;$jj<$cnt_this;$jj++) {
    492. 

  492. 										if($labels[$i][$jj]['prodId_style']==$str_p){
    493. 

  493. 											$error_this=TRUE;
    494. 

  494. 											$labels[$i][$jj]['qty']+=$rs5['qty_total'];	
    495. 

  495. 										}								
    496. 

  496. 									}
    497. 

  497. 								} 
    498. 

  498. 								$option='';
    499. 

  499. 								if(!$error_this){
    500. 

  500. 									$option=$rs8['coCartOption'];
    501. 

  501. 									if(strstr($rs6['poProdID'],'-Custom')) {
    502. 

  502. 										$opt_cust=$rs8['coCartOption'];
    503. 

  503. 										$labels[$i][$j]['img']=$arr[$i]['custom_screen_img'][$opt_cust];
    504. 

  504. 										$rows_per_label=$rows_per_label-2;
    505. 

  505. 										$option='';									
    506. 

  506. 									}
    507. 

  507. 									$labels[$i][$j]['prodId_style']=$str_p;
    508. 

  508. 									
    509. 

  509. 									//
    510. 

  510. 									$labels['total_prods'][$i]+=$rs5['qty_total'];
    511. 

  511. 									if($j%$rows_per_label==0) {$rows_per_label=10;$labels['label'][$i][$j]['new_label']=$k; $labels['label_per_order'][$i]=$k; $k++;}
    512. 

  512. 									$labels[$i][$j]['opt_group']=$rs8['coOptGroup'];
    513. 

  513. 									$labels[$i][$j]['option']=$rs8['coCartOption'];
    514. 

  514. 									$labels[$i][$j]['pantone']=$rs6['optPantone'];
    515. 

  515. 									$labels[$i][$j]['qty']=$rs5['qty_total'];
    516. 

  516. 									$j++;
    517. 

  517. 									//if(strstr($rs6['poProdID'],'-Custom')) $j++;
    518. 

  518. 								} 
    519. 

  519. 								//creates running totals for report
    520. 

  520. 								if($str_p=='K-1') $option='Free Insert';
    521. 

  521. 								$report[$str_p][0]+=$rs5['qty_total'];
    522. 

  522. 								$report[$str_p][1]=$option;
    523. 

  523. 								$report[$str_p][2]=$rs6['optPantone'];								
    524. 

  524. 							}
    525. 

  525. 						}
    526. 

  526. 					}
    527. 

  527. 				}
    528. 

  528. 			}
    529. 

  529. 			mysql_free_result($result8);
    530. 

  530. 			mysql_free_result($result6);
    531. 

  531. 			$insert_qty='';
    532. 

  532. 		} else {
    533. 

  533. 			$sql9="SELECT * FROM cart c, products p WHERE c.cartProdID=p.pID AND c.cartID= ".$rs5['cartID']." ORDER BY c.cartProdID";
    534. 

  534. 			$result9 = mysql_query($sql9) or print(mysql_error());
    535. 

  535. 			if(mysql_num_rows($result9)>0) {			
    536. 

  536. 				while($rs9=mysql_fetch_assoc($result9)){
    537. 

  537. 					if($rs9['p_iscert']=='0' && $rs9['pDownload']==''){
    538. 

  538. 						$cnt_this=count($labels[$i]);
    539. 

  539. 						$error_this=FALSE;
    540. 

  540. 						for($jj=0;$jj<$cnt_this;$jj++) {
    541. 

  541. 							if($labels[$i][$jj]['prodId_style']==$rs9["cartProdID"]){
    542. 

  542. 								$error_this=TRUE;
    543. 

  543. 								$labels[$i][$jj]['qty']+=$rs5['qty_total'];	
    544. 

  544. 							}								
    545. 

  545. 						}
    546. 

  546. 						if(!$error_this){							
    547. 

  547. 							//creates running totals for report
    548. 

  548. 							$report[$rs9["cartProdID"]][0]+=$rs5['qty_total'];
    549. 

  549. 							//
    550. 

  550. 							$labels[$i][$j]['prodId_style']=$rs9["cartProdID"];
    551. 

  551. 							$labels[$i][$j]['pantone']=$rs9['pBin'];
    552. 

  552. 							$labels['total_prods'][$i]+=$rs5['qty_total'];
    553. 

  553. 							if($j%$rows_per_label==0) {$labels['label'][$i][$j]['new_label']=$k; $labels['label_per_order'][$i]=$k; $k++;}
    554. 

  554. 							$labels[$i][$j]['qty']=$rs5['qty_total'];
    555. 

  555. 							$j++;
    556. 

  556. 						}
    557. 

  557. 					}
    558. 

  558. 				}
    559. 

  559. 			}
    560. 

  560. 			mysql_free_result($result9);	
    561. 

  561. 		}				
    562. 

  562. 	}
    563. 

  563. 	mysql_free_result($result5);
    564. 

  564. 	//wholesalers return label
    565. 

  565. 	if($labels['shipping'][$i]['eid']>0 && empty($etailer_only)) {
    566. 

  566. 		// get wholesaler return label info
    567. 

  567. 		if($row_address['ordEID']>0){
    568. 

  568. 			$sql_return="SELECT Name,returnAddress,returnAddress2,returnCity,returnState,returnState2,returnZip,returnCountry FROM customers WHERE custID=".$labels['shipping'][$i]['eid'];
    569. 

  569. 			$result_return=mysql_query($sql_return);
    570. 

  570. 			$row_return=mysql_fetch_assoc($result_return);
    571. 

  571. 			$i++;
    572. 

  572. 			$labels['return'][$i]=$row_return;
    573. 

  573. 			$labels[$i][$j]['eid']=$row_address['ordEID'];
    574. 

  574. 			$j=0;
    575. 

  575. 			if($j%$rows_per_label==0) {$labels['label'][$i][$j]['new_label']=$k; $labels['label_per_order'][$i]=$k; $k++;}
    576. 

  576. 			$j++;
    577. 

  577. 			$labels['label_count'][$i]=$label_count;
    578. 

  578. 			$labels['order_id'][$i]=$order_id;
    579. 

  579. 		}
    580. 

  580. 		// end wholesaler
    581. 

  581. 	} 
    582. 

  582. 	if(!empty($labels[$i])) sort($labels[$i]);
    583. 

  583. }	
    584. 

  584. unset($arr);
    585. 

  585. if(!is_array($labels)) {echo 'There are no orders to print!';exit();}
    586. 

  586. //showarray($labels);
    587. 

  587. 

  588. ?>
    589. 

  589. <table border="0" cellspacing="0" cellpadding="8" width="50%" align="center">
    590. 

  590. 	<tr>
    591. 

  591. <?
    592. 

  592. $display_text=false;
    593. 

  593. $cell_count=0;
    594. 

  594. //$oldship='';
    595. 

  595. for($i=0;$i<count($labels);$i++) {	
    596. 

  596. 	//echo 'shiptype='.$labels['shipping'][$i]['shiptype']. ' old='.$oldship;
    597. 

  597. 	for($j=0;$j<count($labels[$i]);$j++) {		
    598. 

  598. 		if(!empty($labels['label'][$i][$j]['new_label'])) { 
    599. 

  599. 			if($display_text) {?> 
    600. 

  600.   <tr><td colspan="4" valign="bottom">&nbsp;</td></tr>
    601. 

  601. 		<? }
    602. 

  602. 			$display_text=true; 
    603. 

  603. 			if($cell_count==($rows*$cols)){// || ($labels['shipping'][$i]['shiptype']!=$oldship && $i!=0)) { 
    604. 

  604. 			$cell_count=0;
    605. 

  605. 		?>
    606. 

  606. </table>
    607. 

  607. 				</td>							
    608. 

  608. 			</tr>			
    609. 

  609. 		</table>
    610. 

  610. 		<table width="50%" border="0" align="center" cellpadding="8" cellspacing="0" style="page-break-before:always;">
    611. 

  611. 			<tr>
    612. 

  612. 		<? }
    613. 

  613. 			elseif($cell_count%$cols==0 && $cell_count!=0) echo '</table></td></tr><tr><!-- <td colspan="2">&nbsp;</td></tr> Use for spacing between rows --><tr>'."\r";
    614. 

  614. 			elseif($cell_count==0) echo '';
    615. 

  615. 			else {
    616. 

  616. 				echo '</table>';
    617. 

  617. 				//if(!empty($shipping_logan))
    618. 

  618. 				echo '<td width="10">&nbsp;</td>';
    619. 

  619. 			}		
    620. 

  620. 		?>
    621. 

  621. 		
    622. 

  622. 			<td valign="top" height="">
    623. 

  623. 				<? if(empty($labels[$i][$j]['eid'])) { ?>
    624. 

  624. 				<!-- shipping address -->
    625. 

  625. 				<div style="height:<?=$label_height?>px; border-right:#000000 solid 1px;">
    626. 

  626. 				<table width="<?=$label_width?>"  border="0" cellspacing="0" cellpadding="0" > 
    627. 

  627. 					<tr>
    628. 

  628. 						<td ><?php print $labels['shipping'][$i]['name']?></td>						
    629. 

  629. 				    </tr>
    630. 

  630. 					<tr>
    631. 

  631. 						<td ><?php print $labels['shipping'][$i]['address']?><?php if(!empty($labels['shipping'][$i]['address2'])) print '<br />'.$labels['shipping'][$i]['address2'];?></td>
    632. 

  632. 						
    633. 

  633. 					</tr>
    634. 

  634. 					<tr>
    635. 

  635. 						<td ><?php print $labels['shipping'][$i]['city']?>, <?php print $labels['shipping'][$i]['state']?> <?php print $labels['shipping'][$i]['zip']?></td>
    636. 

  636. 					</tr>
    637. 

  637. 					<tr>
    638. 

  638. 						<td ><?php if($labels['shipping'][$i]['country']=='UNITED STATES OF AMERICA') echo 'USA'; else echo $labels['shipping'][$i]['country']?></td>
    639. 

  639. 					</tr>
    640. 

  640. 					<tr>
    641. 

  641. 						<td ><?php print $labels['shipping'][$i]['phone']?></td>
    642. 

  642. 					</tr>
    643. 

  643. 					<tr>
    644. 

  644. 					    <td><div style=" border-top:#000000 solid 1px; margin-top:4px; text-align:center; font-size:22px; font-weight:bold;"><?=$labels['shipping'][$i]['shiptype']?></div></td>
    645. 

  645. 					</tr>	
    646. 

  646. 					<tr>
    647. 

  647. 					    <td><img src="../../barcode/wrapper.php?p_bcType=1&p_text=<?=$labels['order_id'][$i]?>&p_xDim=1&p_w2n=3&p_charGap=1&p_invert=N&p_charHeight=40&p_type=1&p_label=N&p_rotAngle=0&p_checkDigit=N" ALT="1234567890"></td>
    648. 

  648. 					</tr>	
    649. 

  649. 					<tr>
    650. 

  650. 					    <td ><div style="margin-left:10px; font-weight:bold;">Order# <span style="letter-spacing:.6em;"><? if(!empty($etailer_only) && !empty($labels['ordEOrderID'][$i])) echo $labels['ordEOrderID'][$i]; else echo $labels['order_id'][$i]?></span></div></td>
    651. 

  651. 					</tr>
    652. 

  652. 					<tr>
    653. 

  653. 						<td valign="bottom" ><div style="font-size:9px; margin-top:30px;"><?= number_format($labels['pWeight'][$i]*35.2739619,3).' oz' ?><br />batch #<?=$batch_name?></div></td>
    654. 

  654. 					</tr>															
    655. 

  655. 				</table>
    656. 

  656. 				</div>
    657. 

  657. 				<!-- end shipping address -->
    658. 

  658. 				<? } else { 
    659. 

  659. 					if(empty($etailer_only)){
    660. 

  660. 				?>
    661. 

  661. 				<!-- return address -->
    662. 

  662. 				<div style="height:<?=$label_height?>px;">
    663. 

  663. 				<table width="<?=$label_width?>"  border="0" cellspacing="0" cellpadding="0" > 
    664. 

  664. 					<tr>
    665. 

  665. 						<td ><?php print $labels['return'][$i]['Name']?></td>						
    666. 

  666. 				    </tr>
    667. 

  667. 					<tr>
    668. 

  668. 						<td ><?php print $labels['return'][$i]['returnAddress']?><?php if(!empty($labels['return'][$i]['returnAddress2'])) print '<br />'.$labels['return'][$i]['returnAddress2'];?></td>
    669. 

  669. 						
    670. 

  670. 

  671. 					</tr>
    672. 

  672. 					<tr>
    673. 

  673. 						<td ><?php print $labels['return'][$i]['returnCity']?>, <?php if(!empty($labels['return'][$i]['returnState2'])) echo $labels['return'][$i]['returnState2']; else echo $labels['return'][$i]['returnState'];?> <?php print $labels['return'][$i]['returnZip']?></td>
    674. 

  674. 					</tr>
    675. 

  675. 					<tr>
    676. 

  676. 						<td ><?php if(strtoupper($labels['return'][$i]['returnCountry'])=='UNITED STATES OF AMERICA') echo 'USA'; else echo $labels['return'][$i]['returnCountry']?></td>
    677. 

  677. 					</tr>											
    678. 

  678. 					<tr>
    679. 

  679. 					    <td ><div style="margin-top:4px;padding-top:2px; border-top:#000000 solid 1px; "><?=$labels['order_id'][$i]?></div></td>
    680. 

  680. 					</tr>															
    681. 

  681. 				</table>
    682. 

  682. 				</div>
    683. 

  683. 				<!-- end return address -->
    684. 

  684. 				<? }
    685. 

  685. 				} ?>
    686. 

  686. 			</td>
    687. 

  687. 			<!-- <td>&nbsp;</td> use for spacing between shipping and order labels on the row-->
    688. 

  688. 			<td valign="top" align="left">
    689. 

  689. 				<table height="<?=$label_height?>" width="<?=$label_width?>" border="0" cellspacing="0" cellpadding="2">				  
    690. 

  690. 				  <? if(empty($labels[$i][$j]['eid'])) { ?>
    691. 

  691. 				  <tr>
    692. 

  692. 					<td colspan="4" height="4" style="border-bottom:1px solid #000000;"><div style="font-size:10px; font-weight:bold; float:right">(<?=$labels['label'][$i][$j]['new_label']?> of <?=$labels['label_per_order'][$i]?>)</div><div style="font-size:12px; font-weight:bold"><span style="font-size:14;"><?=$labels['label_count'][$i]?></span> 
    693. 

  693. 					</div></td>
    694. 

  694. 				  </tr>
    695. 

  695. 				  <? } ?>
    696. 

  696. 				
    697. 

  697. 		<? } ?>				 
    698. 

  698. 				  <? if(empty($labels[$i][$j]['eid'])) { ?>
    699. 

  699. 				  <tr>
    700. 

  700. 					<td style="border-right:1px solid #000000;border-top:1px solid #000000;" align="center"><div style="font-size:9px; font-weight:bold"><? if($labels[$i][$j]['qty']>1) echo '*'.$labels[$i][$j]['qty']; else echo $labels[$i][$j]['qty'];?></div></td>
    701. 

  701. 					<td style="border-right:1px solid #000000; border-top:1px solid #000000;" height="4"  align="center" nowrap>
    702. 

  702. 					  <div style="width:120px ">
    703. 

  703. 					    <div style="border:1px solid #000000;width:9px;height:9px; float:right; margin-left:1px; margin-right:1px;"></div>
    704. 

  704.  						<div style="font-size:10px; font-weight:bold; margin:0;"><?=$labels[$i][$j]['prodId_style']?></div>
    705. 

  705. 					  </div>
    706. 

  706. 					</td>
    707. 

  707. 					<td style="border-top:1px solid #000000;" height="4" align="center">
    708. 

  708. 					<? if(!empty($labels[$i][$j]['img'])) {?>
    709. 

  709. 					<img src="../imguploads/img_screen/<?=$labels[$i][$j]['img']?>.gif" height="30"/>
    710. 

  710. 					<? }else { ?>
    711. 

  711. 					<div style="font-size:9px; font-weight:bold;"><? if(!empty($labels[$i][$j]['pantone'])) echo $labels[$i][$j]['pantone']; else echo '&nbsp;'; ?></div>
    712. 

  712. 					<? } ?>
    713. 

  713. 					</td>
    714. 

  714. 				  </tr>
    715. 

  715. 				  <? } ?>
    716. 

  716. 		<? 
    717. 

  717. 		if(!empty($labels['label'][$i][$j]['new_label'])) $cell_count++;
    718. 

  718. 		//$oldship=$labels['shipping'][$i]['shiptype'];
    719. 

  719. 	}
    720. 

  720. 	
    721. 

  721. } ?>
    722. 

  722. 				<tr><td colspan="4" valign="bottom">&nbsp;</td></tr>
    723. 

  723. 			</table>			
    724. 

  724. 		<? if($cell_count%2!=0)echo '</td><td>&nbsp;</td><td><table width="'.$label_width.'" cellspacing="0" cellpadding="2">
    725. 

  725.   <tr>
    726. 

  726.     <td>&nbsp;</td>
    727. 

  727.   </tr>
    728. 

  728. </table>
    729. 

  729. </td><td><table width="'.$label_width.'" cellspacing="0" cellpadding="2">
    730. 

  730.   <tr>
    731. 

  731.     <td>&nbsp;</td>
    732. 

  732.   </tr>
    733. 

  733. </table>'; ?>
    734. 

  734. 		</td>		
    735. 

  735. 	</tr>
    736. 

  736. </table>
    737. 

  737. <?
    738. 

  738. //hong kong shipping recreate	
    739. 

  739. 			/* $file_path='hkshipping/';
    740. 

  740. 			$folderName=date('Y_m');
    741. 

  741. 			$dir=$file_path.$folderName;
    742. 

  742. 			$ourFileName = str_replace('_order_ids.txt','',$file)."_hkshipping.csv";
    743. 

  743. 			if(is_dir($dir) || $dir == "/" ){
    744. 

  744. 			} else {
    745. 

  745. 				//echo $dir;
    746. 

  746. 				mkdir($dir,0777);
    747. 

  747. 			}
    748. 

  748. 				$ourFileHandle = fopen($dir.'/'.$ourFileName, 'w') or die("can't open file");
    749. 

  749. 				fwrite($ourFileHandle,$csv_shipping);
    750. 

  750. 				fclose($ourFileHandle); */  
    751. 

  751. if(empty($file) && empty($path)) {
    752. 

  752. 	// update all orders to packing
    753. 

  753. 	
    754. 

  754. 	//$arr_packing=explode(',',$order_id_commas);
    755. 

  755. 	//showarray($arr_packing);
    756. 

  756. 	/*if(empty($shipping_logan)){*/
    757. 

  757. 		
    758. 

  758. 		foreach($arr_packing as $value) {
    759. 

  759. 			$sql_update="UPDATE orders SET ordStatus='6', ordBatch='".$batch_name."' WHERE ordID='".$value."'";
    760. 

  760. 			//echo $sql_update;
    761. 

  761. 			mysql_query($sql_update)or print(mysql_error());
    762. 

  762. 			//insert location into location history
    763. 

  763. 			if(!setNewLocation( 6 , $value )) print("Unable to record location.");
    764. 

  764. 		}
    765. 

  765. 	/*} else {
    766. 

  766. 		foreach($arr_packing as $value) {
    767. 

  767. 			$sql_update="UPDATE orders SET ordPrinted_logan='".date('Y-m-d H:i:s')."' WHERE ordID='".$value."'";
    768. 

  768. 			mysql_query($sql_update)or print(mysql_error());
    769. 

  769. 		}
    770. 

  770. 	} */ 
    771. 

  771. 	//$order_id_commas=implode(',',$arr_packing);
    772. 

  772. 		
    773. 

  773. 	/*$str_csv.= '"Quantity","Product","Pantone","Option"';
    774. 

  774. 	$str_csv.= "\r\n";*/
    775. 

  775. 	
    776. 

  776. 	foreach($report as $key => $value){
    777. 

  777. 		/*$str_csv.= '"'.$report[$key][0].'","' . str_replace('"','""',$key).'","'. str_replace('"','""',$report[$key][2]) .'","'.str_replace('"','""',$report[$key][1]).'"';
    778. 

  778. 		$str_csv.= "\r\n";*/
    779. 

  779. 		//inventory
    780. 

  780. 		if(!empty($report[$key][3]) && empty($shipping_logan)){
    781. 

  781. 			$sql = "SELECT * FROM options WHERE optID = " . $report[$key][3];
    782. 

  782. 			$res = mysql_query($sql);
    783. 

  783. 			$options = mysql_fetch_assoc($res);
    784. 

  784. 			
    785. 

  785. 			$sSQL = "UPDATE options SET optStock=optStock-" . $report[$key][0] . " WHERE optID=" . $report[$key][3];
    786. 

  786. 			//echo $sSQL;
    787. 

  787. 			mysql_query($sSQL) or print(mysql_error());
    788. 

  788. 			
    789. 

  789. 			$sql = "SELECT p.*
    790. 

  790. 					FROM products p 
    791. 

  791. 						JOIN prodoptions po ON p.pID = po.poProdID
    792. 

  792. 						JOIN optiongroup og ON po.poOptionGroup = og.optGrpID
    793. 

  793. 						JOIN options o ON og.optGrpID = o.optGroup
    794. 

  794. 					WHERE o.optID = '".$report[$key][3]."'";
    795. 

  795. 			$res = mysql_query($sql);
    796. 

  796. 			$prod = mysql_fetch_assoc($res);
    797. 

  797. 			
    798. 

  798. 			$prodstyle = $prod["pID"] . "-" . $options['optStyleID'];
    799. 

  799. 			$newvalue = $options['optStock'] - $report[$key][0];
    800. 

  800. 			
    801. 

  801. 			// RECORD INVENTORY CHANGE
    802. 

  802. 			$sql3 = "INSERT INTO inv_adjustments (iaOptID, iaAmt, iaDate, iaProdStyle, iaOldValue, iaNewValue, iareason, iaEmpID)
    803. 

  803. 					 VALUES (".$report[$key][3].", -".$report[$key][0].", '".date('Y-m-d H:i:s')."', '$prodstyle', ".$options['optStock'].", $newvalue, 8, '".$_SESSION['employee']['id']."')";
    804. 

  804. 			$res3 = mysql_query($sql3);
    805. 

  805. 		}
    806. 

  806. 	}
    807. 

  807. 	//showarray($report);
    808. 

  808. 	//report
    809. 

  809. 	/*$file_path='order_reports/';
    810. 

  810. 	$folderName=date('Y_m');
    811. 

  811. 	$dir=$file_path.$folderName;
    812. 

  812. 	$ourFileName = date('d_H:i:s').$str_batch_type."_report.csv";
    813. 

  813. 	if(is_dir($dir) || $dir == "/" ){
    814. 

  814. 	} else {
    815. 

  815. 		//echo $dir;
    816. 

  816. 		mkdir($dir,0755);
    817. 

  817. 	}
    818. 

  818. 		$ourFileHandle = fopen($dir.'/'.$ourFileName, 'w') or die("can't open file");
    819. 

  819. 		fwrite($ourFileHandle,$str_csv);
    820. 

  820. 		fclose($ourFileHandle); */ 
    821. 

  821. 	//hong kong shipping	
    822. 

  822. 		/*$file_path='hkshipping/';
    823. 

  823. 		$folderName=date('Y_m');
    824. 

  824. 		$dir=$file_path.$folderName;
    825. 

  825. 		$ourFileName = date('d_H:i:s').$str_batch_type."_hkshipping.csv";
    826. 

  826. 		if(is_dir($dir) || $dir == "/" ){
    827. 

  827. 		} else {
    828. 

  828. 			//echo $dir;
    829. 

  829. 			mkdir($dir,0777);
    830. 

  830. 		}
    831. 

  831. 			$ourFileHandle = fopen($dir.'/'.$ourFileName, 'w') or die("can't open file");
    832. 

  832. 			fwrite($ourFileHandle,$csv_shipping);
    833. 

  833. 			fclose($ourFileHandle);*/ 
    834. 

  834. 	//orders	
    835. 

  835. 		/*$file_path='order_ids/';
    836. 

  836. 		$folderName=date('Y_m');
    837. 

  837. 		$dir=$file_path.$folderName;
    838. 

  838. 		$ourFileName = date('d_H:i:s').$str_batch_type.".txt";
    839. 

  839. 		if(is_dir($dir) || $dir == "/"  ){//|| $dir == "/"		
    840. 

  840. 		} else {
    841. 

  841. 			mkdir($dir,0755);
    842. 

  842. 		}
    843. 

  843. 			$ourFileHandle = fopen($dir.'/'.$ourFileName, 'w') or die("can't open file");
    844. 

  844. 			fwrite($ourFileHandle,$order_id_commas);
    845. 

  845. 			//echo 'insert-'.$order_id_commas;
    846. 

  846. 			fclose($ourFileHandle);*/  
    847. 

  847. 	//echo 'commas='.$order_id_commas;
    848. 

  848. 	
    849. 

  849. 	
    850. 

  850. 	//$order_id_commas=''; 
    851. 

  851. }
    852. 

  852. //if(!empty($str_orderstatus))
    853. 

  853. //send('dave@reminderband.com','blake@reminderband.com','Orders Set to Shipping When Packing',$str_orderstatus,'Dave','Blake');
    854. 

  854. 

  855. function send($to,$from,$subject,$message,$toName='',$fromName='') {
    856. 

  856. 	$customheaders = "MIME-Version: 1.0\n";
    857. 

  857. 	$customheaders .= "From: $fromName <$from>\n";
    858. 

  858. 	$customheaders .= "Reply-To: $from\n";
    859. 

  859. 	$customheaders .= "Content-type: text/html; charset=iso-8859-1\n";
    860. 

  860. 	
    861. 

  861. 	mail($to,$subject,$message,$customheaders);
    862. 

  862. }
    863. 

  863. 

  864. //showarray($report);
    865. 

  865. ?>
    866. 

  866.