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