veronj / laravel-eloquent-spatial
Spatial library for Laravel
Requires
- php: ^8.0
- ext-json: *
- laravel/framework: ^8.0|^9.0
- phayes/geophp: ^1.2
Requires (Dev)
- friendsofphp/php-cs-fixer: ^3.0
- jubeki/laravel-code-style: ^1.0
- nunomaduro/larastan: ^1.0|^2.0
- nunomaduro/phpinsights: ^1.0|^2.0
- orchestra/testbench: ^6.23|^7.0
- phpunit/phpunit: ^9.3
This package is not auto-updated.
Last update: 2024-11-12 22:31:15 UTC
README
Laravel package to work with spatial data types and functions.
This package supports MySQL 5.7 & 8.0 and works on PHP 8 & Laravel 8.
Installation
You can install the package via composer:
composer require matanyadaev/laravel-eloquent-spatial
Quickstart
Generate a new model with a migration file:
php artisan make:model {modelName} --migration
Add some spatial columns to the migration file:
use Illuminate\Database\Migrations\Migration; use Illuminate\Database\Schema\Blueprint; class CreatePlacesTable extends Migration { public function up(): void { Schema::create('places', static function (Blueprint $table) { $table->id(); $table->string('name')->unique(); $table->point('location')->nullable(); $table->polygon('area')->nullable(); $table->timestamps(); }); } public function down(): void { Schema::dropIfExists('places'); } }
Run the migration:
php artisan migrate
Fill the $fillable
and $casts
arrays and add custom eloquent builder to your new model:
namespace App\Models; use Illuminate\Database\Eloquent\Model; use MatanYadaev\EloquentSpatial\SpatialBuilder; use MatanYadaev\EloquentSpatial\Objects\Point; use MatanYadaev\EloquentSpatial\Objects\Polygon; /** * @property Point $location * @property Polygon $area * @method static SpatialBuilder query() */ class Place extends Model { protected $fillable = [ 'name', 'location', 'area', ]; protected $casts = [ 'location' => Point::class, 'area' => Polygon::class, ]; public function newEloquentBuilder($query): SpatialBuilder { return new SpatialBuilder($query); } }
Access spatial data:
use App\Models\Place; use MatanYadaev\EloquentSpatial\Objects\Polygon; use MatanYadaev\EloquentSpatial\Objects\LineString; use MatanYadaev\EloquentSpatial\Objects\Point; $londonEye = Place::create([ 'name' => 'London Eye', 'location' => new Point(51.5032973, -0.1195537) ]); $vaticanCity = Place::create([ 'name' => 'Vatican City', 'area' => new Polygon([ new LineString([ new Point(12.455363273620605, 41.90746728266806), new Point(12.450309991836548, 41.906636872349075), new Point(12.445632219314575, 41.90197359839437), new Point(12.447413206100464, 41.90027269624499), new Point(12.457906007766724, 41.90000118654431), new Point(12.458517551422117, 41.90281205461268), new Point(12.457584142684937, 41.903107507989986), new Point(12.457734346389769, 41.905918239316286), new Point(12.45572805404663, 41.90637337450963), new Point(12.455363273620605, 41.90746728266806), ]) ]) ])
Retrieve a record with spatial data:
echo $londonEye->location->latitude; // 51.5032973 echo $londonEye->location->longitude; // -0.1195537 echo $vacationCity->area->toJson(); // {"type":"Polygon","coordinates":[[[41.90746728266806,12.455363273620605],[41.906636872349075,12.450309991836548],[41.90197359839437,12.445632219314575],[41.90027269624499,12.447413206100464],[41.90000118654431,12.457906007766724],[41.90281205461268,12.458517551422117],[41.903107507989986,12.457584142684937],[41.905918239316286,12.457734346389769],[41.90637337450963,12.45572805404663],[41.90746728266806,12.455363273620605]]]}
API
Please see API for more informative API documentation.
Tip for better IDE support
In order to get better IDE support, you should add a query
method phpDoc annotation to your model:
/** * @method static SpatialBuilder query() */ class Place extends Model { // ... }
Or alternatively override the method:
class Place extends Model { public static function query(): SpatialBuilder { return parent::query(); } }
Create queries only with the query()
static method:
Place::query()->whereDistance(...); // This is IDE-friendly Place::whereDistance(...); // This is not
Tests
composer phpunit
# or with coverage
composer phpunit-coverage
Changelog
Please see CHANGELOG for more information on what has changed recently.
License
The MIT License (MIT). Please see License File for more information.