session_import.php 45 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837
  1. <?php
  2. /* For licensing terms, see /license.txt */
  3. /**
  4. * @package chamilo.admin
  5. */
  6. $language_file = array('admin', 'registration');
  7. $cidReset = true;
  8. require_once '../inc/global.inc.php';
  9. $this_section = SECTION_PLATFORM_ADMIN;
  10. api_protect_admin_script(true);
  11. $form_sent = 0;
  12. $error_message = '';
  13. if (isset($_GET['action']) && $_GET['action'] == 'show_message') {
  14. $error_message = Security::remove_XSS($_GET['message']);
  15. }
  16. $tbl_user = Database::get_main_table(TABLE_MAIN_USER);
  17. $tbl_session = Database::get_main_table(TABLE_MAIN_SESSION);
  18. $tbl_session_user = Database::get_main_table(TABLE_MAIN_SESSION_USER);
  19. $tbl_session_course = Database::get_main_table(TABLE_MAIN_SESSION_COURSE);
  20. $tbl_session_course_user = Database::get_main_table(TABLE_MAIN_SESSION_COURSE_USER);
  21. $tool_name = get_lang('ImportSessionListXMLCSV');
  22. $interbreadcrumb[] = array('url' => 'index.php', 'name' => get_lang('PlatformAdmin'));
  23. set_time_limit(0);
  24. // Set this option to true to enforce strict purification for usenames.
  25. $purification_option_for_usernames = false;
  26. $inserted_in_course = array();
  27. global $_configuration;
  28. if ($_POST['formSent']) {
  29. if (isset($_FILES['import_file']['tmp_name']) && !empty($_FILES['import_file']['tmp_name'])) {
  30. $form_sent = $_POST['formSent'];
  31. $file_type = $_POST['file_type'];
  32. $send_mail = $_POST['sendMail'] ? 1 : 0;
  33. //$updatesession = $_POST['updatesession'] ? 1 : 0;
  34. $updatesession = 0;
  35. $sessions = array();
  36. $session_counter = 0;
  37. if ($file_type == 'xml') {
  38. // XML
  39. // SimpleXML for PHP5 deals with various encodings, but how many they are, what are version issues, do we need to waste time with configuration options?
  40. // For avoiding complications we go some sort of "PHP4 way" - we convert the input xml-file into UTF-8 before passing it to the parser.
  41. // Instead of:
  42. // $root = @simplexml_load_file($_FILES['import_file']['tmp_name']);
  43. // we may use the following construct:
  44. // $root = @simplexml_load_string(api_utf8_encode_xml(file_get_contents($_FILES['import_file']['tmp_name'])));
  45. // To ease debugging let us use:
  46. $content = file_get_contents($_FILES['import_file']['tmp_name']);
  47. $content = api_utf8_encode_xml($content);
  48. $root = @simplexml_load_string($content);
  49. unset($content);
  50. if (is_object($root)) {
  51. if (count($root->Users->User) > 0) {
  52. // Creating/updating users from <Sessions> <Users> base node.
  53. foreach ($root->Users->User as $node_user) {
  54. $username = $username_old = trim(api_utf8_decode($node_user->Username));
  55. if (UserManager::is_username_available($username)) {
  56. $password = api_utf8_decode($node_user->Password);
  57. if (empty($password)) {
  58. $password = api_generate_password();
  59. }
  60. switch ($node_user->Status) {
  61. case 'student' :
  62. $status = 5;
  63. break;
  64. case 'teacher' :
  65. $status = 1;
  66. break;
  67. default :
  68. $status = 5;
  69. $error_message .= get_lang('StudentStatusWasGivenTo').' : '.$username.'<br />';
  70. }
  71. $result = UserManager::create_user(
  72. api_utf8_decode($node_user->Firstname),
  73. api_utf8_decode($node_user->Lastname),
  74. $status,
  75. api_utf8_decode($node_user->Email),
  76. $username,
  77. $password,
  78. api_utf8_decode($node_user->OfficialCode),
  79. null,
  80. api_utf8_decode($node_user->Phone),
  81. null,
  82. PLATFORM_AUTH_SOURCE,
  83. null,
  84. 1,
  85. 0,
  86. null,
  87. null,
  88. $send_mail
  89. );
  90. } else {
  91. $lastname = trim(api_utf8_decode($node_user->Lastname));
  92. $firstname = trim(api_utf8_decode($node_user->Firstname));
  93. $password = api_utf8_decode($node_user->Password);
  94. $email = trim(api_utf8_decode($node_user->Email));
  95. $official_code = trim(api_utf8_decode($node_user->OfficialCode));
  96. $phone = trim(api_utf8_decode($node_user->Phone));
  97. $status = trim(api_utf8_decode($node_user->Status));
  98. switch ($status) {
  99. case 'student' : $status = 5; break;
  100. case 'teacher' : $status = 1; break;
  101. default : $status = 5; $error_message .= get_lang('StudentStatusWasGivenTo').' : '.$username.'<br />';
  102. }
  103. $sql = "UPDATE $tbl_user SET
  104. lastname = '".Database::escape_string($lastname)."',
  105. firstname = '".Database::escape_string($firstname)."',
  106. ".(empty($password) ? "" : "password = '".(api_get_encrypted_password($password))."',")."
  107. email = '".Database::escape_string($email)."',
  108. official_code = '".Database::escape_string($official_code)."',
  109. phone = '".Database::escape_string($phone)."',
  110. status = '".Database::escape_string($status)."'
  111. WHERE username = '".Database::escape_string($username)."'";
  112. Database::query($sql);
  113. }
  114. }
  115. }
  116. // Creating courses from <Sessions> <Courses> base node.
  117. if (count($root->Courses->Course) > 0) {
  118. foreach ($root->Courses->Course as $courseNode) {
  119. $params = array();
  120. if (empty($courseNode->CourseTitle)) {
  121. $params['title'] = api_utf8_decode($courseNode->CourseCode);
  122. } else {
  123. $params['title'] = api_utf8_decode($courseNode->CourseTitle);
  124. }
  125. $params['wanted_code'] = api_utf8_decode($courseNode->CourseCode);
  126. $params['tutor_name'] = null;
  127. $params['course_category'] = null;
  128. $params['course_language'] = api_get_valid_language(api_utf8_decode($courseNode->CourseLanguage));
  129. $params['user_id'] = api_get_user_id();
  130. // Looking up for the teacher.
  131. $username = trim(api_utf8_decode($courseNode->CourseTeacher));
  132. $sql = "SELECT user_id, lastname, firstname FROM $tbl_user WHERE username='$username'";
  133. $rs = Database::query($sql);
  134. list($user_id, $lastname, $firstname) = Database::fetch_array($rs);
  135. $params['teachers'] = $user_id;
  136. CourseManager::create_course($params);
  137. }
  138. }
  139. // Creating sessions from <Sessions> base node.
  140. if (count($root->Session) > 0) {
  141. foreach ($root->Session as $node_session) {
  142. $course_counter = 0;
  143. $user_counter = 0;
  144. $session_name = trim(api_utf8_decode($node_session->SessionName));
  145. $coach = UserManager::purify_username(api_utf8_decode($node_session->Coach), $purification_option_for_usernames);
  146. if (!empty($coach)) {
  147. $coach_id = UserManager::get_user_id_from_username($coach);
  148. if ($coach_id === false) {
  149. $error_message .= get_lang('UserDoesNotExist').' : '.$coach.'<br />';
  150. // Forcing the coach id if user does not exist.
  151. $coach_id = api_get_user_id();
  152. }
  153. } else {
  154. // Forcing the coach id.
  155. $coach_id = api_get_user_id();
  156. }
  157. $date_start = trim(api_utf8_decode($node_session->DateStart)); // Just in case - encoding conversion.
  158. $date_end = trim(api_utf8_decode($node_session->DateEnd));
  159. $visibility = trim(api_utf8_decode($node_session->Visibility));
  160. $session_category_id = trim(api_utf8_decode($node_session->SessionCategory));
  161. if (!$updatesession) {
  162. // Always create a session.
  163. $unique_name = false; // This MUST be initializead.
  164. $i = 0;
  165. // Change session name, verify that session doesn't exist.
  166. while (!$unique_name) {
  167. if ($i > 1) {
  168. $suffix = ' - '.$i;
  169. }
  170. $sql = 'SELECT 1 FROM '.$tbl_session.' WHERE name="'.Database::escape_string($session_name.$suffix).'"';
  171. $rs = Database::query($sql);
  172. if (Database::result($rs, 0, 0)) {
  173. $i++;
  174. } else {
  175. $unique_name = true;
  176. $session_name .= $suffix;
  177. }
  178. }
  179. $params = array (
  180. 'id_coach' => $coach_id,
  181. 'visibility' => $visibility,
  182. 'name' => $session_name,
  183. 'access_start_date' => $date_start,
  184. 'access_end_date' => $date_end,
  185. 'session_category_id' => $session_category_id,
  186. 'session_admin_id' => api_get_user_id(),
  187. );
  188. $session_id = SessionManager::add($params);
  189. $session_counter++;
  190. } else {
  191. // Update the session if it is needed.
  192. $my_session_result = SessionManager::get_session_by_name($session_name);
  193. if ($my_session_result === false) {
  194. $params = array (
  195. 'id_coach' => $coach_id,
  196. 'visibility' => $visibility,
  197. 'name' => $session_name,
  198. 'access_start_date' => $date_start,
  199. 'access_end_date' => $date_end,
  200. 'session_category_id' => $session_category_id,
  201. 'session_admin_id' => api_get_user_id(),
  202. );
  203. $session_id = SessionManager::add($params);
  204. $session_counter++;
  205. } else {
  206. $params = array (
  207. 'id' => $my_session_result['id'],
  208. 'id_coach' => $coach_id,
  209. 'visibility' => $visibility,
  210. 'name' => $session_name,
  211. 'access_start_date' => $date_start,
  212. 'access_end_date' => $date_end,
  213. 'session_category_id' => $session_category_id,
  214. 'session_admin_id' => api_get_user_id(),
  215. );
  216. SessionManager::update($params);
  217. $session_id = Database::query("SELECT id FROM $tbl_session WHERE name='$session_name'");
  218. list($session_id) = Database::fetch_array($session_id);
  219. Database::query("DELETE FROM $tbl_session_user WHERE id_session='$session_id'");
  220. Database::query("DELETE FROM $tbl_session_course WHERE id_session='$session_id'");
  221. Database::query("DELETE FROM $tbl_session_course_user WHERE id_session='$session_id'");
  222. }
  223. }
  224. // Associate the session with access_url.
  225. global $_configuration;
  226. if ($_configuration['multiple_access_urls']) {
  227. $access_url_id = api_get_current_access_url_id();
  228. UrlManager::add_session_to_url($session_id, $access_url_id);
  229. } else {
  230. // We fill by default the access_url_rel_session table.
  231. UrlManager::add_session_to_url($session_id, 1);
  232. }
  233. // Adding users to the new session.
  234. foreach ($node_session->User as $node_user) {
  235. $username = UserManager::purify_username(api_utf8_decode($node_user), $purification_option_for_usernames);
  236. $user_id = UserManager::get_user_id_from_username($username);
  237. if ($user_id !== false) {
  238. $sql = "INSERT IGNORE INTO $tbl_session_user SET
  239. id_user='$user_id',
  240. id_session = '$session_id'";
  241. $rs_user = Database::query($sql);
  242. $user_counter++;
  243. }
  244. }
  245. // Adding courses to a session.
  246. foreach ($node_session->Course as $node_course) {
  247. $course_code = Database::escape_string(trim(api_utf8_decode($node_course->CourseCode)));
  248. // Verify that the course pointed by the course code node exists.
  249. if (CourseManager::course_exists($course_code)) {
  250. // If the course exists we continue.
  251. $course_info = CourseManager::get_course_information($course_code);
  252. $session_course_relation = SessionManager::relation_session_course_exist($session_id, $course_code);
  253. if (!$session_course_relation) {
  254. $sql_course = "INSERT INTO $tbl_session_course SET
  255. course_code = '$course_code',
  256. id_session='$session_id'";
  257. $rs_course = Database::query($sql_course);
  258. }
  259. $course_coaches = explode(',', $node_course->Coach);
  260. // Adding coachs to session course user
  261. foreach ($course_coaches as $course_coach) {
  262. $coach_id = UserManager::purify_username(api_utf8_decode($course_coach), $purification_option_for_usernames);
  263. $coach_id = UserManager::get_user_id_from_username($course_coach);
  264. if ($coach_id !== false) {
  265. $sql = "INSERT IGNORE INTO $tbl_session_course_user SET
  266. id_user='$coach_id',
  267. course_code='$course_code',
  268. id_session = '$session_id',
  269. status = 2 ";
  270. $rs_coachs = Database::query($sql);
  271. } else {
  272. $error_message .= get_lang('UserDoesNotExist').' : '.$user.'<br />';
  273. }
  274. }
  275. // Adding users.
  276. $course_counter++;
  277. $users_in_course_counter = 0;
  278. foreach ($node_course->User as $node_user) {
  279. $username = UserManager::purify_username(api_utf8_decode($node_user), $purification_option_for_usernames);
  280. $user_id = UserManager::get_user_id_from_username($username);
  281. if ($user_id !== false) {
  282. // Adding to session_rel_user table.
  283. $sql = "INSERT IGNORE INTO $tbl_session_user SET
  284. id_user='$user_id',
  285. id_session = '$session_id'";
  286. $rs_user = Database::query($sql);
  287. $user_counter++;
  288. // Adding to session_rel_user_rel_course table.
  289. $sql = "INSERT IGNORE INTO $tbl_session_course_user SET
  290. id_user='$user_id',
  291. course_code='$course_code',
  292. id_session = '$session_id'";
  293. $rs_users = Database::query($sql);
  294. $users_in_course_counter++;
  295. } else {
  296. $error_message .= get_lang('UserDoesNotExist').' : '.$username.'<br />';
  297. }
  298. }
  299. $update_session_course = "UPDATE $tbl_session_course SET nbr_users='$users_in_course_counter' WHERE course_code='$course_code'";
  300. Database::query($update_session_course);
  301. $inserted_in_course[$course_code] = $course_info['title'];
  302. }
  303. if (CourseManager::course_exists($course_code, true)) {
  304. // If the course exists we continue.
  305. // Also subscribe to virtual courses through check on visual code.
  306. $list = CourseManager :: get_courses_info_from_visual_code($course_code);
  307. foreach ($list as $vcourse) {
  308. if ($vcourse['code'] == $course_code) {
  309. // Ignore, this has already been inserted.
  310. } else {
  311. $sql_course = "INSERT INTO $tbl_session_course SET
  312. course_code = '".$vcourse['code']."',
  313. id_session='$session_id'";
  314. $rs_course = Database::query($sql_course);
  315. $course_coaches = explode(",",$node_course->Coach);
  316. // adding coachs to session course user
  317. foreach ($course_coaches as $course_coach) {
  318. $coach_id = UserManager::purify_username(api_utf8_decode($course_coach), $purification_option_for_usernames);
  319. $coach_id = UserManager::get_user_id_from_username($course_coach);
  320. if ($coach_id !== false) {
  321. $sql = "INSERT IGNORE INTO $tbl_session_course_user SET
  322. id_user='$coach_id',
  323. course_code='{$vcourse['code']}',
  324. id_session = '$session_id',
  325. status = 2 ";
  326. $rs_coachs = Database::query($sql);
  327. } else {
  328. $error_message .= get_lang('UserDoesNotExist').' : '.$user.'<br />';
  329. }
  330. }
  331. // adding users
  332. $course_counter++;
  333. $users_in_course_counter = 0;
  334. foreach ($node_course->User as $node_user) {
  335. $username = UserManager::purify_username(api_utf8_decode($node_user), $purification_option_for_usernames);
  336. $user_id = UserManager::get_user_id_from_username($username);
  337. if ($user_id !== false) {
  338. // Adding to session_rel_user table.
  339. $sql = "INSERT IGNORE INTO $tbl_session_user SET
  340. id_user='$user_id',
  341. id_session = '$session_id'";
  342. $rs_user = Database::query($sql);
  343. $user_counter++;
  344. // Adding to session_rel_user_rel_course table.
  345. $sql = "INSERT IGNORE INTO $tbl_session_course_user SET
  346. id_user='$user_id',
  347. course_code='{$vcourse['code']}',
  348. id_session = '$session_id'";
  349. $rs_users = Database::query($sql);
  350. $users_in_course_counter++;
  351. } else {
  352. $error_message .= get_lang('UserDoesNotExist').' : '.$username.'<br />';
  353. }
  354. }
  355. $update_session_course = "UPDATE $tbl_session_course SET nbr_users='$users_in_course_counter' WHERE course_code='$course_code'";
  356. Database::query($update_session_course);
  357. $inserted_in_course[$course_code] = $course_info['title'];
  358. }
  359. $inserted_in_course[$vcourse['code']] = $vcourse['title'];
  360. }
  361. } else {
  362. // Tthe course does not exist.
  363. $error_message .= get_lang('CourseDoesNotExist').' : '.$course_code.'<br />';
  364. }
  365. }
  366. Database::query("UPDATE $tbl_session SET nbr_users='$user_counter', nbr_courses='$course_counter' WHERE id='$session_id'");
  367. }
  368. }
  369. if (empty($root->Users->User) && empty($root->Courses->Course) && empty($root->Session)) {
  370. $error_message = get_lang('NoNeededData');
  371. }
  372. } else {
  373. $error_message .= get_lang('XMLNotValid');
  374. }
  375. } else {
  376. // CSV
  377. $content = file($_FILES['import_file']['tmp_name']);
  378. if (!api_strstr($content[0], ';')) {
  379. $error_message = get_lang('NotCSV');
  380. } else {
  381. $tag_names = array();
  382. foreach ($content as $key => $enreg) {
  383. $enreg = explode(';', trim($enreg));
  384. if ($key) {
  385. foreach ($tag_names as $tag_key => $tag_name) {
  386. $sessions[$key - 1][$tag_name] = $enreg[$tag_key];
  387. }
  388. } else {
  389. foreach ($enreg as $tag_name) {
  390. $tag_names[] = api_preg_replace('/[^a-zA-Z0-9_\-]/', '', $tag_name);
  391. }
  392. if (!in_array('SessionName', $tag_names) || !in_array('DateStart', $tag_names) || !in_array('DateEnd', $tag_names)) {
  393. $error_message = get_lang('NoNeededData');
  394. break;
  395. }
  396. }
  397. }
  398. // Looping the sessions.
  399. foreach ($sessions as $enreg) {
  400. $user_counter = 0;
  401. $course_counter = 0;
  402. $session_name = $enreg['SessionName'];
  403. $date_start = $enreg['DateStart'];
  404. $date_end = $enreg['DateEnd'];
  405. $visibility = $enreg['Visibility'];
  406. $session_category_id = $enreg['SessionCategory'];
  407. // Searching a coach.
  408. if (!empty($enreg['Coach'])) {
  409. $coach_id = UserManager::get_user_id_from_username($enreg['Coach']);
  410. if ($coach_id === false) {
  411. // If the coach-user does not exist - I'm the coach.
  412. $coach_id = api_get_user_id();
  413. }
  414. } else {
  415. $coach_id = api_get_user_id();
  416. }
  417. if (!$updatesession) {
  418. // Always create a session.
  419. $unique_name = false; // This MUST be initializead.
  420. $i = 0;
  421. // Change session name, verify that session doesn't exist.
  422. while (!$unique_name) {
  423. if ($i > 1) {
  424. $suffix = ' - '.$i;
  425. }
  426. $sql = 'SELECT 1 FROM '.$tbl_session.' WHERE name="'.Database::escape_string($session_name.$suffix).'"';
  427. $rs = Database::query($sql);
  428. if (Database::result($rs, 0, 0)) {
  429. $i++;
  430. } else {
  431. $unique_name = true;
  432. $session_name .= $suffix;
  433. }
  434. }
  435. $params = array (
  436. 'id_coach' => $coach_id,
  437. 'visibility' => $visibility,
  438. 'name' => $session_name,
  439. 'access_start_date' => $date_start,
  440. 'access_end_date' => $date_end,
  441. 'session_category_id' => $session_category_id,
  442. 'session_admin_id' => api_get_user_id(),
  443. );
  444. $session_id = SessionManager::add($params);
  445. $session_counter++;
  446. } else {
  447. $my_session_result = SessionManager::get_session_by_name($session_name);
  448. if ($my_session_result === false) {
  449. $params = array (
  450. 'id_coach' => $coach_id,
  451. 'visibility' => $visibility,
  452. 'name' => $session_name,
  453. 'access_start_date' => $date_start,
  454. 'access_end_date' => $date_end,
  455. 'session_category_id' => $session_category_id,
  456. 'session_admin_id' => api_get_user_id(),
  457. );
  458. $session_id = SessionManager::add($params);
  459. } else {
  460. $session_id = $my_session_result['id'];
  461. $params = array (
  462. 'id' => $session_id,
  463. 'id_coach' => $coach_id,
  464. 'visibility' => $visibility,
  465. 'name' => $session_name,
  466. 'access_start_date' => $date_start,
  467. 'access_end_date' => $date_end,
  468. 'session_category_id' => $session_category_id,
  469. 'session_admin_id' => api_get_user_id(),
  470. );
  471. SessionManager::update($params);
  472. Database::query("DELETE FROM $tbl_session_user WHERE id_session='$session_id'");
  473. Database::query("DELETE FROM $tbl_session_course WHERE id_session='$session_id'");
  474. Database::query("DELETE FROM $tbl_session_course_user WHERE id_session='$session_id'");
  475. }
  476. $session_counter++;
  477. }
  478. $users = explode('|', $enreg['Users']);
  479. // Adding the relationship "Session - User".
  480. if (is_array($users)) {
  481. foreach ($users as $user) {
  482. $user_id = UserManager::get_user_id_from_username($user);
  483. if ($user_id !== false) {
  484. // Insert new users.
  485. $sql = "INSERT IGNORE INTO $tbl_session_user SET
  486. id_user='$user_id',
  487. id_session = '$session_id'";
  488. $rs_user = Database::query($sql);
  489. $user_counter++;
  490. }
  491. }
  492. }
  493. $courses = explode('|', $enreg['Courses']);
  494. foreach ($courses as $course) {
  495. $course_code = api_strtoupper(api_substr($course, 0, api_strpos($course, '[')));
  496. if (CourseManager::course_exists($course_code)) {
  497. // If the course exists we continue.
  498. $course_info = CourseManager::get_course_information($course_code);
  499. $coach = api_strstr($course, '[');
  500. $coach = api_substr($coach, 1, api_strpos($coach,']') - 1);
  501. if (!empty($coach)) {
  502. $coach_id = UserManager::get_user_id_from_username($coach);
  503. if ($coach_id === false) {
  504. $coach_id = '';
  505. }
  506. } else {
  507. $coach = '';
  508. }
  509. // Adding the course to a session.
  510. $sql_course = "INSERT IGNORE INTO $tbl_session_course SET
  511. course_code = '$course_code',
  512. id_session='$session_id'";
  513. $rs_course = Database::query($sql_course);
  514. $course_counter++;
  515. $course_split = array();
  516. $pattern = "/\[(.*?)\]/";
  517. preg_match_all($pattern, $course, $matches);
  518. if (isset($matches[1])) {
  519. $course_coaches = $matches[1][0];
  520. $course_users = $matches[1][1];
  521. }
  522. $course_users = explode(',', $course_users);
  523. $course_coaches = explode(',', $course_coaches);
  524. // Adding coaches to session course user
  525. if (!empty($course_coaches)) {
  526. foreach ($course_coaches as $course_coach) {
  527. $coach_id = UserManager::get_user_id_from_username($course_coach);
  528. if ($coach_id !== false) {
  529. $sql = "INSERT IGNORE INTO $tbl_session_course_user SET
  530. id_user='$coach_id',
  531. course_code='$course_code',
  532. id_session = '$session_id',
  533. status = 2 ";
  534. $rs_coachs = Database::query($sql);
  535. } else {
  536. $error_message .= get_lang('UserDoesNotExist').' : '.$user.'<br />';
  537. }
  538. }
  539. }
  540. $users_in_course_counter = 0;
  541. // Adding the relationship "Session - Course - User".
  542. foreach ($course_users as $user) {
  543. $user_id = UserManager::get_user_id_from_username($user);
  544. if ($user_id !== false) {
  545. $sql = "INSERT IGNORE INTO $tbl_session_course_user SET
  546. id_user='$user_id',
  547. course_code='$course_code',
  548. id_session = '$session_id'";
  549. $rs_users = Database::query($sql);
  550. $users_in_course_counter++;
  551. } else {
  552. $error_message .= get_lang('UserDoesNotExist').' : '.$user.'<br />';
  553. }
  554. }
  555. $sql = "UPDATE $tbl_session_course SET nbr_users='$users_in_course_counter' WHERE course_code='$course_code'";
  556. Database::query($sql);
  557. $course_info = CourseManager::get_course_information($course_code);
  558. $inserted_in_course[$course_code] = $course_info['title'];
  559. } else {
  560. // TODO: We should create the course as in the XML import.
  561. }
  562. if (CourseManager::course_exists($course_code, true)) {
  563. $list = CourseManager :: get_courses_info_from_visual_code($course_code);
  564. foreach ($list as $vcourse) {
  565. if ($vcourse['code'] == $course_code) {
  566. // Ignore, this has already been inserted.
  567. } else {
  568. $coach = api_strstr($course, '[');
  569. $coach = api_substr($coach, 1, api_strpos($coach,']') - 1);
  570. // Adding the relationship "Session - Course".
  571. $sql_course = "INSERT IGNORE INTO $tbl_session_course SET
  572. course_code = '".$vcourse['code']."',
  573. id_session='$session_id'";
  574. $rs_course = Database::query($sql_course);
  575. // adding coachs to session course user
  576. foreach ($course_coaches as $course_coach) {
  577. $coach_id = UserManager::get_user_id_from_username($course_coach);
  578. if ($coach_id !== false) {
  579. $sql = "INSERT IGNORE INTO $tbl_session_course_user SET
  580. id_user='$coach_id',
  581. course_code='{$vcourse['code']}',
  582. id_session = '$session_id',
  583. status = 2 ";
  584. $rs_coachs = Database::query($sql);
  585. } else {
  586. $error_message .= get_lang('UserDoesNotExist').' : '.$user.'<br />';
  587. }
  588. }
  589. $users_in_course_counter = 0;
  590. // Adding the relationship "Session - Course - User".
  591. foreach ($course_users as $user) {
  592. $user_id = UserManager::get_user_id_from_username($user);
  593. if ($user_id !== false) {
  594. $sql = "INSERT IGNORE INTO $tbl_session_course_user SET
  595. id_user='$user_id',
  596. course_code='{$vcourse['code']}',
  597. id_session = '$session_id'";
  598. $rs_users = Database::query($sql);
  599. $users_in_course_counter++;
  600. } else {
  601. $error_message .= get_lang('UserDoesNotExist').' : '.$user.'<br />';
  602. }
  603. }
  604. Database::query("UPDATE $tbl_session_course SET nbr_users='$users_in_course_counter' WHERE course_code='".$vcourse['code']."'");
  605. }
  606. }
  607. $inserted_in_course[$vcourse['code']] = $vcourse['title'];
  608. }
  609. }
  610. $access_url_id = api_get_current_access_url_id();
  611. UrlManager::add_session_to_url($session_id, $access_url_id);
  612. $sql_update_users = "UPDATE $tbl_session SET nbr_users='$user_counter', nbr_courses='$course_counter' WHERE id='$session_id'";
  613. Database::query($sql_update_users);
  614. }
  615. }
  616. }
  617. if (!empty($error_message)) {
  618. $error_message = get_lang('ButProblemsOccured').' :<br />'.$error_message;
  619. }
  620. if (count($inserted_in_course) > 1) {
  621. $warn = get_lang('SeveralCoursesSubscribedToSessionBecauseOfSameVisualCode').': ';
  622. foreach ($inserted_in_course as $code => $title) {
  623. $warn .= ' '.$title.' ('.$code.'),';
  624. }
  625. $warn = substr($warn, 0, -1);
  626. }
  627. if ($session_counter == 1) {
  628. header('Location: resume_session.php?id_session='.$session_id.'&warn='.urlencode($warn));
  629. exit;
  630. } else {
  631. header('Location: session_list.php?action=show_message&message='.urlencode(get_lang('FileImported').' '.$error_message).'&warn='.urlencode($warn));
  632. exit;
  633. }
  634. } else {
  635. $error_message = get_lang('NoInputFile');
  636. }
  637. }
  638. // Display the header.
  639. Display::display_header($tool_name);
  640. if (count($inserted_in_course) > 1) {
  641. $msg = get_lang('SeveralCoursesSubscribedToSessionBecauseOfSameVisualCode').': ';
  642. foreach ($inserted_in_course as $code => $title) {
  643. $msg .= ' '.$title.' ('.$title.'),';
  644. }
  645. $msg = substr($msg, 0, -1);
  646. Display::display_warning_message($msg);
  647. }
  648. echo '<div class="actions">';
  649. echo '<a href="../admin/index.php">'.Display::return_icon('back.png', get_lang('BackTo').' '.get_lang('PlatformAdmin'),'',ICON_SIZE_MEDIUM).'</a>';
  650. echo '</div>';
  651. if (!empty($error_message)) {
  652. Display::display_normal_message($error_message, false);
  653. }
  654. $form = new FormValidator('import_sessions', 'post', api_get_self(), null, array('enctype' => 'multipart/form-data'));
  655. $form->addElement('hidden', 'formSent', 1);
  656. $form->addElement('file', 'import_file', get_lang('ImportFileLocation'));
  657. $form->addElement('radio', 'file_type', array(get_lang('FileType'), '<a href="example_session.csv" target="_blank">'.get_lang('ExampleCSVFile').'</a>'), 'CSV', 'csv');
  658. $form->addElement('radio', 'file_type', array(null, '<a href="example_session.xml" target="_blank">'.get_lang('ExampleXMLFile').'</a>'), 'XML', 'xml');
  659. $form->addElement('checkbox', 'sendMail', null, get_lang('SendMailToUsers'));
  660. $form->addElement('button', 'submit', get_lang('ImportSession'));
  661. $defaults = array('sendMail' => 'true','file_type' => 'csv');
  662. $form->setDefaults($defaults);
  663. Display::display_normal_message(get_lang('TheXMLImportLetYouAddMoreInfoAndCreateResources'));
  664. $form->display();
  665. ?>
  666. <font color="gray">
  667. <p><?php echo get_lang('CSVMustLookLike').' ('.get_lang('MandatoryFields').')'; ?> :</p>
  668. <blockquote>
  669. <pre>
  670. <strong>SessionName</strong>;Coach;<strong>DateStart</strong>;<strong>DateEnd</strong>;Users;Courses
  671. <strong>xxx1</strong>;xxx;<strong>xxx;xxx</strong>;username1|username2;course1[coach1][username1,username2,...]|course2[coach1][username1,username2,...]
  672. <strong>xxx2</strong>;xxx;<strong>xxx;xxx</strong>;username1|username2;course1[coach1][username1,username2,...]|course2[coach1][username1,username2,...]
  673. </pre>
  674. </blockquote>
  675. <p><?php echo get_lang('XMLMustLookLike').' ('.get_lang('MandatoryFields').')'; ?> :</p>
  676. <blockquote>
  677. <pre>
  678. &lt;?xml version=&quot;1.0&quot; encoding=&quot;<?php echo api_refine_encoding_id(api_get_system_encoding()); ?>&quot;?&gt;
  679. &lt;Sessions&gt;
  680. &lt;Users&gt;
  681. &lt;User&gt;
  682. &lt;Username&gt;<strong>username1</strong>&lt;/Username&gt;
  683. &lt;Lastname&gt;xxx&lt;/Lastname&gt;
  684. &lt;Firstname&gt;xxx&lt;/Firstname&gt;
  685. &lt;Password&gt;xxx&lt;/Password&gt;
  686. &lt;Email&gt;xxx@xx.xx&lt;/Email&gt;
  687. &lt;OfficialCode&gt;xxx&lt;/OfficialCode&gt;
  688. &lt;Phone&gt;xxx&lt;/Phone&gt;
  689. &lt;Status&gt;student|teacher&lt;/Status&gt;
  690. &lt;/User&gt;
  691. &lt;/Users&gt;
  692. &lt;Courses&gt;
  693. &lt;Course&gt;
  694. &lt;CourseCode&gt;<strong>xxx</strong>&lt;/CourseCode&gt;
  695. &lt;CourseTeacher&gt;<strong>teacher_username</strong>&lt;/CourseTeacher&gt;
  696. &lt;CourseLanguage&gt;xxx&lt;/CourseLanguage&gt;
  697. &lt;CourseTitle&gt;xxx&lt;/CourseTitle&gt;
  698. &lt;CourseDescription&gt;xxx&lt;/CourseDescription&gt;
  699. &lt;/Course&gt;
  700. &lt;/Courses&gt;
  701. &lt;Session&gt;
  702. <strong>&lt;SessionName&gt;xxx&lt;/SessionName&gt;</strong>
  703. &lt;Coach&gt;xxx&lt;/Coach&gt;
  704. <strong>&lt;DateStart&gt;xxx&lt;/DateStart&gt;</strong>
  705. <strong>&lt;DateEnd&gt;xxx&lt;/DateEnd&gt;</strong>
  706. &lt;User&gt;xxx&lt;/User&gt;
  707. &lt;User&gt;xxx&lt;/User&gt;
  708. &lt;Course&gt;
  709. &lt;CourseCode&gt;coursecode1&lt;/CourseCode&gt;
  710. &lt;Coach&gt;coach1&lt;/Coach&gt;
  711. &lt;User&gt;username1&lt;/User&gt;
  712. &lt;User&gt;username2&lt;/User&gt;
  713. &lt;/Course&gt;
  714. &lt;/Session&gt;
  715. &lt;Session&gt;
  716. <strong>&lt;SessionName&gt;xxx&lt;/SessionName&gt;</strong>
  717. &lt;Coach&gt;xxx&lt;/Coach&gt;
  718. <strong>&lt;DateStart&gt;xxx&lt;/DateStart&gt;</strong>
  719. <strong>&lt;DateEnd&gt;xxx&lt;/DateEnd&gt;</strong>
  720. &lt;User&gt;xxx&lt;/User&gt;
  721. &lt;User&gt;xxx&lt;/User&gt;
  722. &lt;Course&gt;
  723. &lt;CourseCode&gt;coursecode1&lt;/CourseCode&gt;
  724. &lt;Coach&gt;coach1&lt;/Coach&gt;
  725. &lt;User&gt;username1&lt;/User&gt;
  726. &lt;User&gt;username2&lt;/User&gt;
  727. &lt;/Course&gt;
  728. &lt;/Session&gt;
  729. &lt;/Sessions&gt;
  730. </pre>
  731. </blockquote>
  732. </font>
  733. <?php
  734. /* FOOTER */
  735. Display::display_footer();