gradebook_view_result.php 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * Script
  5. * @package chamilo.gradebook
  6. */
  7. require_once '../inc/global.inc.php';
  8. api_block_anonymous_users();
  9. $isDrhOfCourse = CourseManager::isUserSubscribedInCourseAsDrh(
  10. api_get_user_id(),
  11. api_get_course_info()
  12. );
  13. if (!$isDrhOfCourse) {
  14. GradebookUtils::block_students();
  15. }
  16. $interbreadcrumb[] = array(
  17. 'url' => $_SESSION['gradebook_dest'],
  18. 'name' => get_lang('Gradebook'
  19. ));
  20. //load the evaluation & category
  21. $select_eval = Security::remove_XSS($_GET['selecteval']);
  22. if (empty($select_eval)) {
  23. api_not_allowed();
  24. }
  25. $displayscore = ScoreDisplay :: instance();
  26. $eval = Evaluation :: load($select_eval);
  27. $overwritescore = 0;
  28. if ($eval[0]->get_category_id() < 0) {
  29. // if category id is negative, then the evaluation's origin is a link
  30. $link = LinkFactory :: get_evaluation_link($eval[0]->get_id());
  31. $currentcat = Category :: load($link->get_category_id());
  32. } else
  33. $currentcat = Category :: load($eval[0]->get_category_id());
  34. //load the result with the evaluation id
  35. if (isset($_GET['delete_mark'])) {
  36. $result = Result :: load($_GET['delete_mark']);
  37. if (!empty($result[0])) {
  38. $result[0]->delete();
  39. }
  40. }
  41. if (isset($_GET['selecteval'])) {
  42. $allresults = Result :: load(null, null, $select_eval);
  43. $iscourse = $currentcat[0]->get_course_code() == null ? 1 : 0;
  44. }
  45. if (isset($_GET['editres'])) {
  46. $edit_res_xml = Security::remove_XSS($_GET['editres']);
  47. $select_eval_edit = Security::remove_XSS($_GET['selecteval']);
  48. $resultedit = Result :: load($edit_res_xml);
  49. $edit_res_form = new EvalForm(
  50. EvalForm :: TYPE_RESULT_EDIT,
  51. $eval[0],
  52. $resultedit[0],
  53. 'edit_result_form',
  54. null,
  55. api_get_self() . '?editres=' . $resultedit[0]->get_id() . '&selecteval=' . $select_eval_edit.'&'.api_get_cidreq()
  56. );
  57. if ($edit_res_form->validate()) {
  58. $values = $edit_res_form->exportValues();
  59. $result = new Result();
  60. $resultlog = new Result();
  61. $resultlog->add_result__log($values['hid_user_id'], $select_eval_edit);
  62. $result->set_id($edit_res_xml);
  63. $result->set_user_id($values['hid_user_id']);
  64. $result->set_evaluation_id($select_eval_edit);
  65. $row_value = isset($values['score']) ? (float) $values['score'] : 0;
  66. if (!empty($row_value) || $row_value == 0) {
  67. $result->set_score(floatval(number_format($row_value, api_get_setting('gradebook_number_decimals'))));
  68. }
  69. $result->save();
  70. unset($result);
  71. header('Location: gradebook_view_result.php?selecteval=' . $select_eval_edit . '&editresmessage=&'.api_get_cidreq());
  72. exit;
  73. }
  74. }
  75. $file_type = null;
  76. if (isset($_GET['import'])) {
  77. $interbreadcrumb[] = array(
  78. 'url' => 'gradebook_view_result.php?selecteval=' . Security::remove_XSS($_GET['selecteval']).'&'.api_get_cidreq(),
  79. 'name' => get_lang('ViewResult')
  80. );
  81. $import_result_form = new DataForm(
  82. DataForm :: TYPE_IMPORT,
  83. 'import_result_form',
  84. null,
  85. api_get_self() . '?import=&selecteval=' . Security::remove_XSS($_GET['selecteval']),
  86. '_blank',
  87. ''
  88. );
  89. if (!$import_result_form->validate()) {
  90. Display :: display_header(get_lang('Import'));
  91. }
  92. $eval[0]->check_lock_permissions();
  93. if ($_POST['formSent']) {
  94. if (!empty($_FILES['import_file']['name'])) {
  95. $values = $import_result_form->exportValues();
  96. $file_type = $_POST['file_type'];
  97. $file_name = $_FILES['import_file']['tmp_name'];
  98. if ($file_type == 'csv') {
  99. $results = Import :: csvToArray($file_name);
  100. } else {
  101. $results = parse_xml_data($file_name);
  102. }
  103. $nr_results_added = 0;
  104. foreach ($results as $index => $importedresult) {
  105. //check username & score
  106. $importedresult['user_id'] = UserManager::get_user_id_from_username($importedresult['username']);
  107. $added = '0';
  108. foreach ($allresults as $allresult) {
  109. if (($importedresult['user_id'] == $allresult->get_user_id())) {
  110. if ($importedresult['score'] != $allresult->get_score()) {
  111. if (!isset($values['overwrite'])) {
  112. header('Location: gradebook_view_result.php?selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&import_score_error=' . $importedresult['user_id']);
  113. exit;
  114. break;
  115. } else {
  116. GradebookUtils::overwritescore(
  117. $allresult->get_id(),
  118. $importedresult['score'],
  119. $eval[0]->get_max()
  120. );
  121. $overwritescore++;
  122. $added = '1';
  123. }
  124. } else {
  125. $added = '1';
  126. }
  127. }
  128. }
  129. if ($importedresult['user_id'] == null) {
  130. header('Location: gradebook_view_result.php?selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&incorrectdata=');
  131. exit;
  132. }
  133. $userinfo = api_get_user_info($importedresult['user_id']);
  134. if ($userinfo['lastname'] != $importedresult['lastname'] ||
  135. $userinfo['firstname'] != $importedresult['firstname'] ||
  136. $userinfo['official_code'] != $importedresult['official_code']
  137. ) {
  138. if (!isset($values['ignoreerrors'])) {
  139. header('Location: gradebook_view_result.php?selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&import_user_error=' . $importedresult['user_id']);
  140. exit;
  141. }
  142. }
  143. if ($added != '1') {
  144. if ($importedresult['score'] > $eval[0]->get_max()) {
  145. header('Location: gradebook_view_result.php?selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&overwritemax=');
  146. exit;
  147. }
  148. $result = new Result();
  149. $result->set_user_id($importedresult['user_id']);
  150. if (!empty($importedresult['score'])) {
  151. $result->set_score(floatval(number_format($importedresult['score'], api_get_setting('gradebook_number_decimals'))));
  152. }
  153. if (!empty($importedresult['date'])) {
  154. $result->set_date(api_get_utc_datetime($importedresult['date']));
  155. } else {
  156. $result->set_date(api_get_utc_datetime());
  157. }
  158. $result->set_evaluation_id($_GET['selecteval']);
  159. $result->add();
  160. $nr_results_added++;
  161. }
  162. }
  163. } else {
  164. header('Location: ' . api_get_self() . '?import=&selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&importnofile=');
  165. exit;
  166. }
  167. if ($overwritescore != 0) {
  168. header('Location: ' . api_get_self() . '?selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&importoverwritescore=' . $overwritescore);
  169. exit;
  170. }
  171. if ($nr_results_added == 0) {
  172. header('Location: ' . api_get_self() . '?selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&nothingadded=');
  173. exit;
  174. }
  175. header('Location: ' . api_get_self() . '?selecteval=' . Security::remove_XSS($_GET['selecteval']) . '&importok=');
  176. exit;
  177. }
  178. }
  179. if (isset($_GET['export'])) {
  180. $interbreadcrumb[] = array('url' => 'gradebook_view_result.php?selecteval=' . Security::remove_XSS($_GET['selecteval']), 'name' => get_lang('ViewResult'));
  181. $locked_status = $eval[0]->get_locked();
  182. $export_result_form = new DataForm(
  183. DataForm :: TYPE_EXPORT,
  184. 'export_result_form',
  185. null,
  186. api_get_self() . '?export=&selecteval=' . $_GET['selecteval'],
  187. '_blank',
  188. $locked_status
  189. );
  190. if (!$export_result_form->validate()) {
  191. Display :: display_header(get_lang('Export'));
  192. }
  193. if ($export_result_form->validate()) {
  194. $export = $export_result_form->exportValues();
  195. $file_type = $export['file_type'];
  196. $filename = 'export_results_' . gmdate('Y-m-d_H-i-s');
  197. $results = Result :: load(null, null, Security::remove_XSS($_GET['selecteval']));
  198. $data = array(); //when file type is csv, add a header to the output file
  199. if ($file_type == 'csv') {
  200. $alldata[] = array(
  201. 'username',
  202. 'official_code',
  203. 'lastname',
  204. 'firstname',
  205. 'score',
  206. 'date'
  207. );
  208. }
  209. // export results to pdf file
  210. if ($file_type == 'pdf') {
  211. $number_decimals = api_get_setting('gradebook_number_decimals');
  212. $datagen = new ResultsDataGenerator($eval[0], $allresults);
  213. // set headers pdf
  214. !empty($_user['official_code']) ? $officialcode = $_user['official_code'] . ' - ' : '';
  215. $h1 = array(get_lang('Teacher'), $officialcode . $_user['firstName'] . ', ' . $_user['lastName']);
  216. $h2 = array(get_lang('Score'), $eval[0]->get_max());
  217. $h3 = array(get_lang('Course'), $_course['name']);
  218. $h4 = array(get_lang('Weight'), $eval[0]->get_weight());
  219. $h5 = array(get_lang('Session'), api_get_session_name(api_get_session_id()));
  220. $date = date('d-m-Y H:i:s', time());
  221. $h6 = array(get_lang('DateTime'), api_convert_and_format_date($date, "%d/%m/%Y %H:%M"));
  222. $header_pdf = array($h1, $h2, $h3, $h4, $h5, $h6);
  223. // set footer pdf
  224. $f1 = '<hr />' . get_lang('Drh');
  225. $f2 = '<hr />' . get_lang('Teacher');
  226. $f3 = '<hr />' . get_lang('Date');
  227. $footer_pdf = array($f1, $f2, $f3);
  228. // set title pdf
  229. $title_pdf = $eval[0]->get_name();
  230. // set headers data table
  231. $head_ape_name = '';
  232. if (api_is_western_name_order()) {
  233. $head_ape_name = get_lang('FirstName') . ', ' . get_lang('LastName');
  234. } else {
  235. $head_ape_name = get_lang('LastName') . ', ' . get_lang('FirstName');
  236. }
  237. $head_table = array(
  238. array('#', 3),
  239. array(get_lang('Code'), 12),
  240. array($head_ape_name, 40),
  241. array(get_lang('Score'), 12)
  242. );
  243. if ($number_decimals == null) {
  244. $head_table[] = array(get_lang('Letters'), 15);
  245. }
  246. $head_display_score = '';
  247. $scoredisplay = ScoreDisplay :: instance();
  248. $customdisplays = $scoredisplay->get_custom_score_display_settings();
  249. if (!empty($customdisplays) && $scoredisplay->is_custom()) {
  250. $head_display_score = get_lang('Display');
  251. $head_table[] = array($head_display_score, 15);
  252. }
  253. // get data table
  254. if (api_sort_by_first_name()) {
  255. $data_array = $datagen->get_data(ResultsDataGenerator :: RDG_SORT_FIRSTNAME, 0, null, false, true);
  256. } else {
  257. $data_array = $datagen->get_data(ResultsDataGenerator :: RDG_SORT_LASTNAME, 0, null, false, true);
  258. }
  259. $data_table = array();
  260. foreach ($data_array as $data) {
  261. $result = array();
  262. $user_info = api_get_user_info($data['id']);
  263. $result[] = $user_info['username'];
  264. if (api_is_western_name_order()) {
  265. $result[] = $user_info['firstname'] . ', ' . $user_info['lastname'];
  266. } else {
  267. $result[] = $user_info['lastname'] . ', ' . $user_info['firstname'];
  268. }
  269. if ($number_decimals == null) {
  270. if (empty($data['scoreletter']) && !is_numeric($data['score'])) {
  271. $result[] = get_lang('DidNotTakeTheExam');
  272. } else {
  273. $result[] = api_strtoupper(get_lang('Literal' . $data['scoreletter']));
  274. }
  275. } else {
  276. if (empty($data['score']) && !is_numeric($data['score'])) {
  277. $result[] = get_lang('DidNotTakeTheExamAcronym');
  278. } else {
  279. $result[] = $data['score'];
  280. }
  281. }
  282. if ($scoredisplay->is_custom()) {
  283. $result[] = $data['display'];
  284. }
  285. $data_table[] = $result;
  286. }
  287. export_pdf_with_html(
  288. $head_table,
  289. $data_table,
  290. $header_pdf,
  291. $footer_pdf,
  292. $title_pdf
  293. );
  294. }
  295. // export results to xml or csv file
  296. foreach ($results as $result) {
  297. $userinfo = api_get_user_info($result->get_user_id());
  298. $data['username'] = $userinfo['username']; //$result->get_user_id();
  299. $data['official_code'] = $userinfo['official_code'];
  300. $data['lastname'] = $userinfo['lastname'];
  301. $data['firstname'] = $userinfo['firstname'];
  302. $data['score'] = $result->get_score();
  303. $data['date'] = api_format_date($result->get_date(), "%d/%m/%Y %R");
  304. $alldata[] = $data;
  305. }
  306. switch ($file_type) {
  307. case 'xml' :
  308. Export :: arrayToXml($alldata, $filename, 'Result', 'XMLResults');
  309. exit;
  310. break;
  311. case 'csv' :
  312. Export :: arrayToCsv($alldata, $filename);
  313. exit;
  314. break;
  315. }
  316. }
  317. }
  318. if (isset($_GET['resultdelete'])) {
  319. $result = Result :: load($_GET['resultdelete']);
  320. $result[0]->delete();
  321. header('Location: gradebook_view_result.php?deleteresult=&selecteval=' . Security::remove_XSS($_GET['selecteval']));
  322. exit;
  323. }
  324. if (isset($_POST['action'])) {
  325. $number_of_selected_items = count($_POST['id']);
  326. if ($number_of_selected_items == '0') {
  327. Display :: display_warning_message(get_lang('NoItemsSelected'), false);
  328. } else {
  329. switch ($_POST['action']) {
  330. case 'delete' :
  331. $number_of_deleted_results = 0;
  332. foreach ($_POST['id'] as $indexstr) {
  333. $result = Result :: load($indexstr);
  334. $result[0]->delete();
  335. $number_of_deleted_results++;
  336. }
  337. header('Location: gradebook_view_result.php?massdelete=&selecteval=' . Security::remove_XSS($_GET['selecteval']));
  338. exit;
  339. break;
  340. }
  341. }
  342. } // TODO - what if selecteval not set ?
  343. $addparams = array('selecteval' => $eval[0]->get_id());
  344. if (isset($_GET['print'])) {
  345. $datagen = new ResultsDataGenerator($eval[0], $allresults);
  346. if (api_sort_by_first_name()) {
  347. $data_array = $datagen->get_data(ResultsDataGenerator :: RDG_SORT_FIRSTNAME, 0, null, true);
  348. } else {
  349. $data_array = $datagen->get_data(ResultsDataGenerator :: RDG_SORT_LASTNAME, 0, null, true);
  350. }
  351. if ($displayscore->is_custom()) {
  352. if (api_is_western_name_order()) {
  353. $header_names = array(get_lang('FirstName'), get_lang('LastName'), get_lang('Score'), get_lang('Display'));
  354. } else {
  355. $header_names = array(get_lang('LastName'), get_lang('FirstName'), get_lang('Score'), get_lang('Display'));
  356. }
  357. } else {
  358. if (api_is_western_name_order()) {
  359. $header_names = array(get_lang('FirstName'), get_lang('LastName'), get_lang('Score'));
  360. } else {
  361. $header_names = array(get_lang('LastName'), get_lang('FirstName'), get_lang('Score'));
  362. }
  363. }
  364. $newarray = array();
  365. foreach ($data_array as $data) {
  366. $newarray[] = array_slice($data, 3);
  367. }
  368. echo print_table($newarray, $header_names, get_lang('ViewResult'), $eval[0]->get_name());
  369. exit;
  370. } else {
  371. $resulttable = new ResultTable($eval[0], $allresults, $iscourse, $addparams);
  372. }
  373. $htmlHeadXtra[] = '<script type="text/javascript">
  374. function confirmationuser() {
  375. if (confirm("' . get_lang('DeleteUser') . '?"))
  376. {return true;}
  377. else
  378. {return false;}
  379. }
  380. function confirmationall () {
  381. if (confirm("' . get_lang('DeleteAll') . '?"))
  382. {return true;}
  383. else
  384. {return false;}
  385. }
  386. </script>';
  387. if (isset($_GET['deleteall'])) {
  388. $eval[0]->delete_results();
  389. header('Location: gradebook_view_result.php?allresdeleted=&selecteval=' . Security::remove_XSS($_GET['selecteval']));
  390. exit;
  391. }
  392. if ((!isset($_GET['export'])) && (!isset($_GET['import']))) {
  393. if (!isset($_GET['selectcat'])) {
  394. $interbreadcrumb[] = array(
  395. 'url' => $_SESSION['gradebook_dest'] . '?selectcat=' . $currentcat[0]->get_id(),
  396. 'name' => get_lang('Details')
  397. );
  398. }
  399. $interbreadcrumb[] = array('url' => 'gradebook_view_result.php' . '?selecteval=' . Security::remove_XSS($_GET['selecteval']), 'name' => get_lang('ViewResult'));
  400. Display :: display_header('');
  401. }
  402. if (isset($_GET['addresultnostudents'])) {
  403. Display :: display_warning_message(get_lang('AddResultNoStudents'), false);
  404. }
  405. if (isset($_GET['editresmessage'])) {
  406. Display :: display_confirmation_message(get_lang('ResultEdited'), false);
  407. }
  408. if (isset($_GET['addresult'])) {
  409. Display :: display_confirmation_message(get_lang('ResultAdded'), false);
  410. }
  411. if (isset($_GET['adduser'])) {
  412. Display :: display_confirmation_message(get_lang('UserAdded'), false);
  413. }
  414. if (isset($_GET['deleteresult'])) {
  415. Display :: display_confirmation_message(get_lang('ResultDeleted'), false);
  416. }
  417. if (isset($_GET['editallresults'])) {
  418. Display :: display_confirmation_message(get_lang('AllResultsEdited'), false);
  419. }
  420. if (isset($_GET['importok'])) {
  421. Display :: display_confirmation_message(get_lang('FileUploadComplete'), false);
  422. }
  423. if (isset($_GET['importnofile'])) {
  424. Display :: display_warning_message(get_lang('ImportNoFile'), false);
  425. }
  426. if (isset($_GET['incorrectdata'])) {
  427. Display :: display_warning_message(get_lang('IncorrectData'), false);
  428. }
  429. if (isset($_GET['nothingadded'])) {
  430. Display :: display_warning_message(get_lang('ProblemUploadingFile'), false);
  431. }
  432. if (isset($_GET['massdelete'])) {
  433. Display :: display_confirmation_message(get_lang('ResultsDeleted'), false);
  434. }
  435. if (isset($_GET['nouser'])) {
  436. Display :: display_warning_message(get_lang('NoUser'), false);
  437. }
  438. if (isset($_GET['overwritemax'])) {
  439. Display :: display_warning_message(get_lang('OverWriteMax'), false);
  440. }
  441. if (isset($_GET['importoverwritescore'])) {
  442. Display :: display_confirmation_message(get_lang('ImportOverWriteScore') . ' ' . $_GET['importoverwritescore']);
  443. }
  444. if (isset($_GET['import_user_error'])) {
  445. $userinfo = api_get_user_info($_GET['import_user_error']);
  446. Display :: display_warning_message(get_lang('UserInfoDoesNotMatch') . ' ' . api_get_person_name($userinfo['firstname'], $userinfo['lastname']));
  447. }
  448. if (isset($_GET['allresdeleted'])) {
  449. Display :: display_confirmation_message(get_lang('AllResultDeleted'));
  450. }
  451. if (isset($_GET['import_score_error'])) {
  452. $userinfo = api_get_user_info($_GET['import_score_error']);
  453. Display :: display_warning_message(get_lang('ScoreDoesNotMatch') . ' ' . api_get_person_name($userinfo['firstname'], $userinfo['lastname']));
  454. }
  455. if ($file_type == null) { //show the result header
  456. if (isset($export_result_form) && !(isset($edit_res_form))) {
  457. echo $export_result_form->display();
  458. DisplayGradebook :: display_header_result($eval[0], $currentcat[0]->get_id(), 1);
  459. } else {
  460. if (isset($import_result_form)) {
  461. echo $import_result_form->display();
  462. }
  463. if (isset($edit_res_form)) {
  464. echo $edit_res_form->toHtml();
  465. }
  466. DisplayGradebook :: display_header_result($eval[0], $currentcat[0]->get_id(), 1);
  467. }
  468. // Letter-based scores are built from lib/results_data_generator.class.php::get_score_display()
  469. $resulttable->display();
  470. Display :: display_footer();
  471. }