<?php include("../../include/dbconnect.php");?>
<title>Customer add page</title>
<body background="../../images/blater01.gif"  topmargin=0>
<center>
<table cellpadding=0 cellspacing=4 width=590>
<tr>
<td style="padding:3px;" colspan=2 bgcolor="#93BEE2"><font face="Arial, Helvetica, sans-serif" ><b>Fill Customer Details</b></font></td>
</tr><tr valign="top"><td colspan=2>
<font >&nbsp;</font>
</td>
</tr>
</table>
<table border=0 cellpadding=3 cellspacing=4 width="590"><form method="POST" action="buy_create_entry.php">
  <tr> 
    <td > <font face="Arial, Helvetica, sans-serif" class="sbd"><b>Account Group</b></font> 
    </td>
    <td colspan=2> <font face="Arial, Helvetica, sans-serif"> 
      <select name=accthead>
        <?php
$query = "select acctcode,groupname  from acctgroup where acctcode in ('11120002','11130005')";
$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>Area</b></font> </font></td>
    <td colspan=2> <font face="Arial, Helvetica, sans-serif"> 
      <select name="area">
        <?php $query=" select location,areacode from area  order by location,areacode ";
      $query=stripslashes($query);
      $result=mysqli_query($conn,$query) or
      die( mysqli_error() );
      while ( $row= mysqli_fetch_row($result))
      {         
          echo "<option value=$row[1]>";
	  echo $row[0];
	  echo "\n";
      }
?>
      </select>
      </font></td>
  </tr>
  <tr> 
    <td > <font face="Arial, Helvetica, sans-serif"><b>Customer Type</b></font> 
      </font></td>
    <td colspan=2> <font face="Arial, Helvetica, sans-serif"> 
      <select name="buyertype">
        <option value="Supplier"> Supplier</option>
        <option value="Buyer">Buyer</option>
        <option value="Supbuy">Supplier & Buyer</option>
        <option value="Others"> Others</option>
      </select>
      </font></td>
  </tr>
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>Customer Name</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bname">
      </font></td>
  </tr>
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>Address 1</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="baddress1">
      </font></td>
  </tr>
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif">Address 2 </font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="baddress2">
      </font></td>
  </tr>
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>District</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bcity">
      </font></td>
  </tr>
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>State</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bstate">
      </font></td>
  </tr>
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>Country</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="country">
      </font></td>
  </tr>
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>Pin Code</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="10" name="bpin">
      </font></td>
  </tr>
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>STD Code</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="10" name="bstd">
      </font></td>
  </tr>
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>Tel No(s)</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="btelno">
      </font></td>
  </tr>
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>Mobile No (with out 0 / +91)</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="mobile">
      </font></td>
  </tr>
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>E-mail</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bemail">
      </font></td>
  </tr>

  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>Contact Person</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="contact">
      </font></td>
  </tr>

  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>CST No</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="bcst">
      </font></td>
  </tr>
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>TIN No</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="tin">
      </font></td>
  </tr>
  
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>GSTIN No</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="gstin">
      </font></td>
  </tr>

  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>TAX TYPE</b></font></font></td>
    <td> 
      <select name="taxtype">
      <option value="STATE">Within State
      <option value="INTERSTATE">Inter State
      </option>
      </td>
  </tr>
    
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>State Code</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="state_code">
      </font></td>
  </tr>
      
  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>Incentive (Yes/No)</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="incentive">
      </font></td>
  </tr>

  <tr> 
    <td><font face="Arial, Helvetica, sans-serif"><b>Credit Days</b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text"    onKeyPress="return event.keyCode!=13"   size="35" name="credit">
      </font></td>
  </tr>
  
</tr>
    <td><font face="Arial, Helvetica, sans-serif"><b>Discount Percentage </b></font></font></td>
    <td> <font face="Arial, Helvetica, sans-serif"> 
      <input type="text" onKeyPress="return event.keyCode!=13" size="10" name="discount" >
      </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>

