for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?php
namespace ChurakovMike\EasyGrid\DataProviders;
use ChurakovMike\EasyGrid\Helpers\SortHelper;
use Illuminate\Http\Request;
use Illuminate\Support\Collection;
/**
* Class EloquentDataProvider.
* @package ChurakovMike\EasyGrid\DataProviders
*/
class EloquentDataProvider extends BaseDataProvider
{
* Get result.
*
* @param Request $request
* @return Collection
public function get(Request $request): Collection
return $this->query->offset(($request->page - 1) * ($request->perPage))
->limit($request->perPage)
->get() ?? new Collection();
}
* Prepare query parameters.
public function prepareQuery(Request $request)
if ($request->get('sort', null)) {
$this->query->orderBy(SortHelper::getSortColumn($request), SortHelper::getDirection($request));
if (!is_null($request->filters)) {
foreach ($request->filters as $column => $value) {
$this->query->where($column, 'like', '%' . $value . '%');
Churakovmike /
laravel-grid
