RequestSearchHelper::fetchByStatus() - Code Metrics - Inspection of "Merge pull request #704 from enwikipedia-acc/multi..." - enwikipedia-acc/waca - Measure and Improve Code Quality continuously with Scrutinizer

Failed Conditions

Push — multiproject/requestqueue ( a1c474...082002 )

by Simon

created 2021-10-15 22:40 UTC

RequestSearchHelper::fetchByStatus() A

↳ Parent: RequestSearchHelper

Complexity

Conditions	1
Paths	1

Size

Total Lines	3
Code Lines	1

Duplication

Lines	0
Ratio	0 %

Code Coverage

Tests	0
CRAP Score	2

Importance

Changes	1
Bugs	0	Features	0

Metric	Value
eloc	1
c	1
b	0
f	0
dl	0
loc	3
ccs	0
cts	3
cp	0
rs	10
cc	1
nc	1
nop	1
crap	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 Waca\DataObjects\Request;
use Waca\PdoDatabase;
use Waca\RequestStatus;
use Waca\SiteConfiguration;

class RequestSearchHelper extends SearchHelperBase
{
    /**
     * RequestSearchHelper constructor.
     *
     * @param PdoDatabase $database
     */
    protected function __construct(PdoDatabase $database)
    {
        parent::__construct($database, 'request', Request::class);
    }

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

        return $helper;
    }

    /**
     * Filters the results by IP address
     *
     * @param string $ipAddress
     *
     * @return $this
     */
    public function byIp($ipAddress)
    {
        $this->whereClause .= ' AND (ip LIKE ? OR forwardedip LIKE ?)';
        $this->parameterList[] = $ipAddress;
        $this->parameterList[] = '%' . trim($ipAddress, '%') . '%';

        return $this;
    }

    /**
     * Filters the results by email address
     *
     * @param string $emailAddress
     *
     * @return $this
     */
    public function byEmailAddress($emailAddress)
    {
        $this->whereClause .= ' AND email LIKE ?';
        $this->parameterList[] = $emailAddress;

        return $this;
    }

    /**
     * Filters the results by name
     *
     * @param string $name
     *
     * @return $this
     */
    public function byName($name)
    {
        $this->whereClause .= ' AND name LIKE ?';
        $this->parameterList[] = $name;

        return $this;
    }

    /**
     * Filters the requests to those with a defined status
     *
     * @param $status
     *
     * @return $this
     */
    public function byStatus($status)
    {
        $this->whereClause .= ' AND status = ?';
        $this->parameterList[] = $status;

        return $this;
    }

    /**
     * Excludes a request from the results
     *
     * @param int $requestId
     *
     * @return $this
     */
    public function excludingRequest($requestId)
    {
        $this->whereClause .= ' AND id <> ?';
        $this->parameterList[] = $requestId;

        return $this;
    }

    /**
     * Filters the results to only those with a confirmed email address
     *
     * @return $this
     */
    public function withConfirmedEmail()
    {
        $this->whereClause .= ' AND emailconfirm = ?';
        $this->parameterList[] = 'Confirmed';

        return $this;
    }

    /**
     * Filters the results to exclude purged data
     *
     * @param SiteConfiguration $configuration
     *
     * @return $this
     */
    public function excludingPurgedData(SiteConfiguration $configuration)
    {
        $this->whereClause .= ' AND ip <> ? AND email <> ?';
        $this->parameterList[] = $configuration->getDataClearIp();
        $this->parameterList[] = $configuration->getDataClearEmail();

        return $this;
    }

    /**
     * Filters the requests to those without a defined status
     *
     * @param $status
     *
     * @return $this
     */
    public function excludingStatus($status)
    {
        $this->whereClause .= ' AND status <> ?';
        $this->parameterList[] = $status;

        return $this;
    }

    /**
     * Filters the requests to those which have failed an auto-creation
     *
     * @return $this
     */
    public function isHospitalised()
    {
        $this->whereClause .= ' AND status = ?';
        $this->parameterList[] = RequestStatus::HOSPITAL;

        return $this;
    }

    /**
     * Filters the requests to those which have not failed an auto-creation
     *
     * @return $this
     */
    public function notHospitalised()
    {
        $this->whereClause .= ' AND status <> ?';
        $this->parameterList[] = RequestStatus::HOSPITAL;

        return $this;
    }

    public function fetchByQueue($queues)
    {
        return $this->fetchByParameter(' AND queue = ?', $queues);
    }
}


