Search found 61 matches

by scubatricky
Tue Mar 23, 2021 10:45 am
Forum: Administration Management
Topic: Competencies Not Working For Classroom Course
Replies: 36
Views: 7718

Re: Competencies Not Working For Classroom Course

To be honest, I find the whole workflow very chaotic and redundant so I've spent a couple of weeks working at its refactoring. Now my instance is much more logical regarding status changes, and what happens when the status changes to completed. Not only competences are involved, but also certificat...
by scubatricky
Sat Mar 20, 2021 5:19 pm
Forum: Administration Management
Topic: Competencies Not Working For Classroom Course
Replies: 36
Views: 7718

Re: Competencies Not Working For Classroom Course

Thanks, looks like that is now fixed. It'll need updating in V3.0 :-)
by scubatricky
Sun Mar 07, 2021 4:16 pm
Forum: Administration Management
Topic: Competencies Not Working For Classroom Course
Replies: 36
Views: 7718

Re: Competencies Not Working For Classroom Course

You must be missing something. I've tried and it works. Unfortunately not. There is still the current time value being assigned to the learning_coursesuer:date_completed field in the database. competencies will make no difference to this, as it's the subscribe library that is controlling the date i...
by scubatricky
Sun Mar 07, 2021 1:28 pm
Forum: Administration Management
Topic: Competencies Not Working For Classroom Course
Replies: 36
Views: 7718

Re: Competencies Not Working For Classroom Course

Unfortunately no success. Marking a student as attended, and setting their course status to complete adds Now() to the learning_courseuser -> date_completed field.

I'm looking at lib.subscribe.php now for the bug.
by scubatricky
Fri Mar 05, 2021 4:35 pm
Forum: Administration Management
Topic: Competencies Not Working For Classroom Course
Replies: 36
Views: 7718

Re: Competencies Not Working For Classroom Course

Just implemented the above code in the competencies files, no change to behaviour unfortunately. After dinner this evening I will trace through lib.subscribe.php and find the error.
by scubatricky
Fri Mar 05, 2021 4:28 pm
Forum: Administration Management
Topic: Competencies Not Working For Classroom Course
Replies: 36
Views: 7718

Re: Competencies Not Working For Classroom Course

:lol: alfa24, you may be my twin, I'm just looking through SubscriptionsAlms.php and it appears to call updateUserStatusInCourse, just after setDateFinished has been called. updateUserStatusInCourse takes a variable $new_date_complete, which if empty, inserts Now() into the query... The rabbit hole ...
by scubatricky
Thu Mar 04, 2021 10:21 pm
Forum: Administration Management
Topic: Competencies Not Working For Classroom Course
Replies: 36
Views: 7718

Re: Competencies Not Working For Classroom Course

Thanks alfa24, suffice to say the code you posted previously updates the DB correctly, but somewhere else in the system is resetting the date automatically straight after the update. This can be watched with a trace on the DB field when running the code. I'll continue debugging the code and find out...
by scubatricky
Thu Mar 04, 2021 9:14 pm
Forum: Administration Management
Topic: Competencies Not Working For Classroom Course
Replies: 36
Views: 7718

Re: Competencies Not Working For Classroom Course

Please provide detailed steps to reproduce the issue WITH my proposed function. alfa24, tracked the problem down, and it was with the DB, not the code. However, I've now found another problem :lol: https://forum.formalms.org/forum/download/file.php?mode=view&id=1051 The date of completion in the us...
by scubatricky
Wed Mar 03, 2021 6:49 pm
Forum: Administration Management
Topic: Competencies Not Working For Classroom Course
Replies: 36
Views: 7718

Re: Competencies Not Working For Classroom Course

Tried to implement the code above Alfa24, but unfortunately unsuccessful as there is another piece of code that is taking a value from php Now() and inserting it into learning_courseuser table in the field date_complete. I dug around in the lib.subscribe.php file and found the function updateUserDat...
by scubatricky
Thu Feb 18, 2021 5:54 pm
Forum: Installation and configuration
Topic: Locked access - how to unlock
Replies: 6
Views: 2253

Re: Locked access - how to unlock

The table core_setting contains a field called param_value.

Set this to 0 via phpmyadmin or such and you'll not have the problem if you are locked out again.