@@ -73,9 +73,9 @@ discard block |
||
73 | 73 | public function getLeadLogs($leadId = null, array $options = []) |
74 | 74 | { |
75 | 75 | $query = $this->getEntityManager() |
76 | - ->getConnection() |
|
77 | - ->createQueryBuilder() |
|
78 | - ->select('ll.id as log_id, |
|
76 | + ->getConnection() |
|
77 | + ->createQueryBuilder() |
|
78 | + ->select('ll.id as log_id, |
|
79 | 79 | ll.event_id, |
80 | 80 | ll.campaign_id, |
81 | 81 | ll.date_triggered as dateTriggered, |
@@ -92,7 +92,7 @@ discard block |
||
92 | 92 | ll.lead_id, |
93 | 93 | fl.reason as fail_reason |
94 | 94 | ' |
95 | - ) |
|
95 | + ) |
|
96 | 96 | ->from(MAUTIC_TABLE_PREFIX.'campaign_lead_event_log', 'll') |
97 | 97 | ->join('ll', MAUTIC_TABLE_PREFIX.'campaign_events', 'e', 'll.event_id = e.id') |
98 | 98 | ->join('ll', MAUTIC_TABLE_PREFIX.'campaigns', 'c', 'll.campaign_id = c.id') |
@@ -178,7 +178,7 @@ discard block |
||
178 | 178 | |
179 | 179 | if (isset($options['type'])) { |
180 | 180 | $query->andwhere('e.type = :type') |
181 | - ->setParameter('type', $options['type']); |
|
181 | + ->setParameter('type', $options['type']); |
|
182 | 182 | } |
183 | 183 | |
184 | 184 | if (isset($options['eventType'])) { |
@@ -223,7 +223,7 @@ discard block |
||
223 | 223 | public function getCampaignLogCounts($campaignId, $excludeScheduled = false, $excludeNegative = true, $all = false) |
224 | 224 | { |
225 | 225 | $q = $this->getSlaveConnection()->createQueryBuilder() |
226 | - ->from(MAUTIC_TABLE_PREFIX.'campaign_lead_event_log', 'o'); |
|
226 | + ->from(MAUTIC_TABLE_PREFIX.'campaign_lead_event_log', 'o'); |
|
227 | 227 | |
228 | 228 | $join = 'innerJoin'; |
229 | 229 | if ($all === true) { |
@@ -272,8 +272,8 @@ discard block |
||
272 | 272 | ); |
273 | 273 | |
274 | 274 | $q->where($expr) |
275 | - ->setParameter('false', false, 'boolean') |
|
276 | - ->groupBy($groupBy); |
|
275 | + ->setParameter('false', false, 'boolean') |
|
276 | + ->groupBy($groupBy); |
|
277 | 277 | |
278 | 278 | $results = $q->execute()->fetchAll(); |
279 | 279 |