public function getCursosDT() { $curso = new Curso(); if ($_GET['search']['value'] != '') { $num_total = $curso->searchDT($_GET['columns'], $_GET['search']['value'])->count(); $cursos = $curso->searchDT($_GET['columns'], $_GET['search']['value'])->orderBy($_GET['columns'][$_GET['order'][0]['column']]['data'], $_GET['order'][0]['dir'])->skip($_GET['start'])->take($_GET['length']); } else { $num_total = $curso->count(); $cursos = $curso->orderBy($_GET['columns'][$_GET['order'][0]['column']]['data'], $_GET['order'][0]['dir'])->skip($_GET['start'])->take($_GET['length']); //$this->lastSQL(); } $cursos = $cursos->select('id', 'nombre_curso', 'cod_interno', 'num_expediente', 'fecha_inicio', 'fecha_final')->get(); //$this->lastSQL(); foreach ($cursos as $clave => $curso) { $cursos[$clave]['DT_RowId'] = 'row_' . $curso->id; } $return['draw'] = Input::get('draw'); $return['data'] = $cursos; $return['recordsTotal'] = $num_total; $return['recordsFiltered'] = $num_total; return $return; }