EloquentDataProvider::prepareQuery() - Code Metrics - Churakovmike/laravel-grid - Measure and Improve Code Quality continuously with Scrutinizer

EloquentDataProvider::prepareQuery() A
last analyzed 2020-04-01 15:53 UTC

↳ Parent: EloquentDataProvider

Complexity

Conditions	5
Paths	8

Size

Total Lines	13
Code Lines	7

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	5
eloc	7
c	0
b	0
f	0
nc	8
nop	1
dl	0
loc	13
rs	9.6111

<?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.
     *
     * @param Request $request
     */
    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) {
                if (is_null($value)) {
                    continue;
                }

                $this->query->where($column, 'like', '%' . $value . '%');
            }
        }
    }
}


1			<?php
2
3			namespace ChurakovMike\EasyGrid\DataProviders;
4
5			use ChurakovMike\EasyGrid\Helpers\SortHelper;
6			use Illuminate\Http\Request;
7			use Illuminate\Support\Collection;
8
9			/**
10			* Class EloquentDataProvider.
11			* @package ChurakovMike\EasyGrid\DataProviders
12			*/
13			class EloquentDataProvider extends BaseDataProvider
14			{
15			/**
16			* Get result.
17			*
18			* @param Request $request
19			* @return Collection
20			*/
21			public function get(Request $request): Collection
22			{
23			return $this->query->offset(($request->page - 1) * ($request->perPage))
24			->limit($request->perPage)
25			->get() ?? new Collection();
26			}
27
28			/**
29			* Prepare query parameters.
30			*
31			* @param Request $request
32			*/
33			public function prepareQuery(Request $request)
34			{
35			if ($request->get('sort', null)) {
36			$this->query->orderBy(SortHelper::getSortColumn($request), SortHelper::getDirection($request));
37			}
38
39			if (!is_null($request->filters)) {
40			foreach ($request->filters as $column => $value) {
41			if (is_null($value)) {
42			continue;
43			}
44
45			$this->query->where($column, 'like', '%' . $value . '%');
46			}
47			}
48			}
49			}
50

Churakovmike / laravel-grid

EloquentDataProvider::prepareQuery() A last analyzed 2020-04-01 15:53 UTC

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like

EloquentDataProvider::prepareQuery() A
last analyzed 2020-04-01 15:53 UTC