如何將 sql 查詢轉(zhuǎn)換為 Larvel 查詢生成器格式這是查詢"SELECT `id`, `name`, `phone`, `latitude`, `longitude`, SQRT( POW(69.1 * (`latitude` - 24.900363), 2) + POW(69.1 * (67.099760 - `longitude`) * COS(`latitude` / 57.3), 2)) AS `distance` FROM `users` HAVING `distance` < 25 ORDER BY `distance`";
1 回答
慕萊塢森
TA貢獻1810條經(jīng)驗 獲得超4個贊
你可以像這樣試一試
$results = Users::select(['id','name','phone','latitude','longitude', DB::raw('SQRT( POW(69.1 * (`latitude` - 24.900363), 2) + POW(69.1 * (67.099760 - `longitude`) * COS(`latitude` / 57.3), 2)) AS distance')])->havingRaw('distance < 25')->OrderBy('distance')->get();- 1 回答
- 0 關(guān)注
- 91 瀏覽
添加回答
舉報
0/150
提交
取消