gradebook_showlog_eval.php 2.6 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576
  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. api_block_anonymous_users();
  9. GradebookUtils::block_students();
  10. $selectCat = isset($_GET['selectcat']) ? (int) $_GET['selectcat'] : 0;
  11. $interbreadcrumb[] = array(
  12. 'url' => Category::getUrl(),
  13. 'name' => get_lang('Gradebook')
  14. );
  15. $interbreadcrumb[] = array(
  16. 'url' => Category::getUrl().'selectcat='.$selectCat,
  17. 'name' => get_lang('Details')
  18. );
  19. $interbreadcrumb[] = array(
  20. 'url' => 'gradebook_showlog_eval.php?visiblelog='.Security::remove_XSS($_GET['visiblelog']).'&amp;selectcat='.$selectCat,
  21. 'name' => get_lang('GradebookQualifyLog')
  22. );
  23. $this_section = SECTION_COURSES;
  24. Display::display_header('');
  25. echo Display::page_header(get_lang('GradebookQualifyLog'));
  26. $t_linkeval_log = Database::get_main_table(TABLE_MAIN_GRADEBOOK_LINKEVAL_LOG);
  27. $t_user = Database::get_main_table(TABLE_MAIN_USER);
  28. $visible_log = Security::remove_XSS($_GET['visiblelog']);
  29. $evaledit = Evaluation :: load($visible_log);
  30. $sql = "SELECT le.name,le.description,le.weight,le.visible,le.type,le.created_at, us.user_id
  31. FROM $t_linkeval_log le
  32. INNER JOIN $t_user us
  33. ON le.user_id_log = us.user_id
  34. WHERE
  35. id_linkeval_log=".$evaledit[0]->get_id()." AND
  36. type = 'evaluation'
  37. ";
  38. $result = Database::query($sql);
  39. $list_info = array();
  40. while ($row = Database::fetch_row($result)) {
  41. $list_info[] = $row;
  42. }
  43. foreach ($list_info as $key => $info_log) {
  44. $list_info[$key][5] = $info_log[5] ? api_convert_and_format_date($info_log[5]) : 'N/A';
  45. $list_info[$key][3] = $info_log[3] == 1 ? get_lang('GradebookVisible') : get_lang('GradebookInvisible');
  46. $userInfo = api_get_user_info($info_log[6]);
  47. if ($userInfo) {
  48. $list_info[$key][6] = $userInfo['complete_name_with_message_link'];
  49. } else {
  50. $list_info[$key][6] = '';
  51. }
  52. }
  53. $parameters = array(
  54. 'visiblelog' => $visible_log,
  55. 'selectcat' => intval($_GET['selectcat']),
  56. );
  57. $table = new SortableTableFromArrayConfig($list_info, 1, 20, 'gradebookeval');
  58. $table->set_additional_parameters($parameters);
  59. $table->set_header(0, get_lang('GradebookNameLog'));
  60. $table->set_header(1, get_lang('GradebookDescriptionLog'));
  61. $table->set_header(2, get_lang('GradebookPreviousWeight'));
  62. $table->set_header(3, get_lang('GradebookVisibilityLog'));
  63. $table->set_header(4, get_lang('ResourceType'));
  64. $table->set_header(5, get_lang('Date'));
  65. $table->set_header(6, get_lang('GradebookWhoChangedItLog'));
  66. $table->display();
  67. Display :: display_footer();