如何解决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;

mstaack/laravel-postgis

mstaack/laravel-postgis

clickbar/laravel-magellan

mstaack/laravel-postgis

mstaack/laravel-postgis

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

config/app.php

MStaack\LaravelPostgis\DatabaseServiceProvider

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

Blueprint

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

MStaack\LaravelPostgis\Schema\Blueprint

<pre class="brush:php;toolbar:false;"><?php

use Illuminate\Database\Migrations\Migration;
use MStaack\LaravelPostgis\Schema\Blueprint; // 注意这里的命名空间
use Illuminate\Support\Facades\Schema;

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');
    }
}

point

polygon

GEOGRAPHY

GEOMETRY

app/Models/Location.php

<pre class="brush:php;toolbar:false;"><?php

namespace App\Models;

use Illuminate\Database\Eloquent\Model;
use MStaack\LaravelPostgis\Eloquent\PostgisTrait;
use MStaack\LaravelPostgis\Geometries\Point;
use MStaack\LaravelPostgis\Geometries\Polygon;
use MStaack\LaravelPostgis\Geometries\LineString; // 如果需要

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 App\Models\Location;
use MStaack\LaravelPostgis\Geometries\Point;
use MStaack\LaravelPostgis\Geometries\Polygon;
use MStaack\LaravelPostgis\Geometries\LineString;

// 创建一个点对象 (纬度, 经度)
$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); // 返回 MStaack\LaravelPostgis\Geometries\Point 实例
dump($retrievedStore->location instanceof Point); // true

// 你可以直接访问点的坐标
echo "纬度: " . $retrievedStore->location->getLat();
echo "经度: " . $retrievedStore->location->getLng();

mstaack/laravel-postgis

mstaack/laravel-postgis

clickbar/laravel-magellan

mstaack/laravel-postgis