cwarwicker/moodle-block_bc_dashboard

Reporting Dashboard plugin for Moodle - Integration with block_gradetracker and block_elbp

moodle-block_bc_dashboard's Issues

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.

Running report error

Hi

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

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.

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?

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.

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()

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.

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.

*Update to Moodle 3.7*

General update issue

Params issue

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

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

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.

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