public function filtrarPendentes()
{
$aluno = new App\Aluno();
$filtrarPor = Input::get('filtrarPor');
$filtro = Input::get('filtro');
$alunosPendentesFiltro = $aluno->where('pendente', '=', '1')->where($filtrarPor, 'LIKE', "%{$filtro}%")->paginate(10);
$numRegistrosPendentes = $alunosPendentesFiltro->count();
return view('alunos.controlePendentes')->with(['alunosPendentes' => $alunosPendentesFiltro, 'numRegistrosPendentes' => $numRegistrosPendentes, 'ascDesc' => 'asc', 'filtrarPor' => $filtrarPor, 'filtro' => $filtro]);
}
public function getJsonAlunos(Aluno $alunos, Request $requests)
{
if ($requests->has("term")) {
$result = $alunos->where("alu_nome", "like", "%" . $requests->term . "%")->get();
} else {
$result = $alunos->whereNotExists(function ($query) {
$query->select(DB::raw(1))->from('mensalidade')->whereRaw('mensalidade.mes_alu_id = aluno.id');
})->get();
//$result = $alunos->all();
}
// dd($requests->term);
$list = [];
foreach ($result as $key => $value) {
$list[$key]['id'] = $value->id;
$list[$key]['text'] = $value->alu_nome;
}
// $teste = json_encode($list);
//return "{ \"results\": " . json_encode($list) . "}";
// return json_encode($list);
return $list;
}
