123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192 |
- <?php
- exit();
- $cidReset = true;
- require_once __DIR__.'/../inc/global.inc.php';
- $libpath = api_get_path(LIBRARY_PATH);
- require_once('../auth/ldap/authldap.php');
- $annee_base = date('Y');
- $this_section = SECTION_PLATFORM_ADMIN;
- $interbreadcrumb[] = array('url' => 'index.php', "name" => get_lang('PlatformAdmin'));
- $interbreadcrumb[] = array('url' => api_get_self(), "name" => "Liste des sessions");
- $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();
-
-
- $ds = ldap_connect($ldap_host, $ldap_port) or die(get_lang('LDAPConnectionError'));
- ldap_set_version($ds);
-
- if ($ds)
- {
- $r = false;
- $res = ldap_handle_bind($ds, $r);
- $UserList = array();
- if ($result !== false)
- {
-
-
-
-
-
-
-
- $sr = @ ldap_search($ds, $ldap_basedn, '(uid=*)');
- $info = ldap_get_entries($ds, $sr);
- for ($key = 0; $key < $info["count"]; $key++)
- {
- echo "<pre>";
- print_r($info[$key]);
- echo "</pre>";
- $lastname = api_utf8_decode($info[$key]["sn"][0]);
- $firstname = api_utf8_decode($info[$key]["givenname"][0]);
- $email = $info[$key]["mail"][0];
-
- $dn_array = ldap_explode_dn($info[$key]["dn"], 1);
- $username = $dn_array[0];
- $outab[] = $info[$key]["edupersonprimaryaffiliation"][0];
- $val = ldap_get_values_len($ds, $sr, "userPassword");
- $password = $val[0];
-
- $official_code = $etape."-".$annee;
- $auth_source = "ldap";
-
- $expiration_date = '';
- $active = 1;
-
- 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').'<br/>';
- }
- else
- {
- print "> $name_session: ".count($UserAdd).get_lang('Added').' '.get_lang('And').' '.count($UserUpdate).' '.get_lang('Modified')."\n";
- }
-
- $result = Database::query("SELECT c_id FROM $tbl_session_rel_course WHERE session_id='$id_session'");
- $CourseList = array();
- while ($row = Database::fetch_array($result)) {
- $CourseList[] = $row['c_id'];
- }
- foreach ($CourseList as $enreg_course) {
-
- foreach ($UserList as $enreg_user) {
- $sql = "INSERT IGNORE INTO $tbl_session_rel_course_rel_user(session_id,c_id,user_id)
- VALUES('$id_session','$enreg_course','$enreg_user')";
- Database::query($sql);
- }
- $sql = "SELECT COUNT(user_id) as nbUsers ".
- "FROM $tbl_session_rel_course_rel_user ".
- "WHERE session_id='$id_session' AND c_id='$enreg_course'";
- $rs = Database::query($sql);
- list($nbr_users) = Database::fetch_array($rs);
- $sql = "UPDATE $tbl_session_rel_course SET nbr_users=$nbr_users
- WHERE session_id='$id_session' AND c_id = '$enreg_course'";
- Database::query($sql);
- }
-
- foreach ($UserList as $enreg_user) {
- $sql = "INSERT IGNORE INTO $tbl_session_rel_user(session_id, user_id, registered_at) ".
- "VALUES('$id_session','$enreg_user', '".api_get_utc_datetime()."')";
- Database::query($sql);
- }
- $sql = "SELECT COUNT(user_id) as nbUsers ".
- "FROM $tbl_session_rel_user ".
- "WHERE session_id='$id_session' AND relation_type<>".SESSION_RELATION_TYPE_RRHH."";
- $rs = Database::query($sql);
- list($nbr_users) = Database::fetch_array($rs);
- $sql = "UPDATE $tbl_session SET nbr_users=$nbr_users WHERE id='$id_session'";
- Database::query($sql);
- }
- }
|