Spaces:
No application file
No application file
File size: 2,225 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 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 |
<?php
namespace Mautic\LeadBundle\Entity;
use Mautic\CoreBundle\Entity\CommonRepository;
/**
* @extends CommonRepository<ListLead>
*/
class ListLeadRepository 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('l.leadlist_id')
->from(MAUTIC_TABLE_PREFIX.'lead_lists_leads', 'l')
->where('l.lead_id = '.$toLeadId)
->executeQuery()
->fetchAllAssociative();
$lists = [];
foreach ($results as $r) {
$lists[] = $r['leadlist_id'];
}
$q = $this->_em->getConnection()->createQueryBuilder();
$q->update(MAUTIC_TABLE_PREFIX.'lead_lists_leads')
->set('lead_id', (int) $toLeadId)
->where('lead_id = '.(int) $fromLeadId);
if (!empty($lists)) {
$q->andWhere(
$q->expr()->notIn('leadlist_id', $lists)
)->executeStatement();
// Delete remaining leads as the new lead already belongs
$this->_em->getConnection()->createQueryBuilder()
->delete(MAUTIC_TABLE_PREFIX.'lead_lists_leads')
->where('lead_id = '.(int) $fromLeadId)
->executeStatement();
} else {
$q->executeStatement();
}
}
/**
* @param mixed[] $filters
*/
public function getContactsCountBySegment(int $segmentId, array $filters = []): int
{
$qb = $this->createQueryBuilder('ll');
$qb->select('count(ll.list) as count')
->where('ll.list = :segmentId')
->setParameter('segmentId', $segmentId);
foreach ($filters as $colName => $val) {
$entityFieldName = lcfirst(str_replace(' ', '', ucwords(str_replace('_', ' ', $colName))));
$qb->andWhere(sprintf('ll.%s=:%s', $entityFieldName, $entityFieldName));
$qb->setParameter($entityFieldName, $val);
}
return (int) $qb->getQuery()->getSingleScalarResult();
}
}
|