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