chamilo /
chamilo-lms
| @@ 4881-4931 (lines=51) @@ | ||
| 4878 | ||
| 4879 | // Un subscribe everyone that's not in the list. |
|
| 4880 | $teacherList = CourseManager::get_teacher_list_from_course_code($course_code); |
|
| 4881 | if (!empty($teacherList)) { |
|
| 4882 | foreach ($teacherList as $teacher) { |
|
| 4883 | if ($teacherToAdd != $teacher['user_id']) { |
|
| 4884 | $sql = "SELECT * FROM ".Database::get_main_table(TABLE_MAIN_COURSE_USER)." |
|
| 4885 | WHERE |
|
| 4886 | user_id = ".$teacher['user_id']." AND |
|
| 4887 | c_id = '".$courseId."' |
|
| 4888 | "; |
|
| 4889 | ||
| 4890 | $result = Database::query($sql); |
|
| 4891 | $rows = Database::num_rows($result); |
|
| 4892 | if ($rows > 0) { |
|
| 4893 | $userCourseData = Database::fetch_array($result, 'ASSOC'); |
|
| 4894 | if (!empty($userCourseData)) { |
|
| 4895 | $teacherBackupList[$teacher['user_id']][$course_code] = $userCourseData; |
|
| 4896 | } |
|
| 4897 | } |
|
| 4898 | ||
| 4899 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_USER)." |
|
| 4900 | WHERE |
|
| 4901 | user_id = ".$teacher['user_id']." AND |
|
| 4902 | c_id = '".$courseInfo['real_id']."' |
|
| 4903 | "; |
|
| 4904 | ||
| 4905 | $result = Database::query($sql); |
|
| 4906 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 4907 | $groupBackup['user'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 4908 | } |
|
| 4909 | ||
| 4910 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_TUTOR)." |
|
| 4911 | WHERE |
|
| 4912 | user_id = ".$teacher['user_id']." AND |
|
| 4913 | c_id = '".$courseInfo['real_id']."' |
|
| 4914 | "; |
|
| 4915 | ||
| 4916 | $result = Database::query($sql); |
|
| 4917 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 4918 | $groupBackup['tutor'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 4919 | } |
|
| 4920 | ||
| 4921 | CourseManager::unsubscribe_user( |
|
| 4922 | $teacher['user_id'], |
|
| 4923 | $course_code |
|
| 4924 | ); |
|
| 4925 | ||
| 4926 | if ($debug) { |
|
| 4927 | $logger->addInfo("Delete user #".$teacher['user_id']." from base course: $course_code"); |
|
| 4928 | } |
|
| 4929 | } |
|
| 4930 | } |
|
| 4931 | } |
|
| 4932 | ||
| 4933 | if (!empty($teacherToAdd)) { |
|
| 4934 | self::updateCoaches( |
|
| @@ 5015-5065 (lines=51) @@ | ||
| 5012 | // Deleting all course teachers and adding the only coach as teacher. |
|
| 5013 | $teacherList = CourseManager::get_teacher_list_from_course_code($course_code); |
|
| 5014 | ||
| 5015 | if (!empty($teacherList)) { |
|
| 5016 | foreach ($teacherList as $teacher) { |
|
| 5017 | if (!in_array($teacher['user_id'], $teacherToAdd)) { |
|
| 5018 | $sql = "SELECT * FROM ".Database::get_main_table(TABLE_MAIN_COURSE_USER)." |
|
| 5019 | WHERE |
|
| 5020 | user_id = ".$teacher['user_id']." AND |
|
| 5021 | c_id = '".$courseId."' |
|
| 5022 | "; |
|
| 5023 | ||
| 5024 | $result = Database::query($sql); |
|
| 5025 | $rows = Database::num_rows($result); |
|
| 5026 | if ($rows > 0) { |
|
| 5027 | $userCourseData = Database::fetch_array($result, 'ASSOC'); |
|
| 5028 | if (!empty($userCourseData)) { |
|
| 5029 | $teacherBackupList[$teacher['user_id']][$course_code] = $userCourseData; |
|
| 5030 | } |
|
| 5031 | } |
|
| 5032 | ||
| 5033 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_USER)." |
|
| 5034 | WHERE |
|
| 5035 | user_id = ".$teacher['user_id']." AND |
|
| 5036 | c_id = '".$courseInfo['real_id']."' |
|
| 5037 | "; |
|
| 5038 | ||
| 5039 | $result = Database::query($sql); |
|
| 5040 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 5041 | $groupBackup['user'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 5042 | } |
|
| 5043 | ||
| 5044 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_TUTOR)." |
|
| 5045 | WHERE |
|
| 5046 | user_id = ".$teacher['user_id']." AND |
|
| 5047 | c_id = '".$courseInfo['real_id']."' |
|
| 5048 | "; |
|
| 5049 | ||
| 5050 | $result = Database::query($sql); |
|
| 5051 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 5052 | $groupBackup['tutor'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 5053 | } |
|
| 5054 | ||
| 5055 | CourseManager::unsubscribe_user( |
|
| 5056 | $teacher['user_id'], |
|
| 5057 | $course_code |
|
| 5058 | ); |
|
| 5059 | ||
| 5060 | if ($debug) { |
|
| 5061 | $logger->addInfo("Delete user #".$teacher['user_id']." from base course: $course_code"); |
|
| 5062 | } |
|
| 5063 | } |
|
| 5064 | } |
|
| 5065 | } |
|
| 5066 | ||
| 5067 | foreach ($teacherToAdd as $teacherId) { |
|
| 5068 | $userCourseCategory = ''; |
|
