'index.php', "name" => get_lang('Administration')); $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('LDAP Connection Error')); 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 = ''; $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('platformLanguage'), $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').'