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(); } /** * Display days of month report. * * @return * string days of month report html source */ function visitors_days_of_month() { $header = array( array('data' => t('#')), array('data' => t('Day'), 'field' => 'day', 'sort' => 'asc'), array('data' => t('Pages'), 'field' => 'count'), ); $results = visitors_days_of_month_data($header); $rows = array(); $i = 0; $count = 0; foreach ($results as $data) { $rows[] = array( ++$i, (int) $data->day, $data->count ); $count += $data->count; } $output = visitors_date_filter(); if ($count > 0) { $output .= sprintf( '', url('visitors/days_of_month/chart'), t('Days of month'), visitors_get_chart_width(), visitors_get_chart_height() ); } $output .= theme('table', array('header' => $header, 'rows' => $rows)); return $output; } /** * Display days of month chart report. */ function chart_visitors_days_of_month() { $results = visitors_days_of_month_data(NULL); $rows = array(); for ($i = 1; $i <= 31; $i++) { $rows[$i] = 0; } foreach ($results as $data) { $rows[(int)$data->day] = (int)$data->count; } // build dates series $dates = range(1, 31); visitors_chart($rows, $dates); }