vendor/uvdesk/automation-bundle/Repository/WorkflowRepository.php line 33

Open in your IDE?
  1. <?php
  3. namespace Webkul\UVDesk\AutomationBundle\Repository;
  5. use Doctrine\Common\Collections\Criteria;
  6. use Webkul\UVDesk\AutomationBundle\Entity\Workflow;
  8. /**
  9.  * WorkflowRepository
  10.  *
  11.  * This class was generated by the Doctrine ORM. Add your own custom
  12.  * repository methods below.
  13.  */
  14. class WorkflowRepository extends \Doctrine\ORM\EntityRepository
  15. {
  16.     const LIMIT = 10;
  17.     
  18.     public function getEventWorkflows($eventName, $isActive = true, $isPredefined = true)
  19.     {
  20.         $queryBuilder = $this->getEntityManager()->createQueryBuilder()
  21.             ->select('workflow')
  22.             ->from(Workflow::class, 'workflow')
  23.             ->leftJoin('workflow.workflowEvents', 'workflowEvents')
  24.             ->where('workflow.status = :status')->setParameter('status', $isActive)
  25.             ->andWhere('workflow.isPredefind = :isPredefined')->setParameter('isPredefined', $isPredefined)
  26.             ->andWhere('workflowEvents.event = :eventType')->setParameter('eventType', $eventName)
  27.             ->orderBy('workflow.sortOrder', Criteria::ASC)
  28.         ;
  30.         return $queryBuilder->getQuery()->getResult();
  31.     }
  33.     public function getWorkflows(\Symfony\Component\HttpFoundation\ParameterBag $obj = null, $container)
  34.     {
  35.         $queryBuilder = $this->getEntityManager()->createQueryBuilder()
  36.             ->select('w.id, w.name, w.status')
  37.             ->from($this->getEntityName(), 'w')
  38.             ->orderBy('w.sortOrder', Criteria::ASC)
  39.         ;
  41.         return ['workflows' => $queryBuilder->getQuery()->getArrayResult()];
  42.     }
  43. }