Exemplo n.º 1
0
 /**
  * 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);
 }
Exemplo n.º 2
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);
 }