<?php include "layouts/menu.php"; ?> <div class="right_col" role="main">
            <div class="row">
                 <!-- page header -->
             
                <!--end page header -->
            </div>
            <div class="row">
                <div class="col-lg-12">
                    <!-- Form Elements -->
                    <div class="panel panel-default">
                        <div class="panel-heading">
                            Seized Vehicle Details
                        </div>
                        <div class="panel-body">
                            <div class="row">
                   <form id="demo-form2" data-parsley-validate class="form-horizontal form-label-left" method="post"  enctype="multipart/form-data">
  <div class="col-md-3">      <input type="date" class="form-control thicker" id="datepicker" name="fdate" value="<?php echo date("Y-m-d"); ?>" placeholder="DD/MM/YYYY" onfocus="insertDate(this,'DD-MM-YYYY')">

    </div>
    <div class="col-md-3">   <input type="date" class="form-control thicker" id="datepicker" name="tdate" value="<?php echo date("Y-m-d"); ?>" placeholder="DD/MM/YYYY" onfocus="insertDate(this,'DD-MM-YYYY')">
   </div>
   <div class="col-md-3">    <select type="text" class="form-control"  name="godown" value="" placeholder="" >
	  <option>All Godown</option>
	  <?php $sql5 = mysqli_query($conn, "select * from godown"); while($row5 = mysqli_fetch_array($sql5)) { ?>
	  <option><?php echo $row5['name']; ?></option> <?php } ?></select>
    </div>
   <div class="col-md-3">      <button type="submit" class="btn btn-info" name="s15">Show It</button></div>
 
                  </div>
                </div>
              </div>
              
              <div class="col-md-12 col-sm-12 col-xs-12">
                <div class="x_panel">
                  <div class="x_title" >
                    <h2>Sizzing List <small></small></h2>
                    <ul class="nav navbar-right panel_toolbox">
                      <li><a class="collapse-link"><i class="fa fa-chevron-up"></i></a>
                      </li>
                      <li class="dropdown">
                        <a href="#" class="dropdown-toggle" data-toggle="dropdown" role="button" aria-expanded="false"><i class="fa fa-wrench"></i></a>
                        <ul class="dropdown-menu" role="menu">
                          <li><a href="#">Settings 1</a>
                          </li>
                          <li><a href="#">Settings 2</a>
                          </li>
                        </ul>
                      </li>
                      <li><a class="close-link"><i class="fa fa-close"></i></a>
                      </li>
                    </ul>
                    <div class="clearfix"></div>
                  </div>
                  <div class="x_content">
                    <div class="row">
                      <div class="col-sm-12">
                        <div class="card-box table-responsive">
                          
                                        <?php
		
								if(isset($_POST['s15']))
								{
									extract($_POST);
		
						?></p>
				<table id="datatable-buttons" id="datatable-buttons" class="table table-striped table-bordered">
				<thead>
						<tr>
				<th>S.No</th>	<th>Seize Date</th>	<th>Hpl</th>
						
						<th>Name</th>
							<th>Vehicle Name</th>
							
						<th>Vehicle No</th>
						<th>Vehicle Model</th>
						<th>Gowdown</th>
						<th>Seized By</th>	<th>Closing</th>
		
				
					</tr><thead><tbody>
					<?php $i = 0; if($godown == 'All Godown') { 
					$qry=mysqli_query($conn, "select * from sizzing where mfin='$mfin' && sizdate2 between '$fdate' and '$tdate'"); }
					else { 
					$qry=mysqli_query($conn, "select * from sizzing where mfin='$mfin' && godown='$godown' && sizdate2 between '$fdate' and '$tdate'"); }
				$n=mysqli_num_rows($qry);
				while($row=mysqli_fetch_array($qry))
  { $i++;
$x = $row['hpl'];
?>				<tr>
    <td><?php echo $i;?></td>
				<td><?php
$sssq = $row['sizdate'];
$sssd = date('d-m-Y',strtotime($sssq));
						echo $sssd; ?></td>
						<td><a href="udelete10.php?hpl=<?php echo $row['hpl']; ?>&mfin=<?php echo $mfin; ?>" target="_blank"><?php echo $row['hpl'];?></a></td>
						
						<?php $hpl = $row['hpl'];
			//	$qry122=mysqli_query($conn, "select * from customerdetails where mfin='$mfin' &&  hpl=$hpl");
				//$n55=mysqli_num_rows($qry122); 
				//$row111=mysqli_fetch_array($qry122);
				
	 ?>
<td><?php echo $row['name'];?></td>
<td><?php echo $row['vname'];?></td>

<td><?php echo $row['vno'];?></td>
<td><?php echo $row['model'];?></td>
<td><?php echo $row['godown'];?></td>
<td><?php echo $row['byy'];?></td>
	<td>
<a href="sizgo.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Add to Gowdown!"><i class="fa fa-shopping-cart fa-2x" style="color:navi;" aria-hidden="true"></i></a>

<a href="fullsettle2.php?hpl=<?php echo $row['hpl'];?>&mfin2=<?php echo $row['mfin'];?>" data-toggle="tooltip" title="Full Settlement!"><i class="fa fa-close fa-2x" style="color:red;"  aria-hidden="true"></i></a>&nbsp;&nbsp;	
<a href="udelete.php?id=<?php echo $row['id'];?>&mfin2=<?php echo $row['mfin']; ?>"  data-toggle="tooltip" title="Full View!"><i class="fa fa-feed fa-2x" style="color:navi;" aria-hidden="true"></i></a>
			</td>

					
					</tr>
					<?php
						$x++; }
					}
				
					?></tbody>
					</table>
					
