Phossa2\Query\Traits\Clause\LimitTrait

Complexity

Total Complexity

11

Size/Duplication

Total Lines	73
Duplicated Lines	16.44 %

Coupling/Cohesion

Components	1
Dependencies	0

Importance

Changes	1
Bugs	0	Features	0

6 Methods

Rating	Name	Duplication	Size	Complexity
A	limit()	7	12	4
A	offset()	5	10	2
A	page()	0	6	1
A	buildLimit()	0	16	4
	getClause()	0	1	?
	joinClause()	0	6	?

<?php
/**
 * Phossa Project
 *
 * PHP version 5.4
 *
 * @category  Library
 * @package   Phossa2\Query
 * @copyright Copyright (c) 2016 phossa.com
 * @license   http://mit-license.org/ MIT License
 * @link      http://www.phossa.com/
 */
/*# declare(strict_types=1); */

namespace Phossa2\Query\Traits\Clause;

use Phossa2\Query\Interfaces\Clause\LimitInterface;

/**
 * LimitTrait
 *
 * Implementation of LimitInterface
 *
 * @package Phossa2\Query
 * @author  Hong Zhang <phossa@126.com>
 * @see     LimitInterface
 * @version 2.0.0
 * @since   2.0.0 added
 */
trait LimitTrait
{
    /**
     * {@inheritDoc}
     */
    public function limit(/*# int */ $count, /*# int */ $offset = 0)
    {
        $clause = &$this->getClause('LIMIT');
        if ($count || $offset) {

This code seems to be duplicated across your project.

            if (!empty($clause)) {
                $clause[0] = (int) $count;
            } else {
                $clause = [(int) $count, (int) $offset];
            }
        }
        return $this;
    }

    /**
     * {@inheritDoc}
     */
    public function offset(/*# int */ $offset)
    {
        $clause = &$this->getClause('LIMIT');
        if (!empty($clause)) {

This code seems to be duplicated across your project.

            $clause[1] = (int) $offset;
        } else {
            $clause = [-1, (int) $offset];
        }
        return $this;
    }

    /**
     * {@inheritDoc}
     */
    public function page(/*# int */ $pageNumber, /*# int */ $perPage = 30)
    {
        $clause = &$this->getClause('LIMIT');
        $clause = [(int) $perPage, ($pageNumber - 1) * $perPage];
        return $this;
    }

    /**
     * Build LIMIT
     *
     * @return array
     * @access protected
     */
    protected function buildLimit(array $settings)/*# : string */
    {
        $result = [];
        $clause = &$this->getClause('LIMIT');
        if (!empty($clause)) {
            $res = [];
            if ($clause[0]) {
                $res[] = 'LIMIT ' . $clause[0];
            }
            if ($clause[1]) {
                $res[] = 'OFFSET ' . $clause[1];
            }
            $result[] = join(' ', $res);
        }
        return $this->joinClause('', ' ', $result, $settings);
    }

    abstract protected function &getClause(/*# string */ $clauseName)/*# : array */;
    abstract protected function joinClause(
        /*# : string */ $prefix,
        /*# : string */ $seperator,
        array $clause,
        array $settings
    )/*# : string */;
}