App\Models\Concerns\Branch\QueryScope::scopeNearestLocation()

Complexity

Conditions	1
Paths	1

Size

Total Lines	19
Code Lines	14

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes	1
Bugs	0	Features	0

<?php
    public function scopeNearestLocation(Builder $query, $latitude, $longitude)
    {
        $fieldLatitude = 'address_latitude';
        $fieldLongitude = 'address_longitude';

        $selectQuery = sprintf(
            '*, ' .
            '6371 * acos(cos(radians(?)) ' .
            '* cos(radians(%s)) ' .
            '* cos(radians(%s) - radians(?)) ' .
            '+ sin(radians(?)) ' .
            '* sin(radians(%s))) AS distance',
            $fieldLatitude, $fieldLongitude, $fieldLatitude
        );

        return $query->selectRaw(

The expression return $query->selectRaw($selectQuery, array($latitude, $longitude, $latitude))->orderBy('distance') also could return the type Illuminate\Database\Query\Builder which is incompatible with the documented return type Illuminate\Database\Eloquent\Builder.

            $selectQuery,
            [$latitude, $longitude, $latitude]
        )->orderBy('distance');
    }