raivieira / base-api-php

     *

     * @return $this

     */

    public function andWhere($field, $operation, $value = null, $alias = self::DEFAULT_TABLE_ALIAS)

    {

        if (strpos($field, '.') > 0) {

            $newValues = $this->whereFieldJoin($field, $value, $operation);

            $alias = $newValues['alias'];

            $field = $newValues['field'];

        }

        $this->queryBuilder->andWhere($this->makeExpression($field, $operation, $value, $alias));

        return $this;

    }

    /**

     * Add a "or where" filter.

     *

     * @return $this

     */

    public function orWhere($field, $operation, $value = null, $alias = self::DEFAULT_TABLE_ALIAS)

    {

        if (strpos($field, '.') > 0) {

            $newValues = $this->whereFieldJoin($field, $value, $operation);

            $alias = $newValues['alias'];

            $field = $newValues['field'];

        }

        $this->queryBuilder->orWhere($this->makeExpression($field, $operation, $value, $alias));

        return $this;

    }

    /**

     * Add a join filter.

     * @param string $field

     * @param string $order

     */

    public function addOrderBy($field, $order = 'ASC')

    {

        $alias = self::DEFAULT_TABLE_ALIAS;

        if (strpos($field, '.') > 0) {

            $newValues = $this->whereFieldJoin($field);

            $alias = $newValues['alias'];

            $field = $newValues['field'];

        }

        $this->queryBuilder->addOrderBy($this->getFullFieldName($field, $alias), $order);

        return $this;

    }

    /**

     * Add a "order by" filter.