From 52b077a48c743ba4d08ac00520a0bf1ef6deef5f Mon Sep 17 00:00:00 2001 From: Thomas Lange Date: Fri, 24 Feb 2017 21:27:59 +0100 Subject: Initial commit. --- core/namespace/Item.php | 150 ++++++++++++++++++++++++++++++++++++++++++++++++ 1 file changed, 150 insertions(+) create mode 100644 core/namespace/Item.php (limited to 'core/namespace/Item.php') diff --git a/core/namespace/Item.php b/core/namespace/Item.php new file mode 100644 index 0000000..6d17011 --- /dev/null +++ b/core/namespace/Item.php @@ -0,0 +1,150 @@ +Database = $Database; + + $this->Reflection = new ReflectionObject($this); + + $attribute = "{$this->Reflection->getNamespaceName()}\\Attribute"; + $exception = "{$this->Reflection->getNamespaceName()}\\Exception"; + + #=============================================================================== + # Checking if item in database exists + #=============================================================================== + $Statement = $Database->prepare(sprintf('SELECT * FROM %s WHERE id = ?', $attribute::TABLE)); + $Statement->execute([$itemID]); + + #=============================================================================== + # Checking if retrieving data failed + #=============================================================================== + if(!$this->Attribute = $Statement->fetchObject($attribute)) { + throw new $exception(sprintf('%s\\Item with ID %s does not exists', $this->Reflection->getNamespaceName(), (int) $itemID)); + } + } + + #=============================================================================== + # Return attribute by name (short hand wrapper) + #=============================================================================== + public function attr($attribute) { + return $this->Attribute->get($attribute); + } + + #=============================================================================== + # Return Attribute object + #=============================================================================== + public final function getAttribute(): Attribute { + return $this->Attribute; + } + + #=============================================================================== + # Return unique ID + #=============================================================================== + public final function getID(): int { + return $this->Attribute->get('id'); + } + + #=============================================================================== + # Return pre-parsed content + #=============================================================================== + public function getBody(): string { + $content = preg_replace_callback('#\{(POST|PAGE|USER)\[([0-9]+)\]\}#', function($matches) { + $namespace = ucfirst(strtolower($matches[1])).'\\Factory'; + + try { + $Item = $namespace::build($matches[2]); + return $Item->getURL(); + } catch(Exception $Exception) { + return '{undefined}'; + } + }, $this->Attribute->get('body')); + + $content = preg_replace('#\{BASE\[\"([^"]+)\"\]\}#', \Application::getURL('$1'), $content); + $content = preg_replace('#\{FILE\[\"([^"]+)\"\]\}#', \Application::getFileURL('$1'), $content); + + return $content; + } + + #=============================================================================== + # Return parsed content + #=============================================================================== + public function getHTML(): string { + $item = "{$this->Reflection->getNamespaceName()}\\Item"; + + $Parsedown = new Parsedown(); + $content = $this->getBody(); + + if(\Application::get($item::CONFIGURATION.'.EMOTICONS') === TRUE) { + $content = parseEmoticons($content); + } + + return $Parsedown->text($content); + } + + #=============================================================================== + # Return attached files + #=============================================================================== + public function getFiles(): array { + if(preg_match_all('#\!\[(.*)\][ ]?(?:\n[ ]*)?\((.*)(\s[\'"](.*)[\'"])?\)#U', $this->getBody(), $matches)) { + return array_map('htmlentities', $matches[2]); + } + + return []; + } + + #=============================================================================== + # Return previous item ID + #=============================================================================== + public function getPrevID(): int { + $execute = 'SELECT id FROM %s WHERE DATE(time_insert) <= DATE(?) AND id < ? ORDER BY time_insert DESC, id DESC LIMIT 1'; + + $attribute = "{$this->Reflection->getNamespaceName()}\\Attribute"; + $Statement = $this->Database->prepare(sprintf($execute, $attribute::TABLE)); + + if($Statement->execute([$this->Attribute->get('time_insert'), $this->Attribute->get('id')])) { + return $Statement->fetchColumn(); + } + + return 0; + } + + #=============================================================================== + # Return next item ID + #=============================================================================== + public function getNextID(): int { + $execute = 'SELECT id FROM %s WHERE DATE(time_insert) >= DATE(?) AND id > ? ORDER BY time_insert ASC, id DESC LIMIT 1'; + + $attribute = "{$this->Reflection->getNamespaceName()}\\Attribute"; + $Statement = $this->Database->prepare(sprintf($execute, $attribute::TABLE)); + + if($Statement->execute([$this->Attribute->get('time_insert'), $this->Attribute->get('id')])) { + return $Statement->fetchColumn(); + } + + return 0; + } + + #=============================================================================== + # Return unique ID based on specific field comparison with value + #=============================================================================== + public static function getIDByField($field, $value, \Database $Database): int { + $attribute = (new ReflectionClass(get_called_class()))->getNamespaceName().'\\Attribute'; + $Statement = $Database->prepare('SELECT id FROM '.$attribute::TABLE." WHERE {$field} = ?"); + + if($Statement->execute([$value])) { + return $Statement->fetchColumn(); + } + + return 0; + } +} +?> \ No newline at end of file -- cgit v1.2.3