chamilo /
chamilo-lms
| @@ 4782-4827 (lines=46) @@ | ||
| 4779 | ||
| 4780 | // Un subscribe everyone that's not in the list. |
|
| 4781 | $teacherList = CourseManager::get_teacher_list_from_course_code($course_code); |
|
| 4782 | if (!empty($teacherList)) { |
|
| 4783 | foreach ($teacherList as $teacher) { |
|
| 4784 | if ($teacherToAdd != $teacher['user_id']) { |
|
| 4785 | $sql = "SELECT * FROM ".Database::get_main_table(TABLE_MAIN_COURSE_USER)." |
|
| 4786 | WHERE |
|
| 4787 | user_id = ".$teacher['user_id']." AND |
|
| 4788 | course_code = '".$course_code."' |
|
| 4789 | "; |
|
| 4790 | ||
| 4791 | $result = Database::query($sql); |
|
| 4792 | $userCourseData = Database::fetch_array($result, 'ASSOC'); |
|
| 4793 | $teacherBackupList[$teacher['user_id']][$course_code] = $userCourseData; |
|
| 4794 | ||
| 4795 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_USER)." |
|
| 4796 | WHERE |
|
| 4797 | user_id = ".$teacher['user_id']." AND |
|
| 4798 | c_id = '".$courseInfo['real_id']."' |
|
| 4799 | "; |
|
| 4800 | ||
| 4801 | $result = Database::query($sql); |
|
| 4802 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 4803 | $groupBackup['user'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 4804 | } |
|
| 4805 | ||
| 4806 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_TUTOR)." |
|
| 4807 | WHERE |
|
| 4808 | user_id = ".$teacher['user_id']." AND |
|
| 4809 | c_id = '".$courseInfo['real_id']."' |
|
| 4810 | "; |
|
| 4811 | ||
| 4812 | $result = Database::query($sql); |
|
| 4813 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 4814 | $groupBackup['tutor'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 4815 | } |
|
| 4816 | ||
| 4817 | CourseManager::unsubscribe_user( |
|
| 4818 | $teacher['user_id'], |
|
| 4819 | $course_code |
|
| 4820 | ); |
|
| 4821 | ||
| 4822 | if ($debug) { |
|
| 4823 | $logger->addInfo("Delete user #".$teacher['user_id']." from base course: $course_code"); |
|
| 4824 | } |
|
| 4825 | } |
|
| 4826 | } |
|
| 4827 | } |
|
| 4828 | ||
| 4829 | if (!empty($teacherToAdd)) { |
|
| 4830 | SessionManager::updateCoaches( |
|
| @@ 4909-4955 (lines=47) @@ | ||
| 4906 | // Deleting all course teachers and adding the only coach as teacher. |
|
| 4907 | $teacherList = CourseManager::get_teacher_list_from_course_code($course_code); |
|
| 4908 | ||
| 4909 | if (!empty($teacherList)) { |
|
| 4910 | foreach ($teacherList as $teacher) { |
|
| 4911 | if (!in_array($teacher['user_id'], $teacherToAdd)) { |
|
| 4912 | ||
| 4913 | $sql = "SELECT * FROM ".Database::get_main_table(TABLE_MAIN_COURSE_USER)." |
|
| 4914 | WHERE |
|
| 4915 | user_id = ".$teacher['user_id']." AND |
|
| 4916 | course_code = '".$course_code."' |
|
| 4917 | "; |
|
| 4918 | ||
| 4919 | $result = Database::query($sql); |
|
| 4920 | $userCourseData = Database::fetch_array($result, 'ASSOC'); |
|
| 4921 | $teacherBackupList[$teacher['user_id']][$course_code] = $userCourseData; |
|
| 4922 | ||
| 4923 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_USER)." |
|
| 4924 | WHERE |
|
| 4925 | user_id = ".$teacher['user_id']." AND |
|
| 4926 | c_id = '".$courseInfo['real_id']."' |
|
| 4927 | "; |
|
| 4928 | ||
| 4929 | $result = Database::query($sql); |
|
| 4930 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 4931 | $groupBackup['user'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 4932 | } |
|
| 4933 | ||
| 4934 | $sql = "SELECT * FROM ".Database::get_course_table(TABLE_GROUP_TUTOR)." |
|
| 4935 | WHERE |
|
| 4936 | user_id = ".$teacher['user_id']." AND |
|
| 4937 | c_id = '".$courseInfo['real_id']."' |
|
| 4938 | "; |
|
| 4939 | ||
| 4940 | $result = Database::query($sql); |
|
| 4941 | while ($groupData = Database::fetch_array($result, 'ASSOC')) { |
|
| 4942 | $groupBackup['tutor'][$teacher['user_id']][$course_code][$groupData['group_id']] = $groupData; |
|
| 4943 | } |
|
| 4944 | ||
| 4945 | CourseManager::unsubscribe_user( |
|
| 4946 | $teacher['user_id'], |
|
| 4947 | $course_code |
|
| 4948 | ); |
|
| 4949 | ||
| 4950 | if ($debug) { |
|
| 4951 | $logger->addInfo("Delete user #".$teacher['user_id']." from base course: $course_code"); |
|
| 4952 | } |
|
| 4953 | } |
|
| 4954 | } |
|
| 4955 | } |
|
| 4956 | ||
| 4957 | foreach ($teacherToAdd as $teacherId) { |
|
| 4958 | $userCourseCategory = ''; |
|
