public function presenceTask() { require_once _base_ . '/lib/lib.form.php'; YuiLib::load(); $user_date = $this->model->getUserDateForCourse(getLogUserId(), $_SESSION['idCourse']); $date_info = $this->model->getDateInfoForPublicPresence($user_date); if ($this->id_date == 0) { $this->id_date = isset($date_info[0]['id_date']) ? $date_info[0]['id_date'] : 0; } $this->model->setIdDate($this->id_date); if (isset($_POST['save'])) { $this->model->savePresence(); } foreach ($date_info as $info_date) { $date_for_dropdown[$info_date['id_date']] = $info_date['code'] . ' - ' . $info_date['name'] . ' (' . Format::date($info_date['date_begin'], 'date') . ')'; } if ($this->id_date == 0) { $this->render('presence_empty', array()); } else { $params = array(); $params['model'] = $this->model; $params['dropdown'] = $date_for_dropdown; $params['tb'] = $this->model->getPresenceTable(); $params['test_type'] = $this->model->getTestType(); $params['date_for_dropdown'] = $date_for_dropdown; $this->render('presence', $params); } }
public function deleteMessage($id) { require_once _adm_ . '/lib/lib.message.php'; $del_query = "UPDATE %adm_message_user SET deleted = '" . _OPERATION_SUCCESSFUL . "' WHERE idUser='******' AND idMessage = '" . (int) $id . "'"; if (!$this->db->query($del_query)) { return false; } $query = "SELECT idMessage FROM %adm_message_user WHERE idMessage = '" . (int) $id . "'"; $res = $this->db->query($query); if ($res && $this->db->num_rows($res) > 0) { $query = "SELECT attach FROM %adm_message WHERE idMessage = '" . (int) $id . "'"; $res = $this->db->query($query); list($attach) = $this->db->fetch_row($res); if ($attach != '') { if (!$this->deleteAttachment($attach)) { return false; } } if (!$this->db->query("DELETE FROM %adm_message_user WHERE idMessage = '" . (int) $id . "'")) { return false; } if (!$this->db->query("DELETE FROM %adm_message WHERE idMessage = '" . (int) $id . "'")) { return false; } } return true; }
function lmsLoginOperation() { require_once $GLOBALS['where_lms'] . '/lib/lib.subscribe.php'; require_once $GLOBALS['where_lms'] . '/lib/lib.preassessment.php'; $pa_man = new AssessmentList(); $user_course_as_assessment = $pa_man->getUserAssessmentSubsription(Docebo::user()->getArrSt()); if (is_array($user_course_as_assessment)) { $subs_man = new CourseSubscribe_Management(); $subs_man->multipleUserSubscribe(getLogUserId(), $user_course_as_assessment['course_list'], $user_course_as_assessment['level_number']); } }
function insfaqcat() { checkPerm('view', false, 'storage'); $back_url = urldecode($_POST['back_url']); $query_ins = "\r\n\tINSERT INTO " . $GLOBALS['prefix_lms'] . "_faq_cat\r\n\tSET title = '" . (trim($_POST['title']) == '' ? Lang::t('_NOTITLE', 'faq', 'lms') : $_POST['title']) . "',\r\n\t\tdescription = '" . $_POST['description'] . "',\r\n\t\tauthor = '" . (int) getLogUserId() . "'"; if (!sql_query($query_ins)) { $_SESSION['last_error'] = Lang::t('_OPERATION_FAILURECAT', 'faq', 'lms'); Util::jump_to($back_url . '&create_result=0'); } list($idFaq) = sql_fetch_row(sql_query("SELECT LAST_INSERT_ID()")); Util::jump_to($back_url . '&id_lo=' . $idFaq . '&create_result=1'); }
function inslinkcat() { checkPerm('view', false, 'storage'); $lang =& DoceboLanguage::createInstance('link'); $back_url = urldecode($_POST['back_url']); $query_ins = "\r\n\tINSERT INTO " . $GLOBALS['prefix_lms'] . "_link_cat\r\n\tSET title = '" . (trim($_POST['title']) == '' ? $lang->def('_NOTITLE') : $_POST['title']) . "',\r\n\t\tdescription = '" . $_POST['description'] . "',\r\n\t\tauthor = '" . (int) getLogUserId() . "'"; if (!sql_query($query_ins)) { $_SESSION['last_error'] = $lang->def('_OPERATION_FAILURE'); Util::jump_to('' . $back_url . '&create_result=0'); } list($idLink) = sql_fetch_row(sql_query("SELECT LAST_INSERT_ID()")); Util::jump_to('' . $back_url . '&id_lo=' . $idLink . '&create_result=1'); }
function play($object_link, $id_param) { //-kb-play-// if(!checkPerm('view', true, 'organization') && !checkPerm('view', true, 'storage')) die("You can't access"); $lang =& DoceboLanguage::createInstance('link'); $idCategory = $object_link->getId(); $mode = importVar('mode', false, 'link'); $back_coded = htmlentities(urlencode($object_link->back_url)); require_once $GLOBALS['where_lms'] . '/lib/lib.param.php'; $idReference = getLOParam($id_param, 'idReference'); // NOTE: Track only if $idReference is present if ($idReference !== FALSE) { require_once $GLOBALS['where_lms'] . '/class.module/track.link.php'; list($exist, $idTrack) = Track_Link::getIdTrack($idReference, getLogUserId(), $idCategory, TRUE); if ($exist) { $ti = new Track_Link($idTrack); $ti->setDate(date('Y-m-d H:i:s')); $ti->status = 'completed'; $ti->update(); } else { $ti = new Track_Link(false); $ti->createTrack($idReference, $idTrack, getLogUserId(), date('Y-m-d H:i:s'), 'completed', 'link'); } } list($title) = sql_fetch_row(sql_query("\r\n\tSELECT title \r\n\tFROM " . $GLOBALS['prefix_lms'] . "_link_cat \r\n\tWHERE idCategory = '" . (int) $idCategory . "'")); $link = 'index.php?modname=link&op=play&idCategory=' . $idCategory . '&id_param=' . $id_param . '&back_url=' . $back_coded; /*$GLOBALS['page']->add('<div id="top" class="std_block">' .'<div class="colum_container">' */ cout('<div id="top" class="yui-navset yui-navset-top tab_block"> <ul class="yui-nav"> <li class="first' . ($mode != 'keyw' ? ' selected' : '') . '"> <a href="' . $link . '&mode=list"> <em>' . Lang::t('_SWITCH_TO_LIST', 'link') . '</em> </a> </li> <li' . ($mode == 'keyw' ? ' class="selected"' : '') . '> <a href="' . $link . '&mode=keyw"> <em>' . Lang::t('_SWITCH_TO_KEYWORD', 'link') . '</em> </a> </li> </ul> <div class="yui-content">', 'content'); cout(getBackUi(Util::str_replace_once('&', '&', $object_link->back_url), $lang->def('_BACK')), 'content'); $GLOBALS['page']->add('<b>' . $lang->def('_TITLE') . ' : ' . $title . '</b><br /><br />' . $lang->def('_LINKIUNNEWWINDOW') . '<br /><br />', 'content'); if ($mode == 'keyw') { displayAsKey($idCategory, $link . '&mode=keyw'); } else { displayAsList($idCategory); } $GLOBALS['page']->add('<div class="align_center">' . '<a href="#top"><img src="' . getPathImage() . 'standard/up.png" title="' . $lang->def('_BACKTOTOP') . '" />' . $lang->def('_BACKTOTOP') . '</a>' . getBackUi(Util::str_replace_once('&', '&', $object_link->back_url), $lang->def('_BACK')) . '</div>', 'content'); cout('</div></div>', 'content'); }
function insglossary() { checkPerm('view', false, 'storage'); if ($_POST['title'] == "") { $_POST['title'] = Lang::t('_NOTITLE', 'glossary'); } $queryIns = "\r\n\tINSERT INTO " . $GLOBALS['prefix_lms'] . "_glossary \r\n\tSET title = '" . $_POST['title'] . "',\r\n\t\tdescription = '" . $_POST['description'] . "',\r\n\t\tauthor = '" . (int) getLogUserId() . "'"; if (!sql_query($queryIns)) { $_SESSION['last_error'] = Lang::t('_OPERATION_FAILURE', 'glossary'); Util::jump_to(urldecode($_POST['back_url']) . '&create_result=0'); } list($id) = sql_fetch_row(sql_query("SELECT LAST_INSERT_ID()")); Util::jump_to(urldecode($_POST['back_url']) . '&id_lo=' . $id . '&create_result=1'); }
function profile() { checkPerm('view'); require_once $GLOBALS['where_lms'] . '/lib/lib.lms_user_profile.php'; $lang =& DoceboLanguage::createInstance('profile', 'framework'); $profile = new LmsUserProfile(getLogUserId()); $profile->init('profile', 'framework', 'modname=profile&op=profile&id_user='******'ap'); if (checkPerm('mod', true)) { $profile->enableEditMode(); } if (Get::sett('profile_only_pwd') == 'on') { $GLOBALS['page']->add($profile->getTitleArea() . $profile->getHead() . $profile->performAction(false, 'mod_password') . profileBackUrl() . $profile->getFooter(), 'content'); } else { $GLOBALS['page']->add($profile->getTitleArea() . $profile->getHead() . $profile->performAction() . profileBackUrl() . $profile->getFooter(), 'content'); } }
function instest() { checkPerm('view', false, 'storage'); $lang =& DoceboLanguage::createInstance('test'); if (trim($_POST['title']) == '') { $_POST['title'] = $lang->def('_NOTITLE'); } $ins_query = "\r\n\tINSERT INTO " . $GLOBALS['prefix_lms'] . "_test \r\n\t( author, title, description )\r\n\t\tVALUES \r\n\t( '" . (int) getLogUserId() . "', '" . $_POST['title'] . "', '" . $_POST['textof'] . "' )"; if (!sql_query($ins_query)) { $_SESSION['last_error'] = $lang->def('_OPERATION_FAILURE'); Util::jump_to('' . urldecode($_POST['back_url']) . '&create_result=0'); } list($id_test) = sql_fetch_row(sql_query("SELECT LAST_INSERT_ID()")); if ($id_test > 0) { Util::jump_to('' . urldecode($_POST['back_url']) . '&id_lo=' . $id_test . '&create_result=1'); } else { Util::jump_to('' . urldecode($_POST['back_url']) . '&create_result=0'); } }
function play($idResource, $idParams, $back_url) { //if(!checkPerm('view', true, 'organization') && !checkPerm('view', true, 'storage')) die("You can't access"); //echo ("idResource = ".$idResource."; idParams = ".$idParams."; back_url = ".$back_url); list($file) = sql_fetch_row(sql_query("SELECT path" . " FROM " . $GLOBALS['prefix_lms'] . "_materials_lesson" . " WHERE idLesson = '" . $idResource . "'")); //recognize mime type $expFileName = explode('.', $file); $totPart = count($expFileName) - 1; require_once $GLOBALS['where_lms'] . '/lib/lib.param.php'; $idReference = getLOParam($idParams, 'idReference'); // NOTE: Track only if $idReference is present if ($idReference !== FALSE) { require_once $GLOBALS['where_lms'] . '/class.module/track.item.php'; list($exist, $idTrack) = Track_Item::getIdTrack($idReference, getLogUserId(), $idResource, TRUE); if ($exist) { $ti = new Track_Item($idTrack); $ti->setDate(date('Y-m-d H:i:s')); $ti->status = 'completed'; $ti->update(); } else { $ti = new Track_Item(false); $ti->createTrack($idReference, $idTrack, getLogUserId(), date('Y-m-d H:i:s'), 'completed', 'item'); } } if ($_SESSION['direct_play'] == 1) { if (isset($_SESSION['idCourse'])) { TrackUser::closeSessionCourseTrack(); unset($_SESSION['idCourse']); unset($_SESSION['idEdition']); } if (isset($_SESSION['test_assessment'])) { unset($_SESSION['test_assessment']); } if (isset($_SESSION['cp_assessment_effect'])) { unset($_SESSION['cp_assessment_effect']); } $_SESSION['current_main_menu'] = '1'; $_SESSION['sel_module_id'] = '1'; $_SESSION['is_ghost'] = false; } //send file sendFile('/appLms/' . Get::sett('pathlesson'), $file, $expFileName[$totPart]); }
function mycompetences(&$url) { checkPerm('view'); $html = ""; $html .= getTitleArea(Lang::t('_COMPETENCES'), 'competences'); $html .= '<div class="std_block">'; $cmodel = new CompetencesAdm(); $fmodel = new FunctionalrolesAdm(); $id_user = getLogUserId(); $ucomps = $cmodel->getUserCompetences($id_user); $rcomps = $fmodel->getUserRequiredCompetences($id_user); $ucomps_info = $cmodel->getCompetencesInfo(array_keys($ucomps)); $language = getLanguage(); $_typologies = $cmodel->getCompetenceTypologies(); $_types = $cmodel->getCompetenceTypes(); $icon_actv = '<span class="ico-sprite subs_actv"><span>' . Lang::t('_COMPETENCE_OBTAINED', 'competences') . '</span></span>'; $icon_req = '<span class="ico-sprite subs_actv"><span>' . Lang::t('_MANDATORY', 'competences') . '</span></span>'; //******************* require_once _base_ . '/lib/lib.table.php'; $table = new Table(Get::sett('visuItem'), Lang::t('_COMPETENCES'), Lang::t('_COMPETENCES')); $style_h = array('', '', 'image', 'image', 'image', 'image', 'image'); $label_h = array(Lang::t('_NAME', 'competences'), Lang::t('_TYPOLOGY', 'competences'), Lang::t('_TYPE', 'standard'), Lang::t('_SCORE', 'competences'), Lang::t('_DATE_LAST_COMPLETE', 'subscribe'), Lang::t('_COMPETENCES_REQUIRED', 'competences')); $table->addHead($label_h, $style_h); foreach ($ucomps_info as $id_competence => $cinfo) { $line = array(); $line[] = $cinfo->langs[$language]['name']; $line[] = $_typologies[$cinfo->typology]; $line[] = $_types[$cinfo->type]; $line[] = $cinfo->type == 'score' ? '<b>' . $ucomps[$id_competence]->score_got . '</b>' : $icon_actv; $line[] = Format::date($ucomps[$id_competence]->last_assign_date, 'datetime'); $line[] = array_key_exists($id_competence, $rcomps) ? $icon_req : ''; $table->addBody($line); } $html .= $table->getTable(); $html .= '</div>'; $html .= Form::openForm('beck_url', 'index.php'); $html .= Form::openButtonSpace(); $html .= Form::getButton('close', 'close', Lang::t('_CLOSE', 'standard')); $html .= Form::closeButtonSpace(); $html .= Form::closeform(); cout($html, 'content'); }
function inspage() { checkPerm('view', false, 'storage'); $back_url = urldecode($_POST['back_url']); $insert_query = "\r\n\tINSERT INTO " . $GLOBALS['prefix_lms'] . "_htmlpage\r\n\tSET title = '" . (trim($_POST['title']) == '' ? Lang::t('_NOTITLE', 'htmlpage', 'lms') : $_POST['title']) . "',\r\n\t\ttextof = '" . $_POST['textof'] . "',\r\n\t\tauthor = '" . (int) getLogUserId() . "'"; if (!sql_query($insert_query)) { $_SESSION['last_error'] = Lang::t('_OPERATION_FAILURE', 'htmlpage', 'lms'); Util::jump_to($back_url . '&create_result=0'); } list($idPage) = sql_fetch_row(sql_query("SELECT LAST_INSERT_ID()")); if ($_FILES) { $n = 0; foreach ($_FILES as $_FILE) { $n++; $file = save_file($_FILE); if ($file) { $insert_query = "INSERT INTO " . $GLOBALS['prefix_lms'] . "_htmlpage_attachment SET file = '" . $file . "', title = '" . trim($_FILE['name']) . "', idpage = " . $idPage; sql_query($insert_query); } } } Util::jump_to($back_url . '&id_lo=' . $idPage . '&create_result=1'); }
public function setRulesFromScore($score_arr) { require_once _base_ . '/lib/lib.json.php'; require_once _lms_ . '/lib/lib.subscribe.php'; $res = true; $where_score_arr = array(); foreach ($score_arr as $val) { $where_score_arr[] = "(category_id = '" . (int) $val['category_id'] . "' " . "AND from_score <= '" . (int) $val['score'] . "' AND to_score >= '" . (int) $val['score'] . "')"; } if (empty($where_score_arr)) { return ''; } $fields = "*"; $qtxt = "SELECT " . $fields . " FROM %lms_assessment_rule\r\n\t\t\tWHERE test_id='" . $this->test_id . "'\r\n\t\t\tAND (" . implode(' OR ', $where_score_arr) . ")\r\n\t\t\tORDER BY from_score ASC"; $q = $this->db->query($qtxt); $json = new Services_JSON(SERVICES_JSON_LOOSE_TYPE); $csm = new CourseSubscribe_Management(); $cmpman = new CompetencesAdm(); $feedback_txt = array(); while ($row = $this->db->fetch_assoc($q)) { $course_arr = $json->decode($row['courses_list']); $competence_arr = $json->decode($row['competences_list']); $feedback_txt[] = $row['feedback_txt']; //courses subscriptions - only students are affected if (!empty($course_arr) && $_SESSION['levelCourse'] <= 3) { $arr_courses = array_keys($course_arr); $csm->multipleUserSubscribe(getLogUserId(), $arr_courses, 3); } //competences assignment - only students are affected if (!empty($competence_arr) && $_SESSION['levelCourse'] <= 3) { foreach ($competence_arr as $c_id => $data) { if ($data['type'] == 'score') { $score = isset($data['score']) ? $data['score'] : 0; if ($score > 0) { if (!$cmpman->userHasCompetence($c_id, Docebo::user()->getIdst())) { $cmpman->assignCompetenceUsers($c_id, array(Docebo::user()->getIdst() => $score)); } else { $cmpman->addScoreToUsers($c_id, array(Docebo::user()->getIdst()), $score); } } } else { if (!$cmpman->userHasCompetence($c_id, Docebo::user()->getIdst())) { $cmpman->assignCompetenceUsers($c_id, array(Docebo::user()->getIdst() => 1)); } } } } } $output = ""; if (!empty($feedback_txt)) { $output = implode('<br/><br />', $feedback_txt); } return $output; }
public function standingsTask() { $id_game = Get::req('id_game', DOTY_INT, 0); $model = new GamesAlms(); $game = $model->findByPk($id_game, Docebo::user()->getArrSt()); YuiLib::load('base,charts'); $this->render('standings', array('game' => $game, 'track' => $model->getUserStandings($game['id_game'], getLogUserId()), 'standings' => $model->getStandings($game['id_game'], 0, 30), 'chart_data' => $this->json->encode($model->getStandingsChartData($game['id_game'])))); }
function delnotes() { checkPerm('view'); $lang =& DoceboLanguage::createInstance('notes', 'lms'); if (isset($_GET['confirm'])) { $query = "\r\n\t\tDELETE FROM " . $GLOBALS['prefix_lms'] . "_notes\r\n\t\tWHERE idNotes='" . $_GET['idNotes'] . "' AND owner='" . getLogUserId() . "' AND idCourse='" . $_SESSION['idCourse'] . "'"; if (!sql_query($query)) { Util::jump_to('index.php?modname=notes&op=notes&result=err'); } Util::jump_to('index.php?modname=notes&op=notes&result=ok'); } else { list($title) = sql_fetch_row(sql_query("\r\n\t\tSELECT title\r\n\t\tFROM " . $GLOBALS['prefix_lms'] . "_notes \r\n\t\tWHERE owner = '" . getLogUserId() . "' AND idNotes = '" . (int) $_GET['idNotes'] . "'")); $title_page = array('index.php?modname=notes&op=notes' => $lang->def('_NOTES'), $lang->def('_DEL')); $GLOBALS['page']->add(getTitleArea($title_page, 'notes') . '<div class="std_block">' . getDeleteUi($lang->def('_AREYOUSURE'), '<span>' . $lang->def('_TITLE') . ' : </span>' . $title, true, 'index.php?modname=notes&op=delnotes&idNotes=' . $_GET['idNotes'] . '&confirm=1', 'index.php?modname=notes&op=notes') . '</div>', 'content'); } }
/** * @param int $id_user the idst of a user * * @return array the id of all the course associated to the group, not include the course in the associated coursepath */ function getAllCourseOfUser($id_user) { $courses = array(); if ($id_user == getLogUserId()) { $user_groups = Docebo::user()->getArrSt(); } else { $user_groups = $this->acl->getSTGroupsST($id_user); } $query = "\r\n\t\tSELECT DISTINCT ce.idEntry\r\n\t\tFROM " . $this->_getCataEntryTable() . " AS ce\r\n\t\t\tJOIN " . $this->_getCataMemberTable() . " AS cm\r\n\t\tWHERE ce.type_of_entry = 'course' AND\r\n\t\t\tce.idCatalogue = cm.idCatalogue AND\r\n\t\t\tcm.idst_member IN (" . implode(',', $user_groups) . ") "; $re_courses = $this->_executeQuery($query); while (list($id_course) = sql_fetch_row($re_courses)) { $courses[$id_course] = $id_course; } return $courses; }
public function getCoursesVisibleToUser($user_id = false) { require_once _lms_ . '/lib/lib.subscribe.php'; $res = array(); $user_id = $user_id > 0 ? $user_id : getLogUserId(); $allowed_status = array(_CUS_SUBSCRIBED, _CUS_BEGIN, _CUS_END); $qtxt = "SELECT t1.idCourse, t2.name, t1.idUser, t1.status FROM %lms_courseuser as t1,\n\t\t\t%lms_course as t2\n\t\t\tWHERE t1.idCourse = t2.idCourse AND\n\t\t\tt1.idUser = "******" AND t1.status IN (" . implode(',', $allowed_status) . ")\n\t\t\tORDER BY t2.name ASC"; $q = $this->db->query($qtxt); while ($row = $this->db->fetch_assoc($q)) { $id = $row['idCourse']; $res[$id] = $row['name']; } return $res; }
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'); }
public function getUserName() { $user_info = $this->aclManager->getUser(getLogUserId(), false); return $user_info[ACL_INFO_LASTNAME] . $user_info[ACL_INFO_FIRSTNAME] ? $user_info[ACL_INFO_LASTNAME] . ' ' . $user_info[ACL_INFO_FIRSTNAME] : $this->aclManager->relativeId($user_info[ACL_INFO_USERID]); }
function modTeacherPublicationsGui() { require_once _base_ . '/lib/lib.form.php'; $html = '<div class="up_user_info">' . '<div class="up_name">' . $this->resolveUsername(false, getLogUserId()) . '</div>'; // user standard info ----------------------------------------------------------------- $html .= Form::openForm('mod_publications', $this->_url_man->getUrl($this->_varname_action . '=save_teach_publ')); $html .= Form::getTextarea($this->_lang->def('_TEACHER_PUBLICATIONS'), 'tp_publications', 'tp_publications', Get::req('tp_publications', DOTY_MIXED, $this->_up_data_man->getTeacherPublications($this->_user_profile->getIdUser()))); $html .= Form::openButtonSpace() . Form::getButton('save', 'save', $this->_lang->def('_SAVE')) . Form::getButton('undo', 'undo', $this->_lang->def('_UNDO')) . Form::closeButtonSpace(); $html .= Form::closeForm() . '</div>'; return $html; }
function booking() { require_once $GLOBALS['where_scs'] . '/lib/lib.booking.php'; $lang =& DoceboLanguage::createInstance('conference', 'lms'); $room_id = Get::req('id', DOTY_INT, 0); $booking = new RoomBooking(); $result = $booking->bookRoom(getLogUserId(), $room_id); Util::jump_to('index.php?modname=conference&op=list&result=' . ($result ? 'ok' : 'err')); }
function delfriend(&$url) { checkPerm('view'); require_once $GLOBALS['where_framework'] . '/lib/lib.myfriends.php'; $lang =& DoceboLanguage::createInstance('myfriends', 'lms'); $my_fr = new MyFriends(getLogUserId()); $id_friend = importVar('id_friend', true, 0); $GLOBALS['page']->add(getTitleArea(array($url->getUrl() => $lang->def('_MY_FRIENDS'), $lang->def('_REMOVE_FRIEND')), 'myfriends') . '<div class="std_block">', 'content'); if (isset($_GET['confirm'])) { if ($my_fr->delFriend($id_friend)) { Util::jump_to($url->getUrl('result=ok_del')); } $GLOBALS['page']->add(getErrorUi($lang->def('_ERR_REMOVE_FRIEND'))); } $ui = $my_fr->getFriendsInfo(array($id_friend)); if ($ui == false) { $GLOBALS['page']->add(getErrorUi($lang->def('_INVALID_FRIEND'))); } else { $acl_man =& Docebo::user()->getAclManager(); $ui = current($ui); $GLOBALS['page']->add(getDeleteUi($lang->def('_AREYOUSURE'), '<span>' . $lang->def('_USERNAME') . ' : </span>' . $acl_man->relativeId($ui[ACL_INFO_USERID]) . '<br />' . '<span>' . $lang->def('_USERCOMPLETENAME') . ' : </span>' . $ui[ACL_INFO_LASTNAME] . ($ui[ACL_INFO_LASTNAME] != '' ? ' ' : '') . $ui[ACL_INFO_FIRSTNAME], true, $url->getUrl('op=delfriend&id_friend=' . $id_friend . '&confirm=1'), $url->getUrl()), 'content'); } $GLOBALS['page']->add('</div>', 'content'); }
if (!$ma->currentCanAccessObj('tb_elearning')) { Util::jump_to('index.php?r=lms/classroom/show'); } Util::jump_to('index.php?r=' . _after_login_); } // end login } } else { Util::jump_to('../index.php'); } } break; case "logout": require_once $GLOBALS['where_lms'] . '/lib/lib.track_user.php'; if (!Docebo::user()->isAnonymous() && isset($_SESSION['idCourse'])) { TrackUser::setActionTrack(getLogUserId(), $_SESSION['idCourse'], '', ''); } //i need to save the language of the user in order to use it again after logout $language = Lang::get(); if (!Docebo::user()->isAnonymous()) { TrackUser::logoutSessionCourseTrack(); $_SESSION = array(); session_destroy(); // load standard language module and put it global $glang =& DoceboLanguage::createInstance('standard', 'framework'); // Recreate Anonymous user $GLOBALS['current_user'] =& DoceboUser::createDoceboUserFromSession('public_area'); $GLOBALS['logout'] = true; require_once _base_ . '/lib/lib.platform.php'; $pm =& PlatformManager::createInstance(); $pm->doCommonOperations("logout");
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'); }
public function subscribeUserToEdition($id_user, $id_course, $id_edition, $level, $waiting, $date_begin_validity = false, $date_expire_validity = false) { require_once _lms_ . '/lib/lib.subscribe.php'; $subscribe_man = new CourseSubscribe_Manager(); if (!$subscribe_man->controlSubscription($id_user, $id_course)) { $subscribe_man->subscribeUserToCourse($id_user, $id_course, $level, $waiting, $date_begin_validity = false, $date_expire_validity = false); } else { $subscribe_man->updateForNewDateSubscribe($id_user, $id_course, $waiting); } return $this->addUserToEdition($id_edition, $id_user, getLogUserId()); }
function HomeDirDb($idUser = NULL) { $this->table = $GLOBALS['prefix_lms'] . '_homerepo_dir'; $this->fields = array('id' => 'id', 'idParent' => 'idParent', 'path' => 'path', 'lev' => 'lev'); if ($idUser === NULL) { $this->hd_idUser = getLogUserId(); } else { $this->hd_idUser = $idUser; } }
public function disconnectAccount($network, $user_idst = false) { $res = false; $user_idst = $user_idst > 0 ? $user_idst : getLogUserId(); switch ($network) { case "facebook": $field = 'facebook_id'; break; case "twitter": $field = 'twitter_id'; break; case "linkedin": $field = 'linkedin_id'; break; case "google": $field = 'google_id'; break; } if (!empty($field)) { $db = DbConn::getInstance(); $qtxt = "UPDATE %adm_user SET " . $field . " = NULL WHERE idst=" . $user_idst . " LIMIT 1"; $res = $db->query($qtxt); } return $res; }
function loadBody() { global $op, $modname; if ($this->treeView === NULL) { $this->initialize(); } switch ($this->treeView->op) { case "import": import($this->treeView); break; case 'createLO': global $modname; // save state require_once $GLOBALS['where_framework'] . '/lib/lib.sessionsave.php'; $saveObj = new Session_Save(); $saveName = $saveObj->getName('homerepo' . getLogUserId(), true); $saveObj->save($saveName, $this->treeView->getState()); $GLOBALS['page']->add($this->treeView->LOSelector($modname, 'index.php?modname=' . $modname . '&op=display&shr=' . $saveName . '&' . $this->treeView->_getOpCreateLOEnd() . '=1'), 'content'); break; case 'createLOSel': global $modname; // save state require_once $GLOBALS['where_framework'] . '/lib/lib.sessionsave.php'; $saveObj = new Session_Save(); $saveName = $saveObj->getName('homerepo' . getLogUserId(), true); $saveObj->save($saveName, $this->treeView->getState()); // start learning object creation $lo = createLO($_POST['radiolo']); $lo->create('index.php?modname=' . $modname . '&op=display&shr=' . $saveName . '&' . $this->treeView->_getOpCreateLOEnd() . '=1'); break; case 'editLO': global $modname; // save state require_once $GLOBALS['where_framework'] . '/lib/lib.sessionsave.php'; $saveObj = new Session_Save(); $saveName = $saveObj->getName('homerepo' . getLogUserId(), true); $saveObj->save($saveName, $this->treeView->getState()); $folder = $this->repoDb->getFolderById($this->treeView->getSelectedFolderId()); $lo = createLO($folder->otherValues[REPOFIELDOBJECTTYPE]); $lo->edit($folder->otherValues[REPOFIELDIDRESOURCE], 'index.php?modname=' . $modname . '&op=display&shr=' . $saveName . '&' . $this->treeView->_getOpEditLOEnd() . '=1'); break; case 'playitem': global $modname; // save state require_once $GLOBALS['where_framework'] . '/lib/lib.sessionsave.php'; $saveObj = new Session_Save(); $saveName = $saveObj->getName('homerepo' . getLogUserId(), true); $saveObj->save($saveName, $this->treeView->getState()); $folder = $this->repoDb->getFolderById($this->treeView->getItemToPlay()); $lo = createLO($folder->otherValues[REPOFIELDOBJECTTYPE]); $idItem = $folder->otherValues[REPOFIELDIDRESOURCE]; $back_url = 'index.php?modname=' . $modname . '&op=homerepo&shr=' . $saveName . '&' . $this->treeView->_getOpPlayEnd() . '=' . $folder->id; $lo->play($idItem, NULL, $back_url); break; case 'copyLOSel': $GLOBALS['page']->add($this->treeView->load()); break; case 'copyLOEndOk': case 'copyLOEndCancel': global $modname; require_once $GLOBALS['where_framework'] . '/lib/lib.sessionsave.php'; $saveObj = new Session_Save(); $saveName = $_GET['crepo']; if ($saveObj->nameExists($saveName)) { $saveData =& $saveObj->load($saveName); $saveObj->delete($saveName); Util::jump_to(' index.php?modname=' . $modname . '&op=' . $saveData['repo']); } Util::jump_to(' index.php?modname=' . $modname . '&op=display'); break; case 'copyLO': global $modname; // save state require_once $GLOBALS['where_framework'] . '/lib/lib.sessionsave.php'; $saveObj = new Session_Save(); $saveName = $saveObj->getName('crepo', true); $folder = $this->treeView->tdb->getFolderById($this->treeView->selectedFolder); $saveData = array('repo' => 'homerepo', 'id' => $this->treeView->getSelectedFolderId(), 'objectType' => $folder->otherValues[REPOFIELDOBJECTTYPE], 'name' => $folder->getFolderName(), 'idResource' => $folder->otherValues[REPOFIELDIDRESOURCE]); $saveObj->save($saveName, $saveData); Util::jump_to(' index.php?modname=' . $modname . '&op=display&crepo=' . $saveName . '&' . $this->treeView->_getOpCopyLOSel() . '=1'); case 'createLOEnd': // insertion managed by extendParsing // insertion managed by extendParsing case "display": case "homerepo": default: /*$GLOBALS['page']->addStart( getTitleArea(Lang::t('_HOMEREPO', 'homerepo', 'lms'), 'homerepo') .'<div class="std_block">', 'content'); $GLOBALS['page']->addEnd('</div>', 'content'); if( isset($_SESSION['last_error']) ) if( $_SESSION['last_error'] != "" ) { $GLOBALS['page']->add( $_SESSION['last_error'], 'content' ); unset( $_SESSION['last_error'] ); }*/ homerepo($this->treeView); break; } }
function getUserCurrentSessionCourseTime($id_course) { if (isset($_SESSION['is_ghost']) && $_SESSION['is_ghost'] === true) { return 0; } if (isset($_SESSION['id_enter_course'])) { $query_time = "\r\n\t\t\tSELECT UNIX_TIMESTAMP(enterTime)\r\n\t\t\tFROM " . $GLOBALS['prefix_lms'] . "_tracksession \r\n\t\t\tWHERE idCourse = '" . $id_course . "' AND idUser = '******' \r\n\t\t\t\tAND idEnter = '" . $_SESSION['id_enter_course'] . "'"; list($partial_time) = sql_fetch_row(sql_query($query_time)); return time() - $partial_time; } else { return false; } }
function extendedParsing($arrayState, $arrayExpand, $arrayCompress) { $this->selection_parseInput($arrayState); if (isset($arrayState[$this->_getOpCreateLO()])) { $this->op = 'createLO'; } elseif (isset($arrayState[$this->_getOpCreateLOSel()])) { $this->op = 'createLOSel'; $this->creatingObjectType = $_POST['radiolo']; } elseif (isset($_GET[$this->_getOpCreateLOEnd()])) { // get result and id resource $this->op = 'createLOEnd'; if (isset($_GET['create_result'])) { if ($_GET['create_result'] == '1') { $idResource = (int) $_GET['id_lo']; $lo = createLO($this->creatingObjectType, $idResource); $this->tdb->addItem($this->getSelectedFolderId(), $lo->getTitle(), $this->creatingObjectType, $idResource, 0, 0, getLogUserId(), '1.0', '_DIFFICULT_MEDIUM', '', '', '', '', date("Y-m-d H:i:s")); $this->refresh = TRUE; } elseif ($_GET['create_result'] == '2') { $idMultiResource = (int) $_GET['id_lo']; $multiLo = createLO($this->creatingObjectType); $arrIdResources = $multiLo->getMultipleResource($idMultiResource); foreach ($arrIdResources as $idResource) { $lo = createLO($this->creatingObjectType, $idResource); $this->tdb->addItem($this->getSelectedFolderId(), $lo->getTitle(), $this->creatingObjectType, $idResource, 0, 0, getLogUserId(), '1.0', '_DIFFICULT_MEDIUM', '', '', '', '', date("Y-m-d H:i:s")); } $this->refresh = TRUE; } } } elseif (isset($arrayState[$this->_getOpEditLO()])) { $this->op = 'editLO'; } elseif (isset($_GET[$this->_getOpEditLOEnd()])) { $this->op = 'editLOEnd'; } elseif (isset($arrayState[$this->_getOpCopyLO()])) { $this->op = 'copyLO'; } elseif (isset($_GET[$this->_getOpCopyLOSel()])) { $this->op = 'copyLOSel'; } elseif (isset($_GET[$this->_getOpPlayEnd()])) { $this->op = 'itemdone'; } if (isset($arrayState[$this->_getOpCopyLOEndOk()])) { // op now can be copyLOSel, but we override it require_once $GLOBALS['where_framework'] . '/lib/lib.sessionsave.php'; $saveObj = new Session_Save(); $saveName = $_GET['crepo']; if ($saveObj->nameExists($saveName)) { $saveData =& $saveObj->load($saveName); $lo = createLO($saveData['objectType']); $idResource = $lo->copy((int) $saveData['idResource']); if ($idResource != 0) { $lo = createLO($saveData['objectType']); $this->tdb->addItem($this->getSelectedFolderId(), $saveData['name'], $saveData['objectType'], $idResource, 0, 0, getLogUserId(), '1.0', '_DIFFICULT_MEDIUM', '', '', '', '', date("Y-m-d H:i:s")); $this->refresh = TRUE; } } $this->op = 'copyLOEndOk'; } elseif (isset($arrayState[$this->_getOpCopyLOEndCancel()])) { // op now can be copyLOSel, but we override it $this->op = 'copyLOEndCancel'; } if (isset($arrayState[$this->id])) { foreach ($arrayState[$this->id] as $key => $action) { if ($key == $this->_getOpPropertiesId()) { if (is_array($action)) { $id = key($action); $this->op = 'properties'; $this->opContextId = $id; } } elseif ($key == $this->_getOpEditLOId()) { if (is_array($action)) { $id = key($action); if ($id > 0) { $this->op = 'editLO'; $this->selectedFolder = $id; } } } elseif ($key == $this->_getOpCopyLOId()) { if (is_array($action)) { $id = key($action); if ($id > 0) { $this->op = 'copyLO'; $this->selectedFolder = $id; } } } } } foreach ($arrayState as $nameField => $valueField) { if (strstr($nameField, $this->_getOpPropertiesId())) { $id = substr($nameField, strlen($this->_getOpPropertiesId())); $this->op = 'properties'; $this->opContextId = $id; } else { if (strstr($nameField, $this->_getOpEditLOId())) { $id = substr($nameField, strlen($this->_getOpEditLOId())); if (strlen($id) > 0) { $this->op = 'editLO'; $this->selectedFolder = $id; } } else { if (strstr($nameField, $this->_getOpCopyLOId())) { $id = substr($nameField, strlen($this->_getOpCopyLOId())); if (strlen($id) > 0) { $this->op = 'copyLO'; $this->selectedFolder = $id; } } } } } if ($this->pathToExpand != NULL) { if (is_array($this->expandList)) { $this->expandList = $this->expandList + $this->pathToExpand; } else { $this->expandList = $this->pathToExpand; } } }