php - Laravel 5 Eloquent 地查询半正矢公式

Question

我有这个查询

select tbl_container.*, 
       ( 6371 * acos( cos( radians(17.7427643) ) 
              * cos( radians( tbl_locations.latitude ) ) 
              * cos( radians( tbl_locations.longitude ) - radians(83.3277787) ) 
              + sin( radians(17.7427643) ) 
              * sin( radians( tbl_locations.latitude ) ) ) ) AS distance 
from tbl_locations,tbl_container  
where tbl_container.`status` = 1 
and tbl_container.location_id=tbl_locations.id having distance<4 order by distance asc

为此，我有两个模型容器，位置

如何将此查询写入 laravel 5 eloquent...

Answer 1

我没有得到任何 Eloquent 模型查询所以我使用这样的查询

DB::select(DB::raw(' select tbl_container.*, 
      ( 6371 * acos( cos( radians(17.7427643) ) 
             * cos( radians( tbl_locations.latitude ) ) 
             * cos( radians( tbl_locations.longitude ) - radians(83.3277787) ) 
             + sin( radians(17.7427643) ) 
             * sin( radians( tbl_locations.latitude ) ) ) ) AS distance 
from tbl_locations,tbl_container  
where tbl_container.`status` = 1 
and tbl_container.location_id=tbl_locations.id having distance<4 order by distance asc   '));

并使用此数据库外观来执行此原始查询

use Illuminate\Support\Facades\DB;