Wandu\Database\Query\Expression\HasWhereExpression

Complexity

Total Complexity

21

Size/Duplication

Total Lines	162
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	4

Test Coverage

Coverage

79.03%

Importance

Changes

0

10 Methods

Rating	Name	Duplication	Size	Complexity
A	getBindings()	0	14	2
A	where()	0	8	2
A	andWhere()	0	8	2
A	orWhere()	0	8	2
A	orderBy()	0	8	2
A	andOrderBy()	0	8	2
A	take()	0	8	2
A	offset()	0	8	2
A	limit()	0	8	2
A	toSql()	0	16	3

<?php
namespace Wandu\Database\Query\Expression;

use Wandu\Database\Contracts\ExpressionInterface;

class HasWhereExpression implements ExpressionInterface
{
    /** @var \Wandu\Database\Query\Expression\WhereExpression */
    protected $where;

    /** @var \Wandu\Database\Query\Expression\OrderByExpression */
    protected $orderBy;

    /** @var \Wandu\Database\Query\Expression\LimitExpression */
    protected $limit;

    /**
     * @param string|array|callable $name
     * @param string $operator
     * @param string $value
     * @return static
     */
    public function where($name, $operator = null, $value = null)
    {
        if (!isset($this->where)) {
            $this->where = new WhereExpression();
        }
        $this->where->where($name, $operator, $value);
        return $this;
    }

    /**
     * @param string|array|callable $name
     * @param string $operator
     * @param string $value
     * @return static
     */
    public function andWhere($name, $operator = null, $value = null)
    {
        if (!isset($this->where)) {
            $this->where = new WhereExpression();
        }
        $this->where->andWhere($name, $operator, $value);
        return $this;
    }

    /**
     * @param string|array|callable $name
     * @param string $operator
     * @param string $value
     * @return static
     */
    public function orWhere($name, $operator = null, $value = null)
    {
        if (!isset($this->where)) {
            $this->where = new WhereExpression();
        }
        $this->where->orWhere($name, $operator, $value);
        return $this;
    }

    /**
     * @param array|string $name
     * @param boolean $asc
     * @return static
     */
    public function orderBy($name, $asc = true)
    {
        if (!isset($this->orderBy)) {
            $this->orderBy = new OrderByExpression();
        }
        $this->orderBy->orderBy($name, $asc);
        return $this;
    }

    /**
     * @param array|string $name
     * @param boolean $asc
     * @return static
     */
    public function andOrderBy($name, $asc = true)
    {
        if (!isset($this->orderBy)) {
            $this->orderBy = new OrderByExpression();
        }
        $this->orderBy->andOrderBy($name, $asc);
        return $this;
    }

    /**
     * @param int $take
     * @return static
     */
    public function take($take = null)
    {
        if (!isset($this->limit)) {
            $this->limit = new LimitExpression();
        }
        $this->limit->take($take);
        return $this;
    }

    /**
     * @param int $offset
     * @return static
     */
    public function offset($offset = null)
    {
        if (!isset($this->limit)) {
            $this->limit = new LimitExpression();
        }
        $this->limit->offset($offset);
        return $this;
    }

    /**
     * @param int $offset
     * @param int $take
     * @return static
     */
    public function limit($offset, $take)
    {
        if (!isset($this->limit)) {
            $this->limit = new LimitExpression();
        }
        $this->limit->limit($offset, $take);
        return $this;
    }

    /**
     * {@inheritdoc}
     */
    public function toSql()
    {
        $parts = array_reduce([
            $this->where,
            $this->orderBy,
            $this->limit,
        ], function ($carry, $expression) {
            /* @var \Wandu\Database\Contracts\ExpressionInterface $expression */
            if (isset($expression) && $sqlPart = $expression->toSql()) {
                $carry[] = $sqlPart;
                return $carry;
            }
            return $carry;
        }, []);
        return implode(' ', $parts);
    }

    /**
     * {@inheritdoc}
     */
    public function getBindings()
    {
        return array_reduce([
            $this->where,
            $this->orderBy,
            $this->limit,
        ], function ($carry, $expression) {
            /* @var \Wandu\Database\Contracts\ExpressionInterface $expression */
            if (isset($expression)) {
                return array_merge($carry, $expression->getBindings());
            }
            return $carry;
        }, []);
    }
}