private function between($column, $a, $b, $prefix, $not = false, $operator = null, $filter = false)
    {
        if (!$this->isFilterable($filter, array($a, $b))) {
            return $this;
        }

        if ($operator !== null) {
            // A space before the operator is preferred
            $operator = sprintf(' %s', $operator);
        }

        // Handle NOT prefix
        if ($not === true) {
            $not = 'NOT';
        } else {
            $not = '';
        }

        $this->append($operator.sprintf(' %s %s %s BETWEEN %s AND %s ', $prefix, $this->quote($column), $not, $a, $b));
        return $this;
    }
private function between($column, $a, $b, $prefix, $not = false, $operator = null, $filter = false)
    {
        if (!$this->isFilterable($filter, array($a, $b))) {
            return $this;
        }

        if ($operator !== null) {
            // A space before the operator is preferred
            $operator = sprintf(' %s', $operator);
        }

        // Handle NOT prefix
        if ($not === true) {
            $not = 'NOT';
        } else {
            $not = '';
        }

        $this->append($operator.sprintf(' %s %s %s BETWEEN %s AND %s ', $prefix, $this->quote($column), $not, $a, $b));
        return $this;
    }
private function between ( $ column , $ a , $ b , $ prefix , $ not = false , $ operator = null , $ filter = false ) { if ( ! $ this -> isFilterable ( $ filter , array ( $ a , $ b ) ) ) { return $ this ; } if ( $ operator !== null ) { // A space before the operator is preferred $ operator = sprintf ( ' %s' , $ operator ) ; } // Handle NOT prefix if ( $ not === true ) { $ not = 'NOT' ; } else { $ not = '' ; } $ this -> append ( $ operator . sprintf ( ' %s %s %s BETWEEN %s AND %s ' , $ prefix , $ this -> quote ( $ column ) , $ not , $ a , $ b ) ) ; return $ this ; }
Appends WHERE with BETWEEN operator

@param string $column
@param string $a First value
@param string $b Second value
@param string $prefix The first prefix such as WHERE or AND or OR
@param boolean $not Whether it must be NOT BETWEEN or not
@param string $operator Optional operator to be prep-ended before WHERE clause
@param boolean $filter Whether to rely on filter
@return \Krystal\Db\Sql\QueryBuilder
Appends WHERE with BETWEEN operator