/** * Gets a list of email addresses which have an owner * Email addresses are sorted by modification date; newest at the top * * @return EmailAddress[] */ protected function getKnownEmailAddresses() { $this->log->notice('Loading known email addresses ...'); $repo = $this->emailAddressManager->getEmailAddressRepository($this->em); $query = $repo->createQueryBuilder('a')->select('partial a.{id, email, updated}')->where('a.hasOwner = ?1')->orderBy('a.updated', 'DESC')->setParameter(1, true)->getQuery(); $emailAddresses = $query->getResult(); $this->log->notice(sprintf('Loaded %d email address(es).', count($emailAddresses))); return $emailAddresses; }
/** * @param string $emailAddress * @param string|null $ownerClass * @param mixed|null $ownerId * @param bool $excludeCurrentUser */ public function preciseFullEmailAddress(&$emailAddress, $ownerClass = null, $ownerId = null, $excludeCurrentUser = false) { if (!$this->emailAddressHelper->isFullEmailAddress($emailAddress)) { if (!empty($ownerClass) && !empty($ownerId)) { $owner = $this->entityRoutingHelper->getEntity($ownerClass, $ownerId); if ($owner) { if ($this->doExcludeCurrentUser($excludeCurrentUser, $emailAddress, $owner)) { return; } $ownerName = $this->entityNameResolver->getName($owner); if (!empty($ownerName)) { $emailAddress = $this->emailAddressHelper->buildFullEmailAddress($emailAddress, $ownerName); return; } } } $repo = $this->emailAddressManager->getEmailAddressRepository($this->entityManager); $emailAddressObj = $repo->findOneBy(array('email' => $emailAddress)); if ($emailAddressObj) { $owner = $emailAddressObj->getOwner(); if ($owner) { if ($this->doExcludeCurrentUser($excludeCurrentUser, $emailAddress, $owner)) { return; } $ownerName = $this->entityNameResolver->getName($owner); if (!empty($ownerName)) { $emailAddress = $this->emailAddressHelper->buildFullEmailAddress($emailAddress, $ownerName); } } } } }
/** * @param string[] $emailsToLoad * * @return array * key = email address * value = array * known => true/false * false if the address belongs to user only * true if the address belongs to not excluded owners * user => user id */ protected function getKnownEmailAddresses(array $emailsToLoad) { $repo = $this->emailAddressManager->getEmailAddressRepository($this->em); $qb = $repo->createQueryBuilder('a')->where('a.hasOwner = :hasOwner AND a.email IN (:emails)')->setParameter('hasOwner', true)->setParameter('emails', $emailsToLoad); $select = 'a.email'; $userIdField = null; $mailboxIdField = null; $ownerIdFields = []; foreach ($this->emailOwnerProviderStorage->getProviders() as $provider) { $ownerClass = $provider->getEmailOwnerClass(); $isUser = $ownerClass === 'Oro\\Bundle\\UserBundle\\Entity\\User'; $isMailbox = $ownerClass === 'Oro\\Bundle\\EmailBundle\\Entity\\Mailbox'; $field = $this->emailOwnerProviderStorage->getEmailOwnerFieldName($provider); if ($isUser) { $userIdField = $field; } if ($isMailbox) { $mailboxIdField = $field; } if (isset($this->exclusions[$ownerClass])) { if ($isUser) { $select .= sprintf(',IDENTITY(a.%1$s) AS %1$s', $field); } else { $qb->andWhere(sprintf('a.%s IS NULL', $field)); } } else { $select .= sprintf(',IDENTITY(a.%1$s) AS %1$s', $field); $ownerIdFields[] = $field; } } $qb->select($select); $data = $qb->getQuery()->getArrayResult(); $result = $this->prepareKnownEmailAddressesData($data, $ownerIdFields, $userIdField, $mailboxIdField); return $result; }
/** * @param array $bindings * @param EntityManager $em */ protected function persistBindings(array &$bindings, EntityManager $em) { $repository = $this->emailAddressManager->getEmailAddressRepository($em); foreach ($bindings['changes'] as $item) { $email = $item['email']; $owner = false === $item['owner'] ? null : $item['owner']; $emailAddress = $repository->findOneBy(['email' => $email]); if ($emailAddress === null) { $emailAddress = $this->emailAddressManager->newEmailAddress()->setEmail($email)->setOwner($owner); $em->persist($emailAddress); $this->computeEntityChangeSet($em, $emailAddress); } elseif ($emailAddress->getOwner() !== $owner) { $emailAddress->setOwner($owner); $this->computeEntityChangeSet($em, $emailAddress); } } foreach ($bindings['deletions'] as $owner) { foreach ($this->emailOwnerClasses as $fieldName => $ownerClass) { if (is_a($owner, $ownerClass)) { $condition = array($fieldName => $owner); /** @var EmailAddress[] $emailAddresses */ $emailAddresses = $repository->findBy($condition); foreach ($emailAddresses as $emailAddress) { $emailAddress->setOwner(null); $this->computeEntityChangeSet($em, $emailAddress); } } } } }
/** * @param string $emailAddress * @param string|null $ownerClass * @param mixed|null $ownerId */ protected function preciseFullEmailAddress(&$emailAddress, $ownerClass = null, $ownerId = null) { if (!$this->emailAddressHelper->isFullEmailAddress($emailAddress)) { if (!empty($ownerClass) && !empty($ownerId)) { $owner = $this->entityRoutingHelper->getEntity($ownerClass, $ownerId); if ($owner) { $ownerName = $this->nameFormatter->format($owner); if (!empty($ownerName)) { $emailAddress = $this->emailAddressHelper->buildFullEmailAddress($emailAddress, $ownerName); return; } } } $repo = $this->emailAddressManager->getEmailAddressRepository($this->em); $emailAddressObj = $repo->findOneBy(array('email' => $emailAddress)); if ($emailAddressObj) { $owner = $emailAddressObj->getOwner(); if ($owner) { $ownerName = $this->nameFormatter->format($owner); if (!empty($ownerName)) { $emailAddress = $this->emailAddressHelper->buildFullEmailAddress($emailAddress, $ownerName); } } } } }
/** * @param EntityManager $em * * @return EntityRepository */ protected function getEmailAddressRepository(EntityManager $em) { if (null === $this->emailAddressRepository) { $this->emailAddressRepository = $this->emailAddressManager->getEmailAddressRepository($em); } return $this->emailAddressRepository; }
/** * @param array $emailOwnerChanges * * @return EmailAddress[] */ protected function updateEmailAddresses(array $emailOwnerChanges, array $emailOwnerDeletions) { $updatedEmailAddresses = []; foreach ($emailOwnerChanges as $item) { $email = $item['email']; $newOwner = false === $item['owner'] ? null : $item['owner']; $emailAddress = $this->emailAddressManager->getEmailAddressRepository()->findOneBy(['email' => $email]); if ($emailAddress === null) { $emailAddress = $this->emailAddressManager->newEmailAddress()->setEmail($email)->setOwner($newOwner); $this->emailAddressManager->getEntityManager()->persist($emailAddress); $updatedEmailAddresses[] = $emailAddress; } elseif ($emailAddress->getOwner() !== $newOwner) { $emailAddress->setOwner($newOwner); $updatedEmailAddresses[] = $emailAddress; } } foreach ($emailOwnerDeletions as $owner) { foreach ($this->emailOwnerClasses as $fieldName => $ownerClass) { if (is_a($owner, $ownerClass)) { $condition = array($fieldName => $owner); /* @var $emailAddresses EmailAddress[] */ $emailAddresses = $this->emailAddressManager->getEmailAddressRepository()->findBy($condition); foreach ($emailAddresses as $emailAddress) { $emailAddress->setOwner(null); $updatedEmailAddresses[] = $emailAddress; } } } } return $updatedEmailAddresses; }
public function testGetEmailAddressRepository() { $manager = new EmailAddressManager('Oro\\Bundle\\EmailBundle\\Tests\\Unit\\Entity\\TestFixtures', 'Test%sProxy'); $repo = $this->getMockBuilder('Doctrine\\ORM\\EntityRepository')->disableOriginalConstructor()->getMock(); $em = $this->getMockBuilder('Doctrine\\ORM\\EntityManager')->disableOriginalConstructor()->getMock(); $em->expects($this->once())->method('getRepository')->with($this->equalTo('Oro\\Bundle\\EmailBundle\\Tests\\Unit\\Entity\\TestFixtures\\TestEmailAddressProxy'))->will($this->returnValue($repo)); $this->assertTrue($repo === $manager->getEmailAddressRepository($em)); }
/** * @param string $emailAddress * @return string */ protected function preciseFullEmailAddress(&$emailAddress) { if (!EmailUtil::isFullEmailAddress($emailAddress)) { $repo = $this->emailAddressManager->getEmailAddressRepository($this->em); $emailAddressObj = $repo->findOneBy(array('email' => $emailAddress)); if ($emailAddressObj) { $owner = $emailAddressObj->getOwner(); if ($owner) { $emailAddress = EmailUtil::buildFullEmailAddress($emailAddress, $this->nameFormatter->format($owner)); } } } }
/** * @param string[] $emailsToLoad * * @return array * key = email address * value = array * known => true/false * false if the address belongs to user only * true if the address belongs to not excluded owners * user => user id */ protected function getKnownEmailAddresses(array $emailsToLoad) { $repo = $this->emailAddressManager->getEmailAddressRepository($this->em); $qb = $repo->createQueryBuilder('a')->where('a.hasOwner = :hasOwner AND a.email IN (:emails)')->setParameter('hasOwner', true)->setParameter('emails', $emailsToLoad); $select = 'a.email'; $userIdField = null; $mailboxIdField = null; $ownerIdFields = []; foreach ($this->emailOwnerProviderStorage->getProviders() as $provider) { $ownerClass = $provider->getEmailOwnerClass(); $isUser = $ownerClass === 'Oro\\Bundle\\UserBundle\\Entity\\User'; $isMailbox = $ownerClass === 'Oro\\Bundle\\EmailBundle\\Entity\\Mailbox'; $field = $this->emailOwnerProviderStorage->getEmailOwnerFieldName($provider); if ($isUser) { $userIdField = $field; } if ($isMailbox) { $mailboxIdField = $field; } if (isset($this->exclusions[$ownerClass])) { if ($isUser) { $select .= sprintf(',IDENTITY(a.%1$s) AS %1$s', $field); } else { $qb->andWhere(sprintf('a.%s IS NULL', $field)); } } else { $select .= sprintf(',IDENTITY(a.%1$s) AS %1$s', $field); $ownerIdFields[] = $field; } } $qb->select($select); $result = []; $data = $qb->getQuery()->getArrayResult(); foreach ($data as $item) { $known = false; foreach ($ownerIdFields as $field) { if ($item[$field] !== null) { $known = true; break; } } $email = strtolower($item['email']); $userId = $item[$userIdField]; $mailboxId = $item[$mailboxIdField]; $result[$email] = $userId === null ? ['known' => $known] : ['known' => $known, 'user' => (int) $userId]; if ($mailboxId !== null) { $result[$email]['mailbox'] = $mailboxId; } } return $result; }
/** * Tell the given EntityManager to manage EmailAddress objects in this batch * * @param EntityManager $em */ protected function persistAddresses(EntityManager $em) { $repository = $this->emailAddressManager->getEmailAddressRepository($em); foreach ($this->addresses as $key => $obj) { /** @var EmailAddress $dbObj */ $dbObj = $repository->findOneBy(['email' => $obj->getEmail()]); if ($dbObj === null) { $obj->setOwner($this->emailOwnerProvider->findEmailOwner($em, $obj->getEmail())); $em->persist($obj); } else { $this->updateAddressReferences($obj, $dbObj); $this->addresses[$key] = $dbObj; } } }
/** * Unbind EmailAddress entity from the given owner * * @param EntityManager $em * @param EmailOwnerInterface $owner * @param EmailInterface $email */ protected function unbindEmailAddress(EntityManager $em, EmailOwnerInterface $owner, EmailInterface $email = null) { $repository = $this->emailAddressManager->getEmailAddressRepository($em); foreach ($this->emailOwnerClasses as $fieldName => $emailOwnerClass) { $condition = array($fieldName => $owner); if ($email !== null) { $condition['email'] = $email->getEmail(); } /** @var EmailAddress $emailAddress */ foreach ($repository->findBy($condition) as $emailAddress) { $emailAddress->setOwner(null); $this->computeEntityChangeSet($em, $emailAddress); } } }
/** * Loads the given emails into $this->knownEmailAddresses * * @param string[] $emailsToLoad */ protected function loadKnownEmailAddresses(array $emailsToLoad) { $this->log->notice(sprintf('Loading email address(es) "%s" ...', implode(',', $emailsToLoad))); $repo = $this->emailAddressManager->getEmailAddressRepository($this->em); $query = $repo->createQueryBuilder('a')->select('a.email')->where('a.hasOwner = ?1 AND a.email IN (?2)')->setParameter(1, true)->setParameter(2, $emailsToLoad)->getQuery(); $query->setHydrationMode(Query::HYDRATE_ARRAY); $emails = $query->getResult(); $loadedEmailCount = count($emails); foreach ($emails as $item) { $email = strtolower($item['email']); $this->knownEmailAddresses[$email] = 1; // known unset($emailsToLoad[$email]); } foreach ($emailsToLoad as $email) { $this->knownEmailAddresses[$email] = -1; // unknown } $this->log->notice(sprintf('Loaded %d email address(es).', $loadedEmailCount)); }