HexMakina\Crudites\Grammar\Clause\Where

Complexity

Total Complexity

18

Size/Duplication

Total Lines	85
Duplicated Lines	0 %

Importance

Changes	4
Bugs	0	Features	2

11 Methods

Rating	Name	Duplication	Size	Complexity
A	name()	0	3	1
A	__toString()	0	7	2
A	__construct()	0	10	4
A	andIn()	0	3	1
A	andFields()	0	10	3
A	andIsNull()	0	3	1
A	andPredicate()	0	3	1
A	andLike()	0	3	1
A	and()	0	9	2
A	andValue()	0	3	1
A	add()	0	3	1

<?php

namespace HexMakina\Crudites\Grammar\Clause;

use HexMakina\Crudites\Grammar\Predicate;

class Where extends Clause
{
    protected array $and = [];

    public function __construct(?array $predicates = null)
    {
        parent::__construct();

        if ($predicates !== null) {
            foreach ($predicates as $predicate) {
                if (is_string($predicate))
                    $this->and($predicate);
                else
                    $this->and($predicate, $predicate->bindings());
            }
        }
    }

    public function __toString(): string
    {
        if (empty($this->and)) {
            return '';
        }

        return 'WHERE ' . implode(' AND ', $this->and);
    }

    public function name(): string
    {
        return self::WHERE;
    }

    public function add($predicate): self
    {
        return $this->andPredicate($predicate);
    }


    public function and(string $predicate, $bindings = []): self
    {
        $this->and[] = $predicate;

        if (!empty($bindings)) {
            $this->bindings = array_merge($this->bindings, $bindings);
        }

        return $this;
    }

    public function andPredicate(Predicate $predicate)
    {
        return $this->and($predicate->__toString(), $predicate->bindings());
    }


    public function andIsNull($expression)
    {
        return $this->and(new Predicate($expression, 'IS NULL'));
    }

    public function andFields(array $assoc_data, $table_name = null, $operator = '=')
    {
        foreach ($assoc_data as $field => $value) {
            $column = $table_name === null ? [$field] : [$table_name, $field];
            $predicate = (new Predicate($column, $operator))->withValue($value, __FUNCTION__ .'_'.implode('_', $column));

            $this->and($predicate, $predicate->bindings());
        }

        return $this;
    }

    public function andValue($expression, $operator, $value, $bind_label = null)
    {
        return $this->andPredicate((new Predicate($expression, $operator))->withValue($value, $bind_label));
    }

    public function andIn($expression, array $values)
    {
        return $this->andPredicate((new Predicate($expression, 'IN'))->withValues($values, __FUNCTION__));
    }

    public function andLike($expression, string $value)
    {
        return $this->andPredicate((new Predicate($expression, 'LIKE'))->withValue($value, __FUNCTION__));
    }
}