1 date_views_plugin_pager.inc public date_views_plugin_pager::query()

Transfer date information from the argument to the view.

The pager theme can use it and update the date argument value to whatever is set by the pager.

Overrides views_plugin_pager::query

File

core/modules/date/views/date_views_plugin_pager.inc, line 151
Date views pager plugin.

Class

date_views_plugin_pager
Date views pager plugin.

Code

public function query() {

  // By fetching our data from the exposed input, it is possible to
  // feed pager data through some method other than $_GET.
  $input = $this->view->get_exposed_input();
  $value = NULL;
  if (!empty($input) && !empty($input[$this->options['date_id']])) {
    $value = $input[$this->options['date_id']];
  }

  // Bring the argument information into the view so our theme can access it.
  $i = 0;
  foreach ($this->view->argument as $id => &$argument) {
    if (date_views_handler_is_date($argument, 'argument')) {

      // If the argument is empty, nothing to do. This could be from
      // an argument that does not set a default value.
      if (empty($argument->argument) || empty($argument->date_handler)) {
        continue;
      }

      // Storing this information in the pager so it's available
      // for summary info.
      // The view argument information is not otherwise accessible
      // to the pager. Not working right yet, tho.
      $date_handler = $argument->date_handler;
      $this->options['date_argument'] = $id;
      $this->options['granularity'] = $argument->date_handler->granularity;

      // Reset values set by argument if pager requires it.
      if (!empty($value)) {
        $this->set_argument_value($argument, $value);
      }

      // The pager value might move us into a forbidden range, so test it.
      if ($this->date_forbid($argument)) {
        $this->view->build_info['fail'] = TRUE;
        return;
      }
      // Write date_info to store information to be used
      // in the theming functions.
      if (empty($this->view->date_info)) {
        $this->view->date_info = new stdClass();
      }
      $this->view->date_info->granularity = $argument->date_handler->granularity;
      $format = $this->view->date_info->granularity == 'week' ? DATE_FORMAT_DATETIME : $argument->sql_format;
      $this->view->date_info->placeholders = isset($argument->placeholders) ? $argument->placeholders : $argument->date_handler->placeholders;
      $this->view->date_info->date_arg = $argument->argument;
      $this->view->date_info->date_arg_pos = $i;
      $this->view->date_info->limit = $argument->limit;
      $this->view->date_info->url = $this->view->get_url();
      $this->view->date_info->pager_id = $this->options['date_id'];
      $this->view->date_info->date_pager_position = $this->options['pager_position'];
      $this->view->date_info->date_pager_format = $this->options['link_format'];
      $this->view->date_info->skip_empty_pages = $this->options['skip_empty_pages'] == 1;
      // Execute two additional queries to find
      // the previous and next page with values.
      if ($this->view->date_info->skip_empty_pages) {
        $q = clone $argument->query;
        $field = $argument->table_alias . '.' . $argument->real_field;
        $fieldsql = $date_handler->sql_field($field);
        $fieldsql = $date_handler->sql_format($format, $fieldsql);
        $q->clear_fields();
        $q->orderby = array();
        $q->set_distinct(TRUE, TRUE);
        // Date limits of this argument.
        $datelimits = $argument->date_handler->arg_range($argument->limit[0] . '--' . $argument->limit[1]);
        // Find the first two dates between the minimum date
        // and the upper bound of the current value.
        $q->add_orderby(NULL, $fieldsql, 'DESC', 'date');
        $this->set_argument_placeholders($this->view->date_info->placeholders, $datelimits[0], $argument->max_date, $q, $format);

        $compiledquery = $q->query();
        $compiledquery->range(0, 2);
        $results = $compiledquery->execute()->fetchCol(0);

        $prevdate = array_shift($results);
        $prevdatealt = array_shift($results);
        // Find the first two dates between the lower bound
        // of the current value and the maximum date.
        $q->add_orderby(NULL, $fieldsql, 'ASC', 'date');
        $this->set_argument_placeholders($this->view->date_info->placeholders, $argument->min_date, $datelimits[1], $q, $format);

        $compiledquery = $q->query();
        $compiledquery->range(0, 2);
        $results = $compiledquery->execute()->fetchCol(0);

        $nextdate = array_shift($results);
        $nextdatealt = array_shift($results);

        // Set the default value of the query to $prevfirst or $nextfirst
        // when there is no value and $prevsecond or $nextsecond is set.
        if (empty($value)) {
          // @Todo find out which of $prevdate or $nextdate is closest to the
          // default argument date value and choose that one.
          if ($prevdate && $prevdatealt) {
            $this->set_argument_value($argument, $prevdate);
            $value = $prevdate;
            $prevdate = $prevdatealt;
            // If the first next date is the same as the first previous date,
            // move to the following next date.
            if ($value == $nextdate) {
              $nextdate = $nextdatealt;
              $nextdatealt = NULL;
            }
          }
          elseif ($nextdate && $nextdatealt) {
            $this->set_argument_value($argument, $nextdate);
            $value = $nextdate;
            $nextdate = $nextdatealt;
            // If the first previous date is the same as the first next date,
            // move to the following previous date.
            if ($value == $prevdate) {
              $prevdate = $prevdatealt;
              $prevdatealt = NULL;
            }
          }
        }
        else {
          // $prevdate and $nextdate are the same as $value, so move to
          // the next values.
          $prevdate = $prevdatealt;
          $nextdate = $nextdatealt;
        }

        $this->view->date_info->prev_date = $prevdate ? new BackdropDateTime($prevdate, NULL, $format) : NULL;
        $this->view->date_info->next_date = $nextdate ? new BackdropDateTime($nextdate, NULL, $format) : NULL;
      }
      else {
        $this->view->date_info->prev_date = clone($argument->min_date);
        date_modify($this->view->date_info->prev_date, '-1 ' . $argument->date_handler->granularity);
        $this->view->date_info->next_date = clone($argument->min_date);
        date_modify($this->view->date_info->next_date, '+1 ' . $argument->date_handler->granularity);
      }
      // Write the date_info properties that depend on the current value.
      $this->view->date_info->year = date_format($argument->min_date, 'Y');
      $this->view->date_info->month = date_format($argument->min_date, 'n');
      $this->view->date_info->day = date_format($argument->min_date, 'j');
      $this->view->date_info->week = date_week(date_format($argument->min_date, DATE_FORMAT_DATE));
      $this->view->date_info->date_range = $argument->date_range;
      $this->view->date_info->min_date = $argument->min_date;
      $this->view->date_info->max_date = $argument->max_date;
    }
    $i++;
  }

  // Is this a view that needs to be altered based on a pager value?
  // If there is pager input and the argument has set the placeholders,
  // swap the pager value in for the placeholder set by the argument.
  if (!empty($value) && !empty($this->view->date_info->placeholders)) {
    $this->set_argument_placeholders($this->view->date_info->placeholders, $this->view->date_info->min_date, $this->view->date_info->max_date, $this->view->query, $format);
  }
}