malhal / Laravel-Geographical by malhal

Easily add longitude and latitude columns to your records and use inherited functionality for calculating distances
236,736
269
11
Package Data
Maintainer Username: malhal
Maintainer Contact: composer@malcolmhall.com (Malcolm Hall)
Package Create Date: 2016-10-01
Package Last Update: 2024-03-12
Language: PHP
License: MIT
Last Refreshed: 2024-04-12 03:05:55
Package Statistics
Total Downloads: 236,736
Monthly Downloads: 4,403
Daily Downloads: 154
Total Stars: 269
Total Watchers: 11
Total Forks: 49
Total Open Issues: 8

Laravel Geographical

Easily add longitude and latitude columns to your records and use inherited functionality for calculating distances.

First either update your database or add this to a migration for each model:

$table->double('longitude');
$table->double('latitude');

Finally in your model use:

use Geographical;

1. Distance

Find the distance to all the entries in your table from a particular location.

$query = Model::distance($latitude, $longitude);
$asc = $query->orderBy('distance', 'ASC')->get();

2. Geofence

Find all the entries in your table inside a circular geo-fence.

$query = Model::geofence($latitude, $longitude, $inner_radius, $outer_radius);
$all = $query->get();

Units

The default unit of distance is miles. You can change it to kilometers by putting this in your model

protected static $kilometers = true;

Notes

  1. The method returns a Eloquent\Builder object so that you can add optional conditions if you want.
  2. You can use distance as an aggregate column in the result. (Aggregate columns cannot be used in WHERE, use HAVING to execute any condition.)
  3. If you use different column names for latitude and longitude, mention them in the Model.php
const LATITUDE  = 'lat';
const LONGITUDE = 'lng';

Installation

PHP 5.6.4+ and Laravel 5+ are required.

To get the latest version of Laravel Geographical, simply require the project using Composer:

$ composer require malhal/laravel-geographical