PageRenderTime 43ms CodeModel.GetById 9ms RepoModel.GetById 0ms app.codeStats 1ms

/application/views/pages/admin/prodopts.php

https://bitbucket.org/chadsaun/ifrogz-panel
PHP | 785 lines | 754 code | 16 blank | 15 comment | 113 complexity | c2bf3acf8c6764f3ea0110f3423abc1c 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. if(@$storesessionvalue=="") $storesessionvalue="virtualstore".time();
    8. 

  8. if($_SESSION["loggedon"] != $storesessionvalue || @$disallowlogin==TRUE) exit();
    9. 

  9. $success=TRUE;
    10. 

  10. $sSQL = "";
    11. 

  11. $alldata="";
    12. 

  12. $alreadygotadmin = getadminsettings();
    13. 

  13. if(@$_POST["posted"]=="1"){
    14. 

  14. 	if(@$_POST["act"]=="delete"){
    15. 

  15. 		$sSQL = "SELECT poID FROM prodoptions WHERE poOptionGroup=" . @$_POST["id"];
    16. 

  16. 		$result = mysql_query($sSQL) or print(mysql_error());
    17. 

  17. 		if(mysql_num_rows($result) > 0){
    18. 

  18. 			$success=FALSE;
    19. 

  19. 			$errmsg = $yyPOErr . "<br />";
    20. 

  20. 			$errmsg .= $yyPOUse;
    21. 

  21. 		}
    22. 

  22. 		mysql_free_result($result);
    23. 

  23. 		if($success){
    24. 

  24. 			$sSQL = "DELETE FROM options WHERE optGroup=" . @$_POST["id"];
    25. 

  25. 			mysql_query($sSQL) or print(mysql_error());
    26. 

  26. 			$sSQL = "DELETE FROM optiongroup WHERE optGrpID=" . @$_POST["id"];
    27. 

  27. 			mysql_query($sSQL) or print(mysql_error());
    28. 

  28. 			print '<meta http-equiv="refresh" content="3; url=/admin/prodopts.php">';
    29. 

  29. 		}
    30. 

  30. 	}elseif(@$_POST["act"]=="domodify" || @$_POST["act"]=="doaddnew"){
    31. 

  31. 		$sSQL = "";
    32. 

  32. 		$bOption=FALSE;
    33. 

  33. 		$optFlags = 0;
    34. 

  34. 		if(@$_POST["pricepercent"]=="1") $optFlags=1;
    35. 

  35. 		if(@$_POST["weightpercent"]=="1") $optFlags += 2;
    36. 

  36. 		for($rowcounter=0; $rowcounter < maxprodopts; $rowcounter++){
    37. 

  37. 			if(trim(@$_POST["opt" . $rowcounter]) != "") $bOption=TRUE;
    38. 

  38. 			$aOption[$rowcounter][0]=mysql_real_escape_string(unstripslashes(trim(@$_POST["opt" . $rowcounter])));
    39. 

  39. 			for($index=2; $index <= $adminlanguages+1; $index++){
    40. 

  40. 				if(($adminlangsettings & 32)==32)
    41. 

  41. 					$aOption[$rowcounter][5+$index]=mysql_real_escape_string(unstripslashes(trim(@$_POST["opl" . $index . "x" . $rowcounter])));
    42. 

  42. 			}
    43. 

  43. 			if(is_numeric(trim(@$_POST["pri" . $rowcounter])))
    44. 

  44. 				$aOption[$rowcounter][1]=trim(@$_POST["pri" . $rowcounter]);
    45. 

  45. 			else
    46. 

  46. 				$aOption[$rowcounter][1]=0;
    47. 

  47. 			if(is_numeric(trim(@$_POST["wsp" . $rowcounter])))
    48. 

  48. 				$aOption[$rowcounter][4]=trim(@$_POST["wsp" . $rowcounter]);
    49. 

  49. 			else
    50. 

  50. 				$aOption[$rowcounter][4]=0;
    51. 

  51. 			if(is_numeric(trim(@$_POST["wei" . $rowcounter])))
    52. 

  52. 				$aOption[$rowcounter][2]=trim(@$_POST["wei" . $rowcounter]);
    53. 

  53. 			else
    54. 

  54. 				$aOption[$rowcounter][2]=0;			
    55. 

  55. 			//added by Blake 2-15-06
    56. 

  56. 				$aOption[$rowcounter][7]=trim(@$_POST["style" . $rowcounter]);
    57. 

  57. 			$aOption[$rowcounter][8]=trim(@$_POST["color" . $rowcounter]);
    58. 

  58. 			$aOption[$rowcounter][9]=trim(@$_POST["pantonecolor" . $rowcounter]);
    59. 

  59. 			if(trim(@$_POST["display" . $rowcounter])=='yes') $aOption[$rowcounter][10]='yes';
    60. 

  60. 			else $aOption[$rowcounter][10]='no';
    61. 

  61. 			 $aOption[$rowcounter][11]=trim(@$_POST["optUPC" . $rowcounter]);
    62. 

  62. 			
    63. 

  63. 			//end
    64. 

  64. 			if(is_numeric(trim(@$_POST["optStock" . $rowcounter])))
    65. 

  65. 				$aOption[$rowcounter][3]=trim(@$_POST["optStock" . $rowcounter]);
    66. 

  66. 			else
    67. 

  67. 				$aOption[$rowcounter][3]=0;
    68. 

  68. 			$aOption[$rowcounter][5]=mysql_real_escape_string(unstripslashes(trim(@$_POST["regexp" . $rowcounter])));
    69. 

  69. 			$aOption[$rowcounter][6]=trim(@$_POST["orig" . $rowcounter]);
    70. 

  70. 		}
    71. 

  71. 		if((trim(@$_POST["secname"])=="" || ! $bOption) && @$_POST["optType"] != "3"){
    72. 

  72. 			$success=FALSE;
    73. 

  73. 			$errmsg = $yyPOErr . "<br />";
    74. 

  74. 			$errmsg .= $yyPOOne;
    75. 

  75. 		}else{
    76. 

  76. 			if(@$_POST["optType"]=="3"){ // Text option
    77. 

  77. 				$fieldDims = trim(@$_POST["pri0"]) . ".";
    78. 

  78. 				if((int)@$_POST["fieldheight"] < 10) $fieldDims .= "0";
    79. 

  79. 				$fieldDims .= trim(@$_POST["fieldheight"]);
    80. 

  80. 				if(@$_POST["act"]=="doaddnew"){
    81. 

  81. 					$sSQL = "INSERT INTO optiongroup (optGrpName,";
    82. 

  82. 					for($index=2; $index <= $adminlanguages+1; $index++){
    83. 

  83. 						if(($adminlangsettings & 16)==16)
    84. 

  84. 							$sSQL .= "optGrpName" . $index . ",";
    85. 

  85. 					}
    86. 

  86. 					$sSQL .= "optType,optGrpWorkingName,optFlags) VALUES (";
    87. 

  87. 					$sSQL .= "'" . mysql_real_escape_string(unstripslashes(trim(@$_POST["secname"]))) . "',";
    88. 

  88. 					for($index=2; $index <= $adminlanguages+1; $index++){
    89. 

  89. 						if(($adminlangsettings & 16)==16)
    90. 

  90. 							$sSQL .= "'" . mysql_real_escape_string(unstripslashes(trim(@$_POST["secname" . $index]))) . "',";
    91. 

  91. 					}
    92. 

  92. 					if(trim(@$_POST["forceselec"])=="ON") $sSQL .= "'3',"; else $sSQL .= "'-3',";
    93. 

  93. 					if(trim(@$_POST["workingname"])=="")
    94. 

  94. 						$sSQL .= "'" . mysql_real_escape_string(unstripslashes(trim(@$_POST["secname"])));
    95. 

  95. 					else
    96. 

  96. 						$sSQL .= "'" . mysql_real_escape_string(unstripslashes(trim(@$_POST["workingname"])));
    97. 

  97. 					$sSQL .= "'," . $optFlags . ")";
    98. 

  98. 					mysql_query($sSQL) or print(mysql_error());
    99. 

  99. 					$iID  = mysql_insert_id();
    100. 

  100. 					$sSQL = "INSERT INTO options (optGroup,optName,optPriceDiff";
    101. 

  101. 					for($index=2; $index <= $adminlanguages+1; $index++){
    102. 

  102. 						if(($adminlangsettings & 16)==16)
    103. 

  103. 							$sSQL .= ",optName" . $index;
    104. 

  104. 					}
    105. 

  105. 					$sSQL .= ",optWeightDiff) VALUES (" . $iID . ",'" . mysql_real_escape_string(unstripslashes(trim(@$_POST["opt0"]))) . "'," . $fieldDims;
    106. 

  106. 					for($index=2; $index <= $adminlanguages+1; $index++){
    107. 

  107. 						if(($adminlangsettings & 16)==16)
    108. 

  108. 							$sSQL .= ",'" . mysql_real_escape_string(unstripslashes(trim(@$_POST["opl" . $index . "x0"]))) . "'";
    109. 

  109. 					}
    110. 

  110. 					$sSQL .= ",0)";
    111. 

  111. 					mysql_query($sSQL) or print(mysql_error());
    112. 

  112. 				}else{
    113. 

  113. 					$iID = @$_POST["id"];
    114. 

  114. 					$sSQL = "UPDATE optiongroup SET optGrpName='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["secname"]))) . "'";
    115. 

  115. 					for($index=2; $index <= $adminlanguages+1; $index++){
    116. 

  116. 						if(($adminlangsettings & 16)==16)
    117. 

  117. 							$sSQL .= ",optGrpName" . $index . "='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["secname" . $index]))) . "'";
    118. 

  118. 					}
    119. 

  119. 					if(trim(@$_POST["forceselec"])=="ON")
    120. 

  120. 						$sSQL .= ",optType='3'";
    121. 

  121. 					else
    122. 

  122. 						$sSQL .= ",optType='-3'";
    123. 

  123. 					if(trim(@$_POST["workingname"])=="")
    124. 

  124. 						$sSQL .= ",optGrpWorkingName='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["secname"]))) . "',";
    125. 

  125. 					else
    126. 

  126. 						$sSQL .= ",optGrpWorkingName='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["workingname"]))) . "',";
    127. 

  127. 					$sSQL .= "optFlags=" . $optFlags;
    128. 

  128. 					$sSQL .= " WHERE optGrpID=" . $iID;
    129. 

  129. 					mysql_query($sSQL) or print(mysql_error());
    130. 

  130. 					$sSQL = "UPDATE options SET optName='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["opt0"]))) . "',optPriceDiff=" . $fieldDims;
    131. 

  131. 					for($index=2; $index <= $adminlanguages+1; $index++){
    132. 

  132. 						if(($adminlangsettings & 16)==16)
    133. 

  133. 							$sSQL .= ",optName" . $index . "='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["opl" . $index . "x0"]))) . "'";
    134. 

  134. 					}
    135. 

  135. 					$sSQL .= " WHERE optGroup=" . $iID;
    136. 

  136. 					mysql_query($sSQL) or print(mysql_error());
    137. 

  137. 				}
    138. 

  138. 			}else{ // Non-text Option
    139. 

  139. 				if(@$_POST["act"]=="doaddnew"){
    140. 

  140. 					$sSQL = "INSERT INTO optiongroup (optGrpName";
    141. 

  141. 					for($index=2; $index <= $adminlanguages+1; $index++){
    142. 

  142. 						if(($adminlangsettings & 16)==16)
    143. 

  143. 							$sSQL .= ",optGrpName" . $index;
    144. 

  144. 					}
    145. 

  145. 					$sSQL .= ",optType,optGrpWorkingName,optFlags) VALUES (";
    146. 

  146. 					$sSQL .= "'" . mysql_real_escape_string(unstripslashes(trim(@$_POST["secname"]))) . "',";
    147. 

  147. 					for($index=2; $index <= $adminlanguages+1; $index++){
    148. 

  148. 						if(($adminlangsettings & 16)==16)
    149. 

  149. 							$sSQL .= "'" . mysql_real_escape_string(unstripslashes(trim(@$_POST["secname" . $index]))) . "',";
    150. 

  150. 					}
    151. 

  151. 					if(trim(@$_POST["forceselec"])=="ON")
    152. 

  152. 						$sSQL .= "'2',";
    153. 

  153. 					else
    154. 

  154. 						$sSQL .= "'-2',";
    155. 

  155. 					if(trim(@$_POST["workingname"])=="")
    156. 

  156. 						$sSQL .= "'" . mysql_real_escape_string(unstripslashes(trim(@$_POST["secname"])));
    157. 

  157. 					else
    158. 

  158. 						$sSQL .= "'" . mysql_real_escape_string(unstripslashes(trim(@$_POST["workingname"])));
    159. 

  159. 					$sSQL .= "'," . $optFlags . ")";
    160. 

  160. 					mysql_query($sSQL) or print(mysql_error());
    161. 

  161. 					$iID  = mysql_insert_id();
    162. 

  162. 				}else{
    163. 

  163. 					$iID = @$_POST["id"];
    164. 

  164. 					$sSQL = "UPDATE optiongroup SET optGrpName='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["secname"]))) . "'";
    165. 

  165. 					for($index=2; $index <= $adminlanguages+1; $index++){
    166. 

  166. 						if(($adminlangsettings & 16)==16)
    167. 

  167. 							$sSQL .= ",optGrpName" . $index . "='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["secname" . $index]))) . "'";
    168. 

  168. 					}
    169. 

  169. 					if(trim(@$_POST["forceselec"])=="ON")
    170. 

  170. 						$sSQL .= ",optType='2'";
    171. 

  171. 					else
    172. 

  172. 						$sSQL .= ",optType='-2'";
    173. 

  173. 					if(trim(@$_POST["workingname"])=="")
    174. 

  174. 						$sSQL .= ",optGrpWorkingName='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["secname"]))) . "',";
    175. 

  175. 					else
    176. 

  176. 						$sSQL .= ",optGrpWorkingName='" . mysql_real_escape_string(unstripslashes(trim(@$_POST["workingname"]))) . "',";
    177. 

  177. 					$sSQL .= "optFlags=" . $optFlags;
    178. 

  178. 					$sSQL .= " WHERE optGrpID=" . $iID;
    179. 

  179. 					mysql_query($sSQL) or print(mysql_error());
    180. 

  180. 				}
    181. 

  181. 				for($rowcounter=0; $rowcounter < maxprodopts; $rowcounter++){
    182. 

  182. 					if(trim($aOption[$rowcounter][0]) != ""){
    183. 

  183. 						if($aOption[$rowcounter][6] != ''){
    184. 

  184. 							//added by Blake 2-15-06 added to update and insert statement to include optColor, pantone, optDisplay and optStyleID
    185. 

  185. 							$sSQL = "UPDATE options SET optName='" . $aOption[$rowcounter][0] . "',optRegExp='" . $aOption[$rowcounter][5] . "',optPriceDiff=" . $aOption[$rowcounter][1] . ",optWeightDiff=" . $aOption[$rowcounter][2] . ",optColor='" . $aOption[$rowcounter][8] . "',optStyleID='" . $aOption[$rowcounter][7] ."',optPantone='" . $aOption[$rowcounter][9] . "',optDisplay='" . $aOption[$rowcounter][10] . "',optUPC='" . $aOption[$rowcounter][11] . "'";
    186. 

  186. 							if(@$wholesaleoptionpricediff==TRUE) $sSQL .= ",optWholesalePriceDiff=" . $aOption[$rowcounter][4];
    187. 

  187. 							for($index=2; $index <= $adminlanguages+1; $index++){
    188. 

  188. 								if(($adminlangsettings & 32)==32)
    189. 

  189. 									$sSQL .= ",optName" . $index . "='" . $aOption[$rowcounter][5+$index] . "'";
    190. 

  190. 							}
    191. 

  191. 							$sSQL .= " WHERE optID=" . $aOption[$rowcounter][6];
    192. 

  192. 							mysql_query($sSQL) or print(mysql_error());
    193. 

  193. 						}else{
    194. 

  194. 							$sSQL = "INSERT INTO options (optGroup,optName,optRegExp,optPriceDiff,optWeightDiff,optStock,optColor,optStyleID,optPantone,optDisplay,optUPC";
    195. 

  195. 							if(@$wholesaleoptionpricediff==TRUE) $sSQL .= ",optWholesalePriceDiff";
    196. 

  196. 							for($index=2; $index <= $adminlanguages+1; $index++){
    197. 

  197. 								if(($adminlangsettings & 32)==32) $sSQL .= ",optName" . $index;
    198. 

  198. 							}
    199. 

  199. 							$sSQL .= ") VALUES (" . $iID . ",'" . $aOption[$rowcounter][0] . "','" . $aOption[$rowcounter][5] . "'," . $aOption[$rowcounter][1] . "," . $aOption[$rowcounter][2] . "," . $aOption[$rowcounter][3] . ",'" . $aOption[$rowcounter][8] . "','" . $aOption[$rowcounter][7] . "','" . $aOption[$rowcounter][9] . "','" . $aOption[$rowcounter][10] . "','" . $aOption[$rowcounter][11] . "'";
    200. 

  200. 							if(@$wholesaleoptionpricediff==TRUE) $sSQL .= "," . $aOption[$rowcounter][4];
    201. 

  201. 							for($index=2; $index <= $adminlanguages+1; $index++){
    202. 

  202. 								if(($adminlangsettings & 32)==32) $sSQL .= ",'" . $aOption[$rowcounter][5+$index] ."'";
    203. 

  203. 							}
    204. 

  204. 							$sSQL .= ")";
    205. 

  205. 							mysql_query($sSQL) or print(mysql_error());
    206. 

  206. 						}
    207. 

  207. 					}else{
    208. 

  208. 						if($aOption[$rowcounter][6] != ''){
    209. 

  209. 							$sSQL = "DELETE FROM options WHERE optID='" . $aOption[$rowcounter][6] . "'";
    210. 

  210. 							mysql_query($sSQL) or print(mysql_error());
    211. 

  211. 						}
    212. 

  212. 					}
    213. 

  213. 				}
    214. 

  214. 			}
    215. 

  215. 		}
    216. 

  216. 		if($success)
    217. 

  217. 			print '<meta http-equiv="refresh" content="2; url=/admin/prodopts.php">';
    218. 

  218. 	}
    219. 

  219. }
    220. 

  220. ?>
    221. 

  221. <link rel="stylesheet" href="http://assets.ifrogz.com/lib/packages/jquery-ui/1.8/ui-lightness/jquery-ui.custom.css" type="text/css" media="screen" title="no title" charset="utf-8">
    222. 

  222. 

  223. <script language="JavaScript" type="text/javascript" charset="utf-8" src="http://assets.ifrogz.com/lib/packages/scriptaculous-js/1.5.1/prototype.js"></script>
    224. 

  224. <script language="JavaScript" type="text/javascript" charset="utf-8" src="http://assets.ifrogz.com/lib/packages/jquery/1.4.2/jquery.min.js"></script>
    225. 

  225. <script language="JavaScript" type="text/javascript" charset="utf-8" src="http://assets.ifrogz.com/lib/packages/jquery-ui/1.8/jquery-ui.custom.min.js"></script>
    226. 

  226. <script language="JavaScript" type="text/javascript" charset="utf-8" src="/lib/js/pages/admin/upc.js"></script>
    227. 

  227. <script language="JavaScript" type="text/javascript" charset="utf-8">
    228. 

  228. <!--
    229. 

  229. var j = jQuery.noConflict();
    230. 

  230. 

  231. j(document).ready(function() {
    232. 

  232. 	// Return a helper with preserved width of cells
    233. 

  233. 	var fixHelper = function(e, ui) {
    234. 

  234. 	    ui.children().each(function() {
    235. 

  235. 	        j(this).width(j(this).width());
    236. 

  236. 	    });
    237. 

  237. 	    return ui;
    238. 

  238. 	};
    239. 

  239. 	
    240. 

  240. 	j('#option_table tbody').sortable({
    241. 

  241. 		helper: fixHelper,
    242. 

  242. 		cursor: 'move',
    243. 

  243. 		update: function (event, ui) {
    244. 

  244. 			var options = j(this).sortable('toArray');
    245. 

  245. 			j.post('/admin/sortoptions.php', { data: options }, function(data){}, 'json');
    246. 

  246. 		}
    247. 

  247. 	}).disableSelection();
    248. 

  248. 	
    249. 

  249. 	j("#dialog-form").dialog({
    250. 

  250. 		autoOpen: false,
    251. 

  251. 		height: 300,
    252. 

  252. 		width: 350,
    253. 

  253. 		modal: true,
    254. 

  254. 		buttons: {
    255. 

  255. 			'Populate': function() {							
    256. 

  256. 				var prefix = j('#prefix').val();
    257. 

  257. 				j('input[id^="style-"]').each(function(i) {
    258. 

  258. 					var val = j(this).val();
    259. 

  259. 					if (val.length > 0) {
    260. 

  260. 						var arr = this.id.split('-');
    261. 

  261. 						j('#optRegExp-' + arr[1]).val(prefix + val);
    262. 

  262. 					}
    263. 

  263. 				});
    264. 

  264. 				
    265. 

  265. 				j(this).dialog('close');
    266. 

  266. 			},
    267. 

  267. 			Cancel: function() {
    268. 

  268. 				j(this).dialog('close');
    269. 

  269. 			}
    270. 

  270. 		},
    271. 

  271. 		close: function() {
    272. 

  272. 			
    273. 

  273. 		}
    274. 

  274. 	});
    275. 

  275. 	
    276. 

  276. 	
    277. 

  277. 	j('#formula').click(function() {
    278. 

  278. 		j('#dialog-form').dialog('open');
    279. 

  279. 	});
    280. 

  280. 	
    281. 

  281. 	j('#sweep').click(function() {
    282. 

  282. 		j('input[id^="optRegExp-"]').each(function(i) {
    283. 

  283. 			j(this).val('');
    284. 

  284. 		});
    285. 

  285. 	});
    286. 

  286. });
    287. 

  287. 

  288. function formvalidator(theForm){
    289. 

  289.   if (theForm.secname.value == "")
    290. 

  290.   {
    291. 

  291.     alert("<?php print $yyPlsEntr?> \"<?php print $yyPOName?>\".");
    292. 

  292.     theForm.secname.focus();
    293. 

  293.     return (false);
    294. 

  294.   }
    295. 

  295.   return (true);
    296. 

  296. }
    297. 

  297. function changeunits(){
    298. 

  298. 	var nopercentchar="&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
    299. 

  299. 	for(index=0;index<<?php print maxprodopts?>;index++){
    300. 

  300. 		wel = document.getElementById("wunitspan" + index);
    301. 

  301. 		pel = document.getElementById("punitspan" + index);
    302. 

  302. <?php if(@$wholesaleoptionpricediff==TRUE){ ?>
    303. 

  303. 		wspel = document.getElementById("pwspunitspan" + index);
    304. 

  304. 		if(document.forms.mainform.pricepercent.checked){
    305. 

  305. 			wspel.innerHTML='&nbsp;%&nbsp;';
    306. 

  306. 		}else{
    307. 

  307. 			wspel.innerHTML='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
    308. 

  308. 		}
    309. 

  309. <?php } ?>
    310. 

  310. 		if(document.forms.mainform.weightpercent.checked){
    311. 

  311. 			wel.innerHTML='&nbsp;%&nbsp;';
    312. 

  312. 		}else{
    313. 

  313. 			wel.innerHTML=nopercentchar;
    314. 

  314. 		}
    315. 

  315. 		if(document.forms.mainform.pricepercent.checked){
    316. 

  316. 			pel.innerHTML='&nbsp;%&nbsp;';
    317. 

  317. 		}else{
    318. 

  318. 			pel.innerHTML='&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;';
    319. 

  319. 		}
    320. 

  320. 	}
    321. 

  321. }
    322. 

  322. 

  323. //-->
    324. 

  324. </script>
    325. 

  325. <style type="text/css" media="screen">
    326. 

  326. 	#dialog-form {display: none;}
    327. 

  327. 	#dialog-form label, #dialog-form input { display:block; }
    328. 

  328. 	#dialog-form input.text { margin-bottom: 12px; width: 95%; padding: .4em; }
    329. 

  329. 	#dialog-form fieldset { padding:0; border:0; margin-top:25px; }
    330. 

  330. </style>
    331. 

  331. 	<div id="dialog-form" title="Populate Alt Prod ID">
    332. 

  332. 		<p>This will populate the "Alt Prod ID" field by concatenating the part # prefix with what's in the "Style" column.</p>
    333. 

  333. 		
    334. 

  334. 		<form>
    335. 

  335. 			<fieldset>
    336. 

  336. 				<label for="name">Part # Prefix</label>
    337. 

  337. 				<input type="text" name="prefix" id="prefix" value="product-id-" class="text ui-widget-content ui-corner-all" />
    338. 

  338. 			</fieldset>
    339. 

  339. 		</form>
    340. 

  340. 	</div>
    341. 

  341. 

  342. 

  343.       <table border="0" cellspacing="<?php print $maintablespacing?>" cellpadding="<?php print $maintablepadding?>" width="<?php print $maintablewidth?>" bgcolor="<?php print $maintablebg?>" align="center">
    344. 

  344. <?php
    345. 

  345. if(@$_POST["posted"]=="1" && (@$_POST["act"]=="modify" || @$_POST["act"]=="clone" || @$_POST["act"]=="addnew")){
    346. 

  346. 	$noptions=0;
    347. 

  347. 	$iscloning = (@$_POST["act"]=="clone");
    348. 

  348. 	if(@$_POST["act"]=="modify" || @$_POST["act"]=="clone"){
    349. 

  349. 		$doaddnew = false;
    350. 

  350. 		// added optStyleID,pantone,optDisplay and optColor to select list
    351. 

  351. 		$sSQL = "SELECT optID,optName,optName2,optName3,optGrpName,optGrpName2,optGrpName3,optGrpWorkingName,optPriceDiff,optType,optWeightDiff,optFlags,optStock,optWholesalePriceDiff,optRegExp,optColor,optStyleID,optPantone,optDisplay,optUPC FROM options LEFT JOIN optiongroup ON optiongroup.optGrpID=options.optGroup WHERE optGroup=" . @$_POST["id"] . " ORDER BY optSequence, optID";
    352. 

  352. 		$result = mysql_query($sSQL) or print(mysql_error());
    353. 

  353. 		while($rs = mysql_fetch_assoc($result)){
    354. 

  354. 			$alldata[$noptions++] = $rs;
    355. 

  355. 		}
    356. 

  356. 		$optName = $alldata[0]["optName"];
    357. 

  357. 		$optGrpName = $alldata[0]["optGrpName"];
    358. 

  358. 		for($index=2; $index <= $adminlanguages+1; $index++){
    359. 

  359. 			$optNames[$index] = $alldata[0]["optName" . $index];
    360. 

  360. 			$optGrpNames[$index] = $alldata[0]["optGrpName" . $index];
    361. 

  361. 		}
    362. 

  362. 		$optGrpWorkingName = $alldata[0]["optGrpWorkingName"];
    363. 

  363. 		$optPriceDiff = $alldata[0]["optPriceDiff"];
    364. 

  364. 		$optType = $alldata[0]["optType"];
    365. 

  365. 		$optWeightDiff = $alldata[0]["optWeightDiff"];
    366. 

  366. 		$optFlags = $alldata[0]["optFlags"];
    367. 

  367. 		$optStock = $alldata[0]["optStock"];
    368. 

  368. 		$optWholesalePriceDiff = $alldata[0]["optWholesalePriceDiff"];
    369. 

  369. 	}else{
    370. 

  370. 		$doaddnew = true;
    371. 

  371. 		$optName = "";
    372. 

  372. 		$optGrpName = "";
    373. 

  373. 		for($index=2; $index <= $adminlanguages+1; $index++){
    374. 

  374. 			$optNames[$index] = "";
    375. 

  375. 			$optGrpNames[$index] = "";
    376. 

  376. 		}
    377. 

  377. 		$optGrpWorkingName = "";
    378. 

  378. 		$optPriceDiff = 15;
    379. 

  379. 		$optType = (int)@$_POST["optType"];
    380. 

  380. 		$optWeightDiff = "";
    381. 

  381. 		$optFlags = 0;
    382. 

  382. 		$optStock = "";
    383. 

  383. 		$optWholesalePriceDiff = "";
    384. 

  384. 		$optName2 = "";
    385. 

  385. 		$optName3 = "";
    386. 

  386. 		$optGrpName2 = "";
    387. 

  387. 		$optGrpName3 = "";
    388. 

  388. 		$optUPC = "";
    389. 

  389. 	}
    390. 

  390. ?>
    391. 

  391.         <tr>
    392. 

  392. 		  <form name="mainform" method="post" action="/admin/prodopts.php" onsubmit="return formvalidator(this)">
    393. 

  393. 			<td width="100%" align="center">
    394. 

  394. 			<input type="hidden" name="posted" value="1" />
    395. 

  395. 			<?php if($iscloning || @$_POST["act"]=="addnew"){ ?>
    396. 

  396. 			<input type="hidden" name="act" value="doaddnew" />
    397. 

  397. 			<?php }else{ ?>
    398. 

  398. 			<input type="hidden" name="act" value="domodify" />
    399. 

  399. 			<input type="hidden" name="id" id="id" value="<?php print @$_POST["id"]?>" />
    400. 

  400. 			<?php } ?>
    401. 

  401. 			<input type="hidden" name="optType" value="<?php print abs($optType)?>" />
    402. 

  402.             <table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="">
    403. 

  403. <?php	if(abs((int)$optType)==3){ ?>
    404. 

  404. 			  <tr> 
    405. 

  405.                 <td width="100%" colspan="3" align="center"><strong><?php print $yyPOAdm?></strong><br />&nbsp;</td>
    406. 

  406. 			  </tr>
    407. 

  407. 			  <tr>
    408. 

  408. 				<td width="50%" align="center"><p><strong><?php print $yyPOName?></strong><br />
    409. 

  409. 				  <input type="text" name="secname" size="30" value="<?php print str_replace('"',"&quot;",$optGrpName)?>" /><br /><?php
    410. 

  410. 				for($index=2; $index <= $adminlanguages+1; $index++){
    411. 

  411. 					if(($adminlangsettings & 16)==16){
    412. 

  412. 						?><strong><?php print $yyPOName . " " . $index?></strong><br />
    413. 

  413. 						<input type="text" name="secname<?php print $index?>" size="30" value="<?php print str_replace('"',"&quot;",$optGrpNames[$index])?>" /><br /><?php
    414. 

  414. 					}
    415. 

  415. 				} ?></p>
    416. 

  416. 				  <p><strong><?php print $yyWrkNam?></strong><br />
    417. 

  417. 				  <input type="text" name="workingname" size="30" value="<?php print str_replace('"',"&quot;",$optGrpWorkingName)?>" /></p>
    418. 

  418.                 </td>
    419. 

  419. 				<td width="30%" align="center"><p><strong><?php print $yyDefTxt?></strong><br />
    420. 

  420. 				<input type="text" name="opt0" size="25" value="<?php print str_replace('"',"&quot;",$optName)?>" /><br /><?php
    421. 

  421. 				for($index=2; $index <= $adminlanguages+1; $index++){
    422. 

  422. 					if(($adminlangsettings & 16)==16){
    423. 

  423. 						?><strong><?php print $yyDefTxt . " " . $index?></strong><br />
    424. 

  424. 						<input type="text" name="opl<?php print $index?>x0" size="25" value="<?php print str_replace('"',"&quot;",$optNames[$index])?>" /><br /><?php
    425. 

  425. 					}
    426. 

  426. 				} ?></p>
    427. 

  427. 				<p>&nbsp;<br /><input type="checkbox" name="forceselec" value="ON" <?php if($optType>0) print "checked"?> /> <strong><?php print $yyForSel?></strong></p>
    428. 

  428.                 </td>
    429. 

  429. 				<td width="20%" align="center"><p><strong><?php print $yyFldWdt?></strong><br />
    430. 

  430. 				<select name="pri0" size="1">
    431. 

  431. 				<?php
    432. 

  432. 					for($rowcounter=1; $rowcounter <= 35; $rowcounter++){
    433. 

  433. 						print "<option value='" . $rowcounter . "'";
    434. 

  434. 						if($rowcounter==(int)$optPriceDiff) print " selected";
    435. 

  435. 						print ">&nbsp; " . $rowcounter . " </option>\n";
    436. 

  436. 					}
    437. 

  437. 				?>
    438. 

  438. 				</select></p>
    439. 

  439. 				<p><strong><?php print $yyFldHgt?></strong><br />
    440. 

  440. 				<select name="fieldheight" size="1">
    441. 

  441. 				<?php
    442. 

  442. 					$fieldHeight = round(((double)($optPriceDiff)-floor($optPriceDiff))*100.0);
    443. 

  443. 					for($rowcounter=1; $rowcounter <= 15; $rowcounter++){
    444. 

  444. 						print "<option value='" . $rowcounter . "'";
    445. 

  445. 						if($rowcounter==$fieldHeight) print " selected";
    446. 

  446. 						print ">&nbsp; " . $rowcounter . " </option>\n";
    447. 

  447. 					}
    448. 

  448. 				?>
    449. 

  449. 				</select></p>
    450. 

  450. 				</td>
    451. 

  451. 			  </tr>
    452. 

  452. 			  <tr>
    453. 

  453. 				<td colspan="3" align="left">
    454. 

  454. 				  <ul>
    455. 

  455. 				  <li><font size="1"><?php print $yyPOEx1?></li>
    456. 

  456. 				  <li><font size="1"><?php print $yyPOEx2?></li>
    457. 

  457. 				  <li><font size="1"><?php print $yyPOEx3?></li>
    458. 

  458. 				  </ul>
    459. 

  459.                 </td>
    460. 

  460. 			  </tr>
    461. 

  461. <?php	}else{ ?>
    462. 

  462. 			  <tr>
    463. 

  463. 				<td width="30%" align="center"><p><strong><?php print $yyPOName?></strong><br />
    464. 

  464. 				  <input type="text" name="secname" size="30" value="<?php print str_replace('"',"&quot;",$optGrpName)?>" /><br /><?php
    465. 

  465. 				for($index=2; $index <= $adminlanguages+1; $index++){
    466. 

  466. 					if(($adminlangsettings & 16)==16){
    467. 

  467. 						?><strong><?php print $yyPOName . " " . $index?></strong><br />
    468. 

  468. 						<input type="text" name="secname<?php print $index?>" size="30" value="<?php print str_replace('"',"&quot;",$optGrpNames[$index])?>" /><br /><?php
    469. 

  469. 					}
    470. 

  470. 				} ?></p>
    471. 

  471. 				  <p><strong><?php print $yyWrkNam?></strong><br />
    472. 

  472. 				  <input type="text" name="workingname" size="30" value="<?php print str_replace('"',"&quot;",$optGrpWorkingName)?>" /></p>
    473. 

  473. 				  <p><input type="checkbox" name="forceselec" value="ON" <?php if($optType>0) print "checked"?> /> <strong><?php print $yyForSel?></strong></p>
    474. 

  474.                 </td>
    475. 

  475. 				<td colspan="2" align="left">
    476. 

  476. 				  <p align="center"><strong><?php print $yyPOAdm?></strong></p>
    477. 

  477. 				  <ul>
    478. 

  478. 				  <li><font size="1"><?php print $yyPOEx1?></font></li>
    479. 

  479. 				  <li><font size="1"><?php print $yyPOEx4?></font></li>
    480. 

  480. 				  <li><font size="1"><?php print $yyPOEx5?></font></li>
    481. 

  481. 				  <!-- added by Blake on 2-15-06 -->
    482. 

  482. 				  <li><font size="1">Use color only for options that need to pass the flash movie a hex color code.</font></li>
    483. 

  483. 				  <li><font size="1">Style is the two digit number added on the product id to distiquish the option.</font></li>
    484. 

  484. 				  <!-- end -->
    485. 

  485. 				  <?php if($useStockManagement){ ?>
    486. 

  486. 				  <li><font size="1"><?php print $yyPOEx6?></font></li>
    487. 

  487. 				  <?php } ?>
    488. 

  488. 				  <ul>
    489. 

  489.                 </td>
    490. 

  490. 			  </tr>
    491. 

  491. 			</table>
    492. 

  492. 			<table width="500" border="0" cellspacing="0" cellpadding="3" bgcolor="" id="option_table">
    493. 

  493. 				<thead>
    494. 

  494. 					<tr>
    495. 

  495. 						<td>&nbsp;</td>
    496. 

  496. 						<td align="center"><strong>optID</strong></td>
    497. 

  497. 						<td align="center"><strong>Display</strong></td>
    498. 

  498. 						<td align="center"><strong><?php print $yyPOOpts?></strong></td>
    499. 

  499. 						<td width="5" align="center">&nbsp;</td>
    500. 

  500. 						<td align="center"><strong>UPC</strong></td>
    501. 

  501. 						<td align="center">&nbsp;</td>
    502. 

  502. 						<!-- added by Blake on 2-15-06 -->
    503. 

  503. 						<td align="center"><strong>Pantone</strong></td>
    504. 

  504. 						<td width="5" align="center">&nbsp;</td>
    505. 

  505. 						<td align="center"><strong>Colors</strong></td>
    506. 

  506. 						<td width="5" align="center">&nbsp;</td>
    507. 

  507. 						<td align="center"><strong>Style</strong></td>
    508. 

  508. 						<td width="5" align="center">&nbsp;</td>
    509. 

  509. 						<!-- end -->
    510. 

  510. 					<?php
    511. 

  511. 					for($index=2; $index <= $adminlanguages+1; $index++) {
    512. 

  512. 						if(($adminlangsettings & 32)==32){
    513. 

  513. 							?><td align="center"><strong><?php print $yyPOOpts . " " . $index?></strong></td>
    514. 

  514. 							<td width="5" align="center">&nbsp;</td><?php
    515. 

  515. 						}
    516. 

  516. 						} ?>
    517. 

  517. 						<td align="center" nowrap><strong><?php print $yyPOPrDf?>&nbsp;%<input class="noborder" type="checkbox" name="pricepercent" value="1" onclick="javascript:changeunits();" <?php if(($optFlags & 1) == 1) print "checked"?> /></strong></td>
    518. 

  518. 						<td width="5" align="center">&nbsp;</td>
    519. 

  519. 						<?php if(@$wholesaleoptionpricediff==TRUE){ ?>
    520. 

  520. 							<td align="center" nowrap><strong><?php print $yyWhoPri?></strong></td>
    521. 

  521. 							<td width="5" align="center">&nbsp;</td>
    522. 

  522. 							<?php } ?>
    523. 

  523. 							<td align="center" nowrap><strong><?php print $yyPOWtDf?>&nbsp;%<input class="noborder" type="checkbox" name="weightpercent" value="1" onclick="javascript:changeunits();" <?php if(($optFlags & 2) == 2) print "checked"?> /></strong></td>
    524. 

  524. 							<?php if($useStockManagement){ ?>
    525. 

  525. 								<td width="5" align="center">&nbsp;</td>
    526. 

  526. 								<td align="center" nowrap><strong><?php print $yyStkLvl?></strong></td>
    527. 

  527. 								<?php } ?>
    528. 

  528. 								<td width="5" align="center">&nbsp;</td>
    529. 

  529. 								<td align="center" nowrap><div style="position: relative;"><strong>Alt Prod ID</strong><img id="formula" src="/lib/images/misc/formula.png" style="position: absolute; left: 13px; top: -20px; cursor: pointer;" /><img id="sweep" src="/lib/images/misc/sweep.png" style="position: absolute; top: -16px; right: 13px; cursor: pointer;"></div></td>
    530. 

  530. 					</tr>
    531. 

  531. 				</thead>
    532. 

  532. 				<tbody>
    533. 

  533. <?php		if(($optFlags & 1) == 1) $pdUnits="&nbsp;%&nbsp;"; else $pdUnits="&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
    534. 

  534. 			if(($optFlags & 2) == 2) $wdUnits="&nbsp;%&nbsp;"; else $wdUnits="&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;";
    535. 

  535. 			for($rowcounter=0, $tab_names = 1, $tab_styles = 1000; $rowcounter < maxprodopts; $rowcounter++, $tab_names++, $tab_styles++) { ?>
    536. 

  536. 			
    537. 

  537. 			  <tr id="<?php echo (!empty($alldata[$rowcounter]['optID'])) ? $alldata[$rowcounter]['optID'] : '' ?>">
    538. 

  538. 			    <td align="center" valign="center"><img src="/lib/images/sort_icon.gif" style="cursor: move;" /></td>
    539. 

  539. 				<td align="center"><?php if (!empty($alldata[$rowcounter]['optID'])) {print $alldata[$rowcounter]['optID'];} ?></td>
    540. 

  540.                 <td align="center"><?php					
    541. 

  541. 					print '<input name="display' . $rowcounter . '" type="checkbox" value="yes" ';
    542. 

  542. 					if($rowcounter < $noptions && $alldata[$rowcounter]["optDisplay"]=='yes') print 'checked';
    543. 

  543. 					print  "/><br />\n";
    544. 

  544. 				?></td>
    545. 

  545. 				<td align="center"><?php
    546. 

  546. 					if($rowcounter < $noptions && ! $iscloning) print '<input type="hidden" name="orig' . $rowcounter . '" value="' . $alldata[$rowcounter]['optID'] . '">';
    547. 

  547. 					print '<input type="text" name="opt' . $rowcounter . '" size="20" tabindex="' . $tab_names . '" value="';
    548. 

  548. 					if($rowcounter < $noptions) print str_replace('"', '&quot;',$alldata[$rowcounter]["optName"]);
    549. 

  549. 					print "\" /><br />\n";
    550. 

  550. 				?></td>
    551. 

  551. 				<!-- added by Blake 2-15-06 -->
    552. 

  552. 				<td align="center"><strong>&raquo;</strong></td>
    553. 

  553. 				<td align="center" id="errUPC<?=$rowcounter?>"><?php
    554. 

  554. 					if(is_array($alldata) && is_array($alldata[$rowcounter]) &&is_array($alldata[$rowcounter]['optUPC']) && isset($alldata[$rowcounter]['optUPC'])) $optUPC=$alldata[$rowcounter]['optUPC'];
    555. 

  555. 					print '<input type="text" id="optUPC' . $rowcounter . '" name="optUPC' . $rowcounter . '" size="12" value="'.$optUPC.'" onchange="checkUPC(\'optUPC'.$rowcounter.'\')"';
    556. 

  556. 					if($_POST["act"]=="clone") $alldata[$rowcounter]["optUPC"]="";
    557. 

  557. 					if($rowcounter < $noptions) print str_replace('"', '&quot;',$optUPC);
    558. 

  558. 					print "\" /><br />\n";
    559. 

  559. 				?></td>
    560. 

  560. 				<td align="center"><strong>&raquo;</strong></td>
    561. 

  561. 				<td align="center"><?php
    562. 

  562. 					print '<input type="text" name="pantonecolor' . $rowcounter . '" size="5" value="';
    563. 

  563. 					if($rowcounter < $noptions) print str_replace('"', '&quot;',$alldata[$rowcounter]["optPantone"]);
    564. 

  564. 					print "\" /><br />\n";
    565. 

  565. 				?></td>
    566. 

  566. 				<td align="center"><strong>&raquo;</strong></td>
    567. 

  567. 				<td align="center"><?php
    568. 

  568. 					print '<input type="text" name="color' . $rowcounter . '" size="10" value="';
    569. 

  569. 					if($rowcounter < $noptions) print str_replace('"', '&quot;',$alldata[$rowcounter]["optColor"]);
    570. 

  570. 					print "\" /><br />\n";
    571. 

  571. 				?></td>
    572. 

  572. 				<td align="center"><strong>&raquo;</strong></td>
    573. 

  573. 				<td align="center"><?php
    574. 

  574. 					print '<input type="text" id="style-' . $rowcounter . '" name="style' . $rowcounter . '" size="5" tabindex="' . $tab_styles . '" value="';
    575. 

  575. 					if($rowcounter < $noptions) print str_replace('"', '&quot;',$alldata[$rowcounter]["optStyleID"]);
    576. 

  576. 					print "\" /><br />\n";
    577. 

  577. 				?></td>
    578. 

  578. 				<!-- end -->
    579. 

  579. 				<td align="center"><strong>&raquo;</strong></td>
    580. 

  580. <?php			for($index=2; $index <= $adminlanguages+1; $index++){
    581. 

  581. 					if(($adminlangsettings & 32)==32){
    582. 

  582. 						?><td align="center"><?php
    583. 

  583. 					print '<input type="text" name="opl' . $index . 'x' . $rowcounter. '" size="20" value="';
    584. 

  584. 					if($rowcounter < $noptions) print str_replace('"', '&quot;',$alldata[$rowcounter]["optName" . $index]);
    585. 

  585. 					print '" /><br />' . "\r\n";
    586. 

  586. 				?></td>
    587. 

  587. 				<td align="center"><strong>&raquo;</strong></td><?php
    588. 

  588. 					}
    589. 

  589. 				} ?>
    590. 

  590. 				<td align="center"><?php
    591. 

  591. 					print "&nbsp;&nbsp;&nbsp;&nbsp;<input type='text' name='pri" . $rowcounter . "' size='5' value='";
    592. 

  592. 					if($rowcounter < $noptions) print (double)$alldata[$rowcounter]["optPriceDiff"];
    593. 

  593. 					print "' /><span name='punitspan" . $rowcounter . "' id='punitspan" . $rowcounter . "'>" . $pdUnits . "</span><br />\n";
    594. 

  594. 				?></td>
    595. 

  595. 				<td align="center"><strong>&raquo;</strong></td>
    596. 

  596. 				<?php if(@$wholesaleoptionpricediff==TRUE){?>
    597. 

  597. 				<td align="center"><?php
    598. 

  598. 					print "&nbsp;&nbsp;&nbsp;&nbsp;<input type='text' name='wsp" . $rowcounter . "' size='5' value='";
    599. 

  599. 					if($rowcounter < $noptions) print (double)$alldata[$rowcounter]["optWholesalePriceDiff"];
    600. 

  600. 					print "' /><span name='pwspunitspan" . $rowcounter . "' id='pwspunitspan" . $rowcounter . "'>" . $pdUnits . "</span><br />\n";
    601. 

  601. 				?></td>
    602. 

  602. 				<td align="center"><strong>&raquo;</strong></td>
    603. 

  603. 				<?php } ?>
    604. 

  604. 				<td align="center" nowrap><?php
    605. 

  605. 					print "&nbsp;&nbsp;&nbsp;&nbsp;<input type='text' name='wei" . $rowcounter . "' size='5' value='";
    606. 

  606. 					if($rowcounter < $noptions) print $alldata[$rowcounter]["optWeightDiff"];
    607. 

  607. 					print "' /><span name='wunitspan" . $rowcounter . "' id='wunitspan" . $rowcounter . "'>" . $wdUnits . "</span><br />\n";
    608. 

  608. 				?></td>
    609. 

  609. 				<?php	if ($useStockManagement) { ?>
    610. 

  610. 				<td align="center"><strong>&raquo;</strong></td>
    611. 

  611. 				<td align="center"><input <?php (($_POST['act']=='modify') ? 'disabled="disabled"' : '') ?> type="text" name="optStock<?php echo $rowcounter?>" size="4" value="<?php if($rowcounter < $noptions) print $alldata[$rowcounter]['optStock']?>" /></td>
    612. 

  612. 				<?php	}else{
    613. 

  613. 							if($rowcounter < $noptions){ ?>
    614. 

  614. 								<input type="hidden" name="optStock<?php print $rowcounter?>" value="<?php print $alldata[$rowcounter]["optStock"]?>" />
    615. 

  615. 				<?php		}
    616. 

  616. 						} ?>
    617. 

  617. 				<td align="center"><strong>&raquo;</strong></td>
    618. 

  618. 				<td align="center"><input type="text" id="optRegExp-<?=$rowcounter?>" name="regexp<?php print $rowcounter?>" size="12" value="<?php if($rowcounter < $noptions) print $alldata[$rowcounter]["optRegExp"]?>" /></td>
    619. 

  619. 			  </tr>
    620. 

  620. 			
    621. 

  621. <?php		} ?>
    622. 

  622. 			</tbody>
    623. 

  623. 			</table>
    624. 

  624. 			<table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="">
    625. 

  625. <?php	} ?>
    626. 

  626. 			  <tr>
    627. 

  627.                 <td width="100%" colspan="3" align="center"><br /><input type="submit" value="<?php print $yySubmit?>" /><br />&nbsp;</td>
    628. 

  628. 			  </tr>
    629. 

  629. 			  <tr> 
    630. 

  630.                 <td width="100%" colspan="3" align="center"><br />
    631. 

  631.                           <a href="/admin/index.php"><strong><?php print $yyAdmHom?></strong></a><br />
    632. 

  632.                           &nbsp;</td>
    633. 

  633. 			  </tr>
    634. 

  634.             </table></td>
    635. 

  635. 		  </form>
    636. 

  636.         </tr>
    637. 

  637. <?php
    638. 

  638. }elseif(@$_POST["posted"]=="1" && $success){ ?>
    639. 

  639.         <tr>
    640. 

  640.           <td width="100%">
    641. 

  641. 			<table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="">
    642. 

  642. 			  <tr> 
    643. 

  643.                 <td width="100%" colspan="2" align="center"><br /><strong><?php print $yyUpdSuc?></strong><br /><br /><?php print $yyNowFrd?><br /><br />
    644. 

  644.                         <?php print $yyNoAuto?> <a href="/admin/prodopts.php"><strong><?php print $yyClkHer?></strong></a>.<br />
    645. 

  645.                         <br />
    646. 

  646. 				<img src="/lib/images/misc/clearpixel.gif" width="300" height="3" alt="" />
    647. 

  647.                 </td>
    648. 

  648. 			  </tr>
    649. 

  649. 			</table></td>
    650. 

  650.         </tr>
    651. 

  651. <?php
    652. 

  652. }elseif(@$_POST["posted"]=="1"){ ?>
    653. 

  653.         <tr>
    654. 

  654.           <td width="100%">
    655. 

  655. 			<table width="100%" border="0" cellspacing="0" cellpadding="3" bgcolor="">
    656. 

  656. 			  <tr> 
    657. 

  657.                 <td width="100%" colspan="2" align="center"><br /><font color="#FF0000"><strong><?php print $yyOpFai?></strong></font><br /><br /><?php print $errmsg?><br /><br />
    658. 

  658. 				<a href="javascript:history.go(-1)"><strong><?php print $yyClkBac?></strong></a>					
    659. 

  659. 				</td>
    660. 

  660. 			  </tr>
    661. 

  661. 			</table></td>
    662. 

  662.         </tr>
    663. 

  663. <?php
    664. 

  664. }else{
    665. 

  665. ?>
    666. 

  666. <script language="JavaScript" type="text/javascript">
    667. 

  667. <!--
    668. 

  668. function modrec(id) {
    669. 

  669. 	document.mainform.id.value = id;
    670. 

  670. 	document.mainform.act.value = "modify";
    671. 

  671. 	document.mainform.submit();
    672. 

  672. }
    673. 

  673. function clone(id) {
    674. 

  674. 	document.mainform.id.value = id;
    675. 

  675. 	document.mainform.act.value = "clone";
    676. 

  676. 	document.mainform.submit();
    677. 

  677. }
    678. 

  678. function newtextrec(id) {
    679. 

  679. 	document.mainform.id.value = id;
    680. 

  680. 	document.mainform.act.value = "addnew";
    681. 

  681. 	document.mainform.optType.value = "3";
    682. 

  682. 	document.mainform.submit();
    683. 

  683. }
    684. 

  684. function newrec(id) {
    685. 

  685. 	document.mainform.id.value = id;
    686. 

  686. 	document.mainform.act.value = "addnew";
    687. 

  687. 	document.mainform.optType.value = "2";
    688. 

  688. 	document.mainform.submit();
    689. 

  689. }
    690. 

  690. function delrec(id) {
    691. 

  691. cmsg = "<?php print $yyConDel?>\n"
    692. 

  692. if (confirm(cmsg)) {
    693. 

  693. 	document.mainform.id.value = id;
    694. 

  694. 	document.mainform.act.value = "delete";
    695. 

  695. 	document.mainform.submit();
    696. 

  696. }
    697. 

  697. }
    698. 

  698. // -->
    699. 

  699. </script>
    700. 

  700. <style type="text/css">
    701. 

  701. <!--
    702. 

  702. tr.optRow:hover {background-color: #FFC; color: 000;}
    703. 

  703. -->
    704. 

  704. </style>
    705. 

  705.         <tr>
    706. 

  706. 		<form name="mainform" method="post" action="/admin/prodopts.php">
    707. 

  707. 		  <td width="100%">
    708. 

  708. 			<input type="hidden" name="posted" value="1" />
    709. 

  709. 			<input type="hidden" name="act" value="xxxxx" />
    710. 

  710. 			<input type="hidden" name="id" value="xxxxx" />
    711. 

  711. 			<input type="hidden" name="optType" value="xxxxx" />
    712. 

  712.             <table width="100%" border="0" cellspacing="0" cellpadding="1" bgcolor="">
    713. 

  713. 			  <tr> 
    714. 

  714.                 <td width="100%" colspan="6" align="center"><strong><?php print $yyPOAdm?></strong><br />&nbsp;</td>
    715. 

  715. 			  </tr>
    716. 

  716. 			  <tr>
    717. 

  717. 			  	<td width="100%" colspan="6" align="center">
    718. 

  718. 					<input type="button" value="<?php print $yyPONew?>" onclick="newrec()" />&nbsp;<strong><?php print $yyOr?></strong>&nbsp;<input type="button" value="<?php print $yyPONewT?>" onclick="newtextrec()" /><br /><br />
    719. 

  719. 				</td>
    720. 

  720. 			  </tr>
    721. 

  721. 			  <tr>
    722. 

  722. 				<td width="6%"><strong>ID</strong></td>
    723. 

  723. 				<td width="16%"><strong><?php print $yyPOName?></strong></td>
    724. 

  724. 				<td width="50%"><strong><?php print $yyWrkNam?></strong></td>
    725. 

  725. 				<td width="6%" align="center"><strong><?php print $yyClone?></strong></td>
    726. 

  726. 				<td width="6%" align="center"><strong><?php print $yyModify?></strong></td>
    727. 

  727. 				<td width="6%" align="center"><strong><?php print $yyDelete?></strong></td>
    728. 

  728. 			  </tr>
    729. 

  729. <?php
    730. 

  730. 	$sSQL = "SELECT optGrpID,optGrpName,optGrpWorkingName FROM optiongroup ORDER BY optGrpWorkingName, optGrpName";
    731. 

  731. 	$result = mysql_query($sSQL) or print(mysql_error());
    732. 

  732. 	if(mysql_num_rows($result) > 0){
    733. 

  733. 		$bgcolor="";
    734. 

  734. 		while($rs = mysql_fetch_assoc($result)){
    735. 

  735. 			if($bgcolor=="#E7EAEF") $bgcolor="#FFFFFF"; else $bgcolor="#E7EAEF"; ?>
    736. 

  736. 			  <tr class="optRow" bgcolor="<?php print $bgcolor?>">
    737. 

  737. 				<td><?php print $rs['optGrpID']; ?></td>
    738. 

  738. 				<td><?php print $rs["optGrpName"]?></td>
    739. 

  739. 				<td><?php print $rs["optGrpWorkingName"]?></td>
    740. 

  740. 				<td align="center"><input type=button value="<?php print $yyClone?>" onclick="clone('<?php print $rs["optGrpID"]?>')" /></td>
    741. 

  741. 				<td align="center"><input type=button value="<?php print $yyModify?>" onclick="modrec('<?php print $rs["optGrpID"]?>')" /></td>
    742. 

  742. 				<td align="center"><input type=button value="<?php print $yyDelete?>" onclick="delrec('<?php print $rs["optGrpID"]?>')" /></td>
    743. 

  743. 			  </tr>
    744. 

  744. <?php	}
    745. 

  745. 	}else{
    746. 

  746. ?>
    747. 

  747. 			  <tr>
    748. 

  748.                 <td width="100%" colspan="6" align="center"><br /><?php print $yyPONon?><br />&nbsp;</td>
    749. 

  749. 			  </tr>
    750. 

  750. <?php
    751. 

  751. 	}
    752. 

  752. ?>
    753. 

  753. 			  <tr>
    754. 

  754.                 <td width="100%" colspan="6" align="center"><br /><strong><?php print $yyPOClk?> </strong>&nbsp;&nbsp;<input type="button" value="<?php print $yyPONew?>" onclick="newrec()" />&nbsp;<strong><?php print $yyOr?></strong>&nbsp;<input type="button" value="<?php print $yyPONewT?>" onclick="newtextrec()" /><br />&nbsp;</td>
    755. 

  755. 			  </tr>
    756. 

  756. <?php
    757. 

  757. 	if($useStockManagement){
    758. 

  758. 		$sSQL = "SELECT DISTINCT optGrpID,optGrpName,optGrpWorkingName FROM optiongroup INNER JOIN options ON optiongroup.optGrpID=options.optGroup INNER JOIN prodoptions ON options.optGroup=prodoptions.poOptionGroup INNER JOIN products ON prodoptions.poProdID=products.pID WHERE options.optStock<=0 AND products.pSell>1 AND (optType=2 OR optType=-2) ORDER BY optGrpWorkingName, optGrpName";
    759. 

  759. 		$result = mysql_query($sSQL) or print(mysql_error());
    760. 

  760. 		if(mysql_num_rows($result)>0) print '<tr><td colspan="5" align="center"><strong>The following options contain at least 1 item that is out of stock</strong></td></tr>';
    761. 

  761. 		while($rs = mysql_fetch_array($result)){
    762. 

  762. 			if($bgcolor=="#E7EAEF") $bgcolor="#FFFFFF"; else $bgcolor="#E7EAEF"; ?>
    763. 

  763. 			  <tr bgcolor="<?php print $bgcolor?>">
    764. 

  764. 				<td><?php print $rs['optGrpID']; ?></td>
    765. 

  765. 				<td><?php print $rs["optGrpName"]?></td>
    766. 

  766. 				<td><?php print $rs["optGrpWorkingName"]?></td>
    767. 

  767. 				<td align="center">&nbsp;</td>
    768. 

  768. 				<td align="center"><input type=button value="<?php print $yyModify?>" onclick="modrec('<?php print $rs["optGrpID"]?>')" /></td>
    769. 

  769. 				<td align="center"><input type=button value="<?php print $yyDelete?>" onclick="delrec('<?php print $rs["optGrpID"]?>')" /></td>
    770. 

  770. 			  </tr><?php
    771. 

  771. 		}
    772. 

  772. 		mysql_free_result($result);
    773. 

  773. 	} ?>
    774. 

  774. 			  <tr>
    775. 

  775.                 <td width="100%" colspan="6" align="center"><br />
    776. 

  776.                           <a href="/admin/index.php"><strong><?php print $yyAdmHom?></strong></a><br />
    777. 

  777. 				<img src="/lib/images/misc/clearpixel.gif" width="300" height="3" alt="" /></td>
    778. 

  778. 			  </tr>
    779. 

  779.             </table></td>
    780. 

  780. 		  </form>
    781. 

  781.         </tr>
    782. 

  782. <?php
    783. 

  783. }
    784. 

  784. ?>
    785. 

  785.       </table>
    786.