gradebook_view_result.php 18 KB

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