jleyva/moodle-block_configurablereports

This block is a Moodle custom reports builder. You can create custom reports without SQL knowledge. It's a tool suitable for admins or teachers.

moodle-block_configurablereports's Issues

Convert internals to use table_sql / iterators

This block completely chokes on big data sets. We should:

• change the internal api for report.class.php to return an iterators / resultsets instead of massive arrays in memory.
• change the table output to use the table_sql API

Fatal error: Trait 'block_configurable_reports\privacy\core_privacy\local\legacy_polyfill' not found

Thank you for updating the plugin.

We're testing it in 3.5 and got Fatal error while running unit tests.

vendor/bin/phpunit privacy/tests/provider_test.php

Fatal error: Trait 'block_configurable_reports\privacy\core_privacy\local\legacy_polyfill' not found in /var/www/project/monash35/blocks/configurable_reports/classes/privacy/provider.php on line 55

Moodle branch 2.2 error message

I recently installed your block on our 2.2 test instance of moodle and receive the following error message:
Field "courseid" does not exist in table "block_configurable_reports_report"

In looking at the install.xml, it doesn't appear that courseid is being added to the table.

Error Messages for Start/End Filter

Now getting error messages for any reports using the Start/End filter (with the new CR version):

line 808 of /lib/moodlelib.php: coding_exception thrown
line 166 of /blocks/configurable_reports/report.class.php call to clearn_param()
line 80 of /blocks/configurable_reports/viewreports.php: call to report_base-->check_filters_request()

It has been reported by David Heuring in https://moodle.org/mod/forum/discuss.php?d=382639:

where is the selected value stored in filters

@nadavkav

I'm attempting to dynamically load the filters as other filters are selected. But I can't seem to locate where you are storing which filter option is selected. Any pointers?

Including @nadavkav just in case!

pix_url should be replaced with pix_icon or image_url

The pix_url() function was deprecated as of Moodle 3.3. All instances should be replaced appropriately with pix_icon (in most places) and image_url for the case of setting a background image in CSS.

The 3 files are:

• editcomp.php
• managereport.php
• locallib.php

Best regards,

Michael Milette

Duplicate

Hi,

When 'Enable JavaScript ordering' the head of the form appears twice

Can't enter custom SQL

Using Moodle 2.7.1+ (Build: 20140814) and Configurable Reports 2.3.3 (2011040114). Essential theme (also tried Clean theme).

When I try to enter a custom SQL query on the "Custom SQL" tab, there is nowhere to type. I have tried toggling full screen mode, pressing ESC to get out of full screen mode, different browsers (Chrome, FireFox), switching themes (in case my CSS was messing something up), all to no avail. Here is what I see:

Report list (blocks/configurable_reports/managereport.php) unreadable after js_init_call

blocks/configurable_reports/managereport.php
$PAGE->requires->js_init_call('M.block_configurable_reports.setup_html_table', array('reportslist'));

I had to comment out the above line for it to show correctly. (Moodle 2.3.1)

Question/Pointer - Add additional 'user field value' to permissions

Curious if you could point me to where I can modify the permissions to allow multiple "user field value". Currently only allows one.

User report custom profiles fields with only date set also show a time

Discussion here: https://moodle.org/mod/forum/discuss.php?d=345609

When admins create a user custom profile field of type datetime, there is an option in Moodle 3.1 to omit storing the time, so users only enter a date. This is tracked in mdl_user_info_field.param3 where 1 = use the time, otherwise use only the date.

The user report always puts a time (of 00:00 or 12:00 AM) in the report output there even when this setting to omit the date is set.

To replicate:

1. Add a custom profile field of type date/time in the Moodle site. Use the default settings but leave the "Include time?" setting UNchecked.
2. Add some date data for this field to a test user(s).
3. Create a CR report of type User, and under the Columns tab add a User profile field for username, and add a user profile field referencing the custom profile field already created.
4. View the report and see the report always puts a time in the format with times of 00:00 or 12:00 AM.

