php - 使用 Laravel Eloquent ORM 实现 MySQL Spatial 函数

Question

查询 1:

"SELECT * from search_table WHERE column>=4"

'Query1' 的 Eloquent ORM 实现

$searchResults = SearchTempTable::select(*);

$searchResults = $searchResults->where('column', '>=', 4);

查询 2:

"SELECT * FROM search_table WHERE ST_Intersects(column, geomfromtext( 'POLYGON(($point1X $point1Y, $point2X $point2Y, $point3X $point3Y,$point4X $point4Y,$point1X $point1Y))'))"

“查询 2”如何在 Eloquent ORM 中实现？

Answer 1

只有 raw 语句适用于此。

$bindings = [$point1X, $point1Y, ... ];

SearchTempTable::whereRaw(
 "ST_Intersects(column, geomfromtext( 'POLYGON((? ?, ? ?, ? ?, ? ?, ? ?))' ))",
  $bindings
)->get();