Advertisement
Guest User

Query Problem

a guest
Feb 10th, 2016
66
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 0.66 KB | None | 0 0
  1. $users = User::orderBy('name', 'ASC')
  2.             ->select ('users.name', 'last_name', 'expertise', 'e.name as e_name',
  3.                 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'))
  4.             ->leftJoin('user_expertises as uex', 'users.id', '=', 'uex.user_id')
  5.             ->leftJoin('user_enterprises as ue', 'users.id', '=', 'ue.user_id')
  6.             ->leftJoin('enterprises as e', 'ue.enterprise_id', '=', 'e.id')
  7.             ->leftJoin('locations as l', 'users.id', '=', 'l.user_id')
  8.             ->having('distancia', '<', '10000')
  9.             ->orderBy('distancia', 'ASC')
  10.         ->get();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement