</td>
<td><?php
$startend_date_format = _AT('startend_date_format');
echo AT_date($startend_date_format, $row['date_taken'], AT_DATE_MYSQL_DATETIME);
?>
</td>
<td><?php
echo get_human_time($row['time_spent']);
?>
</td>
<td align="center">
<?php
if ($out_of) {
if ($random) {
$out_of = get_random_outof($tid, $row['result_id']);
}
if ($row['final_score'] != '') {
echo $row['final_score'] . '/' . $out_of;
} else {
echo _AT('unmarked');
}
} else {
echo _AT('na');
}
?>
</td>
</tr>
<?php
}
} else {
function get_class_avg($gradebook_test_id)
{
global $db;
$sql = "SELECT * FROM " . TABLE_PREFIX . "gradebook_tests WHERE gradebook_test_id=" . $gradebook_test_id;
$result = mysql_query($sql, $db) or die(mysql_error());
$row = mysql_fetch_assoc($result);
if ($row["id"] != 0) {
require_once AT_INCLUDE_PATH . '../mods/_standard/tests/lib/test_result_functions.inc.php';
$sql_test = "SELECT * FROM " . TABLE_PREFIX . "tests WHERE test_id=" . $row["id"];
$result_test = mysql_query($sql_test, $db) or die(mysql_error());
$row_test = mysql_fetch_assoc($result_test);
if ($row_test['out_of'] == 0 || $row_test['result_release'] == AT_RELEASE_NEVER) {
return _AT("na");
}
$sql_marks = "SELECT * FROM " . TABLE_PREFIX . "tests_results WHERE test_id=" . $row["id"] . " AND status=1";
$result_marks = mysql_query($sql_marks, $db) or die(mysql_error());
$num_students = 0;
$total_final_score = 0;
$total_out_of = 0;
while ($row_marks = mysql_fetch_assoc($result_marks)) {
if ($row_marks['final_score'] == '') {
continue;
}
$num_students++;
$total_final_score += $row_marks["final_score"];
if ($row_test['random']) {
$total_out_of += get_random_outof($row_marks['test_id'], $row_marks['result_id']);
} else {
$total_out_of += $row_test['out_of'];
}
}
if ($num_students > 0) {
$avg_final_score = round($total_final_score / $num_students);
$avg_out_of = round($total_out_of / $num_students);
}
if ($avg_final_score != "") {
$avg_grade = get_mark_by_grade($row["grade_scale_id"], $avg_final_score, $avg_out_of);
} else {
$avg_grade = "";
}
} else {
$sql_grades = "SELECT * FROM " . TABLE_PREFIX . "gradebook_detail WHERE gradebook_test_id=" . $gradebook_test_id . " ORDER BY grade";
$result_grades = mysql_query($sql_grades, $db) or die(mysql_error());
$grade_array = array();
while ($row_grades = mysql_fetch_assoc($result_grades)) {
$grade_array[] = $row_grades["grade"];
}
$avg_grade = median($grade_array);
}
if ($avg_grade == "") {
return _AT("na");
} else {
return $avg_grade;
}
}
$csv_content .= ', ' . quote_csv(_AT('location'));
$csv_content .= ', ' . quote_csv(_AT('role'));
$csv_content .= ', ' . quote_csv(_AT('focus'));
break;
}
}
// reset $result for next loop
mysql_data_seek($result, 0);
$csv_content .= "\n";
$sql2 = "SELECT anonymous FROM " . TABLE_PREFIX . "tests WHERE test_id={$tid} AND course_id={$_SESSION['course_id']}";
$result2 = mysql_query($sql2, $db);
$row2 = mysql_fetch_array($result2);
$anonymous = $row2['anonymous'];
while ($row = mysql_fetch_assoc($result)) {
if ($random) {
$total_weight = get_random_outof($row['test_id'], $row['result_id']);
}
// display passed student
if ($_POST['student_type'] == 'all' || $_POST['student_type'] == 'passed' && ($passscore != 0 && $row['final_score'] >= $passscore || $passpercent != 0 && $row['final_score'] / $total_weight * 100 >= $passpercent)) {
display_test_info($row, $anonymous);
} elseif ($_POST['student_type'] == 'all' || $_POST['student_type'] == 'failed' && ($passscore != 0 && $row['final_score'] < $passscore || $passpercent != 0 && $row['final_score'] / $total_weight * 100 < $passpercent)) {
display_test_info($row, $anonymous);
} elseif ($_POST['student_type'] == 'all') {
display_test_info($row, $anonymous);
}
}
$table_content .= '</tbody>';
$table_content .= '<tfoot>';
$table_content .= '<tr>';
$table_content .= '<td colspan="3" align="right"><strong>' . _AT('average') . ':</strong></td>';
$table_content .= '<td align="center"><strong>' . number_format($total_score / $num_results, 1) . '</strong></td>';
$this_course_id = 0;
do {
echo '<tr>';
echo '<td><strong>' . AT_print($row['title'], 'tests.title') . '</strong></td>';
echo '<td>' . AT_date($startend_date_long_format, $row['date_taken']) . '</td>';
echo '<td>' . get_human_time($row['diff']) . '</td>';
echo '<td>';
if ($row['out_of'] == 0) {
echo _AT('na');
} elseif ($row['final_score'] == '') {
echo _AT('unmarked');
} elseif ($row['final_score'] != '' && $row['result_release'] == AT_RELEASE_NEVER) {
echo _AT('unreleased');
} else {
if ($row['random']) {
$out_of = get_random_outof($row['test_id'], $row['result_id']);
} else {
$out_of = $row['out_of'];
}
echo '<strong>' . $row['final_score'] . '</strong>/' . $out_of;
}
echo '</td>';
echo '<td>';
if ($row['result_release'] == AT_RELEASE_IMMEDIATE || $row['final_score'] != '' && $row['result_release'] == AT_RELEASE_MARKED) {
echo '<a href="mods/_standard/tests/view_results.php?tid=' . $row['test_id'] . SEP . 'rid=' . $row['result_id'] . '">' . _AT('view_results') . '</a>';
} else {
echo '<strong>' . _AT('no_results_yet') . '</strong>';
}
echo '</td>';
echo '</tr>';
} while ($row = mysql_fetch_assoc($result));
function get_class_avg($gradebook_test_id)
{
$sql = "SELECT * FROM %sgradebook_tests WHERE gradebook_test_id=%d";
$row = queryDB($sql, array(TABLE_PREFIX, $gradebook_test_id), TRUE);
if ($row["id"] != 0) {
require_once AT_INCLUDE_PATH . '../mods/_standard/tests/lib/test_result_functions.inc.php';
$sql_test = "SELECT * FROM %stests WHERE test_id=%d";
$row_test = queryDB($sql_test, array(TABLE_PREFIX, $row["id"]), TRUE);
if ($row_test['out_of'] == 0 || $row_test['result_release'] == AT_RELEASE_NEVER) {
return _AT("na");
}
$sql_marks = "SELECT * FROM %stests_results WHERE test_id=%d AND status=1";
$rows_marks = queryDB($sql_marks, array(TABLE_PREFIX, $row["id"]));
$num_students = 0;
$total_final_score = 0;
$total_out_of = 0;
foreach ($rows_marks as $row_marks) {
if ($row_marks['final_score'] == '') {
continue;
}
$num_students++;
$total_final_score += $row_marks["final_score"];
if ($row_test['random']) {
$total_out_of += get_random_outof($row_marks['test_id'], $row_marks['result_id']);
} else {
$total_out_of += $row_test['out_of'];
}
}
if ($num_students > 0) {
$avg_final_score = round($total_final_score / $num_students);
$avg_out_of = round($total_out_of / $num_students);
}
if ($avg_final_score != "") {
$avg_grade = get_mark_by_grade($row["grade_scale_id"], $avg_final_score, $avg_out_of);
} else {
$avg_grade = "";
}
} else {
$sql_grades = "SELECT * FROM %sgradebook_detail WHERE gradebook_test_id= %d ORDER BY grade";
$rows_grades = queryDB($sql_grades, array(TABLE_PREFIX, $gradebook_test_id));
$grade_array = array();
foreach ($rows_grades as $row_grades) {
$grade_array[] = $row_grades["grade"];
}
$avg_grade = median($grade_array);
}
if ($avg_grade == "") {
return _AT("na");
} else {
return $avg_grade;
}
}
