/** * Display a listing of the resource. * * @return Response */ public function index() { if (\Input::get('all') == 1) { ini_set('memory_limit', '-1'); ini_set('max_execution_time', 0); if (\Input::get('geo_only') == 1) { $projects = Project::select('id', 'geo_lat', 'geo_lng')->hasGeo()->get(); } else { $projects = Project::all(array('id', 'geo_lat', 'geo_lng')); } } else { if (\Input::get('min') == 1) { if (\Input::get('geo_only') == 1) { $projects = Project::select('id', 'geo_lat', 'geo_lng')->hasGeo()->paginate(10); } else { $projects = Project::select('id', 'geo_lat', 'geo_lng')->paginate(10); } } else { if (\Input::get('geo_only') == 1) { $projects = Project::hasGeo()->paginate(10); } else { $projects = Project::paginate(10); } } } return response()->json(array('error' => false, 'projects' => $projects->toArray()), 200); }
public function showMap() { $projects = \DB::table('projects')->take(10)->get(); $projects_all = Project::select('id', 'geo_lat', 'geo_lng')->hasGeo()->get(); $categories = Category::geocoded(); foreach ($categories as $key => $category) { $pivot = \DB::table('project_category')->where('category_id', $category->id)->lists('project_id'); $categories[$key] = array_add($categories[$key], 'projects_pivot', $pivot); } $data = compact('projects', 'projects_all', 'categories'); return view('home.map', $data); }