diff options
-rw-r--r-- | core/namespace/ORM/Repositories/PageRepository.php | 3 | ||||
-rw-r--r-- | core/namespace/ORM/Repositories/PostRepository.php | 3 | ||||
-rw-r--r-- | core/namespace/ORM/Repository.php | 99 | ||||
-rw-r--r-- | core/namespace/ORM/RepositorySearch.php | 103 |
4 files changed, 109 insertions, 99 deletions
diff --git a/core/namespace/ORM/Repositories/PageRepository.php b/core/namespace/ORM/Repositories/PageRepository.php index 8c7c94b..993fb67 100644 --- a/core/namespace/ORM/Repositories/PageRepository.php +++ b/core/namespace/ORM/Repositories/PageRepository.php @@ -1,8 +1,11 @@ <?php namespace ORM\Repositories; use ORM\Repository; +use ORM\RepositorySearch; class PageRepository extends Repository { + use RepositorySearch; + public static function getTableName(): string { return 'page'; } public static function getClassName(): string { return 'ORM\Entities\Page'; } } diff --git a/core/namespace/ORM/Repositories/PostRepository.php b/core/namespace/ORM/Repositories/PostRepository.php index 400d596..24ab47f 100644 --- a/core/namespace/ORM/Repositories/PostRepository.php +++ b/core/namespace/ORM/Repositories/PostRepository.php @@ -1,8 +1,11 @@ <?php namespace ORM\Repositories; use ORM\Repository; +use ORM\RepositorySearch; class PostRepository extends Repository { + use RepositorySearch; + public static function getTableName(): string { return 'post'; } public static function getClassName(): string { return 'ORM\Entities\Post'; } } diff --git a/core/namespace/ORM/Repository.php b/core/namespace/ORM/Repository.php index 44bd62e..423a286 100644 --- a/core/namespace/ORM/Repository.php +++ b/core/namespace/ORM/Repository.php @@ -7,9 +7,6 @@ abstract class Repository { protected $Database; protected $entities = []; - # See "search" method for more details. - private $lastSearchOverallCount = 0; - abstract public static function getTableName(): string; abstract public static function getClassName(): string; @@ -260,100 +257,4 @@ abstract class Repository { return $this->fetchEntities($Statement); } - - #=============================================================================== - # Get entities based on search query - #=============================================================================== - public function search(string $search, array $filter = [], int $limit = NULL, int $offset = 0): array { - if(strlen($filter['year'] ?? '') !== 0) { - $extend[] = 'YEAR(time_insert) = ? AND'; - $params[] = $filter['year']; - } - - if(strlen($filter['month'] ?? '') !== 0) { - $extend[] = 'MONTH(time_insert) = ? AND'; - $params[] = $filter['month']; - } - - if(strlen($filter['day'] ?? '') !== 0) { - $extend[] = 'DAY(time_insert) = ? AND'; - $params[] = $filter['day']; - } - - if($limit) { - $limit = "LIMIT $offset,$limit"; - } - - $dateparts = implode(' ', $extend ?? []); - - $query = 'SELECT *, COUNT(*) OVER() AS _count FROM %s WHERE %s MATCH(name, body) - AGAINST(? IN BOOLEAN MODE) %s'; - $query = sprintf($query, static::getTableName(), $dateparts, $limit ?? 'LIMIT 20'); - - $Statement = $this->Database->prepare($query); - $Statement->execute(array_merge($params ?? [], [$search])); - - if($entities = $this->fetchEntities($Statement)) { - # Temporary (maybe crappy) solution to prevent a second count query. - # Virtual column "_count" does not belong into the entities. - $this->lastSearchOverallCount = $entities[0]->get('_count'); - } - - return $entities; - } - - #=============================================================================== - # Get the number of overall results for the last performed search - #=============================================================================== - public function getLastSearchOverallCount(): int { - return $this->lastSearchOverallCount; - } - - #=============================================================================== - # Get a list of distinct days - #=============================================================================== - public function getDistinctDays(): array { - $query = 'SELECT DISTINCT DAY(time_insert) AS d FROM %s ORDER BY d'; - $query = sprintf($query, static::getTableName()); - - $Statement = $this->Database->query($query); - - if($result = $Statement->fetchAll($this->Database::FETCH_COLUMN)) { - return $result; - } - - return []; - } - - #=============================================================================== - # Get a list of distinct months - #=============================================================================== - public function getDistinctMonths(): array { - $query = 'SELECT DISTINCT MONTH(time_insert) AS m FROM %s ORDER BY m'; - $query = sprintf($query, static::getTableName()); - - $Statement = $this->Database->query($query); - - if($result = $Statement->fetchAll($this->Database::FETCH_COLUMN)) { - return $result; - } - - return []; - } - - #=============================================================================== - # Get a list of distinct years - #=============================================================================== - public function getDistinctYears(): array { - $query = 'SELECT DISTINCT YEAR(time_insert) AS y FROM %s ORDER BY y'; - $query = sprintf($query, static::getTableName()); - - $Statement = $this->Database->query($query); - - if($result = $Statement->fetchAll($this->Database::FETCH_COLUMN)) { - return $result; - } - - return []; - } } diff --git a/core/namespace/ORM/RepositorySearch.php b/core/namespace/ORM/RepositorySearch.php new file mode 100644 index 0000000..8a61998 --- /dev/null +++ b/core/namespace/ORM/RepositorySearch.php @@ -0,0 +1,103 @@ +<?php +namespace ORM; + +trait RepositorySearch { + # See "search" method for more details. + private $lastSearchOverallCount = 0; + + #=============================================================================== + # Get entities based on search query + #=============================================================================== + public function search(string $search, array $filter = [], int $limit = NULL, int $offset = 0): array { + if(strlen($filter['year'] ?? '') !== 0) { + $extend[] = 'YEAR(time_insert) = ? AND'; + $params[] = $filter['year']; + } + + if(strlen($filter['month'] ?? '') !== 0) { + $extend[] = 'MONTH(time_insert) = ? AND'; + $params[] = $filter['month']; + } + + if(strlen($filter['day'] ?? '') !== 0) { + $extend[] = 'DAY(time_insert) = ? AND'; + $params[] = $filter['day']; + } + + if($limit) { + $limit = "LIMIT $offset,$limit"; + } + + $dateparts = implode(' ', $extend ?? []); + + $query = 'SELECT *, COUNT(*) OVER() AS _count FROM %s WHERE %s MATCH(name, body) + AGAINST(? IN BOOLEAN MODE) %s'; + $query = sprintf($query, static::getTableName(), $dateparts, $limit ?? 'LIMIT 20'); + + $Statement = $this->Database->prepare($query); + $Statement->execute(array_merge($params ?? [], [$search])); + + if($entities = $this->fetchEntities($Statement)) { + # Temporary (maybe crappy) solution to prevent a second count query. + # Virtual column "_count" does not belong into the entities. + $this->lastSearchOverallCount = $entities[0]->get('_count'); + } + + return $entities; + } + + #=============================================================================== + # Get the number of overall results for the last performed search + #=============================================================================== + public function getLastSearchOverallCount(): int { + return $this->lastSearchOverallCount; + } + + #=============================================================================== + # Get a list of distinct days + #=============================================================================== + public function getDistinctDays(): array { + $query = 'SELECT DISTINCT DAY(time_insert) AS d FROM %s ORDER BY d'; + $query = sprintf($query, static::getTableName()); + + $Statement = $this->Database->query($query); + + if($result = $Statement->fetchAll($this->Database::FETCH_COLUMN)) { + return $result; + } + + return []; + } + + #=============================================================================== + # Get a list of distinct months + #=============================================================================== + public function getDistinctMonths(): array { + $query = 'SELECT DISTINCT MONTH(time_insert) AS m FROM %s ORDER BY m'; + $query = sprintf($query, static::getTableName()); + + $Statement = $this->Database->query($query); + + if($result = $Statement->fetchAll($this->Database::FETCH_COLUMN)) { + return $result; + } + + return []; + } + + #=============================================================================== + # Get a list of distinct years + #=============================================================================== + public function getDistinctYears(): array { + $query = 'SELECT DISTINCT YEAR(time_insert) AS y FROM %s ORDER BY y'; + $query = sprintf($query, static::getTableName()); + + $Statement = $this->Database->query($query); + + if($result = $Statement->fetchAll($this->Database::FETCH_COLUMN)) { + return $result; + } + + return []; + } +} |