gradebook_view_result.php 17 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485
  1. <?php // $Id: $
  2. /*
  3. ==============================================================================
  4. Dokeos - elearning and course management software
  5. Copyright (c) 2008 Dokeos Latinoamerica SAC
  6. Copyright (c) 2006 Dokeos SPRL
  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, rue du Corbeau, 108, B-1030 Brussels, Belgium
  17. Mail: info@dokeos.com
  18. ==============================================================================
  19. */
  20. $language_file[] = 'gradebook';
  21. //$cidReset= true;
  22. require_once ('../inc/global.inc.php');
  23. require_once ('lib/be.inc.php');
  24. require_once ('lib/gradebook_functions.inc.php');
  25. require_once ('lib/fe/displaygradebook.php');
  26. require_once ('lib/fe/evalform.class.php');
  27. require_once ('lib/fe/dataform.class.php');
  28. require_once (api_get_path(LIBRARY_PATH) . 'fileManage.lib.php');
  29. require_once (api_get_path(LIBRARY_PATH) . 'export.lib.inc.php');
  30. require_once (api_get_path(LIBRARY_PATH) . 'import.lib.php');
  31. require_once (api_get_path(LIBRARY_PATH) . 'usermanager.lib.php');
  32. require_once ('lib/results_data_generator.class.php');
  33. require_once ('lib/fe/resulttable.class.php');
  34. require_once ('lib/fe/exportgradebook.php');
  35. require_once ('lib/scoredisplay.class.php');
  36. require_once (api_get_path(LIBRARY_PATH).'ezpdf/class.ezpdf.php');
  37. require_once api_get_path(SYS_CODE_PATH).'gradebook/lib/gradebook_functions.inc.php';
  38. api_block_anonymous_users();
  39. block_students();
  40. $interbreadcrumb[]= array (
  41. 'url' => $_SESSION['gradebook_dest'],
  42. 'name' => get_lang('Gradebook'
  43. ));
  44. //load the evaluation & category
  45. $select_eval=Security::remove_XSS($_GET['selecteval']);
  46. if (empty($select_eval)) {
  47. api_not_allowed();
  48. }
  49. $displayscore = Scoredisplay :: instance();
  50. $eval= Evaluation :: load($select_eval);
  51. $overwritescore= 0;
  52. if ($eval[0]->get_category_id() < 0) {
  53. // if category id is negative, then the evaluation's origin is a link
  54. $link= LinkFactory :: get_evaluation_link($eval[0]->get_id());
  55. $currentcat= Category :: load($link->get_category_id());
  56. } else
  57. $currentcat= Category :: load($eval[0]->get_category_id());
  58. //load the result with the evaluation id
  59. if (isset ($_GET['selecteval'])) {
  60. $allresults= Result :: load(null,null,$select_eval);
  61. $iscourse= $currentcat[0]->get_course_code() == null ? 1 : 0;
  62. }
  63. if (isset ($_GET['editres'])) {
  64. $edit_res_xml=Security::remove_XSS($_GET['editres']);
  65. $select_eval_edit=Security::remove_XSS($_GET['selecteval']);
  66. $resultedit= Result :: load($edit_res_xml);
  67. $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=' .$select_eval_edit);
  68. if ($edit_res_form->validate()) {
  69. $values= $edit_res_form->exportValues();
  70. $result= new Result();
  71. $resultlog=new Result();
  72. $resultlog->add_result__log($values['hid_user_id'],$select_eval_edit);
  73. $result->set_id($edit_res_xml);
  74. $result->set_user_id($values['hid_user_id']);
  75. $result->set_evaluation_id($select_eval_edit);
  76. $row_value=isset($values['score']) ? (int)$values['score'] : 0 ;
  77. if ((!empty ($row_value)) || ($row_value == 0)) {
  78. $result->set_score($row_value);
  79. }
  80. $result->save();
  81. unset ($result);
  82. header('Location: gradebook_view_result.php?selecteval=' . $select_eval_edit . '&editresmessage=');
  83. exit;
  84. }
  85. }
  86. if (isset ($_GET['import'])) {
  87. $interbreadcrumb[]= array (
  88. 'url' => 'gradebook_view_result.php?selecteval=' . Security::remove_XSS($_GET['selecteval']),
  89. 'name' => get_lang('ViewResult'
  90. ));
  91. $import_result_form = new DataForm(DataForm :: TYPE_IMPORT, 'import_result_form', null, api_get_self() . '?import=&selecteval=' . Security::remove_XSS($_GET['selecteval']));
  92. if (!$import_result_form->validate()) {
  93. Display :: display_header(get_lang('Import'));
  94. }
  95. if ($_POST['formSent'] ) {
  96. if (!empty ($_FILES['import_file']['name'])) {
  97. $values= $import_result_form->exportValues();
  98. $file_type= $_POST['file_type'];
  99. $file_name= $_FILES['import_file']['tmp_name'];
  100. if ($file_type == 'csv') {
  101. $results= Import :: csv_to_array($file_name);
  102. } else {
  103. $results= parse_xml_data($file_name);
  104. }
  105. $nr_results_added= 0;
  106. foreach ($results as $index => $importedresult) {
  107. //check username & score
  108. $importedresult['user_id'] = UserManager::get_user_id_from_username($importedresult['username']);
  109. $added= '0';
  110. foreach ($allresults as $allresult) {
  111. if (($importedresult['user_id'] == $allresult->get_user_id())) {
  112. if ($importedresult['score'] != $allresult->get_score()) {
  113. if (!isset ($values['overwrite'])) {
  114. header('Location: gradebook_view_result.php?selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&import_score_error=' . $importedresult['user_id']);
  115. exit;
  116. break;
  117. } else {
  118. overwritescore($allresult->get_id(), $importedresult['score'], $eval[0]->get_max());
  119. $overwritescore++;
  120. $added= '1';
  121. }
  122. } else {
  123. $added= '1';
  124. }
  125. }
  126. }
  127. if ($importedresult['user_id'] == null) {
  128. header('Location: gradebook_view_result.php?selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&incorrectdata=');
  129. exit;
  130. }
  131. $userinfo= get_user_info_from_id($importedresult['user_id']);
  132. if ($userinfo['lastname'] != $importedresult['lastname'] || $userinfo['firstname'] != $importedresult['firstname'] || $userinfo['official_code'] != $importedresult['official_code']) {
  133. if (!isset ($values['ignoreerrors'])) {
  134. header('Location: gradebook_view_result.php?selecteval=' .Security::remove_XSS($_GET['selecteval']) . '&import_user_error=' . $importedresult['user_id']);
  135. exit;
  136. }
  137. }
  138. if ($added != '1') {
  139. if ($importedresult['score'] > $eval[0]->get_max()) {
  140. header('Location: gradebook_view_result.php?selecteval=' .Security::remove_XSS($_GET['selecteval']) . '&overwritemax=');
  141. exit;
  142. }
  143. $result= new Result();
  144. $result->set_user_id($importedresult['user_id']);
  145. if (!empty ($importedresult['score'])) {
  146. $result->set_score($importedresult['score']);
  147. }
  148. if (!empty ($importedresult['date'])) {
  149. $result->set_date(strtotime($importedresult['date']));
  150. } else {
  151. $result->set_date(time());
  152. }
  153. $result->set_evaluation_id($_GET['selecteval']);
  154. $result->add();
  155. $nr_results_added++;
  156. }
  157. }
  158. } else {
  159. header('Location: ' . api_get_self() . '?import=&selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&importnofile=');
  160. exit;
  161. }
  162. if ($overwritescore != 0) {
  163. header('Location: ' . api_get_self() . '?selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&importoverwritescore=' . $overwritescore);
  164. exit;
  165. }
  166. if ($nr_results_added == 0) {
  167. header('Location: ' . api_get_self() . '?selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&nothingadded=');
  168. exit;
  169. }
  170. header('Location: ' . api_get_self() . '?selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&importok=');
  171. exit;
  172. }
  173. }
  174. if (isset ($_GET['export'])) {
  175. $interbreadcrumb[]= array (
  176. 'url' => 'gradebook_view_result.php?selecteval=' . Security::remove_XSS($_GET['selecteval']),
  177. 'name' => get_lang('ViewResult'
  178. ));
  179. $export_result_form= new DataForm(DataForm :: TYPE_EXPORT, 'export_result_form', null, api_get_self() . '?export=&selecteval=' . $_GET['selecteval'], '_blank');
  180. if (!$export_result_form->validate()) {
  181. Display :: display_header(get_lang('Export'));
  182. }
  183. if ($export_result_form->validate()) {
  184. $export= $export_result_form->exportValues();
  185. $file_type= $export['file_type'];
  186. $filename= 'export_results_' . date('Y-m-d_H-i-s');
  187. $results= Result :: load(null, null, Security::remove_XSS($_GET['selecteval']));
  188. $data= array (); //when file type is csv, add a header to the output file
  189. if ($file_type == 'csv') {
  190. $alldata[]= array (
  191. 'username',
  192. 'official_code',
  193. 'lastname',
  194. 'firstname',
  195. 'score',
  196. 'date'
  197. );
  198. }
  199. if ($file_type == 'pdf') {
  200. if (($eval[0]->has_results())) {
  201. $score= $eval[0]->calc_score();
  202. if ($score != null) {
  203. $average= get_lang('Average') . ' : ' . round(100 * ($score[0] / $score[1]),2) . ' %';
  204. }
  205. }
  206. if ($eval[0]->get_course_code() == null) {
  207. $course= get_lang('CourseIndependent');
  208. } else {
  209. $course= get_course_name_from_code($eval[0]->get_course_code());
  210. }
  211. $pdf= new Cezpdf();
  212. $pdf->selectFont(api_get_path(LIBRARY_PATH).'ezpdf/fonts/Courier.afm');
  213. $pdf->ezSetMargins(30, 30, 50, 30);
  214. $pdf->ezSetY(800);
  215. $pdf->ezText(get_lang('EvaluationName') . ' : ' . $eval[0]->get_name() . ' (' . date('j/n/Y g:i', $eval[0]->get_date()) . ')', 12, array (
  216. 'justification' => 'left'
  217. ));
  218. $pdf->ezText(get_lang('Description') . ' : ' . $eval[0]->get_description());
  219. $pdf->ezText(get_lang('Course') . ' : ' . $course, 12, array (
  220. 'justification' => 'left'
  221. ));
  222. $pdf->ezText(get_lang('Weight') . ' : ' . $eval[0]->get_weight(), 12, array (
  223. 'justification' => 'left'
  224. ));
  225. $pdf->ezText(get_lang('Max') . ' : ' . $eval[0]->get_max(), 12, array (
  226. 'justification' => 'left'
  227. ));
  228. $pdf->ezText($average, 12, array (
  229. 'justification' => 'left'
  230. ));
  231. $datagen = new ResultsDataGenerator ($eval[0],$allresults);
  232. if (api_sort_by_first_name()) {
  233. $data_array = $datagen->get_data(ResultsDataGenerator :: RDG_SORT_FIRSTNAME, 0, null, true);
  234. } else {
  235. $data_array = $datagen->get_data(ResultsDataGenerator :: RDG_SORT_LASTNAME,0,null,true);
  236. }
  237. $newarray = array();
  238. $is_western_name_order = api_is_western_name_order();
  239. foreach ($data_array as $data) {
  240. $newitem = array();
  241. if ($is_western_name_order) {
  242. $newitem[] = $data['firstname'];
  243. $newitem[] = $data['lastname'];
  244. } else {
  245. $newitem[] = $data['lastname'];
  246. $newitem[] = $data['firstname'];
  247. }
  248. $newitem[] = $data['score'];
  249. if ($displayscore->is_custom())
  250. $newitem[] = $data['display'];
  251. $newarray[] = $newitem;
  252. }
  253. $pdf->ezSetY(650);
  254. if ($displayscore->is_custom()) {
  255. if ($is_western_name_order) {
  256. $header_names = array(get_lang('FirstName'),get_lang('LastName'),get_lang('Score'),get_lang('Display'));
  257. } else {
  258. $header_names = array(get_lang('LastName'),get_lang('FirstName'),get_lang('Score'),get_lang('Display'));
  259. }
  260. } else {
  261. if ($is_western_name_order) {
  262. $header_names = array(get_lang('FirstName'),get_lang('LastName'),get_lang('Score'));
  263. } else {
  264. $header_names = array(get_lang('LastName'),get_lang('FirstName'),get_lang('Score'));
  265. }
  266. }
  267. $pdf->ezTable($newarray,$header_names,'',array('showHeadings'=>1,'shaded'=>1,'showLines'=>1,'rowGap'=>3,'width'=> 500));
  268. $pdf->ezStream();
  269. exit;
  270. }
  271. foreach ($results as $result) {
  272. $userinfo= get_user_info_from_id($result->get_user_id());
  273. $data['username']= $userinfo['username']; //$result->get_user_id();
  274. $data['official_code']= $userinfo['official_code'];
  275. $data['lastname']= $userinfo['lastname'];
  276. $data['firstname']= $userinfo['firstname'];
  277. $data['score']= $result->get_score();
  278. $data['date']= date('Y-n-j g:i', $result->get_date());
  279. $alldata[]= $data;
  280. }
  281. switch ($file_type) {
  282. case 'xml' :
  283. Export :: export_table_xml($alldata, $filename, 'Result', 'XMLResults');
  284. exit;
  285. break;
  286. case 'csv' :
  287. Export :: export_table_csv($alldata, $filename);
  288. exit;
  289. break;
  290. }
  291. }
  292. }
  293. if (isset ($_GET['resultdelete'])) {
  294. $result= Result :: load($_GET['resultdelete']);
  295. $result[0]->delete();
  296. header('Location: gradebook_view_result.php?deleteresult=&selecteval=' .Security::remove_XSS($_GET['selecteval']));
  297. exit;
  298. }
  299. if (isset ($_POST['action'])) {
  300. $number_of_selected_items= count($_POST['id']);
  301. if ($number_of_selected_items == '0') {
  302. Display :: display_warning_message(get_lang('NoItemsSelected'),false);
  303. } else {
  304. switch ($_POST['action']) {
  305. case 'delete' :
  306. $number_of_deleted_results= 0;
  307. foreach ($_POST['id'] as $indexstr) {
  308. $result= Result :: load($indexstr);
  309. $result[0]->delete();
  310. $number_of_deleted_results++;
  311. }
  312. header('Location: gradebook_view_result.php?massdelete=&selecteval=' .Security::remove_XSS($_GET['selecteval']));
  313. exit;
  314. break;
  315. }
  316. }
  317. } // TODO - what if selecteval not set ?
  318. $addparams = array ('selecteval' => $eval[0]->get_id());
  319. if (isset ($_GET['print'])) {
  320. $datagen = new ResultsDataGenerator ($eval[0],$allresults);
  321. if (api_sort_by_first_name()) {
  322. $data_array = $datagen->get_data(ResultsDataGenerator :: RDG_SORT_FIRSTNAME, 0, null, true);
  323. } else {
  324. $data_array = $datagen->get_data(ResultsDataGenerator :: RDG_SORT_LASTNAME,0,null,true);
  325. }
  326. if ($displayscore->is_custom()) {
  327. if (api_is_western_name_order()) {
  328. $header_names = array(get_lang('FirstName'),get_lang('LastName'),get_lang('Score'),get_lang('Display'));
  329. } else {
  330. $header_names = array(get_lang('LastName'),get_lang('FirstName'),get_lang('Score'),get_lang('Display'));
  331. }
  332. } else {
  333. if (api_is_western_name_order()) {
  334. $header_names = array(get_lang('FirstName'),get_lang('LastName'),get_lang('Score'));
  335. }else {
  336. $header_names = array(get_lang('LastName'),get_lang('FirstName'),get_lang('Score'));
  337. }
  338. }
  339. $newarray = array();
  340. foreach ($data_array as $data) {
  341. $newarray[] = array_slice($data, 2);
  342. }
  343. echo print_table($newarray, $header_names,get_lang('ViewResult'), $eval[0]->get_name());
  344. exit;
  345. } else
  346. $resulttable= new ResultTable($eval[0], $allresults, $iscourse, $addparams);
  347. $htmlHeadXtra[]= '<script type="text/javascript">
  348. function confirmationuser ()
  349. {
  350. if (confirm("' . get_lang('DeleteUser') . '?"))
  351. {return true;}
  352. else
  353. {return false;}
  354. }
  355. function confirmationall ()
  356. {
  357. if (confirm("' . get_lang('DeleteAll') . '?"))
  358. {return true;}
  359. else
  360. {return false;}
  361. }
  362. </script>';
  363. if (isset ($_GET['deleteall'])) {
  364. $eval[0]->delete_results();
  365. header('Location: gradebook_view_result.php?allresdeleted=&selecteval=' . Security::remove_XSS($_GET['selecteval']));
  366. exit;
  367. }
  368. if ((!isset ($_GET['export'])) && (!isset ($_GET['import']))) {
  369. if (!isset($_GET['selectcat'])) {
  370. $interbreadcrumb[]= array (
  371. 'url' => $_SESSION['gradebook_dest'].'?selectcat=' .$currentcat[0]->get_id(),
  372. 'name' => get_lang('Details')
  373. );
  374. }
  375. $interbreadcrumb[]= array (
  376. 'url' => 'gradebook_view_result.php'.'?selecteval='.Security::remove_XSS($_GET['selecteval']),
  377. 'name' => get_lang('ViewResult'
  378. ));
  379. Display :: display_header('');
  380. }
  381. if (isset ($_GET['addresultnostudents'])) {
  382. Display :: display_warning_message(get_lang('AddResultNoStudents'),false);
  383. }
  384. if (isset ($_GET['editresmessage'])) {
  385. Display :: display_confirmation_message(get_lang('ResultEdited'),false);
  386. }
  387. if (isset ($_GET['addresult'])) {
  388. Display :: display_confirmation_message(get_lang('ResultAdded'),false);
  389. }
  390. if (isset ($_GET['adduser'])) {
  391. Display :: display_confirmation_message(get_lang('UserAdded'),false);
  392. }
  393. if (isset ($_GET['deleteresult'])) {
  394. Display :: display_confirmation_message(get_lang('ResultDeleted'),false);
  395. }
  396. if (isset ($_GET['editallresults'])) {
  397. Display :: display_confirmation_message(get_lang('AllResultsEdited'),false);
  398. }
  399. if (isset ($_GET['importok'])) {
  400. Display :: display_confirmation_message(get_lang('FileUploadComplete'),false);
  401. }
  402. if (isset ($_GET['importnofile'])) {
  403. Display :: display_warning_message(get_lang('ImportNoFile'),false);
  404. }
  405. if (isset ($_GET['incorrectdata'])) {
  406. Display :: display_warning_message(get_lang('IncorrectData'),false);
  407. }
  408. if (isset ($_GET['nothingadded'])) {
  409. Display :: display_warning_message(get_lang('ProblemUploadingFile'),false);
  410. }
  411. if (isset ($_GET['massdelete'])) {
  412. Display :: display_confirmation_message(get_lang('ResultsDeleted'),false);
  413. }
  414. if (isset ($_GET['nouser'])) {
  415. Display :: display_warning_message(get_lang('NoUser'),false);
  416. }
  417. if (isset ($_GET['overwritemax'])) {
  418. Display :: display_warning_message(get_lang('OverWriteMax'),false);
  419. }
  420. if (isset ($_GET['importoverwritescore'])) {
  421. Display :: display_confirmation_message(get_lang('ImportOverWriteScore') . ' ' . $_GET['importoverwritescore']);
  422. }
  423. if (isset ($_GET['import_user_error'])) {
  424. $userinfo= get_user_info_from_id($_GET['import_user_error']);
  425. Display :: display_warning_message(get_lang('UserInfoDoesNotMatch') . ' ' . api_get_person_name($userinfo['firstname'], $userinfo['lastname']));
  426. }
  427. if (isset ($_GET['allresdeleted'])) {
  428. Display :: display_confirmation_message(get_lang('AllResultDeleted'));
  429. }
  430. if (isset ($_GET['import_score_error'])) {
  431. $userinfo= get_user_info_from_id($_GET['import_score_error']);
  432. Display :: display_warning_message(get_lang('ScoreDoesNotMatch') . ' ' . api_get_person_name($userinfo['firstname'], $userinfo['lastname']));
  433. }
  434. if ($file_type == null) { //show the result header
  435. if (isset ($export_result_form) && !(isset ($edit_res_form))) {
  436. echo '<div class ="normal-message">';
  437. echo $export_result_form->display();
  438. echo '</div>';
  439. DisplayGradebook :: display_header_result($eval[0], $currentcat[0]->get_id(), 1);
  440. } else {
  441. if (isset ($import_result_form)){
  442. echo '<div class ="normal-message">';
  443. echo $import_result_form->display();
  444. echo '</div>';
  445. }
  446. if (isset ($edit_res_form)) {
  447. Display :: display_normal_message($edit_res_form->toHtml(),false);
  448. }
  449. DisplayGradebook :: display_header_result($eval[0], $currentcat[0]->get_id(), 1);
  450. }
  451. $resulttable->display();
  452. Display :: display_footer();
  453. }