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