function views_handler_filter_numeric::op_between in Views (for Drupal 7) 6.3

Same name and namespace in other branches

1. 6.2 handlers/views_handler_filter_numeric.inc \views_handler_filter_numeric::op_between()
2. 7.3 handlers/views_handler_filter_numeric.inc \views_handler_filter_numeric::op_between()

3 methods override views_handler_filter_numeric::op_between()

views_handler_filter_date::op_between in handlers/views_handler_filter_date.inc

views_handler_filter_float::op_between in handlers/views_handler_filter_float.inc

views_handler_filter_group_by_numeric::op_between in handlers/views_handler_filter_group_by_numeric.inc

File

handlers/views_handler_filter_numeric.inc, line 268

Class

views_handler_filter_numeric

Simple filter to handle greater than/less than filters

Code

function op_between($field) {
  $is_null = $this
    ->check_for_null($field);
  if ($this->operator == 'between') {
    $this->query
      ->add_where($this->options['group'], "{$field} >= %d {$is_null}", $this->value['min']);
    $this->query
      ->add_where($this->options['group'], "{$field} <= %d {$is_null}", $this->value['max']);
  }
  else {
    $this->query
      ->add_where($this->options['group'], "{$field} <= %d OR {$field} >= %d {$is_null}", $this->value['min'], $this->value['max']);
  }
}