/** * 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); } }