Commit | Line | Data |
---|---|---|
84973212 | 1 | <?php |
2 | ||
c70ad9f7 | 3 | /** |
4 | * shows an analysed view of a feedback on the mainsite | |
5 | * | |
c70ad9f7 | 6 | * @author Andreas Grabs |
7 | * @license http://www.gnu.org/copyleft/gpl.html GNU Public License | |
8 | * @package feedback | |
9 | */ | |
10 | ||
84973212 | 11 | require_once("../../config.php"); |
12 | require_once("lib.php"); | |
13 | ||
14 | // $SESSION->feedback->current_tab = 'analysis'; | |
15 | $current_tab = 'analysis'; | |
16 | ||
17 | $id = required_param('id', PARAM_INT); //the POST dominated the GET | |
18 | $coursefilter = optional_param('coursefilter', '0', PARAM_INT); | |
19 | $courseitemfilter = optional_param('courseitemfilter', '0', PARAM_INT); | |
20 | $courseitemfiltertyp = optional_param('courseitemfiltertyp', '0', PARAM_ALPHANUM); | |
21 | // $searchcourse = optional_param('searchcourse', '', PARAM_ALPHAEXT); | |
22 | $searchcourse = optional_param('searchcourse', '', PARAM_RAW); | |
23 | $courseid = optional_param('courseid', false, PARAM_INT); | |
24 | ||
a6855934 | 25 | $url = new moodle_url('/mod/feedback/analysis_course.php', array('id'=>$id)); |
84973212 | 26 | if ($courseid !== false) { |
27 | $url->param('courseid', $courseid); | |
28 | } | |
29 | if ($coursefilter !== '0') { | |
30 | $url->param('coursefilter', $coursefilter); | |
31 | } | |
32 | if ($courseitemfilter !== '0') { | |
33 | $url->param('courseitemfilter', $courseitemfilter); | |
34 | } | |
35 | if ($courseitemfiltertyp !== '0') { | |
36 | $url->param('courseitemfiltertyp', $courseitemfiltertyp); | |
37 | } | |
38 | if ($searchcourse !== '') { | |
39 | $url->param('searchcourse', $searchcourse); | |
40 | } | |
41 | $PAGE->set_url($url); | |
42 | ||
43 | if(($searchcourse OR $courseitemfilter OR $coursefilter) AND !confirm_sesskey()) { | |
44 | print_error('invalidsesskey'); | |
45 | } | |
46 | ||
b6f26001 AG |
47 | if (! $cm = get_coursemodule_from_id('feedback', $id)) { |
48 | print_error('invalidcoursemodule'); | |
49 | } | |
50 | ||
51 | if (! $course = $DB->get_record("course", array("id"=>$cm->course))) { | |
52 | print_error('coursemisconf'); | |
53 | } | |
54 | ||
55 | if (! $feedback = $DB->get_record("feedback", array("id"=>$cm->instance))) { | |
56 | print_error('invalidcoursemodule'); | |
84973212 | 57 | } |
c987dbad AG |
58 | |
59 | if (!$context = get_context_instance(CONTEXT_MODULE, $cm->id)) { | |
60 | print_error('badcontext'); | |
61 | } | |
84973212 | 62 | |
63 | require_login($course->id, true, $cm); | |
64 | ||
c987dbad | 65 | if( !( (intval($feedback->publish_stats) == 1) OR has_capability('mod/feedback:viewreports', $context))) { |
84973212 | 66 | print_error('error'); |
67 | } | |
68 | ||
69 | /// Print the page header | |
70 | $strfeedbacks = get_string("modulenameplural", "feedback"); | |
71 | $strfeedback = get_string("modulename", "feedback"); | |
72 | ||
9d092aa9 | 73 | $PAGE->set_heading(format_string($course->fullname)); |
84973212 | 74 | $PAGE->set_title(format_string($feedback->name)); |
84973212 | 75 | echo $OUTPUT->header(); |
76 | ||
77 | /// print the tabs | |
78 | include('tabs.php'); | |
79 | ||
80 | //print the analysed items | |
81 | echo $OUTPUT->box_start('generalbox boxaligncenter boxwidthwide'); | |
82 | ||
c987dbad | 83 | if( has_capability('mod/feedback:viewreports', $context) ) { |
84973212 | 84 | //button "export to excel" |
85 | echo $OUTPUT->container_start('mdl-align'); | |
5c2ed7e2 PS |
86 | $aurl = new moodle_url('analysis_to_excel.php', array('sesskey'=>sesskey(), 'id'=>$id, 'coursefilter'=>$coursefilter)); |
87 | echo $OUTPUT->single_button($aurl, get_string('export_to_excel', 'feedback')); | |
84973212 | 88 | echo $OUTPUT->container_end(); |
89 | } | |
90 | ||
91 | //get the groupid | |
92 | //lstgroupid is the choosen id | |
93 | $mygroupid = false; | |
94 | //get completed feedbacks | |
95 | $completedscount = feedback_get_completeds_group_count($feedback, $mygroupid, $coursefilter); | |
96 | ||
97 | //show the count | |
98 | echo '<b>'.get_string('completed_feedbacks', 'feedback').': '.$completedscount. '</b><br />'; | |
99 | ||
100 | // get the items of the feedback | |
101 | $items = $DB->get_records('feedback_item', array('feedback'=>$feedback->id, 'hasvalue'=>1), 'position'); | |
102 | //show the count | |
103 | if(is_array($items)){ | |
104 | echo '<b>'.get_string('questions', 'feedback').': ' .sizeof($items). ' </b><hr />'; | |
105 | echo '<a href="analysis_course.php?id=' . $id . '&courseid='.$courseid.'">'.get_string('show_all', 'feedback').'</a>'; | |
106 | } else { | |
107 | $items=array(); | |
108 | } | |
109 | ||
110 | echo '<form name="report" method="post" id="analysis-form">'; | |
111 | echo '<div class="mdl-align"><table width="80%" cellpadding="10">'; | |
112 | if ($courseitemfilter > 0) { | |
113 | $avgvalue = 'avg(value)'; | |
114 | if ($DB->get_dbfamily() == 'postgres') { // TODO: this should be moved to standard sql DML function ;-) | |
115 | $avgvalue = 'avg(cast (value as integer))'; | |
c70ad9f7 | 116 | } |
84973212 | 117 | if ($courses = $DB->get_records_sql ("SELECT fv.course_id, c.shortname, $avgvalue AS avgvalue |
118 | FROM {feedback_value} fv, {course} c, {feedback_item} fi | |
119 | WHERE fv.course_id = c.id AND fi.id = fv.item AND fi.typ = ? AND fv.item = ? | |
120 | GROUP BY course_id, shortname | |
121 | ORDER BY avgvalue desc", | |
122 | array($courseitemfiltertyp, $courseitemfilter))) { | |
8ebbb06a SH |
123 | $item = $DB->get_record('feedback_item', array('id'=>$courseitemfilter)); |
124 | echo '<tr><th colspan="2">'.$item->name.'</th></tr>'; | |
125 | echo '<tr><td><table align="left">'; | |
126 | echo '<tr><th>Course</th><th>Average</th></tr>'; | |
127 | $sep_dec = get_string('separator_decimal', 'feedback'); | |
128 | $sep_thous = get_string('separator_thousand', 'feedback'); | |
129 | ||
130 | foreach ($courses as $c) { | |
eb38d45b | 131 | $shortname = format_string($c->shortname, true, array('context' => get_context_instance(CONTEXT_COURSE, $c->course_id))); |
8ebbb06a SH |
132 | echo '<tr><td>'.$shortname.'</td><td align="right">'.number_format(($c->avgvalue), 2, $sep_dec, $sep_thous).'</td></tr>'; |
133 | } | |
84973212 | 134 | echo '</table></td></tr>'; |
c70ad9f7 | 135 | } else { |
84973212 | 136 | echo '<tr><td>'.get_string('noresults').'</td></tr>'; |
c70ad9f7 | 137 | } |
84973212 | 138 | } else { |
139 | ||
140 | echo get_string('search_course', 'feedback') . ': '; | |
141 | echo '<input type="text" name="searchcourse" value="'.s($searchcourse).'"/> <input type="submit" value="'.get_string('search').'"/>'; | |
142 | echo '<input type="hidden" name="sesskey" value="'.sesskey().'" />'; | |
143 | echo '<input type="hidden" name="id" value="'.$id.'" />'; | |
144 | echo '<input type="hidden" name="courseitemfilter" value="'.$courseitemfilter.'" />'; | |
145 | echo '<input type="hidden" name="courseitemfiltertyp" value="'.$courseitemfiltertyp.'" />'; | |
146 | echo '<input type="hidden" name="courseid" value="'.$courseid.'" />'; | |
c17f05fb | 147 | echo html_writer::script('', $CFG->wwwroot.'/mod/feedback/feedback.js'); |
31c0fa53 | 148 | $sql = 'select DISTINCT c.id, c.shortname from {course} c, '. |
84973212 | 149 | '{feedback_value} fv, {feedback_item} fi '. |
150 | 'where c.id = fv.course_id and fv.item = fi.id '. | |
31c0fa53 | 151 | 'and fi.feedback = ? '. |
84973212 | 152 | 'and |
0f1b6a5e PS |
153 | ('.$DB->sql_like('c.shortname', '?', false).' |
154 | OR '.$DB->sql_like('c.fullname', '?', false).')'; | |
84973212 | 155 | $params = array($feedback->id, "%$searchcourse%", "%$searchcourse%"); |
156 | ||
157 | if ($courses = $DB->get_records_sql_menu($sql, $params)) { | |
158 | ||
159 | echo ' ' . get_string('filter_by_course', 'feedback') . ': '; | |
0f1b6a5e | 160 | |
18300e6b | 161 | echo html_writer::select($courses, 'coursefilter', $coursefilter, null, array('id'=>'coursefilterid')); |
edc28287 | 162 | $PAGE->requires->js_init_call('M.util.init_select_autosubmit', array('analysis-form', 'coursefilterid', false)); |
84973212 | 163 | } |
164 | echo '<hr />'; | |
165 | $itemnr = 0; | |
166 | //print the items in an analysed form | |
167 | echo '<tr><td>'; | |
168 | foreach($items as $item) { | |
169 | if($item->hasvalue == 0) continue; | |
170 | echo '<table width="100%" class="generalbox">'; | |
171 | //get the class from item-typ | |
6cc1599e | 172 | $itemobj = feedback_get_item_class($item->typ); |
84973212 | 173 | $itemnr++; |
174 | if($feedback->autonumbering) { | |
175 | $printnr = $itemnr.'.'; | |
c70ad9f7 | 176 | } else { |
84973212 | 177 | $printnr = ''; |
c70ad9f7 | 178 | } |
84973212 | 179 | $itemobj->print_analysed($item, $printnr, $mygroupid, $coursefilter); |
180 | if (preg_match('/rated$/i', $item->typ)) { | |
181 | echo '<tr><td colspan="2"><a href="#" onclick="setcourseitemfilter('.$item->id.',\''.$item->typ.'\'); return false;">'. | |
182 | get_string('sort_by_course', 'feedback').'</a></td></tr>'; | |
c70ad9f7 | 183 | } |
84973212 | 184 | echo '</table>'; |
c70ad9f7 | 185 | } |
84973212 | 186 | echo '</td></tr>'; |
187 | } | |
188 | echo '</table></div>'; | |
189 | echo '</form>'; | |
190 | echo $OUTPUT->box_end(); | |
d4b1d58c | 191 | |
84973212 | 192 | echo $OUTPUT->footer(); |
c70ad9f7 | 193 |