Breaking News: Grepper is joining You.com. Read the official announcement!

php Laravel query get coordinate distance

Precious Petrel answered on January 4, 2024 Popularity 1/10 Helpfulness 1/10

answer php Laravel query get coordinate distance

php Laravel query get coordinate distance

Comment

$queries->addSelect(['distance' => User::whereNotNull('coordinates')
    ->selectRaw(
        "ST_Distance_Sphere(
            ST_GeomFromGeoJSON(
                JSON_UNQUOTE(JSON_EXTRACT(coordinates, '$.lng'))
            ), 
            ST_GeomFromGeoJSON(
                JSON_UNQUOTE(JSON_EXTRACT(coordinates, '$.lat'))
            )
            point(?, ?)) * .000621371192 as distance",
        [$coordinate['lng'], $coordinate['lat']]
    )
    ->whereColumn('users.id', 'technicians.user_id')])->orderBy('distance', 'ASC');

Popularity 1/10 Helpfulness 1/10 Language php

Source: chat.openai.com

Tags: coordinate distance get laravel php

Link to this answer
Share Copy Link

Contributed on Jan 04 2024

Precious Petrel

0 Answers Avg Quality 2/10

Continue with Google

By continuing, I agree that I have read and agree to Greppers's Terms of Service and Privacy Policy.

php Laravel query get coordinate distance

Contents

More Related Answers

php Laravel query get coordinate distance

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.