public function actionImportSubjects()
{
$result = $this->model->importSubjects();
$messages = $result->messages;
$data = $result->data;
$reports = array();
foreach ($data as $record) {
$a = $this->subjectsModel->query("SELECT * FROM `sch_subject` WHERE `bakalari_code` = '{$record->bakalari_code}' ")->fetch();
if (!$a) {
$this->subjectsModel->insert(array("name" => $record->name, "shortname" => $record->shortname, "bakalari_code" => $record->bakalari_code));
$reports[] = "ADD: Předmět " . $record->name . " byl přidán.";
} else {
$this->subjectsModel->update($a->id, array("name" => $record->name, "shortname" => $record->shortname));
$reports[] = "UPDATE: Předmět " . $a->name . " byl aktualizován. (" . $a->id . ")";
}
}
$this->template->reports = $reports;
$this->template->messages = $messages;
$this->setView("result");
}
