src/Provider/DoctrineProvider.php
public function findBy($data)
    {
        $qb = $this->repository->createQueryBuilder('p');
        $qb->select('p');
        $qb->where('p.queue = :queue');
        $qb->setParameter('queue', $this->name);

        $field = (isset($data['field'])) ? $data['field'] : 'message';

        if (isset($data['search']) && $data['search'] !== null) {
            $qb->andWhere('p.' . $field . ' LIKE :contains');
            $qb->setParameter('contains', '%' . $data['search'] . '%');
        }

        if (isset($data['from']) && $data['from'] !== null && isset($data['to']) && $data['to'] !== null) {
            $qb->andWhere('p.created BETWEEN :from AND :to');
            $qb->setParameter('from', $data['from']);
            $qb->setParameter('to', $data['to']);
        } 

        return $qb->getQuery();
    }
public function findBy($data)
    {
        $qb = $this->repository->createQueryBuilder('p');
        $qb->select('p');
        $qb->where('p.queue = :queue');
        $qb->setParameter('queue', $this->name);

        $field = (isset($data['field'])) ? $data['field'] : 'message';

        if (isset($data['search']) && $data['search'] !== null) {
            $qb->andWhere('p.' . $field . ' LIKE :contains');
            $qb->setParameter('contains', '%' . $data['search'] . '%');
        }

        if (isset($data['from']) && $data['from'] !== null && isset($data['to']) && $data['to'] !== null) {
            $qb->andWhere('p.created BETWEEN :from AND :to');
            $qb->setParameter('from', $data['from']);
            $qb->setParameter('to', $data['to']);
        } 

        return $qb->getQuery();
    }
public function findBy ( $ data ) { $ qb = $ this -> repository -> createQueryBuilder ( 'p' ) ; $ qb -> select ( 'p' ) ; $ qb -> where ( 'p.queue = :queue' ) ; $ qb -> setParameter ( 'queue' , $ this -> name ) ; $ field = ( isset ( $ data [ 'field' ] ) ) ? $ data [ 'field' ] : 'message' ; if ( isset ( $ data [ 'search' ] ) && $ data [ 'search' ] !== null ) { $ qb -> andWhere ( 'p.' . $ field . ' LIKE :contains' ) ; $ qb -> setParameter ( 'contains' , '%' . $ data [ 'search' ] . '%' ) ; } if ( isset ( $ data [ 'from' ] ) && $ data [ 'from' ] !== null && isset ( $ data [ 'to' ] ) && $ data [ 'to' ] !== null ) { $ qb -> andWhere ( 'p.created BETWEEN :from AND :to' ) ; $ qb -> setParameter ( 'from' , $ data [ 'from' ] ) ; $ qb -> setParameter ( 'to' , $ data [ 'to' ] ) ; } return $ qb -> getQuery ( ) ; }
Returns a query of the message queue

@param array $data ['field'=>'id', 'search'=>'text', 'to'=>date, from=>date]
@return Query
Returns a query of the message queue