<?php
session_start();
     if( (isset($_SESSION['IdStudent'])) &&($_SESSION['IdStudent']>0))
   {  
?>
<!DOCTYPE html>
<html>
<head>
<title>IESTP-Abancay</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/font-awesome/css/font-awesome.min.css">
<link rel="stylesheet"  href="assets/css/style.css">
<link rel="stylesheet" href="assets/css/wysihtml5.css">
<?php
include("script_funciones.php");
include('db___cn.php');
$mysqli=conex_db_mysql();

$estudiante="SELECT IdEstudiante,Apellidos,Nombres,UrlFoto,IdCarrera
              FROM tb_estudiantes 
              WHERE IdEstudiante='".$_SESSION['IdStudent']."'";
$rs=$mysqli->query($estudiante);
$fila_estudiante=mysqli_fetch_array($rs);

$convocatoria="SELECT IdBolsaLaboral,Titulo,Detalles,RazonSocial,CarreraProfesional,Departamento,Vacantes,TipoHorario,Sueldo,Horario,FechaLimite,TipoEntidad 
                        FROM tb_bolsa_laboral,tb_carrera,tb_departamentos,tb_entidades
                         WHERE tb_bolsa_laboral.IdCarrera=tb_carrera.IdCarrera
                         and tb_bolsa_laboral.IdDepartamento= tb_departamentos.IdDepartamento
                         and tb_bolsa_laboral.IdRazonSocial=tb_entidades.IdRazonSocial
                         and IdBolsaLaboral='".base64_decode($_GET['id'])."'";
 $rs_convocatoria=$mysqli->query($convocatoria);
 $fila_ver_convocatoria=mysqli_fetch_array($rs_convocatoria);

$verificar_postulacion="SELECT IdPostulacion FROM  tb_bolsa_laboral_postulaciones
                         WHERE IdBolsaLaboral=".base64_decode($_GET['id'])." and IdEstudiante=".$fila_estudiante['IdEstudiante'];
$rs_verificar_postulacion=$mysqli->query($verificar_postulacion);
if(mysqli_num_rows($rs_verificar_postulacion)>0)
    {
      $Postulacion='SI';
    }
    else
    {
      $Postulacion='NO';
    }

 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">
        <?php
          MenuSuperior($fila_estudiante['Nombres'],$fila_estudiante['UrlFoto'],$_SESSION['Carrera']);
         ?>
<div class="pcoded-main-container">
  <div class="pcoded-wrapper">
    <?php
       MenuPrincipal();
     ?>
<div class="pcoded-content">
  <div class="page-header card">
      <div class="row align-items-end">
		<div class="col-lg-8">
			
		</div>
		<div class="col-lg-4">
			<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="#">Ofertas Laborales</a>
				</li>
				</ul>
			</div>
		</div>
      </div>
  </div>
<div class="pcoded-inner-content">
<div class="main-body">
<div class="page-wrapper">
<div class="page-body">
	  <div class="card">
			<div class="card-header bg-primary">
			    <h5>Ver Oferta Laboral</h5>
			</div>
		    <div class="card-block b-b-default">
                <div class="row">
                         <div class="col-sm-12">
                          <h4 class="f-14 f-w-600 f-s-italic">T&#237;tulo :</h4>
                           <div class="p-4 mb-2 b-default rounded">
                             <p class="mb-0"><?php echo $fila_ver_convocatoria['Titulo'];?></p>
                           </div>
                         </div>
                      </div>
                      <div class="row">
                         <div class="col-sm-12">
                         <h4 class="f-14 f-w-600 f-s-italic">Detalle :</h4>
                           <div class="p-4 mb-3 b-default rounded">
                                <?php echo $fila_ver_convocatoria['Detalles'];?>
                           </div>
                         </div>
                      </div>
                       <div class="row">
                          <div class="col-sm-8">
                              <h4 class="f-14 f-w-600 f-s-italic">Entidad Solicitante:</h4>
                               <div class="p-2 mb-2 b-default rounded">
                           <p><?php echo $fila_ver_convocatoria['RazonSocial'];?></p>
                         </div>
                           </div>
                           <div class="col-sm-4">
                              <h4 class="f-14 f-w-600 f-s-italic">Tipo de Entidad:</h4>
                               <div class="p-2 mb-2 b-default rounded">
                           <p><?php echo $fila_ver_convocatoria['TipoEntidad'];?></p>
                         </div>
                           </div> 
                        </div>
                        <div class="row">
                             <div class="col-sm-12">
                              <h4 class="f-14 f-w-600 f-s-italic">Dirigido a estudiantes / egresados de:</h4>
                                <div class="p-2 mb-2 b-default rounded">
                                  <p><?php echo $fila_ver_convocatoria['CarreraProfesional'];?></p>
                                </div>
                             </div>
                        </div>          
                        <div class="row">
                             <div class="col-sm-3">
                               <h4 class="f-14 f-w-600 f-s-italic">Ciudad:</h4>
                                 <div class="p-2 mb-2 b-default rounded">
                                   <p><?php echo $fila_ver_convocatoria['Departamento'];?></p>
                                 </div>
                             </div>
                             <div class="col-sm-3">
                              <h4 class="f-14 f-w-600 f-s-italic"># Vacantes:</h4>
                              <div class="p-2 mb-2 b-default rounded">
                                <p><?php echo $fila_ver_convocatoria['Vacantes'];  ?></p>
                              </div>
                             </div>
                             <div class="col-sm-3">
                              <h4 class="f-14 f-w-600 f-s-italic">Sueldo S/. </h4>
                                <div class="p-2 mb-2 b-default rounded">
                                  <p><?php echo $fila_ver_convocatoria['Sueldo'];?></p>
                                </div>
                             </div>
                             <div class="col-sm-3">
                                <h4 class="f-14 f-w-600 f-s-italic">Tipo de Horario:</h4>
                                <?php
                                 if($fila_ver_convocatoria['TipoHorario']=='TC')
                                    {$tipo_horario="TIEMPO COMPLETO";}else{$tipo_horario="TIEMPO PARCIAL";}
                                ?>
                                <div class="p-2 mb-2 b-default rounded">
                                   <p><?php echo $tipo_horario;?></p>
                                </div>
                             </div>
                        </div>
                        <div class="row">
                             <div class="col-sm-9">
                               <h4 class="f-14 f-w-600 f-s-italic">Horario :</h4>
                                 <div class="p-2 mb-2 b-default rounded">
                                   <p><?php echo $fila_ver_convocatoria['Horario'];?></p>
                                 </div>
                             </div>
                             <div class="col-sm-3">
                              <?php $fecha_limite = new DateTime($fila_ver_convocatoria['FechaLimite']); ?>
                                <h4 class="f-14 f-w-600 f-s-italic">Fecha L&#237;mite : </h4>
                                 <div class="p-2 mb-2 b-default rounded">
                                   <p><?php echo $fecha_limite->format('d-m-Y');?></p>
                                 </div>
                             </div>
                        </div>
            </div>
            <div class="card-footer text-center">
              <?php 
                  if($Postulacion=='NO')
                  {?>
                    <a href="postularBolsaLaboral.php?id=<?php echo base64_encode($fila_ver_convocatoria['IdBolsaLaboral']); ?>" class="btn btn-primary">Postular Ahora</a>
                    <a href="ofertasLaborales.php" class="btn btn-secondary"><i class="fa fa-mail-reply"></i>Volver</a>
                  <?php 
                   } 
                   else
                   {
                    echo '<p class="text-success">Ud. ya postul&#243; a esta convocatoria...</p>';
                    echo '<a href="ofertasLaborales.php" class="btn btn-secondary"><i class="fa fa-mail-reply"></i>Volver</a>';
                   }
                  ?>

            	

            </div>  
	  </div>
</div>
</div>
</div>
</div>
</div>

</div>
</div>
</div>
</div>

<script src="bower_components/jquery/js/jquery.min.js"></script>
<script src="bower_components/jquery-ui/js/jquery-ui.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="assets/pages/waves/js/waves.min.js"></script>
<script  src="bower_components/jquery-slimscroll/js/jquery.slimscroll.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.min.js"></script>

</body>
</html>
<?php
}
else
{ 

echo "Error Ud. Debe Iniciar Sesion.................";

}
?>
