chamilo /
chamilo-lms
| @@ 4998-5048 (lines=51) @@ | ||
| 4995 | ||
| 4996 | // Un subscribe everyone that's not in the list. |
|
| 4997 | $teacherList = CourseManager::get_teacher_list_from_course_code($course_code); |
|
| 4998 | if (!empty($teacherList)) { |
|
| 4999 | foreach ($teacherList as $teacher) { |
|
| 5000 | if ($teacherToAdd != $teacher['user_id']) { |
|
| 5001 | $sql = "SELECT * FROM ".Database::get_main_table(TABLE_MAIN_COURSE_USER)." |
|
| 5002 | WHERE |
|
| 5003 | user_id = ".$teacher['user_id']." AND |
|
| 5004 | c_id = '".$courseId."' |
|
| 5005 | "; |
|
| 5006 | ||
| 5007 | $result = Database::query($sql); |
|
| 5008 | $rows = Database::num_rows($result); |
|
| 5009 | if ($rows > 0) { |
|
| 5010 | $userCourseData = Database::fetch_array($result, 'ASSOC'); |
|
| 5011 | if (!empty($userCourseData)) { |
|
| 5012 | $teacherBackupList[$teacher['user_id']][$course_code] = $userCourseData; |
|
| 5013 | } |
|
| 5014 | } |
|
| 5015 | ||
| 5016 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_USER)." |
|
| 5017 | WHERE |
|
| 5018 | user_id = ".$teacher['user_id']." AND |
|
| 5019 | c_id = '".$courseInfo['real_id']."' |
|
| 5020 | "; |
|
| 5021 | ||
| 5022 | $result = Database::query($sql); |
|
| 5023 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 5024 | $groupBackup['user'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 5025 | } |
|
| 5026 | ||
| 5027 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_TUTOR)." |
|
| 5028 | WHERE |
|
| 5029 | user_id = ".$teacher['user_id']." AND |
|
| 5030 | c_id = '".$courseInfo['real_id']."' |
|
| 5031 | "; |
|
| 5032 | ||
| 5033 | $result = Database::query($sql); |
|
| 5034 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 5035 | $groupBackup['tutor'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 5036 | } |
|
| 5037 | ||
| 5038 | CourseManager::unsubscribe_user( |
|
| 5039 | $teacher['user_id'], |
|
| 5040 | $course_code |
|
| 5041 | ); |
|
| 5042 | ||
| 5043 | if ($debug) { |
|
| 5044 | $logger->addInfo("Delete user #".$teacher['user_id']." from base course: $course_code"); |
|
| 5045 | } |
|
| 5046 | } |
|
| 5047 | } |
|
| 5048 | } |
|
| 5049 | ||
| 5050 | if (!empty($teacherToAdd)) { |
|
| 5051 | self::updateCoaches( |
|
| @@ 5132-5182 (lines=51) @@ | ||
| 5129 | // Deleting all course teachers and adding the only coach as teacher. |
|
| 5130 | $teacherList = CourseManager::get_teacher_list_from_course_code($course_code); |
|
| 5131 | ||
| 5132 | if (!empty($teacherList)) { |
|
| 5133 | foreach ($teacherList as $teacher) { |
|
| 5134 | if (!in_array($teacher['user_id'], $teacherToAdd)) { |
|
| 5135 | $sql = "SELECT * FROM ".Database::get_main_table(TABLE_MAIN_COURSE_USER)." |
|
| 5136 | WHERE |
|
| 5137 | user_id = ".$teacher['user_id']." AND |
|
| 5138 | c_id = '".$courseId."' |
|
| 5139 | "; |
|
| 5140 | ||
| 5141 | $result = Database::query($sql); |
|
| 5142 | $rows = Database::num_rows($result); |
|
| 5143 | if ($rows > 0) { |
|
| 5144 | $userCourseData = Database::fetch_array($result, 'ASSOC'); |
|
| 5145 | if (!empty($userCourseData)) { |
|
| 5146 | $teacherBackupList[$teacher['user_id']][$course_code] = $userCourseData; |
|
| 5147 | } |
|
| 5148 | } |
|
| 5149 | ||
| 5150 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_USER)." |
|
| 5151 | WHERE |
|
| 5152 | user_id = ".$teacher['user_id']." AND |
|
| 5153 | c_id = '".$courseInfo['real_id']."' |
|
| 5154 | "; |
|
| 5155 | ||
| 5156 | $result = Database::query($sql); |
|
| 5157 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 5158 | $groupBackup['user'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 5159 | } |
|
| 5160 | ||
| 5161 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_TUTOR)." |
|
| 5162 | WHERE |
|
| 5163 | user_id = ".$teacher['user_id']." AND |
|
| 5164 | c_id = '".$courseInfo['real_id']."' |
|
| 5165 | "; |
|
| 5166 | ||
| 5167 | $result = Database::query($sql); |
|
| 5168 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 5169 | $groupBackup['tutor'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 5170 | } |
|
| 5171 | ||
| 5172 | CourseManager::unsubscribe_user( |
|
| 5173 | $teacher['user_id'], |
|
| 5174 | $course_code |
|
| 5175 | ); |
|
| 5176 | ||
| 5177 | if ($debug) { |
|
| 5178 | $logger->addInfo("Delete user #".$teacher['user_id']." from base course: $course_code"); |
|
| 5179 | } |
|
| 5180 | } |
|
| 5181 | } |
|
| 5182 | } |
|
| 5183 | ||
| 5184 | foreach ($teacherToAdd as $teacherId) { |
|
| 5185 | $userCourseCategory = ''; |
|
