get_record('course', array('id' => $cm->course), '*', MUST_EXIST); $sqlbox = $DB->get_record('sqlbox', array('id' => $cm->instance), '*', MUST_EXIST); } else { print_error('invalidcourse'); } require_login($course, true, $cm); $context = get_context_instance(CONTEXT_MODULE, $cm->id); require_capability('mod/sqlbox:readqueries', $context); add_to_log($course->id, 'sqlbox', 'report', "reportall.php?id={$cm->id}", $sqlbox->name, $cm->id); $PAGE->set_url('/mod/sqlbox/reportall.php', array('id' => $cm->id)); $PAGE->set_title("Results for all SQLBoxes"); $PAGE->set_heading(format_string($course->fullname)); $PAGE->set_context($context); echo $OUTPUT->header(); // TODO: Order Results using the frontend ordering. sth like this would get the ordering right for a given course_id: /* select mdl_sqlbox.name from ( select to_number(unnest(string_to_array(sequence,',')),'99999') as id from (select sequence from mdl_course_sections where course=:course_id order by section) as tmp ) sid, mdl_course_modules, mdl_sqlbox, mdl_modules where sid.id = mdl_course_modules.id and mdl_course_modules.instance = mdl_sqlbox.id and mdl_modules.name='sqlbox' and mdl_modules.id=mdl_course_modules.module; */ $boxes = $DB->get_records_sql("SELECT * FROM {sqlbox} ORDER BY id"); $b = array(); foreach ($boxes as $box) $b[] = $box->name; $table = new html_table; $table->head = array_merge(array("Nutzer", "Fortschritt"), $b); $table->align = array_merge(array("left", "left"), array_fill(0, count($b), 'center')); $users = $DB->get_records_sql("select u.* from {enrol} e, {user_enrolments} ue, {user} u where e.courseid=:courseid and ue.enrolid = e.id and ue.userid = u.id and u.deleted = 0", array('courseid'=>$course->id)); foreach ($users as $user) { if (isguestuser($user)) continue; $name = $user->firstname.' '.$user->lastname; $solutions = $DB->get_records_sql("SELECT s.id, sol.correct FROM {sqlbox} s LEFT JOIN ( SELECT sqlboxid,correct FROM {sqlbox_solutions} WHERE userid=:id) as sol ON s.id = sol.sqlboxid ORDER BY s.id", array('id'=>$user->id)); $s = array(); $progress = 0; foreach ($solutions as $solution) { $s[] = ($solution->correct == '1') ? '☑' : ($solution->correct == '0' ? '☒' : '☐'); if ($solution->correct == '1') $progress++; } $progress /= count($s); $table->data[] = array_merge(array($name, round($progress * 100) . "%"), $s); } echo '

'; echo html_writer::table($table); echo '

'; echo $OUTPUT->footer(); ?>