SearchTermsReport

Complexity

Total Complexity

2

Size/Duplication

Total Lines	34
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Test Coverage

Coverage

0%

Importance

Changes	2
Bugs	0	Features	1

2 Methods

Rating	Name	Duplication	Size	Complexity
A	columns()	0	12	1
A	query()	0	13	1

<?php
/**
 * Silverstripe report for searchs
 *
 * @author Mark Guinn <mark@adaircreative.com>
 * @date 09.24.2014
 * @package apluswhs.com
 * @subpackage
 */
class SearchTermsReport extends ShopPeriodReport

PSR1 recommends that each class must be in a namespace of at least one level to avoid collisions.

{
    protected $title = "Search Terms";
    protected $description = "Understand what users are searching for.";
    protected $dataClass = "SearchLog";
    protected $periodfield = "SearchLog.Created";

    public function columns()
    {
        return array(
            "Query" => array(
                "title" => "Query",
                "formatting" => '<a href=\"home/SearchForm?q=$ATT_val($Query)\" target=\"_new\">$Query</a>'
            ),
            'NumResults' => 'Results',
            'Quantity' => 'Searches',
            'MostRecent' => 'Most Recent',
        );
    }

    public function query($params)
    {
        $query = parent::query($params);
        $query->selectField($this->periodfield, "FilterPeriod")
            ->addSelect("SearchLog.Query")
            ->selectField("Count(SearchLog.ID)", "Quantity")
            ->selectField("Max(SearchLog.Created)", "MostRecent")
            ->selectField("Max(SearchLog.NumResults)", "NumResults");
        $query->addGroupby("SearchLog.Query");
        $query->addWhere("\"SearchLog\".\"Filters\" is null AND \"SearchLog\".\"ParentSearchID\" = '0'");
        $query->setOrderBy("Quantity", "DESC");
        return $query;
    }
}