Phossa2\Query\Traits\Clause\OrderByTrait

Complexity

Total Complexity

9

Size/Duplication

Total Lines	85
Duplicated Lines	15.29 %

Coupling/Cohesion

Components	1
Dependencies	0

Importance

Changes	1
Bugs	0	Features	0

11 Methods

Rating	Name	Duplication	Size	Complexity
A	orderBy()	0	4	1
A	orderByDesc()	0	4	1
A	orderByTpl()	0	4	1
A	orderByRaw()	0	4	1
A	realOrderBy()	13	13	2
A	buildOrderby()	0	11	3
	isRaw()	0	1	?
	clauseTpl()	0	1	?
	getClause()	0	1	?
	quoteItem()	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\OrderByInterface;

/**
 * OrderByTrait
 *
 * Implementation of OrderByInterface
 *
 * @package Phossa2\Query
 * @author  Hong Zhang <phossa@126.com>
 * @see     OrderByInterface
 * @version 2.0.0
 * @since   2.0.0 added
 */
trait OrderByTrait
{
    /**
     * {@inheritDoc}
     */
    public function orderBy($col)
    {
        return $this->realOrderBy($col, 'ASC');
    }

    /**
     * {@inheritDoc}
     */
    public function orderByDesc($col)
    {
        return $this->realOrderBy($col, 'DESC');
    }

    /**
     * {@inheritDoc}
     */
    public function orderByTpl(/*# string */ $template, $col)
    {
        return $this->realOrderBy($this->clauseTpl($template, $col), '', true);
    }

    /**
     * {@inheritDoc}
     */
    public function orderByRaw(/*# string */ $rawString)
    {
        return $this->realOrderBy($rawString, '',  true);
    }

    /**
     * @param  string|string[] $col
     * @param  string $suffix 'ASC' or 'DESC'
     * @param  bool $rawMode
     * @return $this
     * @access protected
     */
    protected function realOrderBy(

This method seems to be duplicated in your project.

        $col,
        /*# sting */ $suffix = 'ASC',
        /*# bool */ $rawMode = false
    ) {
        if (is_array($col)) {
            $this->multipleOrderBy($col);

The method multipleOrderBy() does not exist on Phossa2\Query\Traits\Clause\OrderByTrait. Did you maybe mean orderBy()?

        } else {
            $clause = &$this->getClause('ORDER BY');
            $clause[] = [$col, $suffix, $this->isRaw($col, $rawMode)];
        }
        return $this;
    }

    /**
     * Build ORDER BY
     *
     * @param  array $settings
     * @return string
     * @access protected
     */
    protected function buildOrderby(array $settings)/*# : string */
    {
        $result = [];
        $clause = &$this->getClause('ORDER BY');
        foreach ($clause as $ord) {
            $item = $this->quoteItem($ord[0], $ord[2]);
            $ordr = $ord[1] ? (' ' . $ord[1]) : '';
            $result[] =  $item . $ordr;
        }
        return $this->joinClause('ORDRE BY', ',', $result, $settings);
    }

    abstract protected function isRaw($str, /*# bool */ $rawMode)/*# : bool */;
    abstract protected function clauseTpl(/*# string */ $template, $col)/*# : string */;
    abstract protected function &getClause(/*# string */ $clauseName)/*# : array */;
    abstract protected function quoteItem($item, /*# bool */ $rawMode = false)/*# : string */;
    abstract protected function joinClause(
        /*# : string */ $prefix,
        /*# : string */ $seperator,
        array $clause,
        array $settings
    )/*# : string */;
}