diff options
| author | Thomas Lange <code@nerdmind.de> | 2018-04-01 17:10:21 +0200 |
|---|---|---|
| committer | Thomas Lange <code@nerdmind.de> | 2018-04-01 17:10:21 +0200 |
| commit | ea29b80ec2942f7e0390e3bb98c37ac6c4c5686d (patch) | |
| tree | 4282b90a6a2c2f9a1083bcffbd7c6b3dd5d5f031 | |
| parent | 36965226acd25178ce3d28633aadc1749f85b9f2 (diff) | |
| download | blog-ea29b80ec2942f7e0390e3bb98c37ac6c4c5686d.tar.gz blog-ea29b80ec2942f7e0390e3bb98c37ac6c4c5686d.tar.xz blog-ea29b80ec2942f7e0390e3bb98c37ac6c4c5686d.zip | |
Remove unused method "getSearchResultIDs" from Page and Post class
| -rw-r--r-- | core/namespace/Page/Item.php | 14 | ||||
| -rw-r--r-- | core/namespace/Post/Item.php | 21 |
2 files changed, 0 insertions, 35 deletions
diff --git a/core/namespace/Page/Item.php b/core/namespace/Page/Item.php index cd2c94f..563602a 100644 --- a/core/namespace/Page/Item.php +++ b/core/namespace/Page/Item.php @@ -27,20 +27,6 @@ class Item extends \Item { } #=============================================================================== - # Return unique page IDs for search results - #=============================================================================== - public static function getSearchResultIDs($search, \Database $Database): array { - $Statement = $Database->prepare(sprintf("SELECT id FROM %s WHERE - MATCH(name, body) AGAINST(? IN BOOLEAN MODE) LIMIT 20", Attribute::TABLE)); - - if($Statement->execute([$search])) { - return $Statement->fetchAll($Database::FETCH_COLUMN); - } - - return []; - } - - #=============================================================================== # Return search results as Page\Attribute #=============================================================================== public static function getSearchResults($search, \Database $Database): array { diff --git a/core/namespace/Post/Item.php b/core/namespace/Post/Item.php index 71d8014..84b5f43 100644 --- a/core/namespace/Post/Item.php +++ b/core/namespace/Post/Item.php @@ -27,27 +27,6 @@ class Item extends \Item { } #=============================================================================== - # 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 []; - } - - #=============================================================================== # Return search results as Post\Attribute #=============================================================================== public static function getSearchResults($search, array $date, \Database $Database): array { |