views_date_format_sql_handler_date.inc in Views Date Format SQL 7.3

This file contains the class to override views_handler_field_date.

File

includes/views_date_format_sql_handler_date.inc

<?php

/**
 * @file
 * This file contains the class to override views_handler_field_date.
 */

/**
 * Allows to removes the date formatting from render() and put it in query().
 */
class views_date_format_sql_handler_date extends views_handler_field_date {
  function option_definition() {
    $options = parent::option_definition();
    $options['format_date_sql'] = array(
      'default' => FALSE,
    );
    return $options;
  }
  function options_form(&$form, &$form_state) {
    parent::options_form($form, $form_state);
    $form['format_date_sql'] = array(
      '#type' => 'checkbox',
      '#title' => t('Use SQL to format date'),
      '#description' => t('Use the SQL database to format the date. This enables date values to be used in grouping aggregation.'),
      '#default_value' => $this->options['format_date_sql'],
    );
  }
  function query() {
    if ($this->options['format_date_sql'] != TRUE) {
      return parent::query();
    }
    $this
      ->ensure_my_table();

    // Add the field.
    $params = $this->options['group_type'] != 'group' ? array(
      'function' => $this->options['group_type'],
    ) : array();
    $format = $this->options['date_format'];
    $custom_format = $this->options['custom_date_format'];
    $format_string = _views_date_format_sql_get_date_format($format, $custom_format);
    $formula = views_date_sql_format($format_string, "{$this->table_alias}.{$this->real_field}");
    $this->field_alias = $this->query
      ->add_field(NULL, $formula, "{$this->table_alias}_{$this->real_field}", $params);
    $this->query
      ->add_groupby($this->field_alias);
    $this
      ->add_additional_fields();
  }
  function render($values) {
    if ($this->options['format_date_sql'] != TRUE) {
      return parent::render($values);
    }
    $format = $this->options['date_format'];
    return $this
      ->get_value($values);
  }

}

Classes

Name	Description
views_date_format_sql_handler_date	Allows to removes the date formatting from render() and put it in query().