使用laravel按纬度和经度搜索

Question

我知道这个问题已经被问过了，但在我的情况下，我有一个令人沮丧的问题，我很想找到答案。基本上，当我运行脚本时，我会得到一个遇到的非数字值，因为我无法在等式中使用db表中的行的值。如下所示：

$auctions = Auction::join('users','auctions.user_id','users.id')
                ->join('categories','auctions.category_id','categories.id')
                ->join('sub_catogories','auctions.sub_category_id','sub_catogories.id')
                ->select(['auctions.id','auctions.title','auctions.slug',
                          'auctions.description','auctions.image',
                          'auctions.reserve_price','auctions.auction_status',
                          'auctions.start_date','auctions.end_date'], 
                          ((acos(sin($orig_lat * pi() / 180) * sin(-37.8136 * pi() / 180) + cos($orig_lat * pi() / 180) * cos(-37.8136 * pi() / 180) * cos(($orig_long - '**HOW DO I INSERT users.lat HERE????**') * pi() / 180)) * 180 / pi()) * 60 * 1.1515), 'AS', 'distance')

                ->where ( 'lat', 'BETWEEN', ($orig_lat - $bounding_distance), 'AND', ($orig_lat +         $bounding_distance), 'AND', 'lng', 'BETWEEN', ($orig_long - $bounding_distance), 'AND', ($orig_long + $bounding_distance))
                ->orderBy('auctions.id','desc')->paginate(PAGINATE_RECORDS);

Answer 1

这个错误将会消失，而不是使用selectRaw而不是select。

Auction::join('users','auctions.user_id','users.id')
                ->join('categories','auctions.category_id','categories.id')
                -
>join('sub_catogories','auctions.sub_category_id','sub_catogories.id')
                ->selectRaw('auctions.id','auctions.title','auctions.slug',
                          'auctions.description','auctions.image',
                          'auctions.reserve_price','auctions.auction_status',
                          'auctions.start_date','auctions.end_date', 
                          ((acos(sin($orig_lat * pi() / 180) * sin(-37.8136 * pi() / 180) + cos($orig_lat * pi() / 180) * cos(-37.8136 * pi() / 180) * cos(($orig_long - '**HOW DO I INSERT users.lat HERE????**') * pi() / 180)) * 180 / pi()) * 60 * 1.1515), 'AS', 'distance')

                ->where ( 'lat', 'BETWEEN', ($orig_lat - $bounding_distance), 'AND', ($orig_lat +         $bounding_distance), 'AND', 'lng', 'BETWEEN', ($orig_long - $bounding_distance), 'AND', ($orig_long + $bounding_distance))
                ->orderBy('auctions.id','desc')->paginate(PAGINATE_RECORDS);