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 />";
Esempio n. 2
0
 * 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";