Container::getRouter()->generate('administration'),"name" => get_lang('PlatformAdmin')); $interbreadcrumb[]=array('url' => api_get_self(),"name" => "Liste des sessions"); // Database Table Definitions $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION); $tbl_session_rel_class = Database::get_main_table(TABLE_MAIN_SESSION_CLASS); $tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE); $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER); $tbl_course = Database::get_main_table(TABLE_MAIN_COURSE); $tbl_user = Database::get_main_table(TABLE_MAIN_USER); $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER); $tbl_class = Database::get_main_table(TABLE_MAIN_CLASS); $tbl_class_user = Database::get_main_table(TABLE_MAIN_CLASS_USER); $tbl_session_rel_etape = "session_rel_etape"; $message=""; $result=Database::query("SELECT id, name FROM $tbl_session"); $Sessions=Database::store_result($result); $result=Database::query($sql); $users=Database::store_result($result); foreach($Sessions as $session){ $id_session = $session['id']; $name_session = $session['name']; $UserList=array(); $UserUpdate=array(); $UserAdd=array(); // Parse des code etape de la session /* $sql = "SELECT id_session, code_etape, etape_description, code_ufr, annee FROM $tbl_session_rel_etape WHERE id_session='$id_session' ORDER BY code_ufr, code_etape"; $result = Database::query($sql); */ $ds = ldap_connect($ldap_host, $ldap_port) or die(get_lang('LDAPConnectionError')); ldap_set_version($ds); // Import des utilisateurs des etapes dans la session if ($ds) { $r = false; $res = ldap_handle_bind($ds, $r); $UserList=array(); if($result !== false) { //while($row = Database::fetch_array($result)) //{ /* $annee = $row['annee']; $code_ufr = $row['code_ufr']; $etape = $row['code_etape']; */ // LDAP Query // edupersonorgunitdn=ou=12CI1,ou=2006,ou=diploma,o=Paris1,dc=univ-paris1,dc=fr //etapescommented //$sr = @ ldap_search($ds, "ou=people,$LDAPbasedn", "edupersonorgunitdn=ou=$etape,ou=$annee,ou=diploma,$LDAPbasedn"); $sr = @ ldap_search($ds, $ldap_basedn, '(uid=*)'); $info = ldap_get_entries($ds, $sr); for ($key = 0; $key < $info["count"]; $key ++) { echo "
"; print_r($info[$key]); echo ""; $lastname = api_utf8_decode($info[$key]["sn"][0]); $firstname = api_utf8_decode($info[$key]["givenname"][0]); $email = $info[$key]["mail"][0]; // Get uid from dn $dn_array=ldap_explode_dn($info[$key]["dn"],1); $username = $dn_array[0]; // uid is first key $outab[] = $info[$key]["edupersonprimaryaffiliation"][0]; // Ici "student" $val = ldap_get_values_len($ds, $sr, "userPassword"); $password = $val[0]; // Pour faciliter la gestion on ajoute le code "etape-annee" $official_code=$etape."-".$annee; $auth_source="ldap"; // Pas de date d'expiration d'etudiant (a recuperer par rapport au shadow expire LDAP) $expiration_date='0000-00-00 00:00:00'; $active=1; // Ajout de l'utilisateur if (UserManager::is_username_available($username)) { $user_id = UserManager::create_user( $firstname, $lastname, $status, $email, $username, $password, $official_code, api_get_setting('language.platform_language'), $phone, $picture_uri, $auth_source, $expiration_date, $active ); $UserAdd[]=$user_id; } else { $user = api_get_user_info_from_username($username); $user_id=$user['user_id']; UserManager::update_user($user_id, $firstname, $lastname, $username, null, null, $email, $status, $official_code, $phone, $picture_uri, $expiration_date, $active); $UserUpdate[]=$user_id; } $UserList[]=$user_id; } //} } if (isset($included) && ($included)) { $message .= "> $name_session: ".count($UserAdd)." ".get_lang('Added').' '.get_lang('And').' '.count($UserUpdate).' '.get_lang('Modified').'