Example #1
0
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;
 }