OldTown\Workflow\ZF2\Toolkit\EntityRepository\DoctrineWorkflowStory\ExtEntryRepository

Complexity

Total Complexity

1

Size/Duplication

Total Lines	33
Duplicated Lines	0 %

Coupling/Cohesion

Components	1
Dependencies	3

Importance

Changes	2
Bugs	0	Features	0

1 Method

Rating	Name	Duplication	Size	Complexity
A	findEntryByObjectInfo()	0	21	1

<?php
/**
 * @link  https://github.com/old-town/workflow-zf2-toolkit
 * @author  Malofeykin Andrey  <and-rey2@yandex.ru>
 */
namespace OldTown\Workflow\ZF2\Toolkit\EntityRepository\DoctrineWorkflowStory;

use Doctrine\ORM\EntityRepository;
use OldTown\Workflow\ZF2\Toolkit\Entity\DoctrineWorkflowStory\ExtEntry;


/**
 * Class ExtEntryRepository
 *
 * @package OldTown\Workflow\ZF2\Toolkit\EntityRepository\DoctrineWorkflowStory
 */
class ExtEntryRepository extends EntityRepository
{
    /**
     * @param       $workflowName
     * @param array $objectHash
     *
     * @return ExtEntry
     *
     * @throws \Doctrine\ORM\NonUniqueResultException
     * @throws \Doctrine\ORM\NoResultException
     */
    public function findEntryByObjectInfo($workflowName, array $objectHash = [])
    {
        $entryClassName = ExtEntry::class;

        $dql = "
          SELECT
            entry
          FROM {$entryClassName} entry
          JOIN entry.objectsInfo objectInfo
          WHERE
              entry.workflowName = :workflowName
                AND
              objectInfo.hash IN (:hash)
          GROUP BY entry.id
          ";
        $query = $this->_em->createQuery($dql);
        $query->setParameter('workflowName', $workflowName);
        $query->setParameter('hash', $objectHash);

        return $query->getSingleResult();
    }
}