function chart_visitors_monthly_history in Visitors 7.2

Same name and namespace in other branches

1. 8 reports/monthly_history.inc \chart_visitors_monthly_history()
2. 7 reports/monthly_history.inc \chart_visitors_monthly_history()
3. 7.0 reports/monthly_history.inc \chart_visitors_monthly_history()

Display monthly history chart report.

1 string reference to 'chart_visitors_monthly_history'

visitors_menu in ./visitors.module

Menu callback. Prints a listing of active nodes on the site.

File

reports/monthly_history.inc, line 81

Monthly history report for the visitors module.

Code

function chart_visitors_monthly_history() {
  $query = db_select('visitors', 'v')
    ->extend('TableSort');
  $query
    ->addExpression('COUNT(*)', 'count');
  $query
    ->addExpression(visitors_date_format_sql('visitors_date_time', '%Y%m'), 'm');
  $query
    ->addExpression(visitors_date_format_sql('MIN(visitors_date_time)', '%Y %M'), 's');
  visitors_date_filter_sql_condition($query);
  $query
    ->groupBy('m');
  $query
    ->orderBy('m');
  $results = $query
    ->execute();
  $rows = array();
  $dates = array();
  foreach ($results as $data) {
    $rows[$data->s] = (int) $data->count;
    $dates[] = $data->s;
  }
  if (count($rows) > 1) {
    visitors_chart($rows, $dates);
  }
}