public function search(Request $request)
{
$query = Counselor::query();
if (Input::has('name')) {
$name = Input::get('name');
$query->where('name', 'LIKE', "%{$name}%")->orderBy('name')->paginate(10);
}
//1000005752
//1000001792
if (Input::has('code_bar')) {
$code_bar = Input::get('code_bar');
if (strlen($code_bar) > 10) {
$code_bar = substr(Input::get('code_bar'), 1, -1);
}
$codeBar = DB::table('code_bars')->where('serial', $code_bar)->first();
if (isset($codeBar)) {
$accreditation = DB::table('accreditation')->where('code_bar_id', $codeBar->id)->first();
if (isset($accreditation)) {
$query->where('id', '=', $accreditation->counselor_id)->orderBy('name')->paginate(10);
} else {
Session::flash('error', 'Conselheiro não encontrado.');
return redirect('counselors');
}
} else {
Session::flash('error', 'Conselheiro não encontrado.');
return redirect('counselors');
}
}
$counselors = $query->paginate(10);
return view('counselors.index', compact('counselors'));
}
/**
* Display a listing of the resource.
*
* @return Response
*/
public function index(Request $request)
{
$counselors = Counselor::query();
$counselors = $counselors->paginate(10);
return view('reports.index', compact('counselors'));
}
