两点之间距离php demo,php – Laravel中两点之间的Haversine距离计算

我正在开发一个laravel应用程序,我需要找到所有在用户坐标的某个半径范围内的产品.产品与用户有一对多的关系,因此用户可以拥有多种产品.

我发现,半正式公式可以计算出两点之间的距离,但我似乎无法使它起作用.

我的控制器中有以下查询：

$latitude = 51.0258761;

$longitude = 4.4775362;

$radius = 20000;

$products = Product::with('user')

->selectRaw("*,( 6371 * acos( cos( radians(" . $latitude . ") ) *

cos( radians(user.latitude) ) *

cos( radians(user.longitude) - radians(" . $longitude . ") ) +

sin( radians(" . $latitude . ") ) *

sin( radians(user.latitude) ) ) )

AS distance")

->having("distance","

为了测试目的,我将半径设置为20000,看起来所有产品的距离都是5687,…

问题似乎是产品的纬度和经度存储在User表中,但我不确定如何在查询中访问这些产品.我已经尝试过user.latitude和’user->纬度’,但似乎没有任何效果.

这是我的模特：

产品型号

namespace App;

use Illuminate\Database\Eloquent\Model;

class Product extends Model

{

protected $fillable =

[

'soort','hoeveelheid','hoeveelheidSoort','prijsPerStuk','extra','foto','bio'

];

public function User()

{

return $this->belongsTo('App\User');

}

public $timestamps = true;

}

用户模型

namespace App;

use Illuminate\Auth\Authenticatable;

use Illuminate\Database\Eloquent\Model;

use Illuminate\Auth\Passwords\CanResetPassword;

use Illuminate\Foundation\Auth\Access\Authorizable;

use Illuminate\Contracts\Auth\Authenticatable as AuthenticatableContract;

use Illuminate\Contracts\Auth\Access\Authorizable as AuthorizableContract;

use Illuminate\Contracts\Auth\CanResetPassword as CanResetPasswordContract;

class User extends Model implements AuthenticatableContract,AuthorizableContract,CanResetPasswordContract

{

use Authenticatable,Authorizable,CanResetPassword;

protected $table = 'users';

protected $fillable =

[

'firstName','lastName','adres','profilepic','description','longitude','latitude','email','password'

];

protected $hidden = ['password','remember_token'];

public function product()

{

return $this->hasMany('App\Product');

}

}