. /** * shows an analysed view of a feedback on the mainsite * * @author Andreas Grabs * @license http://www.gnu.org/copyleft/gpl.html GNU Public License * @package mod_feedback */ require_once("../../config.php"); require_once("lib.php"); $current_tab = 'analysis'; $id = required_param('id', PARAM_INT); //the POST dominated the GET $courseitemfilter = optional_param('courseitemfilter', '0', PARAM_INT); $courseitemfiltertyp = optional_param('courseitemfiltertyp', '0', PARAM_ALPHANUM); $courseid = optional_param('courseid', false, PARAM_INT); $url = new moodle_url('/mod/feedback/analysis_course.php', array('id'=>$id)); navigation_node::override_active_url($url); if ($courseid !== false) { $url->param('courseid', $courseid); } if ($courseitemfilter !== '0') { $url->param('courseitemfilter', $courseitemfilter); } if ($courseitemfiltertyp !== '0') { $url->param('courseitemfiltertyp', $courseitemfiltertyp); } $PAGE->set_url($url); list($course, $cm) = get_course_and_cm_from_cmid($id, 'feedback'); $context = context_module::instance($cm->id); require_course_login($course, true, $cm); $feedback = $PAGE->activityrecord; if (!($feedback->publish_stats OR has_capability('mod/feedback:viewreports', $context))) { print_error('error'); } $feedbackstructure = new mod_feedback_structure($feedback, $PAGE->cm, $courseid); // Process course select form. $courseselectform = new mod_feedback_course_select_form($url, $feedbackstructure); if ($data = $courseselectform->get_data()) { redirect(new moodle_url($url, ['courseid' => $data->courseid])); } /// Print the page header $strfeedbacks = get_string("modulenameplural", "feedback"); $strfeedback = get_string("modulename", "feedback"); $PAGE->set_heading($course->fullname); $PAGE->set_title($feedback->name); echo $OUTPUT->header(); echo $OUTPUT->heading(format_string($feedback->name)); /// print the tabs require('tabs.php'); //get the groupid //lstgroupid is the choosen id $mygroupid = false; $courseselectform->display(); // Button "Export to excel". if (has_capability('mod/feedback:viewreports', $context) && $feedbackstructure->get_items()) { echo $OUTPUT->container_start('form-buttons'); $aurl = new moodle_url('/mod/feedback/analysis_to_excel.php', ['sesskey' => sesskey(), 'id' => $id, 'courseid' => (int)$courseid]); echo $OUTPUT->single_button($aurl, get_string('export_to_excel', 'feedback')); echo $OUTPUT->container_end(); } // Show the summary. $summary = new mod_feedback\output\summary($feedbackstructure); echo $OUTPUT->render_from_template('mod_feedback/summary', $summary->export_for_template($OUTPUT)); // Get the items of the feedback. $items = $feedbackstructure->get_items(true); if ($courseitemfilter > 0) { $sumvalue = 'SUM(' . $DB->sql_cast_char2real('value', true) . ')'; $sql = "SELECT fv.course_id, c.shortname, $sumvalue AS sumvalue, COUNT(value) as countvalue FROM {feedback_value} fv, {course} c, {feedback_item} fi WHERE fv.course_id = c.id AND fi.id = fv.item AND fi.typ = ? AND fv.item = ? GROUP BY course_id, shortname ORDER BY sumvalue desc"; if ($courses = $DB->get_records_sql($sql, array($courseitemfiltertyp, $courseitemfilter))) { $item = $DB->get_record('feedback_item', array('id'=>$courseitemfilter)); echo '

'.$item->name.'

'; echo '
'; echo ''; echo ''; foreach ($courses as $c) { $coursecontext = context_course::instance($c->course_id); $shortname = format_string($c->shortname, true, array('context' => $coursecontext)); echo ''; echo ''; echo ''; echo ''; } echo '
CourseAverage
'.$shortname.''; echo format_float(($c->sumvalue / $c->countvalue), 2); echo '
'; } else { echo '

'.get_string('noresults').'

'; } echo '

'; echo get_string('back'); echo '

'; } else { // Print the items in an analysed form. foreach ($items as $item) { echo ''; $itemobj = feedback_get_item_class($item->typ); $printnr = ($feedback->autonumbering && $item->itemnr) ? ($item->itemnr . '.') : ''; $itemobj->print_analysed($item, $printnr, $mygroupid, $feedbackstructure->get_courseid()); if (preg_match('/rated$/i', $item->typ)) { $url = new moodle_url('/mod/feedback/analysis_course.php', array('id' => $id, 'courseitemfilter' => $item->id, 'courseitemfiltertyp' => $item->typ)); $anker = html_writer::link($url, get_string('sort_by_course', 'feedback')); echo ''; } echo '
'.$anker.'
'; } } echo $OUTPUT->footer();