. /** * 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 feedback */ require_once("../../config.php"); require_once("lib.php"); $current_tab = 'analysis'; $id = required_param('id', PARAM_INT); //the POST dominated the GET $coursefilter = optional_param('coursefilter', '0', PARAM_INT); $courseitemfilter = optional_param('courseitemfilter', '0', PARAM_INT); $courseitemfiltertyp = optional_param('courseitemfiltertyp', '0', PARAM_ALPHANUM); $searchcourse = optional_param('searchcourse', '', PARAM_RAW); $courseid = optional_param('courseid', false, PARAM_INT); $url = new moodle_url('/mod/feedback/analysis_course.php', array('id'=>$id)); if ($courseid !== false) { $url->param('courseid', $courseid); } if ($coursefilter !== '0') { $url->param('coursefilter', $coursefilter); } if ($courseitemfilter !== '0') { $url->param('courseitemfilter', $courseitemfilter); } if ($courseitemfiltertyp !== '0') { $url->param('courseitemfiltertyp', $courseitemfiltertyp); } if ($searchcourse !== '') { $url->param('searchcourse', $searchcourse); } $PAGE->set_url($url); if (($searchcourse OR $courseitemfilter OR $coursefilter) AND !confirm_sesskey()) { print_error('invalidsesskey'); } if (! $cm = get_coursemodule_from_id('feedback', $id)) { print_error('invalidcoursemodule'); } if (! $course = $DB->get_record("course", array("id"=>$cm->course))) { print_error('coursemisconf'); } if (! $feedback = $DB->get_record("feedback", array("id"=>$cm->instance))) { print_error('invalidcoursemodule'); } if (!$context = get_context_instance(CONTEXT_MODULE, $cm->id)) { print_error('badcontext'); } require_login($course->id, true, $cm); if (!($feedback->publish_stats OR has_capability('mod/feedback:viewreports', $context))) { print_error('error'); } /// Print the page header $strfeedbacks = get_string("modulenameplural", "feedback"); $strfeedback = get_string("modulename", "feedback"); $PAGE->set_heading(format_string($course->fullname)); $PAGE->set_title(format_string($feedback->name)); echo $OUTPUT->header(); /// print the tabs require('tabs.php'); //print the analysed items echo $OUTPUT->box_start('generalbox boxaligncenter boxwidthwide'); if (has_capability('mod/feedback:viewreports', $context)) { //button "export to excel" echo $OUTPUT->container_start('mdl-align'); $aurl = new moodle_url('analysis_to_excel.php', array('sesskey' => sesskey(), 'id' => $id, 'coursefilter' => $coursefilter)); echo $OUTPUT->single_button($aurl, get_string('export_to_excel', 'feedback')); echo $OUTPUT->container_end(); } //get the groupid //lstgroupid is the choosen id $mygroupid = false; //get completed feedbacks $completedscount = feedback_get_completeds_group_count($feedback, $mygroupid, $coursefilter); //show the count echo ''.get_string('completed_feedbacks', 'feedback').': '.$completedscount. '
'; // get the items of the feedback $params = array('feedback' => $feedback->id, 'hasvalue' => 1); $items = $DB->get_records('feedback_item', $params, 'position'); //show the count if (is_array($items)) { echo ''.get_string('questions', 'feedback').': ' .count($items). '
'; echo ''; echo get_string('show_all', 'feedback'); echo ''; } else { $items=array(); } echo '
'; echo '
'; if ($courseitemfilter > 0) { $avgvalue = 'avg(value)'; if ($DB->get_dbfamily() == 'postgres') { // TODO: this should be moved to standard sql DML function ;-) $avgvalue = 'avg(cast (value as integer))'; } $sql = "SELECT fv.course_id, c.shortname, $avgvalue AS avgvalue 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 avgvalue desc"; if ($courses = $DB->get_records_sql($sql, array($courseitemfiltertyp, $courseitemfilter))) { $item = $DB->get_record('feedback_item', array('id'=>$courseitemfilter)); echo ''; echo ''; } else { echo ''; } } else { echo html_writer::label(get_string('search_course', 'feedback') . ': ', 'searchcourse'); echo ' '; echo ''; echo ''; echo ''; echo ''; echo ''; echo ''; echo html_writer::script('', $CFG->wwwroot.'/mod/feedback/feedback.js'); $sql = 'select DISTINCT c.id, c.shortname from {course} c, '. '{feedback_value} fv, {feedback_item} fi '. 'where c.id = fv.course_id and fv.item = fi.id '. 'and fi.feedback = ? '. 'and ('.$DB->sql_like('c.shortname', '?', false).' OR '.$DB->sql_like('c.fullname', '?', false).')'; $params = array($feedback->id, "%$searchcourse%", "%$searchcourse%"); if ($courses = $DB->get_records_sql_menu($sql, $params)) { echo ' '. html_writer::label(get_string('filter_by_course', 'feedback'), 'coursefilterid'). ': '; echo html_writer::select($courses, 'coursefilter', $coursefilter, null, array('id'=>'coursefilterid')); $PAGE->requires->js_init_call('M.util.init_select_autosubmit', array('analysis-form', 'coursefilterid', false)); } echo '
'; $itemnr = 0; //print the items in an analysed form echo ''; } echo '
'.$item->name.'
'; echo ''; $sep_dec = get_string('separator_decimal', 'feedback'); $sep_thous = get_string('separator_thousand', 'feedback'); foreach ($courses as $c) { $coursecontext = get_context_instance(CONTEXT_COURSE, $c->course_id); $shortname = format_string($c->shortname, true, array('context' => $coursecontext)); echo ''; echo ''; echo ''; echo ''; } echo '
CourseAverage
'.$shortname.''; echo number_format(($c->avgvalue), 2, $sep_dec, $sep_thous); echo '
'.get_string('noresults').'
'; foreach ($items as $item) { if ($item->hasvalue == 0) { continue; } echo ''; //get the class from item-typ $itemobj = feedback_get_item_class($item->typ); $itemnr++; if ($feedback->autonumbering) { $printnr = $itemnr.'.'; } else { $printnr = ''; } $itemobj->print_analysed($item, $printnr, $mygroupid, $coursefilter); if (preg_match('/rated$/i', $item->typ)) { $onclick = 'onclick="setcourseitemfilter'. "(".$item->id.",'".$item->typ."');". ' return false;"'; $anker = ''. get_string('sort_by_course', 'feedback'). ''; echo ''; } echo '
'.$anker.'
'; } echo '
'; echo '
'; echo $OUTPUT->box_end(); echo $OUTPUT->footer();