/** * Create new document */ function create($user = null, $category = false) { $arr["users_id"] = $user; $arr["date_created"] = date("Y-m-d H:i:s"); $arr["date_published"] = date("Y-m-d H:i:s"); if ($category != false) { $arr["pages_id"] = $category; } if ($this->getTitle()) { $arr["title"] = $this->getTitle(); } if ($this->getPreview()) { $arr["preview"] = $this->getPreview(); } if ($this->getMetaKey()) { $arr["metakeys"] = $this->getMetaKey(); } if ($this->getPublic()) { $arr["public"] = $this->getPublic(); } if ($this->getParent()) { $arr["pages_id"] = $this->getParent(); } if ($this->getSlug()) { $slug = $this->getSlug(); } else { if ($this->checkReservedNames($arr["title"])) { $slug = $arr["title"] . '-name'; } else { $slug = $arr["title"]; } } $slugNew = $this->generate($slug); $arr["slug"] = $slugNew; $arr["pages_types_id"] = $this->getType(); $id = $this->database->table("pages")->insert($arr); $this->database->query("SET @i = 1;UPDATE `pages` SET `sorted` = @i:=@i+2 ORDER BY `sorted` ASC"); return $id; }
/** * Vrací vysledek custom dotazu * @return Nette\Database\Context\ResultSet */ public function query($query) { return $this->database->query($query); }