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>');
}
}
public function certificate()
{
if (!$this->permissions['mod']) {
$this->render('invalid', array('message' => $this->_getErrorMessage('no permission'), 'back_url' => 'index.php?r=' . $this->base_link_course . '/show'));
return;
}
if (isset($_POST['undo'])) {
Util::jump_to('index.php?r=' . $this->base_link_course . '/show');
}
require_once _lms_ . '/lib/lib.certificate.php';
$cert = new Certificate();
$id_course = Get::req('id_course', DOTY_INT, 0);
if (isset($_POST['assign'])) {
$point_required = Get::req('point_required', DOTY_INT, 0);
// , $list_of_assign_obj, $list_of_who
if (!$cert->updateCertificateCourseAssign($id_course, $_POST['certificate_assign'], $_POST['certificate_ex_assign'], $point_required)) {
Util::jump_to('index.php?r=' . $this->base_link_course . '/show&err=_up_cert_err');
}
Util::jump_to('index.php?r=' . $this->base_link_course . '/show&res=_up_cert_ok');
} else {
require_once _base_ . '/lib/lib.table.php';
$all_languages = Docebo::langManager()->getAllLanguages(true);
$languages = array();
foreach ($all_languages as $k => $v) {
$languages[$v['code']] = $v['description'];
}
$query = "SELECT code, name, course_type" . " FROM %lms_course WHERE idCourse = '" . $id_course . "'";
$course = sql_fetch_array(sql_query($query));
$tb = new Table(false, Lang::t('_TITLE_CERTIFICATE_TO_COURSE', 'course'), Lang::t('_TITLE_CERTIFICATE_TO_COURSE', 'course'));
$certificate_list = $cert->getCertificateList();
$course_cert = $cert->getCourseCertificate($id_course);
$course_ex_cert = $cert->getCourseExCertificate($id_course);
$released = $cert->numOfcertificateReleasedForCourse($id_course);
$point_required = $cert->getPointRequiredForCourse($id_course);
$possible_status = array(AVS_NOT_ASSIGNED => Lang::t('_NOT_ASSIGNED', 'course'), AVS_ASSIGN_FOR_ALL_STATUS => Lang::t('_ASSIGN_FOR_ALL_STATUS', 'course'), AVS_ASSIGN_FOR_STATUS_INCOURSE => Lang::t('_ASSIGN_FOR_STATUS_INCOURSE', 'course'), AVS_ASSIGN_FOR_STATUS_COMPLETED => Lang::t('_ASSIGN_FOR_STATUS_COMPLETED', 'course'));
$type_h = array('nowrap', 'nowrap', '', '', 'image');
$cont_h = array(Lang::t('_TITLE', 'course'), Lang::t('_CERTIFICATE_LANGUAGE', 'course'), Lang::t('_CERTIFICATE_ASSIGN_STATUS', 'course'), Lang::t('_CERTIFICATE_EX_ASSIGN_STATUS', 'course'), Lang::t('_CERTIFICATE_RELEASED', 'course'));
$tb->setColsStyle($type_h);
$tb->addHead($cont_h);
$view_cert = false;
if (Docebo::user()->getUserLevelId() != ADMIN_GROUP_GODADMIN) {
if (checkPerm('view', true, 'certificate', 'lms') || checkPerm('view', true, 'pcertificate', 'lms')) {
$view_cert = true;
}
} else {
$view_cert = true;
}
while (list($id_cert, $cert) = each($certificate_list)) {
$cont = array();
$cont[] = '<label for="certificate_assign_' . $id_cert . '">' . $cert[CERT_NAME] . '</label>';
$cont[] = isset($languages[$cert[CERT_LANG]]) ? $languages[$cert[CERT_LANG]] : $cert[CERT_LANG];
//lang description?
$cont[] = Form::getInputDropdown('dropdown_nowh', 'certificate_assign_' . $id_cert, 'certificate_assign[' . $id_cert . ']', $possible_status, isset($course_cert[$id_cert]) ? $course_cert[$id_cert] : 0, '');
$cont[] = Form::getInputDropdown('dropdown_nowh', 'certificate_ex_assign_' . $id_cert, 'certificate_ex_assign[' . $id_cert . ']', $possible_status, isset($course_ex_cert[$id_cert]) ? $course_ex_cert[$id_cert] : 0, '');
$cont[] = (isset($course_cert[$id_cert]) && $course_cert[$id_cert] != 0 && $view_cert ? '<a href="index.php?modname=' . (Docebo::user()->getUserLevelId() == ADMIN_GROUP_PUBLICADMIN ? 'p' : '') . 'certificate&op=view_report_certificate&id_certificate=' . $id_cert . '&id_course=' . $id_course . '&from=course&of_platform=lms">' : '') . (isset($released[$id_cert]) ? $released[$id_cert] : '0') . (isset($course_cert[$id_cert]) && $course_cert[$id_cert] != 0 ? '</a>' : '');
$tb->addBody($cont);
}
$course_info = $this->model->getInfo($id_course);
$course_name = ($course_info['code'] !== '' ? '[' . $course_info['code'] . '] ' : '') . $course_info['name'];
$this->render('certificate', array('id_course' => $id_course, 'tb' => $tb, 'point_required' => $point_required, 'base_link_course' => $this->base_link_course, 'course_name' => $course_name));
}
}
