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>');
}
}
