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'); } }