JAQB\Statement\OrderStatement

Complexity

Total Complexity

15

Size/Duplication

Total Lines	98
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	1

Importance

Changes

0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	isGroupBy()	0	4	1
B	addFields()	0	25	8
A	getFields()	0	4	1
A	build()	0	18	4

<?php

/**
 * @author Jared King <j@jaredtking.com>
 *
 * @link http://jaredtking.com
 *
 * @copyright 2015 Jared King
 * @license MIT
 */
namespace JAQB\Statement;

class OrderStatement extends Statement
{
    /**
     * @var bool
     */
    protected $groupBy;

    /**
     * @var array
     */
    protected $fields = [];

    /**
     * @param bool $groupBy when true, statement becomes a group by statement
     */
    public function __construct($groupBy = false)
    {
        $this->groupBy = $groupBy;
    }

    /**
     * Tells whether this statement is a GROUP BY statement.
     *
     * @return bool true: is group by, false: is order by
     */
    public function isGroupBy()
    {
        return $this->groupBy;
    }

    /**
     * Adds fields to this statement
     * Support input styles:
     * - addFields('field ASC,field2')
     * - addFields('field', 'ASC')
     * - addFields(['field','field2'], 'DESC')
     * - addFields([['field','ASC'], ['field2','ASC']]).
     *
     * @param string|array $fields
     * @param string       $direction direction for fields where direction is unspecified (optional)
     *
     * @return self
     */
    public function addFields($fields, $direction = false)
    {
        if (!is_array($fields)) {
            $fields = array_map(function ($f) {
                return trim($f);
            }, explode(',', $fields));
        }

        foreach ($fields as $field) {
            if (!is_array($field)) {
                $field = explode(' ', trim($field));
            }

            if (count($field) === 1 && $direction !== false) {
                $field[] = $direction;
            }

            // validate the direction
            if (count($field) === 1 || in_array(strtolower($field[1]), ['asc', 'desc'])) {
                $this->fields[] = $field;
            }
        }

        return $this;
    }

    /**
     * Gets the fields associated with this statement.
     *
     * @return array fields i.e. [['field1','ASC'], ['field2']]
     */
    public function getFields()
    {
        return $this->fields;
    }

    public function build()
    {
        $fields = $this->fields;
        foreach ($fields as &$field) {
            $field[0] = $this->escapeIdentifier($field[0]);
            $field = implode(' ', $field);
        }

        // remove empty values
        $fields = array_filter($fields);

        if (count($fields) == 0) {
            return '';
        }

        return ((!$this->groupBy) ? 'ORDER BY ' : 'GROUP BY ').
            implode(',', $fields);
    }
}