forked from jleyva/moodle-block_configurablereports
-
Notifications
You must be signed in to change notification settings - Fork 0
/
README.txt
338 lines (261 loc) · 13.5 KB
/
README.txt
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
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
Configurable Reports Block
Installation, Documentation, Tutorials....
See http://docs.moodle.org/en/blocks/configurable_reports/
Also http://moodle.org/mod/data/view.php?d=13&rid=4283
Author: Juan Leyva
<http://moodle.org/user/profile.php?id=49568>
<http://twitter.com/jleyvadelgado>
<http://sites.google.com/site/mooconsole/>
<http://moodle-es.blogspot.com>
<http://openlearningtech.blogspot.com>
Thanks to:
Nadav Kavalerchik for developing amazing new features
Ivan Breziansky for translating the block to slovak language
Iñaki Arenaza for translating the block documentation to spanish
Luis de Vasconcelos for testing the block
Adam Olley and Netspot Moodle Partner for improving some parts of the Moodle2 version
Some functionalities of this plugin uses code from:
Admin Report: Custom SQL queries
http://moodle.org/mod/data/view.php?d=13&rid=2884
By Tim Hunt
VERSIONS HISTORY
4.1.0 (2023120600) for Moodle 4.1
Release date: 06.12.2023
----------------------------------------------------------------------
This release focuses on solving issues in Moodle 4.1 and PHP 7.4 and start with small improvements and bug fixes.
- Reformat code
- Add CI testing based on Github Actions created by Catalyst IT
- Add PHP 7.4 support - minimum PHP version is now 7.4
- Add PHP 8.0 support
- Add PHP 8.1 support
- pChart library updated to version 2.4.0
- JS tablesorter library updated to version 2.31.3
- JS CodeMirror library updated to version 5.65.16
- Move repository to https://github.com/Lesterhuis-Training-en-Consultancy/moodle-block_configurablereports
- Original repository (https://github.com/jleyva/moodle-block_configurablereports) can be used for older release or use the old branches within this repository
- removed cr_add_to_log not used anymore
- Important this branch is not backwards compatible with Moodle 3.11 and lower
Thanks to Lesterhuis Training & Consultancy for the contribution / updated by Ldesign Media
- TODOS for the future:
* Namespaces for classes & autoloading
* Move all to `classes` to `classes/` directory
* Clean up code
* Add tests
* AJAX_SCRIPT move to webservice
* unserialize() to json_decode()
* Readme to Markdown format
* validation if a class exists and inherits the correct parent class.
* Changelog to separate file
* Move cron to a scheduled task
* phpcpd and phpdocs checks in CI
* Make CSS strict should only affect this plugin!
----------------------------------------------------------------------
3.9.0 (2019122000) for Moodle 3.4, 3.5, 3.6, 3.7, 3.8, 3.9
Release date: Tuesday, 3 November 2020
----------------------------------------------------------------------
- Starting this version for allowing SQL queries performing data insertion/creation the following configuration variable set to 1
is required in your site root /config.php:
$CFG->block_configurable_reports_enable_sql_execution = 1;
Otherwise, previous Custom SQL reports performing data insertion/creation will stop working.
- Added matching colors to pie charts
- Added unmapped palette for general colors to pie charts
- Changed fuserfield to allow for multiple instances of the filter
- Added alphabetical sort to courses filter
- Added webservice to get reports data
- Added new filters for competencies
- Other fixes and improvements:
* Fix offset error for bar graphs when not using SQL reporting
* Removed default sorting from DataTables JS UI
* Fixed issue where colors would mismatch if values weren't present
* Fixed STARTTIME and ENDTIME variable substitution
* Avoid text filtering when exporting
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.
3.8.0 (2019122000) for Moodle 3.4, 3.5, 3.6, 3.7, 3.8
Release date: Friday, 20 Dec 2019
----------------------------------------------------------------------
- Order the list of users in users filter by fullname considering language - #130
- Other fixes and improvements:
* Fix template array error - #132
* Fix DB mismatch between install.xml and upgrade.php - #123
* Fix LIMIT error for MSSQL - CONTRIB-7891
* Remove "_" from the table header titles - #137
* Review supported Moodle versions, because the core_userlist_provider interface is only supported from 3.4 onwards - #125
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.
And special thanks also to Carlos, Moodle HQ and Juan for letting Sara work on this again during the project week.
3.3.0 (2019121900) for Moodle 3.0, 3.1, 3.2, 3.3
Release date: Friday, 20 Dec 2019
----------------------------------------------------------------------
- Order the list of users in users filter by fullname considering language - #130
- Add a new calculation type: percentage
- Allow userfields to be used more than once in the permissions
- Move JS to AMD modules
- Upgrade some 3rd party JS libraries
- Fix import from XML
- Review the year filter to take min and max years from the calendar factory
- Other fixes and improvements:
* Fix template array error - #132
* Fix DB mismatch between install.xml and upgrade.php - #123
* Fix LIMIT error for MSSQL - CONTRIB-7891
* Remove "_" from the table header titles - #137
* Review supported Moodle versions, because the core_userlist_provider interface is only supported from 3.4 onwards - #125
* Fix error when using templates
* Fix error when using the Start/End filter
* Fix legacy_polyfill error when running unit tests
* Display custom title for the block
* Replace deprecated methods (htmleditor, pix_url and coursecat)
* Remove CSS files not found error in JS console
* Show breadcrumbs for users without manage report capability
* Fix DB query function call for the enrolled students filter
* Raise the memory limit when exporting
* Clean some request parameters before using them
* Fix error with user field search box filter
* Improve compatibility with PostgreSQL when importing
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.
And special thanks also to Carlos, Sander, Moodle HQ and Juan for letting Sara work on this again during the project week.
3.7.0 (2019060300) for Moodle 3.4, 3.5, 3.6, 3.7
Release date: Monday, 3 Jun 2019
----------------------------------------------------------------------
- Add a new calculation type: percentage
- Allow userfields to be used more than once in the permissions
- Other fixes and improvements:
* Fix error when using templates
* Fix error when using the Start/End filter
* Fix legacy_polyfill error when running unit tests
* Display custom title for the block
Thanks David (davidpesce), Dimitrii (dmitriim) and all the contributors who have sent several fixes and improvements.
And special thanks also to Sander, Moodle HQ and Juan for letting Sara work on this again during the project week.
3.6.0 (2019021500) for Moodle 3.4, 3.5, 3.6
Release date: Friday, 15 Feb 2019
----------------------------------------------------------------------
- Implement Privacy API
- Replace deprecated methods:
* htmleditor
* pix_url
* coursecat
- Move JS to AMD modules
- Upgrade some 3rd party JS libraries
- Fix import from XML
- Review the year filter to take min and max years from the calendar factory
- Other fixes and improvements:
* Remove CSS files not found error in JS console
* Show breadcrumbs for users without manage report capability
* Fix DB query function call for the enrolled students filter
* Raise the memory limit when exporting
* Clean some request parameters before using them
* Fix error with user field search box filter
* Improve compatibility with PostgreSQL when importing
Thanks Alex (agrowe), Donald (emyb2), sopnep15, Danniel (dannielarriola) and all the contributors who have sent several
fixes and improvements.
And special thanks also to Sander, Moodle HQ and Juan for letting Sara work on this during the project week.
3.1.1 (2016020103) for Moodle 3.0, 3.1
Release date: Monday, 10 Oct 2016
----------------------------------------------------------------------
- Fix a critical bug when adding user action/outline statistics, see https://tracker.moodle.org/browse/CONTRIB-4600
Thanks Marina Glancy for the fix
3.1.0 (2016020102) for Moodle 3.0, 3.1
Release date: Wednesday, 25 May 2016
----------------------------------------------------------------------
- Several bug fixes
3.0.1 (2016020101) for Moodle 3.0
2.3.9 (2011040121) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Release date: Wednesday, 17 Feb 2016
----------------------------------------------------------------------
- Fix bug when creating the category list
3.0.0 (2016020100) for Moodle 3.0
Release date: Tuesday, 02 Feb 2016
----------------------------------------------------------------------
- Compatible version with Moodle 3.0
2.3.8 (2011040120) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Release date: Tuesday, 02 Feb 2016
----------------------------------------------------------------------
- Release including bug fixes
2.3.7 (2011040119) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Release date: Monday, 03 Aug 2015
----------------------------------------------------------------------
- Several bug fixes
- Fixed installation for old moodle versions
- Improved pie chats
Thanks CV&A and Carlos Escobedo for the contribution
2.3.6 (2011040118) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Release date: Wednesday, 27 May 2015
----------------------------------------------------------------------
- Minor release fixing a regression
Thanks to Dan Marsden for the fix
2.3.5 (2011040116) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7, 2.8, 2.9
Release date: Wednesday, 06 May 2015
----------------------------------------------------------------------
- Added support for Moodle 2.8 and 2.9
- Added support to the new logging system
- Improved the color palette for graphics with lots of elements
- Allow translations of DataTable strings
- Restored the fsearchuserfield plugin
- Minor issues fixes
Thanks albergasset and jpeak5 for their fixes
2.3.4 (2011040114) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7
Release date: Thursday, 26 June 2014, 18:16
----------------------------------------------------------------------
- New fullname user field column
- Several bug fixes
2.3.3 (2011040113) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6, 2.7
Release date: Friday, 13 June 2014, 18:16
----------------------------------------------------------------------
- Fixed layout and notice/warnings problems
2.3.2 (2011040110) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6
Release date: Friday, 14 February 2014, 11:14 AM
----------------------------------------------------------------------
- Several bug fixes
2.3.2 (2011040109) for Moodle 2.2, 2.3, 2.4, 2.5, 2.6
Release date: Thursday, 30 January 2014, 10:33 AM
----------------------------------------------------------------------
- Fixed invalid table reference in cron
2.3.2 (2011040108) for Moodle 2.2, 2.3, 2.4, 2.5m 2.6
Release date Thursday, 16 January 2014, 15:25 AM
----------------------------------------------------------------------
- Some bug fixes
- New CSV export
2.3.1 (2011040107) for Moodle 2.0, 2.1, 2.2, 2.3, 2.4, 2.5m 2.6
Release date Monday, 16 December 2013, 10:25 AM
----------------------------------------------------------------------
- Some minor bug fixes
- SQL syntax by default is disabled
- New block instance settings (change name and also show/hide global reports)
- New users cohorts condition
2.3 (2011040106) for Moodle 2.0, 2.1, 2.2, 2.3, 2.4, 2.5m 2.6
Release date Friday, 13 December 2013, 4:35 PM
----------------------------------------------------------------------
- Support for Moodle 2.6
- Multiple bugs fixed
- Global report that can be shared in all courses
- Public reports repository with multiple sample reports available
- Public SQL queries repository
- Reports can run on a different DB that the current (production) DB
- Reports can run on a CRON scheduler
- Several filter plugins added
- Integrated DataTables.js for the report table
- Integrated CodeMirror.js for highlighting SQL query code, while editing.
- New security settings
Thanks to Nadav Kavalerchik for providing most of the new features
2.2 (2011040105) for Moodle 2.0, 2.1, 2.2, 2.3, 2.4, 2.5
Release date Wednesday, 27 February 2013, 9:35 AM
----------------------------------------------------------------------
- Support for Moodle 2.4 and 2.5
- Bugs fixed
2.1 (2011040103) for Moodle 2.0, 2.1, 2.2, 2.3
Release date Friday, 6 July 2012, 1:29 PM
----------------------------------------------------------------------
- Support for Moodle 2.3
- Bugs fixed
2.0.2 (2011040102) for Moodle 2.0, 2.1, 2.2
Release date Monday, 9 January 2012, 11:41 AM
----------------------------------------------------------------------
- Support for Moodle 2.2
- Bugs fixed
2.0.1 (2011040101) for Moodle 2.0, 2.1
Release date Thursday, 13 October 2011, 12:55 AM
----------------------------------------------------------------------
2.0 (2011040100) for Moodle 2.0, 2.1
Release date Thursday, 29 September 2011, 10:47 AM
----------------------------------------------------------------------
1.0 (2010090100) for Moodle 1.9
Release date Thursday, 29 September 2011, 10:38 AM
----------------------------------------------------------------------