Azine\MailgunWebhooksBundle\Entity\Repositories\EmailTrafficStatisticsRepository

Complexity

Total Complexity

2

Size/Duplication

Total Lines	27
Duplicated Lines	0 %

Coupling/Cohesion

Components	0
Dependencies	3

Importance

Changes

0

1 Method

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

<?php

namespace Azine\MailgunWebhooksBundle\Entity\Repositories;

use Azine\MailgunWebhooksBundle\Entity\EmailTrafficStatistics;
use Doctrine\ORM\QueryBuilder;
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()
            ->select('e')
            ->from($this->getEntityName(), "e")
            ->where('e.action = :action')
            ->orderBy('e.created ', 'desc')
            ->setParameters(['action' => $action]);

        try {

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

            return null;
        }
    }
}