public function availability_calendar_handler_filter_sql_date::op_simple in Availability Calendars 7.5

Overrides the parent method to use date only arithmetic and to format the value as an ISO date as accepted and expected by the databases.

Overrides views_handler_filter_date::op_simple

File

views/availability_calendar_handler_filter_sql_date.inc, line 51

Class

availability_calendar_handler_filter_sql_date

Defines a filter handler for sql date types.

Code

public function op_simple($field) {
  if ($this->value['type'] === 'offset') {

    // Date relative to now.
    $value = new DateTime('@' . REQUEST_TIME);
    $value
      ->modify($this->value['value']);
  }
  else {

    // Absolute date.
    $value = new DateTime($this->value['min']);
  }

  // Cut off any time parts and format as ISO date.
  $value
    ->setTime(0, 0, 0);
  $value = $value
    ->format(AC_ISODATE);
  $this->query
    ->add_where_expression($this->options['group'], "{$field} {$this->operator} '{$value}'");
}