function visitors_days_of_week_data in Visitors 7.2

Same name and namespace in other branches

1. 8 reports/days_of_week.inc \visitors_days_of_week_data()
2. 7 reports/days_of_week.inc \visitors_days_of_week_data()
3. 7.0 reports/days_of_week.inc \visitors_days_of_week_data()

Get data for days of week 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_week_data()

chart_visitors_days_of_week in reports/days_of_week.inc

Display days of week chart report.

visitors_days_of_week in reports/days_of_week.inc

Display days of week report.

File

reports/days_of_week.inc, line 40

Days of week report for the visitors module.

Code

function visitors_days_of_week_data() {
  $query = db_select('visitors', 'v');
  $query
    ->addExpression('COUNT(*)', 'count');
  $query
    ->addExpression(visitors_date_format_sql('visitors_date_time', '%a'), 'd');
  $query
    ->addExpression(visitors_date_format_sql('MIN(visitors_date_time)', '%w'), 'n');
  visitors_date_filter_sql_condition($query);
  $query
    ->groupBy('d');
  $query
    ->orderBy('n');
  return $query
    ->execute();
}