/** * Display a listing of the resource. * * @return \Illuminate\Http\Response */ public function index(Request $request) { $cvs = Curriculum::orderBy('created_at', 'desc'); if ($request->has('term')) { $cvs->whereRaw(" concat(curricula.nombre,' ',curricula.apellido,' ',curricula.email,' ',curricula.puesto,' ',curricula.domicilio, ' ',curricula.localidad, ' ',curricula.provincia, ' ',curricula.dni) like ?", ['%' . $request->get('term') . '%']); } return view('bdt-consulta', ["cvs" => $cvs->paginate(25), "term" => $request->get('term')]); }