gistfile1.txt

Model

public function scopeDistance($subQuery, $latitude, $longitude, $distance)
    {
        //Generating Query
        $item_distance_query = '* , (3959 * ' .
            'acos( cos( radians(?) ) ' . //lat
            '* cos( radians( lat ) ) ' .
            '* cos( radians( lng ) - radians(?) ) ' . //long
            '+ sin( radians(?) ) ' . //lat
            '* sin( radians( lat ) ) ' .
            ') ) as distance'; //distance3

        $subQuery->getQuery()->selectRaw($item_distance_query,
            [$latitude, $longitude, $latitude]
        );
        $rawQuery = self::getSql($subQuery);
        return $subQuery->select(DB::raw("(" . $rawQuery . ") as item"))
                  ->where('distance', '<', $distance);
    }