App\Models\Concerns\Branch\QueryScope

Complexity

Total Complexity

1

Size/Duplication

Total Lines	29
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	scopeNearestLocation()	0	19	1

<?php

namespace App\Models\Concerns\Branch;

use Illuminate\Database\Eloquent\Builder;

/**
 * @method static \Illuminate\Database\Eloquent\Builder|static nearestLocation()
 *
 * @see \App\Models\Branch
 * @see \Illuminate\Database\Eloquent\Builder @callScope()
 */
trait QueryScope
{
    /**
     * Scope a query to find nearest location based on the given latitude and longitude.
     *
     * @param  \Illuminate\Database\Eloquent\Builder  $query
     * @param  mixed  $latitude
     * @param  mixed  $longitude
     * @return \Illuminate\Database\Eloquent\Builder
     */
    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');
    }
}