Moodle Custom Reports (PhP MySql SQL)
We want a PHP page (Admin Plugin) to query our Moodle 1.9 database and create 3 custom reports:
1.- Enrolled users by region (Region is a custom field in our Moodle users table)
2.- All tests results for a specific user (Tests are quizzes inside the Moodle database)
3.- All courses and topics completed (visited) by a specific user.
(We are attaching an excel file with the sample reports that we need).
Ideally the interface would allow easy querying, filtering and sorting. Populated dropdown options are preferrable so the end user would type the minimum input to the querying page.
Our server is a dedicated Centos.
We do not give any milestone payments to anyone without them having developed at least a prototype first.
1.- We have to test the reports with the database we will send you. You can use the a cpanel account we give you access to or you can use your server. Throuhg feedback (skype chats) we will fine tune the requirements.
2.- Once we believe the files are producing the specs requested we will deploy the files on our servers. We will test to make sure that they work in production mode.
3.- As soon the test is completed and everything works in production the payment will be send to you.
4.- Then we will write our review and rate your work, not before.
NOTE: The Moodle database has many tables, if you do not know how to write SQL well, or analyze it to find out which tables/fields are needed to create the reports DO NOT BID. The data to be queried must be data from a Moodle database.