nabble/ajde

<?php

class Ajde_Filter_HavingGroup extends Ajde_Filter
{
    protected $_filters;
    protected $_operator;

    public function __construct($operator = Ajde_Query::OP_AND)
    {
        $this->_operator = $operator;
    }

    public function addFilter(Ajde_Filter $filter)
    {
        $this->_filters[] = $filter;
    }

    public function hasFilters()
    {
        return !empty($this->_filters);
    }

    public function prepare(Ajde_Db_Table $table = null)
    {
        $sqlWhere = '';
        $first = true;
        $values = [];
        foreach ($this->_filters as $filter) {
            $prepared = $filter->prepare($table);
            foreach ($prepared as $queryPart => $v) {
                switch ($queryPart) {
                    case 'having':
                        if ($first === false) {
                            $sqlWhere .= ' '.$v['arguments'][1];
                        }
                        $sqlWhere .= ' '.$v['arguments'][0];
                        $first = false;
                        if (isset($v['values'])) {
                            $values = array_merge($values, $v['values']);
                        }
                        break;
                }
            }
        }

        if (!$sqlWhere) {
            $sqlWhere = 1;
        }

        return [
            'having' => [
                'arguments' => ['('.$sqlWhere.')', $this->_operator],
                'values'    => $values,
            ],
        ];
    }
}