diff options
author | Thomas Lange <code@nerdmind.de> | 2017-02-24 21:27:59 +0100 |
---|---|---|
committer | Thomas Lange <code@nerdmind.de> | 2017-02-24 21:27:59 +0100 |
commit | 52b077a48c743ba4d08ac00520a0bf1ef6deef5f (patch) | |
tree | b4205c194167e0e03e273957cdd0aab3be9fdf01 /core/namespace/Post/Item.php | |
download | blog-1.0.tar.gz blog-1.0.tar.xz blog-1.0.zip |
Initial commit.v1.0
Diffstat (limited to 'core/namespace/Post/Item.php')
-rw-r--r-- | core/namespace/Post/Item.php | 50 |
1 files changed, 50 insertions, 0 deletions
diff --git a/core/namespace/Post/Item.php b/core/namespace/Post/Item.php new file mode 100644 index 0000000..a269ce4 --- /dev/null +++ b/core/namespace/Post/Item.php @@ -0,0 +1,50 @@ +<?php +namespace Post; + +class Item extends \Item { + const CONFIGURATION = 'POST'; + + #=============================================================================== + # Return absolute post URL + #=============================================================================== + public function getURL(): string { + if(\Application::get('POST.SLUG_URLS')) { + return \Application::getPostURL("{$this->Attribute->get('slug')}/"); + } + + return \Application::getPostURL("{$this->Attribute->get('id')}/"); + } + + #=============================================================================== + # Return unique pseudo GUID + #=============================================================================== + public function getGUID(): string { + foreach(\Application::get('POST.FEED_GUID') as $attribute) { + $attributes[] = $this->Attribute->get($attribute); + } + + return sha1(implode(NULL, $attributes)); + } + + #=============================================================================== + # Return unique post IDs for search results + #=============================================================================== + public static function getSearchResultIDs($search, array $date, \Database $Database): array { + $D = ($D = intval($date[0])) !== 0 ? $D : 'NULL'; + $M = ($M = intval($date[1])) !== 0 ? $M : 'NULL'; + $Y = ($Y = intval($date[2])) !== 0 ? $Y : 'NULL'; + + $Statement = $Database->prepare(sprintf("SELECT id FROM %s WHERE + ({$Y} IS NULL OR YEAR(time_insert) = {$Y}) AND + ({$M} IS NULL OR MONTH(time_insert) = {$M}) AND + ({$D} IS NULL OR DAY(time_insert) = {$D}) AND + MATCH(name, body) AGAINST(? IN BOOLEAN MODE) LIMIT 20", Attribute::TABLE)); + + if($Statement->execute([$search])) { + return $Statement->fetchAll($Database::FETCH_COLUMN); + } + + return []; + } +} +?>
\ No newline at end of file |