我有一个复杂的查询,该查询不基于我想要对其输出进行分页的任何特定模型表。然而 Laravel 的内置分页依赖于模型和表格。如何对集合进行分页并使输出与 laravel 内置的分页输出格式匹配?
我将其保存在 app\Core\Helpers 类中,以便我可以从任何地方调用它们作为 \App\Core\Helpers::makePaginatorForCollection($query_results)。最有可能使用它的地方是处理复杂查询的控制器的最后一行。
在应用程序/Http/Controllers/simpleExampleController.php
/**
* simpleExampleController
**/
public function myWeirdData(Request $request){
$my_unsafe_sql = '...';//never do this!!
$result = DB::statement(DB::raw($my_unsafe_sql));
return \App\Core\Helpers::makePaginatorForCollection($result);
}
在 app\Core\Helpers.php 或您喜欢的任何地方自动加载。
/**
* This will match laravel's built in Model::paginate()
* because it uses the same underlying code.
*
* @param \Illuminate\Support\Collection $collection
*
* @return \Illuminate\Pagination\LengthAwarePaginator
*/
public static function makePaginatorForCollection(\Illuminate\Support\Collection $collection){
$current_page = (request()->has('page')? request()->page : 1) -1;//off by 1 (make zero start)
$per_page = (request()->has('per_page')? request()->per_page : config('api.pagination.per_page')) *1;//make numeric
$page_data = $collection->slice($current_page * $per_page, $per_page)->all();
return new \Illuminate\Pagination\LengthAwarePaginator(array_values($page_data), count($collection), $per_page);
}
/**
* Copy and refactor makePaginatorForCollection()
* if collection building is too slow.
*
* @param $array
*
* @return \Illuminate\Pagination\LengthAwarePaginator
*/
public static function makePaginatorForArray($array){
$collection = collect($array);
return self::makePaginatorForCollection($collection);
}
本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系:hwhale#tublm.com(使用前将#替换为@)