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;
  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. }