gradebook_view_result.php 16 KB

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