<!DOCTYPE HTML>
<html>

<head>
  <title>COLTANQUES</title>
  <meta name="description" content="website description" />
  <meta name="keywords" content="website keywords, website keywords" />
  <meta http-equiv="content-type" content="text/html; charset=UTF-8" />
  <!-- stylesheets -->
  <link href="css/style.css" rel="stylesheet" type="text/css" />
  <link href="css/colour.css" rel="stylesheet" type="text/css" />
  <!-- modernizr enables HTML5 elements and feature detects -->
<style type="text/css">
.botonExcel{cursor:pointer;}
</style>
  <script type="text/javascript" src="js/modernizr-1.5.min.js"></script>
<script type="text/javascript" src="js/jquery-1.3.2.min.js"></script>
 
      <script type="text/javascript">
        function ajax(){

            var d=document.getElementById("buscar").value; 
            var n=document.getElementById("numero").value;
            var n1=parseInt(n);
            
            document.getElementById("numero").value=n1+1;
            var div=document.getElementById("con").innerHTML;
            div=div+'<tr id="lolo'+n+'"></tr>';
            document.getElementById("con").innerHTML=div
            var ajax=new XMLHttpRequest();
            ajax.onreadystatechange=function(){
                if(ajax.readyState==4 && ajax.status==200){
                    document.getElementById("lolo"+n).innerHTML=ajax.responseText;
                }
            }
            ajax.open("GET","consultapersonal.php?var1="+d,true);
            ajax.send();   
        }
        </script>

           <script type="text/javascript">
             function ajax1(){
            var d=document.getElementById("buscar1").value; 
            var n=document.getElementById("numero1").value;
            var n1=parseInt(n);
            document.getElementById("numero1").value=n1+1;
            var div=document.getElementById("con1").innerHTML;
            var ajax1=new XMLHttpRequest();
            ajax1.onreadystatechange=function(){
                if(ajax1.readyState==4 && ajax1.status==200){
                    document.getElementById("con1").innerHTML=ajax1.responseText;
                }
            }
            ajax1.open("GET","consultapersonal1.php?var1="+d,true);
            ajax1.send();   
        }
        </script>
    <script language="javascript">
$(document).ready(function() {
	$(".botonExcel").click(function(event) {
		$("#datos_a_enviar").val( $("<div>").append( $("#Exportar_a_Excel").eq(0).clone()).html());
		$("#FormularioExportacion").submit();
	});


});
</script>
    </head>
        

