/**
* Imports the course defined in the csv file, and then returns the generated identifier for it. This is made under the
* transaction initiated in import_data function.
*
* @param object $coursefile Course csv file.
* @param object $formdata Submitted form data, needed to load the csv.
* @param \block_mycourse_recommendations\database_helper $db Database handler object, passed as argument to instance it
* again.
* @return int Course id generated.
*/
public static function import_course($coursefile, $formdata, $db)
{
$iid = \csv_import_reader::get_new_iid('coursefile');
$csvreader = new \csv_import_reader($iid, 'coursefile');
$csvreader->load_csv_content($coursefile, $formdata->encoding, $formdata->delimiter_name);
$csvreader->init();
$fields = $csvreader->get_columns();
while ($fields) {
$fullname = $fields[0];
$shortname = $fields[1];
$startdate = $fields[2];
$idnumber = $fields[3];
$category = $fields[4];
$courseid = $db->insert_historic_course($fullname, $shortname, $startdate, $idnumber, $category);
self::$lastinsertedcourses++;
$fields = $csvreader->next();
}
$csvreader->close();
return $courseid;
}
