function mycertificate(&$url)
{
checkPerm('view');
require_once _lms_ . '/lib/lib.course.php';
require_once _base_ . '/lib/lib.table.php';
$lang =& DoceboLanguage::createInstance('profile', 'framework');
$lang =& DoceboLanguage::createInstance('course', 'lms');
$lang =& DoceboLanguage::createInstance('certificate', 'lms');
$admin_level = Docebo::user()->getUserLevelId();
$show_preview = true;
//($admin_level == ADMIN_GROUP_ADMIN || $admin_level == ADMIN_GROUP_GODADMIN);
$title = $lang->def('_MY_CERTIFICATE', 'certificate');
$html = getTitleArea($title, 'mycertificate') . '<div class="std_block">';
//--- draw time periods dropdown ---------------------------------------------
$period_start = '';
$period_end = '';
//extract checking period
$p_model = new TimeperiodsAlms();
$year = date("Y");
$p_list = array("0" => $lang->def('_ALL'));
$p_selected = Get::req('selected_period', DOTY_INT, 0);
$p_data = $p_model->getTimePeriods('', true);
if (count($p_data) > 0) {
foreach ($p_data as $obj) {
$p_list[$obj->id_period] = Format::date($obj->start_date, 'date') . ' - ' . Format::date($obj->end_date, 'date');
if ($p_selected == $obj->id_period) {
$period_start = $obj->start_date;
$period_end = $obj->end_date;
}
}
}
if (!array_key_exists($p_selected, $p_list)) {
$p_selected = 0;
$period_start = '';
$period_end = '';
}
//date dropdown
$onchange = ' onchange="javascript:this.form.submit();"';
$html_filter_cert = '' . Form::openForm('selected_period_form_cert', $url->getUrl()) . Form::openElementSpace() . Form::getDropdown(Lang::t('_TIME_PERIODS', 'menu'), 'selected_period_cert', 'selected_period', $p_list, $p_selected, '', '', $onchange) . Form::closeElementSpace() . Form::getHidden('current_tab_cert', 'current_tab', Get::req('current_tab', DOTY_STRING, 'cert')) . Form::getHidden('is_filtering_cert', 'is_filtering_cert', 1) . Form::closeForm();
$html_filter_meta = '' . Form::openForm('selected_period_form_meta', $url->getUrl()) . Form::openElementSpace() . Form::getDropdown(Lang::t('_TIME_PERIODS', 'menu'), 'selected_period_meta', 'selected_period', $p_list, $p_selected, '', '', $onchange) . Form::closeElementSpace() . Form::getHidden('current_tab_meta', 'current_tab', Get::req('current_tab', DOTY_STRING, 'meta')) . Form::getHidden('is_filtering_meta', 'is_filtering_meta', 1) . Form::closeForm();
//----------------------------------------------------------------------------
$cert = new Certificate();
/*
* Print certificates tables, subdivided by year and course type
*/
$html_cert = '';
$tb_cert = new Table(0);
$cont_h = array($lang->def('_YEAR', 'standard'), $lang->def('_COURSE_CODE', 'course'), $lang->def('_COURSE', 'course'), $lang->def('_CERTIFICATE_NAME', 'course'), $lang->def('_DATE_END', 'course'));
//if ($show_preview) $cont_h[] = '<img src="'.getPathImage('lms').'certificate/preview.gif" alt="'.$lang->def('_PREVIEW').'" />';
//$cont_h[] = '<img src="'.getPathImage('lms').'certificate/certificate.gif" alt="'.$lang->def('_ALT_TAKE_A_COPY').'" />';
if ($show_preview) {
$cont_h[] = '<span class="ico-sprite subs_view"><span>' . $lang->def('_PREVIEW') . '"</span></span>';
}
$cont_h[] = '<span class="ico-sprite subs_pdf"><span>' . $lang->def('_ALT_TAKE_A_COPY') . '</span></span>';
$type_h = array('img-cell', '', '', 'align-center', 'align-center', 'img-cell', 'img-cell');
if ($show_preview) {
$type_h[] = 'nowarp';
}
$type_h[] = 'nowarp';
$tb_cert->setColsStyle($type_h);
$tb_cert->addHead($cont_h);
$available_cert = $cert->certificateForCourses(false, false);
$released = $cert->certificateReleased(Docebo::user()->getIdST());
$query_courses = "" . " SELECT c.idCourse, c.code, c.name, u.status AS user_status, c.course_type, c.permCloseLO " . " FROM %lms_course AS c JOIN %lms_courseuser AS u ON (c.idCourse = u.idCourse) " . " WHERE u.idUser = '******' " . ($period_start != '' ? " AND u.date_complete >= '" . $period_start . "' " : "") . ($period_end != '' ? " AND u.date_complete <= '" . $period_end . "' " : "") . " ORDER BY u.date_complete DESC, u.status DESC ";
$course_list = sql_query($query_courses);
$arr_courses = array();
$arr_courses_ids = array();
while ($obj = sql_fetch_object($course_list)) {
$arr_courses[$obj->course_type][] = array($obj->idCourse, $obj->code, $obj->name, $obj->user_status, $obj->permCloseLO);
$arr_courses_ids[] = $obj->idCourse;
}
$arr_course_types = getCourseTypes();
$table_displayed = false;
//extract certificates details and availability by courses ids
$arr_courses_ids = array_unique($arr_courses_ids);
$arr_certificates_availability = array();
$arr_certificates_details = array();
if (count($arr_courses_ids) > 0) {
$query = "SELECT id_certificate, id_course, available_for_status " . " FROM " . $GLOBALS['prefix_lms'] . "_certificate_course" . " WHERE id_course IN (" . implode(",", $arr_courses_ids) . ")";
//." WHERE id_certificate = '".$id_cert."'"
//." AND id_course IN (".implode(",", $arr_courses_ids).")";
$res = sql_query($query);
while (list($id_certificate, $id_course, $available_for_status) = sql_fetch_row($res)) {
$arr_certificates_availability[$id_course][$id_certificate] = $available_for_status;
}
$cont = array();
$query = "SELECT idCourse, date_inscr, date_first_access, date_complete, status" . " FROM %lms_courseuser WHERE idUser = '******'" . " AND idCourse IN (" . implode(",", $arr_courses_ids) . ") " . ($period_start != '' ? " AND date_complete >= '" . $period_start . "' " : "") . ($period_end != '' ? " AND date_complete <= '" . $period_end . "' " : "");
$res = sql_query($query);
while (list($id_course, $date_inscr, $date_begin, $date_end, $status) = sql_fetch_row($res)) {
$arr_certificate_details[$id_course] = array($date_inscr, $date_begin, $date_end, $status);
}
}
//order arr_courses by key
ksort($arr_courses);
$years = array();
foreach ($arr_courses as $course_type => $course_data) {
if (in_array($course_type, array_keys($arr_course_types))) {
//$html .= '';
$tb = new Table(0);
$tb->setColsStyle($type_h);
$tb->addHead($cont_h);
//filter and organize data to display
$display_data = array();
foreach ($course_data as $k => $value) {
list($id_course, $code, $name, $user_status, $perm_close_lo) = $value;
if (isset($available_cert[$id_course])) {
$can_rel_exceptional = false;
while (list($id_cert, $certificate) = each($available_cert[$id_course])) {
if ($cert->certificateAvailableForUser($id_cert, $id_course, getLogUserId())) {
if ($certificate[CERT_AV_POINT_REQUIRED] > 0) {
$course_score_final = false;
if ($perm_close_lo == 0) {
require_once $GLOBALS['where_lms'] . '/lib/lib.orgchart.php';
$org_man = new OrganizationManagement(false);
$score_final = $org_man->getFinalObjectScore(array(getLogUserId()), array($id_course));
if (isset($score_final[$id_course][getLogUserId()]) && $score_final[$id_course][getLogUserId()]['max_score']) {
$course_score_final = $score_final[$id_course][getLogUserId()]['score'];
$course_score_final_max = $score_final[$id_course][getLogUserId()]['max_score'];
}
} else {
require_once $GLOBALS['where_lms'] . '/lib/lib.coursereport.php';
$rep_man = new CourseReportManager();
$score_course = $rep_man->getUserFinalScore(array(getLogUserId()), array($id_course));
if (!empty($score_course)) {
$course_score_final = isset($score_course[getLogUserId()][$id_course]) ? $score_course[getLogUserId()][$id_course]['score'] : false;
$course_score_final_max = isset($score_course[getLogUserId()][$id_course]) ? $score_course[getLogUserId()][$id_course]['max_score'] : false;
}
}
if ($course_score_final >= $certificate[CERT_AV_POINT_REQUIRED]) {
$can_rel_exceptional = true;
}
}
}
}
reset($available_cert[$id_course]);
//count years for rowspans
while (list($id_cert, $certificate) = each($available_cert[$id_course])) {
//(aggiunto if prima dell'or)
if ($cert->certificateAvailableForUser($id_cert, $id_course, getLogUserId())) {
//$value[4] = $id_cert;
list($available_for_status) = $arr_certificates_availability[$id_course][$id_cert];
list($date_inscr, $date_begin, $date_end, $status) = $arr_certificate_details[$id_course];
if ($available_for_status == 3 && $status == 2 || $available_for_status == 2 && $status == 1 || $available_for_status == 1) {
//$year = substr($date_end, 0, 4);
switch ($available_for_status) {
case 3:
$cur_year = substr($date_end, 0, 4);
break;
case 2:
$cur_year = substr($date_begin, 0, 4);
break;
case 1:
$cur_year = substr($date_inscr, 0, 4);
break;
default:
$cur_year = '-';
}
// (mi ricreo l'array value perchè manca di date_* BUG FIX)
$value = array($id_course, $code, $name, $date_begin, $date_end, $user_status, $perm_close_lo);
$value[6] = $id_cert;
$query = "SELECT name " . " FROM " . $GLOBALS['prefix_lms'] . "_certificate" . " WHERE id_certificate = " . $id_cert;
$res = sql_query($query);
list($cname) = sql_fetch_row($res);
$value[7] = $cname;
if ($can_rel_exceptional && $certificate[CERT_AV_POINT_REQUIRED] > 0) {
if (isset($years[$course_type][$cur_year])) {
$years[$course_type][$cur_year]++;
} else {
$years[$course_type][$cur_year] = 1;
}
$display_data[$cur_year][] = $value;
} elseif (!$can_rel_exceptional && $certificate[CERT_AV_POINT_REQUIRED] == 0) {
if (isset($years[$course_type][$cur_year])) {
$years[$course_type][$cur_year]++;
} else {
$years[$course_type][$cur_year] = 1;
}
$display_data[$cur_year][] = $value;
}
}
}
}
}
}
if (count($display_data) > 0) {
krsort($display_data);
}
$av_cert = 0;
$prev_year = false;
$rowspan_counter = 0;
require_once $GLOBALS['where_lms'] . '/lib/lib.orgchart.php';
$org_man = new OrganizationManagement(false);
foreach ($display_data as $year => $rows) {
$first = true;
foreach ($rows as $row) {
// list($id_course, $code, $name, $user_status, $id_cert) = $row;
list($id_course, $code, $name, $date_begin, $date_end, $user_status, $id_cert, $cname) = $row;
$cont = array();
if ($first) {
$cont[] = array('rowspan' => isset($years[$course_type][$year]) ? $years[$course_type][$year] : 1, 'value' => $year, 'style' => $type_h[0] . ' mycertificate_rowspan' . ($rowspan_counter % 2 > 0 ? '_odd' : ''));
$rowspan_counter++;
$first = false;
}
// 2 - the code of the course
$cont[] = array('value' => $code, 'style' => $type_h[1]);
// 3 - the name of the course
$cont[] = array('value' => $name, 'style' => $type_h[2]);
// sostituito date_begin con certificate name
// 4 - starting date
// $cont[] = array(
// 'value' => Format::date($date_begin, 'datetime'),
// 'style' => $type_h[3]
// );
$cont[] = array('value' => $cname, 'style' => $type_h[3]);
// 5 - complete date
$cont[] = array('value' => Format::date($date_end, 'datetime'), 'style' => $type_h[4]);
//-- scores --
$score_start = $org_man->getStartObjectScore(array(Docebo::user()->getIdST()), array($id_course));
$score_final = $org_man->getFinalObjectScore(array(Docebo::user()->getIdST()), array($id_course));
$_value1 = isset($score_start[$id_course][Docebo::user()->getIdST()]) && $score_start[$id_course][Docebo::user()->getIdST()]['max_score'] ? $score_start[$id_course][Docebo::user()->getIdST()]['score'] . ' / ' . $score_start[$id_course][Docebo::user()->getIdST()]['max_score'] : '';
$_value2 = isset($score_final[$id_course][Docebo::user()->getIdST()]) && $score_final[$id_course][Docebo::user()->getIdST()]['max_score'] ? $score_final[$id_course][Docebo::user()->getIdST()]['score'] . ' / ' . $score_final[$id_course][Docebo::user()->getIdST()]['max_score'] : '';
/* hide course scores - remove comment to show
// 6 - init score
$cont[] = array(
'value' => $_value1,
'style' => $type_h[5]
);
// 7 - end score
$cont[] = array(
'value' => $_value2,
'style' => $type_h[6]
);
*/
if (isset($released[$id_course][$id_cert])) {
$av_cert++;
if ($show_preview) {
$cont[] = array('value' => '', 'style' => $type_h[7]);
}
$_value = '<a class="ico-wt-sprite subs_pdf" href="' . $url->getUrl('op=release_cert&id_certificate=' . $id_cert . '&id_course=' . $id_course) . '" ' . ' title="' . $lang->def('_TAKE_A_COPY') . '"><span>' . $lang->def('_TAKE_A_COPY') . '</span></a>';
$cont[] = array('value' => $_value, 'style' => $type_h[$show_preview ? 8 : 7]);
} else {
$av_cert++;
if ($show_preview) {
$_value = '<a class="ico-wt-sprite subs_view" href="' . $url->getUrl('op=preview_cert&id_certificate=' . $id_cert . '&id_course=' . $id_course) . '" ' . ' title="' . $lang->def('_PREVIEW') . '"><span>' . $lang->def('_PREVIEW') . '</span></a>';
$cont[] = array('value' => $_value, 'style' => $type_h[7]);
}
$_value = '<a class="ico-wt-sprite subs_pdf" href="' . $url->getUrl('op=release_cert&id_certificate=' . $id_cert . '&id_course=' . $id_course) . '" ' . ' title="' . $lang->def('_NEW_CERTIFICATE') . '"><span>' . $lang->def('_NEW_CERTIFICATE') . '</span></a>';
$cont[] = array('value' => $_value, 'style' => $type_h[$show_preview ? 8 : 7]);
}
$tb->addBody($cont);
}
}
if ($av_cert > 0) {
$table_displayed = true;
$html_cert .= '<h2 class="mycertificate_title">' . $arr_course_types[$course_type] . '</h2>';
$html_cert .= $tb->getTable();
}
}
}
//end course_type foreach
if (!$table_displayed) {
$is_filtering = Get::req('is_filtering_cert', DOTY_INT, 0);
$html_cert .= '<p>' . ($is_filtering ? $html_filter_cert : '') . $lang->def('_NO_CONTENT') . '</p>';
} else {
$html_cert = $html_filter_cert . $html_cert;
}
//-------------------------------------------------------------------------------------------
/*
* Print meta-certificates table
*/
$html_meta = '';
$tb_meta_cert = new Table(0);
$cont_h = array();
$cont_h[] = $lang->def('_CODE');
$cont_h[] = $lang->def('_NAME');
$cont_h[] = $lang->def('_COURSE_LIST');
//if ($show_preview) $cont_h[] = '<img src="'.getPathImage('lms').'certificate/preview.gif" alt="'.$lang->def('_PREVIEW').'" />';
//$cont_h[] = '<img src="'.getPathImage('lms').'certificate/certificate.gif" alt="'.$lang->def('_ALT_TAKE_A_COPY').'" />';
if ($show_preview) {
$cont_h[] = '<span class="ico-sprite subs_view"><span>' . $lang->def('_PREVIEW') . '"</span></span>';
}
$cont_h[] = '<span class="ico-sprite subs_pdf"><span>' . $lang->def('_ALT_TAKE_A_COPY') . '</span></span>';
$type_h = array();
$type_h[] = '';
$type_h[] = '';
$type_h[] = '';
if ($show_preview) {
$type_h[] = 'img-cell';
}
//'nowrap';
$type_h[] = 'img-cell';
//'nowrap';
$tb_meta_cert->setColsStyle($type_h);
$tb_meta_cert->addHead($cont_h);
$query = "SELECT c.idMetaCertificate, m.title, m.description, m.idCertificate" . " FROM %lms_certificate_meta_course as c" . " JOIN %lms_certificate_meta as m ON c.idMetaCertificate = m.idMetaCertificate" . " WHERE c.idUser = '******'" . " GROUP BY c.idMetaCertificate" . " ORDER BY m.title, m.description";
$result = sql_query($query);
$av_meta_cert = sql_num_rows($result);
$cert_meta_html = '';
while (list($id_meta, $name, $description, $id_certificate) = sql_fetch_row($result)) {
$cont = array();
$query = "SELECT code, name" . " FROM %lms_certificate" . " WHERE id_certificate = " . " (" . " SELECT idCertificate" . " FROM %lms_certificate_meta" . " WHERE idMetaCertificate = '" . $id_meta . "'" . " )";
list($code, $name) = sql_fetch_row(sql_query($query));
$cont[] = $code;
$cont[] = $name;
$query_released = "SELECT on_date" . " FROM %lms_certificate_meta_assign" . " WHERE idUser = '******'" . " AND idMetaCertificate = '" . $id_meta . "'";
$result_released = sql_query($query_released);
$query = "SELECT user_release" . " FROM %lms_certificate" . " WHERE id_certificate = '" . $id_certificate . "'";
list($user_release) = sql_fetch_row(sql_query($query));
if (sql_num_rows($result_released)) {
$course_list = '';
$first = true;
$query_course = "SELECT code, name" . " FROM %lms_course" . " WHERE idCourse IN " . "(" . "SELECT idCourse" . " FROM " . $GLOBALS['prefix_lms'] . "_certificate_meta_course" . " WHERE idUser = '******'" . " AND idMetaCertificate = '" . $id_meta . "'" . ")";
$result_course = sql_query($query_course);
while (list($code, $name) = sql_fetch_row($result_course)) {
if ($first) {
$first = false;
} else {
$course_list .= '<br/>';
}
$course_list .= '(' . $code . ') - ' . $name;
}
$cont[] = $course_list;
if ($show_preview) {
$cont[] = '';
}
list($date) = sql_fetch_row($result_released);
$cont[] = '<a class="ico-wt-sprite subs_pdf" href="' . $url->getUrl('op=release_cert&id_certificate=' . $id_certificate . '&idmeta=' . $id_meta) . '" ' . ' title="' . $lang->def('_TAKE_A_COPY') . '"><span>' . $lang->def('_TAKE_A_COPY') . '</span></a>';
$tb_meta_cert->addBody($cont);
} elseif ($user_release == 0) {
$av_meta_cert--;
} else {
$query = "SELECT idCourse" . " FROM %lms_certificate_meta_course" . " WHERE idUser = '******'" . " AND idMetaCertificate = '" . $id_meta . "'";
$result_int = sql_query($query);
$control = true;
while (list($id_course) = sql_fetch_row($result_int)) {
$query = "SELECT COUNT(*)" . " FROM %lms_courseuser" . " WHERE idCourse = '" . $id_course . "'" . " AND idUser = '******'" . " AND status = '" . _CUS_END . "'";
list($number) = sql_fetch_row(sql_query($query));
if (!$number) {
$control = false;
}
}
if ($control) {
$course_list = '';
$first = true;
$query_course = "SELECT code, name" . " FROM %lms_course" . " WHERE idCourse IN " . "(" . "SELECT idCourse" . " FROM " . $GLOBALS['prefix_lms'] . "_certificate_meta_course" . " WHERE idUser = '******'" . " AND idMetaCertificate = '" . $id_meta . "'" . ")";
$result_course = sql_query($query_course);
while (list($code, $name) = sql_fetch_row($result_course)) {
if ($first) {
$first = false;
} else {
$course_list .= '<br/>';
}
$course_list .= '(' . $code . ') - ' . $name;
}
$cont[] = $course_list;
if ($show_preview) {
$cont[] = '<a class="ico-wt-sprite subs_view" href="' . $url->getUrl('op=preview_cert&id_certificate=' . $id_certificate . '&idmeta=' . $id_meta) . '" ' . ' title="' . $lang->def('_PREVIEW') . '"><span>' . $lang->def('_PREVIEW') . '</span></a>';
}
$cont[] = '<a class="ico-wt-sprite subs_pdf" href="' . $url->getUrl('op=release_cert&id_certificate=' . $id_certificate . '&idmeta=' . $id_meta) . '" ' . ' title="' . $lang->def('_NEW_CERTIFICATE') . '"><span>' . $lang->def('_NEW_CERTIFICATE') . '</span></a>';
$tb_meta_cert->addBody($cont);
} else {
$av_meta_cert--;
}
}
}
if ($av_meta_cert) {
$html_meta .= $tb_meta_cert->getTable() . '<br/><br/>';
} else {
//$is_filtering = Get::req('is_filtering_meta', DOTY_INT, 0);
//$html_meta .= '<p>'.($is_filtering>0 ? $html_filter_meta : '').$lang->def('_NO_CONTENT').'</p>';
$html_meta .= '<p>' . $lang->def('_NO_CONTENT') . '</p>';
}
//-----------------------------------------------------------------------------
$selected_tab = Get::req('current_tab', DOTY_STRING, 'cert');
$html .= '<div id="mycertificate_tabs" class="yui-navset">
<ul class="yui-nav">
<li' . ($selected_tab == 'cert' ? ' class="selected"' : '') . '><a href="#cert"><em>' . Lang::t('_CERTIFICATE', 'menu') . '</em></a></li>
<li' . ($selected_tab == 'meta' ? ' class="selected"' : '') . '><a href="#meta"><em>' . Lang::t('_TITLE_META_CERTIFICATE', 'certificate') . '</em></a></li>
</ul>
<div class="yui-content">
<div>' . $html_cert . '</div>
<div>' . $html_meta . '</div>
</div>
</div>';
$html .= '</div>';
//close std_block div
cout($html, 'content');
YuiLib::load('tabs');
cout('<script type="text/javascript">var myTabs = new YAHOO.widget.TabView("mycertificate_tabs");</script>', 'scripts');
}
function userCourseList(&$url, $use_tab = true, $page_add = true)
{
YuiLib::load(array('animation' => 'animation-min.js', 'dragdrop' => 'dragdrop-min.js', 'button' => 'button-min.js', 'container' => 'container-min.js', 'my_window' => 'windows.js'), array('container/assets/skins/sam' => 'container.css', 'button/assets/skins/sam' => 'button.css'));
if ($page_add) {
addJs($GLOBALS['where_lms_relative'] . '/modules/coursecatalogue/', 'ajax.coursecatalogue.js');
}
require_once _base_ . '/lib/lib.form.php';
require_once _base_ . '/lib/lib.user_profile.php';
require_once _base_ . '/lib/lib.navbar.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.preassessment.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.catalogue.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.course.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.coursereport.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.coursepath.php';
require_once $GLOBALS["where_framework"] . "/lib/lib.ajax_comment.php";
require_once $GLOBALS['where_lms'] . '/lib/lib.classroom.php';
// pre-loading coursepath ------------------------------------------------------------------
$path_man = new CoursePath_Manager();
// search for the coursepath ----------------------------------------------------------
$user_coursepath = $path_man->getUserSubscriptionsInfo(getLogUserId(), true);
$coursepath = $path_man->getCoursepathAllInfo(array_keys($user_coursepath));
if (!empty($coursepath)) {
// find structures of the course path ---------------------------------------------
$path_courses = $path_man->getPathStructure(array_keys($coursepath));
$cp_info = $path_man->getAllCoursesInfo($path_courses['all_paths']);
/*echo "<pre>\n\n";
print_r($cp_info);
echo "\n\n</pre>";*/
}
// ------------------------------------------------------------------------
$course_stats = array('total' => 0, 'u_can_enter' => 0, 'with_status' => array(CST_AVAILABLE => 0, CST_EFFECTIVE => 0, CST_CONCLUDED => 0, CST_CANCELLED => 0), 'with_ustatus' => array(_CUS_SUBSCRIBED => 0, _CUS_BEGIN => 0, _CUS_END => 0, _CUS_SUSPEND => 0), 'with_wstatus' => array(_CUS_RESERVED => 0, _CUS_WAITING_LIST => 0), 'with_ulevel' => array(), 'expiring' => 0, 'cert_relesable' => 0);
// ------------------------------------------------------------------------
$filter = importVar('filter', false, 'total');
if ($filter == 'level') {
$filter_level = importVar('filter_on', true, 0);
}
$current_tab = importVar('current_tab', false, 'lo_plan');
if ($use_tab && $page_add) {
addCss('style_tab');
$lo_plan = importVar('lo_plan', false, 0);
$lo_history = importVar('lo_history', false, 0);
if ($lo_plan != 0) {
$current_tab = 'lo_plan';
}
if ($lo_history != 0) {
$current_tab = 'lo_history';
}
}
if ($use_tab && $page_add) {
addCss('style_tab');
$lo_plan = importVar('lo_plan', false, 0);
$lo_history = importVar('lo_history', false, 0);
if ($lo_plan != 0) {
$current_tab = 'lo_plan';
}
if ($lo_history != 0) {
$current_tab = 'lo_history';
}
}
require_once $GLOBALS['where_lms'] . '/lib/lib.certificate.php';
$cert = new Certificate();
$released = $cert->certificateReleased(getLogUserId());
$available_cert = $cert->certificateForCourses(false, false);
// cahce classroom -----------------------------------------------------------------
$classroom_man = new ClassroomManager();
$classrooms = $classroom_man->getClassroomNameList();
$lang =& DoceboLanguage::createInstance('catalogue');
$lang_c =& DoceboLanguage::createInstance('course');
$man_course = new Man_Course();
$subcourse_list = sql_query("" . " SELECT u.idCourse, u.edition_id, level, u.date_inscr, u.date_first_access, " . "\t\tu.date_complete, u.status AS user_status, u.waiting, u.edition_id " . " FROM " . $GLOBALS['prefix_lms'] . "_courseuser AS u" . " WHERE idUser = '******'");
$subscription = array();
while ($cinfo = mysql_fetch_assoc($subcourse_list)) {
$subscription['course'][$cinfo['idCourse']] = $cinfo;
if ($cinfo['edition_id'] != 0) {
$subscription['edition'][$cinfo['idCourse']][$cinfo['edition_id']] = $cinfo;
}
}
// searching courses ---------------------------------------------------------------
$select_course = "" . " SELECT c.idCourse, c.course_type, c.idCategory, c.code, c.name, c.description, c.lang_code, c.difficult, " . "\tc.subscribe_method, c.date_begin, c.date_end, c.max_num_subscribe, " . "\tc.selling, c.prize, c.create_date, c.status AS course_status, c.course_edition, " . "\tc.classrooms, c.img_othermaterial, c.course_demo, c.course_vote, " . "\tc.can_subscribe, c.sub_start_date, c.sub_end_date, c.valid_time, c.userStatusOp, c.show_result, u.status AS user_status, u.level " . ", c.use_logo_in_courselist, c.img_course, c.direct_play ";
$from_course = " FROM " . $GLOBALS['prefix_lms'] . "_course AS c " . "\t JOIN " . $GLOBALS['prefix_lms'] . "_courseuser AS u ";
$where_course = " c.idCourse = u.idCourse " . " AND u.idUser = '******' " . " AND ( c.status <> '" . CST_PREPARATION . "' OR u.level > 3 )" . " AND c.course_type <> 'assessment' ";
$selected_year = 0;
$selected_search = '';
if (isset($_POST['apply_filter'])) {
if ($_POST['year']) {
$where_course .= " AND c.create_date BETWEEN '" . $_POST['year'] . "-01-01 00:00:00' AND '" . $_POST['year'] . "-12-31 23:59:59'";
$selected_year = $_POST['year'];
}
if ($_POST['search'] !== '') {
$where_course .= " AND c.name LIKE '%" . $_POST['search'] . "%'";
$selected_search = $_POST['search'];
}
}
$group_by_course = " GROUP BY c.idCourse ";
$order_course = " ORDER BY ";
$tablist = Get::sett('tablist_mycourses', '');
if ($tablist != '') {
$arr_order_course = explode(',', $tablist);
$arr_temp = array();
foreach ($arr_order_course as $key => $value) {
switch ($value) {
case 'status':
$arr_temp[] = ' u.status ';
break;
case 'code':
$arr_temp[] = ' c.code ';
break;
case 'name':
$arr_temp[] = ' c.name ';
break;
}
}
$order_course = $order_course . implode(', ', $arr_temp);
}
if ($order_course == " ORDER BY ") {
//default without parameter
$order_course .= " u.status, c.name ";
}
// apply search filter --------------------------------------------------------------
$all_lang = Docebo::langManager()->getAllLangCode();
$re_course = sql_query($select_course . $from_course . " WHERE " . $where_course . $group_by_course . $order_course);
// retrive editions ----------------------------------------------------------------
$select_edition = " SELECT e.* ";
$from_edition = " FROM " . $GLOBALS["prefix_lms"] . "_course_editions AS e " . " JOIN " . $GLOBALS["prefix_lms"] . "_courseuser AS u ";
$where_edition = " WHERE e.status <> '" . CST_PREPARATION . "' AND e.id_edition = u.edition_id ";
$re_edition = sql_query($select_edition . $from_edition . $where_edition);
// --------------------------------------------------------------------------------
$editions = array();
if ($re_edition) {
while ($edition_elem = mysql_fetch_assoc($re_edition)) {
$edition_elem['classrooms'] = isset($classrooms[$edition_elem['classrooms']]) ? $classrooms[$edition_elem['classrooms']] : '';
$editions[$edition_elem["id_course"]][$edition_elem["id_course"]] = $edition_elem;
}
}
$man_courseuser = new Man_CourseUser();
$ax_comm = new AjaxComment('course', 'lms');
$comment_count = $ax_comm->getResourceCommentCount();
$user_score = $man_courseuser->getUserCourseScored(getLogUserId());
// -----------------------------------------------------------------------------
$needed_info_for = array();
if (!empty($subscription['course'])) {
$id_course_list = array_keys($subscription['course']);
// find last access to the courses ---------------------------------------------------------------------
require_once $GLOBALS['where_lms'] . '/lib/lib.track_user.php';
$last_access_courses = TrackUser::getLastAccessToCourse(getLogUserId());
// retrive unreaded advice -----------------------------------------------------------------------------
require_once $GLOBALS['where_lms'] . '/lib/lib.advice.php';
$advices = Man_Advice::getCountUnreaded(getLogUserId(), $id_course_list, $last_access_courses);
// retrive unreaded forum messages ---------------------------------------------------------------------
require_once $GLOBALS['where_lms'] . '/lib/lib.forum.php';
$forums = Man_Forum::getCountUnreaded(getLogUserId(), $id_course_list, $last_access_courses);
// retrive new lesson ----------------------------------------------------------------------------------
require_once $GLOBALS['where_lms'] . '/lib/lib.orgchart.php';
$org_chart = OrganizationManagement::getCountUnreaded(getLogUserId(), $id_course_list, $last_access_courses);
if (!empty($path_courses['all_items'])) {
$needed_info_for = array_diff($path_courses['all_items'], $id_course_list);
}
$first_is_scorm = OrganizationManagement::objectFilter($id_course_list, 'scormorg');
$enroll_list = sql_query("" . " SELECT u.idCourse, u.edition_id, COUNT(*) as number " . " FROM " . $GLOBALS['prefix_lms'] . "_courseuser AS u" . " WHERE u.idCourse IN (" . implode($id_course_list, ',') . ") " . " AND u.level = '3'" . " AND u.status IN ('" . _CUS_CONFIRMED . "', '" . _CUS_SUBSCRIBED . "', '" . _CUS_BEGIN . "', '" . _CUS_END . "', '" . _CUS_SUSPEND . "', '" . _CUS_WAITING_LIST . "')" . " AND u.absent = '0'" . " GROUP BY u.idCourse, u.edition_id ");
$enrolled = array();
while ($cinfo = mysql_fetch_assoc($enroll_list)) {
$enrolled[$cinfo['idCourse']][$cinfo['edition_id']] = $cinfo['number'];
}
}
// search pre-assessment -----------------------------------------------------------
$select_assess = "" . " SELECT c.idCourse, c.course_type, c.idCategory, c.code, c.name, c.description, c.lang_code, c.difficult, " . "\tc.subscribe_method, c.date_begin, c.date_end, c.max_num_subscribe, " . "\tc.selling, c.prize, c.create_date, c.status AS course_status, c.course_edition, " . "\tc.classrooms, c.img_othermaterial, c.course_demo, c.course_vote, " . "\tc.can_subscribe, c.sub_start_date, c.sub_end_date, c.valid_time, c.userStatusOp, " . "\tu.level, u.date_inscr, u.date_first_access, u.date_complete, u.status AS user_status, u.waiting, c.advance, u.waiting ";
$from_assess = " FROM " . $GLOBALS['prefix_lms'] . "_course AS c " . "\t JOIN " . $GLOBALS['prefix_lms'] . "_courseuser AS u ";
$where_assess = " c.idCourse = u.idCourse " . " AND u.idUser = '******' " . " AND c.course_type = 'assessment' " . " AND ( c.status <> '" . CST_PREPARATION . "' OR u.level > 3 ) " . ($filter == 'level' ? " AND level = '" . $filter_level . "'" : "");
//." AND ( u.status <> '"._CUS_END."' OR u.level > 3 ) ";
$preass_list = sql_query($select_assess . $from_assess . " WHERE " . $where_assess . " ORDER BY c.name ");
// pre assessment list ---------------------------------------------------------------------------------------
$i = 0;
if (mysql_num_rows($preass_list) && $current_tab == 'lo_plan') {
if ($page_add) {
$GLOBALS['page']->add('<div id="mycourse_asses">' . '<h1>' . $lang_c->def('_ASSESSMENT_LIST') . '</h1>', 'content');
}
while ($cinfo = mysql_fetch_assoc($preass_list)) {
$cinfo['user_score'] = isset($user_score[$cinfo['idCourse']]) ? $user_score[$cinfo['idCourse']] : NULL;
if (isset($comment_count[$cinfo['idCourse']])) {
$cinfo['comment_count'] = $comment_count[$cinfo['idCourse']];
}
if ($page_add) {
$GLOBALS['page']->add(dashmyassess($url, $lang_c, $cinfo, $i++), 'content');
}
}
if ($page_add) {
$GLOBALS['page']->add('</div>', 'content');
}
}
// page intest ------------------------------------------------------------
require_once $GLOBALS['where_lms'] . '/lib/lib.levels.php';
$lvl = CourseLevel::getLevels();
$title = $lang->def('_COURSE_LIST');
switch ($filter) {
case "access":
$title = $lang->def('_COURSE_YOU_CAN_ACCESS');
break;
case "expiring":
$title = $lang->def('_COURSE_EXPIRING');
break;
case "subscribed":
$title = $lang->def('_COURSE_SUBSCRIBED');
break;
case "begin":
$title = $lang->def('_COURSE_BEGIN');
break;
case "end":
$title = $lang->def('_COURSE_END');
break;
case "level":
$title = str_replace('[level]', $lvl[$_GET['filter_on']], $lang->def('_COURSE_AS'));
break;
}
if ($page_add) {
$GLOBALS['page']->add('<div id="mycourse_list">' . '<h1>' . $title . '</h1>', 'content');
}
$i = 0;
$direct_play = false;
while ($cinfo = mysql_fetch_assoc($re_course)) {
$access = Man_Course::canEnterCourse($cinfo);
if ($cinfo['direct_play'] == 1) {
$direct_play = true;
}
$course_stats['total']++;
if ($cinfo['user_status'] == _CUS_RESERVED || $cinfo['user_status'] == _CUS_WAITING_LIST) {
$course_stats['with_wstatus'][$cinfo['user_status']]++;
} elseif ($access['can']) {
$course_stats['u_can_enter']++;
}
if (isset($course_stats['with_ustatus'][$cinfo['user_status']])) {
$course_stats['with_ustatus'][$cinfo['user_status']]++;
} else {
$course_stats['with_ustatus'][$cinfo['user_status']] = 1;
}
if (!isset($course_stats['with_ulevel'][$cinfo['level']])) {
$course_stats['with_ulevel'][$cinfo['level']] = 1;
} else {
$course_stats['with_ulevel'][$cinfo['level']]++;
}
if (isset($available_cert[$cinfo['idCourse']])) {
while (list($id_cert, $certificate) = each($available_cert[$cinfo['idCourse']])) {
if (!isset($released[$id_cert]) && $cert->canRelease($certificate[CERT_AV_STATUS], $cinfo['user_status'])) {
$course_stats['cert_relesable']++;
}
}
}
}
if (mysql_num_rows($re_course)) {
mysql_data_seek($re_course, 0);
}
while ($cinfo = mysql_fetch_assoc($re_course)) {
$cinfo['edition_list'] = isset($editions[$cinfo['idCourse']]) ? $editions[$cinfo['idCourse']] : array();
$cinfo['user_score'] = isset($user_score[$cinfo['idCourse']]) ? $user_score[$cinfo['idCourse']] : NULL;
$cinfo['enrolled'] = isset($enrolled[$cinfo['idCourse']]) ? $enrolled[$cinfo['idCourse']] : false;
if (isset($comment_count[$cinfo['idCourse']])) {
$cinfo['comment_count'] = $comment_count[$cinfo['idCourse']];
}
$cinfo['classrooms'] = isset($classrooms[$cinfo['classrooms']]) ? $classrooms[$cinfo['classrooms']] : '';
// advertising --------------------------------------------------------------------------------------------
$cinfo['to_read']['advice'] = isset($advices[$cinfo['idCourse']]) ? $advices[$cinfo['idCourse']] : 0;
$cinfo['to_read']['forum'] = isset($forums[$cinfo['idCourse']]) ? $forums[$cinfo['idCourse']] : 0;
$cinfo['to_read']['lobj'] = isset($org_chart[$cinfo['idCourse']]) ? $org_chart[$cinfo['idCourse']] : 0;
// 10 days in the future
$range = time() + 10 * 24 * 60 * 60;
$expiring = false;
if ($cinfo['date_end'] != '0000-00-00') {
$time_end = fromDatetimeToTimestamp($cinfo['date_end']);
if ($range > $time_end) {
$expiring = true;
$course_stats['expiring']++;
}
}
if ($cinfo['valid_time'] != '0' && $cinfo['valid_time'] != '' && $cinfo['date_first_access'] != '') {
$time_first_access = fromDatetimeToTimestamp($cinfo['date_first_access']);
if ($range > $time_first_access + $cinfo['valid_time'] * 24 * 3600) {
$expiring = true;
$course_stats['expiring']++;
}
}
if (isset($first_is_scorm[$cinfo['idCourse']])) {
$cinfo['first_is_scorm'] = $first_is_scorm[$cinfo['idCourse']];
} else {
$cinfo['first_is_scorm'] = false;
}
$access = Man_Course::canEnterCourse($cinfo);
// --------------------------------------------------------------------
if (!isset($path_courses['all_items'][$cinfo['idCourse']])) {
// the course is not related with a coursepath, so i can print it --------------
if ($filter == 'level') {
if ($subscription['course'][$cinfo['idCourse']]['level'] == $filter_level) {
$dash = dashmycourse($url, $lang_c, $subscription, $cinfo, $i++);
} else {
$dash = '';
}
} else {
$dash = dashmycourse($url, $lang_c, $subscription, $cinfo, $i++);
}
if ($use_tab == true) {
if ($course_stats['with_ustatus'][_CUS_END] == $course_stats['total']) {
$current_tab = 'lo_history';
}
if ($current_tab == 'lo_history') {
if ($cinfo['user_status'] == _CUS_END && $page_add) {
$GLOBALS['page']->add($dash, 'content');
}
} else {
if (($cinfo['user_status'] != _CUS_END || $cinfo['level'] >= 4) && $page_add) {
$GLOBALS['page']->add($dash, 'content');
}
}
} else {
switch ($filter) {
case "access":
if ($access['can'] && $page_add) {
$GLOBALS['page']->add($dash, 'content');
}
break;
case "expiring":
if ($expiring && $page_add) {
$GLOBALS['page']->add($dash, 'content');
}
break;
case "subscribed":
if ($cinfo['user_status'] == _CUS_SUBSCRIBED && $page_add) {
$GLOBALS['page']->add($dash, 'content');
}
break;
case "begin":
if ($cinfo['user_status'] == _CUS_BEGIN && $page_add) {
$GLOBALS['page']->add($dash, 'content');
}
break;
case "end":
if ($cinfo['user_status'] == _CUS_END && $page_add) {
$GLOBALS['page']->add($dash, 'content');
}
break;
case "level":
if ($_GET['filter_on'] == $cinfo['level'] && $page_add) {
$GLOBALS['page']->add($dash, 'content');
}
break;
default:
if ($page_add) {
$GLOBALS['page']->add($dash, 'content');
}
}
}
} else {
// the course is related with a coursepath, so i must wait to print it ----------
//$cinfo['prerequisites'] = $path_courses['all_items'][$cinfo['idCourse']]; // <- useless?
//$courses =array($cinfo['idCourse']=>$cinfo);
$prere = $cp_info[$cinfo['idCourse']]["prerequisites"];
if ($path_man->checkPrerequisites($prere, $subscription)) {
$cinfo['prerequisites_satisfied'] = true;
} else {
$cinfo['prerequisites_satisfied'] = false;
}
if ($filter == 'level') {
if ($subscription['course'][$cinfo['idCourse']]['level'] == $filter_level) {
$course_cache[$cinfo['idCourse']] = dashmycourse($url, $lang_c, $subscription, $cinfo, 1, true, 4);
} else {
$course_cache[$cinfo['idCourse']] = '';
}
} else {
$course_cache[$cinfo['idCourse']] = dashmycourse($url, $lang_c, $subscription, $cinfo, 1, true, 4);
}
}
// end else-if -------------------------------------------------------
}
// end while ------------------------------------------------------------
if ($direct_play && $page_add) {
$GLOBALS['page']->add('' . ' <link href="' . getPathTemplate() . '/style/shadowbox.css" rel="stylesheet" type="text/css" />' . '<script type="text/javascript" src="' . $GLOBALS['where_framework_relative'] . '/addons/shadowbox/shadowbox-yui.js"></script>' . "\n" . '<script type="text/javascript" src="' . $GLOBALS['where_framework_relative'] . '/addons/shadowbox/shadowbox.js"></script>' . "\n", 'page_head');
$GLOBALS['page']->add('<script type="text/javascript">
YAHOO.util.Event.onDOMReady(function() {
var options = { listenOverlay:false, overlayOpacity:"0.8",
loadingImage:"' . getPathImage('lms') . 'standard/loading.gif", overlayBgImage:"' . getPathImage('lms') . 'standard/overlay-85.png",
text: {close: "' . Lang::t('_CLOSE') . '", cancel: "' . Lang::t('_UNDO') . '", loading:"' . Lang::t('_LOADING') . '" },
onOpen: function (gallery) { window.onbeforeunload = function() { return "' . Lang::t('_CONFIRM_EXIT', 'organization', 'lms') . '"; } }
};
Shadowbox.init(options);
Shadowbox.close = function() {
window.frames[\'shadowbox_content\'].uiPlayer.closePlayer(true, window);
}
});
</script>');
}
if ($course_stats['total'] == 0 && $page_add) {
$GLOBALS['page']->add('' . '<b>' . $lang->def('_NO_COURSE') . '</b> ' . '<br />', 'content');
}
if ($page_add) {
$GLOBALS['page']->add('</div>', 'content');
}
// Coursepath --------------------------------------------------------------
if (!empty($coursepath)) {
// find structures of the course path ----------------------------------
$path_slot = $path_man->getPathSlot(array_keys($coursepath));
// coursepath list -----------------------------------------------------
if ($page_add) {
$GLOBALS['page']->add('<div id="mycoursepath_list">' . '<h1>' . $lang->def('_COURSEPATH_LIST') . '</h1>', 'content');
}
$i = 0;
// find course basilar information -------------------------------------
if (!empty($needed_info_for)) {
$course_info = $man_course->getAllCourses(false, false, $needed_info_for);
} else {
$course_info = array();
}
while (list($id_path, $path) = each($coursepath)) {
$html = '<div class="coursepath_container coursepath_container_simple">';
$html .= '<h2>' . ($path[COURSEPATH_CODE] != '' ? '[' . $path[COURSEPATH_CODE] . '] ' : '') . $path[COURSEPATH_NAME] . '</h2>';
if (!isset($path_courses[$id_path]) || empty($path_courses[$id_path])) {
$html .= $lang->def('_NO_COURSE_ASSIGNED_TO_COURSEPATH') . '<br />';
} else {
// display the slots
foreach ($path_slot[$id_path] as $id_slot => $slot_info) {
if ($id_slot == 0) {
$html .= '<h3>' . $lang->def('_MANDATORY') . '</h3>';
if (!empty($path_courses[$id_path][$id_slot])) {
$html .= '<ul class="coursepath_mainslot">';
}
} else {
if ($slot_info['min_selection'] > 0 && $slot_info['max_selection'] > 0) {
$title = str_replace(array('[min_selection]', '[max_selection]'), array($slot_info['min_selection'], $slot_info['max_selection']), $lang->def('_COURSE_PATH_SLOT_MIN_MAX'));
} elseif ($slot_info['max_selection'] > 0) {
$title = str_replace('[max_selection]', $slot_info['max_selection'], $lang->def('_COURSE_PATH_SLOT_MAX'));
} else {
$title = $lang->def('_COURSE_PATH_SLOT');
}
$html .= '<h3>' . $title . '</h3>';
if (!empty($path_courses[$id_path][$id_slot])) {
$html .= '<ul class="coursepath_otherslot">';
}
}
while (list($id) = each($path_courses[$id_path][$id_slot])) {
if (isset($course_cache[$id])) {
$html .= '<li>' . $course_cache[$id] . '</li>';
} else {
$html .= '<li>' . dashAcourse($id, 4) . '</li>';
}
}
if (!empty($path_courses[$id_path][$id_slot])) {
$html .= '</ul>';
}
}
}
$html .= '</div>';
if ($page_add) {
$GLOBALS['page']->add($html, 'content');
}
}
if ($page_add) {
$GLOBALS['page']->add('</div>', 'content');
}
}
if ($course_stats['cert_relesable'] < 0) {
$course_stats['cert_relesable'] = 0;
}
return $course_stats;
}
