Spaces:
No application file
No application file
File size: 1,542 Bytes
d2897cd |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 |
<?php
namespace Mautic\PointBundle\Entity;
use Mautic\CoreBundle\Entity\CommonRepository;
/**
* @extends CommonRepository<LeadTriggerLog>
*/
class LeadTriggerLogRepository extends CommonRepository
{
/**
* Updates lead ID (e.g. after a lead merge).
*/
public function updateLead($fromLeadId, $toLeadId): void
{
// First check to ensure the $toLead doesn't already exist
$results = $this->_em->getConnection()->createQueryBuilder()
->select('pl.event_id')
->from(MAUTIC_TABLE_PREFIX.'point_lead_event_log', 'pl')
->where('pl.lead_id = '.$toLeadId)
->executeQuery()
->fetchAllAssociative();
$events = [];
foreach ($results as $r) {
$events[] = $r['event_id'];
}
$q = $this->_em->getConnection()->createQueryBuilder();
$q->update(MAUTIC_TABLE_PREFIX.'point_lead_event_log')
->set('lead_id', (int) $toLeadId)
->where('lead_id = '.(int) $fromLeadId);
if (!empty($events)) {
$q->andWhere(
$q->expr()->notIn('event_id', $events)
)->executeStatement();
// Delete remaining leads as the new lead already belongs
$this->_em->getConnection()->createQueryBuilder()
->delete(MAUTIC_TABLE_PREFIX.'point_lead_event_log')
->where('lead_id = '.(int) $fromLeadId)
->executeStatement();
} else {
$q->executeStatement();
}
}
}
|