if (!$courseExists) { print_error(get_string('INVALID_ACCESS', 'local_attendance')); } $url = new moodle_url('/local/attendance/studentrecord.php'); $context = context_system::instance(); $PAGE->set_context($context); $PAGE->set_url($url); $PAGE->set_pagelayout('standard'); if (has_capability('local/attendance:teacherview', $context)) { print_error(get_string('INVALID_ACCESS', 'local_attendance')); } $courseName = $DB->get_record('course', array('id' => $courseid)); //breadcurmbs $PAGE->navbar->add($courseName->shortname, '/course/view.php?id=' . $courseid); $PAGE->navbar->add(get_string('attendances', 'local_attendance')); $PAGE->navbar->add(get_string('record', 'local_attendance'), '/local/attendance/studentrecord.php?courseid=' . $courseid); $percentage = $DB->get_record_sql('SELECT ROUND(100*(SELECT count(*) FROM {local_attendance_attendance} a WHERE a.sessionid IN (SELECT s.id from {local_attendance_session} s WHERE s.courseid=' . $courseid . ') AND a.userid=' . $USER->id . ')/ (SELECT count(*) FROM {local_attendance_session} s WHERE s.courseid=' . $courseid . ')) as total'); $title = $courseName->fullname . ' - ' . get_string('attendancerecord', 'local_attendance') . ' (' . get_string('attendance', 'local_attendance') . ': ' . $percentage->total . '%)'; $PAGE->set_title($title); $PAGE->set_heading($title); echo $OUTPUT->header(); echo $OUTPUT->heading($title); echo '<br>'; $table = tables::getStudentHistory($courseid); echo html_writer::table($table); echo $OUTPUT->single_button(new moodle_url('/course/view.php?id=' . $courseid), get_string('back', 'local_attendance')); global $local_attendance; $local_attendance = true; echo $OUTPUT->footer();