Charcoal\Admin\Widget\Search\NoResultsSearchWidget::loadSearchHistory()

Complexity

Conditions	1
Paths	1

Size

Total Lines	36
Code Lines	11

Duplication

Lines	36
Ratio	100 %

Importance

Changes

0

<?php
    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;
    }
}