<!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" />

<script language="JavaScript">
    <!--
    function submitForm(){
              document.form1.mySubmit.click();
    }
    -->
    </script>
  
<script language="JavaScript" src="../jscript/gen_validatorv4.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>



<?php

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


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

$table_name = $_SESSION['db_prefix']."_store_items";
$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++;
	}

//$store_item_id = $_GET['store_item_id'];
//$table_name = $_SESSION['db_prefix']."_store_items";
//$categoryQuery = "SELECT category, subCategory FROM $table_name WHERE store_item_id ='". $store_item_id. "' ";
//$categoryResult = execsql($categoryQuery);
//$category = mysql_result($categoryResult, 0, "category");
//$sub_category = mysql_result($categoryResult, 0, "subCategory");
	

?>

<style>
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;
	
}

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>



<script type="text/javascript">
function MM_goToURL() { //v3.0
  var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
  for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}
function MM_callJS(jsStr) { //v2.0
  return eval(jsStr)
}
function MM_showHideLayers() { //v9.0
  var i,p,v,obj,args=MM_showHideLayers.arguments;
  for (i=0; i<(args.length-2); i+=3) 
  with (document) if (getElementById && ((obj=getElementById(args[i]))!=null)) { v=args[i+2];
    if (obj.style) { obj=obj.style; v=(v=='show')?'visible':(v=='hide')?'hidden':v; }
    obj.visibility=v; }
}
</script>
</head>
<body onLoad="initListGroup('Direct materials', document.forms[0].category, document.forms[0].sub_category);<?php if ($category=='') { ?>MM_showHideLayers('select_table','','hide')<?php } ?>" >
<form action="supply_add.php" method="get" name="form1" target="_self" id="form1">
  <table width="450" border="0" align="left" cellpadding="0" cellspacing="0" class="list2">
    <tr>
      <td colspan="3" align="center"><label class="label_std">Select category and sub category:</label>        
      <label class="std">&nbsp;</label></td>
    </tr>
    <tr>
      <td width="160" height="29" align="center" valign="top"><select name="category" id="category" style="width:160px;" onfocus="MM_showHideLayers('select_table','','hide')"   >
        <option value="<?php echo $category?>" selected="selected"><?php echo $category?></option >
      </select></td>
      <td width="181" align="center" valign="top"><select name="sub_category" id="sub_category" style="width:160px;" onchange="javascript:submitForm()" >
        <option value="<?php echo $sub_category?>" selected="selected"><?php echo $sub_category?></option>
      </select>
      </td>
      <td width="107" align="center" valign="top"><input type="image" src="../images/continue_icon.gif"alt="" name="mySubmit" /></td>
    </tr>
    <tr>
      <td height="29" colspan="3" align="center" valign="top"><hr /></td>
    </tr>
    
    </table>
    </form>
    
    <form action="../store/supplyOrderWizbase.php?p=2$s=" 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" id="store_item_select" style="width:250px;" >
          <option value=" " selected="selected"> </option>
          
          <?php
    	for ($i = 0; $i < count($arrId); $i++) {
		echo "<option value=" . "\"" . $arrId[$i] . "\"" . ">" . $arrName[$i] . "</option>";
		$_SESSION['productName'] = $arrName[$i];
		//foreach($arrId as $key=>$value){
			//echo "<option value=\"delivery.php?store_item_id=".$arrId[$i]."&cat=$cat&formEnabled2=1&date=$date" . "\"" . ">" . $arrName[$i] . "</option>";	
	    }
     ?>
        </select>
        <br />
        <br />
       
      </span></td>
    </tr>
    <tr>
      <td align="center"><label class="label_std">Quantity:&nbsp;
  <input name="quantity_text" type="text" id="quantity_text" size="15" onkeypress="return numbersonly(this, event)"/>
      </label></td>
      </tr>
    <tr>
      <td align="center"><br />
        <input name="input" type="submit" value="Enter" class="imagebutton"  />
        <input name="button" type="button" id="button" class="imagebutton" onclick="MM_goToURL('parent','../store/supplyOrderWizbase.php?p=2&s=');return document.MM_returnValue" value="Cancel" />
        <input type="hidden" name="category" id="category" value="<?php echo $category?>" />
        <input type="hidden" name="sub_category" id="sub_category" value="<?php echo $sub_category?>" />
        <input type="hidden" name="p" id="p" value="2" />
        <input type="hidden" name="s" id="s" value="10>" /></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 an item.");
  frmvalidator.addValidation("quantity_text","req","Please enter quantity.");
  
</script>
</body>
</html>