function JQ_view_questReport($id, $option, $page, $course_id)
{
global $JLMS_DB;
$query = "SELECT q.c_type, q.c_id,q.c_image, sq.c_stu_quiz_id, q.c_question, q.c_pool, q.c_pool_gqp FROM #__lms_quiz_t_question as q, #__lms_quiz_r_student_question as sq" . "\n WHERE q.c_id = sq.c_question_id and sq.c_id = '" . $id . "'";
$JLMS_DB->SetQuery($query);
$q_data = $JLMS_DB->LoadObjectList();
$lists = array();
if (count($q_data)) {
$q_type = $q_data[0]->c_type;
$q_id = $q_data[0]->c_id;
$qid = $q_data[0]->c_stu_quiz_id;
if ($q_type == 20) {
$query = "SELECT * FROM #__lms_quiz_t_question WHERE c_id = " . $q_data[0]->c_pool;
$JLMS_DB->SetQuery($query);
$rtrtr = $JLMS_DB->LoadObject();
if (is_object($rtrtr)) {
$q_id = $rtrtr->c_id;
$q_type = $rtrtr->c_type;
$q_data[0]->c_question = $rtrtr->c_question;
}
}
if ($q_type == 21) {
$query = "SELECT * FROM #__lms_quiz_t_question WHERE c_id = " . $q_data[0]->c_pool_gqp;
$JLMS_DB->SetQuery($query);
$rtrtr = $JLMS_DB->LoadObject();
if (is_object($rtrtr)) {
$q_id = $rtrtr->c_id;
$q_type = $rtrtr->c_type;
$q_data[0]->c_question = $rtrtr->c_question;
}
}
$query = "SELECT u.username, u.name, u.email, u.id FROM #__users as u, #__lms_quiz_r_student_quiz as q WHERE q.c_id = '" . $qid . "'" . "\n and q.c_student_id = u.id";
$JLMS_DB->SetQuery($query);
$user_info = $JLMS_DB->LoadObjectList();
$group = '';
$user_id = isset($user_info[0]->id) ? $user_info[0]->id : 0;
if ($user_id) {
$query = "SELECT a.ug_name FROM #__lms_usergroups as a, #__lms_users_in_groups as b" . "\n WHERE b.course_id = '" . $course_id . "' AND b.user_id = '" . $user_id . "' AND b.group_id = a.id";
$JLMS_DB->SetQuery($query);
$group = $JLMS_DB->LoadResult();
}
if (count($user_info)) {
$lists['user'] = $user_info[0];
} else {
$lists['user']->username = "******";
$lists['user']->name = " - ";
$lists['user']->email = " - ";
}
$lists['user']->usergroup = $group;
switch ($q_type) {
case 1:
case 2:
case 3:
$query = "SELECT c.*, sc.c_id as sc_id FROM #__lms_quiz_t_choice as c LEFT JOIN #__lms_quiz_r_student_choice as sc ON c.c_id = sc.c_choice_id" . "\n and sc.c_sq_id = '" . $id . "'" . "\n WHERE c.c_question_id = '" . $q_id . "'" . "\n ORDER BY c.ordering, c.c_id";
$JLMS_DB->SetQuery($query);
$answer = $JLMS_DB->LoadObjectList();
$lists['id'] = $id;
$lists['qid'] = $qid;
$lists['question'] = $q_data[0]->c_question;
JLMS_quiz_admin_html_class::JQ_view_questionReport(1, $answer, $option, $page, $course_id, $lists);
break;
case 4:
case 5:
$query = "SELECT * FROM #__lms_quiz_t_matching as m LEFT JOIN #__lms_quiz_r_student_matching as sm" . "\n ON m.c_id = sm.c_matching_id and sm.c_sq_id = '" . $id . "'" . "\n WHERE m.c_question_id = '" . $q_id . "'" . "\n ORDER BY m.ordering, m.c_id";
$JLMS_DB->SetQuery($query);
$answer = $JLMS_DB->LoadObjectList();
$lists['id'] = $id;
$lists['qid'] = $qid;
$lists['question'] = $q_data[0]->c_question;
JLMS_quiz_admin_html_class::JQ_view_questionReport(4, $answer, $option, $page, $course_id, $lists);
break;
case 6:
$query = "SELECT * FROM #__lms_quiz_r_student_blank WHERE c_sq_id = '" . $id . "'";
$JLMS_DB->SetQuery($query);
$answer = $JLMS_DB->LoadObjectList();
if (!count($answer)) {
$answer = array();
$answer[0]->c_answer = '';
}
$lists['id'] = $id;
$lists['qid'] = $qid;
$lists['question'] = $q_data[0]->c_question;
JLMS_quiz_admin_html_class::JQ_view_questionReport(6, $answer[0], $option, $page, $course_id, $lists);
break;
case 7:
$query = "SELECT * FROM #__lms_quiz_r_student_hotspot WHERE c_sq_id = '" . $id . "'";
$JLMS_DB->SetQuery($query);
$answer = $JLMS_DB->LoadObjectList();
if (!count($answer)) {
$answer = array();
$answer[0]->c_select_x = 0;
$answer[0]->c_select_y = 0;
}
$lists['id'] = $id;
$lists['qid'] = $qid;
$lists['question'] = $q_data[0]->c_question;
$query = "SELECT * FROM #__lms_quiz_t_hotspot WHERE c_question_id = '" . $q_id . "'";
$JLMS_DB->SetQuery($query);
$hotspot = $JLMS_DB->LoadObjectList();
if (!count($hotspot)) {
$hotspot = array();
$hotspot[0]->c_start_x = 0;
$hotspot[0]->c_start_y = 0;
$hotspot[0]->c_width = 0;
$hotspot[0]->c_height = 0;
}
$lists['image'] = $q_data[0]->c_image;
$lists['hotspot'] = $hotspot[0];
JLMS_quiz_admin_html_class::JQ_view_questionReport(7, $answer[0], $option, $page, $course_id, $lists);
break;
case 8:
$query = "SELECT * FROM #__lms_quiz_r_student_survey WHERE c_sq_id = '" . $id . "'";
$JLMS_DB->SetQuery($query);
$answer = $JLMS_DB->LoadObjectList();
if (!count($answer)) {
$answer = array();
$answer[0]->c_answer = '';
}
$lists['id'] = $id;
$lists['qid'] = $qid;
$lists['question'] = $q_data[0]->c_question;
JLMS_quiz_admin_html_class::JQ_view_questionReport(6, $answer[0], $option, $page, $course_id, $lists);
break;
case 9:
$query = "SELECT * FROM #__lms_quiz_r_student_scale WHERE c_sq_id = '" . $id . "'";
$JLMS_DB->SetQuery($query);
$lists['id'] = $id;
$lists['qid'] = $qid;
$lists['question'] = $q_data[0]->c_question;
$answers = $JLMS_DB->LoadObjectList();
$answer = array();
for ($p = 0; $p < count($answers); $p++) {
$answer[$p][0] = $answers[$p]->q_scale_id;
$answer[$p][1] = $answers[$p]->scale_id;
}
$query = "SELECT * FROM #__lms_quiz_t_scale WHERE c_question_id = '" . $q_id . "'" . "\n ORDER BY ordering";
$JLMS_DB->SetQuery($query);
$scale_data = $JLMS_DB->LoadObjectList();
for ($i = 0; $i < count($scale_data); $i++) {
$scale_data[$i]->inchek = '';
foreach ($answer as $uansw) {
if ($uansw[0] == $scale_data[$i]->c_id) {
$scale_data[$i]->inchek = $uansw[1];
}
}
}
JLMS_quiz_admin_html_class::JQ_view_questionReport(9, $scale_data, $option, $page, $course_id, $lists);
break;
}
} else {
$stu_id = intval(mosGetParam($_REQUEST, 'stu_id', 0));
JLMSRedirect(sefRelToAbs("index.php?option={$option}&Itemid={$Itemid}&task=quizzes&id={$course_id}&page=stu_reportA&c_id={$stu_id}"));
#JLMS_quiz_admin_html_class::JQ_view_BlankFormPage( $option, $page, $course_id, $stu_id );
}
}
