doctrine / dbal

     *

     * @see where()

     */

    public function andWhere($where)

    {

        $args = func_get_args();

        $where = $this->getQueryPart('where');

        if ($where instanceof CompositeExpression && $where->getType() === CompositeExpression::TYPE_AND) {

            $where->addMultiple($args);

        } else {

            array_unshift($args, $where);

            $where = new CompositeExpression(CompositeExpression::TYPE_AND, $args);

        }

        return $this->add('where', $where, true);

    }

    /**

     * Adds one or more restrictions to the query results, forming a logical

     *

     * @see where()

     */

    public function orWhere($where)

    {

        $args = func_get_args();

        $where = $this->getQueryPart('where');

        if ($where instanceof CompositeExpression && $where->getType() === CompositeExpression::TYPE_OR) {

            $where->addMultiple($args);

        } else {

            array_unshift($args, $where);

            $where = new CompositeExpression(CompositeExpression::TYPE_OR, $args);

        }

        return $this->add('where', $where, true);

    }

    /**

     * Specifies a grouping over the results of the query.

     *

     * @return $this This QueryBuilder instance.

     */

    public function andHaving($having)

    {

        $args = func_get_args();

        $having = $this->getQueryPart('having');

        if ($having instanceof CompositeExpression && $having->getType() === CompositeExpression::TYPE_AND) {

            $having->addMultiple($args);

        } else {

            array_unshift($args, $having);

            $having = new CompositeExpression(CompositeExpression::TYPE_AND, $args);

        }

        return $this->add('having', $having);

    }

    /**

     * Adds a restriction over the groups of the query, forming a logical

     *

     * @return $this This QueryBuilder instance.

     */

    public function orHaving($having)

    {

        $args = func_get_args();

        $having = $this->getQueryPart('having');

        if ($having instanceof CompositeExpression && $having->getType() === CompositeExpression::TYPE_OR) {

            $having->addMultiple($args);

        } else {

            array_unshift($args, $having);

            $having = new CompositeExpression(CompositeExpression::TYPE_OR, $args);

        }

        return $this->add('having', $having);

    }

    /**

     * Specifies an ordering for the query results.