$url->param('a', $a); $scorm = $DB->get_record('scorm', array('id' => $a), '*', MUST_EXIST); $course = $DB->get_record('course', array('id' => $scorm->course), '*', MUST_EXIST); $cm = get_coursemodule_from_instance('scorm', $scorm->id, $course->id, false, MUST_EXIST); } } $PAGE->set_url($url); //END of url setting + data buildup // checking login +logging +getting context require_login($course->id, false, $cm); $contextmodule = get_context_instance(CONTEXT_MODULE, $cm->id); require_capability('mod/scorm:viewreport', $contextmodule); add_to_log($course->id, 'scorm', 'userreport', 'userreport.php?id='.$cm->id, $scorm->id, $cm->id); $userdata = scorm_get_user_data($user); // Print the page header $strreport = get_string('report', 'scorm'); $strattempt = get_string('attempt', 'scorm'); $PAGE->set_title("$course->shortname: ".format_string($scorm->name)); $PAGE->set_heading($course->fullname); $PAGE->navbar->add($strreport, new moodle_url('/mod/scorm/report.php', array('id'=>$cm->id))); if (empty($b)) { if (!empty($a)) { $PAGE->navbar->add("$strattempt $attempt - ".fullname($userdata)); } } else { $PAGE->navbar->add("$strattempt $attempt - ".fullname($userdata), new moodle_url('/mod/scorm/userreport.php', array('a'=>$a, 'user'=>$user, 'attempt'=>$attempt)));
$table->wrap[] = 'nowrap'; $table->size[] = '*'; $table->head[] = get_string('started', 'scorm'); $table->align[] = 'center'; $table->wrap[] = 'nowrap'; $table->size[] = '*'; $table->head[] = get_string('last', 'scorm'); $table->align[] = 'center'; $table->wrap[] = 'nowrap'; $table->size[] = '*'; $table->head[] = get_string('score', 'scorm'); $table->align[] = 'center'; $table->wrap[] = 'nowrap'; $table->size[] = '*'; foreach ($scousers as $scouser) { $userdata = scorm_get_user_data($scouser->userid); $attempt = scorm_get_last_attempt($scorm->id, $scouser->userid); for ($a = 1; $a <= $attempt; $a++) { $row = array(); $row[] = print_user_picture($scouser->userid, $course->id, $userdata->picture, false, true); $row[] = '<a href="' . $CFG->wwwroot . '/user/view.php?id=' . $scouser->userid . '&course=' . $course->id . '">' . fullname($userdata) . '</a>'; $row[] = '<a href="report.php?a=' . $scorm->id . '&user='******'&attempt=' . $a . '">' . $a . '</a>'; $select = 'scormid = ' . $scorm->id . ' and userid = ' . $scouser->userid . ' and attempt = ' . $a; $timetracks = get_record_select('scorm_scoes_track', $select, 'min(timemodified) as started, max(timemodified) as last'); $row[] = userdate($timetracks->started, get_string('strftimedaydatetime')); $row[] = userdate($timetracks->last, get_string('strftimedaydatetime')); $row[] = scorm_grade_user_attempt($scorm, $scouser->userid, $a); $table->data[] = $row; } } }