Spaces:
No application file
No application file
File size: 3,803 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 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 |
<?php
namespace Mautic\PageBundle\Entity;
use Mautic\CoreBundle\Entity\CommonRepository;
use Mautic\LeadBundle\Entity\Lead;
use Mautic\LeadBundle\Entity\TimelineTrait;
/**
* @extends CommonRepository<VideoHit>
*/
class VideoHitRepository extends CommonRepository
{
use TimelineTrait;
/**
* Get video hit info for lead timeline.
*
* @param int|null $leadId
*
* @return array
*/
public function getTimelineStats($leadId = null, array $options = [])
{
$query = $this->getEntityManager()->getConnection()->createQueryBuilder();
$query->select('h.id, h.url, h.date_hit, h.time_watched, h.duration, h.referer, h.user_agent')
->from(MAUTIC_TABLE_PREFIX.'video_hits', 'h');
if ($leadId) {
$query->where($query->expr()->eq('h.lead_id', (int) $leadId));
}
if (isset($options['search']) && $options['search']) {
$query->andWhere(
$query->expr()->like('h.url', $query->expr()->literal('%'.$options['search'].'%'))
);
}
return $this->getTimelineResults($query, $options, 'h.url', 'h.date_hit', [], ['date_hit']);
}
/**
* @param string $guid
*
* @return VideoHit
*/
public function getHitForLeadByGuid(Lead $lead, $guid)
{
$result = $this->findOneBy(['guid' => $guid, 'lead' => $lead]);
return $result ?: new VideoHit();
}
/**
* Get a lead's page hits.
*
* @param int $leadId
*
* @return array
*
* @throws \Doctrine\ORM\NoResultException
* @throws \Doctrine\ORM\NonUniqueResultException
*/
public function getLeadHits($leadId, array $options = [])
{
$query = $this->createQueryBuilder('h');
$query->select('h.userAgent, h.dateHit, h.dateLeft, h.referer, h.channel, h.channelId, h.url, h.duration, h.query, h.timeWatched')
->where('h.lead = :leadId')
->setParameter('leadId', (int) $leadId);
if (isset($options['url']) && $options['url']) {
$query->andWhere($query->expr()->eq('h.url', $query->expr()->literal($options['url'])));
}
return $query->getQuery()->getArrayResult();
}
/**
* Count stats from hit times.
*
* @param array $times
*/
public function countStats($times): array
{
return [
'sum' => array_sum($times),
'min' => count($times) ? min($times) : 0,
'max' => count($times) ? max($times) : 0,
'average' => count($times) ? round(array_sum($times) / count($times)) : 0,
'count' => count($times),
];
}
/**
* Get list of referers ordered by it's count.
*
* @param \Doctrine\DBAL\Query\QueryBuilder $query
* @param int $limit
* @param int $offset
*
* @throws \Doctrine\ORM\NoResultException
* @throws \Doctrine\ORM\NonUniqueResultException
*/
public function getReferers($query, $limit = 10, $offset = 0): array
{
$query->select('h.referer, count(h.referer) as sessions')
->groupBy('h.referer')
->orderBy('sessions', 'DESC')
->setMaxResults($limit)
->setFirstResult($offset);
return $query->executeQuery()->fetchAllAssociative();
}
/**
* Updates lead ID (e.g. after a lead merge).
*/
public function updateLead($fromLeadId, $toLeadId): void
{
$q = $this->_em->getConnection()->createQueryBuilder();
$q->update(MAUTIC_TABLE_PREFIX.'video_hits')
->set('lead_id', (int) $toLeadId)
->where('lead_id = '.(int) $fromLeadId)
->executeStatement();
}
}
|