<?php
 
session_start();
include("DMMYSQLG.php");
include("DSA1000.php");
include ("varfun.php");
include("JQUERY.inc");
$nr=0;
$adultos="";
$f_f="";
$tohb1="";
$f_m="";
mysqli_query($con ,"DELETE from valeryusst08 where fec_fin<'".$dt_empres['fec_alta']."'");
if(isset($_GET['reg'])){
	
	 mysqli_query($con ,"DELETE from valeryusst08 where n_reg=".$_GET['reg']);
}
?>
<html>
<HEAD> 

<STYLE>
table tr td {
    padding: 5px;
    border-bottom: 1px dotted;
    border-right: 3px;
    margin: 3px;
    font-weight: bold;
    font-size: 14px;
    color: blue;
}
</style>


<link rel="stylesheet" href="css/estilo1.css" type="text/css"/>
<meta name="tipo_contenido" content="text/html;" http-equiv="content-type" charset="utf-8">
<script type="text/javascript" language="JavaScript1.2" src="js/searchtable.js"></script>
<script>
    $(function() {
		  theTable = $("#latabla");
		  $("#q").keyup(function() {
			$.uiTableFilter(theTable, this.value);
		  });
		});
</script>
</HEAD>
<script type="text/javascript" language="JavaScript1.2" src="DSSCRIPT.js"></script>

<div align="left">

</div>
<div align="center">
  <form name="frm1" id="frm1" method="post" action="<?php
 echo $_SERVER['PHP_SELF']; ?>" target="_self">
    <table width="441" border="0">
	<tr>
	  <th colspan="2"><span class="Estilo23">REPORTE DE BLOQUEOS</span></th>
	  </tr>
	
	  <td colspan="2" height="25">	  </td>
	  </tr>
      <tr>
        <td colspan="2">
            <div align="center">
              <input name="Submit" type="submit" class="original"  value="Buscar"/>
			  
		  </div></td>  </tr>  
    </table>  
	</form> 
 </div>
<div align="center">
 
     <div style="height:450px; overflow:scroll; width:1150;" align="center">
         
         <div id="busqueda" style="color:#000">
		Busqueda Rapida <input type="text" style="width: 70%" id="q" name="q" value="" />
		</div>
	<table id='latabla'>
            <thead>
	<tr><th colspan="15"><span class="Estilo23">
	 </span></th></tr>
      <tr>
		<th><div align="center">HAB</div></th>
		<th><div align="center">INICIO</div></th>
		<th><div align="center">FIN</div></th>
		<th><div align="center">MOTIVO</div></th>
		<th><div align="center">TIPO DE BLOQUEO</div></th>
		<th><div align="center">LIBERAR</div></th>
		
        </tr></thead><tbody>
	  <?php

	 
		$seccion=mysqli_query($con ,"select * from valeryusst08 order by fnumcto ");
	//if(!$seccion)die(mysqli_error($con));
	while($reg=mysqli_fetch_array($seccion)){
	
		echo "<tr>";
			echo "<td>".$reg['fnumcto']."</td>";
		echo "<td>".$reg['fec_ini']."</td>";
		echo "<td>".$reg['fec_fin']."</td>";
	echo "<td>".$reg['motivo']."</td>";
	echo "<td>".$reg['status']."</td>";
	echo "<td> <button onclick=\"openpage('ama_bloqueados_PR.php?reg=".$reg['n_reg']."','_self')\" >LIBERAR</button>
			  
			  </td>";	
		echo " </tr>";	
	
	
	}
	mysqli_close($con);
	?>
	 
            </tbody>
    </table></div>  </div>  </body>  </html>
