"index.php","name" => get_lang('AdministrationTools')); $interbreadcrumb[]=array("url" => "session_list.php","name" => "Liste des sessions"); if($_POST['formSent']) { $formSent=$_POST['formSent']; $firstLetterCourse=$_POST['firstLetterCourse']; $firstLetterSession=$_POST['firstLetterSession']; $CourseList=$_POST['SessionCoursesList']; if(!is_array($CourseList)) { $CourseList=array(); } $nbr_courses=0; $id_coach = api_sql_query("SELECT id_coach FROM $tbl_session WHERE id=$id_session"); $id_coach = mysql_fetch_array($id_coach); $id_coach = $id_coach[0]; $rs = api_sql_query("SELECT course_code FROM $tbl_session_rel_course WHERE id_session=$id_session"); $existingCourses = api_store_result($rs); $sql="SELECT id_user FROM $tbl_session_rel_user WHERE id_session = $id_session"; $result=api_sql_query($sql,__FILE__,__LINE__); $UserList=api_store_result($result); foreach($CourseList as $enreg_course) { $exists = false; foreach($existingCourses as $existingCourse){ if($enreg_course == $existingCourse['course_code']){ $exists=true; } } if(!$exists){ api_sql_query("INSERT INTO $tbl_session_rel_course(id_session,course_code, id_coach) VALUES('$id_session','$enreg_course','$id_coach')",__FILE__,__LINE__); $nbr_users=0; foreach($UserList as $enreg_user) { $enreg_user = $enreg_user['id_user']; api_sql_query("INSERT IGNORE INTO $tbl_session_rel_course_rel_user(id_session,course_code,id_user) VALUES('$id_session','$enreg_course','$enreg_user')",__FILE__,__LINE__); if(mysql_affected_rows()) { $nbr_users++; } } api_sql_query("UPDATE $tbl_session_rel_course SET nbr_users=$nbr_users WHERE id_session='$id_session' AND course_code='$enreg_course'",__FILE__,__LINE__); } } foreach($existingCourses as $existingCourse) { if(!in_array($existingCourse['course_code'], $CourseList)){ api_sql_query("DELETE FROM $tbl_session_rel_course WHERE course_code='".$existingCourse['course_code']."' AND id_session=$id_session"); api_sql_query("DELETE FROM $tbl_session_rel_course_rel_user WHERE course_code='".$existingCourse['course_code']."' AND id_session=$id_session"); } } $nbr_courses=count($CourseList); api_sql_query("UPDATE $tbl_session SET nbr_courses=$nbr_courses WHERE id='$id_session'",__FILE__,__LINE__); if(isset($_GET['add'])) header('Location: add_users_to_session.php?id_session='.$id_session.'&add=true'); else header('Location: resume_session.php?id_session='.$id_session); //header('Location: '.$_GET['page'].'?id_session='.$id_session); } Display::display_header($tool_name); api_display_tool_title($tool_name); $sql="SELECT code, title, visual_code, id_session FROM $tbl_course LEFT JOIN $tbl_session_rel_course ON code = course_code ORDER BY ".(sizeof($courses)?"(code IN(".implode(',',$courses).")) DESC,":"")." title"; $result=api_sql_query($sql,__FILE__,__LINE__); $Courses=api_store_result($result); $nosessionCourses = $sessionCourses = array(); foreach($Courses as $course) if($course['id_session'] == $id_session) $sessionCourses[$course['code']] = $course ; foreach($Courses as $course) if(empty($sessionCourses[$course['code']]) && empty($nosessionCourses[$course['code']])) $nosessionCourses[$course['code']] = $course ; unset($Courses); ?>