function occapira_get_section_percentage($courseid, $sectionid) { global $USER, $DB; $mods = $DB->get_records_sql("SELECT cm.*, m.name as modname\r\n FROM {modules} m, {course_modules} cm\r\n WHERE cm.course = ? \r\n\t\t\t\t\t\t\t\t AND cm.section= ? \r\n\t\t\t\t\t\t\t\t\tAND cm.completion !=0 \r\n\t\t\t\t\t\t\t\t\tAND cm.module = m.id \r\n\t\t\t\t\t\t\t\t\tAND m.visible = 1", array($courseid, $sectionid)); // no disabled mods //$mods = get_course_section_mods($courseid, $sectionid); $modules = array(); foreach ($mods as $m) { if ($m->modname == 'occapira') { $modules[] = $m; } } $count = count($modules); $percentage = 0; foreach ($modules as $modu) { $result = occapira_get_percentage($modu->instance, $USER->id); $percentage += $result['percentage'] / $count; } return $percentage; }
function get_section_grades(&$section) { global $CFG, $USER, $course; require_once $CFG->dirroot . '/mod/occapira/locallib.php'; $mods = get_course_section_mods($course->id, $section->id); //print_object($mods); $modules = array(); foreach ($mods as $m) { if ($m->modname == 'occapira') { $modules[] = $m; } } $count = count($modules); if ($count == 0) { return -1; } $percentage = 0; foreach ($modules as $modu) { //print_object($modu); $result = occapira_get_percentage($modu->instance, $USER->id); $percentage += $result['percentage'] / $count; } return $percentage; }