function updateTestReport($id_tests)
{
$test_man = new GroupTestManagement();
$tests_list = $test_man->getTestInfo($id_tests);
while (list($id_test, $test_info) = each($tests_list)) {
$query_test = "\r\n\t\t\tUPDATE " . $GLOBALS['prefix_lms'] . "_coursereport \r\n\t\t\tSET required_score = '" . $test_info['point_required'] . "' " . ($test_info['order_type'] != 2 ? ", " . " max_score = '" . $test_man->getMaxScore($id_test) . "' " : '') . ", " . " required_score = " . $test_man->getRequiredScore($id_test) . " " . " WHERE id_course = '" . $_SESSION['idCourse'] . "' AND \r\n\t\t\t\tsource_of = 'test' AND \r\n\t\t\t\tid_source = '" . $id_test . "'";
sql_query($query_test);
}
}
function coursereport()
{
global $nquest;
global $course_score, $course_score_max;
global $test_title;
checkPerm('view');
require_once $GLOBALS['where_lms'] . '/lib/lib.test.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.coursereport.php';
require_once _base_ . '/lib/lib.table.php';
$lang =& DoceboLanguage::createInstance('gradebook', 'lms');
$out =& $GLOBALS['page'];
$out->setWorkingZone('content');
$test_man = new GroupTestManagement();
$report_man = new CourseReportManager();
// XXX: update if needed
$org_tests =& $report_man->getTest();
$tests_info =& $test_man->getTestInfo($org_tests);
$i_test = array();
$i_test_report_id = array();
// XXX: Info for updates
$query_tot_report = "\r\n\tSELECT COUNT(*)\r\n\tFROM " . $GLOBALS['prefix_lms'] . "_coursereport\r\n\tWHERE id_course = '" . $_SESSION['idCourse'] . "'";
list($tot_report) = sql_fetch_row(sql_query($query_tot_report));
$query_tests = "\r\n\tSELECT id_report, id_source\r\n\tFROM " . $GLOBALS['prefix_lms'] . "_coursereport\r\n\tWHERE id_course = '" . $_SESSION['idCourse'] . "' AND source_of = 'test'";
$re_tests = sql_query($query_tests);
while (list($id_r, $id_t) = sql_fetch_row($re_tests)) {
$i_test[$id_t] = $id_t;
$i_test_report_id[$id_r] = $id_r;
}
// XXX: Update if needed
if ($tot_report == 0) {
$report_man->initializeCourseReport($org_tests);
} else {
if (is_array($i_test)) {
$test_to_add = array_diff($org_tests, $i_test);
} else {
$test_to_add = $org_tests;
}
if (is_array($i_test)) {
$test_to_del = array_diff($i_test, $org_tests);
} else {
$test_to_del = $org_tests;
}
if (!empty($test_to_add) || !empty($test_to_del)) {
$report_man->addTestToReport($test_to_add, 1);
$report_man->delTestToReport($test_to_del);
$included_test = $org_tests;
}
}
$report_man->updateTestReport($org_tests);
$reports = array();
$id_test = array();
$id_report = array();
$tests = array();
// XXX: retrive all report info
$query_report = "\r\n\tSELECT id_report, title, max_score, required_score, weight, show_to_user, use_for_final, source_of, id_source\r\n\tFROM " . $GLOBALS['prefix_lms'] . "_coursereport\r\n\tWHERE id_course = '" . $_SESSION['idCourse'] . "' AND show_to_user = '******'\r\n\tORDER BY sequence ";
$re_report = sql_query($query_report);
while ($info_report = mysql_fetch_assoc($re_report)) {
switch ($info_report['source_of']) {
case "test":
$id_test[] = $info_report['id_source'];
break;
}
}
$id_user = getLogUserId();
if (count($id_test)) {
$title = $GLOBALS['course_descriptor']->getValue('name');
$username = Docebo::user()->getUserName();
$GLOBALS['page']->add(getTitleArea($lang->def('_GRADEBOOK_AREATITLE'), 'gradebook') . '<div class="std_block">' . '<div class="print">' . '<a href="#" onclick="window.print(); return false;">' . '<img src="' . getPathImage() . 'standard/print.gif" alt="' . $lang->def('_PRINT') . '" /> ' . $lang->def('_PRINT') . '</a>' . '</div>' . getBackUi('index.php?modname=gradebook&op=showgrade', $lang->def('_BACK')) . '<div class="title coursereport-title">' . $username . '</div><div class="title coursereport-title">' . $title . '</div>', 'content');
$GLOBALS['page']->add('<div class="coursereport-div"><table class="coursereport-table">' . '<tr><td><strong>' . $lang->def('_TEST_N') . '</strong></td><td><strong>' . $lang->def('_QUESTION') . '</strong></td><td align="right"><strong>' . $lang->def('_SCORE') . '</strong></td></tr>', 'content');
$nquest = 0;
$course_score = 0;
$course_score_max = 0;
$j = 0;
for ($i = 0; $i < count($id_test); $i++) {
$test_title = $tests_info[$id_test[$i]]['title'];
$GLOBALS['page']->add('<tr><td colspan="3"><br /><strong>' . $test_title . '</strong></td></tr>', 'content');
$query_track = "SELECT idTrack FROM " . $GLOBALS['prefix_lms'] . "_testtrack " . "WHERE idTest =" . $id_test[$i] . " AND idUser="******"3" align="right"><strong>' . $lang->def('_TOTAL') . ': ' . $course_score . ' ' . $lang->def('_ON') . ' ' . $course_score_max . ' (' . $perc_course_score . '%)</strong> </td></tr>', 'content');
$GLOBALS['page']->add('</table>', 'content');
/*
if ($perc_course_score<75) {
$msg_feedback=$lang->def('_COURSE_NOT_OK').' '.$lang->def('_COURSE_CHECK_GRAPH');
} else {
$msg_feedback=$lang->def('_COURSE_OK');
}
$GLOBALS['page']->add('<p><strong>'.$msg_feedback.'</strong>', 'content');
*/
$GLOBALS['page']->add('</div>', 'content');
draw_bar($tests);
$GLOBALS['page']->add('</div>', 'content');
}
}
function intro($object_test, $id_param)
{
if (!checkPerm('view', true, 'organization') && !checkPerm('view', true, 'storage')) {
die("You can't access");
}
require_once _base_ . '/lib/lib.form.php';
require_once $GLOBALS['where_lms'] . '/class.module/track.test.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.param.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.test.php';
$lang =& DoceboLanguage::createInstance('test');
$id_test = $object_test->getId();
$id_reference = getLoParam($id_param, 'idReference');
$url_coded = urlencode(serialize($object_test->back_url));
$id_track = retriveTrack($id_reference, $id_test, Docebo::user()->getIdst());
if ($id_track === false) {
$GLOBALS['page']->add(getErrorUi($lang->def('_TEST_TRACK_FAILURE') . getBackUi(Util::str_replace_once('&', '&', $object_test->back_url), $lang->def('_BACK'))), 'content');
}
$track_info = Track_Test::getTrackInfoById($id_track);
$test_man = new TestManagement($id_test);
$play_man = new PlayTestManagement($id_test, Docebo::user()->getIdst(), $id_track, $test_man);
$test_info = $test_man->getTestAllInfo();
$prerequisite = $test_man->getPrerequisite();
$group_test_man = new GroupTestManagement();
$tests_score =& $group_test_man->getTestsScores(array($id_test), array(Docebo::user()->getIdst()));
if ($test_info['time_dependent'] && $test_info['time_assigned']) {
$minute_assigned = (int) ($test_info['time_assigned'] / 60);
$second_assigned = (int) ($test_info['time_assigned'] % 60);
if (strlen($second_assigned) == 1) {
$second_assigned = '0' . $second_assigned;
}
$time_readable = str_replace('[time_assigned]', $minute_assigned . ':' . $second_assigned . '', $lang->def('_TEST_TIME_ASSIGNED'));
$time_readable = str_replace('[second_assigned]', '' . $second_assigned, str_replace('[minute_assigned]', '' . $minute_assigned, $time_readable));
}
$page_title = array(Util::str_replace_once('&', '&', $object_test->back_url) => $lang->def('_TITLE'), $test_info['title']);
$GLOBALS['page']->add(getTitleArea($page_title, 'test', $lang->def('_TEST_INFO')) . '<div class="std_block">' . getBackUi(Util::str_replace_once('&', '&', $object_test->back_url), $lang->def('_BACK')) . '<span class="text_bold">' . $lang->def('_TITLE') . ' : </span>' . $test_info['title'] . '<br /><br />' . ($test_info['description'] != '' ? '<span class="text_bold">' . $lang->def('_DESCRIPTION') . ' : </span>' . $test_info['description'] . '<br /><br />' : '') . (isset($track_info['score']) && $track_info['score'] >= $test_info['point_required'] ? '<span class="text_bold">' . str_replace('[score]', $track_info['score'], $lang->def('_RESTART_INFO')) . '</span><br /><br />' : ''), 'content');
if ($test_info['hide_info'] == 0) {
$GLOBALS['page']->add('<span class="text_bold">' . $lang->def('_TEST_INFO') . ' : </span><br />' . '<ul class="test_info_list">', 'content');
if ($test_info['order_type'] != 2) {
$GLOBALS['page']->add('<li>' . str_replace('[max_score]', '' . ($test_info['point_type'] != 1 ? $test_man->getMaxScore() : 100), $lang->def('_TEST_MAXSCORE')) . '</li>', 'content');
}
$GLOBALS['page']->add('<li>' . str_replace('[question_number]', '' . $test_man->getNumberOfQuestion(), $lang->def('_TEST_QUESTION_NUMBER')) . '</li>', 'content');
if ($test_info['point_required'] != 0) {
$GLOBALS['page']->add('<li>' . str_replace('[score_req]', '' . $test_info['point_required'], $lang->def('_TEST_REQUIREDSCORE')) . '</li>', 'content');
}
$GLOBALS['page']->add('<li>' . ($test_info['save_keep'] ? $lang->def('_TEST_SAVEKEEP') : $lang->def('_TEST_SAVEKEEP_NO')) . '</li>' . '<li>' . ($test_info['mod_doanswer'] ? $lang->def('_TEST_MOD_DOANSWER') : $lang->def('_TEST_MOD_DOANSWER_NO')) . '</li>' . '<li>' . ($test_info['can_travel'] ? $lang->def('_TEST_CAN_TRAVEL') : $lang->def('_TEST_CAN_TRAVEL_NO')) . '</li>' . '<li>' . ($test_info['show_score'] || $test_info['show_score_cat'] ? $lang->def('_TEST_SHOW_SCORE') : $lang->def('_TEST_SHOW_SCORE_NO')) . '</li>' . '<li>' . ($test_info['show_solution'] ? $lang->def('_TEST_SHOW_SOLUTION') : $lang->def('_TEST_SHOW_SOLUTION_NO')) . '</li>' . '<li>', 'content');
switch ($test_info['time_dependent']) {
case 0:
$GLOBALS['page']->add($lang->def('_TEST_TIME_ASSIGNED_NO'), 'content');
break;
case 1:
$GLOBALS['page']->add($time_readable, 'content');
break;
case 2:
$GLOBALS['page']->add($lang->def('_TEST_TIME_ASSIGNED_QUEST'), 'content');
break;
}
if ($test_info['max_attempt'] > 0) {
$GLOBALS['page']->add('<li>' . str_replace('[remaining_attempt]', $test_info['max_attempt'] - $track_info['number_of_attempt'], Lang::t('_NUMBER_OF_ATTEMPT', 'test')) . '</li>', 'content');
}
$GLOBALS['page']->add('</ul>' . '<br />', 'content');
}
if ($tests_score[$id_test][Docebo::user()->getIdst()]['comment'] !== '') {
$GLOBALS['page']->add('<span class="text_bold">' . $lang->def('_COMMENTS') . ' : </span>' . $tests_score[$id_test][Docebo::user()->getIdst()]['comment'] . '<br /><br />', 'content');
}
// Actions
$score_status = $play_man->getScoreStatus();
$show_result = $test_info['show_score'] || $test_info['show_score_cat'] || $test_info['show_solution'];
$is_end = $score_status == 'valid' || $score_status == 'not_checked' || $score_status == 'passed' || $score_status == 'not_passed';
$GLOBALS['page']->add(Form::openForm('test_intro', 'index.php?modname=test&op=play') . Form::getHidden('id_test', 'id_test', $id_test) . Form::getHidden('id_param', 'id_param', $id_param) . Form::getHidden('idTrack', 'idTrack', $id_track) . Form::getHidden('back_url', 'back_url', $url_coded) . Form::getHidden('next_step', 'next_step', 'play'), 'content');
if ($test_info['max_attempt'] > 0) {
if ($test_info['max_attempt'] - $track_info['number_of_attempt'] <= 0) {
//$GLOBALS['page']->add($lang->def('_MAX_ATTEMPT_REACH'), 'content');
$GLOBALS['page']->add(Lang::t('_MAX_ATTEMPT_REACH', 'test'), 'content');
if ($show_result) {
$GLOBALS['page']->add('<div class="align_right">' . Form::getHidden('show_result', 'show_result', 1) . Form::getButton('show_review', 'show_review', $lang->def('_TEST_SHOW_REVIEW')) . '</div>', 'content');
}
$GLOBALS['page']->add(Form::closeForm() . '</div>', 'content');
return;
}
if ($is_end && $track_info['score'] >= $test_info['point_required']) {
$GLOBALS['page']->add($lang->def('_YOU_HAVE_PASS_THIS_TEST'), 'content');
if ($show_result) {
$GLOBALS['page']->add('<div class="align_right">' . Form::getHidden('show_result', 'show_result', 1) . Form::getButton('show_review', 'show_review', $lang->def('_TEST_SHOW_REVIEW')) . '</div>', 'content');
}
$GLOBALS['page']->add(Form::closeForm() . '</div>', 'content');
return;
}
}
//--- check for suspension condition -------------------------------------------
if ($test_info['use_suspension']) {
$attempts_until_now = $track_info['attempts_for_suspension'];
$last_suspension_date = $track_info['suspended_until'];
if ($last_suspension_date == "") {
$last_suspension_date = '0000-00-00 00:00:00';
}
$now = date("Y-m-d H:i:s");
//check remaining attempts
$diff_attempts = $test_info['suspension_num_attempts'] - $attempts_until_now;
if ($diff_attempts > 0 && ($last_suspension_date < $now || $test_info['suspension_num_hours'] <= 0)) {
//warning: $diff_attempts remaining before suspesion
cout(UIFeedback::pnotice($lang->def('_ATTEMPTS_REMAINING_BEFORE_SUSPENSION') . ' : ' . $diff_attempts) . '<br /><br />', 'content');
} else {
if ($test_info['suspension_num_hours'] <= 0) {
cout(UIFeedback::pnotice($lang->def('_TEST_SUSPENDED')) . '<br /><br />', 'content');
cout(Form::closeForm() . '</div>', 'content');
return;
} else {
//check if last suspension date is prior to now
if ($last_suspension_date > $now) {
//user is suspended for this test until "last_suspension_date"
cout(UIFeedback::pnotice($lang->def('_TEST_SUSPENDED_UNTIL') . ' : ' . Format::date($last_suspension_date, "datetime")) . '<br /><br />', 'content');
cout(Form::closeForm() . '</div>', 'content');
return;
} else {
//we shouldn't get here, except if test options about suspension have been modified
//in a second time: in this case update test track data and go on
$suspend_info = array('attempts_for_suspension' => 0);
$re = Track_Test::updateTrack($id_track, $suspend_info);
$diff_attempts = $test_info['suspension_num_attempts'];
cout(UIFeedback::pnotice($lang->def('_ATTEMPTS_REMAINING_BEFORE_SUSPENSION') . ' : ' . $diff_attempts) . '<br /><br />', 'content');
}
}
}
//check if the user should re-play LO in prerequisites
if ($test_info['suspension_prerequisites']) {
if ($prerequisite != "") {
//check all prerequisites conditions
$query = "SELECT idOrg FROM " . $GLOBALS['prefix_lms'] . "_organization WHERE objectType='test' AND idResource=" . (int) $test_info['idTest'];
list($idOrg) = sql_fetch_row(sql_query($query));
$conditions = explode(",", $prerequisite);
$req_arr = array();
foreach ($conditions as $condition) {
if (is_numeric($condition) && (int) $condition != $idOrg) {
$req_arr[] = $condition;
}
}
if (count($req_arr) > 0) {
$query = "SELECT * FROM " . $GLOBALS['prefix_lms'] . "_commontrack WHERE idReference IN (" . implode(",", $req_arr) . ") " . " AND dateAttempt>'" . $last_suspension_date . "' AND status IN ('completed','passed')";
$res = sql_query($query);
if (sql_num_rows($res) < count($req_arr)) {
cout(UIFeedback::pnotice($lang->def('_UNREACHED_PREREQUISITES')) . '<br /><br />', 'content');
cout(Form::closeForm() . '</div>', 'content');
return;
}
}
}
}
}
//--- end suspension check -----------------------------------------------------
if ($score_status == 'passed') {
$incomplete = FALSE;
} elseif ($score_status == 'valid') {
$track_info = $play_man->getTrackAllInfo();
if ($track_info['score'] >= $test_info['point_required']) {
$incomplete = FALSE;
} else {
$incomplete = TRUE;
}
} else {
$incomplete = TRUE;
}
if ($score_status == 'not_complete') {
$GLOBALS['page']->add(Form::getHidden('page_continue', 'page_continue', $play_man->getLastPageSeen()), 'content');
}
if ($is_end) {
$GLOBALS['page']->add(Form::getHidden('show_result', 'show_result', 1), 'content');
}
if ($test_info['save_keep'] && $score_status == 'not_complete') {
$GLOBALS['page']->add('<span class="text_bold">' . $lang->def('_TEST_SAVED') . '</span><br /><br />', 'content');
}
$GLOBALS['page']->add('<div class="align_right">', 'content');
if ($is_end && $show_result) {
$GLOBALS['page']->add(Form::getButton('show_review', 'show_review', $lang->def('_TEST_SHOW_REVIEW')), 'content');
} elseif ($test_info['save_keep'] && $score_status == 'not_complete') {
$GLOBALS['page']->add(Form::getButton('continue', 'continue', $lang->def('_TEST_CONTINUE')), 'content');
}
if ($score_status == 'not_complete') {
$GLOBALS['page']->add(Form::getButton('restart', 'restart', $lang->def('_TEST_BEGIN')), 'content');
} elseif ($is_end) {
if ($_SESSION['levelCourse'] > '3') {
$GLOBALS['page']->add(Form::getButton('restart', 'restart', $lang->def('_TEST_RESTART')), 'content');
} elseif (str_replace('incomplete', '', $prerequisite) !== $prerequisite) {
$incomplete ? $GLOBALS['page']->add(Form::getButton('restart', 'restart', $lang->def('_TEST_RESTART')), 'content') : $GLOBALS['page']->add($lang->def('_TEST_COMPLETED'), 'content');
} elseif (str_replace('NULL', '', $prerequisite) !== $prerequisite) {
$score_status !== 'valid' && $score_status !== 'passed' ? $GLOBALS['page']->add(Form::getButton('restart', 'restart', $lang->def('_TEST_RESTART')), 'content') : $GLOBALS['page']->add($lang->def('_TEST_COMPLETED'), 'content');
} else {
$GLOBALS['page']->add(Form::getButton('restart', 'restart', $lang->def('_TEST_RESTART')), 'content');
}
} else {
resetTrack($id_test, $id_track);
$GLOBALS['page']->add(Form::getButton('begin', 'begin', $lang->def('_TEST_BEGIN')), 'content');
}
$GLOBALS['page']->add('</div>' . Form::closeForm() . '</div>', 'content');
}
function testQuestion()
{
checkPerm('view');
YuiLib::load(array('animation' => 'my_animation.js'));
addJs($GLOBALS['where_lms_relative'] . '/modules/coursereport/', 'ajax.coursereport.js');
require_once _base_ . '/lib/lib.table.php';
require_once $GLOBALS['where_lms'] . '/lib/lib.test.php';
$lang =& DoceboLanguage::createInstance('coursereport', 'lms');
$out =& $GLOBALS['page'];
$out->setWorkingZone('content');
$out->add('<script type="text/javascript">' . ' setup_coursereport(\'' . $GLOBALS['where_lms_relative'] . '/ajax.server.php?plf=lms&mn=coursereport&\'); ' . '</script>', 'page_head');
$id_test = importVar('id_test', true, 0);
$test_man = new GroupTestManagement();
$lev = FALSE;
if (isset($_GET['type_filter']) && $_GET['type_filter'] != null) {
$lev = $_GET['type_filter'];
}
$students = getSubscribed((int) $_SESSION['idCourse'], FALSE, $lev, TRUE, false, false, true);
$id_students = array_keys($students);
$quests = array();
$answers = array();
$tracks = array();
$test_info = $test_man->getTestInfo(array($id_test));
$page_title = array('index.php?modname=coursereport&op=coursereport' => $lang->def('_COURSEREPORT', 'menu_course'), $test_info[$id_test]['title']);
$out->add(getTitleArea($page_title, 'coursereport') . '<div class="std_block">');
$query_test = "SELECT title" . " FROM " . $GLOBALS['prefix_lms'] . "_test" . " WHERE idTest = '" . $id_test . "'";
list($titolo_test) = sql_fetch_row(sql_query($query_test));
$query_quest = "SELECT idQuest, type_quest, title_quest" . " FROM " . $GLOBALS['prefix_lms'] . "_testquest" . " WHERE idTest = '" . $id_test . "'" . " ORDER BY sequence";
$result_quest = sql_query($query_quest);
while (list($id_quest, $type_quest, $title_quest) = sql_fetch_row($result_quest)) {
$quests[$id_quest]['idQuest'] = $id_quest;
$quests[$id_quest]['type_quest'] = $type_quest;
$quests[$id_quest]['title_quest'] = $title_quest;
// $query_answer = "SELECT idAnswer, is_correct, answer"
// ." FROM ".$GLOBALS['prefix_lms']."_testquestanswer"
// ." WHERE idQuest = '".$id_quest."'"
// ." ORDER BY sequence";
$query_answer = "SELECT tqa.idAnswer, tqa.is_correct, tqa.answer" . " FROM " . $GLOBALS['prefix_lms'] . "_testquestanswer AS tqa" . " LEFT JOIN" . " " . $GLOBALS['prefix_lms'] . "_testtrack_answer tta ON tqa.idAnswer = tta.idAnswer" . " LEFT JOIN" . " " . $GLOBALS['prefix_lms'] . "_testtrack tt ON tt.idTrack = tta.idTrack" . " WHERE tqa.idQuest = '" . $id_quest . "'";
$query_answer .= " and tt.idUser in (" . implode(",", $id_students) . ")";
$query_answer .= " ORDER BY tqa.sequence";
$result_answer = sql_query($query_answer);
while (list($id_answer, $is_correct, $answer) = sql_fetch_row($result_answer)) {
$answers[$id_quest][$id_answer]['idAnswer'] = $id_answer;
$answers[$id_quest][$id_answer]['is_correct'] = $is_correct;
$answers[$id_quest][$id_answer]['answer'] = $answer;
}
if ($type_quest == 'choice_multiple' || $type_quest == 'choice' || $type_quest == 'inline_choice') {
$answers[$id_quest][0]['idAnswer'] = 0;
$answers[$id_quest][0]['is_correct'] = 0;
$answers[$id_quest][0]['answer'] = $lang->def('_NO_ANSWER');
}
}
$query_track = "SELECT idTrack" . " FROM " . $GLOBALS['prefix_lms'] . "_testtrack" . " WHERE idTest = '" . $id_test . "'" . " AND score_status = 'valid'" . " AND idUser in (" . implode(",", $id_students) . ")";
$result_track = sql_query($query_track);
while (list($id_track) = sql_fetch_row($result_track)) {
$query_track_answer = "SELECT idQuest, idAnswer, more_info" . " FROM " . $GLOBALS['prefix_lms'] . "_testtrack_answer" . " WHERE idTrack = '" . $id_track . "'";
// COMMENTATO MA NON E' CHIARO COME MAI C'E'????
//." AND user_answer = 1";
//print_r($query_track_answer.'<br />');
$result_track_answer = sql_query($query_track_answer);
//echo $query_track_answer."<br>";
while (list($id_quest, $id_answer, $more_info) = sql_fetch_row($result_track_answer)) {
$tracks[$id_track][$id_quest][$id_answer]['more_info'] = $more_info;
//echo " -> ".$id_quest." - ".$id_answer." - ".$more_info."<br>";
}
}
$query_total_play = "SELECT COUNT(*)" . " FROM " . $GLOBALS['prefix_lms'] . "_testtrack" . " WHERE idTest = '" . $id_test . "'" . " AND score_status = 'valid'" . " AND idUser in (" . implode(",", $id_students) . ")";
list($total_play) = sql_fetch_row(sql_query($query_total_play));
/*if ($total_play == 0) {
$query_total_play = "SELECT COUNT(*)"
." FROM ".$GLOBALS['prefix_lms']."_testtrack"
." WHERE idTest = '".$id_test."' AND score_status = 'not_checked'";
list($total_play2) = mysql_fetch_row(mysql_query($query_total_play));
$total_play += $total_play2;
}*/
//print_r($tracks);
foreach ($quests as $quest) {
switch ($quest['type_quest']) {
case "inline_choice":
case "hot_text":
case "choice_multiple":
case "choice":
$cont_h = array($lang->def('_ANSWER'), $lang->def('_PERCENTAGE'));
$type_h = array('', 'image nowrap');
$tb = new Table(0, str_replace('[title]', $quest['title_quest'], $lang->def('_TABLE_QUEST')));
$tb->setColsStyle($type_h);
$tb->addHead($cont_h);
foreach ($answers[$quest['idQuest']] as $answer) {
$cont = array();
if ($answer['is_correct']) {
$txt = '<img src="' . getPathImage('lms') . 'standard/publish.png" alt="' . $lang->def('_ANSWER_CORRECT') . '" title="' . $lang->def('_ANSWER_CORRECT') . '" align="left" /> ';
} else {
$txt = '';
}
$cont[] = '<p>' . $txt . ' ' . $answer['answer'] . '</p>';
$answer_given = 0;
reset($tracks);
$i = 0;
foreach ($tracks as $track) {
$i++;
if (isset($track[$quest['idQuest']][$answer['idAnswer']])) {
$answer_given++;
} elseif (!isset($track[$quest['idQuest']]) && $answer['idAnswer'] == 0) {
$answer_given++;
}
}
if ($answer['idAnswer'] == 0 && $i < $total_play) {
// if ($i < $total_play) {
$answer_given = $answer_given + ($total_play - $i);
}
if ($total_play > 0) {
$percentage = $answer_given / $total_play * 100;
} else {
$percentage = 0;
}
$percentage = number_format($percentage, 2);
$cont[] = Util::draw_progress_bar($percentage, true, false, false, false, false);
$tb->addBody($cont);
}
$out->add($tb->getTable() . '<br/>');
break;
case "upload":
case "extended_text":
$out->add('<div>');
$out->add('<p><a href="#" onclick="getQuestDetail(' . $quest['idQuest'] . ', ' . $id_test . ', \'' . $quest['type_quest'] . '\'); return false;" id="more_quest_' . $quest['idQuest'] . '"><img src="' . getPathImage('fw') . 'standard/more.gif" alt="' . $lang->def('_MORE_INFO') . '" />' . str_replace('[title]', $quest['title_quest'], $lang->def('_TABLE_QUEST_LIST')) . '</a></p>');
$out->add('<p><a href="#" onclick="closeQuestDetail(' . $quest['idQuest'] . '); return false;" id="less_quest_' . $quest['idQuest'] . '" style="display:none"><img src="' . getPathImage('fw') . 'standard/less.gif" alt="' . $lang->def('_CLOSE') . '" />' . str_replace('[title]', $quest['title_quest'], $lang->def('_TABLE_QUEST_LIST')) . '</a></p>');
$out->add('</div>');
$out->add('<div id="quest_' . $quest['idQuest'] . '">');
$out->add('</div>');
break;
case "text_entry":
$cont_h = array($lang->def('_PERCENTAGE_CORRECT'));
$type_h = array('align-center');
$tb = new Table(0, str_replace('[title]', $quest['title_quest'], $lang->def('_TABLE_QUEST_CORRECT_TXT')));
$tb->setColsStyle($type_h);
$tb->addHead($cont_h);
foreach ($answers[$quest['idQuest']] as $answer) {
$cont = array();
$answer_correct = 0;
foreach ($tracks as $track) {
if ($track[$quest['idQuest']][$answer['idAnswer']]['more_info'] === $answer['answer']) {
$answer_correct++;
}
}
$percentage = $answer_correct / $total_play * 100;
$percentage = number_format($percentage, 2);
$cont[] = Util::draw_progress_bar($percentage, true, false, false, false, false);
$tb->addBody($cont);
}
$out->add($tb->getTable() . '<br/>');
break;
case "associate":
$cont_h = array($lang->def('_ANSWER'), $lang->def('_PERCENTAGE_CORRECT'));
$type_h = array('', 'align-center');
$tb = new Table(0, str_replace('[title]', $quest['title_quest'], $lang->def('_TABLE_QUEST_CORRECT_ASS')));
$tb->setColsStyle($type_h);
$tb->addHead($cont_h);
foreach ($answers[$quest['idQuest']] as $answer) {
$cont = array();
$cont[] = $answer['answer'];
$answer_correct = 0;
foreach ($tracks as $track) {
if ($track[$quest['idQuest']][$answer['idAnswer']]['more_info'] === $answer['is_correct']) {
$answer_correct++;
}
}
$percentage = $answer_correct / $total_play * 100;
echo "risp corrette: " . $answer_correct . " totale: " . $total_play;
$percentage = number_format($percentage, 2);
$cont[] = Util::draw_progress_bar($percentage, true, false, false, false, false);
$tb->addBody($cont);
}
$out->add($tb->getTable() . '<br/>');
break;
}
reset($answers);
reset($tracks);
}
$out->add('</div>');
}
function getFinalObjectScore($arr_user, $arr_course = false)
{
$l_obj = array();
$r_obj = array();
$score = array();
$query_lo = "\r\n\t\tSELECT idOrg, idResource, objectType, idCourse \r\n\t\tFROM " . $GLOBALS['prefix_lms'] . "_organization \r\n\t\tWHERE milestone = 'end' " . (!empty($arr_course) ? " AND idCourse IN ( " . implode(',', $arr_course) . " )" : "") . " ";
$re_lo = sql_query($query_lo);
while (list($id_org, $id_resource, $obj_type, $id_course) = sql_fetch_row($re_lo)) {
$l_obj[$obj_type][$id_resource] = $id_resource;
$r_obj[$obj_type][$id_org] = $id_org;
$course_obj_assoc[$obj_type][$id_resource] = $id_course;
$course_org_assoc[$obj_type][$id_org] = $id_course;
}
$obj_types = array_keys($l_obj);
while (list(, $type) = each($obj_types)) {
switch ($type) {
case "scormorg":
require_once $GLOBALS['where_lms'] . '/lib/lib.scorm.php';
$group_test = new GroupScormObjMan();
$scorm_score =& $group_test->getSimpleScormScores($r_obj['scormorg'], $arr_user);
while (list($id_test, $scorm_info) = each($scorm_score)) {
$idc = $course_org_assoc['scormorg'][$id_test];
$score[$idc] = $scorm_info;
}
break;
// ------------------------------------------------------------
// ------------------------------------------------------------
case "test":
require_once $GLOBALS['where_lms'] . '/lib/lib.test.php';
$group_test = new GroupTestManagement();
$test_score =& $group_test->getSimpleTestsScores($l_obj['test'], $arr_user);
while (list($id_test, $test_info) = each($test_score)) {
$idc = $course_obj_assoc['test'][$id_test];
$score[$idc] = $test_info;
}
break;
}
}
return $score;
}
