gradebook_view_result.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507
  1. <?php
  2. // $Id: gradebook_view_result.php 1020 2007-05-11 08:20:27Z stijn $
  3. /*
  4. ==============================================================================
  5. Dokeos - elearning and course management software
  6. Copyright (c) 2006 Dokeos S.A.
  7. Copyright (c) 2006 Ghent University (UGent)
  8. Copyright (c) various contributors
  9. For a full list of contributors, see "credits.txt".
  10. The full license can be read in "license.txt".
  11. This program is free software; you can redistribute it and/or
  12. modify it under the terms of the GNU General Public License
  13. as published by the Free Software Foundation; either version 2
  14. of the License, or (at your option) any later version.
  15. See the GNU General Public License for more details.
  16. Contact address: Dokeos, 44 rue des palais, B-1030 Brussels, Belgium
  17. Mail: info@dokeos.com
  18. ==============================================================================
  19. */
  20. $language_file[] = 'gradebook';
  21. $cidReset= true;
  22. include_once ('../inc/global.inc.php');
  23. include_once ('lib/be.inc.php');
  24. include_once ('lib/gradebook_functions.inc.php');
  25. include_once ('lib/fe/displaygradebook.php');
  26. include_once ('lib/fe/evalform.class.php');
  27. include_once ('lib/fe/dataform.class.php');
  28. include_once (api_get_path(LIBRARY_PATH) . 'fileManage.lib.php');
  29. include_once (api_get_path(LIBRARY_PATH) . 'export.lib.inc.php');
  30. include_once (api_get_path(LIBRARY_PATH) . 'import.lib.php');
  31. include_once ('lib/results_data_generator.class.php');
  32. include_once ('lib/fe/resulttable.class.php');
  33. include_once ('lib/fe/exportgradebook.php');
  34. include_once ('lib/scoredisplay.class.php');
  35. include_once (api_get_path(LIBRARY_PATH).'ezpdf/class.ezpdf.php');
  36. api_block_anonymous_users();
  37. block_students();
  38. $interbreadcrumb[]= array (
  39. 'url' => 'gradebook.php',
  40. 'name' => get_lang('Gradebook'
  41. ));
  42. //load the evaluation & category
  43. $displayscore = Scoredisplay :: instance();
  44. $eval= Evaluation :: load($_GET['selecteval']);
  45. $overwritescore= 0;
  46. if ($eval[0]->get_category_id() < 0)
  47. {
  48. // if category id is negative, then the evaluation's origin is a link
  49. $link= LinkFactory :: get_evaluation_link($eval[0]->get_id());
  50. $currentcat= Category :: load($link->get_category_id());
  51. } else
  52. $currentcat= Category :: load($eval[0]->get_category_id());
  53. //load the result with the evaluation id
  54. function overwritescore($resid, $importscore, $eval_max)
  55. {
  56. $result= Result :: load($resid);
  57. if ($importscore > $eval_max)
  58. {
  59. header('Location: gradebook_view_result.php?selecteval=' . $_GET['selecteval'] . '&overwritemax=');
  60. exit;
  61. }
  62. $result[0]->set_score($importscore);
  63. $result[0]->save();
  64. unset ($result);
  65. }
  66. if (isset ($_GET['selecteval']))
  67. {
  68. $allresults= Result :: load(null, null, $_GET['selecteval']);
  69. $iscourse= $currentcat[0]->get_course_code() == null ? 1 : 0;
  70. }
  71. /**
  72. * XML-parser: handle start of element
  73. */
  74. function element_start($parser, $data)
  75. {
  76. global $user;
  77. global $current_tag;
  78. switch ($data)
  79. {
  80. case 'Result' :
  81. $user= array ();
  82. break;
  83. default :
  84. $current_tag= $data;
  85. }
  86. }
  87. /**
  88. * XML-parser: handle end of element
  89. */
  90. function element_end($parser, $data)
  91. {
  92. global $user;
  93. global $users;
  94. global $current_value;
  95. switch ($data)
  96. {
  97. case 'Result' :
  98. $users[]= $user;
  99. break;
  100. default :
  101. $user[$data]= $current_value;
  102. break;
  103. }
  104. }
  105. /**
  106. * XML-parser: handle character data
  107. */
  108. function character_data($parser, $data)
  109. {
  110. global $current_value;
  111. $current_value= $data;
  112. }
  113. /**
  114. * Read the XML-file
  115. * @param string $file Path to the XML-file
  116. * @return array All userinformation read from the file
  117. */
  118. function parse_xml_data($file)
  119. {
  120. global $current_tag;
  121. global $current_value;
  122. global $user;
  123. global $users;
  124. $users= array ();
  125. $parser= xml_parser_create();
  126. xml_set_element_handler($parser, 'element_start', 'element_end');
  127. xml_set_character_data_handler($parser, "character_data");
  128. xml_parser_set_option($parser, XML_OPTION_CASE_FOLDING, false);
  129. xml_parse($parser, file_get_contents($file));
  130. xml_parser_free($parser);
  131. return $users;
  132. }
  133. if (isset ($_GET['editres']))
  134. {
  135. $resultedit= Result :: load($_GET['editres']);
  136. $edit_res_form= new EvalForm(EvalForm :: TYPE_RESULT_EDIT, $eval[0], $resultedit[0], 'edit_result_form', null, api_get_self() . '?editres=' . $resultedit[0]->get_id() . '&selecteval=' . $_GET['selecteval']);
  137. if ($edit_res_form->validate())
  138. {
  139. $values= $edit_res_form->exportValues();
  140. $result= new Result();
  141. $result->set_id($_GET['editres']);
  142. $result->set_user_id($values['hid_user_id']);
  143. $result->set_evaluation_id($_GET['selecteval']);
  144. if ((!empty ($values['score'])) || ($values['score'] == '0'))
  145. $result->set_score($values['score']);
  146. $result->save();
  147. unset ($result);
  148. header('Location: gradebook_view_result.php?selecteval=' . $_GET['selecteval'] . '&editresmessage=');
  149. exit;
  150. }
  151. }
  152. if (isset ($_GET['import']))
  153. {
  154. $interbreadcrumb[]= array (
  155. 'url' => 'gradebook_view_result.php?selecteval=' . $_GET['selecteval'],
  156. 'name' => get_lang('ViewResult'
  157. ));
  158. $import_result_form = new DataForm(DataForm :: TYPE_IMPORT, 'import_result_form', null, api_get_self() . '?import=&selecteval=' . $_GET['selecteval']);
  159. if (!$import_result_form->validate())
  160. Display :: display_header(get_lang('Import'));
  161. if ($_POST['formSent'])
  162. {
  163. if (!empty ($_FILES['import_file']['name']))
  164. {
  165. $values= $import_result_form->exportValues();
  166. $file_type= $_POST['file_type'];
  167. $file_name= $_FILES['import_file']['tmp_name'];
  168. if ($file_type == 'csv')
  169. {
  170. $results= Import :: csv_to_array($file_name);
  171. } else
  172. {
  173. $results= parse_xml_data($file_name);
  174. }
  175. //var_dump($results);
  176. $nr_results_added= 0;
  177. foreach ($results as $index => $importedresult)
  178. {
  179. //check username & score
  180. $added= '0';
  181. foreach ($allresults as $allresult)
  182. {
  183. if (($importedresult['user_id'] == $allresult->get_user_id()))
  184. {
  185. if ($importedresult['score'] != $allresult->get_score())
  186. {
  187. if (!isset ($values['overwrite']))
  188. {
  189. header('Location: gradebook_view_result.php?selecteval=' . $_GET['selecteval'] . '&import_score_error=' . $importedresult['user_id']);
  190. exit;
  191. break;
  192. } else
  193. {
  194. overwritescore($allresult->get_id(), $importedresult['score'], $eval[0]->get_max());
  195. $overwritescore++;
  196. $added= '1';
  197. }
  198. } else
  199. $added= '1';
  200. }
  201. }
  202. if ($importedresult['user_id'] == null)
  203. {
  204. header('Location: gradebook_view_result.php?selecteval=' . $_GET['selecteval'] . '&incorrectdata=');
  205. exit;
  206. }
  207. $userinfo= get_user_info_from_id($importedresult['user_id']);
  208. if ($userinfo['lastname'] != $importedresult['lastname'] || $userinfo['firstname'] != $importedresult['firstname'] || $userinfo['official_code'] != $importedresult['official_code'])
  209. {
  210. if (!isset ($values['ignoreerrors']))
  211. {
  212. header('Location: gradebook_view_result.php?selecteval=' . $_GET['selecteval'] . '&import_user_error=' . $importedresult['user_id']);
  213. exit;
  214. }
  215. }
  216. if ($added != '1')
  217. {
  218. if ($importedresult['score'] > $eval[0]->get_max())
  219. {
  220. header('Location: gradebook_view_result.php?selecteval=' . $_GET['selecteval'] . '&overwritemax=');
  221. exit;
  222. }
  223. $result= new Result();
  224. $result->set_user_id($importedresult['user_id']);
  225. if (!empty ($importedresult['score']))
  226. {
  227. $result->set_score($importedresult['score']);
  228. }
  229. if (!empty ($importedresult['date']))
  230. {
  231. $result->set_date(strtotime($importedresult['date']));
  232. } else
  233. {
  234. $result->set_date(time());
  235. }
  236. $result->set_evaluation_id($_GET['selecteval']); //var_dump($result);
  237. $result->add();
  238. $nr_results_added++;
  239. }
  240. }
  241. } else
  242. {
  243. header('Location: ' . api_get_self() . '?import=&selecteval=' . $_GET['selecteval'] . '&importnofile=');
  244. exit;
  245. }
  246. if ($overwritescore != 0)
  247. {
  248. header('Location: ' . api_get_self() . '?selecteval=' . $_GET['selecteval'] . '&importoverwritescore=' . $overwritescore);
  249. exit;
  250. }
  251. if ($nr_results_added == 0)
  252. {
  253. header('Location: ' . api_get_self() . '?selecteval=' . $_GET['selecteval'] . '&nothingadded=');
  254. exit;
  255. }
  256. header('Location: ' . api_get_self() . '?selecteval=' . $_GET['selecteval'] . '&importok=');
  257. exit;
  258. }
  259. }
  260. if (isset ($_GET['export']))
  261. {
  262. $interbreadcrumb[]= array (
  263. 'url' => 'gradebook_view_result.php?selecteval=' . $_GET['selecteval'],
  264. 'name' => get_lang('ViewResult'
  265. ));
  266. $export_result_form= new DataForm(DataForm :: TYPE_EXPORT, 'export_result_form', null, api_get_self() . '?export=&selecteval=' . $_GET['selecteval'], '_blank');
  267. if (!$export_result_form->validate())
  268. Display :: display_header(get_lang('Export'));
  269. if ($export_result_form->validate())
  270. {
  271. $export= $export_result_form->exportValues();
  272. $file_type= $export['file_type'];
  273. $filename= 'export_results_' . date('Y-m-d_H-i-s');
  274. $results= Result :: load(null, null, $_GET['selecteval']);
  275. $data= array (); //when file type is csv, add a header to the output file
  276. if ($file_type == 'csv')
  277. {
  278. $alldata[]= array (
  279. 'user_id',
  280. 'official_code',
  281. 'lastname',
  282. 'firstname',
  283. 'score',
  284. 'date'
  285. );
  286. }
  287. if ($file_type == 'pdf')
  288. {
  289. if (($eval[0]->has_results()))
  290. {
  291. $score= $eval[0]->calc_score();
  292. if ($score != null)
  293. $average= get_lang('Average') . ' : ' . round(100 * ($score[0] / $score[1])) . ' %';
  294. }
  295. if ($eval[0]->get_course_code() == null)
  296. $course= get_lang('CourseIndependent');
  297. else
  298. $course= get_course_name_from_code($eval[0]->get_course_code());
  299. $pdf= new Cezpdf();
  300. $pdf->selectFont(api_get_path(LIBRARY_PATH).'ezpdf/fonts/Courier.afm');
  301. $pdf->ezSetMargins(30, 30, 50, 30);
  302. $pdf->ezSetY(800);
  303. $pdf->ezText(get_lang('EvaluationName') . ' : ' . $eval[0]->get_name() . ' (' . date('j/n/Y g:i', $eval[0]->get_date()) . ')', 12, array (
  304. 'justification' => 'left'
  305. ));
  306. $pdf->ezText(get_lang('Description') . ' : ' . $eval[0]->get_description());
  307. $pdf->ezText(get_lang('Course') . ' : ' . $course, 12, array (
  308. 'justification' => 'left'
  309. ));
  310. $pdf->ezText(get_lang('Weight') . ' : ' . $eval[0]->get_weight(), 12, array (
  311. 'justification' => 'left'
  312. ));
  313. $pdf->ezText(get_lang('Max') . ' : ' . $eval[0]->get_max(), 12, array (
  314. 'justification' => 'left'
  315. ));
  316. $pdf->ezText($average, 12, array (
  317. 'justification' => 'left'
  318. ));
  319. $datagen = new ResultsDataGenerator ($eval[0],$allresults);
  320. $data_array = $datagen->get_data(ResultsDataGenerator :: RDG_SORT_LASTNAME,0,null,true);
  321. $newarray = array();
  322. foreach ($data_array as $data)
  323. {
  324. $newitem = array();
  325. $newitem[] = $data['lastname'];
  326. $newitem[] = $data['firstname'];
  327. $newitem[] = $data['score'];
  328. if ($displayscore->is_custom())
  329. $newitem[] = $data['display'];
  330. $newarray[] = $newitem;
  331. }
  332. $pdf->ezSetY(650);
  333. if ($displayscore->is_custom())
  334. $header_names = array(get_lang('LastName'),get_lang('FirstName'),get_lang('Score'),get_lang('Display'));
  335. else
  336. $header_names = array(get_lang('LastName'),get_lang('FirstName'),get_lang('Score'));
  337. $pdf->ezTable($newarray,$header_names,'',array('showHeadings'=>1,'shaded'=>1,'showLines'=>1,'rowGap'=>3,'width'=> 500));
  338. $pdf->ezStream();
  339. exit;
  340. }
  341. foreach ($results as $result)
  342. {
  343. $userinfo= get_user_info_from_id($result->get_user_id());
  344. $data['user_id']= $result->get_user_id();
  345. $data['official_code']= $userinfo['official_code'];
  346. $data['lastname']= $userinfo['lastname'];
  347. $data['firstname']= $userinfo['firstname'];
  348. $data['score']= $result->get_score();
  349. $data['date']= date('Y-n-j g:i', $result->get_date());
  350. $alldata[]= $data;
  351. }
  352. switch ($file_type)
  353. {
  354. case 'xml' :
  355. Export :: export_table_xml($alldata, $filename, 'Result', 'XMLResults');
  356. break;
  357. case 'csv' :
  358. Export :: export_table_csv($alldata, $filename);
  359. break;
  360. }
  361. }
  362. }
  363. if (isset ($_GET['resultdelete']))
  364. {
  365. $result= Result :: load($_GET['resultdelete']);
  366. $result[0]->delete();
  367. header('Location: gradebook_view_result.php?deleteresult=&selecteval=' . $_GET['selecteval']);
  368. exit;
  369. }
  370. if (isset ($_POST['action']))
  371. {
  372. $number_of_selected_items= count($_POST['id']);
  373. if ($number_of_selected_items == '0')
  374. Display :: display_warning_message(get_lang('NoItemsSelected'),false);
  375. else
  376. {
  377. switch ($_POST['action'])
  378. {
  379. case 'delete' :
  380. $number_of_deleted_results= 0;
  381. foreach ($_POST['id'] as $indexstr)
  382. {
  383. $result= Result :: load($indexstr);
  384. $result[0]->delete();
  385. $number_of_deleted_results++;
  386. }
  387. header('Location: gradebook_view_result.php?massdelete=&selecteval=' . $_GET['selecteval']);
  388. exit;
  389. break;
  390. }
  391. }
  392. } // TODO - what if selecteval not set ?
  393. $addparams= array (
  394. 'selecteval' => $eval[0]->get_id());
  395. if (isset ($_GET['print']))
  396. {
  397. $datagen = new ResultsDataGenerator ($eval[0],$allresults);
  398. $data_array = $datagen->get_data(ResultsDataGenerator :: RDG_SORT_LASTNAME,0,null,true);
  399. if ($displayscore->is_custom())
  400. $header_names = array(get_lang('LastName'),get_lang('FirstName'),get_lang('Score'),get_lang('Display'));
  401. else
  402. $header_names = array(get_lang('LastName'),get_lang('FirstName'),get_lang('Score'));
  403. $newarray = array();
  404. foreach ($data_array as $data)
  405. $newarray[] = array_slice($data, 2);
  406. echo print_table($newarray, $header_names,get_lang('ViewResult'), $eval[0]->get_name());
  407. exit;
  408. } else
  409. $resulttable= new ResultTable($eval[0], $allresults, $iscourse, $addparams);
  410. $htmlHeadXtra[]= '<script type="text/javascript">
  411. function confirmationuser ()
  412. {
  413. if (confirm("' . get_lang('DeleteUser') . '?"))
  414. {return true;}
  415. else
  416. {return false;}
  417. }
  418. function confirmationall ()
  419. {
  420. if (confirm("' . get_lang('DeleteAll') . '?"))
  421. {return true;}
  422. else
  423. {return false;}
  424. }
  425. </script>';
  426. if (isset ($_GET['deleteall']))
  427. {
  428. $eval[0]->delete_results();
  429. header('Location: gradebook_view_result.php?allresdeleted=&selecteval=' . $_GET['selecteval']);
  430. exit;
  431. }
  432. if ((!isset ($_GET['export'])) && (!isset ($_GET['import'])))
  433. Display :: display_header(get_lang('ViewResult'));
  434. if (isset ($_GET['addresultnostudents']))
  435. Display :: display_warning_message(get_lang('AddResultNoStudents'),false);
  436. if (isset ($_GET['editresmessage']))
  437. Display :: display_confirmation_message(get_lang('ResultEdited'),false);
  438. if (isset ($_GET['addresult']))
  439. Display :: display_confirmation_message(get_lang('ResultAdded'),false);
  440. if (isset ($_GET['adduser']))
  441. Display :: display_confirmation_message(get_lang('UserAdded'),false);
  442. if (isset ($_GET['deleteresult']))
  443. Display :: display_confirmation_message(get_lang('ResultDeleted'),false);
  444. if (isset ($_GET['editallresults']))
  445. Display :: display_confirmation_message(get_lang('AllResultsEdited'),false);
  446. if (isset ($_GET['importok']))
  447. Display :: display_confirmation_message(get_lang('ImportOk'),false);
  448. if (isset ($_GET['importnofile']))
  449. Display :: display_warning_message(get_lang('ImportNoFile'),false);
  450. if (isset ($_GET['incorrectdata']))
  451. Display :: display_warning_message(get_lang('IncorrectData'),false);
  452. if (isset ($_GET['nothingadded']))
  453. Display :: display_warning_message(get_lang('NothingAdded'),false);
  454. if (isset ($_GET['massdelete']))
  455. Display :: display_confirmation_message(get_lang('ResultsDeleted'),false);
  456. if (isset ($_GET['nouser']))
  457. Display :: display_warning_message(get_lang('NoUser'),false);
  458. if (isset ($_GET['overwritemax']))
  459. Display :: display_warning_message(get_lang('OverWriteMax'),false);
  460. if (isset ($_GET['importoverwritescore']))
  461. Display :: display_confirmation_message(get_lang('ImportOverwriteScore') . ' ' . $_GET['importoverwritescore']);
  462. if (isset ($_GET['import_user_error']))
  463. {
  464. $userinfo= get_user_info_from_id($_GET['import_user_error']);
  465. Display :: display_warning_message(get_lang('UserInfoDoesNotMatch') . '<br /><br /><b>' . $userinfo['lastname'] . ' ' . $userinfo['firstname'] . '</b>');
  466. }
  467. if (isset ($_GET['allresdeleted']))
  468. Display :: display_confirmation_message(get_lang('AllResultDeleted'));
  469. if (isset ($_GET['import_score_error']))
  470. {
  471. $userinfo= get_user_info_from_id($_GET['import_score_error']);
  472. Display :: display_warning_message(get_lang('ScoreDoesNotMatch') . '<br /><br /><b>' . $userinfo['lastname'] . ' ' . $userinfo['firstname'] . '</b>');
  473. }
  474. if ($file_type == null)
  475. { //show the result header
  476. if (isset ($export_result_form) && !(isset ($edit_res_form)))
  477. {
  478. echo '<div class ="normal-message">';
  479. echo $export_result_form->display();
  480. echo '</div>';
  481. DisplayGradebook :: display_header_result($eval[0], $currentcat[0]->get_id(), 1);
  482. } else
  483. {
  484. if (isset ($import_result_form))
  485. {
  486. echo '<div class ="normal-message">';
  487. echo $import_result_form->display();
  488. echo '</div>';
  489. }
  490. if (isset ($edit_res_form))
  491. {
  492. Display :: display_normal_message($edit_res_form->toHtml(),false);
  493. }
  494. DisplayGradebook :: display_header_result($eval[0], $currentcat[0]->get_id(), 1);
  495. }
  496. $resulttable->display();
  497. Display :: display_footer();
  498. }
  499. ?>