UESPWiki:SearchLog/SpecialSearchLog.php

<?php
class SpecialSearchLog extends SpecialPage {

        public $pageurl;
        public $sortkey;
        public $maxrows;
        public $summary;
        public $empty;

        function __construct() {
                parent::__construct( 'SearchLog' );
                wfLoadExtensionMessages('SearchLog');

                        # TODO: Proper URL of this page
                $this->pageurl = "/wiki/Special:SearchLog";
                $this->sortkey = "none";
                $this->maxrows = 1000;
                $this->summary = 0;
                $this->empty   = 0;
        }

        function execute( $par ) {
                global $wgRequest, $wgOut, $wgUser;

                $this->setHeaders();

                if ( !$wgUser->isAllowed( 'patrol' ) )
                {
                        $wgOut->permissionRequired( 'patrol' );
                        return;
                }

                $this->showHeader();

                $this->summary = $wgRequest->getText('summary');
                $this->sortkey = $wgRequest->getText('sort');
                $this->empty   = $wgRequest->getText('empty');

                if ($this->summary)
                        $this->showSummary();
                else
                        $this->showLog();
        }

        function makePageLink ($var, $value)
        {
                $pagelink = $this->pageurl . '?';

                if ( $var != 'summary' )
                        $pagelink .= 'summary='. $this->summary .'&';
                else
                        $pagelink .= $var .'='. $value .'&';

                if ( $var != 'sort' )
                        $pagelink .= 'sort='. $this->sortkey .'&';
                else
                        $pagelink .= $var .'='. $value .'&';

                if ( $var != 'empty' )
                        $pagelink .= 'empty='. $this->empty .'&';
                else
                        $pagelink .= $var .'='. $value .'&';

                return $pagelink;
        }

        function showHeader()
        {
                global $wgOut, $ArticlePath;

                $wgOut->addHTML('<small>');
                $wgOut->addHTML('<a href="' . $this->makePageLink('summary', '0') . '">Display Log</a>     ');
                $wgOut->addHTML('<a href="' . $this->makePageLink('empty',   '1') . '">Display Empty Log</a>     ');
                $wgOut->addHTML('<a href="' . $this->makePageLink('summary', '1') . '">Display Summary</a>');
                $wgOut->addHTML("</small><br />\n");
        }

        function showSummary()
        {
                global $wgOut;

                $wgOut->addHTML("Displaying accumulated summary of search queries ordered by $this->sortkey.<p />\n");

                $dbw = wfGetDB(DB_SLAVE);
                $sortSQL = 'term ASC';

                switch ($this->sortkey)
                {
                case 'term':
                        $sortSQL = 'term';
                        break;
                case 'count':
                        $sortSQL = 'count DESC';
                        break;
                }

                $log = $dbw->select('searchlog_summary', array('term', 'count'), '', __METHOD__, array('ORDER BY' => $sortSQL));

                if ($log)
                        $wgOut->addHTML("Found ". $log->numRows() ." unique search queries...");
                else
                        $wgOut->addHTML("Found 0 unique search queries...");

                $wgOut->addHTML("<table class='wikitable'>\n");
                $wgOut->addHTML("<tr>");
                $wgOut->addHTML("<th><a href='". $this->makePageLink('sort', 'term') . "'>Search Term(s)</a></th>");
                $wgOut->addHTML("<th><a href='". $this->makePageLink('sort', 'count') ."'>Count</a></th>");
                $wgOut->addHTML("</tr>\n");

                $count = 0;

                while ($result = $log->next())
                {
                        ++$count;
                        if ($count > $this->maxrows) break;

                        $wgOut->addHTML("<tr>");
                        $wgOut->addHTML("<td>$result->term</td>");
                        $wgOut->addHTML("<td>$result->count</td>");
                        $wgOut->addHTML("</tr>\n");
                }

                $wgOut->addHTML("</table>\n");
        }

        function showLog ()
        {
                global $wgOut;

                if ($this->empty)
                        $wgOut->addHTML("Displaying log of empty search queries ordered by $this->sortkey.<p />\n");
                else
                        $wgOut->addHTML("Displaying log of search queries ordered by $this->sortkey.<p />\n");


                $sortSQL = 'searchdate DESC';

                switch ($this->sortkey)
                {
                case 'term':
                        $sortSQL = 'term';
                        break;
                case 'titlecount':
                        $sortSQL = 'titlecount ASC';
                        break;
                case 'textcount':
                        $sortSQL = 'textcount ASC';
                        break;
                case 'date':
                        $sortSQL = 'searchdate DESC';
                        break;
                case 'timetaken':
                        $sortSQL = 'searchtime DESC';
                        break;
                }

                $dbw = wfGetDB(DB_SLAVE);
       }

        function showLog ()
        {
                global $wgOut;

                if ($this->empty)
                        $wgOut->addHTML("Displaying log of empty search queries ordered by $this->sortkey.<p />\n");
                else
                        $wgOut->addHTML("Displaying log of search queries ordered by $this->sortkey.<p />\n");


                $sortSQL = 'searchdate DESC';

                switch ($this->sortkey)
                {
                case 'term':
                        $sortSQL = 'term';
                        break;
                case 'titlecount':
                        $sortSQL = 'titlecount ASC';
                        break;
                case 'textcount':
                        $sortSQL = 'textcount ASC';
                        break;
                case 'date':
                        $sortSQL = 'searchdate DESC';
                        break;
                case 'timetaken':
                        $sortSQL = 'searchtime DESC';
                        break;
                }

                $dbw = wfGetDB(DB_SLAVE);

                if ($this->empty)
                        $where = "titlecount=0 AND textcount=0";
                else
                        $where = "";

                $log = $dbw->select('searchlog', array('term', 'titlecount', 'textcount', 'searchdate', 'searchtime'), $where, __METHOD__, array('ORDER BY' => $sortSQL));

                if ($log)
                        $wgOut->addHTML("Found ". $log->numRows() ." search queries...");
                else
                        $wgOut->addHTML("Found 0 search queries...");

                $wgOut->addHTML("<table class='wikitable'>\n");
                $wgOut->addHTML("<tr>");
                $wgOut->addHTML("<th><a href='". $this->makePageLink('sort', 'term') . "'>Search Term(s)</a></th>");
                $wgOut->addHTML("<th><a href='". $this->makePageLink('sort', 'titlecount') . "'>Title Count</a></th>");
                $wgOut->addHTML("<th><a href='". $this->makePageLink('sort', 'textcount') . "'>Text Count</a></th>");
                $wgOut->addHTML("<th><a href='". $this->makePageLink('sort', 'date') . "'>Search Date</a></th>");
                $wgOut->addHTML("<th><a href='". $this->makePageLink('sort', 'timetaken') . "'>Time Taken</a></th>");
                $wgOut->addHTML("</tr>\n");

                $count = 0;

                while ($result = $log->next())
                {
                        ++$count;
                        if ($count > $this->maxrows) break;

                        $wgOut->addHTML("<tr>");
                        $wgOut->addHTML("<td>$result->term</td>");
                        $wgOut->addHTML("<td>$result->titlecount</td>");
                        $wgOut->addHTML("<td>$result->textcount</td>");
                        $wgOut->addHTML("<td>$result->searchdate</td>");
                        $wgOut->addHTML("<td>$result->searchtime</td>");
                        $wgOut->addHTML("</tr>\n");
                }

                $wgOut->addHTML("</table>\n");
        }

}

?>