123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337 |
- <?php
- /* For licensing terms, see /license.txt */
- use ChamiloSession as Session;
- /**
- * List all certificates filtered by session/course and month/year.
- *
- * @author Angel Fernando Quiroz Campos <angel.quiroz@beeznest.com>
- *
- * @package chamilo.gradebook
- */
- $cidReset = true;
- require_once __DIR__.'/../inc/global.inc.php';
- api_block_anonymous_users();
- $is_allowedToTrack = api_is_platform_admin(true) || api_is_student_boss();
- if (!$is_allowedToTrack) {
- api_not_allowed(true);
- }
- $this_section = SECTION_TRACKING;
- $interbreadcrumb[] = [
- "url" => api_is_student_boss() ? "#" : api_get_path(WEB_CODE_PATH)."mySpace/index.php?".api_get_cidreq(),
- "name" => get_lang("MySpace"),
- ];
- $selectedSession = isset($_POST['session']) && !empty($_POST['session']) ? intval($_POST['session']) : 0;
- $selectedCourse = isset($_POST['course']) && !empty($_POST['course']) ? intval($_POST['course']) : 0;
- $selectedMonth = isset($_POST['month']) && !empty($_POST['month']) ? intval($_POST['month']) : 0;
- $selectedYear = isset($_POST['year']) && !empty($_POST['year']) ? trim($_POST['year']) : null;
- $selectedStudent = isset($_POST['student']) && !empty($_POST['student']) ? intval($_POST['student']) : 0;
- $userId = api_get_user_id();
- $sessions = $courses = $months = $students = [0 => get_lang('Select')];
- $userList = [];
- if (api_is_student_boss()) {
- $userGroup = new UserGroup();
- $userList = $userGroup->getGroupUsersByUser($userId);
- $sessionsList = SessionManager::getSessionsFollowedForGroupAdmin($userId);
- } else {
- $sessionsList = SessionManager::getSessionsCoachedByUser(
- $userId,
- false,
- api_is_platform_admin()
- );
- }
- foreach ($sessionsList as $session) {
- $sessions[$session['id']] = $session['name'];
- }
- if ($selectedSession > 0) {
- if (!SessionManager::isValidId($selectedSession)) {
- Display::addFlash(Display::return_message(get_lang('NoSession')));
- header("Location: $selfUrl");
- exit;
- }
- $coursesList = SessionManager::get_course_list_by_session_id($selectedSession);
- if (is_array($coursesList)) {
- foreach ($coursesList as &$course) {
- $course['real_id'] = $course['id'];
- }
- }
- } else {
- if (api_is_student_boss()) {
- $coursesList = CourseManager::getCoursesFollowedByGroupAdmin($userId);
- } else {
- $coursesList = CourseManager::get_courses_list_by_user_id(
- $userId,
- false,
- true
- );
- if (is_array($coursesList)) {
- foreach ($coursesList as &$course) {
- $courseInfo = api_get_course_info_by_id($course['real_id']);
- $course = array_merge($course, $courseInfo);
- }
- }
- }
- }
- foreach ($coursesList as $course) {
- if (isset($course['real_id'])) {
- $courses[$course['real_id']] = $course['title'];
- } else {
- $courses[$course['id']] = $course['title'];
- }
- }
- for ($key = 1; $key <= 12; $key++) {
- $months[$key] = sprintf("%02d", $key);
- }
- $exportAllLink = null;
- $certificateStudents = [];
- $searchSessionAndCourse = $selectedSession > 0 && $selectedCourse > 0;
- $searchCourseOnly = $selectedSession <= 0 && $selectedCourse > 0;
- $searchStudentOnly = $selectedStudent > 0;
- if ($searchSessionAndCourse || $searchCourseOnly) {
- $selectedCourseInfo = api_get_course_info_by_id($selectedCourse);
- if (empty($selectedCourseInfo)) {
- Display::addFlash(Display::return_message(get_lang('NoCourse')));
- header("Location: $selfUrl");
- exit;
- }
- $gradebookCategories = Category::load(
- null,
- null,
- $selectedCourseInfo['code'],
- null,
- false,
- $selectedSession
- );
- $gradebook = null;
- if (!empty($gradebookCategories)) {
- $gradebook = current($gradebookCategories);
- }
- if (!is_null($gradebook)) {
- $exportAllLink = api_get_path(WEB_CODE_PATH)."gradebook/gradebook_display_certificate.php?";
- $exportAllLink .= http_build_query([
- "action" => "export_all_certificates",
- "cidReq" => $selectedCourseInfo['code'],
- "id_session" => 0,
- "gidReq" => 0,
- "cat_id" => $gradebook->get_id(),
- ]);
- $sessionName = api_get_session_name($selectedSession);
- $courseName = api_get_course_info($selectedCourseInfo['code'])['title'];
- $studentList = GradebookUtils::get_list_users_certificates($gradebook->get_id());
- $certificateStudents = [];
- if (is_array($studentList) && !empty($studentList)) {
- foreach ($studentList as $student) {
- if (api_is_student_boss() && !in_array($student['user_id'], $userList)) {
- continue;
- }
- $certificateStudent = [
- 'fullName' => api_get_person_name($student['firstname'], $student['lastname']),
- 'sessionName' => $sessionName,
- 'courseName' => $courseName,
- 'certificates' => [],
- ];
- $studentCertificates = GradebookUtils::get_list_gradebook_certificates_by_user_id(
- $student['user_id'],
- $gradebook->get_id()
- );
- if (!is_array($studentCertificates) || empty($studentCertificates)) {
- continue;
- }
- foreach ($studentCertificates as $certificate) {
- $creationDate = new DateTime($certificate['created_at']);
- $creationMonth = $creationDate->format('m');
- $creationYear = $creationDate->format('Y');
- $creationMonthYear = $creationDate->format('m Y');
- if ($selectedMonth > 0 && empty($selectedYear)) {
- if ($creationMonth != $selectedMonth) {
- continue;
- }
- } elseif ($selectedMonth <= 0 && !empty($selectedYear)) {
- if ($creationYear != $selectedYear) {
- continue;
- }
- } elseif ($selectedMonth > 0 && !empty($selectedYear)) {
- if ($creationMonthYear != sprintf("%02d %s", $selectedMonth, $selectedYear)) {
- continue;
- }
- }
- $certificateStudent['certificates'][] = [
- 'createdAt' => api_convert_and_format_date($certificate['created_at']),
- 'id' => $certificate['id'],
- ];
- }
- if (count($certificateStudent['certificates']) > 0) {
- $certificateStudents[] = $certificateStudent;
- }
- }
- }
- }
- } elseif ($searchStudentOnly) {
- $selectedStudentInfo = api_get_user_info($selectedStudent);
- if (empty($selectedStudentInfo)) {
- Display::addFlash(Display::return_message(get_lang('NoUser')));
- header('Location: '.$selfUrl);
- exit;
- }
- $sessionList = SessionManager::getSessionsFollowedByUser($selectedStudent);
- foreach ($sessionList as $session) {
- $sessionCourseList = SessionManager::get_course_list_by_session_id($session['id']);
- foreach ($sessionCourseList as $sessionCourse) {
- $gradebookCategories = Category::load(
- null,
- null,
- $sessionCourse['code'],
- null,
- false,
- $session['id']
- );
- $gradebook = null;
- if (!empty($gradebookCategories)) {
- $gradebook = current($gradebookCategories);
- }
- if (!is_null($gradebook)) {
- $sessionName = $session['name'];
- $courseName = $sessionCourse['title'];
- $certificateStudent = [
- 'fullName' => $selectedStudentInfo['complete_name'],
- 'sessionName' => $sessionName,
- 'courseName' => $courseName,
- 'certificates' => [],
- ];
- $studentCertificates = GradebookUtils::get_list_gradebook_certificates_by_user_id(
- $selectedStudent,
- $gradebook->get_id()
- );
- if (!is_array($studentCertificates) || empty($studentCertificates)) {
- continue;
- }
- foreach ($studentCertificates as $certificate) {
- $certificateStudent['certificates'][] = [
- 'createdAt' => api_convert_and_format_date($certificate['created_at']),
- 'id' => $certificate['id'],
- ];
- }
- if (count($certificateStudent['certificates']) > 0) {
- $certificateStudents[] = $certificateStudent;
- }
- }
- }
- }
- }
- /* View */
- $template = new Template(get_lang('GradebookListOfStudentsCertificates'));
- $form = new FormValidator(
- 'certificate_report_form',
- 'post',
- api_get_path(WEB_CODE_PATH).'gradebook/certificate_report.php'
- );
- $form->addSelect('session', get_lang('Sessions'), $sessions, ['id' => 'session']);
- $form->addSelect('course', get_lang('Courses'), $courses, ['id' => 'course']);
- $form->addGroup(
- [
- $form->createElement(
- 'select',
- 'month',
- null,
- $months,
- ['id' => 'month']
- ),
- $form->createElement(
- 'text',
- 'year',
- null,
- ['id' => 'year', 'placeholder' => get_lang('Year')]
- ),
- ],
- null,
- get_lang('Date')
- );
- $form->addButtonSearch();
- $form->setDefaults([
- 'session' => $selectedSession,
- 'course' => $selectedCourse,
- 'month' => $selectedMonth,
- 'year' => $selectedYear,
- ]);
- if (api_is_student_boss()) {
- foreach ($userList as $studentId) {
- $students[$studentId] = api_get_user_info($studentId)['complete_name_with_username'];
- }
- $searchForm = new FormValidator(
- 'certificate_report_form',
- 'post',
- api_get_path(WEB_CODE_PATH).'gradebook/certificate_report.php'
- );
- $searchForm->addSelect('student', get_lang('Students'), $students, ['id' => 'student']);
- $searchForm->addButtonSearch();
- $searchForm->setDefaults([
- 'student' => $selectedStudent,
- ]);
- $template->assign('search_form', $searchForm->returnForm());
- }
- $template->assign('search_by_session_form', $form->returnForm());
- $template->assign('sessions', $sessions);
- $template->assign('courses', $courses);
- $template->assign('months', $months);
- $template->assign('export_all_link', $exportAllLink);
- $template->assign('certificate_students', $certificateStudents);
- $templateName = $template->get_template('gradebook/certificate_report.tpl');
- $content = $template->fetch($templateName);
- $template->assign('content', $content);
- $template->display_one_col_template();
|