function _get_quiz_grade_range_chart in Quiz 7.5
Same name and namespace in other branches
- 8.6 modules/quiz_stats/quiz_stats.admin.inc \_get_quiz_grade_range_chart()
- 8.4 modules/quiz_stats/quiz_stats.admin.inc \_get_quiz_grade_range_chart()
- 8.5 modules/quiz_stats/quiz_stats.admin.inc \_get_quiz_grade_range_chart()
- 6.6 includes/quiz_dashboard/quiz_dashboard.admin.inc \_get_quiz_grade_range_chart()
- 6.4 includes/quiz_stats/quiz_stats.admin.inc \_get_quiz_grade_range_chart()
- 7.6 modules/quiz_stats/quiz_stats.admin.inc \_get_quiz_grade_range_chart()
- 7 includes/quiz_stats/quiz_stats.admin.inc \_get_quiz_grade_range_chart()
- 7.4 includes/quiz_stats/quiz_stats.admin.inc \_get_quiz_grade_range_chart()
- 6.x modules/quiz_stats/quiz_stats.admin.inc \_get_quiz_grade_range_chart()
Generates grade range chart.
Parameters
int $vid: Revision id of quiz node.
int $uid: An optional user ID. If supplied, only quizzes created by that user will be returned.
Return value
array|false Array with chart and metadata, FALSE if no quiz was found.
1 call to _get_quiz_grade_range_chart()
- quiz_stats_get_adv_stats in modules/
quiz_stats/ quiz_stats.admin.inc - Get stats for a single quiz. Maybe also for a single user.
File
- modules/
quiz_stats/ quiz_stats.admin.inc, line 97 - Administration file for Quiz stats Module.
Code
function _get_quiz_grade_range_chart($vid, $uid = 0) {
// @todo: make the ranges configurable
$query = db_select('quiz_node_results', 'qnr');
$query
->addExpression('SUM(score >= 0 && score < 20)', 'zero_to_twenty');
$query
->addExpression('SUM(score >= 20 && score < 40)', 'twenty_to_fourty');
$query
->addExpression('SUM(score >= 40 && score < 60)', 'fourty_to_sixty');
$query
->addExpression('SUM(score >= 60 && score < 80)', 'sixty_to_eighty');
$query
->addExpression('SUM(score >= 80 && score <= 100)', 'eighty_to_hundred');
$query
->condition('qnr.vid', $vid);
$query
->condition('qnr.is_invalid', 0);
if ($uid != 0) {
$query
->condition('qnr.uid', $uid);
}
$range = $query
->execute()
->fetch();
$count = $range->zero_to_twenty + $range->twenty_to_fourty + $range->fourty_to_sixty + $range->sixty_to_eighty + $range->eighty_to_hundred;
if ($count < 2) {
return FALSE;
}
// Return the chart with some meta data.
$chart = '<div id="quiz_top_scorers" class="quiz-stats-chart-space">';
$chart .= theme('quiz_grade_range', array(
'range' => $range,
));
$chart .= '</div>';
return array(
'chart' => $chart,
'title' => t('Distribution'),
'explanation' => t('This chart shows the distribution of the scores on this quiz.'),
);
}