azine / AzineMailgunWebhooksBundle

                ->setParameter('domain', $criteria['domain']);

        }

        if (array_key_exists('recipient', $criteria) && '' != $criteria['recipient']) {

            $qb->andWhere('e.recipient like :recipient')

                ->setParameter('recipient', '%'.$criteria['recipient'].'%');

        }

        if (array_key_exists('eventType', $criteria) && 'all' != $criteria['eventType']) {

            $qb->andWhere('e.event = :eventType')

                ->setParameter('eventType', $criteria['eventType']);

        }

        if (array_key_exists('search', $criteria) && '' != $criteria['search']) {

            $qb->andWhere('(e.messageHeaders like :search OR e.description like :search OR e.notification like :search OR e.reason like :search OR e.errorCode like :search OR e.ip like :search OR e.error like :search OR e.country like :search OR e.city like :search OR e.campaignId like :search OR e.campaignName like :search OR e.clientName like :search OR e.clientOs like :search OR e.clientType like :search OR e.deviceType like :search OR e.mailingList like :search OR e.messageId like :search OR e.tag like :search OR e.userAgent like :search OR e.url like :search)')

                ->setParameter('search', '%'.$criteria['search'].'%');

        }

        if ($lookForUnopened) {

            $qb->andWhere("NOT EXISTS (SELECT o.id FROM AzineMailgunWebhooksBundle:MailgunEvent o WHERE o.messageId like e.messageId AND o.event in ('opened', 'clicked', 'unsubscribed', 'complained'))");