function visitors_days_of_month_data in Visitors 7.2

Same name and namespace in other branches

1. 8 reports/days_of_month.inc \visitors_days_of_month_data()
2. 7 reports/days_of_month.inc \visitors_days_of_month_data()
3. 7.0 reports/days_of_month.inc \visitors_days_of_month_data()

Get data for days of month report order the query based on a header array.

Parameters

header: Table header array. If header is NULL - data is not sorted.

Return value

hours data array

2 calls to visitors_days_of_month_data()

chart_visitors_days_of_month in reports/days_of_month.inc

Display days of month chart report.

visitors_days_of_month in reports/days_of_month.inc

Display days of month report.

File

reports/days_of_month.inc, line 17

Days of month report for the visitors module.

Code

function visitors_days_of_month_data($header) {
  $query = db_select('visitors', 'v');
  $query
    ->addExpression('COUNT(*)', 'count');
  $query
    ->addExpression(visitors_date_format_sql('visitors_date_time', '%d'), 'day');
  $query
    ->groupBy('day');
  visitors_date_filter_sql_condition($query);
  if (!is_null($header)) {
    $query
      ->extend('TableSort')
      ->orderByHeader($header);
  }
  return $query
    ->execute();
}