$HEAD[] = "<script type=\"text/javascript\" src=\"" . ENTRADA_URL . "/javascript/AutoCompleteList.js?release=" . html_encode(APPLICATION_VERSION) . "\"></script>";
$HEAD[] = "<script type=\"text/javascript\" src=\"" . ENTRADA_URL . "/javascript/picklist.js?release=" . html_encode(APPLICATION_VERSION) . "\"></script>\n";
$HEAD[] = "<script src=\"" . ENTRADA_URL . "/javascript/elementresizer.js\" type=\"text/javascript\"></script>\n";
/**
* Compiles the full list of reviewers.
*/
$REVIEWER_LIST = array();
$query = "\tSELECT a.`id` AS `proxy_id`, CONCAT_WS(', ', a.`lastname`, a.`firstname`) AS `fullname`, a.`organisation_id`\n\t\t\t\t\t\t\t\tFROM `" . AUTH_DATABASE . "`.`user_data` AS a\n\t\t\t\t\t\t\t\tLEFT JOIN `" . AUTH_DATABASE . "`.`user_access` AS b\n\t\t\t\t\t\t\t\tON b.`user_id` = a.`id`\n\t\t\t\t\t\t\t\tWHERE b.`app_id` = '" . AUTH_APP_ID . "'\n\t\t\t\t\t\t\t\tAND (b.`group` = 'faculty' OR (b.`group` = 'resident' AND b.`role` = 'lecturer') OR b.`group` = 'staff' OR b.`group` = 'medtech')\n\t\t\t\t\t\t\t\tORDER BY a.`lastname` ASC, a.`firstname` ASC";
$results = $db->GetAll($query);
if ($results) {
foreach ($results as $result) {
$REVIEWER_LIST[$result["proxy_id"]] = array('proxy_id' => $result["proxy_id"], 'fullname' => $result["fullname"], 'organisation_id' => $result['organisation_id']);
}
}
$EVALUATOR_LIST = array();
$evaluators = Models_Evaluation::getEvaluators($EVALUATION_ID);
if ($evaluators) {
foreach ($evaluators as $evaluator) {
$EVALUATOR_LIST[$evaluator["proxy_id"]] = array("proxy_id" => $evaluator["proxy_id"], "fullname" => $evaluator["fullname"], "organisation_id" => $evaluator["organisation_id"]);
}
}
if (has_error() || has_notice()) {
echo display_status_messages();
}
$ONLOAD[] = "initFormOptions()";
?>
<script type="text/javascript">
function initFormOptions() {
if ($('target_type_rotations') != undefined) {
var target_type = 'rotations';
if ($(target_type + '_options') != undefined) {
case "clerk":
$query .= "\tAND b.`group` = 'student' AND b.`role` >= '" . (date("Y") - (date("m") < 7 ? 2 : 1)) . "'";
break;
case "learners":
$query .= "\tAND (b.`group` = 'resident' OR (b.`group` = 'student' AND b.`role` >= '" . (date("Y") - (date("m") < 7 ? 2 : 1)) . "'))";
break;
case "director":
$query .= "\tAND b.`group` = 'faculty' AND (b.`role` = 'director' OR b.`role` = 'admin')";
break;
case "coordinator":
$query .= "\tAND b.`group` = 'staff' AND b.`role` = 'admin'";
break;
case "evaluators":
$evaluator_ids_string = "";
if (isset($_GET["id"]) && ($evaluation_id = clean_input($_GET["id"], "int"))) {
$evaluators = Models_Evaluation::getEvaluators($evaluation_id);
if ($evaluators) {
foreach ($evaluators as $evaluator) {
$evaluator_ids_string .= ($evaluator_ids_string ? ", " : "") . $db->qstr($evaluator["proxy_id"]);
}
}
}
$query .= " AND a.`id` IN (" . $evaluator_ids_string . ")";
break;
}
$query .= "\tAND b.`app_id` = " . $db->qstr(AUTH_APP_ID) . "\n\t\t\t\t\tAND b.`account_active` = 'true'\n\t\t\t\t\tAND (b.`access_starts`='0' OR b.`access_starts` <= " . $db->qstr(time()) . ")\n\t\t\t\t\tAND (b.`access_expires`='0' OR b.`access_expires` >= " . $db->qstr(time()) . ")\n\t\t\t\t\tGROUP BY a.`id`\n\t\t\t\t\tORDER BY `fullname` ASC";
echo "<ul>\n";
$results = $db->GetAll($query);
if ($results) {
foreach ($results as $result) {
echo "\t<li id=\"" . (int) $result["proxy_id"] . "\">" . html_encode($result["fullname"]) . "<span class=\"informal content-small\"><br />" . html_encode($result["organisation_title"]) . " - " . html_encode(ucfirst($result["group"])) . "<br />" . html_encode($result["email"]) . "</span></li>\n";
if ($report["type"] == "Course") {
echo "<td><h3>Course code:</h3></td><td>[{$type['code']}]</td></tr>";
} else {
echo "<td colspan=\"2\" /></tr>";
}
echo "\t<tr>\n";
echo "\t\t<td><h3> Evaluation period:</h3></td>\n";
echo "\t\t<td>" . date("M jS", $report["evaluation_start"]) . " - " . date("M jS Y", $report["evaluation_finish"]) . "</td>";
if ((int) $report["release_date"]) {
echo "\t<td><h3>Released:</h3></td>\n";
echo "\t<td>" . date("M jS Y", $report["release_date"]) . "</td>";
} else {
echo "\t<td colspan=\"2\"> </td>";
}
echo "\t</tr>\n";
$evaluators_list = Models_Evaluation::getEvaluators($report["evaluation"]);
$evaluators = count($evaluators_list);
if ($STUDENTS) {
$query = "\tSELECT COUNT(DISTINCT(a.`proxy_id`)) `total`, b.`group_name`\n\t\t\t\t\t\tFROM `group_members` a, `evaluation_evaluators` ev\n\t\t\t\t\t\tJOIN `groups` AS b\n\t\t\t\t\t\tON a.`group_id` = b.`group_id`\n\t\t\t\t\t\tWHERE ev.`evaluator_type` = 'cohort'\n\t\t\t\t\t\tAND ev.`evaluator_value` = a.`group_id`\n\t\t\t\t\t\tAND a.`member_active` = '1'\n\t\t\t\t\t\tAND ev.`evaluation_id` = " . $db->qstr($report["evaluation"]);
$class = $db->GetRow($query);
}
$updated = $db->GetOne("SELECT MAX(`updated_date`) FROM `evaluation_progress`\n\t\t\t\t\t\t\t\tWHERE `etarget_id` = " . $db->qstr($target) . " AND `progress_value` <> 'cancelled'");
$cancelled = $db->GetOne("\tSELECT COUNT(`eprogress_id`) FROM `evaluation_progress`\n\t\t\t\t\t\t\t\t\tWHERE `etarget_id` = " . $db->qstr($target) . " AND `progress_value` = 'cancelled'");
$progress = $db->GetOne("\tSELECT COUNT(`eprogress_id`) FROM `evaluation_progress`\n\t\t\t\t\t\t\t\t\tWHERE `etarget_id` = " . $db->qstr($target) . " AND `progress_value` = 'inprogress'");
$completed = $db->GetOne("\tSELECT COUNT(`eprogress_id`) FROM `evaluation_progress`\n\t\t\t\t\t\t\t\t\tWHERE `etarget_id` = " . $db->qstr($target) . " AND `progress_value` = 'complete'");
echo "<tr><td><h3>Evaluators:</h3></td>";
/**
* Calculate number of evaluators, the class, and extra indviduals not in the class.
*/
if ($STUDENTS && $class["total"] > 0) {
$indies = $evaluators - $class["total"];
