Waca\Helpers\SearchHelpers\UserSearchHelper

Complexity

Total Complexity

8

Size/Duplication

Total Lines	92
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

7 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	get()	0	6	1
A	byStatus()	0	7	1
A	statusIn()	0	5	1
A	byRole()	0	8	1
A	lastActiveBefore()	0	6	1
A	getRoleMap()	0	20	2

<?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\Helpers\SearchHelpers;

use DateTime;
use PDO;
use Waca\DataObjects\User;
use Waca\PdoDatabase;

class UserSearchHelper extends SearchHelperBase
{
    /**
     * UserSearchHelper constructor.
     *
     * @param PdoDatabase $database
     */
    public function __construct(PdoDatabase $database)
    {
        parent::__construct($database, 'user', User::class);
    }

    /**
     * Initiates a search for requests
     *
     * @param PdoDatabase $database
     *
     * @return UserSearchHelper
     */
    public static function get(PdoDatabase $database)
    {
        $helper = new UserSearchHelper($database);

        return $helper;
    }

    /**
     * @param string $status
     *
     * @return $this
     */
    public function byStatus($status)
    {
        $this->whereClause .= ' AND status = ?';
        $this->parameterList[] = $status;

        return $this;
    }

    public function statusIn($statuses) {
        $this->inClause('status', $statuses);

        return $this;
    }

    /**
     * @param string $role
     *
     * @return $this
     */
    public function byRole($role)
    {
        $this->joinClause .= ' INNER JOIN userrole r on origin.id = r.user';
        $this->whereClause .= ' AND r.role = ?';
        $this->parameterList[] = $role;

        return $this;
    }

    /**
     * @param DateTime $instant
     *
     * @return $this
     */
    public function lastActiveBefore(DateTime $instant){
        $this->whereClause .= ' AND origin.lastactive < ?';
        $this->parameterList[] = $instant->format("Y-m-d H:i:s");

        return $this;
    }

    public function getRoleMap(&$roleMap){
        $query = <<<SQL
            SELECT /* UserSearchHelper/roleMap */ 
                  r.user user
                , group_concat(r.role SEPARATOR ', ') roles 
            FROM userrole r 
            WHERE user IN ({$this->buildQuery(array('id'))})
            GROUP BY r.user
SQL;

        $statement = $this->database->prepare($query);
        $statement->execute($this->parameterList);

        $roleMap = array();
        foreach ($statement->fetchAll(PDO::FETCH_ASSOC) as $row) {
            $roleMap[$row['user']] = $row['roles'];
        }

        return $this;
    }
}