SpecialGadgetUsage.php

Go to the documentation of this file.

<?php
use Wikimedia\Rdbms\IDatabase;
use Wikimedia\Rdbms\IResultWrapper;
 
class SpecialGadgetUsage extends QueryPage {
    public function __construct( $name = 'GadgetUsage' ) {
        parent::__construct( $name );
        $this->limit = 1000; // Show all gadgets
        $this->shownavigation = false;
        $this->activeUsers = $this->getConfig()->get( 'SpecialGadgetUsageActiveUsers' );
    }
 
    public $activeUsers;
 
    public function isExpensive() {
        return true;
    }
 
    public function getQueryInfo() {
        $dbr = wfGetDB( DB_REPLICA );
        if ( !$this->activeUsers ) {
            return [
                'tables' => [ 'user_properties' ],
                'fields' => [
                    'title' => 'up_property',
                    'value' => 'SUM( up_value )',
                    'namespace' => NS_GADGET
                ],
                'conds' => [
                    'up_property' . $dbr->buildLike( 'gadget-', $dbr->anyString() )
                ],
                'options' => [
                    'GROUP BY' => [ 'up_property' ]
                ]
            ];
        } else {
            return [
                'tables' => [ 'user_properties', 'user', 'querycachetwo' ],
                'fields' => [
                    'title' => 'up_property',
                    'value' => 'SUM( up_value )',
                    // Need to pick fields existing in the querycache table so that the results are cachable
                    'namespace' => 'COUNT( qcc_title )'
                ],
                'conds' => [
                    'up_property' . $dbr->buildLike( 'gadget-', $dbr->anyString() )
                ],
                'options' => [
                    'GROUP BY' => [ 'up_property' ]
                ],
                'join_conds' => [
                    'user' => [
                        'LEFT JOIN', [
                            'up_user = user_id'
                        ]
                    ],
                    'querycachetwo' => [
                        'LEFT JOIN', [
                            'user_name = qcc_title',
                            'qcc_type = "activeusers"',
                            'up_value = 1'
                        ]
                    ]
                ]
            ];
        }
    }
 
    public function getOrderFields() {
        return [ 'value' ];
    }
 
    protected function outputTableStart() {
        $html = Html::openElement( 'table', [ 'class' => [ 'sortable', 'wikitable' ] ] );
        $html .= Html::openElement( 'thead', [] );
        $html .= Html::openElement( 'tr', [] );
        $headers = [ 'gadgetusage-gadget', 'gadgetusage-usercount' ];
        if ( $this->activeUsers ) {
            $headers[] = 'gadgetusage-activeusers';
        }
        foreach ( $headers as $h ) {
            if ( $h == 'gadgetusage-gadget' ) {
                $html .= Html::element( 'th', [], $this->msg( $h )->text() );
            } else {
                $html .= Html::element( 'th', [ 'data-sort-type' => 'number' ],
                    $this->msg( $h )->text() );
            }
        }
        $html .= Html::closeElement( 'tr' );
        $html .= Html::closeElement( 'thead' );
        $html .= Html::openElement( 'tbody', [] );
        $this->getOutput()->addHTML( $html );
    }
 
    protected function outputTableEnd() {
        $this->getOutput()->addHTML(
            Html::closeElement( 'tbody' ) .
            Html::closeElement( 'table' )
        );
    }
 
    public function formatResult( $skin, $result ) {
        $gadgetTitle = substr( $result->title, 7 );
        $gadgetUserCount = $this->getLanguage()->formatNum( $result->value );
        if ( $gadgetTitle ) {
            $html = Html::openElement( 'tr', [] );
            $html .= Html::element( 'td', [], $gadgetTitle );
            $html .= Html::element( 'td', [], $gadgetUserCount );
            if ( $this->activeUsers == true ) {
                $activeUserCount = $this->getLanguage()->formatNum( $result->namespace );
                $html .= Html::element( 'td', [], $activeUserCount );
            }
            $html .= Html::closeElement( 'tr' );
            return $html;
        }
        return false;
    }
 
    protected function getDefaultGadgets( $gadgetRepo, $gadgetIds ) {
        $gadgetsList = [];
        foreach ( $gadgetIds as $g ) {
            $gadget = $gadgetRepo->getGadget( $g );
            if ( $gadget->isOnByDefault() ) {
                $gadgetsList[] = $gadget->getName();
            }
        }
        asort( $gadgetsList, SORT_STRING | SORT_FLAG_CASE );
        return $gadgetsList;
    }
 
    protected function outputResults( $out, $skin, $dbr, $res, $num, $offset ) {
        $gadgetRepo = GadgetRepo::singleton();
        $gadgetIds = $gadgetRepo->getGadgetIds();
        $defaultGadgets = $this->getDefaultGadgets( $gadgetRepo, $gadgetIds );
        if ( $this->activeUsers ) {
            $out->addHtml(
                $this->msg( 'gadgetusage-intro' )
                    ->numParams( $this->getConfig()->get( 'ActiveUserDays' ) )->parseAsBlock()
            );
        } else {
            $out->addHtml(
                $this->msg( 'gadgetusage-intro-noactive' )->parseAsBlock()
            );
        }
        if ( $num > 0 ) {
            $this->outputTableStart();
            // Append default gadgets to the table with 'default' in the total and active user fields
            foreach ( $defaultGadgets as $default ) {
                $html = Html::openElement( 'tr', [] );
                $html .= Html::element( 'td', [], $default );
                $html .= Html::element( 'td', [ 'data-sort-value' => 'Infinity' ],
                    $this->msg( 'gadgetusage-default' )->text() );
                if ( $this->activeUsers ) {
                    $html .= Html::element( 'td', [ 'data-sort-value' => 'Infinity' ],
                        $this->msg( 'gadgetusage-default' )->text() );
                }
                $html .= Html::closeElement( 'tr' );
                $out->addHTML( $html );
            }
            foreach ( $res as $row ) {
                // Remove the 'gadget-' part of the result string and compare if it's present
                // in $defaultGadgets, if not we format it and add it to the output
                if ( !in_array( substr( $row->title, 7 ), $defaultGadgets ) ) {
                    // Only pick gadgets which are in the list $gadgetIds to make sure they exist
                    if ( in_array( substr( $row->title, 7 ), $gadgetIds ) ) {
                        $line = $this->formatResult( $skin, $row );
                        if ( $line ) {
                            $out->addHTML( $line );
                        }
                    }
                }
            }
            // Close table element
            $this->outputTableEnd();
        } else {
            $out->addHtml(
                $this->msg( 'gadgetusage-noresults' )->parseAsBlock()
            );
        }
    }
 
    protected function getGroupName() {
        return 'wiki';
    }
}