Developtech\AgilityBundle\Repository\FeedbackRepository

Complexity

Total Complexity

1

Size/Duplication

Total Lines	19
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	4

Importance

Changes	2
Bugs	0	Features	2

1 Method

Rating	Name	Duplication	Size	Complexity
A	countPerStatus()	0	11	1

<?php

namespace Developtech\AgilityBundle\Repository;

use Developtech\AgilityBundle\Model\ProjectModel;

/**
 * FeedbackRepository
 *
 * This class was generated by the Doctrine ORM. Add your own custom
 * repository methods below.
 */
class FeedbackRepository extends \Doctrine\ORM\EntityRepository
{
    /**
     * @param ProjectModel $project
     * @param integer $status
     * @return integer
     */
    public function countPerStatus(ProjectModel $project, $status) {
        $statement = $this->getEntityManager()->getConnection()->prepare(
            "SELECT COUNT(*) as nb_feedbacks FROM {$this->getClassMetadata()->getTableName()} " .
            "WHERE project_id = :project_id AND status = :status"
        );
        $statement->execute([
            'project_id' => $project->getId(),
            'status' => $status
        ]);
        return (int) $statement->fetch()['nb_feedbacks'];
    }
}