public function actionImportClasses()
{
$result = $this->model->importClasses();
$messages = $result->messages;
$data = $result->data;
$reports = array();
$this->classesModel->invalidate();
foreach ($data as $record) {
$id = $this->classesModel->existsBakalari($record->bakalari_code);
$teacher = $this->teachersModel->query("SELECT user_id FROM sch_teacher WHERE bakalari_code = \"{$record->teacher_code}\"")->fetch();
if (!$id) {
$newrec = array("name" => $record->name, "shortname" => $record->shortname, "year" => $record->year, "bakalari_code" => $record->bakalari_code);
if ($teacher) {
$newrec["teacher_id"] = $teacher["user_id"];
}
$newid = $this->classesModel->insert($newrec);
$reports[] = "ADD: Třída " . $record->shortname . " byla přidána. ({$newid})";
} else {
$recid = $id->id;
$newrec = array("name" => $record->name, "shortname" => $record->shortname, "year" => $record->year, "bakalari_code" => $record->bakalari_code, "invalidated" => 0);
if ($teacher) {
$newrec["teacher_id"] = $teacher["user_id"];
}
$this->classesModel->update($recid, $newrec);
$reports[] = "UPDATE: Třída " . $record->shortname . " byla aktualizována. ({$recid})";
}
}
$this->classesModel->removeUnused();
$this->template->reports = $reports;
$this->template->messages = $messages;
$this->setView("result");
}
