chamilo /
chamilo-lms
| @@ 4791-4841 (lines=51) @@ | ||
| 4788 | ||
| 4789 | // Un subscribe everyone that's not in the list. |
|
| 4790 | $teacherList = CourseManager::get_teacher_list_from_course_code($course_code); |
|
| 4791 | if (!empty($teacherList)) { |
|
| 4792 | foreach ($teacherList as $teacher) { |
|
| 4793 | if ($teacherToAdd != $teacher['user_id']) { |
|
| 4794 | $sql = "SELECT * FROM ".Database::get_main_table(TABLE_MAIN_COURSE_USER)." |
|
| 4795 | WHERE |
|
| 4796 | user_id = ".$teacher['user_id']." AND |
|
| 4797 | c_id = '".$courseId."' |
|
| 4798 | "; |
|
| 4799 | ||
| 4800 | $result = Database::query($sql); |
|
| 4801 | $rows = Database::num_rows($result); |
|
| 4802 | if ($rows > 0) { |
|
| 4803 | $userCourseData = Database::fetch_array($result, 'ASSOC'); |
|
| 4804 | if (!empty($userCourseData)) { |
|
| 4805 | $teacherBackupList[$teacher['user_id']][$course_code] = $userCourseData; |
|
| 4806 | } |
|
| 4807 | } |
|
| 4808 | ||
| 4809 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_USER)." |
|
| 4810 | WHERE |
|
| 4811 | user_id = ".$teacher['user_id']." AND |
|
| 4812 | c_id = '".$courseInfo['real_id']."' |
|
| 4813 | "; |
|
| 4814 | ||
| 4815 | $result = Database::query($sql); |
|
| 4816 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 4817 | $groupBackup['user'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 4818 | } |
|
| 4819 | ||
| 4820 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_TUTOR)." |
|
| 4821 | WHERE |
|
| 4822 | user_id = ".$teacher['user_id']." AND |
|
| 4823 | c_id = '".$courseInfo['real_id']."' |
|
| 4824 | "; |
|
| 4825 | ||
| 4826 | $result = Database::query($sql); |
|
| 4827 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 4828 | $groupBackup['tutor'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 4829 | } |
|
| 4830 | ||
| 4831 | CourseManager::unsubscribe_user( |
|
| 4832 | $teacher['user_id'], |
|
| 4833 | $course_code |
|
| 4834 | ); |
|
| 4835 | ||
| 4836 | if ($debug) { |
|
| 4837 | $logger->addInfo("Delete user #".$teacher['user_id']." from base course: $course_code"); |
|
| 4838 | } |
|
| 4839 | } |
|
| 4840 | } |
|
| 4841 | } |
|
| 4842 | ||
| 4843 | if (!empty($teacherToAdd)) { |
|
| 4844 | SessionManager::updateCoaches( |
|
| @@ 4923-4973 (lines=51) @@ | ||
| 4920 | // Deleting all course teachers and adding the only coach as teacher. |
|
| 4921 | $teacherList = CourseManager::get_teacher_list_from_course_code($course_code); |
|
| 4922 | ||
| 4923 | if (!empty($teacherList)) { |
|
| 4924 | foreach ($teacherList as $teacher) { |
|
| 4925 | if (!in_array($teacher['user_id'], $teacherToAdd)) { |
|
| 4926 | $sql = "SELECT * FROM ".Database::get_main_table(TABLE_MAIN_COURSE_USER)." |
|
| 4927 | WHERE |
|
| 4928 | user_id = ".$teacher['user_id']." AND |
|
| 4929 | c_id = '".$courseId."' |
|
| 4930 | "; |
|
| 4931 | ||
| 4932 | $result = Database::query($sql); |
|
| 4933 | $rows = Database::num_rows($result); |
|
| 4934 | if ($rows > 0) { |
|
| 4935 | $userCourseData = Database::fetch_array($result, 'ASSOC'); |
|
| 4936 | if (!empty($userCourseData)) { |
|
| 4937 | $teacherBackupList[$teacher['user_id']][$course_code] = $userCourseData; |
|
| 4938 | } |
|
| 4939 | } |
|
| 4940 | ||
| 4941 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_USER)." |
|
| 4942 | WHERE |
|
| 4943 | user_id = ".$teacher['user_id']." AND |
|
| 4944 | c_id = '".$courseInfo['real_id']."' |
|
| 4945 | "; |
|
| 4946 | ||
| 4947 | $result = Database::query($sql); |
|
| 4948 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 4949 | $groupBackup['user'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 4950 | } |
|
| 4951 | ||
| 4952 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_TUTOR)." |
|
| 4953 | WHERE |
|
| 4954 | user_id = ".$teacher['user_id']." AND |
|
| 4955 | c_id = '".$courseInfo['real_id']."' |
|
| 4956 | "; |
|
| 4957 | ||
| 4958 | $result = Database::query($sql); |
|
| 4959 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 4960 | $groupBackup['tutor'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 4961 | } |
|
| 4962 | ||
| 4963 | CourseManager::unsubscribe_user( |
|
| 4964 | $teacher['user_id'], |
|
| 4965 | $course_code |
|
| 4966 | ); |
|
| 4967 | ||
| 4968 | if ($debug) { |
|
| 4969 | $logger->addInfo("Delete user #".$teacher['user_id']." from base course: $course_code"); |
|
| 4970 | } |
|
| 4971 | } |
|
| 4972 | } |
|
| 4973 | } |
|
| 4974 | ||
| 4975 | foreach ($teacherToAdd as $teacherId) { |
|
| 4976 | $userCourseCategory = ''; |
|