1			<?php
2			/******************************************************************************
3			* Wikipedia Account Creation Assistance tool *
4			* *
5			* All code in this file is released into the public domain by the ACC *
6			* Development Team. Please see team.json for a list of contributors. *
7			******************************************************************************/
8
9			namespace Waca\Helpers\SearchHelpers;
10
11			use Waca\DataObjects\Request;
12			use Waca\PdoDatabase;
13			use Waca\RequestStatus;
14			use Waca\SiteConfiguration;
15
16			class RequestSearchHelper extends SearchHelperBase
17			{
18			/**
19			* RequestSearchHelper constructor.
20			*
21			* @param PdoDatabase $database
22			*/
23			protected function __construct(PdoDatabase $database)
24			{
25			parent::__construct($database, 'request', Request::class);
26			}
27
28			/**
29			* Initiates a search for requests
30			*
31			* @param PdoDatabase $database
32			*
33			* @return RequestSearchHelper
34			*/
35			public static function get(PdoDatabase $database)
36			{
37			$helper = new RequestSearchHelper($database);
38
39			return $helper;
40			}
41
42			/**
43			* Filters the results by IP address
44			*
45			* @param string $ipAddress
46			*
47			* @return $this
48			*/
49			public function byIp($ipAddress)
50			{
51			$this->whereClause .= ' AND (ip LIKE ? OR forwardedip LIKE ?)';
52			$this->parameterList[] = $ipAddress;
53			$this->parameterList[] = '%' . trim($ipAddress, '%') . '%';
54
55			return $this;
56			}
57
58			/**
59			* Filters the results by email address
60			*
61			* @param string $emailAddress
62			*
63			* @return $this
64			*/
65			public function byEmailAddress($emailAddress)
66			{
67			$this->whereClause .= ' AND email LIKE ?';
68			$this->parameterList[] = $emailAddress;
69
70			return $this;
71			}
72
73			/**
74			* Filters the results by name
75			*
76			* @param string $name
77			*
78			* @return $this
79			*/
80			public function byName($name)
81			{
82			$this->whereClause .= ' AND name LIKE ?';
83			$this->parameterList[] = $name;
84
85			return $this;
86			}
87
88			/**
89			* Filters the requests to those with a defined status
90			*
91			* @param $status
92			*
93			* @return $this
94			*/
95			public function byStatus($status)
96			{
97			$this->whereClause .= ' AND status = ?';
98			$this->parameterList[] = $status;
99
100			return $this;
101			}
102
103			/**
104			* Excludes a request from the results
105			*
106			* @param int $requestId
107			*
108			* @return $this
109			*/
110			public function excludingRequest($requestId)
111			{
112			$this->whereClause .= ' AND id <> ?';
113			$this->parameterList[] = $requestId;
114
115			return $this;
116			}
117
118			/**
119			* Filters the results to only those with a confirmed email address
120			*
121			* @return $this
122			*/
123			public function withConfirmedEmail()
124			{
125			$this->whereClause .= ' AND emailconfirm = ?';
126			$this->parameterList[] = 'Confirmed';
127
128			return $this;
129			}
130
131			/**
132			* Filters the results to exclude purged data
133			*
134			* @param SiteConfiguration $configuration
135			*
136			* @return $this
137			*/
138			public function excludingPurgedData(SiteConfiguration $configuration)
139			{
140			$this->whereClause .= ' AND ip <> ? AND email <> ?';
141			$this->parameterList[] = $configuration->getDataClearIp();
142			$this->parameterList[] = $configuration->getDataClearEmail();
143
144			return $this;
145			}
146
147			/**
148			* Filters the requests to those without a defined status
149			*
150			* @param $status
151			*
152			* @return $this
153			*/
154			public function excludingStatus($status)
155			{
156			$this->whereClause .= ' AND status <> ?';
157			$this->parameterList[] = $status;
158
159			return $this;
160			}
161
162			/**
163			* Filters the requests to those which have failed an auto-creation
164			*
165			* @return $this
166			*/
167			public function isHospitalised()
168			{
169			$this->whereClause .= ' AND status = ?';
170			$this->parameterList[] = RequestStatus::HOSPITAL;
171
172			return $this;
173			}
174
175			/**
176			* Filters the requests to those which have not failed an auto-creation
177			*
178			* @return $this
179			*/
180			public function notHospitalised()
181			{
182			$this->whereClause .= ' AND status <> ?';
183			$this->parameterList[] = RequestStatus::HOSPITAL;
184
185			return $this;
186			}
187
188			public function fetchByQueue($queues)
189			{
190			return $this->fetchByParameter(' AND queue = ?', $queues);
191			}
192			}
193

enwikipedia-acc / waca

Push — multiproject/requestqueue ( a1c474...082002 )

RequestSearchHelper::fetchByStatus() A

Complexity

Size

Duplication

Code Coverage

Importance

Duplication Side-by-Side

Filter issues like