| 1 |
efrain |
1 |
Configurable Reports Block
|
|
|
2 |
|
|
|
3 |
Installation, Documentation, Tutorials....
|
|
|
4 |
See http://docs.moodle.org/en/blocks/configurable_reports/
|
|
|
5 |
Also http://moodle.org/mod/data/view.php?d=13&rid=4283
|
|
|
6 |
|
|
|
7 |
Author: Juan Leyva
|
|
|
8 |
<http://moodle.org/user/profile.php?id=49568>
|
|
|
9 |
<http://twitter.com/jleyvadelgado>
|
|
|
10 |
<http://sites.google.com/site/mooconsole/>
|
|
|
11 |
<http://moodle-es.blogspot.com>
|
|
|
12 |
<http://openlearningtech.blogspot.com>
|
|
|
13 |
|
|
|
14 |
Thanks to:
|
|
|
15 |
Nadav Kavalerchik for developing amazing new features
|
|
|
16 |
Ivan Breziansky for translating the block to slovak language
|
|
|
17 |
Iñaki Arenaza for translating the block documentation to spanish
|
|
|
18 |
Luis de Vasconcelos for testing the block
|
|
|
19 |
Adam Olley and Netspot Moodle Partner for improving some parts of the Moodle2 version
|
|
|
20 |
|
|
|
21 |
Some functionalities of this plugin uses code from:
|
|
|
22 |
|
|
|
23 |
Admin Report: Custom SQL queries
|
|
|
24 |
http://moodle.org/mod/data/view.php?d=13&rid=2884
|
|
|
25 |
By Tim Hunt
|
|
|
26 |
|
|
|
27 |
|
|
|
28 |
VERSIONS HISTORY
|
|
|
29 |
|
|
|
30 |
3.9.0 (2019122000) for Moodle 3.4, 3.5, 3.6, 3.7, 3.8, 3.9
|
|
|
31 |
Release date: Tuesday, 3 November 2020
|
|
|
32 |
----------------------------------------------------------------------
|
|
|
33 |
- Starting this version for allowing SQL queries performing data insertion/creation the following configuration variable set to 1
|
|
|
34 |
is required in your site root /config.php:
|
|
|
35 |
$CFG->block_configurable_reports_enable_sql_execution = 1;
|
|
|
36 |
Otherwise, previous Custom SQL reports performing data insertion/creation will stop working.
|
|
|
37 |
- Added matching colors to pie charts
|
|
|
38 |
- Added unmapped palette for general colors to pie charts
|
|
|
39 |
- Changed fuserfield to allow for multiple instances of the filter
|
|
|
40 |
- Added alphabetical sort to courses filter
|
|
|
41 |
- Added webservice to get reports data
|
|
|
42 |
- Added new filters for competencies
|
|
|
43 |
- Other fixes and improvements:
|
|
|
44 |
* Fix offset error for bar graphs when not using SQL reporting
|
|
|
45 |
* Removed default sorting from DataTables JS UI
|
|
|
46 |
* Fixed issue where colors would mismatch if values weren't present
|
|
|
47 |
* Fixed STARTTIME and ENDTIME variable substitution
|
|
|
48 |
* Avoid text filtering when exporting
|
|
|
49 |
|
|
|
50 |
Thanks Alex Rowe, David Saylor, Michael Gardener, Muhammad Osama Arshad, Daniel Poggenpohl, Daniel Neis, François Parlant and all the contributors who have sent several fixes and improvements.
|
|
|
51 |
|
|
|
52 |
|
|
|
53 |
3.8.0 (2019122000) for Moodle 3.4, 3.5, 3.6, 3.7, 3.8
|
|
|
54 |
Release date: Friday, 20 Dec 2019
|
|
|
55 |
----------------------------------------------------------------------
|
|
|
56 |
- Order the list of users in users filter by fullname considering language - #130
|
|
|
57 |
- Other fixes and improvements:
|
|
|
58 |
* Fix template array error - #132
|
|
|
59 |
* Fix DB mismatch between install.xml and upgrade.php - #123
|
|
|
60 |
* Fix LIMIT error for MSSQL - CONTRIB-7891
|
|
|
61 |
* Remove "_" from the table header titles - #137
|
|
|
62 |
* Review supported Moodle versions, because the core_userlist_provider interface is only supported from 3.4 onwards - #125
|
|
|
63 |
|
|
|
64 |
|
|
|
65 |
Thanks Daniel Neis (danielneis), Mike McDougal (mcdoogs), Tuan Ngoc Nguyen (tuanngocnguyen), Mike Henry (mhenry79mnet), safatshahinsd, kristian-94 and all the contributors who have sent several fixes and improvements.
|
|
|
66 |
And special thanks also to Carlos, Moodle HQ and Juan for letting Sara work on this again during the project week.
|
|
|
67 |
|
|
|
68 |
|
|
|
69 |
3.3.0 (2019121900) for Moodle 3.0, 3.1, 3.2, 3.3
|
|
|
70 |
Release date: Friday, 20 Dec 2019
|
|
|
71 |
----------------------------------------------------------------------
|
|
|
72 |
- Order the list of users in users filter by fullname considering language - #130
|
|
|
73 |
- Add a new calculation type: percentage
|
|
|
74 |
- Allow userfields to be used more than once in the permissions
|
|
|
75 |
- Move JS to AMD modules
|
|
|
76 |
- Upgrade some 3rd party JS libraries
|
|
|
77 |
- Fix import from XML
|
|
|
78 |
- Review the year filter to take min and max years from the calendar factory
|
|
|
79 |
- Other fixes and improvements:
|
|
|
80 |
* Fix template array error - #132
|
|
|
81 |
* Fix DB mismatch between install.xml and upgrade.php - #123
|
|
|
82 |
* Fix LIMIT error for MSSQL - CONTRIB-7891
|
|
|
83 |
* Remove "_" from the table header titles - #137
|
|
|
84 |
* Review supported Moodle versions, because the core_userlist_provider interface is only supported from 3.4 onwards - #125
|
|
|
85 |
* Fix error when using templates
|
|
|
86 |
* Fix error when using the Start/End filter
|
|
|
87 |
* Fix legacy_polyfill error when running unit tests
|
|
|
88 |
* Display custom title for the block
|
|
|
89 |
* Replace deprecated methods (htmleditor, pix_url and coursecat)
|
|
|
90 |
* Remove CSS files not found error in JS console
|
|
|
91 |
* Show breadcrumbs for users without manage report capability
|
|
|
92 |
* Fix DB query function call for the enrolled students filter
|
|
|
93 |
* Raise the memory limit when exporting
|
|
|
94 |
* Clean some request parameters before using them
|
|
|
95 |
* Fix error with user field search box filter
|
|
|
96 |
* Improve compatibility with PostgreSQL when importing
|
|
|
97 |
|
|
|
98 |
|
|
|
99 |
Thanks Daniel Neis (danielneis), Mike McDougal (mcdoogs), Tuan Ngoc Nguyen (tuanngocnguyen), Mike Henry (mhenry79mnet), safatshahinsd, kristian-94, David (davidpesce), Dimitrii (dmitriim), Alex (agrowe), Donald (emyb2), sopnep15, Danniel (dannielarriola) and all the contributors who have sent several fixes and improvements.
|
|
|
100 |
And special thanks also to Carlos, Sander, Moodle HQ and Juan for letting Sara work on this again during the project week.
|
|
|
101 |
|
|
|
102 |
|
|
|
103 |
3.7.0 (2019060300) for Moodle 3.4, 3.5, 3.6, 3.7
|
|
|
104 |
Release date: Monday, 3 Jun 2019
|
|
|
105 |
----------------------------------------------------------------------
|
|
|
106 |
- Add a new calculation type: percentage
|
|
|
107 |
- Allow userfields to be used more than once in the permissions
|
|
|
108 |
- Other fixes and improvements:
|
|
|
109 |
* Fix error when using templates
|
|
|
110 |
* Fix error when using the Start/End filter
|
|
|
111 |
* Fix legacy_polyfill error when running unit tests
|
|
|
112 |
* Display custom title for the block
|
|
|
113 |
|
|
|
114 |
|
|
|
115 |
Thanks David (davidpesce), Dimitrii (dmitriim) and all the contributors who have sent several fixes and improvements.
|
|
|
116 |
And special thanks also to Sander, Moodle HQ and Juan for letting Sara work on this again during the project week.
|
|
|
117 |
|
|
|
118 |
|
|
|
119 |
3.6.0 (2019021500) for Moodle 3.4, 3.5, 3.6
|
|
|
120 |
Release date: Friday, 15 Feb 2019
|
|
|
121 |
----------------------------------------------------------------------
|
|
|
122 |
- Implement Privacy API
|
|
|
123 |
- Replace deprecated methods:
|
|
|
124 |
* htmleditor
|
|
|
125 |
* pix_url
|
|
|
126 |
* coursecat
|
|
|
127 |
- Move JS to AMD modules
|
|
|
128 |
- Upgrade some 3rd party JS libraries
|
|
|
129 |
- Fix import from XML
|
|
|
130 |
- Review the year filter to take min and max years from the calendar factory
|
|
|
131 |
- Other fixes and improvements:
|
|
|
132 |
* Remove CSS files not found error in JS console
|
|
|
133 |
* Show breadcrumbs for users without manage report capability
|
|
|
134 |
* Fix DB query function call for the enrolled students filter
|
|
|
135 |
* Raise the memory limit when exporting
|
|
|
136 |
* Clean some request parameters before using them
|
|
|
137 |
* Fix error with user field search box filter
|
|
|
138 |
* Improve compatibility with PostgreSQL when importing
|
|
|
139 |
|
|
|
140 |
Thanks Alex (agrowe), Donald (emyb2), sopnep15, Danniel (dannielarriola) and all the contributors who have sent several
|
|
|
141 |
fixes and improvements.
|
|
|
142 |
And special thanks also to Sander, Moodle HQ and Juan for letting Sara work on this during the project week.
|
|
|
143 |
|
|
|
144 |
|
|
|
145 |
|
|
|
146 |
3.1.1 (2016020103) for Moodle 3.0, 3.1
|
|
|
147 |
Release date: Monday, 10 Oct 2016
|
|
|
148 |
----------------------------------------------------------------------
|
|
|
149 |
- Fix a critical bug when adding user action/outline statistics, see https://tracker.moodle.org/browse/CONTRIB-4600
|
|
|
150 |
|
|
|
151 |
Thanks Marina Glancy for the fix
|
|
|
152 |
|
|
|
153 |
|
|
|
154 |
3.1.0 (2016020102) for Moodle 3.0, 3.1
|
|
|
155 |
Release date: Wednesday, 25 May 2016
|
|
|
156 |
----------------------------------------------------------------------
|
|
|
157 |
- Several bug fixes
|
|
|
158 |
|
|
|
159 |
|
|
|
160 |
3.0.1 (2016020101) for Moodle 3.0
|
|
|
161 |
2.3.9 (2011040121) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
|
|
|
162 |
Release date: Wednesday, 17 Feb 2016
|
|
|
163 |
----------------------------------------------------------------------
|
|
|
164 |
- Fix bug when creating the category list
|
|
|
165 |
|
|
|
166 |
|
|
|
167 |
3.0.0 (2016020100) for Moodle 3.0
|
|
|
168 |
Release date: Tuesday, 02 Feb 2016
|
|
|
169 |
----------------------------------------------------------------------
|
|
|
170 |
- Compatible version with Moodle 3.0
|
|
|
171 |
|
|
|
172 |
|
|
|
173 |
2.3.8 (2011040120) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
|
|
|
174 |
Release date: Tuesday, 02 Feb 2016
|
|
|
175 |
----------------------------------------------------------------------
|
|
|
176 |
- Release including bug fixes
|
|
|
177 |
|
|
|
178 |
|
|
|
179 |
2.3.7 (2011040119) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
|
|
|
180 |
Release date: Monday, 03 Aug 2015
|
|
|
181 |
----------------------------------------------------------------------
|
|
|
182 |
- Several bug fixes
|
|
|
183 |
- Fixed installation for old moodle versions
|
|
|
184 |
- Improved pie chats
|
|
|
185 |
|
|
|
186 |
Thanks CV&A and Carlos Escobedo for the contribution
|
|
|
187 |
|
|
|
188 |
|
|
|
189 |
2.3.6 (2011040118) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
|
|
|
190 |
Release date: Wednesday, 27 May 2015
|
|
|
191 |
----------------------------------------------------------------------
|
|
|
192 |
- Minor release fixing a regression
|
|
|
193 |
|
|
|
194 |
Thanks to Dan Marsden for the fix
|
|
|
195 |
|
|
|
196 |
|
|
|
197 |
2.3.5 (2011040116) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
|
|
|
198 |
Release date: Wednesday, 06 May 2015
|
|
|
199 |
----------------------------------------------------------------------
|
|
|
200 |
- Added support for Moodle 2.8 and 2.9
|
|
|
201 |
- Added support to the new logging system
|
|
|
202 |
- Improved the color palette for graphics with lots of elements
|
|
|
203 |
- Allow translations of DataTable strings
|
|
|
204 |
- Restored the fsearchuserfield plugin
|
|
|
205 |
- Minor issues fixes
|
|
|
206 |
|
|
|
207 |
Thanks albergasset and jpeak5 for their fixes
|
|
|
208 |
|
|
|
209 |
|
|
|
210 |
2.3.4 (2011040114) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7
|
|
|
211 |
Release date: Thursday, 26 June 2014, 18:16
|
|
|
212 |
----------------------------------------------------------------------
|
|
|
213 |
- New fullname user field column
|
|
|
214 |
- Several bug fixes
|
|
|
215 |
|
|
|
216 |
|
|
|
217 |
2.3.3 (2011040113) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7
|
|
|
218 |
Release date: Friday, 13 June 2014, 18:16
|
|
|
219 |
----------------------------------------------------------------------
|
|
|
220 |
- Fixed layout and notice/warnings problems
|
|
|
221 |
|
|
|
222 |
|
|
|
223 |
2.3.2 (2011040110) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6
|
|
|
224 |
Release date: Friday, 14 February 2014, 11:14 AM
|
|
|
225 |
----------------------------------------------------------------------
|
|
|
226 |
- Several bug fixes
|
|
|
227 |
|
|
|
228 |
|
|
|
229 |
2.3.2 (2011040109) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6
|
|
|
230 |
Release date: Thursday, 30 January 2014, 10:33 AM
|
|
|
231 |
----------------------------------------------------------------------
|
|
|
232 |
- Fixed invalid table reference in cron
|
|
|
233 |
|
|
|
234 |
|
|
|
235 |
2.3.2 (2011040108) for Moodle 2.2, 2.3, 2.4, 2.5m 2.6
|
|
|
236 |
Release date Thursday, 16 January 2014, 15:25 AM
|
|
|
237 |
----------------------------------------------------------------------
|
|
|
238 |
- Some bug fixes
|
|
|
239 |
- New CSV export
|
|
|
240 |
|
|
|
241 |
|
|
|
242 |
2.3.1 (2011040107) for Moodle 2.0, 2.1, 2.2, 2.3, 2.4, 2.5m 2.6
|
|
|
243 |
Release date Monday, 16 December 2013, 10:25 AM
|
|
|
244 |
----------------------------------------------------------------------
|
|
|
245 |
- Some minor bug fixes
|
|
|
246 |
- SQL syntax by default is disabled
|
|
|
247 |
- New block instance settings (change name and also show/hide global reports)
|
|
|
248 |
- New users cohorts condition
|
|
|
249 |
|
|
|
250 |
|
|
|
251 |
2.3 (2011040106) for Moodle 2.0, 2.1, 2.2, 2.3, 2.4, 2.5m 2.6
|
|
|
252 |
Release date Friday, 13 December 2013, 4:35 PM
|
|
|
253 |
----------------------------------------------------------------------
|
|
|
254 |
- Support for Moodle 2.6
|
|
|
255 |
- Multiple bugs fixed
|
|
|
256 |
- Global report that can be shared in all courses
|
|
|
257 |
- Public reports repository with multiple sample reports available
|
|
|
258 |
- Public SQL queries repository
|
|
|
259 |
- Reports can run on a different DB that the current (production) DB
|
|
|
260 |
- Reports can run on a CRON scheduler
|
|
|
261 |
- Several filter plugins added
|
|
|
262 |
- Integrated DataTables.js for the report table
|
|
|
263 |
- Integrated CodeMirror.js for highlighting SQL query code, while editing.
|
|
|
264 |
- New security settings
|
|
|
265 |
|
|
|
266 |
Thanks to Nadav Kavalerchik for providing most of the new features
|
|
|
267 |
|
|
|
268 |
|
|
|
269 |
2.2 (2011040105) for Moodle 2.0, 2.1, 2.2, 2.3, 2.4, 2.5
|
|
|
270 |
Release date Wednesday, 27 February 2013, 9:35 AM
|
|
|
271 |
----------------------------------------------------------------------
|
|
|
272 |
- Support for Moodle 2.4 and 2.5
|
|
|
273 |
- Bugs fixed
|
|
|
274 |
|
|
|
275 |
|
|
|
276 |
2.1 (2011040103) for Moodle 2.0, 2.1, 2.2, 2.3
|
|
|
277 |
Release date Friday, 6 July 2012, 1:29 PM
|
|
|
278 |
----------------------------------------------------------------------
|
|
|
279 |
- Support for Moodle 2.3
|
|
|
280 |
- Bugs fixed
|
|
|
281 |
|
|
|
282 |
|
|
|
283 |
2.0.2 (2011040102) for Moodle 2.0, 2.1, 2.2
|
|
|
284 |
Release date Monday, 9 January 2012, 11:41 AM
|
|
|
285 |
----------------------------------------------------------------------
|
|
|
286 |
- Support for Moodle 2.2
|
|
|
287 |
- Bugs fixed
|
|
|
288 |
|
|
|
289 |
|
|
|
290 |
2.0.1 (2011040101) for Moodle 2.0, 2.1
|
|
|
291 |
Release date Thursday, 13 October 2011, 12:55 AM
|
|
|
292 |
----------------------------------------------------------------------
|
|
|
293 |
|
|
|
294 |
|
|
|
295 |
2.0 (2011040100) for Moodle 2.0, 2.1
|
|
|
296 |
Release date Thursday, 29 September 2011, 10:47 AM
|
|
|
297 |
----------------------------------------------------------------------
|
|
|
298 |
|
|
|
299 |
|
|
|
300 |
1.0 (2010090100) for Moodle 1.9
|
|
|
301 |
Release date Thursday, 29 September 2011, 10:38 AM
|
|
|
302 |
----------------------------------------------------------------------
|