}
$query .= " GROUP BY b.`id`";
$query .= " ORDER BY `fullname`";
$students = $db->GetAll($query);
ob_start();
echo "\"Number\",\"Fullname\"";
$assessment_ids = array();
$indexed_assessments = array();
foreach ($assessments as $key => $assessment) {
$assessment_ids[] = $assessment["assessment_id"];
$indexed_assessments[$assessment["assessment_id"]] = $assessment;
$weight_heading = "";
if ($export_weighted_grades) {
$weight_heading = " [Weighting: " . $assessment["grade_weighting"] . "%]";
}
echo ",\"" . trim($assessment["name"]) . (" [" . (assessment_suffix($assessment) == "%" ? "Out of 100%" : ($assessment["handler"] == "Numeric" ? "Out of " . $assessment["numeric_grade_points_total"] . " marks" : ($assessment["handler"] == "Boolean" ? "P for Pass, F for Fail" : "C for Complete, I for Incomplete"))) . "]") . $weight_heading . " (" . trim($assessment["type"]) . ")\"";
}
$assessment_ids_string = "";
foreach ($assessment_ids as $assessment_id) {
$assessment_ids_string .= ($assessment_ids_string ? "," : "") . $db->qstr($assessment_id);
}
// foreach ($assessments as $key => $assessment) {
// $query .= " LEFT JOIN `".DATABASE_NAME."`.`assessment_grades` AS assessment_$key ON b.`id` = assessment_$key.`proxy_id` AND assessment_$key.`assessment_id` IN (".$db->qstr($assessment["assessment_id"]).")";
// }
if ($export_weighted_grades) {
echo ",\"Weighted Total\"";
}
if ($export_calculated_grades_enabled) {
echo ",\"" . (isset($export_calculated_grades->grade_long) && $export_calculated_grades->grade_long ? $export_calculated_grades->grade_long : "Rounded Total") . "\"";
}
// foreach ($assessments as $key => $assessment) {
"
data-proxy-id="<?php
echo $student["proxy_id"];
?>
"
style="float:left;"
><?php
echo $grade_value;
?>
</span>
<span class="gradesuffix" <?php
echo $grade_value === "-" ? "style=\"display: none;\"" : "";
?>
style="float:left;">
<?php
echo assessment_suffix($assessment);
?>
</span>
<span class="gradesuffix" style="float:right;">
<i class="icon-edit edit_grade" id="edit_grade_<?php
echo $assignment["assessment_id"] . "_" . $student["proxy_id"];
?>
"></i>
</span>
<?php
} else {
?>
No Assessment
<?php
}
?>
echo "\t<td>" . trim($mean_value) . assessment_suffix($result) . "</td>\n";
}
if (defined("GRADEBOOK_DISPLAY_MEDIAN_GRADE") && GRADEBOOK_DISPLAY_MEDIAN_GRADE) {
$query = "SELECT c.`value`\n FROM `courses` AS a\n JOIN `assessments` AS b\n ON a.`course_id` = b.`course_id`\n AND b.`cohort` IN(" . $group_ids_string . ")\n JOIN `assessment_grades` AS c\n ON b.`assessment_id` = c.`assessment_id`\n JOIN `assessment_marking_schemes` AS d\n ON b.`marking_scheme_id` = d.`id`\n JOIN `assessment_grades` AS e\n ON b.`assessment_id` = e.`assessment_id`\n WHERE a.`course_id` = " . $db->qstr($COURSE_ID) . "\n AND b.`active` = 1\n AND (b.`release_date` = '0' OR b.`release_date` <= " . $db->qstr(time()) . ")\n AND (b.`release_until` = '0' OR b.`release_until` >= " . $db->qstr(time()) . ")\n AND b.`assessment_id` = " . $db->qstr($result["assessment_id"]) . "\n ORDER BY c.`value` ASC";
$all_grades = $db->GetAll($query);
if ($all_grades) {
$n = count($all_grades);
$h = intval($n / 2);
if ($n % 2 == 0) {
$median_value = ($all_grades[$h]["value"] + $all_grades[$h - 1]["value"]) / 2;
} else {
$median_value = $all_grades[$h]["value"];
}
$median_value = format_retrieved_grade(round($median_value, 2), $result);
}
echo "\t<td>" . trim($median_value) . assessment_suffix($result) . "</td>\n";
}
if (defined("GRADEBOOK_DISPLAY_WEIGHTED_TOTAL") && GRADEBOOK_DISPLAY_WEIGHTED_TOTAL) {
$gradebook = gradebook_get_weighted_grades($result["course_id"], $ENTRADA_USER->getCohort(), $ENTRADA_USER->getID(), $result["assessment_id"]);
echo "\t<td>" . round(trim($gradebook["grade"]), 2) . " / " . trim($gradebook["total"]) . "</td>\n";
}
echo "\t<td style=\"text-align: right;\">" . ($grade_value === "-" ? "-" : ($result["handler"] == "Numeric" ? ($result["value"] === "0" ? "0" : trim(trim(number_format($grade_value / $result["numeric_grade_points_total"] * 100, 2), "0"), ".")) . "%" : ($result["handler"] == "Percentage" ? "N/A" : $grade_value))) . "</td>\n";
echo "</tr>\n";
}
?>
</tbody>
</table>
<?php
} else {
echo display_notice("No grades are available for any assessments in this course.");
}
