question_course_report.php 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291
  1. <?php
  2. /**
  3. * Report
  4. * @package chamilo.tracking
  5. */
  6. /**
  7. * Code
  8. */
  9. $language_file = array ('registration', 'index', 'tracking', 'exercice','survey');
  10. $cidReset = true;
  11. require_once '../inc/global.inc.php';
  12. require_once api_get_path(LIBRARY_PATH).'course.lib.php';
  13. require_once api_get_path(LIBRARY_PATH).'events.lib.inc.php';
  14. require_once api_get_path(LIBRARY_PATH).'tracking.lib.php';
  15. require_once api_get_path(LIBRARY_PATH).'sessionmanager.lib.php';
  16. require_once api_get_path(SYS_CODE_PATH).'exercice/exercise.class.php';
  17. require_once api_get_path(SYS_CODE_PATH).'exercice/question.class.php';
  18. require_once api_get_path(LIBRARY_PATH).'formvalidator/FormValidator.class.php';
  19. require_once api_get_path(LIBRARY_PATH).'pear/Spreadsheet_Excel_Writer/Writer.php';
  20. require_once api_get_path(SYS_CODE_PATH).'newscorm/learnpathList.class.php';
  21. require_once api_get_path(SYS_CODE_PATH).'newscorm/learnpath.class.php';
  22. require_once api_get_path(SYS_CODE_PATH).'newscorm/learnpathList.class.php';
  23. $this_section = "session_my_space";
  24. $is_allowedToTrack = $is_courseAdmin || $is_platformAdmin || $is_courseCoach || $is_sessionAdmin;
  25. if(!$is_allowedToTrack) {
  26. Display :: display_header(null);
  27. api_not_allowed();
  28. Display :: display_footer();
  29. }
  30. $export_to_xls = false;
  31. if (isset($_GET['export'])) {
  32. $export_to_xls = true;
  33. }
  34. $TBL_EXERCICES = Database::get_course_table(TABLE_QUIZ_TEST);
  35. $tbl_stats_exercices = Database :: get_statistic_table(TABLE_STATISTIC_TRACK_E_EXERCICES);
  36. if (api_is_platform_admin() ) {
  37. $global = true;
  38. } else {
  39. $global = false;
  40. }
  41. $global = true;
  42. $course_list = $course_select_list = array();
  43. $course_select_list[0] = get_lang('None');
  44. $htmlHeadXtra[] = '
  45. <script type="text/javascript">
  46. function load_courses() {
  47. document.search_simple.submit();
  48. }
  49. </script> ';
  50. $session_id = intval($_REQUEST['session_id']);
  51. if (empty($session_id)) {
  52. $temp_course_list = CourseManager :: get_courses_list();
  53. } else {
  54. $temp_course_list = SessionManager::get_course_list_by_session_id($session_id);
  55. }
  56. foreach($temp_course_list as $temp_course_item) {
  57. $course_item = CourseManager ::get_course_information($temp_course_item['code']);
  58. $course_list[]= array('db_name' =>$course_item['db_name'],'code'=>$course_item['code'], 'title'=>$course_item['title'], 'visual_code'=>$course_item['visual_code']);
  59. $course_select_list[$temp_course_item['code']] = $course_item['title'];
  60. }
  61. //Get session list
  62. $session_list = SessionManager::get_sessions_list(array(), array('name'));
  63. $my_session_list = array();
  64. $my_session_list[0] = get_lang('None');
  65. foreach($session_list as $sesion_item) {
  66. $my_session_list[$sesion_item['id']] = $sesion_item['name'];
  67. }
  68. $form = new FormValidator('search_simple','POST','','',null,false);
  69. $form->addElement('select', 'session_id', get_lang('Sessions'), $my_session_list, array('id'=>'session_id', 'onchange'=>'load_courses();'));
  70. $form->addElement('select', 'course_code',get_lang('Courses'), $course_select_list);
  71. $form->addElement('style_submit_button','submit_form', get_lang('Filter'));
  72. if (!empty($_REQUEST['course_code'])) $course_code = $_REQUEST['course_code']; else $course_code = '';
  73. if (empty($course_code)) {
  74. $course_code = 0;
  75. }
  76. $form->setDefaults(array('course_code'=>(string)$course_code));
  77. $course_info = api_get_course_info($course_code);
  78. //var_dump($session_id);
  79. if (!empty($course_info)) {
  80. $list = new learnpathList('', $course_code);
  81. $lp_list = $list->get_flat_list();
  82. $_course = $course_info;
  83. $main_question_list = array();
  84. foreach ($lp_list as $lp_id =>$lp) {
  85. $exercise_list = get_all_exercises_from_lp($lp_id, $course_info['dbName']);
  86. //var_dump($exercise_list);
  87. foreach ($exercise_list as $exercise) {
  88. $my_exercise = new Exercise();
  89. //$my_exercise->read($exercise['ref']);
  90. $my_exercise->read($exercise['path']);
  91. $question_list = $my_exercise->selectQuestionList();
  92. $exercise_stats = get_all_exercise_event_from_lp($exercise['path'],$course_info['id'], $session_id);
  93. //echo '<pre>'; print_r($exercise_stats);
  94. foreach($question_list as $question_id) {
  95. $question_data = Question::read($question_id);
  96. ///var_dump($question_data);
  97. $main_question_list[$question_id] = $question_data;
  98. $quantity_exercises = 0;
  99. $question_result = 0;
  100. //echo '<pre>';
  101. //print_r($exercise_stats);
  102. foreach($exercise_stats as $stats) {
  103. if (!empty($stats['question_list'])) {
  104. foreach($stats['question_list'] as $my_question_stat) {
  105. // var_dump($my_question_stat);
  106. if ($question_id == $my_question_stat['question_id']) {
  107. //var_dump($my_question_stat);
  108. $question_result = $question_result + $my_question_stat['marks'];
  109. // var_dump($my_question_stat['marks']);
  110. $quantity_exercises++;
  111. }
  112. }
  113. }
  114. }
  115. //echo $question_id;
  116. //var_dump($question_result.' - '.$quantity_exercises.$main_question_list[$question_id]->weighting);
  117. if(!empty($quantity_exercises)) {
  118. $main_question_list[$question_id]->results =(($question_result / ($quantity_exercises)) ) ; // Score % average
  119. } else {
  120. $main_question_list[$question_id]->results = 0;
  121. }
  122. $main_question_list[$question_id]->quantity = $quantity_exercises;
  123. }
  124. }
  125. }
  126. }
  127. //var_dump($main_question_list);
  128. //var_dump($main_question_list);
  129. //$course_list = SessionManager::get_course_list_by_session_id($session_id);
  130. if (!$export_to_xls) {
  131. Display :: display_header(get_lang("MySpace"));
  132. echo '<div class="actions" style ="font-size:10pt;" >';
  133. if ($global) {
  134. $menu_items[] = '<a href="'.api_get_path(WEB_CODE_PATH).'mySpace/?view=teacher">'.get_lang('TeacherInterface').'</a>';
  135. $menu_items[] = get_lang('AdminInterface');
  136. $menu_items[] = '<a href="'.api_get_path(WEB_CODE_PATH).'tracking/exams.php">'.get_lang('ExamTracking').'</a>';
  137. $nb_menu_items = count($menu_items);
  138. if($nb_menu_items>1) {
  139. foreach($menu_items as $key=> $item) {
  140. echo $item;
  141. if($key!=$nb_menu_items-1) {
  142. echo ' | ';
  143. }
  144. }
  145. echo '<br />';
  146. }
  147. } else {
  148. echo '<div style="float:left; clear:left">
  149. <a href="courseLog.php?'.api_get_cidreq().'&studentlist=true">'.get_lang('StudentsTracking').'</a>&nbsp;|
  150. <a href="courseLog.php?'.api_get_cidreq().'&studentlist=false">'.get_lang('CourseTracking').'</a>&nbsp;';
  151. echo '</div>';
  152. }
  153. echo '</div>';
  154. echo '<h4>'.get_lang('CoachList').'</h4>';
  155. if (api_is_platform_admin()) {
  156. echo '<a href="'.api_get_path(WEB_CODE_PATH).'mySpace/?view=admin&amp;display=coaches">'.get_lang('DisplayCoaches').'</a> | ';
  157. echo '<a href="'.api_get_path(WEB_CODE_PATH).'mySpace/?view=admin&amp;display=useroverview">'.get_lang('DisplayUserOverview').'</a>';
  158. echo ' | <a href="'.api_get_path(WEB_CODE_PATH).'mySpace/?view=admin&amp;display=sessionoverview">'.get_lang('DisplaySessionOverview').'</a>';
  159. echo ' | <a href="'.api_get_path(WEB_CODE_PATH).'mySpace/?view=admin&amp;display=courseoverview">'.get_lang('DisplayCourseOverview').'</a>';
  160. echo ' | '.get_lang('LPQuestionListResults');
  161. echo ' | <a href="'.api_get_path(WEB_CODE_PATH).'tracking/course_session_report.php?view=admin">'.get_lang('LPExerciseResultsBySession').'</a>';
  162. }
  163. echo '<br />';
  164. echo '<h2>'.get_lang('LPQuestionListResults').'</h2>';
  165. $form->display();
  166. //Display::display_normal_message(get_lang('QuestionsAreTakenFromLPExercises'));
  167. if (empty($course_code)) {
  168. Display::display_warning_message(get_lang('PleaseSelectACourse'));
  169. }
  170. }
  171. $course_average = array();
  172. $counter = 0;
  173. if (!empty($main_question_list) && is_array($main_question_list)) {
  174. $html_result .= '<table class="data_table">';
  175. $html_result .= '<tr><th>'.get_lang('Question').Display :: return_icon('info3.gif', get_lang('QuestionsAreTakenFromLPExercises'), array('align' => 'absmiddle', 'hspace' => '3px')).'</th>';
  176. $html_result .= '<th>'.$course_info['visual_code'].' '.get_lang('AverageScore').Display :: return_icon('info3.gif', get_lang('AllStudentsAttemptsAreConsidered'), array('align' => 'absmiddle', 'hspace' => '3px')).' </th>';
  177. $html_result .= '<th>'.get_lang('Quantity').'</th>';
  178. foreach($main_question_list as $question) {
  179. $total_student = 0;
  180. $counter ++;
  181. $s_css_class = 'row_even';
  182. if ($counter % 2 ==0 ) {
  183. $s_css_class = 'row_odd';
  184. }
  185. $html_result .= "<tr class='$s_css_class'>
  186. <td >";
  187. $question_title = trim($question->question);
  188. if (empty($question_title)) {
  189. $html_result .= get_lang('Untitled').' '.get_lang('Question').' #'.$question->id;
  190. } else {
  191. $html_result .= $question->question;
  192. }
  193. $html_result .= "</td>";
  194. $html_result .= "<td align=\"center\" >";
  195. $html_result .= round($question->results, 2).' / '.$question->weighting;
  196. $html_result .= "</td>";
  197. $html_result .= "<td align=\"center\" >";
  198. $html_result .= $question->quantity;
  199. $html_result .= "</td>";
  200. }
  201. $html_result .="</tr>";
  202. $html_result .= '</table>';
  203. } else {
  204. if (!empty($course_code)) {
  205. Display::display_warning_message(get_lang('NoResults'));
  206. }
  207. }
  208. if (!$export_to_xls) {
  209. echo $html_result;
  210. }
  211. $filename = 'exam-reporting-'.date('Y-m-d-h:i:s').'.xls';
  212. if ($export_to_xls) {
  213. echo $html_result;
  214. export_complete_report_xls($filename, $export_array);
  215. exit;
  216. }
  217. function sort_user($a, $b) {
  218. if (is_numeric($a['score']) && is_numeric($b['score'])) {
  219. echo $a['score'].' : '.$b['score'];
  220. echo '<br />';
  221. if ($a['score'] < $b['score']) {
  222. return 1;
  223. }
  224. return 0;
  225. }
  226. return 1;
  227. }
  228. function export_complete_report_xls($filename, $array) {
  229. global $charset;
  230. $workbook = new Spreadsheet_Excel_Writer();
  231. $workbook ->setTempDir(api_get_path(SYS_ARCHIVE_PATH));
  232. $workbook->send($filename);
  233. $workbook->setVersion(8); // BIFF8
  234. $worksheet =& $workbook->addWorksheet('Report');
  235. //$worksheet->setInputEncoding(api_get_system_encoding());
  236. $worksheet->setInputEncoding($charset);
  237. /*
  238. $line = 0;
  239. $column = 1; // Skip the first column (row titles)
  240. foreach ($array as $elem) {
  241. $worksheet->write($line, $column, $elem);
  242. $column++;
  243. }
  244. $workbook->close();*/
  245. exit;
  246. }
  247. Display :: display_footer();