public function getPostulantesEvaluacionByVacante($vacante)
{
$sql = "select u.id as usuario_id, v.id as vacante_id , et.id as etapa_id, u.nombres, u.apellidos, u.numero_identificacion, v.titulo, et.nombre as etapa, e.valor, e.observacion\n\t\t\t\tfrom vacante as v \n\t\t\t\tinner join postulacion as p on p.vacante_id = v.id\n\t\t\t\tinner join usuario as u on p.postulante_id = u.id \n\t\t\t\tinner join evaluacion as e on e.postulacion_id = p.id\n\t\t\t\tinner join etapa as et on et.id = e.etapa_id\n\t\t\twhere v.id = {$vacante} or 999 = {$vacante}\n\t\torder by u.id, v.id, et.id";
$model = new model();
$result = $model->runSql($sql);
return $model->getRows($result);
}
public function deleteArea()
{
$area = $_GET['id'];
$sql = "update area set eliminado = 1 where id = " . $area;
$model = new model();
$result = $model->runSql($sql);
}
public function deleteCategoria()
{
$categoria = $_GET['id'];
$sql = "delete from categoria where id = " . $categoria;
$model = new model();
$result = $model->runSql($sql);
}
/**
* Obtiene Categorias
*/
public function getCategoriaList()
{
$model = new model();
$sql = "select * from categoria ";
$result = $model->runSql($sql);
return $model->getRows($result);
}
public function getUsuarioByCedula($cedula)
{
$model = new model();
$sql = "select * from usuario where numero_identificacion = " . $cedula;
$result = $model->runSql($sql);
$resultArray = $model->getRows($result);
return $resultArray[0];
}
public function obtenerUsuario($usuario)
{
$model = new model();
$sql = "Select * from usuario where numero_identificacion = " . $usuario;
$result = $model->runSql($sql);
$resultArray = $model->getRows($result);
return $resultArray[0];
}
public function getRespuestas($desempenioId)
{
$model = new model();
$sql = "SELECT * FROM respuesta as r\t\t\t\t\n\t\t\t\twhere r.desempenio_id = " . $desempenioId;
$result = $model->runSql($sql);
return $model->getRows($result);
}
public function getEtapaById($id)
{
$model = new model();
$sql = "select * from etapa where id = " . $id;
$result = $model->runSql($sql);
return $model->getRows($result);
}
public function getPais($pais_id)
{
$model = new model();
$sql = "select * from pais where id = " . $pais_id;
$result = $model->runSql($sql);
$resultArray = $model->getRows($result);
$resultArray = $resultArray[0];
return $resultArray;
}
public function getAreas()
{
$model = new model();
$sql = "select * from area where eliminado = 0";
$result = $model->runSql($sql);
return $model->getRows($result);
}
public function getEmailByCI($user)
{
$model = new model();
$sql = "select * from usuario where username = "******" and eliminado = 0";
$result = $model->runSql($sql);
$resultArray = $model->getRows($result);
if (count($resultArray) > 0) {
return $resultArray[0];
}
return null;
}