/**
  * Display a listing of the resource.
  *
  * @return Response
  */
 public function index()
 {
     if (Request::ajax()) {
         $query = Input::get('query');
         //return Response::json($query);
         $vendedores = DB::table('vendedors')->select()->where('nome', 'like', '%' . $query . '%')->orWhere('empresa', 'like', '%' . $query . '%')->orWhere('cidade', 'like', '%' . $query . '%')->get();
         return Response::json($vendedores);
     } else {
         // get all the vendedors
         if (isset($_GET['orderby'])) {
             $vendedores = Vendedor::orderBy($_GET['orderby'])->get();
         } else {
             $vendedores = Vendedor::orderBy('nome')->get();
         }
         // load the view and pass the vendedors
         return View::make('vendedors.index')->with('vendedores', $vendedores);
     }
 }