/**
  * Display a listing of the resource.
  *
  * @return \Illuminate\Http\Response
  */
 public function index(Request $request)
 {
     $url = $request->get('q');
     // var_dump($url);
     // exit();
     if (is_null($url) || $url == "") {
         $roadshow_registrations = RoadshowRegistration::orderBy('id', 'desc')->get();
     } else {
         $roadshow_registrations = RoadshowRegistration::where("raodshow", $url)->get();
     }
     // Excel::load('import.xls', function($reader) {
     //     // Loop through all rows
     //     $reader->each(function($row) {
     //     $roadshow_registration = new RoadshowRegistration(array(
     //                 'name'  =>        $row->name,
     //                 'email'  =>       $row->email,
     //                 'phone'  =>       $row->phone,
     //                 'position'  =>    $row->position,
     //                 'company'  =>     $row->company,
     //                 'session'  =>     $row->session,
     //                 'raodshow'  =>    $row->raodshow,
     //               ));
     //            $roadshow_registration->save();
     //     });
     // });
     // exit();
     return view('admin.registration-roadshows.index', compact('roadshow_registrations'));
 }