gradebook_view_result.php 21 KB

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