$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"];