ntentan\nibii\QueryParameters

Complexity

Total Complexity

25

Size/Duplication

Total Lines	137
Duplicated Lines	0 %

Coupling/Cohesion

Components	5
Dependencies	1

Test Coverage

Coverage

81.25%

Importance

Changes	8
Bugs	0	Features	2

17 Methods

Rating	Name	Duplication	Size	Complexity
A	getFields()	0	10	2
A	__construct()	0	5	1
A	getEagerLoad()	0	4	1
A	setFields()	0	5	1
A	getTable()	0	4	1
A	getLimit()	0	4	2
A	getOffset()	0	4	2
A	getWhereClause()	0	4	2
A	getBoundData()	0	4	1
A	getSorts()	0	4	2
A	setRawFilter()	0	5	1
A	setFirstOnly()	0	5	1
A	getFirstOnly()	0	4	1
A	setLimit()	0	4	1
A	setOffset()	0	4	1
A	addSort()	0	4	1
B	addFilter()	0	28	4

<?php

namespace ntentan\nibii;


/**
 * Description of QueryParameters
 *
 * @author ekow
 */
class QueryParameters
{
    private $whereClause;
    private $and = '';
    private $boundData = [];
    private $fields = [];
    private $table;
    private $db;
    private $firstOnly = false;
    private $eagerLoad = [];
    private $limit;
    private $offset;
    private $sorts = [];

    /**
     *
     * @param \ $model

There is no parameter named $model. Was it maybe removed?

     */
    public function __construct($wrapper)
    {
        $this->db = DriverAdapter::getDefaultInstance();
        $this->table = $wrapper->getTable();
    }

    public function getFields()
    {
        $fields = '*';

        if (count($this->fields) > 0) {
            $fields = implode(', ', $this->fields);
        }

        return $fields;
    }

    public function getEagerLoad()
    {
        return $this->eagerLoad;
    }

    public function setFields($fields)
    {
        $this->fields = $fields;
        return $this;
    }

    public function getTable()

The return type could not be reliably inferred; please add a @return annotation.

    {
        return $this->table;
    }
    
    public function getLimit()

The return type could not be reliably inferred; please add a @return annotation.

    {
        return $this->limit > 0 ? " LIMIT {$this->limit}" : null;
    }
    
    public function getOffset()

The return type could not be reliably inferred; please add a @return annotation.

    {
        return $this->offset > 0 ? " OFFSET {$this->offset}" : null;
    }

    public function getWhereClause()

The return type could not be reliably inferred; please add a @return annotation.

    {
        return $this->whereClause ? " WHERE {$this->whereClause}" : '';
    }

    public function getBoundData()
    {
        return $this->boundData;
    }
    
    public function getSorts()
    {
        return count($this->sorts) ? " ORDER BY " . implode(", ", $this->sorts) : null;
    }

    public function addFilter($field, $values = [])
    {
        $this->whereClause .= $this->and;
        $numValues = count($values);
        $startIndex = count($this->boundData);

        if ($numValues === 1) {
            $key = "filter_{$startIndex}";
            if($values[0] === null) {
               $this->whereClause .= "{$field} is NULL";
            } else {
               $this->whereClause .= "{$field} = :$key";
               $this->boundData[$key] = reset($values);
            }
        } else {
            $this->whereClause .= "{$field} IN (";
            $comma = '';
            for ($i = 0; $i < $numValues; $i++) {
                $key = "filter_" . ($startIndex + $i);
                $this->whereClause .= "$comma:$key";
                $this->boundData[$key] = $values[$i];
                $comma = ' ,';
            }
            $this->whereClause .= ")";
        }
        $this->and = ' AND ';
        return $this;
    }

    public function setRawFilter($filter, $values)
    {
        $this->whereClause .= "{$this->and}$filter";
        $this->boundData += $values;
    }

    public function setFirstOnly($firstOnly)
    {
        $this->firstOnly = $firstOnly;
        return $this;
    }

    public function getFirstOnly()
    {
        return $this->firstOnly;
    }
    
    public function setLimit($numItems)
    {
        $this->limit = $numItems;
    }
    
    public function setOffset($offset)
    {
        $this->offset = $offset;
    }
    
    public function addSort($field, $direction = 'ASC')
    {
        $this->sorts[] = "$field $direction";
    }
}