function rooms_booking_handler_date_filter::op_between in Rooms - Drupal Booking for Hotels, B&Bs and Vacation Rentals 7

Overrides views_handler_filter_date::op_between

File

modules/rooms_booking/views/rooms_booking_handler_date_filter.inc, line 18

Filter to handle dates stored as a string.

Class

rooms_booking_handler_date_filter

@file Filter to handle dates stored as a string.

Code

function op_between($field) {

  // Use the substitutions to ensure a consistent timestamp.
  $query_substitutions = views_views_query_substitutions($this->view);
  $a = date('Y-m-d', intval(strtotime($this->value['min'], $query_substitutions['***CURRENT_TIME***'])));
  $b = date('Y-m-d', 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}'");
}