public function views_handler_filter_date::op_between in Views (for Drupal 7) 7.3

Same name and namespace in other branches

1. 6.3 handlers/views_handler_filter_date.inc \views_handler_filter_date::op_between()
2. 6.2 handlers/views_handler_filter_date.inc \views_handler_filter_date::op_between()

Overrides views_handler_filter_numeric::op_between

File

handlers/views_handler_filter_date.inc, line 181

Definition of views_handler_filter_date.

Class

views_handler_filter_date

Filter to handle dates stored as a timestamp.

Code

public function op_between($field) {

  // Use the substitutions to ensure a consistent timestamp.
  $query_substitutions = views_views_query_substitutions($this->view);
  $a = intval(strtotime($this->value['min'], $query_substitutions['***CURRENT_TIME***']));
  $b = intval(strtotime($this->value['max'], $query_substitutions['***CURRENT_TIME***']));

  // 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}");
}