function JQ_ViewAnswersSurvey($option, $course_id, $quiz_id, $quest_id) { global $JLMS_DB, $Itemid; $group_id = intval(mosGetParam($_REQUEST, 'group_id', 0)); // echo '<pre>'; // print_r($_POST); // echo '</pre>'; if ($group_id) { $query = "SELECT b.user_id FROM #__lms_users_in_global_groups as b, #__lms_users_in_groups as c"; $query .= "\n WHERE b.user_id = c.user_id AND c.course_id = '" . $course_id . "'"; $query .= "\n AND b.group_id = '" . $group_id . "'"; } else { $query = "SELECT c.user_id FROM #__lms_users_in_groups as c"; $query .= "\n WHERE c.course_id = '" . $course_id . "'"; } $JLMS_DB->setQuery($query); $user_in_groups = $JLMS_DB->loadResultArray(); $str_user_in_groups = '0'; if (count($user_in_groups)) { $str_user_in_groups = implode(",", $user_in_groups); } $query = "SELECT c_question FROM #__lms_quiz_t_question WHERE c_id = '" . $quest_id . "' AND c_quiz_id = '" . $quiz_id . "'"; $JLMS_DB->setQuery($query); $question = $JLMS_DB->loadResult(); $query = "SELECT c.* FROM #__lms_quiz_r_student_quiz as a, #__lms_quiz_r_student_question as q, #__lms_quiz_r_student_survey as c"; $query .= "\n WHERE q.c_id = c.c_sq_id AND q.c_question_id = '" . $quest_id . "'"; $query .= "\n AND a.c_id = q.c_stu_quiz_id"; if ($group_id) { $query .= "\n AND a.c_student_id IN (" . $str_user_in_groups . ")"; } $JLMS_DB->setQuery($query); $total_answers = $JLMS_DB->loadObjectList(); // echo '<pre>'; // print_r($total_count); // print_r($total_answers); // echo '</pre>'; $lists = array(); $javascript = 'onchange="if(document.adminFormQ.quiz_id.value != 0){document.adminFormQ.submit();}"'; $query = "SELECT id as value, ug_name as text FROM #__lms_usergroups WHERE course_id = '0'"; $JLMS_DB->setQuery($query); $showgroups = array(); $showgroups[] = mosHTML::makeOption('0', 'All Courses'); $showgroups = array_merge($showgroups, $JLMS_DB->loadObjectList()); $lists['showgroups'] = mosHTML::selectList($showgroups, 'group_id', 'class="inputbox" size="1" ' . $javascript, 'value', 'text', $group_id); $extra = $group_id ? "&group_id=" . $group_id . "" : ''; $link_back = sefRelToAbs("index.php?option=" . $option . "&Itemid=" . $Itemid . "&task=quizzes&page=quiz_bars&id=" . $course_id . "&quiz_id=" . $quiz_id . "" . $extra); JLMS_quiz_admin_html_class::JQ_ShowAnswersSurvey($lists, $total_answers, $course_id, $quiz_id, $quest_id, $question, $link_back, $option); }