/** * Display search results of studios * * @return View */ public function studiosSearch(Request $request) { $lat = $request->input('lat'); $long = $request->input('long'); $studios = Studio::select(DB::raw("*,\n ( 6371 * acos( cos( radians(?) ) *\n cos( radians( latitude ) )\n * cos( radians( longitude ) - radians(?)\n ) + sin( radians(?) ) *\n sin( radians( latitude ) ) )\n ) AS distance"))->having("distance", "<", 25)->orderBy("distance")->setBindings([$lat, $long, $lat])->where('approved', 1)->with('artists')->get(); //dd($studios); return $studios; }