Fix:

Line 61 of /components/columns/userfield/plugin.class.php gets the custom profile field info for datatimes:
if ($p->datatype == 'datetime') {
$p->data = userdate($p->data);
It should add a check here for param3 to see if it is set to one and if so suppress the time portion by setting and passing the $format parameter to userdate() or stripping it out after it is returned.

Apostrophe in Filter value fails

Attempting to filter on a value with an apostrophe (ie a name like D'Anna) causes an "error reading from database" error.

Configurable reports causes 404 errors on every Moodle page

Discussion and fix here:

https://moodle.org/mod/forum/discuss.php?d=351496

Make plugin compliant with GDPR

Since Moodle 3.4 there are privacy tests that all plugins should comply to. See https://docs.moodle.org/dev/Privacy_API

Configurable reports: Display Global reports by default

When you add a new block instance, the block instance has no config property, so the line if (!empty($this->config->displayglobalreports)) is evaluated to false and global reports are not displayed.
This behavior is quiete confusing for new users that create global reports and don't see them in the block!
2 recent topics about that on the forum:

• https://moodle.org/mod/forum/discuss.php?d=348560#p1414583
• https://moodle.org/mod/forum/discuss.php?d=350404#p1414058

You need to manually edit the block settings so the $this->config->displayglobalreport can be set to true, and then global reports are available!

The fix is quite easy, let's say that in specialization of block_configurable_reports.php, when there is no config, let's set to true the displayglobalreports option as follow:

   /**
     * Act on instance data.
     */
    public function specialization()
    {

        if ($this->config) {
            $this->title = $this->config->title ? get_string('pluginname', 'block_configurable_reports') : $this->config->title;
        } else {
            $this->config = new stdClass();
            $this->config->displayglobalreports = true;
        }
    }

problem with backticks

we make use of custom views eg

create view mdl_user_data as select u.address AS 'Hub Access',concat((select auid.data from (mdl_user_info_data auid join mdl_user_info_field auif on(auid.fieldid = auif.id)) where auif.shortname = 'CA Student number' and auid.userid = u.id)) AS 'Banner ID' from mdl_user u where u.deleted = 0

[while the code above was entered with all tables and fields quoted with backticks - they get removed in the display in this comment box, which is frustrating ]

an sql CR like this

select * from prefix_user_data ud where ud.hub access <> "" [again backticks around hub access not displayed here ]

cannot be viewed in ver 2019021500 (with moodle 3.6) but can be viewed in ver 2016020103 (with moodle 3.1.6)

NB the two moodles are on the same server having Mariadb 10.3.14 PHP 7.0

in 2019021500 the CR can be saved/created but NOT viewed

on view report

Debug info: You have an error in your SQL syntax;
select * from mdl_v2_user_data ud where ud. hub access <> "" LIMIT 0, 5000

NOTE - the backticks have been removed in the CR error report

If I run that same query from a mysql commandline the query works fine

php error when tried create 'categories report' type

steps to replicate

• go to reports
• select 'categories report' type from report type list
• click 'add'
• switch to 'conditions' tab
• select 'parent category'

Results in php error -
PHP Fatal error: Call to undefined function cr_make_categories_list() in /blocks/configurable_reports/components/conditions/parentcategory/form.php on line 42

jQuery version conflict

Good day,

The Moodle theme on our site loads a newer version of jQuery v2.0.3 (2013).

Unfortunately, Configurable Reports subsequently loads its own instance of jQuery 1.2.3 (2011), which is much older than the version the theme is using. This results in conflicts and failures when the theme uses features that didn't exist back then.

Could you please re-write the way jQuery is only loaded by the plugin if it is not already loaded? Here is an untested example of how this might be achieved:

<script type="text/javascript">
if (typeof jQuery == 'undefined') {
     document.write(unescape('%3Cscript type="text/javascript" src="../../lib/jquery/jquery-1.11.0.min.js"%3E%3C/script%3E'));
}
</script>

You might need some additional code to check the version of jQuery available with a given version of Moodle if that is a concern or just include a more recent version with the plugin.

Best regards,

Michael Milette

Getting "array" output when using template

Using Moodle 3.6.3, mySQL 5.7, PHP 7.1 and plugin version available on 01/05/19

This is THE ultimate plugin for generating reports in Moodle ! But when using a template for beautyfulising the reports, I always get a page with "ArrayArray" (see picture) as answer in the report view page.

I did use the latest official version and the version you mentioned in this thread. Same results...

Please help, this template function is very important to me...

Thank you so much for the good work !

Christophe

DB Upgrade file not in sync with DB install.xml

In the upgrade.php there is a reference to adding a new field called 'remote'.
This field is not in the install.xml file.

I do not know if this will impact on the plugin at all? But doing a quick search for 'remote' shows that it is referenced in editreport.php line 200/201.

Which Branch

Which branch should I use if I want to install this plugin with git, CR_23_STABLE? Will that always be stable or do you also do development on that branch between releases?

It would be nice if you could follow the version convention of using the release date as the version number. So version 2.3.6 would be 2015050601 instead of 2011040117, which makes it look like it is 4 years old.

CodeMirror not defined

When accessing editcomp.php, it loads configurable_reports.js, but not codemirror.js. This causes a background js error to occur when line 13 of configurable_reports.js attempt to call CodeMirror. This can be fixed by commenting out lines 13-38 of configurable_reports.js or including:

$PAGE->requires->js('/blocks/configurable_reports/js/codemirror/lib/codemirror.js');
$PAGE->requires->css('/blocks/configurable_reports/js/codemirror/lib/codemirror.css');

in editcomp.php.

PHP7 issues

When looking to use this plugin with PHP7, there are a couple of issues:

1. Function split() is deprecated since PHP 5.3 and removed since PHP 7.0; Use preg_split instead. This occurs in lib/pChart/pChart.class (and other places);
2. In js/datatables/extras/Scroller/media/data/server_processing.php, Extension 'mysql_' is deprecated since PHP 5.5 and removed since PHP 7.0; Use mysqli instead;

Let ,me know if you need more information

Configurable reports: JSON exporter feature request

This request deals with adding a JSON exporter for configurable reports.

There are ODS, CSV, XLS exports but not JSON. This would be very handy to have a JSON export, especially to process exported data with other tools.

Auto run delay option does not save when unchecked

If you check the Auto run daily option and save, then if you uncheck it it will not save

Configurable report: Moodle 3.3

Hello Juan,

I installed Configurable reports on a test Moodle 3.3 (PHP 5.6.30) without issues. It evens seems to run the reports fine. But I have one small line of text when it shows "View Reports" - it seems to be in the javascript.

===

    function printDiv(id){
        var cdiv, tmpw;

        cdiv = document.getElementById(id);
        tmpw = window.open(" ","Print");

        tmpw.document.open();
        tmpw.document.write('<html><body>');
        tmpw.document.write(cdiv.innerHTML);
        tmpw.document.write('  <div id="bitnami-banner" data-banner-id="a36d2">  <style>#bitnami-banner {z-index:100000;height:80px;padding:0px;width:120px;background:transparent;position:fixed;right:0px;bottom:0px;border:0px solid #EDEDED;} #bitnami-banner .bitnami-corner-image-div {position:fixed;right:0px;bottom:0px;border:0px;z-index:100001;height:110px;} #bitnami-banner .bitnami-corner-image-div .bitnami-corner-image {position:fixed;right:0px;bottom:0px;border:0px;z-index:100001;height:110px;} #bitnami-close-banner-button {height:12px;width:12px;z-index:10000000000;position:fixed;right:5px;bottom:65px;display:none;cursor:pointer}</style>  <img id="bitnami-close-banner-button" src="/bitnami/images/close.png"/>  <div class="bitnami-corner-image-div">     <a href="/bitnami/index.html" target="_blank">       <img class="bitnami-corner-image" alt="Bitnami" src="/bitnami/images/corner-logo.png"/>     </a>  </div>  <script type="text/javascript" src="/bitnami/banner.js"> 

==

I am not sure how easy it is to fix this, but I hope you find some time through out the Moodle Desktop/Moodle Mobile to fix this.

If I need to contact someone else then please let me know.

Gemma

Notices and warnings when adding user report

Hi Juan. I've just cloned your repo and installed the cr_23_stable branch into our development Moodle 2.9. I added the block to a course and added the Users report 'users course time dedication.xml' and received the following notices and warning:

Notice: Undefined index: customsql in blocks/configurable_reports/locallib.php on line 536
Notice: Trying to get property of non-object in blocks/configurable_reports/locallib.php on line 536
Warning: Creating default object from empty value in blocks/configurable_reports/locallib.php on line 536

Additionally, when cloning your repo it has the name configurablereports but when installing, Moodle complains that the folder name should be configurable_reports.

Requires legacy logging

Or Moodle admins really like the configurable reports block, but we have not been able to make it work for them in 2.8 because we are not planning to enable legacy logging. Are there any plans to make this plugin usable to some extent without legacy logging? Can you suggest any quick workarounds to make it functional without legacy logging enabled?

Print report link only works in Firefox

At the bottom of a report near the bottom of the page, there is a link called "Print report".

• In Firefox, it prints the report.
• In Chrome, it prints a blank page with just the date in the header (comes from Chrome).
• In Internet Explorer 11 on Windows 10, the screen flashes and reloads the page. Not even an offer to print.
• In Edge on Windows 10, the screen flashes and reloads the page. Not even an offer to print.

Workaround: In all cases, you can still print using CTRL-P however you get a printout of the web page with the header and borders, etc (the theme), instead of a clean report.

I am using Configurable Reports 3.1.1 on Moodle 3.4.2+.
My default printer is the Microsoft Print to PDF printer.

Let me know if you need any additional information.

Best regards,

Michael Milette

Configured block title does not display on course main page

We have found that in Moodle 3.5, users can configure the title of a Configurable Reports block on its settings page but no matter what they set, the default language string is always displayed on the course main page.

It looks as if the way in which blocks set their display title has changed, and requires a different format to be used in specialization(). I've been able to fix this by reference to other blocks where this feature does work, and have attached a patch here.

configurable_reports.patch.txt

SQL report limited to 5000 records

There is an undocumented "feature" that the SQL report only outputs 5000 records.
Can you create a settings flag for this so you can configure it?

If you like I can make a pull request with the required changes.

David

fuser filter: all options marked as "selected" when filter is applied.

Steps to reproduce:

1. Create a SQL report with a user field filter (I used username for mine)
2. View the report
3. Examine the page source. The filter dropdown has no pre-selected items (as expected).
4. Apply a filter
   • Does not have the be the user field filter; e.g. applying a date filter has the same effect.
5. Examine the page source. Every item in the dropdown now has selected="selected"
   • As a result, whatever was selected for the filter, the last item in the dropdown list is now treated as selected, and will be used if you re-apply the filter.

Add new tile feature

I have added a feature as part of a project with the NZ Office of the Privacy Commissioner that allows users that can manage and view reports to be displayed as tiles.

Reports have a new component 'Tile' which allows users to control what reports can be viewed as a tile. Tiles can be displayed as

1. A count of the results the report returns
   A report could be developed that shows the number of users logged in over the past 120 days. The tile for this report can be named as "Logged in users" and the number displayed will be a count of the number of records returned by the report.
2. The highest/lowest record in a report
   A report could be developed that shows each course and counts the number of completions it has. The tile for this report can be configured to display the course that has the most completions and named "Most completions".

To display the configurable reports as a tile the block instance needs to be configured to display the reports as tiles instead of a list in the block body.

What do I need to do to have this reviewed and merged in? I have made this for Moodle 3.2 and above on a branch MOODLE_32_STABLE

Block instance view:

Block instance settings:

A subtitle to each block instance can be added. This would typically describe the reports being displayed as a tile.

Displaying data in the tiled configurable report:

1. Counting the number of records a configurable report returns.

2. Display the last/first record (highest/lowest)

Repo

https://github.com/emyb2/moodle-block_configurablereports/tree/MOODLE_32_STABLE

Future things

Currently each block instance that displays the reports as tiles will show the same reports with the same subtitles etc. It would be great to be able to control at the block instance level which reports to display.

Line graph

If we limit the value less than 1000 only i can able to see the line chart, else image is not loading.

Using Moodle 2.5
MSSQL 2005.
PHP 5.3.3

MSSQL ROW_NUMBER() in a sql query crashes Configurable Reports

Moodle version: $release = '3.5.2+ (Build: 20181027)';
Configurable Reports version: $plugin->release = '3.6.0';
OS: Windows Server 2012 R2
PHP v7.2.9 NTS Win32-VC15-x64
Database: Microsoft SQL Server 2016 (SP1) - 13.0.4001.0 (X64)
Database driver: $CFG->dbtype = 'sqlsrv';
PHP SQLSRV extension version: 5.3.0+11108

When I run the following query in a SQL Report

SELECT COUNT(*) AS 'Users who have logged in today' FROM (
	SELECT
		ROW_NUMBER() OVER(ORDER BY lastaccess DESC) AS Row
	FROM mdl_user
	WHERE lastaccess > DATEDIFF(s, '1970-01-01 02:00:00', (SELECT Convert(DateTime, DATEDIFF(DAY, 0, GETDATE()))))
) AS Logins

Configurable Reports crashes with this error:

**[17-May-2019 11:08:50 Africa/Johannesburg] Default exception handler: Error reading from database Debug: SQLState: 42000

Error Code: 102

Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Incorrect syntax near 'OFFSET'.

SQLState: 42000

Error Code: 153

Message: [Microsoft][ODBC Driver 11 for SQL Server][SQL Server]Invalid usage of the option NEXT in the FETCH statement.

SELECT COUNT(*) AS 'Users who have logged in today' FROM (
SELECT
ROW_NUMBER() OVER(ORDER BY lastaccess DESC) AS Row
FROM mdl_user
WHERE lastaccess > DATEDIFF(s, '1970-01-01 02:00:00', (SELECT Convert(DateTime, DATEDIFF(DAY, 0, GETDATE()))))
) AS Logins
OFFSET 0 ROWS FETCH NEXT 20000 ROWS ONLY
[array (
)]
Error code: dmlreadexception

• line 486 of \lib\dml\moodle_database.php: dml_read_exception thrown
• line 324 of \lib\dml\sqlsrv_native_moodle_database.php: call to moodle_database->query_end()
• line 431 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->query_end()
• line 897 of \lib\dml\sqlsrv_native_moodle_database.php: call to sqlsrv_native_moodle_database->do_query()
• line 77 of \blocks\configurable_reports\reports\sql\report.class.php: call to sqlsrv_native_moodle_database->get_recordset_sql()
• line 122 of \blocks\configurable_reports\reports\sql\report.class.php: call to report_sql->execute_query()
• line 71 of \blocks\configurable_reports\viewreport.php: call to report_sql->create_report()**

I posted more details here:
https://moodle.org/mod/forum/discuss.php?d=386483
https://tracker.moodle.org/browse/CONTRIB-7725

I don't have access to a MySQL or Postgres database so I can't test it on those platforms.

3.2-compatible version

Any guess as to when a 3.2-compatible version will be available? Has anybody reported whether the latest version simply works as-is with 3.2?

Constant REPORT_CUSTOMSQL_MAX_RECORDS already defined

Notice: Constant REPORT_CUSTOMSQL_MAX_RECORDS already defined in /home/catholic/public_html/totara/blocks/configurable_reports/reports/sql/report.class.php on line 25

block_configurablereports 2011040114
report_customsql 2014061800

Reports are wrongly thought to be on a system context

Problem: when a teacher tries to access any report editing links from managereport.php, he/she never gets access due to missing permissions.

There are two options why this happens:

1. editing links are missing 'courseid' parameter in URLs therefore editreport.php thinks it is from a system context
2. editreport.php has a default value for courseid=SITEID which forces system context to be used.

I have modified it to grab a 'courseid' value from DB instead of from given URL:

        if ($id) {
              $courseid = $DB->get_field('block_configurable_reports','courseid',array('id' => $id));
        }

This seems to be an inconsistency for me, since none of our teachers has editing rights on a system context, only within courses.

Ability to specify remote or local db per report

Instead of having a site wide setting for using a remote DB or the local DB , it would be good to have a tick-box / yes|no for using a local DB or using the remote DB .

The remote DB could be configured in the settings so it is the default as it is currently, and on the editreport.php page, there is an option to set it to run locally (or visa versa).

403 Error while installing on Moodle 3

I get 403 Error while upgrading this plugin to its latest version on Moodle 3.0
Tried several previous versions of the plugin and got the same 403 Error on Moodle 3.0
Please see the screenshot attached.

cr_import_xml() failure when Importing Report From Repository

When using the Import Report From Repository feature, I get the following notices:

Notice: cr_import_xml(): The script tried to execute a method or access a property of an incomplete object. Please ensure that the class definition "object" of the object you are trying to operate on was loaded _before_ unserialize() gets called or provide a __autoload() function to load the class definition in /var/www/blocks/configurable_reports/locallib.php on line 543

Notice: cr_import_xml(): The script tried to execute a method or access a property of an incomplete object. Please ensure that the class definition "object" of the object you are trying to operate on was loaded _before_ unserialize() gets called or provide a __autoload() function to load the class definition in /var/www/blocks/configurable_reports/locallib.php on line 544

In this case, I was attempting to import the "User course completion with Criteria" User type report however it happens with others as well. The report gets created but includes no SQL.

When you go to view the SQL report, you get the following error message:

Notice: report_sql::create_report(): The script tried to execute a method or access a property of an incomplete object. Please ensure that the class definition "object" of the object you are trying to operate on was loaded _before_ unserialize() gets called or provide a __autoload() function to load the class definition in /var/www/blocks/configurable_reports/reports/sql/report.class.php on line 108

I am using:

• Configurable Reports 3.1.1
• Moodle 3.4.2+
• PHP 7.0

Let me know if you need any additional information.

Best regards,

Michael Milette

SQL reports that exceed the number of rows in 'Report row limit' get truncated

The Report row limit (block_configurable_reports | reportlimit) setting in CR defines the maximum number of records that get displayed in a Custom SQL Report. If the query that you use returns more rows than that defined reportlimit number the report gets truncated at that number of rows.

So, if the reportlimit has been left at the default 5000 value and you create a custom SQL report that returns 6000 rows the report that Configurable Reports produces will be truncated at 5000 rows! When that truncation occurs CR needs to display a clear warning message indicating that the report has been truncated. This will reduce the risk of people producing custom SQL reports that have been truncated without them realizing that the truncation has occurred.

CR:
$plugin->version = 2019021500;
$plugin->release = '3.6.0';

Moodle:
$release = '3.5.2+ (Build: 20181027)';

See https://tracker.moodle.org/browse/CONTRIB-7727

Graphs are not working properly with PHP 7

When I add a bar chart to a Configurable report, I get the following messages when I try to view the report (with debugging set to DEVELOPER):

Notice: Undefined offset: 1 in /var/www/html/blocks/configurable_reports/components/plot/bar/plugin.class.php on line 45

Notice: Undefined offset: 1 in /var/www/html/blocks/configurable_reports/components/plot/bar/plugin.class.php on line 53

In addition, I get a broken image instead of a graph.

I am using:

• Configurable Reports v3.1.1 (2016020103)
• Moodle 3.4.3 (2017111303) release on 2018-05-17
• PHP 7.0

Let me know if you have any questions.

Best regards,

Michael

Error when using in Moodle 3.4

When trying to view reports in a course we see the following error:

get_role_users() without specifying one single roleid needs to be called prefixing role assignments id (ra.id) as unique field, you can use $fields param for it.
line 3619 of /lib/accesslib.php: call to debugging()
line 45 of /blocks/configurable_reports/components/conditions/usersincurrentcourse/plugin.class.php: call to get_role_users()
line 352 of /blocks/configurable_reports/report.class.php: call to plugin_usersincurrentcourse->execute()
line 386 of /blocks/configurable_reports/report.class.php: call to report_base->elements_by_conditions()
line 71 of /blocks/configurable_reports/viewreport.php: call to report_base->create_report()

from readme_moodle.txt: grunt js fails (no package.json or gruntfile.js)

trying to follow the steps in the readme_moodle.txt file in the root directory and i've come across an error. when i run grunt js (i'm assuming to minify the js) i get this:
`% grunt js
grunt-cli: The grunt command line interface (v1.3.2)

Fatal error: Unable to find local grunt.

If you're seeing this message, grunt hasn't been installed locally to
your project. For more information about installing and configuring grunt,
please see the Getting Started guide:

https://gruntjs.com/getting-started
`
and there's no package.js nor Gruntfile.js within the repository ...

so i'm skipping this step for now.

this might be a bug, or is there an expectation that anyone reading that far will be able to generate these files themselves ... ?

enable AMOS translations

Juan,

Please see if you can initiate an English translation for Configurable Reports on the lang.moodle.org (AMOS) translation server/service.

It will enable us (Hebrew users and others) to upload translations and manage them easily.

Nadav :-)

Report Dies if it is too large. Hitting PHP Memory Limit

We edited a report which on trying to export gives an error message (with debugging turned on) of

PHP Fatal Error: Allowed Memory Size of X Bytes Exhausted

due to the amount of data the report is generating. This was for a CSV export as well.

To get around this, we added the Moodle raise_memory_limit() function to viewreport.php on line 109 as below.

    } else {
        raise_memory_limit(MEMORY_HUGE);
        $exportplugin = $CFG->dirroot.'/blocks/configurable_reports/export/'.$format.'/export.php';
        if (file_exists($exportplugin)) {
            require_once($exportplugin);
            export_report($reportclass->finalreport);
        }
        die;

If you would like me to submit a Pull Request, let me know, otherwise this could be added quite easily and would be helpful when needing a report with a lot of data.

Thanks
Alex

Enrolled students filter issue with db query

When I use the enrolled students filter I get the following error.

Issue is here - https://github.com/jleyva/moodle-block_configurablereports/blob/MOODLE_30_STABLE/components/filters/enrolledstudents/plugin.class.php#L74

Fix is to replace the period with a comma.

Actions

Hello Juan, thanks for your work.

What do you think about adding ability to do actions with users in users reports?
It can be complex task. So I think may be we can add ability to select users and add them for bulk actions? Seems as it can be done easily. And I can implement such feature.

Moodle 3.0 branch, JS broken.

I'm seeing these errors:
..blocks/configurable_reports/js/datatables/media/js/jquery.js Failed to load resource: the server responded with a status of 404 (Not Found)

seems to be caused by:
3c218a9

Where the file media/js/jquery.js is deleted but the path is not updated to point to the core jquery file correctly.

This prevents all the js sorting stuff from working.