Sirius\Sql\Component\Limit

Complexity

Total Complexity

18

Size/Duplication

Total Lines	96
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	0

Test Coverage

Coverage

76.6%

Importance

Changes

0

11 Methods

Rating	Name	Duplication	Size	Complexity
A	setLimit()	0	8	2
A	getLimit()	0	4	1
A	setOffset()	0	8	2
A	getOffset()	0	4	1
A	setPage()	0	5	1
A	getPage()	0	4	1
A	setPerPage()	0	7	2
A	getPerPage()	0	4	1
A	setPagingLimitOffset()	0	9	2
A	buildEarly()	0	4	1
A	build()	0	18	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;
    }
}