foreach ($PODCAST_OUTPUT as $result) { $primary_contact = array(); $other_contacts = array(); $other_contacts_names = array(); $squery = "\n\t\t\t\t\t\t\tSELECT a.`proxy_id`, CONCAT_WS(' ', b.`firstname`, b.`lastname`) AS `fullname`, b.`email`\n\t\t\t\t\t\t\tFROM `event_contacts` AS a\n\t\t\t\t\t\t\tLEFT JOIN `" . AUTH_DATABASE . "`.`user_data` AS b\n\t\t\t\t\t\t\tON b.`id` = a.`proxy_id`\n\t\t\t\t\t\t\tWHERE a.`event_id` = " . $db->qstr($result["event_id"]) . "\n\t\t\t\t\t\t\tAND b.`id` IS NOT NULL\n\t\t\t\t\t\t\tORDER BY a.`contact_order` ASC"; $sresults = $db->GetAll($squery); if ($sresults) { foreach ($sresults as $key => $sresult) { if (!(int) $key) { $primary_contact = array("proxy_id" => $sresult["proxy_id"], "fullname" => $sresult["fullname"], "email" => $sresult["email"]); } else { $other_contacts[] = array("proxy_id" => $sresult["proxy_id"], "fullname" => $sresult["fullname"], "email" => $sresult["email"]); } } } $description = "Course: " . ($result["course_id"] ? "<a href=\"" . ENTRADA_URL . "/courses?id=" . $result["course_id"] . "\">" . fetch_course_title($result["course_id"]) . "</a> " . ($result["course_num"] ? "(" . $result["course_num"] . ")" : "") : "Not Filed") . "<br />"; $description .= "Associated Faculty:"; $description .= "<ol>"; if (count($primary_contact)) { $description .= "<li>" . html_encode($primary_contact["fullname"]) . ": <a href=\"mailto:" . $primary_contact["email"] . "\">" . $primary_contact["email"] . "</a></li>"; if (count($other_contacts)) { foreach ($other_contacts as $other_contact) { $description .= "<li>" . html_encode($other_contact["fullname"]) . ": <a href=\"mailto:" . $other_contact["email"] . "\">" . $other_contact["email"] . "</a></li>"; } } } else { $description .= "<li>To Be Announced</li>"; } $description .= "</ol><br /><br />"; $description .= "Cohort: " . html_encode(groups_get_name($result["event_cohort"])) . "<br />"; $description .= "Phase: " . strtoupper($result["event_phase"]) . "<br />";
* This section is loaded when an individual wants to attempt a quiz. * * @author Organisation: Queen's University * @author Unit: School of Medicine * @author Developer: Matt Simpson <*****@*****.**> * @copyright Copyright 2010 Queen's University. All Rights Reserved. * */ if (!defined("PARENT_INCLUDED") || !defined("IN_PUBLIC_GRADEBOOK")) { exit; } elseif (!isset($_SESSION["isAuthorized"]) || !$_SESSION["isAuthorized"]) { header("Location: " . ENTRADA_URL); exit; } if ($COURSE_ID) { $course_title = fetch_course_title($COURSE_ID); $BREADCRUMB[] = array("url" => ENTRADA_URL . "/profile/gradebook", "title" => $course_title); $group_ids = groups_get_enrolled_group_ids($ENTRADA_USER->getId()); $group_ids_string = implode(', ', $group_ids); $query = "\tSELECT b.*, c.*, d.`handler`, AVG(e.`value`) as `mean`\n\t\t\t\tFROM `courses` AS a\n\t\t\t\tJOIN `assessments` AS b\n\t\t\t\tON a.`course_id` = b.`course_id`\n\t\t\t\tAND b.`cohort` IN(" . $group_ids_string . ")\n\t\t\t\tJOIN `assessment_grades` AS c\n\t\t\t\tON b.`assessment_id` = c.`assessment_id`\n\t\t\t\tAND c.`proxy_id` = " . $db->qstr($ENTRADA_USER->getID()) . "\n\t\t\t\tJOIN `assessment_marking_schemes` AS d\n\t\t\t\tON b.`marking_scheme_id` = d.`id`\n JOIN `assessment_grades` AS e\n ON b.`assessment_id` = e.`assessment_id`\n\t\t\t\tWHERE a.`course_id` = " . $db->qstr($COURSE_ID) . "\n\t\t\t\tAND b.`active` = 1\n\t\t\t\tAND (b.`release_date` = '0' OR b.`release_date` <= " . $db->qstr(time()) . ")\n\t\t\t\tAND (b.`release_until` = '0' OR b.`release_until` >= " . $db->qstr(time()) . ")\n\t\t\t\tAND b.`show_learner` = '1'\n GROUP BY e.`assessment_id`\n\t\t\t\tORDER BY `order` ASC"; $results = $db->GetAll($query); if ($results) { ?> <h1><?php echo $course_title; ?> Gradebook</h1> <table class="tableList" cellspacing="0" summary="List of Assessments"> <colgroup> <col class="title" /> <col class="assessment-type" />
/** * Returns all audience members for the specified learning event. * * @global object $db * @param int $event_id * @return array */ function events_fetch_event_audience($event_id = 0) { global $db; $output = array(); $event_id = (int) $event_id; if ($event_id) { $query = "SELECT * FROM `event_audience` WHERE `event_id` = " . $db->qstr($event_id); $results = $db->GetAll($query); if ($results) { // This puts them in the display order I want them in. $output = array("course_id" => array(), "cohort" => array(), "group_id" => array(), "proxy_id" => array()); foreach ($results as $result) { $row = array("type" => $result["audience_type"], "link" => "", "title" => "", "count" => 0); switch ($result["audience_type"]) { case "course_id": // Course Audience $row["link"] = ENTRADA_URL . "/courses?id=" . $result["audience_value"]; $row["title"] = fetch_course_title($result["audience_value"]); break; case "cohort": // Cohorts $row["title"] = fetch_group_title($result["audience_value"]); break; case "group_id": // Course Groups $cgroup = course_fetch_course_group($result["audience_value"]); $row["title"] = $cgroup["group_name"]; $row["count"] = $cgroup["members"]; break; case "proxy_id": // Learners $row["link"] = ENTRADA_URL . "/people?id=" . $result["audience_value"]; $row["title"] = get_account_data("fullname", $result["audience_value"]); break; default: // No longer supported, but include the value just in case. $row["title"] = $result["audience_value"]; application_log("notice", "audience_type [" . $result["audience_type"] . "] is no longer supported, but is used in event_id [" . $event_id . "]."); break; } if ($row["title"]) { $output[$result["audience_type"]][] = $row; } } } } return $output; }
echo "\t\t</ol>"; echo "\t</div>\n"; echo "</div>\n"; if (count($report_results)) { $absolute_final_total = 0; foreach ($report_results as $course_id => $course_teachers) { $OTHER_DIRECTORS = array(); $sub_query = "SELECT `proxy_id` FROM `course_contacts` WHERE `course_contacts`.`course_id` = " . $db->qstr($course_id) . " AND `course_contacts`.`contact_type` = 'director' ORDER BY `contact_order` ASC"; $sub_results = $db->GetAll($sub_query); if ($sub_results) { foreach ($sub_results as $sub_result) { $OTHER_DIRECTORS[] = $sub_result["proxy_id"]; } } if ((int) $course_id) { $course_name = ($tmp_course_name = fetch_course_title($course_id)) ? $tmp_course_name : "Unknown Course Name"; } else { $course_name = "Learning Events With No Assigned Course"; } $course_final_total = 0; echo "<a name=\"" . $course_sidebar[$course_id]["course_link"] . "\"></a>\n"; echo "<h1>" . html_encode($course_name) . "</h1>"; echo "<div style=\"margin-left: 0px\">\n"; $query = "\tSELECT * FROM `courses` \n\t\t\t\t\t\tWHERE `course_id` = " . $db->qstr($course_id) . "\n\t\t\t\t\t\tAND `course_active` = '1'"; $result = $db->CacheGetRow(LONG_CACHE_TIMEOUT, $query); if ($result) { echo "<h2>Course Details</h2>\n"; echo "<table style=\"width: 100%\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\" summary=\"Detailed Course Information\">\n"; echo "<colgroup>\n"; echo "\t<col style=\"width: 22%\" />\n"; echo "\t<col style=\"width: 78%\" />\n";