gradebook_view_result.php 20 KB

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