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