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