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

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.     public $safeFields = array('page','limit','sort','order','direction');
  17.     const LIMIT = 10;
  19.     public function getEventWorkflows($eventName, $isActive = true, $isPredefined = true)
  20.     {
  21.         return $this->getEntityManager()->createQueryBuilder()
  22.             ->select('workflow')
  23.             ->from(Workflow::class, 'workflow')
  24.             ->leftJoin('workflow.workflowEvents', 'workflowEvents')
  25.             ->where('workflow.status = :status')->setParameter('status', $isActive)
  26.             ->andWhere('workflow.isPredefind = :isPredefined')->setParameter('isPredefined', $isPredefined)
  27.             ->andWhere('workflowEvents.event = :eventType')->setParameter('eventType', $eventName)
  28.             ->orderBy('workflow.sortOrder', Criteria::ASC)
  29.             ->getQuery()->getResult();
  30.     }
  32.     public function getWorkflows(\Symfony\Component\HttpFoundation\ParameterBag $obj = null, $container) {
  33.         $qb = $this->getEntityManager()->createQueryBuilder();
  34.         $qb->select('w.id, w.name, w.status')->from($this->getEntityName(), 'w')
  35.             ->orderBy('w.sortOrder', Criteria::ASC);
  36.         
  37.         return ['workflows' => $qb->getQuery()->getArrayResult()];
  38.     }
  39. }