Not long ago I was tasked to make a tool to manage Moodle courses by moving them through categories, creating and cleaning them up. Now I had to make some way to “refresh” the course participants and that means unenrolling teachers and managers, assign different roles, suspending students, adding students, all that stuff.<\/p>\n
This was going pretty good and easy until I hit upon a web service function The problem here is with a ueid<\/strong> (User enrolment ID) argument because there’s no function that returns such an ID. At least I wasn’t able to find one easily accessible and I had to make my own web service function to get that ID. The sources that I used were: From the table diagram I made out this SQL query to get the record ID:<\/p>\n Because the function expects not the Enrol ID (ID of the record in core_enrol_edit_user_enrolment<\/code>. It’s an External function that updates a given user enrolment<\/em><\/code>, it is needed to suspend students from a course.
\nFrom the official API docs, we can see that it takes in required arguments courseid<\/strong> (User enrolment ID), ueid<\/strong> (User enrolment ID) and status<\/strong> (Enrolment status).<\/p>\n
\n
\nIt appears that Moodle plugin development isn’t thoroughly documented and straightforward, so I took an example template<\/a> and built on it by reading here and there.<\/p>\n
\nhttps:\/\/docs.moodle.org\/dev\/Enrolment_API<\/a>
\nhttps:\/\/docs.moodle.org\/dev\/Adding_a_web_service_to_a_plugin<\/a>
\nhttp:\/\/www.examulator.com\/er\/components\/course.html<\/a>
\nhttps:\/\/docs.moodle.org\/dev\/Tutorial<\/a>
\nand some various forum posts.<\/p>\nSELECT {user_enrolments}.id AS id, {user_enrolments}.enrolid AS enrolid, {user_enrolments}.userid AS userid, {enrol}.courseid AS courseid\r\nFROM {user_enrolments}, {enrol}\r\nWHERE {user_enrolments}.enrolid = {enrol}.id AND {enrol}.courseid = ? AND {user_enrolments}.userid = ?<\/pre>\nenrol<\/code> table), but the ID of the record from user_enrolments<\/code> table, that is what I returned.<\/p>\n