JuKu / JuKuCMS

system/packages/com.jukusoft.cms.page/classes/page.php

Indentation +487 added lines, -487 removed lines

@@ -18,510 +18,510 @@
 
 class Page {
 
-	protected $pageID = -1;
-	protected $alias = null;
-	protected $row = null;
-	protected $pagetype = "";
-
-	protected $author = null;
-
-	//changed columns to save with save()
-	protected $changes = array();
-
-	public function __construct() {
-		//
-	}
-
-	public function load ($alias = null) {
-		if ($alias == null) {
-			if (isset($_REQUEST['page']) && !empty($_REQUEST['page'])) {
-				$alias = Validator_String::get($_REQUEST['page']);
-			} else {
-				$alias = $this->getDomain()->getHomePage();
-			}
-		} else {
-			//$alias = Database::getInstance()->escape($alias);
-		}
-
-		Events::throwEvent("get_alias", array(
-			'alias' => &$alias,
-			'page' => &$this,
-			'domain' => $this->getDomain()
-		));
-
-		$this->alias = $alias;
-
-		if (Cache::contains("pages", "page_" . $alias)) {
-			$this->row = Cache::get("pages", "page_" . $alias);
-		} else {
-			$row = Database::getInstance()->getRow("SELECT * FROM `{praefix}pages` WHERE `alias` = :alias AND `activated` = '1'; ", array('alias' => $alias));
-
-			if (!$row) {
-				if (PHPUtils::strEqs("error404", $alias)) {
-					throw new IllegalStateException("No page with alias 'error404' exists (requested alias: " . $alias . ").");
-				}
-
-				//page not found
-				$new_alias = "error404";
-
-				Events::throwEvent("load_page_error404", array(
-					'alias' => &$new_alias,
-					'original_alias' => $alias,
-					'page' => &$this,
-					'domain' => $this->getDomain()
-				));
-
-				$this->load($new_alias);
-				return null;
-			}
-
-			$this->row = $row;
-
-			//cache result
-			Cache::put("pages", "page_" . $alias, $row);
-		}
-
-		//get pageID
-		$this->pageID = $this->row['id'];
-
-		//get name of page type (class name)
-		$this->pagetype = $this->row['page_type'];
-	}
-
-	public function loadByID (int $pageID, bool $use_cache = true) {
-		if ($use_cache && Cache::contains("pages", "pageID_" . $pageID)) {
-			$this->row = Cache::get("pages", "pageID_" . $pageID);
-		} else {
-			$row = Database::getInstance()->getRow("SELECT * FROM `{praefix}pages` WHERE `id` = :pageID; ", array('pageID' => $pageID));
-
-			if (!$row) {
-				throw new IllegalStateException("Page with pageID " . $pageID . " doesnt exists!");
-			}
-
-			$this->row = $row;
-
-			//cache result
-			Cache::put("pages", "pageID_" . $pageID, $row);
-		}
-
-		$this->pageID = $this->row['id'];
-		$this->alias = $this->row['alias'];
-
-		//get name of page type (class name)
-		$this->pagetype = $this->row['page_type'];
-	}
-
-	protected function getDomain () : Domain {
-		return Registry::singleton()->getObject("domain");
-	}
-
-	public function reloadCache () {
-		Cache::clear("pages");
-	}
-
-	public function getPageID () : int {
-		return $this->row['id'];
-	}
-
-	public function getAlias () : string {
-		return $this->alias;
-	}
-
-	public function getPageType () : string {
-		return $this->pagetype;
-	}
-
-	public function getTitle () : string {
-		return $this->row['title'];
-	}
-
-	public function setTitle (string $title) {
-		$this->row['title'] = $title;
-		$this->changes[] = "title";
-	}
-
-	public function getContent () : string {
-		return $this->row['content'];
-	}
-
-	public function setContent (string $content) {
-		$this->row['content'] = $content;
-		$this->changes[] = "content";
-		$this->changes[] = "content";
-	}
-
-	public function getGlobalMenuID () : int {
-		return $this->row['global_menu'];
-	}
-
-	public function getLocalMenuID () : int {
-		return $this->row['local_menu'];
-	}
-
-	public function getStyle () : string {
-		return $this->row['design'];
-	}
-
-	public function getFolder () : string {
-		return $this->row['folder'];
-	}
+    protected $pageID = -1;
+    protected $alias = null;
+    protected $row = null;
+    protected $pagetype = "";
+
+    protected $author = null;
+
+    //changed columns to save with save()
+    protected $changes = array();
+
+    public function __construct() {
+        //
+    }
+
+    public function load ($alias = null) {
+        if ($alias == null) {
+            if (isset($_REQUEST['page']) && !empty($_REQUEST['page'])) {
+                $alias = Validator_String::get($_REQUEST['page']);
+            } else {
+                $alias = $this->getDomain()->getHomePage();
+            }
+        } else {
+            //$alias = Database::getInstance()->escape($alias);
+        }
+
+        Events::throwEvent("get_alias", array(
+            'alias' => &$alias,
+            'page' => &$this,
+            'domain' => $this->getDomain()
+        ));
+
+        $this->alias = $alias;
+
+        if (Cache::contains("pages", "page_" . $alias)) {
+            $this->row = Cache::get("pages", "page_" . $alias);
+        } else {
+            $row = Database::getInstance()->getRow("SELECT * FROM `{praefix}pages` WHERE `alias` = :alias AND `activated` = '1'; ", array('alias' => $alias));
+
+            if (!$row) {
+                if (PHPUtils::strEqs("error404", $alias)) {
+                    throw new IllegalStateException("No page with alias 'error404' exists (requested alias: " . $alias . ").");
+                }
+
+                //page not found
+                $new_alias = "error404";
+
+                Events::throwEvent("load_page_error404", array(
+                    'alias' => &$new_alias,
+                    'original_alias' => $alias,
+                    'page' => &$this,
+                    'domain' => $this->getDomain()
+                ));
+
+                $this->load($new_alias);
+                return null;
+            }
+
+            $this->row = $row;
+
+            //cache result
+            Cache::put("pages", "page_" . $alias, $row);
+        }
+
+        //get pageID
+        $this->pageID = $this->row['id'];
+
+        //get name of page type (class name)
+        $this->pagetype = $this->row['page_type'];
+    }
+
+    public function loadByID (int $pageID, bool $use_cache = true) {
+        if ($use_cache && Cache::contains("pages", "pageID_" . $pageID)) {
+            $this->row = Cache::get("pages", "pageID_" . $pageID);
+        } else {
+            $row = Database::getInstance()->getRow("SELECT * FROM `{praefix}pages` WHERE `id` = :pageID; ", array('pageID' => $pageID));
+
+            if (!$row) {
+                throw new IllegalStateException("Page with pageID " . $pageID . " doesnt exists!");
+            }
+
+            $this->row = $row;
+
+            //cache result
+            Cache::put("pages", "pageID_" . $pageID, $row);
+        }
+
+        $this->pageID = $this->row['id'];
+        $this->alias = $this->row['alias'];
+
+        //get name of page type (class name)
+        $this->pagetype = $this->row['page_type'];
+    }
+
+    protected function getDomain () : Domain {
+        return Registry::singleton()->getObject("domain");
+    }
+
+    public function reloadCache () {
+        Cache::clear("pages");
+    }
+
+    public function getPageID () : int {
+        return $this->row['id'];
+    }
+
+    public function getAlias () : string {
+        return $this->alias;
+    }
+
+    public function getPageType () : string {
+        return $this->pagetype;
+    }
+
+    public function getTitle () : string {
+        return $this->row['title'];
+    }
+
+    public function setTitle (string $title) {
+        $this->row['title'] = $title;
+        $this->changes[] = "title";
+    }
+
+    public function getContent () : string {
+        return $this->row['content'];
+    }
+
+    public function setContent (string $content) {
+        $this->row['content'] = $content;
+        $this->changes[] = "content";
+        $this->changes[] = "content";
+    }
+
+    public function getGlobalMenuID () : int {
+        return $this->row['global_menu'];
+    }
+
+    public function getLocalMenuID () : int {
+        return $this->row['local_menu'];
+    }
+
+    public function getStyle () : string {
+        return $this->row['design'];
+    }
+
+    public function getFolder () : string {
+        return $this->row['folder'];
+    }
 
-	public function getLastEdit () {
-		return $this->row['lastUpdate'];
-	}
+    public function getLastEdit () {
+        return $this->row['lastUpdate'];
+    }
 
-	public function hasCustomTemplate () : bool {
-		return $this->row['template'] !== "none";
-	}
+    public function hasCustomTemplate () : bool {
+        return $this->row['template'] !== "none";
+    }
 
-	public function getCustomTemplate () : string {
-		return $this->row['template'];
-	}
+    public function getCustomTemplate () : string {
+        return $this->row['template'];
+    }
 
-	public function hasCustomPermissions () : bool {
-		return $this->row['can_see_permissions'] !== "none";
-	}
+    public function hasCustomPermissions () : bool {
+        return $this->row['can_see_permissions'] !== "none";
+    }
 
-	public function listCustomPermissions () : array {
-		return explode("|", $this->row['can_see_permissions']);
-	}
+    public function listCustomPermissions () : array {
+        return explode("|", $this->row['can_see_permissions']);
+    }
 
-	public function isPublished () : bool {
-		return $this->row['published'] == 1;
-	}
+    public function isPublished () : bool {
+        return $this->row['published'] == 1;
+    }
 
-	public function publish () {
-		$this->row['published'] = 1;
-		$this->changes[] = "published";
-	}
+    public function publish () {
+        $this->row['published'] = 1;
+        $this->changes[] = "published";
+    }
 
-	public function getContentType () : string {
-		return $this->row['content_type'];
-	}
+    public function getContentType () : string {
+        return $this->row['content_type'];
+    }
 
-	public function getParentID () : int {
-		return $this->row['parent'];
-	}
+    public function getParentID () : int {
+        return $this->row['parent'];
+    }
 
-	public function getLeftSidebarID () : int {
-		return $this->row['sidebar_left'];
-	}
+    public function getLeftSidebarID () : int {
+        return $this->row['sidebar_left'];
+    }
 
-	public function getRightSidebarID () : int {
-		return $this->row['sidebar_right'];
-	}
+    public function getRightSidebarID () : int {
+        return $this->row['sidebar_right'];
+    }
 
-	public function getMetaDescription () : string {
-		return $this->row['meta_description'];
-	}
+    public function getMetaDescription () : string {
+        return $this->row['meta_description'];
+    }
 
-	public function getMetaKeywords () : string {
-		return $this->row['meta_keywords'];
-	}
-
-	public function getMetaRobotsOptions () : string {
-		return $this->row['meta_robots'];
-	}
-
-	public function getMetaCanonicals () : string {
-		return $this->row['meta_canonicals'];
-	}
-
-	public function getOgType () : string {
-		return $this->row['og_type'];
-	}
-
-	public function getOgTitle () : string {
-		return !empty($this->row['og_title']) ? $this->row['og_title'] : $this->getTitle();
-	}
-
-	public function getOgDescription () : string {
-		return !empty($this->row['og_description']) ? $this->row['og_description'] : $this->getMetaDescription();
-	}
-
-	public function getOgImages () : array {
-		if (empty($this->row['og_image'])) {
-			return array();
-		}
-
-		return explode(",", $this->row['og_image']);
-	}
-
-	public function getAuthorID () : int {
-		return $this->row['author'];
-	}
-
-	public function getAuthor () : User {
-		if ($this->author == null) {
-			//load author
-			$this->author = new User();
-
-			if ($this->getAuthorID() <= 0) {
-				throw new IllegalArgumentException("authorID has to be > 0.");
-			}
-
-			$this->author->load($this->getAuthorID());
-		}
-
-		return $this->author;
-	}
-
-	public function isSitemapEnabled () : bool {
-		return $this->row['sitemap'] == 1;
-	}
-
-	public function getSitemapChangeFreq () : string {
-		return $this->row['sitemap_changefreq'];
-	}
-
-	public function getSitemapPriority () : string {
-		return $this->row['sitemap_priority'];
-	}
-
-	public function activate (bool $bool = true) {
-		$this->row['activated'] = ($bool ? 1 : 0);
-	}
-
-	public function isTrash () : bool {
-		return $this->row['activated'] == 2;
-	}
-
-	public function isEditable () : bool {
-		return $this->row['editable'] == 1;
-	}
-
-	public function isDeletable () : bool {
-		return $this->row['deletable'] == 1;
-	}
-
-	public function isActivated () : bool {
-		return $this->row['activated'] == 1;
-	}
-
-	public function moveToTrash () {
-		self::movePageToTrash($this->pageID);
-
-		//clear cache
-		$this->clearCache();
-	}
-
-	/**
-	 * restore page from trash
-	 */
-	public function restore () {
-		self::restorePage($this->pageID);
-
-		//clear cache
-		$this->clearCache();
-	}
-
-	/**
-	 * save changes into database
-	 */
-	public function save () {
-		//TODO: add code here
-	}
-
-	public function clearCache () {
-		if (!is_int($this->getPageID())) {
-			throw new IllegalStateException("pageID isn't set.");
-		}
-
-		//clear cache
-		Cache::clear("pages", "pageID_" . $this->getPageID());
-		Cache::clear("pages", "page_" . $this->getAlias());
-	}
-
-	public static function createIfAbsent (string $alias, string $title, string $page_type, string $content = "", string $folder = "/", int $globalMenu = -1, int $localMenu = -1, int $parentID = -1, bool $sitemap = true, bool $published = true, bool $editable = true, bool $deletable = true, string $author = "system") : int {
-		//throw event
-		Events::throwEvent("create_page", array(
-			'alias' => &$alias,
-			'title' => &$title,
-			'page_type' => &$page_type,
-			'content' => &$content,
-			'folder' => &$folder,
-			'global_menu' => &$globalMenu,
-			'local_menu' => &$localMenu,
-			'parentID' => &$parentID,
-			'sitemap' => &$sitemap,
-			'published' => &$published,
-			'editable' => &$editable,
-			'author' => &$author
-		));
-
-		if (!is_int($author)) {
-			//get userID of author
-			$author = User::getIDByUsernameFromDB($author);
-
-			if ($author == -1) {
-				//username doesnt exists, so choose first user
-				$author = 1;
-			}
-		} else {
-			$author = (int) $author;
-		}
-
-		Database::getInstance()->execute("INSERT INTO `{praefix}pages` (
+    public function getMetaKeywords () : string {
+        return $this->row['meta_keywords'];
+    }
+
+    public function getMetaRobotsOptions () : string {
+        return $this->row['meta_robots'];
+    }
+
+    public function getMetaCanonicals () : string {
+        return $this->row['meta_canonicals'];
+    }
+
+    public function getOgType () : string {
+        return $this->row['og_type'];
+    }
+
+    public function getOgTitle () : string {
+        return !empty($this->row['og_title']) ? $this->row['og_title'] : $this->getTitle();
+    }
+
+    public function getOgDescription () : string {
+        return !empty($this->row['og_description']) ? $this->row['og_description'] : $this->getMetaDescription();
+    }
+
+    public function getOgImages () : array {
+        if (empty($this->row['og_image'])) {
+            return array();
+        }
+
+        return explode(",", $this->row['og_image']);
+    }
+
+    public function getAuthorID () : int {
+        return $this->row['author'];
+    }
+
+    public function getAuthor () : User {
+        if ($this->author == null) {
+            //load author
+            $this->author = new User();
+
+            if ($this->getAuthorID() <= 0) {
+                throw new IllegalArgumentException("authorID has to be > 0.");
+            }
+
+            $this->author->load($this->getAuthorID());
+        }
+
+        return $this->author;
+    }
+
+    public function isSitemapEnabled () : bool {
+        return $this->row['sitemap'] == 1;
+    }
+
+    public function getSitemapChangeFreq () : string {
+        return $this->row['sitemap_changefreq'];
+    }
+
+    public function getSitemapPriority () : string {
+        return $this->row['sitemap_priority'];
+    }
+
+    public function activate (bool $bool = true) {
+        $this->row['activated'] = ($bool ? 1 : 0);
+    }
+
+    public function isTrash () : bool {
+        return $this->row['activated'] == 2;
+    }
+
+    public function isEditable () : bool {
+        return $this->row['editable'] == 1;
+    }
+
+    public function isDeletable () : bool {
+        return $this->row['deletable'] == 1;
+    }
+
+    public function isActivated () : bool {
+        return $this->row['activated'] == 1;
+    }
+
+    public function moveToTrash () {
+        self::movePageToTrash($this->pageID);
+
+        //clear cache
+        $this->clearCache();
+    }
+
+    /**
+     * restore page from trash
+     */
+    public function restore () {
+        self::restorePage($this->pageID);
+
+        //clear cache
+        $this->clearCache();
+    }
+
+    /**
+     * save changes into database
+     */
+    public function save () {
+        //TODO: add code here
+    }
+
+    public function clearCache () {
+        if (!is_int($this->getPageID())) {
+            throw new IllegalStateException("pageID isn't set.");
+        }
+
+        //clear cache
+        Cache::clear("pages", "pageID_" . $this->getPageID());
+        Cache::clear("pages", "page_" . $this->getAlias());
+    }
+
+    public static function createIfAbsent (string $alias, string $title, string $page_type, string $content = "", string $folder = "/", int $globalMenu = -1, int $localMenu = -1, int $parentID = -1, bool $sitemap = true, bool $published = true, bool $editable = true, bool $deletable = true, string $author = "system") : int {
+        //throw event
+        Events::throwEvent("create_page", array(
+            'alias' => &$alias,
+            'title' => &$title,
+            'page_type' => &$page_type,
+            'content' => &$content,
+            'folder' => &$folder,
+            'global_menu' => &$globalMenu,
+            'local_menu' => &$localMenu,
+            'parentID' => &$parentID,
+            'sitemap' => &$sitemap,
+            'published' => &$published,
+            'editable' => &$editable,
+            'author' => &$author
+        ));
+
+        if (!is_int($author)) {
+            //get userID of author
+            $author = User::getIDByUsernameFromDB($author);
+
+            if ($author == -1) {
+                //username doesnt exists, so choose first user
+                $author = 1;
+            }
+        } else {
+            $author = (int) $author;
+        }
+
+        Database::getInstance()->execute("INSERT INTO `{praefix}pages` (
 			`id`, `alias`, `title`, `content`, `parent`, `folder`, `global_menu`, `local_menu`, `page_type`, `design`, `sitemap`, `published`, `version`, `last_update`, `created`, `editable`, `deletable`, `author`, `activated`
 		) VALUES (
 			NULL, :alias, :title, :content, :parent, :folder, :globalMenu, :localMenu, :pageType, 'none', :sitemap, :published, '1', '0000-00-00 00:00:00', CURRENT_TIMESTAMP, :editable, :deletable, :author, '1'
 		) ON DUPLICATE KEY UPDATE `alias` = :alias, `editable` = :editable, `deletable` = :deletable; ", array(
-			'alias' => $alias,
-			'title' => $title,
-			'content' => $content,
-			'parent' => $parentID,
-			'folder' => $folder,
-			'globalMenu' => $globalMenu,
-			'localMenu' => $localMenu,
-			'pageType' => $page_type,
-			'sitemap' => ($sitemap ? 1 : 0),
-			'published' => ($published ? 1 : 0),
-			'editable' => ($editable ? 1 : 0),
-			'deletable' => ($deletable ? 1 : 0),
-			'author' => $author
-		));
-
-		Cache::clear("pages");
-
-		//return page id
-		$insertID = Database::getInstance()->lastInsertId();
-
-		//throw event
-		Events::throwEvent("created_page", array(
-			'alias' => $alias,
-			'title' => $title,
-			'insertID' => $insertID
-		));
-
-		//get pageID by alias
-		$pageID = Page::getPageIDByAlias($alias);
-
-		//set default rights, allow page for administrators, registered users, guests and bots
-		PageRights::setDefaultAllowedGroups($pageID, array(1, 2, 3, 4));
-
-		return $pageID;
-	}
-
-	public static function delete (string $alias) {
-		$delete = true;
-
-		//plugins can avoid deletion or change alias
-		Events::throwEvent("delete_page_alias", array(
-			'alias' => &$alias,
-			'delete' => &$delete
-		));
-
-		if ($delete) {
-			//remove page from database
-			Database::getInstance()->execute("DELETE FROM `{praefix}pages` WHERE `alias` = :alias; ", array('alias' => $alias));
-
-			Cache::clear("pages");
-		}
-	}
-
-	public static function deleteByID (int $id) {
-		$delete = true;
-
-		//plugins can avoid deletion or change alias
-		Events::throwEvent("delete_page_id", array(
-			'alias' => &$id,
-			'delete' => &$delete
-		));
-
-		if ($delete) {
-			//remove page from database
-			Database::getInstance()->execute("DELETE FROM `{praefix}pages` WHERE `id` = :id; ", array('id' => $id));
-
-			Cache::clear("pages");
-		}
-	}
-
-	public static function get (string $alias) : Page {
-		$page = new Page();
-		$page->load($alias);
-
-		return $page;
-	}
-
-	public static function setPageType (string $alias, string $page_type) {
-		Events::throwEvent("set_pagetype", array(
-			'alias' => &$alias,
-			'page_type' => &$page_type
-		));
-
-		Database::getInstance()->execute("UPDATE `{praefix}pages` SET `page_type` = :page_type WHERE `alias` = :alias; ", array(
-			'alias' => $alias,
-			'page_type' => $page_type
-		));
-
-		Cache::clear("pages");
-	}
-
-	/**
-	 * get id of page by alias
-	 *
-	 * only use this method for database upgrade, because their is no caching for this method!
-	 *
-	 * @param string $alias alias of page
-	 *
-	 * @throws IllegalStateException if alias doesnt exists
-	 *
-	 * @return int pageID
-	 */
-	public static function getPageIDByAlias (string $alias) : int {
-		$row = Database::getInstance()->getRow("SELECT * FROM `{praefix}pages` WHERE `alias` = :alias; ", array('alias' => $alias));
-
-		if (!$row) {
-			throw new IllegalStateException("page with alias '" . $alias . "' doesnt exists.");
-		}
-
-		return $row['id'];
-	}
-
-	public static function lockPage (int $pageID, int $userID) {
-		Database::getInstance()->execute("UPDATE `{praefix}pages` SET `locked_by` = :userID, `locked_timestamp` = CURRENT_TIMESTAMP WHERE `id` = :pageID; ", array(
-			'userID' => $userID,
-			'pageID' => $pageID
-		));
-
-		//clear cache
-		Cache::clear("pages", "pageID_" . $pageID);
-	}
-
-	public static function unlockPage (int $pageID) {
-		Database::getInstance()->execute("UPDATE `{praefix}pages` SET `locked_by` = '-1' WHERE `id` = :pageID; ", array(
-			'pageID' => $pageID
-		));
-
-		//clear cache
-		Cache::clear("pages", "pageID_" . $pageID);
-	}
-
-	protected static function movePageToTrash (int $pageID) {
-		Database::getInstance()->execute("UPDATE `{praefix}pages` SET `activated` = 2 WHERE `id` = :pageID; ", array(
-			'pageID' => $pageID
-		));
-
-		//clear cache
-		Cache::clear("pages", "pageID_" . $pageID);
-	}
-
-	protected static function restorePage (int $pageID) {
-		Database::getInstance()->execute("UPDATE `{praefix}pages` SET `activated` = 1 WHERE `id` = :pageID; ", array(
-			'pageID' => $pageID
-		));
-
-		//clear cache
-		Cache::clear("pages", "pageID_" . $pageID);
-	}
-
-	public static function exists (string $alias) : bool {
-		$row = Database::getInstance()->getRow("SELECT * FROM `{praefix}pages` WHERE `alias` = :alias; ", array(
-			'alias' => $alias
-		));
-
-		return $row !== false;
-	}
+            'alias' => $alias,
+            'title' => $title,
+            'content' => $content,
+            'parent' => $parentID,
+            'folder' => $folder,
+            'globalMenu' => $globalMenu,
+            'localMenu' => $localMenu,
+            'pageType' => $page_type,
+            'sitemap' => ($sitemap ? 1 : 0),
+            'published' => ($published ? 1 : 0),
+            'editable' => ($editable ? 1 : 0),
+            'deletable' => ($deletable ? 1 : 0),
+            'author' => $author
+        ));
+
+        Cache::clear("pages");
+
+        //return page id
+        $insertID = Database::getInstance()->lastInsertId();
+
+        //throw event
+        Events::throwEvent("created_page", array(
+            'alias' => $alias,
+            'title' => $title,
+            'insertID' => $insertID
+        ));
+
+        //get pageID by alias
+        $pageID = Page::getPageIDByAlias($alias);
+
+        //set default rights, allow page for administrators, registered users, guests and bots
+        PageRights::setDefaultAllowedGroups($pageID, array(1, 2, 3, 4));
+
+        return $pageID;
+    }
+
+    public static function delete (string $alias) {
+        $delete = true;
+
+        //plugins can avoid deletion or change alias
+        Events::throwEvent("delete_page_alias", array(
+            'alias' => &$alias,
+            'delete' => &$delete
+        ));
+
+        if ($delete) {
+            //remove page from database
+            Database::getInstance()->execute("DELETE FROM `{praefix}pages` WHERE `alias` = :alias; ", array('alias' => $alias));
+
+            Cache::clear("pages");
+        }
+    }
+
+    public static function deleteByID (int $id) {
+        $delete = true;
+
+        //plugins can avoid deletion or change alias
+        Events::throwEvent("delete_page_id", array(
+            'alias' => &$id,
+            'delete' => &$delete
+        ));
+
+        if ($delete) {
+            //remove page from database
+            Database::getInstance()->execute("DELETE FROM `{praefix}pages` WHERE `id` = :id; ", array('id' => $id));
+
+            Cache::clear("pages");
+        }
+    }
+
+    public static function get (string $alias) : Page {
+        $page = new Page();
+        $page->load($alias);
+
+        return $page;
+    }
+
+    public static function setPageType (string $alias, string $page_type) {
+        Events::throwEvent("set_pagetype", array(
+            'alias' => &$alias,
+            'page_type' => &$page_type
+        ));
+
+        Database::getInstance()->execute("UPDATE `{praefix}pages` SET `page_type` = :page_type WHERE `alias` = :alias; ", array(
+            'alias' => $alias,
+            'page_type' => $page_type
+        ));
+
+        Cache::clear("pages");
+    }
+
+    /**
+     * get id of page by alias
+     *
+     * only use this method for database upgrade, because their is no caching for this method!
+     *
+     * @param string $alias alias of page
+     *
+     * @throws IllegalStateException if alias doesnt exists
+     *
+     * @return int pageID
+     */
+    public static function getPageIDByAlias (string $alias) : int {
+        $row = Database::getInstance()->getRow("SELECT * FROM `{praefix}pages` WHERE `alias` = :alias; ", array('alias' => $alias));
+
+        if (!$row) {
+            throw new IllegalStateException("page with alias '" . $alias . "' doesnt exists.");
+        }
+
+        return $row['id'];
+    }
+
+    public static function lockPage (int $pageID, int $userID) {
+        Database::getInstance()->execute("UPDATE `{praefix}pages` SET `locked_by` = :userID, `locked_timestamp` = CURRENT_TIMESTAMP WHERE `id` = :pageID; ", array(
+            'userID' => $userID,
+            'pageID' => $pageID
+        ));
+
+        //clear cache
+        Cache::clear("pages", "pageID_" . $pageID);
+    }
+
+    public static function unlockPage (int $pageID) {
+        Database::getInstance()->execute("UPDATE `{praefix}pages` SET `locked_by` = '-1' WHERE `id` = :pageID; ", array(
+            'pageID' => $pageID
+        ));
+
+        //clear cache
+        Cache::clear("pages", "pageID_" . $pageID);
+    }
+
+    protected static function movePageToTrash (int $pageID) {
+        Database::getInstance()->execute("UPDATE `{praefix}pages` SET `activated` = 2 WHERE `id` = :pageID; ", array(
+            'pageID' => $pageID
+        ));
+
+        //clear cache
+        Cache::clear("pages", "pageID_" . $pageID);
+    }
+
+    protected static function restorePage (int $pageID) {
+        Database::getInstance()->execute("UPDATE `{praefix}pages` SET `activated` = 1 WHERE `id` = :pageID; ", array(
+            'pageID' => $pageID
+        ));
+
+        //clear cache
+        Cache::clear("pages", "pageID_" . $pageID);
+    }
+
+    public static function exists (string $alias) : bool {
+        $row = Database::getInstance()->getRow("SELECT * FROM `{praefix}pages` WHERE `alias` = :alias; ", array(
+            'alias' => $alias
+        ));
+
+        return $row !== false;
+    }
 
 }
 

