<?php include "layouts/menu.php"; ?>
 <?php $vno=$_REQUEST['vno'];?>
 <script>
function add3()
{
var x = document.getElementById("1").value;
var y = document.getElementById("bba").value;
document.getElementById("1").value =(x*1)+(y*1);
}
</script>

 <script>
function add11()
{
var x = document.getElementById("44").value;
var y = document.getElementById("33").value;
document.getElementById("1").value =(x*1)+(y*1);
}
</script>
  <script>
function add()
{
var x = document.getElementById("txt1").value;
var y = document.getElementById("txt2").value;
document.getElementById("tot").value =(x*1)+(y*1);
}
</script>
<script>
function add1()
{
var x1 = document.getElementById("1").value;
var y1 = document.getElementById("2").value;
document.getElementById("txt2").value =(x1*1)*(y1/100);
}
</script>
<script>
function add2()
{
var x1 = document.getElementById("1").value;
var y1 = document.getElementById("3").value;
document.getElementById("txt1").value =parseInt((x1*1)/(y1*1));
}
</script>
  <!--  page-wrapper -->
         <div class="right_col" role="main">
            <div class="row">
                 <!-- page header -->
                <div class="col-lg-12">
                    <h1 class="page-header  alert alert-danger">New Registration For Auto Due Loan</h1>
                </div>
                <!--end page header -->
            </div>
            <div class="row">
                <div class="col-lg-12">
				<a href="allcus.php"><button class="btn btn-primary">View</button></a>&nbsp;&nbsp;&nbsp;<a href="edithp.php"><button class="btn btn-primary">Edit</button></a>
                    <!-- Form Elements -->
                    <div class="panel panel-default">
                        <div class="panel-heading">
                            Fill the form
                        </div>
                        <div class="panel-body">
                            <div class="row">
                                <div class="col-lg-6">
                                   <?php
								   $qry1=mysqli_query($conn, "select * from customerdetails where mfin='$mfin' &&  vno='$vno'");
						$n1=mysqli_num_rows($qry1);
						$row1=mysqli_fetch_array($qry1);
						$qry=mysqli_query($conn, "select * from customerdetails where mfin='$mfin'");
						$n=mysqli_num_rows($qry);
						if($n==0)
						{
							$rty = 1;
						}
						else
					    {
						while($row=mysqli_fetch_array($qry))
						{
						$sss = $row['hpl'];
						}
						$rtyy = $sss + 1;
						$rty = sprintf('%03d', $rtyy);
						} ?>
   <form role="form" name="form1" method="post" action="register1.php" enctype="multipart/form-data">
   <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >HPL</label>
      <input type="text" class="form-control" id="inputPassword3" name="hpl" value="<?php echo $rty;?>" placeholder="E.g 1008" required>
