Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $users = User::orderBy('name', 'ASC')
- ->select ('users.name', 'last_name', 'expertise', 'e.name as e_name',
- DB::raw('(acos(sin(radians(-46.626619)) * sin(radians(l.latitude)) + cos(radians(-46.626619)) * cos(radians(l.latitude)) * cos(radians(-57.047053) - radians(l.longitude))) * 6378) AS distancia'))
- ->leftJoin('user_expertises as uex', 'users.id', '=', 'uex.user_id')
- ->leftJoin('user_enterprises as ue', 'users.id', '=', 'ue.user_id')
- ->leftJoin('enterprises as e', 'ue.enterprise_id', '=', 'e.id')
- ->leftJoin('locations as l', 'users.id', '=', 'l.user_id')
- ->having('distancia', '<', '10000')
- ->orderBy('distancia', 'ASC')
- ->get();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement