Source for file course_import.php

 

 

 

 

 

 

    $errors = array ();

    $coursecodes = array ();

    foreach ($courses as $index => $course)

    {

        $course['line'] = $index +1;

        //1. check if mandatory fields are set

        $mandatory_fields = array ('Code', 'Title', 'CourseCategory', 'Teacher');

        foreach ($mandatory_fields as $key => $field)

        {

            if (!isset ($course[$field]) || strlen($course[$field]) == 0)

            {

                $course['error'] = get_lang($field.'Mandatory');

                $errors[] = $course;

            }

        }

        //2. check if code isn't in use

        if (isset ($course['Code']) && strlen($course['Code']) != 0)

        {

            //2.1 check if code allready used in this CVS-file

            if (isset ($coursecodes[$course['Code']]))

            {

                $course['error'] = get_lang('CodeTwiceInFile');

                $errors[] = $course;

            }

            elseif(strlen($course['Code']) > 20)

            {

                $course['error'] = get_lang('Max');

                $errors[] = $course;

            }

            //2.3 check if code allready used in DB

            else

            {

                $course_table = Database :: get_main_table(TABLE_MAIN_COURSE);

                $sql = "SELECT * FROM $course_table WHERE code = '".mysql_real_escape_string($course['Code'])."'";

                $res = api_sql_query($sql, __FILE__, __LINE__);

                if (mysql_num_rows($res) > 0)

                {

                    $course['error'] = get_lang('CodeExists');

                    $errors[] = $course;

                }

            }

            $coursecodes[$course['Code']] = 1;

        }

        //3. check if teacher exists

        if (isset ($course['Teacher']) && strlen($course['Teacher']) != 0)

        {

            if (UserManager :: is_username_available($course['Teacher']))

            {

                $course['error'] = get_lang('UnknownTeacher');

                $errors[] = $course;

            }

        }

        //4. check if category exists

        if (isset ($course['CourseCategory']) && strlen($course['CourseCategory']) != 0)

        {

            $category_table = Database :: get_main_table(TABLE_MAIN_CATEGORY);

            $sql = "SELECT * FROM $category_table WHERE code = '".mysql_real_escape_string($course['CourseCategory'])."'";

            $res = api_sql_query($sql, __FILE__, __LINE__);

            if (mysql_num_rows($res) == 0)

            {

                $course['error'] = get_lang('UnkownCategory');

                $errors[] = $course;

            }

        }

    }

    return $errors;

 

    global $_configuration, $firstExpirationDelay;

    

    foreach($courses as $index => $course)

    {

        $keys = define_course_keys($course['Code'], "", $_configuration['db_prefix']);

        $user_table = Database::get_main_table(TABLE_MAIN_USER);

        $sql = "SELECT user_id, CONCAT(lastname,' ',firstname) AS name FROM $user_table WHERE username = '".mysql_real_escape_string($course['Teacher'])."'";

        $res = api_sql_query($sql,__FILE__,__LINE__);

        $teacher = mysql_fetch_object($res);

        $visual_code = $keys["currentCourseCode"];

        $code = $keys["currentCourseId"];

        $db_name = $keys["currentCourseDbName"];

        $directory = $keys["currentCourseRepository"];

        $expiration_date = time() + $firstExpirationDelay;

        prepare_course_repository($directory, $code);

        update_Db_course($db_name);

        fill_course_repository($directory);

        fill_Db_course($db_name, $directory, api_get_setting('platformLanguage'));

        register_course($code, $visual_code, $directory, $db_name, $teacher->name, $course['CourseCategory'], $course['Title'], api_get_setting('platformLanguage'), $teacher->user_id, $expiration_date);

        echo $code.' CREATED<br />';

    }

    $courses = Import :: csv_to_array($file);

    return $courses;

 

$language_file = array ('admin', 'registration','create_course', 'document');

 

$cidReset = true;

 

require_once (api_get_path(LIBRARY_PATH).'fileManage.lib.php');

require_once (api_get_path(LIBRARY_PATH).'import.lib.php');

require_once (api_get_path(LIBRARY_PATH).'usermanager.lib.php');

require_once (api_get_path(CONFIGURATION_PATH).'add_course.conf.php');

require_once (api_get_path(LIBRARY_PATH).'add_course.lib.inc.php');

$formSent = 0;

$errorMsg = '';

$defined_auth_sources[] = PLATFORM_AUTH_SOURCE;

    $defined_auth_sources = array_merge($defined_auth_sources, array_keys($extAuthSource));

 

$tool_name = get_lang('AddCourse').' CSV';

 

$interbreadcrumb[] = array ("url" => 'index.php', "name" => get_lang('PlatformAdmin'));

 

    if(empty($_FILES['import_file']['tmp_name']))

    {

        $error_message = get_lang('UplUploadFailed');

        Display :: display_error_message($error_message, false);

    }

    else

    {

        $file_type = $_POST['file_type'];

        $courses = parse_csv_data($_FILES['import_file']['tmp_name']);

        $errors = validate_data($courses);

        if (count($errors) == 0)

        {

            //$users = complete_missing_data($courses);

            save_data($courses);

            //header('Location: user_list.php?action=show_message&message='.urlencode(get_lang('FileImported')));

            //exit ();

        }

    }

 

if (count($errors) != 0)

    $error_message = '<ul>';

    foreach ($errors as $index => $error_course)

    {

        $error_message .= '<li>'.get_lang('Line').' '.$error_course['line'].': <b>'.$error_course['error'].'</b>: ';

        $error_message .= $error_course['Code'].' '.$error_course['Title'];

        $error_message .= '</li>';

    }

    $error_message .= '</ul>';

    Display :: display_error_message($error_message, false);

<form method="post" action="<?php echo api_get_self(); ?>" enctype="multipart/form-data" style="margin:0px;">

<input type="file" name="import_file"/>

<input type="hidden" name="formSent" value="1"/>

<input type="submit" value="<?php echo get_lang('Ok'); ?>"/>

</form>

<p><?php echo get_lang('CSVMustLookLike').' ('.get_lang('MandatoryFields').')'; ?> :</p>

 

<blockquote>

<pre>

<b>Code</b>;<b>Title</b>;<b>CourseCategory</b>;<b>Teacher</b>

BIO0015;Biology;BIO;username

</pre>

</blockquote>