Limit::build() - Code Metrics - siriusphp/sql - Measure and Improve Code Quality continuously with Scrutinizer

Limit::build() A
last analyzed 2020-11-24 15:04 UTC

↳ Parent: Limit

Complexity

Conditions	4
Paths	8

Size

Total Lines

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	9
CRAP Score	4

Importance

Changes

Metric	Value
dl	0
loc	18
ccs	9
cts	9
cp	1
rs	9.6666
c	0
b	0
f	0
cc	4
nc	8
nop	0
crap	4

<?php
declare(strict_types=1);

namespace Sirius\Sql\Component;

class Limit
{
    protected $limit = 0;

    protected $offset = 0;

    protected $page = 0;

    protected $perPage = 10;

    public function setLimit(int $limit): void
    {
        $this->limit = $limit;
        if ($this->page) {
            $this->page   = 0;
            $this->offset = 0;
        }
    }

    public function getLimit(): int
    {
        return $this->limit;
    }

    public function setOffset(int $offset): void
    {
        $this->offset = $offset;
        if ($this->page) {
            $this->page  = 0;
            $this->limit = 0;
        }
    }

    public function getOffset(): int
    {
        return $this->offset;
    }

    public function setPage(int $page): void
    {
        $this->page = $page;
        $this->setPagingLimitOffset();
    }

    public function getPage(): int
    {
        return $this->page;
    }

    public function setPerPage(int $perPage): void
    {
        $this->perPage = $perPage;
        if ($this->page) {
            $this->setPagingLimitOffset();
        }
    }

    public function getPerPage(): int
    {
        return $this->perPage;
    }

    protected function setPagingLimitOffset(): void
    {
        $this->limit  = 0;
        $this->offset = 0;
        if ($this->page) {
            $this->limit  = $this->perPage;
            $this->offset = $this->perPage * ($this->page - 1);
        }
    }

    public function buildEarly(): string
    {
        return '';
    }

    public function build(): string
    {
        $clause = '';

        if ($this->limit != 0) {
            $clause .= "LIMIT {$this->limit}";
        }

        if ($this->offset != 0) {
            $clause .= " OFFSET {$this->offset}";
        }

        if ($clause != '') {
            $clause = PHP_EOL . ltrim($clause);
        }

        return $clause;
    }
}


1		<?php
2		declare(strict_types=1);
3
4		namespace Sirius\Sql\Component;
5
6		class Limit
7		{
8		protected $limit = 0;
9
10		protected $offset = 0;
11
12		protected $page = 0;
13
14		protected $perPage = 10;
15
16	2	public function setLimit(int $limit): void
17		{
18	2	$this->limit = $limit;
19	2	if ($this->page) {
20	1	$this->page = 0;
21	1	$this->offset = 0;
22		}
23	2	}
24
25		public function getLimit(): int
26		{
27		return $this->limit;
28		}
29
30	2	public function setOffset(int $offset): void
31		{
32	2	$this->offset = $offset;
33	2	if ($this->page) {
34		$this->page = 0;
35		$this->limit = 0;
36		}
37	2	}
38
39		public function getOffset(): int
40		{
41		return $this->offset;
42		}
43
44	2	public function setPage(int $page): void
45		{
46	2	$this->page = $page;
47	2	$this->setPagingLimitOffset();
48	2	}
49
50		public function getPage(): int
51		{
52		return $this->page;
53		}
54
55	2	public function setPerPage(int $perPage): void
56		{
57	2	$this->perPage = $perPage;
58	2	if ($this->page) {
59		$this->setPagingLimitOffset();
60		}
61	2	}
62
63		public function getPerPage(): int
64		{
65		return $this->perPage;
66		}
67
68	2	protected function setPagingLimitOffset(): void
69		{
70	2	$this->limit = 0;
71	2	$this->offset = 0;
72	2	if ($this->page) {
73	2	$this->limit = $this->perPage;
74	2	$this->offset = $this->perPage * ($this->page - 1);
75		}
76	2	}
77
78	16	public function buildEarly(): string
79		{
80	16	return '';
81		}
82
83	16	public function build(): string
84		{
85	16	$clause = '';
86
87	16	if ($this->limit != 0) {
88	2	$clause .= "LIMIT {$this->limit}";
89		}
90
91	16	if ($this->offset != 0) {
92	2	$clause .= " OFFSET {$this->offset}";
93		}
94
95	16	if ($clause != '') {
96	2	$clause = PHP_EOL . ltrim($clause);
97		}
98
99	16	return $clause;
100		}
101		}
102

siriusphp / sql

Limit::build() A last analyzed 2020-11-24 15:04 UTC

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like

Limit::build() A
last analyzed 2020-11-24 15:04 UTC