<span class="glyphicon glyphicon-user form-control-feedback"></span> 
 </div>
  <div class="form-group has-success has-feedback">
    <label for="inputEmail3" >Vehicle No</label>
      <input type="text" class="form-control" id="inputEmail3" name="vno" value="<?php echo $row1['vno'];?>" placeholder="E.g TN 21 S 2676">
  <span class="glyphicon glyphicon-shopping-cart form-control-feedback"></span>
    </div>
  <div class="form-group has-success has-feedback">
    <label for="inputEmail3" >Upload Image</label>
    <input type="file" id="exampleInputFile" name="uimg" >
    <p class="help-block">Upload Passport size Photo here.</p>
	<span class="glyphicon glyphicon-cloud-upload form-control-feedback"></span>
  </div>  
  <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Model</label>
      <input type="text" class="form-control" id="inputPassword3" name="model" value="<?php echo $row1['model'];?>" placeholder="Vehicle Model">
   <span class="glyphicon glyphicon-time form-control-feedback"></span>
  </div>
    <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Vehicle Name</label>
       <input type="text" class="form-control" id="inputPassword3" name="vname" value="<?php echo $row1['vname'];?>" placeholder="Vehicle Name">
    <span class="glyphicon glyphicon-plane form-control-feedback"></span>

    </div>

   <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Color</label>
      <input type="text" class="form-control" id="inputPassword3" name="color" value="<?php echo $row1['color'];?>" placeholder="E.g RED">
    <span class="glyphicon glyphicon-tint form-control-feedback"></span>
	
    </div>
	
     <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >H.P Amount</label>
      <input type="text" class="form-control" id="44" name="totalhpamt"  value="" placeholder="H.P Amount" >
   <span class="glyphicon glyphicon-usd form-control-feedback"></span>
  </div>

   <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Documentation Charge</label>
      <input type="text" class="form-control" id="33" name="document"  value="" onchange="add11()"  placeholder="Documentation Charge" >
   <span class="glyphicon glyphicon-usd form-control-feedback"></span>
  </div>

    <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Total H.P Amount</label>
      <input type="text" class="form-control" id="1" name="hpamount"  value="" placeholder="H.P Amount" onChange="add1()">
   <span class="glyphicon glyphicon-usd form-control-feedback"></span>
  </div>
   <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Interest in %</label>
      <input type="text" class="form-control" id="2" name="inter"  value="" placeholder="2" onChange="add1()">
    <span class="glyphicon glyphicon-info-sign form-control-feedback"></span>
  </div>
  
  <div class="form-group has-success has-feedback">
    <label for="inputPassword3" class="control-label">H.P Date</label>
      <input type="text" class="form-control" id="datepicker"  name="hpdate" value="" placeholder="H.P Date" onfocus="insertDate(this,'DD-MM-YYYY')">
 <span class="glyphicon glyphicon-calendar form-control-feedback"></span>
    </div>
   <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Due Month</label>
      <input type="text" class="form-control" id="3" name="duemnt" value="" placeholder="Due Month" onchange="add2()";>
  <span class="glyphicon glyphicon-time form-control-feedback"></span>
  </div>
								<div class="form-group has-success has-feedback">
    <label for="txt1" >Principle part</label>
      <input type="text" class="form-control" id="txt1"  name="dueamt" value="" placeholder="Due Amount" onChange="add()">
   <span class="glyphicon glyphicon-usd form-control-feedback"></span>
  </div>
  <div class="form-group has-success has-feedback">
    <label for="txt2" >Interest Part</label>
      <input type="text" class="form-control" id="txt2"  name="interest" value="" placeholder="Interest" >
   <span class="glyphicon glyphicon-usd form-control-feedback"></span>
  </div>

   <div class="form-group has-error has-feedback">
    <label for="inputPassword3" >Total Amount</label>
      <input type="text" class="form-control" id="tot" name="total" value="" placeholder="Total Amount" onClick="add()">
   <span class="glyphicon glyphicon-usd form-control-feedback"></span>
  </div>

  
	  
  </div>
                                <div class="col-lg-6">  

  <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Name</label>
      <input type="text" class="form-control" id="inputPassword3" name="name" value="<?php echo $row1['name'];?>" placeholder="Name">
 <span class="glyphicon glyphicon-user form-control-feedback"></span>
  </div>
    <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Phone Number</label>
      <input type="text" class="form-control" id="inputPassword3" name="pno" value="<?php echo $row1['pno'];?>" placeholder="Eg: 9876543210">
 <span class="glyphicon glyphicon-phone-alt form-control-feedback"></span>
  </div>
    <div class="form-group has-warning has-feedback">
    <label for="inputEmail3" >Upload Image</label>
    <input type="file" id="exampleInputFile" name="img" >
    <p class="help-block">Upload Co-Applicant Passport size Photo here.</p>
	<span class="glyphicon glyphicon-cloud-upload form-control-feedback"></span>
  </div>  
  <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Address</label>
      <textarea class="form-control" rows="3" name="address" value="" placeholder="Address"><?php echo $row1['address'];?></textarea>
  <span class="glyphicon glyphicon-home form-control-feedback"></span>
  </div> <input type="hidden" class="form-control" id="balance"  name="nname" value="<?php echo $nname; ?>" placeholder=""  onclick="sum()">
 
  	    <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Govt ID</label>
      <select type="text" class="form-control" id="inputPassword3" name="gi1" value="" placeholder="">
	  
    <span class="glyphicon glyphicon-plane form-control-feedback"></span>
	<option><?php echo $row1['gi1'];?></option>
	<?php 
