ldap_synchro.php 8.2 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @package chamilo.admin
  5. * @deprecated ?
  6. */
  7. /**
  8. * Code
  9. */
  10. exit(); //not yet functional, needs to be revised
  11. // name of the language file that needs to be included
  12. $language_file = 'admin';
  13. $cidReset = true;
  14. require('../inc/global.inc.php');
  15. $libpath = api_get_path(LIBRARY_PATH);
  16. require_once($libpath.'formvalidator/FormValidator.class.php');
  17. require_once($libpath.'usermanager.lib.php');
  18. require_once('../auth/ldap/authldap.php');
  19. $annee_base = date('Y');
  20. // setting the section (for the tabs)
  21. $this_section = SECTION_PLATFORM_ADMIN;
  22. //api_protect_admin_script(); // on vire la secu... qui n'a pas lieu d'etre ici (script de synchro)
  23. // setting breadcrumbs
  24. $interbreadcrumb[] = array('url' => 'index.php', "name" => get_lang('PlatformAdmin'));
  25. $interbreadcrumb[] = array('url' => api_get_self(), "name" => "Liste des sessions");
  26. // Database Table Definitions
  27. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  28. $tbl_session_rel_class = Database::get_main_table(TABLE_MAIN_SESSION_CLASS);
  29. $tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  30. $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  31. $tbl_course = Database::get_main_table(TABLE_MAIN_COURSE);
  32. $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
  33. $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER);
  34. $tbl_class = Database::get_main_table(TABLE_MAIN_CLASS);
  35. $tbl_class_user = Database::get_main_table(TABLE_MAIN_CLASS_USER);
  36. $tbl_session_rel_etape = "session_rel_etape";
  37. $message = "";
  38. $result = Database::query("SELECT id, name FROM $tbl_session");
  39. $Sessions = Database::store_result($result);
  40. $result = Database::query($sql);
  41. $users = Database::store_result($result);
  42. foreach ($Sessions as $session) {
  43. $id_session = $session['id'];
  44. $name_session = $session['name'];
  45. $UserList = array();
  46. $UserUpdate = array();
  47. $UserAdd = array();
  48. // Parse des code etape de la session
  49. /*
  50. $sql = "SELECT id_session, code_etape, etape_description, code_ufr, annee
  51. FROM $tbl_session_rel_etape
  52. WHERE id_session='$id_session'
  53. ORDER BY code_ufr, code_etape";
  54. $result = Database::query($sql);
  55. */
  56. $ds = ldap_connect($ldap_host, $ldap_port) or die(get_lang('LDAPConnectionError'));
  57. ldap_set_version($ds);
  58. // Import des utilisateurs des etapes dans la session
  59. if ($ds) {
  60. $r = false;
  61. $res = ldap_handle_bind($ds, $r);
  62. $UserList = array();
  63. if ($result !== false) {
  64. //while($row = Database::fetch_array($result))
  65. //{
  66. /*
  67. $annee = $row['annee'];
  68. $code_ufr = $row['code_ufr'];
  69. $etape = $row['code_etape'];
  70. */
  71. // LDAP Query
  72. // edupersonorgunitdn=ou=12CI1,ou=2006,ou=diploma,o=Paris1,dc=univ-paris1,dc=fr
  73. //etapescommented
  74. //$sr = @ ldap_search($ds, "ou=people,$LDAPbasedn", "edupersonorgunitdn=ou=$etape,ou=$annee,ou=diploma,$LDAPbasedn");
  75. $sr = @ ldap_search($ds, $ldap_basedn, '(uid=*)');
  76. $info = ldap_get_entries($ds, $sr);
  77. for ($key = 0; $key < $info["count"]; $key++) {
  78. echo "<pre>";
  79. print_r($info[$key]);
  80. echo "</pre>";
  81. $lastname = api_utf8_decode($info[$key]["sn"][0], api_get_system_encoding());
  82. $firstname = api_utf8_decode($info[$key]["givenname"][0], api_get_system_encoding());
  83. $email = $info[$key]["mail"][0];
  84. // Get uid from dn
  85. $dn_array = ldap_explode_dn($info[$key]["dn"], 1);
  86. $username = $dn_array[0]; // uid is first key
  87. $outab[] = $info[$key]["edupersonprimaryaffiliation"][0]; // Ici "student"
  88. $val = ldap_get_values_len($ds, $sr, "userPassword");
  89. $password = $val[0];
  90. // Pour faciliter la gestion on ajoute le code "etape-annee"
  91. $official_code = $etape."-".$annee;
  92. $auth_source = "ldap";
  93. // Pas de date d'expiration d'etudiant (a recuperer par rapport au shadow expire LDAP)
  94. $expiration_date = '0000-00-00 00:00:00';
  95. $active = 1;
  96. // Ajout de l'utilisateur
  97. if (UserManager::is_username_available($username)) {
  98. $user_id = UserManager::create_user(
  99. $firstname,
  100. $lastname,
  101. $status,
  102. $email,
  103. $username,
  104. $password,
  105. $official_code,
  106. api_get_setting('platformLanguage'),
  107. $phone,
  108. $picture_uri,
  109. $auth_source,
  110. $expiration_date,
  111. $active
  112. );
  113. $UserAdd[] = $user_id;
  114. } else {
  115. $user = UserManager::get_user_info($username);
  116. $user_id = $user['user_id'];
  117. UserManager::update_user(
  118. $user_id,
  119. $firstname,
  120. $lastname,
  121. $username,
  122. null,
  123. null,
  124. $email,
  125. $status,
  126. $official_code,
  127. $phone,
  128. $picture_uri,
  129. $expiration_date,
  130. $active
  131. );
  132. $UserUpdate[] = $user_id;
  133. }
  134. $UserList[] = $user_id;
  135. }
  136. //}
  137. }
  138. if (isset($included) && ($included)) {
  139. $message .= "> $name_session: ".count($UserAdd)." ".get_lang('Added').' '.get_lang('And').' '.count(
  140. $UserUpdate
  141. ).' '.get_lang('Modified').'<br/>';
  142. } else {
  143. print "> $name_session: ".count($UserAdd).get_lang('Added').' '.get_lang('And').' '.count(
  144. $UserUpdate
  145. ).' '.get_lang('Modified')."\n";
  146. }
  147. // Une fois les utilisateurs importer dans la base des utilisateurs, on peux les affecter a� la session
  148. $result = Database::query("SELECT c_id FROM $tbl_session_rel_course WHERE id_session='$id_session'");
  149. $CourseList = array();
  150. while ($row = Database::fetch_array($result)) {
  151. $CourseList[] = $row['c_id'];
  152. }
  153. foreach ($CourseList as $courseId) {
  154. // On ajoute la relation entre l'utilisateur et le cours
  155. foreach ($UserList as $enreg_user) {
  156. Database::query(
  157. "INSERT IGNORE INTO $tbl_session_rel_course_rel_user(id_session,c_id,id_user) VALUES('$id_session','$courseId','$enreg_user')"
  158. );
  159. }
  160. $sql = "SELECT COUNT(id_user) as nbUsers ".
  161. "FROM $tbl_session_rel_course_rel_user ".
  162. "WHERE id_session='$id_session' AND c_id='$courseId'";
  163. $rs = Database::query($sql);
  164. list($nbr_users) = Database::fetch_array($rs);
  165. $sql = "UPDATE $tbl_session_rel_course SET nbr_users=$nbr_users WHERE id_session='$id_session' AND c_id='$courseId'";
  166. Database::query($sql);
  167. }
  168. // On ajoute la relation entre l'utilisateur et la session
  169. foreach ($UserList as $enreg_user) {
  170. $sql = "INSERT IGNORE INTO $tbl_session_rel_user(id_session, id_user) ".
  171. "VALUES('$id_session','$enreg_user')";
  172. Database::query($sql);
  173. }
  174. $sql = "SELECT COUNT(id_user) as nbUsers ".
  175. "FROM $tbl_session_rel_user ".
  176. "WHERE id_session='$id_session' AND relation_type<>".SESSION_RELATION_TYPE_RRHH."";
  177. $rs = Database::query($sql);
  178. list($nbr_users) = Database::fetch_array($rs);
  179. $sql = "UPDATE $tbl_session SET nbr_users=$nbr_users WHERE id='$id_session'";
  180. Database::query($sql);
  181. }
  182. }