Beispiel #1
0
 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;
 }