/** * {@inheritdoc} */ public function searchSourceUser(CallEventInterface $ce) { /** @var Call $call */ $call = $ce->getCall(); $qb = $this->em->createQueryBuilder(); $query = $qb->select('u')->from('UserBundle:User', 'u')->leftJoin('u.groups', 'g')->leftJoin('u.contacts', 'c')->where('g.account = :account')->setParameter('account', $call->getAccount())->andWhere('c.sip LIKE :sip')->setParameter('sip', '%' . $ce->getSrcNumber() . '%')->setMaxResults(1)->getQuery(); return $query->getOneOrNullResult(); }
/** * {@inheritdoc} */ public function searchSourceClient(CallEventInterface $ce) { /** @var Call $call */ $call = $ce->getCall(); $number = $this->clearNumber($ce->getSrcNumber()); $qb = $this->em->createQueryBuilder(); $query = $qb->select('c')->from('CoreBundle:Client', 'c')->leftJoin('c.phones', 'p')->where('c.account = :account')->setParameter('account', $call->getAccount())->andWhere('p.number LIKE :number')->setParameter('number', '%' . $number . '%')->setMaxResults(1)->getQuery(); return $query->getOneOrNullResult(); }
/** * @param CallEventInterface $ce * @return TelephonyManager * @throws CallSystemDetermineException */ public function getCallerSystem(CallEventInterface $ce) { /** @var TelephonyManager $manager */ foreach ($this->managers as $manager) { if ($manager->checkFormat($ce->getSrcNumber())) { return $manager; } } throw new CallSystemDetermineException(); }