IndexingStatisticsController.php

Go to the documentation of this file.

<?php
namespace TYPO3\CMS\IndexedSearch\Controller;

use TYPO3\CMS\Core\Utility\GeneralUtility;

class IndexingStatisticsController extends \TYPO3\CMS\Backend\Module\AbstractFunctionModule {

    public function __construct() {
        $GLOBALS['LANG']->includeLLFile('EXT:indexed_search/modfunc2/locallang.xlf');
    }

    public function main() {
        // Initializes the module. Done in this function because we may need to re-initialize if data is submitted!
        $theOutput = $this->pObj->doc->header($GLOBALS['LANG']->getLL('title'));
        $theOutput .= $this->pObj->doc->section('', $this->showStats(), 0, 1);
        $menu = array();
        $functionMenu = \TYPO3\CMS\Backend\Utility\BackendUtility::getFuncCheck($this->pObj->id, 'SET[tx_indexedsearch_modfunc2_check]', $this->pObj->MOD_SETTINGS['tx_indexedsearch_modfunc2_check'], '', '', 'id="checkTx_indexedsearch_modfunc2_check"');
        $menu[] = $functionMenu . '<label for="checkTx_indexedsearch_modfunc2_check"' . $GLOBALS['LANG']->getLL('checklabel') . '</label>';
        $theOutput .= $this->pObj->doc->spacer(5);
        return $theOutput;
    }

    public function showStats() {
        $conf['words'] = 50;

        // max words in result list
        $conf['bid'] = (int)\TYPO3\CMS\Core\Utility\GeneralUtility::_GET('id');

        // pageid for several statistics
        $addwhere1 = '';

        // all records
        $addwhere2 = ' AND tstamp > ' . ($GLOBALS['EXEC_TIME'] - 30 * 24 * 60 * 60);

        // last 30 days
        $addwhere3 = ' AND tstamp > ' . ($GLOBALS['EXEC_TIME'] - 24 * 60 * 60);

        // last 24 hours
        $content = '<p class="lead">' . $GLOBALS['LANG']->getLL('title2') . '</p>';
        $content .= '<table cellpading="5" cellspacing="5" valign="top" class=""><tr><td valign="top">' . $this->listSeveralStats($GLOBALS['LANG']->getLL('all'), $addwhere1, $conf) . '</td><td valign="top">' . $this->listSeveralStats($GLOBALS['LANG']->getLL('last30days'), $addwhere2, $conf) . '</td><td valign="top">' . $this->listSeveralStats($GLOBALS['LANG']->getLL('last24hours'), $addwhere3, $conf) . '</td></tr></table>';
        $content .= '<p>' . $this->note . '</p>';

        // Ask hook to include more on the page:
        if ($hookObj = $this->hookRequest('additionalSearchStat')) {
            $content .= $hookObj->additionalSearchStat();
        }
        return $content;
    }

    public function listSeveralStats($title, $addwhere, $conf) {
        global $LANG;
        $queryParts['SELECT'] = 'word, COUNT(*) AS c';
        $queryParts['FROM'] = 'index_stat_word';
        $queryParts['WHERE'] = sprintf('pageid= %d ' . $addwhere, $conf['bid']);
        $queryParts['GROUPBY'] = 'word';
        $queryParts['ORDERBY'] = 'c DESC,word';
        $queryParts['LIMIT'] = $conf['words'];
        $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery($queryParts['SELECT'], $queryParts['FROM'], $queryParts['WHERE'], $queryParts['GROUPBY'], $queryParts['ORDERBY'], $queryParts['LIMIT']);
        if ($res) {
            $count = $GLOBALS['TYPO3_DB']->sql_num_rows($res);
        } else {
            $count = 0;
        }
        // exist several statistics for this page?
        if ($count > 0) {
            $this->note = $LANG->getLL('justthispage');
        } else {
            // Limit access to pages of the current site
            $secureaddwhere = ' AND pageid IN (' . $this->extGetTreeList($conf['bid'], 100, 0, '1=1') . $conf['bid'] . ') ';
            $this->note = $LANG->getLL('allpages');
            $queryParts['WHERE'] = '1=1 ' . $addwhere . $secureaddwhere;
        }
        // make real query
        $res = $GLOBALS['TYPO3_DB']->exec_SELECTquery($queryParts['SELECT'], $queryParts['FROM'], $queryParts['WHERE'], $queryParts['GROUPBY'], $queryParts['ORDERBY'], $queryParts['LIMIT']);
        $table1 = '';
        $i = 0;
        if ($res) {
            while ($row = $GLOBALS['TYPO3_DB']->sql_fetch_assoc($res)) {
                $i++;
                $table1 .= '<tr class="bgColor4"><td>' . $i . '.</td><td>' . htmlspecialchars($row['word']) . '</td><td>&nbsp;&nbsp;' . $row['c'] . '</td></tr>';
            }
        }
        if ($i == 0) {
            $table1 = '<tr class="bgColor4"><td callspan="3">' . $LANG->getLL('noresults') . '</td></tr>';
        }
        $table1 = '<table class="bgColor5" cellpadding="2" cellspacing="1"><tr class="tableheader"><td colspan="3">' . $title . '</td></tr>' . $table1 . '</table>';
        return $note . $table1;
    }

    public function extGetTreeList($id, $depth, $begin = 0, $perms_clause) {
        return GeneralUtility::makeInstance('TYPO3\\CMS\\Backend\\FrontendBackendUserAuthentication')->extGetTreeList($id, $depth, $begin, $perms_clause);
    }

    public function hookRequest($functionName) {
        // Hook: menuConfig_preProcessModMenu
        if ($GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['indexed_search']['be_hooks'][$functionName]) {
            $hookObj = \TYPO3\CMS\Core\Utility\GeneralUtility::getUserObj($GLOBALS['TYPO3_CONF_VARS']['EXTCONF']['indexed_search']['be_hooks'][$functionName]);
            if (method_exists($hookObj, $functionName)) {
                $hookObj->pObj = $this;
                return $hookObj;
            }
        }
    }

}