Xtools\AdminScoreRepository::fetchData()

Complexity

Conditions	1
Paths	1

Size

Total Lines	65
Code Lines	25

Duplication

Lines	0
Ratio	0 %

Importance

Changes

0

<?php
    public function fetchData(Project $project, User $user)
    {
        $userTable = $project->getTableName('user');
        $pageTable = $project->getTableName('page');
        $loggingTable = $project->getTableName('logging', 'userindex');
        $revisionTable = $project->getTableName('revision');
        $archiveTable = $project->getTableName('archive');

        $sql = "SELECT 'account-age' AS source, user_registration AS value FROM $userTable
                    WHERE user_name = :username
                UNION
                SELECT 'edit-count' AS source, user_editcount AS value FROM $userTable
                    WHERE user_name = :username
                UNION
                SELECT 'user-page' AS source, page_len AS value FROM $pageTable
                    WHERE page_namespace = 2 AND page_title = :username
                UNION
                SELECT 'patrols' AS source, COUNT(*) AS value FROM $loggingTable
                    WHERE log_type = 'patrol'
                        AND log_action = 'patrol'
                        AND log_namespace = 0
                        AND log_deleted = 0 AND log_user_text = :username
                UNION
                SELECT 'blocks' AS source, COUNT(*) AS value FROM $loggingTable l
                    INNER JOIN $userTable u ON l.log_user = u.user_id
                    WHERE l.log_type = 'block' AND l.log_action = 'block'
                    AND l.log_namespace = 2 AND l.log_deleted = 0 AND u.user_name = :username
                UNION
                SELECT 'afd' AS source, COUNT(*) AS value FROM $revisionTable r
                  INNER JOIN $pageTable p on p.page_id = r.rev_page
                    WHERE p.page_title LIKE 'Articles_for_deletion/%'
                        AND p.page_title NOT LIKE 'Articles_for_deletion/Log/%'
                        AND r.rev_user_text = :username
                UNION
                SELECT 'recent-activity' AS source, COUNT(*) AS value FROM $revisionTable
                    WHERE rev_user_text = :username AND rev_timestamp > (now()-INTERVAL 730 day)
                        AND rev_timestamp < now()
                UNION
                SELECT 'aiv' AS source, COUNT(*) AS value FROM $revisionTable r
                  INNER JOIN $pageTable p on p.page_id = r.rev_page
                    WHERE p.page_title LIKE 'Administrator_intervention_against_vandalism%'
                        AND r.rev_user_text = :username
                UNION
                SELECT 'edit-summaries' AS source, COUNT(*) AS value
                FROM $revisionTable JOIN $pageTable ON rev_page = page_id
                    WHERE page_namespace = 0 AND rev_user_text = :username
                UNION
                SELECT 'namespaces' AS source, count(*) AS value
                FROM $revisionTable JOIN $pageTable ON rev_page = page_id
                    WHERE rev_user_text = :username AND page_namespace = 0
                UNION
                SELECT 'pages-created-live' AS source, COUNT(*) AS value FROM $revisionTable
                    WHERE rev_user_text = :username AND rev_parent_id = 0
                UNION
                SELECT 'pages-created-deleted' AS source, COUNT(*) AS value FROM $archiveTable
                    WHERE ar_user_text = :username AND ar_parent_id = 0
                UNION
                SELECT 'rpp' AS source, COUNT(*) AS value FROM $revisionTable r
                  INNER JOIN $pageTable p on p.page_id = r.rev_page
                    WHERE p.page_title LIKE 'Requests_for_page_protection%'
                        AND r.rev_user_text = :username;";

        return $this->executeProjectsQuery($sql, [
            'username' => $user->getUsername(),
        ])->fetchAll();
    }