Laravel纬度和经度半径

Question

I am trying to find all postcodes within X radius of {lat}/{long}, however I am receiving a TypeError.

I'm getting this error:

Type error: Argument 1 passed to App\Transformers\PostcodesTransformer::transform() must be an instance of App\Postcodes, instance of stdClass given, called in /home/vagrant/postcode-data/vendor/league/fractal/src/Scope.php on line 338

The query is:

$postcodes = DB::select("Select 
    id, 
    postcode, 
    latitude, 
    longitude, 
    district, 
    postal_town, 
    county, 
    country, 
    northing, 
    easting, 
    type,
    acos(sin(".$lat.")*sin(radians(latitude)) + cos(".$lat.")*cos(radians(latitude))*cos(radians(longitude)-".$lon.")) * ".$R." As distance
        From (
            Select *
            From uk_postcodes
            Where latitude Between ".$minLat." And ".$maxLat."
              And longitude Between ".$minLon." And ".$maxLon."
        ) As FirstCut
        Where acos(sin(".$lat.")*sin(radians(latitude)) + cos(".$lat.")*cos(radians(latitude))*cos(radians(longitude)-".$lon.")) * ".$R."< ".$rad."
        Order by distance");
    return $this->response->withCollection($postcodes, new PostcodesTransformer); 

However the result of the DB::select query returns stdClass.

How would I have it return an instance of the Postcodes class?

Answer 1

According to your code, you aren't using Laravel' Eloquent Model concept to make the queries to the Database.

Read about: Eloquent: Getting Started.

So you can have a collection of Postcode objects like this:

Create a model named Postcode like this:

<?php

namespace App;

use Illuminate\Database\Eloquent\Model;

class Postcode extends Model
{
    protected $table = 'postcodes';
    protected $guarded = ['id'];
}

Then while creating your query, you can do it like this, you can use Laravel's query builder's method - selectRaw():

$postcodes = Postcode::selectRaw("
    *,
    acos(sin(".$lat.")*sin(radians(latitude)) + cos(".$lat.")*cos(radians(latitude))*cos(radians(longitude)-".$lon.")) * ".$R." As distance
        From (
            Select *
            From uk_postcodes
            Where latitude Between ".$minLat." And ".$maxLat."
              And longitude Between ".$minLon." And ".$maxLon."
        ) As FirstCut
        Where acos(sin(".$lat.")*sin(radians(latitude)) + cos(".$lat.")*cos(radians(latitude))*cos(radians(longitude)-".$lon.")) * ".$R."< ".$rad."
")
->orderBy('distance', 'asc')
->get();

You'll now get a collection of Postcode model Objects instead of StdClass. It would be better if you break your select raw query more deeply, as it seems to me that it will not work!