open-lms-open-source / moodle-enrol_programs Goto Github PK

If there are no programs defined, the SQL at line 179 of enrol/programs/classes/local/calendar.php fetches all calendar events, not just those with a component=='enrol_programs' as both "LEFT JOIN"s just produce null values. I think the "AND e.component=..." in the first "LEFT JOIN" isn't doing what you think it is.
As a result, the following code then deletes every event.
This is from the moodle version 4 stable branch of your code.

This is run at 1 minute past every hour as a scheduled task, so you don't have long to create a program before all your calendar events are wiped.

standard template text response follows... :-)

in your styles.css you define a number of generic styles that could clash with core moodle code or other locations where simliar names are used.

Moodle helpfully adds a number of classes to the body tag based on the path that you can use such as:
eg if you are have a file in mod/assign you would see the following class added to the body tag
path-mod-assign
so if you have an item with the class "filething" on the page you would target it like:

.path-mod-assign .filething {
   color: red;
}

Please make sure your css classes in styles.css are specific enough so they cannot clash with other core code.

The table users does not exist in Moodle, the table user does

Foreign key userid on table enrol_programs_requests points to a non-existent table users.
Foreign key rejectedby on table enrol_programs_requests points to a non-existent table users.
Foreign key userid on table enrol_programs_allocations points to a non-existent table users.
Foreign key userid on table enrol_programs_evidences points to a non-existent table users.
Foreign key createdby on table enrol_programs_evidences points to a non-existent table users.
Foreign key snapshotby on table enrol_programs_prg_snapshots points to a non-existent table users.
Foreign key snapshotby on table enrol_programs_usr_snapshots points to a non-existent table users.
Foreign key userid on table enrol_programs_usr_snapshots points to a non-existent table users.

enrol/programs/db/install.xml
enrol_programs_programs
Key: foreign (contextid) references context (id) OK
enrol_programs_items
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (courseid) references course (id) OK
Key: foreign (previtemid) references enrol_programs_items (id) OK
enrol_programs_groups
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (courseid) references course (id) OK
Key: foreign (groupid) references groups (id) OK
enrol_programs_prerequisites
Key: foreign (itemid) references enrol_programs_items (id) OK
Key: foreign (prerequisiteitemid) references enrol_programs_items (id) OK
enrol_programs_cohorts
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (cohortid) references cohort (id) OK
enrol_programs_sources
Key: foreign (programid) references enrol_programs_programs (id) OK
enrol_programs_requests
Key: foreign (sourceid) references enrol_programs_sources (id) OK
Key: foreign (userid) references users (id) Refers to an unknown table
Key: foreign (rejectedby) references users (id) Refers to an unknown table
enrol_programs_allocations
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (userid) references users (id) Refers to an unknown table
Key: foreign (sourceid) references enrol_programs_sources (id) OK
enrol_programs_completions
Key: foreign (itemid) references enrol_programs_items (id) OK
Key: foreign (allocationid) references enrol_programs_allocations (id) OK
enrol_programs_evidences
Key: foreign (itemid) references enrol_programs_items (id) OK
Key: foreign (userid) references users (id) Refers to an unknown table
Key: foreign (createdby) references users (id) Refers to an unknown table
enrol_programs_prg_snapshots
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (snapshotby) references users (id) Refers to an unknown table
enrol_programs_usr_snapshots
Key: foreign (allocationid) references enrol_programs_allocations (id) OK
Key: foreign (snapshotby) references users (id) Refers to an unknown table
Key: foreign (programid) references enrol_programs_programs (id) OK
Key: foreign (userid) references users (id) Refers to an unknown table
Key: foreign (sourceid) references enrol_programs_sources (id) OK

Table mdl_enrol_programs_programs have a column name 'public'. 'Public' is a reserved word in SQL Server which made this plugin unrelevant with SQL server :(

For exampel, a simple insert in table get an error.
Query error (156): Incorrect syntax near the keyword 'public'.

Best regards,

Hi,
I have installed Moodle 4.0.4+ on Ubuntu 20.04 and using MySQL. Then, I installed moodle-enrol_programs, moodle-block_myprograms, and moodle-local_openlms. However, I am getting an error when I tried to add programs. Please find the details below:
Error details:

JSON.parse: unexpected character at line 1 column 5 of the JSON data
File: https://moodlesite/lib/javascript.php/1667111939/lib/jquery/jquery-3.6.0.min.js
Line: 2
ln: 79470
https://moodlesite/lib/javascript.php/1
ajax/l/s<

ln: 79587
https://moodlesite/lib/javascript.php/1
l

ln: 82355
https://moodlesite/lib/javascript.php/1
send/o/<

I really appreciate your hard work

The next course in the program does not appear automatically when the previous course is complete. we have to go to programs/program management/user select the user, and in that moment the completion date is set and the next course is visble.

The "Installation" section in the README.md file states that: "This code is not yet suitable for production use."

Approximately, when will this plugin be stable enough for production use?

Hi Team,

Great to know Implementing programs, Kudos to Open LMS Team,

I am trying to use this in my lms to add programs, Need web service to get programs, I tried as in snapshot, but not getting results in JSON,

Could you help with this?

Hi Team,

I installed this plugin with all it's dependencies. I use All in Order but I found it is not working as expected.
By default first course is coming to take but after completion of this 2nd or 3rd not getting enabled. I tried multiple time but same issue. I also tried running the CRON but no impact. Can you please check and fix. Also, please let me know in case I am missing something.

If we create a program with no set program end date, enroll some users, and then create a ending date. The ending date of those users didn't update with the new information.
Am i wrong? or there is no way to auto-update this info?
Thanks 4 your work!