'index.php', 'name' => get_lang('PlatformAdmin')); $interbreadcrumb[] = array('url' => 'session_list.php', 'name' => get_lang('SessionList')); set_time_limit(0); // Set this option to true to enforce strict purification for usenames. $purification_option_for_usernames = false; $inserted_in_course = array(); $warn = null; if (isset($_POST['formSent']) && $_POST['formSent']) { if (isset($_FILES['import_file']['tmp_name']) && !empty($_FILES['import_file']['tmp_name']) ) { $form_sent = $_POST['formSent']; $file_type = isset($_POST['file_type']) ? $_POST['file_type'] : null; $send_mail = isset($_POST['sendMail']) && $_POST['sendMail'] ? 1 : 0; $isOverwrite = isset($_POST['overwrite']) && $_POST['overwrite'] ? true : false; $deleteUsersNotInList = isset($_POST['delete_users_not_in_list']) ? true : false; $sessions = array(); $session_counter = 0; if ($file_type == 'xml') { // XML // 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? // 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. // Instead of: // $root = @simplexml_load_file($_FILES['import_file']['tmp_name']); // we may use the following construct: // $root = @simplexml_load_string(api_utf8_encode_xml(file_get_contents($_FILES['import_file']['tmp_name']))); // To ease debugging let us use: $content = file_get_contents($_FILES['import_file']['tmp_name']); $content = api_utf8_encode_xml($content); $root = @simplexml_load_string($content); unset($content); if (is_object($root)) { if (count($root->Users->User) > 0) { // Creating/updating users from base node. foreach ($root->Users->User as $node_user) { $username = $username_old = trim(api_utf8_decode($node_user->Username)); if (UserManager::is_username_available($username)) { $password = api_utf8_decode($node_user->Password); if (empty($password)) { $password = api_generate_password(); } switch ($node_user->Status) { case 'student' : $status = 5; break; case 'teacher' : $status = 1; break; default: $status = 5; $error_message .= get_lang('StudentStatusWasGivenTo').' : '.$username.'
'; } $result = UserManager::create_user( api_utf8_decode($node_user->Firstname), api_utf8_decode($node_user->Lastname), $status, api_utf8_decode($node_user->Email), $username, $password, api_utf8_decode($node_user->OfficialCode), null, api_utf8_decode($node_user->Phone), null, PLATFORM_AUTH_SOURCE, null, 1, 0, null, null, $send_mail ); } else { $lastname = trim(api_utf8_decode($node_user->Lastname)); $firstname = trim(api_utf8_decode($node_user->Firstname)); $password = api_utf8_decode($node_user->Password); $email = trim(api_utf8_decode($node_user->Email)); $official_code = trim(api_utf8_decode($node_user->OfficialCode)); $phone = trim(api_utf8_decode($node_user->Phone)); $status = trim(api_utf8_decode($node_user->Status)); switch ($status) { case 'student': $status = 5; break; case 'teacher': $status = 1; break; default: $status = 5; $error_message .= get_lang('StudentStatusWasGivenTo').' : '.$username.'
'; } $userId = UserManager::get_user_id_from_username($username); if (!empty($userId)) { UserManager::update_user( $userId, $firstname, $lastname, $username, $password, null, $email, $status, $official_code, $phone, null, //$picture_uri, null, //$expiration_date, null, //$active, null, //$creator_id = null, 0, null, //$extra = null, null, //$language = 'english', null, //$encrypt_method = '', false, 0 //$reset_password = 0 ); } } } } // Creating courses from base node. if (count($root->Courses->Course) > 0) { foreach ($root->Courses->Course as $courseNode) { $params = array(); if (empty($courseNode->CourseTitle)) { $params['title'] = api_utf8_decode($courseNode->CourseCode); } else { $params['title'] = api_utf8_decode($courseNode->CourseTitle); } $params['wanted_code'] = api_utf8_decode($courseNode->CourseCode); $params['tutor_name'] = null; $params['course_category'] = null; $params['course_language'] = api_utf8_decode($courseNode->CourseLanguage); $params['user_id'] = api_get_user_id(); // Looking up for the teacher. $username = trim(api_utf8_decode($courseNode->CourseTeacher)); $sql = "SELECT user_id, lastname, firstname FROM $tbl_user WHERE username='$username'"; $rs = Database::query($sql); list($user_id, $lastname, $firstname) = Database::fetch_array($rs); $params['teachers'] = $user_id; CourseManager::create_course($params); } } // Creating sessions from base node. if (count($root->Session) > 0) { foreach ($root->Session as $node_session) { $course_counter = 0; $user_counter = 0; $session_name = trim(api_utf8_decode($node_session->SessionName)); $coach = UserManager::purify_username( api_utf8_decode($node_session->Coach), $purification_option_for_usernames ); if (!empty($coach)) { $coach_id = UserManager::get_user_id_from_username($coach); if ($coach_id === false) { $error_message .= get_lang('UserDoesNotExist').' : '.$coach.'
'; // Forcing the coach id if user does not exist. $coach_id = api_get_user_id(); } } else { // Forcing the coach id. $coach_id = api_get_user_id(); } // Just in case - encoding conversion. $date_start = trim(api_utf8_decode($node_session->DateStart)); if (!empty($date_start)) { list($year_start, $month_start, $day_start) = explode('/', $date_start); if (empty($year_start) || empty($month_start) || empty($day_start)) { $error_message .= get_lang('WrongDate').' : '.$date_start.'
'; break; } else { $time_start = mktime(0, 0, 0, $month_start, $day_start, $year_start); } $date_end = trim(api_utf8_decode($node_session->DateEnd)); if (!empty($date_start)) { list($year_end, $month_end, $day_end) = explode('/', $date_end); if (empty($year_end) || empty($month_end) || empty($day_end)) { $error_message .= get_lang('Error').' : '.$date_end.'
'; break; } else { $time_end = mktime(0, 0, 0, $month_end, $day_end, $year_end); } } if ($time_end - $time_start < 0) { $error_message .= get_lang('StartDateShouldBeBeforeEndDate').' : '.$date_end.'
'; } } $visibility = trim(api_utf8_decode($node_session->Visibility)); $session_category_id = trim(api_utf8_decode($node_session->SessionCategory)); if (!$updatesession) { // Always create a session. $unique_name = false; // This MUST be initializead. $i = 0; // Change session name, verify that session doesn't exist. while (!$unique_name) { if ($i > 1) { $suffix = ' - '.$i; } $sql = 'SELECT 1 FROM '.$tbl_session.' WHERE name="'.Database::escape_string($session_name.$suffix).'"'; $rs = Database::query($sql); if (Database::result($rs, 0, 0)) { $i++; } else { $unique_name = true; $session_name .= $suffix; } } // Creating the session. $sql_session = "INSERT IGNORE INTO $tbl_session SET name = '".Database::escape_string($session_name)."', id_coach = '$coach_id', access_start_date = '$date_start', access_end_date = '$date_end', visibility = '$visibility', session_category_id = '$session_category_id', session_admin_id=".intval($_user['user_id']); $rs_session = Database::query($sql_session); $session_id = Database::insert_id(); $session_counter++; } else { // Update the session if it is needed. $my_session_result = SessionManager::get_session_by_name($session_name); if ($my_session_result === false) { // Creating the session. $sql_session = "INSERT IGNORE INTO $tbl_session SET name = '".Database::escape_string($session_name)."', id_coach = '$coach_id', access_start_date = '$date_start', access_end_date = '$date_end', visibility = '$visibility', session_category_id = '$session_category_id', session_admin_id=".intval($_user['user_id']); $rs_session = Database::query($sql_session); $session_id = Database::insert_id(); $session_counter++; } else { // if the session already exists - update it. $sql_session = "UPDATE $tbl_session SET id_coach = '$coach_id', access_start_date = '$date_start', access_end_date = '$date_end', visibility = '$visibility', session_category_id = '$session_category_id' WHERE name = '$session_name'"; $rs_session = Database::query($sql_session); $session_id = Database::query("SELECT id FROM $tbl_session WHERE name='$session_name'"); list($session_id) = Database::fetch_array($session_id); Database::query("DELETE FROM $tbl_session_user WHERE session_id ='$session_id'"); Database::query("DELETE FROM $tbl_session_course WHERE session_id='$session_id'"); Database::query("DELETE FROM $tbl_session_course_user WHERE session_id='$session_id'"); } } // Associate the session with access_url. if (api_is_multiple_url_enabled()) { $access_url_id = api_get_current_access_url_id(); UrlManager::add_session_to_url($session_id, $access_url_id); } else { // We fill by default the access_url_rel_session table. UrlManager::add_session_to_url($session_id, 1); } // Adding users to the new session. foreach ($node_session->User as $node_user) { $username = UserManager::purify_username(api_utf8_decode($node_user), $purification_option_for_usernames); $user_id = UserManager::get_user_id_from_username($username); if ($user_id !== false) { $sql = "INSERT IGNORE INTO $tbl_session_user SET user_id ='$user_id', session_id = '$session_id', registered_at = '".api_get_utc_datetime()."'"; $rs_user = Database::query($sql); $user_counter++; } } // Adding courses to a session. foreach ($node_session->Course as $node_course) { $course_code = Database::escape_string(trim(api_utf8_decode($node_course->CourseCode))); // Verify that the course pointed by the course code node exists. if (CourseManager::course_exists($course_code)) { // If the course exists we continue. $course_info = CourseManager::get_course_information($course_code); $courseId = $course_info['real_id']; $session_course_relation = SessionManager::relation_session_course_exist($session_id, $courseId); if (!$session_course_relation) { $sql_course = "INSERT INTO $tbl_session_course SET c_id = $courseId, session_id = $session_id"; $rs_course = Database::query($sql_course); SessionManager::installCourse($id_session, $courseId); } $course_coaches = explode(',', $node_course->Coach); // Adding coachs to session course user foreach ($course_coaches as $course_coach) { $coach_id = UserManager::purify_username(api_utf8_decode($course_coach), $purification_option_for_usernames); $coach_id = UserManager::get_user_id_from_username($course_coach); if ($coach_id !== false) { $sql = "INSERT IGNORE INTO $tbl_session_course_user SET user_id='$coach_id', c_id = '$courseId', session_id = '$session_id', status = 2 "; $rs_coachs = Database::query($sql); } else { $error_message .= get_lang('UserDoesNotExist').' : '.$user.'
'; } } // Adding users. $course_counter++; $users_in_course_counter = 0; foreach ($node_course->User as $node_user) { $username = UserManager::purify_username(api_utf8_decode($node_user), $purification_option_for_usernames); $user_id = UserManager::get_user_id_from_username($username); if ($user_id !== false) { // Adding to session_rel_user table. $sql = "INSERT IGNORE INTO $tbl_session_user SET user_id ='$user_id', session_id = '$session_id', registered_at = '".api_get_utc_datetime()."'"; $rs_user = Database::query($sql); $user_counter++; // Adding to session_rel_user_rel_course table. $sql = "INSERT IGNORE INTO $tbl_session_course_user SET user_id = '$user_id', c_id = '$courseId', session_id = '$session_id'"; $rs_users = Database::query($sql); $users_in_course_counter++; } else { $error_message .= get_lang('UserDoesNotExist').' : '.$username.'
'; } } $sql = "UPDATE $tbl_session_course SET nbr_users='$users_in_course_counter' WHERE c_id='$courseId'"; Database::query($sql); $inserted_in_course[$course_code] = $course_info['title']; } } Database::query("UPDATE $tbl_session SET nbr_users='$user_counter', nbr_courses='$course_counter' WHERE id='$session_id'"); } } if (empty($root->Users->User) && empty($root->Courses->Course) && empty($root->Session)) { $error_message = get_lang('NoNeededData'); } } else { $error_message .= get_lang('XMLNotValid'); } } else { // CSV $updateCourseCoaches = isset($_POST['update_course_coaches']) ? true : false; $addOriginalCourseTeachersAsCourseSessionCoaches = isset($_POST['add_me_as_coach']) ? true : false; $result = SessionManager::importCSV( $_FILES['import_file']['tmp_name'], $isOverwrite, api_get_user_id(), null, array(), null, null, null, 1, array(), $deleteUsersNotInList, $updateCourseCoaches, false, $addOriginalCourseTeachersAsCourseSessionCoaches, false ); $sessionList = $result['session_list']; $error_message = $result['error_message']; $session_counter = $result['session_counter']; } if (!empty($error_message)) { $error_message = get_lang('ButProblemsOccured').' :
'.$error_message; } if (count($inserted_in_course) > 1) { $warn = get_lang('SeveralCoursesSubscribedToSessionBecauseOfSameVisualCode').': '; foreach ($inserted_in_course as $code => $title) { $warn .= ' '.$title.' ('.$code.'),'; } $warn = substr($warn, 0, -1); } if ($session_counter == 1) { if ($file_type == 'csv') { $session_id = current($sessionList); } Display::addFlash(Display::return_message($warn)); header('Location: resume_session.php?id_session='.$session_id); exit; } else { Display::addFlash(Display::return_message(get_lang('FileImported').' '.$error_message)); header('Location: session_list.php'); exit; } } else { $error_message = get_lang('NoInputFile'); } } // Display the header. Display::display_header($tool_name); if (count($inserted_in_course) > 1) { $msg = get_lang('SeveralCoursesSubscribedToSessionBecauseOfSameVisualCode').': '; foreach ($inserted_in_course as $code => $title) { $msg .= ' '.$title.' ('.$title.'),'; } $msg = substr($msg, 0, -1); echo Display::return_message($msg, 'warning'); } echo ''; if (!empty($error_message)) { echo Display::return_message($error_message, 'normal', false); } $form = new FormValidator('import_sessions', 'post', api_get_self(), null, array('enctype' => 'multipart/form-data')); $form->addElement('hidden', 'formSent', 1); $form->addElement('file', 'import_file', get_lang('ImportFileLocation')); $form->addElement( 'radio', 'file_type', [ get_lang('FileType'), Display::url( get_lang('ExampleCSVFile'), api_get_path(WEB_CODE_PATH).'admin/example_session.csv', ['target' => '_blank'] ) ], 'CSV', 'csv' ); $form->addElement( 'radio', 'file_type', [ null, Display::url( get_lang('ExampleXMLFile'), api_get_path(WEB_CODE_PATH).'admin/example_session.xml', ['target' => '_blank'] ) ], 'XML', 'xml' ); $form->addElement('checkbox', 'overwrite', null, get_lang('IfSessionExistsUpdate')); $form->addElement('checkbox', 'delete_users_not_in_list', null, get_lang('DeleteUsersNotInList')); $form->addElement('checkbox', 'update_course_coaches', null, get_lang('CleanAndUpdateCourseCoaches')); $form->addElement('checkbox', 'add_me_as_coach', null, get_lang('AddMeAsCoach')); $form->addElement('checkbox', 'sendMail', null, get_lang('SendMailToUsers')); $form->addButtonImport(get_lang('ImportSession')); $defaults = array('sendMail' => 'true', 'file_type' => 'csv'); $form->setDefaults($defaults); Display::return_message(get_lang('TheXMLImportLetYouAddMoreInfoAndCreateResources')); $form->display(); ?>

