for testing and deploying your application
for finding and fixing issues
for empowering human code reviews
<?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);
OpencachingDeutschland /
oc-server3
