function visitors_get_years_range in Visitors 8

Same name and namespace in other branches

1. 7.2 forms/date_filter.inc \visitors_get_years_range()
2. 7 forms/date_filter.inc \visitors_get_years_range()
3. 7.0 forms/date_filter.inc \visitors_get_years_range()

Get year range for date fields visitors date filter. Min year - min value from {visitors} table. If min value does not exist - use current year. Max year - current year.

Return value

int array years array from min year to max year

1 call to visitors_get_years_range()

visitors_expand_date in forms/date_filter.inc

Roll out a single date element.

File

forms/date_filter.inc, line 47

Date filter form for the visitors module.

Code

function visitors_get_years_range() {

  /* TODO: use db_select() function. */
  $sql = sprintf('SELECT MIN(visitors_date_time) AS min_time
                  FROM {visitors}
                  LIMIT 1');
  $result = db_query($sql);
  $min_time = time();
  foreach ($result as $data) {
    $min_time = $data->min_time;
  }
  return range(date('Y', $min_time), date('Y'));
}