public function add($vals)
{
$arr = array("titulek" => $vals['titulek'], "autor" => $vals["autor"], "kategorie_id" => $vals['kategorie_id'], "obrazek_id" => $vals['obrazek_id']);
if (!empty($vals['skupina'])) {
$arr['skupina'] = $vals['skupina'];
}
if (empty($vals['id'])) {
$this->database->query("INSERT INTO clanky ", $arr);
$id = $this->database->getInsertId();
} else {
$this->database->query("UPDATE clanky SET ", $arr, " WHERE id=?", $vals['id']);
$id = $vals['id'];
}
$arr = array("clanek_id" => $id, "perex" => $vals['perex'], "text" => $vals['text']);
$this->database->query("INSERT INTO clanky_revize", $arr);
$this->database->query("DELETE FROM stitky WHERE clanek_id=?;", $id);
$stitky = explode("\n", $vals['stitky_text']);
foreach ($stitky as $key => $stitek) {
if (empty($stitek)) {
continue;
}
$stitky[$key] = trim($stitek);
}
$stitky = array_unique($stitky);
foreach ($stitky as $stitek) {
$this->database->query("INSERT INTO stitky ", array("clanek_id" => $id, "stitek" => trim($stitek)));
}
return $id;
}