function views_handler_filter_date::op_between

3.x views_handler_filter_date.inc views_handler_filter_date::op_between($field)
2.x views_handler_filter_date.inc views_handler_filter_date::op_between($field)

Overrides views_handler_filter_numeric::op_between

File

handlers/views_handler_filter_date.inc, line 160
Definition of views_handler_filter_date.

Class

views_handler_filter_date
Filter to handle dates stored as a timestamp.

Code

function op_between($field) {
  $a = intval(strtotime($this->value['min'], 0));
  $b = intval(strtotime($this->value['max'], 0));

  if ($this->value['type'] == 'offset') {
    $a = '***CURRENT_TIME***' . sprintf('%+d', $a); // keep sign
    $b = '***CURRENT_TIME***' . sprintf('%+d', $b); // keep sign
  }
  // This is safe because we are manually scrubbing the values.
  // It is necessary to do it this way because $a and $b are formulas when using an offset.
  $operator = strtoupper($this->operator);
  $this->query->add_where_expression($this->options['group'], "$field $operator $a AND $b");
}