date_views_fields.inc in Date 7

Helper for identifying Date API fields for views.

File

date_views/includes/date_views_fields.inc

<?php

/**
 * @file
 * Helper for identifying Date API fields for views.
 */

/**
 *  Identify all potential date/timestamp fields.
 *
 *  @return
 *    array with fieldname, type, and table.
 *  @see 
 *    date_views_date_views_fields() which implements 
 *    the hook_date_views_fields() for the core date fields.
 */
function _date_views_fields($base = 'node') {

  // Make sure $base is never empty.
  if (empty($base)) {
    $base = 'node';
  }
  $cid = 'date_views_fields_' . $base;
  cache_clear_all($cid, 'cache_views');
  $all_fields = date_views_views_fetch_fields($base, 'field');
  $content_fields = field_views_data();

  // Iterate over all the fields that Views knows about.
  $fields = array();
  foreach ((array) $all_fields as $alias => $val) {

    // Set up some default values.
    $granularity = array(
      'year',
      'month',
      'day',
      'hour',
      'minute',
    );
    $tz_handling = 'site';
    $related_fields = array();
    $timezone_field = '';
    $offset_field = '';
    $rrule_field = '';
    $delta_field = '';
    $sql_type = DATE_UNIX;
    $type = '';
    $name = $alias;
    $tmp = explode('.', $name);
    $field_name = $tmp[1];
    $table_name = $tmp[0];
    $fromto = array(
      str_replace('.', '_', $name),
      str_replace('.', '_', $name),
    );

    // If we don't have a field handler, we don't need to do anything more.
    if (!($handler = views_get_handler($table_name, $field_name, 'field'))) {
      continue;
    }
    $handler = views_get_handler($table_name, $field_name, 'field');
    $handler_name = $handler->definition['handler'];

    // For Field module fields, get the date type.
    $custom = array();
    if ($handler->definition['group'] == 'Fields') {

      //$field_name = $content_fields[$table_name]['entity_id']['field']['field_name'];
      $field = field_info_field($field_name);
      switch ($field['type']) {
        case 'date':
          $type = 'cck_string';
          $sql_type = DATE_ISO;
          break;
        case 'datestamp':
          $type = 'cck_timestamp';
          break;
        case 'datetime':
          $type = 'cck_datetime';
          $sql_type = DATE_DATETIME;
          break;
      }
      if (empty($type)) {

        // If this is not a date field, nothing more to do.
        continue;
      }
      $db_info = date_api_database_info($field);
      $name = $table_name . "." . $field_name . "_value";
      $granularity = !empty($field['granularity']) ? $field['granularity'] : array(
        'year',
        'month',
        'day',
        'hour',
        'minute',
      );
      $fromto = array(
        $table_name . '_' . $db_info['columns'][$table_name]['value'],
        $table_name . '_' . (!empty($field['settings']['todate']) ? $db_info['columns'][$table_name]['value2'] : $db_info['columns'][$table_name]['value']),
      );
      if (isset($field['settings']['tz_handling'])) {
        $tz_handling = $field['settings']['tz_handling'];
        $db_info = date_api_database_info($field);
        if ($tz_handling == 'date') {
          $offset_field = $table_name . '.' . $db_info['columns'][$table_name]['offset'];
        }
        $related_fields = array(
          $table_name . '.' . $db_info['columns'][$table_name]['value'],
        );
        if (isset($db_info['columns'][$table_name]['value2'])) {
          $related_fields = array_merge($related_fields, array(
            $table_name . '.' . $db_info['columns'][$table_name]['value2'],
          ));
        }
        if (isset($db_info['columns'][$table_name]['timezone'])) {
          $related_fields = array_merge($related_fields, array(
            $table_name . '.' . $db_info['columns'][$table_name]['timezone'],
          ));
          $timezone_field = $table_name . '.' . $db_info['columns'][$table_name]['timezone'];
        }
        if (isset($db_info['columns'][$table_name]['rrule'])) {
          $related_fields = array_merge($related_fields, array(
            $table_name . '.' . $db_info['columns'][$table_name]['rrule'],
          ));
          $rrule_field = $table_name . '.' . $db_info['columns'][$table_name]['rrule'];
        }
      }

      // Get the delta value into the query.
      if ($field['cardinality'] != 1) {
        array_push($related_fields, "{$table_name}.delta");
        $delta_field = $table_name . '_delta';
      }
    }
    elseif ($handler instanceof views_handler_field_date) {
      foreach (module_implements('date_views_fields') as $module) {
        $function = $module . '_date_views_fields';
        if ($custom = $function("{$table_name}.{$field_name}")) {
          $type = 'custom';
          break;
        }
      }
    }

    // Don't do anything if this is not a date field we can handle.
    if (!empty($type)) {
      $alias = str_replace('.', '_', $alias);
      $fields['name'][$name] = array(
        'type' => $type,
        'sql_type' => $sql_type,
        'label' => $val['group'] . ': ' . $val['title'],
        'granularity' => $granularity,
        'fullname' => $name,
        'table_name' => $table_name,
        'field_name' => $field_name,
        'query_name' => $alias,
        'fromto' => $fromto,
        'tz_handling' => $tz_handling,
        'offset_field' => $offset_field,
        'timezone_field' => $timezone_field,
        'rrule_field' => $rrule_field,
        'related_fields' => $related_fields,
        'delta_field' => $delta_field,
      );

      // Allow the custom fields to over-write values.
      if (!empty($custom)) {
        foreach ($custom as $key => $val) {
          $fields['name'][$name][$key] = $val;
        }
      }
      $fields['name'][$name]['real_field_name'] = $field_name == 'entity_id' ? $real_field_name : $field_name;

      // The D7 field handling is funny, there is only a single record
      // with a field name of 'entity_id'. We need the real names for our queries.
      // Fields also need an extra record so we have both from and to values.
      if (strstr($alias, 'entity_id')) {
        $field_name .= '_value';
        $fields['name'][$name]['field_name'] = $field_name;
        $alias = $table_name . '_' . $field_name;
        $fields['name'][$name]['query_name'] = $alias;
        $fields['alias'][$alias] = $fields['name'][$name];
        if (!empty($field['settings']['todate'])) {
          $fields['name'][$name]['label'] .= ' value';
          $name2 = str_replace('value', 'value2', $name);
          $alias2 = str_replace('value', 'value2', $alias);
          $fields['name'][$name2] = $fields['name'][$name];
          $fields['name'][$name2]['field_name'] = str_replace('value', 'value2', $field_name);
          $fields['name'][$name2]['label'] .= '2';
          $fields['name'][$name2]['fullname'] .= '2';
          $fields['alias'][$alias2] = $fields['name'][$name2];
        }
      }
      else {
        $fields['alias'][$alias] = $fields['name'][$name];
      }
    }
  }

  //cache_set($cid, $fields, 'cache_views');
  return $fields;
}

Functions

Name	Description
_date_views_fields	Identify all potential date/timestamp fields.