Reports::getReportStatus() - Code Metrics - Inspection of "Misc/cleanup oc namespace and add api endpoint" - OpencachingDeutschland/oc-server3 - Measure and Improve Code Quality continuously with Scrutinizer

Completed

Pull Request — development (#560)

by Thomas

created 2017-08-28 18:27 UTC

Reports::getReportStatus() A

↳ Parent: Reports

Complexity

Conditions	1
Paths	1

Size

Total Lines	15
Code Lines	11

Duplication

Lines	0
Ratio	0 %

Importance

Changes

Metric	Value
cc	1
eloc	11
nc	1
nop	1
dl	0
loc	15
rs	9.4285
c	0
b	0
f	0

<?php

namespace Oc\GeoCache;

use Doctrine\DBAL\Connection;

class Reports
{
    /**
     * @var Connection
     */
    private $connection;

    /**
     * @param Connection $connection
     */
    public function __construct(Connection $connection)
    {
        $this->connection = $connection;
    }

    /**
     * @param array $wpCodes
     * @return array
     */
    public function getReportStatus(array $wpCodes)
    {
        $query = $this->connection->createQueryBuilder()
            ->select('DISTINCT(wp_oc)')
            ->from('caches', 'c')
            ->innerJoin('c', 'cache_reports', 'cr', 'cr.cacheid = c.cache_id')
            ->where('wp_oc IN (:wpCodes)')
            ->andWhere('cr.status IN (:status)')
            ->setParameter(':wpCodes', $wpCodes, Connection::PARAM_STR_ARRAY)
            ->setParameter(':status', [1, 2], Connection::PARAM_INT_ARRAY);

        $statement = $query->execute();

        return $statement->fetchAll(\PDO::FETCH_ASSOC);
    }
}


1			<?php
2
3			namespace Oc\GeoCache;
4
5			use Doctrine\DBAL\Connection;
6
7			class Reports
8			{
9			/**
10			* @var Connection
11			*/
12			private $connection;
13
14			/**
15			* @param Connection $connection
16			*/
17			public function __construct(Connection $connection)
18			{
19			$this->connection = $connection;
20			}
21
22			/**
23			* @param array $wpCodes
24			* @return array
25			*/
26			public function getReportStatus(array $wpCodes)
27			{
28			$query = $this->connection->createQueryBuilder()
29			->select('DISTINCT(wp_oc)')
30			->from('caches', 'c')
31			->innerJoin('c', 'cache_reports', 'cr', 'cr.cacheid = c.cache_id')
32			->where('wp_oc IN (:wpCodes)')
33			->andWhere('cr.status IN (:status)')
34			->setParameter(':wpCodes', $wpCodes, Connection::PARAM_STR_ARRAY)
35			->setParameter(':status', [1, 2], Connection::PARAM_INT_ARRAY);
36
37			$statement = $query->execute();
38
39			return $statement->fetchAll(\PDO::FETCH_ASSOC);
40			}
41			}
42

OpencachingDeutschland / oc-server3

Pull Request — development (#560)

Reports::getReportStatus() A

Complexity

Size

Duplication

Importance

Duplication Side-by-Side

Filter issues like