問題描述

我正在嘗試在 laravel 5.2 中使用 distinct() 和 pagination() 流利，結(jié)果正確，但分頁仍然存在相同(就像沒有應(yīng)用不同).

I'm trying to use distinct() with pagination() in laravel 5.2 with fluent and it's given result proper but pagination remain same(Like without apply distinct).

我已經(jīng)使用我的代碼查看并測試了以下答案
- laravel 5 - 使用不同的分頁對 total() 查詢/a>
- 分頁 &與眾不同
- 使用 distinct 時(shí)查詢生成器分頁方法計(jì)數(shù)錯(cuò)誤

我的代碼類似于:

DB::table('myTable1 AS T1')
->select('T1.*')
->join('myTable2 AS T2','T2.T1_id','=','T1.id')
->distinct()
->paginate(5);

示例
- 我得到了三個(gè)記錄(即 POST1、POST2、POST3 和 POST1)的結(jié)果，所以我應(yīng)用了 distinct().
- 現(xiàn)在我的結(jié)果是 POST1、POST2 和 POST3 但分頁仍然顯示為 4 條記錄(作為應(yīng)用 distinct() 之前的結(jié)果).

EXAMPLE
- I have result with three records(i.e. POST1, POST2, POST3 and POST1) so I apply distinct().
- Now my result is POST1, POST2 and POST3 but pagination still display like 4 records(As result before applied distinct()).

任何建議將不勝感激！

推薦答案

Laravel 和在分頁中使用 distinct 似乎存在一些持續(xù)的問題.

There seems to be some ongoing issues with Laravel and using distinct with pagination.

在這種情況下，當(dāng)分頁確定記錄總數(shù)時(shí)，它會(huì)忽略您在 select() 子句中指定的字段.由于它忽略了您的列，因此也忽略了不同的功能.因此，計(jì)數(shù)查詢變?yōu)?select count(*) as aggregate from ...

In this case, when pagination is determining the total number of records, it is ignoring the fields you have specified in your select() clause. Since it ignores your columns, the distinct functionality is ignored as well. So, the count query becomes select count(*) as aggregate from ...

要解決此問題，您需要將您的列的分頁功能告知.傳遞您的列數(shù)組以選擇作為第二個(gè)參數(shù)，它會(huì)將它們計(jì)入總計(jì)數(shù).所以，如果你這樣做:

To resolve the issue, you need to tell the paginate function about your columns. Pass your array of columns to select as the second parameter, and it will take them into account for the total count. So, if you do:

/*DB::stuff*/->paginate(5, ['T1.*']);

這將運(yùn)行計(jì)數(shù)查詢:

select count(distinct T1.*) as aggregate from

因此，您的查詢應(yīng)如下所示:

So, your query should look like:

DB::table('myTable1 AS T1')
    ->select('T1.*')
    ->join('myTable2 AS T2','T2.T1_id','=','T1.id')
    ->distinct()
    ->paginate(5, ['T1.*']);

這篇關(guān)于在laravel 5.2中使用分頁()的distinct()不起作用的文章就介紹到這了，希望我們推薦的答案對大家有所幫助，也希望大家多多支持html5模板網(wǎng)！