Charcoal\Admin\Widget\Search\NoResultsSearchWidget

Complexity

Total Complexity

1

Size/Duplication

Total Lines	44
Duplicated Lines	100 %

Coupling/Cohesion

Components	0
Dependencies	1

Importance

Changes	1
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
B	loadSearchHistory()	36	36	1

<?php

namespace Charcoal\Admin\Widget\Search;

use \PDO;

use \Charcoal\Search\SearchLog;

/**
 * Search widget to show the latest searched-for terms that produced no results.
 */
class NoResultsSearchWidget extends AbstractSearchHistoryWidget

This class seems to be duplicated in your project.

{
    /**
     * Load the top searches, from the source, that produced no results.
     *
     * @return SearchLog[]
     */
    public function loadSearchHistory()
    {
        $proto  = $this->modelFactory()->get(SearchLog::class);
        $source = $proto->source();
        $table  = $source->table();

        $q = '
        SELECT
            `keyword`,
            COUNT(`keyword`) as num_searches,
            SUM(`num_results`) as num_results
        FROM
            `'.$table.'`
        WHERE
            `num_results` = 0
        AND
            `ts` > :start
        AND
            `ts` <= :end
        GROUP BY
            `keyword`
        ORDER BY
            num_searches DESC
        LIMIT
            20
        ';

        $sth = $source->dbQuery($q, [
            'start' => $this->startDate()->format('Y-m-d H:i:s'),
            'end'   => $this->endDate()->format('Y-m-d H:i:s')
        ]);

        $results = $sth->fetchAll(PDO::FETCH_ASSOC);

        return $results;
    }
}