certificate_report.php 6.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * List all certificates filtered by session/course and month/year
  5. * @author Angel Fernando Quiroz Campos <angel.quiroz@beeznest.com>
  6. * @package chamilo.gradebook
  7. */
  8. use \ChamiloSession as Session;
  9. $cidReset = true;
  10. require_once '../inc/global.inc.php';
  11. $this_section = SECTION_TRACKING;
  12. api_block_anonymous_users();
  13. $interbreadcrumb[] = array(
  14. "url" => api_get_path(WEB_CODE_PATH) . "mySpace/index.php",
  15. "name" => get_lang("MySpace")
  16. );
  17. $selectedSession = isset($_POST['session']) && !empty($_POST['session']) ? intval($_POST['session']) : 0;
  18. $selectedCourse = isset($_POST['course']) && !empty($_POST['course']) ? intval($_POST['course']) : 0;
  19. $selectedMonth = isset($_POST['month']) && !empty($_POST['month']) ? intval($_POST['month']) : 0;
  20. $selectedYear = isset($_POST['year']) && !empty($_POST['year']) ? $_POST['year'] : null;
  21. $userId = api_get_user_id();
  22. $sessions = SessionManager::getSessionsCoachedByUser($userId);
  23. if ($selectedSession > 0) {
  24. if (!SessionManager::isValidId($selectedSession)) {
  25. Session::write('reportErrorMessage', get_lang('NoSession'));
  26. header("Location: $selfUrl");
  27. exit;
  28. }
  29. $courses = SessionManager::get_course_list_by_session_id($selectedSession);
  30. if (is_array($courses)) {
  31. foreach ($courses as &$course) {
  32. $course['real_id'] = $course['id'];
  33. }
  34. }
  35. } else {
  36. $courses = CourseManager::get_courses_list_by_user_id($userId);
  37. if (is_array($courses)) {
  38. foreach ($courses as &$course) {
  39. $courseInfo = api_get_course_info_by_id($course['real_id']);
  40. $course = array_merge($course, $courseInfo);
  41. }
  42. }
  43. }
  44. $months = array();
  45. for ($key = 1; $key <= 12; $key++) {
  46. $months[] = array(
  47. 'key' => $key,
  48. 'name' => sprintf("%02d", $key)
  49. );
  50. }
  51. $exportAllLink = null;
  52. $certificateStudents = array();
  53. $searchSessionAndCourse = $selectedSession > 0 && $selectedCourse > 0;
  54. $searchCourseOnly = $selectedSession <= 0 && $selectedCourse > 0;
  55. if ($searchSessionAndCourse || $searchCourseOnly) {
  56. $selectedCourseInfo = api_get_course_info_by_id($selectedCourse);
  57. if (empty($selectedCourseInfo)) {
  58. Session::write('reportErrorMessage', get_lang('NoCourse'));
  59. header("Location: $selfUrl");
  60. exit;
  61. }
  62. $gradebookCategories = Category::load(null, null, $selectedCourseInfo['code'], null, false, $selectedSession);
  63. $gradebook = null;
  64. if (!empty($gradebookCategories)) {
  65. $gradebook = current($gradebookCategories);
  66. }
  67. if (!is_null($gradebook)) {
  68. $exportAllLink = api_get_path(WEB_CODE_PATH) . "gradebook/gradebook_display_certificate.php?";
  69. $exportAllLink .= http_build_query(array(
  70. "action" => "export_all_certificates",
  71. "cidReq" => $selectedCourseInfo['code'],
  72. "id_session" => 0,
  73. "gidReq" => 0,
  74. "cat_id" => $gradebook->get_id()
  75. ));
  76. $studentList = GradebookUtils::get_list_users_certificates($gradebook->get_id());
  77. $certificateStudents = array();
  78. if (is_array($studentList) && !empty($studentList)) {
  79. foreach ($studentList as $student) {
  80. $certificateStudent = array(
  81. 'fullName' => api_get_person_name($student['firstname'], $student['lastname']),
  82. 'certificates' => array()
  83. );
  84. $studentCertificates = GradebookUtils::get_list_gradebook_certificates_by_user_id(
  85. $student['user_id'],
  86. $gradebook->get_id()
  87. );
  88. if (!is_array($studentCertificates) || empty($studentCertificates)) {
  89. continue;
  90. }
  91. foreach ($studentCertificates as $certificate) {
  92. $creationDate = new DateTime($certificate['created_at']);
  93. $creationMonth = $creationDate->format('m');
  94. $creationYear = $creationDate->format('Y');
  95. $creationMonthYear = $creationDate->format('m Y');
  96. if ($selectedMonth > 0 && empty($selectedYear)) {
  97. if ($creationMonth != $selectedMonth) {
  98. continue;
  99. }
  100. } elseif ($selectedMonth <= 0 && !empty($selectedYear)) {
  101. if ($creationYear != $selectedYear) {
  102. continue;
  103. }
  104. } elseif ($selectedMonth > 0 && !empty($selectedYear)) {
  105. if ($creationMonthYear != sprintf("%d %s", $selectedMonth, $selectedYear)) {
  106. continue;
  107. }
  108. }
  109. $certificateStudent['certificates'][] = array(
  110. 'createdAt' => api_convert_and_format_date($certificate['created_at']),
  111. 'id' => $certificate['id']
  112. );
  113. }
  114. if (count($certificateStudent['certificates']) > 0) {
  115. $certificateStudents[] = $certificateStudent;
  116. }
  117. }
  118. }
  119. }
  120. }
  121. /* View */
  122. $template = new Template(get_lang('GradebookListOfStudentsCertificates'));
  123. if (Session::has('reportErrorMessage')) {
  124. $template->assign('errorMessage', Session::read('reportErrorMessage'));
  125. }
  126. $template->assign('selectedSession', $selectedSession);
  127. $template->assign('selectedCourse', $selectedCourse);
  128. $template->assign('selectedMonth', $selectedMonth);
  129. $template->assign('selectedYear', $selectedYear);
  130. $template->assign('sessions', $sessions);
  131. $template->assign('courses', $courses);
  132. $template->assign('months', $months);
  133. $template->assign('exportAllLink', $exportAllLink);
  134. $template->assign('certificateStudents', $certificateStudents);
  135. $content = $template->fetch("default/gradebook/certificate_report.tpl");
  136. $template->assign('content', $content);
  137. $template->display_one_col_template();
  138. Session::erase('reportErrorMessage');