public function saveTrackStatusChange($idUser, $idCourse, $status)
{
require_once $GLOBALS['where_lms'] . '/lib/lib.course.php';
list($prev_status) = sql_fetch_row(sql_query("\r\n\t\tSELECT status\r\n\t\tFROM " . $GLOBALS['prefix_lms'] . "_courseuser\r\n\t\tWHERE idUser = '******' AND idCourse = '" . (int) $idCourse . "'"));
$extra = '';
if ($prev_status != $status) {
switch ($status) {
case _CUS_SUBSCRIBED:
//approved subscriptin for example
$extra = ", date_inscr = NOW()";
break;
case _CUS_BEGIN:
//first access
UpdatesLms::resetCache();
$extra = ", date_first_access = NOW()";
break;
case _CUS_END:
//end course
$extra = ", date_complete = NOW()";
break;
}
}
if (!sql_query("\r\n\t\tUPDATE " . $GLOBALS['prefix_lms'] . "_courseuser\r\n\t\tSET status = '" . (int) $status . "' " . $extra . "\r\n\t\tWHERE idUser = '******' AND idCourse = '" . (int) $idCourse . "'")) {
return false;
}
$re = sql_query("\r\n\t\tSELECT when_do\r\n\t\tFROM " . $GLOBALS['prefix_lms'] . "_statuschangelog\r\n\t\tWHERE status_user = '******' AND\r\n\t\t\tidUser = '******' AND\r\n\t\t\tidCourse = '" . (int) $idCourse . "'");
if (sql_num_rows($re)) {
sql_query("\r\n\t\t\tUPDATE " . $GLOBALS['prefix_lms'] . "_statuschangelog\r\n\t\t\tSET when_do = NOW()\r\n\t\t\tWHERE status_user = '******' AND\r\n\t\t\t\tidUser = '******' AND\r\n\t\t\t\tidCourse = '" . (int) $idCourse . "'");
} else {
sql_query("\r\n\t\t\tINSERT INTO " . $GLOBALS['prefix_lms'] . "_statuschangelog\r\n\t\t\tSET status_user = '******',\r\n\t\t\t\tidUser = '******',\r\n\t\t\t\tidCourse = '" . (int) $idCourse . "',\r\n\t\t\t\twhen_do = NOW()");
}
if ($prev_status != $status && $status == _CUS_END) {
// send alert
if (!sql_num_rows($re)) {
/*
//add course's competences scores to user
require_once($GLOBALS['where_lms'].'/lib/lib.competences.php');
$competences_man = new Competences_Manager();
$competences_man->AssignCourseCompetencesToUser($idCourse, $idUser);
*/
}
require_once $GLOBALS['where_lms'] . '/lib/lib.course.php';
require_once _base_ . '/lib/lib.eventmanager.php';
$teachers = Man_Course::getIdUserOfLevel($idCourse, '6');
$cd = new DoceboCourse($idCourse);
$acl_man =& Docebo::user()->getAclManager();
$array_subst = array('[user]' => $acl_man->getUserName($idUser), '[course]' => $cd->getValue('name'));
$msg_composer = new EventMessageComposer();
$msg_composer->setSubjectLangText('email', '_USER_END_COURSE_SBJ', false);
$msg_composer->setBodyLangText('email', '_USER_END_COURSE_TEXT', $array_subst);
$msg_composer->setBodyLangText('sms', '_USER_END_COURSE_TEXT_SMS', $array_subst);
// send message to the user subscribed
createNewAlert('UserCourseEnded', 'status', 'modify', '1', 'User end course', $teachers, $msg_composer);
//add course's competences scores to user
/*
require_once($GLOBALS['where_lms'].'/lib/lib.competences.php');
$competences_man = new Competences_Manager();
$competences_man->AssignCourseCompetencesToUser($idCourse, $idUser);
*/
//increment coursecompleted if this course is in a coursepath
require_once _lms_ . '/lib/lib.coursepath.php';
$cpmodel = new CoursePath_Manager();
$cpmodel->assignComplete($idCourse, $idUser);
}
return true;
}