$qry=mysqli_query($conn, "select * from mgovt");
	while($row2=mysqli_fetch_array($qry))
						{ ?> <option><?php echo $row2['name'];?></option>
						<?php } ?> </select>
		<input type="text" class="form-control" id="1" name="g1"  value="<?php echo $row1['g1'];?>" placeholder="Govt ID No" >

    </div>
		    <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Govt ID</label>
      <select type="text" class="form-control" id="inputPassword3" name="gi2" value="" placeholder="">
	  
    <span class="glyphicon glyphicon-plane form-control-feedback"></span>
	<option><?php echo $row1['gi2'];?></option>
	<?php 
$qry=mysqli_query($conn, "select * from mgovt");
	while($row2=mysqli_fetch_array($qry))
						{ ?> <option><?php echo $row2['name'];?></option>
						<?php } ?> </select>
		<input type="text" class="form-control" id="1" name="g2"  value="<?php echo $row1['g2'];?>" placeholder="Govt ID No" >

    </div>	    <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Govt ID</label>
      <select type="text" class="form-control" id="inputPassword3" name="gi3" value="" placeholder="">
	  
    <span class="glyphicon glyphicon-plane form-control-feedback"></span>
	<option><?php echo $row1['gi3'];?></option>
	<?php 
$qry=mysqli_query($conn, "select * from mgovt");
	while($row2=mysqli_fetch_array($qry))
						{ ?> <option><?php echo $row2['name'];?></option>
						<?php } ?> </select>
		<input type="text" class="form-control" id="1" name="g3"  value="<?php echo $row1['g3'];?>" placeholder="Govt ID No" >

    </div>
	<div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Co-Applicant Name</label>
      <input type="text" class="form-control" id="inputPassword3" name="cobname" value="<?php echo $row1['cobname'];?>" placeholder="Co-Applicant Name">
 <span class="glyphicon glyphicon-user form-control-feedback"></span>
  </div>
		<div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Co-Applicant Phone</label>
      <input type="text" class="form-control" id="inputPassword3" name="cobpno" value="<?php echo $row1['cobpno'];?>" placeholder="Co-Applicant Phone">
 <span class="glyphicon glyphicon-user form-control-feedback"></span>
  </div>
    <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Co-Applicant Details</label>
      <textarea class="form-control" rows="3" name="co" value="" placeholder=""><?php echo $row1['co'];?></textarea>
    <span class="glyphicon glyphicon-user form-control-feedback"></span>
  </div>
    	    <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Co-Applicant Govt ID</label>
      <select type="text" class="form-control" id="inputPassword3" name="bi1" value="" placeholder="">
	  
    <span class="glyphicon glyphicon-plane form-control-feedback"></span>
	<option><?php echo $row1['bi1'];?></option>
	<?php 
$qry=mysqli_query($conn, "select * from mgovt");
	while($row2=mysqli_fetch_array($qry))
						{ ?> <option><?php echo $row2['name'];?></option>
						<?php } ?> </select>
		<input type="text" class="form-control" id="1" name="b1"  value="<?php echo $row1['b1'];?>" placeholder="Govt ID No" >

    </div>
		    <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Co-Applicant Govt ID</label>
      <select type="text" class="form-control" id="inputPassword3" name="bi2" value="" placeholder="">
	  
    <span class="glyphicon glyphicon-plane form-control-feedback"></span>
	<option><?php echo $row1['bi2'];?></option>
	<?php 
