cwarwicker / moodle-block_bc_dashboard Goto Github PK

Reporting Dashboard plugin for Moodle - Integration with block_gradetracker and block_elbp

License: Other

PHP 40.60% HTML 4.76% CSS 4.16% JavaScript 50.47%

moodle moodle-plugin moodle-block php bc-dashboard grade-tracker plp

moodle-block_bc_dashboard's Introduction

Reporting Dashboard Plugin

This plugin provides you with a Reporting Dashboard block which can be used to create reports, in conjunction with the Grade Tracker and ELBP blocks.

Features

Capability-driven
Reporting Wizard - Build custom reports from pre-defined Grade Tracker and ELBP elements
SQL Reporting - Build your own reports from SQL queries
Run reports In-Browser and Export to Excel
Report Scheduling - Schedule reports to run at specific times and email the results to users

Requirements

Moodle 3.4, 3.5, 3.6, 3.7

Installation

Download the latest version of the plugin from the Releases page.
Extract the directory from the zip file and rename it to 'bc_dashboard' if it is not already named as such.
Place the 'bc_dashboard' folder into your Moodle site's /blocks/ directory.
Run the Moodle upgrade process either through the web interface or command line.
Add the block to a page and start using it

License

https://www.gnu.org/licenses/gpl-3.0

Support

If you need any help using the block, or wish to report a bug or feature request, please use the issue tracking system: https://github.com/cwarwicker/moodle-block_bc_dashboard/issues

If you want to help out with the development, feel free to submit commits for review.

moodle-block_bc_dashboard's People

Contributors

Stargazers

Watchers

moodle-block_bc_dashboard's Issues

Saving report makes some links disappear

All nav links except Save disappear when you save a report and you're not an admin.

It's because when you save it builds up a blank report with form data, but doesn't have the createdby id to compare to yours.

The requested URL /blocks/bc_dashboard/reporting was not found

Hi,

I have installed this plugin along with other ELDP blocks plugins (block_elbp and elbp_timetable).

When trying to access the /blocks/bc_dashboard/reporting URL, and other URLs, it gives me the following error message:

Not Found
The requested URL /blocks/bc_dashboard/reporting was not found on this server.

Export - show errors

When exporting a report, if there are any errors show an error message and cancel the loading gif, otherwise it looks like its still running.

Params issue

Can't save the report without at least 1 param.

Export Built Report: Fatal error

Exception - Invalid parameters passed.

More information about this error

Debug info:
Error code: generalexceptionmessage
Stack trace:
line 250 of /lib/phpexcel/PHPExcel/Writer/Excel2007/Workbook.php: PHPExcel_Writer_Exception thrown
line 220 of /lib/phpexcel/PHPExcel/Writer/Excel2007/Workbook.php: call to PHPExcel_Writer_Excel2007_Workbook->writeSheet()
line 72 of /lib/phpexcel/PHPExcel/Writer/Excel2007/Workbook.php: call to PHPExcel_Writer_Excel2007_Workbook->writeSheets()
line 290 of /lib/phpexcel/PHPExcel/Writer/Excel2007.php: call to PHPExcel_Writer_Excel2007_Workbook->writeWorkbook()
line 889 of /blocks/bc_dashboard/components/reporting/builder/classes/BuiltReport.php: call to PHPExcel_Writer_Excel2007->save()
line 590 of /blocks/bc_dashboard/components/reporting/builder/classes/BuiltReport.php: call to BCDB\Report\BuiltReport->runExportExcel()
line 100 of /blocks/bc_dashboard/components/reporting/builder/BuilderController.php: call to BCDB\Report\BuiltReport->export()
line ? of unknownfile: call to BCDB\Controllers\reporting\BuilderController->action_ajax()
line 122 of /blocks/bc_dashboard/classes/Controller.php: call to call_user_func()
line 147 of /blocks/bc_dashboard/classes/Controller.php: call to BCDB\Controller->loadAction()
line 256 of /blocks/bc_dashboard/lib.php: call to BCDB\Controller->__destruct()
line 48 of /blocks/bc_dashboard/index.php: call to bcdb_callHook()

Student list doesn't load if some PLP plugins not enabled

Forgot to check if the plugins which it is trying to show information for in the list, are actually enabled or not, and its giving fatal error. E.g. Attendance.

Report category changes to private if you edit it and don't have category rights

If you don't have the permission to edit what categories a report is in, but you can edit a report someone else has made, it will set it to be your private report when you save it.

Running report error

Every time I go to run a report I receive the following error, not quite sure why this is happening.

Exception - Call to undefined function gt_get_course()

Regards

Smithy31

SQL Report ordering incorrectly

SQL report ignoring my ORDER BY clause and ordering it wrong. Think it's to do with the table sorting plugin?

Permissions only checking frontpage

Is hard-coded to check front page, but some sintitutions don't use it on the frontpage, so it needs to check against the course id passed in.

Make sure checking for all possible keywords to disable

    $regex = '/\b(ALTER|CREATE|DELETE|DROP|GRANT|INSERT|INTO|TRUNCATE|UPDATE|SET|VACUUM|REINDEX|DISCARD|LOCK)\b/i';

Externally enrolled students do not appear in "User Qualifications"

Hi Conn,

We appear to be having some issues with the Grade Tracker displaying externally enrolled students on http://moodle.swindon-college.ac.uk. All students, both externally and manually enrolled appear in the "View by Student" area to a course in the block but in the "Courses" -> "User Qualifications" page of the grade tracker on that course, only students who have been manually enrolled appear to be available. The role used for students is the "student" role as default for the external enrolments.

Manually enrolling a student who has already been externally enrolled causes them to appear in the list as well so it appears to be a problem specific to external enrolments. Is this an issue you have encountered before?

Thanks,

Sam

Update to Moodle 3.7

General update issue

SQL error (MS SQL) - Built Report

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

SELECT distinct user.id, user.firstname, user.lastname, user.username, count(distinct t2.id) as t2_value, t3.value as t3_value FROM mdl_user user inner join mdl_role_assignments ra ON ra.userid = user.id inner join mdl_context ctxt ON ctxt.id = ra.contextid left join mdl_lbp_targets t2 on (t2.studentid = user.id and t2.del = 0 and t2.status = '3') left join mdl_lbp_att_punc t3 on (t3.studentid = user.id and t3.type = N'Attendance' and t3.period = N'Last 7 Days' AND t3.courseid IS NULL) WHERE user.deleted = 0 AND ra.roleid = 5 AND ctxt.instanceid = '3' GROUP BY user.id ORDER BY user.lastname, user.firstname, user.username