system/packages/com.jukusoft.cms.admin/classes/pageeditpage.php

Indentation +253 added lines, -253 removed lines

@@ -27,270 +27,270 @@ 
 
 class PageEditPage extends PageType {
 
-	public function getContent(): string {
-		$template = new DwooTemplate("pages/editpage");
-
-		//check, if pageID is set
-		if (!isset($_REQUEST['edit']) || empty($_REQUEST['edit'])) {
-			//show error
-			return $this->showError("No pageID was set!");
-		}
-
-		$pageID = (int) $_REQUEST['edit'];
-
-		$page = new Page();
-		$page->loadByID($pageID);
-
-		//first check permissions
-		if (!PermissionChecker::current()->hasRight("can_edit_all_pages") && !(PermissionChecker::current()->hasRight("can_edit_own_pages") && $page->getAuthorID() == User::current()->getID())) {
-			//user doesn't have permissions to edit this page
-			return $this->showError("You don't have permissions to edit this page!");
-		}
-
-		//first, lock page
-		Page::lockPage($page->getPageID(), User::current()->getID());
-
-		$success_messages = array();
-		$error_messages = array();
-
-		//save page
-		if (isset($_REQUEST['submit'])) {
-			if ($_REQUEST['submit'] === "Save") {
-				//save page
-				$res = $this->save($page);
-
-				if ($res === true) {
-					$success_messages[] = "Saved page successfully!";
-				} else {
-					$error_messages[] = $res;
-				}
-			} else if ($_REQUEST['submit'] === "SaveUnlock") {
-				//save page
-				$res = $this->save($page);
-
-				if ($res === true) {
-					//unlock page
-					Page::unlockPage($page->getPageID());
-
-					//redirect to admin/pages
-					header("Location: " . DomainUtils::generateURL("admin/pages"));
-
-					ob_flush();
-					ob_end_flush();
-
-					exit;
-				} else {
-					$error_messages[] = $res;
-				}
-			} else if ($_REQUEST['submit'] === "Publish") {
-				//save page
-				$res = $this->save($page);
-
-				if ($res === true) {
-					$success_messages[] = "Saved page successfully!";
-				} else {
-					$error_messages[] = $res;
-				}
-
-				//publish page
-				$res = $this->publish($page);
-
-				if ($res === true) {
-					$success_messages[] = "Page published successfully!";
-				} else {
-					$error_messages[] = $res;
-				}
-			}
-		}
-
-		$template->assign("action_url", DomainUtils::generateURL($this->getPage()->getAlias(), array("edit" => $pageID)));
-
-		$template->assign("page", array(
-			'id' => $page->getPageID(),
-			'alias' => "/" . $page->getAlias(),
-			'title' => $page->getTitle(),
-			'content' => $page->getContent(),
-			'is_published' => $page->isPublished(),
-			'can_publish' => (!$page->isPublished() && (PermissionChecker::current()->hasRight("can_publish_all_pages") || (PermissionChecker::current()->hasRight("can_publish_own_pages") && $page->getAuthorID() == User::current()->getID()))),
-			'can_change_owner' => (PermissionChecker::current()->hasRight("can_change_page_owner") || $page->getAuthorID() == User::current()->getID()),
-			'folder' => $page->getFolder(),
-			'preview_url' => DomainUtils::generateURL($page->getAlias(), array("preview" => "true")),
-			'current_style' => $page->getStyle(),
-			'template' => $page->getCustomTemplate(),
-			'has_custom_template' => $page->hasCustomTemplate(),
-			'parent' => $page->getParentID(),
-			'meta_description' => $page->getMetaDescription(),
-			'meta_keywords' => $page->getMetaKeywords(),
-			'meta_robots' => $page->getMetaRobotsOptions(),
-			'meta_canonicals' => $page->getMetaCanonicals(),
-			'has_canoncials' => !empty($page->getMetaCanonicals()),
-			'sitemap' => $page->isSitemapEnabled(),
-			'sitemap_changefreq' => $page->getSitemapChangeFreq(),
-			'sitemap_priority' => $page->getSitemapPriority()
-		));
-
-		//set available styles
-		$template->assign("styles", StyleController::listAllStyles());
-
-		//get all pages from database
-		$pages = array();
-		$rows = Database::getInstance()->listRows("SELECT `id`, `alias` FROM `{praefix}pages` WHERE `editable` = '1' AND `activated` = '1'; ");
-
-		foreach ($rows as $row) {
-			$pages[] = array(
-				'id' => $row['id'],
-				'alias' => $row['alias']
-			);
-		}
-
-		$template->assign("parent_pages", $pages);
-
-		//https://developers.google.com/search/reference/robots_meta_tag?hl=de
-		$robots_options = array(
-			"all",
-			"noindex",
-			"nofollow",
-			"none",
-			"noarchive",
-			"nosnippet",
-			"noodp",
-			"notranslate",
-			"noimageindex",
-			"unavailable_after: "
-		);
-
-		$template->assign("robots_options", $robots_options);
-
-		$sitemap_change_frequencies = array(
-			"AlWAYS", "HOURLY", "DAILY", "WEEKLY", "MONTHLY", "YEARLY", "NEVER"
-		);
-
-		$template->assign("sitemap_changefreq", $sitemap_change_frequencies);
-
-		//add support to show additional code from plugins
-		$additional_code_header = "";
-		$additional_code_footer = "";
-
-		Events::throwEvent("page_edit_additional_code_header", array(
-			'page' => &$page,
-			'code' => &$additional_code_header
-		));
-
-		$template->assign("additional_code_header", $additional_code_footer);
-
-		Events::throwEvent("page_edit_additional_code_footer", array(
-			'page' => &$page,
-			'code' => &$additional_code_footer
-		));
-
-		$template->assign("additional_code_footer", $additional_code_footer);
-
-		$template->assign("errors", $error_messages);
-		$template->assign("success_messages", $success_messages);
-
-		return $template->getCode();
-	}
-
-	protected function save (Page &$page) {
-		//first check permissions
-		if (!PermissionChecker::current()->hasRight("can_edit_all_pages") && !(PermissionChecker::current()->hasRight("can_edit_own_pages") && $page->getAuthorID() == User::current()->getID())) {
-			//user doesn't have permissions to edit this page
-			return "You don't have permissions to edit this page!";
-		}
-
-		if (!isset($_POST['title']) || empty($_POST['title'])) {
-			return "No title was set";
-		}
-
-		//validate title
-		$title = htmlentities($_POST['title']);
-
-		if (!isset($_POST['html_code']) || empty($_POST['html_code'])) {
-			return "No content was set or content is empty!";
-		}
-
-		$content = $_POST['html_code'];
-
-		//TODO: save page attributes
-		if (!isset($_REQUEST['parent']) || empty($_REQUEST['parent'])) {
-			return "Parent page wasn't set!";
-		}
-
-		$parent = (int) $_REQUEST['parent'];
-
-		if (!isset($_REQUEST['design']) || empty($_REQUEST['design'])) {
-			return "Design wasn't set!";
-		}
-
-		$design = $_REQUEST['design'];
-
-		//TODO: check, if style (design) exists
+    public function getContent(): string {
+        $template = new DwooTemplate("pages/editpage");
+
+        //check, if pageID is set
+        if (!isset($_REQUEST['edit']) || empty($_REQUEST['edit'])) {
+            //show error
+            return $this->showError("No pageID was set!");
+        }
+
+        $pageID = (int) $_REQUEST['edit'];
+
+        $page = new Page();
+        $page->loadByID($pageID);
+
+        //first check permissions
+        if (!PermissionChecker::current()->hasRight("can_edit_all_pages") && !(PermissionChecker::current()->hasRight("can_edit_own_pages") && $page->getAuthorID() == User::current()->getID())) {
+            //user doesn't have permissions to edit this page
+            return $this->showError("You don't have permissions to edit this page!");
+        }
+
+        //first, lock page
+        Page::lockPage($page->getPageID(), User::current()->getID());
+
+        $success_messages = array();
+        $error_messages = array();
+
+        //save page
+        if (isset($_REQUEST['submit'])) {
+            if ($_REQUEST['submit'] === "Save") {
+                //save page
+                $res = $this->save($page);
+
+                if ($res === true) {
+                    $success_messages[] = "Saved page successfully!";
+                } else {
+                    $error_messages[] = $res;
+                }
+            } else if ($_REQUEST['submit'] === "SaveUnlock") {
+                //save page
+                $res = $this->save($page);
+
+                if ($res === true) {
+                    //unlock page
+                    Page::unlockPage($page->getPageID());
+
+                    //redirect to admin/pages
+                    header("Location: " . DomainUtils::generateURL("admin/pages"));
+
+                    ob_flush();
+                    ob_end_flush();
+
+                    exit;
+                } else {
+                    $error_messages[] = $res;
+                }
+            } else if ($_REQUEST['submit'] === "Publish") {
+                //save page
+                $res = $this->save($page);
+
+                if ($res === true) {
+                    $success_messages[] = "Saved page successfully!";
+                } else {
+                    $error_messages[] = $res;
+                }
+
+                //publish page
+                $res = $this->publish($page);
+
+                if ($res === true) {
+                    $success_messages[] = "Page published successfully!";
+                } else {
+                    $error_messages[] = $res;
+                }
+            }
+        }
+
+        $template->assign("action_url", DomainUtils::generateURL($this->getPage()->getAlias(), array("edit" => $pageID)));
+
+        $template->assign("page", array(
+            'id' => $page->getPageID(),
+            'alias' => "/" . $page->getAlias(),
+            'title' => $page->getTitle(),
+            'content' => $page->getContent(),
+            'is_published' => $page->isPublished(),
+            'can_publish' => (!$page->isPublished() && (PermissionChecker::current()->hasRight("can_publish_all_pages") || (PermissionChecker::current()->hasRight("can_publish_own_pages") && $page->getAuthorID() == User::current()->getID()))),
+            'can_change_owner' => (PermissionChecker::current()->hasRight("can_change_page_owner") || $page->getAuthorID() == User::current()->getID()),
+            'folder' => $page->getFolder(),
+            'preview_url' => DomainUtils::generateURL($page->getAlias(), array("preview" => "true")),
+            'current_style' => $page->getStyle(),
+            'template' => $page->getCustomTemplate(),
+            'has_custom_template' => $page->hasCustomTemplate(),
+            'parent' => $page->getParentID(),
+            'meta_description' => $page->getMetaDescription(),
+            'meta_keywords' => $page->getMetaKeywords(),
+            'meta_robots' => $page->getMetaRobotsOptions(),
+            'meta_canonicals' => $page->getMetaCanonicals(),
+            'has_canoncials' => !empty($page->getMetaCanonicals()),
+            'sitemap' => $page->isSitemapEnabled(),
+            'sitemap_changefreq' => $page->getSitemapChangeFreq(),
+            'sitemap_priority' => $page->getSitemapPriority()
+        ));
+
+        //set available styles
+        $template->assign("styles", StyleController::listAllStyles());
+
+        //get all pages from database
+        $pages = array();
+        $rows = Database::getInstance()->listRows("SELECT `id`, `alias` FROM `{praefix}pages` WHERE `editable` = '1' AND `activated` = '1'; ");
+
+        foreach ($rows as $row) {
+            $pages[] = array(
+                'id' => $row['id'],
+                'alias' => $row['alias']
+            );
+        }
+
+        $template->assign("parent_pages", $pages);
+
+        //https://developers.google.com/search/reference/robots_meta_tag?hl=de
+        $robots_options = array(
+            "all",
+            "noindex",
+            "nofollow",
+            "none",
+            "noarchive",
+            "nosnippet",
+            "noodp",
+            "notranslate",
+            "noimageindex",
+            "unavailable_after: "
+        );
+
+        $template->assign("robots_options", $robots_options);
+
+        $sitemap_change_frequencies = array(
+            "AlWAYS", "HOURLY", "DAILY", "WEEKLY", "MONTHLY", "YEARLY", "NEVER"
+        );
+
+        $template->assign("sitemap_changefreq", $sitemap_change_frequencies);
+
+        //add support to show additional code from plugins
+        $additional_code_header = "";
+        $additional_code_footer = "";
+
+        Events::throwEvent("page_edit_additional_code_header", array(
+            'page' => &$page,
+            'code' => &$additional_code_header
+        ));
+
+        $template->assign("additional_code_header", $additional_code_footer);
+
+        Events::throwEvent("page_edit_additional_code_footer", array(
+            'page' => &$page,
+            'code' => &$additional_code_footer
+        ));
+
+        $template->assign("additional_code_footer", $additional_code_footer);
+
+        $template->assign("errors", $error_messages);
+        $template->assign("success_messages", $success_messages);
+
+        return $template->getCode();
+    }
+
+    protected function save (Page &$page) {
+        //first check permissions
+        if (!PermissionChecker::current()->hasRight("can_edit_all_pages") && !(PermissionChecker::current()->hasRight("can_edit_own_pages") && $page->getAuthorID() == User::current()->getID())) {
+            //user doesn't have permissions to edit this page
+            return "You don't have permissions to edit this page!";
+        }
+
+        if (!isset($_POST['title']) || empty($_POST['title'])) {
+            return "No title was set";
+        }
+
+        //validate title
+        $title = htmlentities($_POST['title']);
+
+        if (!isset($_POST['html_code']) || empty($_POST['html_code'])) {
+            return "No content was set or content is empty!";
+        }
+
+        $content = $_POST['html_code'];
+
+        //TODO: save page attributes
+        if (!isset($_REQUEST['parent']) || empty($_REQUEST['parent'])) {
+            return "Parent page wasn't set!";
+        }
+
+        $parent = (int) $_REQUEST['parent'];
+
+        if (!isset($_REQUEST['design']) || empty($_REQUEST['design'])) {
+            return "Design wasn't set!";
+        }
+
+        $design = $_REQUEST['design'];
+
+        //TODO: check, if style (design) exists
 
-		$template = "none";
+        $template = "none";
 
-		if (isset($_REQUEST['has_custom_template']) && isset($_REQUEST['template']) && !empty($_REQUEST['template'])) {
-			$template = $_REQUEST['template'];
-		}
+        if (isset($_REQUEST['has_custom_template']) && isset($_REQUEST['template']) && !empty($_REQUEST['template'])) {
+            $template = $_REQUEST['template'];
+        }
 
-		//update page in database
-		Database::getInstance()->execute("UPDATE `{praefix}pages` SET `title` = :title, `content` = :content, `parent` = :parent, `design` = :design, `template` = :template WHERE `id` = :pageID; ", array(
-			'title' => $title,
-			'content' => $content,
-			'pageID' => $page->getPageID(),
-			'parent' => $parent,
-			'design' => $design,
-			'template' => $template
-		));
+        //update page in database
+        Database::getInstance()->execute("UPDATE `{praefix}pages` SET `title` = :title, `content` = :content, `parent` = :parent, `design` = :design, `template` = :template WHERE `id` = :pageID; ", array(
+            'title' => $title,
+            'content' => $content,
+            'pageID' => $page->getPageID(),
+            'parent' => $parent,
+            'design' => $design,
+            'template' => $template
+        ));
 
-		//clear cache
-		$page->clearCache();
+        //clear cache
+        $page->clearCache();
 
-		//reload page from database
-		$page->loadByID($page->getPageID(), false);
+        //reload page from database
+        $page->loadByID($page->getPageID(), false);
 
-		//TODO: remove this line later
-		Cache::clear("pages");
+        //TODO: remove this line later
+        Cache::clear("pages");
 
-		return true;
-	}
+        return true;
+    }
 
-	protected function publish (Page &$page) {
-		//check permissions for publishing
-		if (PermissionChecker::current()->hasRight("can_publish_all_pages") || (PermissionChecker::current()->hasRight("can_publish_own_pages") && $page->getAuthorID() == User::current()->getID())) {
-			//update page in database
-			Database::getInstance()->execute("UPDATE `{praefix}pages` SET `published` = '1' WHERE `id` = :pageID; ", array(
-				'pageID' => $page->getPageID()
-			));
+    protected function publish (Page &$page) {
+        //check permissions for publishing
+        if (PermissionChecker::current()->hasRight("can_publish_all_pages") || (PermissionChecker::current()->hasRight("can_publish_own_pages") && $page->getAuthorID() == User::current()->getID())) {
+            //update page in database
+            Database::getInstance()->execute("UPDATE `{praefix}pages` SET `published` = '1' WHERE `id` = :pageID; ", array(
+                'pageID' => $page->getPageID()
+            ));
 
-			//clear cache
-			$page->clearCache();
+            //clear cache
+            $page->clearCache();
 
-			//reload page from database
-			$page->loadByID($page->getPageID(), false);
+            //reload page from database
+            $page->loadByID($page->getPageID(), false);
 
-			//TODO: remove this line later
-			Cache::clear("pages");
+            //TODO: remove this line later
+            Cache::clear("pages");
 
-			return true;
-		} else {
-			return "You don't have the permissions to publish this page!";
-		}
-	}
+            return true;
+        } else {
+            return "You don't have the permissions to publish this page!";
+        }
+    }
 
-	protected function showError (string $message) : string {
-		//show error
-		$template = new DwooTemplate("pages/error");
-		$template->assign("message", "No pageID was set!");
-		return $template->getCode();
-	}
+    protected function showError (string $message) : string {
+        //show error
+        $template = new DwooTemplate("pages/error");
+        $template->assign("message", "No pageID was set!");
+        return $template->getCode();
+    }
 
-	public function getFooterScripts(): string {
-		$style_name = Registry::singleton()->getSetting("current_style_name");
-		$style_path = DomainUtils::getBaseURL() . "/styles/" . $style_name . "/";
+    public function getFooterScripts(): string {
+        $style_name = Registry::singleton()->getSetting("current_style_name");
+        $style_path = DomainUtils::getBaseURL() . "/styles/" . $style_name . "/";
 
-		$thirdparty_url = Registry::singleton()->getSetting("thirdparty_url");
+        $thirdparty_url = Registry::singleton()->getSetting("thirdparty_url");
 
-		/*return "<!-- CK Editor -->
+        /*return "<!-- CK Editor -->
 			<script src=\"" . $style_path . "bower_components/ckeditor/ckeditor.js\"></script>
 			
 			<script>
@@ -304,7 +304,7 @@ 
 				});
 			</script>";*/
 
-		return "<script src=\"" . $thirdparty_url . "tinymce_4.8.2/js/tinymce/tinymce.min.js\"></script>
+        return "<script src=\"" . $thirdparty_url . "tinymce_4.8.2/js/tinymce/tinymce.min.js\"></script>
   				<script>tinymce.init({
 					  selector: 'textarea',
 					  height: 500,
@@ -331,11 +331,11 @@ 
 					}
 				};
 				</script>";
-	}
+    }
 
-	public function listRequiredPermissions(): array {
-		return array("can_edit_all_pages", "can_edit_own_pages");
-	}
+    public function listRequiredPermissions(): array {
+        return array("can_edit_all_pages", "can_edit_own_pages");
+    }
 
 }