Waca\Pages\Statistics\StatsMain

Complexity

Total Complexity

3

Size/Duplication

Total Lines	96
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes	1
Bugs	0	Features	0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	generateSmallStatsTable()	0	65	2
A	main()	0	24	1

<?php
/******************************************************************************
 * Wikipedia Account Creation Assistance tool                                 *
 *                                                                            *
 * All code in this file is released into the public domain by the ACC        *
 * Development Team. Please see team.json for a list of contributors.         *
 ******************************************************************************/

namespace Waca\Pages\Statistics;

use Waca\Tasks\InternalPageBase;

class StatsMain extends InternalPageBase
{
    public function main()
    {
        $this->setHtmlTitle('Statistics');

        $this->assign('statsPageTitle', 'Account Creation Statistics');

        $statsPages = array(
            'fastCloses'       => 'Requests closed less than 30 seconds after reservation in the past 3 months',
            'inactiveUsers'    => 'Inactive tool users',
            'monthlyStats'     => 'Monthly Statistics',
            'reservedRequests' => 'All currently reserved requests',
            'templateStats'    => 'Template Stats',
            'topCreators'      => 'Top Account Creators',
            'users'            => 'Account Creation Tool users',
        );

        $this->generateSmallStatsTable();

        $this->assign('statsPages', $statsPages);

        $graphList = array('day', '2day', '4day', 'week', '2week', 'month', '3month');
        $this->assign('graphList', $graphList);

        $this->setTemplate('statistics/main.tpl');
    }

    /**
     * Gets the relevant statistics from the database for the small statistics table
     */
    private function generateSmallStatsTable()
    {
        $database = $this->getDatabase();
        $requestsQuery = <<<'SQL'
SELECT COUNT(*) FROM request WHERE status = :status AND emailconfirm = 'Confirmed';
SQL;
        $requestsStatement = $database->prepare($requestsQuery);

        $requestStates = $this->getSiteConfiguration()->getRequestStates();

        $requestStateData = array();

        foreach ($requestStates as $statusName => $data) {
            $requestsStatement->execute(array(':status' => $statusName));
            $requestCount = $requestsStatement->fetchColumn();
            $requestsStatement->closeCursor();
            $headerText = $data['header'];
            $requestStateData[$headerText] = $requestCount;
        }

        $this->assign('requestCountData', $requestStateData);

        // Unconfirmed requests
        $unconfirmedStatement = $database->query(<<<SQL
SELECT COUNT(*) FROM request WHERE emailconfirm != 'Confirmed' AND emailconfirm != '';
SQL
        );
        $unconfirmed = $unconfirmedStatement->fetchColumn();
        $unconfirmedStatement->closeCursor();
        $this->assign('statsUnconfirmed', $unconfirmed);

        $userStatusStatement = $database->prepare('SELECT COUNT(*) FROM user WHERE status = :status;');

        // Admin users
        $userStatusStatement->execute(array(':status' => 'Admin'));
        $adminUsers = $userStatusStatement->fetchColumn();
        $userStatusStatement->closeCursor();
        $this->assign('statsAdminUsers', $adminUsers);

        // Users
        $userStatusStatement->execute(array(':status' => 'User'));
        $users = $userStatusStatement->fetchColumn();
        $userStatusStatement->closeCursor();
        $this->assign('statsUsers', $users);

        // Suspended users
        $userStatusStatement->execute(array(':status' => 'Suspended'));
        $suspendedUsers = $userStatusStatement->fetchColumn();
        $userStatusStatement->closeCursor();
        $this->assign('statsSuspendedUsers', $suspendedUsers);

        // New users
        $userStatusStatement->execute(array(':status' => 'New'));
        $newUsers = $userStatusStatement->fetchColumn();
        $userStatusStatement->closeCursor();
        $this->assign('statsNewUsers', $newUsers);

        // Most comments on a request
        $mostCommentsStatement = $database->query(<<<SQL
SELECT request FROM comment GROUP BY request ORDER BY COUNT(*) DESC LIMIT 1;
SQL
        );
        $mostComments = $mostCommentsStatement->fetchColumn();
        $mostCommentsStatement->closeCursor();
        $this->assign('mostComments', $mostComments);
    }
}