$results = \DB::select(DB::raw('SELECT id, ( 3959 * acos( cos( radians('
. $order->delivery_lattitude . ') ) * cos( radians( lat ) ) * cos(
radians( lon ) - radians(' . $order->delivery_logitude . ') ) + sin(
radians(' . $order->delivery_lattitude . ') ) * sin( radians(lat) ) )
) AS distance FROM rider_location HAVING distance < ' . $distance . '
ORDER BY distance'));
No comments:
Post a Comment