$ids[] = clean_param($dirty, PARAM_INT); } } else { $ids[] = clean_param($dirtyids, PARAM_INT); } } else { $ids[] = 0; } // Must have blank value as the default here (instead of zero) or it breaks the gas guage report $choices_array = array(array('', get_string('anyvalue', 'filters'))); if (sizeof($ids) > 0) { $contexts = get_contexts_by_capability_for_user('course', 'block/php_report:view', $USER->id); foreach ($ids as $id) { $records = false; if ($id > 0) { $records = curriculumcourse_get_listing($id, 'crs.name'); $idfield = 'courseid'; $namefield = 'coursename'; } else { if ($id == 0) { $records = course_get_listing(); $idfield = 'id'; $namefield = 'name'; } } if (is_array($records)) { foreach ($records as $record) { $choices_array[] = array($record->id, $record->{$namefield}); } } }
/** * Dynamically loads child menu items for a curriculum entity * * @param int $id The entity id * @param int $parent_cluster_id The last cluster passed going down the elisadmin tree, or 0 if none * @param int $parent_curriculum_id The last curriculum passed going down the elisadmin tree, or 0 if none * @param int $num_block_icons Max number of entries to display * @param string $parent_path Path of parent curriculum elements in the tree * @return menuitem array The appropriate child items */ function block_elisadmin_load_menu_children_curriculum($id, $parent_cluster_id, $parent_curriculum_id, $num_block_icons, $parent_path = '') { global $CFG; //page dependencies require_once elispm::file('pmclasspage.class.php'); $result_items = array(); /***************************************** * Curriculum - Course Associations *****************************************/ $course_css_class = block_elisadmin_get_item_css_class('course_instance'); //permissions filter $course_filter = array('contexts' => coursepage::get_contexts('local/elisprogram:course_view')); $listing = curriculumcourse_get_listing($id, 'position', 'ASC', 0, $num_block_icons, '', '', $course_filter); foreach ($listing as $item) { $item->id = $item->courseid; $params = array('id' => $item->id, 'action' => 'view'); //count associated classes $class_contexts = pmclasspage::get_contexts('local/elisprogram:class_view'); $class_count = pmclass_count_records('', '', $item->id, false, $class_contexts, $parent_cluster_id); $isLeaf = empty($class_count); $result_items[] = block_elisadmin_get_menu_item('course', $item, 'root', $course_css_class, $parent_cluster_id, $parent_curriculum_id, $params, $isLeaf, $parent_path); } unset($listing); //summary item $num_records = curriculumcourse_count_records($id, '', '', $course_filter); if ($num_block_icons < $num_records) { $params = array('id' => $id); $result_items[] = block_elisadmin_get_menu_summary_item('curriculumcourse', $course_css_class, $num_records - $num_block_icons, $params, '', $parent_path); } /***************************************** * Curriculum - Track Associations *****************************************/ $track_css_class = block_elisadmin_get_item_css_class('track_instance'); //permissions filter $track_contexts = trackpage::get_contexts('local/elisprogram:track_view'); if ($track_records = track_get_listing('name', 'ASC', 0, $num_block_icons, '', '', $id, $parent_cluster_id, $track_contexts)) { foreach ($track_records as $track_record) { $params = array('id' => $track_record->id, 'action' => 'view'); //count associated classes $class_contexts = array('contexts' => pmclasspage::get_contexts('local/elisprogram:class_view')); $class_count = track_assignment_count_records($track_record->id, '', '', $class_contexts); //count associated clusters $cluster_filter = array('contexts' => usersetpage::get_contexts('local/elisprogram:userset_view')); $cluster_count = clustertrack::count_clusters($track_record->id, $parent_cluster_id, $cluster_filter); $isLeaf = empty($class_count) && empty($cluster_count); $result_items[] = block_elisadmin_get_menu_item('track', $track_record, 'root', $track_css_class, $parent_cluster_id, $parent_curriculum_id, $params, $isLeaf, $parent_path); } } //summary item $num_records = track_count_records('', '', $id, $parent_cluster_id, $track_contexts); if ($num_block_icons < $num_records) { $params = array('id' => $id); //add extra param if appropriate if (!empty($parent_cluster_id)) { $params['parent_clusterid'] = $parent_cluster_id; } $result_items[] = block_elisadmin_get_menu_summary_item('track', $track_css_class, $num_records - $num_block_icons, $params, '', $parent_path); } /***************************************** * Curriculum - Cluster Associations *****************************************/ $cluster_css_class = block_elisadmin_get_item_css_class('cluster_instance'); //permissions filter $cluster_filter = array('contexts' => usersetpage::get_contexts('local/elisprogram:userset_view')); $clusters = clustercurriculum::get_clusters($id, $parent_cluster_id, 'name', 'ASC', 0, $num_block_icons, $cluster_filter); //$clusters = clustercurriculum::get_clusters($id, $parent_cluster_id, 'priority, name', 'ASC', 0, $num_block_icons); if (!empty($clusters)) { foreach ($clusters as $cluster) { $cluster->id = $cluster->clusterid; $params = array('id' => $cluster->id, 'action' => 'view'); $result_items[] = block_elisadmin_get_menu_item('userset', $cluster, 'root', $cluster_css_class, $cluster->id, $parent_curriculum_id, $params, false, $parent_path); } } //summary item $num_records = clustercurriculum::count_clusters($id, $parent_cluster_id, $cluster_filter); if ($num_block_icons < $num_records) { $params = array('id' => $id); //add extra param if appropriate if (!empty($parent_cluster_id)) { $params['parent_clusterid'] = $parent_cluster_id; } $result_items[] = block_elisadmin_get_menu_summary_item('curriculumcluster', $cluster_css_class, $num_records - $num_block_icons, $params, 'clustercurriculumpage.class.php', $parent_path); } return $result_items; }
/** * Get the user dashboard report view. * * @uses $CFG, $CURMAN * @param none * @return string The HTML for the dashboard report. */ function get_dashboard() { global $CFG, $CURMAN; require_once CURMAN_DIRLOCATION . '/lib/curriculumstudent.class.php'; //needed for AJAX calls require_js(array('yui_yahoo', 'yui_dom', 'yui_event', 'yui_connection', "{$CFG->wwwroot}/curriculum/js/util.js", "{$CFG->wwwroot}/curriculum/js/dashboard.js"), true); if (optional_param('tab', '', PARAM_CLEAN) == 'archivedlp') { $tab = 'archivedlp'; $show_archived = 1; } else { $tab = 'currentlp'; $show_archived = 0; } $content = ''; $archive_var = '_elis_curriculum_archive'; $totalcourses = 0; $totalcurricula = 0; $completecourses = 0; $curriculas = array(); $classids = array(); $sql = 'SELECT curstu.id, curstu.curriculumid as curid, cur.name as name FROM ' . $CURMAN->db->prefix_table(CURASSTABLE) . ' curstu JOIN ' . $CURMAN->db->prefix_table(CURTABLE) . ' cur ON cur.id = curstu.curriculumid WHERE curstu.userid = \'' . $this->id . '\' ORDER BY cur.priority ASC, cur.name ASC'; if ($usercurs = get_records_sql($sql)) { foreach ($usercurs as $usercur) { // Check if this curricula is set as archived and whether we want to display it $crlm_context = get_context_instance(context_level_base::get_custom_context_level('curriculum', 'block_curr_admin'), $usercur->curid); $data_array = field_data::get_for_context_and_field($crlm_context, $archive_var); $crlm_archived = 0; if (is_array($data_array) && !empty($data_array)) { foreach ($data_array as $data_key => $data_obj) { $crlm_archived = !empty($data_obj->data) ? 1 : 0; } } if ($show_archived == $crlm_archived) { $totalcurricula++; $curriculas[$usercur->curid]['id'] = $usercur->curid; $curriculas[$usercur->curid]['name'] = $usercur->name; $data = array(); if ($courses = curriculumcourse_get_listing($usercur->curid, 'curcrs.position, crs.name', 'ASC')) { foreach ($courses as $course) { $totalcourses++; $course_obj = new course($course->courseid); $coursedesc = $course_obj->syllabus; if ($cdata = student_get_class_from_course($course->courseid, $this->id)) { foreach ($cdata as $classdata) { if (!in_array($classdata->id, $classids)) { $classids[] = $classdata->id; } if ($classdata->completestatusid == STUSTATUS_PASSED) { $completecourses++; } if ($mdlcrs = moodle_get_course($classdata->id)) { $coursename = '<a href="' . $CFG->wwwroot . '/course/view.php?id=' . $mdlcrs . '">' . $course->coursename . '</a>'; } else { $coursename = $course->coursename; } $data[] = array($coursename, $coursedesc, $classdata->grade, $classdata->completestatusid == STUSTATUS_PASSED ? get_string('yes') : get_string('no'), $classdata->completestatusid == STUSTATUS_PASSED && !empty($classdata->completetime) ? date('M j, Y', $classdata->completetime) : get_string('na', 'block_curr_admin')); } } else { $data[] = array($course->coursename, $coursedesc, 0, get_string('no'), get_string('na', 'block_curr_admin')); } } } $curriculas[$usercur->curid]['data'] = $data; } else { // Keep note of the classid's regardless if set archived or not for later use in determining non-curricula courses if ($courses = curriculumcourse_get_listing($usercur->curid, 'curcrs.position, crs.name', 'ASC')) { foreach ($courses as $course) { if ($cdata = student_get_class_from_course($course->courseid, $this->id)) { foreach ($cdata as $classdata) { if (!in_array($classdata->id, $classids)) { $classids[] = $classdata->id; } } } } } } } } // Show different css for IE below version 8 if (check_browser_version('MSIE', 7.0) && !check_browser_version('MSIE', 8.0)) { // IEs that are lower than version 8 do not get the float because it messes up the tabs at the top of the page for some reason $float_style = 'text-align:right;'; } else { // Sane browsers get the float tag $float_style = 'text-align:right; float:right;'; } // Tab header $field_exists = field::get_for_context_level_with_name('curriculum', $archive_var); if (!empty($field_exists)) { $tabrow = array(); $tabrow[] = new tabobject('currentlp', $CFG->wwwroot . '/curriculum/index.php?tab=currentlp', get_string('tab_current_learning_plans', 'block_curr_admin')); $tabrow[] = new tabobject('archivedlp', $CFG->wwwroot . '/curriculum/index.php?tab=archivedlp', get_string('tab_archived_learning_plans', 'block_curr_admin')); $tabrows = array($tabrow); print_tabs($tabrows, $tab); } $content .= print_heading_block(get_string('learningplanwelcome', 'block_curr_admin', fullname($this)), '', true); if ($totalcurricula === 0) { $blank_lang = $tab == 'archivedlp' ? 'noarchivedplan' : 'nolearningplan'; $content .= '<br /><center>' . get_string($blank_lang, 'block_curr_admin') . '</center>'; } // Load the user preferences for hide/show button states if ($collapsed = get_user_preferences('crlm_learningplan_collapsed_curricula')) { $collapsed_array = explode(',', $collapsed); } else { $collapsed = ''; $collapsed_array = array(); } $content .= '<input type="hidden" name="collapsed" id="collapsed" value="' . $collapsed . '">'; if (!empty($usercurs)) { foreach ($usercurs as $usercur) { if (!isset($curriculas[$usercur->curid])) { continue; } $curricula = $curriculas[$usercur->curid]; $table = new stdClass(); $table->head = array(get_string('class', 'block_curr_admin'), get_string('description', 'block_curr_admin'), get_string('score', 'block_curr_admin'), get_string('completed_label', 'block_curr_admin'), get_string('date', 'block_curr_admin')); $table->data = $curricula['data']; $curricula_name = empty($CURMAN->config->disablecoursecatalog) ? '<a href="index.php?s=crscat§ion=curr&showcurid=' . $curricula['id'] . '">' . $curricula['name'] . '</a>' : $curricula['name']; $header_curr_name = get_string('learningplanname', 'block_curr_admin', $curricula_name); if (in_array($curricula['id'], $collapsed_array)) { $button_label = get_string('showcourses', 'block_curr_admin'); $extra_class = ' hide'; } else { $button_label = get_string('hidecourses', 'block_curr_admin'); $extra_class = ''; } $heading = '<div class="clearfix"></div>' . '<div style="' . $float_style . '">' . '<script id="curriculum' . $curricula['id'] . 'script" type="text/javascript">toggleVisibleInitWithState("curriculum' . $curricula['id'] . 'script", "curriculum' . $curricula['id'] . 'button", "' . $button_label . '", "' . get_string('hidecourses', 'block_curr_admin') . '", "' . get_string('showcourses', 'block_curr_admin') . '", "curriculum-' . $curricula['id'] . '");</script></div>' . $header_curr_name; $content .= '<div class="dashboard_curricula_block">'; $content .= print_heading($heading, 'left', 2, 'main', true); $content .= '<div id="curriculum-' . $curricula['id'] . '" class="yui-skin-sam ' . $extra_class . '">'; if (empty($curricula['data'])) { $content .= get_string('nocourseassoc', 'block_curr_admin'); } else { $content .= print_table($table, true); } $content .= '</div>'; $content .= '</div>'; } } /// Completed non-curricula course data if ($tab != 'archivedlp') { if (!empty($classids)) { $sql = "SELECT stu.id, stu.classid, crs.name as coursename, stu.completetime, stu.grade, stu.completestatusid\n FROM " . $CURMAN->db->prefix_table(STUTABLE) . " stu\n INNER JOIN " . $CURMAN->db->prefix_table(CLSTABLE) . " cls ON cls.id = stu.classid\n INNER JOIN " . $CURMAN->db->prefix_table(CRSTABLE) . " crs ON crs.id = cls.courseid\n WHERE userid = {$this->id}\n AND classid " . (count($classids) == 1 ? "!= " . current($classids) : "NOT IN (" . implode(", ", $classids) . ")") . "\n ORDER BY crs.name ASC, stu.completetime ASC"; } else { $sql = "SELECT stu.id, stu.classid, crs.name as coursename, stu.completetime, stu.grade, stu.completestatusid\n FROM " . $CURMAN->db->prefix_table(STUTABLE) . " stu\n INNER JOIN " . $CURMAN->db->prefix_table(CLSTABLE) . " cls ON cls.id = stu.classid\n INNER JOIN " . $CURMAN->db->prefix_table(CRSTABLE) . " crs ON crs.id = cls.courseid\n WHERE userid = {$this->id}\n ORDER BY crs.name ASC, stu.completetime ASC"; } if ($classes = get_records_sql($sql)) { $table = new stdClass(); $table->head = array(get_string('class', 'block_curr_admin'), get_string('score', 'block_curr_admin'), get_string('completed_label', 'block_curr_admin'), get_string('date', 'block_curr_admin')); $table->data = array(); foreach ($classes as $class) { if ($mdlcrs = moodle_get_course($class->classid)) { $coursename = '<a href="' . $CFG->wwwroot . '/course/view.php?id=' . $mdlcrs . '">' . $class->coursename . '</a>'; } else { $coursename = $class->coursename; } $table->data[] = array($coursename, $class->grade, $class->completestatusid == STUSTATUS_PASSED ? get_string('yes') : get_string('no'), $class->completestatusid == STUSTATUS_PASSED && !empty($class->completetime) ? date('M j, Y', $class->completetime) : get_string('na', 'block_curr_admin')); } $header_curr_name = get_string('noncurriculacourses', 'block_curr_admin'); if (in_array('na', $collapsed_array)) { $button_label = get_string('showcourses', 'block_curr_admin'); $extra_class = ' hide'; } else { $button_label = get_string('hidecourses', 'block_curr_admin'); $extra_class = ''; } $heading = '<div class="clearfix"></div>' . '<div style="' . $float_style . '">' . '<script id="noncurriculascript" type="text/javascript">toggleVisibleInitWithState("noncurriculascript", "noncurriculabutton", "' . $button_label . '", "' . get_string('hidecourses', 'block_curr_admin') . '", "' . get_string('showcourses', 'block_curr_admin') . '", "curriculum-na");</script></div>' . $header_curr_name; $content .= '<div class="dashboard_curricula_block">'; $content .= print_heading($heading, 'left', 2, 'main', true); $content .= '<div id="curriculum-na" class="yui-skin-sam ' . $extra_class . '">'; $content .= print_table($table, true); $content .= '</div>'; $content .= '</div>'; } } return $content; }
/** * Obtain the appropriate information regarding program courses as needed * by the dashboard * * @param boolean $tab_sensitive true if we need to be concerned about whether * we are on the current or archived tab, otherwise * false * @param boolean $show_archived specifies whether we're showing archived or non- * archived courses (ignored if tab_sensitive is false) * @param boolean $showcompleted specifies whether we're showing passed and failed * courses in addition to ones in progress * @param mixed $programid a specific program id to look for data related to, or * NULL for all * @return array a list of values, where the first entry is the user's course list, * the second is a mapping of programs to a course listing, the third * is a list of classes handled, and the fourth is the number of programs * handled, the fifth is a mapping of program ids to number of compelted * courses, the sixth is a mapping of program ids to total number of courses */ function get_dashboard_program_data($tab_sensitive, $show_archived, $showcompleted = false, $programid = NULL) { global $CFG, $DB; $archive_var = '_elis_program_archive'; $classids = array(); //track mapping of programs to course / class listings $curriculas = array(); $totalcurricula = 0; //map program ids to appropriate counts $completecoursesmap = array(); $totalcoursesmap = array(); $params = array($this->id); //set up a condition for when handling a specific program $program_condition = ''; if ($programid !== NULL) { $program_condition = 'AND cur.id = ?'; $params[] = $programid; } $sql = 'SELECT curstu.id, curstu.curriculumid as curid, cur.name as name FROM {' . curriculumstudent::TABLE . '} curstu JOIN {' . curriculum::TABLE . '} cur ON cur.id = curstu.curriculumid WHERE curstu.userid = ? ' . $program_condition . ' ORDER BY cur.priority ASC, cur.name ASC'; //mapping of completion status to display string $status_mapping = array(STUSTATUS_PASSED => get_string('passed', 'local_elisprogram'), STUSTATUS_FAILED => get_string('failed', 'local_elisprogram'), STUSTATUS_NOTCOMPLETE => get_string('n_completed', 'local_elisprogram')); if ($usercurs = $DB->get_records_sql($sql, $params)) { //^pre-ELIS-3615 WAS: if ($usercurs = curriculumstudent::get_curricula($this->id)) { foreach ($usercurs as $usercur) { // Check if this curricula is set as archived and whether we want to display it $crlm_context = \local_elisprogram\context\program::instance($usercur->curid); $data_array = field_data::get_for_context_and_field($crlm_context, $archive_var); $crlm_archived = 0; if (!empty($data_array) && is_object($data_array->rs) && !empty($data_array->rs)) { $crlm_archived = !empty($data_array->rs->current()->data) ? 1 : 0; } //being insensitive to which tab we're on gets us this listing "for free" if (!$tab_sensitive || $show_archived == $crlm_archived) { $totalcurricula++; $curriculas[$usercur->curid]['id'] = $usercur->curid; $curriculas[$usercur->curid]['name'] = $usercur->name; $data = array(); //count our totals per-program //note that "course" is really one enrolment, so this should //count each enrolment, plus one for each unenrolled program course $totalcourses = 0; $completecourses = 0; $courses = curriculumcourse_get_listing($usercur->curid, 'curcrs.position, crs.name', 'ASC'); foreach ($courses as $course) { $course_obj = new course($course->courseid); $coursedesc = $course_obj->syllabus; $cdata = student_get_class_from_course($course->courseid, $this->id); if ($cdata->valid() === true) { foreach ($cdata as $classdata) { //count each enrolment as one "course" $totalcourses++; if (!in_array($classdata->id, $classids)) { $classids[] = $classdata->id; } if ($classdata->completestatusid == STUSTATUS_PASSED || $classdata->completestatusid == STUSTATUS_FAILED) { //count completed enrolments $completecourses++; } if (!$showcompleted && ($classdata->completestatusid == STUSTATUS_PASSED || $classdata->completestatusid == STUSTATUS_FAILED)) { //not showing completed courses, so skip this course continue; } if ($mdlcrs = moodle_get_course($classdata->id)) { $coursename = '<a href="' . $CFG->wwwroot . '/course/view.php?id=' . $mdlcrs . '">' . $course->coursename . '</a>'; } else { $coursename = $course->coursename; } $data[] = array($coursename, $classdata->idnumber, $coursedesc, pm_display_grade($classdata->grade), $status_mapping[$classdata->completestatusid], $classdata->completestatusid == STUSTATUS_PASSED && !empty($classdata->completetime) ? userdate($classdata->completetime, get_string('pm_date_format', 'local_elisprogram')) : get_string('na', 'local_elisprogram')); } } else { //count this unenrolled course toward the total $totalcourses++; $data[] = array($course->coursename, get_string('dashboard_na', 'local_elisprogram'), $coursedesc, 0, get_string('not_enrolled', 'local_elisprogram'), get_string('na', 'local_elisprogram')); } unset($cdata); } unset($courses); $curriculas[$usercur->curid]['data'] = $data; //associate this program id with the appropriate counts $completecoursesmap[$usercur->curid] = $completecourses; $totalcoursesmap[$usercur->curid] = $totalcourses; } else { // Keep note of the classid's regardless if set archived or not for later use in determining non-curricula courses $courses = curriculumcourse_get_listing($usercur->curid, 'curcrs.position, crs.name', 'ASC'); foreach ($courses as $course) { $cdata = student_get_class_from_course($course->courseid, $this->id); foreach ($cdata as $classdata) { if (!in_array($classdata->id, $classids)) { $classids[] = $classdata->id; } } unset($cdata); } unset($courses); } } } return array($usercurs, $curriculas, $classids, $totalcurricula, $completecoursesmap, $totalcoursesmap); }
$ids[] = clean_param($dirty, PARAM_INT); } } else { $ids[] = clean_param($dirtyids, PARAM_INT); } } else { $ids[] = 0; } // Must have blank value as the default here (instead of zero) or it breaks the gas guage report $choices_array = array(array('', get_string('anyvalue', 'filters'))); if (!empty($ids)) { $contexts = get_contexts_by_capability_for_user('course', 'local/elisreports:view', $USER->id); foreach ($ids as $id) { $records = false; if ($id > 0) { $records = curriculumcourse_get_listing($id, 'crs.name', 'ASC', 0, 0, '', '', array('contexts' => $contexts)); $idfield = 'courseid'; $namefield = 'coursename'; } else { if ($id == 0) { $records = course_get_listing('crs.name', 'ASC', 0, 0, '', '', $contexts); $idfield = 'id'; $namefield = 'name'; } } if (is_array($records) && !empty($records) || $records instanceof Iterator && $records->valid() === true) { foreach ($records as $record) { $choices_array[] = array($record->{$idfield}, $record->{$namefield}); } } unset($records);
function action_default() { $id = $this->required_param('id', PARAM_INT); $sort = optional_param('sort', 'position', PARAM_ALPHA); $dir = optional_param('dir', 'ASC', PARAM_ALPHA); $page = optional_param('page', 0, PARAM_INT); $perpage = optional_param('perpage', 30, PARAM_INT); // how many per page $namesearch = trim(cm_get_param('search', '')); $alpha = cm_get_param('alpha', ''); $columns = array('coursename' => get_string('course_name', 'block_curr_admin'), 'required' => get_string('required', 'block_curr_admin'), 'frequency' => get_string('frequency', 'block_curr_admin'), 'timeperiod' => get_string('time_period', 'block_curr_admin'), 'position' => get_string('position', 'block_curr_admin'), 'buttons' => get_string('management', 'block_curr_admin')); $items = curriculumcourse_get_listing($id, $sort, $dir, 0, 0, $namesearch, $alpha); $numitems = curriculumcourse_count_records($id, $namesearch, $alpha); $formatters = $this->create_link_formatters(array('coursename'), 'coursepage', 'courseid'); $this->print_num_items($numitems); $this->print_alpha(); $this->print_search(); $this->print_list_view($items, $columns, $formatters, 'courses'); if (coursepage::_has_capability('block/curr_admin:associate')) { $this->print_add_button(array('id' => $id), get_string('curriculumcourse_assigncourse', 'block_curr_admin')); } }