Azine\MailgunWebhooksBundle\Entity\Repositories\EmailTrafficStatisticsRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	23
Duplicated Lines	0 %

Test Coverage

Coverage

0%

Importance

Changes	2
Bugs	1	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	getLastByAction()	0	14	2

<?php

namespace Azine\MailgunWebhooksBundle\Entity\Repositories;

use Azine\MailgunWebhooksBundle\Entity\EmailTrafficStatistics;
use Doctrine\ORM\EntityRepository;

/**
 * EmailTrafficStatisticsRepository.
 *
 * This entity is used to store some events that occurred regarding mailgun.
 * E.g. when has the last notification about a SPAM complaint been sent to the administrator.
 */
class EmailTrafficStatisticsRepository extends EntityRepository
{
    /**
     * Get last EmailTrafficStatistics by action.
     *
     * @param $action
     *
     * @return EmailTrafficStatistics
     */
    public function getLastByAction($action)
    {
        $q = $this->getEntityManager()->createQueryBuilder()
            ->setMaxResults(1)
            ->select('e')
            ->from($this->getEntityName(), 'e')
            ->where('e.action = :action')
            ->orderBy('e.created ', 'desc')
            ->setParameters(array('action' => $action));

        try {
            return $q->getQuery()->getSingleResult();
        } catch (\Doctrine\ORM\NoResultException $e) {
            return null;
        }
    }
}