問題描述

我有一個簡單的問題，但沒有找到我需要的.

I have a simple question and I didn′t find what I need.

我需要計算商店列表的 t2 地理編碼點之間的距離.我還需要為 WebService 分頁.

I need to calculate the distance between t2 geocode points for a list of Stores. I also need it to be paginated for a WebService.

這可行，但結果中沒有距離:

This works, but there is no distance in the result:

public function stores(){
    return Store::paginate(10);
}

結果是:

{
   total: 4661, 
   per_page: 10, 
   current_page: 6, 
   last_page: 467,
   next_page_url: "WS_URL/stores/?page=7",
   prev_page_url: "WS_URL/stores/?page=5", from: 51,
   to: 60, 
   data: [ { 
        id: "51", 
        name: "Sprouts",
        .
        .
        lng: "-118.359688", 
        lat: "33.808281", 
        country: "usa" 
        },
    .
    .
    .
    ]}

但我需要這段代碼工作:

But I need this code working:

public function stores(){
    return DB::table('stores')
        ->selectRaw(' *, distance(lat, ?, lng, ?) as distance ')
        ->setBindings([ 41.123401,1.2409893])
        ->orderBy('distance')
        ->paginate($this->limit);
}

這是結果:

{total: 0,
    per_page: 10,
    current_page: 1,
    last_page: 0,
    next_page_url: null,
    prev_page_url: null,
    from: 1,
    to: 10,
    data: [{
        id: "3686",
        name: "Bon Area", 
        .
        .
        lng: "1.602016",
        lat: "41.266823",
        distance: "0.15091"
        },
    .
    .
    .
    ]
}

我需要 next_page_url 和 prev_page_url

有什么想法嗎?

推薦答案

在 Eloquent 模型上使用 selectRaw 方法.

Use the selectRaw method on the Eloquent model.

Store::selectRaw('*, distance(lat, ?, lng, ?) as distance', [$lat, $lon])
    ->orderBy('distance')
    ->paginate(10);

在這種情況下，Laravel 會向數據庫詢問行的數量(使用 select count(*) as aggregate from stores)以節省您的 RAM.

In that case Laravel asks the database for the amount of rows (using select count(*) as aggregate from stores) which saves your RAM.

這篇關于如何在帶有原始查詢的 Laravel 5 中使用分頁的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網！