function visitors_get_years_range in Visitors 7.0
Same name and namespace in other branches
- 8 forms/date_filter.inc \visitors_get_years_range()
- 7.2 forms/date_filter.inc \visitors_get_years_range()
- 7 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'));
}