<?php
session_start();
     if( (isset($_SESSION['IdDoc'])) &&($_SESSION['IdDoc']>0))
   {  
?>
<!DOCTYPE html>
<html>
<head>
<title>IESTP-Abancay-Docente</title>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0, user-scalable=0, minimal-ui">
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<link rel="icon" href="assets/images/favicon.ico" type="image/x-icon">
<link rel="stylesheet" href="bower_components/bootstrap/css/bootstrap.min.css">
<link rel="stylesheet" href="assets/pages/waves/css/waves.min.css" media="all">
<link rel="stylesheet" href="assets/icon/feather/css/feather.css">
<link rel="stylesheet" href="assets/icon/icofont/css/icofont.css">
<link rel="stylesheet" href="assets/icon/font-awesome/css/font-awesome.min.css">
<link rel="stylesheet" href="assets/css/style.css">
<link rel="stylesheet" href="assets/css/jquery.dataTables.min.css">

<?php
include("script_funciones.php");
include('db___cn.php');
$mysqli=conex_db_mysql();
$docente="SELECT IdDocente,Apellidos,Nombres,UrlFoto
              FROM tb_docentes 
              WHERE IdDocente='".$_SESSION['IdDoc']."'";
$rs=$mysqli->query($docente);
$fila_docente=mysqli_fetch_array($rs);

 $listar_convocatorias="SELECT IdBolsaLaboral,Titulo,Sueldo,FechaLimite,EstadoConvocatoria 
                        FROM tb_bolsa_laboral WHERE EstadoConvocatoria='Disponible'";
 $rs_convocatorias=$mysqli->query($listar_convocatorias);
mysqli_close($mysqli);
?>
</head>
<body>

<div class="loader-bg">
     <div class="loader-bar"></div>
</div>

<div id="pcoded" class="pcoded">
     <div class="pcoded-overlay-box"></div>
<div class="pcoded-container navbar-wrapper">
	
	<nav class="navbar header-navbar pcoded-header">
		<div class="navbar-wrapper">
			<div class="navbar-logo">
				<?php logo(); ?>	
			</div>
			<div class="navbar-container container-fluid">
			    <?php menuSuperior($fila_docente['Nombres'],$fila_docente['UrlFoto']); ?>
			</div>
		</div>
	</nav>

<div class="pcoded-main-container"><!-- inicio pcoded-main-container -->
  <div class="pcoded-wrapper"><!-- inicio pcoded-wrapper -->
	<nav class="pcoded-navbar">
	  <div class="nav-list">
	     <div class="pcoded-inner-navbar main-menu">
	        <div class="pcoded-navigation-label">Panel Navegaci&#243;n</div>
	          <?php  MenuPrincipal(); ?>
	     </div>
	  </div>
	</nav>

<div class="pcoded-content"><!-- inicio pcoded-content -->

	<div class="page-header card"> <!-- inicio page-header card - encabezado -->
		<div class="row align-items-end">
				<div class="col-lg-4">
				  
				</div>
				<div class="col-lg-8">
					<div class="page-header-breadcrumb">
							<ul class=" breadcrumb breadcrumb-title">
								<li class="breadcrumb-item">
								<a href="principal.php"><i class="feather icon-home"></i></a>
								</li>
								<li class="breadcrumb-item">
								<a href="#">Bolsa Laboral</a>
								</li>
								<li class="breadcrumb-item">
								 <a href="#">Ver Convocatorias</a>
								</li>
							</ul>
					</div>
				</div>
		</div>
	</div><!-- fin page-header card - encabezado -->

	<div class="pcoded-inner-content"><!-- inicio pcoded-inner-content - contenido dinamico -->
		<div class="main-body">
			<div class="page-wrapper">
                <div class="card">
					<div class="card-header bg-primary">
					  <h5>Lista de ofertas laborales </h5>
					</div>
					<div class="card-block">
					  <div class="table-responsive">
						<table id="tb_convocatorias" class="display" style="width:100%">
								<thead>
								<tr>
									<th>N&#176;</th>
									<th>T&#237;tulo Convocatoria</th>
									<th>Sueldo</th>
									<th>Fecha L&#237;mite</th>
									<th>Condici&#243;n Convocatoria</th>
									<th>Acciones</th>
								 </tr>
							</thead>
							<tbody>
								<?php
								 $contador=1;
				                while($fila_convocatoria=mysqli_fetch_array($rs_convocatorias))
				                { $fecha_limite = new DateTime($fila_convocatoria['FechaLimite']);
								 echo'<tr>';
					                  echo'<td>'.$contador.'</td>';
					                  echo'<td>'.$fila_convocatoria['Titulo'].'</td>';
					                  echo'<td>'.$fila_convocatoria['Sueldo'].'</td>';
					                  echo'<td>'.$fecha_limite->format('d-m-Y').'</td>';
					                  echo'<td>'.$fila_convocatoria['EstadoConvocatoria'].'</td>';
					                  echo'<td>
		                                   <a href="verDetallesOfertaLaboral.php?id='.base64_encode($fila_convocatoria['IdBolsaLaboral']).'" class="btn btn-outline-primary">Ver</a>  
					                      </td>';
					             echo'</tr>';
					                $contador++;
								}
								?>
							</tbody>
						</table>
					  </div>
		          </div>
		          <div class="card-footer">
	              </div>
                </div>
			</div>
		</div>
	</div><!-- fin pcoded-inner-content - contenido dinamico -->
</div> <!-- fin pcoded-content -->

</div><!-- fin pcoded-wrapper -->

</div> <!-- fin pcoded-main-container -->

</div>
</div>

<script src="bower_components/jquery/js/jquery.min.js"></script>
<script src="bower_components/popper/js/popper.min.js"></script>
<script src="bower_components/bootstrap/js/bootstrap.min.js"></script>
<script  src="bower_components/jquery-slimscroll/js/jquery.slimscroll.js"></script>
<script src="assets/pages/waves/js/waves.min.js"></script>
<script src="assets/js/pcoded.min.js"></script>
<script src="assets/js/vertical/vertical-layout.min.js"></script>
<script src="assets/js/script.js"></script>
<script src="js/jquery.dataTables.min.js"></script>
<script type="text/javascript">
	new DataTable('#tb_convocatorias', {
    info: false,
    ordering: false,
    paging: true,
    responsive: true,language: {
                    "url": "//cdn.datatables.net/plug-ins/1.13.4/i18n/es-ES.json",
                    "paginate": {
                        "previous": "<<",
                        "next": ">>",
                        "first": "<",
                        "last": ">"
                    },
                },
});
</script>
</body>
</html>
<?php
}
else
{ 
echo "Error Ud. Debe Iniciar Sesion.................";
}
?>
