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