public function informe_final()
{
require_once 'Management.php';
$link = new Management();
if (isset($_POST['IDCON_']) && $_POST['CONTOKEN'] == $link->tokengenerate($_POST['IDCON_'])) {
$CON_ID = $_POST['IDCON_'];
$this->view->data = $link->datos_concurso($CON_ID, 'F');
$aspirantes = $link->model->getAspirantesbyCONID($CON_ID);
$baseconcurso = $this->view->data['fasesConcurso'];
$meritos = array();
$oposicion = array();
foreach ($baseconcurso as $key => $value) {
if ($value[8] == 'M') {
array_push($meritos, array($value[7], $value[3], $value[0]));
} else {
if ($value[8] == 'O') {
array_push($oposicion, array($value[7], $value[3], $value[0]));
}
}
}
$selectROW = "";
$stringMeritos = "";
foreach ($meritos as $key => $value) {
$stringMeritos .= " , truncate(calificacion_ASP_BCO(ASP_ID," . $value[2] . "),2)";
}
$selectROW .= "nomb_aspbyID(ASP_ID)" . $stringMeritos . ', truncate(fobtsummerops(ASP_ID,CON_ID,"M"),2)';
$stringOposicion = "";
foreach ($oposicion as $key => $value) {
$stringOposicion .= " ,truncate (calificacion_ASP_BCO(ASP_ID," . $value[2] . "),2)";
}
$selectROW .= $stringOposicion . ',truncate(fobtsummerops(ASP_ID,CON_ID,"O"),2) ,truncate(fobtsummerops(ASP_ID,CON_ID,"%"),2) ';
array_push($meritos, array('Subtotal', 50));
array_push($oposicion, array('Subtotal', 50));
$this->view->data += ['meritos' => $meritos];
$this->view->data += ['oposicion' => $oposicion];
$this->view->data += ['AspirantesROW' => $this->model->calificacionProcesada($selectROW, $CON_ID)];
//var_dump( $this->view->data);
// $this->view->data2=$link->model->getAspirantesbyCONIDBCONID();
$this->view->render($this, 'informe_final');
}
}