</div>
</div></div>
</div></div></div>      <footer>
          <div class="pull-right">
             <a href="https://infossel.com">Infossel Soft Solution</a>
          </div>
          <div class="clearfix"></div>
        </footer>
        <!-- /footer content -->
      </div>
    </div>

    <!-- jQuery -->
    <script src="vendors/jquery/dist/jquery.min.js"></script>
    <!-- Bootstrap -->
    <script src="vendors/bootstrap/dist/js/bootstrap.min.js"></script>
    <!-- FastClick -->
    <script src="vendors/fastclick/lib/fastclick.js"></script>
    <!-- NProgress -->
    <script src="vendors/nprogress/nprogress.js"></script>
    <!-- iCheck -->
    <script src="vendors/iCheck/icheck.min.js"></script>
    <!-- Datatables -->
    <script src="vendors/datatables.net/js/jquery.dataTables.min.js"></script>
    <script src="vendors/datatables.net-bs/js/dataTables.bootstrap.min.js"></script>
    <script src="vendors/datatables.net-buttons/js/dataTables.buttons.min.js"></script>
    <script src="vendors/datatables.net-buttons-bs/js/buttons.bootstrap.min.js"></script>
    <script src="vendors/datatables.net-buttons/js/buttons.flash.min.js"></script>
    <script src="vendors/datatables.net-buttons/js/buttons.html5.min.js"></script>
    <script src="vendors/datatables.net-buttons/js/buttons.print.min.js"></script>
    <script src="vendors/datatables.net-fixedheader/js/dataTables.fixedHeader.min.js"></script>
    <script src="vendors/datatables.net-keytable/js/dataTables.keyTable.min.js"></script>
    <script src="vendors/datatables.net-responsive/js/dataTables.responsive.min.js"></script>
    <script src="vendors/datatables.net-responsive-bs/js/responsive.bootstrap.js"></script>
    <script src="vendors/datatables.net-scroller/js/dataTables.scroller.min.js"></script>
    <script src="vendors/jszip/dist/jszip.min.js"></script>
    <script src="vendors/pdfmake/build/pdfmake.min.js"></script>
    <script src="vendors/pdfmake/build/vfs_fonts.js"></script>

    <!-- Custom Theme Scripts -->
    <script src="build/js/custom.min.js"></script>

  </body>
</html>