Doctrs\SonataImportBundle\Repository\DefaultRepository

Complexity

Total Complexity

8

Size/Duplication

Total Lines	33
Duplicated Lines	0 %

Importance

Changes

0

2 Methods

Rating	Name	Duplication	Size	Complexity
A	count()	0	11	3
B	pagerfanta()	0	18	5

<?php


namespace Doctrs\SonataImportBundle\Repository;


use Doctrine\ORM\EntityRepository;

The type Doctrine\ORM\EntityRepository was not found. Maybe you did not declare it correctly or list all dependencies?

use Symfony\Component\HttpFoundation\Request;

class DefaultRepository extends EntityRepository {

    public function pagerfanta(Request $request) {
        $sql = $this->createQueryBuilder('data');
        $sql->select('data');
        switch ($request->get('type', 'all')) {
            case 'success':
                $sql->where('data.status = 1 or data.status = 2');
                break;
            case 'new':
                $sql->where('data.status = 1');
                break;
            case 'update':
                $sql->where('data.status = 2');
                break;
            case 'error':
                $sql->where('data.status = 3');
                break;
        }
        return $sql->getQuery();
    }

    public function count(array $where = []) {
        $sql = $this->createQueryBuilder('data');
        $sql->select('COUNT(data)');
        if (sizeof($where)) {

The call to sizeof() has too few arguments starting with mode.

            foreach ($where as $key => $value) {
                $sql->andWhere('data.' . $key . ' = :' . $key);
                $sql->setParameter($key, $value);
            }
        }

        return $sql->getQuery()->getSingleScalarResult();
    }

}