-
Notifications
You must be signed in to change notification settings - Fork 0
/
detail_groups_to_excel.php
119 lines (101 loc) · 4.44 KB
/
detail_groups_to_excel.php
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
<?php
// This file is part of Moodle - http://moodle.org/
//
// Moodle is free software: you can redistribute it and/or modify
// it under the terms of the GNU General Public License as published by
// the Free Software Foundation, either version 3 of the License, or
// (at your option) any later version.
//
// Moodle is distributed in the hope that it will be useful,
// but WITHOUT ANY WARRANTY; without even the implied warranty of
// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
// GNU General Public License for more details.
//
// You should have received a copy of the GNU General Public License
// along with Moodle. If not, see <http://www.gnu.org/licenses/>.
/**
* prints an analysed excel-spreadsheet of the grouped individualfeedback
*
* @copyright Martijn Spruijt
* @license http://www.gnu.org/copyleft/gpl.html GNU Public License
* @package mod_individualfeedback
*/
require_once("../../config.php");
require_once("lib.php");
require_once("$CFG->libdir/excellib.class.php");
$id = required_param('id', PARAM_INT); // Course module id.
$courseid = optional_param('courseid', '0', PARAM_INT);
$url = new moodle_url('/mod/individualfeedback/detail_groups_to_excel.php', array('id' => $id));
if ($courseid) {
$url->param('courseid', $courseid);
}
$PAGE->set_url($url);
list($course, $cm) = get_course_and_cm_from_cmid($id, 'individualfeedback');
require_login($course, false, $cm);
$context = context_module::instance($cm->id);
require_capability('mod/individualfeedback:viewreports', $context);
$individualfeedback = $PAGE->activityrecord;
// Buffering any output. This prevents some output before the excel-header will be send.
ob_start();
ob_end_clean();
// Get the questions (item-names).
$individualfeedbackstructure = new mod_individualfeedback_structure($individualfeedback, $cm, $course->id);
if (!$items = $individualfeedbackstructure->get_groups_and_items()) {
throw new \moodle_exception('no_items_available_yet', 'individualfeedback', $cm->url);
}
$mygroupid = groups_get_activity_group($cm);
// Creating a workbook.
$subtabname = get_string('detail_groups', 'individualfeedback');
$filename = "individualfeedback_" . clean_filename($cm->get_formatted_name()) . " " . $subtabname . ".xls";
$workbook = new MoodleExcelWorkbook($filename);
// Creating the worksheet.
error_reporting(0);
$worksheet1 = $workbook->add_worksheet();
error_reporting($CFG->debug);
$worksheet1->hide_gridlines();
$worksheet1->set_column(0, 0, 10);
$worksheet1->set_column(1, 1, 30);
$worksheet1->set_column(2, 20, 15);
// Creating the needed formats.
$xlsformats = new stdClass();
$xlsformats->head1 = $workbook->add_format(['bold' => 1, 'size' => 12]);
$xlsformats->head2 = $workbook->add_format(['align' => 'left', 'bold' => 1, 'bottum' => 2]);
$xlsformats->default = $workbook->add_format(['align' => 'left', 'v_align' => 'top']);
$xlsformats->value_bold = $workbook->add_format(['align' => 'left', 'bold' => 1, 'v_align' => 'top']);
$xlsformats->procent = $workbook->add_format(['align' => 'left', 'bold' => 1, 'v_align' => 'top', 'num_format' => '#,##0.00%']);
// Writing the table header.
$rowoffset1 = 0;
$worksheet1->write_string($rowoffset1, 0, userdate(time()), $xlsformats->head1);
// Get the completeds.
$completedscount = individualfeedback_get_completeds_group_count($individualfeedback, $mygroupid, $courseid);
if ($completedscount > 0) {
// Write the count of completeds.
$rowoffset1++;
$worksheet1->write_string($rowoffset1,
0,
$cm->get_module_type_name(true).': '.strval($completedscount),
$xlsformats->head1);
}
$rowoffset1++;
$worksheet1->write_string($rowoffset1,
0,
get_string('questions', 'individualfeedback').': '. strval(count($items)),
$xlsformats->head1);
$rowoffset1 += 2;
$worksheet1->write_string($rowoffset1, 0, get_string('item_label', 'individualfeedback'), $xlsformats->head1);
$worksheet1->write_string($rowoffset1, 1, get_string('question', 'individualfeedback'), $xlsformats->head1);
$worksheet1->write_string($rowoffset1, 2, get_string('responses', 'individualfeedback'), $xlsformats->head1);
$rowoffset1++;
foreach ($items as $item) {
// Get the class of item-typ.
$itemobj = individualfeedback_get_item_class($item->typ);
if (method_exists($itemobj, 'excelprint_detail_groups')) {
$rowoffset1 = $itemobj->excelprint_detail_groups($worksheet1,
$rowoffset1,
$xlsformats,
$item,
$mygroupid,
$courseid);
}
}
$workbook->close();