<body style=width:1300px>

  <div id="main">

    <!-- begin header -->
    <aside>
        <nav>
        <ul class="sf-menu" id="nav">
            <li><a href="#">Administrar</a>
                <ul>
                 <li><a href="AdministrarPersonal.php"><span class="fa fa-caret-right"></span>Personal</a></li>
                <li><a href="ingresarportatil.php"><span class="fa fa-caret-right"></span> Portatil</a></li>
                <li><a href="ingresarcpu.php"><span class="fa fa-caret-right"></span> CPU</a></li>
                <li><a href="ingresarpantalla.php"><span class="fa fa-caret-right"></span> Pantalla</a></li>
                <li><a href="ingresarteclado.php"><span class="fa fa-caret-right"></span> Teclado</a></li>
                <li><a href="ingresarcamara.php"><span class="fa fa-caret-right"></span> Camara</a></li>
                <li><a href="ingresarimpresora.php"><span class="fa fa-caret-right"></span> Impresora</a></li>
                <li><a href="ingresartablets.php"><span class="fa fa-caret-right"></span> Tablets</a></li>
                <li><a href="ingresarmouse.php"><span class="fa fa-caret-right"></span> Mouse</a></li>
                 <li><a href="Historial.php"></span>Historial</a></li>
            </ul>
            </li>
                <li><a href="#">Asignacion</a>
              <ul>
               <li><a href="equipo.php">Equipos</a></li>
               <li><a href="equipoborrar.php">Borrar asig</a></li>
               <li><a href="Aplicaciones.php"></span>Aplicaciones</a></li>
               <li><a href="consultaasignbloque.php"></span>Consulta Total</a></li>
               <li><a href="consultabloqueasigequipo.php"></span>Historial Asig</a></li>
            </ul>
             <li><a href="#">Formato Equipo</a>
                <ul>
                <li><a href="formatosPortatilesinv.html"><span class="fa fa-caret-right"></span>Entrega Equipo</a>
                <li><a href="formatoDestruccion.html"><span class="fa fa-caret-right"></span>Destruccion</a>
                <li><a href="formatoSalida.html"><span class="fa fa-caret-right"></span>Salida</a>
                <li><a href="formatoEnvio.html"><span class="fa fa-caret-right"></span>Mantenimiento</a>
            </ul>         
              <li><a href="login.php">salir</a>
  
      </nav>
    </div>
    </aside>

    <section id="content" style="height: auto;">
    <div class="container">
      <div id="logo" ><h2><img src="img/coltan.png" style="width:135px"></h2></div>
      <form  action="registropersonal.php" method="POST">
     <table class="table table-condensed">
     <thead align="left">
      <tr>
         <br>
        <font size=5 color=grey ><label align="left"><strong>Personal de la Empresa</strong></label></font>
        <br>
      </tr>
      <tr>
        <br>
         <td>
        <input type="text" style="WIDTH: 173px; HEIGHT: 19px" name="Nombre" placeholder="Nombre" required>
       </td>
       <td>
        <input type="text" style="WIDTH: 173px; HEIGHT: 19px" name="Apellido" placeholder="Apellido" required>
       </td>
       <td>
        <input type="text" style="WIDTH: 173px; HEIGHT: 19px" name="Cedula" placeholder="Cedula" required>
       </td>
      </tr>
        <tr>
          <td>
           <input type="text" style="WIDTH: 173px; HEIGHT: 19px" name="Email" placeholder="E.Mail" required>
          </td>
          <td>
           <input type="text" style="WIDTH: 173px; HEIGHT: 19px" name="Celular" placeholder="Celular" required>
          </td>
          <td>
           <input type="text" style="WIDTH: 173px; HEIGHT: 19px" name="Telefonofijo" placeholder="Telefono Fijo" required>
          </td>
          
        </tr>
        <tr>
        <td><strong>Areas</strong></td>
          
        <td><strong>Sedes</strong></td>

        <td><strong>Estado de la Persona</strong></td>
        </tr>
        <tr>
          <td>
            <select required style="WIDTH: 173px; HEIGHT: 19px" name="area" >
              <option value="">------</option>
              <option value="1">Talento Humano</option>
              <option value="2">Financiero</option>
              <option value="3">Compras</option>
              <option value="4">Almacen</option>
              <option value="5">Tesoreria</option>
              <option value="6">Mantenimiento</option>
              <option value="7">Administracion</option>
              <option value="8">Seguridad</option>
              <option value="9">Comercial</option>
              <option value="10">Tecnologia</option>
              <option value="11">Mantenimiento</option>
              <option value="12">Contabilidad</option>
            </select>
        </td>
         <td>
            <select required style="WIDTH: 173px; HEIGHT: 19px" name="sede" >
              <option value="">------</option>
              <option value="1">Bogota</option>
              <option value="2">Barrancabermeja</option>
              <option value="3">Bucaramanga</option>
              <option value="4">Duitama</option>
              <option value="5">Barranquilla</option>
              <option value="6">Ronal Castro</option>
              <option value="7">Cali</option>
              <option value="8">Buenaventura</option>
              <option value="9">racevedo</option>
              <option value="10">Cucuta</option>
              <option value="11">Cartagena</option>
              <option value="12">Santa Marta</option>
              <option value="13">Villavicencio</option>
              <option value="14">Medellín</option>
              <option value="15">Buga</option>
              <option value="16">Manizales</option>
              <option value="17">Diaco Tocancipa</option>
              <option value="18">Medellín-Procter</option>
              <option value="19">BARRANCA DE UPÌA</option>
              <option value="20">Puerto Gaitan</option>
              <option value="21">Cedi Pereira</option>
              <option value="22">Cali-Colgate</option>
              <option value="23">Muña</option>
              <option value="24">CediMontevideocroosdocking</option>
              <option value="25">Cedimedellin</option>
              <option value="26">Cedibuenaventura</option>
              <option value="27">achroma</option>
              <option value="28">Basf Quimica</option>
              <option value="29">Indumil</option>
              <option value="30">Tactic</option>
              <option value="31">Casa Luker</option>
              <option value="32">CediCali</option>
            </select>
        </td>
            <td>
           <select required style="WIDTH: 173px; HEIGHT: 19px" name="estado" >
           <option value="">------</option>
              <option value="1">Activo</option>
              <option value="2">Inactivo</option>
            </select>
          </td>
        </tr>
      <div align="left">
      <tr>             
        <td>
          <br>
         <button style="color: #FF0000" type="submit" value="ingresar">Ingresar</button>
        </td>
      </tr>
      </table>
      </form>
      </div>

   <form action="consultapersonal.php" method="POST"> 
     <table class="table table-condensed">
     <thead align="left"></thead>
     <tr>
        <font size=5 color=grey ><label align="left"><strong>Consultar Personal</strong></label></font>
        <br>
      </tr>
    <tr>
    <td>   
    <input  type="text" name="auto" id="buscar"  placeholder="Cedula" > 
    <input style="color: #FF0000" type="button" name="buscar" value="Buscar" onclick="ajax()"/>
    <input type="hidden" id="numero" value="1"/>
    </td>   
    </tr>
    </table> 
    <br> 
     <div class="borderidge" style="width: 1150px">
    <table class='table table-condensed' border="1">
    <thead align='left'></thead>
    <tr>       
    <td bgcolor='GREY' style="WIDTH: 110px; HEIGHT: 15px">
    <label><Strong>Cedula</Strong></label>
    </td>
    
    <td bgcolor='GREY' style="WIDTH: 110px; HEIGHT: 15px">
    <label><Strong>Nombre</Strong></label>
    </td>
   
    <td bgcolor='GREY' style="WIDTH: 110px; HEIGHT: 15px">
    <label><Strong>Apellido</Strong></label> 
    </td>
    
    <td bgcolor='GREY' style="WIDTH: 120px; HEIGHT: 15px">
    <label><Strong>Celular</Strong></label>
    </td>

     <td bgcolor='GREY' style="WIDTH: 120px; HEIGHT: 15px">
    <label><Strong>Telefono</Strong></label>
    </td>
    
    <td bgcolor='GREY' style="WIDTH: 150px; HEIGHT: 15px">
    <label><Strong>E.Mail</Strong></label>
    </td>
    
    <td bgcolor='GREY' style="WIDTH: 115px; HEIGHT: 15px">
    <label><Strong>Sede</Strong></label> 
    </td>
    
    <td bgcolor='GREY' style="WIDTH: 115px; HEIGHT: 15px">
    <label><Strong>Area</Strong></label>
    </td>

    <td bgcolor='GREY' style="WIDTH: 100px; HEIGHT: 15px">
    <label><Strong>Estado</Strong></label>
    </td>
    
    <td bgcolor='GREY' style="WIDTH: 140px; HEIGHT: 15px">
    <label><Strong>Fecha Ingreso</Strong></label> 
    </td>
    </tr>
    <tbody id="con">
    </tbody>
    </form>
    </table>
    </div>
    <tr>
    <br>
        <font size=5 color=grey ><label align="left"><strong>Actualizar Datos </strong></label></font>
        <br>
      </tr>
 <form action="actualizarpersonal.php" method="POST"> 
     <table>
        <tr>
         <td>
         <br>
          <input type="text" style="WIDTH: 173px; HEIGHT: 19px" name="Cedula" placeholder="Cedula" required>
          </td>
          <td>
          <br>
           <input type="text" style="WIDTH: 173px; HEIGHT: 19px" name="Email" placeholder="E.Mail" required>
          </td>
          <td>
          <br>
           <input type="text" style="WIDTH: 173px; HEIGHT: 19px" name="Celular" placeholder="Celular" required>
          </td>
           <td>
          <br>
           <input type="text" style="WIDTH: 173px; HEIGHT: 19px" name="Telefonofijo" placeholder="Telefono Fijo" required>
          </td>
        </tr>
         <tr>
        <td><strong>Areas</strong></td>
          
        <td><strong>Sedes</strong></td>

        <td><strong>Estado de la Persona</strong></td>
        </tr>
        <tr>
          <td>
            <select required style="WIDTH: 173px; HEIGHT: 19px" name="area">
            <option value="">-----</option>
              <option value="1">Talento Humano</option>
              <option value="2">Financiero</option>
              <option value="3">Compras</option>
              <option value="4">Almacen</option>
              <option value="5">Tesoreria</option>
              <option value="6">Mantenimiento</option>
              <option value="7">Administracion</option>
              <option value="8">Seguridad</option>
              <option value="9">Comercial</option>
              <option value="10">Tecnologia</option>
              <option value="11">Mantenimiento</option>
              <option value="12">Contabilidad</option>
            </select>
        </td>
         <td>
            <select required style="WIDTH: 173px; HEIGHT: 19px" name="sede">
            <option value="">-----</option>
              <option value="1">Bogota</option>
              <option value="2">Barrancabermeja</option>
              <option value="3">Bucaramanga</option>
              <option value="4">Duitama</option>
              <option value="5">Barranquilla</option>
              <option value="6">Ronal Castro</option>
              <option value="7">Cali</option>
              <option value="8">Buenaventura</option>
              <option value="9">racevedo</option>
              <option value="10">Cucuta</option>
              <option value="11">Cartagena</option>
              <option value="12">Santa Marta</option>
              <option value="13">Villavicencio</option>
              <option value="14">Medellín</option>
              <option value="15">Buga</option>
              <option value="16">Manizales</option>
              <option value="17">Diaco Tocancipa</option>
              <option value="18">Medellín-Procter</option>
              <option value="19">BARRANCA DE UPÌA</option>
              <option value="20">Puerto Gaitan</option>
              <option value="21">Cedi Pereira</option>
              <option value="22">Cali-Colgate</option>
              <option value="23">Muña</option>
              <option value="24">CediMontevideocroosdocking</option>
              <option value="25">Cedimedellin</option>
              <option value="26">Cedibuenaventura</option>
              <option value="27">achroma</option>
              <option value="28">Basf Quimica</option>
              <option value="29">Indumil</option>
              <option value="30">Tactic</option>
              <option value="31">Casa Luker</option>
              <option value="32">CediCali</option>
            </select>
        </td>
            <td>
           <select required style="WIDTH: 173px; HEIGHT: 19px" name="estado">
           <option value="">-----</option>
              <option value="1">Activo</option>
              <option value="2">Inactivo</option>
            </select>
          </td>
        </tr>
        </table>
      <div align="left">
      <tr>             
        <td>
        <br>
         <button style="color: #FF0000" type="submit" value="ingresar">Actualizar</button>
          <br>
        </td>
        <td><br></td>
      </tr>
      </table>
      </form>
    </div>
  </div>


    <table>
    <tr>
    <font size=5 color=grey ><label align="left"><strong>Consultar Persona Por Sedes-Areas-Estados</strong></label></font>
    <br>
    </tr>
    <tr>
    <td>   
    <input  type="text" name="auto1" id="buscar1"  placeholder="Sede-Area-Estado" > 
    <input style="color: #FF0000" type="button" name="buscar1" value="Buscar" onclick="ajax1()"/>
    <input type="hidden" id="numero1" value="1"/>
    </td>  
    </tr>
    </table> 
    <form action="consultapersonal1.php" method="POST">
    <div class="borderidge" style="width: 1150px">
    <table border="1" id="Exportar_a_Excel">
    <thead>
    <tr>       
    <td bgcolor='GREY' style="WIDTH: 110px; HEIGHT: 15px">
    <label><Strong>Cedula</Strong></label>
    </td>
    
    <td bgcolor='GREY' style="WIDTH: 110px; HEIGHT: 15px">
    <label><Strong>Nombre</Strong></label>
    </td>
   
    <td bgcolor='GREY' style="WIDTH: 110px; HEIGHT: 15px">
    <label><Strong>Apellido</Strong></label> 
    </td>
    
    <td bgcolor='GREY' style="WIDTH: 120px; HEIGHT: 15px">
    <label><Strong>Celular</Strong></label>
    </td>

     <td bgcolor='GREY' style="WIDTH: 120px; HEIGHT: 15px">
    <label><Strong>Telefono</Strong></label>
    </td>
    
    <td bgcolor='GREY' style="WIDTH: 150px; HEIGHT: 15px">
    <label><Strong>E.Mail</Strong></label>
    </td>
    
    <td bgcolor='GREY' style="WIDTH: 115px; HEIGHT: 15px">
    <label><Strong>Sede</Strong></label> 
    </td>
    
    <td bgcolor='GREY' style="WIDTH: 115px; HEIGHT: 15px">
    <label><Strong>Area</Strong></label>
    </td>

    <td bgcolor='GREY' style="WIDTH: 100px; HEIGHT: 15px">
    <label><Strong>Estado</Strong></label>
    </td>
    
    <td bgcolor='GREY' style="WIDTH: 140px; HEIGHT: 15px">
    <label><Strong>Fecha Ingreso</Strong></label> 
    </td>
    </tr>
    <tbody id="con1">
    </tbody>
    </form>
    </thead>
    </table>
<form action="ficheroExcel.php" method="post" target="_blank" id="FormularioExportacion">
<p><img src="img/export_to_excel.gif" class="botonExcel" /></p>
<input type="hidden" id="datos_a_enviar" name="datos_a_enviar" />
</form>
    </div>
 </section>
</div>
<div><table><tr></tr></table></div>
<table><tr><br></tr></table>
  <script type="text/javascript" src="js/jquery.min.js"></script>
  <script type="text/javascript" src="js/jquery.easing-sooper.js"></script>
  <script type="text/javascript" src="js/jquery.sooperfish.js"></script>
  <script type="text/javascript" src="js/image_fade.js"></script>
  <script type="text/javascript">
    $(document).ready(function() {
      $('ul.sf-menu').sooperfish();
    });
  </script>
</body>
</html>
