FORMA LMS & DOCEBO Open Source Community
https://forum.formalms.org/forum/
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 insertion, alongside the lib.date.php file with setDateFinished().
Code: Select all
public function setDateFinished($id_date, $id_user)
{
list($last_datetime) = sql_fetch_row(sql_query("SELECT MAX(day) AS date_end "
." FROM ".$this->presence_date_table." WHERE id_date = ".$id_date." and id_user = ".$id_user
." GROUP BY id_date"));
list($id_course) = sql_fetch_row(sql_query("SELECT id_course FROM ".$this->date_table." WHERE id_date = ".$id_date));
sql_query("UPDATE ".$this->courseuser_table." SET date_complete = '".($last_datetime?$last_datetime:date('Y-m-d H:i:s'))."' WHERE idUser = ".$id_user." AND idCourse = ".$id_course);
$query = "UPDATE ".$this->user_date_table
." SET date_complete = '".($last_datetime?$last_datetime:date('Y-m-d H:i:s'))."'"
." WHERE id_date = ".$id_date
." AND id_user = ".$id_user;
if (sql_query($query))
return $last_datetime;
else return false;
}
Code: Select all
if($new_status == _CUS_END)
{
require_once(_lms_.'/lib/lib.date.php');
$date_man = new DateManager();
$date_man->setDateFinished($this->id_date, $id_user);
}
return $subscribe_man->updateUserStatusInCourse($id_user, $this->id_course, $new_status);Code: Select all
$completion_date = false;
if($new_status == _CUS_END)
{
require_once(_lms_.'/lib/lib.date.php');
$date_man = new DateManager();
$completion_date = $date_man->setDateFinished($this->id_date, $id_user);
}
return $subscribe_man->updateUserStatusInCourse($id_user, $this->id_course, $new_status, $completion_date);
alfa24 wrote: ↑Sat Mar 20, 2021 7:27 pm 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 certificates, meta certificates, coursepaths, subscription policies and so on.
The best way is to hook with the courseuser event. With the occasion, I suggest to upgrade synfony framework to make it work wit PHP 8 and enjoy its powerful components.