function getSubstitution()
{
$subs = array();
$lang =& DoceboLanguage::createInstance('course', 'lms');
$lang =& DoceboLanguage::createInstance('certificate', 'lms');
if ($this->id_meta != 0) {
require_once $GLOBALS['where_lms'] . '/lib/lib.course.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.coursereport.php';
$acl_man =& $GLOBALS['current_user']->getAclManager();
$courses = array();
$array_coursetype = array('elearning' => $lang->def('_COURSE_TYPE_ELEARNING', 'course', 'lms'), 'classroom' => $lang->def('_CLASSROOM', 'course', 'lms'), 'web_seminar' => $lang->def('Web seminar'));
$course_time = 0;
$blended_time = 0;
$query = "SELECT DISTINCT idCourse" . " FROM " . $GLOBALS['prefix_lms'] . "_certificate_meta_course" . " WHERE idMetaCertificate = '" . $this->id_meta . "'" . " AND idUser = '******'";
$result = sql_query($query);
$table_course = '<table width="100%" cellspacing="1" cellpadding="1" border="1" align="" summary="Corsi frequentati">' . '<thead>' . '<tr>' . '<td>' . $lang->def('_COURSE_NAME') . '</td>' . '<td>' . $lang->def('_COURSE_TYPE') . '</td>' . '<td align="right">' . $lang->def('_COURSE_TIME') . '</td>' . '</tr>' . '</thead>' . '</tbody>';
$table_blended = '<table width="100%" cellspacing="1" cellpadding="1" border="1" align="" summary="Corsi frequentati">' . '<thead>' . '<tr>' . '<td>' . $lang->def('_COURSE_NAME') . '</td>' . '<td>' . $lang->def('_COURSE_PROF') . '</td>' . '<td>' . $lang->def('_COURSE_TYPE') . '</td>' . '<td align="right">' . $lang->def('_COURSE_TIME') . '</td>' . '</thead>' . '</tbody>';
$course_count = 0;
$blended_count = 0;
$array_meta_complete = array();
$array_meta_inscr = array();
$array_meta_access = array();
while (list($id_course) = sql_fetch_row($result)) {
$query = "SELECT date_complete, date_inscr, date_first_access" . " FROM " . $GLOBALS['prefix_lms'] . "_courseuser" . " WHERE idCourse = '" . $id_course . "'" . " AND idUser = '******'";
list($date_complete_meta, $date_inscr_meta, $date_access_meta) = sql_fetch_row(sql_query($query));
$array_meta_complete[] = $date_complete_meta;
$array_meta_inscr[] = $date_inscr_meta;
$array_meta_access[] = $date_access_meta;
$man_course = new Man_Course();
$course_info = $man_course->getCourseInfo($id_course);
$rep_man = new CourseReportManager();
$score_course = $rep_man->getUserFinalScore(array($this->id_user), array($this->id_course));
if ($course_info['course_type'] === 'blended') {
$teacher_array = getSubscribed($id_course, false, 6, true);
$first = true;
if (is_array($teacher_array) && !empty($teacher_array)) {
while (list(, $id_teach) = each($teacher_array)) {
$teacher_info = $acl_man->getUser($id_teach);
if ($first) {
$teacher = $teacher_info[ACL_INFO_FIRSTNAME] . ' ' . $teacher_info[ACL_INFO_LASTNAME];
$first = false;
} else {
$teacher = '<br/>' . $teacher_info[ACL_INFO_FIRSTNAME] . ' ' . $teacher_info[ACL_INFO_LASTNAME];
}
}
} else {
$teacher = ' ';
}
$table_blended .= '<tr>' . '<td>' . $course_info['name'] . '</td>' . '<td>' . $teacher . '</td>' . '<td>' . $array_coursetype[$course_info['course_type']] . '</td>' . '<td align="right">' . $course_info['mediumTime'] . '</td>' . '</tr>';
$blended_time += $course_info['mediumTime'];
$blended_count++;
} else {
$table_course .= '<tr>' . '<td>' . $course_info['name'] . '</td>' . '<td>' . $array_coursetype[$course_info['course_type']] . '</td>' . '<td align="right">' . $course_info['mediumTime'] . '</td>' . '</tr>';
$course_time += $course_info['mediumTime'];
$course_count++;
}
}
$table_course .= '<tr>' . '<td align="right" colspan="2">' . $lang->def('_TOTAL_HOURS') . '</td>' . '<td align="right">' . $course_time . '</td>' . '</tr>' . '</tbody>' . '</table>';
$table_blended .= '<tr>' . '<td align="right" colspan="2">' . $lang->def('_TOTAL_HOURS') . '</td>' . '<td align="right">' . $blended_time . '</td>' . '</tr>' . '</tbody>' . '</table>';
rsort($array_meta_complete);
sort($array_meta_inscr);
sort($array_meta_access);
$subs['[meta_complete]'] = $array_meta_complete[0];
$subs['[meta_inscr]'] = $array_meta_inscr[0];
$subs['[meta_access]'] = $array_meta_access[0];
$subs['[table_course]'] = $course_count ? $table_course : '';
$subs['[table_blended]'] = $blended_count ? $table_blended : '';
} else {
require_once $GLOBALS['where_lms'] . '/lib/lib.course.php';
$courseuser = new Man_CourseUser();
$course_stat =& $courseuser->getUserCourses($this->id_user, false, false, false, array($this->id_course));
if (isset($course_stat[$this->id_course])) {
$subs['[date_enroll]'] = Format::date($course_stat[$this->id_course]['date_inscr'], 'date');
$subs['[date_first_access]'] = Format::date($course_stat[$this->id_course]['date_first_access'], 'date');
$subs['[date_complete]'] = Format::date($course_stat[$this->id_course]['date_complete'], 'date');
$subs['[date_complete_year]'] = substr($course_stat[$this->id_course]['date_complete'], 0, 4);
} else {
$subs['[date_enroll]'] = '';
$subs['[date_first_access]'] = '';
$subs['[date_complete]'] = '';
$subs['[date_complete_year]'] = '';
}
require_once $GLOBALS['where_lms'] . '/lib/lib.orgchart.php';
$org_man = new OrganizationManagement($this->id_course);
$score_start = $org_man->getStartObjectScore(array($this->id_user), array($this->id_course));
$score_final = $org_man->getFinalObjectScore(array($this->id_user), array($this->id_course));
require_once $GLOBALS['where_lms'] . '/lib/lib.coursereport.php';
$rep_man = new CourseReportManager();
$score_course = $rep_man->getUserFinalScore(array($this->id_user), array($this->id_course));
$subs['[test_score_start]'] = isset($score_start[$this->id_course][$this->id_user]) ? $score_start[$this->id_course][$this->id_user]['score'] : '';
$subs['[test_score_start_max]'] = isset($score_start[$this->id_course][$this->id_user]) ? $score_start[$this->id_course][$this->id_user]['max_score'] : '';
$subs['[test_score_final]'] = isset($score_final[$this->id_course][$this->id_user]) ? $score_final[$this->id_course][$this->id_user]['score'] : '';
$subs['[test_score_final_max]'] = !empty($score_final[$this->id_course][$this->id_user]['max_score']) ? $score_final[$this->id_course][$this->id_user]['max_score'] : '100';
$subs['[course_score_final]'] = isset($score_course[$this->id_user][$this->id_course]) ? $score_course[$this->id_user][$this->id_course]['score'] : '';
$subs['[course_score_final_max]'] = isset($score_course[$this->id_user][$this->id_course]) ? $score_course[$this->id_user][$this->id_course]['max_score'] : '';
require_once $GLOBALS['where_lms'] . '/lib/lib.track_user.php';
$time_in = TrackUser::getUserTotalCourseTime($this->id_user, $this->id_course);
$hours = (int) ($time_in / 3600);
$minutes = (int) ($time_in % 3600 / 60);
$seconds = (int) ($time_in % 60);
if ($minutes < 10) {
$minutes = '0' . $minutes;
}
if ($seconds < 10) {
$seconds = '0' . $seconds;
}
$subs['[total_time]'] = $hours . 'h ' . $minutes . 'm ' . $seconds . 's';
$subs['[total_time_hour]'] = $hours;
$subs['[total_time_minute]'] = $minutes;
$subs['[total_time_second]'] = $seconds;
}
return $subs;
}
