Guest User

Untitled

a guest
Apr 26th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.44 KB | None | 0 0
  1. $salons = Salon::select('salons.*')
  2. ->selectRaw('( 3959 * acos( cos( radians(?) ) *
  3. cos( radians( lat ) )
  4. * cos( radians( lng ) - radians(?)
  5. ) + sin( radians(?) ) *
  6. sin( radians( lat ) ) )
  7. ) AS distance', [$lat, $lng, $lat])
  8. ->havingRaw("distance < 25")
  9. ->where("category_Id" , "=" , $id)
  10. ->get();
Add Comment
Please, Sign In to add comment