public function historico($id) { $this->idAlu = $id; Session::put('idAlu', $this->idAlu); $alunoConteudo = Aluno::where('id', $id)->lists('nome_alu', 'id'); $DisciplinaConteudo = Disciplina::select('componente_curricular_ccr.id AS id_ccr', 'componente_curricular_ccr.nome_ccr AS nome_ccr')->leftJoin('componente_curricular_ccr', 'componente_curricular_ccr.id', '=', 'disciplina_dis.id_ccr_dis')->lists('nome_ccr', 'id_ccr'); //SELECT count(status_his) FROM `historico_his` LEFT JOIN disciplina_dis ON disciplina_dis.id = id_dis_his WHERE id_alu_his = 1 GROUP BY status_his //SELECT count(status_his) AS status_his FROM `historico_his` WHERE id_alu_his = 1 and status_his = 1 $countAprovDis = Historico::select(DB::raw('COUNT(status_his) AS cursadas'))->where('id_alu_his', $id)->where('status_his', 1)->get(); $countTotalDis = Historico::select(DB::raw('COUNT(id_dis_his) AS total_dis'))->where('id_alu_his', $id)->get(); /*$perPage = 10; $skip = $perPage; $photos = Photo::take($perPage)->skip($skip)->get()->toArray();*/ $historico = Historico::select('ccr.id AS id_ccr', 'ccr.nome_ccr AS nome_ccr', 'historico_his.id AS id_his', 'historico_his.status_his AS status_his', 'historico_his.id_alu_his AS id_alu_his', 'historico_his.ano_his AS ano_his', 'ddi.id AS id_dis', 'ddi.semestre_dis AS semestre_dis', 'aluno_alu.nome_alu AS nome_alu', 'aluno_alu.id AS id_alu')->leftJoin('aluno_alu', 'aluno_alu.id', '=', 'historico_his.id_alu_his')->leftJoin('componente_curricular_ccr AS ccr', 'ccr.id', '=', 'historico_his.id_dis_his')->leftJoin('disciplina_dis AS ddi', 'ddi.id', '=', 'historico_his.id_dis_his')->where('historico_his.id_alu_his', $id)->orderBy('ddi.semestre_dis', 'asc')->paginate(10); return View::make('historico.index', array('historico' => $historico, 'alunoConteudo' => $alunoConteudo, 'DisciplinaConteudo' => $DisciplinaConteudo, 'countAprovDis' => $countAprovDis, 'countTotalDis' => $countTotalDis)); }
Route::any('/usuario/senha', 'UsuarioController@senha'); Route::post('/usuario/logout', 'UsuarioController@logout'); Route::resource('/usuario', 'UsuarioController'); Route::controller('/usuario', 'UsuarioController'); Route::get('/aluno/search', 'AlunoController@getSearch'); Route::resource('/ocorrencia/update', 'OcorrenciaController@update'); Route::resource('/ocorrencia', 'OcorrenciaController'); Route::controller('/ocorrencia', 'OcorrenciaController'); // Route::controller('/aluno', 'AlunoController'); Route::any('/aluno/index', 'AlunoController@index'); Route::resource('/aluno', 'AlunoController'); Route::controller('/aluno', 'AlunoController'); Route::resource('/turma', 'TurmaController'); Route::controller('/turma', 'TurmaController'); Route::resource('/curso', 'CursoController'); Route::controller('/curso', 'CursoController'); }); // Ajax Route::get('/getalunos', function () { $term = Request::all('term')['term']; $alunos = Aluno::where('nome', 'LIKE', '%' . $term . '%')->get(); $result = array_pluck($alunos, 'nome', 'matricula'); return Response::json($result); }); Route::get('/search', function () { $term = Request::all()['term']; $alunos = Aluno::where('nome', 'LIKE', '%' . $term . '%')->with(['turma' => function ($query) use($term) { $query->where('sigla', 'LIKE', '%' . $term . '%')->orWhere('descricao', 'LIKE', $term); }])->get(); return Response::json($alunos); });