:

SessionName;Coach;DateStart;DateEnd;Users;Courses;VisibilityAfterExpiration
Example 1;username;yyyy/mm/dd;yyyy/mm/dd;username1|username2;course1[coach1][username1,username2,...]|course2[coach1][username1,username2,...];read_only
Example 2;username;yyyy/mm/dd;yyyy/mm/dd;username1|username2;course1[coach1][username1,username2,...]|course2[coach1][username1,username2,...];accessible
Example 3;username;yyyy/mm/dd;yyyy/mm/dd;username1|username2;course1[coach1][username1,username2,...]|course2[coach1][username1,username2,...];not_accessible

:

<?xml version="1.0" encoding="UTF-8"?>
<Sessions>
    <Users>
        <User>
            <Username>username1</Username>
            <Lastname>xxx</Lastname>
            <Firstname>xxx</Firstname>
            <Password>xxx</Password>
            <Email>xxx@xx.xx</Email>
            <OfficialCode>xxx</OfficialCode>
            <Phone>xxx</Phone>
            <Status>student|teacher</Status>
        </User>
    </Users>
    <Courses>
        <Course>
            <CourseCode>xxx</CourseCode>
            <CourseTeacher>teacher_username</CourseTeacher>
            <CourseLanguage>xxx</CourseLanguage>
            <CourseTitle>xxx</CourseTitle>
            <CourseDescription>xxx</CourseDescription>
        </Course>
    </Courses>
    <Session>
        <SessionName>xxx</SessionName>
        <Coach>xxx</Coach>
        <DateStart>yyyy/mm/dd</DateStart>
        <DateEnd>yyyy/mm/dd</DateEnd>
        <User>xxx</User>
        <User>xxx</User>
        <Course>
            <CourseCode>coursecode1</CourseCode>
            <Coach>coach1</Coach>
        <User>username1</User>
        <User>username2</User>
        </Course>
    </Session>

    <Session>
        <SessionName>xxx</SessionName>
        <Coach>xxx</Coach>
        <DateStart>xxx</DateStart>
        <DateEnd>xxx</DateEnd>
        <User>xxx</User>
        <User>xxx</User>
        <Course>
            <CourseCode>coursecode1</CourseCode>
            <Coach>coach1</Coach>
        <User>username1</User>
        <User>username2</User>
        </Course>
    </Session>
</Sessions>