heathdutton

diff --git a/app/bundles/CampaignBundle/Controller/CampaignController.php b/app/bundles/CampaignBundle/Controller/CampaignController.php
index 0e854506e..d03daf7d5 100644
--- a/app/bundles/CampaignBundle/Controller/CampaignController.php
+++ b/app/bundles/CampaignBundle/Controller/CampaignController.php
@@ -746,15 +746,18 @@ class CampaignController extends AbstractStandardFormController
                         'dateRangeForm'   => $dateRangeForm->createView(),
                         'campaignSources' => $this->campaignSources,
                         'campaignEvents'  => $events,
-                        'campaignLeads'   => $this->forward(
-                            'MauticCampaignBundle:Campaign:contacts',

heathdutton

diff --git a/app/bundles/CampaignBundle/Entity/CampaignRepository.php b/app/bundles/CampaignBundle/Entity/CampaignRepository.php
index c463a0bad1..c041bb4760 100644
--- a/app/bundles/CampaignBundle/Entity/CampaignRepository.php
+++ b/app/bundles/CampaignBundle/Entity/CampaignRepository.php
@@ -21,6 +21,7 @@
 class CampaignRepository extends CommonRepository
 {
     use ContactLimiterTrait;

heathdutton

<?php

$loader->import('config.php');

if (file_exists(__DIR__.'/security_local.php')) {
    $loader->import('security_local.php');
} else {
    $loader->import('security.php');
}

heathdutton

# Command lines tools
xcode-select --install

# Install dependencies
brew install wget autoconf openssl libjpeg libpng lzlib curl imap-uw readline postgresql libxml2 mcrypt gettext libxslt homebrew/dupes/libiconv icu4c expat bison webp freetype

# Dirs
mkdir -p /Applications/MAMP/bin/php/php7.2.10/include
cd /Applications/MAMP/bin/php/php7.2.10/include

heathdutton

/* Lead ingestion behind - Leads waiting to be processed by a campaign */
SELECT cl.campaign_id as campaign_id, count(cl.lead_id) as lead_count FROM campaign_leads cl WHERE (cl.manually_removed = 0) AND (NOT EXISTS (SELECT null FROM campaign_lead_event_log e WHERE (cl.lead_id = e.lead_id) AND (e.campaign_id = cl.campaign_id))) GROUP BY cl.campaign_id LIMIT 100;
-- Faster:
SELECT cl.campaign_id AS campaign_id, c.name as campaign_name, count(cl.lead_id) AS lead_count, c.is_published AS published
FROM campaign_leads cl
LEFT JOIN campaigns c
	ON c.id = cl.campaign_id
WHERE (NOT EXISTS (
    SELECT null FROM campaign_lead_event_log e
    WHERE

heathdutton

diff --git a/app/bundles/LeadBundle/Entity/LeadListRepository.php b/app/bundles/LeadBundle/Entity/LeadListRepository.php
index 8cdfbae108..234535214f 100644
--- a/app/bundles/LeadBundle/Entity/LeadListRepository.php
+++ b/app/bundles/LeadBundle/Entity/LeadListRepository.php
@@ -1677,11 +1677,44 @@ public function getListFilterExpr($filters, &$parameters, QueryBuilder $q, $isNo
 
                         case 'in':
                         case 'notIn':
+                            if (is_string($details['filter'])) {
+                                // Expound the string to an array based on common string array notations.

heathdutton

From 23a41e73f13cfbc9bc0156ee8bcb69ff15fa29c1 Mon Sep 17 00:00:00 2001
From: heathdutton <hdutton@thedmsgrp.com>
Date: Mon, 9 Apr 2018 16:47:13 -0400
Subject: [PATCH 1/5] Support includes/excludes with text fields for bulk
 filtering.

---
 app/bundles/LeadBundle/Entity/LeadListRepository.php | 10 ++++++++++
 app/bundles/LeadBundle/Entity/OperatorListTrait.php  |  2 ++
 2 files changed, 12 insertions(+)

heathdutton

Found by php app/console debug:container --show-private --env=dev | grep -i "listener:"

bazinga.oauth.event_listener.exception                                                                 Bazinga\OAuthServerBundle\EventListener\OAuthExceptionListener
  bazinga.oauth.event_listener.request                                                                   Mautic\ApiBundle\EventListener\OAuth1\OAuthRequestListener
Symfony\Component\Security\Http\Firewall\ExceptionListener
  debug.debug_handlers_listener                                                                          Symfony\Component\HttpKernel\EventListener\DebugHandlersListener
  doctrine.orm.default_entity_listener_resolver                                                          Doctrine\Bundle\DoctrineBundle\Mapping\ContainerAwareEntityListenerResolver
  doctrine.orm.default_listeners.attach_entity_listeners                                                 Doctrine\ORM\Tools\AttachEntityListenersListener
  fos_rest.body_listener                 

heathdutton

$sql = $query->getSQL();
foreach($query->getParameters() as $key => $val) {
    if (is_numeric($val)) {
        $sql = str_replace(':' . $key, $val, $sql);
    } else {
        $sql = str_replace(':' . $key, '"'.$val.'"', $sql);
    }
}

heathdutton

Symfony Container Public Services
=================================

 ------------------------------------------------------------------------------------------------------ ---------------------------------------------------------------------------------------
  Service ID                                                                                             Class name
 ------------------------------------------------------------------------------------------------------ ---------------------------------------------------------------------------------------
  annotation_reader                                                                                      Doctrine\Common\Annotations\CachedReader
  assets.context                                                                                         Symfony\Component\Asset\Context\RequestStackContext
  assets.packages                                                                                        Symfony\Component\Asset\Packages
  babdev\trans