Add method "getSearchResults" to Page and Post class

1 files changed, 21 insertions, 0 deletions

diff --git a/core/namespace/Post/Item.php b/core/namespace/Post/Item.php
index d5b7f2e..71d8014 100644
--- a/core/namespace/Post/Item.php
+++ b/core/namespace/Post/Item.php
@@ -48,6 +48,27 @@ class Item extends \Item {
 	}
 
 	#===============================================================================
+	# Return search results as Post\Attribute
+	#===============================================================================
+	public static function getSearchResults($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 * 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_CLASS, 'Post\Attribute');
+		}
+
+		return [];
+	}
+
+	#===============================================================================
 	# Return associated User\Attribute
 	#===============================================================================
 	public function getUserAttribute() {