<?php include("../../include/dbconnect.php");?>
<title>Product Master Creation</title>

<body background="../../images/blater01.gif" topmargin=0>
<center>
<form method="Post" action="entry.php">
<table cellpadding=0 cellspacing=4 width=590>
<tr>
<td style="padding:3px;" colspan=2 bgcolor="#93BEE2"><font face="Arial, Helvetica, sans-serif" ><b>Product Master Creation</b></font></td>
</tr><tr valign="top"><td colspan=2>
<font >&nbsp;</font>
</td>
</tr>

 
  <tr> 
    <td > <font face="Arial, Helvetica, sans-serif" class="sbd"><b>Product Group 
      / Item</b></font> </td>
    <td colspan=2> <font face="Arial, Helvetica, sans-serif"> 
      <select name=prodcat>
        <?php
$query = "select catcode,category  from prodcat order by category";
$query = stripslashes($query);
$result= mysqli_query($conn,$query) or
      die (mysqli_error() );
     while($row=mysqli_fetch_row($result) )
       {
        echo "<option value='$row[0]'>";
	echo $row[1];
	echo "\n";
	}
?>
      </select>
      </font></td>
  </tr>
 <?
 /*
    <td > <font face="Arial, Helvetica, sans-serif" class="sbd"><b>Product Type 
      </b></font> </td>
    <td colspan=2> <font face="Arial, Helvetica, sans-serif"> 
      <select name=type>
        <option value="RM">Raw Material</option>
        <option value="WP">Work in Progress</option>
        <option value="FG">Finished Goods</option>
      </select>
      </font></td>
  </tr>
  */
  ?>
  <tr>
    <td > <font face="Arial, Helvetica, sans-serif" class="sbd"><b>Packed in</b></font> 
    </td>
    <td colspan=2> <font face="Arial, Helvetica, sans-serif"> 
      <select name = packed>
                  <option value="nos">Nos 
        <option value="kgs">Kgs 
        <option value="Packets">Packets 

      </select>
      </font></td>
  </tr>
  <tr>
    <td><font face="Arial, Helvetica, sans-serif"><b>Product Name </b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text" onKeyPress="return event.keyCode!=13" size="50" name="prodname" >
      </font></td>
  </tr>

  <tr>
    <td><font face="Arial, Helvetica, sans-serif"><b>HSN Code  </b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text" onKeyPress="return event.keyCode!=13" size="15" name="capacity">
      </font></td>
  </tr>
  <?
  /*
  <tr>
    <td><font face="Arial, Helvetica, sans-serif"><b> Weight</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text" onKeyPress="return event.keyCode!=13" size="15" name="weight">
      </font></td>
  </tr>  
  */
  ?>
  <tr>
    <td><font face="Arial, Helvetica, sans-serif"><b>Minimum Qty of stock</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text" onKeyPress="return event.keyCode!=13" size="15" name="minimum_qty">
      </font></td>
  </tr>
  
  <?
  /*
  <tr> 
    <td > <font face="Arial, Helvetica, sans-serif" class="sbd"><b>Transfer Stock to </b></font> </td>
    <td colspan=2> <font face="Arial, Helvetica, sans-serif"> 
      <select name=stprodcode>
	  <option selected value="Same">Current Item</option>
        <?php
		
$query = "select prodcode,prodname  from product order by prodname";
$query = stripslashes($query);
$result= mysqli_query($conn,$query) or
      die (mysqli_error() );
     while($row=mysqli_fetch_row($result) )
       {
        echo "<option value='$row[0]'>";
	echo $row[1];
	echo "\n";
	}
?>
      </select>
      </font></td>
  </tr>  
 
  
</tr>
    <td><font face="Arial, Helvetica, sans-serif"><b>Opening Balance </b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text" onKeyPress="return event.keyCode!=13" size="50" name="opening_balance" >
      </font></td>
  </tr>  
   */
  ?>
  <tr>
    <td><font face="Arial, Helvetica, sans-serif"><b>Rate </b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text" onKeyPress="return event.keyCode!=13" size="50" name="rate" >
      </font></td>
  </tr> 
  
    <tr>
    <td><font face="Arial, Helvetica, sans-serif"><b>Tax Rate </b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text" onKeyPress="return event.keyCode!=13" size="50" name="tax_rate" >
      </font></td>
  </tr>
  <?
  /*
    </tr>
      <td><font face="Arial, Helvetica, sans-serif"><b>Status Debit / Credit</b></font></font></td>
        <td> <font face="Arial, Helvetica, sans-serif"> 
	<select name="db_cr">
	<option value="DB">Debit</option>
	<option value="CR">Credit</option>
	</select>
      </font></td>
  </tr>  
  */
  ?>
  <table cellpading=0 cellspacing=10 width= 50>
    <tr> 
      <blockquote> 
        <td> <input type =submit name=submit value = "Submit"></td>
        <td><input type="reset" name="reset" value="Clear"></blockquote></td>
  </table>
</table>
<br><br><font size=1><center><a href= "index.html">Return to index page</a></center></font>

                                                                             
</body>

</form>
