Example #1
0
 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);
 }