public function add()
{
require_once _lms_ . '/lib/lib.course.php';
//Course info
$id_course = Get::req('id_course', DOTY_INT, 0);
$course_info = Man_Course::getCourseInfo($id_course);
$model = new EditionLms($id_course);
if (isset($_POST['undo'])) {
Util::jump_to('index.php?r=edition/show&id_course=' . $model->getIdCourse());
} elseif (isset($_POST['ins'])) {
if ($model->addEdition()) {
Util::jump_to('index.php?r=edition/show&id_course=' . $model->getIdCourse() . '&result=ok');
}
Util::jump_to('index.php?r=edition/show&id_course=' . $model->getIdCourse() . '&result=err_ins');
} else {
$this->render('add', array('model' => $model, 'course_info' => $course_info));
}
}
public function add()
{
if (!$this->permissions['add']) {
$this->render('invalid', array('message' => $this->_getMessage('no permission'), 'back_url' => 'index.php?r=alms/communication/show'));
return;
}
require_once _lms_ . '/lib/lib.course.php';
//Course info
$id_course = Get::req('id_course', DOTY_INT, 0);
$course_info = Man_Course::getCourseInfo($id_course);
$model = new EditionAlms($id_course);
if (isset($_POST['undo'])) {
Util::jump_to('index.php?r=' . $this->base_link_edition . '/show&id_course=' . $model->getIdCourse());
} elseif (isset($_POST['ins'])) {
if ($model->addEdition()) {
Util::jump_to('index.php?r=' . $this->base_link_edition . '/show&id_course=' . $model->getIdCourse() . '&result=ok');
}
Util::jump_to('index.php?r=' . $this->base_link_edition . '/show&id_course=' . $model->getIdCourse() . '&result=err_ins');
} else {
$this->render('add', array('model' => $model, 'course_info' => $course_info, 'base_link_course' => $this->base_link_course, 'base_link_edition' => $this->base_link_edition));
}
}
function showprofile()
{
require_once $GLOBALS['where_lms'] . '/lib/lib.course.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.lms_user_profile.php';
$lang =& DoceboLanguage::createInstance('catalogue');
$lang =& DoceboLanguage::createInstance('course');
$id_user = importVar('id_user');
$id_course = importVar('id_course');
$man_course = new Man_Course();
$course = $man_course->getCourseInfo($id_course);
$profile = new LmsUserProfile($id_user);
$profile->init('profile', 'framework', 'modname=login&op=showprofile&id_course' . $id_course . '&id_user='******'ap');
$GLOBALS['page']->add(getTitleArea($lang->def('_NAME', 'catalogue'), 'catalogue') . '<div class="std_block">' . getBackUi('index.php?modname=login&op=courselist&id_parent=' . $course['idCategory'], $lang->def('_BACK')), 'content');
$GLOBALS['page']->add('<p class="category_path">' . '<b>' . $lang->def('_CATEGORY_PATH') . ' :</b> ' . $man_course->getCategoryPath($course['idCategory'], $lang->def('_MAIN_CATEGORY'), $lang->def('_TITLE_CATEGORY_JUMP'), 'index.php?modname=login&op=courselist', 'id_parent') . ' > ' . $course['name'] . '</p>' . $profile->getProfile(getLogUserId()) . '</div>', 'content');
}
function _get_delay_query($type = 'html', $report_data = NULL, $other = '')
{
if ($report_data == NULL) {
$report_data =& $_SESSION['report_tempdata'];
}
$rdata =& $report_data['rows_filter'];
$cdata =& $report_data['columns_filter'];
$acl_man = new DoceboACLManager();
$acl_man->include_suspended = TRUE;
$course_man = new Man_Course();
$alluser = $rdata['all_users'];
$jump_url = '';
$org_chart_subdivision = isset($cdata['org_chart_subdivision']) ? $cdata['org_chart_subdivision'] : false;
$day_from_subscription = $cdata['day_from_subscription'] != "" ? $cdata['day_from_subscription'] : false;
$day_until_course_end = $cdata['day_until_course_end'] != "" ? $cdata['day_until_course_end'] : false;
$date_until_course_end = $cdata['date_until_course_end'] != "" ? $cdata['date_until_course_end'] : false;
$report_type_completed = isset($cdata['report_type_completed']) ? $cdata['report_type_completed'] : false;
$report_type_started = isset($cdata['report_type_started']) ? $cdata['report_type_started'] : false;
$course_selected = $cdata['selected_courses'];
$all_courses = $cdata['all_courses'];
$order_by = isset($cdata['order_by']) ? $cdata['order_by'] : 'userid';
$order_dir = isset($cdata['order_dir']) ? $cdata['order_dir'] : 'asc';
$show_suspended = isset($cdata['show_suspended']) ? (bool) $cdata['show_suspended'] : false;
if (!$alluser) {
$user_selected =& $acl_man->getAllUsersFromIdst($rdata['users']);
} else {
$user_selected =& $acl_man->getAllUsersIdst();
}
$lang =& DoceboLanguage::createInstance('report', 'framework');
$lang_u =& DoceboLanguage::CreateInstance('stats', 'lms');
if (empty($user_selected)) {
return $lang->def('_NULL_SELECTION');
}
if (empty($course_selected) && !$all_courses) {
return $lang->def('_NULL_COURSE_SELECTION');
}
if (1 == 1) {
$date_now = Format::date(date("Y-m-d H:i:s"));
//set query suspended users condition
$query_show_suspended = "u.valid = 1";
//default condition
switch ($show_suspended) {
case "all":
$query_show_suspended = "";
break;
case "suspended_only":
$query_show_suspended = " AND u.valid = 0 ";
break;
case "active_only":
$query_show_suspended = " AND u.valid = 1 ";
break;
}
//set query order by param
$_dir = "ASC";
switch ($order_dir) {
case "desc":
$_dir = "DESC";
break;
}
$query_order_by = "u.lastname, u.firstname, u.userid";
switch ($order_by) {
case 'firstname':
$query_order_by = "u.firstname " . $_dir . ", u.userid " . $_dir;
break;
case 'lastname':
$query_order_by = "u.lastname " . $_dir . ", u.userid " . $_dir;
break;
case 'email':
$query_order_by = "u.email " . $_dir . ", u.userid " . $_dir;
break;
case 'status':
$query_order_by = "cu.status " . $_dir . ", u.userid " . $_dir . ", u.lastname " . $_dir;
break;
//case 'level': $query_order_by = "cu.level ".$_dir.", u.userid ".$_dir.", c.code ".$_dir.""; break;
//case 'level': $query_order_by = "cu.level ".$_dir.", u.userid ".$_dir.", c.code ".$_dir.""; break;
case 'date_subscription':
$query_order_by = "cu.date_inscr " . $_dir . ", u.userid " . $_dir . ", u.lastname " . $_dir;
break;
case 'date_first_access':
$query_order_by = "cu.date_first_access " . $_dir . ", u.userid " . $_dir . ", u.lastname " . $_dir;
break;
case 'date_last_access':
$query_order_by = "cu.date_last_access " . $_dir . ", u.userid " . $_dir . ", u.lastname " . $_dir;
break;
case 'date_complete':
$query_order_by = "cu.date_complete " . $_dir . ", u.userid " . $_dir . ", u.lastname " . $_dir;
break;
}
$query_course_user = "******" . $GLOBALS['prefix_lms'] . "_courseuser AS cu " . " JOIN " . $GLOBALS['prefix_fw'] . "_user as u ON cu.idUser = u.idst\r\n\t\t\t\tWHERE cu.idCourse > 0 " . $query_show_suspended . ($alluser ? "" : " AND cu.idUser IN ( " . implode(',', $user_selected) . " ) ") . ($all_courses ? '' : " AND cu.idCourse IN (" . implode(',', $course_selected) . ")") . " ORDER BY " . $query_order_by;
$re_course_user = sql_query($query_course_user);
$element_to_print = array();
$courses_codes = array();
while (list($id_u, $id_c, $id_e, $date_inscr, $date_first_access, $date_complete, $status, $level, $date_last_access, $u_userid, $u_firstname, $u_lastname, $u_email, $u_valid) = sql_fetch_row($re_course_user)) {
if ($level == '3') {
//$report_type === 'course_started' && $level == '3') {
$user_check = false;
$now_timestamp = mktime('0', '0', '0', date('m'), date('d'), date('Y'));
//check the condition on status (course started and/or completed)
$status_condition = $status != _CUS_END;
//&& $status != _CUS_SUSPEND;
if ($report_type_completed && !$report_type_started) {
$status_condition = $status_condition && $status == _CUS_BEGIN;
}
if ($report_type_started && !$report_type_completed) {
$status_condition = $status_condition && $status != _CUS_BEGIN;
}
if ($day_from_subscription) {
if ($status_condition) {
$user_timestamp = mktime('0', '0', '0', $date_inscr[5] . $date_inscr[6], $date_inscr[8] . $date_inscr[9] + $day_from_subscription, $date_inscr[0] . $date_inscr[1] . $date_inscr[2] . $date_inscr[3]);
if ($user_timestamp < $now_timestamp) {
$user_check = true;
}
}
}
if ($day_until_course_end) {
if ($status_condition) {
if ($id_e > 0) {
$query = "SELECT date_end" . " FROM " . $GLOBALS['prefix_lms'] . "_course_edition" . " WHERE idCourseEdition = '" . $id_e . "'";
list($date_end) = sql_fetch_row(sql_query($query));
$user_timestamp = mktime('0', '0', '0', $date_end[5] . $date_end[6], $date_end[8] . $date_end[9] - $day_until_course_end, $date_end[0] . $date_end[1] . $date_end[2] . $date_end[3]);
if ($user_timestamp < $now_timestamp) {
$user_check = true;
}
} else {
$query = "SELECT date_end" . " FROM " . $GLOBALS['prefix_lms'] . "_course" . " WHERE idCourse = '" . $id_c . "'";
list($date_end) = sql_fetch_row(sql_query($query));
$user_timestamp = mktime('0', '0', '0', $date_end[5] . $date_end[6], $date_end[8] . $date_end[9] - $day_until_course_end, $date_end[0] . $date_end[1] . $date_end[2] . $date_end[3]);
if ($user_timestamp < $now_timestamp) {
$user_check = true;
}
}
}
}
if ($date_until_course_end) {
if ($status_condition) {
if ($id_e > 0) {
$query = "SELECT COUNT(*)" . " FROM " . $GLOBALS['prefix_lms'] . "_course_edition" . " WHERE idCourseEdition = '" . $id_e . "'" . " AND date_end < '" . Format::dateDb($date_until_course_end, 'date') . "'";
list($control) = sql_fetch_row(sql_query($query));
if ($control) {
$user_check = true;
}
} else {
$query = "SELECT COUNT(*)" . " FROM " . $GLOBALS['prefix_lms'] . "_course" . " WHERE idCourse = '" . $id_c . "'" . " AND date_end < '" . Format::dateDb($date_until_course_end, 'date') . "'";
list($control) = sql_fetch_row(sql_query($query));
if ($control) {
$user_check = true;
}
}
}
}
if (!$date_until_course_end && !$day_from_subscription && !$date_until_course_end) {
if ($status_condition) {
$user_check = true;
}
}
if ($user_check) {
$course_info = $course_man->getCourseInfo($id_c);
//$user_detail = $acl_man->getUser($id_u, false);
$element_to_print[$id_c]['name'] = $course_info['name'];
$element_to_print[$id_c]['code'] = $course_info['code'];
$element_to_print[$id_c]['data'][] = array('idUser' => $id_u, 'idCourse' => $id_c, 'idCourseEdition' => $id_e, 'status' => $status, 'level' => $level, 'userid' => Docebo::aclm()->relativeId($u_userid), 'firstname' => $u_firstname, 'lastname' => $u_lastname, 'mail' => $u_email, 'suspended' => $u_valid <= 0, 'date_subscription' => $date_inscr, 'date_first_access' => $date_first_access, 'date_completed' => $date_complete, 'date_last_access' => $date_last_access);
}
}
}
//backward compatibility
$showed_columns = array();
foreach ($cdata['showed_columns'] as $_column_key) {
$showed_columns[] = $this->_check_delay_column($_column_key);
}
//print course table
$this->_printTable_delay($type, $element_to_print, $showed_columns);
if ($this->use_mail) {
$this->_loadEmailActions();
}
}
}
function modAssignmentAssignMetaCertificate()
{
checkPerm('mod');
require_once _base_ . '/lib/lib.form.php';
require_once $GLOBALS['where_framework'] . '/lib/lib.directory.php';
require_once _base_ . '/lib/lib.userselector.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.course.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.course_managment.php';
$lang =& DoceboLanguage::createInstance('certificate', 'lms');
$id_certificate = importVar('id_certificate', true, 0);
$id_meta = Get::req('idmeta', DOTY_INT, 0);
$step = Get::req('step', DOTY_INT, 0);
$out =& $GLOBALS['page'];
$out->setWorkingZone('content');
$acl_man =& Docebo::user()->getAclManager();
$aclManager = new DoceboACLManager();
$user_select = new UserSelector();
$form = new Form();
$sel = new Course_Manager();
$course_man = new Man_Course();
if (isset($_POST['okselector'])) {
$user_selected = $user_select->getSelection($_POST);
$_SESSION['meta_certificate']['users'] = $user_selected;
$step++;
}
if (isset($_POST['import_filter'])) {
$_SESSION['meta_certificate']['course'] = $sel->getCourseSelection($_POST);
$step++;
}
if (isset($_POST['insert'])) {
$step++;
}
if ($step == 3) {
$array_user =& $aclManager->getAllUsersFromIdst($_SESSION['meta_certificate']['users']);
$array_user = array_unique($array_user);
$res = true;
$user_reset = array();
$course_reset = array();
$reasign = array();
//array reasign
$query = "SELECT idUser, idCourse" . " FROM " . $GLOBALS['prefix_lms'] . "_certificate_meta_course" . " WHERE idMetaCertificate = '" . $id_meta . "'";
$result = sql_query($query);
while (list($id_user, $id_course) = sql_fetch_row($result)) {
$reasign[$id_user][$id_course] = 1;
}
//array user_reset
$query = "SELECT DISTINCT idUser" . " FROM " . $GLOBALS['prefix_lms'] . "_certificate_meta_course" . " WHERE idMetaCertificate = '" . $id_meta . "'";
$result = sql_query($query);
while (list($id_user) = sql_fetch_row($result)) {
$user_reset[$id_user] = $id_user;
}
//array course_reset
$query = "SELECT DISTINCT idCourse" . " FROM " . $GLOBALS['prefix_lms'] . "_certificate_meta_course" . " WHERE idMetaCertificate = '" . $id_meta . "'";
$result = sql_query($query);
while (list($id_course) = sql_fetch_row($result)) {
$course_reset[$id_course] = $id_course;
}
//finish array initialization
$query_course = "INSERT INTO " . $GLOBALS['prefix_lms'] . "_certificate_meta_course (idMetaCertificate, idUser, idCourse)" . " VALUES ";
$first = true;
$array_user_flipped = array_flip($array_user);
foreach ($user_reset as $id_user) {
if (!isset($array_user_flipped[$id_user])) {
$query = "DELETE FROM " . $GLOBALS['prefix_lms'] . "_certificate_meta_course" . " WHERE idUser = '******'" . " AND idMetaCertificate = '" . $id_meta . "'";
if (!sql_query($query)) {
$res = false;
}
}
}
if (!$res) {
Util::jump_to('index.php?modname=meta_certificate&op=assign&id_certificate=' . $id_certificate . '&res=error_mod_assign');
}
foreach ($course_reset as $id_course) {
if (!isset($_SESSION['meta_certificate']['course'][$id_course])) {
$query = "DELETE FROM " . $GLOBALS['prefix_lms'] . "_certificate_meta_course" . " WHERE idCourse = '" . $id_course . "'" . " AND idMetaCertificate = '" . $id_meta . "'";
if (!sql_query($query)) {
$res = false;
}
}
}
if (!$res) {
Util::jump_to('index.php?modname=meta_certificate&op=assign&id_certificate=' . $id_certificate . '&res=error_mod_assign');
}
reset($_SESSION['meta_certificate']['course']);
foreach ($array_user as $id_user) {
foreach ($_SESSION['meta_certificate']['course'] as $id_course) {
if (isset($_POST['_' . $id_user . '_' . $id_course . '_'])) {
if (!isset($reasign[$id_user][$id_course])) {
if ($first) {
$query_course .= "('" . $id_meta . "', '" . $id_user . "', '" . $id_course . "')";
$first = false;
} else {
$query_course .= ", ('" . $id_meta . "', '" . $id_user . "', '" . $id_course . "')";
}
}
} else {
if (isset($reasign[$id_user][$id_course])) {
$query = "DELETE FROM " . $GLOBALS['prefix_lms'] . "_certificate_meta_course" . " WHERE idUser = '******'" . " AND idCourse = '" . $id_course . "'" . " AND idMetaCertificate = '" . $id_meta . "'";
if (!sql_query($query)) {
$res = false;
}
}
}
}
}
if (!$res) {
Util::jump_to('index.php?modname=meta_certificate&op=assign&id_certificate=' . $id_certificate . '&res=error_mod_assign');
}
$res = sql_query($query_course);
if ($res) {
Util::jump_to('index.php?modname=meta_certificate&op=assign&id_certificate=' . $id_certificate . '&res=ok');
} else {
Util::jump_to('index.php?modname=meta_certificate&op=assign&id_certificate=' . $id_certificate . '&res=error_mod_assign');
}
} elseif ($step == 2) {
YuiLib::load();
Util::get_js(Get::rel_path('base') . '/lib/js_utils.js', true, true);
$tb = new Table(0, $lang->def('_META_CERTIFICATE_NEW_ASSIGN_CAPTION'), $lang->def('_META_CERTIFICATE_NEW_ASSIGN_SUMMARY'));
$tb->setLink('index.php?modname=meta_certificate&op=modassignment');
$out->add(getTitleArea($lang->def('_TITLE_META_CERTIFICATE_ASSIGN'), 'certificate') . '<div class="std_block">' . $form->openForm('new_assign_step_2', 'index.php?modname=meta_certificate&op=modassignment') . $form->getHidden('id_certificate', 'id_certificate', $id_certificate) . $form->getHidden('idmeta', 'idmeta', $id_meta) . $form->getHidden('step', 'step', 2) . $form->getHidden('reasign', 'reasign', 1));
$reasign = array();
if (!isset($_POST['reasign'])) {
$query = "SELECT idUser, idCourse" . " FROM " . $GLOBALS['prefix_lms'] . "_certificate_meta_course" . " WHERE idMetaCertificate = '" . $id_meta . "'";
$result = sql_query($query);
while (list($id_user, $id_course) = sql_fetch_row($result)) {
$reasign[$id_user][$id_course] = 1;
}
}
$form_name = 'new_assign_step_2';
$type_h = array('', '');
$cont_h = array($lang->def('_FULLNAME'), $lang->def('_USERNAME'));
foreach ($_SESSION['meta_certificate']['course'] as $id_course) {
$type_h[] = 'align_center';
$course_info = $course_man->getCourseInfo($id_course);
$cont_h[] = $course_info['code'] . ' - ' . $course_info['name'];
}
$type_h[] = 'image';
$cont_h[] = $lang->def('_CHECKALL');
$type_h[] = 'image';
$cont_h[] = $lang->def('_UNCHECKALL');
$tb->setColsStyle($type_h);
$tb->addHead($cont_h);
reset($_SESSION['meta_certificate']['course']);
$array_user =& $aclManager->getAllUsersFromIdst($_SESSION['meta_certificate']['users']);
$array_user = array_unique($array_user);
$query = "SELECT idst" . " FROM " . $GLOBALS['prefix_fw'] . "_user" . " WHERE idst IN (" . implode(',', $array_user) . ")" . " ORDER BY userid";
$result = sql_query($query);
$array_user = array();
while (list($id_user) = sql_fetch_row($result)) {
$array_user[] = $id_user;
}
foreach ($array_user as $id_user) {
$cont = array();
$user_info = $acl_man->getUser($id_user, false);
$cont[] = $user_info[ACL_INFO_LASTNAME] . ' ' . $user_info[ACL_INFO_FIRSTNAME];
$cont[] = $acl_man->relativeId($user_info[ACL_INFO_USERID]);
foreach ($_SESSION['meta_certificate']['course'] as $id_course) {
if (isset($_POST['_' . $id_user . '_' . $id_course . '_']) || isset($_POST['select_all']) || isset($reasign[$id_user][$id_course])) {
$checked = true;
} else {
$checked = false;
}
$cont[] = $form->getCheckbox('', '_' . $id_user . '_' . $id_course . '_', '_' . $id_user . '_' . $id_course . '_', 1, $checked);
}
$cont[] = '<a href="javascript:;" onclick="checkall_fromback_meta(\'' . $form_name . '\', \'' . $id_user . '\', true); return false;">' . $lang->def('_CHECKALL') . '</a>';
$cont[] = '<a href="javascript:;" onclick="checkall_fromback_meta(\'' . $form_name . '\', \'' . $id_user . '\', false); return false;">' . $lang->def('_UNCHECKALL') . '</a>';
$tb->addBody($cont);
}
reset($_SESSION['meta_certificate']['course']);
$cont = array();
$cont[] = '';
$cont[] = '';
foreach ($_SESSION['meta_certificate']['course'] as $id_course) {
$cont[] = '<a href="javascript:;" onclick="checkall_meta(\'' . $form_name . '\', \'' . $id_course . '\', true); return false;">' . $lang->def('_CHECKALL') . '</a><br/>' . '<a href="javascript:;" onclick="checkall_meta(\'' . $form_name . '\', \'' . $id_course . '\', false); return false;">' . $lang->def('_UNCHECKALL') . '</a>';
}
$cont[] = '';
$cont[] = '';
$tb->addBody($cont);
$out->add($form->openElementSpace() . $tb->getTable() . $form->closeElementSpace() . $form->openButtonSpace() . $form->getButton('select_all', 'select_all', $lang->def('_SELECT_ALL')) . $form->getButton('insert', 'insert', $lang->def('_INSERT')) . $form->getButton('undo_assign', 'undo_assign', $lang->def('_UNDO')) . $form->closeButtonSpace() . $form->closeForm());
} elseif ($step == 1) {
$sel->setLink('index.php?modname=meta_certificate&op=modassignment');
$out->add(getTitleArea($lang->def('_TITLE_META_CERTIFICATE_ASSIGN'), 'certificate') . '<div class="std_block">' . $form->openForm('new_assign_step_1', 'index.php?modname=meta_certificate&op=modassignment') . $form->getHidden('id_certificate', 'id_certificate', $id_certificate) . $form->getHidden('idmeta', 'idmeta', $id_meta) . $form->getHidden('step', 'step', 1) . $form->getHidden('course_reload', 'course_reload', 1));
if (!isset($_POST['course_reload'])) {
$query = "SELECT DISTINCT idCourse" . " FROM " . $GLOBALS['prefix_lms'] . "_certificate_meta_course" . " WHERE idMetaCertificate = '" . $id_meta . "'";
$result = sql_query($query);
$course_reset = array();
while (list($id_course) = sql_fetch_row($result)) {
$course_reset[$id_course] = $id_course;
}
$sel->resetCourseSelection($course_reset);
}
$sel->loadSelector();
$out->add(Form::getHidden('update_tempdata', 'update_tempdata', 1) . Form::openButtonSpace() . Form::getBreakRow() . Form::getButton('ok_filter', 'import_filter', $lang->def('_NEXT')) . Form::getButton('undo_filter', 'undo_filter', $lang->def('_UNDO')) . Form::closeButtonSpace() . Form::closeForm() . '</div>');
} else {
$user_select->show_orgchart_simple_selector = FALSE;
$user_select->multi_choice = TRUE;
$user_select->addFormInfo($form->getHidden('step', 'step', 0) . $form->getHidden('id_certificate', 'id_certificate', $id_certificate) . $form->getHidden('idmeta', 'idmeta', $id_meta) . $form->getHidden('user_reload', 'user_reload', 1));
$user_select->setPageTitle(getTitleArea($lang->def('_TITLE_META_CERTIFICATE_ASSIGN'), 'certificate') . '<div class="std_block">');
if (!isset($_POST['user_reload'])) {
$query = "SELECT DISTINCT idUser" . " FROM " . $GLOBALS['prefix_lms'] . "_certificate_meta_course" . " WHERE idMetaCertificate = '" . $id_meta . "'";
$result = sql_query($query);
$user_reset = array();
while (list($id_user) = sql_fetch_row($result)) {
$user_reset[$id_user] = $id_user;
}
$user_select->resetSelection($user_reset);
}
$user_select->loadSelector('index.php?modname=meta_certificate&op=modassignment', false, $lang->def('_USER_FOR_META_CERTIFICATE_ASSIGN'), true);
}
}
function report_certificate()
{
require_once _base_ . '/lib/lib.form.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.certificate.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.course.php';
require_once _base_ . '/lib/lib.table.php';
checkPerm('view');
$out =& $GLOBALS['page'];
$out->setWorkingZone('content');
$form = new Form();
$certificate = new Certificate();
$lang =& DoceboLanguage::createInstance('certificate', 'lms');
if (isset($_GET['id_certificate'])) {
$id_certificate = importVar('id_certificate', true, 0);
$man_course = new Man_Course();
$id_course = array();
$id_course = $certificate->getCourseForCertificate($id_certificate);
$course_info = array();
$out->add(getTitleArea(array('index.php?modname=certificate&op=certificate' => $lang->def('_TITLE_CERTIFICATE'), $lang->def('_COURSES'))) . '<div class="std_block">' . getBackUi('index.php?modname=certificate&op=certificate', $lang->def('_BACK')));
$tb = new Table(Get::sett('visuItem'), $lang->def('_CHOOSE_COURSE'), $lang->def('_COURSE_LIST'));
$type_h = array('', '', 'min-cell');
$cont_h = array($lang->def('_CODE'), $lang->def('_NAME'), $lang->def('_CERTIFICATE_REPORT'));
$tb->setColsStyle($type_h);
$tb->addHead($cont_h);
foreach ($id_course as $course_id) {
$course_info = $man_course->getCourseInfo($course_id);
$cont = array($course_info['code'], '<a href="index.php?modname=certificate&op=view_report_certificate&id_certificate=' . $id_certificate . '&id_course=' . $course_id . '">' . $course_info['name'] . '</a>', $certificate->getNumberOfCertificateForCourse($id_certificate, $course_info['idCourse']));
$tb->addBody($cont);
}
$out->add($tb->getTable() . '<br/>' . getBackUi('index.php?modname=certificate&op=certificate', $lang->def('_BACK')) . '</div>');
} else {
$out->add(getTitleArea($lang->def('_CERTIFICATE_REPORT'), 'certificate') . '<div class="std_block">');
if (isset($_POST['toggle_filter'])) {
unset($_POST['name_filter']);
unset($_POST['code_filter']);
}
$out->add($form->openForm('certificate_filter', 'index.php?modname=certificate&op=report_certificate') . $form->openElementSpace() . $form->getTextfield($lang->def('_NAME'), 'name_filter', 'name_filter', '255', isset($_POST['name_filter']) && $_POST['name_filter'] !== '' ? $_POST['name_filter'] : '') . $form->getTextfield($lang->def('_CODE'), 'code_filter', 'code_filter', '255', isset($_POST['code_filter']) && $_POST['code_filter'] !== '' ? $_POST['code_filter'] : '') . $form->closeElementSpace() . $form->openButtonSpace() . $form->getButton('filter', 'filter', $lang->def('_FILTER')) . $form->getButton('toggle_filter', 'toggle_filter', $lang->def('_TOGGLE_FILTER')) . $form->closeButtonSpace() . $form->closeForm());
if (isset($_POST['filter'])) {
if ($_POST['name_filter'] !== '' && $_POST['code_filter'] !== '') {
$certificate_info = $certificate->getCertificateList($_POST['name_filter'], $_POST['code_filter']);
} elseif ($_POST['name_filter'] !== '') {
$certificate_info = $certificate->getCertificateList($_POST['name_filter']);
} elseif ($_POST['code_filter'] !== '') {
$certificate_info = $certificate->getCertificateList(false, $_POST['code_filter']);
} else {
$certificate_info = $certificate->getCertificateList();
}
} else {
$certificate_info = $certificate->getCertificateList();
}
$tb = new Table(Get::sett('visuItem'), $lang->def('_CHOOSE_CERTIFICATE'), $lang->def('_CERTIFICATE_LIST'));
$type_h = array('', '');
$cont_h = array($lang->def('_CODE'), $lang->def('_NAME'), $lang->def('_DESCRIPTION'));
$tb->setColsStyle($type_h);
$tb->addHead($cont_h);
foreach ($certificate_info as $info_certificate) {
$cont = array($info_certificate[CERT_CODE], '<a href="index.php?modname=certificate&op=report_certificate&id_certificate=' . $info_certificate[CERT_ID] . '">' . $info_certificate[CERT_NAME] . '</a>', $info_certificate[CERT_DESCR]);
$tb->addBody($cont);
}
$out->add($tb->getTable() . '</div>');
}
}
function subscribeFromCourse()
{
require_once _base_ . '/lib/lib.form.php';
require_once $GLOBALS['where_framework'] . '/lib/lib.directory.php';
require_once _base_ . '/lib/lib.userselector.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.course.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.course_managment.php';
$lang =& DoceboLanguage::CreateInstance('subscribe', 'lms');
$back_url = 'index.php?modname=course&op=course_list';
$acl_man =& Docebo::user()->getAclManager();
$out =& $GLOBALS['page'];
$out->setWorkingZone('content');
$id_course = Get::req('id_course', DOTY_INT, 0);
$edition_id = Get::req('edition_id', DOTY_INT, 0);
$alert = Get::req('alert', DOTY_INT, 0);
$delete_prev = Get::req('delete_from_prev', DOTY_INT, 0);
$sel = new Course_Manager();
if (isset($_POST['subscribe_import'])) {
$course_info = Man_Course::getCourseInfo($id_course);
$level_idst =& getCourseLevel($id_course);
if (count($level_idst) == 0) {
$level_idst =& DoceboCourse::createCourseLevel($id_course);
}
$course_selected = $sel->getCourseSelection($_POST);
if (empty($course_selected)) {
Util::jump_to('index.php?modname=course&op=course_list&result=err');
}
$id_course = Get::req('id_course', DOTY_INT, 0);
$level = Get::req('level', DOTY_INT, 0);
$status = Get::req('status', DOTY_INT, 0);
$gsel = array();
foreach ($course_selected as $trash => $id) {
$gsel[$id] = getCourseLevel($id);
}
$query = "SELECT idUser, idCourse, level" . " FROM " . $GLOBALS['prefix_lms'] . "_courseuser" . " WHERE idCourse IN (" . implode(',', $course_selected) . ")";
if ($level) {
$query .= " AND level = '" . $level . "'";
}
if ($status != '-2') {
$query .= " AND status = '" . $status . "'";
}
$result = sql_query($query);
$array_user = array();
$user_subscribed = array();
while (list($id_user, $id_prev_course, $lv_sel) = sql_fetch_row($result)) {
if ($delete_prev) {
removeSubscription($id_prev_course, $id_user, $gsel[$id_prev_course][$lv_sel]);
}
// Add in group for permission
$acl_man->addToGroup($level_idst[$lv_sel], $id_user);
// Add in table
$re = sql_query("\r\n\t\t\tINSERT INTO " . $GLOBALS['prefix_lms'] . "_courseuser\r\n\t\t\t( idUser, idCourse, edition_id, level, waiting, subscribed_by, date_inscr )\r\n\t\t\tVALUES\r\n\t\t\t( '" . $id_user . "', '" . $id_course . "', '" . $edition_id . "', '" . $lv_sel . "', '0', '" . getLogUserId() . "', '" . date("Y-m-d H:i:s") . "' )\t");
if ($re) {
$user_subscribed[] = $id_user;
addUserToTimeTable($id_user, $id_course, $edition_id);
}
}
Docebo::user()->loadUserSectionST('/lms/course/private/');
Docebo::user()->SaveInSession();
require_once _base_ . '/lib/lib.eventmanager.php';
$array_subst = array('[url]' => Get::sett('url'), '[course]' => $course_info['name'], '[medium_time]' => $course_info['mediumTime'], '[course_name]' => $course_info['name'], '[course_code]' => $course['code']);
if (!empty($user_subscribed) && $alert) {
// message to user that is subscribed
$msg_composer = new EventMessageComposer();
$msg_composer->setSubjectLangText('email', '_NEW_USER_SUBSCRIBED_SUBJECT', false);
$msg_composer->setBodyLangText('email', '_NEW_USER_SUBSCRIBED_TEXT', $array_subst);
$msg_composer->setBodyLangText('sms', '_NEW_USER_SUBSCRIBED_TEXT_SMS', $array_subst);
// send message to the user subscribed
createNewAlert('UserCourseInserted', 'subscribe', 'insert', '1', 'User subscribed', $user_subscribed, $msg_composer);
}
Util::jump_to('index.php?modname=course&op=course_list&result=ok');
}
$sel->setLink('index.php?modname=meta_certificate&op=new_assign');
$sel->show_coursepath_selector = false;
$sel->show_catalogue_selector = false;
$array_level = CourseLevel::getLevels();
$array_level['0'] = $lang->def('_ALL');
$arr_status = array('-2' => $lang->def('_ALL'), _CUS_CONFIRMED => $lang->def('_USER_STATUS_CONFIRMED'), _CUS_SUBSCRIBED => $lang->def('_USER_STATUS_SUBS'), _CUS_BEGIN => $lang->def('_USER_STATUS_BEGIN'), _CUS_END => $lang->def('_USER_STATUS_END'), _CUS_SUSPEND => $lang->def('_SUSPENDED'), _CUS_CANCELLED => $lang->def('_USER_STATUS_CANCELLED'));
$out->add(getTitleArea($lang->def('_IMPORT_FROM_COURSE')) . '<div class="std_block">' . Form::openForm('course_selection', 'index.php?modname=subscribe&op=subscribe_from_course') . Form::openElementSpace() . Form::getDropdown($lang->def('_LEVEL_TO_IMPORT'), 'level', 'level', $array_level, isset($_POST['level']) ? $_POST['level'] : '0') . Form::getDropdown($lang->def('_STATUS_TO_IMPORT'), 'status', 'status', $arr_status, isset($_POST['status']) ? $_POST['status'] : '-2') . Form::getCheckbox($lang->def('_SEND_ALERT'), 'alert', 'alert', '1', $delete_prev) . Form::getCheckbox($lang->def('_DELETE'), 'delete_from_prev', 'delete_from_prev', '1', $delete_prev) . Form::closeElementSpace());
$sel->loadSelector(false);
$out->add(Form::getHidden('id_course', 'id_course', $id_course) . Form::getHidden('edition_id', 'edition_id', $edition_id) . Form::openButtonSpace() . Form::getBreakRow() . Form::getButton('subscribe_import', 'subscribe_import', $lang->def('_SUBSCRIBE')) . Form::getButton('undo_course', 'undo_course', $lang->def('_UNDO')) . Form::closeButtonSpace() . Form::closeForm() . '</div>');
}
public function delDate($id_date)
{
$res = false;
$id_course = $this->getDateCourse($id_date);
$subscribed = $this->getDateSubscribed($id_date);
foreach ($subscribed as $id_user) {
$control = $this->removeUserFromDate($id_user, $id_date, $id_course);
if (!$control) {
require_once _lms_ . '/admin/modules/subscribe/subscribe.php';
require_once _lms_ . '/lib/lib.course.php';
$docebo_course = new DoceboCourse($id_course);
$course_man = new Man_Course();
$course_info = $course_man->getCourseInfo($id_course);
$date_begin = $course_info["date_begin"];
$date_end = $course_info["date_end"];
$group_levels = $docebo_course->getCourseLevel($id_course);
$user_levels = getSubscribedLevel($id_course, false, false, 0);
removeSubscription($id_course, $id_user, $group_levels[$user_levels[$id_user]], 0, $date_begin, $date_end);
}
}
if ($this->clearDateDay($id_date)) {
$query = "DELETE FROM " . $this->date_table . " WHERE id_date = " . $id_date;
$res = sql_query($query);
}
return $res;
}
function savePanel()
{
checkPerm('mod');
require_once _base_ . '/lib/lib.form.php';
require_once _adm_ . '/lib/lib.publicadminmanager.php';
require_once _lms_ . '/lib/lib.course.php';
require_once _lms_ . '/lib/lib.date.php';
require_once _lms_ . '/lib/lib.competences.php';
$save = Get::req('save', DOTY_MIXED, false);
$undo = Get::req('undo', DOTY_MIXED, false);
$update = Get::req('update', DOTY_MIXED, false);
$db = DbConn::getInstance();
$lang =& DoceboLanguage::CreateInstance('public_coursepanel', 'lms');
$man_competences = new Competences_Manager();
//back page link
$back_ui = getBackUi('index.php?modname=public_coursepanel&op=coursepanel', $lang->def('_BACK'));
cout(getTitleArea($lang->def('_COURSEPANEL'), 'coursepanel') . '<div class="std_block">' . $back_ui, 'content');
$sel_competence = Get::req('sel_competence', DOTY_INT, false);
$sel_course = Get::req('sel_course', DOTY_INT, false);
$required_filter = Get::req('required_filter', DOTY_INT, 0);
$is_retraining = $man_competences->isRetrainingCourse($sel_course, $sel_competence);
$back_url = "index.php?modname=public_coursepanel&op=coursepanel&sel_competence=" . (int) $sel_competence . "&sel_course=" . (int) $sel_course;
if ($required_filter > 0) {
$back_url .= '&required_filter=1';
}
$to_consider = Get::req('to_consider', DOTY_MIXED, false);
if ($to_consider) {
require_once _base_ . '/lib/lib.json.php';
$json = new Services_JSON(SERVICES_JSON_LOOSE_TYPE);
$to_consider = $json->decode(base64_decode($to_consider));
} else {
$to_consider = array('users' => array(), 'editions' => array());
}
if ($undo) {
Util::jump_to("index.php");
} elseif ($save) {
//change users' subscription to course editions
$data = Get::req('subscriptions', DOTY_MIXED, array());
$man_course = new Man_Course();
$course_info = $man_course->getCourseInfo($sel_course);
if (!$sel_competence || !$sel_course) {
//error ...
Util::jump_to($back_url . "&err=invalid");
}
//check the admin level of the current user, if it's not an admin or the idst is invalid, return an error
$id_pa = getLogUserId();
if (!$id_pa) {
Util::jump_to($back_url . "&err=invalid");
}
$acl_man = new DoceboACLManager();
$admin_manager = new PublicAdminManager();
$array_users = array();
$idst_associated = $admin_manager->getAdminTree($id_pa);
$array_users =& $acl_man->getAllUsersFromIdst($idst_associated);
$array_users = array_unique($array_users);
if (empty($array_users)) {
Util::jump_to($back_url . "&err=invalid");
}
//filter array of user ids by competence
$filtered_users = array();
$query_filter = "SELECT id_user FROM %lms_competence_user WHERE id_user IN (" . implode(",", $array_users) . ") AND id_competence='" . (int) $sel_competence . "'";
$res_filter = $db->query($query_filter);
while (list($idst) = $db->fetch_row($res_filter)) {
$filtered_users[] = $idst;
}
$subs_limit = array();
$subs_count = array();
if ($course_info['course_type'] == 'elearning') {
$editions[] = $sel_course;
$subscribed[$sel_course] = getSubscribed((int) $sel_course);
$course_info = $man_course->getCourseInfo($sel_course);
$subs_count[$sel_course] = count($data);
} elseif ($course_info['course_type'] == 'classroom') {
//get all combinations id_user - id_date
$date_man = new DateManager();
$editions = array();
$query_editions = "SELECT id_date, id_course, code, name FROM %lms_course_date WHERE id_course='" . (int) $sel_course . "'";
$res_editions = $db->query($query_editions);
while (list($id_edition, $id_course, $code, $name) = $db->fetch_row($res_editions)) {
$editions[] = $id_edition;
$subscribed[$id_edition] = $date_man->getDateSubscribed($id_edition);
$date_info = $date_man->getDateInfo($id_edition);
$subs_limit[$id_edition] = array('max' => $date_info['max_par'], 'subs' => $date_info['user_subscribed']);
$subs_count[$id_edition] = 0;
}
}
//------------------------------------------------------------------------------
//count the users to be subscribed/unsubscribed and check subscription limits, if any
//subtract users to de-subscribe from courses
foreach ($subscribed as $id_edition => $users_list) {
foreach ($users_list as $id_user) {
if ($course_info['course_type'] == 'elearning') {
if (!isset($data[$id_user])) {
$subs_count[$id_edition]--;
}
} elseif ($course_info['course_type'] == 'classroom') {
//check if the current selection match the current subscriptions
if (!isset($data[$id_user][$id_edition])) {
$subs_count[$id_edition]--;
}
}
}
}
foreach ($data as $user => $edition_list) {
//id user
foreach ($edition_list as $edition => $val) {
//id date edition
if (isset($subscribed[$edition][$user])) {
//already subscribed, do nothing
} else {
$subs_count[$edition]++;
}
}
}
//check if we have enough room to subscribe users
//{at the moment, rely on js ...}
//------------------------------------------------------------------------------
//unsubscribe deselected users
foreach ($subscribed as $id_edition => $users_list) {
foreach ($users_list as $id_user) {
if ($course_info['course_type'] == 'elearning') {
if (!isset($data[$id_user])) {
if (in_array($id_user, $to_consider['users']) && in_array($id_edition, $to_consider['editions'])) {
$group_levels = DoceboCourse::getCourseLevel($sel_course);
$user_levels = getSubscribedLevel($sel_course, false, false, 0);
$_res = _removeCourseSubscription($sel_course, $id_user, $group_levels[$user_levels[$id_user]], 0);
}
}
} elseif ($course_info['course_type'] == 'classroom') {
//check if the current selection match the current subscriptions
if (!isset($data[$id_user][$id_edition])) {
if (in_array($id_user, $to_consider['users']) && in_array($id_edition, $to_consider['editions'])) {
$date_man->removeUserFromDate($id_user, $id_edition, $sel_course);
}
}
}
}
}
//------------------------------------------------------------------------------
//check every single user for inscription
$count = 0;
$lv_sel = 3;
//student level
$waiting = 0;
//don't subscribe as "waiting for approvation"
//retrive id of group of the course for the varioud level
$level_idst = DoceboCourse::getCourseLevel((int) $sel_course);
//if the group doesn't exists create it
if (count($level_idst) == 0 || $level_idst[1] == '') {
$level_idst =& DoceboCourse::createCourseLevel((int) $sel_course);
}
foreach ($data as $user => $edition_list) {
//id user
foreach ($edition_list as $edition => $val) {
//id date edition
if (isset($subscribed[$edition][$user])) {
//already subscribed, do nothing
} else {
//this user is to be subscribed, do it
//add to level group of the course
$acl_man->addToGroup($level_idst[$lv_sel], $user);
// Add in table
$re = $db->query("INSERT INTO %lms_courseuser (idUser, idCourse, edition_id, level, waiting, subscribed_by, date_inscr)" . " VALUES ( '" . (int) $user . "', '" . (int) $sel_course . "', '0', '" . $lv_sel . "', '" . $waiting . "', '" . getLogUserId() . "', '" . date("Y-m-d H:i:s") . "' )\t");
//additional operations for editions
if ($course_info['course_type'] == 'elearning') {
//...
} elseif ($course_info['course_type'] == 'classroom') {
$ret = $date_man->addUserToDate($edition, $user, getLogUserId());
if ($ret) {
$count++;
}
}
}
}
}
Util::jump_to($back_url . "&err=ok&count=" . (int) $count);
} elseif ($update) {
$sel_competence = Get::req('sel_competence', DOTY_INT, false);
$sel_course = Get::req('sel_course', DOTY_INT, false);
Util::jump_to($back_url);
//."&sel_competence=".(int)$sel_competence."&sel_course=".(int)$sel_course);
} else {
//...
}
cout($back_ui . '</div>', 'content');
}
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;
}
function approveusers()
{
if (!$this->permissions['moderate']) {
die("You can't access");
}
require_once _lms_ . '/lib/lib.course.php';
require_once _base_ . '/lib/lib.preference.php';
$id_course = Get::req('id_course', DOTY_INT, 0);
$course_info = Man_Course::getCourseInfo($id_course);
$edition_id = Get::req('id_edition', DOTY_INT, 0);
$re = true;
$approve_user = array();
$deny_user = array();
if (isset($_POST['waiting_user'])) {
$man_course = new Man_Course();
$waiting_users =& $man_course->getWaitingSubscribed($id_course);
$tot_deny = array();
require_once _lms_ . '/lib/lib.course.php';
require_once _lms_ . '/admin/modules/subscribe/subscribe.php';
$docebo_course = new DoceboCourse($id_course);
$group_levels = $docebo_course->getCourseLevel($id_course);
if (count($group_levels) == 0 || $group_levels[1] == '') {
$group_levels =& $docebo_course->createCourseLevel($id_course);
}
while (list($id_user, $action) = each($_POST['waiting_user'])) {
if ($action == 0) {
// approved -----------------------------------------------
$text_query = "\r\n\t\t\t\t\tUPDATE " . $GLOBALS['prefix_lms'] . "_courseuser\r\n\t\t\t\t\tSET waiting = 0,\r\n\t\t\t\t\t\tstatus = '" . _CUS_SUBSCRIBED . "'\r\n\t\t\t\t\tWHERE idCourse = '" . $id_course . "' AND idUser = '******' ";
$text_query .= "AND edition_id='" . $edition_id . "'";
$result = sql_query($text_query);
if ($result) {
$approve_user[] = $id_user;
}
$re &= $result;
} elseif ($action == 1) {
// refused --------------------------------------------------
$level = $waiting_users['users_info'][$id_user]['level'];
$sub_by = $waiting_users['users_info'][$id_user]['subscribed_by'];
$result = removeSubscription($id_course, $id_user, $group_levels[$level], $edition_id);
if ($sub_by != 0 && $id_user != $sub_by) {
if (isset($tot_deny[$sub_by])) {
$tot_deny[$sub_by]++;
} else {
$tot_deny[$sub_by] = 1;
}
}
if ($result) {
$deny_user[] = $id_user;
}
$re &= $result;
}
}
}
if (!empty($tot_deny)) {
while (list($id_user, $inc) = each($tot_deny)) {
$pref = new UserPreferences($id_user);
$max_subscribe = $pref->getAdminPreference('admin_rules.max_course_subscribe');
$pref->setPreference('admin_rules.max_course_subscribe', $max_subscribe + $inc);
}
}
require_once _base_ . '/lib/lib.eventmanager.php';
$array_subst = array('[url]' => Get::sett('url'), '[course]' => $course_info['name']);
if (!empty($approve_user)) {
$msg_composer = new EventMessageComposer();
$msg_composer->setSubjectLangText('email', '_APPROVED_SUBSCRIBED_SUBJECT', false);
$msg_composer->setBodyLangText('email', '_APPROVED_SUBSCRIBED_TEXT', $array_subst);
$msg_composer->setBodyLangText('email', "\n\n" . $_POST['subscribe_accept'], array(), true);
$msg_composer->setBodyLangText('sms', '_APPROVED_SUBSCRIBED_TEXT_SMS', $array_subst);
// send message to the user subscribed
createNewAlert('UserCourseInserted', 'subscribe', 'approve', '1', 'User course approve', $approve_user, $msg_composer, true);
}
if (!empty($deny_user)) {
$msg_composer = new EventMessageComposer();
$msg_composer->setSubjectLangText('email', '_DENY_SUBSCRIBED_SUBJECT', false);
$msg_composer->setBodyLangText('email', '_DENY_SUBSCRIBED_TEXT', $array_subst);
$msg_composer->setBodyLangText('email', "\n\n" . $_POST['subscribe_refuse'], array(), true);
$msg_composer->setSubjectLangText('sms', '_DENY_SUBSCRIBED_SUBJECT_SMS', false);
$msg_composer->setBodyLangText('sms', '_DENY_SUBSCRIBED_TEXT_SMS', $array_subst);
// send message to the user subscribed
createNewAlert('UserCourseInserted', 'subscribe', 'deny', '1', 'User course deny', $deny_user, $msg_composer, true);
}
Util::jump_to('index.php?r=' . $this->link_course . '/show&res=' . ($re ? 'ok' : 'err'));
}
function getCourseEditionTable($course_id)
{
$res = "";
require_once _base_ . '/lib/lib.table.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.course.php';
$lang_c =& DoceboLanguage::createInstance('catalogue');
$lang =& DoceboLanguage::createInstance('course');
/*
$qtxt ="SELECT name FROM ".$GLOBALS["prefix_lms"]."_course ";
$qtxt.="WHERE idCourse = '".(int)$course_id."'";
list($course_name)=sql_fetch_row(sql_query($qtxt));
*/
$man_course = new Man_Course();
$course = $man_course->getCourseInfo($course_id);
$course_name = $course["name"];
$subs_lang = array(0 => $lang->def('_COURSE_S_GODADMIN'), 1 => $lang->def('_COURSE_S_MODERATE'), 2 => $lang->def('_COURSE_S_FREE'), 3 => $lang->def('_COURSE_S_SECURITY_CODE'));
$tab = new Table(0, $lang->def('_EDITIONS') . ": " . $course_name, $lang->def('_EDITIONS'));
$tab->setTableStyle('edition_block');
$cont_h[] = $lang->def('_CODE');
$type_h[] = 'code_course';
$cont_h[] = $lang->def('_COURSE');
$type_h[] = '';
$cont_h[] = $lang->def('_SUBSCRIBE_METHOD');
$type_h[] = 'image nowrap';
$cont_h[] = $lang->def('_ENROL_COUNT');
$type_h[] = 'image nowrap';
$cont_h[] = $lang->def('_CREATION_DATE');
$type_h[] = 'image nowrap';
$cont_h[] = $lang->def('_SUBSCRIPTION', 'course');
$type_h[] = 'image nowrap';
$tab->setColsStyle($type_h);
$tab->addHead($cont_h);
$qtxt = "SELECT t1.*, COUNT(t2.idUser) as enrolled ";
$qtxt .= "FROM " . $GLOBALS["prefix_lms"] . "_course_edition as t1 ";
$qtxt .= "\tLEFT JOIN " . $GLOBALS['prefix_lms'] . "_courseuser AS t2 ON ( t1.idCourseEdition = t2.edition_id ) ";
$qtxt .= "WHERE t1.idCourse='" . (int) $course_id . "' ";
$qtxt .= "\tAND t1.status <> '" . CST_PREPARATION . "' ";
$qtxt .= "GROUP BY t1.idCourseEdition ";
$qtxt .= "ORDER BY t1.date_begin ";
//$res.=$qtxt;
$q = sql_query($qtxt);
if ($q && mysql_num_rows($q) > 0) {
while ($row = mysql_fetch_assoc($q)) {
$cont = array();
$cont[] = $row["code"];
$edition_id = $row["idCourseEdition"];
$url = "index.php?modname=coursecatalogue&op=editiondetails&edition_id=" . $edition_id;
$url .= "&course_id=" . $course_id;
$cont[] = '<a href="' . $url . '">' . $row["name"] . "</a>\n";
$cont[] = $subs_lang[$course["subscribe_method"]];
$cont[] = $row["enrolled"];
$cont[] = createDateDistance($course["create_date"], "coursecatalogue");
$cont[] = getSubscribeActionLink($course_id, $course, $lang, $edition_id);
$tab->addBody($cont);
}
$res .= $tab->getTable();
} else {
$res = FALSE;
}
return $res;
}
function _printTable_users($type, &$acl_man, &$id_courses, &$num_iscr, &$num_nobegin, &$num_itinere, &$num_end, &$time_in_course, $filter_cols, $show_percent, $show_classrooms_editions, &$classrooms_editions_info)
{
require_once _lms_ . '/admin/modules/report/report_tableprinter.php';
$buffer = new ReportTablePrinter($type);
$output = '';
require_once $GLOBALS['where_lms'] . '/lib/lib.course.php';
$lang =& DoceboLanguage::createInstance('course', 'lms');
$course_lang =& DoceboLanguage::createInstance('course', 'lms');
$rg_lang =& DoceboLanguage::createInstance('report', 'framework');
$colspan_course = 0;
if (in_array('_CODE_COURSE', $filter_cols)) {
$colspan_course++;
}
if (in_array('_NAME_COURSE', $filter_cols)) {
$colspan_course++;
}
if (in_array('_COURSE_CATEGORY', $filter_cols)) {
$colspan_course++;
}
if (in_array('_COURSESTATUS', $filter_cols)) {
$colspan_course++;
}
if (in_array('_COURSECATALOGUE', $filter_cols)) {
$colspan_course++;
}
if (in_array('_PUBLICATION_DATE', $filter_cols)) {
$colspan_course++;
}
if (in_array('_LANGUAGE', $filter_cols)) {
$colspan_course++;
}
if (in_array('_DIFFICULT', $filter_cols)) {
$colspan_course++;
}
if (in_array('_DATE_BEGIN', $filter_cols)) {
$colspan_course++;
}
if (in_array('_DATE_END', $filter_cols)) {
$colspan_course++;
}
if (in_array('_TIME_BEGIN', $filter_cols)) {
$colspan_course++;
}
if (in_array('_TIME_END', $filter_cols)) {
$colspan_course++;
}
if (in_array('_MAX_NUM_SUBSCRIBED', $filter_cols)) {
$colspan_course++;
}
if (in_array('_MIN_NUM_SUBSCRIBED', $filter_cols)) {
$colspan_course++;
}
if (in_array('_CREDITS', $filter_cols)) {
$colspan_course++;
}
if (in_array('_PRICE', $filter_cols)) {
$colspan_course++;
}
if (in_array('_ADVANCE', $filter_cols)) {
$colspan_course++;
}
if (in_array('_COURSE_TYPE', $filter_cols)) {
$colspan_course++;
}
if (in_array('_AUTOREGISTRATION_CODE', $filter_cols)) {
$colspan_course++;
}
$colspan_classrooms_editions = 0;
if ($show_classrooms_editions) {
if (in_array('_TH_CLASSROOM_CODE', $filter_cols)) {
$colspan_classrooms_editions++;
}
if (in_array('_TH_CLASSROOM_NAME', $filter_cols)) {
$colspan_classrooms_editions++;
}
if (in_array('_TH_CLASSROOM_MIN_DATE', $filter_cols)) {
$colspan_classrooms_editions++;
}
if (in_array('_TH_CLASSROOM_MAX_DATE', $filter_cols)) {
$colspan_classrooms_editions++;
}
}
$colspan_stats = 0;
if (in_array('_INSCR', $filter_cols)) {
$colspan_stats++;
}
if (in_array('_MUSTBEGIN', $filter_cols)) {
$colspan_stats += $show_percent ? 2 : 1;
}
if (in_array('_USER_STATUS_BEGIN', $filter_cols)) {
$colspan_stats += $show_percent ? 2 : 1;
}
if (in_array('_COMPLETECOURSE', $filter_cols)) {
$colspan_stats += $show_percent ? 2 : 1;
}
$buffer->openTable();
$th1 = array(array('colspan' => $colspan_course + $colspan_classrooms_editions, 'style' => 'align-center', 'value' => $lang->def('_COURSE')), array('colspan' => $colspan_stats, 'style' => 'align-center', 'value' => $rg_lang->def('_USERS')));
$th2 = array();
$th2[] = array('colspan' => $colspan_course, 'value' => '');
if ($show_classrooms_editions) {
$th2[] = array('colspan' => $colspan_classrooms_editions, 'style' => 'align-center', 'value' => Lang::t('_CLASSROOM', 'classroom'));
}
if (in_array('_INSCR', $filter_cols)) {
$th2[] = array('style' => 'align-center', 'value' => $rg_lang->def('_USER_STATUS_SUBS'));
}
if (in_array('_MUSTBEGIN', $filter_cols)) {
$th2[] = array('colspan' => $show_percent ? 2 : 1, 'style' => 'align-center', 'value' => $rg_lang->def('_MUSTBEGIN'));
}
if (in_array('_USER_STATUS_BEGIN', $filter_cols)) {
$th2[] = array('colspan' => $show_percent ? 2 : 1, 'style' => 'align-center', 'value' => $rg_lang->def('_USER_STATUS_BEGIN'));
}
if (in_array('_COMPLETECOURSE', $filter_cols)) {
$th2[] = array('colspan' => $show_percent ? 2 : 1, 'style' => 'align-center', 'value' => $rg_lang->def('_COMPLETED'));
}
$th3 = array();
if (in_array('_CODE_COURSE', $filter_cols)) {
$th3[] = $lang->def('_COURSE_CODE');
}
if (in_array('_NAME_COURSE', $filter_cols)) {
$th3[] = $lang->def('_COURSE_NAME');
}
if (in_array('_COURSE_CATEGORY', $filter_cols)) {
$th3[] = $lang->def('_CATEGORY');
}
if (in_array('_COURSESTATUS', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $lang->def('_STATUS'));
}
if (in_array('_COURSECATALOGUE', $filter_cols)) {
$th3[] = $lang->def('_CATALOGUE');
}
if (in_array('_PUBLICATION_DATE', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $lang->def('_CREATION_DATE'));
}
if (in_array('_LANGUAGE', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $lang->def('_COURSE_LANG_METHOD'));
}
if (in_array('_DIFFICULT', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $lang->def('_DIFFICULTY'));
}
if (in_array('_DATE_BEGIN', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $lang->def('_DATE_BEGIN'));
}
if (in_array('_DATE_END', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $lang->def('_DATE_END'));
}
if (in_array('_TIME_BEGIN', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $lang->def('_HOUR_BEGIN'));
}
if (in_array('_TIME_END', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $lang->def('_HOUR_END'));
}
if (in_array('_MAX_NUM_SUBSCRIBED', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $lang->def('_MAX_NUM_SUBSCRIBE'));
}
if (in_array('_MIN_NUM_SUBSCRIBED', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $lang->def('_MIN_NUM_SUBSCRIBE'));
}
if (in_array('_CREDITS', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => Lang::t('_CREDITS', 'standard'));
}
if (in_array('_PRICE', $filter_cols)) {
$th3[] = $lang->def('_COURSE_PRIZE');
}
if (in_array('_ADVANCE', $filter_cols)) {
$th3[] = $lang->def('_COURSE_ADVANCE');
}
if (in_array('_COURSE_TYPE', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $lang->def('_COURSE_TYPE'));
}
if (in_array('_AUTOREGISTRATION_CODE', $filter_cols)) {
$th3[] = $lang->def('_AUTOREGISTRATION_CODE');
}
if ($show_classrooms_editions) {
if (in_array('_TH_CLASSROOM_CODE', $filter_cols)) {
$th3[] = Lang::t('_NAME', 'standard');
}
if (in_array('_TH_CLASSROOM_NAME', $filter_cols)) {
$th3[] = Lang::t('_CODE', 'standard');
}
if (in_array('_TH_CLASSROOM_MIN_DATE', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => Lang::t('_DATE_BEGIN', 'standard'));
}
if (in_array('_TH_CLASSROOM_MAX_DATE', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => Lang::t('_DATE_END', 'standard'));
}
}
if (in_array('_INSCR', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $rg_lang->def('_NUM'));
}
if (in_array('_MUSTBEGIN', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $rg_lang->def('_NUM', 'report'));
if ($show_percent) {
$th3[] = array('style' => 'align-center', 'value' => $rg_lang->def('_PERC'));
}
}
if (in_array('_USER_STATUS_BEGIN', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $rg_lang->def('_NUM', 'report'));
if ($show_percent) {
$th3[] = array('style' => 'align-center', 'value' => $rg_lang->def('_PERC'));
}
}
if (in_array('_COMPLETECOURSE', $filter_cols)) {
$th3[] = array('style' => 'align-center', 'value' => $rg_lang->def('_NUM', 'report'));
if ($show_percent) {
$th3[] = array('style' => 'align-center', 'value' => $rg_lang->def('_PERC'));
}
}
if (in_array('_TOTAL_SESSION', $filter_cols)) {
$th1[] = array('style' => 'align-center', 'value' => $rg_lang->def('_TOTAL_SESSION'));
$th2[] = '';
$th3[] = '';
}
$buffer->openHeader();
$buffer->addHeader($th1);
$buffer->addHeader($th2);
$buffer->addHeader($th3);
$buffer->closeHeader();
$i = 0;
$tot_iscr = $tot_itinere = $tot_nobegin = $tot_comple = '';
$tot_perc_itinere = $tot_perc_nobegin = $tot_perc_comple = '';
$total_time = 0;
$array_status = array(CST_PREPARATION => $lang->def('_CST_PREPARATION', 'course', 'lms'), CST_AVAILABLE => $lang->def('_CST_AVAILABLE', 'course', 'lms'), CST_EFFECTIVE => $lang->def('_CST_CONFIRMED', 'course', 'lms'), CST_CONCLUDED => $lang->def('_CST_CONCLUDED', 'course', 'lms'), CST_CANCELLED => $lang->def('_CST_CANCELLED', 'course', 'lms'));
//extract course categories
$query = "SELECT idCategory, path" . " FROM " . $GLOBALS['prefix_lms'] . "_category";
$result = sql_query($query);
$array_category = array(0 => $lang->def('_NONE'));
while (list($id_cat, $name_cat) = sql_fetch_row($result)) {
$array_category[$id_cat] = substr($name_cat, 5, strlen($name_cat) - 5);
}
//strrpos($name_cat, '/') + 1 );
//extract course catalogues and relations
$query = "SELECT idCatalogue, name" . " FROM " . $GLOBALS['prefix_lms'] . "_catalogue";
$result = sql_query($query);
$array_catalogue = array();
while (list($id_cat, $name_cat) = sql_fetch_row($result)) {
$array_catalogue[$id_cat] = $name_cat;
}
//strrpos($name_cat, '/') + 1 );
$catalogue_entries = array();
$query = "select * FROM " . $GLOBALS['prefix_lms'] . "_catalogue_entry ";
//where idst_member in (...)
$result = sql_query($query);
while (list($idcat, $entry, $type) = sql_fetch_row($result)) {
switch ($type) {
case 'course':
if (!isset($catalogue_entries[$entry])) {
$catalogue_entries[$entry] = array();
}
$catalogue_entries[$entry][] = $idcat;
break;
case 'coursepath':
//...
break;
}
//end switch
}
$difficult_trans = array('veryeasy' => Lang::t('_DIFFICULT_VERYEASY', 'standard'), 'easy' => Lang::t('_DIFFICULT_EASY', 'standard'), 'medium' => Lang::t('_DIFFICULT_MEDIUM', 'standard'), 'difficult' => Lang::t('_DIFFICULT_DIFFICULT', 'standard'), 'verydifficult' => Lang::t('_DIFFICULT_VERYDIFFICULT', 'standard'));
$course_man = new Man_Course();
$buffer->openBody();
while (list($index, $course_info) = each($id_courses)) {
$idc = $id_date = 0;
if ($show_classrooms_editions) {
if (isset($course_info['course_type']) && $course_info['course_type'] == 'classroom') {
list($idc, $id_date) = explode('_', $index);
} else {
$idc = $index;
}
} else {
$idc = $index;
}
$info_course = $course_man->getCourseInfo($idc);
$code_c = $course_info['code'];
$name_c = $course_info['name'];
$_date_create = $info_course['create_date'] != '0000-00-00 00:00:00' && $info_course['create_date'] != "" ? Format::date($info_course['create_date'], 'datetime') : "";
$_date_begin = $info_course['date_begin'] != '0000-00-00 00:00:00' && $info_course['date_begin'] != "" ? Format::date($info_course['date_begin'], 'datetime') : "";
$_date_end = $info_course['date_end'] != '0000-00-00 00:00:00' && $info_course['date_end'] != "" ? Format::date($info_course['date_end'], 'datetime') : "";
$trow = array();
if (in_array('_CODE_COURSE', $filter_cols)) {
$trow[] = addslashes($code_c);
}
if (in_array('_NAME_COURSE', $filter_cols)) {
$trow[] = addslashes($name_c);
}
if (in_array('_COURSE_CATEGORY', $filter_cols)) {
$trow[] = $array_category[$info_course['idCategory']];
}
if (in_array('_COURSESTATUS', $filter_cols)) {
$trow[] = isset($array_status[$info_course['status']]) ? $array_status[$info_course['status']] : '';
}
if (in_array('_COURSECATALOGUE', $filter_cols)) {
$temp = array();
if (isset($catalogue_entries[$info_course['idCourse']])) {
foreach ($catalogue_entries[$info_course['idCourse']] as $idcat) {
$temp[] = $array_catalogue[$idcat];
}
}
$trow[] = implode(', ', $temp);
}
if (in_array('_PUBLICATION_DATE', $filter_cols)) {
$trow[] = array('style' => 'align-center', 'value' => $_date_create);
}
if (in_array('_LANGUAGE', $filter_cols)) {
$trow[] = $info_course['lang_code'];
}
if (in_array('_DIFFICULT', $filter_cols)) {
$trow[] = isset($difficult_trans[$info_course['difficult']]) ? $difficult_trans[$info_course['difficult']] : "";
}
if (in_array('_DATE_BEGIN', $filter_cols)) {
$trow[] = array('style' => 'align-center', 'value' => $_date_begin);
}
if (in_array('_DATE_END', $filter_cols)) {
$trow[] = array('style' => 'align-center', 'value' => $_date_end);
}
if (in_array('_TIME_BEGIN', $filter_cols)) {
$trow[] = $info_course['hour_begin'] < 0 ? '' : $info_course['hour_begin'];
}
if (in_array('_TIME_END', $filter_cols)) {
$trow[] = $info_course['hour_end'] < 0 ? '' : $info_course['hour_end'];
}
if (in_array('_MAX_NUM_SUBSCRIBED', $filter_cols)) {
$trow[] = $info_course['max_num_subscribe'] ? $info_course['max_num_subscribe'] : '';
}
if (in_array('_MIN_NUM_SUBSCRIBED', $filter_cols)) {
$trow[] = $info_course['min_num_subscribe'] ? $info_course['min_num_subscribe'] : '';
}
if (in_array('_CREDITS', $filter_cols)) {
$trow[] = isset($info_course['credits']) ? $info_course['credits'] : '';
}
if (in_array('_PRICE', $filter_cols)) {
$trow[] = $info_course['prize'] != '' ? $info_course['prize'] : '0';
}
if (in_array('_ADVANCE', $filter_cols)) {
$trow[] = $info_course['advance'] != '' ? $info_course['advance'] : '0';
}
if (in_array('_COURSE_TYPE', $filter_cols)) {
$trow[] = array('style' => 'align-center', 'value' => $this->_translateCourseType($info_course['course_type']));
}
if (in_array('_AUTOREGISTRATION_CODE', $filter_cols)) {
$trow[] = $info_course['autoregistration_code'];
}
if ($show_classrooms_editions) {
$e_code = $e_name = $date_1 = $date_2 = '';
if ($id_date > 0 && isset($classrooms_editions_info['classrooms'][$id_date])) {
$e_code = $classrooms_editions_info['classrooms'][$id_date]->code;
$e_name = $classrooms_editions_info['classrooms'][$id_date]->name;
$date_1 = Format::date($classrooms_editions_info['classrooms'][$id_date]->date_1, 'datetime');
$date_2 = Format::date($classrooms_editions_info['classrooms'][$id_date]->date_2, 'datetime');
}
if (in_array('_TH_CLASSROOM_CODE', $filter_cols)) {
$trow[] = $e_code;
}
if (in_array('_TH_CLASSROOM_NAME', $filter_cols)) {
$trow[] = $e_name;
}
if (in_array('_TH_CLASSROOM_MIN_DATE', $filter_cols)) {
$trow[] = array('style' => 'align-center', 'value' => $date_1);
}
if (in_array('_TH_CLASSROOM_MAX_DATE', $filter_cols)) {
$trow[] = array('style' => 'align-center', 'value' => $date_2);
}
}
if (isset($num_iscr[$index])) {
if (in_array('_INSCR', $filter_cols)) {
$trow[] = array('style' => 'img-cell', 'value' => $num_iscr[$index]);
}
$tot_iscr += $num_iscr[$index];
//no begin course
if (in_array('_MUSTBEGIN', $filter_cols)) {
if (isset($num_nobegin[$index])) {
$perc = $num_nobegin[$index] / $num_iscr[$index] * 100;
$tot_nobegin += $num_nobegin[$index];
$tot_perc_nobegin += $perc;
$trow[] = array('style' => 'img-cell', 'value' => $num_nobegin[$index]);
if ($show_percent) {
$trow[] = array('style' => 'img-cell', 'value' => number_format($perc, 2, '.', '') . '%');
}
} else {
$trow[] = '';
if ($show_percent) {
$trow[] = '';
}
}
}
//begin
if (in_array('_USER_STATUS_BEGIN', $filter_cols)) {
if (isset($num_itinere[$index])) {
$perc = $num_itinere[$index] / $num_iscr[$index] * 100;
$tot_itinere += $num_itinere[$index];
$tot_perc_itinere += $perc;
$trow[] = array('style' => 'img-cell', 'value' => $num_itinere[$index]);
if ($show_percent) {
$trow[] = array('style' => 'img-cell', 'value' => number_format($perc, 2, '.', '') . '%');
}
} else {
$trow[] = array('style' => 'img-cell', 'value' => '');
if ($show_percent) {
$trow[] = array('style' => 'img-cell', 'value' => '');
}
}
}
//end course
if (in_array('_COMPLETECOURSE', $filter_cols)) {
if (isset($num_end[$index])) {
$perc = $num_end[$index] / $num_iscr[$index] * 100;
$tot_comple += $num_end[$index];
$tot_perc_comple += $perc;
$trow[] = array('style' => 'img-cell', 'value' => $num_end[$index]);
if ($show_percent) {
$trow[] = array('style' => 'img-cell', 'value' => number_format($perc, 2, '.', '') . '%');
}
} else {
$trow[] = array('style' => 'img-cell', 'value' => '');
if ($show_percent) {
$trow[] = array('style' => 'img-cell', 'value' => '');
}
}
}
// time in
if (in_array('_TOTAL_SESSION', $filter_cols)) {
if (isset($time_in_course[$idc])) {
$total_time += $time_in_course[$idc];
$trow[] = array('style' => 'img-cell', 'value' => (int) ($time_in_course[$idc] / 3600) . 'h ' . substr('0' . (int) ($time_in_course[$idc] % 3600 / 60), -2) . 'm ' . substr('0' . (int) ($time_in_course[$idc] % 60), -2) . 's ');
} else {
$trow[] = array('style' => 'img-cell', 'value' => '');
}
}
} else {
if (in_array('_INSCR', $filter_cols)) {
$trow[] = '';
}
//no begin course
if (in_array('_MUSTBEGIN', $filter_cols)) {
$trow[] = '';
if ($show_percent) {
$trow[] = '';
}
}
//begin
if (in_array('_USER_STATUS_BEGIN', $filter_cols)) {
$trow[] = '';
if ($show_percent) {
$trow[] = '';
}
}
//end course
if (in_array('_COMPLETECOURSE', $filter_cols)) {
$trow[] = '';
if ($show_percent) {
$trow[] = '';
}
}
// time in
if (in_array('_TOTAL_SESSION', $filter_cols)) {
$trow[] = '';
}
}
//print row
if (isset($num_iscr[$index]) && $num_iscr[$index]) {
$buffer->addLine($trow);
} else {
$i--;
}
}
$buffer->closeBody();
$tfoot = array(array('colspan' => $colspan_course + $colspan_classrooms_editions, 'value' => $lang->def('_TOTAL')));
if (in_array('_INSCR', $filter_cols)) {
$tfoot[] = $tot_iscr;
}
if (in_array('_MUSTBEGIN', $filter_cols)) {
$tfoot[] = $tot_nobegin;
if ($show_percent) {
$tfoot[] = $tot_nobegin ? number_format($tot_nobegin / $tot_iscr * 100, 2, '.', '') . '%' : 'n.d.';
}
}
if (in_array('_USER_STATUS_BEGIN', $filter_cols)) {
$tfoot[] = $tot_itinere;
if ($show_percent) {
$tfoot[] = $tot_itinere ? number_format($tot_itinere / $tot_iscr * 100, 2, '.', '') . '%' : 'n.d.';
}
}
if (in_array('_COMPLETECOURSE', $filter_cols)) {
$tfoot[] = $tot_comple;
if ($show_percent) {
$tfoot[] = $tot_comple ? number_format($tot_comple / $tot_iscr * 100, 2, '.', '') . '%' : 'n.d.';
}
}
if (in_array('_TOTAL_SESSION', $filter_cols)) {
$tfoot[] = (int) ($total_time / 3600) . 'h ' . substr('0' . (int) ($total_time / 60), -2) . 'm ' . substr('0' . (int) $total_time, -2) . 's ';
}
$buffer->setFoot($tfoot);
$buffer->closeTable();
//return $output;
return $buffer->get();
}
public function getClassrooms($params)
{
require_once _lms_ . '/lib/lib.course.php';
require_once _lms_ . '/lib/lib.date.php';
$output = array();
$output['success'] = true;
$course_id = isset($params['course_id']) ? (int) $params['course_id'] : false;
$course_code = isset($params['course_code']) ? $params['course_code'] : false;
if (empty($course_id) && empty($course_code)) {
return false;
// return array('success'=>true, 'debug'=>print_r($params, true));
} else {
if (empty($course_id) && !empty($course_code)) {
// grab course info by code:
$db = DbConn::getInstance();
$qtxt = "SELECT * FROM %lms_course\r\n\t\t\t\t\tWHERE code='" . $course_code . "'\r\n\t\t\t\t\tLIMIT 0,1";
$q = $db->query($qtxt);
$course_info = $db->fetch_assoc($q);
if (!empty($course_info)) {
$course_id = (int) $course_info['idCourse'];
} else {
// course not found
return false;
// return array('success'=>'true', 'debug'=>print_r($course_info));
}
}
}
$classroom_man = new DateManager();
$course_list = $classroom_man->getCourseDate($course_id);
$course_man = new Man_Course();
$course = $course_man->getCourseInfo($course_id);
foreach ($course_list as $key => $course_info) {
$output[]['course_info'] = array('course_id' => $course['idCourse'], 'date_id' => $course_info['id_date'], 'code' => str_replace('&', '&', $course_info['code']), 'course_name' => str_replace('&', '&', $course_info['name']), 'course_description' => str_replace('&', '&', $course_info['description']), 'status' => $course_info['status'], 'selling' => $course['selling'], 'price' => $course_info['price'], 'subscribe_method' => $course['subscribe_method'], 'sub_start_date' => $course_info['sub_start_date'], 'sub_end_date' => $course_info['sub_end_date'], 'date_begin' => $course_info['date_begin'], 'date_end' => $course_info['date_end'], 'num_day' => $course_info['num_day'], 'classroom' => $course_info['classroom'], 'course_link' => Get::sett('url') . _folder_lms_ . '/index.php?modname=course&op=aula&idCourse=' . $course['idCourse']);
}
//$output['debug']=print_r($course_list, true).print_r($course, true);
return $output;
}
public function getCourseInfoForSubscription()
{
if ($this->id_edition != 0) {
require_once _lms_ . '/lib/lib.edition.php';
$edition_man = new EditionManager();
$edition_info = $edition_man->getEditionInfo($this->id_edition);
require_once _lms_ . '/lib/lib.course.php';
$course_info = Man_Course::getCourseInfo($this->id_course);
$res = array('max_num_subscribe' => $edition_info['max_num_subscribe'], 'subscribe_method' => $course_info['subscribe_method'], 'code' => $edition_info['code'], 'name' => $edition_info['name'], 'medium_time' => $course_info['mediumTime'], 'course_type' => $course_info['course_type'], 'date_begin' => $edition_info['date_begin'], 'date_end' => $edition_info['date_end']);
} elseif ($this->id_date != 0) {
require_once _lms_ . '/lib/lib.date.php';
$date_man = new DateManager();
$date_info = $date_man->getDateInfo($this->id_date);
require_once _lms_ . '/lib/lib.course.php';
$course_info = Man_Course::getCourseInfo($this->id_course);
$res = array('max_num_subscribe' => $course_info['max_num_subscribe'], 'subscribe_method' => $course_info['subscribe_method'], 'code' => $date_info['code'], 'name' => $date_info['name'], 'medium_time' => $course_info['mediumTime'], 'course_type' => $course_info['course_type'], 'date_begin' => $date_info['date_begin'], 'date_end' => $date_info['date_end']);
} else {
require_once _lms_ . '/lib/lib.course.php';
$course_info = Man_Course::getCourseInfo($this->id_course);
$res = array('max_num_subscribe' => $course_info['max_num_subscribe'], 'subscribe_method' => $course_info['subscribe_method'], 'code' => $course_info['code'], 'name' => $course_info['name'], 'medium_time' => $course_info['mediumTime'], 'course_type' => $course_info['course_type'], 'date_begin' => $course_info['date_begin'], 'date_end' => $course_info['date_end']);
}
return $res;
}
function modTransaction()
{
require_once _base_ . '/lib/lib.table.php';
require_once _base_ . '/lib/lib.form.php';
require_once _base_ . '/lib/lib.dialog.php';
require_once _lms_ . '/lib/lib.course.php';
require_once _lms_ . '/lib/lib.date.php';
$lang =& DoceboLanguage::createInstance('transaction');
$acl_man = Docebo::user()->getAclManager();
$man_transaction = new Man_Transaction();
$course_man = new Man_Course();
$date_man = new DateManager();
$id_transaction = Get::req('id', DOTY_INT, 0);
$transaction_info = $man_transaction->getTransactionInfo($id_transaction);
if (isset($_POST['update'])) {
$payment_status = Get::req('payment_status', DOTY_INT, 0);
$course_status = Get::req('course_status', DOTY_INT, 0);
$note = Get::req('note', DOTY_MIXED, '');
if ($man_transaction->updateTransaction($id_transaction, $payment_status, $course_status, $note)) {
if (isset($_POST['confirm'])) {
$activations = array();
foreach ($_POST['confirm'] as $id => $n) {
list($id_course, $id_date) = explode('_', $id);
if ($id_date != 0) {
$activations[$id_course]['dates'][$id_date] = $id_date;
} else {
$activations[$id_course] = $id_course;
}
}
if ($man_transaction->activateCourses($id_transaction, $transaction_info['id_user'], $activations)) {
Util::jump_to('index.php?modname=transaction&op=transaction&res=ok');
}
} else {
Util::jump_to('index.php?modname=transaction&op=transaction&res=ok');
}
}
Util::jump_to('index.php?modname=transaction&op=transaction&res=err_up');
}
$array_title = array('index.php?modname=transaction&op=transaction' => $lang->def('_TRANSACTION'), $lang->def('_MOD_TRANSACTION'));
//Status info & note
$array_payment_status = array('-1' => $lang->def('_CANCELLED'), '0' => $lang->def('_WAITING_PAYMENT'), '1' => $lang->def('_PARTIAL_PAID'), '2' => $lang->def('_PAID'));
$array_course_status = array('-1' => $lang->def('_CANCELLED'), '0' => $lang->def('_NO_COURSE_ACTIVATED'), '1' => $lang->def('_SOME_COURSE_ACTIVATED'), '2' => $lang->def('_ALL_COURSE_ACTIVATED'));
cout(getTitleArea($array_title) . '<div class="std_block">' . Form::openForm('transaction_info', 'index.php?modname=transaction&op=mod&id=' . $id_transaction) . Form::openElementSpace() . Form::getDropdown($lang->def('_PAYMENT_STATUS_FILTER'), 'payment_status', 'payment_status', $array_payment_status, $transaction_info['payment_status']) . Form::getDropdown($lang->def('_COURSE_STATUS_FILTER'), 'course_status', 'course_status', $array_course_status, $transaction_info['course_status']) . Form::getSimpleTextarea($lang->def('_NOTES'), 'note', 'note', $transaction_info['note']) . Form::closeElementSpace());
//User info
$user_info = $acl_man->getUser($transaction_info['id_user'], false);
$tb_user = new Table(0, $lang->def('_USER_INFO'), $lang->def('_USER_INFO'));
$cont_h = array($lang->def('_USERNAME'), $lang->def('_FIRSTNAME'), $lang->def('_LASTNAME'), $lang->def('_EMAIL'));
$type_h = array('', '', '', '');
$tb_user->setColsStyle($type_h);
$tb_user->addHead($cont_h);
$tb_user->addBody(array($acl_man->relativeId($user_info[ACL_INFO_USERID]), $user_info[ACL_INFO_FIRSTNAME], $user_info[ACL_INFO_LASTNAME], $user_info[ACL_INFO_EMAIL]));
cout('<br />' . $tb_user->getTable());
//Payment info if we need it
//Product info
$tb_product = new Table(0, $lang->def('_PRODUCT_INFO'), $lang->def('_PRODUCT_INFO'));
$cont_h = array($lang->def('_CODE'), $lang->def('_NAME'), $lang->def('_DATE_BEGIN'), $lang->def('_DATE_END'), $lang->def('_COURSE_PRIZE'), $lang->def('_CONFIRM_COURSE'));
$type_h = array('', '', '', '', '', '');
$tb_product->setColsStyle($type_h);
$tb_product->addHead($cont_h);
$transaction_course = $man_transaction->getTransactionCourses($id_transaction);
foreach ($transaction_course as $id_course => $details) {
if (is_array($details)) {
foreach ($details['dates'] as $id_date) {
$date_info = $date_man->getDateInfo($id_date);
$checked = false;
$other = '';
if ($man_transaction->controlActivation($id_transaction, $id_course, $id_date)) {
$checked = true;
$other = 'disabled="disabled"';
}
$tb_product->addBody(array($date_info['code'], $date_info['name'], Format::date($date_info['date_begin']), Format::date($date_info['date_end']), $date_info['price'], Form::getInputCheckbox($id_course . '_' . $id_date, 'confirm[' . $id_course . '_' . $id_date . ']', 1, $checked, $other)));
}
} else {
$course_info = $course_man->getCourseInfo($id_course);
$checked = false;
$other = '';
if ($man_transaction->controlActivation($id_transaction, $id_course)) {
$checked = true;
$other = 'disabled="disabled"';
}
$tb_product->addBody(array($course_info['code'], $course_info['name'], $course_info['date_begin'] !== '0000-00-00' ? Format::date($course_info['date_begin'], 'date') . ($course_info['hour_begin'] !== '-1' ? $course_info['hour_begin'] : '') : '', $course_info['date_end'] !== '0000-00-00' ? Format::date($course_info['date_end'], 'date') . ($course_info['hour_end'] !== '-1' ? $course_info['hour_end'] : '') : '', $course_info['prize'] == '' ? '0' : $course_info['prize'], Form::getInputCheckbox($id_course . '_0', 'confirm[' . $id_course . '_0]', 1, $checked, $other)));
}
}
cout('<br />' . $tb_product->getTable() . Form::openButtonSpace() . Form::getButton('update', 'update', $lang->def('_UPDATE')) . Form::getButton('back_mod', 'back_mod', $lang->def('_BACK')) . Form::closeButtonSpace() . Form::closeForm());
cout('</div>');
}
function subscribe()
{
checkPerm('view');
require_once _base_ . '/lib/lib.form.php';
$form = new Form();
if (isset($_POST['course_autoregistration_code'])) {
require_once _lms_ . '/lib/lib.course.php';
$out =& $GLOBALS['page'];
$out->setWorkingZone('content');
$code = $_POST['course_autoregistration_code'];
$code = strtoupper($code);
$code = str_replace('-', '', $code);
$registration_code_type = Get::sett('registration_code_type', '0');
if ($registration_code_type == 'tree_course') {
$code = substr($code, 10, 10);
}
$course_registration_result = false;
$man_course_user = new Man_CourseUser();
$course_registration_result = $man_course_user->subscribeUserWithCode($code, getLogUserId());
$out->add(getTitleArea(Lang::t('_AUTOREGISTRATION', 'course_autoregistration')) . '<div class="std_block">');
if ($course_registration_result > 0) {
$out->add(str_replace('[course_added]', $course_registration_result, Lang::t('_OPERATION_SUCCESSFUL', 'course_autoregistration')));
$out->add('<br/><a href="index.php?r=' . _after_login_ . '">' . Lang::t('_BACK_TO_COURSE', 'course_autoregistration') . '</a>');
} else {
if ($course_registration_result == -1) {
$out->add(getErrorUi(Lang::t('_CODE_ALREDY_USED', 'course_autoregistration')));
$out->add($form->openForm('course_autoregistration', 'index.php?modname=course_autoregistration&op=course_autoregistration') . $form->openElementSpace() . $form->getTextfield(Lang::t('_COURSE_AUTOREGISTRATION_CODE', 'course_autoregistration'), 'course_autoregistration_code', 'course_autoregistration_code', '255', '') . $form->closeElementSpace() . $form->openButtonSpace() . $form->getButton('subscribe', 'subscribe', Lang::t('_SEND', 'course_autoregistration')) . $form->closeButtonSpace());
} else {
if ($course_registration_result == -2) {
$out->add(getErrorUi(Lang::t('_SUBSCRIPTION_NOT_ALLOWED_YET', 'course_autoregistration')));
$out->add($form->openForm('course_autoregistration', 'index.php?modname=course_autoregistration&op=course_autoregistration') . $form->openElementSpace() . $form->getTextfield(Lang::t('_COURSE_AUTOREGISTRATION_CODE', 'course_autoregistration'), 'course_autoregistration_code', 'course_autoregistration_code', '255', '') . $form->closeElementSpace() . $form->openButtonSpace() . $form->getButton('subscribe', 'subscribe', Lang::t('_SEND', 'course_autoregistration')) . $form->closeButtonSpace());
} else {
require_once _adm_ . '/lib/lib.code.php';
$code = $_POST['course_autoregistration_code'];
$code_manager = new CodeManager();
$valid_code = $code_manager->controlCodeValidity($code);
if ($valid_code == 1) {
$array_course = $code_manager->getAvailableCourseAssociateWithCode($code);
require_once _lms_ . '/lib/lib.course.php';
$man_course = new Man_Course();
$array_course_name = array();
$counter = 0;
require_once _lms_ . '/lib/lib.subscribe.php';
$subscribe = new CourseSubscribe_Management();
foreach ($array_course as $id_course) {
$query_control = "SELECT COUNT(*)" . " FROM %lms_courseuser" . " WHERE idCourse = " . $id_course . " AND idUser = "******"index.php?r=' . _after_login_ . '">' . Lang::t('_BACK_TO_COURSE', 'course_autoregistration') . '</a>');
} else {
if (sizeof($array_course) == 0) {
$out->add(getErrorUi(Lang::t('_SUBSCRIPTION_NOT_ALLOWED_YET', 'course_autoregistration')));
} else {
$out->add(getErrorUi(Lang::t('_ALREADY_SUBSCRIBED', 'course_autoregistration')));
}
$out->add($form->openForm('course_autoregistration', 'index.php?modname=course_autoregistration&op=course_autoregistration') . $form->openElementSpace() . $form->getTextfield(Lang::t('_COURSE_AUTOREGISTRATION_CODE', 'course_autoregistration'), 'course_autoregistration_code', 'course_autoregistration_code', '255', '') . $form->closeElementSpace() . $form->openButtonSpace() . $form->getButton('subscribe', 'subscribe', Lang::t('_SEND', 'course_autoregistration')) . $form->closeButtonSpace());
}
} else {
if ($valid_code == 0) {
$out->add(getErrorUi(Lang::t('_CODE_ALREDY_USED', 'course_autoregistration')));
} else {
$out->add(getErrorUi(Lang::t('_CODE_NOT_VALID', 'course_autoregistration')));
}
$out->add($form->openForm('course_autoregistration', 'index.php?modname=course_autoregistration&op=course_autoregistration') . $form->openElementSpace() . $form->getTextfield(Lang::t('_COURSE_AUTOREGISTRATION_CODE', 'course_autoregistration'), 'course_autoregistration_code', 'course_autoregistration_code', '255', '') . $form->closeElementSpace() . $form->openButtonSpace() . $form->getButton('subscribe', 'subscribe', Lang::t('_SEND', 'course_autoregistration')) . $form->closeButtonSpace());
}
}
}
}
$out->add('</div>');
}
}
