<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<!--jscript-->
<script language="JavaScript">
   function submitForm(){
              document.form1.mySubmit.click();
    }
</script>
<script language="JavaScript" src="../jscript/gen_validatorv4_2.js"  type="text/javascript" xml:space="preserve"></script>
<script language="javascript" src="../jscript/chainedselects.js"></script>
<script language="javascript"  src="../jscript/chainedselectconfig_receive.js"></script>
<script language="JavaScript" src="../jscript/go_to_url.js"  type="text/javascript"></script>
<script language="JavaScript" src="../jscript/numbers_only.js"  type="text/javascript"></script>

<?php

//include('../include/db.php');
include('../include/session.php');	



;
$category=$_GET['category'];
$sub_category=$_GET['sub_category'];

$table_name = $_SESSION['db_prefix']."_store_items";
if ($sub_category=='Mitek') {
$dropDownQuery = "SELECT store_item_id, item_name, unit FROM $table_name WHERE category= '".$category."' AND subCategory = '".$sub_category."' AND class <> 'plate' ORDER BY item_name ASC";}
else {
$dropDownQuery = "SELECT store_item_id, item_name, unit FROM $table_name WHERE category= '".$category."' AND subCategory = '".$sub_category."' ORDER BY item_name ASC";}	

$dropDownResult = execsql($dropDownQuery);
	$num = mysql_num_rows($dropDownResult);
	$a = 0;
	$arrId = array ();
	$arrName = array ();
	while ($a < $num) {
		$arrId[$a] = mysql_result($dropDownResult, $a, "store_item_id");
		$arrName[$a] = mysql_result($dropDownResult, $a, "item_name");
		$arrUnit[$a] = mysql_result($dropDownResult, $a, "unit");
		
		$a++;
	}

?>
<style>
select.store_item_select {
	width: 230px;
}
select.store_item_select option {
	width: 220px;
}
label.label_std {
	margin-left: 5px;
	line-height: 20px;
	padding-top: 6px;
	color: #000;
	text-shadow: 1px 1px 1px #fff;
	font: bold 12px Arial;
}
input.imagebutton {
	background-color: #E1E1E1;
	width: 100px;
	height: 24px;
	border: solid;
	border-width: 1px;
	border-color: #FB6808;
	cursor: pointer;
	color: #000000;
	font: bold 12px Arial;
	-moz-border-radius: 5px;
	-webkit-border-radius: 5px;
	border-radius: 5px;
	-moz-box-shadow: 0px 0px 0px #CCC;
	-webkit-box-shadow: 0px 0px 0px #CCC;
	box-shadow: 0px 0px 0px #CCC;
}
</style>
<style >
input.imagebutton {
	background-color: #E1E1E1;
	width: 100px;
	height: 24px;
	border: solid;
	border-width: 1px;
	border-color: #FB6808;
	cursor: pointer;
	color: #000000;
	font: bold 12px Arial;
	-moz-border-radius: 5px;
	-webkit-border-radius: 5px;
	border-radius: 5px;
	-moz-box-shadow: 0px 0px 0px #CCC;
	-webkit-box-shadow: 0px 0px 0px #CCC;
	box-shadow: 0px 0px 0px #CCC;
}
input.imagebutton:hover {
	background-color: #E4E4E4;
	width: 100px;
	height: 24px;
	border: solid;
	border-width: 2px;
	border-color: #FB6808;
	cursor: pointer;
	color: #000000;
	font: bold 12px Arial;
	-moz-border-radius: 5px;
	-webkit-border-radius: 5px;
	border-radius: 5px;
	-moz-box-shadow: 5px 5px 5px #666;
	-webkit-box-shadow: 5px 5px 5px #666;
	box-shadow: 5px 5px 5px #666;
}
</style>

</head>
<body>
<form action="../production/authorisationWizbase.php" method="get" name="form2" target="_top" id="form2">
  <table width="450" border="0" align="left" cellpadding="0" cellspacing="0" class="list2" id="select_table">
    <tr>
      <td height="38" align="center"><span class="wizard_frame">
        <label class="label_std"><?php echo $category." --- ".$sub_category?></label>
        <br />
        <select  name="store_item_select" class="store_item_select" id="store_item_select" style="width:250px;" autofocus   onchange="document.getElementById('unit_text').value = (document.getElementById('store_item_select').options[document.getElementById('store_item_select').selectedIndex].text).slice(-5)
        document.getElementById('unit_text2').value = (document.getElementById('store_item_select').options[document.getElementById('store_item_select').selectedIndex].text).slice(-5) ">
          <option value=" " selected="selected"> </option>
          <?php
    	for ($i = 0; $i < count($arrId); $i++) {
		echo "<option value=" . "\"" . $arrId[$i] . "\"" . ">" . $arrName[$i] ."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;"."&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;". $arrUnit[$i]." </option>";
		$_SESSION['productName'] = $arrName[$i];
		
	    }
     ?>
        </select>
        <br />
        <br />
        </td>
    </tr>
    <tr>
      <td align="center"><label class="label_std">Quantity:&nbsp;
          <input name="quantity_text" type="text" id="quantity_text" size="10" onkeypress="return numbersonly(this, event)" autocomplete="off"/>
          &nbsp;&nbsp;
          <input name="unit_text" type="text" id="unit_text" size="4"  style="border:hidden; text-align:left; font-weight:600;"/>
        </label></td>
    </tr>
    <tr>
      <td align="center"><br />
        <input name="next_add_button" type="submit" id='next_add_button' value="Next" class="imagebutton"  />
        <input name="finish_add_button" type="submit" id='finish_add_button' value="Finish" class="imagebutton"  />
        <input name="button" type="button" id="button" class="imagebutton" onclick="MM_goToURL('parent','../production/authorisationWizbase.php?p=<?php  echo $_SESSION['p']?>&s=&screen=0');return document.MM_returnValue; needToConfirm = false;" value="Cancel" />
        <input type="hidden" name="p" id="p" value="<?php  echo $_SESSION['p']?> " />
        <?php if ($sub_category=='Mitek') { ?>
        <input type="hidden" name="s" id="s" value="10" />
        <?php } ?>
        <?php if ($sub_category=='Sundries') { ?>
        <input type="hidden" name="s" id="s" value="13" />
        <?php } ?>
        <input type="hidden" name="screen" id="screen" value="0" /></td>
    </tr>
  </table>
</form>
<script language="JavaScript" type="text/javascript" xml:space="preserve">
  var frmvalidator  = new Validator("form2");
  frmvalidator.EnableMsgsTogether();
  frmvalidator.addValidation("store_item_select","req","Please select item.");
  frmvalidator.addValidation("quantity_text","req","Please enter quantity.");
</script>
</body>
</html>