GeminiLabs\SiteReviews\Database\Search\SearchPosts

Complexity

Total Complexity

6

Size/Duplication

Total Lines	75
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

5 Methods

Rating	Name	Duplication	Size	Complexity
A	postTypes()	0	4	1
A	searchById()	0	12	1
A	posts()	0	7	2
A	searchByTerm()	0	15	1
A	render()	0	7	1

<?php

namespace GeminiLabs\SiteReviews\Database\Search;

use GeminiLabs\SiteReviews\Database;
use GeminiLabs\SiteReviews\Database\Query;
use GeminiLabs\SiteReviews\Helpers\Str;

class SearchPosts extends AbstractSearch
{
    /**
     * @return array
     */
    public function posts()
    {
        $posts = [];
        foreach ($this->results as $result) {
            $posts[] = get_post($result->id);
        }
        return $posts;
    }

    /**
     * @return string
     */
    public function render()
    {
        return array_reduce($this->posts(), function ($carry, $post) {
            return $carry.glsr()->build('partials/editor/search-result', [
                'ID' => $post->ID,
                'permalink' => esc_url((string) get_permalink($post->ID)),
                'title' => esc_attr(get_the_title($post->ID)),
            ]);
        });
    }

    /**
     * @return string
     */
    protected function postTypes()
    {
        $types = array_keys(get_post_types(['exclude_from_search' => false]));
        return Str::join($types, true);
    }

    /**
     * @param int $searchId
     * @return array
     */
    protected function searchById($searchId)
    {
        $sql = $this->db->prepare("
            SELECT p.ID AS id, p.post_title AS name
            FROM {$this->db->posts} AS p
            WHERE 1=1
            AND p.ID = %d
            AND p.post_type IN ({$this->postTypes()})
            AND p.post_status = 'publish'
        ", $searchId);
        return glsr(Database::class)->dbGetResults(
            glsr(Query::class)->sql($sql)
        );
    }

    /**
     * @param string $searchTerm
     * @return array
     */
    protected function searchByTerm($searchTerm)
    {
        $like = '%'.$this->db->esc_like($searchTerm).'%';
        $sql = $this->db->prepare("
            SELECT p.ID AS id, p.post_title AS name
            FROM {$this->db->posts} AS p
            WHERE 1=1
            AND p.post_title LIKE %s
            AND p.post_type IN ({$this->postTypes()})
            AND p.post_status = 'publish'
            ORDER BY p.post_title LIKE %s DESC, p.post_date DESC
            LIMIT 0, 20
        ", $like, $like);
        return glsr(Database::class)->dbGetResults(
            glsr(Query::class)->sql($sql)
        );
    }
}