Trying to convert this SQL query to Laravel Query
$query = "SELECT *, ( 3959 * acos( cos( radians('$lat') ) *
cos( radians( latitude ) ) *
cos( radians( longitude ) -
radians('$lon') ) +
sin( radians('$lat') ) *
sin( radians( latitude ) ) ) )
AS distance FROM yourtable HAVING distance < '$miles' ORDER BY distance ASC LIMIT 0, 5";
Heres what I did but I guess I really don't have any idea about this.
$stores = DB::table('stores')
->select( DB::raw( 'stores.*, ( ( 3959 * acos( cos( radians('.$lat.') ) *
cos( radians( stores.latitude ) ) *
cos( radians( stores.longitude ) -
radians('.$lon.') ) +
sin( radians('.$lat.') ) *
sin( radians( stores.latitude ) ) ) )
as distance' ) )
->orderBy('distance')->where('domain',$domain->appEnv)->get();