$qry=mysqli_query($conn, "select * from mgovt");
	while($row2=mysqli_fetch_array($qry))
						{ ?> <option><?php echo $row2['name'];?></option>
						<?php } ?> </select>
		<input type="text" class="form-control" id="1" name="b2"  value="<?php echo $row1['b2'];?>" placeholder="Govt ID No" >

    </div>	    
	<div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Co-Applicant Govt ID</label>
      <select type="text" class="form-control" id="inputPassword3" name="bi3" value="" placeholder="">
	  
    <span class="glyphicon glyphicon-plane form-control-feedback"></span>
	<option><?php echo $row1['model'];?></option>
	<?php 
$qry=mysqli_query($conn, "select * from mgovt");
	while($row2=mysqli_fetch_array($qry))
						{ ?> <option><?php echo $row2['name'];?></option>
						<?php } ?> </select>
		<input type="text" class="form-control" id="1" name="b3"  value="<?php echo $row1['b3'];?>" placeholder="Govt ID No" >

    </div>	   

   <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Broker Name</label>
      <select type="text" class="form-control" id="inputPassword3" name="bname" value="" placeholder="Broker Name">
    <span class="glyphicon glyphicon-cloud-download form-control-feedback"></span>
	<option><?php echo $row1['bname'];?></option>
	<?php 
$qry=mysqli_query($conn, "select * from mbroker");
	while($row2=mysqli_fetch_array($qry))
						{ ?> <option><?php echo $row2['name'];?></option>
						<?php } ?> </select>
    </div>
	
    <div class="form-group has-success has-feedback">
    <label for="inputPassword3" >Boker Commission</label>
      <input type="text" class="form-control" id="txt3" name="bcommission"  value="" placeholder="Boker Commission" >
   <span class="glyphicon glyphicon-usd form-control-feedback"></span>
  </div>
  <div class="form-group">
   
      <button type="submit" class="btn btn-success btn-lg btn-block" name="s2">Register</button>

</div>
      <div class="alert alert-success">
	 <?php
							if(isset($_POST['s2']))
							{
								extract($_POST);
								$uimg=$_FILES['uimg']['name'];
								$img=$_FILES['img']['name'];
								$insert=mysqli_query($conn, "insert into customerdetails(mfin,scode,hpl,uimg,vno,model,vname,color,hpamount,inter,hpdate,duemnt,dueamt,interest,total,name,pno,address,cobname,cobpno,co,img,bname,bcommission,document,totalhpamt,g1,g2,g3,gi1,gi2,gi3,b1,b2,b3,bi1,bi2,bi3,nname)
								values('$mfin','$scode','$hpl','$uimg','$vno','$model','$vname','$color','$hpamount','$inter','$hpdate','$duemnt','$dueamt','$interest','$total','$name','$pno','$address','$cobname','$cobpno','$co','$img','$bname','$bcommission','$document','$totalhpamt','$g1','$g2','$g3','$gi1','$gi2','$gi3','$b1','$b2','$b3','$bi1','$bi2','$bi3','$nname')");
								if($insert)
								{
								echo "<script>alert('Register successfully');window.location.href='register1.php'</script><br>";
						//header("location:register1.php");
									$move=move_uploaded_file($_FILES['uimg']['tmp_name'],"user/".$uimg);
									$move1=move_uploaded_file($_FILES['img']['tmp_name'],"user/".$img);
						
									if($move&&$move1)
									{
										echo "  Image Upload";
									}
									else
									{
										echo "Image Upload failure";
									}
								}
								else
								{
									echo "Failure";
								}
							}
?>
	  </div>
</form>
  </div>
 
 
</div>
</div></div>
</div></div></div><?php include "layouts/footer.php"; ?></body></html>
