LARAVEL-COORDINATE
get nearby location data from database with eloquent laravel
Installation
composer require bagusindrayana/laravel-coordinate
- In Model
#use trait
use Bagusindrayana\LaravelCoordinate\Traits\LaravelCoordinate;
class Toko extends Model
{
use LaravelCoordinate;
//optional
public $_latitudeName = "latitude_column"; //default name is latitude
public $_longitudeName = "latitude_column"; //default name is longitude
//
}
- Using trait
//get data by distance 500 m (0.5KM)
$tokos = Toko::nearby([
-0.497493,//latitude
117.156480//longitude
],0.5)->get();
//using order remember order awlways in last query
//get data by distance 1 KM and order by farthest distance
$tokos = Toko::nearby([
-0.497493,//latitude
117.156480//longitude
],1)->farthest()->get();
//get data by distance 1 KM and order by closest distance
$tokos = Toko::nearby([
-0.497493,//latitude
117.156480//longitude
],1)->closest()->get();
//add new column with containt distance value
$tokos = Toko::nearby([
-0.497493,//latitude
117.156480//longitude
],0.5) //0.5 Km
->selectDistance(['id','nama_toko'],'_distance') //will add new column with name _distance contain value of distance every record
->get();
Formula
I haven't tried how much data it can handle and how fast the calculations are so here are 3 different formulas you can try
formula paramter/arguments (int)
- 0 = default
- 1 = Spherical Law of Cosines
- 2 = Haversine formula
example :
$tokos = Toko::nearby([
-0.497493,//latitude
117.156480//longitude
],
0.5,
1//using Spherical Law of Cosines
)
->get();
Scope
nearby(coordinate,radius/distance = 5,formula = 0)
closest(coordinate,formula = 0)
farthest(coordinate,formula = 0)
selectDistance(fieldName,aliasName,formula = 0)
insideBox(coorinate(2 coordinate))
82 Nov 24, 2022
42 Dec 15, 2022
477 Dec 1, 2022
8 Aug 17, 2022
11 May 7, 2022
9 Feb 10, 2022
82 Nov 24, 2022
1.9k Jan 6, 2023
16 Nov 26, 2022
8 Jul 27, 2022
8 Aug 9, 2022
1 Nov 15, 2021
12.6k Dec 30, 2022
1 Mar 21, 2022
349 Jan 8, 2023
87 Nov 26, 2022
13 Jun 15, 2023
1.7k Dec 14, 2022
708 Dec 22, 2022
1.3k Jan 7, 2023
0 Jul 24, 2021
34 Jun 20, 2022
56 Dec 16, 2022
2.2k Jan 5, 2023
53 Oct 17, 2022
50 Dec 5, 2022
100 Jan 4, 2023
320 Dec 12, 2022