/**
* 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);
}
