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) && $criteria['eventType'] != "all") {

            $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'))");