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