Oc\GeoCache\Reports

Complexity

Total Complexity

2

Size/Duplication

Total Lines	35
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	2

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	__construct()	0	4	1
A	getReportStatus()	0	15	1

<?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);
    }
}