orderByDistance()

[robjbrain]

I thought i'd put this here for anyone else that wanted it.

I wanted to orderByDistance and it was as simple as:

public function scopeOrderByDistance($query, $geometryColumn, $geometry)
    {
        $this->isColumnAllowed($geometryColumn);

        $query->orderByRaw("st_distance(`$geometryColumn`, ST_GeomFromText(?))", [
            $geometry->toWkt()
        ]);

        return $query;
    }

Presumably you can add these scopes for the other columns as well.

[NicksonYap]

Great reference for running other spatial queries! Thanks!

[lostfocus]

I was looking for that, thank you!

[iSWORD]

Very helpful, thanks @robjbrain

This should be merged into the trait @grimzy

[grimzy]

@robjbrain Thank you! Rolling out a new version with this scope soon.

Better late than never?