require("../admin/config.php");
// bienvenidos
$sql = "SELECT * FROM `notas` WHERE idcategoria=1 AND `CLAVE` = 'BIEN'" ;
$result = mysqli_query($link_mysql,$sql);
$row = mysqli_fetch_assoc($result) ;
$idnota = $row['idnota'];
/*
$imagen= "../imagenes/notas/".$idnota.'.jpg';
if (!file_exists($imagen))
$imagen= '';
$imagen_chica= "../imagenes/notas/chicas/".$idnota.'.jpg';
if (!file_exists($imagen_chica))
$imagen_chica= '';
*/
$bienvenidos_titulo=$row['titulo'];
$bienvenidos_texto= $row['texto2'];
// STEM
$sql = "SELECT * FROM `notas` WHERE idcategoria=1 AND `CLAVE` = 'STEM'" ;
$result = mysqli_query($link_mysql,$sql);
$row = mysqli_fetch_assoc($result) ;
$stem_titulo=$row['titulo'];
$stem_texto= nl2br($row['texto2']);
// EXT
$sql = "SELECT * FROM `notas` WHERE idcategoria=1 AND `CLAVE` = 'EXT'" ;
$result = mysqli_query($link_mysql,$sql);
$row = mysqli_fetch_assoc($result) ;
$ext_titulo=$row['titulo'];
$ext_texto= nl2br($row['texto2']);
// PROC
$sql = "SELECT * FROM `notas` WHERE idcategoria=14 AND `CLAVE` = 'PROC'" ;
$result = mysqli_query($link_mysql,$sql);
$row = mysqli_fetch_assoc($result) ;
$proc_titulo=$row['titulo'];
$proc_texto= nl2br( $row['texto2']);
// SERV
$sql = "SELECT * FROM `notas` WHERE idcategoria=1 AND `CLAVE` = 'SERV'" ;
$result = mysqli_query($link_mysql,$sql);
$row = mysqli_fetch_assoc($result) ;
$serv_titulo=$row['titulo'];
$serv_texto= nl2br( $row['texto2']);
///////////////// OFERTAS LABORALES
$curl = curl_init();
curl_setopt_array($curl, array(
CURLOPT_URL => "https://api.recooty.com/api/v1/jobs/451fb934c780fecbf584d33f8e843d61/list",
CURLOPT_RETURNTRANSFER => true,
CURLOPT_ENCODING => "",
CURLOPT_MAXREDIRS => 10,
CURLOPT_TIMEOUT => 30,
CURLOPT_HTTP_VERSION => CURL_HTTP_VERSION_1_1,
CURLOPT_CUSTOMREQUEST => "GET",
CURLOPT_SSL_VERIFYHOST => 0,
CURLOPT_SSL_VERIFYPEER => 0,
));
$response = curl_exec($curl);
$err = curl_error($curl);
curl_close($curl);
if ($err) {
echo "cURL Error #:" . $err;
} else {
$result1 = json_decode($response);
$total_ofertas = $result1->job_count;
for ($i = 0; $i < $total_ofertas; $i++)
{
$titulo[ $i] = $result1->jobs[$i]->title ;
$ubicacion[ $i] = $result1->jobs[$i]->city.','.$result1->jobs[$i]->country ; //.','.$result1->jobs[$i]->state;
$tipo[ $i] = $result1->jobs[$i]->employment_type;
$experiencia[ $i] = $result1->jobs[$i]->experience;
$descripcion[ $i] = $result1->jobs[$i]->description;
$aplicar[ $i] = $result1->jobs[$i]->apply_url_external;
$link_detallado[ $i] = $result1->jobs[$i]->details_url_external;
$rubro[ $i] = $result1->jobs[$i]->industry;
$fecha[ $i] = $result1->jobs[$i]->date;
$newDate = date("d-m-Y", strtotime( $fecha[ $i]));
$fecha[ $i] = $newDate;
// echo($titulo[$total_ofertas-$i].'
');
// echo('Location:'.$ubicacion.'
');
// echo('Employment Type:'.$tipo.'
');
// echo('Experience :'.$experiencia.'
');
// echo($descripcion.'
');
}
}
?>