如何解决Laravel地理空间数据处理的复杂性？mstaack/laravel-postgis助你轻松驾驭！

Float

stores

latitude

longitude

<pre class="brush:php;toolbar:false;">SELECT *,        (6371 * acos(            cos(radians(?)) * cos(radians(latitude)) * cos(radians(longitude) - radians(?)) +            sin(radians(?)) * sin(radians(latitude))        )) AS distance FROM stores ORDER BY distance LIMIT 10;

<pre class="brush:php;toolbar:false;">composer require mstaack/laravel-postgis

config/app.php

MStaackLaravelPostgisDatabaseServiceProvider

<pre class="brush:php;toolbar:false;">CREATE EXTENSION postgis;

Blueprint

PLUG AI

AI辅助包装设计！并对包装方案生成分析评估

13

查看详情

<pre class="brush:php;toolbar:false;">php artisan make:model location -m

MStaackLaravelPostgisSchemaBlueprint

<pre class="brush:php;toolbar:false;"><?php  use IlluminateDatabaseMigrationsMigration; use MStaackLaravelPostgisSchemaBlueprint; // 注意这里的命名空间 use IlluminateSupportFacadesSchema;  class CreateLocationsTable extends Migration {     public function up()     {         Schema::create('locations', function (Blueprint $table) {             $table->increments('id');             $table->string('name');             $table->string('address')->unique();             $table->point('location'); // GEOGRAPHY POINT 列，默认 SRID 4326             $table->point('store_entrance', 'GEOMETRY', 27700); // GEOMETRY POINT 列，自定义 SRID 27700             $table->polygon('delivery_area'); // GEOGRAPHY POLYGON 列             $table->timestamps();         });     }      public function down()     {         Schema::dropIfExists('locations');     } }

GEOGRAPHY

GEOMETRY

app/Models/Location.php

<pre class="brush:php;toolbar:false;"><?php  namespace AppModels;  use IlluminateDatabaseEloquentModel; use MStaackLaravelPostgisEloquentPostgisTrait; use MStaackLaravelPostgisGeometriesPoint; use MStaackLaravelPostgisGeometriesPolygon; use MStaackLaravelPostgisGeometriesLineString; // 如果需要  class Location extends Model {     use PostgisTrait;      protected $fillable = [         'name',         'address',     ];      // 声明哪些字段是 PostGIS 几何类型     protected $postgisFields = [         'location',         'store_entrance',         'delivery_area',     ];      // 为每个 PostGIS 字段指定其几何类型和 SRID     protected $postgisTypes = [         'location' => [             'geomtype' => 'geography',             'srid' => 4326         ],         'store_entrance' => [             'geomtype' => 'geometry',             'srid' => 27700 // 自定义 SRID         ],         'delivery_area' => [             'geomtype' => 'geography',             'srid' => 4326         ]     ];      // ... 其他模型方法 }

<pre class="brush:php;toolbar:false;">use AppModelsLocation; use MStaackLaravelPostgisGeometriesPoint; use MStaackLaravelPostgisGeometriesPolygon; use MStaackLaravelPostgisGeometriesLineString;  // 创建一个点对象 (纬度, 经度) $point = new Point(34.052235, -118.243683); // 洛杉矶市中心  // 创建一个多边形对象 (由一个或多个 LineString 组成) $linestring = new LineString([     new Point(0, 0),     new Point(0, 1),     new Point(1, 1),     new Point(1, 0),     new Point(0, 0) // 闭合多边形 ]); $polygon = new Polygon([$linestring]);  // 保存数据 $store = new Location(); $store->name = '我的商店'; $store->address = '某某街某某号'; $store->location = $point; $store->store_entrance = new Point(34.052230, -118.243670); // 另一个点 $store->delivery_area = $polygon; $store->save();  // 读取数据 $retrievedStore = Location::first(); dump($retrievedStore->location); // 返回 MStaackLaravelPostgisGeometriesPoint 实例 dump($retrievedStore->location instanceof Point); // true  // 你可以直接访问点的坐标 echo "纬度: " . $retrievedStore->location->getLat(); echo "经度: " . $retrievedStore->location->getLng();