ldap_import_students_to_session.php 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766
  1. <?php //$id: $
  2. /*
  3. ==============================================================================
  4. Dokeos - elearning and course management software
  5. Copyright (c) 2008 Dokeos SPRL
  6. Copyright (c) 2007 Mustapha Alouani (supervised by Michel Moreau-Belliard)
  7. For a full list of contributors, see "credits.txt".
  8. The full license can be read in "license.txt".
  9. This program is free software; you can redistribute it and/or
  10. modify it under the terms of the GNU General Public License
  11. as published by the Free Software Foundation; either version 2
  12. of the License, or (at your option) any later version.
  13. See the GNU General Public License for more details.
  14. Contact: Dokeos, rue du Corbeau, 108, B-1030 Brussels, Belgium, info@dokeos.com
  15. ==============================================================================
  16. */
  17. /**
  18. ==============================================================================
  19. * @package dokeos.admin
  20. ==============================================================================
  21. */
  22. // name of the language file that needs to be included
  23. $language_file='admin';
  24. $cidReset=true;
  25. require_once('../inc/global.inc.php');
  26. // setting the section (for the tabs)
  27. $this_section = SECTION_PLATFORM_ADMIN;
  28. api_protect_admin_script();
  29. $libpath = api_get_path(LIBRARY_PATH);
  30. require_once($libpath.'formvalidator/FormValidator.class.php');
  31. include_once($libpath.'usermanager.lib.php');
  32. require('../auth/ldap/authldap.php');
  33. $annee_base=date('Y');
  34. // setting breadcrumbs
  35. $interbreadcrumb[]=array('url' => 'index.php',"name" => get_lang('PlatformAdmin'));
  36. $interbreadcrumb[]=array('url' => api_get_self(),"name" => get_lang('SessionList'));
  37. // Database Table Definitions
  38. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  39. $tbl_session_rel_class = Database::get_main_table(TABLE_MAIN_SESSION_CLASS);
  40. $tbl_session_rel_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  41. $tbl_session_rel_course_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  42. $tbl_course = Database::get_main_table(TABLE_MAIN_COURSE);
  43. $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
  44. $tbl_session_rel_user = Database::get_main_table(TABLE_MAIN_SESSION_USER);
  45. $tbl_class = Database::get_main_table(TABLE_MAIN_CLASS);
  46. $tbl_class_user = Database::get_main_table(TABLE_MAIN_CLASS_USER);
  47. $tbl_session_rel_etape = "session_rel_etape";
  48. $id_session=intval($_GET['id_session']);
  49. $formSent=0;
  50. $errorMsg=$firstLetterUser=$firstLetterSession='';
  51. $UserList=$SessionList=array();
  52. $users=$sessions=array();
  53. $noPHP_SELF=true;
  54. $page=intval($_GET['page']);
  55. $action=$_REQUEST['action'];
  56. $sort=in_array($_GET['sort'],array('name','nbr_courses','date_start','date_end'))?$_GET['sort']:'name';
  57. $idChecked = $_REQUEST['idChecked'];
  58. $annee = intval($_GET['annee']);
  59. $composante = $_GET['composante'];
  60. $etape = $_GET['etape'];
  61. if (isset($id_session) && $id_session!="")
  62. {
  63. $tool_name = get_lang('LDAPImportUsersSteps');;
  64. Display::display_header($tool_name);
  65. //api_display_tool_title($tool_name);
  66. if (isset($action) && ($action=="add")) {
  67. // ICI Selection ETAPE a partir de LDAP
  68. // form1 annee = 0; composante= 0 etape = 0
  69. if ($annee == "" && $composante == "" && $etape == "") {
  70. echo '<div style="align:center">';
  71. echo '<h3><img src=\"../img/group.gif\" alt="'.get_lang('EnterStepToAddToYourSession').'" />'.get_lang('EnterStepToAddToYourSession').'</h3>';
  72. echo '<b>'.get_lang('ToDoThisYouMustEnterYearDepartmentAndStep').'</b><br />';
  73. echo get_lang('FollowEachOfTheseStepsStepByStep').'<br />';
  74. echo '<form method="get" action="'.api_get_self().'"><br />';
  75. echo '<b>'.sprintf(get_lang('RegistrationYearExample'),date('Y'),date('Y'),date('Y')+1).' :</b>';
  76. echo '<input type="text" name="annee" size="4" maxlength="30" value="'.$annee_base.'"><br />';
  77. echo '<input type="hidden" name="id_session" value="'.$id_session.'">';
  78. echo '<input type="hidden" name="action" value="add">';
  79. echo '<input type="submit" value="'.get_lang('Submit').'">';
  80. echo '</form>';
  81. echo '</div>';
  82. }
  83. // form 2 annee != 0; composante= 0 etape = 0
  84. elseif ($annee <> "" && $composante == "" && $etape == "") {
  85. $ds = ldap_connect($ldap_host, $ldap_port) or die(get_lang('LDAPConnectionError'));
  86. ldap_set_version($ds);
  87. if ($ds) {
  88. $r = false;
  89. $res = ldap_handle_bind($ds, $r);
  90. //$sr = @ ldap_search($ds, "o=groups,$ldap_basedn", "(&(description=etape*)(cn=*$annee))", array ('cn'));
  91. //$sr = @ ldap_search($ds, "ou=$annee, ou=diploma, o=paris1, $ldap_basedn", "ou=02*", array ('description'));
  92. //$sr = @ ldap_search($ds, "ou=structures, o=paris1, $ldap_basedn", "businessCategory=pedagogy", array ('ou','description'));
  93. $sr = @ ldap_search($ds, "$ldap_basedn", "", array ('ou','description'));
  94. // "ou=2006,ou=diploma,o=Paris1,dc=univ-paris1,dc=fr
  95. $info = ldap_get_entries($ds, $sr);
  96. for ($i = 0; $i < $info['count']; $i ++) {
  97. $composante[$info[$i]['ou'][0]] = iconv('utf-8',api_get_setting('platform_charset'), $info[$i]['description'][0]);
  98. }
  99. $oucompotab3=$composante;
  100. echo '<div style="align:center">';
  101. echo '<br />';
  102. echo '<h3><img src="../img/group.gif" alt="'.get_lang('SelectDepartment').'"/>'.get_lang('SelectDepartment').'</h3>';
  103. echo '<form method="get" action="'.api_get_self().'">';
  104. echo '<b>'.get_lang('RegistrationYear').'</b> : ';
  105. echo '<input type="text" name="annee" size="4" maxlength="30" value="'.$annee.'">';
  106. echo '<b>'.get_lang('Department').' : </b>';
  107. echo '<select name="composante" size="1">';
  108. while (list ($key, $val) = each($oucompotab3)) {
  109. echo '<option value="'.$key.'">'.$oucompotab3[$key].'</option>';
  110. }
  111. echo '</select>';
  112. echo '<br />';
  113. echo '<br />';
  114. echo '<input type="hidden" name="id_session" value="'.$id_session.'">';
  115. echo '<input type="hidden" name="action" value="add">';
  116. echo '<input type="submit" name="valider" value="'.get_lang('Submit').'">';
  117. echo '</form>';
  118. ldap_close($ds);
  119. }
  120. echo '<br />';
  121. echo '<br />';
  122. echo '<a href="'.api_get_self().'"?id_session='.$id_session.'&annee=&action=add&composante=&etape=">'.get_lang('BackToNewSearch').'</a>';
  123. echo '<br />';
  124. echo '</div>';
  125. }
  126. // form3 :annee!=0composante=0etape=0
  127. elseif ($annee <> "" && $composante <> "" && $etape == "") {
  128. echo '<div style="align:center;">';
  129. echo '<h3><img src="../img/group.gif" alt="'.get_lang('SearchResults').'" />'.get_lang('SearchResults').'</h3>';
  130. $ds = ldap_connect($ldap_host, $ldap_port);
  131. ldap_set_version($ds);
  132. if ($ds) {
  133. $r = false;
  134. $res = ldap_handle_bind($ds, $r);
  135. //$sr = @ ldap_search($ds, "ou=$annee, ou=diploma, o=paris1, $ldap_basedn", "seeAlso=ou=$composante,ou=structures,o=Paris1,$ldap_basedn", array ('ou','description'));
  136. $sr = @ ldap_search($ds, "ou=$annee, ou=diploma, $ldap_basedn", "seeAlso=ou=$composante,ou=structures,$ldap_basedn", array ('ou','description'));
  137. //echo "Le nombre de resultats est : ".ldap_count_entries($ds,$sr)."<p>";
  138. echo '<br />';
  139. $info = ldap_get_entries($ds, $sr);
  140. for ($i = 0; $i <= $info['count']; $i ++) {
  141. $description = $info[$i]['description'];
  142. $ouetapetab[$i] = $description[0];
  143. $description2 = $info[$i]['ou'];
  144. $ouetapetab2[$i] = $description2[0];
  145. }
  146. asort($ouetapetab);
  147. reset($ouetapetab);
  148. echo '<form method="get" action="'.api_get_self().'">';
  149. echo '<b>'.get_lang('RegistrationYear').' :</b> <input type="text" name="annee" size="4" maxlength="30" value="'.$annee.'">';
  150. echo '<br /><br />';
  151. echo '<b>'.get_lang('Department').' :</b><input type="text" name="composante" size="4" maxlength="30" value="'.$composante.'">';
  152. echo '<br />';
  153. echo '<h4>'.get_lang('SelectStepAcademicYear').'</h4>';
  154. echo '<br />';
  155. echo '<b>'.get_lang('Step').' : </b>';
  156. echo '<select name="etape" size="1">';
  157. $tempcomp = "";
  158. while (list ($key, $val) = each($ouetapetab)) {
  159. if ($ouetapetab[$key] != $tempcomp) {
  160. $etape = $ouetapetab2[$key];
  161. $tempcomp = '"'.$ouetapetab[$key].'"';
  162. //$tempcomp = str_replace("etape", " => ", $tempcomp);
  163. //$tempcomp = system('echo '.$tempcomp.' | iconv -f utf-8 -t iso-8859-1', $toto);
  164. $tempcomp = iconv('utf-8',api_get_setting('platform_charset'),$tempcomp);
  165. $annee = str_word_count($etape, 1);
  166. echo '<option value="'.$etape.'">'.$tempcomp;
  167. echo '</option>';
  168. }
  169. }
  170. echo '</select>';
  171. echo '<input type="hidden" name="displayname" value="'.$displayname.'">';
  172. echo '<br />';
  173. echo '<input type="hidden" name="id_session" value="'.$id_session.'">';
  174. echo '<input type="submit" name="envoi" value="'.get_lang('Submit').'">';
  175. echo '</form>';
  176. ldap_close($ds);
  177. } else {
  178. // echo "<h4>Unable to connect to LDAP server</h4>";
  179. }
  180. echo '<br />';
  181. echo '<br />';
  182. echo '<br />';
  183. echo '<a href="'.api_get_self().'"?id_session='.$id_session.'&annee=&action=add&composante=&etape=">'.get_lang('BackToNewSearch').'</a>';
  184. echo '<br />';
  185. echo '</form>';
  186. echo '</div>';
  187. }
  188. } else {
  189. $id_session = intval($id_session);
  190. $annee = intval($annee);
  191. $composante = Database::escape_string($composante);
  192. // Lister les etapes concernant la session : table
  193. // Ajout de l'etape
  194. if ($annee <> "" && $composante <> "" && $etape <> "") {
  195. $ds = ldap_connect($ldap_host, $ldap_port);
  196. ldap_set_version($ds);
  197. if ($ds) {
  198. $r = false;
  199. $res = ldap_handle_bind($ds, $r);
  200. //$sr = @ ldap_search($ds, "ou=$annee, ou=diploma, o=paris1, $ldap_basedn", "ou=$etape", array ('ou','description'));
  201. $sr = @ ldap_search($ds, "$ldap_basedn", "ou=$etape", array ('ou','description'));
  202. //echo "Le nombre de resultats est : ".ldap_count_entries($ds,$sr)."<p>";
  203. $info = ldap_get_entries($ds, $sr);
  204. if ($info['count']>0) {
  205. // Ajout de l'Etape a la session
  206. $description=Database::escape_string(iconv('utf-8',api_get_setting('platform_charset'), $info[0]['description'][0]));
  207. $sql = "INSERT IGNORE INTO $tbl_session_rel_etape " .
  208. "(id_session,code_etape,etape_description,code_ufr,annee) " .
  209. "VALUES " .
  210. "('$id_session','".Database::escape_string($info[0]["ou"][0])."','".$description."','$composante','$annee')";
  211. if (api_sql_query($sql,__FILE__,__LINE__))
  212. Display :: display_normal_message(get_lang('Step').": $annee, $composante, $description ".get_lang('SomethingFemininAddedSuccessfully'));
  213. else
  214. Display :: display_error_message(get_lang('ErrorExistingStep'));
  215. } else
  216. Display :: display_error_message(get_lang('ErrorStepNotFoundOnLDAP'));
  217. } else
  218. Display :: display_error_message(get_lang('LDAPConnectionError'));
  219. }
  220. $sql = 'SELECT name, nbr_courses, nbr_users, nbr_classes, ' .
  221. 'DATE_FORMAT(date_start,"%d-%m-%Y") as date_start, ' .
  222. 'DATE_FORMAT(date_end,"%d-%m-%Y") as date_end, lastname, firstname, username
  223. FROM '.$tbl_session.'
  224. LEFT JOIN '.$tbl_user.'
  225. ON id_coach = user_id
  226. WHERE '.$tbl_session.'.id='.$id_session;
  227. $rs = api_sql_query($sql, __FILE__, __LINE__);
  228. $session = api_store_result($rs);
  229. $session = $session[0];
  230. if (isset($action) && ($action=="delete")) {
  231. $idChecked = $_GET['idChecked'];
  232. if(is_array($idChecked))
  233. $idChecked="'".implode("','",$idChecked)."'";
  234. $sql = "DELETE FROM $tbl_session_rel_etape " .
  235. "WHERE id_session='$id_session' " .
  236. "AND code_etape IN($idChecked)";
  237. api_sql_query($sql,__FILE__,__LINE__);
  238. if (mysql_affected_rows()>0)
  239. Display :: display_normal_message(get_lang('StepDeletedSuccessfully'));
  240. else
  241. Display :: display_error_message(get_lang('DeleteError'));
  242. } else if (isset($action) && ($action=='deleteusers')) {
  243. $idChecked = $_GET['idChecked'];
  244. if(is_array($idChecked))
  245. {
  246. $idChecked=Database::escape_string("'".implode("','",$idChecked)."'");
  247. }
  248. $sql = 'SELECT '.$tbl_user.'.user_id, lastname, firstname, username, official_code
  249. FROM '.$tbl_user.'
  250. INNER JOIN '.$tbl_session_rel_user.'
  251. ON '.$tbl_user.'.user_id = '.$tbl_session_rel_user.'.id_user
  252. AND '.$tbl_session_rel_user.'.id_session = '.$id_session.'
  253. WHERE official_code IN('.$idChecked.')
  254. ORDER BY official_code, lastname, firstname';
  255. $result=api_sql_query($sql,__FILE__,__LINE__);
  256. $users=api_store_result($result);
  257. $UserList=array();
  258. foreach($users as $user){
  259. $UserList[]=$user['user_id'];
  260. }
  261. // On supprime toutes les relations de l'utilisateur
  262. $result=api_sql_query("SELECT course_code FROM $tbl_session_rel_course " .
  263. "WHERE id_session='$id_session'",__FILE__,__LINE__);
  264. $CourseList=array();
  265. while($row=Database::fetch_array($result))
  266. {
  267. $CourseList[]=$row['course_code'];
  268. }
  269. foreach($CourseList as $enreg_course)
  270. {
  271. foreach($UserList as $enreg_user)
  272. {
  273. api_sql_query("DELETE IGNORE FROM $tbl_session_rel_course_rel_user " .
  274. "WHERE id_user='$enreg_user'",__FILE__,__LINE__);
  275. }
  276. $sql = "SELECT COUNT(id_user) as nbUsers FROM $tbl_session_rel_course_rel_user " .
  277. "WHERE id_session='$id_session' AND course_code='$enreg_course'";
  278. $rs = api_sql_query($sql, __FILE__, __LINE__);
  279. list($nbr_users) = Database::fetch_array($rs);
  280. api_sql_query("UPDATE $tbl_session_rel_course " .
  281. "SET nbr_users=$nbr_users " .
  282. "WHERE id_session='$id_session' " .
  283. "AND course_code='$enreg_course'",__FILE__,__LINE__);
  284. }
  285. foreach($UserList as $enreg_user){
  286. api_sql_query("DELETE IGNORE FROM $tbl_session_rel_user " .
  287. "WHERE id_user='$enreg_user'",__FILE__,__LINE__);
  288. }
  289. // updating number of users in the session
  290. $sql = "SELECT COUNT(id_user) as nbUsers FROM $tbl_session_rel_user " .
  291. "WHERE id_session='$id_session'";
  292. $rs = api_sql_query($sql, __FILE__, __LINE__);
  293. list($nbr_users) = Database::fetch_array($rs);
  294. api_sql_query("UPDATE $tbl_session SET nbr_users=$nbr_users " .
  295. "WHERE id='$id_session'",__FILE__,__LINE__);
  296. foreach($UserList as $enreg_user){
  297. if (UserManager::can_delete_user($enreg_user))
  298. UserManager::delete_user($enreg_user);
  299. }
  300. Display :: display_normal_message(get_lang('StepUsersDeletedSuccessfully'));
  301. }
  302. // Importing periods/steps users into the session
  303. if (isset($action) && ($action=='import')) {
  304. // id_session
  305. // Parse des code etape de la session
  306. $sql = "SELECT id_session, code_etape, etape_description, code_ufr, annee
  307. FROM $tbl_session_rel_etape
  308. WHERE id_session='$id_session'
  309. ORDER BY code_ufr, code_etape";
  310. $result = api_sql_query($sql);
  311. $ds = ldap_connect($ldap_host, $ldap_port) or die(get_lang('LDAPConnectionError'));
  312. ldap_set_version($ds);
  313. // Import des utilisateurs des etapes dans la session
  314. if ($ds)
  315. $r = false;
  316. $res = ldap_handle_bind($ds, $r);
  317. $UserList=array();
  318. while($row = Database::fetch_array($result)){
  319. $annee = $row['annee'];
  320. $code_ufr = $row['code_ufr'];
  321. $etape = $row['code_etape'];
  322. // LDAP Querry
  323. // edupersonorgunitdn=ou=12CI1,ou=2006,ou=diploma,o=Paris1,dc=univ-paris1,dc=fr
  324. //$sr = @ ldap_search($ds, "ou=people,$ldap_basedn", "edupersonorgunitdn=ou=$etape,ou=$annee,ou=diploma,o=Paris1,$ldap_basedn");
  325. $sr = @ ldap_search($ds, "ou=people,$ldap_basedn", "edupersonorgunitdn=ou=$etape,ou=$annee,ou=diploma,$ldap_basedn");
  326. $info = ldap_get_entries($ds, $sr);
  327. for ($key = 0; $key < $info["count"]; $key ++) {
  328. $lastname = iconv('utf-8', api_get_setting('platform_charset'), $info[$key]["sn"][0]);
  329. $firstname = iconv('utf-8', api_get_setting('platform_charset'), $info[$key]["givenname"][0]);
  330. $email = $info[$key]["mail"][0];
  331. // Get uid from dn
  332. $dn_array=ldap_explode_dn($info[$key]["dn"],1);
  333. $username = $dn_array[0]; // uid is first key
  334. $outab[] = $info[$key]["edupersonprimaryaffiliation"][0]; // Ici "student"
  335. $val = ldap_get_values_len($ds, $entry, "userPassword");
  336. $password = $val[0];
  337. // Pour faciliter la gestion on ajoute le code "etape-annee"
  338. $official_code=$etape."-".$annee;
  339. $auth_source="cas";
  340. // Pas de date d'expiration d'etudiant (a recuperer par rapport au shadow expire LDAP)
  341. $expiration_date='0000-00-00 00:00:00';
  342. $active=1;
  343. // Ajout de l'utilisateur
  344. if (UserManager::is_username_available($username))
  345. $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);
  346. else{
  347. $user = UserManager::get_user_info($username);
  348. $user_id=$user['user_id'];
  349. UserManager::update_user($user_id, $firstname, $lastname, $username, null, null, $email, $status, $official_code, $phone, $picture_uri, $expiration_date, $active);
  350. }
  351. $UserList[]=$user_id;
  352. }
  353. }
  354. // Une fois les utilisateurs importer dans la base des utilisateurs, on peux les affecter a la session
  355. $result=api_sql_query("SELECT course_code FROM $tbl_session_rel_course WHERE id_session='$id_session'",__FILE__,__LINE__);
  356. $CourseList=array();
  357. while($row=Database::fetch_array($result))
  358. {
  359. $CourseList[]=$row['course_code'];
  360. }
  361. foreach($CourseList as $enreg_course)
  362. {
  363. // On ajoute la relation entre l'utilisateur et le cours
  364. foreach($UserList as $enreg_user)
  365. {
  366. 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__);
  367. }
  368. $sql = "SELECT COUNT(id_user) as nbUsers FROM $tbl_session_rel_course_rel_user WHERE id_session='$id_session' AND course_code='$enreg_course'";
  369. $rs = api_sql_query($sql, __FILE__, __LINE__);
  370. list($nbr_users) = Database::fetch_array($rs);
  371. 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__);
  372. }
  373. // On ajoute la relation entre l'utilisateur et la session
  374. foreach($UserList as $enreg_user){
  375. api_sql_query("INSERT IGNORE INTO $tbl_session_rel_user(id_session, id_user) VALUES('$id_session','$enreg_user')",__FILE__,__LINE__);
  376. }
  377. $sql = "SELECT COUNT(id_user) as nbUsers FROM $tbl_session_rel_user WHERE id_session='$id_session'";
  378. $rs = api_sql_query($sql, __FILE__, __LINE__);
  379. list($nbr_users) = Database::fetch_array($rs);
  380. api_sql_query("UPDATE $tbl_session SET nbr_users=$nbr_users WHERE id='$id_session'",__FILE__,__LINE__);
  381. }
  382. ?>
  383. <!-- General properties -->
  384. <table class="data_table" width="100%">
  385. <tr>
  386. <th colspan="2"><?php echo get_lang('GeneralProperties'); ?>
  387. <a href="session_edit.php?page=ldap_import_students_to_session.php&id=<?php echo $id_session; ?>">
  388. <img src="../img/edit.gif" border="0" align="absmiddle" alt="<?php echo get_lang('Edit'); ?>">
  389. </a>
  390. </th>
  391. </tr>
  392. <tr>
  393. <td><?php echo get_lang('SessionName');?> :</td>
  394. <td><?php echo $session['name'] ?></td>
  395. </tr>
  396. <tr>
  397. <td><?php echo get_lang('GeneralCoach'); ?> :</td>
  398. <td><?php echo $session['lastname'].' '.$session['firstname'].' ('.$session['username'].')' ?></td>
  399. </tr>
  400. <tr>
  401. <td><?php echo ('Dates'); ?> :</td>
  402. <td>
  403. <?php
  404. if($session['date_start']=='00-00-0000')
  405. echo get_lang('NoTimeLimits');
  406. else
  407. echo get_lang('From').' '.$session['date_start'].' '.get_lang('To').' '.$session['date_end'];
  408. ?>
  409. </td>
  410. </tr>
  411. </table>
  412. <!--List des etapes -->
  413. <table class="data_table" width="100%">
  414. <tr>
  415. <th colspan="4"><?php echo get_lang('StepsList');?>
  416. <a href="<?php echo api_get_self(); ?>?action=add&id_session=<?php echo $id_session; ?>">
  417. <img src="../img/group_add_big.gif" border="0" align="absmiddle" alt="<?php echo get_lang('AddStep');?>">
  418. </a>
  419. </th>
  420. </tr>
  421. <tr>
  422. <th width="20%"><?php echo get_lang('Department');?></th>
  423. <th width="20%"><?php echo get_lang('StepCode');?></th>
  424. <th width="45%"><?php echo get_lang('Label');?></th>
  425. <th width="15%"><?php echo get_lang('Actions'); ?></th>
  426. </tr>
  427. <?php
  428. $sql = "SELECT id_session, code_etape, etape_description, code_ufr, annee
  429. FROM $tbl_session_rel_etape
  430. WHERE id_session='$id_session'
  431. ORDER BY code_ufr, code_etape";
  432. $result=api_sql_query($sql,__FILE__,__LINE__);
  433. if($result)
  434. {
  435. $etapes=api_store_result($result);
  436. }
  437. else
  438. {
  439. $etapes = array();
  440. }
  441. if(count($etapes)==0)
  442. {
  443. echo '
  444. <tr>
  445. <td colspan="4">'.get_lang('NoStepForThisSession').'</td>
  446. </tr>';
  447. } else {
  448. foreach($etapes as $etape){
  449. echo '
  450. <tr>
  451. <td>'.$etape['code_ufr'].' ('.$etape['annee'].')</td>
  452. <td>'.$etape['code_etape'].'</td>
  453. <td>'.$etape['etape_description'].'</td>
  454. <td>
  455. <a href="'.api_get_self().'?id_session='.$id_session.'&action=delete&idChecked[]='.$etape['code_etape'].'" onclick="javascript:if(!confirm(\''.get_lang('ConfirmYourChoice').'\')) return false;">' .
  456. '<img src="../img/delete.gif" border="0" align="absmiddle" alt="'.get_lang('Delete').'">' .
  457. '</a>
  458. <a href="'.api_get_self().'?id_session='.$id_session.'&action=deleteusers&idChecked[]='.$etape['code_etape'].'-'.$etape['annee'].'" onclick="javascript:if(!confirm(\''.get_lang('ConfirmYourChoice').'\')) return false;">' .
  459. '<img src="../img/undelete.gif" border="0" align="absmiddle" title="'.get_lang('DeleteStepUsers').'">' .
  460. '</a>
  461. </td>
  462. </tr>';
  463. }
  464. }
  465. ?>
  466. </table>
  467. <br />
  468. <form method="get" action="<?php echo api_get_self(); ?>" onsubmit="javascript:if(!confirm('<?php echo get_lang('ConfirmYourChoice'); ?>')) return false;">
  469. <select name="action">
  470. <option value="import"><?php echo get_lang('ImportStudentsOfAllSteps');?></option>
  471. </select>
  472. <input type="hidden" name="id_session" value="<?php echo $id_session; ?>">
  473. <input type="submit" value="<?php echo get_lang('Submit'); ?>">
  474. </form>
  475. <br />
  476. <br />
  477. <!--List of users -->
  478. <table class="data_table" width="100%">
  479. <tr>
  480. <th colspan="4"><?php echo get_lang('UserList')." (".$session['nbr_users'].")"; ?>
  481. <a href="add_users_to_session.php?page=resume_session.php&id_session=<?php echo $id_session; ?>"><img src="../img/edit.gif" border="0" align="absmiddle" alt="<?php echo get_lang('Edit');?>"></a>
  482. &nbsp;
  483. <a href="ldap_users_list.php?page=resume_session.php&id_session=<?php echo $id_session; ?>"><img src="../img/add_user.gif" border="0" align="absmiddle" alt="<?php echo get_lang('AddLDAPUsers');?>"></a>
  484. </th>
  485. </th>
  486. </tr>
  487. </tr>
  488. <?php
  489. if($session['nbr_users']==0){
  490. echo '
  491. <tr>
  492. <td colspan="2">'.get_lang('NoUserInThisSession').'</td>
  493. </tr>';
  494. }
  495. else {
  496. $sql = 'SELECT '.$tbl_user.'.user_id, lastname, firstname, username, official_code
  497. FROM '.$tbl_user.'
  498. INNER JOIN '.$tbl_session_rel_user.'
  499. ON '.$tbl_user.'.user_id = '.$tbl_session_rel_user.'.id_user
  500. AND '.$tbl_session_rel_user.'.id_session = '.$id_session.'
  501. ORDER BY official_code, lastname, firstname';
  502. $result=api_sql_query($sql,__FILE__,__LINE__);
  503. $users=api_store_result($result);
  504. foreach($users as $user){
  505. echo '<tr>
  506. <td width="10%">
  507. <b>'.$user['official_code'].'</b>
  508. </td>
  509. <td width="80%">
  510. <b>'.$user['lastname'].' '.$user['firstname'].' ('.$user['username'].')</b>
  511. </td>
  512. <td>
  513. <a href="../mySpace/student.php?user_id='.$user['user_id'].'">' .
  514. '<img src="../img/statistics.gif" border="0" style="vertical-align: middle;" title="'.get_lang('Reporting').'" alt="'.get_lang('Reporting').'"/>' .
  515. '</a>
  516. </td>
  517. </tr>';
  518. }
  519. }
  520. echo '</table>';
  521. }
  522. }
  523. else
  524. {
  525. $limit=20;
  526. $from=$page * $limit;
  527. $result=api_sql_query("SELECT id,name,nbr_courses,date_start,date_end " .
  528. " FROM $tbl_session ".(empty($_POST['keyword']) ? "" : "WHERE name LIKE '%".Database::escape_string($_POST['keyword'])."%'")." " .
  529. " ORDER BY $sort LIMIT $from,".($limit+1),__FILE__,__LINE__);
  530. $Sessions=api_store_result($result);
  531. $nbr_results=count($Sessions);
  532. //$tool_name = "Import LDAP session";
  533. //$interbreadcrumb[]=array("url" => "index.php","name" => get_lang('AdministrationTools'));
  534. Display::display_header($tool_name);
  535. ?>
  536. <div id="main">
  537. <?php
  538. if(isset($_GET['action'])){
  539. Display::display_normal_message($_GET['message']);
  540. }
  541. ?>
  542. <form method="POST" <?php echo api_get_self(); ?>>
  543. <input type="text" name="keyword" value="<?php echo Security::remove_XSS($_GET['keyword']); ?>"/>
  544. <input type="submit" value="<?php echo get_lang('Search'); ?>"/>
  545. </form>
  546. <div align="left">
  547. <?php
  548. if(count($Sessions)==0 && isset($_POST['keyword']))
  549. {
  550. echo get_lang('NoSearchResults');
  551. }
  552. else
  553. {
  554. if($page)
  555. {
  556. ?>
  557. <a href="<?php echo api_get_self(); ?>?page=<?php echo $page-1; ?>&sort=<?php echo $sort; ?>"><?php echo get_lang('Previous'); ?></a>
  558. <?php
  559. }
  560. else
  561. {
  562. echo get_lang('Previous');
  563. }
  564. ?>
  565. |
  566. <?php
  567. if($nbr_results > $limit)
  568. {
  569. ?>
  570. <a href="<?php echo api_get_self(); ?>?page=<?php echo $page+1; ?>&sort=<?php echo $sort; ?>"><?php echo get_lang('Next'); ?></a>
  571. <?php
  572. }
  573. else
  574. {
  575. echo get_lang('Next');
  576. }
  577. ?>
  578. </div>
  579. <br />
  580. <table class="data_table" width="100%">
  581. <tr>
  582. <th>&nbsp;</th>
  583. <th><a href="<?php echo api_get_self(); ?>?sort=nbr_courses"><?php echo get_lang('NumberOfCourses');?></a></th>
  584. <th><a href="<?php echo api_get_self(); ?>?sort=date_start"><?php echo get_lang('StartDate'); ?></a></th>
  585. <th><a href="<?php echo api_get_self(); ?>?sort=date_end"><?php echo get_lang('EndDate'); ?></a></th>
  586. <th><?php echo get_lang('Actions'); ?></th>
  587. </tr>
  588. <?php
  589. $i=0;
  590. foreach($Sessions as $key=>$enreg)
  591. {
  592. if($key == $limit)
  593. {
  594. break;
  595. }
  596. $sql = 'SELECT COUNT(course_code) FROM '.$tbl_session_rel_course.' ' .
  597. 'WHERE id_session='.intval($enreg['id']);
  598. $rs = api_sql_query($sql, __FILE__, __LINE__);
  599. list($nb_courses) = Database::fetch_array($rs);
  600. ?>
  601. <tr class="<?php echo $i?'row_odd':'row_even'; ?>">
  602. <td><a href="resume_session.php?id_session=<?php echo $enreg['id']; ?>"><?php echo htmlentities($enreg['name']); ?></a></td>
  603. <td><a href="session_course_list.php?id_session=<?php echo $enreg['id']; ?>"><?php echo $nb_courses; ?> cours</a></td>
  604. <td><?php echo htmlentities($enreg['date_start']); ?></td>
  605. <td><?php echo htmlentities($enreg['date_end']); ?></td>
  606. <td>
  607. <a href="<?php echo api_get_self(); ?>?id_session=<?php echo $enreg['id']; ?>"><img src="../img/add_user_big.gif" border="0" align="absmiddle" title="<?php echo get_lang('SubscribeSomeUsersToThisSession');?>"></a>
  608. </td>
  609. </tr>
  610. <?php
  611. $i=$i ? 0 : 1;
  612. }
  613. unset($Sessions);
  614. ?>
  615. </table>
  616. <br />
  617. <div align="left">
  618. <?php
  619. if($page)
  620. {
  621. ?>
  622. <a href="<?php echo api_get_self(); ?>?page=<?php echo $page-1; ?>&sort=<?php echo $sort; ?>"><?php echo get_lang('Previous'); ?></a>
  623. <?php
  624. }
  625. else
  626. {
  627. echo get_lang('Previous');
  628. }
  629. ?>
  630. |
  631. <?php
  632. if($nbr_results > $limit)
  633. {
  634. ?>
  635. <a href="<?php echo api_get_self(); ?>?page=<?php echo $page+1; ?>&sort=<?php echo $sort; ?>"><?php echo get_lang('Next'); ?></a>
  636. <?php
  637. }
  638. else
  639. {
  640. echo get_lang('Next');
  641. }
  642. ?>
  643. </div>
  644. <br />
  645. <?php } ?>
  646. </table>
  647. </div>
  648. <?php
  649. }
  650. Display::display_footer();
  651. ?>