function JQ_printCertificate()
{
global $JLMS_DB, $my, $JLMS_CONFIG;
global $JLMS_LANGUAGE, $JLMS_CONFIG;
JLMS_require_lang($JLMS_LANGUAGE, 'quiz.lang', $JLMS_CONFIG->get('default_language'));
require _JOOMLMS_FRONT_HOME . '/includes/quiz/quiz_language.php';
global $jq_language;
$stu_quiz_id = intval(mosGetParam($_GET, 'stu_quiz_id', 0));
$user_unique_id = strval(mosGetParam($_GET, 'user_unique_id', ''));
$course_id = $JLMS_CONFIG->get('course_id', 0);
$query = "SELECT sq.c_passed, sq.c_student_id, sq.c_total_score, sq.unique_id, sq.c_date_time as completion_datetime," . "\n qtq.c_full_score, qtq.c_title, qtq.c_certificate, qtq.course_id, qtq.c_id as quiz_id, qtq.course_id" . "\n FROM #__lms_quiz_r_student_quiz AS sq, #__lms_quiz_t_quiz AS qtq" . "\n WHERE sq.c_id = '" . $stu_quiz_id . "' and qtq.c_id = sq.c_quiz_id";
$JLMS_DB->SetQuery($query);
$stu_quiz = $JLMS_DB->LoadObjectList();
if (count($stu_quiz) && $course_id) {
$stu_quiz = $stu_quiz[0];
$query = "SELECT course_id FROM #__lms_quiz_t_quiz WHERE c_id = '" . $stu_quiz->quiz_id . "'";
$JLMS_DB->SetQuery($query);
$quiz_course = $JLMS_DB->LoadResult();
if ($user_unique_id == $stu_quiz->unique_id && $quiz_course == $course_id) {
$JLMS_ACL =& JLMSFactory::getACL();
$i_can_view_these_results = false;
if ($my->id == $stu_quiz->c_student_id) {
// user who passed the quiz
$i_can_view_these_results = true;
} elseif ($JLMS_ACL->isCourseTeacher()) {
// course teacher
$i_can_view_these_results = true;
} elseif ($JLMS_ACL->isStaff() && isset($JLMS_ACL->_staff_learners) && is_array($JLMS_ACL->_staff_learners) && in_array($stu_quiz->c_student_id, $JLMS_ACL->_staff_learners)) {
//users CEO
$i_can_view_these_results = true;
}
if ($i_can_view_these_results) {
$user_id = $stu_quiz->c_student_id;
if ($stu_quiz->c_passed != 1) {
echo $jq_language['quiz_mes_notpassed'];
die;
}
if (!$stu_quiz->c_certificate) {
echo $jq_language['quiz_mes_notavail'];
die;
}
require_once _JOOMLMS_FRONT_HOME . "/includes/lms_certificates.php";
$query = "SELECT * FROM #__users WHERE id = '" . $user_id . "'";
$JLMS_DB->SetQuery($query);
$u_data = $JLMS_DB->LoadObjectList();
$tm_obj = new stdClass();
$tm_obj->username = isset($u_data[0]->username) ? $u_data[0]->username : '';
$tm_obj->name = isset($u_data[0]->name) ? $u_data[0]->name : '';
$tm_obj->crtf_spec_answer = '';
$course_id = $stu_quiz->course_id;
$tm_obj->is_preview = false;
$tm_obj->quiz_id = $stu_quiz->quiz_id;
$tm_obj->quiz_name = $stu_quiz->c_title;
$tm_obj->stu_quiz_id = $stu_quiz_id;
$tm_obj->crtf_date = strtotime($stu_quiz->completion_datetime);
$user = new stdClass();
$user->id = isset($u_data[0]->id) ? $u_data[0]->id : 0;
$user->username = isset($u_data[0]->username) ? $u_data[0]->username : '';
$user->name = isset($u_data[0]->name) ? $u_data[0]->name : '';
$user->email = isset($u_data[0]->email) ? $u_data[0]->email : '';
JLMS_Certificates::JLMS_outputCertificate($stu_quiz->c_certificate, $stu_quiz->course_id, $tm_obj, $user);
}
}
}
echo $jq_language['quiz_mes_notavail'];
}
