EloquentDataProvider::baseQuery() - Code Metrics - Inspection of "Fixes" - deniskoronets/Laravel-GridView - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Push — master ( ca7ffd...251636 )

by Denis

created 2019-04-21 21:45 UTC

EloquentDataProvider::baseQuery() A

↳ Parent: EloquentDataProvider

Complexity

Conditions	3
Paths	4

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	3
nc	4
nop	1
dl	0
loc	14
rs	9.7998
c	0
b	0
f	0

<?php

namespace Woo\GridView\DataProviders;

use Illuminate\Database\Eloquent\Builder;
use Woo\GridView\GridViewRequest;

class EloquentDataProvider extends BaseDataProvider
{
    protected $query;

    /**
     * EloquentDataProvider constructor.
     * @param Builder $query
     */
    public function __construct(Builder $query)
    {
        $this->query = clone $query;
    }

    /**
     * @param GridViewRequest $request
     * @return Builder
     */
    protected function baseQuery(GridViewRequest $request)
    {
        $query = clone $this->query;

        foreach ($request->filters as $field => $value) {
            $query->where($field, 'LIKE', '%' . $value . '%');
        }

        if ($request->sortColumn) {
            $query->orderBy($request->sortColumn, $request->sortOrder);
        }

        return $query;
    }

    /**
     * @inheritdoc
     */
    public function getCount(GridViewRequest $request) : int
    {
        return $this->baseQuery($request)->count();
    }

    /**
     * @inheritdoc
     */
    public function getData(GridViewRequest $request)
    {
        $query = $this->baseQuery($request);

        if ($request->perPage == 0) {
            return $query->get();
        }

        return $query->offset(($request->page - 1) * $request->perPage)
            ->limit($request->perPage)
            ->get();
    }
}

1			<?php
2
3			namespace Woo\GridView\DataProviders;
4
5			use Illuminate\Database\Eloquent\Builder;
6			use Woo\GridView\GridViewRequest;
7
8			class EloquentDataProvider extends BaseDataProvider
9			{
10			protected $query;
11
12			/**
13			* EloquentDataProvider constructor.
14			* @param Builder $query
15			*/
16			public function __construct(Builder $query)
17			{
18			$this->query = clone $query;
19			}
20
21			/**
22			* @param GridViewRequest $request
23			* @return Builder
24			*/
25			protected function baseQuery(GridViewRequest $request)
26			{
27			$query = clone $this->query;
28
29			foreach ($request->filters as $field => $value) {
30			$query->where($field, 'LIKE', '%' . $value . '%');
31			}
32
33			if ($request->sortColumn) {
34			$query->orderBy($request->sortColumn, $request->sortOrder);
35			}
36
37			return $query;
38			}
39
40			/**
41			* @inheritdoc
42			*/
43			public function getCount(GridViewRequest $request) : int
44			{
45			return $this->baseQuery($request)->count();
46			}
47
48			/**
49			* @inheritdoc
50			*/
51			public function getData(GridViewRequest $request)
52			{
53			$query = $this->baseQuery($request);
54
55			if ($request->perPage == 0) {
56			return $query->get();
57			}
58
59			return $query->offset(($request->page - 1) * $request->perPage)
60			->limit($request->perPage)
61			->get();
62			}
63			}

deniskoronets / Laravel-GridView

Push — master ( ca7ffd...251636 )

EloquentDataProvider::baseQuery() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like